Abhishek Mahendroo

I am software development engineer with nearly 3 years of experience. I have mainly worked in data engineering for past 3 years with a bit of application development. I am proficient in SSIS, SQL(t/pl sql), Azure(logic apps, data factory, storage account, blob etc). I am microsoft azure certified. I have hands on experience on working with ETL/ELT pipelines and good experience working with github (CI/CD).

I also know c# and python and can code in both. 

• ETL Development: Proficient in developing, deploying, and optimizing ETL (Extract, Transform, Load) packages using SSIS (SQL Server Integration Services).

• SQL Expertise: Skilled in writing SQL queries, stored procedures, and functions for data analysis, reporting, and ETL integration.

• Query Performance Tuning: Experienced in fine-tuning SQL queries for enhanced performance and efficiency.

• Data Analysis: Strong foundational knowledge of SQL and relational databases, with a focus on data analysis.

• Data Tools: Familiarity with SAP BW for extracting and reporting on business data.

• Version Control & DevOps: Proficient in Git for version control and understanding of DevOps practices.

• Cloud Expertise: Microsoft Azure Fundamental (AZ-900) certified, showcasing cloud computing knowledge. Capable of working with Azure services like Logic Apps, Data Factory, storage accounts, and Blob Storage.

• Programming Languages: Capable of working with .NET and Java programming languages and HTML.

• SDLC and Methodologies: Proficient in SDLC processes with experience in Agile and Waterfall methodologies. Familiar with development principles like KISS, SOLID, and YAGNI.

• Production Support: Experience in production support and on-call responsibilities for ETL jobs, including code and data analysis, and providing solutions.

• ITIL Knowledge: Familiarity with ITIL concepts for IT service management.

• Tools - SSMS, Visual Studio Data Tools, GitHub, Multiple SAP BW Systems, Bex Query Designer, Bex Analyzer, SNOW, JIRA Work Experience

Software Development Engineer – MResult Services, Bangalore(India) Client – BioMarin (USA)

06/2023 - Current Project – Commercial Datamart Development Technologies Involved - SQL(SSMS),SSIS, Azure Devops, JIRA Data Gathering and Processing

• Collect and process pharmaceutical data from various sources.

• Execute Extract, Transform, Load (ETL) processes for data transformation.

10/2023 – Current

Development:

• Develop and modify database tables/SSIS Packages to meet project-specific requirements.

Rigorous Unit Testing:

• Conduct thorough unit testing to ensure data reliability and quality.

• Ensure data is production-ready after testing.

Jira Ticket Management:

• Utilize Jira for efficient project management.

• Prioritize and address tasks according to project needs.

Process Chain Correction and Optimization:

• Periodically correct and optimize data process chains.

• Maintain the smooth and efficient flow of data throughout the system. Project - Source Code Migration from TFS 2018 to Azure Devops Technologies Involved - SQL(SSMS) , Visual Studios

06/2023 – 09/2023

• Project Analysis: Conducted a thorough project analysis and proposed three migration strategies and built POC for the selected solution option.

• Development: Actively contributed to the migration of the code repository from TFS 2018 to Azure DevOps, working alongside the solution architect and Tech Leads.

• Successful Project Delivery: Collaborated effectively with the project team, ensuring the successful completion of the project within the stipulated time frame.

Application Development Analyst – Accenture, Bangalore(India) 01/2021 – 05/2023 Client - Ab InBev (Belgium) Project – Sales Data Warehouse(ETL) Technologies Involved - SQL(SSMS) , SSIS, Visual Studio, Bex Query Designer, Bex Analyzer, SNOW, JIRA

• Support: Managed and supported an ETL application, overseeing data stored in the database.

• Development: Designed and modified SSIS packages in alignment with provided requirements and specifications.

• Client Engagement: Represented the internal team in daily and weekly meetings with onshore client teams, fostering effective communication.

• Project Tracking: Executed essential project activities and maintained ticketing tools like SNOW and JIRA, ensuring project progress tracking.

• 24/7 On-Call Support: Provided round-the-clock on-call support for live systems and assisted clients across different time zones.

• Data Analysis: Investigated data anomalies, job failures, and managed tickets (Incidents, Service Requests, and Change Requests).

• Cross-Team Collaboration: Collaborated with diverse teams to expedite ticket resolution and enhance efficiency.

VTU – Sir MVIT Bangalore, India (2016-2020)

(Bachelor of Engineering: Electrical & Electronics Engineering) • Graduated with distinction – 7.8 CGPA