SAM GEORGE
PROFESSIONAL OBJECTIVE
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.
TECHNICAL
STRENGTHS
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.
ACADEMIC
QUALIFICATIONS
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.
EXPERIENCE
PROJECT:
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.
PROJECT:
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.
PROJECT:
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.
PROJECT:
11.5.8
Implementation
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.
PROJECTS:
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
PROJECTS:
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
PROJECTS:
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
PROJECTS:
(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.
January
1995
(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.
PROJECTS:
(1) Programmed reports to specifications using SQR
for the corporate information system. The system uses an Oracle (7.0) database
on a HP9000.
November
1993
(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.
PROJECTS:
(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.