SUMMARY:

• Extensive experience in Client Server and Mainframe environment.
• Experienced team player at all organizational levels.
• Responsible, flexible, highly adaptable and willing to learn new concepts and methods of operation.
• Proven ability to work effectively and accurately.

TECHNICAL SKILLS:

Operating System: OS390, MVS, VM, CMS, DOS/VSE, RDOS, UNIX, AIX, HP - UNIX, VI and Windows (XP, 2000, NT).

Applications: Retail and Warehouse Management, Business Entity Tax, Calwin Welfare, Financial & Cost Accounting, Loan, Inventory Control, BOM (Bill Of Material), Purchase, Fixed Assets, Payroll, Human Resources, Insurance and Confidential .

Database: DB2, INFORMIX, ORACLE, IMS DB/DC, ADABAS, ACCESS, FOXPRO, VSAM and DBAM.

Language: COBOL, MicroFocus COBOL, Net Express 5.1, INFORMIX-4GL, Focus, SQL, PL/SQL, ESQL/C, PL1, NATURAL, SAS, JCL, IFPL, KornShell and CogniShell Scripts.

Technique: Hierarchical Database Design, Relational Database Design and Modeling with a heavy emphasize on Referential Integrity, Structured Methodologies, System Testing, and Quality Assurance.

Tools: ISPW, Maestro, Toad, CA7, Total View, CICS, ENDEAVOR, SYNCSORT, FILEAID, EXPEDITER, SDSF, QMF, PANVALET, SELCOPY, MKS, Change Management, Incident Management, FTP, Remedy, Excel, Word, Lotus Notes, Tuxedo, Microsoft Outlook, OLAP Reporting (QBEX), Autosys/Cron, IBM Now Problem Management and Artemis Timesheet.

Hardware: IBM AS400, IBM Mainframe, SUN, HP 9000, Data General, and Personal Computers (Novell, DOS, Windows).

PROFESSIONAL EXPERIENCE:

Mainframe Developer

Confidential

Responsibilities:

• Analyzed existing code based on high-level integration requirements.
• Wrote new program and modified the existing batch and online programs to create and process new loans.
• Integrity tests and Quality Assurance for external and internal relations.
• Shared knowledge of application programs and development tools with new team members.

Platform Specification: COBOL, CICS, VSAM, IAM, JCL, Z/OS, ENDEAVOR, DFSort, FileAid, Excel, Word, Windows10.

Mainframe Developer

Confidential

Responsibilities:

• Analyzed existing code based on high-level integration requirements.
• Modified the existing programs and wrote the new programs to process corrected and recycled transactions as they are completed in the online system and allow further corrections within the same work cycle.
• Integrity tests and Quality Assurance for external and internal relations.
• Maintained DB2 Stored Procedures.
• Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.
• Shared knowledge of application programs and development tools with new team members.

Platform Specification: COBOL, DB2, CICS, SQL, JCL, Z/OS, DFSort, FileAid, XPEDITER, ISPW, Excel, Word, Windows7.

Analyst / Developer

Confidential

Responsibilities:

• Analyzed existing code based on high-level integration requirements.
• Performed Analysis of business requirements to improve the business process of existing systems.
• Developed Micro Focus COBOL/Oracle code based on design.
• Provided support by ensuring stability of the application, addressing and resolving the issues in a timely manner.
• Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.
• Shared knowledge of application programs and development tools with new team members.

Platform Specification: Micro Focus COBOL, Net Express (5.1), Oracle (V11), Informix, HP-Unix, Toad, Tuxedo, Windows and Incident Management.

Analyst / Developer

Confidential

Responsibilities:

• Analyzed existing code based on high-level integration requirements.
• Prepared design document based on analysis.
• Developed COBOL/DB2 code based on design.
• Prepared jobs (JCL) based on design.
• Created and Maintained DB2 Stored Procedures.
• Developed DFSort /Icetool based file joins and reports.
• Developed secure FTP scripts based on State's security requirements.

Platform Specification: COBOL, DB2, CICS, SQL, JCL, Z/OS, DFSort, Excel, Word, Windows XP/7, Change Management, ZEKE and Infoman.

Production Support Analyst

Confidential

Responsibilities:

• Performed Analysis of business requirements as offshore team lead to improve the business process of existing systems.
• Prepared Document of Understanding for RRC and JRC Application Systems.
• Provided support by ensuring stability of the application, addressing and resolving the issues in a timely manner.
• Created and maintained Stored Procedures for Informix Database.
• Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.
• Shared knowledge of application programs and development tools with new team members.

Platform Specification: AIX (V5.3), INFORMIX (V10.0), INFORMIX-4GL, MicroFocus Cobol, SQL, AIX/Unix Scripts, INFORMIX tools, Access, Excel, Word, Lotus Notes, Windows XP, Change Management, Incident Management, JIRA and SHARE.

Finance Analyst / Production Support Analyst

Confidential

Responsibilities:

• Responsible for monitoring all daily, weekly, monthly, quarterly and yearly interface jobs that flow through FMS on a daily basis.
• Analysis and resolution of problems resulting from the running of these jobs or processes during business hours and in the off-hours, whether they are of a technical nature or are data-related.
• Provided day time and after hours support for Financial Management Systems especially General Ledger System.
• Worked closely with our Confidential client’s through-out the bank resolving issues.
• Coordinated system/process changes with technology and business partners.
• Assisted with job scheduling (CA7) to meet the requirements of clients, and responding to their requests for information.
• Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.
• Extracted, transformed, organized and load data from Mainframe Environment to PC and vice versa.
• Prepared process documentations and migrated to Standard FPS Process Template Documentation provided by TDBFG.
• Shared knowledge of application programs and development tools with new team members.

Platform Specifications: MVS, TSO, ISPF, COBOL, DB2, Access, SQL, SAS, VSAM, JCL, QMF, CA7, Total View, Incident Management, Change Management, Access, Excel, Word, Microsoft Outlook and Windows XP.

Senior Software Developer

Confidential

Responsibilities:

• Performed Analysis of business requirements to improve the business process of existing systems.
• Wrote detailed description of user’s needs, program functions and prepared designed documents ensuring proper IT standard are followed.
• Maintained application through the life cycle of systems.
• Provided support by ensuring stability of the application, addressing and resolving the issues in a timely manner.
• Created functional design & test cases and regression testing.
• Developed new programs as well as enhanced existing programs (INFORMIX-4GL, PL/SQL, MicroFocus COBOL) and promoted to production.
• Created and maintained Stored Procedures for Informix and Oracle Databases.
• Maintained Sarbanes Oxley Compliant documentation.
• Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.
• Shared knowledge of application programs and development tools with new team members.

Platform Specification: AIX on AS400, DB2, ORACLE, INFORMIX, INFORMIX-4GL, INFORMIX tools, MicroFocus COBOL, SQL, PL/SQL, ESQL, Focus, KornShell Scripts, Access, Excel, Word, Lotus Notes, Windows 2000, CA7, MQ Series, IBM Manage Now Problem Management And ArtemisTimesheet .

Technical Consultant

Confidential

Responsibilities:

• Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.
• Shared knowledge of application programs and development tools with new team members.

Platform Specification: UNIX (HP9000, Sun), VI, INFORMIX, MicroFocus COBOL, SQL, ESQL/COBOL, Informix tools, Maestro, Tuxedo, KornShell and CogniShell Scripts, Change Management,MKS, FTP, Remedy, and Windows 2000.

Programmer Analyst

Confidential

Responsibilities:

• Developed a detailed knowledge of the application systems, especially the order processing, production and inventory control modules.
• Supported Financial Control Systems (Account Payable, Credit Management and General Ledger).
• Developed numerous new programs as well as enhanced existing programs. By careful testing and release of new and enhanced programs, avoided any business interruptions.
• Added the capability of e-mailed reports and Excel-importable files. Many of these are available by menu picks while others are produced by automated processes.
• Created and maintained Stored Procedures for Informix Database.
• Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.
• Maintained the application programs and menus on seven distributed production servers and the development server.
• Shared knowledge of application programs and development tools with new team members.

Platform Specification: UNIX (HP 9000), VI, Informix tools, INFORMIX, INFORMIX-4GL, SQL, OLAP Reporting (QBEX), KornShell Scripts, Autosys/Cron and Windows XP.

Programmer Analyst

Confidential

Responsibilities:

• Maintained, enhanced and supported application systems after Y2K changes.
• Supported Automobile Exhibit System (AIX), Automobile Exhibit System for Quebec (AQX), Commercial Liability System (LIA), Property & Casualty (CAS) and Charge Back System (CBS).
• Identified and trouble shouted the specific problem areas including program debugging.
• Analyzed old Charge Back System for new design and develop with Visual Age Generator.
• Developed the new programs (COBOL & SQL) and tested them.

Platform Specification: OS390, MVS, TSO/ISPF and Windows NT at the desk, DB2, ADABAS, VSAM, COBOL, SQL, NATURAL, CICS, JCL, FILEAID, SDSF, QMF, SYNCSORT and PANVALET.

Technical Project Manager

Confidential

Responsibilities:

• Designed Financial Systems using Structured Methodology
• Developed Budgeting, Financial Accounting and Payroll systems.
• Created logical ERD.
• Designed logical database.
• Integrity tests and Quality Assurance for external and internal relations.
• Exported and converted from COBOL / MVS environment to Informix database on a Unix Solaris platform.

Platform Specification: UNIX (Solaris), VI, INFORMIX, INFORMIX-4GL, Informix tools, SQL and Microsoft Project for Windows 95.

Systems Analyst / Programmer Analyst

Confidential

Responsibilities:

• Analyzed, designed, implemented, tested and supported Purchase, Bookkeeping, Fixed Assets and Accounting systems.
• Designed database (logical & physical), including implementing and testing.

Platform Specification: UNIX (SCO), VI, NOVELL, DOS, INFORMIX, INFORMIX-4GL, Informix tools, SQL and FOXPRO.

Systems Analyst / Programmer Analyst

Confidential

Responsibilities:

• Maintained, enhanced and supported Fixed Assets, Financial and Cost Accounting systems.
• Designed, implemented, tested and supported BOM, Inventory Control, Human Resources, and Payroll Systems.
• Designed logical and physical database.

Platform Specifications: MVS, TSO, ISPF, COBOL, DB2, CICS, VSAM, SQL, JCL, ENDEAVOR, FILEAID, QMF and SYNCSORT.

Systems Analyst / Programmer Analyst

Confidential

Responsibilities:

• Designed and developed and maintained and supported Confidential .
• Designed data structures and files.
• Implemented the constructed codes and insured the data accuracy through testing.

Platform Specifications: DOS/VSE, VM, CMS, IMS DB/DC, DB2, COBOL, PL/1, JCL, XENIX, NOVELL and DOS.