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.• Analyze, and document business and functional requirements using with SOA & XML.• Analyst knowledgeable in using HL7.• Worked with the data mapping team for ICD9 to ICD10 code mappings of the diagnosis andprocedure codes.• Populate MDM configuration tables through Management Agent & console process.• Deep level SQL query in analyzing and validating SSIS ETL database data warehouse processes.• Created Teradata Tables, Views, and Stored Procedures for loading the data from Oracle to DW.• Attended requirements review meetings with business analysts, project managers and developers.• Validating the EDI 837 claim billing (professional, institutional, and dental claims) & 835 (remittance advice or payment) claims adjudications.• Documented, tabulated, and reviewed methods of valuation in effect, using SQL (to continue working on prototype developed by self).• Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.• Wrote Data migration plans.

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.• Identification of Data Domains for MDM such as Patient, Organization and Physician etc.• Designed and developed Sub-reports, Drill-down reports, Matrix, and Summary reports in SSRS.• Involved in generation and execution of SQL queries.• Produced performance reports using MS Excel queries, SQL, and MS Access• Created system DBA, Stored procedures, triggers, queries.• Designed new database tables to meet business information needs.• Created MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and Architect.• Configured the Data mapping between Oracle and SQL Server 2005.• Created SAS programs that are used for data validation, statistical report generation and program validation and automated the Edit Check programs using Macros.• Identify customer marketing opportunities by applying data mining models and writing advancedT-SQL stored procedures and queries.• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.• Used SQL to test various reports and ETL load jobs in development, QA, and production environments.

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.• Involved in defining the source to target ETL data mappings, business rules and data definitions.• Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.• Used Query Analyzer, Execution Plan to optimize SQL Queries.• Attended status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project is Data Mapping.• Involved in defining the source to target ETL data mappings, business rules and data definitions.• Performed extensive requirement analysis including data analysis and gap analysis.• Worked on project life cycle and SDLC methodologies including Waterfall and Agile.• Helped in troubleshooting the designed jobs using the DataStage Debugger.

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.• Supported technical teams for development and execution of supplemental analytical tools and methods. Conducted independent statistical analysis, descriptive analysis, hypothesis testing and logistic regression.• Assisted in development of data formatting and cleaning criteria from various data sources.• Generated database reports, presentation, and documentation of analytical methods.• Performed ad hoc analysis of data sources for all external and internal customers.