Tara AC

Experience

• 

  Westfield Insurance

  Oct 2008 - Nov 2010

  Database Developer

  • Designed and maintained real-time SQL data pipelines powering 15+ critical financial dashboards, reducing reporting latency by 80%. • Improved financial reporting speed by 25% through database schema optimization and use of indexed views. • Partnered with business and technical teams to ensure data accuracy and timely delivery of insights for high-stakes decision-making.

• 

  Credit Suisse

  Nov 2010 - Jun 2011

  Senior Data Analyst

  • Designed and maintained real-time SQL data pipelines powering 15+ critical financial dashboards, reducing reporting latency by 80%. • Improved financial reporting speed by 25% through database schema optimization and use of indexed views. • Partnered with business and technical teams to ensure data accuracy and timely delivery of insights for high-stakes decision-making.

• 

  Ernst & Young

  Jun 2011 - Jan 2013

  Senior ETL Developer

  • Enhanced performance of a 15TB+ enterprise data warehouse by 40% through optimized star schema design and strategic table partitioning. • Developed 50+ stored procedures, functions, and audit triggers, improving data integrity and reducing query execution time by 30%. • Streamlined ETL processes and reporting workflows, decreasing report cycle time by 20% and improving reliability. • Supported enterprise reporting needs with scalable solutions that ensured consistency and audit-readiness across departments. Show less

• 

  Federation of State Medical Boards

  Jan 2013 - May 2023

  Senior Data Engineer

  • Led the migration of a 15TB Oracle database to Snowflake MDM and a 10TB data warehouse to Azure, improving performance by 97% without disrupting operations. • Automated and optimized data workflows using Python, Informatica, and Azure Data Factory, reducing manual processing time by 40%. • Strengthened data reliability by implementing custom rules in Informatica PowerCenter, reducing errors by 15%. • Accelerated project delivery by 25% through Agile methodologies and improved collaboration across development and QA teams. • Mentored junior engineers on QA best practices, resulting in a 20% increase in process efficiency and data accuracy. Show less

• 

  CHRISTUS Health

  May 2023 - now

  Senior Data Engineer

  • Improved patient data retrieval by 60% by optimizing a 5TB data warehouse with columnar storage and partitioning. • Enhanced security through RBAC and encryption within ETL pipelines, reducing access risk and improving error handling. • Developed a Python/SQL-based data lineage framework, improving audit readiness and regulatory compliance. • Automated BI/ML testing and reporting flows, increasing accuracy and reducing manual effort. • Delivered high-impact dashboards and reports that elevated anomaly detection and data insights. Show less