Program Manager Systems Analyst

Summary:

An accomplished, results-driven Program Manager and Senior Business/Systems Analyst with over 20 years of experience in Information Technology and Business processes. Over 10 years of experience in Agile/Scrum and over 15 years in SDLC methodologies

Business Solutions Analyst at CHPW (Community Health Plan of Washington)

Program Manager at Premera Blue Cross for Provider Information Management Systems

QA Analyst at Safeco for Liability and Payments project for Auto Insurance Policies

Business Analyst at Boeing Product Data Management and Human Resources & Payroll projects

Functional Analyst at Boeing Human Resource Legacy Systems Disposition projects

Systems Analyst for Sprint Billing Systems project at Ernst & Young Application Services

Systems Analyst for Sales, Customer Service and Y2K Projects at Eddie Bauer

Functional Analyst for and Manitoba Government Vehicle Licensing Project at IBM Canada

Systems Analyst for Sales, Marketing and Finances systems at Safeway Canada

Over 12 years’ experience working in Healthcare Industry including Claims Processing, managing Providers Information, Provider Networks, Provider Credentialing, Payment Policies

Education:

Bachelor of Science (4-Years Degree)

University of Manitoba, Winnipeg, MB, Canada

Bachelor of Engineering (4-Years Degree)

Panjab University, Chandigarh, India

Work:

Program Manager & Data Analyst (March 20 – Current)

Port Of Subs, Mill Creek, WA, U.S.A

Human Resource, Payroll, Sales Data Analysis, Marketing

Maintained Inventory, Sales and Employee Data

Created Daily and Monthly Sales, Profit/Loss and Payroll Reports

Financial analysis including financial modeling, profitability analysis, return on investment/discounted cash flow analysis

Managed Customer Database and created Performance & Analytical reports for Management

Negotiated and managed customer contracts, including scope changes. Reviewed contract terms and conditions

Program Manager (April 2018 – February 2020) – Remote and On-Site

Physical Medicine Rehab Clinics, Fresno, CA, 93720 U.S.A

Negotiated and managed billing contracts with Clearing-House (Insurance companies) and Medicare contract services departments and reviewed contract terms and conditions

Managed Claims and Patient Databases and Micro-MD EMR (Electronic Health Records)

Enhanced various Business Applications related to Claims and Customer Data

Created Work-In-Progress and Claims Tracking Process Tools using Visual Basics

Responsible for updating and maintaining business networks and computer systems, analysing and determining systems enhancements and business reengineering processes

Created user training manuals and process documents for Billing, EMR and Eligibilities

Business Solutions Analyst (December 2017 – March 2018) - Contract

Community Health Plan of Washington Seattle, 98101 WA U.S.A

Gathered requirements from the business and worked with the developers (Business Intelligence and Reporting team) to ensure they understand the technical requirements from the functional specification. Approved final deployment into Production

Performed QA Analysis on SQL Queries, Developers’ coding & testing, Test plans

Managed Medicare database and presented the data through SSRS and Web Analytics

Created SQL queries, data tables, views, case statements, join tables, sProc (stored procedures) and SQL functions in Microsoft SQL Server environment

Scrum coach and management and provided day-to-day direction to the project team

Created ETL processes, SSIS packages and SSRS reports, identified data gaps, and documented new processes and models, Software verification and validation

Collaborated with vendor, clients, and internal teams to ensure deliverables on time that meet user expectations. Designed operational workflows and solutions for management

Business Analyst & Program Manager (April 2005 – October 2016) - Permanent

Premera Blue Cross. Mountlake Terrace, & WA U.S.A

Managed multiple projects simultaneously as Program Manager by planning and prioritizing the sprints for development and testing teams from scope delivery to use case development

Served as liaison between the internal/external business stake holders and the IT professionals to provide technical solutions to meet user needs including data and attribute mapping

Developed a new Application/Tool by combining 12 different systems within 6 different departments that helped company to save over $500,000 and thousands of hours of Data Entry

Negotiated and managed customer contracts, including scope changes. Reviewed contract terms and conditions and supported Business Unit Leaders in solving challenges.

Lead the 2005 SQL Server Upgrade team and transferred all Applications to 2012 Server

Managed Providers and Claims Databases using SSIS packages and SSRS reports

Organized daily Stand-up meetings, Kaizen events and JAD sessions

Lead Sprint Planning, Sprint Review and Sprint Retrospective meetings

Negotiated between Users, Developers and Testers to prioritize Product Backlog and Sprint Backlog items. Created User Stories and Acceptance Criteria

Worked as Business & QA Analyst within Health Care Delivery Systems group that maintains various Business Applications related to Claims & Provider Information Management Systems

Worked closely with Business and Product Owners to write User Stories

Used TFS (Team Foundation Server) to document requirements as Product Backlog

Responsible for Business Requirements and Functional Specification documents

Participated in Kanban, Kaizen, 5s, Six Sigma and Continuous Improvement processes

Skills: Agile Methodology, Sprint Planning, Business Requirements and Functional Specification, Risk Assessment and Management, Data Analysis, SQL Queries, Stored Procedures, SQL Server, SSRS, SSIS, Crystal Reports. Facilitated all four Scrum ceremonies as a Scrum Master.

QA Analyst (March 2004 – February 2005) - Contract

Solutions IQ. Bellevue, WA U.S.A - Client: Safeco Corp

Worked in Quality Assurance & Testing team to resolve Driver & Vehicle insurance issues

Responsible for testing new Business enhancements and change requests

Developed test plans and conducted program reviews and test reviews with project teams

Designed Process Flow and Data Flow Diagrams, wrote program specs and documentation

Created online and batch modules, copybooks, link cards, MFS, new DB2 and IMS subroutines

Identified business cases and wrote test scripts and set up the test data. Performed

functional tests, verified test results and created Crystal reports, change reports

Functional Analyst (June 2000 – November 2003) - Contract

FUJITSU Consulting Inc. Bellevue, WA U.S.A - Client: Boeing Corp.

Worked on “Human Resource Legacy Systems Disposition” project at Boeing that helped company to move from old system to new object-oriented systems and saved over $300,000 in maintaining and operating the old system with lots of manual hours of data entering

Worked on Y2K fixes for Human Resource and Payroll Systems applications

Worked as functional analyst on “Product Data Management” project at Boeing by identifying and mapping the Air Plane parts to various sections of Air Planes (737, 757, and 747)

Created functional Test units and identified any input or output data dependencies.

Identified and described the Test cases and expected results for these functional test units Systems Analyst/Programmer

Systems Analyst/Programmer (December 1999 – June 2000) - Permanent

Ernst & Young Applications Services, Irvine, CA, U.S.A Client: Sprint Corp.

New Application developments for Sprint Billing Systems to challenge AT&T promotions

Documented functional specifications, processes, data relationships, interfaces, and operational requirements

Designed DB2 tables, indexes, paths to correct/improve performance of complex programs

Worked, in DB2, COBOL, SQL, JCL, TELON QMF, CA11, CA7 environment using various development tools like ISPF, Platinum products, Insight, Infopac, Data Expert, PNMS.

Systems Analyst/Programmer (April 1999 – November 1999) - Contract through CNC Global

Eddie Bauer Inc. Seattle, WA, U.S.A

Worked on Y2K project that was in testing phase and included COBOL, DB2, JCL, CICS.

Performed the functional and integration testing and raised problem and change reports.

Analysed, coded and tested new Cobol programs and JCLs. Tested JCL changes for CA-11

Systems Analyst/Programmer (June 1998 – April 1999) - Contract

IBM Canada Ltd. Winnipeg, Manitoba, Canada

Performed Analysis, Coding & Testing of Y2K project

QSAM/VSAM files, IMS and DB2 databases to identify date fields that need Y2K fix.

Identified members in terms of their operations (batch, online, report, etc.) and type.

Made code changes, prepared test strategies & test cases and performed unit testing.

System Analyst/Programmer (April 1996 – June 1998)

Canada Safeway Ltd, Winnipeg, Manitoba, Canada

Was responsible for maintaining 6 Accounts & Finance systems.

Handled emergency production problems which included: recovery of data, program abends, rescheduling production jobs with quick fixes during off-hours/nights.

Designed DB2 tables, indexes, paths to correct/improve performance of complex programs.

Designed Process Flow and Data Flow Diagrams, wrote program specs and documentation.

Designed DB2 tables, indexes, paths to correct/improve performance of complex programs.

Developed test plans and conducted program reviews and test reviews with project teams.

Contact this candidate