TECHNICAL SKILLS

Knowledge and abilities: DB2, COBOL, MicroFocus COBOL, CICS, VSAM, OS JCL, IDMS, ADSO, IAM, IMS, MQ Series, Xpediter, File - Aid, Intertest, CEDF, CA-7, MVS, SDLC, TSO, CLISTs, Syncsort, Easytrieve, QMF/SPUFI, Relational Database, T-SQL,Visual Studio, SQL Studio, Python, Java, JavaScript, HTML, XML, C, C#, SQL, Transact SQL, SQL Studio, MS SQL Server, Stored Procedures, MS Access, Excel, Word, Powerpoint, MS Project, One Note, Windows, Linux, SSRS, SSIS, Power BI, Tableau, Object-Oriented programming, Web applications, Service-Oriented Architecture, Software as a Service (SAAS), Sharepoint, Endevor; Zeke, Changeman, Visio, Erwin, CPT, HCPCS, ICD-10-CM, ICD-10-PCS, Jira

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Quality Assurance Analyst

Responsibilities:

• Perform Independent Verification and Validation services for state Confidential claims projects.
• Provide Subject Matter Expertise for CMS certification of the Integrated Eligibility System.
• Perform IV&V of a state Enrollment and Eligibility systems.
• Access Jira/Confluence to research planned releases and to do risk analysis.
• Performed oversight of Tableau and Power BI reports for client states.

Confidential, New York, NY

IT Specialist

Responsibilities:

• State Officer for the states of Georgia, New York, and New Jersey for Confidential and track state Confidential IT replacement projects.
• Support legacy systems in NY and NJ utilizing Cobol, DB2, CICS, etc.
• Support content management using Sharepoint and network intranet site.
• Served as Sharepoint administrator for grouping users into roles for identity access management.
• Review state projects for modular design, outcome - based planning, and metrics for success.

Confidential, Iselin, NJ

Technical Consultant

Responsibilities:

• Perform data analysis on Eligibility and Enrollment for Confidential Advantage and Confidential Part D.
• Research for data reconciliation using Confidential Advantage (MARx) and InfoCrossing.
• Research defects and discrepancies using queries to do root cause analysis.
• Implement new Physician Contact screen for the Managed Care project for Confidential Part D.

Confidential, Weehawken, NJ

Senior Associate

Responsibilities:

• Performed application support for COBOL CICS DB2 systems.
• Develop online programs for performance reporting for Ultra High Net Worth accounts.
• Perform performance tuning on programs with large DB2 tables with the Database Administrator (DBA).
• Write/modify stored procedures and calling programs.
• Scheduled new jobs in production using CA7
• Design new tables and convert VSAM files to DB2 tables.
• Develop programs to report composite performance for the Performance Conversion project.

Confidential, New York, NY

Senior Systems Analyst

Responsibilities:

• Develop new cross-platform applications using full project lifecycle methodology.
• Perform data modeling for table design of new applications.
• Write queries for stored for stored procedures for use in client server applications.

Confidential, New York, NY

Software Engineer

Responsibilities:

• Develop and support client statements for 30 brokers.
• Set up and support transmissions from vendors such as ADP, Sunguard, DST, and SIS.

Confidential, New York, NY

Project Leader

Responsibilities:

• Lead a team of 5 developers supporting Participant Systems.
• Perform analysis and design for the modernization of the Confidential Loan System.
• Analyze and design for the modernization of the Confidential Loan System using COBOL CICS DB2 and Java.
• Provided support for CICS COBOL DB2 systems.
• Change control for production turnover including CA7 scheduler and Endevor for change control.
• Write SQL for new database Application Program Interfaces (APIs).
• Load data from banks and brokerages using CCF, MDH, and NDM utilities.

Confidential, New York, NY

Project Leader

Responsibilities:

• Lead group of 4 developers supporting telecommunications and network operations.
• Perform data analysis and data modeling for new database tables.
• Develop SQL query tools for the data warehouse.
• Write DB2 programs and stored procedures for a new Network Operations system.
• Write extract programs to load tables to be accessed via the gateway for client server queries using MS Access.
• Work with the DBA using database utilities to offload tables for load to the acquiring company system.
• Conduct technical interviews.

Confidential, West Nyack, NY

Senior Programmer Analyst

Responsibilities:

• Develop Perpetual Inventory system using RAD tool, APS, with Microfocus Cobol and SQL for XDB.
• Program and test Monarch bar code printers, protocol converters, and software.
• Travel to warehouse sites around the country to install and implement the new hardware and software and provide training.
• Develop Perpetual Inventory messaging system using RAD tool, APS, with Microfocus Cobol and SQL for XDB on the LAN.
• Built complex JCL using multiple procs with overrides and conditional execution.

Confidential, Princeton, NJ

Senior Applications Analyst

Responsibilities:

• Integrate the Squibb payroll into the Confidential package used by Confidential following the merger of the two companies in early 1991.
• Provide user training and support through the successful implementation.
• Develop a front-end to the Confidential payroll system.

Confidential, Paramus, NJ

Project Manager

Responsibilities:

• Manage the Business Applications group doing development and support of General Ledger, Accounts Payable, Accounts Receivable, and Human Resources.
• Manage a staff of 6.
• Conduct interviews and reviews.

Confidential, Hackensack, NJ

Senior Programmer Analyst

Responsibilities:

• Develop and test programs for the ATM.

Confidential, Hackensack, NJ

Senior Progammer Analyst

Responsibilities:

• Develop the Profit and Loss system using COBOL, CICS, IDMS, and ADSO.
• Perform program support for CICS/DB2 systems.