Data Analytics Engineer

MONIKA SANGEM

515-***-**** ********@*******.*** www.linkedin.com/in/monika-sangem-9a0a28156

EDUCATION

Iowa State University, Ames, Iowa CGPA: 3.74/4

Master of Science in Information Systems with Business Analytics certification (STEM) August 2022 – December 2024 University College of Engineering, Osmania University, Telangana, India CGPA: 8.43/10 Bachelor of Engineering in Electrical and Electronics Engineering August 2015 - April 2019 TECHNICAL SKILLS

Data Analysis: Data Cleaning, Data Mining, Data Visualization, Database Management, Big Data Analytics, Data Modelling, Data integration, Data Migration, Data Warehousing, Dashboard development, KPI reporting, Statistical and Text Analysis. Cloud Platforms: Microsoft Azure (Data Factory, Databricks, Apache Spark, ADLS Gen2, Blob storage), AWS (Redshift, S3, Airflow), Oracle (OCI, FAW).

Visualization Tools: Power BI, Tableau, MS Excel, Lucid Chart. Programming Languages: SQL (Advanced), Python, R, SAS, SPSS, DAX. WORK EXPERIENCE

Data Engineer Intern at MidAmerican Energy Company May 2024 - present

• Designed and implemented snowflake schemas and dimension models to support financial data analytics projects and improving query performance by 30%.

• Collaborated with Business Analysts and Data Modelers to translate business requirements into scalable data solutions.

• Developed ETL/ELT processes and source-to-target mappings using Oracle Data Integrator in Oracle Cloud, improving data processing efficiency by 40%.

• Documented data pipeline migration processes across Development and QA, enhancing deployment efficiency and minimizing errors by almost half than the earlier numbers.

• Conducted research and identified a data recovery solution using OCI Undo Management, decreasing potential data loss recovery time from several hours to less than 15 minutes with a single timestamp parameter. Application Development Associate at Accenture Solutions Pvt. Ltd. September 2019 – October 2021

• Collaborated in a multidisciplinary team environment, contributing to project advancement and self-learning.

• Led two full-cycle Oracle ERP Procurement module implementations in Oracle EBS R12, streamlining rollouts, testing (SIT & UAT), and production deployments, reducing deployment time by 30%.

• Resolved end user issues and executed third-party application interfacing with Oracle EBS 11i version, improving system efficiency.

• Extracted and delivered custom data files to clients using Oracle SQL Developer, ensuring 100% accuracy in client reports.

• Automated account code entry for purchase orders, reducing related remedy tickets by 40% and earning user appreciation for swift resolution.

ACADEMIC PROJECTS

Yelp Customer Reviews - Big Data Analytics August 2023

- Developed ETL pipelines in Azure Data Factory for initial data cleaning and prepping, storing files in Blob storage, performed transformation and sent the prepared data to ADLS Gen2.

- Visualized insights in Power BI, enhancing business-decision making.

- Performed sentiment analysis using R, identifying key food trends and restaurant shortcomings. Iowa Liquor sales dashboard - POWER BI August 2023

- Conducted exploratory data analysis to identify the trend of liquor consumption in Iowa vs nationwide.

- Derived data-driven insights into sales performance by store type, optimizing sales strategies. AWS Redshift – Data warehousing August 2023

- Built data pipelines using Apache Airflow to ingest data from Amazon S3 to Redshift, streamlining data operations.

Contact this candidate