Sql Maintenance
Resume:
JUAN FELICIANO
Davidson, NC 28036
Home: 704-***-****
Cell: 704-***-****
Email: ***********@***.***
Professional Summary:
A result-oriented individual with proven expertise in systems development and programming.
Over twenty five years of IT experience.
More than ten years of experience using Oracle, PL/SQL, SQL Plus, SQL Loader.
Experience in supporting web-based applications.
Demonstrated ability to learn and utilize emerging technologies.
Ability to manage user requests and task priorities.
Possesses excellent communication, inter-personal, and analytical skills.
Education:
Bachelor of Science in Computer Science
University of the City of Manila, Philippines
Technical Profile:
Languages
PL/SQL, NATURAL, JCL
Object Oriented Languages
J2EE, WebObjects/Java, HTML, JavaScript, XML
Databases/RDBMS
Oracle, ADABAS, Foxpro, Clipper
Tools/Utilities
PL/SQL Developer, TOAD, SQL Developer, SQL Plus, SQL Ultra Edit, Navigator, SQL Loader, Subversion, Predict, Construct, EntireX, N2O, CICS, TSO, CMS, Eclipse, Visual Source Safe, Start Team
Operating System
z/OS, MVS/XA, MVS/ESA, VM/ESA, Unix, Windows
Professional Experience:
Client: Wells Fargo, NC Oct 2014 – Present
Contractor
Environment: PL/SQL, Oracle, SQL Loader, Perl, Unix, Subversion, PL/SQL Developer
A member of the development team that supports the Enterprise Collections and Recovery (ECaR) application. Worked on numerous projects including creation of new functionalities, enhancements of front-end screens, new batch jobs, addition of new system of records to the system, and conversion of account numbers from Master Card to Visa.
Client: TIAA-CREF Mar 2014 – Oct 2014
Contractor
Environment: PL/SQL, Oracle, SQL Developer
As a member of the Operational Data Store (ODS) development team, I was heavily involved in supporting various services that provide data to the company’s web applications. Worked closely with other functional team members on development projects and created database packages and stored procedures in an Agile environment utilizing test driven development approach.
Client: Wells Fargo, NC Aug 2012 – Feb 2014
Contractor
Environment: PL/SQL, Oracle, Perl, Unix, AutoSys,TOAD
A member of the development team that provides support to SimCorp application. Converted several Data Extractors and Crystal Reports utilizing PL/SQL functions. Worked on some performance tuning and testing and created new reports for the business partners. Tasks involve analysis of highly complex business requirements that are translated into PL/SQL code.
Company: TIAA-CREF Mar 2004 - July 2012
Employee
Environment: Oracle, PL/SQL, SQL Loader, Natural/Adabas, JCL, TSO, CA-7, z/OS, J2EE
Responsible for the maintenance and enhancement of several Oracle-based applications. Supported the Quarterly Statements Reporting, Deferred Annuity Reporting applications and served as the Subject Matter Expert for Consolidated Retirement and Savings Statement which provides details of a participant’s retirement plan information across all providers. The applications use packages and stored procedures as well as SQL Loader to access and update the data. Several Natural and Cobol modules are included in the processes that extract data from other platforms.
Supported several web-based applications Plan Rules and Verification of Account developed using J2EE.
Heavily involved and key member of the team responsible for the conversion of plan and participant data from the legacy system to SunGard OmniPlus platform using Natural/Adabas. This new mainframe-based system will have the capability of mapping and extracting data along with balancing and control functionality.
Involved in coding Oracle stored procedures, functions, packages using PL/SQL.
Created batch jobs that extract data from Adabas and load into Oracle database tables using SQL Loader.
Created NDM processes that copy file from a third party vendor over to the Charlotte office.
Involved in coding complex Natural programs (Online and Batch in Structured mode).
Provided maintenance and support to business clients.
Prepared functional requirement and technical documents as part of the Software Development Life Cycle.
Client: TIAA-CREF, NY Nov 1998 - May 2003
Contractor
Environment: Oracle, PL/SQL, SQL Loader, Natural/Adabas, JCL, TSO, z/OS, MVS/ESA, VM/ESA, CMS, CICS, EntireX, WebObjects/Java
Master Index Tracking (MIT). The system provides information concerning participant, non-participant, institutional work request details. MIT includes Logging and Indexing, Contact/Activity, Work Tracking, Reporting, Corrections, and Electronic Folder Management (EFM), a facility for the storage of documents which are related to MIT work requests to quickly and easily make documents available to the user. MIT was written using Natural/Adabas running under MVS/ESA.
Sales Management, Asset Retention Tracking (SMART). A web-based application that provides the infrastructure and internal processing required to create, track and maintain information on leads for participants and non-participants. The system was initiated to satisfy a business need for a more comprehensive facility to monitor corporate asset growth and retention efforts
NPIRMatchMerge. A web-based application that assists users in merging duplicate records in the Non-Participant Information (NPIR) file and matching Non-participant records in the policyholder (COR) file. I was heavily involved in the development and implementation of the system written using WebObjects/Java with Oracle as the main database.
Involved in coding Oracle stored procedures, functions, packages, triggers using PL/SQL.
Created batch jobs that extract data from Adabas and load into Oracle database tables using SQL Loader.
Responsible for solving incident reports and adhoc requests in a timely manner.
Involved in coding complex Natural programs (Online and Batch in Structured mode).
Developed Natural modules which extract data from Adabas and pass on to the periphonics screen-scraper utility of the Automated Telephone System (ATS) of the company
Created IDL files and Java fetchers, a service used by web applications to do RPC call to Natural programs in mainframe with EntireX as the middleware
Involved in coding WebObjects/Java, HTML, JavaScript.
Client: Asian Development Bank, Philippines Nov. 1994 to July 1998
Contractor
Environment: Natural/Adabas, JCL, ISPF/TSO, and MVS/ESA.
The project involved maintenance and enhancement services for the Investment Portfolio System (IPS). IPS is used to record and maintain current and historical details of investments on securities and deposits and to process related accounting entries. It interfaces with the Banking Transaction System for updates to the cash balances and generates accounting entries for posting to the General Ledger Accounting System. The system runs under MVS/ESA on an IBM mainframe and is written in Natural/Adabas. Also worked on the maintenance and enhancement of the Borrowings Portfolio System (BPS) and Inter-Application Message Handling System (AMHS).
Involved in coding complex Natural programs (Online and Batch in Reporting and Structured mode).
Interact with system users to document information requirements.
Perform Adhoc requests as per user requirements.
Diagnose production problems and perform resolutions.
Maintenance and enhancement of the applications.
Client: SPL, Philippines July 1994 to Oct. 1994
Contractor
Environment: Natural Construct, DB2
As a team member, was involved in the development of Automated Communication Technical Information and Operations Network system for the Hong Kong government using Natural Construct.
Client: Development Bank of the Philippines, Philippines May 1991 to July 1994
Employee
Environment: Natural/Adabas, JCL, TSO, MVS/XA, Foxpro, Clipper, MS-DOS
Worked on PC-based applications for the Office of the Chairman and Vice Chairman of the bank. The applications include (i) Executive Information System (EIS), provides high-level of information to the Chairman and Vice Chairman to help and assist in making critical decisions. EIS was written using Comshare’s Commander EIS and OneUp Modeling; (ii) Deadline Tracking System (DTS), keeps track of correspondence coming in and out of the Chairman and Vice Chairman's office. Responsible for conversion of the system from Clipper Summer ’87 to Foxpro 2.5; (iii) Very Important Personalities System (VIP), designed to store bio-data-like information of people close to the Chairman. Responsible for the re-development of the system.
Responsible for the support and maintenance of the following mainframe-based applications written using Natural/Adabas running under MVS/XA: (i) Modified Disbursement Scheme-DECS (MDS-DECS), a system designed to monitor the issuance and reconciliation of checks issued by the Department of Education for public school teachers. It is used primarily to facilitate effective management of cash resources entrusted by government agency maintaining disbursement account in government servicing bank; (ii) Provident Fund Loans (PFL), monitors loan account of bank’s employees; (iii) Provident Fund Contributions (PFC), keeps track of the employee’s fund contributions.
Involved in coding complex Natural programs (Online and Batch in Structured mode).
Involved in coding Foxpro, Clipper programs.
Responsible for the re-development of VIP application which involves Analysis and Design, Coding and Implementation of the system.
Responsible for the conversion of DTS application from Clipper Summer ’87 to Foxpro 2.5.
Responsible for the maintenance and enhancement of the applications.
Contact this candidate