Ritika Varshney

Product Manager

Bengaluru, Karnataka, India7 yrs 10 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in transforming data into actionable insights.
Proficient in developing automated ETL solutions.
Strong background in data visualization and reporting.

Stackforce AI infers this person is a Data Analyst with expertise in SaaS and Data Engineering.

Contact

Skills

Core Skills

Data AnalysisData WarehousingData EngineeringEtlData Validation

Other Skills

SSISSSASSSRSTSQLExcelPowerBIData ModellingInformaticaSQLTableauPythonDjangoTest AutomationTeradataOracle

About

Experienced Data Analyst with a demonstrated history of working in Data and Analytics fields for Mcafee and Dell. Passionate about working with large amount of data and to turn this data into information,information into insight and insight into business decisions. I also have keen interest in the field of data visualization and I'm fascinated by the power to compress complex data-sets into approachable and appealing graphics. Skilled in Python,SQL,Tableau,ETL (Informatica and SSIS),Microsoft Excel with good understanding of data modelling and data warehousing concepts.

Experience

7 yrs 10 mos

Total Experience

2 yrs 7 mos

Average Tenure

4 yrs 8 mos

Current Experience

Amazon

2 roles

Business Intelligence Engineer II

Oct 2024 – Present · 1 yr 8 mos

Business Intelligence Engineer

Sep 2021 – Sep 2024 · 3 yrs

Mcafee

Data Analyst

Jan 2021 – Sep 2021 · 8 mos · Bengaluru, Karnataka, India

▪ High level of Proficiency with database and Datawarehouse concepts including replication, staging, ETL, stored procedures, partitioning, change data capture, triggers, scheduling tools, cubes and DataMart.
▪ Strong computer literacy and experience in data manipulation and reporting tools with demonstrated knowledge of SSIS, SSAS, SSRS, TSQL, Excel and PowerBI.
▪ Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into Datawarehouse.
▪ Advanced personal computing skills and knowledge of MS Excel and creating presentations with MS PowerPoint.

ETLSSISSSASSSRSTSQLExcel+3

Dell

2 roles

Data Analyst

Jul 2018 – Jan 2021 · 2 yrs 6 mos · Bengaluru, Karnataka

▪ Experience in Data Modelling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
▪ 2+ years of industry experience in working with large sets of data, and design of ETL data pipelines using Informatica 9.x, and working with statistical packages.
▪ Hands-on experience in writing complex, highly optimized SQL queries across large datasets.
▪ Worked with leadership teams to extract, process and manage survey data for gaps and anomalies, to distribute business driven visual reports using Tableau and Python.
▪ As a part of Customer Experience Team, translated business rules and sampling rules to integrate, transform and classify source data into customer events.
▪ As a part of Continuous Improvement Project, investigated resistance and performance gaps across multiple business processes and implemented code changes to maturity and robustness.
▪ As a stretch project developed Self-Healing ETL Tool using Python and Django framework to automate the healing process for failing ETL flows. This reduced 30% of the manual support efforts.
▪ Developed a User interactive Test Automation tool with autogenerated test queries, to automate the ETL and Data validation process across multiple databases. Thus reducing >50% of the testing efforts.