Pavan Kumar Email & Phone Number

United States

San Francisco, California, US

• Developed robust data ingestion pipelines using Azure Data Factory and Python to extract patient data from various sources such as Electronic Health Records (EHR) systems, medical devices, IoT sensors, and NoSQL.
• Developed and maintained custom connectors in Azure Data Factory to integrate with various third-party APIs, NoSQL databases, and data sources, extending the ETL capabilities and enabling seamless data ingestion.
• Integrated SQL Auto Loader in data ingestion processes to streamline and automate the detection and loading of new files, enhancing the efficiency of data pipeline workflows and reducing manual intervention.
• Integrated Azure Logic Apps into data workflows to automate and orchestrate data processing tasks across Azure services, improving workflow efficiency and reducing manual intervention.
• Integrated Azure Data Factory with Azure Key Vault to securely manage and access sensitive configuration settings and credentials, enhancing the security of ETL processes.
• Conducted performance tuning and optimization of SQL queries, indexes, and database configurations to enhance the efficiency and speed of database operations.

• Developed and optimized SQL queries and stored procedures within Azure Data Factory and SSIS to extract, transform, and load data, ensuring efficient processing and adherence to data warehousing best practices.
• Created T-SQL scripts for automating routine database maintenance tasks such as index rebuilding, statistics updates, and backup operations, ensuring database health and performance.
• Utilized T-SQL's advanced analytical functions such as window functions, common table expressions (CTEs), and pivoting to perform complex data analyses and generate insightful reports.
• Implemented Azure Logic Apps to automate workflows and orchestrate data integration tasks between disparate systems, enhancing operational efficiency and reducing manual effort.
• Performed performance tuning of Snowflake data warehouse using Query Profiler, caching mechanisms, and virtual data warehouse scaling to optimize query execution and enhance overall system performance.
• Developed data quality dashboards and reports to provide insights into data quality trends and issues, supporting data governance and stewardship efforts.

Phoenix, AZ, US

• Prepared an ETL framework using Sqoop, Pig, and Hive to bring in data from various sources and make it available for consumption.
• Processed HDFS data and created external tables using Hive along with developing scripts for table ingestion and repair for reuse across the project.
• Developed and maintained integration solutions to import and export data between SQL Server and external systems using APIs, Linked Servers, and other connectivity options.
• Created, optimized, and maintained complex stored procedures and user-defined functions to encapsulate business logic and improve application performance.
• Established comprehensive audit and logging mechanisms to track data changes, user activities, and system performance for security and compliance purposes.
• Developed ETL jobs using Spark and Scala to migrate data from Oracle to new MySQL tables.

Atlanta, Georgia, US

• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server
• Expert in designing ETL data flows using SSIS, creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Access/Excel Sheets using SQL Server SSIS.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions, and developing fact tables, dimension tables, using Slowly Changing Dimensions (SCD).
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.
• Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.

Seattle, WA, US

• Used BULK SQL and BULK BINDING to minimize the execution time of PL/SQL code.
• Created SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Analyzed the existing Stored Procedures, Functions, Triggers and Cursors on performance issues.
• Managing Tables, Indexes, Constraints, Views, Sequences, and stored program units.
• Used the Oracle Import/Export utilities for taking the backup of a particular partition data.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.