Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Aishwarya Mogali

Campbell

Summary

Data Engineer with extensive years experience, specializing in SQL and Python. Developed scalable data pipelines and dashboards that significantly improved workflow efficiency. Contributed to Meta’s small business initiatives, supporting millions of advertisers globally, while enhancing privacy review processes. Proficient in big data frameworks like Hadoop and Apache Spark, with strong skills in database management and data visualization using Tableau.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Data Engineer

Accenture (Client: Meta)
Mountain View
01.2022 - Current
  • Collaborated with privacy review team to ensure compliance with privacy standards and legal obligations for new products and services.
  • Developed and maintained core data sets measuring privacy review process across company, collaborating with data scientists on metrics and engineering for instrumentation strategies.
  • Created metrics and reporting dashboards to monitor privacy review performance, identify bottlenecks, and inform process improvements for enhanced workflow efficiency.
  • Engineered scalable data pipelines using complex SQL queries and Python for Facebook business campaigns.
  • Contributed to small business group team serving 200 million small businesses globally, supporting over 10 million active advertisers on Meta’s platforms.
  • Partnered with data scientists to align data infrastructure with strategic goals of small business group, enhancing advertiser experience and optimizing resource utilization.

Business Analyst in Data Modeling

Cisco
San Jose
04.2018 - 07.2020
  • Collected, cleansed, and analyzed structured and unstructured data for modeling purposes.
  • Developed dashboards and conducted ad-hoc analyses using SQL and Tableau.
  • Created and modified SQL queries on Toad and SAP HANA Studio to update dashboard data.
  • Designed A/B tests to evaluate bundling offer recommendations for sites.
  • Extracted and interpreted data to identify key metrics and KPIs, transforming raw data into actionable insights.
  • Utilized BI tools like Tableau and Business Objects to support sales and marketing in lead generation.
  • Employed Python libraries such as Pandas, NumPy, and SciPy for effective data manipulation and analysis.
  • Predicted sales for new products with an 87% accuracy rate using data mining techniques, reducing potential losses.

Database Developer/Administrator

ADP (Automatic Data Processing)
India
06.2013 - 06.2016
  • Leveraged Hadoop components, including HDFS, MapReduce, and Job Tracker, for data processing.
  • Transformed and analyzed data from diverse sources into HDFS using Hive, Pig, and Sqoop.
  • Created Hive tables and developed queries to meet business requirements for large datasets.
  • Generated reports through Hive queries and data ingestion with Apache Sqoop.
  • Developed User Defined Functions in Java and Python for PIG and HIVE queries.
  • Implemented Spark code using Scala and Spark-SQL/Streaming to enhance data processing speed.
  • Managed Payroll and Time Management services, designing databases in 10g and 11g RAC per client needs.

Education

Bachelor of Technology/Science - Information Technology

Jawaharlal Nehru Technological University (JNTU)
India
05.2013

Skills

  • Hadoop and HBase
  • MapReduce and Hive
  • Scala and Pig
  • Oozie and Sqoop
  • Java and Python
  • SQL databases
  • Data visualization tools
  • Data cleansing
  • Data pipeline development
  • SQL query optimization
  • Data visualization
  • Effective communication
  • Process improvement
  • Data modeling
  • NoSQL databases
  • Database administration
  • ETL processes
  • PL/SQL Programming
  • Python programming
  • Database management

Certification

  • Big Data and Hadoop Developer
  • Oracle Database 11g: Administration (OCA)
  • Oracle Database 11g: SQL Fundamentals I

Timeline

Data Engineer

Accenture (Client: Meta)
01.2022 - Current

Business Analyst in Data Modeling

Cisco
04.2018 - 07.2020

Database Developer/Administrator

ADP (Automatic Data Processing)
06.2013 - 06.2016

Bachelor of Technology/Science - Information Technology

Jawaharlal Nehru Technological University (JNTU)

Similar Profiles

CREATE PROFILE
Aishwarya Mogali