Sample bpc resumes :
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 c ube
Confidential, June, 2010 to July, 2010
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 Lo gic, 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)
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 c ube
Team status meeting reports
Confidential, (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
Confidential, (March, 2008 to September, 2008) SAP BPC (Business Planning and Consolidations)
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 re leases.
Supervised junior Accenture resources and client re sources
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 prepare d reports for internal and Accenture Managements
Confidential. 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, April, 2007 – August, 2007 SAP Version: SAP – BPC 5.1 Senior SAP BPC Consultan t
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 L ogic, 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. 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, 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 Operat ing 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, I ncome Statement and Balance Sheet Items. Maintain Unit Test Logs to record r esults and errors and their remediation
Wrote Integration Testing scripts for Consolidation Unit, copy of ver sion, 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, July, 2005 – November, 2005 SAP Version SAP BW 3.5 SAP BW Consultant
Prepared Business Requirement Documents and checked B usiness 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.
Confidential 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 FIGL 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 cre ation, 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 June, 1998 – August, 2004 SAP Version: SAP BW 3.0B, SAP R/3 4.7C
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 t he 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: