TECHNICAL SKILLS

IBM/DB2, IDMS, CICS, COBOL, IMS, Z/OS, OS/MVS, JCL, JES2, CRYSTAL REPORTS, FOXPRO, ORACLE, UNIX, SMP/E, HL7, UNIX SHELL SCRIPT, MICROSOFT SQL DATABASE, PS/QUERY, SQR, SQL, CA-IDMS 18.0, IMS, LRF, Microsoft Dynamics CRM 2011, JAVASCRIPT, HTML, PHP, SUNGARD SCT BANNER, LUMINIS, C/C , C SHARP, SOFTWARE TESTING, QUALITY ASSURANCE, RIBS, OMEGAMON, DMLO, ADSO, QA TEST PRO, DATABASE DEVELOPMENT, TCP/IP, ECLIPE, TSO, SPUFI, ESP, HTML, MYSQL, WORD, DOS, EXCEL, MICROSOFT OFFFICE, POWERPOINT, ACCESS, NOVELL, CLIST/REXX, CATALOG MANAGER, DASD MANAGER, DEGREEWORKS, MICROSOFT OFFICE, MICROSOFT VISUAL BASIC, FOCUS, SCRIBE, ROSCOE, PANVALET, XPEDITER, RESOURCE25, SAS, SAP, BMC, VSAM, LOTUS NOTES, LRF, SNA HEALTHCARE, TSO/ISPF, PRODUCTION INSTALLATIONS/IDMS, OS/MVS, OLQ, CULPRIT, MQ-SERIES, SAS,LOTUS NOTES

Employment History

Confidential

Senior Consultant

• Streamline practice solutions for optimizing software performance utilizing IDMS. Recommended a CA7 Scheduler package to perform IDMS backup and data recovery. Created new features designed to improve information sharing and communication with practice systems, suppliers, staff and clients. Also provided available functional tools which include sending automatic reminders by mail and/or email. Manage important client communications from the Cornerstone message center including appointment and prescription requests and updated client information. Made modifications to On-line screens and reports. Managing On-going technical support as Administrator.
• Assigned as a Computer Instructor to conduct self-paced multimedia CBT Computer Based Training for IDMS. To teach new programmers the basics of IDMS and ADSO this runs on WINDOWS/PC. The course covers database fundamentals schemas, storage mode, etc , central version fundamentals locking, journaling, commits, and recovery , database navigation area sweeps, entry points, many-to-many, bill of materials, etc . Separate module teaches batch COBOL IDMS programming.

Confidential

Senior Programmer Analyst

• Managed and provided leadership and direction on large technical project. The project is, however, restricted to the 14 Verizon States that were bought by Confidential. The project has an online portion that is written in PeopleCode. The database is DB2 ver 10.1. Most transaction data however comes from external systems and is fed into the system by mechanized feeds. These feeds then went through batch processes which were written in COBOL/SQR that populated DB2 tables. Responsibilities included troubleshooting all Peoplesoft Financials which included A/R, Billing, Project Costing, Asset Management, General Ledger, and Revenues, Payroll, Treasury, Labor hours etc.
• Examined DB2 tables to create SQL queries for immediate fixes. Strong technical knowledge in Sql queries, Peoplecode and application designer.
• Used XML ver 1.0 to help store, structure, and transfer data sent on the Internet for various End-users.
• Solely responsible for the Front-End system. This involves monitoring jobs in the Daily, the Monthly and the Month-End Close schedules to ensure that the critical processing paths are met. I diagnose all problems that occur in the processes, which includes both data and code analysis.
• Monitoring of the nightly batch schedule. This includes checking all condition codes daily to ensure that all jobs were successfully executed.
• Developed detailed technical documentation for solutions implemented in resolving production issues.
• Maintained the ESP schedule of financial jobs which contained daily, weekly and monthly jobs in addition to individual packs of financial data including payroll, labor hours, revenue, treasury, asset management, project costing, supply chain management, budgets and general ledger.
• Addressed all Service Level Agreements SLA s with no violations.
• Wrote investigative queries to resolve user investigations into how the system functions.
• Developed several queries to satisfy user requests and to ensure that the system was functioning as expected.
• Worked with Payroll lead to prepared Payroll implementation design document for presentation to clients
• Conducted Year-end processing on the FCS application.
• Performed analysis utilizing the Metadata Navigator for production errors.
• Investigated, classified, collected, and documented requested proposed procedural user modifications via standard requirements document.
• Coordinate and consult on departmental projects when there were data issues..
• Involved with critical business processing efforts which included monthly and year end closing.
• In addition to production support responsibilities, worked on a major conversion effort to re-write the PeopleSoft Financial applications in Infinium.
• Participation in mapping sessions with Infinum developers.
• Developing extracts of the system data in the formats required for Infinium conversion.
• Gathering Requirements
• Preparing Technical Design documents
• Conduct Design walkthrough meetings
• Prepare test cases, unit testing and a to z testing.
• Creating endeavor packages.
• Support the changes.

Confidential

Lead Programmer Analyst

• Contracted by IBM as a Lead Programmer Analyst to join a team for the Confidential project at Confidential Holdings in a COBOL, CICS, and DB2 environment.
• Installed AMI Meters Advanced Meter Infrastructure .
• Created a major critical DB2/COBOL Interface extract program by providing Customer and Meter data for a third party vendor.
• Extracted file SFTed to the third party vendor for their use in installing AMI meters, determining cross-dock locations, inventory purchase needs, and general route planning for maximum saturation of target areas.
• Created a DB2/CICS program to allow the users to enter client billing information and reconnection.
• Developed test plans to verify logic of new or modified DB2/CICS programs.
• Wrote the Systems Requirements and Technical specifications for this newly created interface.

Confidential

Senior Programmer Analyst

• Implemented an integrated computerized patient medical record and services system that offered immediate and cost-effective on-line worldwide access, storage, and retrieval.
• Extracted data from DB2 to ensure accuracy to view tables.
• Created testing on DB2 tables using File-aid.
• Worked with Payroll lead to prepared Payroll implementation design document for presentation clients.
• Developed documentation standards and procedures for the patient medical record system.
• Participated with learning the Ensemble platform for integration and development of newly connected applications.
• Participated on project, development and implementation of integration between Lenox Hill Hospital and several EMR/Hospital applications using HL7 ver 3.0 standards. Working knowledge with Oplink, integration engine. Experience in providing support of HL7 ver 3.0 for the exchange, integration, sharing and retrieval of electronic health information.
• Ability to monitor interface engine to safeguard uninterrupted message transfer between electronic systems.
• Contributed in integration development life cycle comprising validation, Testing and core review.
• Solid experience with TCP/IP, FTP, and SNA. Have a strong working familiarity of HL7 event types.
• Have a good working knowledge of different transaction formats such as HL7, fixed format, and delimited and XML.

Confidential

Enterprise Systems Engineer

• Supported the Blackboard system and hardware issues for the school.
• Configured, installed, and scheduled all enterprise class applications, as well as hardware in support of the applications.
• Provided support to the Luminous Portal.
• Interfaced with the Web Master in Java/SQL related issues using Oracle Database.
• Provided backup to other members of the team including desktop support, call center operations, and network management.
• Coordinate with Web master, Colleague Computing, Network Manager, and Network Engineer to implement key projects and integrate enterprise class applications and security systems across multiple environments.
• Managed databases storing key information for Administrative Computing projects.
• Monitored, patched, and troubleshot enterprise class applications.
• Recommended improvements, and resolved issues related to enterprise class applications
• Perform hands-on design and development for application enterprise class application which included code reviews and unit testing.

Confidential

Senior Systems Analyst

• Oversaw major conversion project from an IDMS platform to CICS/DB2 environment.
• Created program specifications for the NJ Kids interface project.
• Prepared technical specifications to include business rules and program logic to assist with the child support, domestic violence and matrimonial docket types.
• Created an extract program for the county jail department to extract data from the inmate/parolee history file and map the associated fields to the inmate/ parolee file layout. .
• Create and executed procedures to ensure all copybooks, triggers, stored procedures, and modules were migrated completely from test to production libraries.
• Ensured support of daily batch jobs/scheduler as well as troubleshooting problems during the testing phase and migration from IDMS to the DB2 database.
• Supported team members with problem resolution.
• Developed operational, financial and management reports through the use of Crystal Reports.
• Worked with business analysts to refine requirements and provide design options.
• Tested and analyze report performance and results
• Collaborated with other members of software development team on design of reporting data sets as needed
• Optimized efficiency of report performance through continuous improvement of the overall reporting infrastructure as needed
• Created new queries and reports in the BI 4.0 environment Query Designer/ WEBI/ Crystal Reports
• Queried and inserted new records into the production system for absent parents, relative, known address/county and alias information.
• Coded CICS/DB2 programs to process attorney information for scheduling proceedings and/or to associate/disassociate attorneys to a case.
• Created JCL, proclib and store procedures to support the NJ Kids interface project.
• Developed extract program to provide the department of human services in order to assist in the location of parent involved in child support case.
• Created Queries/Views from the DB2 database utilizing SQL/DML for accessing and manipulating data.

Confidential

Senior Programmer Analyst

• Provided technical support throughout the Confidential campuses utilizing IDMS/COBOL and Confidential Resource System.
• Provided production support to Confidential Platform.
• Created the Confidential Point of Sales interface to the IDMS Database system from 70 to 100 which is utilized by more than 150,000 students throughout the Confidential Colleges. Provided back-up support for administrative applications for the Confidential.
• Developed the extract process from legacy system to Blackboard for synchronization of Course/Instructor/Student data as an automated process.
• Conducted training sessions for Student/Staff/Instructor with the use of supported services.
• Prepared operational documentation for Computer Programs, Computer System and Computer Operations.
• Provided technical leadership of the POS system to the team.
• Consulted with users to implement systems enhancements to improve productivity / efficiency.
• Collaborated with Programmers on application specifications and system enhancements to ensure appropriateness of design.
• Developed technical specifications for the development of new computer systems and modifications of existing computer systems utilizing IDMS/COBOL. Provided, troubleshooting and problem resolution for major high risk/high impact critical applications.
• Provided support in MVS/z/OS. Troubleshoot production abends in scheduling and processing of jobs. Debug OS/MVS COBOL programs and system business issues as a production support analyst for the Confidential.
• Reviewed all incoming personnel/job changes for accuracy by verifying all job setup and changes against the computer system
• Setup, maintained, and verified the accuracy of employee tax withholding, direct deposit accounts and other payroll deductions on an ongoing basis.
• Involved in a lead role to design, code, test, implement and provide support to faculty, staff and students via components including course section enhancements, student disability data, financial payment processing and Office of Institutional Research data files.
• Designed an on-line registration system for the Confidential.
• Developed the Esims interface for meningitis power of attorney, transcript and bill presentation.
• Revised programs for corrections, enhancements, and system environment changes.
• Conducted DBA functions and support to the Data Warehouse project utilizing SQR for loading data into tables and coding IDMS programs to extract data from the IDMS database.

Confidential

Technical Support Consultant

• Provided direct support to resolve IDMS technical issues by answering phone and e-mail requests related to their use of supported software and services, and retaining ownership.
• Provided assistance on DB2/CICS production issues in resolving and recommending fixes.
• Assisted in the evaluation of new software/technology and make recommendations on how IT should support these products.
• Provided assistance to support Desk staff by assisting in problems resolution.
• Coordinated with vendor/clients regarding programs revisions.
• Oversaw rapid turnaround on severity issues by solving technical production problems immediately.
• Coordinated with DBA's and technical support staff world-wide in resolving IDMS/COBOL production problems related to Start-up/Shutdown, Broken chains, Corrupted database, unload/reload, programs, apars fixes, dumps etc.
• Delivered support/leadership to systems users..