Oracle PL/SQL Developer, Application Support Analyst Resume

Title
Oracle PL/SQL Developer, Application Support Analyst

Primary Skills
Oracle Pl/sql, Oracle Forms, Toad, Oracle Reports, Unix shell scripting, QA, Application Support, Software Development

Location
Canada-AB-Calgary (will consider relocating)

Posted
Oct-05-09

PROFILE:
* 9 years of Oracle/ PL/SQL Programming experience.
* 9 years of Software Development and Application Support and Maintenance
* Expert in Oracle PL/SQL, Stored Procedures, Packages, Oracle Forms.
* 3 years of Retek Distribution Management (RDM) experience.



SUMMARY
* Nine years of real time experience in Client Server applications using PL/SQL, Oracle Forms/Reports and relational databases like Oracle 7.x/8.x on Windows and 2 years on Unix platforms.
* 3 years of experience in RDM (Retek Distribution Management).
* Strong development skills in application development and developing Database Packages, Stored Procedures/Function using PL/SQL.
* Proficient in Oracle Tools and Utilities such as TOAD, Developer 2000, SQL*Navigator and PVCS Version Manager, Subversion
* Commendable knowledge on all aspects of product development methods - analysis, design, development, testing and problem solving.
* Vast experience in directly working with onshore clients from various countries and providing system and client support.
* Experience in working in the United States and Canada performing knowledge transfer and coordinating with clients.
* Experience in working in an Agile Team.


TECHNICAL SKILLS
* Operating systems: Windows NT/2000, UNIX, Windows 95, 98, XP, VMS
* Languages: Oracle PL/SQL, RDM (Retek Distribution Management)
* Front-End Applications: Oracle Forms 4.5/5.0/6i
* Report Tools: Oracle Reports 2.5/3.0/5i/6i
* Other Tools: TOAD, SQL*Navigator, PL/SQL Developer, PVCS Version Manager, Developer 2000, Exceed, Subversion



PROFESSIONAL EXPERIENCE
Company: Everest Technologies
Client: Gap Inc Direct Jul '09 -- Present
Role: QA Tester
Project Location: Ohio, USA
Project Scope: Jesie Shipping Enhancement Project (Agile)

Gap Inc Direct is one of the world's largest specialty retailers. They operate four recognizable apparel brands -- Gap, Banana Republic, Old Navy and Piperlime

The Jesie Shipping Enhancement project is an Agile Driven project that adds and incorporates new business rules, which translates to the business requirements, to the web based Jesie Shipping Application.

ROLES AND RESPONSIBILITIES
* Prepare and create test cases based on the Acceptance Criteria of the story (based on work request, business requirements and/or product specifications).
* Execute the test cases based on Story (Work Request) criteria and perform Regression Testing.
* Drive Sign-off meetings with Product Manager to verify that all acceptance criteria for the story are met, and that functionality is correct.

TECHNOLOGY/ENVIRONMENT USED: TOAD, UNIX shell scripting, Agile Methodology, Hermes, Mercury, Subversion



Company: Everest Technologies
Client: Gap Inc Direct Mar '08 -- Jul '09
Role: RDM Developer
Project Location: Ohio, USA
Project Scope: RDM Development and Maintenance, RDM MiniQ Project (Agile)

The project involves enhancements and maintenance of RETEK-RDM Application that supports business operations. The RDM MiniQ project is an Agile Driven project that customizes RDM modules to meet business requirements that includes customization of RDM core application that is not limited to: Distribution, Waving, Stock Order Download, Invoices Printing, Inventory, ASN/NSC Receiving, ROP Replenishments, Packing, Picking, and Inventory Balance Upload.


ROLES AND RESPONSIBILITIES
* Designed and developed database packages, procedures, functions and triggers on Oracle 9i/10g databases.
* Made enhancements and applied defect fixes on the ff. RDM functionalities: Distribution, Picking, Inventory Control and Invoice. These changes were developed using Oracle forms, Unix scripting, PL/SQL and TOAD.
* Created Technical Design documents for major enhancements and attended Technical Design Reviews.
* Creates Summary Designs to address fix/enhancement code change to support Story's acceptance criteria.
* Codes and test software that meets the design specifications
* Drive reviews with Product Managers or execute test plan with the product manager to verify that acceptance criteria is met and/or verify that existing functionality of modified module works.
* Support RDM MiniQ Releases (fixing bugs) of production issue found during implementation
* Created Issue Resolution documents and Unit Test Plans for minor enhancements.

TECHNOLOGY/ENVIRONMENT USED: Retek Distribution Management (RDM), Oracle PL/SQL, Oracle Forms 6i, TOAD, UNIX shell scripting, Agile Methodology, Subversion



Company: Accenture
Client: Best Buy, Canada Feb'06 -- Jul '07
Role: Associate Manager
Project Location: Vancouver, Canada and Manila, Philippines
Project Scope: Knowledge transfer, Application Support and Maintenance

Best Buy is an innovative and growing Fortune 100 company. In 2001, Best Buy acquired the Canadian-based company Future Shop Ltd., retailer of consumer electronics, personal computers and entertainment software with over 40 stores in British Columbia, Alberta, Manitoba, Saskatchewan, Ontario and Quebec.

ROLES AND RESPONSIBILITIES
* Supervised a team of 21 members, Conducted Knowledge Transfer sessions with Best Buy Canada employees (Canada Headquarters -- Vancouver) to gather Functional and Technical knowledge of the RDM Application.
* Designed and developed database packages, procedures, functions and triggers on Oracle 9i/10g databases.
* Designed Cross Training Plan for incoming team members. This includes:
o Topics and functional areas to be covered.
o Schedule and timeline for the cross training.
o Identification and design of appropriate hands on exercises and tasks where the trainees can practice the skills they learn in the cross training sessions
* Attended Weekly Conference Call meetings with counterparts to discuss team tasks, staffing, issues and other concerns.
* Worked with the onshore counterparts in creating the process for providing on call support for RDM.
* I was involved in supporting and making enhancements or fixes on the ff. RDM functionalities: Defective Picking, Mispick, Stock Order, Shipping reports. These changes were developed using Oracle forms, Oracle reports, PL/SQL and TOAD.
* Directly worked with clients in Canada addressing high severity or high impact tickets.
* Managed the team work plan, evaluating and assigning team members workload for the RDM Team.
* Addressed RDM support requests/tickets (investigating, code modifying using Oracle PL/SQL and code review).
* Doing and supervising enhancements to various modules of RDM. Completing the unit, system, user acceptance testing, and implementing the changes in production.

TECHNOLOGY/ENVIRONMENT USED: Retek Distribution Management (RDM), Oracle PL/SQL, Oracle Forms 6i, Oracle Reports 6i, TOAD, UNIX, Exceed




Company: Accenture
Client: Dow Chemicals Jun '00 -- Feb '06
Role: Team Lead
Project Location: Michigan, USA and Manila, Philippines
Project Scope: Knowledge transfer, Application Support and Maintenance

It is an outsourcing engagement responsible for the development, enhancement and support of all applications utilized by Dow's global businesses. Dow Chemicals is a leading science and technology company that provides innovative chemical, plastic and agricultural products and services to many essential consumer markets. Dow AgroSciences, headquartered in Indianapolis, Indiana, U.S.A, is a global company that provides pest management, agricultural and biotechnology products. The Dow Chemical Company acquired it in 1998.

ROLES AND RESPONSIBILITIES
* Involved in design, development and testing of application modules of the different applications used by Dow AgroSciences, a subsidiary of DOW Chemicals, using Oracle PL/SQL, Developer 2000, and SQL Navigator.
* Involved in the migration all Dow AgroSciences applications using previous versions of Oracle Forms and Reports to Oracle Forms and Reports 6i. Applied the necessary changes needed to Oracle Forms, Reports, and performed regression testing to ensure all functionalities are still working.
* Involved in coding and testing the enhancement for an online booking system application using Oracle PL/SQl and Oracle Forms.
* Involved in preparing application documentations. I outlined the different processes of the application, and a list of the common problems encountered and how they can be solved. This then were used during the support of the applications.
* Involved in conducting knowledge transfer sessions with other counterparts who will also be supporting the applications.
* Involved in the transition of applications from the Union Carbide applications into the DOW Chemical portfolio. This transition involved meeting with the Union Carbide employees in West Virginia to learn about the different applications, and provide documentation.
* Involved in the creation of the functional design, detailed design, component and assembly testing scripts.
* Interacted with the business users to gather requirements for analysis, design and development of new systems.
* Created functional design documents based on business process requirements.
* Learned and understood the Dow AgroSciences work processes to effectively support these processes offshore
* Worked on support requests/tickets regarding the applications. This involved investigation and enhancements/modifications to the code.
* Served as a coach and mentor to help more junior team members develop their technical skills.
* Created Performance Feedback Forms for team members
* Created Application Detailed Designs of modules in Oracle PL/SQL and Oracle Forms
* Prepared Component and Assembly Test Scripts and performed Component and Assembly tests to ensure that the modules are functioning according to design
* Conducted Peer Reviews to ensure quality work
* Documented the process and the problem resolution
* Coordinated/worked with onshore contacts
* Provided corrective, adaptive and preventative maintenance

TECHNOLOGY/ENVIRONMENT USED: Oracle PL/SQL, Oracle Forms 4.5/6i, Oracle Reports 2.5/6i, SQL*Navigator, PVCS Version Manager, Developer 2000, Windows NT/2000, Windows 95, 98, XP, VMS


Company: Accenture
Client: National Grid Sep'03 -- Dec'03
Role: Team Lead
Project Location: Manila, Philippines

Project Scope: Involved in the supervision of the development team. The team was involved in the build and test of outbound and inbound interfaces to the STORMS module. The technologies used are PL/SQL and Oracle Database, and made use of the PL/SQL Developer tool.

National Grid USA is a subsidiary of National Grid Transco, an international energy delivery business with principal activities in the regulated electric and gas industries. In January 2002, National Grid completed its merger with Niagara Mohawk, the second largest combined electricity and gas utility in New York State.

ROLES AND RESPONSIBILITIES
* Interacted with the business users to gather requirements for analysis, design and development of new systems.
* Supervised team members
* Acted as the first level of support for the developers
* Managed Code and Development Reviews to ensure that the deliverables satisfy the requirements
* Designed specifications and complies with project standards
* Ensured assigned deliverables are on time and within the assigned budget
* Provided individuals with positive and development feedback and creating Performance
Feedback Forms for team members
* Attended Weekly Conference Call meetings with clients/counterparts to discuss team tasks, staffing, issues and other concerns.

TECHNOLOGY/ENVIRONMENT USED: Oracle PL/SQL, Windows XP, PL/SQL Developer


Company: Accenture
Client: Standard Chartered Bank Dec'99 -- June'00
Role: Analyst
Project Location: Manila, Philippines
Project Scope: Involved in the Development and Testing of the module for the Mortgage Loan Calculator.

Standard Chartered Bank is an emerging markets bank with a strong presence in Asia, the subcontinent, the Middle East, Africa and in Latin America. It is a commercial bank focused on Consumer Banking, Corporate and Institutional Banking, and Treasury.


ROLES AND RESPONSIBILITIES
* Conferred with the client to determine the different user requirements and data needed to develop the application enhancements.
* Prepared Prototypes of the enhancements to be implemented for the Mortgage Loan
Calculator.
* Built and tested the release application components

TECHNOLOGY/ENVIRONMENT USED: Smalltalk, Windows 95



EDUCATION
Bachelor of Science in Management Information Systems
Ateneo De Manila University ( Philippines)


TRAININGS
Accent on Client/Server (June 1999)
Accenture, St. Charles, Illinois, USA

Effective Business Writing (April 2000)
Accenture, Philippines

Presentation Dynamics (April 2002)
Accenture, Philippines

Coaching in the Workplace (May 2003)
Accenture, Philippines

Oracle IDS Forms (February 2004)
SQLWizard, Philippines

Oracle IDS Reports (February 2004)
SQLWizard, Philippines

Agile Passport Training (January 15-16, 2009)
Gap Inc Direct, Groveport, Ohio, USA

Certifications
See above


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

Resumes in Calgary, AB | Resumes in Alberta

View other Oracle PL/SQL Developer, Application Support Analyst resumes, Programmer / Developer resumes