Yogesh Bhatt
91 9871329804
B106, Ashoka Enclave II, Faridabad 121003
Current Location: Auckland
Title: / Project Manager with 8.5 years of Experience in ITWork Experience: / 8.5 years
Skills: / Project Management, CMM5, Cognos, Data Warehousing, J2EE, Oracle, NT Scripting
Current Organization: / HCL Technologies
Previous Organization(s): / GRP Consulting, NIIT, SSI Pvt Ltd
Industry: / IT/ Computers Software
Highest Degree Held: / MCA/PGDCA (Computers) ,North Maharashtra University
Gender: / Male
Date of Birth: / 24th October 1971
Current Annual Salary (Rs. in Lacs): / 10.5
Detailed Resume:
Name Yogesh Bhatt
Role / Designation Project Leader/Project Manager
PROFESSIONAL PROFILE
Brief Profile Over eight years of experience in software development, design, client server, internet based, process automation and 24x7 support applications
• Extensive experience on Data Modeling, Database Design, Schema modeling for Banking, Retail Chain (supply chain) clients
• Extensive experience of architecting J2EE and web technologies based n-tier applications using Frameworks, UML design concepts and Design Patterns
• Thorough experience of working under CMM5 process models
• Experience of Managing software project Scope, Risks, Effort and Schedule Variances, Staffing while ensuring the Quality of deliverables.
• Hands on with various software tools and technology that involves Requirements Analysis, Scheduling, Effort Estimation using FP Count and OSC Methodologies, Test Planning, Preparation, Execution, Tracking, Defect Database, Risks and Status Reporting to the Senior Management, SLA tracking/reporting
• Experience of handling Multiple Projects/Teams at Client site/Offshore and working in challenging environments on New Technologies
• Responsible for leading team of Data Warehouse professionals in Development and Support of Enterprise wide DWH Applications and Offshore Transitioning, setting up the ODCs using VPN/Leased line connectivity
Total Experience 8 years (in Project Management, Software Design, Development and Implementation)
Education Master of Computer Applications (MCA)
Business Areas Retail, E-Business, Investment Banking, Dairy Industry (NZ)
Packages J2EE, Visual Studio6 (ASP), Cognos Series7, Informatica5.x, Business Objects6.x, Hyperion Essbase
Operating Systems UNIX, Win-NT, WindowsXP
Languages C/C++, VC++, JAVA, NT Scripting, VB Script, HTML, PL/SQL, Unix Shell Scripting
Databases Oracle 8/9i, MS- SQL, Sybase, DB2
Tools Cognos Series7, PPES, Cognos Upfront, Hyperion Essbase, Cognos Decision Stream, Microsoft VC++, BEA Weblogic, IBM Websphere, Crystal Reports, ADL Scripting, COM/DCOM, Corba, Servlets, JSP, XML, SPSS, IBM Data Miner, PL/SQL Developer, Business Objects, Informatica Powermart, Powercenter 5.1
IBM VisualAge for Java
Project Experience Summary
Employer - Project Name & Description
Client Technologies Role Period Team Size
HCL Technologies - Enterprise Management System. Data Warehousing Support and maintenance
Fonterra NZ Cognos Series7, Upfront, Decision Stream, Oracle8i, PL/SQL, NT Script, Unix Shell Script Project Manager June 2003 till date 8
HCL Technologies - Casper Sales Analysis and Reporting. Data Warehousing Support and Development
ColesMyer Australia Hyperion Essbase, Oracle8i, CoSort, PL/SQL, NT Script, Unix Shell Script Lead Data Warehousing Analyst September 2002 May 2003 8
HCL Technologies - Toyota Parts Specification Management System
Toshiba/Toyota, Japan Java, Websphere, XML, Rational Rose Consultant Feb 2002 Aug 2002 4
GRP Consulting / SSI Pvt Ltd - Deutsche Banc, Investment Banking portal, NY, USA Weblogic, J2EE, Servlets, JSP, XML, Oracle, Unix, JavaScript Lead Architect April 2000 Aug 2000 (SSI), Jan 2001 Jan 2002 (GRP) 51
NIIT Limited Tokyo Stock Exchange, Document Flow System, Japan Weblogic, J2EE, Servlets, JSP, XML, Oracle, JavaScript Associate Consultant Oct 2000 Dec 2000 100
SSI Pvt Ltd - BSD, Stock Brokering Application, USA Corba, VC++, SQL Server, HTML, JavaScript, Servlets, IIS Project Leader Sept 1999 Mar 2000 15
SSI Pvt Ltd - Fraud Prevention & Investigation, Bank Boston USA VC++, COM/DCOM, SQL Server Developer Nov 1997 Aug 1999 15
National Informatics Center Document workflow application, IFCI Govt organization, Delhi Oracle 7.1, Unix, Distributed Databases, Java, Pro*C Developer June 1997 Oct 1997 5
PROJECT DETAILS
Client Name: Fonterra, NZ (Project-1)
Project Name: Enterprise Management System (Duration: June, 2003 till date)
Operating Software Unix, Win2k
Languages PL/SQL, Win NT Scripting, Unix Shell Scripting, Cognos Scripting
Databases Oracle 8i
Tools Used Cognos Series7, PPES, Transformer, Impromputu, Powerplay, Cognos Upfront, Decision Stream, PL/SQL Developer, Netscape Access Manager, Oracle Forms6i
Role Project Manager
Employer HCL Technologies India, HCL Technologies NZ
Team Size 8
Project Description:
Fonterra is NZs largest dairy producer of Milk and Milk products. Fonterra has an Enterprise Management System (EMS) for sales analysis of milk produce across the world. The primary focus of EMS is to provide a management analysis and reporting tool that can be used across all levels of the organization:
• Operating Companies;
• Regional Teams,
• Global Category Teams; and
• SBUs,
to support both operational and strategic decision making within the business. EMS presents data in reporting models. EMS collates information from Operating Companies and combines this with centrally supplied group data to provide these reporting models. The information is available at 3 levels SBU (Group), Regional (ASIA, EUROPE etc) and Operating Company Levels.
Latest change in Fonterra was introduction of SAP as Enterprise Wide Application to be used, this caused rollon effects to EMS Data Warehousing system as source systems were changed to SAP. This is one of major chunk of work we are currently engaged and still managing to keep the User Interface same for all users across the Globe (over 600+).
Responsibilities:
• OnSite (Wellington, NZ) study and knowledge gathering for the whole EMS system. Starting with leading a team of 3 support analyst to take over the EMS Functional support.
• Managing the offshore transition of functional and technical support. Current team structure is one in which 3 onsite member team and 4 offshore member team reports directly to me.
• Coordinating with the offshore(India)) for resources for the technical support team
• Preparation of a high level process document depicting the different processes in the system, external interfaces, data model, performance benchmarks, past problems and data sizing, administration, Hardware and software repositories
• Leading the technical team in the Knowledge transfer of the Cognos and Oracle technical support and maintenance
• Effort estimation, Impact Analysis, Design of Stake Holder Requests and Technical Design documents based on discussions involving Business Analysts of Fonterra
• Managing Development Work related with the approved change requests
• Project Management level reporting, project planning, status reporting, project metrics and estimation efforts standardization for all the change requests
• Planning for transitioning the support to offshore including resource planning, infrastructure planning, logistics etc.
• Setting up quality processes for offshore development as per CMM5 level best practices and manuals/templates
• Presentation of the understanding and getting signoffs from client
Client Name: Liquorland ColesMyer, Australia (Project-2)
Project Name: Casper Sales Analysis and Reporting
(Duration: September, 2002 May, 2003)
Operating Software Windows NT, 2000, Unix
Languages PL/SQL, Win NT Scripting, ADL Scripting, Unix Shell
Databases Oracle 8i
Tools Used Cognos Decision Stream, Comshare ADL, CoSort, Essbase OLAP, Essbase Excel Add-in, Oracle Forms
Role Data Warehousing Lead Analyst
Employer HCL Technologies India, HCL Technologies Pty Ltd Australia
Team Size 8
Project Description:
Liquorland has a Sales Analysis Data Warehouse called CASPER since 1994. The present version of the Data Warehouse Application has been in use since 2000. Casper has a rich mix of application development languages, like Comshare ADL, Visual Basic, Excel Macros, etc., as well as ETL & OLAP tools, like Cognos Decision Stream, Essbase, and Comshare DSS. The functional end users extensively use the data warehouse for Sales Performance Analysis and Forecasting. The back support for the CASPER application is provided by ADD system, which acts as an interface to main Merchandising system of Coles Myer Group. The ADD system itself has 15 subsystems like Flybuys, Wine Club, Discoverer, Stock Build, Stock Take, POS (Point of Sales) etc.
Responsibilities:
• OnSite (Liquorland, Sydney) study and knowledge gathering for the whole CASPER system. Other systems I am involved with are Stock Build, Stock Take, POS, Remote Ware (File transfer server), Daily Sales and Orders processing and feeding sales extracts to various systems like CASPER, Finance, SAP
• Requirements gathering for Inventory reporting and Model Stock Generation development project, designing, prototyping and development in the Development environment. On successful testing and verification, uploading the tested application to the existing production environment.
• Preparation of a high level process document depicting the different processes in the system, external interfaces, data model, performance benchmarks, past problems and data sizing
• Managing the processes and information flow from main Merchandising system (CSR) through ADD (Application data dissection) to SAP, GL, Finance, Sales and other end consumers. This involves monitoring, cron scheduling the batches and delivering the files to different systems (on VAX, Unix and Windows).
• Support for all the scheduled and unscheduled batch jobs, catering to different types of clients like Sales Analysts, Business Users, Senior Management using various end reporting tools like Essbase Excel Add-in, Excel Macro applications, VB Applications, Decision Desktop Report templates. Support also included the mentioned end reporting tools.
• Managing and creating new ETL Process, Essbase Loading process, Decision Stream Batch Builds and Job Streams, Comshare ADL and PL/SQL routines for extraction, Essbase command level API's, Decision Desktop Report template creation/modifications, VB applications were the main day to day activities
• Attending to production calls for CASPER, Remote Ware, Sales processing some of them at Level-1 priority.
Client Name: Toyota/Toshiba, Japan (Project-3)
Project Name: Toyota Specifications Parts Management System
(Duration: Feb, 2002 - Aug, 2002)
Operating Software Windows NT, 2000 Japanese Version
Languages Java, UML, Corba
Databases DB2
Tools Used Japanese to English converter, IBM Websphere, IBM Visual Age
Role Consultant
Employer GRP Consulting, USA
Team Size 4
Project Description:
The project is one of the steps in globalization of Toyota moving its manufacturing to various geo apart from Japan. The system keeps track of various parts and assembly of the different car models that Toyota makes. Currently the project supports Japanese and English locale. Development is to be done in Win2000 Japanese Version with all the HLD and LLD documentation written in Japanese.
Responsibilities:
• Onsite (Kawasaki, Tokyo) study and knowledge gathering for the modules to be developed offshore in India and design modeling using Rational Rose
• Understanding of the tools to be used in the application development, as the tools were specific for this project.
• Development of the modules (screens) at onsite and offshore with proper testing and quality procedures, under the guidelines provided by the Toshiba Joho, Tokyo.
• Training of team on the knowledge gathered at onsite, sending the timely deliveries and change management coordination with on site coordinator.
Client Name : Deutsche Banc, USA (Project-4)
Project Name: Global Investment Banking / Client & Deal Management Portal (Duration: January, 2001 - January, 2002)
Operating Software Windows 9x and NT, Unix, Solaris
Languages HTML, Java, EJB, JavaScript, PL/SQL
Databases Oracle 7.x
Tools Used Weblogic5.x, Oracle client tools, JSP, Servlets, LDAP, Applets, Netscape Directory Server, Rational Rose(RUP), UML
Role Senior Consultant
Employer GRP Consulting, USA
Team Size 51
Project Description:
Deutsche Bank was developing the Internet and Intranet system to be used to create, store and provide seamless access to Investment banking information in a secure environment. It also facilitates two- way communication for Deutsche Bank investment bankers, their clients, and the investing public. A new phase of the project was started which was to develop the client and deal management system into the investment-banking portal.
Responsibilities:
• Application framework and design modeling was the primary task to facilitate the development effort at later stages.
• Writing and delivering technical presentations to support the frameworks and design methodologies.
• Leading technical team of 7 members providing the base frameworks in Java and JavaScript
• Was responsible for creating a generic utility class which will not only merge but also sort result sets from two (or n- number of) entirely different databases, the complexity comes in the fact that column names and number of columns in each result sets can be different. This utility class uses the reflection API, and gives enough flexibility to user in terms of deciding his/her own comparison rules. Supported the research team in using this class and covered most of the JSP and servlets for research module following the Model, View and Controller (MVC) pattern whereby JSP was view, servlets being the controller and backend EJB's and worker bean classes to support data were the Model.
• Worked with Client and Deal management team, more specifically on Deal creation, viewing and modification part. Deal creation was a series of screens (JSP's) and controlling was through servlets, backend information was being fetched via middleware classes wrapping EJB's. Task included coding jsp/servlets and modifying the Deal Object member variables, which finally got updated through, EJB's.
Client Name: Tokyo Stock Exchange (Project-5)
Project Name: TSE Workflow Application (Duration: October, 2000 December, 2000)
Operating Software Windows 9x and NT
Languages HTML, Java, EJB, JavaScript, SQL
Databases Oracle 7.x
Tools Used Weblogic5.x, Oracle client tools, JSP, Servlets, LDAP, Applets, Rational Rose, UML, XML, JMS
Role Associate Consultant
Employer NIIT Limited, Delhi, India
Team Size 100
Project Description:
Tokyo Stock Exchange wanted to build a document control application to track the progress and states of document in its entire life cycle. The application was to be built from scratch using a complicated architecture of Messaging, front ending via servlets/JSP and business logic processing using EJBs on weblogic.
Responsibilities:
• Prime responsibility was to train the entire team on Core Java, Servlets/JSP and EJB concepts and hands on training on weblogic.
• Following the RUP methodology was responsible for designing use cases, class diagrams, database model, EJB (session and entity beans), and Prototyping the front ending using HTML/XML, and Servlets/JSP.
• Being part of core architecture team, solely responsible for designing and creating a Java framework for core Java (JDBC, Session Pooling, Utilities), EJB and HTML framework classes.
• Created robust Java classes framework which was used to drive the entire project.
Client Name: Deutsche Banc, USA (Project-6)
Project Name: Global Investment Banking Portal (Duration: April, 2000 August, 2000)