Senior Consultant Resume Profile
Bronx New, YorK
Summary:
- Over 17 years of experience in the Information Technology field.
- Expertise in IBM Mainframe environment using COBOL/CICS/DB2/VSAM/JCL.
- Excellent experience working on COBOL, Z/OS, JCL etc.
- Worked in Projects involving Java Front-End and Mainframe CICS/DB2 Back-end.
- Excellent experience in managing team.
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,
Work Experience:
Confidential
Senior Consultant
Responsibilities:
- 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.
- Responsibilities included troubleshooting all Peoplesoft Financials.
- Designing and developing or modifying programs based on COBOL, CICS, DB2-COBOL, coding necessary batch JCL and PROCS as per the user requirements.
- Experience developing IBM mainframe applications in COBOL.
- Planning, management and execution of projects to upgrade to new releases of z/OS and installed subsystems
- 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
Responsibilities:
- Managed and provided leadership and direction on large technical project. The project is, however, restricted to the 14 Verizon States that were bought by Frontier. The project has an online portion that is written in PeopleCode. The database is DB2. 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. Hands on experience with COBOL, JCL, Easytreive, SQL, IMS/DB, IDMS, MQ Series,
- 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.
- Streamline practice solutions for optimizing software performance utilizing IDMS.
- Experience working under HIPAA environment.
- 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.
- Systems Automation projects for z/OS operations, CICS, DB2 and IMS work flow and applications support.
- Developed detailed technical documentation for solutions implemented in resolving production issues.
- 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.
- 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
Responsibilities:
- Contracted by IBM as a Lead Programmer Analyst to join a team for the ADSI project at Pepco 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.
- Create Modify and Test COBOL, DB2 and CICS programs and JCL Jobs and Proc's per the technical design documents.
- Experience working in CA-IDMS.
- 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.
- Software design and development using z/OS MVS and USS services to provide quality software for commercial program products, z/OS and subsystem exits, conversion programs, applications, required tools, ISPF and batch utility programs.
- 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
Responsibilities:
- 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.
- Experience developing and/or maintaining server based batch processes that promote data feeds/exchanges between Oracle and IDMS environments
- Experience working under HIPAA environment.
- In addition to production support responsibilities, worked on a major conversion effort to re-write the PeopleSoft Financial applications in Infinium.
- Design of z/OS security procedures, compliance reports and tools for administrators and auditors.
- Participation in mapping sessions with Infinum developers.
- Developing extracts of the system data in the formats required for Infinium conversion.
- Developed many programs batch online using COBOL, DB2, JCL, CICS, MQ Series.
- 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.
- Experience working in CA-IDMS.
- Developed stored procedures, Functions, and Triggers in PL/SQL
- 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
Responsibilities:
- 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.
- Experience developing IBM mainframe applications in COBOL.
- 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 backup to other members of the team including desktop support, call center operations, and network management.
- Involved in writing and executing Stored Procedures, Functions, and Packages in PL/SQL.
- Provide real time reports to the Financial advisors.
- Converted In-stream JCL into CATALOG Procedural.
- 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.
- Analysis and design of the security configuration to protect all z/OS based systems and applications.
- 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
Responsibilities:
- 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.
- Experience developing IBM mainframe applications in COBOL.
- 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
- Managed the non-straightforward upgrade of back level z/OS systems
- 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
Responsibilities:
- Provided technical support throughout the 16 City University campuses utilizing IDMS/COBOL and SCT Banner Human Resource System.
- Created the NCS Point of Sales interface to the IDMS Database system from 70 to 100 which is utilized by more than 150,000 students throughout the 16 City University CUNY Colleges. Provided back-up support for administrative applications for the City University Central Office.
- 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.
- Code changes primarily involved COBOL, JCL, DB2 and VSAM.
- 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 City Universities Campuses.
- 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 CUNY School of Law.
- 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
Responsibilities:
- 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.
- Experience working on complex financial based applications
- Assisted in the evaluation of new software/technology and make recommendations on how IT should support these products.
- Experience in working batch processing using JCL, IDCAMS.
- 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.