Ranjit P. Email & Phone Number

• Led the design, development, and implementation of over 5 Data Warehouse/Business Intelligence Systems at many fortune 500 companies, including industry experience in State Government, financial/insurance, Banking, Retail, and Media.• Excellent leadership and communication skills, including interaction with high level management. Proven ability to work effectively within a highly matrix, global environment. Skilled in collaborating with various offshore teams.• Efficient in managing all phases, including the (analysis, design, testing, and implementation) of data warehouse projects using every common type of data store – transactional (OLTP), data warehouse (Kimball / Inmon), and Data Mart (OLAP).• Collaborated with business partners, product development teams, and Subject Matter Experts (SME) to capture requirements and design a ETL solution that will guide the Conversion / Synchronization of the legacy system data to the future Enterprise Data warehouse.• Thorough knowledge of Data Warehouse and Data Mart design concepts and extensively worked on entity-relationship/multidimensional data models like Star Schema and Snowflake Schema.• Involved in the design of Data Management Strategy and Plan (DMSP) and validated the methods and activities for the successful Data Migration and Conversion to large scale Data Warehouse.• Extensive background in life cycle development SDLC of data warehouse projects in compliance with Waterfall and Agile Development Methodology.• Strong documentation skills especially preparing data / process / system flows, business / reporting requirements, technical specifications, etc. in compliance with organization standards and best industry practices.• Experience in leading a team to achieve success in Design, Development and Deployment / implementation of mid-to-large scale Data warehouse projects.• Ability to establish and maintain a high level of customer trust and confidence in the Data Warehouse / Business Intelligence teams.• Supported a team of ETL developers by providing technical assistance, troubleshooting, and alternative development solutions.• Delivers three years of experience in Software Testing and Quality Assurance. Proficient in designing Use cases, Test plans and Test cases based on Business Requirements and Technical Specifications.• Play a key role in the Design of Master Test plan that drives the overall testing phase, which includes system testing, integration testing, user acceptance testing, performance testing, and track testing metrics / results.