To find a consulting position that requires expertise in Systems Analysis, Database Design and Programming, organizational skills and structured data analysis of logical problems in the Oracle / Oracle Applications arena.
Fourteen Years of Analysis, Design and Database Programming experience, eight years of experience with Oracle Financial Applications (OM, WSH, AR, AP, GL, INV, QP). Experience with Application Upgrades including 11.5.8, 11.5.9 and 11.5.10 . Strong knowledge of Relational Databases, Proficient with ORACLE tools (Developer 9i, Designer 2000, Oracle Forms (6i) & Reports, PL/SQL, Loader, Workflow), Hands-on experience with CASE tools and Database design, Knowledge of Cobol and C, Comfortable with both UNIX and WINDOWS. Experience with the full system development life cycle.
Master of Science in Computer Information Systems
Colorado State University, Fort Collins, Colorado. Graduation: May 1994.
Bachelor of Engineering in Mechanical Engineering
Jabalpur University, Jabalpur, India. Graduation: May 1989.
11.5.9 Oracle Advanced Pricing: Promotional Pricing Implementation
Technical lead and developer for implementing Oracle Advanced Pricing Promotional modifiers. Redesigned and developed the custom pricing API and custom Quote tool to call Oracle Pricing API for implementing Promotional Pricing like Price Breaks and “Buy One Get One” functionality.
11.5.10 Implementation for Marine Division
Jeppesen, a Englewood based company is the industry leader in aviation products. Technical lead for implementing ERP and Supply Chain Suite of Applications for their Marine Division. Responsible for the design, coding and documentation for alerts, interfaces and conversions. Designed and developed a key interface between Oracle applications and Pitney Bowes shipping software. Designed and developed a Cash Management Interface as well as converted Customers from a legacy system (Great Plains) into Oracle’s Trading Community Architecture.
11.5.10 Implementation for KinderCare Merger
Knowledge Learning Corporation (KLC), a Golden based company acquired KinderCare. The project was to bring aboard all of KinderCare’s Legacy System into KLC’s Oracle 11i implementation. This project utilized the Oracle AIM methodology. Responsible for the design, coding and documentation for alerts, forms, reports and interfaces. Responsible for converting Suppliers, Items from legacy system (Lawson) into Oracle 11i. Designed and developed key interfaces between Oracle applications and various external applications for AP Invoices.
Cochlear a Sydney, Australia based company implemented ERP, CRM and Supply Chain Suite of Applications at their US site in Denver Colorado. This project utilized the Oracle AIM methodology. Responsible for the design, coding and documentation for alerts, forms, reports and interfaces. Designed and developed a key interface between Oracle applications and Kewill shipping integration software. Designed and developed a solution for customer agreements as well as designed and developed various reports and alerts including Workflow modifications.
Small Business Administration (11.5.9 upgrade)
Involved in writing technical specification, analysis and development work for implementing the customized transaction code solution for AP, AR and GL in a Federal Financials environment.
Environment: Oracle Applications 11i (AR, OM, AP, GL, INV, SERVICE), C, UNIX (Sun), X Windows, NT, PVCS, Kintana, Oracle 9i: Pro*C, SQL, PL/SQL, Dev, Forms (6.0), Reports (6.0), Financials (11i), Browser, Designer, Workflow
1) Return Material Authorization and Copy Quote
Involved in writing technical specification, analysis and development work for implementing the RMA process at GEAccess.
2) R11i Archiving and Purging (RAP): Assessment Phase.
Assessed business requirements pertaining to data archiving and purging for all applications at GE Access. Generated templates to capture business rules and processes that require data to be available live versus archived. Generated templates to capture technical requirements relating to archiving and purging of application data. Worked closely with business to identify rules for archiving in each business area. Identified and evaluated vendors providing archiving and purging solutions. Developed high level system design including ERD diagrams, purged and archived data flow, technical processes, and, testing strategy. Produced project plan and resource cost estimates.
3) 11i Performance Tuning
Responsible for identifying and resolving performance issues with the 11i standard and custom application.
4) 11i Upgrade
Lead Architect for the Order Management and Sales Compensation development team to upgrade Oracle Applications 10.7 to 11i. Responsibilities include re-designing business and technical processes, interpretation of functional requirements, interaction with users, technical gap and doing technical design for upgrading clients’ application. Developed the prototype for the new custom quote screen and the custom view orders screen to integrate with the 11i application.
Environment: Oracle Applications (10.6/10.7 NCA; CS (Service), AR, OE, AP, GL, INV), C, C++, UNIX (Sun), X Windows, NT, PVCS, Chain Link, Oracle (7.1/7.3): Pro*C, SQL, PL/SQL (2.3), Developer/2000, Forms (4.5), Reports (2.5), Financials (10.6), Browser, Designer/2000
1) Service Module Implementation
Lead Architect for a fifteen-member development team.to implement the NCA Oracle Service Module (CS). Responsibilities included interpretation of functional requirements, interaction with users, technical
gap and doing technical design for interfacing the Service module with the highly customized transaction system (Oracle Apps 10.7). Responsible for the technical side of the project through its entire life cycle including postproduction support.
2) 10.7 Upgrade
Technical Lead for an Oracle Applications 10.6 to 10.7 upgrade. Responsible for evaluating and implementing changes to all customization and extensions in the highly customized Oracle Application (10.6) transaction database. Transaction system includes over 400 custom objects in the Financial, Manufacturing, and Distribution installation.
3) Oracle Applications Implementation
Programmer/Analyst for customizing Oracle Financials and Manufacturing. Programmed the Return Material Authorization screen in Forms 4.5. Coded database packages to integrate Access’ Business procedures with Oracle Order Entry, Oracle Inventory and Oracle Receivables.
April 1996 – February 1998
Senior Consultant: Berger & Co., Denver, CO. September 1995 - March 1996
Consultant: Berger & Co., Denver, CO. September 1993 - August 1995
CLIENT: STOREGETEK. , Louisville CO
(1) Technical lead for a five-member team to analyze, design and implement a corporate wide Subject Database for StorageTek manufactured or marketed products. Technical responsibility for the project through the entire system development life cycle. Used Oracle CASE extensively. The system uses an Oracle (7.1.15) database with the application written in Oracle Forms (4.0). Provided training to other team members for Oracle CASE and Oracle Forms.
February 1995 – September 1995
(2) Performance tuned a couple of Oracle Financials General Ledger reports to reduce the runtime from five hours down to twenty minutes.
(3) Programmed forms and reports to specifications for a problem tracking system. Analyzed, Designed and Programmed a common reporting subsystem for IBM3270, Unix and Mac Users. The system uses an Oracle (7.0) database residing on an MVS mainframe. Development was done on a Unix platform in a Client-Server environment. Programmed in SQL*Forms, Oracle*Forms, SQL*Reportwriter, Oracle*Reports, SQL*Menu, SQL*Plus, PL/SQL and Oracle CASE.
December 1993 - December 1994
CLIENT: WOODWARD-CLYDE GROUP INC., Denver, CO.
(1) Programmed reports to specifications using SQR for the corporate information system. The system uses an Oracle (7.0) database on a HP9000.
(2) Tested and customized a PC based Risk Management Application. Used PC based Oracle database and tools.
September 1993 - October 1993
Consultant: Coopers & Lybrand, Denver, CO. April 1993 - August 1993
CLIENT: CONCEPTS DIRECT INC., Longmont, CO.
(1) Developed applications using Oracle tools. Analyst, Designer and Programmer for the Marketing Subsystem. Programmer for the Telemarketing, Order Entry Subsystems. Programmed extensively in SQL*Forms, SQL*Menu, SQL*Reportwriter, SQL*Plus and PL*SQL. The system uses an Oracle (Version 7.0) database residing on a DG-AV6240 using DG-UX.
Database Designer / Programmer, CSU, Fort Collins, CO. February 1992 - April 1993
Database Analyst/ Designer / Programmer for a Financial Reporting System for Colorado State University. The system used Client/Server architecture with the database residing on a Unix-based Oracle Server and the clients used DOS-based Oracle tools. The system allows users from different departments on the Colorado State University campus to electronically create documents such as Purchase Orders and Requisitions. Wrote triggers and procedures extensively within forms (3.0) to help maintain data integrity.
Systems Analyst / Database Programmer, CSU, Fort Collins, CO. July 1990 - December 1992
Part of a three-member team that designed and implemented a Laboratory Information System for the USDA, Kansas City Technical Center. This system utilized a distributed hardware architecture with the central database residing on the Hewlett-Packard 9000/835 minicomputer on a Unix platform. The application, Sample Tracking Analysis and Reporting System (STARS) was developed using Oracle tools. Programmed the forms and reports for this system.