Senior Functional Lead Business Analyst Resume Profile
SUMMARY
- More than fifteen 15 years of experience of which more than Eleven 11 years of experience in financial management and reporting from AP, AR, Payroll, Projects and Government/Civilian Contracts Administration, GWAC, STARS, WICAP, Procurement, Spend Analytics, EDI, Financial Gateway administration systems to recognize and generate revenue recognition, General Ledger to Month End Closing, financial systems consolidations and/or reconciliation's, budget analysis and setup, Project Management Accounting to monthly annual financial statements using Oracle Financials EBS Suite Oracle Financials 10/11i/rel 12i, HRIS, AP, AR, Billing, Order-to-Cash, Procure-to-Pay, Cash Management, Inventory Management, General Ledger, Project Administration Costing, Fixed Assets Project Resource Management utilizing Clarity NIKU Project Management Analysis, AP/AR/Project Management/Purchasing, Oracle Financials modules versions 10g/11i/release 12i. for the following modules iReceivables iPayables iProcurement iExpense Procure-to-Pay G/L A/R Billing FA Order Management Inventory Management FAS Software, MS Excel, MS Word, MS Access, MS Visio, SAP, MS Project Works, SAP R/3, Hyperion Reports, Crystal Reports, .NET Report Writer, Oracle Discoverer Reports and Business Intelligence Software. Expertise in creating functional and technical administrative use cases, test cases/scripts and executive reports for sales, month-end closing, marketing inventory analysis, revenue recognition, and job costing.
- Three 3 full implementations Oracle Financials version 10/11i/R12i Projects/Project Costing, Grants Administration, Property Management, Procure-to-Pay AR, AP PO Order-toCash, Asset-to-Retire FA Oracle Discover Report Web ADI TOAD Hyperion Enterprise HRIS iExpense iReceivables iPayables/iSupplier Time Expense, SCM/CRM Advanced Collections with specialty to the Procure-to-Pay life cycle and its implementation in Oracle Purchasing and Payables Internet Business Solutions applications for the following releases 11.5.10i/11.5/release 12i.
- Maintain and/set up information regarding suppliers, sites, and quotations used in the procure-to-pay process.
- Working knowledge of the procure-to-pay cycle and key implementation issues in Oracle Sourcing, Order Management Requisitions, iProcurement, iExpense iReceivables Multi-National Currency Vertex Tax Software and Purchase Orders systems.
- Identified processes involved in different phases of the procure-to-pay life cycle to include preparation of Use Cases, Test Scripts and Business Process improvement. Match the applications used in the procure-to-pay process with their descriptions.
- Identified role of suppliers in the sourcing phase of the procure-to-pay process.
- Gathered requirements, configured the Oracle Service Contracts and Sourcing for SO, Contracts, BPA's, and PO's
- Provide enhancements to AR, GL, FA AP Procure-to-Pay, HR Cash Management features, options of suppliers ASL's, supplier sites. - Create a PO catalog quotations. - Create a standard Purchase Order PO using Workflow
- - SME for Financial Gateway transactions to and from workflows that included EFT payments EDI payments Purchasing Sales/Quote-2-Order, Standard invoicing forms. - SME for POS transactions, EFT payments EDI payments standard payment forms.
- - Mass Consolidations of department overhead and overall cost recognition
- Identified the tasks to perform when preparing for closing a Payables period.
- Identified tasks related to invoices and accounting entries that needed to be performed to close a Payables period.
- Identified accounts payable AP PO AR EDI- Advanced Collections and GL-related tasks that need to be performed for closing a Payables and Accounts Receivables period end and reconciliations.
- 3-4 years of custom reporting design and implementation experience with Web ADI, SQL/SQR Reports, .NET DOD OTL XML Publisher Hyperion and Vista Plus or Mobius.
- Develop, review, test and maintain automated web forms and system reports I.e. P L, Balance Sheet, Cash Flow and other operational reports for month-end Actuals close, Forecasting, Budgeting and Long Range Planning processes to ensure and improve the accuracy and integrity of the data maintained in the financial systems.
- The primary focus will be end user support for the Financials, iPurchasing/iProcurement, iReceivables/Billing, iPayables, Advanced Collections, Inventory and Maintenance applications.
- Provide support and assist users with ERP application issues as recorded and routed through the corporate call logging application LanDesk, Oracle Support/Metalink or Remedy Ticketing Software.
- Coordinated and document end user testing for all issues as they are resolved using Requisite Pro Software
- Provided technical solutions primarily SQL ADI and Oracle Accelerator to resolve data and integrity issues
- Gather and document business requirements, business processes for configurations, functional specifications and
- Five years of domain expertise in OTC and Supply chain domain with specialization in Order Management and Advance Pricing and Receivables modules.
- Experience in implementation, requirements gathering, process mapping, training, configuration, conference room pilot, Fit/Gap analysis, functional and technical design specifications, and post implementation support in Oracle Applications.
- Excellent functional and technical knowledge in Oracle Order Management and Distribution modules like Warehouse Management System, Inventory, Bills of Material BOM , Work in Process WIP , Costing CST , Material Requirements Planning MRP .
PROFESSIONAL EXPERIENCE
Confidential
- Senior Functional Lead Business Analyst/ OTC, AR, Advanced Pricing, CRM Leads to Cash
- Work with Brink's colleagues, partners and clients, elicit requirements to solve a business problem or progress an opportunity for a new/enhanced business solution
- Facilitate workshops/meetings with key stakeholders applying the appropriate elicitation techniques to establish the as-is and to-be state to meet the business/client's needs
- Created and maintained documentation, including procedures, system specifications, technical documentation and business requirements documentation BRD of all regulatory, business, user, functional and non-functional requirements
- Completed formal reviews of all requirements, to approve business requirements documentation
- Created and maintained supporting business models, process models, data models and workflow models as required, through structured and object-oriented analysis
- Worked with QA Analysts to design test cases to validate that requirements have been met, overseeing the testing phase as required
- Overseen 'end-user' support, complimenting the Training and Development Manager with knowledge of the business requirements
- Assessed and evaluated all feedback, ensuring the requirements necessary to address any issues are addressed in future releases, iterations or versions of the solution
- Seek out and identified problems and opportunities, through Business Process Re-Engineering, presenting recommendations for improvement
- Prepared and delivered presentations based on requirement gathering and data analysis
- Performed investigational analysis and evaluation to determine project or application feasibility
- Prepared feasibility studies recommends and establishes program objectives, priorities and schedules in conjunction with user and functional requirements and conducts end-user training, as needed, for assigned applications
Confidential
Senior Applications Support Analyst P2P, OTC, RTR
- Maintain and/set up information regarding suppliers, sites, and quotations used in the procure-to-pay process.
- Working knowledge of the procure-to-pay cycle, functional and technical processes involving key implementation issues in Oracle Sourcing, Order Management Requisitions, iProcurement, iExpense iReceivables Multi-National Currency Supplier setup, E-Business Tax Software and Purchase Orders systems.
- Identified processes involved in different phases of the Procure-to-Pay and Order-to-Cash Life Cycles. Match the applications used in the procure-to-pay process with their descriptions.
- Identified role of suppliers in the sourcing phase of the procure-to-pay process.
- Provide enhancements to AR, GL, FA AP Procure-to-Pay, GL HR Cash Management features, options of suppliers ASL's, supplier sites. - Create a PO catalog quotations. - Create a standard Purchase Order PO using Workflow. - SME for POS transactions, EFT payments EDI payments standard payment forms.
- Identified the tasks to perform when preparing for closing a Payables period.
- Identified tasks related to invoices and accounting entries that needed to be performed to close a Payables period.
- Identified accounts payable AP PO and GL-related tasks that need to be performed for closing a Payables and Accounts Receivables period end and reconciliations.
- 3-4 years of custom reporting design and implementation experience with Web ADI, SQL/SQR Reports, DOD OTL XML Publisher Hyperion Windows .Net Framework and Vista Plus or Mobius.
- Develop, review, test and maintain automated web forms and system reports I.e. P L, Balance Sheet, Cash Flow and other operational reports for month-end Actuals close, Forecasting, Budgeting and Long Range Planning processes to ensure and improve the accuracy and integrity of the data maintained in the financial systems.
- The primary focus will be end user support for the Financials, iPayments, iProcurement, iReceivables/Billing, iSupplier Portals, Advanced Collections, Inventory and Supplier Maintenance applications.
- Provide support and assist users with ERP application issues as recorded and routed through the corporate call logging application.
- Coordinated the resolution of complex issues with financial Enduser's and Oracle's support desk.
- Coordinated and document end user testing for all issues as they are resolved
- Provided technical solutions primarily SQL ADI and Oracle Accelerator to resolve data and integrity issues
- Analyzed end user requirements or customer reported defects and develop test plan and strategy, design, code, and execute automated tests across a variety of architectures and cutting-edge technologies.
- Worked hand in hand with the development team while being part of a Quality Assurance community as well as collaborated with agile team members to drive the test and automation strategies.
- Have knowledge and capability for estimating LOE for test/script development, test execution, and other activities central to assigned tasks.
- Developed new tests and maintained existing tests across multiple platforms and toolsets ie. Turnkey, UTF, etc
- Provided training and support to more junior automaton engineers and/or our offshore QA team on complex configuration and execution support techniques.
Confidential
Senior Functional Lead Business Analyst/ OTC, AR, Advanced Collections, iReceivables, CM
- Gathered requirements from business partners.
- Involved in business process flow and functional design document preparation, documentation, system configuration and implementation for Order to Cash, Procurement, SCM/CRM/Fusion.
- Documented Functional design for technical team.
- Provided support for areas of Finance G/L A/R and A/P.
- Provided training to various sites as well as co-workers in UPK 2.7 through 3.5.
- Work as the solution architect on OTC business processes.
- Attend and participate in the meetings with business users representing all sectors.
- Attend meetings with Track Lead and discuss the gaps and plan of actions.
- Work with finance team to understand the financial impact and determine the scope of RICE components.
- Prepare TO-BE process flows and review them with the project team..
- Determine the reusability of the RICE and BR040, BR100, etc components from functional stand point.
- Participate in the Deep Dive sessions to understand and challenge the current business processes.
- Organize meetings with business leads and track leads to discuss and find a common agreeable solution on different scenarios.
- Review the RICE requirements with the tech lead and consolidate the list.
- Prepare the initial configuration document for CRP sessions.
- Prepare data for the technical team for RICE testing.
- Functional testing of the RICE components.
- Multi-National Intercompany reconciliations, including foreign currency translation, process improvements, and system testing.
- Intercompany Multiple Currency - established recon process
- General Ledger Reconciliations
- Bank Reconciliations - reconciled 15 accounts that had not been done in over a year
- Intercompany, Eliminations
- Reconciled Accounts Payable Accounts - Never reconciled before
Confidential
Sr. Oracle Financials Consultant/ Functional Lead Analyst AR, CM, Billing
- Work as the Order to Cash Functional Consultant.
- Arrange and organizing meetings with business users to capture the AS-IS process .
- Attend meetings with OM Track Lead and other team members to share and discuss the information gathered.
- Lead challenge workshops to validate the existing process and prepare design documents for resolving the gaps identified.
- Prepare TO-BE process flows and review them with the business and obtain an approval sign off.
- Work with the Configurator Team to define and design the strategy for modeling.
- Work with the Planners and schedulers to achieve a common solution for planning and order fulfillment.
- Responsible for configuring defaulting Rules and define strategies to cater to the Order booking process.
- One of the key interfaces done was integrating the 11i Order Entry system with 10.7 Character Manufacturing system for Residential and some commercial locks , and AS400 for some commercial door products . This integration included 2 way interfacing of New Orders, Order Updates and Shipping information between these systems.
- Responsible for preparing the training material and conduct training at the end of user acceptance testing.
- Also responsible for supporting the Falcon product which was implemented earlier . Support included resolution of issues and also design new enhancements.
- Perform FIT/GAP analysis and Business Requirements documentation.
- Perform/Create Test Scripts for System Performance Unit Testing Business Process Modeling QA Testing etc. using Mercury Quick Test, Test Director and/or manual.
- Facilitate meetings with client representatives to identify and create functional requirements.
- Facilitate meetings with Development Team to document technical design requirements.
- Meet with other members of CIS to review completed functional specifications, technical specifications and customizations.
- Perform systems analysis and design activities and provide support to Technical team in designing test scripts, data integration and conversion using Clarity.
- Provided training to various sites as well as co-workers in UPK 2.7 through 3.5.
- Oversee and assisted in the development and finalization all training materials and delivered the end-user training for numerous financial modules P2P, OTC, ATR, Tax, EBS, etc,
- Determine and resolve application and program problems using Clarity.
- Assist in the creation and review of test scripts.
- Advise and assist ERP Application Analysts and Senior ERP Application Analysts in areas of special knowledge or certification, i.e. Crystal Reports, HR, Benefits, Payroll, Benefits Administration, etc.
- Document meeting minutes, action items, and issues as assigned by the project manager.
- Planning and managing Application Assessment and Requirements activities
- Assisted clients in defining key capabilities /requirements that will enable their strategy by: Defining the application entrance and exit criteria Planning and managing application design and architecture activities Creating project deliverable templates and standards including coding standards, etc Creating complex conceptual designs including application interfaces and interactions Planning and managing program-wide application build, test, and deploy activities Identifying and monitoring interdependencies between various application implementation activities Planning and establishing after go-live activities including ongoing application support Escalate priority issues to project managers.
Environment: Oracle Financials 11i/R12i SCM/Primervera Project Management modules A/R Billing Advanced Collections UPK v3.5 Inventory Management Order Management, Order-to-Cash, A/P G/L Procure-to-Pay, Cash Management, iExpense iReceivables iPayables iSupplier Purchasing Fixed Assets Asset Management Clarity SAP FICO FSG Financial Reporting APP Engines Interfaces SQL/SQR Hyperion FMS/EssBase Discoverer ETL, Financial Banking Gateway, Cash Management, MS Office Suite Excel Access Projects Visio SharePoint and Word Telecom Software One-View ABACUS and Delphi Mercury Quick Test and/or Test Director Oracle Tutor.
Confidential
Sr. Oracle Financials Consultant / Sr. PeopleSoft Financials Functional Analyst Project Basis
Sr. Business Analyst / QA Analyst Project Basis
- Work as the Order to Cash Functional Consultant.
- Arrange and organizing meetings with business users to capture the AS-IS process .
- Attend meetings with OM Track Lead and other team members to share and discuss the information gathered.
- Lead challenge workshops to validate the existing process and prepare design documents for resolving the gaps identified.
- Prepare TO-BE process flows and review them with the business and obtain an approval sign off.
- Work with the Configurator Team to define and design the strategy for modeling.
- Work with the Planners and schedulers to achieve a common solution for planning and order fulfillment.
- Responsible for configuring defaulting Rules and define strategies to cater to the Order booking process.
- One of the key interfaces done was integrating the 11i Order Entry system with 10.7 Character Manufacturing system for Residential and some commercial locks , and AS400 for some commercial door products . This integration included 2 way interfacing of New Orders, Order Updates and Shipping information between these systems.
- Responsible for preparing the training material and conduct training at the end of user acceptance testing.
- Also responsible for supporting the Falcon product which was implemented earlier . Support included resolution of issues and also design new enhancements.
- Create QA test scripts Regression Testing UAT Testing System Testing, etc. and perform testing using Mercury Quick Test and/or Test Director.
- Participate in formal code review process and provide support to the project teams in resolving issues in production post implementation when needed
- Update and Provide End-User Training materials for PeopleSoft Financials v8.9 and Oracle Financials v11i for the following Modules A/R Billing A/P G/L Fixed Assets/Asset Management Procurement Project Cost HRMS Multinational Currency Taxes Hyperion EssBase Financials Clarity and Discoverer.
- Participate in and lead requirements definition sessions, planning sessions, status meetings, and issue resolution sessions for End-User Training.
- Perform FIT/GAP analysis and Business Requirements documentation.
- Perform/Create Test Scripts for System Performance Unit Testing Business Process Modeling QA Testing etc. using Mercury Quick Test, Test Director and/or manual.
- Facilitate meetings with client representatives to identify and create functional requirements.
- Facilitate meetings with Development Team to document technical design requirements.
- Meet with other members of CIS to review completed functional specifications, technical specifications and customizations.
- Perform systems analysis and design activities and provide support to Technical team in designing test scripts, data integation and conversion using Clarity.
- Determine and resolve application and program problems using Clarity.
- Assist in the creation and review of test scripts.
- Advise and assist ERP Application Analysts and Senior ERP Application Analysts in areas of special knowledge or certification, i.e. Crystal Reports, HR, Benefits, Payroll, Benefits Administration, etc.
- Document meeting minutes, action items, and issues as assigned by the project manager.
- Functional Design Specifications to Upload Spot Currency Rates for PeopleSoft Procurement transactions and provide interfaces to AGIS System for Budget Amount Restatements.
- Functional Design Specifications for Ability to purchase in a desired currency ie Currency Configuration in JDE and Interface to PPSFT AP System
- Planning and managing Application Assessment and Requirements activities
- Assisted clients in defining key capabilities /requirements that will enable their strategy by: Defining the application entrance and exit criteria Planning and managing application design and architecture activities Creating project deliverable templates and standards including coding standards, etc Creating complex conceptual designs including application interfaces and interactions Planning and managing program-wide application build, test, and deploy activities Identifying and monitoring interdependencies between various application implementation activities Planning and establishing after go-live activities including ongoing application support Escalate priority issues to project managers.
- Create reports for financial analysis and reconciliations for the financial team to create journal entries, perform mass allocations and/or projects P L reports or adhoc reports.
- Assist in the development of standards and guidelines around business processes and procedures.
- Ensure compliance of all standards and guidelines within the project.
- Distribute and review project tasks for both the ERP Application Analyst and the Senior ERP Application Analyst.
- Assist the Project Manager in developing and maintaining the Project Charter. Assist and manage Project Schedules. Assist with issue resolution.
- Participate in vendor contract negotiations by providing comments for such documents as Master Service Agreement, Service Level Agreement, Technical Hosting Descriptions, and other contractual documents.
Environment: Oracle Financials 11i/R12i Primervera modules A/R Billing Advanced Collections HRIS Inventory Management A/P G/L Procure-to-Pay, Order Management, Cash Management, iExpense iReceivables iPayables iSupplier Purchasing Fixed Assets Asset Management Clarity SAP FICO SIRAX Net Weaver FSG Financial Reporting PeopleCode Project Costing Procurement and HRMS I-Pay/I-Procure to Payment Time Reporting Expenses HRMS APP Engines Interfaces SQL/SQR Hyperion EssBase Report Writer MS Office Suite Excel Access Projects Visio SharePoint and Word PeopleSoft Financials Telecom Software One-View ABACUS and Delphi Crystal Reports . Hyperion FCM/EssBase PeopleSoft Financials v8.9 A/P A/R HRMS Fixed Assets G/L: Project Costing FSG Reporting Procurement Time Reporting Expenses NVision Report Structure Workflow Mercury Quick Test and/or Test Director Oracle Tutor.