Information Technology Analyst Resume
Wethersfield, CT
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