SUMMARY

• 6 years Supply Chain Management R12 ERP

• 4 years TIPQA knowledge in an Information Technology environment.
• 2 years Perl programming in an I.T. Financial environment.
• 10 years experience hands-on experience with Oracle Financials Applications 11i to R12 - AR, AP, GL, and Cash Management, Open Interfaces and APIs.
• 12 years developing with Oracle Developer (Forms 6i/4.5, Reports 6i/2.5 and Customizing Oracle seeded Oracle Forms/Reports.) Experienced in the customization of pll file extensions and modification within the Application Object Library. Also Forms and Reports in 10g environment.
• 18 years’ experience using SQL and PL/SQL. In 10g and 11g environment.
• 14 years working with and in Oracle 10g/9i/8i/8.0 database and SQL Loader.
• Proficient Interfaces, Data Conversions and Extensions/other Customization.
• Technically Involved in Up-gradation from 11i to R12 for Oracle Modules AR, AP, GL, and Cash Management.
• Customized development for Oracle Financials Module - Data groups, Forms, custom menus, Reports and programs.
• General Ledger (GL) - Set up Multi Currency Processing, revaluations and consolidation, set up open and close periods, set up conversion rules.
• Oracle Application Framework - Tailored the order in which table columns were displayed, tailored query results, tailored the color scheme of UI’s, added new functional flows, extended and overridden existing business logic.
• Extensive knowledge of DBMS, RDBMS and Distributed Databases.
• 6 years writing and maintenance of UNIX shell Scripts and other related tools.
• 5 years Oracle Manufacturing 11i (E Business Suit V11.5.2, V11.5.9, V11.5.10, R12) Data into TIPQA™
• 2 years PL/SQL Web Development using htp and htf Packages.
• Excellent in preparing and writing specifications for updated applications, AIM documentation, user manuals, test procedures, training and document preparation.
• Excellent technical and analytical, problem-solving, inter-personal and communication skills. Excellent team player and willing to work long hours under severe time constraints.
• EPex Engineering Program Execution Tool: MASTER project management tool
• APS Advanced Planning System
• IMPACT Sourcing System
• CAS Calunet Application System

TECHNICAL SKILLS

ERP: Oracle Applications 11.5.10.2 (AR, AP, GL, PO, Cash Management), P roject Costing, Material Resource Planning (MRP), Master Resource Planning (MRP/II), Oracle Manufacturing 11i (E Business Suit V11.5.2, V11.5.9, V11.5.10, R12), TIPQA™, Oracle R12 Supply Chain

Languages:  BASIC, C, C#, COBOL, COBOL II, Enterprise JavaBeans(EJB), HTML, J2EE, Java (JDK), JavaScript, PL/SQL Web Development 10g, Confidential Access Basic 2002-2010, Perl 5.6, PL/SQL, PowerBuilder, SQL, UNIX Shell, VB Script, Visual Basic 6, Visual Studio, XML

OS: AIX, HP-UX, Novell NetWare, OS/2, OS/400, SCO-UNIX, Sun OS/Solaris, UNIX, Windows 2010, Windows 2007, Windows 2000, Windows 2003, Windows 95-98, Windows NT, Windows XP

Networking: Ethernet, SOAP, TCP/IP, IBM Lotus Notes, Groupwise, Confidential Outlook, Clarity, E-Commerce Service Center, HP Openview Service Desk 4.5, ServiceNow R1.5, WinSCP, WindowsPowerShell

Database Tools: SQL*Plus, SQL*Loader, MySQL, Tools for Oracle Application Developer(T.O.A.D.), Graphical Query Language(GQL), CCC Harvest, Dimension R12, Maestro, Oracle SQL Developer, Hummingbird UNIX data base tool

ETL: Informatica, webMethod, AppWorks

RDBMS:  Oracle 10g/ 9i/8i, Oracle 8.0, OLAP Oracle 10g, SQL Server 2008 (SSEE)

Other Databases: MS-Access 2010, IMS 10, Paradox 7.0 - 8.0 for Win 95 / Win NT, Windows XP

Oracle Tools: XML publisher, Confidential Front Page Reports 2.5/6i, Forms 4.5/6i, Discoverer 4i, Workflow Builder. Also in a 10g, 11g environment.

Document Methodologies: AIM methodology

Confidential

Technical Specialist

Responsibilities:

• Powershell Commands - Unix commands to copy license files, move license files in and between server directories for execution.

• LicenseComparator - Tool to determine the differences between new and old license files.
• Applications - Each application used by engineers are monitored by licenses that are controlled based on the time it is issued and the time it expire. Depending on the application each would be located on a different server in one to three environments.
• FLEMgu: Flex License Enumeration, Most Grandly Unified - FLEMgu.xls is an Excel spreadsheet that list all server and application used in GE. With these applications, there are versions and license numbers that must be maintained.
• License files - Each morning the Technical Manager will submit a LIR to either renew license files that are controlled by the License Management Support team.
• Option files - These are the files that determine what user or group of users can view or log into the application indicated via server. These sites applications may hold group access validation rules that may need to be modified before the license file can be renewed.

Confidential,

Technical Specialist

Responsibilities:

• Prepare scorecards/reports for review with the Buyer.

• Confidential Excel Spreadsheet with documented revision dates.
• Scorecard showing status of defined CTQ.
• Detailed database of GE systems to which the spreadsheet was created with documented revision dates.
• Generate a Detailed Program Plan and Development Schedule to develop a functioning spreadsheet.
• Data pulled from a variety of buyer systems which will include:
• EPex APS IMPACT CAS CMT
• Software engineering plan to pull data.
• Data pulled from buyer systems.
• Who or how data will be pulled from buyer systems.
• Test Requirements/Milestones.
• Supplier number “test” runs and supply CMTS to buyer such that a quality review can be completed.
• Test Report Releases.
• Supplier detail test runs in the form of a formal “Test Report” to be reviewed by buyer.

Confidential

Technical Specialist

Responsibilities:

• The Technical Specialist at GE Aviation Cincinnati - Provided consistent communication I.T.

Confidential

Sr. Programmer Analyst 

Responsibilities:

• Oracle database 11i to R12 - In-depth Knowledge

• UNIX - In-depth Knowledge
• PERL - Working Knowledge
• PL SQL In-depth Working Knowledge
• Java In-depth Working Knowledge
• Quality Center In-depth Working Knowledge
• Oracle Forms In-depth Working Knowledge
• Ecommerce Service Center In-depth Knowledge
• Written and Oral Communication In-depth Working Knowledge

Confidential

Sr. Oracle Forms Developer

Responsibilities:

• Oracle Developers Suite - programming in Oracle 10g and higher database environment.

• Designed new Oracle forms applications – Modified Oracle Forms, created multiple TAB on forms.
• Knowledge using Built-in Functions and Trigger. Knowledge coding within Program Units and creating functions, procedures, and setting GLOBAL parameters.
• Experience creating and coding checkbox and radio buttons assigning triggers to items, blocks, and buttons. Coded for blank items, generate generic alert error messages for null values or bad data if exist.
• Experience in PL\SQL PL/SQL packages, stored procedures, functions triggers.
• Created data blocks, data block items, FORM and Block level triggers, triggers to items, LOV’s and Record groups. Set restrictions in property palettes for assigned blocks and items in forms.
• Knowledge using the DEFAULT order by clauses, SET-ITEM-PROPERTY and SET-BLOCK-PROPERTY triggers to validated system data being generated within Oracle Forms.
• Created PL/SQL, SQL, SQL*Plus, and SQL Loader scripts to validate and call stored procedures to validate and populate database objects before generating Oracle Error and Status reports.
• Experienced working with Oracle 9i, 11i, 10g databases.
• Used htp and htf Packages for PL/SQL Web Development to generate tags on Oracle forms, validate data being entered within the web application, and using PLSQL and loader scripts to populate system tables for the Ohio Red website.
• Experience using HTML and JavaScript.
• Excellent using and experience with TOAD to manipulate table structures and analyze data.
• Excellent functional and technical experience in maintenance of SCOTI applications testing application and the deployment of SCOTI application using Forms 6i.
• Working Knowledge of Project Costing – assisted Project Manager with forecasting detailed amount of time needed to implement roll-out, application design time line, selection of contractors and estimated time needed to complete Service Request, material needed to assist I.T. staff with needed resources.
• Provided exception handling mechanisms in an Oracle Application environment and extending Oracle functionality for customizations.
• Created Oracle design functional specifications, and effectively translated business needs/requirements into technical designs.
• Worked with technical teams and project teams in environments requiring significant collaboration and coordination.
• Kept Technical Leads and Project Managers informed of production updates and project status.

Confidential

Business Administrator and Information Systems Consultant 

Responsibilities:

• Developed E-Business Suite programs for databases supporting supply chain management, order management, inventory, warehouse management system, purchasing, and iProcurement.

• Designed and implemented error checking and correction protocols and PLSQL package programs.
• Built Internet access and GUI interfaces to Relational Database Management Systems (RDBMS).
• Using PL/SQL, SQL, SQL*Plus – SQL Loader. Extensively coded, tested, debugged, documented, and maintained Oracle PLSQL programs.
• Created detailed project outlines, application design specifications, and test plans.
• UNIX Scripts - Worked extensively on the UNIX, AIX UNIX, Sun Solaris UNIX platforms. These scripts were developed to Perform several different tasks.
• Project Costing – Project Manager – Assigned projects to FTE’s for fiscal year. Forecast detailed amount of time needed to implement roll-out projects including application design, time lines, selection of additional contractors and estimated time needed to complete Service Request. Also, assigned cost of material to projects needed to assist I.T. staff with needed resources.
• Developed UNIX scripts that automated the process for posting inventory transactions for General Ledger. Developed UNIX scripts to call stored procedures for generating financial reports on a daily, weekly or monthly basis. Developed several scripts to facilitate the source code in stored procedures, control processing for Oracle stored procedures.
• Working with Oshkosh Corporation in Wisconsin - training and familiarity with Material Resource Planning and Master Scheduling Planning Modules and development techniques. (Six weeks).

Confidential

Oracle Financial Application Developer

Responsibilities:

• Installed, administrated and implemented (Oracle e-Business Suite) R11 and R12. Participated in the development of API for creating EXCEL reports for Oracle E-Business Suite using the HTML, XML output and XML template without using Publisher.

• Develop various Oracle Applications using PL/SQL, SQL*Plus, SQL Loader, Forms, Reports, Workflow Builder, and Application Object Library.
• Use Oracle E-Business Suite applications for accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and cash management, supporting data extraction, filtering, and validation.
• Migration of existing Oracle 11.5.9 to 11.5.10 by implementing Oracle GL, AP & FA modules. The objective of this implementation is not only to upgrade but also to bring two different businesses from different environments onto a single instance.
• Preparation & running of Test scripts, using PL/SQL, SQL*Plus, Interaction with Client / Users, Preparation of Reports using Oracle Discoverer 10g,Validation of Data Migration and data loading, Preparation of training materials, End user training.
• Migration of existing Oracle 11.5.8 to 11.5.10 by implementing Oracle AR, AP, GL, and Cash Management modules. The objective of this implementation was not only to upgrade but also to bring two different businesses from different environments on to a single instance.
• Worked alongside of the project manager and gathered all needed technical plus functional requirements which were delivered to DBA’s, I.T. departments for database structure support users. Followed and worked through all Software Development Lifecycle (SDLC) phases.
• Create extensions using Oracle recommended frameworks. Report against Applications data model.
• Write technical design documents for conversions, extensions, interfaces, and reports.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.
• Assisted in design of tables using PL/SQL, SQL*Plus,, databases, forms, and reports; connected forms with Oracle Applications.
• Working Knowledge of Project Costing – assisted Project Manager and Team Lead with forecasting detailed amount of time needed to implement roll-out, application design time line, selection of contractors and estimated time needed to complete Service Request, material needed to assist I.T. staff with needed resources.
• Gathered application requirements and provided design recommendations.
• Helped design custom data models that integrated with Oracle Applications.
• Oracle hands-on for version 11.6.0, RDBMS 8.1.7.1.0. Setup and configured Oracle Inventory Control, Oracle General Ledger, Oracle Accounts Payable, Oracle Cash Management, Oracle Projects, Oracle Fixed Assets and Oracle Order Management with Advanced Pricing