SUMMARY:

• Adept at developing and supporting analysis solutions, data transformations, and reports
• 8 years of professional Experience of Full life Cycle knowledge on SAP FI/CO Module - General Ledger Accountant - GL, PL and BS - reconciliations, work papers, cost, cash control, AP, AR and PR, AA.
• 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 recommendationsand strategies to manage solutions and data efficiently
• Maintain positive communications and working relationships at all business levels
• Strong Excel, Powerpoint and Access skills, with particular focus on financial modeling and the use ofadvanced features of spreadsheets
• Strong experience with SAP Planning and Consolidations
• Exceptionally organized with great ability to work on multiple projects at once
• Deep level of analytical ability and accuracy
• Remarkable ability to work independently and complete tasks with minimal supervision
• Excellent interpersonal and organization skills
• Excellent communication, both oral and written skills

TECHNICAL SKILLS:

Query tools: SQL, SAP Business Explorer and Analyzer, FICO

MS MS Suite: (Word, Excel, Powerpoint and Access), Visio

PROFESSIONAL EXPERIENCE:

Confidential

Sr Accountant (Contract)

Responsibilities:

• Forecast and consolidated total expenses for all departments on a monthly basis.
• Collaborated with peers in Accounting and Finance to perform ad-hoc analysis to explain variances versus Budget, prior forecast and prior months.
• Prepared monthly executive presentation that highlighted the key drivers of expense variances vs. the Budget, prior forecast and prior months.
• Worked with the Department Heads to prepare their detailed annual Budget.
• Provided the Department Heads with their monthly expense performance vs. Budget so that they would be aware of how their department was performing compared to the Budget.
• Served as the primary point of contact and performed timely research to answer questions from Department Heads.
• Served as the resident expert on expenses within Finance.
• Continued to look for ways to improve the accuracy of forecasting process.
• Continued to look for ways to automate forecasting process.

Confidential

Sr. Accountant (Contract)

Responsibilities:

• Collect and study data to determine costs of business activities.
• Recommend budget adjustments, and other cost improvement measures.
• Analyze financial data and extract and define relevant information; interpret data for the purpose of determining past financial performance and to project a financial probability.
• Review costs and perform cost benefit analysis related to projects and programs.
• Perform moderately complex statistical, cost, and financial analysis of data reported in the various financial systems.
• Develop financial reports for forecasting, trending, and results analysis.
• Record, classify, and summarize financial transactions and events in accordance with generally accepted accounting principles.
• Interpret financial transactions and events for users who must make economic or business decisions.
• Apply a working knowledge of applicable laws and regulations; verify documents for completeness and compliance with government and private agencies.
• Use various software applications, such as spreadsheets, relational databases, statistical packages, and graphics packages to assemble, manipulate and format data and reports.

Confidential

Senior Consultant

Responsibilities:

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

SAP BPC (Business Planning and Consolidations)

Responsibilities:

• Configuration rationale documentation.
• Configure appsets, dimensions, properties, applications, input schedules.

Confidential, Virginia

Responsibilities:

• Configure master data, currency translation, applications in BPC V5.0
• Planning: budgets, forecast model. Develop Input Schedules and Reports
• Worked with Confidential and Confidential counterparts as the reporting lead and turned requirements into functional and technical report designs through R0.1 and R1 releases.
• Supervised junior Confidential 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 Confidential Managements

Confidential, California

Senior SAP BPC Consultant

Responsibilities:

• 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

Senior SAP BPC Consultant

Responsibilities:

• 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
• Configure user authorizations and security profiles
• Configure EVDRE reports on Planning using templates
• Administer change control procedures and troubleshoot issues
• Write test scripts, user testing, documentation and

Confidential, Greenville, SC

BPC Consultant

Responsibilities:

• Information gathering from business users and Management in three domestic sites to document their business processes.
• 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

Senior BW/SEM BCS Consultant

Responsibilities:

• 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 for end-users

Confidential, San Jose, Ca

SAP BW Consultant

Responsibilities:

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

Confidential, Fremont, Ca

SAP BW Consultant (Independent)

Responsibilities:

• 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
• 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 AnalyzerDeveloped documentation and user manuals
• 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, 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

FICO/BW Consultant

Responsibilities:

• 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