Project Management It
Resume:
MICHAEL SAMBOR
Longmeadow, MA ***06
****************@*******.***
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: COBOL / DB2 / IMS DB/DC / CICS, INFORMATICA (7.3), ORACLE PL/SQL / Toad, INFORMIX, ACCESS / EXCEL, Sybase EC Map, VB Script, HTML Platforms: IBM OS 390 / 30XX MVS/ESA JCL / TSO / ISPF,
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, Rally, Jira Training: IT Project Management Overview, Project Cost Management, Project Communications Management, Agile Epic & Feature Writing, Project Scope Management, Project Risk Assessment,
Summary:
Professional with proven background in data analysis, business requirements, 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
Travelers Companies / Reinsurance Department June 2023 –
Senior Business Systems Analyst
Major Initiatives
Multi-year project to enable reinsurance platform to support multinational business
Migration of existing business to new financial platform (new feed to Reinsurance)
Business functions supported:
Reinsurable Claim identification
Reinsurer Billing
Accounts Receivable Subledger Maintenance and Feed to General Ledger
Reinsurance Contract Maintenance
Role: Translate business requirements into detailed functional requirements and user stories.
Understand the business functions, processes, and overall business strategies
Clearly define the behavior of the system
Ensure the requirements are unambiguous and understandable by both business users and solution delivery teams.
Communicate technical concepts to non-technical leaders
Ensure the team has sufficient detail to get work done
Participate on a Scrum team, collaborating with the Product owner to evaluate the feature, write user stories, document business rules and with the developers to review technical design enablers and dependencies.
UnitedHealth Group / Optum January 2016 – May 2023
IT Business Analyst / Data Analyst
Work with business stakeholders to gather requirements and complete artifacts, including solution design support . Validate requirements with stakeholders and the project team; provide suggestions and recommendations. Translate highly complex concepts in ways that can be understood by a variety of audiences. Contribute to the architecture and design of Data Warehouse infrastructure and solutions. Develop technical specifications and design documents. Develop, enhance, integrate Data Warehouses/Data Marts and Business Intelligence Solutions. Test Data Warehouses/Data Marts. Support all phases of the software development lifecycle (SDLC). Lead internal review sessions with all levels, including senior leadership. Document, discuss and resolve business, data and reporting issues within the team, across functional teams, and with business stakeholders. Collaborate with project stakeholders and technical teams regarding enhancements, changes, issues and defects that may impact development, data, workflow and/or functionality. Present written and verbal data analysis findings, to both the project team and business stakeholders. Build constructive partnerships with business leadership to proactively recommend solutions to business issues through practical, elegant, and effective business intelligence and reporting vehicles. Direct deployment of enterprise data strategy vision through successful program delivery. Collaborate with global and contractor leaders to develop partnerships that allow for capacity flexibility and offer equivalent and or superior quality delivery capability. Incorporate best practices and standards in metadata and report/dashboard development. Function as a mentor for other team members, providing assistance where needed. Function as a lead on projects as necessary.
Kforce Windsor, CT August - December 2015
Data and Analytical Platform Support Specialist
Installed and configured SPSS and WebSphere Application Servers on Linux platforms. Documented installation procedures. Supported Salesforce Reporting processes.
CIGNA (Permanent Employee) /
TEK SYSTEMS (Consultant) Bloomfield, CT September 2009 – July 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, including Multiple Platform Test Strategy Articulation, Regression Testing, Point-to-Point Data Validation
Production Implementation, including Knowledge Transfer, Warranty Issue Resolution & Turnover to Production Support.
MASSMUTUAL FINANCIAL GROUP (Permanent Employee) /
Albano Systems (Consultant), Springfield, MA August 2005- April 2009
Project Manager (2008-2009)
Controlled portfolio budgets. Created communications vehicle for portfolio stakeholders. Provided leadership for small-to-medium ($50k - $300k) projects including all phases of Systems Development Life Cycle. Roles included Project Planning and management of 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.
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 New Product Review Process, enabling business to assess impacts of product launches
Received area technical award for leadership of platform migration and product launch projects.
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 (Permanent Employee) /
Howard Systems (Consultant), Bloomfield, CT January 2001-July 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 to Process Improvement Project that increased EDI Claim throughput by 196% to Cigna Medical & Dental Claim Systems. Utilized linear regression analysis to forecast transaction volume that would break the batch window. Drove reductions in claim process time.
Provided Technical Leadership to Project delivering Enterprise HIPAA Interactive Transaction Reporting Application – included Response Time & Transaction Volume Reporting for Referral, Claim Status Inquiry, and Eligibility Benefit Inquiry transactions. Utilized 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. Managed Functional & Regression Testing Efforts, maintained 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
Contact this candidate