Hemant Narkhede

acq3dj@r.postjobfree.com

267-***-****

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