Consultant
ZS Associates Inc.
Total years of experience :13 years, 3 Months
Data Warehousing: Extensive experience in DW/BI area. Proficient in Dimensional Modelling, Data Management Consulting including Master Data Management, DW Architecture and Data Quality Management. Experience in architecting end-to-end Data Warehousing solutions. Empanelled as SME in DW/BI Architecture in ZS Associates and helped develop and implement DW/ETL standards, procedures and best practices.
Data Integration & Delivery: Proficient in Data Integration area. Handled Structured/Semi-Structured/Unstructured data using tools such as Informatica PC and Talend Studio. Exposure in building Real Time Data Warehouses and implementation of Data Quality layer. Exposure working on MSTR and Business Objects to build Reporting Packages and reports.
Databases: Worked on Oracle, MS SQL Server and MySQL databases including DB Design and SQL Development. Thorough in performance optimization techniques.
Domain Understanding: Been in techno-functional roles to ensure BI solutions meet customer expectations. Extensively worked in US Pharma (Otsuka, Gilead, Vivus) domain. Good understanding of Pharma industry and various vital processes such as Sales Reporting, Call Planning, Alignment and Targeting, Incentive Compensation, Field Reporting, Plan Payer data, PLD and more.
Project Management: Experienced in leading and managing projects with diverse technologies. Worked extensively on Pre-Sales/ITO cycle and contributed to organization’s business building initiatives through proposal writing and presentations.
Worked as a ETL professional . Primary Roles and Responsibilities involved :
Providing estimation and project plan for enhancements prior to commencement of project.
Functioning as part of the Form Certification project, which involved development of attachment criteria for policy documents.
Performing coding and Unit testing.
Attending daily status meeting with client.
Using Product Configuration Tool (PCT) for development of customized insurance products on the MIC framework.