SUMMARY:

• SAP BPC consultant with hands - on experience on BPC through multiple implementations and FOUR full project life cycle experiences. I have worked for original company Outlooksoft and SAP in the past.
• Subject Matter Expert in Planning, Budgeting and Forecasting
• Subject Matter Expert in Financial Consolidation
• Subject Matter Expert in Application Optimization
• Subject Matter Expert in Report Writing
• Subject Matter Expert in Business Process Flows
• Subject Matter Expert in Logic(Script Logic, SQL Logic, MDX Logic)

TECHNICAL SKILLS:

APPLICATIONS/LANGUAGES: SAP Business Objects EPM BPC 4.2 (MS) / 5.1(MS) / 7.0 (MS) / 7.5 (MS/NW) / 10.0 (MS/NW), Outlooksoft 3.5/4.0/4.2 / 5.0 , OLTP - Business Warehouse 7.0/7.3, SSAS / 2008 R2, Reporting Services / 2008 R2, Other - Configuring BPC security in BW & MS SQL

OPERATING SYSTEMS: Client - MS-DOS, Windows 98 / 98 / XP / Win 7 (32bit, 64bit), Server - Windows Server Enterprise Ed. R2(32bit, 64bit)

RDBMS: ODS, MS Access, SQL Server / 2008 R2

PROFESSIONAL EXPERIENCE:

Confidential

BPC Manager

Responsibilities:

• Work with PMO to set up the security support mechanism for the onboarding, offboarding etc.
• Using creative approach to diagnose and resolve problems while working with on shore and offshore teams.
• Assign clear goals and foster ownership
• Assisting in the workshops from business and technical perspective to explain existing reporting architecture.
• Working as a reporting manager to facilitate the reports gathering and UAT for the financial reports.
• Primarily working with business process owners to help them translate their processes in to business requirements.
• Working with onshore and offshore teams.
• Responsible for career goals and budgeting for my team.
• Responsible to maintain existing reports and work through the cycle from development, UAT to promotion of reports to production.
• Work with business to build test case scenarios based on process and work with developers to validate the scalability performance of reports/templates.
• Lead BPC related troubleshooting from both functional and technical aspect.
• Work closely with BPO(Business Process Owners), Super users and developers.
• Lead the BPC enhancements and projects related to financial systems.
• Working with the development team on escalated issues.
• Working as a liaison between Business, Project team and vendors.
• Building project plans for reporting related modules(new, enhancements).
• Identifying the reports enhancements and automation for templates.

Confidential

Senior Techno/ Functional Lead

Responsibilities:

• Leading the sessions to drive the requirements gathering with FP & A team.
• Review the functional requirements document for requirements gathering.
• Owner to building and getting design document approved.
• Scope the numbers of sessions required for blueprint.
• Assign and review tasks for each week with in BPC and client teams.
• Working with all the line of business to build a planning POC.
• Building excel based models to help understand the client the future state of planning.
• Using the functional document and requirements gathering sessions to build Design doc.
• Working with different heads of LOB’s to get approval on Design Doc.
• Leading the data mapping exercise between different source systems and BPC staging area.
• Working on building different prototypes for understanding of Design Doc.
• Building system landscape diagrams to define future state of the BW/ BPC.
• Build and presented the phase II development for BPC and timelines for other BPC models.
• Delegating work assignments to 2 other BPC resources and managing them.
• Working with clients IT department to come up with BPC roll out strategy.
• Responsible for building and presenting Demo for BPC.

Confidential

Senior Techno/ Functional Lead

Responsibilities:

• Reporting manager
• Built assessment gathering document for migration to highlight the objects that needs attention
• Migrated Input Schedules(44), Reports(123) and SSIS packages(7) and upgrade Script Logic(16) for enhancements for 4 different models
• Worked with Global Finance (FPA team) and HR users to identify the add-on functionalities required for successful migration and upgrade
• Increased performance and saved time for currency translation by moving away from complex script logic to Business Rules
• Expedite the month end process by moving from two rate application to use only one Rate Application
• Increase the proficiency to find underlying data for FPA team’s/ Regional Managers analysis and troubleshooting by enhancing the Drill Through Functionality
• Built add on Functionality, Dynamic Drill Through to query BPC Journal Tables from any BPC report/ input schedule
• Increase the transparency by giving the FPA team and regional managers a view of underlying data that was loaded from ODS to BPC, by customizing Drill Through to pull data from any BPC report and Input Schedule
• Built add on functionality, Dynamic Drill Through to BPC Transaction tables in ODS DB from any report/ input schedule
• Worked with the consultants to create/ modify BPC processes to satisfy business reporting requirements to further cleanse and provide deep understanding for analysis
• Create a One click process for BPC power users to run Default Script Logic on the current month. The BPC process is dynamic to switch to new month, once the current month changes to another
• Wrote BPC report writing document for Finance and HR users
• Hosted BPC report writing best practice sessions for Finance and HR super users
• Build migration plan to migrate to EPM 10.0
• Worked with global FPA team and different line of business to blueprint the new requirements that will be applied to EPM 10.0 implementation
• Build Project plan for migration of existing Application/model and new Applications to be built from scratch
• Lead the project to work with Citrix(Consultants) and infrastructure(Global IT) team to implement BPC on Citrix
• Worked with Citrix Consultant for Scoping and detail design for implementing BPC via Citrix
• Worked on video demo’s for Accessing Citrix via Company machine, Mobile Device and smart phone with touch screen capabilities
• Lead the LMS vendor to implement the Citrix and BPC 7.0 vs. 7.5 delta using Camtasia, Studio 8, SnagIT 11 published SCORM Packages
• Strategize and executed the project plan to work with IT globally in order to migrate users from local client to Citrix Client for accessing BPC
• Wrote BPC troubleshooting guide and other related white paper documents for BPC Admin and local IT
• Worked with Citrix consultants to document the core issues with global roll out and their resolutions
• Worked on building 3BPC environments from scratch for DEV,QA & Production

Confidential

Senior BPC Solution Architect EPM 10 NW

Responsibilities:

• Worked with FP&A professionals to convert yearly planning to monthly planning
• Devised scenarios and versions for What-IF analysis
• Blueprint
• Revenue Planning
• Operational Headcount Planning (Transfer to Capital)
• Capital Projects Planning
• OPEX Planning (with Indirects to Capital)
• Financial Statements
• Solution Architecture
• Development
• Models
• InfoObjects
• Reporting(Input Schedule/ Reports)
• Script logic
• BPC Load Package
• Currency translation
• Business Process Flows (BPF)
• Testing
• Functional Scenario, reporting, business processes
• Documentation

Confidential

Senior BPC Solution Architect EPM 10 NW

Responsibilities:

• Joined as an architect/ developer to facilitate the stabilization and enhancement of current BPC 10.0 NW instance
• Worked with Management to fine-tune the requirements for the RDS
• Assisted teammates with BPC troubleshooting, serving as their escalation point for all the BPC issues
• Worked with SAP HR team to understand and effectively translate the reporting requirements in to technical documents
• Built / modified existing Reports, Input Schedules, DM Packages, Script Logic and Business Rules for performance optimization and fulfilling business requirements
• Hosted / attended sessions with the core functional team to help bridge the gap between technical and business requirements
• Wrote instructions / documents to explain and standardize the processes for loading monthly, quarterly and year-end processes, such as loading monthly rates, validation reports and changing variables
• Assisted the BW Team in clarifying the BPC requirements, with respect to Account-based data
• Responsible for System, Performance and Application review and made recommendations on SAP's best practice
• Monitored all the activities of day-to-day operations to improve and take advantage of new options
• Built UAT, test scripts, stress testing and regression testing

Confidential

Financial Application MANAGER (BPC) BPC 7.0,7.5

Responsibilities:

• Responsible for assign for managing the Support team and consultants
• Responsible for managing support team career goals and pool management
• Experience with business drivers and software delivery
• Worked efficiently with remote teams
• Well versed in managing BPC projects
• Lead the stabilization of existing environment and migrated from 5.0 to 7.5
• Helped minimized the unexpected downtime for different line of businesses
• Prepared the project plan with documents and requirements for migration
• Worked with consultants to build new environment for 7.5
• Worked with vendor to build and modified SSIS packages
• Wrote white paper documents for BPC Admins for future
• Performed troubleshooting, worked with other BPC Admins for knowledge transfer
• Performed system / performance / application review and made recommendations on SAP best practice
• Monitored all the activities of day-to-day operations to improve and take advantage of new options
• Rewrote reports and input schedules to support nested time dimension.(calendar year, fiscal year)
• Built new environment for 7.5
• Built UAT, test scripts, stress testing and regression testing

Confidential

Lead Consultant, BPC MS & NW(Trained/ Escalation for 35 engineers)

Responsibilities:

• Senior Team Lead responsible for the support of SAP / BPC OutlookSoft for 700+ NA customers
• Fulfilled all the responsibilities of a Functional Consultant and most of a Technical Consultant
• Provided SAP BPC developmental support, and provided solutions to problems for SAP BPC / OutlookSoft - CPM 4.2-7.0
• Hosting sessions, mentored and trained reps
• Wrote best practice documents and updated the knowledge base, working with escalated customer incidents / messages
• Served as liaison with developers to find solutions
• Tested the components of EPM-BPC, bringing customer cubes in house for detailed analysis
• Hosted remote sessions with customer on a daily basis to understand and solve incidents / messages
• Responsible for all aspects of customer support including escalation and customer management, defect tracking and prioritization, and bridging the gap between development and the customer
• Assigned tasks to the team
• Troubleshot all aspects of the product from Report, Input Schedules, Logic, Security, Data Packages, BPF( Business Process Flow), applications and dimensions to Finance & Accounting related issues
• Worked closely with both business and technical users to provide the best solution for their problems. Made recommendations on improvements to the design, development, testing and implementation of Reports, Input Schedules, Logic, Security, Data Packages, applications, dimensions and other components
• Worked on multiple implementations through the full project life cycle
• Customized the Reports, Input Schedules and Logic to meet the specific needs of the client, using supported functions with BPC
• Assisted the customer through the migration process, migrating cubes from 4.2 to 5.1 and 7.0, 7.5 or 5.1 to 7.0 or 7.5
• Made recommendations about complex reporting requirements and BPC and BI interface applications, to ensure the design of end-to-end reporting solutions for optimal performance
• Assisted customers with the application, reports, input schedules, DTSX packages and other components, ensuring the design included the enhancements added to the newer releases - especially for customers who were migrating from 4.2 to 5.1 or 7.0
• Always kept up to date with the new releases of BPC to take advantage of new or revised enhancements and features
• Worked closely with documentation on a regular basis, writing and reviewing best practice, User Guide and other White Paper documents