SUMMARY:

• Result oriented Solution Architect/Subject Matter expert with experience in global initiatives and culturally diverse teams.
• Experience in delivering both custom and off the shelf ERP product implementation & driving business results.
• Full cycle delivery experience including conceptualization, estimation, project scoping (budget, timelines and delivery dates), team management, documentation and user training.
• 10+ years of strong experience as Oracle EBS financial consultant on Oracle Fusion Applications, EBS Release12, 11i, 10 financial modules General ledger, FAH(SLA), Accounts Payable, Account Receivables, Project Accounting, and Fixed Asset.
• Worked on all new features & functionalities on Fusion, R12 such as Oracle E - Business Tax, FAH, Subledger Accounting, TCA, Multi Org Access Control (MOAC).
• Experience in implementation of business systems including Procure to pay (P2P) and Order to Cash (O2C).
• Experience in working on large projects teams and global initiatives.
• Proficient in writing BR100, MD50, MD70, TE20/40’s, MD120’s (Design, Testing and Installation documents)
• Performed full life cycle implementation, roll outs and production support on Oracle EBS performing various responsibilities like
• Functional responsibilities: requirements gathering, gap analysis after determining the AS-IS and TO-BE processes, application design, test script generation, writing business rules documents.
• Tech Lead activities: interfacing with users, design and documentation, development of inbound and outbound interfaces for third party systems and designing custom solutions, programming and leading developers, dealing with Oracle Support using metalink and production support.
• Good Understanding in quarter end, month end and year end issues and related activities.
• Skilled in FSG (Financial Statement Generator) to customize reports extensively under GL module.
• Designed reports, inbound and outbound interfaces; converting legacy data(RICE objects)
• First-hand exposure to large, dynamic, customer focused and international environments.
• Worked cross functionally with Architects, Developers, System Admins, DBAs, PM’s, Quality Assurance and Application Support Teams.
• Received client appreciation certificates for effective support, good communication skills and achieving tasks efficiently.

TECHNICAL SKILLS:

ERP: Oracle Applications Fusion Rel 5, 7, 8, R12, Ver. 11.5.5, 11.5.7, 11.5.10.2

Oracle Apps Modules: General Ledger (GL), Accounts payables(AP), Account Receivables(AR), Fixed Assets(FA), Financial Accounting Hub, SLA, Procure to Pay( P2P), Order to Cash (O2C)

Languages: SQL, PL/SQL, C, C++Oracle Tools

ADI, SQL*Plus, SQL*Loader, TOAD, ETL Tools like Informatica

GUI Tools: Oracle Forms and Reports, WebADI, XML publisher, Oracle BI tools, Cognos, Oracle Discoverer, OBIA, Publisher,Work Flow Builder, Data warehousing

Operating Systems: UNIX on Sun Solaris, Windows

Version Control: PVCS, CVS, Microsoft VSS

PROFESSIONAL EXPERIENCE:

Confidential

Solution Architect

Responsibilities:

• Currently helping in setting up a US Financial Accounting Hub Center of Excellence within Oracle Consulting.
• Full cycle delivery experience including estimation, project scoping (budget, timelines and delivery dates), planning, budget management, team management, documentation and user training.
• Expertise in designing solutions around GL, AP, AR, SLA core financial modules.
• Key knowledge leader spanning Business, Functional and Technical areas in the Global Finance/financial services space supporting Cross functional Oracle organizations. Subject Matter Expert - Oracle Accounting to Finance Close Process Implementations.
• Helped to run several POC’s (Proof of Concept) and RFP’s.
• Involved with stakeholders, Oracle and implementation partner teams on best practices and issue resolution for implementing Oracle Financial Accounting Hub and EBS Release 12/Fusion.
• Oracle Application Architect - Oracle Applications Release 10.7 to Fusion.

Confidential - Chicago

EBS Financial Solution Architect/ Team lead

Responsibilities:

• Business responsibilities
• Provide functional knowledge and best practice business process expertise across the P2P cycle.
• Gather requirements and interact with users and key business stake holders.
• Participate in Oracle EBS implementations; work on enhancements and system customization requests, troubleshoot issues and recommend solutions.
• Perform functional set-ups with business users utilizing detailed understanding of EBS modules.
• Prepare design specifications including enhancements, configuration.
• Coordinate with project manager & other teams Oracle application development team.
• Prepare a plan for migrate the data from legacy system to EBS.
• Propose multiple solutions, evaluate each solution with team, and make recommendations.
• Technical Responsibilities
• Design and implement inbound and outbound data interfaces; Migrate legacy data to EBS using ADI and open interfaces
• Running adhoc queries to fetch data in required format and validate bulk data upload.
• Participate in UAT and user trainings while acting as a subject matter expert for the solution.
• Interacting with Oracle Support using metalink.

Environment: Oracle E-Business Suite R12 on modules of General Ledger, Accounts Payables, Accounts Receivables.Oracle Discoverer,Oracle TOAD, PL/SQL, SQL.

Confidential

Oracle financial Lead Functional Consultant

Responsibilities:

• Business responsibilities
• Develop project estimates with project manager to manage project work plans.
• Lead a team of five developers; coordinate with project manager & other teams for JPMC US Oracle application development team.
• Gather requirements and interact with users and business analysts.
• Perform functional set-ups with business users utilizing detailed understanding of EBS modules.
• Maintain changes to financial reports like balance sheet, cash and income statements.
• Technical Responsibilities
• Design and implement inbound and outbound data interfaces; Migrate legacy data to EBS using ADI and open interfaces
• Provide technical consultation in developing, testing and rollout of new functionality, custom interfaces & conversions using Oracle AIM methodology
• Coordinate and participate in system testing for upgrade and customizations of modules and reports
• Develop customed reports using Discoverer Application such as LE - account balance report
• Develop and modify shell scripts to handle tasks like fetching status report for management.
• Other Responsibilities
• Hire and train new resources, managing their alignment with the team
• Support internal and external audit by providing reports
• Work closely with the IT support team to provide support for Oracle Financials

Environment: Oracle E-Business Suite R12 on modules General Ledger, Accounts Payables, Accounts receivables, Project Accounting, Fixed Assets. Oracle Discoverer, Oracle Reports and Forms 6i, TOAD, PL/SQL, SQL, SQL * Loader

Confidential

Oracle financial techno functional consultant

Responsibilities:

• Business responsibilities
• Led a team of four developers for JPMC EMEA Oracle application development team for various projects and enhancements.
• Coordinated with various functional key users to ensure successful fusion of new third party trading system
• Integrated new invoices, payments and receipts data from AP/AR to General Ledger.
• Setup AR and Inv according the new operating model
• Provided level three (L-3) functional and technical support for various Oracle modules.
• Technical Responsibilities
• Prepared MD 0.70 for the interfaces, validated all the inbound and outbound files from Istanbul trading system
• Completed the Premium Refunds interface. The PL/SQL package used the Adjustment API to create and approve adjustments
• Developed reports about the files transmitted to the service provider.Involved in reports generation using reports 6i and using BI tools such as cognos and discoverer.
• Designed and developed financial reports from scratch like Batch wise summary report (GL) and Invoice Register Report (AP)
• Analysze (functionally and technically) existing processes with objective of improving & optimizing the system performance.

Environment: Oracle E-Business Suite R11x on modules of General Ledger, Accounts Payables, Accounts Receivables, Oracle Discoverer, Oracle Forms & Reports 6i, TOAD, PL/ SQL, Hyperion.

Confidential

Oracle apps functional consultant

Responsibilities:

• Business responsibilities
• Proactively interacted with client to understand their business practices and estimate customizations required to fulfil those requirements through gap analysis.
• Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials GL, AR, AP, PA and FA modules.
• Prepared BR - 100 documents (Business Rules setup) and setup various financial modules. Examples:
• GL: Chart of accounts structure, accounting flexfields, journal sources, cross validation and security rules, MRC setups.
• AP: Supplier, Supplier site setups.Defining banks and Payaments formats.Payable and Accounting options.
• FA: system controls, asset calendars, asset keys and categories, book controls and depreciations methos.
• Implemented setups required for describing the rules for process constraints (preventing users from adding, updating, deleting information)
• Coordinate and execute financial processes like month end, half yearly, year-end GL posting etc.
• Technical Responsibilities
• Develop solutions to support business needs. Design, develop and customize outbound and inbound interfaces
• Build PL/SQL programs and SQL queries to extract reports and providing data fixes for Oracle backend tables and McKinsey specific tables.
• Utilized Cognos BI tool and FSG for developing custom reports
• Document training material and McKinsey specific processes for business users and new team members.

Environment: Oracle E-Business Suite 11.5.10 on modules of General Ledger, Accounts Payables, Accounts Receivables, Project Accounting, Fixed Assets. Oracle Discoverer, Oracle TOAD, PL/SQL, SQL, SQL * Loader

Confidential

Oracle Apps Developer

Responsibilities:

• Business responsibilities:
• Work with functional experts for understanding the requirements gathered in Requirement Specification Document.
• Design the chart of accounts and writing customized General Ledger and financial reports and perform application setups for GL and AP modules.
• Implemet Chart of Accounts and segments structure for the bank.
• Created general settings and completed specific configuration related to company code, bank transaction codes, bank, bank accounts and bank reconciliations.
• Technical Responsibilities
• Develop ad-hoc reports using FSG such as Balance Sheet, GL balance report etc using Oracle report development tools PL/SQL, reports and forms etc.
• Prepare tests to perform unit testing; support system testing
• Use Web ADI for Manual Journal creation and Data loader to upload bulk data with accuracy.
• Validate journals imported from legacy systems into GL module; resolve discrepancies in data.
• Develop and maintaining various reports/forms at GL level for many branches all over India.

Environment: Oracle E-Business Suite 11.5.9 in GL, AP Modules .Oracle Discoverer, Oracle Reports 6i and Oracle Forms 9i, XML Publisher, ADI, TOAD, PL/SQL, SQL, SQL * Loader

Confidential

Oracle Developer

Responsibilities:

• Develop procedures, packages and triggers using PL/SQL and SQL in Oracle RDBMS environment
• Develop the functional and technical design specifications for the enhancement requests
• Leverage various developer and testing tools such as VSS, TOAD, etc.
• Load data from flat file to temporary table by creating control file (.ctl file).
• Implement changes/enhancements to various programs using C.

Environment: Oracle 9i, TOAD, PL/SQL, SQL, SQL * Loader, C