Saraswati Sharma
New Delhi,DL
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst
Mercer DLF Phase
04.2023 - Current
- MS SQL: Developed and maintained complex SQL queries, scripts, and data pipelines to extract, transform, and load (ETL) data from various sources into a centralized data warehouse
- Dashboard Creation: Created interactive data visualizations and dashboards using tools like Tableau and Excel to facilitate data-driven decision making Statistical Model: Implemented statistical models and machine learning algorithms to predict customer behaviour, resulting in a 15% increase in customer retention rates Data Anomaly Detection and Resolution for Market Publishing : My role involves identifying anomalies in the data and correcting them to ensure that the information is presented in a progressive and accurate form for market publication
Business Analyst
American Express
09.2022 - 04.2023
- Data Import: Importing data from various sources like CSV, text files, databases, or APIs
- Cleaning Data: Using functions and features like Find & Replace, Text to Columns, and
- Remove Duplicates to clean and standardize data
- Data Transformation: Using formulas like TRIM, UPPER, LOWER, and CONCATENATE to manipulate and prepare data for analysis
- Data Validation: Ensuring the integrity of the data with drop-down lists, conditional formatting, and data validation rules
- Data Analysis Applying common formulas such as SUM, AVERAGE, VLOOKUP
- INDEX/MATCH, COUNTIF, and IF to extract insights
- Creating pivot tables to summarize large datasets, group data, and find trends or patterns.Highlighting key data points based on specific criteria, such as sales over a target or negative values
- QuantDesk: Python backend for a web application used by hedge fund managers for portfolio management.
Analyst
GlobalLogic ASF
01.2021 - 09.2022
- Gathered and integrated data to track and analyze quality metrics such defect rates, error frequencies, process cycle times and other KPI’s.
Education
Bachlor’s - English
University of Delhi
Higher Secondary Education -
Jawahar Navodaya Vidyalaya
2015
Skills
- Data visualization and presentations
- Data cleaning
- ETL processes
- SQL
- Tableau
- Problem-solving
- Data analysis
- Data validation
- Data formatting
- Analytical problem solving
- Gap analysis
Accomplishments
- Diploma in Data Science IIT Roorkee.:
- Programming Skills
- Languages: Python, OOPS, MS SQL, Power BI, MS Excel, Technologies: JIRA, AZURE
Certification
- [Diploma in Data Science], [IIT Roorkee] - [August 2023 - November 2024]
Timeline
Data Analyst
Mercer DLF Phase
04.2023 - Current
Business Analyst
American Express
09.2022 - 04.2023
Analyst
GlobalLogic ASF
01.2021 - 09.2022
- [Diploma in Data Science], [IIT Roorkee] - [August 2023 - November 2024]
Bachlor’s - English
University of Delhi
Higher Secondary Education -
Jawahar Navodaya Vidyalaya
Similar Profiles
Charles GreenCharles Green
Protection and Control Technician at Phase to PhaseProtection and Control Technician at Phase to Phase
Tracy BoozerTracy Boozer
Small Business Owner at Phase 2 Phase Construction LLCSmall Business Owner at Phase 2 Phase Construction LLC
Whitney DunawayWhitney Dunaway
Employee at DLF PickseedEmployee at DLF Pickseed