Mahak Agrawal
Noida
Summary
Detail-oriented Data Engineer with 4 years of experience in SSRS reporting, advanced T-SQL development, and ETL pipeline design using Azure Data Factory. Strong background in data modeling, performance tuning, and delivering reporting solutions in Agile, finance-driven environments. Skilled in problem-solving, collaboration, and translating business requirements into efficient data solutions.
Overview
4
4
years of professional experience
Work History
Software Engineer
Indus Valley Partners
Noida
08.2021 - Current
- Developed and maintained 80+ SSRS reports, including matrix, subreports, and parameterized reports with complex expressions, multi-dataset sources, and dynamic formatting.
- Wrote and optimized complex SQL Server stored procedures, functions, views, and queries using CTEs, temp tables, table variables, subqueries, string functions, and window functions.
- Improved performance of stored procedures and ETL pipelines by analyzing query execution plans, adding indexes, and rewriting inefficient logic.
- Created and maintained multiple ETL workflows for processing and loading large datasets into SQL Server and data warehouse environments.
- Built reporting stored procedures used as SSRS data sources, and deployed reports to the SQL Server Reporting Services (SSRS) Report Server for end-user access.
- Collaborated directly with business users for requirements gathering, debugging complex queries, and implementing business logic; ensured alignment with user expectations and reporting needs.
- Leveraged and modified the existing codebase to accelerate the development of new reports, improving delivery timelines, and reducing redundancy.
- Designed and implemented Azure Data Factory (ADF) pipelines for daily ingestion of flat files and automated loading of data into the data warehouse.
- I collaborated in a fast-paced Agile development environment within the financial services domain, supporting hedge fund clients.
- Used Git for version control, and worked with JIRA and Asana for sprint planning, task tracking, and project management.
Education
Bachelor of Technology - Information Technology
United College of Engineering & Research
Prayagraj08-2022
Skills
Databases & Query Languages
- Microsoft SQL Server (T-SQL, Views, Stored Procedures, Functions)
- Azure SQL
- SQL Query Optimization
- Advanced T-SQL
ETL & Data Integration
- ETL Design and Development
- ETL Optimization
- Azure Data Factory (ADF)
- Active Batch
Reporting & BI Tools
- SQL Server Reporting Services (SSRS)
- RDL Report Design
- Parameterized and Matrix Report
Data Management
- Data Modeling & Warehousing
- Data Profiling
- Data Validation
- Data Cleansing
Tools & Version Control
- Git
- Asana
Programming Languages
- Python (Basics)
Soft Skills
- Attention to Detail
- Creative Thinking
- Problem Solving
- Collaboration & Teamwork
- Quick Learner
Accomplishments
- Shining Star Award for exceptional performance and client-focused delivery.
- Multiple Client Appreciations for high-quality work and problem-solving.
- Spot On Recognition for timely execution of complex, high-impact tasks.
Timeline
Software Engineer
Indus Valley Partners
08.2021 - Current
Bachelor of Technology - Information Technology
United College of Engineering & Research