OBIEE, ETL, Business Intelligence, MDM, Data Warehousing, PL/SQL
Resume:
Hemant Narkhede
*******@*****.***
Total 8 years of complete SDLC experience delivering Data Warehouse and Business Intelligence projects.
Excellent business analysis and problem-solving abilities.
Project Management experience following methodologies including agile techniques.
Excellent written and oral communication skills. Excellent listening, presentation, and interpersonal skills.
Experience of training and communication with cross-functional end-users in regards of usage and interpretation of business intelligence reports.
Mix of techno-functional knowledge about CRM products and processes used across different industry verticals like Pharmaceutical, Healthcare, Consumer Goods and Banking sector.
Major contributor in driving process improvement, re-engineering initiatives to achieve significant improvement in productivity and quality of work products.
Diverse onsite and offshore experience playing roles such as Project Manager, Team Lead, Business Analyst and Developer/Support Specialist.
Excellent knowledge using relational database like Oracle, Teradata, DB2, SQL Server including knowledge of database design, dimensional modeling, PL/SQL.
Areas of Expertise
BI Tools – OBIEE, QlikView
ETL - Informatica, PL/SQL, DAC
Relational Database - Oracle, Teradata, DB2
OS: Windows, UNIX
Other Applications - TOAD, SQL Developer
Project Management
Microsoft Project
Microsoft Office
Agile Techniques
QC – JIRA, HEAT
Employment History
Name of the Company
Designation
Duration
Location
Cognizant Technology Solutions, US Corp.
Consultant – CRM
Sep 2011 - till date
US
Cognizant Technology Solutions India Pvt Ltd.
Consultant – CRM
Sep 2007 – Sep 2011
India
Professional Experience
Cognizant/Client: McKesson Specialty Health - USA
Jul/2013 to till date
Role – Project Lead (Onsite - USA)
Key Technologies – OBIEE, Informatica, ETL, DAC, TOAD, SQL Developer, MS Project, MS Office
Key Responsibilities –
Design and develop OBIEE repository models, security, dimensional hierarchy, level based measures.
Design and develop ETL data models, Informatica data transmission mappings, procedures, DAC executions plans.
Install, upgrade and stabilize OBIEE, Informatica, DAC applications.
Manage project processes following agile techniques. Prepare and manage project plan and schedules.
Prepare project status reports for weekly meetings with management and executives.
Day-to-day management of various project control processes, including task management, RAID management, scope/change control, resource management and quality control.
Assist team with understanding data architecture and building ETL and analytics report designs.
Cognizant/Client: Merck Pharmaceutical Co. - USA
Sep/2011 to Jun/2013
Role – Business Analyst (Onsite - USA)
Key Technologies –OBIEE, Informatica, ETL, DAC, Oracle, Teradata, TOAD, MS Project, MS Office
Key Responsibilities –
Prepare functional requirements documents for BI reporting.
Scatter requirements in categories like reporting, ETL and data model.
Design dimensional data model, configure new BI-RPD models and manage promotion, integration, and security of the multi-user development environment.
Manage code advancements to production environment. Install, upgrade, and stabilize OBIEE environment.
Collaborate with the technical and business teams to respond and resolve system modification requests, and assist in the design, testing, deployment, and documentation of these changes.
Perform tasks delegation to team, closely monitor work progress.
Review deliverables adhering quality standards.
Cognizant/Client: Bank of New York Mellon - USA
Aug/2010 to Aug/2011
Role – BI Team Lead (India)
Key Technologies – OBIEE, DB2, Informatica, DAC, UNIX, Siebel Finance, TOAD
Key Responsibilities –
Design dimensional data models and ETL processes for data transfers.
Build ETL Informatica data transmission mappings, workflows and scheduling plans.
Train users on using new reports and dashboards and purpose of each for business analysis.
Configure OBIEE repository, building physical, Logical and Presentation layers.
Build Business Intelligence Reports and Dashboards.
Implement object level and data level security in OBIEE.
Maintain problem log and defect statistics.
Cognizant/Client: L’Oreal - Paris
Feb/2010 to Jul/2010
Role – Team Lead (Onsite – China)
Key Technologies – OBIEE, Informatica, Oracle, DAC, TOAD
Key Responsibilities -
Work closely with business users and understand BI reporting requirements. Train them on using BI reports and application functionality.
Develop ETL mappings and workflows to fulfill data requirements.
Build OBIEE administration repository (.RPD) data model.
Develop Business Intelligence Reports and Dashboards.
Implement object level and data level security in OBIEE.
Prepare Business User Acceptance scripts for testing BI/ETL code.
Prepare project status reports and maintain problem log and defect statistics.
Cognizant/Client: Merck Pharmaceutical Co. - USA
Sep/2007 to Jan/2010
Role – BI ETL Developer (India)
Key Technologies – OBIEE, Oracle, Informatica, PL/SQL, UNIX, XML data sources, TOAD
Key Responsibilities -
Prepare high level, low level ETL-BI design documents aligned with functional requirements.
Build ETL processes using Informatica & PL/SQL to fulfill BI reporting data requirements.
Configure OBIEE repository with star, snowflakes schema dimensional modeling.
Build Business Intelligence reports and dashboards; implement object level, data level security.
Prepare UTC test documents and execute scripts to test ETL and OBIEE code.
Participate in SIT to test ETL-OBIEE code. Provide technical assistance for troubleshooting issues.
Education
Education – Bachelor of Engineering in Mechanical (with Distinction)
Mumbai University (India)
Contact this candidate