AMITABH ABHISHEK
Chennai,TN
Summary
Data Analyst with 8.11 years of experience in developing and maintaining data models, warehouses, and ETL processes resulting in significant reductions in data processing time and increased accuracy. Developed and maintained data warehouses and data marts, resulting in a 30% reduction in data retrieval time and a reduction of 25% bandwidth utilization of the team
Overview
9
9
years of professional experience
Work History
Officer C10-Data/Information Management Analyst 2
CITI Corp Services India Pvt Ltd
Chennai , TN
2022.02 - Current
- Tableau Dashboard Development and maintenance for monitoring of ATM key operation metrics such as Availability, Downtime and Impacting Tickets
- Worked with team of 3 people to migrate 30 IBM Reports to Tableau
- Extended ETL Support( SSIS ) and helped in Data Migration during server decommissioning
- Build and upgraded Dashboards for new fleet of ATMs
- Helped in setting up RLM deployment for SQL objects and SSIS
which helped in freeing up the bandwidth utilization of team by 25%
Senior Associate
BNP Paribas India Solutions Pvt Ltd
Chennai , TN
2021.07 - 2022.02
- Designed SSRS Report and Developed and optimized MS SQL Server Objects and SSIS Packages
Technology Analyst
Infosys Ltd
Chennai , TN
2020.12 - 2021.06
- Coordinated Migration of 30+ reports from SAP BO to SSRS
Associate
Cognizant Technology Solutions
Chennai , TN
2019.01 - 2020.12
- Develop SSIS Package Development for build Process of Lane Growth Project in Supply Chain domain also Responsible for Deploying and Scheduling Jobs
Software Engineer
Hexaware Technologies Ltd
Chennai , TN
2015.07 - 2019.01
- Design and implement Extract, Transformation and Load (ETL) processes, programs and scripts using SSIS and Improved the performance of SQL objects
- Migrated more than 20 Excel Reports to Power BI
Education
Bachelor of Technology - Information Technology
Maulana Abul Kalam Azad University Of Technology
West Bengal07.2015
Skills
- Design and implementation of Data Warehouses, planning applications and reporting solutions
- Proficient in creating, configuring workflows in MS SQL SSIS
- Programming Languages - Python, RDBMS(SQL), DAX
- Databases: SQL Server, Oracle 11g
- Tools: Visual Studio (2005 to 2019), Power BI Desktop,SQL Server Data Tools (SSIS , SSRS)
- Operating System: Windows 7, Windows 10, Windows Server R2
Project Experience
Project 1: Org-Hexaware Technologies,Client- Unisys Corporation
Role - Migrate SAP BO Reports to MSBI
Tools used - SSRS,SSAS(MDX)
Project 2: Org-Hexaware Technologies,Client- Post Office,UK
Role - Process Data coming from different lines of business (insurance-car,home,life,pet,motor) using SSIS packages and then create
SSRS Reports and send the Daily/Weekly/Monthly Reports via Email
Tools used - SSRS,SSIS
Project 3: Org-Cognizant Technologies Solutions,Client - J.B.Hunt
Role - Data Migration from legacy ( IBM- DB 2 to Microsoft SQL Server)
Tools used- SSIS
Project 4: Org-Cognizant Technologies Solutions,Client - UPS
Role- Create Build Process for Lane Growth with help of SSIS Package and also provide Billing,Performance,Transportation Reports
using Power BI
Tools used- SSIS,Power BI
Project 5:Org-Infosys ,Client-UNILEVER
Role-Enhancement and Support various applications for R&D community for there Product Lifecycle Management using MSBI and Power BI
Tools used- SSIS,SSRS,Power BI,SAP BODS
Timeline
Officer C10-Data/Information Management Analyst 2
CITI Corp Services India Pvt Ltd
2022.02 - Current
Senior Associate
BNP Paribas India Solutions Pvt Ltd
2021.07 - 2022.02
Technology Analyst
Infosys Ltd
2020.12 - 2021.06
Associate
Cognizant Technology Solutions
2019.01 - 2020.12
Software Engineer
Hexaware Technologies Ltd
2015.07 - 2019.01
Bachelor of Technology - Information Technology
Maulana Abul Kalam Azad University Of Technology
Similar Profiles
Punit MundraPunit Mundra
Manager (C11)- Financial Planning & Analysis at Citi Bank (Citi Corp Services India Pvt. Ltd.)Manager (C11)- Financial Planning & Analysis at Citi Bank (Citi Corp Services India Pvt. Ltd.)
Tauseef AhmadTauseef Ahmad
Assistant Vice President at Citi Corp Services India Pvt. Ltd. (Citi Bank)Assistant Vice President at Citi Corp Services India Pvt. Ltd. (Citi Bank)
Green RajoriaGreen Rajoria
Escalation Analyst (Senior Operation Specialist) at Citi Corp Services India Pvt LtdEscalation Analyst (Senior Operation Specialist) at Citi Corp Services India Pvt Ltd