EXPERTISE AREA:

Project management:

• 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 applications implementations:

• 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) Fixed Assets (FA) 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

PROFESSIONAL EXPERIENCE:

Lead Oracle Business Analyst 

Confidential

• Lead the requirements gathering and analysis.
• Lead the solution design and development process
• Conduct all GAP analysis to ensure that the requirements are captured properly.
• Performing all configuration set ups of all financial applications including Inventory, OPM Costing
• Coordinate and conduct all production support and troubleshooting activities.
• Raise and coordinate the management of Oracle Service Requests as we fix production issues
• General Maintenance of the Procure to-pay enterprise system
• Prepare training manual documentation for functional analysts and users.
• Prepare manual and automatic test scripts for all artefacts/objects/utilities designed & coordinated the testing.
• Responsible for troubleshooting all open production tickets
• Responsible for bring all enterprise divisions and locations onto the Oracle E-business suite platform
• Environment: Oracle Apps 12.1.3 (GL, AP, PO, FA, PA, INV, OPM Costing), PeopleSoft, PL/SQL, SQL Loader, SQL Developer, UNIX, Windows 7 Enterprise

Oracle EBS Support analyst

Confidential

• Supporting the client off-site in managing the production ticket workflow using JIRA.
• 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 e-Business Suites’ HCM, 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).
• Developing or redesigning old interface tables and other database objects as necessary
• Fully involved in month end closing process of financial modules.
• Raising SRs via Oracle Support Services for various issues related to AR, AP and GL.

Oracle Business ANalyst 

Confidential

• 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 developer 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.
• Developed database and E-Business CEMLIs as necessary
• 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
• Developing database objects and tables as required
• 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, PO, FA, PA), PeopleSoft, PL/SQL, SQL Loader, UNIX, Windows 7 Enterprise

Oracle techno-functional analyst

Confidential

• Lead analyst on the project.
• 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 coordinated 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 corresponding invoice 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

• 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.
• Wrote SQL and PL/SQL scripts/code 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 

• 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, 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