Pl/sql Developer, Contractor Resume
NC
SUMMARY:
- A result - oriented individual with proven expertise in systems development and programming.
- Over twenty eight years of IT experience.
- More than twelve 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.
TECHNICAL SKILLS:
Languages: PL/SQL, NATURAL, JCL, Perl
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, Autosys, Subversion, Predict, Construct, EntireX, N2O, CICS, TSO, CMS, Eclipse, Visual Source Safe, Start Team, Jenkins, uDeploy
Operating System: z/OS, MVS/XA, MVS/ESA, VM/ESA, Unix, Windows
PROFESSIONAL EXPERIENCE:
Confidential, NC
PL/SQL Developer, Contractor
Environment: PL/SQL, Oracle, Perl, Unix, AutoSys, SQL Developer
Responsibilities:
Created new reports for the business partners and performed enhancements to existing procedures including performance tuning. Tasks involve analysis of highly complex business requirements that are translated into PL/SQL code.
Confidential, NC
PL/SQL Developer, Contractor
Environment: PL/SQL, Oracle, TOAD, Unix
Responsibilities:
Heavily involved in the automation of the Break Fix Reports. Worked on creation of new PL/SQL scripts, procedures, views, and tables to support the new process. Reports are generated based on the consolidation of the source files and data from Legal Entity Onboarding system. Took the lead in preparing the technical design and development of EVoC project that will send data feeds from LEO to PRDS.
Confidential, NC
PL/SQL Developer, Contractor
Environment: PL/SQL, Oracle, SQL Loader, Perl, Unix, Subversion, PL/SQL Developer
Responsibilities:
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 using PL/SQL.
Confidential
PL/SQL Developer, Contractor
Environment: PL/SQL, Oracle, SQL Developer
Responsibilities:
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 PL/SQL packages and stored procedures in an Agile environment utilizing test driven development approach.
Confidential, NC
PL/SQL Developer, Contractor
Environment: PL/SQL, Oracle, Perl, Unix, AutoSys,TOAD
Responsibilities:
A member of the development team that provides support to Sim Corp 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.
Confidential
Senior Developer
Environment: Oracle, PL/SQL, SQL Loader, Natural/Adabas, JCL, TSO, CA-7, z/OS, J2EE
Responsibilities:
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.
Confidential, NY
Developer, Contractor
Environment: Oracle, PL/SQL, SQL Loader, Natural/Adabas, JCL, TSO, z/OS, MVS/ESA, VM/ESA, CMS, CICS, EntireX, WebObjects/Java
Responsibilities:
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.
Confidential
Software Engineer, Contractor
Environment: Natural/Adabas, JCL, ISPF/TSO, and MVS/ESA.
Responsibilities:
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.
Confidential
Programmer
Environment: Natural Construct, DB2
Responsibilities:
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.
Confidential
Programmer
Environment: Natural/Adabas, JCL, TSO, MVS/XA, Foxpro, Clipper, MS-DOS
Responsibilities:
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.