SUMMARY

• Over 6 years of experience working as techno - functional consultant in Oracle EBS modules involving complete SDLC lifecycle that includes understanding business system, requirement study, analyzing and gathering the requirements, design, development and testing.
• Worked on upgrade and production support of Oracle EBS modules. Have worked in both Functional as well as Technical areas of development and customization.
• Proficient in Developing and Customizing of Oracle Financials & Operations: GL, AP, AR, FA, CM and PO.
• Strong domain expertise in Oracle Financials working in Retail and Manufacturing industry and possess good knowledge on accounting entries.
• I worked as SME on Procure to Pay, order to cash, General Ledger, Cash Management cycles.
• Extensive Knowledge on RICE (Reports, Interfaces, Conversions, Extension), XML Publisher and Workflow.
• Extensively worked on Triggers, Packages, Procedures, Functions, Views and other Oracle objects.
• Provided Production Support, Change Management, Continuous Improvement, Tuning, and Quality Assurance in various projects.
• Architected and developed various Inbound and Outbound Interfaces in Oracle Financials.
• Expertise in Oracle Financial modules upgrading, supporting acquisitions.
• Helped in IT Audits and SOX Implementations.
• Process centric, Results oriented and Client-focused, leveraging leadership, in-depth technical knowledge, organizational and business development skills and strong team contributor.
• Participate in the day to day activities of the project. Oversee issue tracking/resolution, risk identification / management and change management for overall timely delivery of the project.
• Possess solid business skills, versatile attitude, multi-tasking abilities, strong problem solving and analytical skills, can do impact analysis and take effective decisions to resolve issues in my current role.
• Excellent communication and presentation skills, proactive and proficient to work independently or part as a team.

TECHNICAL SKILLS

Operating Systems: Win 9x/NT/2000 Server, UNIX

Languages: SQL, Pl/Sql, C

ERP: Oracle Applications E - Business Suite 11i, R12

RDBMS/DBMS: Oracle 8i/9i/10g

Design Tools: SQL Navigator

Reporting: Oracle Reports 6i, BI Publisher

Case tool: VSS, VMI-NET

Development Tools: Forms 6i, TOAD, SQL Navigator, SQL Loader, Workflow.

PROFESSIONAL EXPERIENCE

Confidential, Massachusetts

Oracle Applications Techno Functional Lead

Responsibilities:

• Techno-Function Lead for Oracle upgrade project upgrading Oracle application from 11.5.9 to 11.5.10 which has global foot print including Europe, Canada, US and Portugal.
• Worked with over 20 set of books and supported multi organization structure.
• Worked as customer facing personnel for the team and helped user with resolving issues and providing effective solutions.
• Manage Production Support for Oracle Financial modules and resolve issues within given SLA.
• Preparing MD50 and MD70 for new RICE objects.
• Fixing any issues with interfaces, SQL Loaders and data corruption.
• Expert in AOL, Concurrent Manager set up including scheduling concurrent programs and other Sys Admin activities.
• Work closely with third party systems like Getpaid, Bottomline (check printing).
• Developed XML Publisher reports which are easy to use and handled by users.
• Customized Portugal Dunning letters and blocking process to adhere business needs.
• Re-engineered US AR Lockbox process to handle invoice numbers and invoice amounts.
• Represented Confidential as Technical Lead when in contact with Bank of America to code and test the changes.
• Worked on US fixed Assets to resolve depreciation miscalculation with third party budgeting system.
• Developed new report for Canada AP to show all the invoices imported by batches both in transactional and functional currency.
• Expert in writing shell scripts and calling SQL scripts in shell.
• Developing/Customizing reports in AP, FA and AR.
• Work with offshore resources, provide the requirements and clarify any questions and get the work done in time.
• Actively involved in the pre-analysis work to upgrade application from 11.5.10.2 to R12.
• Provided estimates to modify the interfaces, reports etc to migrate to R12 environment and make them work.
• Designed MD.070 and MD.120 documents for Development work done and Support Process.
• Responsible for quality by reviewing the deliverables from offshore.
• Other responsibilities include mentoring junior team members to bring them up to speed and make him comfortable with the working environment.
• Regularly attended training sessions on various tools/modules to keep myself upto date with the technology and give it back to Team.

Confidential, Pennsylvania

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Provide Functional and Technical support in the application (AP, AR, FA and GL).
• Leading the team which is responsible for providing 24X7 production support.
• Supported Oracle Financials for different theatres Latin America, US, Asia Pacific and Europe.
• Developed over 20 reports for Oracle Payables and Receivables using report builder 6i.
• Designed and Prototyped invoice printing application for US and Brazil AR.
• Involved in Major Upgrade Project for all countries from 11.5.8 to 11.5.10 versions. Modify the existing interfaces and customizations to suite the latest version of Oracle.
• Leading a team of 10 resources in onsite and offshore model.
• Worked with Kintana for registering the packages and the SQL scripts in the various instances for moving to the production server.
• Worked on Integrating Oracle AR to Data warehouse systems for reporting purposes.
• Involved in implementing new operating unit called VuCore in the same instance as US. Modified and customized all US reports in all financial modules to handle new operating unit.
• Single point contact for all support related activities and was primary on call person for month end, quarter end and year end related activities.
• Ensuring all AP and AR invoices are imported to Oracle and period can be closed with no delay.
• Customized Brazil AR Invoice flow to be able to capture correct cost centers and then import invoices through AR Auto invoice jobs.
• Developed new process scripts to clear all rejections from AR invoices interface so that manual effort is reduced.
• Worked on FA account generator workflow to customize the flow to fetch correct accountings.
• Developed custom form for AP invoice History.
• Supported the integration of Oracle interfaces to third Party systems like webtrex and other AP systems.
• Redesigned AR Customer Interface to handle huge customer load and fixed few bugs to be able to import them without issues.
• Fine tune the reports and packages for better performance by using hints and indexes as applicable.
• Managing key organizational IT initiatives, such as system performance enhancement, system stabilization, Continuous Improvement, IT audits, and Documentation.
• Coordinating and Communicating with Offshore as a lead and provided the required Knowledge transfer for offshore team and empowering offshore - onsite model and setting up the highest benchmark in customer satisfaction.
• My role involved as support lead Handling customers, business and getting best out of offshore model.
• Prepared MD.070 and MD.050 documents for new developments.
• Responsible for quality by reviewing the deliverables from offshore.

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Develop AP interfaces to import open AP invoices from third party system.
• Reports are developed and customized in AR space. Aging reports are customized to show additional aging buckets.
• As a technical developer, I was involved in Requirements Studies, Coding and Unit Testing the Programs.
• Reports for AP and AR Modules like transaction detail report for a supplier, detailed customer transactions and collection details.
• Testing and tuning of reports.
• Developing and integrating Interfaces for business needs.
• MD.050 and MD.120 documents are prepared for new interfaces.
• Help in user testing in real time scenario and fixing any bugs.
• Reviewing the code and technical documents and capturing the defect in defect system called DTS and IRR.