Open To Work
Moulika Yammani
Summary
Results-driven Business Intelligence and Data Engineering professional with over 12 years of experience in data visualization, analytics, integration, and ETL processes. Expertise in requirement gathering, system analysis, and application design, complemented by a solid understanding of the complete SDLC from technical and project management perspectives. Committed to delivering solutions that enhance customer satisfaction.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Senior Data and Analytics Engineer
Cigna
09.2023 - 12.2025
- Led Agile/Scrum teams delivering enterprise data warehousing and analytics solutions across Provider Payment, Vision, Dental, and Hearing Claims domains, improving delivery velocity by 20–30% through tighter sprint planning and cross‑team alignment.
- Designed and built scalable ETL/ELT pipelines using Databricks, Teradata, Python, AWS, Airflow, and Delta Lake, increasing data processing throughput by 40% and reducing pipeline failures by 25%.
- Migrated legacy Teradata workloads to AWS Redshift/Databricks, cutting compute costs by 30% and improving query performance by 2–5× depending on workload.
- Developed Delta tables, Databricks workflows, and automated ingestion pipelines for structured and semi‑structured sources, reducing manual ingestion effort by 80%.
- Implemented SQL‑based validation frameworks and automated data quality checks, improving data accuracy and reducing downstream defects by 35%.
- Created reusable data models and transformation frameworks that accelerated analytics delivery, reducing development time for new datasets by 50%.
- Integrated Airflow DAGs with Databricks to orchestrate end‑to‑end workflows, improving job reliability to 99%+ and enhancing monitoring visibility.
- Used Terraform for infrastructure‑as‑code, enabling consistent deployment of Databricks resources and reducing environment setup time from days to under 2 hours.
- Optimized ETL performance by tuning SQL and refining pipelines, reducing end‑to‑end processing time by 30–60% across large datasets.
- Built dashboards and validation visualizations that improved operational insight and reduced data investigation time by 40%.
- Ensured governance, lineage, and security compliance using Collibra, increasing metadata coverage to 95%+ across critical datasets.
- Partnered with cross‑functional teams to translate business requirements into scalable data solutions, enabling analytics teams to deliver insights 2× faster.
- Troubleshot production issues and resolved pipeline failures, reducing incident recurrence by 50% through root‑cause analysis and workflow redesign.
- Automated manual data processes with Python, saving 10–15 hours per week in operational workload.
- Developed RESTful APIs to expose curated datasets to downstream applications, reducing integration time by 60%.
- Performed exploratory analysis and built prototype models to validate transformations and uncover trends, accelerating data validation cycles by 30%.
- Documented pipelines, architecture, lineage, and test cases, improving onboarding efficiency and reducing knowledge‑transfer time by 50%.
Data and Analytics Engineer
Cigna
12.2018 - 08.2023
- Engineered and maintained large‑scale enterprise data pipelines supporting 100TB+ of analytical data, leveraging Teradata, Informatica/Talend, and shell‑based automation to improve data throughput by 20%.
- Translated business requirements into scalable data models, ingestion frameworks, and transformation logic for 20+ enterprise data engineering initiatives, reducing development time by 25%.
- Built and optimized high‑performance ETL workflows (Fastload, Multiload, TPT, SAS, Bash, Linux Shell) to support ingestion, cleansing, and transformation across Claims, Clinical, Revenue, Client, and Customer domains, improving SLA reliability from 92% to 99%.
- Led ingestion and transformation of Evernorth Behavioral Health (EBH) data into the Cigna Corporate Warehouse (CCW), enabling 5,000+ analysts and data consumers to access consistent, daily‑refreshed datasets.
- Designed and maintained Clinical Assessment and Lab Results datasets powering predictive analytics and generating 1,500+ automated client reports, eliminating 80% of manual compilation work.
- Built the COVID‑19 Patient Registry integrating 2M+ patient records and engineered the COVID‑19 Risk Model pipeline to supply Health Equity analytics with high‑quality demographic, admissions, and outcomes data.
- Implemented Teradata–Hadoop QueryGrid bi‑directional data movement, increasing cross‑platform query performance by 3× and reducing batch latency by 60%.
- Architected a pseudo‑production environment mirroring production workloads for 15+ delivery teams, reducing deployment‑related defects by 35% and accelerating release readiness.
- Supported production systems by diagnosing and resolving issues at the data, pipeline, and warehouse layers, reducing recurring incidents by 30% through root‑cause analysis and process improvement.
- Developed end‑to‑end ETL/ELT jobs using complex SQL, Informatica, and Talend transformations (Aggregator, Joiner, Lookup, Router, Normalizer, Stored Procedures), improving pipeline performance by 40%.
- Partnered with DBAs, data scientists, and analytics teams to ensure consistent data availability, improving self‑service adoption for 200+ downstream users and reducing data support tickets by 30%.
- Built high‑quality Tableau and Looker dashboards supporting operational and clinical analytics, improving time‑to‑insight for business users by 45%.
Data and Analytics Engineer
Cigna
09.2016 - 11.2018
- Partnered with business stakeholders to translate analytical requirements into technical specifications, improving requirement clarity and reducing rework by 25% across key data pipeline projects.
- Designed and developed scalable ETL pipelines using Teradata, Python, and SQL, enabling processing of 10M+ records daily and reducing ETL runtimes by 30–40% through optimized code and indexing strategies.
- Engineered and optimized big‑data workflows on Hadoop (Hive, Impala, Hue), improving query performance by up to 45% and reducing cluster compute cost by 20% through partitioning, bucketing, and resource tuning.
- Implemented ingestion, transformation, and export pipelines between HDFS, Kafka, AWS, and Oracle via IBIS, improving data delivery SLAs from T+2 days to T+12 hours for several mission‑critical datasets.
- Led the migration of all CPC (Cigna Private Cloud) workloads to CEP, automating IaaS provisioning and reducing infrastructure deployment time by 60%, while eliminating manual operational steps.
- Delivered full lifecycle development under Agile, contributing to multiple successful PI cycles and improving team velocity by 15% through better pipeline modularity and improved test coverage.
- Oversaw and executed 20+ production releases, authored detailed runbooks, and reduced post‑release incidents by 35% through improved validation and rollout procedures.
- Managed high‑visibility Evernorth Behavioral Health (EBH) data pipelines into the CCW warehouse, ensuring 99.9% data accuracy for Client, Customer, and Claims data used by enterprise analytics teams.
- Performed TDD/BDD testing, created test cases, and validated results, increasing automated test coverage to over 70% and reducing regression defects by 40%.
- Built automated CI/CD pipelines in Jenkins, cutting deployment time from hours to under 15 minutes and ensuring consistent QA checks across environments.
- Collaborated with the Information Protection team on ASR compliance, achieving 100% security audit clearance for data pipelines and meeting enterprise architecture standards.
- Supported cloud modernization by migrating large datasets from Hadoop to AWS and conducting a successful POC on Teradata Vantage Cloud, reducing compute cost projections by ~25% for targeted workloads.
- Monitored and optimized end‑to‑end data pipelines, improving data availability SLAs from 95% to 99.8% for analytics consumers and reducing daily job failures by 50%.
Senior Analyst
Harland Clarke
07.2012 - 07.2014
- Ensured incident routing was efficient, engaging appropriate resources to investigate and diagnose critical incidents.
- Coordinating and managing all Severity-1 and Severity-2 issues, taking overall responsibility for incident and service call.
- Aggressively drive conference calls with the end user, internal support teams and third-party vendors.
- Responded promptly to notifications of unplanned service interruptions from end users and internal teams.
- Delivered primary support for initial incident response, documents, categorize and prioritize incidents as they occur.
- Understand SLA requirements and works to ensure those requirements are met when possible.
- Provide timely feedback to higher management, both Internal and the end user on all incidents.
- Feedback includes but is not limited to incident descriptions, executive summaries, detailed timelines, action plans, workarounds and resolution of incidents.
- Provided detailed root cause analysis (RCA) documentation to problem management and participated in RCA meetings with customers to identify root causes of incidents and SLA infractions.
- Actively participate in the CAB meetings, represent changes that are of high priority/importance.
Junior Associate
Hewlett Packard
01.2010 - 06.2012
- Coordinating and managing all Severity-1 and Severity-2 issues.
- Managed and coordinated ticket and incident life cycle activities.
- Oversaw incident and service call management.
- Creating, Assigning and closuring of Incident, and service tickets.
- Followed up in real time with global support teams for timely incident resolution.
- Tracking and escalating of trouble tickets.
- Following up with the SLA guidelines.
- Prepared daily, weekly, and monthly incident trackers to monitor incident progress.
- Incident record preparation and handover to the Problem management team.
- Created tickets for new incidents to initiate resolution processes.
Education
Masters of Science -
Wichita State University
Bachelor of Engineering -
Vazir Sultan College of Engineering
AP, IndiaSkills
- ETL/ELT
- ETL pipeline design
- Databricks workflows
- Spark framework
- Data warehousing
- SQL programming
- SQL & databases / management
- Data integration
- Data governance
- Data management
- Hadoop/Hive
- AWS
- Informatica
- Teradata
- Data analytics
- Data analysis
- Data mining techniques
- Python
- Business Intelligence
- Business solutions development
- Product owner competencies
- Business analysis
- Requirements analysis
- Cross-functional collaboration
- Software development
- Application knowledge
- Insurance
- Health Care
- Banking
- IT
Languages
- Hindi
- Telugu
- English
Certification
- Databricks Certified Data Engineer Associate
- Databricks Certified Generative AI Engineer Associate
- AWS Certified Solutions Architect – Associate
- Azure Data Engineer – Associate
- SAFe 6 Product Owner/Product Manager
Skills
Databases, ETL Tools, Programming Skills, Big Data/Cloud, CICD Tools, Version Control, Scheduling Tools, Project Management, Business Intelligence, Data Analytics, Data Warehousing, ETL, Application Development
Personal Information
- Profile: Highly organized, Solutions-Oriented Business Intelligence/Data Warehouse/Data Analytics Professional with combined Industry Experience of 12+ years in Requirement gathering, system analysis, application design, facilitating cross-functional teams, development, testing, configuration management, client/user support services. Good understanding of complete SDLC life cycle from both technical and project management standpoint. Consistently strive to deliver on time with a strong commitment towards customer satisfaction.
- Title: Senior Consultant
Work Preference
Job Search Status
Open to workWork Type
Full TimeContract WorkLocation Preference
RemoteOn-SiteHybridSalary Range
$120000/yr - $200000/yrTimeline
Senior Data and Analytics Engineer
Cigna
09.2023 - 12.2025
Data and Analytics Engineer
Cigna
12.2018 - 08.2023
Data and Analytics Engineer
Cigna
09.2016 - 11.2018
Senior Analyst
Harland Clarke
07.2012 - 07.2014
Junior Associate
Hewlett Packard
01.2010 - 06.2012
Masters of Science -
Wichita State University
Bachelor of Engineering -
Vazir Sultan College of Engineering