Data Analyst Engineer

Manasa Rao

Phone: 832-***-**** Email: **************@*****.*** LinkedIn: LinkedIn

Professional Summary

Senior Data Analyst and Data Engineer with 10+ years of experience supporting the oil and gas sector, specializing in data sourcing, transformation, cleansing, and quality assurance. Experienced in managing Agile workflows through Jira and ServiceNow, with a proven track record of delivering high-impact solutions on time. Proven expertise in leveraging PySpark, AWS, and Databricks to optimize data workflows and enhance decision-making. Skilled in implementing scalable data solutions that improve reporting efficiency and maintain high data quality standards.

Skills

• Databricks – Data Engineering

• Lower 48 Data – Upstream Oil & Gas Datasets

• Data Quality & Governance – Anomaly detection, validation, data profiling

• Data Analysis & Visualization – Excel (advanced), Power BI, stakeholder collaboration

• SQL & Spark SQL – Querying & analyzing data

• AWS – Data Lake (AWS S3)

• Data Transformation – PySpark, SSIS

• IDE – PyCharm (Python), VS Code

Professional Experience

Wood Mackenzie, Houston, TX: Senior Data Analyst/Data Engineer Apr 2023 – Present

•Led the operationalization of an AWS-native, AI-powered, and highly scalable distributed platform for big data sourcing and ingestion. The platform supports the growing scope and complexity of Lower 48 data and enables the launch of new business products, contributing to over $40 million in annual revenue.

•Coordinated the end-to-end sourcing of upstream oil and gas data from over 100 structured and unstructured sources, ensuring timely delivery of 400+ million records per week to support critical analytics and reporting workflows.

•Streamlined workflows on Databricks using PySpark, resulting in a 40% reduction in processing time over 98% data accuracy, a 35% decrease in QA turnaround and significantly improved data reliability.

•Conducted statistical analysis on oil and gas well data to support the research team in production forecasting and decision making.

•Created and maintained technical documentation on Confluence to support cross- functional collaboration and knowledge sharing.

•Facilitated UI testing and delivered insights to enhance design consistency and user engagement.

•Worked with Medallion architecture to structure raw, refined, and curated data layers for robust data processing and reporting.

•Collaborated with cross-functional stakeholders to gather requirements, align on KPIs, and deliver data-driven insights that informed strategic decisions. Wood Mackenzie, Houston, TX: Data Analyst Jan 2016 – Mar 2023

•Supported migration from legacy systems and resolved critical issues during transitions.

• Debugged and optimized data environments, reducing pipeline failures by 40%.

• Performed root cause analysis on data anomalies and reporting discrepancies, resulting in a 25% reduction in recurring data issues.

• Maintained over 99% data integrity through rigorous quality validations tracked via Jira and ServiceNow.

• Created visual analytics to identify patterns, trends and inconsistencies.

• Built ETL pipelines using SSIS and Python, reducing processing time by 30%.

• Documented processes and workflows using SharePoint. TEKSystems, Houston, TX: Data Analyst Aug 2014 – Jan 2016

• Contributed to the development of North American Well Analysis Tool (NAWAT) to enhance data efficiency.

• Sourced and validated well data from 10+ U.S. states, improving dataset completeness by over 95%.

• Monitored and reported on well production trends across multiple states, enabling faster and data-driven decision-making by operations and management teams.

• Utilized SQL and advanced Excel to streamline data processing and enhance decision- making.

Kforce, Houston, TX: Analyst Jul 2014 – Aug 2014

• Collected and verified payroll data using SQL.

• Converted payroll data from PDF to Excel and identified bonus calculation errors.

• Used Excel and Access to manage and analyze payroll data efficiently. Education

• Masters in Business Information Technology

• Graduate in Business Management

Certifications

• AWS Certified Cloud Practitioner

Contact this candidate