SUMMARY:

• Analyst with over twenty - three years of industry experience. Dynamic career designing and developingapplications from 3rd Generation mainframe systems to Client/Server to Web applications. Successfully
• Developed and led many projects for a wide variety of government departments and industries
• Excel in a team environment. Mentor less experienced analysts and take opportunities to learn new skills from more senior project leaders, database analysts and technical architects.
• Certified as an Oracle Application Developer, some experience as a Database Administrator and experience teaching introductory Oracle classes at the college level.

TECHNICAL SKILLS:

Primary Focus: Oracle database 11g, Oracle Applications 11i and 12, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 9i, Oracle Designer, Oracle Developer

Minimal Experience: Oracle Portal, Java, Eclipse, Microsoft Reporting Services, .Net, Visual Studio, XML, Crystal Reports, Unix, Informatica

PROFESSIONAL EXPERIENCE:

Senior Analyst/Developer

Confidential

Responsibilities:

• Clarifying requirements with Users and Lead Designer
• Designing PL/SQL interfaces and reviewing them with Lead Designer/Application Architects
• Writing and testing PL/SQL packages
• Working extensively with Objects, Collections, Queuing and De-Queuing messages
• Participating in formal Code Reviews to ensure standards are followed and solution is suitable and efficient
• Migrating to User Acceptance environment and checking in PL/SQL packages to repository

Senior Analyst/Developer

Confidential

Responsibilities:

• Designing and developing changes to the Oracle Payment API (Oracle 11g packages)
• Writing database triggers in Oracle 11g
• Writing other PL/SQL packages to write to audit tables, perform utility functions, etc.
• Creating Alerts in Oracle Financials 11i
• Using SQL*Loader to load initial customer segment ratios
• Designing and developing two new forms in 6i
• Designing and developing an Oracle package in 11g to extract statement data to a flat file
• Setting up concurrent requests, etc.

IT Specialist

Confidential, Somers, NY

Responsibilities:

• Designing, developing and tuning Oracle Forms 10g for a Materials Requirement Planning project in Advanced Supply Chain, Release 12
• Designing, developing and tuning Oracle Forms 6i for an enhancement to Oracle 11i OPM
• Designing and creating views in PL/SQL to expose our data to the Supply Chain group
• Writing, maintaining and tuning Oracle packages/procedures for many internal and external groups
• OPM and MRP Administration such as maintaining users, items, responsibilities and creating concurrent requests.
• Write design and technical documents, perform and participate in code reviews

Analyst/Developer

Confidential, Stamford, CT

Responsibilities:

• Gathering requirements from users
• Design and creation of database tables, constraints and indexes on these tables
• Design and development of Portal Forms and Portal Reports
• Design and development of Oracle Forms 10g and Menus
• Design and development of database triggers and stored procedures
• Demonstrating the application and users on the application
• Conversion of the client’s data from Excel into Oracle 10g database using SQL Loader
• Enhancing other Oracle Forms 6i applications as needed

Analyst/Developer

Confidential, Sweet Springs, Missouri

Responsibilities:

• Re-designing PL/SQL batch process which never ran successfully or took weeks to complete
• Wrote several PL/SQL programs to clean up the client’s data prior to loading of new data which was purchased from a competitor
• Used SQL loader extensively to format the incoming data, which was in Excel format and then load into our Oracle 10g database
• Enhanced several Oracle Forms 6i screens to support on-going changes
• Enhanced two Crystal Reports as needed
• Provided assistance and mentoring for less experienced developers

Analyst/Developer

Confidential, Kansas City, Missouri

Responsibilities:

• Resolved issues on Java programs which were written as Web Services to receive telephone data from vendors
• Wrote several reports in Microsoft Visual Studio and .Net

Analyst/Developer

Confidential, Lenexa, Kansas

Responsibilities:

• Schedule team meetings and gather requirements from users
• Design and develop several (approx. 15) Oracle Forms 9i using Oracle Designer
• Design and develop Oracle Reports 9i using Oracle Designer
• Developed several stored procedures and functions in Oracle 10g database
• Modified Oracle Forms libraries (PL/SQL) which are used to standardize the application
• Major role at this client was to assist and mentor less experienced developers
• Served as an Application DBA for a few months
• Maintained the data model using Oracle Designer
• Modified several table definitions, views, constraints and indexes using Oracle Designer and Oracle 10g database

Analyst/Developer

Confidential, Kansas City, Missouri

Responsibilities:

• Analysis and design of several Oracle Forms 6i from user requirements
• Development of Oracle Forms 6i, generated through Oracle Designer
• Performing quality assurance tasks, code reviews, etc. on other analyst’s work
• Tasking other analysts with assignments and reporting to management on progress
• Senior member responsible for mentoring less experienced developers

Analyst

Confidential, Edmonton, Alberta

Responsibilities:

• Attending design sessions, gathering requirements
• Evaluating various web site designs
• Evaluations of software such as Oracle Portal, HTML and JavaScript which led to a recommendation of tools for development of the application
• Writing application standards for PL/SQL
• Writing design specifications for developers

Analyst/Developer

Confidential, Kansas City, Missouri

Responsibilities:

• Correcting several Oracle Forms 6i applications. Some forms were generated using Oracle Designer. Others were in Oracle Developer.
• Developed several stored procedures and functions using PL/SQL in an Oracle 8i database
• Assisting other developers in great deal as most of these developers had not used Oracle, Oracle Designer or Oracle Forms at all at the time