Sandeep R. Merugu

About Sandeep R. Merugu

With a substantial tenure at Macquarie Group, my journey has been marked by spearheading cloud migration initiatives and crafting robust data solutions. My role as Senior Developer has centered on transitioning legacy systems to AWS, showcasing my adeptness in schema conversion, data migration, and establishing a central data repository utilizing AWS Redshift.Our team successfully transformed operational efficiency by deploying Python-based Lambda functions for ETL processes and fine-tuning DMS tasks for over 40TB data migration. My proficiency in SQL Server, alongside a commitment to performance optimization and stakeholder management, has been integral in delivering high-impact data warehousing and BI solutions.

Experience

1. Senior Developer

   Macquarie Group

   Jul 2016 — Present · Philadelphia, PA, US

   As a Senior Developer @ Macquarie Asset Management (MAM) Tech group I have been working on multiple projects including AWS Cloud Migration, data warehouse build, Tech refresh and Vestmark upgrade.• Effectively used SCT and SSMA converting schema from legacy Sybase server to AWS RDS SQL server and handled schema conversion errors.• Created Lambda functions using Python to perform data transformation and ETL processing.• Created and fine-tuned DMS tasks to migrate over 4TB data into AWS RDS server.• Implemented AWS Redshift POC as central data repository Imported data from S3 using AWS Glue.• Simplified Data warehouse model created by external service provider and imported data feeds using generic SSIS packages/procedures.• Designed and implemented Splunk Dashboard to track the status of file loads and job schedules. Used Unified cloudwatch agent to transfer application logs from EC2 to S3. • Upgraded and migrated various in-house applications from older SQL versions to SQL 2016.

Education

• Osmania University

  Bachelor's degree, Electrical, Electronics and Communications Engineering

• Northern Illinois University

  Masters, Electrical and Electronics Engineering

Skills

• Sql
• Informatica
• Xml
• Database Design
• Oracle
• Requirements Analysis
• T-Sql
• Autosys
• Software Development
• Database Administration
• Pervasive
• C#
• .net
• Microsoft Sql Server
• Data Modeling
• Business Analysis
• Data Analysis
• Erwin
• Profiler
• Performance Tuning
• Ssrs
• Java
• Sql Tuning
• Programming
• Tableau
• Databases
• Microsoft Office
• Sdlc
• Sql Server Integration Services (Ssis)
• Sybase
• Access
• Business Intelligence
• Analysis Services
• T-Sql Stored Procedures
• Data Warehousing
• Etl
• Management
• Requirements Gathering
• Hyperion Enterprise
• Integration