SUMMARY:

• A motivated and resourceful professional with over 17 years of experience in Managing, Leading, Architecting, Upgrades, Implementation, Support, Enhancement, Customization, Critical Integration and Global Rollouts of ERP Projects.
• Offering strong techno functional knowledge, coupled with management, analytical and problem solving aptitude to provide end - to-end solutions for business processes.
• Experienced with Oracle Applications development standards and best practices, and mentor other application developers and implementers.
• Possess excellent communication, interpersonal, people management and analytical skills. Experience of working under cross-cultural environments.
• Delivery, Program & Change Management Expertise
• Managed multiple full project lifecycles from requirements, design, development, testing, configuration management and release management, go-live, post go-live process.
• Successful proven track record of leading large scale project initiatives in manufacturing, financial services and retail organizations by delivering work products on time.
• Solution Architect, Techno Functional Expertise
• Demonstrated proven knowledge and success, both as an individual contributor and techno-functional team member, with identifying and addressing client needs related to consulting, designing, and implementing various Oracle application-based solutions.
• Legacy System, Integrations & Customization Expertise
• Managed, Lead, Designed and developed custom solutions for many modules of the Oracle E-Business Suite, ranging from Release 10.7 through Release 12, including; data conversion, interfaces, workflows, reports and other custom processes, using PL/SQL, SQL*Plus, SQL*Loader, ADF, OAF, Oracle Forms & Reports, Workflows, XML/BI Publisher Reports, OBIEE Reports, Oracle Alerts, UNIX scripts.
• Custom interfaces and data loads developed using Oracle’s standard Application Program Interfaces (API) and Open Interfaces include; HR Employees, Customers, Vendors, Purchase Orders, Sales Orders, Item Conversions, Internal Requisitions, Payables Invoices, General Ledger Journals, Cash Management and Receivables Invoices.
• Implementation, Upgrades & Support Engagement Expertise
• Performed several upgrades, implementations of Order Management, Purchasing, Inventory, Payables, Receivables, Cash Management, Project Accounting, Oracle General Ledger, HRMS and Payroll on Releases R11i, R12 by reinforcing knowledge of Oracle Supply Chain, Financial and HRMS process.
• Experienced with System Administration and the architecture of Oracle Applications, possessing the skills to investigate and resolve both system and data problems, and the ability to communicate effectively with business, functional and technical resources.

TECHNICAL SKILLS:

• Proficient in Order Management (OM), Inventory (INV), Work in Process (WIP), Accounts Payables (AP), Accounts Receivables (AR), Purchasing (PO), Bills of material (BOM), Warehouse Management System (WMS), Oracle Sourcing, PIM (Product Data Hub), Advanced Collections, Advanced Pricing, Project Accounting (PA), iRecruitment, iExpenses, iPayments, iProcurement, iStore, Demantra, Trade Management (TM), TCA, GL, Service Contracts, AME, HRMS, Payroll, SCM, AOL, System Administrator.
• Good exposure on FRICEW components with Business Requirements, Data Analysis & Modeling, Functional Specifications, Technical Specifications, Development, Unit, System and User Acceptance Testing, AIM & OUM documentation and End Users Training.
• Goodhands onexperience inOracle ADF 11g Architecture, JDeveloper, Oracle ADF Development (ADF, ADF Faces, ADF Task FlowsandBusiness Components)withWeb Services and integration with EBS System.
• Well versed programing skills in PL/SQL, SQL*PLUS, SQL*Loader, Oracle Standard (PUB & PVT) API’s, Oracle Open Interfaces, OAF pages, Custom WebADI, Forms and Reports 6i/10g, XML/BI Publisher, OBIEE Reports, Workflows, Forms Personalization’s, Discoverer 10g and UNIX scripting.
• Efficient knowledge in fine tuning/performance tuning the programs.
• Proficient knowledge on Oracle 11g/10g/9i/8i.
• Knowledge in Salesforce, Business Objects 6.5, Teradata C, C++, SQL, PL/SQL, COBOL, JAVA, XML.
• Excellent exposure on tools like Kintana, SVN, PVCS, MS Visual Source safe, MS-Project, Load Runner, TOAD, SQL Developer, JDeveloper, Eclipse, Remedy, Power Builder, Win runner, Test Director8.0.
• Hands on exposure in design using AIM, OUM and Agile methodologies.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Systems Analyst

Responsibilities:

• Working as Systems Analyst in a Team Environment including Business Users, Business Analysts, and Technical Developers while working in Confidential, and direct interaction with the business users to discuss business requirements and defects and developing prototypes and implementing new/enhancements to the existing business processes.
• Design and developing an asset in JAVA, for processing auto checkout from PVCS, remediation and deployment into database through Kintana process.
• Design and developed program for processing user and series level security restrictions in Demantra user security management and enhanced the functionality further to handle the level removal, re-ordering, user locking and unlocking, series group handling.
• Design and developing custom WebADI for downloading content using search functionality and uploaded back to TM with dependent values for revenue reclassification.
• Design and developed conversion program for processing Price Management chipsets from external source to EBS using custom program and processed them into Price Management system.
• Design and developing custom program for downloading POS data from Model-N and sent it to finance for SLA JE upload.
• Design and developed a custom program to pre-populate ASP with fill down across forecast horizon using Backlog and Billings ASPs that will get pulled into Demantra.
• Enhanced and fine-tuned existing Rapid Response Sales Order Lines Extract and Part Source Co-product extract programs for transforming the data from Oracle EBS to legacy system.
• All Custom developments involves analyzing MD50 (Functional Specifications), MD65 and transforming into MD70 (Technical Specifications) for all FRICEW and UI components including legacy applications.
• Providing support on Standard Oracle R12 finance modules and legacy applications in production environment by addressing and resolving client’s day to day business issues.
• Prepared UAT documents, Unit test plans TE20, Configuration documents to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment as per the business expectations. Participating in UAT for supporting business users in regression testing for existing processes.

Environment: Oracle Applications R12.2.3, Demantra, Trade Management, Accounts Payables (AP), General Ledger (GL), SCM, BI/XML Reports, WebADI, Oracle 11g, SQL, PL/SQL, TOAD, SQL Loader, PVCS, Kintana, UNIX Shell Scripting, Workflows, Discoverer 10g, UTL FILE package.

Confidential, CA

Senior Techno Functional Consultant

Responsibilities:

• Working as Senior Techno Functional Consultant in a Team Environment including Business Users, Business Analysts, and Technical Developers while working in Marvell, and direct interaction with the business users to discuss business requirements and defects and developing prototypes and implementing new/enhancements to the existing business processes.
• Working as single point of contact for implementing all new ADF custom applications like OSP PR processing, Assembly Build Instructions, HR Delegations and Non ERP User Access. Integrated EBS web services with the ADF application using ADF Web Service and Proxy Data controls.
• Design and developed multiple web (UI) pages ABI Screen, HR Delegations and Non ERP User access user interface components usingJSF,ADFRich Faces, JSP and HTML.
• Developed ADF Model components (creation, configuration, and tuning of entity objects, view objects, application modules, bindings and data controls) for complex OSP PR Processing UI.
• Responsible for all custom MVC design components and implementing theJ2EEframework.
• Design and developed interface for loading OSP Purchase Requisitions details from external supplier spreadsheet to external tables using SQL Loader and processed data translations, pre validations as per the business needs.
• Enhanced the standard OAF controllers of iProcurement Shopping Cart UI and iProcurement Edit Page UI to retrofit sixth segment of charge account based on the project code (Department).
• Design and developed interface for processing OSP Purchase Requisitions from external supplier to EBS using Open Interface Requisition Import program and processed Purchase Orders through auto creation.
• Design and enhanced Print Purchase requisitions report to generate in PDF’s and send these files programmatically to required approvers.
• Design and developing custom Printed Purchase Requisition report templates to fetch and print the dynamic approvers using Oracle BI Publisher.
• Customized Purchase Order Workflow approval process account generator logic in deriving the account based on the project codes using Workflow builder.
• Design and developing custom Prepaid listing report in Fixed Assets to show Assets quarterly, yearly and remaining depreciation balances in each year against the departments using Discoverer reports.
• All Custom developments involves analyzing MD50 (Functional Specifications) and transforming into MD70 (Technical Specifications) for all FRICEW and ADF components including legacy applications.
• Providing support on Standard Oracle R12 finance modules and legacy applications in production environment by addressing and resolving client’s day to day business issues.
• Prepared UAT documents, Unit test plans, Configuration documents to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment as per the business expectations. Participating in UAT for supporting business users in regression testing for existing processes.

Environment: Oracle Applications R12.2.4, iProcurement, Purchasing (PO), Accounts Payables (AP), General Ledger (GL), Fixed Assets (FA), HRMS, Payroll, SCM, ADF JDeveloper 11g, OAF Extensions, Web Logic10.1, BI/XML Reports, Oracle 11g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Workflows, Discoverer 10g, UTL FILE package.

Confidential, WA

Techno Functional Consultant

Responsibilities:

• Working as Techno Functional Consultant in a Team Environment including Business Users, Business Analysts, and Technical Developers while working on Skyfall Project, Enhancements of existing business processes.
• Design and enhancing Vendor Returns invoice process to generate invoice payments for Wholesale and regular customers using Auto Invoice Import and generate Invoice PDF’s in EBS.
• Design and enhancing Vendor Payments process to sync the OFA payee with respect to the VPA system using API POS VENDOR PUB PKG in EBS.
• Design and enhancing Contra Cogs AR billing process to import the invoice transactions into Oracle using Invoice Import in EBS.
• Design and developing custom VAT, Return Invoice and generating and sending electronic e-mail notifications to Vendors using Oracle BI Publisher.
• Prepared UAT documents, Unit test plans, Configuration documents to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment as per the business expectations. Participating in UAT for supporting business users in regression testing for existing Skyfall changes.
• Collaborating with the team members in gathering the requirements for the Contra Cogs process and coordinating with CMB team for code promotions/cutover activities.

Environment: Oracle Applications R12.1.3, Account Receivables (AR), Accounts Payables (AP), General Ledger (GL), TCA Architecture, BI/XML Reports, Oracle 11g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Reports10g, Workflows, UTL FILE package.

Confidential, CA

Team Lead and Techno Functional Consultant

Responsibilities:

• Working as SME in a Team Environment including Business Users, Business Analysts, Technical Developers while working on various New Projects, Enhancements of existing applications and Production Support.
• Design, Development and Implemented Sale Order Import Process to receive sales orders from third party and process in EBS using API oe order pub.process order.
• Enhanced the Sales Order Creation program, to process through EDI 850 using sales order open interface tables.
• Designed, Developed and Production Support for Delivery Ship Confirmation Program for orders shipped from warehouse using the API wsh deliveries pub.delivery action.
• Designed and Developed in converting the standard Purchase Orders from third party and process in EBS using Import Standard Purchase Orders program.
• Design and Developed interface for loading Internal Requisitions from third party to EBS using Open Interface Requisition Import program and processing Advance Shipping Notes (ASN) through the EDI process.
• Design and Developed interface program for uploading the price lists using the Oracle Standard API qp price list pub.process price list.
• Design, Developed and Implemented projection of weekly Supply and Demand values against each SKU using MRP PUB mrp atp pub.call atp.
• Used Form personalization to customize Standard Sales Order and Quick Sales Order forms for calculating region wise Tax and to control manual sales orders order types for Budget Accounts.
• Enhanced and fine-tuned existing Item Import program for transforming the data from legacy application to Oracle EBS system.
• Customized the iExpense home page to show the customer contact and logo information using the OA Framework (OAF).
• Designed, Developed and Implemented custom Sales Order Acknowledgement and Returns Report using Oracle BI Publisher.
• Designed, Developed and Implemented Customer Remittance Check Printing report using XML Bursting.
• Enhanced the existing custom workflow process to reroute different approval process when sales orders are created with Budget Account transaction types.
• Designed, Developed and Implemented WMS Item update Form by using Oracle Standard TEMPLATE.fmb using form builder 10g.
• Designed, Developed and Implemented to load invoices from legacy application to EBS using the Open Interface Payables Open Interface Import program.
• Involved in designing Customer Facing Documents (CFD) Project and developing physical, logical and presentation models in OBIEE to build a dimensional business model as per the business requirements in performing data analysis, CFD formatted documents and reports for UK Business.
• Designed, Developed and Implemented an interface to load Payable invoices from legacy application to EBS using the Open Interface Payables Open Interface Import program.
• Designed, Developed and Implemented a program for converting Receivable invoices from legacy application to Oracle EBS using Open interface Auto Invoice Import program.
• Creating TAR (Technical Assistance Request) on Metalink for technical/functional support with Oracle while finding issues in existing Oracle Application functions during Implementation, Production Support or while customizing existing modules for Company’s new or enhanced business requirements.
• Preparation of Business Requirement documents (BP70), demonstration of Prototypes (POC) to the end users and getting the User sign-off for designing the end product.
• Developed multiple Oracle Alerts to report program status to business users, and to notify daily work orders dropped to warehouse and Sales orders credit card failure status, etc.
• Tuned the complex interfaces: Cricket delivery interface, B2B External ATP extract, Star item description update program and AR Invoice pre processer program by generating and analyzing the trace files in making the programs to execute faster and more efficiently.
• Prepared UAT documents, Unit test plans, Configuration documents to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment as per the business expectations.
• Development involves analyzing MD50 (Functional Specifications) and transforming into MD70 (Technical Specifications) for all FRICEW components including legacy applications.
• Collaborating with the team members to communicate the requirements of the project as well as guiding them in the execution. Supporting all team members in understanding the business requirements for effective deliverables.
• Japan rollout, involved with study of existing system, preparing the extraction template documents and Conversion Mapping Documents to convert data from legacy systems to R12.

Environment: Oracle Applications R12.1.3, Order Management (OM), Account Receivables (AR), Accounts Payables (AP), General Ledger (GL), Inventory (INV), WIP, WMS, Purchasing, iExpenses, Bill of Materials (BOM), Advanced Pricing, HRMS, TCA Architecture, Oracle Alerts, XML Reports, Oracle 11g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Forms10g, Reports10g, Form Personalization, Custom.pll, OBIEE Reports, Workflows, UTL FILE package, Business Objects, Oracle Configurator.

Confidential

Team Lead and Techno Functional consultant

Responsibilities:

• Managed the team and Supported Standard Oracle R12.0.3 and 11.5.10 Finance, HRMS modules and legacy applications in production environment including working on daily production issues. Acted as a link between business users and technical team for gathering and processing the business requirements.
• Shown excellent skills in understanding the requirements from business and end users in creating business requirement documents, Functional Design Documents, Technical Design documents including Unit Test Plans and System Integration Plans.
• Worked on Software Development Life Cycle (SDLC) for implementing Custom Designed Applications into Oracle R12 Environment for Merchandise Payments, TAPS Applications using Oracle R12 Standard Objects including OAF, TEMPLATE.FMB, CUSTOM.PLL and Application Object Library (AOL) for Development and implementing custom applications in Finance and HRMS Modules.
• Created concurrent programs for AR and AP to load financially eligible data from legacy application to EBS for various custom programs AR Invoice consolidation and AR invoice data to AP for cash disbursement to external vendors.
• Worked on designing, developing and implementing Interface program for processing the external bank statements in Cash Management (CM) using Oracle open interface Bank Statement Import program.
• Designed and Developed the Invoice Interface program in AP for importing the external payments from Merchandise Payments system to EBS using open interface Auto Invoice Import program.
• Worked on designing, developing and implementing Interface program for importing AP Suppliers into EBS using standard API.
• As an Architect, provided solutions for converting existing custom applications in HRMS to R12 using OAF.
• Worked on Oracle Application Framework (OAF) to develop custom pages Employee Bonus Payable form, Attendance Bonus Calculation form for iRecruitment module in HRMS. Development involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Involved in designing and developing OAF screens Group Scheme Setup form and Bonus Protection form in HRMS module.
• Involved in customizing Purchase Order Workflow approval process in defining the new approval hierarchy using Workflow builder in PO.
• Developed an Interface to load manually entered GL Journal Accrual Entries into Projects.
• Designed and Developed Utilization Report breaking it down by Organization, Department and the Project Manager in Project Accounting.
• Designed and Developed Profitability Report in Project Accounting for extracting the details of Costing, Revenue, Budgets, Variance and profit/loss for a project. Customized Order Workflow approval process in defining the new approval hierarchy using Workflow builder in PO.
• Designed, Developed and Implemented External Check Print BI report for showing the payments to external suppliers which are imported into Oracle EBS.
• Involved in converting Service contracts from legacy applications to EBS using standard API oks import header pub and oks import line pub.
• Involved in developing new custom forms Supplier Rebate Group set form and Customer Rebates form using TEMPLATE.fmb in Froms10g.
• Implemented XML Bursting for electronic distribution remittance report to external suppliers.
• Responsible for system testing to all the enhancements delivered from offshore to analyze the adequacy and applicability of the system output.
• Development involves analyzing MD50 (Functional Specifications) and transforming into MD70 (Technical Specifications) for all FRICEW components including legacy applications.
• Manage the client expectations, deliverables, and production support and ensure smooth interactions between onshore and offshore team members.
• Involved in end-to-end object reviews on Technical design, coding & UTP documents for all the deliverables with respect to development standards, in-order to mitigate gaps and thereby improving overall quality and efficiency of process.
• Co-ordinate with onshore/offshore team for open clarifications/Issues raised by development team, propose & fix FD gaps identified during object reviews.

Environment: Oracle Applications 11.5.10 and R12.0.3, Account Receivables (AR), Accounts Payables (AP), General Ledger (GL), Cash Management (CM), Project Accounting, Purchasing, iExpenses, iProcurement, iRecruitment, HRMS, Payroll, Advanced Benefits, Fixed Assets, Service Contracts, TCA Architecture, Oracle Alerts, XML Reports, Oracle 10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Forms6i, Reports6i, Form Personalization, Custom.pll, Workflows, UTL FILE package, Teradata, TOAD and legacy applications like TAPS, Merchandise Payments and YODEL systems.

Confidential, MA

Technical Lead

Responsibilities:

• Involved with study of existing system, preparing the extraction template documents and Conversion Mapping Documents (CV40) to convert data from existing 10.7 and legacy systems to R12.
• Prepared Technical Specification (MD070) documents for conversion, interface components as per business requirements.
• Preparation of Customization Requirement Specification (CRS), demonstration of Prototype to the end Users and getting the User sign-off.
• Designed and Developed below RICE components: Conversion of Item Master, Item Org Assignment, Item Revisions, Item Category Assignments and Standard Cost. Conversion of Item Spanish Description from legacy system to R12. Conversion of UDA’s at PIM level. Forecast Interface from legacy system to R12. Conversion of Customer History and Notes information from legacy system to R12 Advanced Collections Module. Item Cost comparison Report. Update Salesrep defaulting rule at Sales order lines.
• Designed and Developed in converting bill of materials from legacy system to Oracle R12 using the Open interface Import BOM program.
• Involved in fine tuning on the SQL and PL/SQL objects, making the programs to execute faster and more efficiently.
• Used SQL trace files in the tuning process, performance testing results were shared with the performance team and the scripts behind the transactions were optimized.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment as per the business expectations. Responsible for delivering and implementing the objects as per the business requirements.

Environment: Oracle Applications R12.1.1, PIM (Product Data Hub), Advanced Collections, Forecasting, Order Management, INV, WMS, AP, AR, WIP, BOM and I-Payments, Oracle 10g, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Rational Clear case Clear Quest, RPM and Promopack.

Confidential, CA

Architect

Responsibilities:

• Involved with study of existing system, preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from existing system into open interface tables.
• Designed, documented Functional (MD050), Technical Specification (MD070) documents for existing components and developed interfaces as per business requirements.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL to import the data into staging tables.
• Designed and developed custom interfaces for Conversion of Historical and Incremental Sourcing data. Conversion of Historical and Incremental Costing data. Weekly demand interface.
• Developed various Custom reports, Customized existing reports according to the functional specifications including weekly demand report, costing report and sourcing reports by channel and by customer.
• Did tuning on the SQL and PL/SQL, making the Procedures runs faster and more efficiently. Used SQL trace files in the tuning process.
• Used Oracle's optimizer and monitored how it chooses and execution path/plan for the procedures. Performance testing results were shared with the performance team and the scripts behind the transactions were optimized.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment.
• Prepared UAT plan for all the components and executed as per the business needs. Responsible for delivering and implementing the objects as per specifications.

Environment: Oracle Applications 11i (11.5.10/11.5.8 ), Oracle Sourcing, BOM, Costing, Oracle 9i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Kintana, Teradata, PVCS, BO, and SQL Assistance.

Confidential, CA

Oracle Applications Technical Consultant and Project Manager

Responsibilities:

• Responsible for analysis of the Requirements by interacting with the business users and understanding the process flow of the system.
• Preparation of Customization Requirement Specification (CRS), demonstration of Prototype to the Users and getting the User sign-off.
• Designed Functional (MD050), Technical Specification (MD070) documents for new components as per business requirements and getting the user sign-off.
• Prepared functional and technical specifications for the below process and shared the same to the team. Order Import process, Shop floor process, Pick release process, WIP Process, Invoice Creation, Inventory Program.
• Fulfilled the above process, by developing the custom forms, custom reports, interfaces and packages/procedures.
• Preparing Unit Test Cases, Unit Test Plans, User Acceptance Test Plans and Test Cases, Setup Document, Code Review Document and responsible for the obtaining user acceptances.
• Coordinating with the performance testing team for obtaining optimized testing results. Worked extensively in Order to Cash cycle.
• Ensured the objects are delivered as per the customer standards. Implemented the Project successfully without any deviations as per the schedule.
• Providing post-delivery support for objects which are released in this phase while simultaneously working on the enhancements.

Environment: Oracle Applications 11i (11.5.8), OM, AR, AP, AOL, SysAdmin, Forms 6i, Reports 6i, Oracle 9i (SQL, PLSQL), SQL*Loader, Toad8.6, Kintana, PVCS, and UNIX.

Confidential, CA

Oracle Applications Technical Consultant and Project Manager

Responsibilities:

• Worked as a Team Leader to develop EXCISE modules to meet the statutory and business requirements.
• Preparation of Customization Requirement Specification (CRS), demonstration of Prototype to the Users and getting the User sign-off.
• Developed SQL script to fetch responsibilities that are assigned to a user, menus and sub menus which are attached to a responsibility.
• Prepared custom request groups to assign it to conflict responsibilities. Identified the conflict forms and disabled or enabled the functions/buttons or adding the new functionalities as per the business requirements using the forms personalization.
• Prepared test plans for UAT and responsible for getting the user acceptance for those setups. AOL set up like registering or excluding the Executables, Concurrent Programs in the assigned Request Groups or Responsibilities in Version 11.0.3 and 11i.
• Developed a new SOD tool in 11i oracle applications using forms 6i and reports 6i to identify the key conflicts for the upcoming.

Environment: Oracle Applications 11i (11.5.8/11.0.3 ), OM, AR, AP, PA, PO, AOL, SysAdmin, Forms 6i, Reports 6i, Oracle 9i (SQL, PLSQL), SQL*Loader, Toad8.6, Kintana, PVCS, and UNIX.