Mahak Garg
Lucknow
Summary
Proficient, organized, and detailed data engineer looking to apply 7+ years’ database management experience and strong written and verbal communication skills towards delivering scalable solutions to meet business needs.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data Engineer
Morgan Stanley
Bangalore
08.2022 - Current
- Extracted, transformed, and loaded cash and equity data into the database (Greenplum, DB2, Snowflake), which helped various down streams generate their regulatory and non-regulatory reports.
- Configured various Autosys jobs.
- Set up an end-to-end process on Snowflake, catering to the US T+1 settlement process.
- Worked on Python Upgrade from 3.7 to 3.10
- Implemented an observability solution to monitor Autosys logs on Grafana.
- Migrated data storage from SharePoint to MongoDB to enhance the Campus Recruitment Application.
- Worked on database maintenance and optimization.
Senior Engineer
Nagarro
Gurugram
09.2021 - 08.2022
- Configured casino platform for multiple countries and regulations.
- Implemented self-exclusion and responsible gaming checks for Germany regulation that affected approximately 10,000 players.
Senior Software Engineer, Finance Domain
PureSoftware (formerly PureTesting)
Noida
05.2019 - 08.2021
- Designed and developed payment processes using SSIS to complete the debt collection of 50K accounts in approximately 1.5 hours.
- Integrated the package with the REST API task, Amazon S3 Storage task, etc.
- Developed an ETL process to load new portfolios efficiently into the database, capable of completing the process for 50K consumers in 5 hours, enhancing the load process by 70%.
- Implemented the Sliding Window Partition Technique to purge the aged data and create new partitions to store the incoming data.
- Worked on query optimization to improve the performance of 5 or more stored procedures by 40%.
- Published SSRS Reports to feature the status of daily running jobs
- Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
- Established joins and created clustered/non-clustered indexes wherever necessary.
- Recognition: I received many achievement and appreciation emails from the MCM Technology head and Account Manager for successfully increasing the cost collection by approximately $1.5M.
Application Development Associate, Hospitality Domain
Accenture
Gurugram
05.2017 - 05.2019
- Configured a database for over 500 properties.
- Designed an ETL package to generate a report containing information about the revenue generated, patching status on a daily basis, which reduced 2 hours of daily manual effort.
- Scheduled a SQL Server Agent job to run the SSIS package at a fixed time daily.
- Served as an SME for point-of-sale database issues and new client-server/interface installations.
- Recognition: I received a letter of recommendation for leadership skills, profit-making, delivery excellence, etc.
Education
Bachelor of Technology - Electronics & Communication
BANASTHALI UNIVERSITY
Rajasthan01.2017
Skills
- Microsoft SQL Server
- GREENPLUM
- DB2
- Python
- SQL Server Integration Services
- Snowflake
- MS Excel (Advanced)
- Autosys
Certification
- SNOWPRO CORE CERTIFICATION
- Querying Microsoft SQL Server using T-SQL, Udemy
Awards
- EMPLOYEE OF THE YEAR, Accenture, 2018
- BRAVO AWARD, PureSoftware, 2019
- DRONACHARYA AWARD, PureSoftware, 2020
- ARJUNA AWARD, MORGAN STANLEY, 2024
Languages
Hindi
First Language
English
Elementary (A2)
A2
French
Beginner
A1
Timeline
Data Engineer
Morgan Stanley
08.2022 - Current
Senior Engineer
Nagarro
09.2021 - 08.2022
Senior Software Engineer, Finance Domain
PureSoftware (formerly PureTesting)
05.2019 - 08.2021
Application Development Associate, Hospitality Domain
Accenture
05.2017 - 05.2019
Bachelor of Technology - Electronics & Communication
BANASTHALI UNIVERSITY
Similar Profiles
Michael RedigerMichael Rediger
Operations Specialist at Morgan StanleyOperations Specialist at Morgan Stanley
Kevin UppKevin Upp
Request Coordinator at Morgan StanleyRequest Coordinator at Morgan Stanley
Meeta VermaMeeta Verma
Director at Morgan StanleyDirector at Morgan Stanley