Shikha Soni

Sep 2021 – Present (3.10 Years)

• Architected and delivered robust, scalable data pipelines on GCP and Snowflake, enabling high-performance data ingestion, transformation, and delivery for analytics and reporting.
• Modernized legacy data workflows by migrating to DBT and FDI frameworks, improving modularity, reusability, and reducing maintenance overhead.
• Enhanced data reliability by implementing end-to-end quality checks and anomaly detection using Monte Carlo, reducing downstream data issues.
• Optimized data infrastructure through smart partitioning, clustering, and schema design, significantly improving query performance and reducing cloud spend.
• Led technical debt remediation initiatives by decommissioning unused resources and streamlining data assets for improved system health.
• Ensured high system availability by proactively managing production pipelines, troubleshooting failures, and minimizing downtime across data platforms.
• Partnered with cross-functional teams to deliver clean, trusted, and business-aligned data solutions that directly supported key decision-making.
• Established and enforced engineering best practices, including CI/CD pipelines, detailed documentation, and secure deployment strategies.
• Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
• Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
• Championed the adoption of agile methodologies within the team, resulting in faster delivery times and increased collaboration among team members.
• Participated in strategic planning sessions with stakeholders to assess business needs related to data engineering initiatives.

Key Projects & Roles:

Jan 2014 – Oct 2021 (7.6 Years)

• Sainsbury’s Argos (BI / Data Warehousing):
  Developed and enhanced BI solutions, reports, and data infrastructure to support business insights.
  Created and executed test plans, worked closely with developers to resolve issues.
  Supported Informatica job testing on AWS and ensured timely, accurate report delivery.
• Axis Capital (Zurich Client) – SQL Developer:
  Solely managed a Contract Planning Tool for enhancement, maintenance, and production support.
  Performed predictive analysis and job monitoring for contract data flow.
  Mentored junior team members on tool usage and SQL development.
• Bank of Baroda Analytics – Big Data Analyst:
  Developed transformation mappings for data migration activities.
  Conducted quarterly data analysis for campaign tracking and generated large datasets for client analysis.
  Migrated data across environments and supported client data needs.
• Dell EMC (US Client) – PL/SQL Senior Analyst:
  Analyzed business requirements and developed Oracle PL/SQL solutions.
  Participated in user story reviews, deployment migrations, and test-phase support.
• EMC² – Field Services Support Analyst:
  Handled production support, defect resolution, and minor enhancements.
  Led knowledge transitions and trained offshore and onshore teams.
  Contributed to automation and process improvement initiatives.