SUMMARY:

• Business Programmer Analyst with experience working with data structures, creating testing scripts and manipulating data for unit, integration, user and acceptance testing.Experience performing data analysis and facilitating client meetings gather requirements to create/update the Business Requirements Documents/User stories and Diagram flowchart documents.
• I have knowledge, familiarity and the ability to read and understand Entity Relationship Diagrams and Data schemas and naming conventions; writing program code and implementing code into production environment in accordance with company standards within the System Development Life Cycle using Change Management/versioning tools.
• Familiarity and knowledge of SQL MS Server development, of HL7 integrator and EDI transaction sets 835 and 837.
• I have worked with both Scrum/Agile and Waterfall methodologies.

TECHNICAL SKILLS:

Languages: IBM Mainframe COBOL II, ADABAS NATURAL/CICS, Natural Construct, SQL, JCL, Mainframe SAS, DB2

Operating Systems: IBM Mainframe Series MVS/ESA - Enterprise zOS/390, UNIX 64 (basic vi)

Database: DB2, ADABAS, ORACLE 9i, IMS

Tools Editing: TSO/ISPF ENDEVOR and PANVALET, vi Editor

IBM Utilities: IDCAMS, SYNCSORT

Versioning: Serena Change Man, Panvalet

File processing: FILE-AID, FTP, NDM, Move IT, Microsoft Word, Excel

Project Management: Clarity, Team Track, Bugzilla, Rally

Debugging: Viasoft, XPeditor

Querying: QMF

Other: Visio - Data Flow Diagrams, Entity Relationship Diagrams

Methodologies: Waterfall and Agile (SCRUM)

System Software Applications: Manufacturing, Marketing, Telecommunications, Auto Insurance, Personnel and Reporting Systems, Educational (Financial Aid), Order Entry, Utilities (CIS Plus), Health Insurance

PROFESSIONAL EXPERIENCE:

Confidential

Mainframe Developer/Business System Analyst

Responsibilities:

• Analyzed user requests for modifications to system applications and processes.
• Conducted requirements gathering for production fixes and service change requests.
• Created program requirements documents and gained user approval and sign-off.
• Published program requirement document needed to convert SAS programs to SQL.
• Collaborated with users and developers to deliver automated solution for Client Letters.
• Analyzed report’s output and source data and changed program logic to produce accurate reporting metrics for Finance Department.
• Presented technical documents to peers and clients for review and verification.
• Created and revised DFD’s for Client Letter processing and other system processes.
• Performed ad-hoc SQL queries to retrieve claims, membership and provider data to fix production data issues/errors.
• Maintained programs used to process EDI transactions received/sent via MQ series.
• Updated programs executing 835/837 Claims transaction processing to comply with HIPPA health coding changes from ICD-9 to ICD-10.
• Restructured program logic to synchronize member data between GHI and BCBSKS.
• Participated in peer reviews of business requirements/user stories and code.
• Performed maintenance and enhancements to the EDI process programming logic.
• Performed system process modeling using Visio.
• Updated program logic to in corporate mandated requirements.
• Used RTM and Use cases to verify the test scripts for unit testing met all requirements.
• Performed or assisted in SDLC testing phases.
• Recorded and tracked time spent on projects using Clarity software tool
• Reported project status to manager and attached supporting technical documents for SDLC workflow tracking using Serena Team Track and Rally(Agile) software tool.
• COBOL/DB2/SQL, MVS JCL, Expeditor TSO ISPF, VSAM, Excel, MS Word, Change Man ZMF, File-Aide, Bugzilla, QMF

Confidential

Software Consultant

Responsibilities:

• Worked with system architects and DBA to identify table/column relationships for data mapping.
• Documented program required changes and assisted system architects with creating detailed functional specifications.
• Performed program analysis of company’s CIS Plus utility systems.
• Performed data mapping required to merge Aquila customer accounts with KCPL.
• Created new ORACLE tables using DDL.
• Created stored procedure/subroutine to perform validation processing.
• Coded Natural program logic with embedded SQL to access Oracle Database Gateway.
• Modified SQL queries using SQL, PL/SQL or SQL*Plus to execute simple data lookups.
• Updated SQL programs to extract, transform and load account data to ORACLE tables.
• Wrote ADABAS Natural program logic with embedded SQL to query account information to validate data was loaded correctly.
• Translated business requirements into technical program specifications.
• ADABAS Natural/UNIX/CICS Excel, MS Word, SQL, ORACLE SQL Developer, CIS Plus

Confidential

Senior Programmer Analyst

Responsibilities:

• Facilitated requirements review meetings with Business Analysts and Application Development Staff.
• Assisted BA with refinement of business requirements, business rules and reviewed Use Cases to create technical program specifications and develop unit test plans.
• Translated technical programming specifications into program code.
• Assisted Testers with creating test scripts and supported unit, integration testing.
• Met with Business Analysts and end users to resolve defects during user acceptance testing.
• Supported production system by meeting with end users, Business Analysts and technical support staff to identify root cause of system failure and provided detailed plan of action to correct and implement code change into production environment to correct the problem.
• Recommended program changes and system job JCL enhancements to increase system performance.
• Used IBM utilities to copy production data to testing environment.
• Created formatted reports using ADABAS Natural and COBOL.
• Worked with middleware developers to resolve issues by reviewing data mapping requirements.
• Provided on call development support during SDLC.
• Produced weekly status reports identifying tasks assigned, progress made and prioritized issues/problems.
• COBOL, MVS JCL, ADABAS Natural/CICS, Expediter, N2O, TSO ISPF, VSAM, Excel, MS Word, Change Man ZMF, File-Aide, Mercury Test Director