Analytics Consultant Resume

SUMMARY:

Around eleven years of experience in software implementation and consulting. Experienced in delivering insights and implementing action - oriented solutions to complex business problems.
Proficient in sharing business recommendations using BI (Business Intelligence) tools with effective communication and time management skills. Specialized in ETL (Extract Transform Load)
Data Modeling, EDW (Enterprise Data Warehouse), Analytics, Data Quality and Data Integration.

TECHNICAL SKILLS:

Analytics & Reporting (Cognos, Tableau)
MDM (Master Data Management)
ETL (Informatica Power Center, Talend, Snaplogic, Oracle PL/SQL, SQL Server T-SQL)
Enterprise Data Warehouse (Informatica Power Center, Oracle PL/SQL, SQL Server T-SQL)
Data Migration & Integration (Informatica Power Center, Oracle PL/SQL, SQL Server T-SQL)
CDC (Change Data Capture) - (Informatica Power Exchange)
Software Products (Revitas, Model-N, Siebel CRM)
BI Tools (Informatica, Cognos)
MS Office (Excel, Power Point, MS-Word )

PROFESSIONAL EXPERIENCE:

Confidential

Analytics Consultant

Responsibilities:

Designing and developing the Government Pricing Reports on Cognos
Developing and unit testing the SQL and API based reports on Cognos
Project Assessment (Data Integration Lead)
Reassessed and analyzed data through each migration cycle for improved data quality prior to conversion into production
Reported status regularly to overall conversion workstream lead and identified issues and risks
Created ETL programs for performing post migration activities for RM and Medi deployments
Created test scripts for RM, MEDI & GP conversion process and performed testing in every cycle on HPALM platform
Data Harmonization Strategy, Design, Development & Testing
Provided consultancy to a major pharmacy and medical devices client
Devised the strategy to harmonize the data between multiple legacy systems and MDM
Design and development of the process to identify the data required to be harmonized using SQL and Informatica ETL programs

Confidential

Testing consultant and test lead

Responsibilities:

Provided software testing consultancy to a multinational conglomerate
Devised the test plan and the testing strategy for a CEO level reporting system
Enhanced the entire testing process, saving time & effort by 60% and cost by 50%
Data Modeling Consultant
Provided data modeling consultancy to a major bank of Poland
Served as an offshore team lead, coordinated with onsite EY Team and owned the offshore delivery
Assisted onsite team in Conducting workshops for the client to discuss the existing system & future requirements, by providing the material for the workshop
Technology Consultant
Provided consultancy to a European Automobile major for EDW implementation
Assisted manager in creating the business proposal
Presented the business proposal and technical solution to the client

Confidential

ETL Lead & Technology Consultant

Responsibilities:

Implemented Enterprise Data Warehouse(EDW) for a major confidential
Provided consultancy to the client regarding the tools and technology for EDW implementation
Devised the Data Extraction / Migration Strategy on the basis of Business Requirements
Assisted Data Modeling team for the designing the data model for entire EDW
Served as the module lead of ETL team for the biggest EDW implementation program across PWC and delivered the ETL module with near zero defects
Established and trained the support team for phase I
Won the “Above and Beyond Performer” for demonstrating exemplary performance and for outstanding contribution, which resulted in business advantage. Confidential

Confidential

Siebel EIM and ETL developer

Responsibilities:

Implemented Siebel UCM project for a major cruise lines of USA
Designed & Developed data synchronization and data loading process
(UTS) Unit Test Scripts preparation
Siebel EIM and ETL developer
Implemented Siebel CTMS (Clinical Trial Management System) for a US Pharmaceutical Major
Served as the Siebel EIM and Informatica ETL lead developer
Conducted peer reviews of design and code
Created comprehensive Unit Test Scripts
Framed the testing strategy for data related testing
Provided Siebel EIM and Informatica ETL

Confidential

Siebel CRM Data Lead

Responsibilities:

Analyzed business processes for major banking group
Served as the data module lead, managing a team of five developers
Devised Proof of Concept, saving over $50,000 in terms of project investment and license costs
Trained the trainers on Customer Relationship Management Software application
Planned and Executed go live process for entire data module in a very strict time window
Won Confidential “GEM” for best team
Won “Star of the month” for excellent contribution to the project