Chalapathi Pagidakula

Client: ASML, San Diego.

• Built a data processing framework for LAS (LiDAR data format).
• Developed LAS (LiDAR data format), Azure, and Databricks integration framework.
• Designed ELT processes (PySpark, Databricks Workflows).
• Created CICD processes for schema migrations, workflows, cluster pools, etc.
• Implemented the MFT flow process using Python and PowerShell.
• Troubleshot Delta Live Tables jobs.
  Environment: Azure (ADLS, Event Hubs, ACR), Databricks. Tools: Python, Git, Docker, Bitbucket, Splunk, Grafana, Ozzie. Other: Scrum methodology

Client: HCSC, U.S.

• Wrote scripts and processes for data integration and bug fixes.
• Worked as part of project teams to coordinate database development and determine project scopes and limitations.
• Utilized various tools such as SQL Server Management Studio, Toad Data Modeler, Visual Studio Code and Red Gate Software products for development purposes.
• Developed algorithms that optimized the accuracy of processed information while minimizing response times.
• Monitored performance of data processing systems in order to identify areas of improvement.
• Coordinated with vendors regarding hardware and software purchases necessary for improving system efficiency.
• Adhered to compliance and privacy policies and procedures to maintain confidentiality and information protection.
• Coordinated with customers to resolve problems regarding process discipline, data accuracy and data integrity.
• Promoted high customer satisfaction by resolving problems with knowledgeable and friendly service.

Environment: Azure (ADLS, Event Hubs, ACR),SQL, Databricks. Tools: Python, Git, Bitbucket, Jenkins, Apache Spark. Other: Scrum methodology.

Client: Diageo, UK.

• Migrated SQL Server 2005, 2008, and 2012 to SQL Server 2014 and 2016 in Microsoft Windows Server 2012 and 2016 Enterprise Edition.
• Migrated SSIS packages from SSDT 2013 to SSIS 2015.
• Migrating the databases from on-premises to Azure Cloud.
• Installing and configuring SQL Server 2014, 2016, and 2017.
• Expert in using DMVs, performance dashboards, mirroring, database snapshots, and tracking performance counters.
• Rebuilding and monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters
• Implementing Point-in-Time Recovery solutions.
• Involved in troubleshooting and fine-tuning of databases for their performance and concurrency.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA)
• Responsible for monitoring and making recommendations for performance improvement in hosted databases
• This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases

Environment: On-premises and Azure; Tools: Python, Bitbucket, Power BI, SQL Server; Other: Scrum methodology.

Client: Heritage Provider Network, U.S.

• Perform business analysis, technical analysis, and systems design.
• Prepared DFDs and Entity Relationship (ER) diagrams.
• Restructuring the stored procedure, designing, coding, and developing it using T-SQL programming.
• Monitoring SQL Server performance using SQL Profiler to find performance issues and deadlocks.
• Developed, deployed, and monitored SSIS packages, including upgrading DTS to SSIS.
• Performed daily tasks, including backup and restore, by using SQL Server 2008 and 2012 tools, like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Extensively worked on data partitioning and snapshot isolation in SQL Server 2005, 2008, and 2012.
• Prepared the project management and technical documentation.
• Unit testing the SSIS packages with respect to their flow and performance issues.
• Solving the bugs reflected by the testing team.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified performance using execution plans and index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Involved in troubleshooting and fine-tuning of databases for their performance and concurrency.
• Complete documentation about the database.
• Recovering the databases from backup in disasters
• Export or import data from other data sources, like flat files, using Import/Export through DTS and SSIS.
• To analyze long-running, slow queries and tune them to optimize application and system performance.
• To set up SQL Server configuration settings for better server management.
• Monitoring the servers using Idera third-party software.
• Worked on SQL Server tools, like Enterprise Manager and SQL Query Analyzer.
• Environment: MS SQL Server 2005, 2008, 2012, and 2014; Win Server 2008 and 2012; BI tools; SQL Query Analyzer; SQL Profiler.

Client: ProCare, Cigna, Aetna, United Healthcare, US.

• Migrated SQL Server 2008, 2012 to SQL Server 2016 in Microsoft Windows Server 2016 Enterprise Edition.
• Migrated SSIS packages from SQL Server 2008 R2 to SSDT 2015.
• Extensively worked on SQL Server Integration Services (SSIS).
• Expert in using DMVs, performance dashboards, mirroring, database snapshots, and tracking performance counters.
• Rebuilding and monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters.
• Implementing Point-in-Time Recovery solutions.
• Involved in troubleshooting and fine-tuning of databases for their performance and concurrency.
• Involved in source data analysis, analysis, and designing mappings for data extraction; also responsible for the design and development of SSIS packages to load the data from various databases and files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented data partitioning, error handling through TRY-CATCH-THROW statements, and common table expressions (CTE).
• Client: ProCare, Cigna, Aetna, United Healthcare, GOTELECARE, Blue Cross, Blue Shield, Fox Insurance, United Healthcare, US.
• Environment: SQL Server 2014/2016 Enterprise, Windows Enterprise Server 2016, .NET, Microsoft Visio, SFTP.