SUMMARY:

Analytical information technology professional with extensive experience in systems analysis, project development, design, creating test plans, performance tuning and enhancing application systems seeking a position as a Systems Analyst, Application Developer, Business Analyst or Quality Assurance Analyst.

TECHNICAL SKILLS:

Languages: DB2/SQL, QMF, SPUFI, CICS/VS, COBOL/COBOL II, ORACLE/PLSQL, SYSTEMS DESIGN, MVS/OS/JCL, SHELL/LOADER SCRIPTS, CLISTS, REXX, HTML, EASYTRIEVE, NDM, FTPIMS, DB2/ORACLE STORED PROCEDURES, SAS, ORACLE

Software: TSO/ISPF, WEB SERVICES, FILEAID, XPEDITER, SYNCSORT, BMC, IOF, SDSF, TOAD, PRECISEUNIX, SQL PLUS, EXCEED/HUMMINGBIRD, ENDEVOR, SCLM, ACR, LOTUS NOTES, SPIFFYJES - MASTER, PANVALET, DFHSM, JOBSCAN, COMPAREX, IBM UTILITIES, EOS, SDLC, MAIRMDS, WFS2, UCC7, MVS, CMS, KEDIT, XEDIT, FLOW4, WINDOWS, ACCESS, DBXL, CEDF EXCEL, LOTUS 123, DOS, SDF2, NDM/DMBATCH, FTP, VISIO, STARTOOL, AUTOSYSPL/SQL, MICROSOFT MICROSTRATEGY REPORTS, WORDPERFECT, WORD, PLANVIEW, RATIONAL ROSE CLEARCASE, CHANGEMAN, INSYNC, MOVE FOR DB2

Hardware: IBM Mainframes, Sun Solaris/Unix

EXPERIENCE:

Confidential, Wethersfield, CT

Information Technology Analyst

Responsibilities:

• Team member responsible for enhancing and supporting the Licensing Systems
• Analyze/Code/Test Development of Central Issue Project deliverables
• Design/Code/Test Web Services/VSAM/CICS Cobol programs which interface with Morphotrust(MTUSA)
• Analyze/Code/Test Licensing JCL for SFTP changes
• Mentor new team members on Central Issue project
• Resolve QA defects
• Design/Code/Test JCL
• Design/Code/Test COBOL Online/Batch programs for file expansions
• Resolve Production/Test problems/abends
• Create/Modify Online Screens
• Document/Organize analysis
• Create/Modify copybooks

Confidential, Madison, WI

Programmer/Analyst

Responsibilities:

• Team member responsible for enhancing and supporting the Origination Portfolio Conversion systems
• Developed/coded/tested DB2 Cobol programs/JCL
• Created/Modified/Ran Production JCL/PROCS/SYSINS Arkansas conversion project
• Created JCL for Daily/Monthly enhancements
• Created Process Documents
• Created Technical specifications
• Created Test Plans and Test Results
• Documented/created new job flows
• Created new job schedules
• Resolved Production/Test problems/abends

Confidential, Farmington, CT

Consultant

Responsibilities:

• Team Member responsible for supporting the Unemployment Benefits Systems and team Lead for the contractors.
• Involved in systems analysis, functional design, specification writing and COBOL/DB2 coding for new application development, and maintenance of existing applications, for the mainframe Benefits systems.
• Worked very closely with business community in the analysis, design and testing phases of these projects.
• Analyzed impact to the Reimbursable/Tax system for legislation changes
• Improved stability of nightly batch cycle through analysis of Production abends and performance changes
• Documented all nightly Batch jobs using Visio
• Resolved Production/Test abends/problems
• Created System documentation

Confidential, Glastonbury, CT

Consultant, Billing System

Responsibilities:

• Team member responsible for the Batch design/update/testing of the Billing System.
• Developed/coded/tested DB2 Cobol programs
• Analyzed Billing system for new enhancements
• Updated/changed automated Balancing rules for the Billing application
• Supported Production implementation/Warranty period
• Documented outcomes of application testing
• Ran Billing Application Batch jobs for the Business Systems User(BSU)

Confidential, Farmington, CT

Team member

Responsibilities:

• Work with entire System Development Life Cycle including requirements definition, design specifications, test plans, quality assurance, implementation, release management
• Analyze current system for new enhancements
• Develop/code/test DB2 Cobol programs/Stored Procedures to handle flag/ICD9 procedure codes
• Coordinate testing with Web application and Back End Stored procedures
• Resolve Test problems/abends
• Support Production implementation/Warranty period
• Document outcomes of application testing

Confidential, Farmington, CT

Consultant

Responsibilities:

• Participated in Joint Application Development (JAD) on the IV - E project
• Analyzed Social Services data structures
• Developed/coded/tested DB2 Cobol programs/JCL
• Created/Modified/Ran Production JCL/PROCS/SYSINS for Database expansion
• Created JCL for Daily/Monthly Parallel test runs
• Developed Cobol/Eztrieve programs to validate data
• Documented/create new job flows
• Resolved Test problems/abends

Confidential, Rocky Hill, CT

Senior Data Programmer

Responsibilities:

• Team member responsible for landing, converting, and loading client data to the PXI warehouse (NDC).
• Developed/coded/tested SAS programs
• Quality tested and reported upon healthcare data being loaded into client warehouses
• Ensured complete testing of data against standard ETL rules and quality checks
• Ran reports and provide information to clients regarding data trends
• Documented outcomes of application testing
• Created/Ran extracts for clients

Confidential, East Hartford, CT

Information Technology Analyst

Responsibilities:

• Analyze programs/problems
• Develop/Modify staging/reporting/view tables
• Design/develop/test programs/data maps/data loaders/public queries
• Develop/maintain cybermation batch job control scripts.
• Develop/performance tune SQL statements.
• Address customers/functional subject matter experts to investigate/resolve data problems

Confidential, Glastonbury, CT

Consultant

Responsibilities:

• Developed/coded/tested DB2 Cobol/Exit Routine programs/JCL
• Created/Modified/Ran Production JCL/PROCS/SYSINS for Database expansion
• Created JCL for Daily/Monthly Parallel test runs
• Developed conversion Cobol/Eztrieve programs to convert to the new LossDB format
• Documented/created new job flows
• Created new job schedules
• Resolved Production/Test problems/abends
• Assisted RACF coordinator in establishing sub groups/access for team members
• Automated JCL for Email notification when Production jobs did not run

Confidential, Hartford, CT

Application Developer

Responsibilities:

• Team Member responsible for the design and development of the Consolidated Billing DB2 database. Provided support for the Data Migrator Member system.
• Worked with entire System Development Life Cycle including requirements definition, design specifications, test plans, quality assurance, implementation, release management
• Coordinated DB2 Test/Production regions with DBA
• Created Test/Production DB2 load jobs to populate the database
• Developed DB2 programs to reconcile the integrity of the database
• Developed/tested DB2 programs to purge erroneous data from database
• Ran/analyzed explain plan results
• Developed/tested DB2 stored procedures for Java Inquiry Tool
• Resolved Production/Test abends/problems
• Setup Production job dependencies
• Implemented/tested Automated Balancing and Reconciliation rules for DB2 load jobs
• Setup/coordinated DB2/Endevor/Dataset security access

Confidential, Hartford, CT

Associate Information Engineer

Responsibilities:

• Provided development and maintenance support for the Claim Data Warehouse. Also provided production and development support for the Specialty Auto system.
• Created/analyzed Oracle procedures/functions for the Claim Data Warehouse
• Created/updated Unix shell/loader scripts to extract/load data
• Ran/analyzed Oracle explain plan results
• FTP/unloaded Production DB2 data to Sun server
• Scheduled Production jobs thru Maestro
• Analyzed/designed technical specifications for warehouse/datamart/reports
• Analyzed programs/problems
• Created Clists to list/update DB2 information/RACF groups
• Resolved Production/Test abends/problems
• Analyzed DB2 performance using DB2 Explains
• Resolved/researched user requests
• Updated/created RACF groups/profiles
• Supported Production Oncall
• Mentored team members to use various tools and techniques
• Migrated Source code to Production
• Unloaded/loaded DB2 Production/Test tables
• Created/executed Spufi/Qmf to update Production data
• Scheduled Production jobs thru UCC7

Confidential, Woodbury, CT

Consultant

Responsibilities:

• Extracted/Copied Production data to Test data
• Created Test JCL/files
• Analyzed Batch/Online DB2 usage
• Aged Test data
• Tested Batch jobs/programs
• Compared Test/Production output files
• Remediated Batch report programs to include century
• Analyzed programs/problems
• Resolved Testing problems/abends
• Created System documentation

Confidential, Wethersfield, CT

Systems Developer

Responsibilities:

• Responsible for the conversion/rewrite of the Unemployment Benefits, Employer Wage Reporting and Stock Inventory systems.
• Designed/developed/tested Batch/Online screens/programs
• Developed/tested/Debugged JCL
• Converted Unisys programs/ECL to IBM programs/JCL
• Analyzed programs/problems
• Addressed user - research questions
• Extracted information for customers
• Tested Project Control Requests(PCR) for various systems
• Documented jobs/programs/problems