We provide IT Staff Augmentation Services!

Senior Oracle Developer Resume

Hunt Valley, MD

SUMMARY

  • IT Professional with 16years experience, primarily with Oracle technologies. Possess strong RDBMS concepts including abstract concepts of set theory. Excellent interpersonal, communication and leadership skills.
  • Employed by Confidential for 5 years. Received internal training on Oracle Financials, AIM and CDM. Participated on full life cycle development teams using Designer 2000 and Developer 2000.
  • Functioned as “Technical Lead” on projects for: Xerox, Confidential, First Brands, Cendant, Confidential .
  • Contributing author Oracle 8 Developer’s Guide. Published by IDG Books Worldwide ISBN: 0764531972
  • BS in Computer Science, State University of New York, December 1991
TECHNICAL SKILLS
  • Oracle RDBMS: V6, V7, V8, V9, V10
  • Oracle Financials Technical: V10.5 through V11.5.10 and R12
  • Oracle data warehousing functionality (star schemas, bit map indexes, query optimization, etc.)
  • Oracle Forms, Reports V3 through V10
  • Oracle CASE 5.0, 5.1 and Designer/2000
  • Oracle BPEL, SOA and OAF.
  • Oracle ADF with forms migrations
  • Webforms 6i/9i deployment with Oracle Application Server
  • Web Reports 6i/9i
  • PL/SQL
  • Application Services with Citrix
  • Sql*Loader
  • C and ProC
  • Java2, Servlets
  • Progress versions 6 and 7
  • Shell programming using Bourn, Korn and C shells
  • Sybase
PROJECT EXPERIENCE

Projects worked, were typically one of:

  • ERP implementations, customizations and upgrades. Oracle Financials
  • Data Warehousing
  • Full Life Cycle Development

Confidential

Technical Manager

Oracle BRM

Communications Industry

  • Implemented Oracle Billing Revenue Management. Stream lined billing processes. Implemented regional and bundled pricing mechanisms. Integrated BRM with existing legacy systems.
  • JCAPS - Designed and developed interface points with JCAPS.
  • AP, PA, FA, GL, Tech Lead, Functional/Technical): Involved in the implementation of Ebusiness Applications (R12) . Implemented Oracle Payables, Oracle Approval Management and a Custom Java web based application for supplier invoice entry. Worked as a technical and functional lead consultant to implement Oracle fixed assets, Oracle Projects and a custom web-based application to process projects and project related invoices. Involved in integrating Oracle Applications with mainframe applications. Oracle Applications R12 and Sun Solaris.
  • ETL - Business intelligence reporting technical lead. Led design and development of intelligence reporting and data warehousing. With Oracle Ebiz R12, used Oracle Data Integrator (ODI), Cognos and BI Publisher.
  • Technical Lead for Hyperion.

Services Industries

  • Siebel / Oracle Order to Cash: Lead Technical Architect for eBusiness intergration with SOA using AIA (BPEL) components. Existing point to point flat file interfaces where replaced with multi point pub/sub model using Oracle Application Integration Architecture. Worked closely with the Oracle Product Development team to identify product deficiencies. Designed and developed working proof of concept for order updates to flow back to Siebel.
  • BPM: End to End design and development of employee expense reporting approval system.

Oracle Internal Development

  • Lead developer for standardized SOA adapters to integrate Oracle’s Order To Cash with other systems such as Siebel. Adapters work with business events for in and out transactions. All of these components are BPEL.
  • Order Management, Fixed Assets, Maximo Technical Lead for post production support and stabilization. Analyzed system deficiencies, gathered requirements, gap analysis. Designed and developed custom interfaces with Maximo. Implemented Maximo customizations including reports.
  • Designed and developed interfaces with Oracle’s Middleware: BPEL.
  • Order Management, Fixed Assets, Data Warehousing: Technical Lead for post production support and stabilization. Analyzed system deficiencies, gathered requirements, gap analysis. Conducted a min full life cycle effort using AIM methodologies. Architected Business Intelligence Reporting (BI Reporting) with BI Publisher and COGNOS.
  • Deployed Forms application on Citrix. Deployed Web Forms 6i/9i with Oracle Application Server.

Services Industries

  • Order to Cash: Functioned as overall technical manager and led development of custom forms, reports and programs. Kevin led a staff of designers/developers from requirement, through development into user acceptance and production roll out.
  • Managed Offshore Effort: The bulk of the development team was based off shore. Kevin workload for 23 offshore resources. Kevin was also tasked with establishing coding standards and performed code reviews. As typical with offshore efforts, Kevin was the liaison between the development staff and onshore functions SMEs.
  • Lead Performance Analyst: Diagnosed and resolved issues with poorly performing forms running through the web enabled application server. Specifically worked to identify performance problems as configuration or development issues related to Universal Work Queue. Identified problem SQL in forms, reports, programs and JTF programs.
  • Integration of Emerging Technology: Introduced and led efforts to use new technologies with the mature Ebiz suite of software such as XML Publisher for customer facing documents (Oracle BI Publisher).
  • Large Scale Application Integration: Kevin has architected large application integrations between Oracle Ebiz and Siebel CRM, third party product configuration and legacy install base. Integration methods have included simple point to point flat files using Oracle Open Interface method as well as newer publisher - subscriber methods. Message based pub-sub projects have been developed with the industry leading Oracle BPEL along with Oracle’s AIA ebiz adapters. Project experience also include other middle tier software such as Tibco and SeeBeyond.
  • ETL Technical Lead for financial reporting and data warehousing ancillary projects. Used Oracle ODI and ETL*Extract.
  • Deployed Applications on Citrix.
  • Financial Extension and Implementation: Led technical team on new implementation of 11.5.9 (GL, AR, AP, OM, FA, OE). Established project standards, managed developer workload, performed code reviews and mentored junior team members. Designed highly reusable modules for updating CSV files from the user desktop into a database blob that could then be processed by a concurrent program. Designed and developed a custom PDF/data merge similar to XML publisher but more robust in that it could create dynamic fill-in fields and checkboxes to be used with FDF data. Designed and developed Iexpenses feature for users to upload scanned receipts. Financial reporting with COGNOS. Extensive setup of Oracle Configurator for made to order kitted products.
  • Performance Tuning: Identified performance issues with the Application Server, Forms, Reports, Programs and SQL. Ensured proper application server configuration and identified bottlenecks. Identified and corrected poorly performing extended functionality in universal work queue. Identified and redesigned unrestricted queries that produce large record sets in LOVs and form blocks. Identified SQL problems using DB tracing and query statistics analysis tools such as tkprof.
  • Deployed applications to Citrix.
  • Project Billing, Order Management, Accounts Receivable, Fixed Assets: Interfaces for Oracle Project Accounting using AIM methodology. Create active projects and tasks based on Order Entries captured on Oracle order management for professional services, create project budgets and project agreements using Activity Management Gateway APIs, also send e-mail notifications to project managers using Oracle Alert. Design build and test a Fixed Assets Interface for Rental assets solution using Oracle assets standard APIs including additions, transfers and retirements. Reports for Accounts Receivable. Send escalation notifications for Order management using PL/SQL standard APIs. Modify Contract Approval Workflow. On site post-production support. Oracle Applications 11.5.8, PL/SQL, RDBMS V9.
  • Upgrade Financial Extension Led upgrade effort from 11.0.3 to 11.5. Development utility to automate recoding of certain AR tables obsolete due to new OTC objects (HZ PARTIES, etc). Conducted code and performance reviews. Analyzed original gap analysis documents to identify custom procedures no longer needed.
  • Participate in a CRP to get the technical specifications and estimate extensions for the Gaps of the Business Requirements in Oracle Project Management and Oracle Project Resource Management 11.5.7 using AIM methodology.
  • Deployed forms 6i, 9i with Citrix.
  • Data Warehousing, Custom Reporting, technical project mgr. Led the deployment of an Oracle 9i DB / 9iAS platform implementing a sales analysis data warehouse for a major car rental company. Designed star schema and indexing scheme to ensure acceptable performance of reporting applications. Created a code generator to produce most of the warehouse loading procedures from detailed specs in MS Excel.

Confidential

Fairfield, NJ

  • Oracle Financials 11i Implementation and Customizations (AR, AP, GL, OE, HR)
  • Extension and Customizations Cell Lead
  • Planned and managed 11i extensions and customizations
  • Review and approve technical designs
  • Perform code reviews and Q/A
  • Managed offshore development.

Confidential

Raritan, NJ

Oracle Financials 11i Implementation and Customizations (AR, AP, GL, OE, HR)

Senior Oracle Lead Developer

  • Planned and managed 11i upgrade to version 11.5.9
  • Participated in the implementation of 11i in a medical supply manufacturing environemt.
  • Established project standards for coding and documentation.
  • Developed custom HR payroll interface programs and reports
  • Invented a custom PDF document data merge program to produce sophisticated documents such as invoice, credit/debit memo, return material authorizations, etc.
  • Identified and corrected system performance issues.

Confidential

Hunt Valley, MD

Data Warehousing using SeeBeyond and Java

Senior Oracle Developer

  • Most assignments where related to Confidential ’s core business of fleet vehicle management.
  • Developed new SeeBeyond systems for data warehouse systems
  • Implemented new business functions related to management of vehicle fleets such as title and preventative maintenance.

Confidential

Parsippany, NJ

Oracle Financials 11i Implementation and Customizations (AR, AP, GL)

Senior Oracle Lead Developer

  • Implemented Oracle Financials in a wise manner for a corporation in acquisition mode of travel related companies.
  • Developed project standards including set up of “custom Oracle applications”
  • Developed strategy for newly acquired companies to be brought onto the core ERP system and how to spin off sold entities.
  • Installed 11i technology stack, web servers and Financials Application.
  • Developed critical interfaces: ACH, Positive Pay, EFT, 1099
  • Developed conversion programs for open invoices, vendors
  • Modified core Oracle invoice and payment processing.

Confidential,

South Portland, ME

Data Warehousing

Senior Oracle Lead Developer

  • Designed, developed and performance tuned a data warehouse application for a fuel charge card processing company.
  • Re-designed aspects of the application to utilize data warehousing features of Oracle. Defined facts and dimensions and optimized the data model into a star schema.
  • Single handed developed all inbound programs to process data from feed systems

Confidential

Hunt Valley, MD

Data Warehousing

Senior Oracle Developer

  • Created a data warehouse application for sales analysis for a major car rental company.
  • Function as the corporate Oracle expert.
  • Lead development team of four.
  • Redesigned existing data model and implementation strategy to exploit Oracle’s data warehousing features (star schema, parallel queries, bit map indexes, etc)
  • Created code generator to produce the warehouse load routines. To the best of my knowledge, not a single bug has been discovered in this generated code.

Confidential

Sugarland, TX

Oracle Financials 10.7SC Implementation and Customizations (AR, AP, GL, FA, CASH, EDI, Oracle Energy)

Senior Oracle Lead Developer

  • Managed technical team of 4.
  • Devised project plan and managed work assignments.
  • Developed code manipulation program that saved Confidential $350,000 of effort.

Confidential

Houston, TX

Oracle Financials 10.7SC Upgrade and Customizations (AR, AP, GL, CPG)

Senior Oracle Developer

  • Performed pre-upgrade system analysis to determine impact of moving to multi-org.
  • Upgraded custom functionality to be multi-org aware.

Confidential

Houston, TX

Data Warehousing

Senior Oracle Developer

  • Developed data warehouse use for analysis of mutual fund performance.
  • Created corporate meta data repository using Designer 2000 to manage deployment and maintenance of computer systems.

Hargray Telephone

Houston, TX

Data Warehousing

Project Manager

  • Project Leader on a business process reengineering project. The project was an enterprise wide effort to retire all VAX/COBOL systems before the year 2000. I was responsible for staffing, training and overall project planning.
  • Function as Technical Lead possessing expert knowledge in: Oracle RDBMS V7, Oracle Designer 2000, Oracle Developer 2000, Full Life Cycle software development methodologies.

Confidential

Rochester, NY

Senior Consultant

  • Function as Technical Lead possessing expert knowledge in: Oracle RDBMS V7, Oracle Designer 2000, Oracle Developer 2000, CASE V5.0/5.1, Forms V4.*, Reports V2.*, PL/SQL,Sql*Loader, C/Proc*C, Full Life Cycle software development methodologies.
  • Established development standards for creating interfaces and custom extensions for Oracle Financials.
  • Mentored associate and staff consultants in the use of Oracle Tools and software development methodologies.
  • Performed Quality Assurance activities on all custom development activities.
  • Designed and implemented a Data Warehouse using Designer/2000 and Developer/2000.
  • Led teams of developers through the phases of Full Life Cycle development as described below.
  • Created class material for and conducted training sessions for Oracle Development tools (Forms 4.5, Reports 2.5, PL/SQL).
  • Participated on Full Life Cycle development projects performing the following tasks:
  • Gathering of user requirements. Analysis of business needs. Modeling of business procedures and data requirements leading to the creation of function hierarchies and entity-relationship diagrams. Designed, built, unit tested and integration tested modules to satisfy identified business requirements.
  • Performed disengagement activities including end user training and documenting system features.
  • Modeled and Implemented mission critical system using CASE 5.1,
  • Forms 4.0, Reports 2.0, PL/SQL.

Confidential

Rochester, NY

Programmer/Analyst, Database Administrator, System Administrator

  • Forms 4.0, Reports 2.0, PL/SQL.
  • Designed, developed and tested a sophisticated item master system that allows engineers and drafters to efficiently search for pre-existing item to prevent the unnecessary proliferation of similar items.
  • Developed custom CASE tools to create and maintain a meta-model for the above mentioned system.
  • Developed code generators for the meta-model mentioned above that would 100% generate database objects (tables, indexes and triggers) and Oracle Forms V3 and V4 for the above mentioned item master system. The combination of the modeling tools and code generators reduced development time from 3 days to 15 minutes per item master family. Cutting the development time to a fraction of what it was allowed me to complete 250 item master families two months before a deadline I was not expected to make. The tools that I created are still in use by regular end users that have created nearly 100 additional families.
  • Created a rules based time and attendance system. The rule base represents the complex union rules that govern the number of hours and the rates paid to union workers. The use of rules has made the adjusting the system to conform to changing union rules a task that is performed by a human resources representative in a manner of minutes what used to take a programmer weeks to do.
  • Created custom extensions and modifications to the Symix business system. Acquired in-depth knowledge of the methods and standards used by Symix that has allowed perfect seamless integration of custom modules.
  • Performed DBA activities for all Oracle and Progress Databases.
  • Responsible for database and system backup and recovery procedures.
  • Installed Oracle, Progress and Symix upgrades and patches.

Confidential

Amherst, NY

Programmer/Analyst

  • Created Oracle Forms V3 for a MRP based business system.
  • Developed C/ProC batch programs.
  • Developed and maintained libraries of C functions that allowed batch programs written in C to access the nearly 300 tables in the application.
  • Developed code generators to create 100% complete code for the above mentioned libraries. The use of these code generators reduced the development time per module from approximately 6 hours to 10 minutes.
  • Developed maintenance utility with a friendly user interface for maintaining the storage parameters for tables and indexes in an Oracle database.

Hire Now