Divya Singh Chauhan
Data Analyst
Noida
Summary
Data Analyst with 7+ years of IT experience, including 4 years in data analytics. Adept at using SQL, Power BI, DBT modeling, and GCP BigQuery to derive actionable insights and drive business growth. Strong team leader with proven problem-solving skills, seeking a challenging analyst role that fosters both professional development and meaningful impact.
Overview
9
9
years of professional experience
5
5
years of post-secondary education
2
2
Certifications
Work History
Data Analyst
Atidiv
Noida
3 2023 - Current
- Fetching the data from GCP Big Query and Developing and maintaining data models using DBT (Data Build Tool) to make data more efficient to use
- Implementing version control using GitHub, enabling seamless collaboration and efficient tracking of code changes
- Documenting the process that is implemented to models
- Created Lifetime Value (LTV) dashboard & Net Promoter Score (NPS) dashboard in Power BI and delivered it to client on time
- Proficiently used SQL to extract and manipulate data from various databases, optimizing queries for performance and efficiency
- Collaborated with cross-functional teams to define data requirements and ensure data integrity throughout ETL process.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Utilized data visualization tools to effectively communicate business insights.
Data Analyst
Tata Consultancy Services
Bangalore
2019.04 - 2022.08
- Accurately identifying, extracting, and analyzing large volumes of data
- Extracting data from databases and cleansing, transforming, and integrating it
- Organized quarterly projection data gathered by senior analysts in orderly way for executive management
- Reported bi-monthly data analysis findings to upper management to use in making organizational decisions
- Participated in collecting, organizing, and interpreting data along with fellow colleagues
- Skilled understanding of data analysis to effectively interpret findings in way that makes sense to end users
- Used analysis and visualization tools such as SQL, Excel, Python Pandas to analyze data and draw accurate and reliable conclusions to provide insights to upper management
- Worked with team of 12 other analysts to accomplish delegated tasks by effectively communicating with team members
- Creative in putting together projections for variety of scenarios to assist departmental experts in making future decisions regarding organization’s growth
- Reorganized data into more easily navigable categories that benefited not only team data analysts but also everyone who had access to data, from data entry to upper management.
- Collaborated with IT to ensure data security measures were in place, safeguarding sensitive information.
Access Management Team Member / Backup Lead
Tata Consultancy Services
Gurgaon
2016.03 - 2019.03
- Managing profile according to their job role using several tools like: DDC, VISTA, EBusiness, SSS, CDM online
- Creation of employee’s profile using SPS tool / Create dash Ids
- Manage all the data regarding the users & Sites all over the world
- Daily / weekly/ Monthly reporting is done using Advance Excel
- Reported bi-monthly data analysis findings to upper management to use in making organizational decisions
- Handle escalations and issues on daily basis
- Monitor team performance and report it to upper management.
Education
Master of Computer Applications - MCA - Computer Science
APJ Abdul Kalam Technological University
Dr. Virendra Swarup Institute Of Computer Studies 2014.08 - 2017.04
Bachelor's degree - Computer Science
Chhatrapati Shahu Ji Maharaj University
Dayanand Girls College, Kanpur 2011.08 - 2014.04
Skills
SQL
Transact-SQL (T-SQL)
DBT (Data Build Tool)
Microsoft Excel
Microsoft Power BI
Data Visualization and Presentations
Data Modeling
Data Validation
Data Cleaning
Google BigQuery
Microsoft Visual Studio Code
Github
Data Analysis
Python (Programming Language)
Tableau
Certification
dbt Fundamentals
Roles And Responsibilities
- Experience in selecting, cleaning, and transform data for analysis and visualization.
- Experience in data modelling using DBT (Data Build Tool) and publishing those models into cloud database.
- Experience in git & GitHub
- Experience in managing BigQuery Datawarehouse
- Experienced in using underlying tooling for data extraction (SQL), transformation & analytics (DBT, Python) and visualization (excel, google sheet and Power BI).
- Experience in Power BI, loading data into it and creating reports using the data.
- Good analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Having experience in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts.
- Good Knowledge in programming language in Python and cleared the Microsoft certification.
- Motivated, teamwork-oriented, and responsible Data Analyst with significant experience in increasing comprehension of reports and presentations by the average professional.
Awards
- Service & Commitment Award - Tata Consultancy Services (Mar 2019)
- Service & Commitment Award - Tata Consultancy Services (Mar 2021)
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Timeline
Data Analyst
Tata Consultancy Services
2019.04 - 2022.08
Access Management Team Member / Backup Lead
Tata Consultancy Services
2016.03 - 2019.03
Master of Computer Applications - MCA - Computer Science
APJ Abdul Kalam Technological University
2014.08 - 2017.04
Bachelor's degree - Computer Science
Chhatrapati Shahu Ji Maharaj University
2011.08 - 2014.04
Data Analyst
Atidiv
3 2023 - Current
dbt Fundamentals
Introduction to Programming Using Python - Microsoft 98-381 - Microsoft
Similar Profiles
Apoorva ChavanApoorva Chavan
Business Analyst at AtidivBusiness Analyst at Atidiv
Manju KambleManju Kamble
Sr. HRBP (HR Ops) at Atidiv India Pvt LtdSr. HRBP (HR Ops) at Atidiv India Pvt Ltd
Vinay SalveVinay Salve
Online Business Analyst at Atidiv India Pvt LtdOnline Business Analyst at Atidiv India Pvt Ltd