Akshay Amrutkar

Project: RAC – UK / Europe

Role: Senior ETL / MSBI Developer
Duration: 2019 – Present

Onsite Assignment – Client Location (UK - Bristol) (July 2022 – July 2024)

Key Responsibilities & Achievements:

· Designed and enhanced SSIS-based ETL pipelines to load large-scale data into enterprise data warehouse systems.

· Implemented end-to-end ETL workflows from Oracle and SQL Server source systems to downstream reporting layers.

· Developed and supported SSRS reports and dashboards for business and operational users.

· Performed SQL performance tuning and optimized ETL processes to improve data load efficiency.

· Monitored and resolved production ETL issues, ensuring SLA compliance and data accuracy.

· Automated manual data processing using SSIS scheduling and control frameworks.

· Currently involved in migration of SSIS/SQL-based ETL workflows to Snowflake, supporting data model validation and query optimization.

· Served as the primary onsite ETL/BI contact (UK/Europe), handling requirement discussions, UAT support, and production deployments.

· Coordinated with offshore teams for defect resolution, change requests, and post-release support.

Project: BPS Applications – TCS

Role: Developer
Duration: 2017 – 2019

Technologies: C#, .NET, MVC, Angular, SQL Server

Key Contributions:

· Developed and enhanced web-based applications for BPS domain, including Project Planning and Forecasting tools.

· Upgraded applications to newer .NET framework versions as part of modernization initiatives.

· Built POCs using Angular and supported enhancements and bug fixes.

· Collaborated with functional teams to understand requirements and deliver solutions.

Project: HSBC POC / RPA – TCS

Role: Developer

Duration: 2016 – 2017

Key Contributions:

· Conducted process analysis and feasibility studies for automation initiatives.

· Created process flow diagrams and RPA design documents.

· Worked with architects to validate proposed automation solutions.