Mounika V
Senior Data Modeler • USA • V*******@gmail.com • 469****598 • drivetube.ai/•••••
Professional Summary
Senior Data Modeler with 7+ years of experience designing and delivering enterprise data models, dimensional schemas, and governance-aligned metadata for healthcare, pharmaceutical, manufacturing, supply chain, and compliance domains. Expert in conceptual, logical and physical modeling using ERwin / ER‑Studio and Kimball dimensional techniques to produce star/snowflake schemas, facts/dimensions, SCD handling, and conformed dimensions for EDW and lakehouse consumption. Strong hands-on experience with Snowflake, Databricks/Delta Lake, SQL Server, Azure Data Factory and AWS S3 to validate ETL/ELT flows and automate profiling with SQL and Python (Pandas). Proven owner of source-to-target mappings, business glossary integration via Collibra, lineage documentation and data-quality controls that improve reporting accuracy and reduce production defects across enterprise-scale environments.
Technical Skills
Programming Language: Python,SQL
Databases: Snowflake,DDL,Reconciliation,OLTP
Cloud Platforms: Amazon Web Services,S3
Testing & QA: Completeness Checks,Reverse Engineering
Data Engineering & Processing: Delta Lake
Data Warehousing: Dimensional Modeling
Data Analysis & Visualization: Pandas,Database Architecture,Relational Modeling,3NF,Normalization,Impact Analysis,Power BI,Tableau
Data Integration & ETL: ELT,Azure Data Factory,ETL,Collibra
Compliance & Governance: Data Governance,Data Catalog,Metadata Management,Data Lineage,HIPAA
Project Management & Collaboration: ER,Studio,Data Dictionaries,Jira
Validation & Qualification: Accuracy
Financial Systems & Data Tools: Source-to-Target Mapping,Model Versioning
Work Experience
Organon
USA
Senior Data Modeler
Sept 2024 – Present
Pharmaceutical company — supported compliance, audit, manufacturing, supply chain and operational reporting by designing enterprise and analytics data models.
Tech Stack: ER, Studio, Snowflake, SQL, Databricks, Delta Lake, Collibra
- Designed and maintained conceptual, logical, and physical data models for compliance, audit, manufacturing and supply-chain reporting using ERwin and ER/Studio to produce implementation-ready schemas.
- Analyzed source-system schemas and reporting requirements in Snowflake to define entities, attributes, primary/foreign keys, cardinality and domain rules for downstream ETL.
- Applied relational modeling and 3NF normalization for OLTP structures and designed Kimball-based star/snowflake schemas for analytical data marts.
- Developed detailed source-to-target mappings and transformation rules to enable Databricks Delta Lake ETL/ELT pipelines and downstream consumption.
- Performed advanced SQL profiling in Snowflake to identify nulls, duplicates and datatype mismatches, eliminating $400K+ in annual reporting discrepancies.
- Validated ETL outputs, performed schema impact analysis and applied Collibra-aligned governance and lineage practices, contributing to a 40% reduction in production defects and release leakage.
United Health Group (Optum)
Texas, USA
Data Modeler
Aug 2022 – Aug 2024
Health care and benefits organization — supported claims, member and provider analytics, data modernization and governance for enterprise reporting.
Tech Stack: SQL, Snowflake, Azure Data Factory, Python, SQL Server, AWS S3, Power BI, Tableau
- Modeled and validated 2M+ healthcare records from claims, member and provider domains in AWS S3 and SQL Server sources to strengthen enterprise analytical data quality.
- Developed conceptual, logical and physical models using ERwin to define entities, datatypes, keys and SCD requirements for care-quality and utilization reporting.
- Translated OLTP/source schemas into normalized 3NF relational models and analytics-ready dimensional structures for enterprise data marts.
- Designed Kimball-based star and snowflake schemas to support utilization, care quality and executive KPIs, improving reporting accuracy by 35%.
- Automated SQL and Python (Pandas) reconciliation and profiling checks for ADF-driven data pipelines on Snowflake, eliminating 20+ hours/week of manual validation.
- Documented end-to-end lineage and validated Azure Data Factory and SQL Server pipelines against mapping specifications to support zero-data-loss migration outcomes.
- Partnered with BI teams to align dimensional models with Power BI and Tableau reports to ensure KPI definitions and metrics matched source logic.
Accenture
India
Data Modeler
Jun 2018 – Jul 2021
Global consulting — delivered relational and dimensional models for operational and financial reporting for enterprise clients.
Tech Stack: ER, Studio, SQL, Python, Jira
- Designed and optimized relational schemas and database architecture for operational and financial reporting using ER/Studio and SQL Server.
- Analyzed source datasets to identify entities, candidate keys, relationships and business rules to inform ETL specifications.
- Developed logical-to-physical model documentation and generated implementation-ready DDL to accelerate schema deployments.
- Applied 3NF normalization for transactional systems and Kimball dimensional modeling to produce analytics-ready marts and conformed dimensions.
- Created source-to-target mapping specifications and data dictionaries to guide ETL developers and reduce schema-related defects.
- Automated recurring profiling and reconciliation using SQL and Python scripts and managed model versioning and reviews via Jira and Confluence.
Education
University of New Haven
Master of Science in Finance and Financial Analytics • USA • 2022
Powered by Drivetube · Create your own profile at drivetube.ai
Explore Drivetube
- Drivetube Profile — your free digital resume — at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept. Documentation.
- Free Job Board — verified openings crawled ATS-by-ATS from 100,000+ real company career pages across 35 ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed. Documentation.
- Job Hunt Program — managed job hunting, a one-time purchase from $199.99. JobScout matches verified roles to your real experience band, Blend AI writes a uniquely tailored resume and cover letter for every application, and the Autofill extension fills the form — or Let Us Apply submits it for you. Documentation.
- Resume Writing Services — human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile. Documentation.
- Community Membership — from $4.99/month (₹1,999/year in India). Unlocks the gated job-board filters — visa sponsorship, security clearance, workplace and application time — plus Job-Scout AI matching, Resume Report AI, Interview AI prep sheets, Recruiter Outreach AI sent from your own Gmail, Apply or Skip triage, a daily market feed and a $10,000+ library including 23 ATS-validated resume templates. Documentation.
- Drivetube Hire — for employers — hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do. Documentation.
Full product documentation — every product explained, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.
The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.