MICHAEL SAMBOR

*** ***** ****

Longmeadow, MA ***06

413-***-****

413-***-****

adwie2@r.postjobfree.com

Summary:

Professional with proven background in business analysis, data analysis, systems analysis, project management, IT strategy formulation, budget process, capacity planning, application development and production support. Expertise includes ETL, data warehouse, EDI, batch and on-line transaction processing and reporting applications. Diverse experience in healthcare services, financial services including Big 5 consulting firm and Fortune 500 companies. Demonstrated success in both systems and business functions. A customer-focused leader who builds and maintains strong relationships.

PROFESSIONAL EXPERIENCE

UnitedHealth Group / Optum 2016 –

IT Business Analyst / Data Analytic Consultant / Senior Business Analyst / Senior Data Engineer

Prepared Business Usage Summaries for 65 extracts to assist Product Owner in discussing business needs with consumers

Decommissioned 8 extracts no longer used by consumers to reduce operating expense

Developed Standard Source to Target Mapping User Story for use by Agile Team

Created Mapping Specification Standards used by over 100 Data Warehouse Business Analysts

Gather requirements and complete artifacts / Validate requirements with stakeholders

Perform Impact Analysis of Data Warehouse changes on downstream systems

Contribute to the architecture and design of Data Warehouse infrastructure and solutions. :

Support all phases of the software development lifecycle (SDLC).

Lead internal review sessions with all levels.

Function as a mentor for other team members, provide assistance where needed.

.

Kforce Windsor, CT 8/2015 – 12/2015

Data and Analytical Platform Support Specialist (Contract Position)

Installed and configured SPSS and WebSphere Application Servers on Linux platforms.

Documented installation procedures.

Supported Salesforce Reporting processes.

CIGNA Bloomfield, CT 2009 – 2015

Systems Analyst Senior Specialist

Lead Analyst on Program delivering Data Warehouse Quality Engine Front End application

oEnabling Business Data Quality Management function

oServing over 50 clients

o Resulting in estimated $220K savings in avoided data remediation expense.

Roles: Senior Systems & Business Analyst., Data Analyst, Acceptance Tester, Business Project Lead, Data Steward.

Experience:

o Inbound Data Exchange & Data Warehouse Integration:

Data Quality Management & Metrics,

Data Lineage

Cross-Platform Reconciliation

Integration of Health Claim, Encounter, Provider, Biometrics, Lab, Incentives, & Eligibility (Member Matching) Data Subject Areas, including Fallout / Re-Cycling

HL7.2.3 Lab Compliance Validation,

ANSI X12 837 5010 Claim / Encounter Vendor Migration

ICD9 to ICD-10 Migration

oSDLC Deliverables Preparation:

Business Requirements Gathering (Information Management, Accounting, Finance, Underwriting)

Traceability between Requirements, Design, & Test Artifacts

Acceptance Testing

Multiple Platform Test Strategy Articulation

Regression Testing

Point-to-Point Data Validation

Production Implementation

Knowledge Transfer

Warranty Issue Resolution

Turnover to Production Support.

MASSMUTUAL FINANCIAL GROUP Springfield, MA 2005-2009

Project Manager (2008-2009)

Controlled portfolio budgets. Created communications vehicle for portfolio stakeholders. Led small-to-medium ($50k - $300k) projects including all phases of Systems Development Life Cycle. Roles included Project Planning and directing matrixed resources to deliver solutions.

Systems Specialist (2005-2008)

Led small-to-medium size projects (system enhancements) including Planning, Analysis, Design, and Execution phases of SDLC. Assisted Business Analysts in Requirements Definition and Testing. Designed and coded solutions. Planned and executed implementation. Provided on-call support.

Received area technical award for leadership of platform migration and product launch projects

Developed New Product Review Process, enabling business to assess impacts of product launches

Augmented and improved end-to-end integration and regression testing in area.

Integrated application controls into area design and testing processes.

Produced Area Application Continuity Plan

Developed ETL solutions utilizing Mainframe JCL / EZPlus, Unix, & Informatica. Informix DBMS.

Executed Disaster Recovery Testing

Updated Data Dictionary to include all permissible values in product enhancement project.

Led 2 projects to convert data in Data Warehouse to new values.

CIGNA Bloomfield, CT 2001-2005

Application Development Senior Specialist

Developed logical level application and data designs. Ensured compliance with enterprise architectures. Ensured development of technical specifications. Led walk-throughs. Contributed to component test strategy. Designed, coded, tested, and implemented applications. Produced Business Requirements.

Coordinated Area Cost Savings Program yielding $1M in IT expense reductions in FY 2003 – 2004.

Provided Technical Leadership for Process Improvements that increased EDI Claim throughput by 196% to Cigna Medical & Dental Claim Systems.

oUtilized linear regression analysis to forecast transaction volume that would break the batch window. Drove reductions in claim process time.

Provided Technical Leadership for Enterprise HIPAA Interactive Transaction Reporting Application

oResponse Time & Transaction Volume Reporting,

oReferral, Claim Status Inquiry, Eligibility Benefit Inquiry transactions

oUtilized Unix & Connect:Direct for cross-platform data transfer.

Managed Project implementing Role-Based Access Control (RBAC) for Corporate eCommerce Production Support Team.

Led Release Testing for Enrollment & Premium Payment Gateway Applications.

oManaged Functional & Regression Testing Efforts,

oMaintained Regression Test Bed.

Developed code migration procedure with DBA team for SQL Server database load scripts.

Provided Production Support for Enrollment, Premium Payment, and Electronic Remittance Advice Gateway Applications.

Planned & Executed Disaster Recovery Testing

OTHER RELATED EXPERIENCE

Price Waterhouse Coopers, Consultant

RCG/IT, Consultant

United Health Group, Senior Software Engineer

Digital Equipment Corporation, General Accounting Manager

Baxter International, Senior Programmer / Analyst

Consolidated Edison Company of New York, Summer Intern

C. Caprino & Associates, Consultant

Amherst Associates, Technical Writer

F.L. Roberts, Programmer

General Electric Company, Financial Management Program

EDUCATION

MS, Management – Information Technology and Finance

Massachusetts Institute of Technology, Cambridge, MA

BS, Business Administration – Accounting

Western New England College, Springfield, MA

BA, cum laude - Economics

Amherst College, Amherst, MA

Technical Assets: SPSS, EDI Transactions:( ANSI X12 Standard): 820 Payment Order / Remittance Advice,

834Enrollment Transaction, 835 Remittance Advice Transaction, 837 Healthcare Claim Transaction,

270/271 – Healthcare Eligibility Benefit Request / Response, 276/277 - Healthcare Claim Status Request / Response. (HL7.2.3 Standard): Lab Test Results.

Languages & Data Bases:

Teradata, R, COBOL / DB2 / IMS DB/DC / CICS, INFORMATICA (7.3), ORACLE PL/SQL / Toad, INFORMIX, ACCESS / EXCEL, Sybase EC Map, VB Script, HTML, Python, DataStage, Airflow

Platforms: IBM OS 390 / 30XX MVS/ESA JCL / TSO / ISPF, Teradata,

AIX, Linux & Sun Solaris / UNIX,

Utilities: EASYTRIEVE, FTP, Connect:Direct

Code Migration Tools: ENDEVOR, PANVALET,

Request Tracking & Testing Applications: Quality Center / ALM Project Management Applications: Microsoft Project, CLARITY, ServiceNow

Training: IT Project Management Overview, Project Cost Management, Project Communications Management, Agile Epic & Feature Writing, Project Scope Management, Project Risk Assessment,

6 years experience working in Agile development environment

Contact this candidate