Renuka Mairal

Assistant Manager – Data Engineer

KPMG India

Apr 2023 - Current (3 years 4 months)

• Involved in discussions with the leadership team for understanding the Business Objective and to set up the architecture and providing best-suited cloud solution by applying best practices of Data Engineering. • Built Cloud Native Data Warehouse(with Distributed Compute Principles) for the apps on GCP Cloud which helped Business to decommission on-prem Data warehouse and migrate fully onto Cloud resulting in Reduced cost, Fully-managed and solved storage constraints by Auto-scaling of Storage thus solving the technology challenges. • Designed, implemented and Orchestrated the data pipeline to process structured data by ingesting raw records from multiple sources/formats using PySpark and Apache Airflow. • Responsible for Migrating Par

Data Science Consultant

accenture

Jan 2023 - Apr 2023 (4 months)

• Developed and Presented a Financial Sales POC for a Multi-National Pharma company. • As part of the POC, Built Data Model and Data Warehouse using Customer's Financial data for a streamlined approach. • Tools used – DBT, GCS Buckets, PySpark, BigQuery & Tableau.

T

Data Analyst

Twilio India

Apr 2022 - Jan 2023 (10 months)

• Developed CI/CD pipelines so that each commit a developer makes will go through standard process of Software Life Cycle (SDLC) and gets tested well enough before it can make it to Production. • Educate developers on how to commit their work and make use of CI/CD pipelines that are in production using Bash Commands. • Extracted and Transformed Data from external sources like Xactly and ingested into Postgres SQL Server for the end reporting. • Identified and Encrypted the PII data fields for the Data Security purposes. • Used Heroku Advanced Scheduler for scheduling the SQL and Python jobs. • Developed Tableau Dashboards for the Sales Representatives for tracking their performance and compensation. • Transformed the data present in

Consultant

KPMG India

Apr 2021 - Mar 2022 (1 year)

• Used Advanced SQL to transform and create Data Marts to deliver insights and analysis from complex and large datasets and prepare reports in Tableau and Excel. • Built an alerting system using SQL & Python for financial stakeholders which notifies customers for uploading manual data on time to avoid process failure and errors on the Dashboard as part of the process improvement. • Experience in working with Financial data and building logic for KPIs/Metrics using SQL and developing business critical reports using Tableau for stakeholders from Finance department. • Experience in End-to-End delivery of project starting from Data requirements gathering to deploying the final solution to production and supporting the production issues, by

V

Senior Executive

Vodafone BI Solutions

Sep 2017 - Apr 2021 (3 years 8 months)

• Extracted, Analyzed and Interpreted BigQuery Usage Data across organization to identify pattern in usage of BigQuery users and identify anomalies which helped business to switch from on-demand pricing to flat-rate pricing. • Experience working in Columnar Storage and Row-Based Storage and applying best practices while working on both the type of storages for optimization. • Experience in Building Wireframes and Visualization Dashboards using Tableau and presenting the Product to the customers. • Implemented best practices of Data Warehousing - Star & Snowflake Schema and SCD Type 1 Models to build OLAP Analytical solutions, resulting in Data Consistency and improved Data Quality. • Responsible for Extracting, Cleansing, Transforming/

About

Detail

Timeline

Résumé