SUMMARY:

• 10 years IT industry experience, 7 years’ Oracle applications implementations/upgrade experience with Oracle Financial and Supply Chain applications from Oracle E - business Suite 11i to R12, specifically version 12.2.x.
• My experience is more functional analyst than it is as a technical resource.
• Project budgeting, human resource utilization and management
• Project Costing, scope management and periodic executive reporting
• Business and credit analysis, internal audit control, ITIL, COSO (SOX), CISA, SEC, OCC and compliance reviews
• Communications Management with and for principals
• Oracle e - business suite solution-architecting to meet various business requirements and needs
• Workflow planning and management
• Client and business user liaison and communications
• Functional requirements gathering processes
• Functional & technical design documentation, application set ups & configurations of Oracle E-business Suite (11i, R12)
• All stages of testing from system to user acceptance testing -functional and technical.
• Operations or post-go-live production support of the various modules

TECHNICAL SKILLS:

ERP: Oracle E-business suite R12/11i/ 11.0.3/11.5.10.2 versions- Accounts Payable (AP), Accounts Receivable (AR), Oracle General Ledger (GL), Oracle Purchasing (PO), Project Accounting (PA), Fixed Assets (FA), eBTax, Order Management (OM), Shipping and Oracle Inventory, iSupplier Portal, etc.

Languages: SQL, PL/SQL, C, C++. Java scripting, Unix

Databases: Oracle 8i, 9i, 10g, 11g, MS Access Tools Oracle - Developer 2000/6i (Forms, Reports), Discoverer, BPEL, SOA, Oracle Utilities Oracle Workflow, XML reports, RICEF, OBIEE10g/11g, CEMLIs, Discoverer, Web ADI, Toad, SQL Developer

EXPERIENCE:

Oracle Support analyst

Confidential

Responsibilities:

• Currently supporting the client off-site in managing the production ticket workflow.
• Handling daily tickets related to various user problems in FA, AP, AR, GL, CE modules
• Testing of various test scenarios of Quote to Cash, Requisition to Purchase Order cycle in Oracle Purchasing.
• Helping with functional testing of various bug fixes.
• Prepare issue and risk tracker and submit to client on a weekly basis.
• Coordinating with other developers in resolving technical issues plaguing the application systems.
• Handling daily tickets related to various user problems in FA, AP, AR, GL, CE modules
• Working on CR's (Understanding the requirement, preparing the necessary conceptual functional and technical design documents, preparing test cases and UAT).
• Fully involved in month end closing process of financial modules.
• Raising SRs on Oracle metalink for various issues related to AR, AP and GL.

Oracle Techno-functional Analyst

Confidential

Responsibilities:

• Involved in requirements gathering, analysis, development, quality assurance production support.
• Performed GAP analysis to ensure that the requirements are captured properly.
• Defined custom interfaces through extension documents (MD050s) for interface tables between the Global P2P system and the various international (local) ledgers and legacy systems.
• Coordinated the discussions between the DEV teams and the users to ensure that user/business requirements were implemented through the technical design and code-writing process.
• Customized Accounting Flexfields, Cross Validation Rules and security rules
• Global Account Standardization Program (AS) - for all international (local) ledgers.
• Participated in two different implementations through to GO-Live as part of the AS program
• As part of the AS program I created or updated general ledger and the Global P2P core-setups (COA included) to meet the new global accounting and reporting standards
• Responsible for mapping analysis as part of ledger/module implementation and or production support
• Per the AS program I convened conferences and demos with various stakeholders to ensure that all were committed to the Global accounting standards prior to or during implementation/extensions.
• Created uniform setups for the GL segment security and cross validation rules.
• General Maintenance of the Global P2P enterprise system
• Responsible for maintaining the calendar in the production instance as well as the P2P ledgers for each country in the UATTEC and UATFIX testing environments.
• Responsible for foreign exchange rate maintenance for all UATTEC and UATFIX ledgers.
• Responsible for documenting production support queries as and when required.
• Prepared training manual documentation for functional analysts and users.
• Prepared manual and automatic test scripts for all artefacts/objects/utilities designed & coordinated the testing.
• Responsible for troubleshooting all open production tickets
• User Testing and System Modification
• Responsible for designing most functional design documents, preparing functional applications and performing tests on all enhancements to ensure that solutions are working as intended. Examples were tests conducted Allocation Processing Systems (APS) and the Employee Compensation Allocation Systems (ECAS) in either UATTEC and or UATFIX.

Environment: Oracle Apps 12.1 (GL, AP, AR, PO, FA, PA), PeopleSoft, OBIAW, PL/SQL, SQL Loader, OBIEE 11g, UNIX, Windows 7 Enterprise, Oracle Db. 11g

Oracle techno-functional analyst-LEAD

Confidential

Responsibilities:

• Functional project leadership role.
• Human resource and workflow allocation management
• Communications with principals on scope and time and resource management issues.
• Gathered requirements prior to preparing FDDs( MD50 and MD70)
• Core module setups and configurations
• Upgrading the modules such as AP, AR, AP, FA, PO, PA and Project Costing from R11.5.9 to Apps R 12.1
• Defined Profile options and set ups for P2P process.
• Developed a PO interface to import POs from an external system. (PeopleSoft-Human Resources)
• Defined custom interfaces in Oracle GL, AR, SLA, PO, AP, CM, iProcurement and others
• Prepared test cases TE-020, 030, 040 for Financials modules (AP, CM, AR, OM, INV, and GL)
• Created documentation for Future Business (BP-80), present business requirements (RD20), conversion (CV-4), and function extensions (MD-50), Test Scripts (TE-40).
• Planned and co-ordinated the data conversion programs
• Developed periodic financial (FSG) and other BI management (analytic) reports as needed.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions
• Undertook performance tuning activities on the Oracle EBS applications, concurrent manager and with exceptions
• Developed Purchase order & AP Invoice Report to display the PO and correspondinginvoice details.
• Developed Supplier Payments Report using XML Publisher and other reports.
• Designed & created custom form using Forms 6i tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated .fmx executable file to $AU TOP on forms server of client.
• Production support on Oracle modules

Environment: Oracle Apps 12.1 (GL, AP, AR, PO, INV, FA, Project Costing, Billing, Advanced Pricing), PeopleSoft, Hyperion Essbase, Hyperion FDM, IR, OBIAW, PL/SQL, SQL Loader, OBIEE 11g, UNIX, Windows 7 Enterprise, Oracle Db. 11g, DAC, Informatica.

Oracle Techno-Functional Analyst

Confidential

Responsibilities:

• Involved in implementation of Oracle Financial Applications R12 GL, AP,, AR, PO, Project Costing and Project Billing, FA and some service modules (iProcurement, iExpenses, etc).
• Implementation of standard Procure to Pay (P2P) functionality
• Involved in documentation of Future Business (BP-80), present business requirements (RD20), conversion (CV-040), & functional extensions (MD-50), Test Scripts (TE-40), System setup Document(BR-100)
• Identified process and reporting gaps and recommended solutions.
• Developed functional specifications for invoice matching solution.
• Created custom responsibilities-attached specific menus, forms & reports.
• Developed and tested the interface and conversion scripts..
• Authored SQL and PL/SQL scripts to analyze underlying data for inconsistencies and integrity
• Used SQL Loader Program to load data from Excel files, flat files into temporary table using UTL FILE utilities, TOAD and SQL loader.
• Experience in developing, customizing, modifying forms, reports existing in Oracle Applications using Oracle Developer Suite 10g/9i(Forms, Reports) and other front-end tools.
• Used other reporting tools such as OBIEE to report from Hyperion Essbase and HFM.
• Developer rpd.files based on metadata from Hyperion data sources.
• Provided production support to the solution after Go-Live

Environment: Oracle Apps 12.1 (GL, AP, AR, PO, SLA, INV, iProcurement, iExpenses, FA), OBIAW, PL/SQL, Oracle Reports

Oracle Technical Developer

Confidential

Responsibilities:

• Involved in the upgrade from EBS 11.5.9 to EBS 11.10.5 and its implementation (AP, AR, Inventory, OM modules).
• Integrated Oracle EBS P2P with Informatica, DAC and OBIEE for analytics reporting
• Involved in business user interaction for application/report enhancements and customizations
• Trained and helped users work on oracle self-service applications (iExpenses and iProcurement).
• Responsible for providing production support as needed.
• Estimation and scheduling tasks for the team and tracking them.
• Developed TDDs and FDDs for the optimal solutions to meet the business requirements.
• Developed and managed programs for data conversions and migrations.
• Responsible for data conversion from legacy system to Oracle Applications.
• Developed and customized as well as modified some seeded forms and standard reports
• Researched and resolved issues that emerged from production environment on runtime.

Oracle BI Developer

Confidential, NY

Responsibilities:

• Performed Gap Analysis to viability and adaptability of possible new data mart solution
• Performed hardware and software sizing for the complete solution.
• Gathered business requirements prior to creating the data mart model
• Developed conceptual, logical and physical Dimensional model for the HR data mart.
• Developed ETL design document with Source to Target mappings and associated transformation rules
• Created technical specifications for OBIEE repository layers and dashboard design
• Configured the physical layer, business model and presentation layer in the BI Admin tool
• Developed ad hoc dashboard reports using web catalogs( Answers, Oracle BI Publisher, Delivers)
• Created users and set up user sign-on security credentials for both BIOPHARMA and HR Data marts.
• Implemented data level security using session and dynamic variables and groups
• Optimized performance via query analysis, table indexing, aggregation tables, fine-tuning the repository, enhanced cache management
• Prepared Test User Acceptance Test cases TE-020, 030 and TE040 to test the functionality and performance of the OBIEE reporting tool on Oracle EBS databases and financial modules (AP, AR, FA, and GL).
• Worked on Customizing and formatting Financial Statement Generator (FSG) Report.
• Dashboards: Compensation, HR Performance, Retention, Workforce Profile,
• Reports: Executive Summary, Headcount/Hire/Termination/Movement, Rolling 12 months Trend, Demographic category-type reports, Ad-Hoc reports, and Oracle Financials, Order-to-Cash and Procure To-Pay Process reporting were also done regularly

Environment: Linux, Oracle 9i-10g, OBIEE 10.1.3.4.1 , Oracle EBS, SQL Server 2005, IBM DB2, SAP ERP R/3, Informatica, Oracle BI-Apps.v 7.9.5.1 internal auditor

Confidential, Batesville, INDIANA

Oracle BI Developer

Responsibilities:

• Planned, performed and documented audits according to the Institute of Internal Auditors (IIA) and CISA Standards
• Evaluated the existing procedures and management practices within accounting, economics, treasury, operations, law, and taxation, computerized information systems for compliance with regulatory (e.g SEC, SOX, HIPAA regs) and other statutory requirements.
• Reviewed internal controls over specialized processing cycles
• Evaluated accounting systems to determine their efficiency and effectiveness
• Conducted investigations into suspected improprieties in a confidential and professional manner
• Developed recommendations for areas of improvement, reported and documented findings, and followed up on recommendations to ensure suggested remedial actions were implemented
• Complete audit reports for dissemination to management
• Documented existing processes through interviews, observation and inquiry.
• Identified risks and key control activities
• Performed financial analysis utilizing corporate tax returns as well as internally prepared and accountant prepared financial statements.
• Prepared industry statistics and projections which are utilized in business analysis and lending decisions throughout the underwriting department.
• Made approval or denial recommendations to the Commercial Loan Committees of the bank.
• Managed and prioritized loan request pipeline.
• Assisted loan officers with loan structure and portfolio maintenance.
• Reviewed commercial and residential appraisals as well as environmental inspections.
• Analyzed personal credit reports, tax returns, and financial statements.
• Collected borrowing bases from loanees periodically and reviewed them for lending compliance.
• Reviewed loans in portfolio to ensure the bank remained adequately secured by the collateral and that the borrowers continued to have the ability to services their debts
• Responsible for identifying potential problem loans and making remedial recommendations to Loan Committee.
• Prepared commercial bank loan summary compliance reports for the federal OCC reviews.