Summary

• Adept at developing and supporting analysis solutions, data transformations, and reports
• 8 years of professional experience as Financial Analyst
• Experience in Procure to Pay processes
• Financial modeling, analysis and reporting experience
• Excel at developing and implementing reporting and data reconciliations using SQL and SAP tools
• Proven background improving process quality and providing system automation recommendations and strategies to manage solutions and data efficiently
• Maintain positive communications and working relationships at all business levels
• SAP Certified Solution Consultant, knowledge of SAP Financials and Business Intelligence
• CPA

Technical Skills Include

Query tools: SQL, SAP Business Explorer and Analyzer
MS MS Suite (Word, Excel, Powerpoint and Access), Visio

PROFESSIONAL EXPERIENCE:

Confidential
August 2010 to date

Project: Cintas Inc., Ohio

• SAP BPC Microsoft 7.5 Version
• Blueprint support, cost and resource estimation
• Planning Application set up
• Create EVDRE Reports in BPC-Excel
• Functional Design documents
• Functional Design of BI to BPC Reconciliation
• Testing of Planning reports, input schedules and data loads from BI cube

Confidential, Houston, TX
June, 2010 to July, 2010

BPC Report Developer – as a Contractor for SAP America.

• Develop ‘Actual’ Reports in BPC from Hyperion
• Prepared 44 EVDRE Reports using templates
• Good knowledge in EVDRE functions, formatting, options and data ranges
• Troubleshoot issues pointed out by the Testers in the Reports
• Support the Project Manager in data loads

July, 2009 to May, 2010
Confidential, CA:

Senior and Lead Consultant– SAP BPC (Business Planning and Consolidations)

• SAP BPC Netweaver 7.0 Version
• Collection and documentation of functional requirements and assessment of KPIs
• Conduct Gap Analysis between business requirements and SAP
• Design, prototype and test BPC application
• Configure Appset, Applications, Dimensions, Properties, Foreign Currency, Script Logic, Business Rules and Security
• Configure Input Schedules on Rolling forecasts and budgets
• Configure Transformation files and data loading packages
• Configure EVDRE reports on Planning
• Utilize Hyperion Planning and Financial and Xcelsius reports to facilitate the Budgeting, Forecasting, and Financial Reporting processes
• Administer change control procedures and troubleshoot issues
• Write test scripts, user testing, documentation and training

Confidential
March, 2008 to July, 2009

Senior Consultant – SAP BPC (Business Planning and Consolidations)

Project: AIG, New York – SAP BPC Version 7.0 (February, 2009 to July, 2009)

• SAP BPC Netweaver 7.0 Version
• Blueprint support
• Configure Appset, Applications, Dimensions, Business Rules and script logic
• Configure Master Data – Chart of Accounts, Customers, Vendors and Product hierarchies
• Configure currency translations – Rate of exchange upload, Rate Types and dimensions
• Interco Elimination journal entries in consolidation system and investment in subsidiaries
• Web administration
• Consolidations:
  Intercompany eliminations: AR AP, bond transfers, reinsurance elimination
  Planning:
  Design and develop input schedules, reports and custom interfaces, budget actual and forecast models
• Create EVDRE Reports in BPC-Excel
• Design Proof of Concept documents
• Functional Design of legacy systems to BPC interfaces
• Functional Design of BI to BPC Reconciliation
• Testing of Planning reports, input schedules and data loads from BI cube
• Team status meeting reports

Confidential, New Jersey (October, 2008 to February, 2009)
SAP BPC (Business Planning and Consolidations)

• Configuration rationale documentation
• Configure appsets, dimensions, properties, applications, input schedules
• Consolidations:
  Intercompany eliminations, equity, Capital contributions and sale of subsidiary
• Create Transports in SAP Development system and move to SAP Test System
• Create Remedy tickets for QC defects
• Create BPC test scripts in HP-QC tool
• Follow-up/resolve test issues
• Test data loads from the source cube against BPC cube
• Oversee test results related to BPC
• Create reports on Profit and Loss Account, Balance Sheet and Planning actual and variance results
• Interact with Client/Accenture Management on important issues

• Configure master data, currency translation, applications in BPC V5.0
• Planning: budgets, forecast model. Develop Input Schedules and Reports
• Worked with Accenture and Wolseley counterparts as the reporting lead and turned requirements into functional
• and technical report designs through R0.1 and R1 releases.
• Supervised junior Accenture resources and client resources
• Closely worked with IDC, India, in building the reports
• Conducted walk-through on functional/technical designs with IDC, India and resolved issues
• Prepared and executed test cases for Assembly and Product test cycles using the QC tool
• Followed up on test defects and prepared reports for internal and Accenture Managements

Confidential, California
September, 2007 to March, 2008
SAP Version SAP – BI 7.0, SEMBCS

Senior SAP BPC Consultant

• Conduct requirements gathering workshops with different focus groups
• Develop blueprint for BPC functionalities
• Configure Appset, Applications, Dimensions, Business Rules and script logic
• Report on Cost center and Profit center accounting areas
• Create EVDRE Reports in BPC-Excel
• Design Proof of Concept documents
• Configure user authorizations and security profiles
• Work with the BI group to perform the design, specifications and implementation of InfoPackage groups, events and process chains for scheduling loading of Master and Transaction data
• Developed work plans, test plans and status reports

Confidential, Kansas
April, 2007 – August, 2007
SAP Version: SAP – BPC 5.1

Senior SAP BPC Consultant

• Blueprint: Gather requirements from end users and prepared blue print documents
• Collection and documentation of functional requirements and assessment of KPIs
• Design, prototype and test BPC application
• Configure Appset, Applications, Dimensions, Properties, Foreign Currency, Script Logic, Business Rules and Security
• Configure Input Schedules on Rolling forecasts and budgets
• Configure Transformation files and data loading packages
• Configure user authorizations and security profiles
• Configure EVDRE reports on Planning using templates
• Design process chains for automatic data loading
• Administer change control procedures and troubleshoot issues
• Write test scripts, user testing, documentation and training

Confidential, Greenville, SC
May, 2006 – Feb, 2007
SAP Version: SAP BPC 5.1

BPC Consultant

• Information gathering from business users and Management in three domestic sites to document their business processes.
  BPC:
• Master Data: Configured segmental hierarchies, Versions
• Configure Transformation files and data loading packages
• Configure user authorizations and security profiles
• Configure EVDRE reports on Planning using templates

Confidential, South San Francisco, Ca
January, 2006 – April, 2006
SAP Version: SAP SEM-BW 3.5, SEM-BCS, SAP R/3 4.7

Senior BW/SEM BCS Consultant

• Gathered requirements and mapped ‘as is’ application processes from end-users
• Mapped existing operating chart of accounts from legacy consolidation system (Frango) to SAP R.3 to BCS systems
• Created Legal, Country and segmental hierarchies consisted of 41 consolidation units in BCS
• Created flexible uploads using Excel templates and reconcile data between legacy (Frango) and BCS systems.
• Configured Movement types and breakdown categories
• Created the Group Chart of Accounts and assign it to the Operating Chart of Accounts
• Defined data and consolidation monitor tasks, document types, number ranges and task groups
• Wrote Unit Testing script for validation of Trial Balance, Income Statement and Balance Sheet
  Items. Maintain Unit Test Logs to record results and errors and their remediation
• Wrote Integration Testing scripts for Consolidation Unit, copy of version, Currency Translation, data collection and elimination tasks. Maintain error log for follow-up and remediation
• Performed Unit Testing of validating financial statement data and integration testing of BEX reports
• Prepared documentation and conduct training for end-users

Confidential, San Jose, Ca
July, 2005 – November, 2005
SAP Version SAP BW 3.5

SAP BW Consultant

• Prepared Business Requirement Documents and checked Business Content to identify necessary Business Objects
• Customized Business Content InfoSources, ODS Objects and InfoCubes to meet client requirements
• Created Management Reports using BEX queries on consolidations based upon the business content cubes.

User training on FICO and BEX report generation
Confidential, Fremont, Ca
November, 2004 – May, 2005
SAP Version SAP BW 3.5 SAP R/3 4.7

SAP BW Consultant (Independent)

BW-BCS-FI Reporting Solution:

• Performed the design, development and testing of a financial reporting solution based on R3 FI-GL FI-AR and FI-AP Modules
• Activated the Business Content for both Transaction data and Master Data for FI. And the relevant Business Content in BW
• Developed an extraction strategy for FI Data
• Scheduled extract jobs with BW Scheduler and monitored transfer/update of data loads into ODS and InfoCubes with BW Monitor
• Created Process Chains to automate the data load and data target administration and monitored the processes
• Worked closely with users created custom queries using BEX Analyzer
• Developed documentation and user manuals
  Accounts Payable
• Accounts payable, Account group & Tolerance group creation, number range for vendor master and the documents, vendor reconciliation account creation
• Vendor master creation, posting entries, account balance, line item wise display of vendor Accounts and open item management
• Down payment to vendor, adjustment of down payment
  Accounts Receivable
• Accounts Receivable, Account group & Tolerance group creation, number range for customer master and the documents, customer master creation, posting entries, account balance, line item wise display of customer Accounts and open item management
• Down payment from customer and adjustment of down payment

Confidential, San Jose, Ca
June, 1998 – August, 2004
SAP Version: SAP BW 3.0B, SAP R/3 4.7C

FICO/BW Consultant (IBM employee)

• SAP BW/FICO support for Global Procurement Division
• Preparation of Performance Measurement Reports using SAP BW
• BW: Team lead on establishing a global data warehouse. Extensive follow-up with team members on data mapping of legacy systems to SAP- BW, Testing and documentation Designed, developed and extracted from Non-SAP Databases thru flat file to BW Performed various tuning techniques (aggregates, statistics and partitioning) to optimize the query performance Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures, exceptions, conditions in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information Worked on RRI jump queries and ODS queries Extensively used process chains to automate the process of loading data into data targets Created role based security and authorization for the solution
• Developed Reporting system on web using web application wizard
• Created Custom InfoCubes/Objects for the accommodating the global data available across the organization including data from SAP and Non-SAP data
• FICO: Configuration of SAP R/3 -4.6C upgrade of FI/CO module: G/L, chart of accounts, AP, AR, customer and vendor master data, account determination, document posting, posting key, cost elements, cost centers, Profit centers and Profitability Analysis

EDUCATION:

CPA
M.S. Accounting