ABHAY SINGH CHAUHAN
Data Analyst
Lucknow
Summary
Business and Data Analyst with 5years of experience in analysis and testing of business requirements. Drives deployment of applications, business processes and system solutions to successful outcomes . Highly analytical and detailed with documented track record in full software development life cycle completion. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Excellent communication skills and a team player.
Overview
6
6
years of professional experience
3
3
years of post-secondary education
Work History
Data Analyst
Tata Consultancy and Services
Pune
05.2019 - Current
- Used data collection and analysis tools like PowerBi and created charts, maps, and diagrams to collect, interpret, and present data for wide range of applications and industries.
- Created 10+ dashboards and 150+ reports in PowerBi for internal teams based on financial and other organizational data as per the requirement of individual teams.
- Developed tables, views and materialized views using SQL.
- Experience with SQL Server Integration Services (SSIS)
- Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports using SQL Server Data Tools.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Validated warehouse data structure and accuracy.
- Prepared functional and technical documentation data for warehouses.
- Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse.
Junior Data Analyst
Tech Mahindra
Mumbai
06.2018 - 05.2019
- Utilized historical data sets and planned product changes to model and forecast business trends.
- Knowledge of statistical methods and data analysis software SPSS to provide quantitative and qualitative data analysis.
- Generated different reports with Jira for large organizational data.
- Report generation for total sales for the client, analyzing and recognizing products that were redundant and were not performing as expected.
- Collaborated with different teams to create a unified portal where employees can track their day to day production activities. They can start with modules mentioned and can also track status of completion of daily activities.
- Developed diagrams to describe and lay out logical operational steps
- Validated warehouse data structure and accuracy.
Technical Support Engineer
Intelenet Global Services
Mumbai
12.2016 - 06.2018
- Analyzed issues to identify troubleshooting methods needed for quick remediation.
- Report creation for number of issues being reported over the quarter and employee wise performance distribution.
- Helped to focus on key areas for customer dissatisfaction. Providing better solutions to the major impact areas.
- Played important part in increasing Net Promoter Score for the vertical by 15% by collaborating with internal teams and focusing on detractor reasons.
Education
Bachelor of Computer Applications -
National P.G. College, Lucknow University
Lucknoww 06.2012 - 06.2015
Skills
Python programming
Linux/UNIX
DAX
SSIS, SSDT, SSMS, SSISDB
MySQL, MongoDB, T-SQL
PowerBI
Report Generation , Dashboard Creation
CI/CD
ETL
Projects
1)Vodafone Customer Success Platform-
- Perform coding migration, database change management & data management through the various stages of the development life cycle
- Assist System Development Manager in developing queries, executing scripts, patches, reports, and monitoring
- Assist System Development Manager in development, setting up and managing automated backups
- Assist System Development Manager in Microsoft SQL Server management and database maintenance
- Assist System Development Manager in performance tuning and database optimization
- Identifying performance improvements to database procedures and data structures and working with Development teams to deliver code changes
- Provide accurate effort estimates of the work involved even when others will be performing the actual programming work.
2) Telstra - NBN Connections -
- Involved in designing,developing and deploying reports in MS SQL Server environment using SSRS-2008.
- Used SSRS to create parameterized reports, Drill Down and Drill through reports using SSRS.
- Used ETL(SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
- Prepared the data mapping for the migrated jobs using SSIS.
- Created databases and schema objects including tables, indexes and applied constraints , connected various applications to the database and written functions , stored procedures and triggers.
3) Barclays - BUK
- Implementation of MS SQL Server Management Studio to create stored procedures and triggers, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
- Created SSRS reports using Report Parameters, Multi-Valued Parameters.
- Created reports with Analysis Services Cube as the data source using SSRS.
Timeline
Data Analyst
Tata Consultancy and Services
05.2019 - Current
Junior Data Analyst
Tech Mahindra
06.2018 - 05.2019
Technical Support Engineer
Intelenet Global Services
12.2016 - 06.2018
Bachelor of Computer Applications -
National P.G. College, Lucknow University
06.2012 - 06.2015