Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic
ABHAY SINGH CHAUHAN

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

undefined

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
ABHAY SINGH CHAUHANData Analyst