PL/SQL Developer Resume

Title
PL/SQL Developer

Primary Skills
PL/SQL prcocedures, functions, triggers

Location
US-FL-Tampa (will consider relocating)

Posted
Oct-02-09

SUMMARY
15+ Years of experience in Mainframe / Client Server / Web Application development and Support; Experienced in Global Funds processing, Data warehouse maintenance, Medical Claim processing, Retail transaction processing, Merchandize system; Experienced in all the phases of the SDLC as Project Lead, Project Analyst, Business Analyst, and Programmer Analyst. Self-starter, highly motivated individual; Team player who is flexible and adaptable to changes. Excellent Use Case identifier, Requirement evaluator, Code debugger and Problem solver; Excellent written and verbal communication skills;

PROFESSIONAL EXPERIENCE
JP Morgan, Tampa, Florida 09/2006 - Present

Title -- Asst Vice President/Application Developer
Department/Area- Treasury & Securities Services.

Responsibilities:
Responsible for design and development of new process in Global Clearing Funds Process (GFP).
Responsible for developing and maintaining Wholesale Data Capture (WDC) Process for Demand Deposit Accounting (DDA) System. Responsible for creating Technical Specifications, Detail designing, Test Cases, System Test Scripts and Regression Test procedures. Working in several roles a Project Lead, Technical designer, Application Developer, Tester and Project Coordinator between multiple systems.

Accomplishments:
• Involved in WAMU conversion.
• Involved in design of new project to build common router (EDI) between Global Clearing Funds Process and all other inbound/outbound interfaces. The application uses WebMethods, Java, JavaScript, XML, MQ series, CICS, Oracle, VB6
• Designed, Developed/Modified CICS, COBOL, DB2, VB6, JAVA, XML and MQseries Applications.
• Involved in developing asynchronous and Synchronous Memo process.
• Improved the THRUPUT data process.
• Identified possible improvements for the system and provided Detail technical design documents.
• Created Use cases and Program specifications for Enterprise Projects.
• Created Standard development and QA turnover procedures and Created training document for Application development and QA/UAT teams
• Involved in Enterprise Cobol conversion.

Princeton Information 06/2005 -- 09/2006
Client -- JP Morgan, Tampa, Florida

Title -- Application Developer
Department/Area- Treasury & Securities Services.

Responsibilities:
Responsible for developing and maintaining Wholesale Data Capture (WDC) Process for Demand Deposit Accounting (DDA) System. Responsible for creating Technical Specifications, Detail designing, Test Cases, System Test Scripts and Regression Test procedures.

Accomplishments:
• Involved in BANK ONE and JP Morgan merger process changes.
• Developed/Modified CICS, COBOL, DB2, and MQseries Applications.
• Involved in developing Memo Post and Hard Post Process.
• Created Tools for System Testing and verification process for Major Enterprise project releases.
IBM Global 02/2005 - 6/2005
Client - Eckerd Corporation, Largo, Florida

Title -- System Technical Specialist
Department/Area- Central Pharmacy Claims Process

Responsibilities:
Responsible for reviewing and analyzing new claims process system requirements to produce an internal design consisting of program specifications, file descriptions, record layouts, report layouts, data mapping of Eckerd data to Brooks Data.

Accomplishments
• Assisted in merger of ECKERD and BROOKS applications.
• Created conversion programs for converting Eckerd Pharmacy data into Brooks Standards and coordinated with AS/400 application Programmers in testing and data validations.
• Coordinated the Billing and Payment cycle transition to new AS/400 application.
• Created data mapping and Data conversion for new System
Eckerd Corporation, Largo, Florida 07/2001 -- 01/2005
Title -- System Technical Specialist
Department/Area- Pharmacy Claims processing

Responsibilities:
Responsible for development and maintenance of J2EE and Legacy Data Management, Pharmacy Claims Process, Billing, Payment, Managed Care Accounting system and Drug applications. Collecting the requirements, Designing, coding, debugging, documenting, and maintaining complex programs. Planning and coordinating Change Management and Release Management functions during project development. Instructing, directing, and checking the work of programmers. Creating User training manuals and providing training.

Accomplishments
• Teamed to create architecture components using UML, J2EE, JSP and IBM WebSphere for multi-tiered Web Pharmacy applications to display drug related information. Created Domain object model, the data object model and USE CASES in Rational Rose, and UML. Used Rational Unified methodology (RUP) to design project goals and deliverables. Managed Projects on schedule with 100% accuracy
• Involved in the Conversion legacy COBOL system into J2EE system.
• Designed and developed in-house ETL for Vendor specific pharmacy data load process. Developed 200 PL/SQL Stored procedures to optimize database load and validation process. Improved the load process time by 60%.
• Researched pharmacy information from three different Vendors and coded database user interfaces (GUI) for easy access. Business users use the application for contract renegotiation, Drug utilization trend research, prescription sales, refurnishing the supplies, clinical information and reimbursement verification.
• Involved with DBAs in the creation of MQseries Queue Managers, Clusters, and Queues in HP-UNIX, and OS/390 environment. Developed Model COBOL Programs that uses MQseries, DB2, and IMS for Team and JCLs for compiling and executing MQseries programs.
• Created a program inventory tool and helped identifying the daily, weekly, and monthly OPC schedules for each application for all the departments. This reduced analysis time by 50% when identifying the applications that are date sensitive.
• Administered OPC JOB, an automated job scheduler to maintain even Load Balance. Reduced process cost by 30% by changing CPU intense ADHOC system applications schedule.
• Took Leadership position on support team. Helped design better tools and procedures to complete and communicate resolutions to production issues.
• Managed to reduce overall execution time of legacy applications by 25% by utilizing database utilities to produce the data while routine maintenance of databases, by optimizing the program logic.
• Utilized REORG utility of DB2 to extract the data and then purge the data from database while the regular database maintenance is performed.

Avani Systems Inc, Tampa, Florida 06/2000 - 06/2001
Client: Eckerd Corporation thru IBM GLOBAL SERVICES thru AIC

Title -- Senior Programmer/Analyst
Department/Area- Central Pharmacy Claims Process

Responsibilities:
Responsible for development and maintenance Pharmacy Claims Process, Billing, Payment and Drug applications.

Accomplishments
• Involved in business analysis, workflow analysis, design, Development and maintenance of Region alignment Project.
• Self taught and used POWERBUILEDR and completed project on schedule. Completed the project 2 months earlier than estimated. The system is used in daily analysis of store performance.
• Analyzed existing Managed care accounting system and improved the process. This reduced the CPU utilization by 30%.
• Created drug usage trend analysis reports for users to assist in the Script management analysis.
• Maintained billing and payment process.
• Managed to reduce Tape mount cost of legacy applications by 25% by analyzing the data and eliminating the multiple tape mounts of the same dataset. Changed the logic to produce multiple reports in one process.


Avani Systems Inc, Tampa, Florida 06/1999 - 06/2000
Client: TIME2MARKET Inc

Title -- Senior Programmer/Analyst
Department/Area- Accounting and Payroll Services

Responsibilities:
Responsible for Business analysis, Workflow analysis, design, assigns and monitors workload, maintenance and user training.


Accomplishments
• As a project Lead, designed and developed business applications to keep track Financial Accounting, Payroll, Invoicing, Customer order tracking, Part time Employee Scheduling.
• Worked with Accountant to Design and develop General Ledger, Income statement, Cash flow and Balance sheet
• Created User training manual and trained users in using new system and efficiently maintaining.
• Completed new Payroll Project using VB6.0 with 20% less staff than estimated.

CDI, Tampa, Florida 10/1998 - 06/1999
Client: GTE DATA SERVICES

Title -- Senior Programmer/Analyst
Department/Area- Data Security System

Responsibilities
Responsible for analysis of existing Data Security system. Design and develop and document new Security system.


Accomplishments
• Re-engineered an existing data Security System that uses VSAM, ISPF and ACF2 to DB2, CICS and MQseries.
• Involved in designing, coding, testing, implementing programs, and creating test plans for unit testing, regression testing and system acceptance test and user documentation.


CGI, Tampa, Florida 09/1997 - 09/1998
Client: GTE DATA SERVICES thru IBM Global Services

Title -- Senior Programmer/Analyst
Department/Area- Telecommunication Customer billing and complaint systems

Responsibilities
Convert existing system to Y2K compliant. Convert non-relational process to relational process.

Accomplishments
• Created SYSTEM acceptance test criteria for Y2K conversions for large Customer Billing system.
• Converted existing IMS, DB2 programs to Y2K compatible. Created JCLs for before and after conversion and comparisons.
• Debugged programs and created test packages for user Acceptance. Promoted JCLs and programs into production with 100% accuracy and bug free.

Department of Corrections, Tallahassee, Florida 07/1997 - 09/1997
Title --System Project Analyst
Department/Area- Offender tracking Information System

Responsibilities
Responsible for development, and maintenance of the Offender tracking Information System (OTIS) for FLORIDA

Accomplishments
• Designed and expanded IMS database segment fields for Offender tracking System.
• Self taught PL/I and converted 30 PL/I programs to COBOL/IMS DLI in 2 months.
Unisys Corporation, Tallahassee, Florida 08/1994 -- 07/1997
Client: Florida State MEDICAID

Title --Programmer/Analyst
Department/Area- Recipient, Provider, Claims, MARS, SURS, and EPSDT

Responsibilities
Responsible for creating Management and Accounting reports. Validating Recipient and Provider eligibility and maintain claims adjudication system

Accomplishments
• Managed Project to convert COBOL report Writer programs to Cobol II. Provided risk assessment document, prepared formal test plans, implemented standard practice documents, worked with users to develop final acceptance test plans.. Implemented with 100% efficiency.
• Designed Executive Interface System (EIS) for State Medicaid Systems, prepared detailed proposals and implementation plans, and scheduled installations. Original project was estimated at 12 months, reassessment was 10 months, delivered successfully in 8 months
• Wrote several COBOL applications to track Medicaid/Medicare patient and provider information.
• Provided Production Support, Monthly Analysis Reporting system updates and assisted in design and development of ADHOC Report system and Upgraded data reporting application for easier maintenance, portability.
• As part of SURS system, developed drug utilization and monitoring reports

Received Achievement AWARD FOR EXCELLENCE





TECHNICAL EXPERIENCE
Operating Systems
• OS/390, MVS, UNIX, Windows, HP-UX, AIX/390, Stratus
Operating System Environments
• Windows, VTAM, TSO
Programming Languages
• JAVA2, JavaScript, JSP, HTML, UML, XML, MQseries, Visual Basic 6.0, C
• SQL, SQL*loader, PL/SQL, QMF, SPUFI, Report Writer
• Rational Rose, Requisite Pro, Clear Quest
• COBOL, CICS, JCL, EASYTRIEVE, ASSEMBLER, IDCAMS, FILE-AID, ISPF/PDF, IQ, ISPF/TSO, VI
Information Security/Audit Tools
• RACF, ACF2, ENDEAVOR, PANVALET, SOURCE CAFÉ, Rational Clear Case
Desktop Publishing
• MS Office, PowerPoint, MS Publisher
Data Access/Databases
• VSAM, IMS, IDMS, DB2, INFORMIX, MS Access, ORACLE9i
Web IDE Tools
• WebSphere, OptimalJ, Dream weaver, Front-page
Debug Tools
• WebSphere IDE debug tools, Expeditor, Hourglass, Inertest, VIASOFT

Quality Assurance Tools
• Mercury Quality Pro Center 9.2

Compliance Strategies
• SOX (Sarbanes Oxley Act), HIPAA(Health Insurance Portability and Accountability Act), Graham Leach Bliley(Financial Modernization Act)


PROFESSIONAL DEVELOPMENT
EDUCATION
• BS Biology, Andhra University, India

CERTIFICATION/TRAINING
• Computer Programming in BASIC- Nagarjuna University, INDIA
• Telecommunications/ Electronics-South San Francisco, CA
• Computer Programming - Tallahassee, FL
• MQseries Administration for OS/390 and HP-UNIX, MQseries Developer for OS/390 - Tampa, FL
• IT Project Management - Tampa, FL
• Objected Oriented Design using UML/JAVA, JAVASCRIPT, JSP, J2EE - Tampa, FL
• OPTIMAL J, an IDE for JAVA using UML data model -Tampa, FL

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Tampa, FL | Resumes in Florida

View other PL/SQL Developer resumes, Programmer / Developer resumes