Experience Summary

A self-motivated analytical problem-solving Oracle developer with over 15 years of experience in the area of database development and administration, middle tier, user interface, mainframe scripting and application development. Some of the activities performed include application architecture, data conversion, data standardization and governance. To compliment the developmental skills the project engagements have afforded the opportunity to develop the business acumen in industries, such as, Oil Gas, Manufacturing and Financial Services. Committed to the improvement of the company through the identification of areas for process improvement and the proactive identification of future business functionality challenges, as well as, personally continuing education in the business arena.

Relevant Experience

Confidential

• Technical responsibilities included the support of the IRS continuous integration effort with the development of process to standardize the testing of Oracle database processes using utPLSQL. Also, provided multiple training sessions to the user community.
• Developed logical and physical database models, as well as, setting of data and database standards and governance.
• Develop database processes for data cleansing and normalization of enterprise, as well as, monitor the data quality and stability.
• Developed an information data repository to assist in the data architecture/steward groups in the maintaining database compliance standards

Confidential

• Technical responsibilities included the data capture of failed institutions portfolio of electronic information in accordance to federal regulations for the long term storage and retrieval. The data was extracted from various back office financial applications and then formatting the data to be accessed by FDIC stakeholders for quickly querying and searching for data.
• Project responsibilities included the assistance in the implementation of the Software Development process in the FDIC development environment. This included both release and project management for various applications within the portfolio.
• Addition project activities were in the assisting the FDIC in the migration from multiple application sources to a standardized application environment of Oracle/Apex. This process encompassed the full software development process, as well as, the development of database level processes and objects. This also included the design and creation of appropriate user interface in support of departmental business rules.

Confidential

• Responsibilities included the management of an off-shore team of resources in the data standardization effort. This process was designed to standardize and correct current company Vendor management data via a 3rd party application.
• Technical activities include data activities, such as standardization, clean and identification of missing or inconsistent data within the client's company price master. To facilitate this effort a mapping/transformation database was constructed along with database processes to calculate parts statistics across all of the client parts databases

Confidential

• Responsible for the providing of both functional and technical expertise the migration of 3rd party proprietary software application to an Oracle APEX application environment.
• Technical responsibilities included the development of logical and physical data model to support new application structure

Confidential

• Responsible for the providing of both functional and technical expertise in the area of Bankruptcy and Foreclosure.
• Technical responsibilities included, but were not limited to the maintenance of the existing application, the development of new processes to support additional business functionality.
• The process development was done using PL/SQL packages, functions and procedures in conjunction with XML to interact with the BizTalk transport mechanism.
• Based upon system modification I developed test scripts and test case scenarios to assist the QC group in signing off that no adverse system affects would happen due to the program changes.
• Major Projects:
• Development of various interfaces to handle the processing of various foreclosure/bankruptcy related data to respective departmental vendors.
• Assisted in the development of data cleansing module for the purpose data validation prior to the boarding of loan portfolios into the Litton system.

Confidential

Sr. Programmer Analyst

• Responsible for the providing the technical leadership in the area of application maintenance and design, as well as, functional support for the company primary drilling application.
• Functioned as the primary technical resource in the coordination/execution of the migration of the current drilling system PERC to the OpenWells drilling application
• Developed various packages, procedures and triggers using PL/SQL to perform data cleansing and verification prior to importing data into production environment in day to day activities, as well as, system migrations
• Preformed detail workflow process analysis to determine areas for improvement either through process redesign or leveraging other data resources.
• Based upon user request to the project team I developed a variety of database modules to provide accurate and timely data.
• Responsible for the management of multiple client request for system enhancement and production data corrections, in addition to performing ongoing functional and technical problem resolution.
• To ensure proper application integration I maintained appropriate testing procedures, use cases and test data in compliance with change management principles.
• Maintained a personal knowledge of IT development tools, such as Java and Weblogic, and programming tools in order to provide knowledgeable assessment of software recommendations and alternatives.

Major Projects:

• Conversion of current drilling application, PERC, to Landmark's OpenWells Drilling Application. Developed database scripts to analyze and verify data for the migration process. Also responsible for analysis of current process workflows to determine best workflow in new application environment.
• Migration of legacy drilling application from a hierarchical data structure to an Oracle environment. Performed data cleansing prior to integrating data into the production drilling application through the development/use of multiple PL/SQL database scripts.

Confidential

Adjunct Faculty

• Responsible for the development of course curriculum to facilitate the instruction of various technical and functional topics
• Developed computer based educational exercises, as well as, assignments to demonstrate various points. In addition, to presenting these topics in a manner appropriate for varying adult computer skill levels.
• Facilitated courses:
• Database Design and Management
• Information Systems

Confidential

Sr. Applications Developer

• Functioned as the technical lead in the development around the Energy clearinghouse application. Primary responsibilities were in database modeling and development, as well as, as the integration of the external customer into the application.
• Developed custom application modules to support business requirements using packages, procedures and triggers to be integrated with Java JSP pages.
• Developed custom application modules to be integrated with Java JSP pages in Oracle PL/SQL packages, stored procedures and triggers to meet user and external client requirements.
• Additional technical responsibilities included performing database administrative function, such as, backup/recovery, object creation and overall disaster planning, Unix shell scripting and the deployment of JSP pages and Java classes using Weblogic.
• Major Projects:
• Development of a data warehousing module and associated processes to support data retention from clients and to perform trend analysis on pricing of various energy products.
• Development of an application integration module to handle the data validation of incoming transaction and the return of Risk Analysis calculations back to the clients.

Confidential

Oracle Applications Analyst

• Participated in all phases of the systems development cycle, including requirements gathering, design, development, data conversion and testing to achieve the customer's business objectives in Oracle Financials, as well as, additional Oracle database modules.
• Responsible for the ongoing support of applications using Oracle Forms and Reports, as well as, design of conversion programs for acquisitions moving to the Inventory Module. Developed PL/SQL processes to support APIs into Oracle Financials from various application extentions.
• Leverage my understanding of both the business and technology to provide best industry practices in the representation of the Inventory Group in discussion throughout the organizations in assuring that a total solution was delivered to exceed user expectations.
• Major Projects:
• Development of standardized data conversion utility to facilitate the migrations of Inventory acquisition to the Inventory module.
• Development of an application extension to the Inventory Module to calculate the Min/Max of inventory items per location.

Confidential

Systems Analyst

• Served as the technical and functional liaison between the IT departmental groups and the Institutional Marketing investment group. This role also comprised the initial analysis of client issues and the determination of the best corrective action, as well as, the determination of system requirements for application enhancements.
• Responsible for developing application enhancements and bug fixes in the current legacy environment.
• Assisted in the design, development, data mapping, normalization, data conversion routines of the new Oracle database environment from the legacy mainframe environment.

Confidential

• Personal Software Products Marketing Associate
• Provided comparative analysis and demonstrations of IBM software products to management and clients
• Analyzed client current system limitations and determined the best product mix to correct those issues with IBM products.

Confidential

Co-operative Education Student

• Preformed initial analysis/verification of client reported issues within the company developed application.
• Worked with the application release team in the coordination of application releases and the development of test case scenarios to work in conjunction with Quality Assurance testing.
• Corrected applications issues through programming efforts and developed system level jobs to handle batch processing.

TECHNICAL SKILLS

• Databases: Oracle 8.x/9.x/10g/11g, SQL Server, Access
• Applications: Oracle Apex 3.x/4.x, IBM InfoSphere Data Architect, Oracle Financials Rel. 10.7/11i,
• Oracle Forms/Reports 4.5/6i, Oracle Discover, Toad, Unix shell scripting, Business Objects,
• Web Technologies: BEA Weblogic V. 5.1/6.0, Java, Oracle Portal 9iAS/10g
• Operating Systems: Windows 2000/NT/XP, Unix Solaris , Various Mainframes