Sql Developer Resume Profile
Cobol Developer
Skills
Current Hands-on COBOL Coding Experience |
Experience in SQL |
Experience in JCL, PROC, Batch and online environment |
Enterprise Application Design and Construction using complete SDLC |
Production Support for Mission Critical Applications |
Experience with Adabas / Natural |
Experience developing, designing, and testing financial applications in mainframe environment. |
Experience creating test cases and conducting unit testing. |
Employment History:
Confidential
Employee/Consultant/Senior Programmer/Analyst
Trade Confirmations Local Bills System
- Senior Programmer Analyst in a COBOL DB2 Mainframe environment. Responsible for developing technical specs, writing new programs, enhancements to existing programs, in CICS and batch. I was responsible for developing the String Test Strategy document and the String Testing test cases. Completely involved in the initial, intermittent and final phases i.e., Development, Testing and Maintenance.
- T his includes supporting the testing effort on highly complex applications ensuring system quality standards is met by planning, designing and executing the appropriate test cases
- Modified the DB2-based disclosure rules, performed trade transactions data analysis to check the accuracy of trade confirmations, created new and revised existing COBOL/DB2 application programs, performed unit, QA and user acceptance testing UAT . Updated JIRA for final user approval. Preparation of JCL's for newly developed batch programs. This system generates disclosure information on the trade confirmation statements based on information in the trades file. At least 15 million trade transactions are processed daily by this system.
- This project provided Production support for the batch Online environment for all the brands. The enhancements to the systems were done based on the customer survey and the client needs. A Full System Development Life Cycle SDLC process was used.
- Transaction Management/Correspondence Clearing System. Performed CICS and ADABAS installations.
- Performs analysis, design, development implementation and support of Enterprise Data Warehousing applications including Data Stage and ETL utilizing COBOL ILE with embedded SQL, DB2
- Updated COBOL/DB2 application programs and performed unit, QA and user acceptance testing UAT . online program, batch program, flat file system, hierarchical file model database, job control language.Added columns to the trade transactions data warehouse tables. This system process daily trade transactions from different systems and routes it to other systems for further processing.
- Asset Transfer Control System ATCS
- Updated COBOL/CICS/MQ/DB2 application programs and performed unit and user acceptance testing UAT . This is a system with a web-based front end and mainframe-based back end that processed and approved the transfer of assets, both securities and cash, to client and internal general ledger accounts. ATCS utilizes a supervisory work flow approach coupled with e-mail notification and on-line reporting to provide managerial control and reduce the risks that can be associated with the transfer of assets.
Environment: z/OS, COBOL, DB2, CICS, FILE MANAGER, FILEAID, ENDEVOR, DEBUG, INTERTEST, MQ Series, COMPAREX, DEBUG
Confidential
Senior Programmer/Analyst
- Human Resources Information and Benefits System
- Performed systems analysis, created functional and technical specifications, prepared test plans, revised application programs and handled unit and user acceptance testing UAT . Updated SDLC for final user approval. This system enabled the Human Resources Department to keep track of employee personal information and benefits 401K, Stock Plans, Wealthbuilder, Medical, Dental, Vision .
- Provided support in Unit testing, System testing and Integration testing. Created numerous test plans and processed a large amount of loan applications to verify system enhancements. Designed test scenarios and data and executed test cases. Validated test results and records and researched defects. Prioritized, defined and managed defect reporting and resolution.
- Modified SQL Queries to substantially reduce CPU usage resulting a substantial savings for the users. Involved in developing in stream and cataloged Procedures in JCL as per the requirements.
- Provided Analysis, Design, Development, Maintenance, enhancements and Production Support for the project.
- I was responsible for resolving abends, DB2 problems, CICS issues, promotion issues, scheduling conflicts, JCL syntax errors, COBOL coding errors, and when necessary contacting the IT subject area exper
- Write new/modify JCL's, PROC's and PARM's. Write new/modify code as per design using languages like JCL, COBOL, VSAM, CICS and database calls to DB2. Created Generic COBOL programs and JCL Procedures PROC s to Allocate and Distribute Restitution amounts for different Omnibus Dealers.
- Coordinated the conversion of the HR system to CICS/COBOL/DB2 from CSP/DB2 in 2004 with a foreign-based outsourcing company. Explained to the users during testing the capabilities that they will lose because of the conversion. Explained to the foreign-based developers the system capabilities that they missed during the re-coding. This enabled the HR department to reduce software maintenance cost without drastically affecting HR system functions.
- Performed systems analysis then developed a Y2K patch in 1999 that enabled the HR department to use the online system beyond year 2000.
Environment: z/OS, COBOL II, CSP, DB2, CICS, COMPAREX, FILEAID, CHANGEMAN, SDLC, INTERTEST.
- Communications Management System CMS
- Performed systems analysis, created functional and technical specifications, prepared test plans, revised application programs and performed unit and user acceptance testing UAT . Updated SDLC for final user approval. This system enabled Citigroup to maintain a central repository of telecommunications and desktop related expenses. It also enabled the company to chargeback the expenses to the appropriate department.
- Environment: IBM ES9000 utilizing MVS, COBOL II, CICS, VSAM, CHANGEMAN, SDLC.
- Websites: HR Weekly, New Baby Gift, HR Control, Fitness Website
- Coordinated with the users in developing content for a web-based system that updates employees about company benefits and events.
Environment: ASP, HTML, DREAMWEAVER, ADOBE PHOTOSHOP, PVCS, SQL Server, SDLC.
Confidential
Consultant of Reliance Consulting Group
- Vanguard Advanced System
- Administered the baseline online test cases using PLAYBACK, compared online output files during the 19XX and 20XX testing using COMPAREX, prepared the online environment for user testing UAT .
Environment: IBM ES9000 utilizing MVS, COBOL, COBOL II, CICS, INTERTEST, PLAYBACK, COMPAREX, AFCS, DB2.
Confidential
Policy Management System
- Revised application programs to make them Y2K compliant. Made 200 existing JCL s portable by using symbolic parameters.
- Contingent Commissions System and Financial Accounting Repository FARE System
- Developed and maintained COBOL II/DB2 programs that enabled the company to determine insurance commissions.
Environment: IBM ES9000 utilizing MVS, COBOL II, DB2, QMF, VIASOFT, FILEAID, COMPAREX.
Confidential
- Teller Productivity Data Warehouse System
- Developed and maintained COBOL II/DB2 programs that enabled the bank to determine the volume of transactions for each branch teller and ATM.
Environment: IBM ES9000 utilizing MVS, COBOL II, DB2, QMF, VSAM
Confidential
Systems Programmer/Analyst