Deepa Kardekar Email & Phone Number

Chapel Hill, Nc, Us

Dublin, Ohio, United States

• Claims Management Innovation: Designed and implemented advanced solutions for claim management systems, optimizing Medicaid and Medicare data accuracy and reducing discrepancies by 25%.• Modernizing Data Infrastructure: Led the seamless migration of legacy mainframe data and reporting feeds to Hadoop, resulting in a 30% improvement in data processing speed and system reliability.• Documentation Excellence: Authored comprehensive Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) to facilitate clarity, ensure alignment across teams, and streamline the project lifecycle.• Advanced Data Analytics: Conducted complex SQL queries for data mapping, analytics, and ad-hoc reporting, enhancing the efficiency and accuracy of enterprise data warehouses.• Cross-Functional Collaboration: Partnered with regulatory reporting teams to design and execute automated solutions for compliance requirements, including CCAR (FR-Y 9, FR-Y 14Q, PPNR) reporting.• Healthcare Compliance Expertise: Validated HIPAA EDI transactions (837, 835, 834, 270/271, 276/277) to ensure full compliance with regulatory standards, strengthening data integrity across systems.• Data Governance Leadership: Developed data lineage frameworks and dependency analysis to remediate root causes and ensure robust traceability for critical data processes.• Technology Integration: Enhanced visualization and reporting by integrating Hadoop with Tableau and Power BI, delivering actionable insights to business stakeholders.• Agile Project Management: Played a pivotal role in Agile Scrum ceremonies, including sprint planning, backlog grooming, and retrospectives, to accelerate project delivery while maintaining quality standards.• Team Enablement: Mentored development and QA teams, providing functional support and managing change processes to align project goals with business objectives.

San Francisco Bay Area

• Requirements Documentation: Developed detailed (BRD) and (FRD) through collaboration with business units, program owners, and technology managers to identify and address operational challenges effectively.• Claims Management Expertise: Oversaw claims processes for Medicaid and Medicare services, ensuring adherence to CMS regulations, HL7 standards, HIPAA, and Health Assessment Systems.• Regulatory Compliance & Oversight: Ensured data systems complied with GCP, FDA regulations, and company SOPs while managing validation for GMP, GLP, and GCP systems.• Advanced Data Analysis: Conducted data analysis to support risk assessments, fraud detection, and decision-making, leveraging complex SQL queries and NoSQL schema design for MariaDB and MongoDB.• Regulatory Reporting: Managed CCAR and OCC reporting, ensuring accuracy in regulatory submissions and resolving data discrepancies to meet Federal Reserve and OCC standards.• Hadoop Data Management: Documented technical specifications, data flows, and models within Hadoop environments, building scalable distributed solutions while maintaining regulatory compliance.• System Integration: Coordinated EMR system integration with HIE networks, developing implementation guidelines and ensuring seamless clinical application deployment.• ETL Processes: Designed ETL pipelines for extracting data from MongoDB, transforming it into analytical datasets for reporting and decision-making.• Testing & Quality Assurance: Collaborated with QA teams to create test scenarios and test cases for integration, UAT, and API testing using SOAP UI.• Data Governance: Maintained data lineage, database specifications, and user access protocols in Collibra, ensuring effective classification and regulatory compliance.• Data Visualization & Reporting: Provided executives with actionable insights and analytics for decision support, using advanced reporting tools to optimize business strategies.

Houston, Texas, United States

Project Management: Defined requirements, managed budgets, and supported organizational restructuring.Healthcare Compliance: Documented HIPAA 4010/5010 requirements and tested ICD-9/ICD-10 claims with CPT4 codes.Use Cases & Reporting: Developed Use Case Models and created mutual fund performance reports for stakeholders.Data Warehousing: Managed data lineage and requirements for mortgage data warehouse programs.Process Optimization: Conducted gap analyses, optimized workflows, and facilitated JAD sessions.Agile Frameworks: Tracked functional requirements using Agile SDLC and RUP methodologies.Cloud Migration & BI Development: Led Salesforce Cloud transitions and built BI data marts for actionable insights.ETL & Data Modeling: Designed ETL processes, Logical Data Models, and utilized SQL for data manipulation.Collaboration & Training: Partnered with stakeholders and trained teams on tools like JIRA and Confluence.Business Process Management: Enhanced operational efficiency through process design, monitoring, and execution.Informatica & Data Quality: Supported Informatica IDQ implementation, ensuring accurate and consistent data.Stakeholder Engagement: Facilitated requirements planning and aligned project goals with business objectives.

Franklin, Tennessee, United States

• Ensured compliance with regulatory standards like GCP and HIPAA through audits and assessments of clinical trial protocols and data.• Supported the Pharmacy Benefit Management (PBM) Team by responding to urgent benefit-related inquiries and identifying issues.• Assisted in clinical trial budgeting, monitoring expenses, and identifying cost-saving opportunities while ensuring quality.• Developed training materials and conducted training sessions for laboratory staff on the LIMS system to ensure effective utilization.• Assisted in reviewing and resolving conflicts or inconsistencies in Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).• Captured and documented knowledge gained during Joint Application Development (JAD) sessions for future reference.• Created Use Case and Activity Diagrams using tools like MS Visio, as well as Agile and Waterfall models for process design.• Prepared and maintained documentation related to data mapping, data transformations, and data warehousing processes.• Extracted and queried data from relational databases using SQL for reporting, analysis, and d ecision-making purposes.•Fostered an Agile mindset within the organization, encouraging collaboration, adaptability, and continuous learning.• Created UML diagrams and business process models to analyze workflows, identify redundancies, and improve systems.• Facilitated communication and gathered feedback throughout the Software Development Life Cycle (SDLC), ensuring project alignment.• Managed comprehensive documentation in JIRA, including requirements, meeting notes, and progress reports.