PROFESSIONAL SUMMARY:

• Over 9 years ofBW/BI/BOBJ/BPC 7x and BPC10.0/BPC10.1experience which includes five years of planning environment likeBPC/BOBJ planning using MS outlook soft and SEM - BPS/Integrated planning tools. Knowledge in HANA1.0 and in ABAP/4, BADI/BAPI/Fox and BPC Script logic functionalities. Extensively involved in BPS/IP/BPC/BOBJ along with char value combinations and Excellus
• Current project is onEPM10to implement and provide solutions on planning, consolidation, budgeting (public budgeting formulation) and forecasting. Solutions provided to end client using Various BPC Applications on customer/Sales data, profit & Loss, Balance sheet, Capex/Treasury planning, SAP Business Objects Profitability and Cost Management (PCM) environments
• Experience in SAP BI7.3Data modeling, designing, development, upgrade, production support and QA along with various(ETL) extraction mechanisms withinmy SAP CRM,SCM(APO DP & SNP),SAP R/3 OLTP, ISU, Non - SAPsystems, Data load processes and performance management tools
• Currently working asSr. Consultant to implement and provide solutions on BPC Consolidation, planning, budgeting with public budgeting formulation and forecasting. BPC Applications for the current project using source data from ECC6.0CO-PA, Profit Center, cost Center, SAP Business Objects Profitability and Cost Management (PCM) environments using material/customer data sources, and implemented Balance sheet/Profit & Loss, Capex/Cash Flow and Man Power Head Count planning
• Extensively worked in BI Security along with BPC work status area during implementations to deal global security functionalities like create users, user roles, assign roles to users based on regions and provide access accordingly based on user profile(PFCG & SU01). Security issues resolved based on the traces from SU53
• Added BPC users to domain, Task profiles, and member access profiles to make user as active member and validity periods set. Performed BPC admin tasks during design & Implementation phase
• Has knowledge in implementing HANA1.0 to improve existing planning, forecasting, budgeting and pricing performance by replacing BWA & Oracle DB
• ImplementedCRM-R/3, ECC-BI7.X, BW-SEM BOBJ/BPS/BCS/IP,APO, PP,MM, SD, CRM, FI/CO & HRmodules with multi country roll out
• Experience inBI7.3/BWwith integration, development, upgrade and production support with modules likeFI/CO, PP,QM, MM, SD & CRM-R/3-BI7.3/BW-SEM BPS/BCS,APOmodules with global projects & organizations
• Business Area -my SAP CRM 4.0, SAP R/3, ECC 5.0/6.0 SEM-BPS,BI7.0 IP(Integrated Planning), Enterprise Portal 6.0, S & D, MM, FI-CO, CO-PA and involved in performancemanagement software to manage the most critical financial and operational planning, budgeting, reporting, and analytic requirements
• Hands on experience on configure/customize BOBJ with Excelcius/BI upgrade/migrations, BI transformations, extractions, data store objects (DSO), data transfer process (DTP), performance optimization/tuning on data loads. Handled work plans to implement large multi continent roll outs having regions USA, EMEA, ASIA
• Expert in enhancing & extracting the data sources onFI-GL, FI-ARandFI-AP, extensively worked on pulling the data fromprofit & cost center accountingand strong inCO-PA with Profitability and SAP Business Objects Profitability and Cost Management (PCM)via creating operating concern.
• Expert in designing sound data model in developing Business Objects integration(BO), info cubes, multi cubes( based on the reporting requirements), and DSO With different delta approaches
• Worked on data Extractions with delta to load the data from flat file, application & cross application specific extractors using views & table.
• Experience in optimizing the data load performance/tuning using SAP best practice methods via RSRV checks, optimizing Data base issues via traces, refreshing the cubes on regular intervals, deleting unused cubes/DSO/multi providers, transformations etc.
• Actively involved in define, execute and evaluateregression & integrationtests onBI7.0/BWandR/3using integratedCATfor the reporting, planning &OLAP technology application areas.
• Actively involved in user acceptance testing(UAT), SIT and stress test VTOfor performance optimizations
• Strong consulting experience in corporate implementation experience in the SAP space, with depth experience implementing and configuringSAP BI7.x/BW & SEM-BPS
• Proven knowledge in defining systems strategy, developing systems requirements, and implementing practical business solutions under multiple deadlines
• Responsible for developing, maintaining, and growing client relationships, leading consultant and client project teams from project planning through execution
• Expert to implement & follow business rules governing the supplied data and its implications to consolidate the data with other businesses when create engineered solutions to suit business requirements
• Worked on complex Process & event chains and set up done to trigger jobs using UC4 & Control-M.
• Worked on info presentation layer like Bex-Analyzer, Bex-Browser, and Creation of workbooks
• Hands on experience onSAP BI7.x/BWobjects like: info-presentation tools, Design & Analysis of Bex, Cube Maintenance, extraction & loading of data using different types of extractors, monitoring of data usingUC4, Control-Mand data Administration (i.e. types of extractors, Char/KF Info Objects, Data sources/ Info Sources, update rules, transfer rules, Info Cubes, Info Packages, process chains, queries, RKF, CKF, structures, etc,)

TECHNICAL SKILLS:

ERP: SAP R/3 Version ECC 5.0/6.0 4.7E,4.6C/4.0B, SAPGUI 7.X Data dictionary, Reports, Scripts, BDC, RFC, BAPI, ALE and IDOCs

SAP-BI/BPC: SAP BI(7.3)/BPC10.1/10 /7.5 versions, HANA1.0, IP, Info cubes, Enterprise,Portal, multi providers, ODS, Info objects, Info sources, Data Extraction, Transformation and Loading,Pocess Chains, CRM, APO,HR, PP & MM, SD, CO-PA, LO-Cockpit, Queries, Workbooks, Bex-Analyzer, Bex-Browser, Web reporting

Packages: Microsoft office suites like MS-word, MS-Excel, MS-Outlook

Languages: C, C++, Java, BSP and SQL

Operating Systems: Unix, Windows NT, Windows 95/98, 2000

EXPERIENCE SUMMERY:

Sr. Consultant -SAP BI/BPC

Confidential

Responsibilities:

• Prepared design document forBPC V10to implemented provide solutions on BPC Consolidation, planning, budgeting with public budgeting formulation, forecastingusing of SCJ sales/customer data from its global operations, FP & A, PNL, Balance sheet, cash Flow Functional Budget, discount & Promotions based considering Intercompany Non-Competitive & Resale Minus Transactions, trading partner, budget, Monthly forecasting(SOP), Roll-Forward Logic, domestic and export net/cost of sales & distribution expenses
• Project scope was to change SAP BPS planning applications to SAP BPC V10 environment based on the client business for CCR, FP & A, Budget planning, SOP and Treasury subject areas
• BPC Consolidations done via reporting requirements like entity information, translate data to reporting currency using calculations, control settings, journal entries and validation, reconcile/eliminate intercompany matching
• Has strong back ground in SEM BPS on planning, Budget, consolidation and forecasting using CO-PA, Profit Center, cost Center, material/customer planning, Balance sheet planning, PNL, FP & A, Capex/Cash Flow(Treasury) and Man Power Head Count planning
• Prior experience in implementing SAP BPS Web Applications for Short Term Estimate, Long Term Plan, Customer/Site Level Business Plan, Petro Pass CCR Account Level Plan, Scorecarding, and RF Overhead Expenses (convert existing BPS tool); Integrate New BPS Applications with Supply Planning Tool based on APO DP
• Data model includes oneEnvironmentwith multiple Applications based on continent/ regions (24 countries) Most data on company acquisition in actuals from different source systems.
• Implemented Data reconciliation and validation of data load and refresh of data loads during close periods
• Created planning dimensions on Account, company, Scenario, Time, Currency, Cost Center, Data Source, Product, Customer, R account, R entity, R Currency and developed dimensional members & properties
• In BI defined reconciliation process, rollup via Hierarchies on customer/product/sales, customized BI data model for BPC Actuals. Data loads done by defining process chains and included BI processes like info providers, packages, data sources to extract data from ECC6.0 and other source systems
• Extensively worked in BI Security area during implementations to deal global security functionalities like create users, user roles, assign roles to users based on regions and provide access accordingly based on user profile(PFCG & SU01). Security issues resolved based on the traces from SU53
• Added BPC users to domain, Task profiles, and member access profiles to make user as active member and validity periods set. Performed BPC admin tasks during design & Implementation phase
• Data loads stream lined using process chain to extract data from source systems to SAP BI cubes/ODS, to consolidate, eliminations, Final data will be loaded into BPC cube with the help of Data Manager package
• Developed Input schedules on Gross Profit, cost of sales, rates, sales discounts, CCR/Memo Accounts, Advertising & Promotions, PNL, Balance sheet and sales forecast. Tested the Input Schedules by Input the values and noted the times how much time on EvDRE, execution/time to send and time to expand etc
• Designed and developed excel reports using EvDRE tool set capabilities and reporting templates.
• Reports developed for Rate Input/Lump Sum Amounts. Ran the packages for the Input schedules by selecting Input selections for the required input schedules by region/company code/product/customer
• Data loaded to BPC info provider, validations done, unit tested and transported to Quality then to production
• Integration testing, unit testing done and Volume/Stress test to optimize performance using HP Quality Center tools like HP Load Runner, BPC Tool Kit, VuGen, Fiddler and Load Generator/Controller scenarios. Load Generators are remote Load generator kept at multi continent Locations like Europe, Asia, and Canada.
• Developed Load Runner scripts when Input schedule/Reports executions and modified the Load runner scripts with user credentials, BPC control panel setting and BPC server details as parameters. Back end CPU, DB, SQL traces done by respective teams to finalize the volume test results. Response time observed about 90 seconds to execute and send data from Input schedule to back end DB using BPC dynamic selections
• End user Training, Technical documentation and Post implementation support completed
• Currently gathered requirements and preparing Functional/Technical specification documents for the second phase of implementation on SAP Business Objects Profitability and Cost Management (PCM),Revenue/CAPEX planning

System Landscape: ECC 6.0, BI 7.3 and BPC10

Sr. Consultant-SAP BI/BPC Apr'11-Oct'11

Confidential, NJ

Responsibilities:

• Requirements gatheredwith specification document to implement sales (trade promotions)Profit & Loss planning using client Market, distribution and Operator business. Designed data model for BPC considering FPM,Business objects planning and BPC consolidation
• Data model designed considering the client business future cast sales volume, sales trade promotions(TPM), coupons and other discounts based on, marketing, selling and supplementary data allocation to brand model in BPC. Captured Profitability and cost components using profit center, cost center, CO-PA tools and SAP Business Objects Profitability and Cost Management (PCM) by linking BOBJ to PCM and LSDAL explorer and RFC connections
• Sales cost linked to profit cost source data derived from R/3 customer, material, Profit center, cost center and CO-PA using business rules
• BPC Consolidation and reporting includes gather all Entity information, translate data to reporting currency using calculations, applied business rules, journal entries and validation, reconcile/eliminate intercompany matching
• Created planning dimensions for category, customer, Data source, Entity, Account, Reporting Currency and Time Loaded data using BPC mapping rules and verified data
• Created properties for Currency translation/verifying exchange rates, intercompany eliminations, reclassification and restatement
• In BI defined reconciliation process, rollup customer to planning customers, customized BI data model for BPC Actual and defined process chains to include BI process for developed info providers PCA & CO-PA extraction to pull the data from ECC6.0
• Extensively worked in BI Security area during implementations to deal global security functionalities like create users, user roles, assign roles to users based on regions and provide access accordingly based on user profile(PFCG & SU01). Security issues resolved based on the traces from SU53
• Added BPC users to domain, Task profiles, and member access profiles to make user as active member and validity periods set. Performed BPC admin tasks during design & Implementation phase
• In BI designed master data for planning customers via hierarchy and created variant to pull data from BI to BPC
• Via fox coding and developed function module to roll up the customer to top nodes
• In BI developed required Transactional data info providers (DSO, cubes) for BPC to pull the data from ECC6.0
• In BPC created Application Setusing BPC predefined ApShell and created Application
• In BPC created data manager package with the help of Application set,ApShellvia drivers, dimension library, source cube and source structures from SAP delivered applications (planning account, Entity, planning activity, category, data source, reporting currency and time
• In BPC Utilized planning applications, planning types and application functionalities for consolidations(rate type etc..) using BPC business rules like modifying specific dimension members, and using script logic, maintaining members and properties
• Assigned planning applications to dimensions and optimized applications as needed and Extensively used input schedules, Applications validations and Solves for calculations
• Data loaded to BPC info provider, validations done, unit tested and transported to Quality then to production
• Generated BPC reports on costs. Goods sold, customer summery via Level 1, Level2 etc.. With the help of planning reporting input schedules(via EvDRE workbook options using BPC functions like EvGET and EvSND), report templates, report variances, trend reporting, conditional formatting. Extensively used expansions, drill downs, filtering, work book options and indentations of reports
• Implemented security on Application administration via profiles and work status feature in BPC

System Landscape: ECC 6.0, BI 7.3 and BPC 10

Consultant

Confidential

Responsibilities:

• Responsible to Design, development of FPM project using BPC standard functionalities for the Confidential apparel business which uses SAP BI7xBPC MS Versiontechnology for the data from different departments
• Business scenario of this client is GTM/TPM(go to market using trade promotions via trade campaign, marketing elements and market segments data sourced from CRM sales and some data from sales & distribution of ECC
• Integrate the data with integration for planning by integrating with other SAP modules like R/3-BI7.0/BPC, APO, PP,MM, SD, FI/CO Cost center/profit center and CO-PA with multi currency rate application environment
• BPC Consolidation and reporting includes gather all Entity information, translate data to reporting currency using calculations, applied business rules, journal entries and validation, reconcile/eliminate intercompany matching
• Upgrade, migrate the relevant BI transformations, extractions, data store objects, data transfer process, performance optimization, tuning on data loads. Extensively used BADI/IDOC and fox functionalities
• Enhance and extract the data sources on FI-GL/FI-AR/ FI-AP, pull the data from profit & cost center accounting
• Responsible in designing sound data model using Business Objects integration, info cubes, multi cubes based on the BPC reporting requirements and data store objects with different delta approaches
• Involved in data Extractions with delta to load the data from flat file, application & cross application specific extractors using views & table.
• Optimized the data load performance tuning using SAP BPC-Excel (modules include budgeting, forecasting, statutory consolidation, EvDRE reporting ) and other best practice methods via optimizing Data base issues via traces, refreshing the cubes on regular intervals, deleting unused cubes, DSO, multi providers, transformations
• Responsible to design & develop complex Process & event chains with set up trigger daily/weekly/monthly jobs to load data to BPC info providers at global level and to run applications like rate/currency exchanges

System Landscape: BI 7.1 and BPCMS Version

Confidential, NJ

Consultant

Responsibilities:

• Requirements gathered to develop BI reports using dump of legacy sample report from Johnson's business process.
• Subject areas involved in Johnson business process are Finance, procurement, inventory and planning manufacturing.
• Reports disposition done and finalized the BI reports to be developed by subject areas.
• Given recommendations to get few reports directly from ECC 6.0 and rest to be developed in BI using SAP Business content data sources/SAP tables
• Enhanced the business content data sources to get all the fields based on BI report requirements using RSA5 & RSA6 transaction codes
• Extracted to data to BI via transformations and loaded data into data targets
• Developed the reports using business objects integration (BO) and validated the data.
• Given authorizations to uses based on their roles & regions.
• End support is in progress

System Landscape: ECC 6.0, BI 7.0 PP, MM, FI

Confidential, Orlando, FL

Consultant - BI

Responsibilities:

• Maintain the BI data loads, monitoring alerts and analyze/fixing the load failures with in SLA time project was to production support on-going issues, analyze the business processes in-order to offer suitable solutions to the problems
• Grab the production support failure tasks from Rev-track (3rd party tool) and assign the tasks to self & to the team, resolve the support issues with in the SLA time frames. Attend the change control meetings if have some major changes needed with the prior approvals.
• Coordinate and pass on the required issue information to the respective team to fix the issues
• Involved in during production issues like configuration of various Account Groups as per customer classification, partner functions, Maintaining Partner Determination Procedures in various objects such as Customer Masters, Sales Document Header & Item, delivery, billing docs, sales documents, billing, shipping, credit management, consignments, pricing, third party Order processing, Delivery and Billing, Pricing Procedure, Condition Type, Access Sequence and Condition tables
• Data load monitoring from the chains related to master data, stock & flows, sales invoices, operations & logistics, SRM, Financial management & controlling, Inventory audit and exchange management.
• Involved in design and development of new process chains as per the need from client
• Involved in enhancements via Remedy tool and enhanced structures moved to BWP using Rev-Track tool.
• Involved in design and development of small and medium projects with the client environment

System Landscape: SAP R/3(ECC 5.0), BI7.0, MM, FI, SD and CRM