SUMMARY:

• I am a Confidential Certified Applications Consultant since 2006 (EPM 10.0, BPC 7.5, 7.0, 5.1, 4.5, 4.0 and BW 7.3 & 7.5).
• Have worked for Outlooksoft(Original BPC Developer) and SAP until 2010.
• Have established, trained and managed teams locally and globally.
• As a full - service technology SAP BPC & SQL/ BW Solutions Professional, I am currently an SAP BPC & SQL/ BW Solution Architect.
• Have over 12 years of management and consulting experience, the past 8 years of which have been focused on SAP Business Planning & Consolidation.
• Have vast experience of development, configuration, business analysis, blue printing, writing functional and technical specifications, testing, training, and post go-live support.
• An SAP consultant with hands-on experience on BPC through multiple implementations and FOUR full project life cycle experiences.
• Prior to my role as solution architect I have been engaged in different roles developer, report writer, data integration and migrating clients from BPC legacy based version to 7.0, 7.5 & EPM 10.0.
• Data modeling of Operational Data Store and Info cube structures
• Assisted in Developing back-end design, construction and unit testing of the Info Cubes, Multi Cubes, and Info Packages and back-end components (e.g. ODS, Transactional Info Sources/Data sources, Master Data, Info Objects) as specified by end user requirements for reporting solutions
• Analyze, design, develop, implement, and support SAP BPC Netweaver Edition and Business Warehouse/Intelligence Operational and Reporting solutions for multiple business units using SAP BPC and SAP BW/BI database designs, data modeling, relational databases, OLAP, SQL and visual development environments.
• Responsible for immediate SAP production issues

TECHNICAL SKILLS:

APPLICATIONS: SAP Business Objects EPM BPC 4.2 (MS) / 5.1(MS) / 7.0 (MS/NW) / 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 2000 / 2005 / 2008 R2, Reporting Services 2000 / 2005/ 2008 R2Other - Configuring BPC security in BW & MS SQL.

OPERATINGClient: MS-DOS, Windows 98 / 98 / XP / Win 7 (32bit, 64bit)

SYSTEMS: Server - Windows Server Enterprise Ed.2000 / 2008 R2(32bit, 64bit)

RDBMS: ODS, MS Access, SQL Server 2000 / 2005 / 2008 R2.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Techno/ Functional Lead

Responsibilities:

• Joined as a part of the core SAP project team for the duration of the SAP ERP deployment, teaming with internal and external resources to formulate the overall technical operation and deployment of SAP. Worked with Corporate Systems management to identify resource needs.
• Provided core SAP expertise for the development and maintenance of systems to support including:
• SQL Administration
• Customized SQL Programming and Code Development
• System Landscape and Infrastructure Design
• System Upgrade and Maintenance support
• BPC administration
• Worked with Corporate Systems peers and business counterparts to determine requirements for Global system deployment and related business system support
• Design, implement, test and support all SAP systems required to realize the end-to-end SAP solution required to meet the business needs.
• Create and maintain production standard operation procedures (SOPs). Define the Work-Break down structure in a yet to be defined SAP infrastructure.
• Provide technical leadership in resolution SAP related issues focusing on root cause analysis and implement corrective action plans
• Overseeing SAP development initiatives and team members(Supporting Offshore teams as well)
• Producing gap analysis to identify alternate solutions specific to SAP development and providing technical recommendations.
• Built assessment gathering document for migration to highlight the objects that needs attention.
• Migrated/ modified Input Schedules, Reports and BPC packages and upgrade Script Logic to upgrade 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.
• Worked with higher management and C level exec’s to tweak the HR module in BPC.
• Modified existing script logic and create new to improve existing HR compensation process also support new KPI’s.
• Worked with the consultants to create/ modify BPC processes to satisfy business reporting requirements 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 build from scratch.
• Lead the project to work with Citrix(Consultants) and infrastructure(Global IT) team to implement BPC on Citrix globally.
• Worked with Citrix Consultant for Scoping and detail design for implementing BPC via Citrix.
• Worked on video training demo’s for Accessing Citrix via Company machine, Mobile Device and smart phone with touch screen capabilities.
• Lead the training LMS vendor to implement the Citrix and BPC training 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 training 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 three BPC environments from scratch for DEV,QA & Production.

Confidential

Senior BPC Lead

Responsibilities:

• Linkage with the Planning and overall BPC 10 Finance business team
• Execution of monthly reporting and system maintenance activities
• Execution of monthly reporting and system operations
• Execution of internal controls that are required for financial reporting
• Supported SMEs and power users in the different geographies
• Work within IT and other Controller’s Group teams where required to resolve issues
• Worked with the business users to define the new reporting structure.
• Explained to key holders the benefits of moving forward with EPM10.0.
• Architected the data load for EPM 10.0 implementation using the new report structure.
• Worked with different teams FPA, IT, Database, Application support to outline the project plan to migrate client from BPC 7.0 to 10.0 on this aggressive schedule.
• Made changes to the BPC architecture to compensate the new reporting structure.
• Defined formats for the new reports and templates.
• Trained BPC Admins and Super Users on the new reporting and processes with EPM 10.0.
• Lead and developed the data integration from MS Dynamics, TM1 into BPC cubes(ETL process).
• Retrieved data from the in-house inventory system into BPC cubes for ETL process.
• Wrote the script for business users to validate BPC reports with the new ETL process.
• Loaded and validated the data and provided documentation on how to update it in the future.
• In order to avoid unexpected down time I created a BPC Admin Guide for weekly maintenance.
• Defined the guidelines on how to roll out the new implementation to the client machines locally and globally.
• For Business users created a basic troubleshooting guide to assist them with EPM 10 reporting issues.
• Worked with the client's IT Team to assist in their training; also defined the work process for each team member.
• Lead the installation and building BPC environments Dev and Prod.
• Performed application optimization and performance maintenance on the servers.
• Validate the installation of the BPC server using SAP guidelines.

Confidential

Senior BPC Architect

Responsibilities:

• Worked with FP&A professionals to convert yearly planning to monthly planning.
• Act as project manager for initiatives of variable scale managing internal and external team resources.
• Worked with a diverse and integrated team consisting of application developers, technical business users and business analysts
• Work with business owners to define and analyze reporting and analytic requirement.
• Responsible for knowledge transfer and technical implementation of SAP BW and SAP BPC
• 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 Techno-Functional Lead

Responsibilities:

• Built and executed the project plan to migrate the client from BPC 7.0 to 7.5.
• Built new environments from scratch for Test, DEV, QA and Prod.
• Installed BPC and the required components.
• Migrated all the reports, input scheduled, logic and SSIS packages.
• Built and tweaked reports, input scheduled, logic and SSIS packages to work with latest OS, SQL and BPC.
• Tested the key reports with business to make sure there is not impact after migration.
• Performance tuning of BPC and related components.
• Updated SSIS packages with enhancements and their pointers.
• Updated the Script Logic with the new file structure.
• Developed additional reports and updated the security.
• Worked with the IT/ Infrastructure Team to create plans for this hardware / software upgrade.
• Developed a strong and robust backup strategy.
• Documentation.
• Used Xcelsius components for dashboarding.
• Built test scenarios and validation scenarios, along with UAT, for the go-live.

Confidential

BPC Architect

Responsibilities:

• Reporting to the SAP Practice Director, apply comprehensive knowledge of SAP Business Intelligence (BI) technologies to create SAP-based technology roadmap for analytical solutions.
• Act as project manager for initiatives of variable scale managing internal and external team resources.
• Work closely with internal business process owners and others to assess current capabilities and identify high-level business requirement to meet business owner needs.
• Work with business counterparts to understand their business needs and translate them into SAP BI solutions.
• Manage full implementation lifecycles of BI functionality including coordinating team responsible for building solutions, developing and supervising training processes, and providing technical guidance and expertise.
• 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

Sr. Financial System Analyst

Responsibilities:

• Joined as a technical consultant to facilitate the stabilization and enhancement of current BPC MS 7.0 instance and led the migration project to BPC NW 7.5.
• Prepared the documents and requirements for migration and analysis for management, to help them understand the key differences between the two environments.
• Enhanced the existing environment to help them close their month- end, quarter-end and year-end processes more efficiently and quickly.
• Closed the gap between management and the Financial Systems Team for better communication and to help them understand one another.
• Worked with management to find out the requirements for new environment.
• Assisted teammates with BPC troubleshooting by serving as their escalation point for all BPC issues.
• Built and modified existing reports, input schedules, SSIS packages, script logic, stored procedures for performance optimization and to fulfill the business requirements.
• Hosted / attended sessions with consulting companies to help them understand and explain business requirements for the new environment (BPC 7.5NW).
• 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.
• Shifted from hardcoded values in reports, input schedules and SSIS packages to more dynamic values.
• Provided ongoing knowledge transfer, with supporting documents and white papers.
• 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.
• Built UAT, test scripts, stress testing and regression testing.

Confidential

Financial Application Administrator

Responsibilities:

• Lead the stabilization of existing environment - 5.0.477 - 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 reference.
• 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

Technical Consultant

Responsibilities:

• Performed installation and implementation of SAP (BOBJ) -EPM-BPC.
• Fulfilled all the responsibilities of a Technical Consultant and most of Functional Consultant.
• Built SAP BPC support practice and managed a team of three people.
• Performed installations of SAP BPC 5.1 / 7.0 / 7.5.
• Performed multiple installations on a single server and standard multi-server environment.
• Performed multiple installations on both SQL 2005(32, 64Bit) & SQL 2008.
• Added to knowledgebase articles and also trained new hires on BPC.
• Worked with both Technical and Application consultants to help them solve all kind of BPC related problems on both technical and functional sides.
• Migrated customer from 4.2 to 5.1 and 5.1 to 7.0 and 7.5.
• Set up benchmarking and hosting environments for customers.
• Reviewed customer environment (technical review) and made recommendations.
• Worked with clients directly to solve their BPC related issues and for performance testing.
• Made pre-sales calls with business stake holders and the IT Dept. to help them understand how BPC can solve their problems efficiently.
• Held training sessions for different modules of BPC.
• Wrote BPC supporting documents, such as pre-install checklist and install checklist, to standardize the installation of BPC.
• Performed multiple implementations on every module of BPC.
• Workedwith internal IT group as a team member, to support IT infrastructure for managing, expanding and troubleshooting.

Confidential

Support & Lead Consultant

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