SUMMARY:

• A Business Intelligence Developer/System Analyst/Programmer with proficiency in system analysis and design, development, testing, implementation, enhancement, troubleshooting, and maintenance of existing programs.
• Extensive experience in reporting on different tools from Mainframe to Oracle, Qlikview, Business Objects, and Mainframe.
• Able to work independently and as part as a team to support multiple systems/projects.
• Adheres to established coding standards and adopt to the software development methodologies.
• Analyze technical requirements and pursue solutions to improve performance and achieve business objectives.
• Effective oral and written communication skills.
• Strong analytical, troubleshooting and problem - solving skills.
• Worked with business users to gather requirements and delivered them in a timely manner.
• Resilient in the face of competing priorities and a demanding workload.
• Team player with exceptional interpersonal skills and a desire to provide superior customer service to end users.

CORE COMPETENCIES INCLUDE:

• Mainframe COBOL/DB2/CICS/EASYTRIEVE PLUS in both VSE/ESA and MVS/ESA environments using VSAM,JCL,IDCAMS,Panvalet, TSO/ISPF,SYNCSORT/FILE AID,Intertest Support of Sharepoint 2013
• Oracle OBIEE/ BI Publisher(10g, 11g, 12c) reports creation, modification, and support
• Expertise in building reports using BI Publisher, building Complex Data Templates, data model, RTF / E-Text / Excel Templates
• Wrote and maintained ad hoc oracle queries for business users using TOAD.
• Oracle Report Access Portal(RAP) creation, modification, and support
• QlikView reports creation, modification, and support
• Oracle R12 Application Developer and maintained Oracle Discoverer reports using PL/SQL packages Business Objects reports creation, modification, and support On Demand Oracle custom report queries creation, modification, and support
• Oracle Discoverer Administration, Development and Support
• Mainframe COBOL/DB2/CICS/EASYTRIEVE PLUS in both VSE/ESA and MVS/ESA environments Quality Center, Citrix Putty, Winscp, SVN Subversion Client - Version Control Tool, Visual Source Safe, Harvest, Service Now,Clearquest

EXPERIENCE:

Confidential, West Caldwell, NJ

Senior Applications Developer

Responsibilities:

• Was a part of a team involved in maintaining and supporting the Mainframe home grown RBAS system in MVS/ESA using COBOL, COBOL 2, CICS, DB2 as, Sybase, SQL Programmer, EASYTRIEVE PLUS, IDCAMS, VSAM, JCL, Panvalet, Microsoft Access, Powerbuilder 9.0, Unix and Intertest.
• Coded new programs using COBOL/DB2/CICS (with execution JCLs and procs) and have done unit and system testing. I also did fixes brought about by documented requests submitted by users.
• Also responded to requests by Mainframe users either through report or the front end Mainframe application system issues.
• Was part of the a team primarily be responsible for the development, maintenance and support of an application in the mainframe environment using COBOL, CICS, DB2 VSAM, and JCL.
• Responsible for creating, modifying and providing technical support to business users of OBIEE / Oracle BI Publisher, Oracle Report Access Portal(RAP), On Demand Oracle custom report queries sourced in Oracle R12/11i Order Management, Inventory Control, Supply Chain, Purchasing, Install Base, Service, Contracts and Finance for Sharepoint 2013 using Visual Studio 2013, I provided technical support for the business.
• Performed day to day production support activities like addressing user queries and report issues.
• Used Oracle 11i and R12 front end application to validate queries, trouble shoot and investigate business user complaints.
• Created, modified and provided technical support for the business users of Oracle Discoverer 4i and 10g, and 6i reports with PL/SQL packages. Developed, tested, and supported Concurrent Programs in PL/SQL packages accomplished during Oracle Discoverer development projects, ran on demand reports upon request or responded to emails or calls periodically with Discoverer Plus issues.
• Developed, maintained and supported the business users of Qlikview and Business Objects.

Confidential, Piscataway, NJ

Programmer Analyst - Mainframe

Responsibilities:

• Was a part of a team of developers that worked a team for the new system in MVS/ESA using COBOL 2, DB2, IDCAMS, VSAM, JCL and FILE-AID, FILEAID for DB2, EXPEDITER for both BATCH and CICS.
• Coded new programs (with execution JCLs and procs) and have done unit and system testing with test plan documentation.
• Attended both specs and code inspections which help the system to see problems before going to production and to ensure high degree of adherence to the company’s standards.
• Also responsible for production support and system maintenance.
• Supported the data quality effort by collecting data on source and error files.

Confidential, Bridgewater, NJ

Systems Analyst/ Programmer - Mainframe

Responsibilities:

• Involved with Year 2000 project in DOS/VSE using COBOL, COBOL 2, IDCAM, VSAM, ACCUCHECK, and aging tool.
• Performed remediation, revisions, and testing including windowing technique for Baseline, Regression and Y2K.

Confidential, Makati, Philippines

Systems Analyst/ Programmer

Responsibilities:

• For a Major Software Developer, as a Systems Analyst Programmer, was involved with Year 2000 project in MVS/ESA and DOS using COBOL 2 and IBS SOLUTIONS 2000.
• Performed impact analysis to determine which fields should be tagged for conversion.

Confidential

Systems Analyst/ Programmer

Responsibilities:

• For a Major Software Developer, as a Systems Analyst/Programmer, was involved in the development of the Financial Management System (FMS).
• This was the financial part of the Systematics retail banking system using IBM ES/9000 running on MVS/ESA using COBOL2/CICS, COBOL2/VSAM, JCL, IDCAMS, and FILE-AID.
• Coding, debugging and testing of batch programs.
• Prepared JCL to compile and run programs.
• Coordinated with members of other application systems for test and actual interface.

Confidential, Makati, Philippines

Systems Analyst/ Programmer

Responsibilities:

• For a Major Bank, as a Systems Analyst/Programmer, was involved in the development of the Accounts Profitability Analysis System. This system aids in decision making regarding clients using IBM ES/9000 under MVS/ESA with COBOL/DB2 and JCL. Duties included: Analyzing, coding, debugging, and testing of batch programs; Prepared JCL to compile and run batch programs. Provided support to user queries arising from problems encountered from the system.
• Another project was the development of the Payroll System. This takes care of the salaries/benefits of employees using IBM ES/9000 MVS/ESA with COBOL/DB2, SPUFI and JCL. Responsible for revision and testing of batch programs. Provided standby support for production run.
• For the same company, as a Systems Analyst/Programmer, was involved in the development of the Field Unit General Ledger System. This was the stand-alone system for Land Bank using PC under Windows 95 with Powerbuilder and Watcom SQL. Responsibilities included: Analyzing, coding, debugging, and made enhancements to existing application programs. Tested system for errors. Provided user support and submitted related documents.

Confidential, Manila, Philippines

Systems Analyst/ Programmer

Responsibilities:

• For a Major Bank, as a Systems Analyst/Programmer, was involved in developing the current retail banking system implemented using IBM ES/9000 under VSE/ESA with COBOL/VSAM, EASYTRIEVE PLUS, JCL, SYNCSORT and IDCAMS.
• Coding, revision and testing of batch programs.
• Prepared JCL to compile and run batch programs.
• Documented production run.
• Provided user support.
• Provided on-call support and troubleshooting to production run.