Simrandeep Kaur Email & Phone Number

Dallas, TX

• Gathering and documenting the requirements in Requisite Pro are critical to the business missionand using those requirements to design application software using a Use Case approach.
• Created EDI (Electronic Data Interchange) documents for EDI maps to generate requirementdocuments and Project Charter, and logical design documents for EDI transactions and code sets.
• Working with clients to better understand their needs and present solutions using a structured SDLC(Software Development Lifecycle) approach.
• Implemented MDM process to take strategy to roadmap and design development activities.
• Functioned as claims analyst with responsibilities that included all aspects of claims adjudication.
• Experienced in data integration, metadata management, ETL, data modeling tool sets.

Newport Beach, CA

• Created Conceptual and Physical Data Models for the source system using Erwin.
• Experienced in full life cycle MDM development including data analysis, database design, data mapping and data load in batch.
• Involved in designing and developing Data Models.
• Created ETL test data and tested all ETL mapping rules to the functionality of the Informatica mapping and Ab Initio graphs.
• Worked on SQL Server migration from SQL 2005 to 2008 for all environments.
• Worked with a team of consultants responsible for developing on-demand Medicaid Management System (MMIS) reports.

Dallas, TX

• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for different applications.
• Created system DBA Stored procedures, triggers, queries.
• Participated on claims analyzing teams to check various nonparticipating fee schedules.
• Built business requirements into the Medicare Advantage (MA) requirements database and created the Project Requirements Document for functional areas.
• Participated in SSIS and SSRS requirement gathering and analysis.
• Developed dozens of complex SSIS and SSRS reports in SQL Server.

Bangalore, India

• Formulated procedures for data extraction, transformation, and integration of healthcare data.
• Conducted assessment to ensure data quality and completeness with validation techniques.
• Helped with quantitative data analysis with health care, biometric and survey data.
• Designed and developed continuous outcomes reporting for multiple intervention programs.
• Coordinated with technical teams for research and evaluation of healthcare and operational problems.
• Participated in critical review and revision of existing systems for updates and enhancements.