Summary
Overview
Work History
Education
Skills
Accomplishments
References
Timeline
Generic

Meena Moorthy

San Jose,CA

Summary

Data and Analytics Engineer with a proven track record, enhancing data operations, pipelines, reports and performance optimization. Expert in Snowflake and Python, with a flair for mentoring and cross-functional collaboration. Achieved significant ETL development advancements, demonstrating a commitment to best practices and technical excellence.

Overview

17
17
years of professional experience

Work History

Business Intelligence Solutions Developer

Pure Storage
San Jose, CA
09.2023 - Current
  • Part of the integrated operations team, which provides data related to sales.
  • Optimized existing database queries for better performance.
  • Design, develop, test, deploy, and support pipelines and reports.
  • Pipelines are developed using Snowflake, Python, and PySpark.
  • Created centralized, easily maintainable ETL code to pull data from various databases, like Snowflake and Postgres.
  • Implemented data quality metrics to implement alerting and anomaly detection as necessary.
  • I wrote pipelines to extract data in almost real time from upstream using PySpark.
  • Review, approve, and deploy Snowflake and Python code submitted by the team.
  • Mentoring fellow engineers on best organization and database practices
  • Involved in monthly and quarterly close support activities.
  • Development languages/tools used: Snowflake, Snaplogic, Tableau, Python, and Pyspark.

Lead Data/Analytics Engineer

Meta @Alphanet Inc LLC
Palo Alto, CA
03.2020 - 09.2023
  • Part of the accounting and tax team.
  • Involved in designing pipelines to extract and load data from different data sources.
  • Design, develop, test, deploy, and support pipelines and reports.
  • Pipelines are developed using Python.
  • Source/destination databases include Oracle, Hive, Presto, Spark, and MySQL.
  • Create reports in Tableau or Incorta, as per business requirements.
  • Handle complex application and data issues, performing root cause analysis, and removal of technical bottlenecks to resolve operational and performance issues.
  • Mentoring fellow engineers on best organization and database practices.
  • Develop audits for data quality at scale, implementing alerting and anomaly detection as necessary.
  • Involved in monthly and quarterly close support activities.
  • Development tools used: SQL Developer, VS Code, Tableau, and Incorta.

Data Engineer

Zuora @ Akshaya Inc
San Jose, CA
11.2018 - 02.2020
  • Part of the integration team between subscription and revenue.
  • Involved in all extract, transform, and loading implementations.
  • Involved in the creation and updates of several SQL packages and procedures, which are used to manipulate and transform the data according to downstream standards.
  • Created supporting documentation of business requirements, functional flow diagrams, and specifications to facilitate the maintenance of programming projects.
  • Create data pipelines using Python to integrate data between upstream and downstream.
  • Attend calls with the product manager and offshore team on a daily basis for requirement clarifications and delivery issues.
  • Support JIRA tickets raised by multiple customers.
  • Development tools used: Oracle 12c/11g, SQL Developer, PyCharm, and Postman.

Technology Analyst

Apple @ Infosys
Sunnyvale, CA
04.2016 - 10.2018
  • Built complex dashboards in Incorta for Apple's recruitment data.
  • Created filters on reports to provide data security.
  • Performed root cause analysis on failures, and resolved performance tuning-related issues.
  • Provided requirements to developers to write PySpark MVIEWS when Incorta could not support the report requirements.
  • Coded services to fetch values from the database and publish to a Kafka topic.
  • Created Splunk alerts to raise incidents in case of failure.
  • Wrote UNIX shell scripts for performing development and DBA activities.
  • Developed installation scripts for all the deliverables.
  • Documentation of projects for Functional Requirement Specification (FRS), Use Case Specification, ER Diagram, Test Plan, and Test Script & Test Cases.
  • Development tools used: MongoDB Atlas, Kafka, SQL Developer, Eclipse, GitHub, Autosys, Incorta.

Technology Analyst

Apple @ Infosys
07.2008 - 03.2016
  • Involved in database modeling.
  • Involved in creating partitioned tables and indexes for improved performance, efficiency, and to make the database faster and easier to maintain.
  • I wrote a Unix script to monitor inactive DB sessions, create incidents, and mail the group.
  • Extensively used the advanced features of PL/SQL, like records, tables, object types, and dynamic SQL.
  • Created Functional Design Document, Technical Design Document, and Test Case Document.
  • Worked with the QA/support team to fix bugs in the system; analyze, fix, unit test, run batch processes, and deployment.
  • Experience in performance tuning, explain plan, Tkprof, SQL Loader, DBMS_SCHEDULER, UTL_FILE, triggers, indexes, and import and export utilities.
  • Troubleshot production problems and worked effectively with other team members to identify and address issues.
  • Provide warranty support post-release, and transition the same to the support team.
  • Development tools used: SQL Developer, Autosys, Visual Paradigm, Eclipse, NetBeans, HP Quality Center, Subversion, Git, UNIX.

Education

B.E. - Electronics and Communications

Anna University

Skills

  • Snowflake
  • Python
  • Tableau
  • Presto
  • GIT
  • Airflow
  • Hive
  • MongoDB
  • MySQL
  • Spark SQL
  • Oracle
  • UNIX
  • Autosys
  • Incorta
  • JIRA
  • Performance optimization
  • Best practices implementation
  • Code review and refactoring
  • SQL expert
  • Cross-functional collaboration
  • Technical design documentation
  • Data warehousing
  • ETL development

Accomplishments

  • Proactively pursue expertise in data engineering, analysis, and business intelligence technologies to enhance problem-solving capabilities.
  • Established and enforced industry-standard coding practices for Pure Storage sales datasets and dashboards, ensuring maintainability and scalability.
  • Optimized Meta's tax pipeline, reducing runtime from 22 hours to 2 hours by implementing chunked processing, partition optimization, and improved query standards.
  • Contributed to Apple’s anti-hack WAR team by developing Unix scripts to prevent bulk orders from malicious IPs, enhancing system security.

References

References available upon request.

Timeline

Business Intelligence Solutions Developer

Pure Storage
09.2023 - Current

Lead Data/Analytics Engineer

Meta @Alphanet Inc LLC
03.2020 - 09.2023

Data Engineer

Zuora @ Akshaya Inc
11.2018 - 02.2020

Technology Analyst

Apple @ Infosys
04.2016 - 10.2018

Technology Analyst

Apple @ Infosys
07.2008 - 03.2016

B.E. - Electronics and Communications

Anna University

Similar Profiles

CREATE PROFILE
Meena Moorthy