Moorthy Subbarayan Parthiban

• Designed and implemented end‑to‑end data migration pipelines to Microsoft Azure, migrating on‑premises datasets to Azure Data Lake Storage (ADLS) and Azure SQL as part of cloud modernization initiatives.
• Developed and orchestrated ETL workflows using Azure Data Factory (ADF) to ingest data from legacy databases and flat files into Azure cloud storage.
• Monitored, optimized, and troubleshot ADF pipelines and Azure data processing jobs to enhance reliability and reduce data‑load latency.
• Created Python‑based automation solutions for data extraction, transformation, and workflow optimization, improving the efficiency of existing ETL processes.
• Utilized Python libraries such as Pandas and PySpark for large‑scale data cleansing, transformation, and validation tasks.
• Developed secure encryption/decryption pipelines using Python and SSIS for PHI data by applying industry‑standard encryption techniques (PGP/GPG) to ensure regulatory compliance.
• Developed reports using Power BI and SSRS based on business requirements.
• Managed HIPAA‑regulated healthcare data and implemented secure processes for enterprise data loading and maintenance.
• Demonstrated strong proficiency in writing, optimizing, and debugging complex stored procedures and SQL functions.
• Used Cerberus FTP and MOVEit SFTP applications to manage and automate secure file transfers
• Proven ability to work independently and provide technical guidance and support to team members and stakeholders as needed.

• Work with Aetna CVS Business analysts and Scrum Master to review and finalize the business requirements.
• Extract Membership information form QNXT Database and load to Dynamo application using SQL Stored procedures.
• Develop SSIS Packages to Import data from various vendors Files (Delimited Files, Flat Files, Fixed width files) to Dynamo application Case, Events, Contact Events and Assessments.
• Develop SSIS Packages to export data from Dynamo application Case, Events, Contact Events and Assessments to various data sources or files.
• Build Reports and Dashboard using Power BI. Build Customized Reports and SSRS Reports based on requirements.
• Conduct software peer code reviews for deliverables and implementing the software applications in production environment.
• Analyze the performance issues encountered in production and provide a fix the performance issues.
• Coordinates day-to-day internal team meetings with clients in order to identity the business needs and evaluate alternate business solutions.
• Act as mentor to the new joiners and train them in the application and SSIS.
• Involved in support activities after production deployment during the application warranty period.

• Worked with key client partners, including American Express, Molina Healthcare, and WellPoint Anthem, to successfully execute business requirements.
• Understanding the requirements and design the system and implement the functionalities.
• Create UML Diagrams, Architecture Diagrams and use case diagrams for the requirements.
• Prepare unit test cases for the requirements.
• Analyze and update SSIS packages for the application.
  Design and develop SSIS packages for the given requirements.
• Analyze the performance issues encountered in production and provide a fix the performance issues.
• Act as mentor to the new joiners and train them in SSIS.
  Involved in support activities after production deployment during the application warranty period.

• Understanding the requirements and design the system and implement the functionalities.
• Create design documents and requirement documents.
  Prepare unit test cases for the requirements.
• Create UML Diagrams, Architecture Diagrams and use case diagrams for the requirements.
• Upgrade the existing CHARM SQL 2000 database to SQL 2005 database and test all the modules and back office process involved in CHARM application.
• Design and develop SSIS package for the existing DTS packages in SQL Server 2000.
• Worked on the payment module for the eCharm application to develop a Credit/Debit Card validation process.
• Analyze the performance issues encountered in production and provide a fix the performance issues.
  Involved in support activities after production deployment during the application warranty period.