TECHNICAL SKILLS:

Database Experience: Oracle, SQL Server, OFSAA

Languages: SQL, UNIX

Reporting and Data Systems Experience: Informatica Data Director, Informatica Metadata Management, Cognos, ESRI ArcGIS BA, Tableau, Power BI, Application Programming Interface (API)

Microsoft Office and Project Tools: Excel, Word, Project, Outlook, PowerPoint, Visio, Project, SharePoint, OneNote, Teams

Software Development Life Cycle (SDLC) Tools: JIRA, Confluence, Rally, Micro Focus Application Lifecycle Management (ALM), Polarion

PROFESSIONAL EXPERIENCE:

TEMPPrincipal IT Business Systems Analyst

Confidential

Responsibilities:

• Consult with business stakeholders to evaluate and identify complex business process and develop business needs into Patient Master Data Management (PMDM) Informatica system requirements.
• Provide technical expertise for system functional specifications and deploys systems, processes and procedures in a cost - effective manner.
• Lead cross-functional linked teams to address business or systems issues.
• Assist with project communication, project planning and development of documentation for system roll-out.
• Responsible for meeting Quality standards for processes and Medtronic System Compliance Methodology (MSCM) documentation.
• Responsible for meeting requirement and technical documentation deadlines and approvals for teh PMDM systems, patient data conversion and application programming interfaces.

Data Management Consultant

Confidential, Minneapolis, Minnesota

Responsibilities:

• Developed SQL queries to analyze data in OFSAA to determine whether Indicative data adjustments needed to be completed.
• Analyzed data quality rule exceptions for specific financial Systems of Record (SOR).
• Utilized Jira to report analytical findings on data quality rule exceptions.

Senior Business Systems Analyst

Confidential, Denver, Colorado

Responsibilities:

• Utilized Visio, OneNote and Word to initiate and lead business stakeholder meetings identifying enterprise-wide requirements for a multi-system environment. This included claims, EMR, Medicare, Medicaid, accounting and CRM systems. Created SharePoint site to upload and store team release documentation.
• Defined requirements and assisted in implementation of Centers for Medicare and Medicaid Services’ (CMS) new Medicare Beneficiary Identifier (MBI) in multiple databases and CMS Risk Adjustment Payment System (RAPS) submissions.
• Interviewed multiple internal clients and utilized Visio and OneNote to map “as is” and “to be” business process for multiple enterprise projects impacting claims, EMR and HRIS systems. Utilized PowerPoint to present business process mapping results for project team and management decision-making.
• Tracked client issues, planned and defined Incremental SDLC release requirements and testing for an internally developed enterprise-level participant census tracking system utilized for CMS submissions and sourced for claims and EMR systems. As a part of this effort, defined CMS “source-of-truth” data elements to be utilized for teh developing data warehouse and shared across enterprise computer systems.
• Initiated legacy system report development upgrade to Tableau. Teh effort was completed with written SQL queries in Oracle databases and internal client meetings to identify data elements.

IT Business Analyst

Confidential, Denver, Colorado

Responsibilities:

• Lead sessions with internal and external clients for requirement gathering, documentation and User Acceptance Testing (UAT) for data warehouse and business intelligence development projects.
• Wrote SQL queries to map data elements provided data integration for multiple Oracle data sourced from Allscripts medical health records, Groupcast claims and pharmaceutical data.
• Responsible for discovering usable data sources that meet client requirements for HEDIS measures and Key Performance Indicators (KPI) using SQL queries in Oracle databases.
• Collaborated with multiple internal clients to define reporting data elements and requirements utilizing Agile SDLC and Jira and Confluence applications.
• Lead daily Scrum meetings for MDM team Agile SDLC development work and responsible for project team backlog clean-up. Developed or clarified User Stories as needed as a part of that effort.

Sr. Business Analyst/Data Analyst

Confidential, Denver, Colorado

Responsibilities:

• Wrote SQL queries in multiple Oracle databases to complete source to target data mapping for teh Colorado Medicaid T-MSIS, PERM+ files and various reports for submittal to CMS.
• Wrote SQL queries to map data elements and data integration against raw data sources as well as teh data mart publishing layer in teh Oracle data warehouse.
• Prepared mapping data elements for T-MSIS ETL data processing by suggesting Informatica ETL development work for raw data transformation.
• Lead Joint Application Design (JAD) sessions with external clients for requirement gathering, documentation and User Acceptance Testing (UAT) for data warehouse and business or analytic client development projects. Utilized Rally for requirement documentation.
• Responsible for identifying business client data needs for Tableau, ArcGIS BA and Cognos reporting. Identified data elements utilizing Informatica Data Catalog. Supported client SAS statistical reporting.
• Initiated steps toward identifying MDM enterprise data elements in Oracle databases utilizing Informatica Metadata Management.

Quality Systems Engineer/Sr. Quality Assurance Analyst

Confidential

Responsibilities:

• Specialized in testing device configuration and device-produced data in databases utilizing HP Quality Center for test case management in an Iterative SDLC environment.
• Developed system functional flow block diagrams, concept documents and user interface design technical documents for device software development using Visio, Paint, Word and Excel software tools.
• Created and updated software specification requirements for device software production releases using Word templates developed for FDA approval.
• Created Risk Management and FMECA documentation supporting standard operating procedures for meeting FDA standards using Word templates for FDA approval.
• Worked with internal and external clients to define, design and develop new system requirements and Use Cases for software applications and medical devices.
• Developed and executed validation protocols for medical device UAT approval.

Lead Quality Assurance Analyst

Confidential

Responsibilities:

• Wrote SQL queries and Unix commands to test application data flow with HL7 messaging and Oracle databases.
• Created project plans with Project to meet release activities and developed project documentation in an Agile SDLC software development environment.
• Created Word templates and documentation for FDA approval of teh HPC 510(k) medical device software.
• Developed new regulatory testing verification practices intended to be utilized throughout teh company.
• Using Project, managed and designed testing activities and documentation for two hybrid obstetrics medical software applications and devices for multiple testing teams.
• Configured and maintained complex multiple testing environments utilizing both Oracle and SQL Server databases as well as a medical device lab with several fetal monitors for regulatory compliance testing.