INFORMATION TECHNOLOGY PROFESSIONAL

Qualified IT professional with experience as an application developer and production support within multiple large organizations in the fields of banking, health insurance, having extensive knowledge in application development, and customized, and packaged-based projects. My experience includes working across multiple development groups and business areas. Assisted in installing WEB server application software, front-end testing working with clients. My logical approach and attention to detail ensure successful compliance for change and problem management, including root cause analysis.
Proficient in writing SQL/DB2 queries and developing programs, scripts, and parameters to retrieve data from various sources and prepare data for analysis and verification of data accuracy. In addition experience using SQL for reporting, queering and updating processing across multiple databases.
Coordinated and participated in the testing of new applications and releases of software working with clients for processing and data verification. Testing of application included unit, system, and regression manually and creation of scripts. I have directed various projects, involving between 2- 4 people.

Lead Programmer / Analyst DB2 / SQL / QMF / SPUFI / MYSQL

Requirements Gathering / Data Mapping SQL Queries / Load / Unloads

System Development Life Cycle Microsoft Outlook / Lotus Notes

Project Management & Methods/Six Sigma Microsoft Word Access Excel Visio PowerPoint

Agile/Scrum Methodology Process ISPF/ SYNCSORT / File-Aid / NDM / FTP

SERENA / Peregrine System / Endevor TSO / ROSCOE /Abend-Aid / Expeditor / SAR

NDM / FTP / SYNCSORT / File-Aid COBOL / JCL / CICS / VSAM /IDCAM / ISPF

SOFTWARE

CA 7/11 Scheduler, OS/VSE/MVS, BMS, SDF, WINDOWS, MS WORD, EXCEL, ACCESS, POWERPOINT, Lotus notes, Visio Siebel, OLDS, Trust Accounting System (TAS), SUNGARD, SEI Financials, Blue Cross Blue Shield Association; Federal Employees Program. UNIX, OOP,

HARDWARE

Platforms: Windows 95/98/2000/XP/VISTA, IBM MVS/XA; MVS/ESA; MVS/SP; OS/390; z/OS

EDUCATION & TRAINING

• Oracle 10g SQL/PL-SQL, Oracle 10g: Administration I & II
• Crystal Rporting XI, Intermediate MS Project, MS SQL
• Microsoft Access Advanced

Associates Degree Corporate Management

Attending classes to earn my Bachelor's Degree in Corporate Management

Associates Degree Programming with Business Procedures

PROFESSIONAL EXPERIENCE

Confidential, (Consulting) 02/10 - 02/10
Graftech International - contracted at clients site, documenting COBOL programs and structure
flows for conversion to a new CRM application, technical reporting of data flow documentation.

Confidential, (Consulting) 12/09 - 12/09
Mentored an Individual with DFAS in COBOL, in a structured programming environment.
Including data handling and verification and JCL creation and job processing within in a structured environment.

Confidential, Strongsville, OH 05/2008 - 12/2008
Lead Programmer Analyst

• HP3000 - Analyzed, developed, modified and tested programs, COBOL, VSAM files and FORMSPEC
• Updated file handling and application processing efficiencies for payroll application system.
• Worked with internal clients modifying screen structure and information availability and accessibility.
• Worked with management to understand and gain experience of the complete payroll processing system.
• Testing of application included unit, system, and regression manually and creation of scripts.
• Microsoft Access, Excel, Visio, PowerPoint on various projects.

Confidential,Cleveland, OH 08/2006 - 05/2008
Lead Programmer Analyst

• Use ofAgile/Scrum Methodology Process.
• Siebel CeDesktop CRM, as a 2nd tier support person working with clients and relationship managers. The Siebel application and many applications submitting data files to be loaded in the DB2 database - duties included a thorough analysis of IR's (Incident Report) and CL's (Change Logs projects) and data fixes to main Siebel tables; data fixes included use of direct SQL updates to the tables, also through programs, parms and analysis and use of DB2, SQL, SPUFI, MYSQL, COBOL, COBOLII, JCL, Microsoft Access, Excel, Visio, PowerPoint, Endevor. Produced SQL and Access Ad hoc reports per Client requests, installed projects and fixes using the Changeman and Peregrine System processes. My logical approach and attention to detail ensures successful compliance for change and problem management, including root cause analysis. Siebel CeDesktop CRM GUI front-end tested and verified data and processes. (Training Siebel Application)
• Mentored an Individual at Key Bank in SQL structure and use of queries and functions of job processing DB2 and SQL used in programs and Ad Hoc scripts across multiple types of databases.
• OLDS On-Line Delivery Systems Development/ Support Group; new and existing COBOL2/DB2/SQL/CICS JCL/CICS programs for processing efficiencies and usage for multiple tables across Banks, in production and test. Used BMC tools for loading/unloading tables for testing of programs and CICS screen usage.
• Worked and coordinated with the DBA on establishing the reorganization of DB2 tables; modified existing CICS screens for client usability and for additional information. Use of TSO, CA Scheduler Job Management.

Confidential, Cleveland, OH02/2000 - 07/2006
Applications Developer II

• Project Services - Consumer Finance Area, Six Sigma Methodology used by division Analyzed, developed, modified and tested programs in COBOL, CICS, DB2, SQL, SPUFI, Microsoft
  Access, Excel, Visio, PowerPoint, use of TSO, CA Scheduler Job Management
• Assisted in the install of WEB server applications software and front-end testing, working with the client areas including; Foreign X-Change, Disbursement Systems GUI front-end tested and verified
  data and processes. Positive-Pay a Bottom-Line Application, Xact4Web GUI front-end tested and verified
  data and processes. Developed and installed programs for the following applications but not limited to,
  the Small Business area, Safety Deposit, Multiple reporting and updating DB2 - Data Warehouse projects.
• Developed multiple programs for Dealer Reserve Application using COBOL2/JCL/DB2/SQL and the ACH process and developed & directed install of the project across applications areas using Excel for project coordination. Played a major role in the install and conversion of the CACS collection system application
  using DB2/SQL/CICS/COBOL/JCL, working with a third party vendor application and team; involved with projects that used the NDM process, to and from the mainframe and servers & installed projects
  and fixes using the Changeman/Peregrine System. (Training in DB2/UDB and Advance DB/UDB)
  

Confidential, Cleve OH 11/1998 - 02/2000
Programmer/Analyst

• Roadway Trucking - analyzed, modified and tested existing COBOL, COBOLII, COBOL370, JCL batch programs and expanded customer sales number from 4 to 6 positions throughout the Sales System. Converted existing COBOL programs to COBOL390 for Y2K compliance
• East Ohio Gas - analyzed, modified and tested existing COBOL, COBOLII, and DB2 batch programs to convert for year 2000 (Y2K) compliance - the Credit Sub system processed updated and reported and updated processing on the delinquencies and bankruptcies application. Use of TSO, CA Scheduler Job Management.