Abhishek Singh
Data Analyst
LUCKNOW
Summary
I aim to leverage my diverse technical skills to meet targets and drive exceptional performance within the organization. I am eager to contribute my innovative ideas, expertise, and creativity to help achieve the company's goals.
As a data analyst with extensive 6 years experience in data migration and ETL processes, I specialize in extracting, transforming, and loading data to ensure seamless integration and accurate reporting. I have hands-on expertise in designing and implementing ETL pipelines using tools like Ab Initio and SQL, with a strong focus on maintaining data quality and optimizing performance. My background includes successfully migrating large datasets, developing data workflows, and conducting thorough analyses to ensure smooth data transitions. I am committed to using my technical skills and analytical mindset to support data-driven decision-making and drive business efficiency.
Overview
6
6
years of professional experience
7
7
years of post-secondary education
Work History
TECHNICAL SPECIALIST
Citibank
Mexico City
06.2021 - Current
- I was responsible for the end-to-end design, development, testing, and deployment of Ab Initio ETL graphs, ensuring efficient extraction, transformation, and loading of large-scale data sets
- Working collaboratively with the global team, I built and configured the application while establishing robust database connections to support seamless data integration
- My responsibilities included managing code promotion across various environments, testing the ETL processes, and ensuring system reliability and performance
- To maintain data integrity and quality, I conducted detailed source system analyses, validated business rules, and applied performance tuning techniques to optimize ETL processes
- I managed high-volume data loads, addressing scalability and performance challenges
- Additionally, I configured and maintained database and server node connections to ensure seamless communication between systems
- I designed and documented high-level test plans for the project, covering comprehensive test case scenarios
- I also created detailed project documentation, including architecture diagrams, connectivity maps and runbook for specific modules
- Furthermore, I identified critical data segregation points for tables and files, overseeing the development and implementation of high-scale data segregation processes
- This ensured secure, efficient, and compliant data segmentation while optimizing performance
- Managed multiple high-priority projects simultaneously, consistently meeting deadlines while maintaining attention to detail.
PRODUCTION SUPPORT
WALGREENS
Noida
02.2019 - 06.2021
- My responsibilities included providing critical production support, swiftly resolving issues to ensure operational continuity
- I automated routine processes and tasks by developing shell scripts, significantly improving operational efficiency
- Using SQL, I executed complex queries for data extraction, transformation, and manipulation to support various business requirements
- Additionally, I gained extensive experience working with ServiceNow, managing and implementing Change Requests (CR), Incident (INC) tickets, and Service Requests (REQ), ensuring timely issue resolution and system enhancements
- Furthermore, I contributed to data integration initiatives using tools like Inspector and Master Data Management (MDM), ensuring smooth data flow and consistency across systems
Education
Bachelor of Science -
Ideal Institute of Technology
Ghaziabad 06.2014 - 08.2018
High School Diploma -
Rani Laxmi Bai
Lucknow 04.2012 - 03.2014
Secondary School -
Rani Laxmi Bai
Lucknow 04.2011 - 01.2012
Skills
Data Analysis
CI/CD Pipeline
Project Management Collaborating with Stakeholders
Migration and Testing
AWS
ETLAb-Initio
DBMSSQL-Teradata
No-SQLMongoDB
PySpark RDD/SQL
Tableau
DockerAirflow
Jira
AutoSys
Linux
Timeline
TECHNICAL SPECIALIST
Citibank
06.2021 - Current
PRODUCTION SUPPORT
WALGREENS
02.2019 - 06.2021
Bachelor of Science -
Ideal Institute of Technology
06.2014 - 08.2018
High School Diploma -
Rani Laxmi Bai
04.2012 - 03.2014
Secondary School -
Rani Laxmi Bai
04.2011 - 01.2012
Similar Profiles
Ariane SchiavettiAriane Schiavetti
Analista De Customer Service at CitibankAnalista De Customer Service at Citibank
Bing ZuoBing Zuo
Universal Banker at CitibankUniversal Banker at Citibank
Sravani USravani U
Salesforce Developer at CitibankSalesforce Developer at Citibank