SUMMARY:

• 14 Years. Experience in handling geographically distributed teams and stakeholders, with 5 years in people management, project management along with hands on technical contribution. Has successfully led and set up development teams to roll out planning and consolidation projects for various customers. Highly skilled in rapid deployment of BPC solutions with significantly increasing efficiency of the business processes.
• Experienced in understanding challenges of existing processes in consolidation and financial reporting and providing views for superior capabilities. Evolved as a true Industry expert from working in SEM BPS, BCS, IP, BW, HANA, BPC Classic, BPC Embedded and now Real Time Consolidations in S/4 and BPC optimized in S4 HANA or B/4 Hana thereby contributing with practical solutions to the customers with evolving technology in this space. Strong Functional knowledge and implementing strategies for best planning and budgeting solutions.
• Finance Management
• Budgeting, Forecasting, Planning
• AO/ BW/BEX Reporting
• Revenue, Cost Center, Capex, HR Planning
• Consolidation Close Management
• Financial Planning and Analysis
• FICO, S/4 HANA, Simple Finance
• BPC Embedded /IP Planning
• EPM Reporting, BPC/ BW configuration
• Advanced Excel,Powerpoint, Visio,Demo
• Big Four Experience( Deloitte, Accenture)
• Tableau and BO Dashboards
• Legal and Management Consolidation in BPC
• Strategic Planning, Price Planning, PM Planning
• Project Management
• Oil & Gas Industry

TECHNICAL SKILLS:

Skills: BW BI HANA 7.4, EPM reports, Input templates, Script Logic, Fox Formulas, Hana Development, Aggregation levels, Planning functions, Planning levels, Data Modelling, Consolidation groups, Universal Journal, Parallel Currencies, Hana Views creation, Composite Providers, Rate Info providers, Use of ACDOCA & ACDOCC tables for RTC consolidation.

PROFESSIONAL EXPERIENCE:

Confidential

EPM Solution Architect and Trusted Advisor

Responsibilities:

• Led global forecast and consolidation project implementation in BPC.
• Rolled out 30 business segments from excel into BPC for profitability planning.
• Rolled out consolidation process for segment reporting. Led requirement sessions/Workshops and design sessions
• Multiple Currency Conversion Solution
• Designed and Configured BPC Reports, Input Forms, Data modeling, Master Data Set up and Automation, BPF’s, script logic,data manager.
• Acted as a liasion between business process Owners and IT monthly forecast closing process
• Migrated BPC Classic to HANA database. Updated all the functionality to run on HANA
• Designed Managment Consolidation solution in BPC
• Consolidated 20 Businesses and 5 Segment for Segment reporting for Cash Flow, Income Statement and Balance Sheet Reporting.
• Business Rules Configuration, Allocation, Currency Translation, Eliminations, Journal Posting,
• Designed and Developed Management Reporting solution in BPC and BW for corporate Finance ReportingTeam.

Confidential

EPM Consultant

Responsibilities:

• Assessment of existing planning and consolidation in BPC
• Presented a demo and features of Embedded BPC
• EPM report developments for Finance Team

Confidential

EPM Solution Architect

Responsibilities:

• Responsible for overall delivery of OGE budgeting and forecasting solution in BPC 10.
• Conducted workshops,interviews,business requirement gathering sessions, gap analysis,BPC 10 system requirements, software installation guidance,system readiness check.
• Delivered business blueprint, functional and technical design document.
• Identified end to end process of budgeting, input templates,report roster for labor planning and Capex budgeting.
• Provided solutions to number of complex problems in the design related to WBS design.
• Designed and extracted project costs,cost center,HR payroll,CATS,activity rates, statistical key figures into BW and then to BPC.
• Developed EPM BPC reports and input forms for capex and HCM labor planning,rolling forecast etc.
• Configured and implemented HCM,capex models,dimensions,properties, script logic, lnput forms, reports, business process flows,Work Status.
• Developed data manager packages, transformation and conversion rules for master data and transaction data load automation.
• Written ABAP program to automate WBS master hierarchy based on the business logic.
• Written UJD ROUTINE,UJD CUSTOM BADI for calculation of HCM costs, moving of data from HCM to CAPEX,Settlement and asssessment cycle run.
• Extracted Settlement rules, assessment rules of CO module into BPC for use in cost settlement process.

Confidential, New York

Responsibilities:

• Conducted interviews, workshops with Corporate Division and delivered blueprint and functional design documents.
• Migrated consolidation solution from Legacy Consolidation.
• Identified the report,dashboards to be created in Xcelcius and WEBI for Financial Statement reports.
• Configured BPC business rules, Currency Converison, Ownership hierarchy, Carry Forward, Minority Interest Calculation, Eliminations, Journal Entries and others.
• Designed the BW solution with identifying the reports,start schema’s,extractors,Business content info cubes, data sources, DSO and loading plan for financial reporting.
• Developed EPM Reports for Financial statements and Validations of consolidation process.

Confidential, New York

BPC Solution Architect

Responsibilities:

• Conducted project assessment for Rush BPC initiative.
• Conducted kick off meeting and interviewed executive leadership to identify project objectives, business case, key deliverables and milestones.
• Evaluated and proposed a phased roll out for budgeting solution for business units, consolidated financial reporting and dashboarding for corporate office.
• Delivered project charter document with project plan, scope, key milestones, future design, number of reports, input schedules, assumptions, constraints,high level risks, cost, resource, roles and responsibilities.
• Proposed time, cost and resource requirements to complete project with a detail bottom up estimation.

Confidential

Embedded BPC/IP Implementation Lead

Responsibilities:

• Managed end to end implementation of budgeting system in SAP BPC and BW Reporting for downstream refinery plant maintenance.
• Conducted multiple workshops for 12 downstream refinery plant managers to determine project objectives & requirements.
• Managed the project plan,budget, resources and delivery of complex solution and coordindated between business units, support organizations and delivered key presentations to executives.
• Developed functional and technical specifications for 40 reports and input schedules.
• Designed and provided guidance to BW/BO blueprint and build with detail process flow of infocube,dso,extractors data loading and process chains strategies.
• Created ABAP routines using classes and methods, BADI’s, Fox Formulas for various data streams like planning costs,simulation costs and order header extractors,validations,business calculations in budgeting and inflation calculations.
• Managed the implementation of financial planning and forecasting solution in SAP BPC for different business areas and corporate headquarters at global crossing.
• Created and Managed schedule, scope and cost plans for build, test & cutover phases.
• Designed and configured data model, application sets, applications, input templates for balance sheet planning, P&L, cash flow planning,capital planning, revenue planning, operating expense planning.
• Implemented business process flows,work status and locking versions within BPC.
• Developed muti hierarchy dimensions for cost centers, internal orders and wbs, extracted master data into BPC dimension member.
• Used advanced script logic for fx currency conversions and dimension logic for net income and other cashflow line item calculations.
• Troubleshooted and recommended several solutions to BPC 7.0 software issues.

Confidential

BPC Consolidation Lead

Responsibilities:

• Designed BPC application to automate consolidation of subsidiaries for monthly, quarterly and yearly close.
• Configured Inter unit eliminations, account transformation, carry forward rules,validations based on the business and GAAP rules.
• Automated data loading of entities/foreign subs from legacy systems.
• Developed inter unit eliminations of account receivables/payables, revenues/expenses for both managment and legal consolidations.
• Developed methods to calculate retained earnings,carry forward,goodwill, cash flow calculations, for operating, investing and financial activities.
• Produced and published financial reports of BS,P&L and CF in BPC.
• Configured ownership rules and used purchase,equity methods to calculate minority interests.
• Developed custom menus on input schedules and reports using vb macros based on the business needs.
• Extensively used EVDRE,EVPRO,EVTIM,custom menus to develop input schedules and various complex reports.
• Build and Deployed new planning system for entire corporation.
• Integrated Revenue,Opex,Capex and HR planning solution with Income Statement Planning.
• Build and Deployed BW system to support planning and reporting.
• Coordinated across functional teams for key dependencies.
• Implemented complex allocation functionality and plan assessment cycles in FI - CO.
• Developed multiple reports in BW front end tool.

Confidential

BW Solution Lead

Responsibilities:

• Built and Deployed new planning system for global.
• Integrated Profitability,Opex,and HR planning solution.
• Built and configured Consolidation tool in BCS.
• Build and Deployed BW system to support planning and reporting.
• Implemented COPA and multi level budgeting across product hierarchy and geography.
• Developed multiple reports in BW front end tool.