Senior Data Warehouse & BI Engineer

DHILIP RAMESH

Senior Data Engineer Data Warehouse Engineer Analytics Engineer

Austin, TX • 704-***-**** • ************.**@*****.*** • LinkedIn • Tableau • Github PROFESSIONAL SUMMARY

Senior Data/Analytics Engineer with 10+ years of experience, including deep expertise in data pipelines, ETL, data warehousing, and analytics. Expert in dimensional modeling, SCD strategies, and enterprise data warehousing, with a strong foundation in building governed, reliable reporting solutions alongside quality engineering teams. Proven track record partnering with stakeholders to align analytics strategy with business goals and delivering AI-powered automation that accelerates reporting and decision-making workflows.

CORE COMPETENCIES

• Cloud & Data Platforms: Oracle OCI, Snowflake, AWS Redshift, Databricks, AWS Glue, Apache Spark, Terraform

• BI & Visualization: Oracle Analytics Cloud (OAC), Tableau, AWS QuickSight, Power BI, OBIEE, SAP BI

• AI & Automation: Claude API integration, LLM-powered tooling, automated schema introspection, script generation

• Data Modeling: Dimensional modeling, SCD, data quality

• Databases & ETL: Oracle, MS SQL Server, AWS DynamoDB, Informatica, SAP BODS, Kafka, dbt

• Programming: Python (NumPy, Pandas), PL/SQL, shell scripting PROFESSIONAL EXPERIENCE

Senior Software Engineer Oracle Cloud Infrastructure (OCI) Austin, TX June 2024 – Present Member of the OCI Data Warehouse engineering team, responsible for database performance, pipeline automation, and deployment of the data warehousing product across Oracle realms. Helps partners ingest data from cloud to the presentation layer for reporting, troubleshooting query performance and improving report performance across large-scale cloud infrastructure.

• Led the end-to-end migration effort moving ~25TB of production data off the primary router database to target databases, freeing router space for uninterrupted, performance-safe partner access via ProxySQL with zero data loss. Directed an AI-powered POC using the Claude API to introspect schemas and auto-generate migration scripts, one month ahead of schedule.

• Resolved production bottlenecks for Alloy customers and OCI critical partners by diagnosing slow ingestion pipelines and SQL IDs, tuning each with targeted indexes or query hints. Built an internal MCP server skill surfacing query metadata for on-call, plus an OAC dashboard tracking SQL ID performance and throughput across the fleet.

• Built an OAC dashboard suite aggregating DB space and temp usage from router and target databases into a single view of per partner consumption, MoM trends, and breach alerts, catching space issues early instead of after partner ingestion broke, with an isolation layer so each partner sees only their own data.

• Led the design and rollout of a scheduled automation framework validating database patches end to end across core Data Warehouse functionality, including transforms, data loads, and user management, cutting manual patch validation from 2 hours to 10 minutes per cycle and giving the team a reliable regression gate.

• Served as Security Champion for the organization, coordinating across 3 teams and 6 security engineers on critical remediation work spanning Anchore, NessusDB, and other scan sources, reducing security vulnerabilities by 75% during the cycle. Senior Data Engineer Amazon New York, NY 2021 – 2024 Led BI and analytics engineering for Amazon Advertising, designing data pipelines and reporting infrastructure including dimensional models and SCD backed data marts serving business critical KPIs to executive stakeholders using AWS Cloud technologies.

• Led technical evaluation and proof of value for Amazon Attribution, building KPIs comparing seller revenue, page views, and add to cart activity before and after ad placement, plus flywheel impact research demonstrating 4x performance over external placements. Presented findings to VP level stakeholders, driving a 25% YoY increase in advertiser spend.

• Designed a self-service metrics platform standardizing advertising KPIs through scheduled ETL pipelines and AWS QuickSight dashboards and email digests, eliminating 2 hours of weekly manual reporting, establishing consistent metric definitions across teams, and automating Weekly, Quarterly, and Monthly Business reporting.

• Built a data governance framework using PySpark to structure and expose YTD click traffic from DynamoDB, enabling Marketing to self serve queries and driving a 40% YoY increase in advertiser acquisition. Reduced MoM help tickets by 15% with a query framework spanning clicks, page views, add to carts, and active brands. Senior Data Warehouse Engineer The MathWorks Inc. Boston, MA 2016 – 2021 Owned data modeling, ETL architecture, and BI platform for the Business Applications organization. Designed data warehouse dimensional models with SCD strategies across data marts to accurately track historical changes in customer, software licensing, and product data.

• Built the Data Warehouse Quality Engineering function from the ground up, partnering with the Director of Business Applications to structure hiring budget and define role requirements with HR and the Data Warehouse manager. Sourced, interviewed, and hired 3 engineers, growing the team from 0 to 4.

• Coached and mentored each engineer into ownership of a dedicated business domain, building validation frameworks and automation around migration testing and report testing for their area. Reduced defects by 85% following the handoff, and helped promote engineers to Senior QE.

• Built the Customer Quality Metrics (CQM) reporting layer in Power BI, using DAX calculated measures to integrate JIRA metadata and surface open bugs, hotfix cadences, and ticket trends, enabling leadership to make data driven release decisions.

• Re-architected ETL flows with restart capability, column store indexing, and cached lookups, reducing pipeline runtime from 6.5 to 4.5 hours. Developed the MATLAB UX data mart, boosting toolbox revenue and cutting support tickets by 30%. Applications Developer II America Fujikura Ltd. Duncan, SC 2015 – 2016 Delivered ETL pipelines and BI reporting for manufacturing and logistics, focused on SQL optimization, data modeling, and analytics enablement for business stakeholders.

• Designed a multi user development environment for parallel data warehouse development in Oracle Data Integrator, shortening the development lifecycle by 4 hours per month.

• Built a manufacturing performance reporting layer from hardware logs enabling YoY process improvements of 25%, and developed Informatica monitoring dashboards in OBIEE to visualize ETL job performance across time and dataflow hierarchies.

• Established enablement programs including workshops and SharePoint training pages for business analysts to self author SQL reports, reducing BI help tickets by 50% MoM.

Software Engineer, BI Mahindra Satyam Hyderabad, India 2011 – 2013 Acted as lead engineer to improve ETL performance, migrate client data across databases, and train teams on market leading BI, ETL, and reporting tools.

• Built interactive dashboards using OBIEE and automated delivery via PL/SQL Agents to executive inboxes. Migrated Oracle telecom data to Teradata using Informatica pipelines, improving storage efficiency and data processing for clients.

• Automated HTML styled reporting using PL/SQL procedures and delivered SQL based KPIs; drove code review sessions covering PL/SQL, ETL, database, and data warehousing practices. EDUCATION

• Master of Science (MS), Information Technology — University of North Carolina, Charlotte

• Bachelor of Engineering (BE), Computer Science and Engineering — Anna University, India PROFESSIONAL DEVELOPMENT

• Python (PyCharm, Jupyter, NumPy, Pandas) for data analysis and scripting

• Trained in designing Apache Spark big data pipelines and conducting data cleansing

• Certified in Snowflake Data Warehousing (view credential)

• Certified Scrum Master (view credential)

Contact this candidate