SUMMARY:

33 years of experience in the design, development and support of business software applications to include Oracle Applications, PeopleSoft, SAP, Great Plains, Manugistics, QAD Enterprise Edition.

DESIRED POSITION S :

Oracle Developer, Technical Lead, Project Manager

SKILLS INVENTORY:

Applications: Oracle Applications eBusiness Suite Version R12, v11i, v10, v9, v8. Oracle GEMMS, Manugistics, Oracle Daily Business Intelligence DBI for Financials and Supply Chain.QAD Enterprise Edition.

Operating Systems: AIX, HP-UX, Linux, Microsoft Windows, Microsoft Windows XP, Microsoft

Windows NT, DEC Open VMS, POSIX, SunOS, Ultrix.

Databases: IBM DB2, Oracle v7, Oracle v8i, Oracle v9i, Oracle v9iAS, Oracle v10g, Oracle v10gAS, Oracle 11g, MS SQL Server 2003.

Dev. Tools/Languages: Crystal Reports, Java, Oracle Applications Framework OAF , Oracle

Designer v9i, Oracle Developer/2000, Oracle Discoverer v3, Oracle

Discoverer v4i, Oracle Discoverer v10g Business Intelligence, Oracle

Business Intelligence Enterprise Edition OBIEE , Oracle Forms versions

v2.0, v2.3, v6i and v10g, Oracle PL/SQL, Oracle JDeveloper, Oracle

ProC., Oracle Reports Builder v6i and v10g, Oracle SQL/Plus, Perl, SQL

Navigator, TOAD, Transact SQL, Unix C, Oracle API, Oracle Open

Interfaces.

Utilities: AIM Methodology, CC Harvest, ERWIN, Kintana, Logical Apps, Mercury,

Oracle TKPROF, Oracle Explain Plan, NoetixViews, PVCS, Remedy,

Unified Modeling Language UML , Visio, Visual Source Safe, Oracle

XML Publisher, Oracle BI Publisher also known as XML Publisher ,

Oracle GUI Loader Data Loader , Vertex Reporting and Geo Coding,

Covisint EDI.

Desktop Software: Microsoft Access, Microsoft Office Word, Excel, Powerpoint , Microsoft

Projects.

JOB HISTORY:

Confidential

Sr. Techno-Functional Consultant

• Primary duties include the design and development of operational reporting within an Oracle Applications R12 environment. Secondary duties include functional related design and development of new/changed business processes which also includes heavy data analysis and troubleshooting tasks.

Apps/Tools Used:Oracle Applications R12, i.e., Financial application modules General Ledger, Payables, Project Accounting, Purchasing, Receivables, Inventory, Cost Management, Project Contracts, Fixed Assets . Oracle PL/SQL, Oracle SQL/Plus, TOAD, Oracle Reports Builder, BI Publisher.

Confidential

Sr. Techno-Functional Consultant Technical Lead

• Design and develop Oracle programs that extract, transform and load data during a conversion from Oracle Applications eBusiness Suite version 11i to the QAD Enterprise Edition business system. Gather and translate data requirements to formulate the scope and specifications for the data migration solutions. Coordinate and lead technical and functional resources in the design and construction of data migration solutions. Participate in planning and coordination with management including the CIO.
• This work also involved heavy analysis and design to map the data and identify the data gaps.

Apps/Tools Used: Oracle eBusiness Suite version v11i, i.e., Financial/Manufacturing application modules General Ledger, Order Management, Payables, Project Accounting, Purchasing, Receivables, Bill of Materials, Inventory, Cost Management, Service Contracts, Shipping Execution, Warehouse Management, Work in Process . QAD Enterprise Edition involving Financials and Manufacturing application modules. Oracle data loader, Oracle PL/SQL, Oracle SQL/Plus, TOAD, Oracle Reports Builder, API, Open Interfaces.

Confidential

Sr. Techno-Functional Consultant

• Design and develop Oracle programs that extract, transforms and loads data for an upgrade from Oracle Applications eBusiness suite version 11i to Oracle Applications eBusiness Suite version R12. This work also involved heavy analysis and design to map the data and identify the data gaps.

Apps/Tools Used: Oracle eBusiness Suite version v11i and R12, i.e., Financial/Manufacturing application modules General Ledger, Order Management, Payables, Project Accounting, Purchasing, Receivables, Bill of Materials, Inventory, Cost Management, Service Contracts, Shipping Execution, Work in Process . Oracle data loader, Oracle PL/SQL, Oracle SQL/Plus, TOAD, XML Publisher, API, Open Interfaces.

Confidential

Sr. Techno-Functional Consultant/Architect

• Design and develop Oracle programs in support of the Company's production system. Gather and analyze requirements for various incidents or service requests in support of the Company's production Oracle eBusiness Suite v11i business system. The enhancements related to Accounts Payable, Accounts Receivable, Cost Management, General Ledger, Inventory, Order Management, Project Accounting, Purchasing, Service Contracts and the Shipping Execution application modules.

Apps/Tools Used: Oracle eBusiness Suite version v11i, i.e., Financial/Manufacturing application modules General Ledger, Order Management, Payables, Project Accounting, Purchasing, Receivables, Inventory, Cost Management, Service Contracts, Shipping Execution . Oracle Discoverer v4i, Oracle PL/SQL, Oracle SQL/Plus, TOAD, XML Publisher, API, Open Interfaces.

Confidential

Sr. Applications Manager/Architect, Business Systems.

• As the Applications Manager, manage the analysis, design and support of the Company's business system called Oracle eBusiness Suite R12. Manage resources involved in the conception and design of business software solutions. This also includes managing outside contractors such as a consulting company for both on-shore and off-shore development. Provide technical and functional support for the EDI related business processes where IBM Sterling EDI translation software is used. Supported systems also include business intelligence/data mart, Demantra, Hyperion and other data warehouse solutions.

Apps/Tools Used: Hyperion, Oracle Applications eBusiness Suite R12, i.e., Financial/Manufacturing application modules iExpense, Cost Management, Incentive Compensation, General Ledger, Subledger Accounting, HRMS, Order Management, Payables, Purchasing, Receivables, Inventory, Service Contracts, Shipping Execution, Bills of Material, Advanced Supply Chain Planning including Demantra , MPS/MRP, Work in Process , IBM Sterling EDI Translator, Oracle Data Integrator ODI , Oracle PL/SQL, Oracle SQL/Plus, TOAD, BI Publisher, API, Open Interfaces, Workflow Builder 2.0, Approvals Management AME .

Confidential

Sr. Techno-Functional Consultant/Architect

• Design and develop Oracle programs in support of the Company's production system. Gather and analyze requirements for various incidents or service requests in support of the Company's production Oracle eBusiness Suite v11i business system and in preparation for an upgrade to Oracle eBusiness Suite R12. The enhancements related to Accounts Payable, Accounts Receivable, General Ledger, Inventory, Order Management, Service Contracts and the Shipping Execution application modules. Involved in the analysis and design of changes to the integration of inventory items/BOMs between Oracle and Agile.

Apps/Tools Used: Oracle eBusiness Suite version v11i, i.e., Financial/Manufacturing application modules General Ledger, Order Management, Payables, Purchasing, Receivables, Inventory, Cost Management, Service Contracts, Shipping Execution . Oracle PL/SQL, Oracle SQL/Plus, TOAD, XML Publisher, API, Open Interfaces.

Confidential

Sr. Techno-Functional Consultant/Architect

• Design and develop Oracle programs in support of the Company's production business system. Gather and analyze requirements for various incidents or service requests in support of the Company's production Oracle eBusiness Suite v11i system. Develop 1099 form using XML Publisher.

Apps/Tools Used: Oracle eBusiness Suite version v11i, i.e., Financial/Manufacturing application modules General Ledger, Payables, Purchasing, Receivables, Project Accounting, Inventory, Cost Management, Bills of Material, Work in Process . Oracle PL/SQL, Oracle SQL/Plus, TOAD, XML Publisher, API, Open Interfaces.

Confidential

Sr. Techno-Functional Consultant/Architect

• Provide senior level support for developing, setting up, and running tests for data migrations using PL/SQL and Mercury software. This was part of a Oracle eBusiness Suite R12 upgrade for the largest utility company ConEdison in New York State involving Receivables, General Ledger, Payables, Purchasing and Project Accounting data and application modules.

Apps/Tools Used: Oracle eBusiness Suite version R12 Financial application modules General Ledger, Subledger Accounting, Payables, Purchasing, Receivables, Project Accounting .Oracle PL/SQL, Oracle SQL/Plus, TOAD, API, Open Interfaces, Mercury software.

Confidential

Sr. Techno-Functional Consultant/Architect

• As a part of an acquisition of 2Wire Communications by PACE, Inc., designed and developed data conversions from SAP to Oracle eBusiness Suite v11i 11.5.10 . The data conversions included the General Ledger accounts and actual balances, Open Purchase Orders, Inventory On-Hand Quantities, In-Transit On-Hand Balances and Price Lists. Provide training and mentoring to other Oracle developers.

Apps/Tools Used: Oracle eBusiness Suite version 11i Financial and Manufacturing application modules General Ledger, Payables, Purchasing, Receivables, Order Management, Advanced Pricing, Cost Management, Inventory . Oracle Reports Builder 6i, Oracle Forms 6i, Oracle PL/SQL, Oracle SQL/Plus, TOAD, API, Open Interfaces.

Confidential

Sr. Techno-Functional Consultant

• Design and develop various Reports, Interfaces, Conversions and Extensions RICE to migrate the systems of an acquired company to Logitech's Oracle eBusiness Suite version 11i system. This involved both technical 70 and functional 30 design. Troubleshoot problems and support interfaces and other processes with the users. Develop reports using Reports Builder 6i and XML Publisher with output in XML and utilize the XML bursting to handle the distribution of the reports. Develop data cleansing and data migration programs for the vendor, PO, inventory item, inventory serial numbers, item costs, item categories, inventory on-hand balances, item cross references and AR customers. Develop numerous form personalizations and workflow to support business processes.

Apps/Tools Used: Oracle eBusiness Suite version 11i Financial and Manufacturing application modules General Ledger, Payables, Purchasing, Receivables, Order Management, Install Base, Bills of Material, Inventory, Supply Chain Planning, Service, Costing, Work in Process . Logical Apps, Oracle Reports Builder 6i, Oracle Forms 6i, Oracle PL/SQL, Oracle Data Integrator ODI , Oracle SQL/Plus, Oracle Workflow Builder, Oracle XML Publisher, TOAD, API, Open Interfaces.

Confidential

Sr. Techno-Functional Consultant Architect

• Design and develop forms, reports, workflow and interfaces for the support of Hitachi's logistics systems. Main project was to help setup the software, business process, etc. in support of a new DistributionCenter located in Singapore. Provide delivery and training of software and processes for the new SingaporeDistributionCenter. Troubleshoot problems and support interfaces and other processes with the users. Develop tables, objects and forms 10g to support the Tariff codes for overseas shipping. Develop numerous packing slip, commercial invoice and customs invoices using Reports Builder 10g. Design and develop the necessary module setup and business processes within Oracle Inventory, Oracle Order Management, Shipping Execution and Oracle Receivables to support the order processing, shipping and other revenue stream related processes for the new distribution center in Singapore. Make modifications and test EDI related transactions to support new DistributionCenter located in Singapore. Provide design and support of custom object, reports, forms, etc. for the Everest project which involved the migration of Oracle eBusiness Suite 11i into Oracle eBusiness Suite R12.

Apps/Tools Used: Oracle eBusiness Suite R12 Financial and Manufacturing application modules General Ledger, Subledger Accounting, Payables, Purchasing, Receivables, Order Management, Shipping Execution, Bills of Material, Inventory, Supply Chain Planning, Service, Cost Management, Warehouse Management, Work in Process . Oracle Reports Builder 10g, Oracle Forms 10g, Oracle PL/SQL, Oracle Data Integrator ODO , Oracle SQL/Plus, Oracle Workflow Builder, Kintana, PVCS, PL/SQL Developer, API, Open Interfaces and desktop tools such as Excel and Word, AIM Methodology.

Confidential

Sr. Technical Consultant Architect

• Provide the design, development, training and support for Cameron's requirement for financial, operational and business intelligence reporting after an implementation of Oracle eBusiness Suite R12. Based upon the Company's requirement to provide key decision support and operational analysis reporting, architect and design a set of business views folders within the End-User-Layer EUL of Oracle Discoverer 10g. Design and adopt new development methodologies and procedures to support the new EUL. Provide training and support to subject matter experts SME relating to the techniques of report writing using Oracle Discoverer Plus 10g. Provide training to the Company's IT staff in the use and maintenance of Oracle Discoverer 10g and the new EUL. Develop various financial, manufacturing and HRMS reports or queries using Oracle SQL/Plus, Oracle Discoverer 10g, Oracle PL/SQL and Oracle BI Publisher.

Apps/Tools Used: Oracle eBusiness Suite R12 HRMS, Financial and Manufacturing application modules Assets, General Ledger, Subledger Accounting, Payables, Purchasing, iProcurement, Receivables, Order Management, Bills of Material, Inventory, Work in Process, Supply Chain Planning, Service, Field Service, Project Manufacturing, Project Accounting, Cost Management . Oracle Applications Daily Business Intelligence, Oracle Discoverer 10g, Oracle Reports Builder 10g, Oracle BI Publisher, Oracle PL/SQL, Oracle SQL/Plus, TOAD and desktop tools such as Excel and Word, AIM Methodology.

Confidential

Sr. Techno-Functional Consultant Technical Lead/Architect

• Manage a project to deliver key business intelligence reporting for the Human Resources and Financial business units of Yahoo, Inc. This involved leading subject matter experts SME , functional analysts and Oracle developers in the definition of key performance indicators KPI and other metrics along with the presentation of this information onto reports. This was also a hands-on role that involved coding and design of ETL routines, Oracle database objects and Discoverer reports. Responsible for managing the upgrade of Oracle Discoverer from v4i to v10g.

Apps/Tools Used: Oracle Applications eBusiness Suite v11.5.9 HRMS and Financials and Inventory, Business Objects, Daily Business Intelligence, Discoverer v10g, Oracle Reports Builder v10g, Oracle PL/SQL, Oracle SQL Plus, TOAD and desktop tools such as Excel and Word, AIM Methodology, Kintana, unix shell.

Confidential

Sr. Techno-Functional Consultant Technical Lead/Architect

As a part of an upgrade to Oracle eBusinessSuite R12, architect and design a replacement to the existing business intelligence and financial reporting systems. This involved the gathering of requirements for key reports and translating those into design documents using the Church's SDLC procedures and AIM document standards. Drive and participate in meetings that defined the new chart of accounts and other needed definitions to support the implementation of Oracle's Daily Business Intelligence for Financials along with Oracle Discoverer 10g Business Intelligence. Analyze existing reports generated by Maximo, FSG and other reporting tools for mapping into the new set of reporting requirements. This project was done for the Treasury Department of the Church. Participate in the discussions and setup of the Oracle Financial modules such as Payables, Purchasing, Oracle iProcurement, iExpenses, Receivables and General Ledger. Participate in business process solution development workshops to gain understanding of solution requirements, particularly in the setup and configuration of core Oracle Financials Fixed Assets, General Ledger, Payables . Develop complex SQL queries to examine existing financial data and how Oracle Financials was configured which was used as a basis for documenting the current setup. Define and expand the approval rules within the Approval Manager Engine AME to include changes in the dynamic rules.

Apps/Tools Used: Oracle eBusiness Suite R12 and supporting development tools such as Oracle Discoverer v10g, Oracle Report Builder v10g, Oracle Applications Framework OAF , Oracle JDeveloper, Daily Business Intelligence for Financials, Maximo and Microsoft desktop tools, such as Access, Excel, Word. AIM document methodology/templates.

Confidential

Sr. Techno-Functional Consultant/Technical Lead/Architect

• Architect, design and lead the development of Business Intelligence MRC reports for Domestic and European operations and finance. Oversee, guide and mentor 1 Oracle developer. Modify clone the purchase order entry form to use a custom table of additional supplier information. Provide periodic production support for the financial, order-to-cash and procure-to-pay systems of Oracle Applications v11.5.10. Provide production support and reporting for service contracts and install base as it relates to Sales Orders. Develop SQL queries to examine data during the process of troubleshooting issues with the transactions and other production support related issues. Assist in troubleshooting production support issues relating to Receivables invoicing and Vertex Geo Coding and Tax Reporting.

Apps/Tools Used: Oracle v9i rdbms, Oracle PL/SQL, SQL Plus, Oracle Forms, Oracle Report Builder v6i, Oracle Discoverer v4i, Oracle Payables, Oracle Assets, Oracle Bills of Material, Oracle Work in Process, Oracle Receivables, Oracle Order Management, Oracle Service, Oracle Install base, Oracle Inventory, Oracle General Ledger, TOAD, SQL Navigator, MetaLink, AIM document methodology/templates.

Confidential

Sr. Technical Lead/Architect

• Architect, design and lead the development of a Business intelligence reporting system along with the requirements gathering for an enterprise wide multi-dimensional data warehouse. The tool being used was Oracle Business Intelligence Enterprise Edition OBIEE and a thorough review of the capability of BI Publisher with working examples. Lead and design Java based inspection tracking system. Responsible for the coordination of work for 4 senior designers and architects. Design initial specifications for the ETL routines that will be used to load spatial data into a newly developed multi-dimensional data warehouse. Develop complex SQL queries against spatial data to demonstrate how polygons and other locating pin pointing could be done to identify areas at risk.

Apps/Tools Used: Oracle 10g rdbms, Oracle PL/SQL, Oracle SQL Plus, Oracle Reports Builder v10g, Oracle Business Intelligence Enterprise Edition OBIEE , MetaLink, Oracle Spatial, Microsoft desktop tools such as word, excel, project, access. AIM document methodology/templates.

Confidential

Sr. Technical Consultant Technical Lead Part-Time Contract

• Design and develop methods and migrate the Company to Oracle Discoverer v10g and setup/utilize the suite of Daily Business Intelligence software as a part of an upgrade from Oracle Applications eBusiness Suite v11i to R12. Plan and coordinate work for 2 application developers. Gather requirements, define and develop numerous Oracle Discoverer reports under R12. Provide training and mentoring to other staff members covering development techniques as it relates to Oracle Applications R12. Participate in the design of the enterprise data warehouse and other initiatives.

Apps/Tools Used: Oracle 10g rdbms, Oracle PL/SQL, Oracle SQL Plus, Oracle Report Builder v10g, Oracle Discoverer v10g, Oracle JDeveloper, Oracle Forms v10g, Oracle Applications R12 eBusiness Suite to include Oracle Financials Payables, Receivables, Purchasing , Oracle Manufacturing Costing, Bills of Material, Quality, Work in Process , Oracle Supply Chain Purchasing, Shipping, Order Management and Oracle CRM Service, Install Base application modules.

Confidential

Sr. Technical/Functional Consultant

• Design and develop Oracle Applications v11.5.10 procure-to-pay interfaces EDI related to support order to cash activities between 3rd party logistics vendors and Hitachi. Develop inventory transfers issues and receipts interface between one inventory organization and another via the MTL Transactions Interface. Design and develop new form to maintain transfer costs associated with inter-plant shipments between factories in Japan and the distribution fulfillment centers 3 PLs in the United States. Analyze, troubleshoot and improve various shipping and invoice related workflows. Participate in business process solution development workshops to gain understanding of solution requirements. Perform database development tasks such as designing, writing and modifying database objects in PL/SQL such as database views, stored procedures and functions. Design and write unix shell and PERL scripts to manage the EDI transaction processes between Hitachi's manufacturing sites in Japan and the shipping sites around the world. Develop complex SQL queries for use in the various PL/SQL packages, procedures and functions and for purposes of examining the test results of transaction processes. Develop reports to monitor the planning process for the builds of saleable products that are processed over EDI interfaces.

Apps/Tools Used: Oracle v10g rdbms, Oracle Forms v10g, Oracle Report Builder v10g, Oracle PL/SQL, SQL Plus, TOAD. Modules: Oracle General Ledger, Oracle Inventory, Oracle Payables, Oracle Purchasing, Oracle iProcurement, Oracle Order Management, Oracle Receivables, MetaLink, API, Open Interfaces, AIM document methodology/templates.

Confidential

Sr. Technical/Functional Consultant

• While assigned to the U.S. Marine Corps, perform detailed analysis and design of complex business systems reporting as a part of an implementation of Oracle Applications v11.5.10 Financial, Manufacturing, Supply Chain, Service including Mobile Field Service and CRM service contracts and install base systems. Study and consider the capabilities of XML Publisher as it related to writing the design for reports. Study and consider the capabilities of BPEL in the design of data interfaces. Participate in business process solution development workshops to gain understanding of solution requirements. Perform analysis of requirements to establish RICE development requirements. Perform design and development of RICE Objects. Develop and document technical procedures for installing and executing RICE objects. Define and expand the approval rules within the Approval Manager Engine AME to include changes in the dynamic rules.

Apps/Tools Used: Oracle v10g rdbms, Oracle Forms v10g, Oracle Reports Builder v10g, Oracle PL/SQL, SQL Plus, TOAD, BPEL, XML Publisher. Application Modules: Oracle Contracts, Oracle Order Management, Oracle Service, Oracle Install Base, Oracle Payables, Oracle Receivables, Oracle Purchasing, Oracle iProcurement, iExpenses, Oracle General Ledger. AIM document methodology/templates.

Confidential

Sr. Technical Consultant Tech Lead/Architect

• Lead, manage, architect and design new Business Intelligence BI system using Oracle Discoverer 10g to provide key operational, decision support and other analytical and metric related reporting under Oracle Applications v11.5.10. Architect, design and implement various data repositories using various OLAP tools. Coordinate the modification of existing ETL processes that feed various data marts and data warehouses to support new version of Oracle Applications. Perform analysis and data modeling for all of the objects required into concise and accurate data models to be used during the construction of the End-User Layer EUL of Oracle Discoverer and custom data warehouse. Oversee, construct and test the EUL. Develop and implement the security model and development methodology for Discoverer and other data sources. Design and develop 30 reports relating to AP, AR, GL, Inventory, PO and Project Accounting using Oracle Discoverer. Lead, train and mentor 10 developers doing the design of BI and other software construction activities. Analyze, design and coordinate/lead the development of reports using XML Publisher. Define, write and administer the testing of the new reports using Mercury software. Participate in business process solution development workshops to gain understanding of solution requirements. Perform database development tasks such as designing, writing and modifying database objects in PL/SQL such as database views, stored procedures, stored packages and functions. Design and write unix shell scripts that were registered as concurrent programs for running the reports. Analyze, migrate and plan for the conversion of 11 universes of Business Objects into a consolidated metadata repository under Oracle Discoverer's End-User-Layer.

Apps/Tools Used: Oracle v10g rdbms, Oracle Report Builder v10g, Oracle Discoverer v10g, Oracle PL/SQL, SQL Plus, TOAD, VISIO, XML Publisher. Modules: Oracle General Ledger, Oracle Payables, Oracle Purchasing, Oracle Project Accounting, Oracle Receivables, Oracle Costing, Oracle Work in Process, Informatica, Primavera, MetaLink, Mercury. AIM document methodology/templates.

Confidential

Sr. Technical Consultant Tech Lead/Architect

• Lead, manage, architect and design new Business Intelligence BI system using Oracle Discoverer 10g to provide MRC reporting under Oracle Applications v11.5.10 and various data warehouses and data marts. Perform analysis and data modeling for all of the objects required into concise and accurate data models to be used during the construction of the End-User Layer EUL of Discoverer. Coordinate the design of the EUL. Develop and implement the security model and development methodology for Discoverer. Oversee, construct and test the EUL. Develop and implement the security model and development methodology for Discoverer. Design and develop 125 Discoverer reports relating to Oracle Applications v11.5.10. Major accomplishment was the design of various reports to manage the shipping for Dell Corporation. Lead, train and mentor 7 developers doing design of BI reports. Participate in business process solution development workshops to gain understanding of solution requirements. A large number of reports developed related to Order Management and Service Contracts warranty based repairs along with Oracle Install Base. Perform database development tasks such as designing, writing and modifying database objects in PL/SQL such as database views, stored procedures and functions. Design and write unix shell scripts to run the reports via the concurrent request manager. Develop SQL queries to be used as a basis for building folders within the Discoverer EUL which was used for reporting. Design EUL for multi-dimensional data warehouse.

Apps/Tools Used: Oracle v10g rdbms, Oracle Reports v6i, Oracle Report Builder v10g, Oracle Discoverer v10g, Oracle PL/SQL, SQL Plus, TOAD. Modules: Oracle Bills of Material, Oracle Work in Process, Oracle Fixed Assets, Oracle General Ledger, Oracle Inventory, Oracle Master Scheduling/MRP, Oracle Order Management, Oracle Payables, Oracle Purchasing, Oracle Projects, Oracle Receivables, MetaLink, AIM document methodology/templates.

Confidential

Sr. Technical Consultant Tech Lead/Architect

• In a technical lead capacity, design and develop custom reports relating to an implementation of Oracle Applications v11.5.10. Architect and administer the End-User Layer EUL of Oracle Discoverer v4. Provide training and support for users of Oracle Discoverer. Design and develop data conversion programs and reports relating to Oracle Project Contracts, Service Contracts and Oracle Work in Process. Do functional design and support relating to Oracle Bills of Material, Oracle Inventory, Oracle Purchasing, Oracle Master Scheduling/MRP and Oracle Work in Process. Design and develop financial reports FSGs under the Oracle General Ledger module. Provide mentoring to other systems analysts and developers who are involved in data conversions and customizations. Participate in business process solution development workshops to gain understanding of solution requirements. Perform database development tasks such as designing, writing and modifying database objects in PL/SQL such as database views, stored procedures and functions. Design and write unix shell scripts to run the reports via concurrent request manager. Develop SQL queries to be used as a basis for building folders within the Discoverer EUL which was used for reporting. Utilize and modify the Planning business areas
• and it's business views within Daily Business Intelligence to satisfy MRP and other planning related reports. Review the set of rules used for expense report approval with the users and determine if adjustments need to be made to the Approval Manager Engine AME .

Apps/Tools Used: Oracle v9i rdbms, Oracle Reports, Oracle Discoverer v4, Oracle PL/SQL, SQL Plus, TOAD, XML Publisher. Modules: Oracle Contracts, Oracle Bills of Material, Oracle Work in Process, Oracle General Ledger, Oracle Inventory, Oracle Master Scheduling MRP, Oracle Order Management, Oracle Payables, Oracle Purchasing, Oracle iProcurement, Oracle iExpenses, Oracle Project Accounting, Oracle Receivables, API, Open Interfaces, Oracle GUI Loader Data Loader , MetaLink, AIM document methodology/templates. .

Confidential

Sr. Technical Consultant

• In a technical lead capacity, design and develop custom MRC reports relating to Oracle Applications v11.5.10. Architect and administer the End-User Layer EUL of Oracle Discoverer. Major reports developed include a Project Commitments Report, Project Billing Report and Custom A/R Aging Report. Provide mentoring to other systems analysts and developers in the functionality of Oracle Projects, Oracle Purchasing and Oracle Receivables. Participate in business process solution development workshops to gain understanding of solution requirements. Perform database development tasks such as designing, writing and modifying database objects in PL/SQL such as database views, stored procedures and functions. Design and write unix shell scripts to run the reports via concurrent request manager. Develop SQL queries to be used as a basis for building folders within the Discoverer EUL which was used for reporting.

Apps/Tools Used: Oracle v9i rdbms, Oracle Reports, Oracle Discoverer v4i, Oracle PL/SQL, SQL Plus, SQR, TOAD, XML Publisher. Modules: Oracle Contracts, Oracle General Ledger, Oracle Inventory, Oracle Payables, Oracle Purchasing, Oracle Project Accounting Costing, Billing , Oracle Receivables, Oracle Bills of Material, Oracle Work in Process, MetaLink, AIM document methodology/templates. .

Confidential

Sr. Technical Consultant Architect

• Architect, design and develop financial MRC reports, forms and other custom software as a part of an implementation of Oracle Applications v11.5.8 for Western Union which is a subsidiary of First Data Corporation. Provide leadership and mentoring of other sr. developers and sr. systems analysts. Assist in the planning and management of the project. Develop and administer development standards and methodologies relating to the Company's Oracle development effort. Participate in business process solution development workshops to gain understanding of solution requirements. Perform analysis of requirements to establish RICE development requirements. Perform design and development of RICE Objects. Develop and document technical procedures for installing and executing RICE objects. Perform database development tasks such as designing, writing and modifying database objects in PL/SQL such as database views, stored procedures and functions. Design and write unix shell scripts to run the reports via concurrent request manager.

Apps/Tools Used: Oracle v9i rdbms, Oracle Reports and Forms Designer v6i, Oracle PL/SQL, SQL Plus, TOAD, XML Publisher. Modules: Oracle Financials, MetaLink, AIM document methodology/templates.

Confidential

Sr. Technical Consultant

• Develop reporting systems under the Oracle Applications business suite. Administer and develop report repositories and scheduling. Provide technical support of the Company's business systems and databases. This may include problems with shipping or other financial related transactions. Develop and migrate software from Oracle Applications v11.0.3 to v11.5.10. Work with DBA and system administrators to resolve unix system and Oracle database/performance issues. Participate in business process solution development workshops to gain understanding of solution requirements. Perform analysis of requirements to establish RICE development requirements. Perform design and development of RICE Objects. Develop and document technical procedures for installing and executing RICE objects. Perform database development tasks such as designing, writing and modifying database objects in PL/SQL such as database views, stored procedures and functions. Design and write unix shell scripts to run the reports via concurrent request manager. Develop SQL queries to examine data for transaction issues such as frozen serial numbers during ship confirmation and other transaction related production support.

Apps/Tools Used: Oracle v9i rdbms, Oracle Reports Designer v6i, Oracle Discoverer v3 and v4i, Oracle PL/SQL, SQL Plus, TOAD. Modules: Oracle Financials, Oracle Supply Chain, Oracle Order Management, MetaLink, AIM document methodology/templates.