SUMMARY:

• I am an experienced Oracle E - Business Senior Business Analyst/Consultant that has been responsible for supporting and managing multiple projects. Twelve years of experience with Accounting/Financial and HCM applications. I have experience in the full life-cycle implementation of Global R12 and upgrades of The Oracle e-Business Suite from 11i to R12.
• Conducting business process analysis in an effort to align information technology solutions with business initiatives of multiple ORACLE ERP Applications (From 10 thru 11i to Release 12) - Knowledge and understanding of accounting concepts. Hands on experience with Oracle PL/SQL and data warehouse OBIEE schemas.
• Worked in both a client/server and web based environment.
• I have excellent communication skills and the ability to work with a diverse group of consultants and clients.

TECHNICAL SKILLS:

Hardware: HP 9000, Windows based client PCs, VAX 78

Software: Oracle Financials all modules AP, AR, FA, GL, Forms, CRM Reports 6i, Cold Fusion, HTML, JavaScript, Java, PowerBuilder 3.x-4.0, 5.02, 6.5, 7.03, Sybase system 10,11, SQL Server, Erwin 2.5, Windows, Watcom SQL 4, MSOFFICE, QuattroPro, Lotus 1-2-3, etc.

Operating System: Windows for Workgroups 3.11, Windows 95, NT, Windows XP, Windows7

PROFESSIONAL EXPERIENCE:

Confidential, NY

Oracle E-Business Suite - BA-Functional Consultant

Responsibilities:

• I have experience with Oracle EBS rel11i and rel12 in Oracle. All Order to Cash and Procure to Pay Modules AP, AR, FA, GL, PA, Cash Management and HCM.
• Responsible for Oracle Fusion HCM configuration for global OAB, HR/performance/Goals/Talent Review - hands-on full life cycle project delivery and go-live experience.
• Experience in Oracle HCM (EBS/Fusion), including workflow and alerts; PL/SQL and Fusion Middleware Object Design, Development & Testing.
• Implement Oracle Payroll's core payroll engine, by adding local extensions to attain the legislative functionality and country reporting requirements.
• Configure and manage personalized compensation policies and programs including ACA patchsets.
• Defining and Maintaining Consolidation and Assignment Sets.
• Worked with Oracle Revenue Recognition and Invoicing rules to process Transactions that have both Bills paid in advance of service completed or Bills paid in arrears at the end of Service period.
• Supported, Setup and Configured AutoInvoice, LockBox and Customer Interfaces.
• Worked with cross functional teams to gather requirements and help design and develop solutions that that meet business needs, help streamline business processes and deliver as per the scope and timeline of the project.
• Configure and implement all major Oracle EBS Modules including FSG, Web ADI and Report Manager.
• Collaborate with internal and consulting resources to devise functional solutions that best serve the project.
• Excellent communication skills; verbal, written and presentation.

Confidential, Boston, NY

Oracle E-Business Suite - BA-Functional Consultant

Responsibilities:

• Responsible for functional deliverables such as business process workflows, requirements and design documents (BR100, BP80, MD70, MD50) configure, setup create test plans and implement AP, AR, GL, FA, PA modules(Costing, Billing).
• Collaborate with Business Process Owners to create detailed specifications of business requirements, functional specs and steps to implement solutions that technical teams can utilize.
• Performed Planning for Financials and Workplan setups, enhancements and customizations. Project Accounting Modules (Costing, Billing, Contracts) Payables, Receivables, Fixed Assets, Cash Management for multiple bank accounts, Inventory, General Ledger, Order Management and HCM.
• Hands-on configuration and implementation on the following Oracle Fusion HCM modules: Performance Management, Goals Management and Workforce Compensation.
• Strong functional experience in HR, Payroll and Benefits module.
• Hands on experience with program and plan changes, open enrollment configuration, creation and modification of eligibility rules, configuration workbench, and life event configuration.
• Experience with standard business process flows for benefits administration.
• Strong configuration and design skills including experience with fast formulas, formula functions, benefits interfaces, reports and processes.
• Understanding and knowledge of Oracle Cloud Services coordination requirements for implementations, My Oracle Support use, and Service Request issue identification, escalation and resolution processes.
• Experience with developing system requirements, defining and documenting procedures, and implementing a practical sustainable business solution.
• Use my strong understanding of Oracle’s core Financial and Project Accounting tracks (Procure to Pay, Order to Cash, Assets management, Contracts, Incentive compensation, Supply Chain) to solve complex issues.
• Analyze Oracle EBS Financials for the Investment bank, involved in the full lifecycle of the implementation including requirements gathering, analysis, design specifications, set-up and functional testing.
• Architecting a solution for a Cancel and Correct application that will integrate data feeds from a number of Trading systems globally for Equities, Fixed Income, Derivatives and other financial products.
• Working with OBIEE to perform detailed data analysis to identify appropriate data sources, key facts, and dimensions that support the business requirements. Performed needed tasks to support the standardization of facts and dimensions.
• Worked with FSDM data model to conceptualize and develop a C&C data repository for supervisory reporting and control.
• Involved in a System Administrators role. Setting up Oracle Applications installations, controlling access, ensuring smooth ongoing operations.
• Managing Concurrent Managers and processes.
• Monitored all components of the Applications systems using Oracle Applications Manager.
• Reviewing and implementing security and auditing for potential holes and breaches. Recording the fact that access to information was made and at what levels.

Confidential

Oracle Functional Business/Process Analyst

Responsibilities:

• Global instance experience in R-12 with Oracle e-Business Suite full life-cycle implementation and upgrades
• Develop and participate in Project plans, identify resource and staff levels.
• R12 Oracle Functional experience that includes advanced knowledge of delivery and configuration of Financials AR, AP, GL, Sub ledger Accounting, and FA.
• Collaborated and worked as part of a large team of senior consultants that were highly skilled functionally and technically.
• Experienced with multi org, inter company, multi currency environments.
• Solid knowledge of financials with multiple GL’s Chart of accounts consolidations for period end reporting.
• Strong and established track record in delivering projects ranging from small to large implementations, using a global hybrid onsite - offshore model and included Shared services.
• Performed Planning for Financials setups, enhancements and customizations. (Payables, Receivables, Fixed Assets, Cash Management for multiple bank accounts, Inventory, General Ledger, Project Accounting, Order Management and HCM)
• Functional configuration and development with emphasis on core Human capital business processes including: recruiting, benefits administration (OAB), human resources, and payroll. Considerable experience designing, implementing and supporting complex HR business processes.
• Solid experience in all financials modules Oracle Projects, Procure to Pay, Order to Cash, Assets management, Contracts, Incentive compensation, Supply Chain.
• OBIEE with Financials and HCM data warehouse. Worked with Informatica and DAC
• Work on multiple projects simultaneously, in a leadership role when required.
• Participate in design meetings, implementation planning process, the management of production and support issues

Confidential

Senior Oracle Functional Consultant

Responsibilities:

• Led the effort in Scoping, Upgrade Planning and implementing the Oracle E Business Suite 12
• Performed Planning for Financials setups.
• Experience in design, development, and administration of integration solutions using Oracle SOA Suite.
• Implemented Oracle E-Business Tax to manage transaction, tax setup associated with trading partners and tax authorities transaction tax processing and reporting
• Inventory of customizations.
• Clearing interfaces and processing exceptions
• Examining pending concurrent requests, running key reports.
• Configuring Oracle CRM modules (Contracts, TeleService, iSupport, Field Service)
• Setup Cash Management for multiple Bank accounts to automate matching, reconciling and clearing transactions.
• Responsible for designing, implementing and supporting complex HR business processes.
• Define and manage compensation and benefits packages in Oracle HCM
• Using Oracle XML Publisher to create Templates and Data Definition for these templates.
• Write templates to extract XML data using XML Publisher's data engine.
• Moving Templates and Data Definitions between E-Business Suite Instances between test, development, and production instances.
• Assist in Accounting and Finance staff with closing procedures and help them

Confidential

Oracle Functional Consultant

Responsibilities:

• Led the effort in implementing and integrating Madison Square Gardens Oracle Financials system with Confidential Corp Oracle 11i
• Performed implementation of Oracle Assets, General Ledger, Payables, Receivables, Project Accounting, OM, Property and Lease Management and PO
• Assist in Accounting and Finance staff with closing procedures and help them resolve technical and functional issues.

Confidential

Senior Business Technologist

Responsibilities:

• Performed implementation of Oracle Receivables, Assets, General Ledger, Payables, Purchasing, Inventory and Oracle Property Management
• Oracle Workflow and Oracle Applications Manager.
• Supported 170 systems applications that manage and optimize financial processes, for Accounts Payable and General Ledger.
• Investigate and analyze application support issues specifically for Accounts Receivables and Cash
• Experience with the following development languages and tools: Oracle Forms and Reports including 6i, Oracle PL/SQL, SQL*Plus, SQL*Loader, Oracle AOL, Oracle Public APIs and Oracle custom.
• Conducted and root cause analysis and drive issue resolution. This includes 7x24 coverage for emergency conditions.
• Worked with Business Analysts and Business Relationship Managers to elicit, review and refine business requirements.
• Use my detailed knowledge of Oracle Financials to identify and design solutions that meet business requirements.
• Provide work effort estimates.
• Collaborate with project managers, and project sponsors to determine project scope and vision.
• Human Resources, Payroll, Advanced Benefits, and Self Service applications
• Create test strategies, test plans, test scripts, test data and actively participate in the testing process.
• Assist with the build release process as required. This is an off-hours activity.
• Work with End-Users, Business Relationship Managers, DBAs, Technical Team, Operations, and Infrastructure Teams as required on issue prioritization, problem resolution and enhancements.

Confidential

Work Stream Lead

Responsibilities:

• Finance Track lead for Oracle Applications Implementation.
• Responsible for determining organizational structures, how many legal entities does the firm own, or are finance, marketing, and manufacturing run at the group level or by business unit.
• Performed implementation of Oracle Assets, General Ledger, Payables, Receivables.
• Design and maintain Oracle FSG budget and financial reports for financial analysts, management, and external reporting.
• Leading the effort to identify impact on people and processes due to the transformation.
• If change affects people and processes or the technology its effects and how to mitigate the impact.
• Managed a team of systems analysts, developers and testers to ensure that the processes are executed in an accurate and a timely manner
• Duties included initial site visit assessments, system setup, documentation, user, and pre & post go-live support.

Confidential

Oracle Financial Business Analyst

Responsibilities:

• Full lifecycle implementation of Oracle subledgers AP/AR/FA/Cash Management /Inventory.
• In depth knowledge of General Ledger.
• Trained and support users in month end closing procedures.
• Analyze complex Accounting processes, facilitate and recommend improvements and solutions based on best industry practices.
• Work closely with cross- functional teams and be an interface between Stakeholders and IT Development, DBA and QA teams
• Develop and nurture relationships with the internal Finance and Project Accounting User communities
• Manage the TARS (Technical Assistance Requests) process
• Develop and manage project plans, identifying resource requirements and budget forecasting
• Plan and lead the post-launch production support effort.
• Possess excellent and presentation skills with the ability to coach and mentor project teams
• Detailed functional knowledge of Accounting, processes, procedures and jargon combined with a strong Accounting Background.
• Manage resolution of technical and functional issues and requests for assistance on Financial Applications.

Confidential

Consultant For Oracle Financial Applications

Responsibilities:

• Configuration, implementation and support of the Functional/technical environments of Oracle Financials, including Modules: AP, AR, GL, INV, PO, OM, FA
• Developed and produced complex Financial Reports.
• Analyze the reporting needs and establish hierarchies. Streamlined operations by conferring with managerial and SME’s (Subject Matter Experts) clarify program intent. Identify problems and suggest changes.
• Upgrade from 11.0.3 to 11i. Converted the data, data structure, applications programs and other objects into the new Release 11i objects.
• Gap analysis was performed with R11i. Assisted functional users to: cleanup List of Values, clean any old setups and perform testing
• Experience with data warehousing, multi-dimensional database architecture/data modeling and OLAP systems
• Used Oracle workflow to automate business processes by routing information and events to decision makers so policy can be reviewed or modified. Prepared flowcharts and diagrams to illustrate sequence of steps program must follow.
• Set up OM to interact with Receivables, it was configured so that web customers can enter orders and check status make payments.
• Work closely with application development teams in the upgrades, new development and customization of AP, AR, GL, FA modules. Resolve technical issues related to the application database server and provide best practices for the monitoring, support and maintenance of the application.
• Create and maintain portions of the project plan related to the technical implementation.
• Participate in other ERP related reengineering efforts as necessary to assess their impact on the Oracle Financials application.
• The role involves 60-70% of on-going Production Support and 30-40% of new developments/implementation, /mentoring of staff in Oracle Financials Administration.

Confidential

Consultant For Oracle Financial Applications

Responsibilities:

• Analyze and translate business needs into a logical model.
• Interacted and communicated with the user on a regular basis.
• Identify and prioritize multiple needs and activities. Used my communication skills and negotiated requirements against time and cost constraints.
• Knowledge of the architecture of the financials module including Oracle Projects
• Developed custom program units with Forms.
• Produced Reports using PL/SQL.
• Loaded budgets into the General Ledger with the help of The Desktop Integrator.
• Plan and define the Accounting flexfield
• Define a set of books
• Create a basic chart of accounts structure
• Consolidate multiple set of books
• Define summary accounts.
• Set up a multiple currency environment
• Enhance Accounting and Financial Reporting by providing the ability to segregate and retrieve meaningful Accounting information through the establishment of detailed sub accounts.

Confidential

Senior Consultant

Responsibilities:

• Analysis, Design and Development
• Successfully implemented an enterprise wide suite of Oracle which Included planning and management of the implementation process.
• Predefined business process workflows.
• Analyze and document business requirements.
• Design and development standards.
• Conversion and bridging issues.
• Formulate test plans.
• Purchase Orders, Replenishments, Planning and Allocation.
• Inventory management.

Confidential

Staff Accountant

Responsibilities:

• Accounting functions
• Prepare and analyze monthly journal entries.
• Prepare and analyze balance sheet reconciliations.
• Prepare analytical review reports for various balance sheet and income statement accounts.
• Prepare and analyze schedules to assist with quarterly reviews and year-end audits.
• Assist in the preparation of financial reports, reconciliations, and other financial analysis for the Company.