Rodney S. Kaler

***** ** ***** ****. ***** #**

Portland, OR 97230

E-mail: RodneyKallar0115@hotmail

I thrive in environments where alternative designs are needed or unorthodox solutions to computing problems are required. I enjoy working on interesting enterprise level projects either a small team or as a member in a large long project. The more difference the assignment is, the more I enjoy finding the solution.

PROFESSIONAL SUMMARY:

I am someone who is self-starting, self-motivated, with a positive attitude, is honest with a professional demeanor and respectful of others and their abilities and responsibilities. Proven ability to lead or follow in a time-constrained and team-oriented environment while maintaining effective working relationships with peers.

I thrive in environments where alternative designs are needed or unorthodox solutions to computing problems are

required. I enjoy working on interesting enterprise level projects either a small team or as a member in a large long

project. The more difference the assignment is the more I enjoy get finding the solution.

I am willing to take on any and all responsibilities and duties that are assigned to me and complete them in a timely and professional manner either as a project lead or work collaboratively in a group or groups, wealth it be the end users, fellow developers, business analysts, IT or IS staff members.

I provide many things to a team, base on my personal experiences I add value to areas of services of design, development, implementing, extending/customizing, upgrading, consolidating, migrating, data migration, data conversion, data mapping, trickle loading, and testing Oracle Applications (EBS) across various private and public sectors.

Proficient List ( well advanced in an art, occupation, or branch of knowledge ) list of skill sets:

Oracle RDBMS: (1987 to 2009)

- Certificated Oracle DBA 5.x, 6.x, 7.2.x, designer/developer 7.x to 10g.

- Developer and Designer 6.i, Forms 4.x to 6i, Reports 4.x to 6i, Report Writer, SQL*Net, SQL*Loader, SQL*Plus,

PL/SQL 1.x to 9i.

- Oracle Application Server (OAS), Oracle WebLogic, Oracle SOA, CVS, XM, ADI, Workflow Builder, DataLoad,

Oracle DB Web, Oracle Gateway.

- Quest Software: SQL Navigator, SQL Optimizer for Oracle, SQL Impact, SQL Xpert, SharePlex, Schema Manger,

I/O Data Monitor, Space Manager, Toad Data Modeler and TOAD, Erwin.

- Oracle 10.1 E-Business Suite - GL, INV, BOM, WIP, Workflow, Multi-Org configurations

Microsoft products: (1982 to 2010)

- Office products: Word, Excel, Visio, PowerPoint, Access, OutLook, Project.

- MS SQL Server 7 - Visual Basic 5 & 6 - Visual SourceSafe

Language list (this is only a summary of difference languages that I have used, just a few key example):

Assembly (8088, Z80), BASIC (10 - dialects and compilers - plus), Borland (Turbo Pascal and Delphi),

Bourne shell (bash and ksh), C, COBOL 77, dBase, FORTRAN, FoxBase, FoxPro, HyperTalk,

HXML, IBM (Basic, Dos, Informix-4GL), LISA, Oracle, PASCAL, PERL, PILOT, PL/SQL, PostScript,

QBASIC, RPG I & II, Unix shell, XML, ZBASIC (renamed it FutureBASIC).

Proficient in Oracle Applications system administration activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, and add on GUI interfaces.

Strong expertise in applying Oracle AIM methodology to design and develop all types of Oracle items - Reports, Forms, Interface, Conversions, Migration, Extensions/Customizations and Workflows.

Strong programming experience in creating Oracle Procedures, APIs, Forms, Reports, Packages, Functions, Triggers, Table Spaces, Indexes, Data Dictionary Objects, Workflows, Alerts and other objects.

Complete experience of all phases of project lifecycles: discovery and analysis, design, development, implementation, testing, documentation and post-production support, 24/7 help client level, 24/7 help for the Help Desk, on call 24/7 for problems in/or with Oracle GUI’s developed and implemented.

Develop and maintain technical documentation including but not limited to design specifications, architectural diagrams, user guides, etc.

Ability to learn and apply new technologies, to grasp the big picture and follow through from design to implementation while maintaining excellent attention to detail, to work with third-party vendors to implement applications or procedures based on specifications.

Discipline to provide documentation and maintainable code for future users and developers.

Analyze functional requirements and develop of new product functionality.

Develop design specifications and influence system architectural direction.

Implementation of new interfaces with customer legacy systems.

Very experienced in software version/change control, configuration management, test strategies baseline testing, functional/integration testing and regression testing.

Develop test strategy and test cases for integration testing of developed system components.

Excellent understanding of Oracle Applications data flow and the underlying technical aspects.

Strong experience in using Oracle Middleware technology (SOA, Oracle Service Bus and ADF) to design and implement web services and web applications.

In-depth knowledge of the business functionality of Oracle RDBMS.

TECHNICAL SKILLS:

Titles: Technical Data Architect, Senior System Analyst, Oracle DBA, Senior Business Analyst, Senior Programming Analyst, System Analyst, Designer/Developer for Business Enterprise Level Applications in both Logical/Physical Schemas, Designer/Developer for Data Warehouses/Data Mining, UNIX HP/SCO admin.

RDBMS: Oracle (certificated DBA in 5.x, 6.x, 7.3.x), MS-Access, MS SQL Server 7, AS 400-DB/2, DBASE II, Quattro Pro and any other major RDBM systems developed for single instances on PC’s between 1986 and 1997.

Modules: Oracle E-Business Suite - GL, INV, BOM, WIP, Workflow, Multi-Org configurations. Oracle E-Business Suite (Oracle Supply Chain Management (SCM), Customer Relationship Management (CRM), Integrated Point of Sales (POS)), Oracle SOA

Tools: Oracle Developer and Designer 6.i , Reports2.5/6i/9i, Forms4.5/6i/9i, Discoverer 4i/9i , Oracle Application Server (OAS), Oracle WebLogic, , SQL*Loader, SQL*Plus, PL/SQL 1.x to 9i, CVS, XM, ADI, Workflow Builder, DataLoad, Quest Software: SQL Navigator, SQL Optimizer for Oracle, SQL Impact, SQL Xpert, SharePlex, Schema Manger, I/O Data Monitor, Space Manager, Toad Data Modeler and TOAD, Erwin, Microsoft Office, Metamatrin, EDS, and API middleware, etc. etc.

Operating systems: UNIX (HP-(3000/9000)/SCO/Sun Solaris), Windows MS-DOS 1.x to 6.x, Window’s Workgroup 3.11/95/98/NT/XP/Vista/7, MS-NT Server, Linux.

Enterprise Resource Planning (ERP): Experiences in manufacturing, warehousing and shipping.

Expired in Extract, Transform, Loading (ETL)

Data warehousing tools: (SSIS - SQL Server Integration Services, It is a Data Warehousing Tool,

MS Visual Studio 2008, MS SQL, MySQL, Transact-SQL

EDUCATION:

Associate in degree in Business/Hospitality Management.

Associate of General Studies (AGS) from PCC, Portland Oregon.

Bachelor of Science (B.S.) from PSU, Portland Oregon, 1989.

PROFESSIONAL EXPERIENCE (WORK HISTORY SUMMARY):

Period from May 2011 to Sept 2011 on sabbatical (Research into A New Data Storage Format)

Company: Joe’s & Rod’s Restaurant

Role: Owner and General Manager

Period: Nov. 2008 Mar. 2011

Key Responsibilities: Part owner and General Manager of Joe’s & Rod’s Restaurant in Spokane, Washington.

The restaurant was computerized under my supervision with a POS (Point Of Sales) system call Focus Solutions developed by RCS Houston.

Created many data interfaces between POS and inventory system modules of Focus between Oracle in house application running under UNIX and Oracle 10g Was total respond able for the computer systems, development, maintaining the Unix (Admin) and Oracle (DBA).

The interfaces would translate, rearrange, convert, and migrate, day to day information (POS and inventory data) from Focus system to my Oracle instance in real time. Where I developed relation data mart, views, queries and reports that improved the performance of the staff, service to our customers, inventory control, reordering and scheduling when to reorder, reordering packaging supply lists which help reduce the need to maintain a large, perishables and expensive inventory.

Company: BLT. Net

Role: Oracle specializes

Period: 2006 to 2008 (18 months)

Key Responsibilities: Was hired as an employed by BLT telecommunication company located in Portland Oregon as a technical data architect, PL/SQL developer, support for DBA staff. Also managed the data conversion, migration and restructuring of their Oracle 7.x and 8i product instances, which there was 7 individual applications into three Oracle 9.i applications (AP, AR, POS) before BLT became part of the Verizon network.

Company: Cascade Software Consulting

Role: Staff consultant / recruiter, site consultant specializing in Oracle

Period: 2005 to 2006

Key Responsibilities: Staff consultant / recruiter, site consultant where I send much of my time training others in PL/SQL, stored processors, logical and physical schemas designs for data warehouses for contacts with HP in Vancouver Washington, Pet Hospital in Portland Oregon

Period: 2003 to 2005 (18 months) Home care for my wife that was recovering from a stoke she had, help in her recovery, outpatient therapy and home therapy. Worked only on two to three week projects so that I had time for my wife.

Company: OnLine Sales (Egghead Corporation)

Role: Oracle migration specializes

Period: Feb 20002 to June 2003

Key Responsibilities: Finish up the conversion and documentation of Egghead’s E-Commerce business.

See Egghead Corporation.

Company: Egghead Corporation

Role: Technical Data Architect, Senior System Analyst, Oracle DBA

Period: Feb 2001 June 2003

Key Responsibilities: Was employed by Egghead at Vancouver office as technical data architect, Oracle DBA to work with other staff member for migrating old legacy HP 3000, UNIX/Oracle E-Commerce business (est. $364,000,000.00 sales, 4th largest on line seller) to new Window NT servers, design new database from moving their data on a HP 3000 to Oracle 7.i, manage the data migration and conversion of 3.4 millions records into Oracle, developed the backend oracle PL/SQL stored processors, trouble shooting Oracle and VB issues. VB was used as the front end GUI on the new web site being developed. Remain with firm for 8 months after they enter bankruptcy which (the web site, data and applications) was later sold to Online Sales that developed the current Fry’s online web site. Much of the backend applications are using the code and design that was developed at Egghead.

Company: Emery Global Logistics (CNF Company)

Role: Technical Data Architect, Senior System Analyst, and Designer/Developer

Period: Dec 2000 to Feb 2001

Key Responsibilities: Migrate and convert the MLG ORS project to Emery World Wide, GM Project rename to Vector SCM. A $500,000,000.00 10 years contact for EWW and Server Logic Corporation (SLC) to re-engineering MLG ORS too handle the transportation issues and auditing for GM automobiles from their YELLOW line (point where the automobiles leave the manufacturing center) to dealerships in North American and Canada. Using Design/Developer 6i and Oracle’s JD Edwards - Enterprise One for supply chain planning, on Sun UNIX systems. A little over 9 months in to the project it was put on hold. Two years later the ORS system was sold to UPS and is current part of their auditing and tracking system that is now available on their web site.

Company: Intel

Role: Oracle specializes and PL/SQL specializes

Period: Oct. 2000 to Nov. 2000

Role: Oracle specializes

Key Responsibilities: Debugging, rewriting, cleaning up PL/SQL code, stored procedures and packages written by other contractors.

Company: Menlo Logistics (CNF Company),

Role: Oracle specializes, Oracle Financial specializes, and Oracle PL/SQL specializes

Period: Aug. 1997 to Sept 2000

Overview of ORS (MLG): OMS (OLTP) on a IBM AS/400 DB/2, IMS (OTLP) on a IBM AS/400 DB/, SMS (OLTP) on a Informix, WMS (OLTP) on a Informix, EDI’s via VAN from IBM Mainframe Legacy (CNF) and FTP flat files. This data was migrated, mapped and remapped, conversion, consolidated into ORS for auditing client alerts and progress on TL’s and LTL’s movements of 10’s of million of dollars that moved daily through their systems. Data transfer in the form of EDI’s (inbound/outbound), all reports were developed and stored at a level, that the client users could access using our specially designed Web site, which each client users could access their own data sets. These client level users could download their data in the following formats: plain text flat files, *.csv, *. txt, *.doc, *.pdf, *.xls, *.xlt, *.dbf, *.dif, etc. Basically a data warehouse in 1997 & 2001.

Key Responsibilities: Hired as a consultant to Menlo Logistics as a specializing in Oracle RDBMS 7.x and Oracle Financial – Inventory module and multi-org developer for enterprise level business applications for a Nike project. To development an applications/processes for Nike to track and report, government (EU) shipment information for duties inbound/outbound requirements on goods being shipped through custom warehouses in Europe (EU). The project was put on hold. This was the third time that a consulting firm (Anderson Consulting) tried to develop a plan for Nike. And then became an employee half through the development of a project called Order Response System.- ‘ORS’, to replacement a $3,000,000.00 plus software package called GLS, a solution for producing an inter-national required import/export documents for goods moving from one country to another.

One of three code system/application developers that design and implemented new modules into Menlo Logistics Supply Chain Management System (SCMS). Successfully designed, implemented and supported Order Response System (ORS) and Shipment Management System (SMSv2). Using Oracle tools, Designer 2000 (1.3 to 6i), Developer 2000 (1.3 to 6i) and Forms 6i, Reports 6i, Oracle DB Web, Oracle Application Server (OAS), HTML's, Oracle Gateway, and PL/SQL packages and processors. Development of interfaces for accessing data schema's on IBM AS400/DB2, Informix feeds, FTP feeds and EDI's. Develop, enhance and support ORS (Order Response System). This application was in-house systems developed using Oracle databases, Oracle Designer 2000 and Developer 2000 tool sets. The applications used Oracle gateways to manage access between the Oracle databases and other non-Oracle databases, Informix, and DB2.ORS is a rules based application providing real time alerts to client operations when customer's business rules have been violated by a trading partner in the supply chain. SMS is a rules based application providing decision support for transportation operations and management of shipping transactions. These are three tiered client server applications. The client access their information via Web site, enabled for both the Internet and Intranet access. Also initiating changes in the trading partner applications with heavy electronic interface between customer systems, various Menlo applications and other third party/partner applications (SAP), Oracle Financial, PeopleSoft, and Bon. Other actives at Menlo Logistics, support for DBA staff, CSR's business analyst, EDI, online 24 by 7 support for SMSv1, SMSv2

Designed and implemented database tables, table spacing, triggers, PL/SQL packages and processors in Oracle //Unix//other systems for transfer of data in either flat files (single or multiple rows) in inbound and /or outbound Edie's ( 210's, 211's, 214's, 850's, 856's, 940's, 945's (3030 and 3050 standards) to client host systems. The modules ware developed for a one instance, multi-org product system on HP/9000 (ORS/SMSv2) system servicing 6 major clients (HP, HP/SAP, IBM old version, IBM new version, DOW, Frigid, Home Depot, Sear) with over 1200 users accessing their data via Web interface application developed on their individual business rules requirements. Client user GUI application for updates and reports via specially built Web site that interface with ORS on the Internet using Oracle PL/SQL OAS interface for data transfer of EDI’s (inbound/outbound) to or from Oracle RDBMS 8i, 9i product instance. All reports were developed and stored at a level, that the client users could take advantage of using their own limits of their PC’s. Download format was in: plain text flat file, *.csv, *. txt, *.doc, *.pdf, *.xls, *.xlt, *.dbf, *.dif, etc.

HP 9000 Unix/Oracle -

IBM Legacy (CNF) -

IBM AS400 / DB2 (MLG) -

IMS (MLG) - Inventory Management System, IBM AS400 / DB2 (OLTP).

OMS (MLG) - Order Management System, IBM AS400 / DB2 (OLTP).

WMS (LMG) - Warehouse Management System, Informix (OLTP).

SMSv1 (MLG) - Shipment Management System, Informix (OLTP).

ORS (MLG) - Order Response System. Oracle 8i, 9i (Data Warehouse, Auditing).

SMSv2MLG) - Shipment Management System, (developing as replacement for SMSv1 in Oracle in 9i ).

OMSv2 (MLG) - Order Management System, (developing as replacement for OMSv1 in Oracle in 9i ).

Special Areas: EDI’s - 3030 or 3050 ISO standards (X12). 210’s, 214’s , 940’s , 945’s, 850’s, 856’s (custom interfaces for each client base on their special businesses rules - client level).

Company: Intel Corporation

Company: Esco Corporation

Company: Sequent Computer Systems

Company: City of Portland (Bureau of Buildings)

Company: Oregon Dept of Environmental Quality (DEQ)

Company: Tektronics

Company: Washington Water Power (now AVista)

Company: Smith Home Furniture

Company: ADP- Role: Programmer Analyst, Pick Basic, Data Conversion and modeling - consulting

Company: Metropolitan Savings Association

Company: Multnomah County Sheriff Department (SIU) - Role: Special assignment in the SIU

Company: Smith & Kline Inc.

Company: CMD Transportation General.

Company: Ringside Restaurant Inc. - Role: Employee: Waiter, Programmer and developer

Period: 1980 to 1988

A CONSULTING FIRMS AND / OR EMPLOYERS:

Cascade - Cascade Software Consulting, staff consultant, site consultant.

ComSys - Consulting Firm, site consultant.

SLC - Server Logic Corporation, staff consultant, site consultant.

UDP Consulting site consultant,

CMSI site consultant, account & recruiter,

FDSI - FDSI Consulting a Cotelligent, site consultant.

CNF - Con-Way

MLG - Menlo Logistics a CNF Company, site consultant, employee.

EWW - Emery World Wide a CNF Company, GM Project Vector SCM ( SLC ).

MWL - Menlo Worldwide Logistics, Emery Global Logistics ( EGL ( EWW ) ) + MLG + Vector SCM site consultant, employee.

Egghead - Egghead Inc, employee, Technical Data Architect, Designer / Developer.

BLT - Telecommunication Company, employee, Technical Data Architect,

PL/SQL, support for DBA staff

CLIENT SITE SUMMARY: Egghead Corporation, Intel Corporation, PF. Net, Emery Global Logistics (CNF Company), Menlo Logistics (CNF Company), BLT, Esco Corporation, Sequent Computer Systems, City of Portland (Bureau of Buildings), Oregon Dept of Environmental Quality (DEQ), Tektronics, Washington Water Power (now AVista), Smith Home Furniture, Multnomah County Sheriff Department (SIU), Smith & Kline Inc., ADP, Metropolitan Savings Association, Ringside Restaurant Inc., CMD Transportation General.

EDUCATION:

Associate in degree in Business/Hospitality Management.

Associate of General Studies (AGS) from PCC, Portland Oregon.

Bachelor of Science (B.S.) from PSU, Portland Oregon, 1989.

TRAINING CERTIFICATES: Oracle: Applications System Administration, Oracle: Developer: Build Forms, Oracle: Developer:: Build Reports, Oracle: Introduction to Oracle SQL and PL/SQL, Develop PL/SQL Program Units, SQL Statement Tuning, Oracle Database 7.x/8i/9i: Advanced PL/SQL ED, Develop Web Services ED, DBA 5.x/6.x/7.3.x, HP/SCO: Fundamentals of Unix System and Admin.

100's of hours in computer languages, design, development, and applications, plus on the job required courses.

Rodney S. Kaler

15908 NE Sandy Blvd. Suite #57 Portland, OR 97230

E-mail: RodneyKallar0115@hotmail

I thrive in environments where alternative designs are needed or unorthodox solutions to computing problems are required. I enjoy working on interesting enterprise level projects either a small team or as a member in a large long project. The more difference the assignment is, the more I enjoy finding the solution.

PROFESSIONAL SUMMARY:

I am someone who is self-starting, self-motivated, with a positive attitude, is honest with a professional demeanor and respectful of others and their abilities and responsibilities. Proven ability to lead or follow in a time-constrained and team-oriented environment while maintaining effective working relationships with peers.

I am willing to take on any and all responsibilities and duties that are assigned to me and complete them in a timely and professional manner either as a project lead or work collaboratively in a group or groups, wealth it be the end users, fellow developers, business analysts, IT or IS staff members.

One outstanding characteristics about me is … I think outside of the box or another way of putting it from an analyst point of view is … if you can should me how you can do that, I will find away to reproduction that as an application or in a function … I also practice the black box theory methodology.

I provide many things to a team, base on my personal experiences I add value to areas of services of design, development, implementing, extending/customizing, upgrading, consolidating, migrating, data migration, data conversion, data mapping and testing Oracle Applications (EBS) across various private and public sectors.

Proficient List - skill sets:

Oracle RDBMS: (1987 to 2009)

- Certificated Oracle DBA 5.x, 6.x, 7.2.x.

- Developer and Designer 6.i, Forms 4.x to 6i, Reports 4.x to 6i, Report Writer, SQL*Net, SQL*Loader, SQL*Plus,

PL/SQL 1.x to 9i.

- Oracle Application Server (OAS), Oracle WebLogic, Oracle SOA, CVS, XM, ADI, Workflow Builder, DataLoad,

Oracle DB Web, Oracle Gateway.

- Quest Software: SQL Navigator, SQL Optimizer for Oracle, SQL Impact, SQL Xpert, SharePlex, Schema Manger,

I/O Data Monitor, Space Manager, Toad Data Modeler and TOAD, Erwin.

- Oracle 10.1 E-Business Suite - GL, INV, BOM, WIP, Workflow, Multi-Org configurations

Microsoft products: (1982 to 2010)

- Office products: Word, Excel, Visio, PowerPoint, Access, OutLook, Project.

- MS SQL Server 7 - Visual Basic 5 & 6 - Visual SourceSafe

Proficient in Oracle Applications system administration activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, and add on GUI interfaces. Strong expertise in applying Oracle AIM methodology to design and develop all types of Oracle items - Reports, Forms, Interface, Conversions, Migration, Extensions/Customizations and Workflows.

Strong programming experience in creating Oracle Procedures, APIs, Forms, Reports, Packages, Functions, Triggers, Table Spaces, Indexes, Data Dictionary Objects, Workflows, Alerts and other objects.

Complete experience of all phases of project lifecycles: discovery and analysis, design, development, implementation, testing, documentation and post-production support, 24/7 help client level, 24/7 help for the Help Desk, on call 24/7 for problems in/or with Oracle GUI’s developed and implemented.

Enterprise Resource Planning (ERP): Experiences in manufacturing, warehousing and shipping.

TECHNICAL SKILLS:

Titles: Technical Data Architect, Senior System Analyst, Oracle DBA, Senior Business Analyst, Senior Programming Analyst, System Analyst, Designer/Developer for Business Enterprise Level Applications in both Logical/Physical Schemas, Designer/Developer for Data Warehouses/Data Mining, UNIX HP/SCO admin.

EDUCATION:

Associate in degree in Business/Hospitality Management.

Associate of General Studies (AGS) from PCC, Portland Oregon.

Bachelor of Science (B.S.) from PSU, Portland Oregon, 1989.

Was one of three project leads for Order Response System ORS (MLG), from a new idea for a replacement of an application called GLS. From developing speculations, designing, development, implications, upgrades, maintaining, trouble shoots client users problems produce system action issues, 24/7 support for over 7 differences clients on the same application with difference Business Rules being applied. Over 800 client users accessing their data, reports (Oracle Report 6i, Excel, *.DOC, HTML’s, Web Pages, *.FTP, *.PDF, *.TXT) and doing their updates via a Web Site which we also developed.

Became the sole owner of the ORS for 6 months before moving to new MLG SMSv2 Development.

This diagram summary of the ORS ( Order Response System)

*) From being inspiration to the end production product.

*) $5,000,000 for old GLS system (be replaced – MS SQL servicer, third party

application (GLS)) plus enhancements .

*) ORS project from start to production, less than14 months, 3 project leas, when

fully staffed at 60 or so people, at a cost less than $800,000.00.

*) Original design was for one client (HP) with two difference divisions (old legacy

and new HP SAP systems).

*) Within one year of being online, management sold the product to other clients (IBM

legacy, IBM new, Dow, Sear, Home Depot,Whirlpool, etc.), all with difference

business rule being applied in the application (ORS).

*) This diagram was developed as a high overview for management of ORS in MS Visio,

MS Excel and migrated to MS Word with 100’s of foot notes in many attachments

(PL/SQL code, Package, Stored processors, DB triggers, DDL Specs.) Showing a step

by step, work flow of ORS, it modules interface with users.

Contact this candidate