SUMMARY:

• Talented, results - driven IT leader with more than 22 years of experience in Database Design, Development and Implementation of Oracle eBusiness suite and various Commercial applications for diverse industries ( Retail, Manufacturing, Technology, Government).
• Hands-on experience leading all stages of system development efforts, including requirements definition, design, architecture and support.
• Outstanding leadership abilities; able to coordinate, estimate the timelines and mentor highly productive team.
• Experience in setting standards for application development.
• Experience in Database design and development of Enterprise Application Integration.
• Experience in integrating with disparate systems using SOA technologies.
• Designed Databases in various implementations, which includes Data Modeling, developing E-R Diagrams, defining attributes and generation of DDL scripts using Case tools like ERwin and Oracle Designer.
• Involved in Defining Software, Process and Module Specifications.
• Worked with DBA’s to improve database performance.
• In depth knowledge in Technical Analysis of the user requirements and determining the customizations needed for various applications.
• Extensive experience in various design and development tools.
• Strong understanding with capabilities of OBIEE.
• Performed Data Migration for large databases.
• Experience in Design and Development of interfaces, conversions, and enhancements (RICE) objects.

TECHNICAL SKILLS:

• Oracle 11g,10g,9i, 8i, 7.x
• UNIX(HP & Solaris)
• Linux
• Win NT/2000/XP
• Oracle General Ledger
• Oracle Procure to Pay
• Oracle Order to Cash
• Oracle iProcurement
• Oracle iSupplier
• Oracle Inv, BOM & WIP
• Oracle Install Base
• Oracle Service Contracts
• Oracle Process Mfg
• Oracle Projects
• Oracle Workflow
• Oracle AME
• Application Object Library
• OBIEE
• SQL, PL/SQL
• C, C++, Pro*C
• Developer 6i/10G
• SOA (BPEL, BAM, ESB, Human WF, Business Rules, Mediator, Adapters), XML, XSLT, XPATH, XQUERY, WSDL
• Designer 10g, 6i, 2000
• Erwin
• Oracle Reports 10g/6i/ 3.0/2.5/2/1.1
• Discoverer
• BI Answers/Dashboards
• Informatica

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Principal Consultant

Responsibilities:

• Changes to iSupplier portal included enhanced and unified loader and export templates, better screen management, temp data clearing capability, validation of data based on Confidential standards, error tab and status columns for error management, look-up based error codes which allow users to turn off / on errors and tailored message capability.
• Was responsible for following activities.
• Map the functional requirements to technical designs.
• Customize, personalized iSupplier/iProcurement screens using Oracle Applications Framework according to roles (Suppliers, Catalog Admins and Procurement agents).
• Built customized export logic using OAF to extract existing blanket purchase order into a standardized catalog template for further editing.
• Added functionality to validate data according to client standards and reported errors in custom screens.
• Customized workflows (PO Summary, PO Authoring and PO Approval) to send appropriate notifications to supplier, catalog admins and procurement agents.

Confidential

Sr. Principal Consultant

Responsibilities:

• Mapping the technical business needs of the client.
• Planning the migration strategy to be followed in converting data from the existing legacy system (SAP) to the Oracle Applications. Data migration interfaces includes Open GL transactions, Customer conversion and Vendor Conversion, AP & AR invoice conversion, Item Conversion and On Hand and cost conversion, BOM/Routing conversion, EAM and projects.
• Preparing a solution document, designing, and migrating documents.
• Involved in customization of forms using personalization, workflow customizations, interfacing data thru open interfaces, Public API’s and custom API’s.
• Involved in instance planning.
• Cutover Planning and Execution.
• Leading technical team meetings and coordinate across project functions
• Publishing status reports
• Managing defect resolutions during testing and post go-live.

Confidential

Sr. Principal Consultant

Responsibilities:

• Collaborated with client to define business requirements and develop solutions for third party integration
• Prepared deliverables such as process flows, functional specifications, test and user documentation
• Lead and supported multiple test cycles for various projects.
• Co-ordinate end to end testing with client business system analysts (BSA)
• Resolved issues and questions on Oracle functionality
• Involved in the implementation of following projects
• Upgrade to Release 12 from Release 11i. implementation of user management with self-service role/responsibility requests with approval process using AME and segregation of duties conflict controls and managing SOX compliance
• Payments Architecture (Integrating with multiple banks for multiple countries using oracle SOA and Confidential web services).
• Confidential Kindle offline retail integrations.
• Developed and Deployed BPEL processes to publish and subscribe oracle suppliers, invoices (AR/AP), payments with various systems at Confidential .

Confidential

Oracle Technical Manager

Responsibilities:

• Implementation of Incentive compensation module in Rel 12.
• Implementation of iExpense Module in 11i.
• Migrate Oracle Applications datacenter from Seattle to Chicago
• Implement AME for purchasing documents and Invoice approval.
• Implementation of Vertex use tax system
• Integration with Amdocs (Telecom Billing, CRM, Operations support Systems)

Confidential

Sr Principal Consultant

Responsibilities:

• As a technical consultant , was involved in integration of a receivables module with third party factoring company Confidential .
• Factoring is the sale of SPI’s accounts receivable, either a single invoice or a batch of invoices.
• Factoring leverages account receivables to provide quick working capital. SPI submits the copies of SPI invoices to be purchased by Confidential .
• Confidential then acts as the collection service on the invoice.
• This involved creation equivalent AR transactions (Invoices, Credit Memos, AR Activity) or contra transactions based on transaction type from Confidential .

Confidential

Sr Principal Consultant

Responsibilities:

• Mapping the business needs of the client.
• Planning the migration strategy to be followed in converting data from the existing legacy system to the new system in Oracle Applications. Data migration interfaces includes Open GL transactions, Customer conversion using Confidential api’s, Vendor Conversion, AP & AR invoice conversion, Item Conversion and On Hand item conversion, BOM’s conversion, install base and service contracts conversion
• Preparing a solution document, designing, and migrating documents.
• Involved in customization of forms using personalization, workflow customizations, interfacing data thru open interfaces, Public API’s and custom API’s.
• Involved in building interfaces between Oracle Applications and external system for integrating Orders and integrating with 3rd party shipping company for pick/ship order’s using Oracle BPEL(SOA).

Confidential, Seattle, WA

Technical Lead

Responsibilities:

• Involved in providing 11i specific technical assistance to their internal team as they refit their customizations to the new Oracle environment, and to help Confidential orient to the new features of 11i and apply relevant new features.
• Helped in designing and prototyping the new interfaces in 11.5.10.
• Technical assistance in migrating Order Cycles in 11.0.3 to Order Management workflows.
• Designing and prototyping the customizations of headers, lines and COGS workflow.

Confidential, Palo Alto, CA

Senior Technical Consultant

Responsibilities:

• Involved in development of new custom Reimbursement system (iOU) to handle reimbursements, demand checks, advances and petty cash throughout the campus.
• Designed the data model based on the requirements.
• Designed and developed multiple forms required for the Travel and Reimbursements dept to enforce compliance with university reimbursement rules and also developed forms required for the setup of system.
• Designed the workflow for the transactions approval and T & R review approvals using parallel and sequential routing.
• Developed java pages for the transaction review.

Environment: : GL, AP (Oracle Apps 11.5.9), PL/SQL, Oracle forms 6i, Workflow, Oracle9i, Sun Solaris 8, Oracle jDeveloper 10g, Web PL/SQL.

Confidential, Seattle, WA

Technical Lead

Responsibilities:

• Providing architectural solutions and mentoring the team.
• Involved in identifying, reviewing and requirement analysis of functional specifications.
• Designed and Developed Interface for implementing Inventory transactions interface from AS/400(JDA) to Oracle, Booked order’s to JDA Interface, Ship Confirmation Interface, Processing constraints.
• Designed and developed the workflow customization to post Discounts, Surcharges, Taxes to different GL Accounts after invoice interface process and before the Autoinvoice process
• Modified Item interface to handle UPC codes in Oracle using mtl cross references table.
• Designed and Developed Oracle Reports 6i that were not available in the Oracle vanilla report set as per the business requirements.
• Troubleshooting the problems during the Design, Code Development and Testing Phases and also working with Oracle to resolve TAR’s.
• Work closely with the user community at all levels, discuss and communicate enhancements, ideas problems and solutions to ensure the quality of the conversion, system testing, user acceptance testing and implementation.

Environment: Oracle Order Management, Advance Pricing, AR (Oracle Apps 11.5.9), PL/SQL, Workflow, Oracle9i, Sun Solaris 8.

Confidential, Seattle, WA

Technical Lead

Responsibilities:

• Providing architectural solutions and mentoring the team.
• Involved in identifying, reviewing and requirement analysis of functional specifications.
• Designed the E-R diagram for the application, identifying the data elements and defining the tables.
• Identifying global objects and developing global views, procedures and functions which include global mail to send email from the application using Java email.
• Designed and developed various technical designs for the application which include notification for various business requirements, Global email, Interface between Oracle Purchasing and Confidential and data conversion.
• Developed Notification System for the application using bulk binds, DBMS utilities and Java email for various business requirements.
• Developed an interface to synchronize data between Oracle Purchasing and Confidential .
• Performed analysis of SCTC Transportation for data conversion into Confidential System, which includes data mapping, validation and to maintain data integrity in Confidential .

Confidential, Seattle, WA

Sr. Technical Specialist

Responsibilities:

• Perform impact analysis of all the listed RICE elements, checking for changes to be made due to the new version of Oracle Applications in all the modules.
• Subsequently modify & test the necessary changes to RICE items, making the RICE items compatible with 11.5.9.
• Designed and developed an PDOI interface to transfer material from SCTC org to US org.
• Customized the iProcurement ‘Catalog Data Extract - Items’ to transfer only designated documents.
• Document the deliverables and work closely with business and user community in achieving the goals and deadlines.
• Work with Oracle TARs to resolve any issues identified including SEV1 with 24x7 resolution.
• Provide technical support during System testing, Integration testing phases.

Environment: Oracle GL, AR, AP, PO, INV (Oracle Apps 11.5.9), WF, PL/SQL, Oracle9i, Sun Solaris 8.

Confidential, Beltsville, MD

iProcurement

Responsibilities:

• Accounts code sync, vendor load,
• Req Approval workflow customization for commitments
• PO Approval workflow customization for obligations.

Environment: Oracle Purchasing, AP (Oracle Apps 11.5.8),PL/SQL, Oracle8i, Sun Solaris 8.

Confidential, Seattle, WA

Technical Consultant

Responsibilities:

• Impact analysis, design and migration.
• Prepared design documents for all the interfaces.
• This includes preparation of Technical Specifications, Mapping documents between Oracle Applications and other systems and preparing Flow Charts.

Environment: Oracle Process Manufacturing (Oracle Apps 11.5.6), PL/SQL, Reports 6i, Oracle8i, Sun Solaris 8.

Confidential, Seattle, WA

Technical Lead

Responsibilities:

• Working as a technical lead from Oracle Applications side in the Confidential project which is part of the Supply Chain Management System at Confidential .
• Involved in Designing and Developing various interfaces from Oracle Applications to Consolidated Distribution Centers (CDC) and Blue Martini (BMS), a third party Order Management system and vice versa.
• Involved in extensive deliberations between Starbucks and the Confidential to design and develop interfaces for Purchase Orders, Receiving Exceptions and Invoice/Credit Memos.
• Prepared design documents for all the interfaces. This includes preparation of Technical Specifications, Mapping documents between Oracle Applications and other systems and preparing Flow Charts.
• The interfaces include Blanket Purchase Orders Interface to BMS, PO Interface to CDC (850), PO Acknowledgement from CDC (824), Receiving and Receipt Exceptions to CDC (861).

Environment: Oracle Purchasing, AP (Oracle Apps 11.5.6),PL/SQL, Reports 6i., Oracle8i, Sun Solaris 8.

Confidential, Seattle, WA

Responsibilities:

• Developed a process, which reads a text file and populates the PDOI tables and creates the Blanket Purchase Agreements, which are in turn loaded into iProcurement using Catalog Extract Process.
• Designed and Developed the HR employee’s interface SAP.
• Involved in defining custom LOVs to the accounting flexfields for the charge account using AK Developer for the requisition creation process in iProcurement.
• Customized Create Documents workflow process to create approved releases using Approved Suppliers List.
• Customized PO Requisition account generator workflow process to get the charge account.

Environment: Oracle8i, Sun Solaris 8, Oracle Purchasing, iProcurement, Inventory (Oracle Apps 11.5.6),PL/SQL, AK Developer, Workflow 2.6, Sql*Loader.