Urvashi Jain

DevOps Engineer

New Delhi, Delhi, India7 yrs 11 mos experience

Key Highlights

8 years of experience in Data Analytics across multiple domains
Expert in ETL and Data Engineering techniques
Proven track record in data visualization and business intelligence

Stackforce AI infers this person is a Data Engineering expert with a strong focus on E-commerce and Analytics.

Contact

Skills

Core Skills

Data EngineeringEtlBusiness IntelligenceData VisualizationData AnalyticsDatabase Management

Other Skills

SnowflakeAmazon RedshiftAWS GluePythonSQLData AnalysisPL/SQLAmazon S3Amazon QuickSightAWS Data PipelineSAS (Programming Language)Microsoft Power BIMicrosoft SQL ServerDatabase Management System (DBMS)SQL Server

About

A professional with 8 years of Data Analytics experience across E-commerce, Insurance, IP & Telecom domain, continuously delivering projects which require extensive application of ETL, Data Engineering, Data Visualization, Data Modeling and Data warehousing techniques.

Experience

7 yrs 11 mos

Total Experience

2 yrs

Average Tenure

1 yr 9 mos

Current Experience

R systems

Lead Data Engineer

Aug 2024 – Present · 1 yr 9 mos · Noida, Uttar Pradesh, India · On-site

● Data Migration & Validation: Executed large-scale data migration from Amazon Redshift to Snowflake using
AWS Glue (Python) for data extraction and staging in S3, followed by loading into Snowflake. Developed
JavaScript-based stored procedures and SQL validation frameworks to perform reconciliation and ensure data
accuracy.
● Optimizing & Maintaining continuity of Data: Developed and optimized data processing scripts using
Python and SQL for handling large-scale datasets (Parquet/CSV), enabling selective column extraction, schema
mapping, and efficient transformations for downstream ETL pipelines ensuring data is processed in real time
or batch jobs as required.

SnowflakeAmazon RedshiftAWS GluePythonSQLData Engineering+1

Amazon

Business Intelligence Engineer

Jul 2022 – Jul 2024 · 2 yrs · Bengaluru, Karnataka, India · On-site

● Building ETL Pipeline: Developed highly complex data processing jobs and AWS Data Pipeline by
consuming the data from Amazon S3 to Amazon Redshift. Did analysis of the data, created PostgreSQL queries
on Amazon Redshift. Partnered with our Data Engineering and Data Science teams to design, build, and
measure data models and metrics using data driven tools like DataCentral, AWS Glue, Amazon Redshift,
Amazon SageMaker.
● Data Visualization: Experience in translating business requirements into dashboards, reports using Amazon
QuickSight and building comprehensive metrics to track KPIs, automated reporting/process solutions and
demonstrate continuous improvement within these metrics.

Data AnalysisPL/SQLAmazon S3Amazon RedshiftAWS GlueAmazon QuickSight+2

Exl

Consultant II- Analytics

Jul 2021 – Jul 2022 · 1 yr · Gurugram, Haryana, India · On-site

● Reporting and Data Optimization (SAS & Power BI): Data cleanup, sanity checks and data manipulation
in SAS using standard procedures, functions and data steps. Design and development of Power BI visualization
solutions like dashboards, standard reports, drill down reports, drill through reports, charts to track KPIs.
● Exploratory Analysis and Dashboard Creation: New metrics were calculated as per the defined rules such
as claims count, avg. amount paid, claim duration, claims per policy. Well versed in data extraction from multiple
data sources like SQL server, CSV, Excel. Developed Power BI reports which helped to develop monitoring
plan and further strategies to reduce losses incurred.

SAS (Programming Language)Microsoft Power BIData AnalyticsData Visualization

Cpa global

Software Engineer

May 2018 – Jul 2021 · 3 yrs 2 mos · Noida, Uttar Pradesh, India · On-site

● Data Map Creation, Collection & Loading: Created DataMap template (based on Snowflake schema and
established links between Fact and Dimension Tables). Collected and converted trademarks, patent data from
Excel to CSV and through import/export wizard to flat files. Developed Macros to move images from excel
to folders with an identification path for SQL Server. Loaded data using Tomcat from SQL Server DB to
Product (Foundation IP).
● Data Modelling: Created relational Data Models (logical data models based on Snowflake Schema) to align
the structure with existing Data Maps, created linked server between SQL 2016 and SQL 2012 to migrate the
operational data. Scripting various SQL functionalities around Joins, Aggregations, String Functions, Stored
Procedures, Views, Indexes etc.

Microsoft SQL ServerDatabase Management System (DBMS)Data EngineeringDatabase Management