Pavan Kumar Shapalli

Innovative and motivated data professional with 9+ years of broad-based experience in building data-driven applications overcoming complex architectural and promoting utility of data within diverse organizations. Proficient in database modelling, programming, data extraction, data manipulation, and data visualization. Committed to delivering high-quality solutions, collaborating effectively with cross-functional teams, and staying up to date with emerging technologies. • Expert in Database Design, Data modeling, Development, Implementation, Visualization through ETL using Microsoft Product SQL Server, SSIS, Informatica Cloud ,Oracle SQL, AWS Cloud Services includes Glue,S3 Buckets, Lambda, Clusters, IAM, EC2,Step Functions with expertise on data normalization, Denormalization and understanding of SDLC lifecycle and methodologies like Agile, Scrum, and Waterfall. • Specialist in all areas of Project Life Cycle including requirements Analysis, Application Design, Data Modeling, Development, Implementation, maintenance, migration, testing heterogenous data warehouses and database applications for Health Care Insurance and Financial Services. • Skilled in crafting SSIS Packages and Infamaps of Informatica Cloud Services for the purpose of Extracting, Transforming, and Loading (ETL) data into the Data Warehouse from various databases including Oracle, DB2, SQL Server, Snowflake, and DataStage. • Designed and orchestrated multiple AWS pipelines through glue to ingest data from multiple sources like Oracle DB, Teradata, Sales force to Amazon RDS, S3 Buckets and AWS DynamoDB. • Analyzing Root Cause Analysis (RCA) of problems, the long and short-term effect of solutions and development of workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines. • Identified opportunities for improvement through analysis of key metrics and KPIs related to user acquisition, retention, and monetization by supervising 6+ cross-functional teams. • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. • Competence in Design, Develop & Maintain Data warehouses for Healthcare Insurance Consumers based of business rules by creating robust ETL pipelines