SUMMARY:

• 20+ Years of experience as a Business Analyst, Data Analyst, Business Process, QA, Project Manager with extensive SQL and PLSQL scripting skills.
• Over 15 years of Information technology background in healthcare and other industries.
• Assisted in defining business processes, business analysis on data, integrated systems, and incorporated standards and best practices.
• Supervisory experience in managing 40+ team members including offshore models.
• ICOMS experience in business processing
• Extensive experience with Oracle environment for over 10 years.
• Excellent data modeling experience;used ErWin data modeling tool
• Great experience with implementing COTS and customizing if needed
• Strong background in maintaining interface tables using SQL and PSQL to query information.
• Maintained release scripts for induction into the various test and ultimately production environment.
• Participated in software audit as permitted.
• Projects included Disaster recovery
• Motivated, personable business professional with multiple technical disciplines and talent for quickly mastering technology.
• Diplomatic and tactful with professionals and non - professionals at all levels.
• Accustomed to communicating with all levels of management and end-users.
• Demonstrated history of producing accurate, test strategies, design specifications for integration within the Finance, Healthcare industry and Oil & Gas.
• Flexible and versatile - Poised and competent with demonstrated ability to easily transcend cultural differences.
• Thrive in deadline-driven environments. Excellent team-building skills.

TECHNICAL SKILLS:

• Business Analysis/data modeling - ServiceNow application
• QA/Testing/Test Developer (automated/manual) (QTP/Selenium); Ruby/Rails
• SOX compliance
• Oracle Financial modules (AP; AR; OTC; GL; FA; P2P; Project Accounting); DBA
• Software/Hardware Configuration Administrator
• Documentum
• SharePoint
• Data Analysis
• Requirements gathering
• Microsoft Visio
• Web application development/integration
• EPIC, Meditech, HL7 processes and infrastructure, Confidential -10
• SOA/.NET/J2EE/C#
• IT SOX Compliance
• Remedy Development/ Support/problem resolution
• Java;.Net; SOA
• Pega BPM
• HPQC/QTP/Selenium
• ICOMS (telecommunications)
• Asset Management
• Database Administration/DBA
• PL/SQL
• Code audits
• MS Access

PROFESSIONAL EXPERIENCE:

Confidential

OTC Business Analyst

Responsibilities:

• Managed all test cases and strategies for OTC workflows
• Resolved issues and defects within OTC
• Worked with developers to identify and defects and enhancements

Confidential, Broomfield, CO

IT PM/Business Systems Analyst/QA

Responsibilities:

• Created all business analyst templates using Servicenow and did gap analysis of Legacy Data.
• Worked directly with Investment software applications (Simcorp) and data modeling as required
• Acted as system administrator for various applications in MSOffice and Active directory
• Gathered requirements for all projects including identity management scenarios
• Wrote project plans for upcoming projects/WBS
• Resource placements
• Installed CMS
• Participated in software audits to determine impact analysis
• Tested all applications/in-house automation using HPQC for Java based applications and Selenium for web based applications
• Activities included sprint planning, daily stand-ups, and retrospectives; drafting user stories, using acceptance criteria to form test cases
• I lead the test team in creating manual and automated test plans and test cases for the Oracle R12 Financial applications, including AP, AR, GL, and FA. This improved development deliverable by 40% due to the details of the use cases and test driven development.
• Used QTP for automated testing
• SCM and ES Finance Oracle modules - configured OM, IM, WIP, BOM, OTC, P2P

Confidential, Denver, CO

Business Systems Analyst/QA

Responsibilities:

• Formulated legacy data extracted from healthcare institutions using SQL
• Tested all SharePoint/web interface reports derived from "cube" data using Selenium
• Wrote and tested 200+ test cases using Test Manager for requirements traceability and stakeholder expectations.
• Created test cases from requirements
• Developed Confidential -10 test formulas as well as Confidential
• Track, monitor, and communicate task progress against the project plan, quality measurestandard processes, and milestones to a Project Manager; used QTP for automated test scripts

Confidential, Broomfield, CO

PM/Business Systems Consultant

Responsibilities:

• Compare report outputs to system reports and define business intelligence data; in QA activities drafted user stories, using acceptance criteria to form test cases; used Selenium for web play/record test cases; wrote requirements using ServiceNow application
• Write SQL queries to test back end systems
• Participate in claims and benefit issue resolution
• Owned Concept documentation as well as requirements document
• Designed process to customize EMR link to pull patient data and distribute to applicable integrating systems McKesson - EKG and EPIC
• Defined disaster recovery protocol for infrastructure projects
• Converted CPT codes from ICD9 to ICD10 and flowed them into Epic
• Developed tests plans for Confidential abd Confidential -10 cases
• Created contextual diagrams for HL7 infrastructure
• HL7 Analysis, created HL7 use cases to show how the legacy data would be transmitted back to their EMR - EPIC
• Designed best practices for SDLC process using ITIL standards/criteria
• Wrote test plans/strategy for migration to HPQC and using Selenium for automated testing
• Executed manual and automated test plans (QTP) and test cases for the Oracle R12 Financial applications, including AP, AR, GL
• Designed process to pull data from third party vendors (McKesson, Meditech; HL7 infrastructure)

Confidential, Broomfield, CO

Sr. Business Systems Analyst/Technical Project Manager

Responsibilities:

• Led weekly ERP queue meetings to review prioritized Remedy tickets and follow up protocol for Oracle SRs
• Conducted configurations for ERP Oracle suite including GL, AR, AP, FA, Advanced Pricing, and Cash Management modules (data modeling)
• Acted as system administrator for CSG billing system and MS applicaitons
• QA activities included sprint planning, daily stand-ups, sprint demos, and retrospectives; used HPQC and Selenium for testing tools
• Identified current and new business process flows for finance modules; conducted software audits which resulted in upgrading from Oracle 11.5.10 to Release12
• Led support efforts for identity management requirements/test cases using ServiceNow application
• Managed SharePoint site
• Support finance month-end close activities with writing finance scripts via SQL to ensure AR reports would balance and post to the general ledger
• Tested RICE Oracle components/configurations for integration and UAT activities and worked with Wipro development team on defect issues and retests activities and maintain database protocols
• Created test automation for HTML forms testing for Oracle R12 using Selenium tool for modules that included GL, FA, AP, AR and Project Accounting

Confidential, Englewood, CO

Business Systems Consultant

Responsibilities:

• Lead daily change management meetings to review prioritized change orders
• Identified current and new business process flows for content/code releases to test environments and production
• Designed integrated process for web application from internal systems (McKesson, Meditech)
• Created test plan for system integration for automated testing and manual activities using HPQC manual/automated testing (QTP) and used Selenium for automated testing
• Created manual and automated test plans and test cases for the Oracle R12 Financial applications, including AP, AR, GL, Project Accounting (worked with RDMS dataase schemas)
• Tested integrations and interfaces for Confidential and Confidential -10 into newly formed architecture
• Wrote SQL queries to pull data from internal systems (PACS, demographics) via web application customization to enable SSO and distribution from Active/Enterprise

Confidential , Denton, TX

Functional Oracle Business Analyst/Project Manager

Responsibilities:

• Lead discovery sessions for 11i to R12 ERP Oracle upgrade for AP, FA, Purchasing, OTC, Advanced Pricing, GL, AR and subsequent setups for applicable modules
• Assisted in setups/configuration for multi-org (GL) using MS Access for scripting
• Identified current and new business process flows for financial modules by pulling and identifying queries to maintain interface tables from E-business orders into Oracle
• Created test strategy and test plans in support of automated testing for all financial modules and reporting activities using HPQC manual/automated testing (QTP/Selenium)
• Wrote SQL queries to pull data from DataTel student system into GL
• Updated flat file process to state accounting system for reimbursements into AR

Confidential, Denver, CO

Functional Oracle Business Analyst/DBA/Data Modeler/QA

Responsibilities:

• Lead support efforts and created test cases for support of enterprise Oracle applications including identity management
• Setup module configurations for Oracle ERP modules that were AP, AR, Advanced Pricing, Order to Cash, GL, CE, OTC, PO, FA and Projects and tested new configurations and setups - also worked on Confidential corp applications as support
• Adopted ITIL standards best practices for using Pega BPM
• System administrator for Remedy and Oracle helpdesk
• Managed several implementations of BMC Remedy for incident/change management
• Wrote/developed/executed test plan using HPQC/QTP as well as manual testing
• Wrote disaster recovery procdedures as directed
• Developed SharePoint site for documentation traceability and Remedy/Helpdesk support
• Implemented Documentum CMS
• Wrote SQL queries to maintain Oracle interface tables for E-Commerce
• Managed release process (SCM) into production environment from development, test using HPQC for manual testing and Selenium for test automation
• Managed defect management process for prioritization of issues
• Coordinated/supported month-end close activities and wrote requirements using ServiceNow applicationi
• Modules: AP, AR, OTC, GL, BOM, WIP; Discoverer 10G; OBIE; Tools: Teradata, ETL

Confidential, Aurora, CO

Sr. Business Systems Analyst/Project Manager/QA

Responsibilities:

• Responsible for gathering requirements for Colorado Region Digital Imaging project
• Collected information from Business and Clinical departments for current state business processes
• Owned Concept documentation as well as requirements document
• Designed process to customize EMR link to pull patient data and distribute to applicable integrating systems McKesson - EKG and EPIC
• Converted CPT codes from ICD9 to ICD10 for reporting purposes
• Created contextual diagrams for HL7 infrastructure
• HL7 Analysis, created HL7 use cases to show how the data would be transmitted back to their EMR - EPIC
• Designed best practices for SDLC process using ITIL standards/criteria
• Wrote test plans/strategy for migration to HPQC and used Selenium for automated testing
• Designed process to pull data from third party vendors (McKesson, Meditech; HL7 infrastructure)
• Conducted JAD session to identify both functional/non-functional requirements to validate business process automation
• Responsible for identifying gaps in current vs. future state technical documents and mitigating accordingly
• Responsible for building integrity and credibility between project consultants and Business Stakeholders

Confidential, Englewood, CO

Business Systems Developer/DBA/Data Modeler

Responsibilities:

• Led test effort and tested end-to-end workflows for transactions that supported R12 Oracle upgrade using HPQC/QTP/Selenium for modules AR, Advanced Pricing, AP, FA, GL, and CE and wrote the UPKs accordingly.
• Managed code releases to production for updates to Pega class structures
• Managed SOA infrastructure changes and patches and identity management protocols
• Created HPQC import of test data from Excel into requirements/test cases
• Managed regression testing efforts and UAT

Confidential, Englewood, CO/Indianapolis, IN

Functional Business Systems Analyst

Responsibilities:

• Lead support efforts and created data sets for HEDIS information
• Analyzed data and managed CPT and ICD9 information for all US regions
• Ensured clients were Confidential certified as a recommendation to auditor
• Converted CPT codes from ICD9 to ICD10 and flowed them into Epic
• CPT codes

Confidential, Longmont, CO

Sr. Oracle Product Support/Oracle DBA

Responsibilities:

• Managed Oracle support desk/activities for both Finance/SCM modules
• Responsible for code releases (RICE) elements into test and production environments
• Responsible for prioritization of all Oracle application issues/tickets and defect management tracking and prioritization
• Acted as system administrator for Oracle applications
• Configured ticketing system (Magic) to adequately notify users of updates to submitted tickets
• Managed Oracle 11.5.10 support issues including Tiers 1-3 support and offshore team of 16 support engineers (Zensar)
• Developed SharePoint site for Confidential Oracle support team and offshore support engineers in India
• CVS/Remedy administrator for all Oracle support issues defect code changes
• Managed all production/dev/test instances for Oracle including code migrations into both test and production using Selenium for non-Java applications
• Develoed disaster recovery protocols
• Supported ITIL standards and best practices
• Managed and implemented Oracle application patches/fixes into production

Confidential, Aliso Viejo, CA

Sr. Project Manager/Business Analyst

Responsibilities:

• Responsible for upgrade from 11.5.8 and 11.5.10 E-Business suite for subsidiaries of Confidential
• Configuration of modules included GL, AR, AP, FA, Service Contracts (external/internal) OIC, OM, Pricing, Inventory Management, BI ( Discoverer, OBIEE)
• Implemented various project life cycle procedures
• Created base SDLC documentation and FIT analysis design as a result of the identification of use cases for FIT analysis and gap analysis
• Created test plan based on traceability matrix linking requirements to test cases and led the test team in creating manual and automated test plans and test cases for the Oracle R12 Financial applications
• Set up CSG requirements and implemented billing system as requested
• Managed change management infrastructure changes and application upgrade code changes
• Participated in test activities from system test to UAT using HPQC/QTP/Selenium
• Acted as administrator for ClearCase configuration management tool
• Managed code migrations from development into test/production
• Managed Data validation team for migration/implementation of data to new workflows in Oracle
• Managed key deliverables for test cycles and requirements gathering