SUMMARY

• 16 years of experience in SAP and 4 years’ experience in implementing & supporting SAP BPC Netweaver as a Techno functional Consultant on SAP FI/CO modules for multinational organization3 End to End implementations of SAP BPC NetWeaver (SAP BPC 7.5/EPM 10) for large scale organization. Excellent Knowledge of EPM 10.1 and provide instant and complex planning solutions in BI IP.
• 1 end to end implementation on SAP Profitability and Cost Management (SAP PCM 7.5) for a Telecom Industry
• Migration of BPC 10 to BPC 10.1 and developed an end to end solution on Sales Planning and Price planning using various Input forms of Unified Model.
• Mr. Swaroop was employed with dissimilar firms like Financial, Retail, Breweries, Medical, Automobile, Oil &Gas, Pharmaceutical, Consumer Products, Dairy, Telecom and Technical solutions.
• Participate in presale activities; work with Business Leads and strategists to define relevant strategies, capabilities and roadmaps.
• Actively involved in diverse phases of SAP full cycle implementation of Project Preparations, Blue Prints, Implementations and Go Live Preparations and support.
• Excellent noledge in SAP FI CO, SAP CO - PA, SAP SD, Master data elements such as GL Accounts, Cost Centers, Profit Centers, Customer Master and Product Hierarchy
• The exploits of EPM/BPC implementation include BPF, validations, customize DM packages, Master and Transaction data loads at Background along with Hierarchies Reports and Input Schedules, Script Logics and complex BADI’s.
• Data extraction and Retraction from EPM Models to PCM using Staging Cubes and DSO’s in COV format (LINEITEMVALUE)
• Proficient in creating Confidential specific FOX Formulas in planning functions of BI IP
• Individual contributor and a go to person for complex requirements
• Expertise in troubleshooting various data issues using Debug Techniques

TECHNICAL SKILLS:

• Analytical Skills
• BPC 10.1, EPM 10.0 /BPC NW 7.5 & MS 5.0
• BI-IP and BI 7.3 /BW
• EPM Functions, EVDRE
• MS Excel
• Programming Skills
• BADI (ABAP)
• Script Language
• VB Script (Macros)
• SQL Language
• MS SQL (Stored Procedures) etc.

PROFESSIONAL EXPERIENCE

Techwave Consulting

Confidential, St. Louis MO

Responsibilities:

• Obtain the functional Requirements from Business Development team
• Involve in Requirement Gathering & analysis, design and SAP BPC 10.0 Consolidation implementation (US GAAP/IFRS)
• TEMPEffectively deliver the solutions on consolidation of investment, Minority calculation, Intercompany eliminations by utilizing currency conversion
• A single application to provide variance analysis, initial budgets and Monthly forecasts
• Automate and streamline planning, budgeting, forecasting and consolidation activities for short budget cycles to make better decisions based on wat-if analysis.
• TEMPEffectively utilize the Business Rules ( Currency conversion and intercompany matching) of consolidation, validations and customized script logic to meet the Business needs
• Automate BW Master and Transaction data extraction by process chains and BADI Retraction
• Maintain the applications of Consolidation, Capital plan and Financial Planning
• Experience in creating planned financial statements, P&L Reports, consolidated Balance sheets, Cost planning, planning templates, Input Schedules and workbooks along with Excel Macros
• Proficient in creating Measure formulas, Member formulas, MDX Formulas, Data Conversion formulas
• TEMPEffective utilization of Transformations and conversion files on need basis along with dynamic filter values to DTP’s to make delta transaction data loads to Various BPC applications
• Provide Leadership and work guidance to associates of other project members
• Developed various Script Logics, Cost allocations, validation logics, Journals and VB Macros
• Thorough noledge in MDX formulas, troubleshooting and extensive experience in Excel functions along with EPM functions
• Instantaneous solutions in BI IP for various Confidential /user requirements by using FOX formulas.
• Thoroughly utilized Lite and Full optimization for report enhancements and advanced proficiency in utilizing Drill through, Drilldown and Journal Entry’s
• Developed complex BADI’s and TEMPeffective utilization of BW Objects like InfoCubes, InfoObjects, DataSources, DTP’s etc.

Techwave Consulting (Senior BPC Consultant)

Confidential

Responsibilities:

• Participated in Business user discussions to provide simplified solutions in terms of Both EPM 10.0 vs PCM
• Participated in pre-sale activities and successfully gathered user requirements and supplement the same to the team by Technical and Functional Specifications
• Design the models of BPC and PCM cubes for driver based planning and product cost allocation
• Responsible in extraction & Retraction of PCM data to BPC along with Integration of these two systems
• Reponsible in Developing the Models in EPM for the Financial Planning ( Cost, Capex, Revenue and MR) and integrate them with PCM for futher allocations
• Design the EPM Models and align them with the Business user functional requirements and successfully able to sign-off the Blueprint
• Customized EPM Models of Revenue and Cost which derives the data from ECC (CO-PA and CCA) for various product lines, Sub Product A & B) and supplies to PCM (for Revenue / Traffic (subscriber data) allocations).
• Custom solution of allocations (Moolah - for Prepaid of Promo Bundles etc) for some specific set (allocated/unallocated) of data based on the Business user defined rules.
• Delivered the simplified solutions using BADI for complex requirements of Revenue
• Ad-hoc complex Excel Reports developed using VB Macros for BPC and PCM transaction data
• Establish connection between database and PCM and subsequently load cumulative figures of BPC into PCM by using Data Bridge (create specification file and control files) and there by reconcile the data for further top-bottom allocation of cost in PCM
• Assist SQL team to create Stored procedures which in turn transmit the data of one PCM model to another Model for further cost allocations

Techwave Consulting (Senior BPC Consultant)

Confidential

Responsibilities:

• Migrate Microsoft 5.0 version requirements and migrate the requirements into SAP BPC NW 7.5
• Built the operational planning applications (Sales, Purchase and BOM) and provide small term planning to long term plan (5 years Plan).
• Responsible in building the critical dimensions (e.g: Material Master, SKU etc) and supply the APO DP and SNP data to BPC Applications
• Thoroughly analyze the stored procedures, SQL Queries and reimplement the functionality in SAP BPC script logics or ABAP BADI’s.
• Proficient in understanding the MDX formulas, Member formulas and Excel functions
• Developed various BW cubes and BPC Models and ensure background data loads and hierarchy loads to happen
• Understand the SSIS package and replicate the SSIS package to SAP Process chains
• Utilized the write back UJ WRITE BACK BADI’s for relevant input schedules
• Ensure performance improvement compared to MS Version
• Generated complex Sales Reports of Weekly, BI weekly, monthly and Yearly data
• Customized various Data Manager packages and provided prompts to trigger various BADI’s
• TEMPEffectively used Java Scripts in conversion files and VB Scripts for various EVDRE Reports
• Built various dimensions and its relevant Hierarchy for Material, SKU etc.
• Developed various staging cubes of Sales and BOM and scheduled the background Jobs for the transaction data loads
• Analyze MS Script Logics and allocation procedures and reimplement it in SAP BPC NW 7.5 using script logic and BADI’s
• Through utilization of UJ CUSTOM LOGIC BADI for BOM, Sales Planning etc.
• Migrate all MS Reports and Input schedules of MS 5.0 to SAP BPC NW 7.5

Techwave Consulting

Confidential

Responsibilities:

• Provide customized functional/business solutions of novonordisk on Clinical cost, GFP (Global Financial Planning) and GSF (Global Sales Forecast) through BPC 7.5
• Monitor assignments to vendor through the tools of Global Remedy, TIMS and accommodate relevant solutions
• Participate in business meetings of Super users and obtain the business requirements and provide the changes or assign the change the requirements to vendor
• Create/Update/Monitor process chains, daily loads (APO) from third party systems and ensures various data reconciliation of cost (with ECC 0D CCA9/ICKK ACT) along with Patients information (IMPACT - DataStage) for plan splits (on 5 -90 -5 rule) and accruals ( country codes of 97,98 and 99) based on trials / country level.
• Troubleshoot various data issues by the problem/change/Incident management of Global Remedy
• Update to various Clincost workbooks comprising of assorted BPC Reports in validating the data and generating the user specific outputs (Extensive utilization of MS Vb code).
• Lead the team of eight on BI IP development and supporting the users across various geographical locations
• Implemented the cycles of Monthly Rolling Forecast and Sales Operational Planning.
• Develop planning functions and input based planning sequences to fulfil the Confidential needs
• Create Reports and input enabled query’s for Financial and Sales planning requirements
• Provide technical solutions to the team with debugging expertise
• Develop various fox code and user exits to meet complex requirements
• Assist the team members in terms of resolving the complex problems of BI and BO

Team Lead

Confidential, MA

Responsibilities:

• Interacted with business owners and users for requirements gathering and analysis. Reviewed and updated the functional design documents for FI/CO developments, Full lifecycle implementation.
• Involved in developing detailed functional specifications documents.
• Configured Account Payable Starting with Purchase Requisition, Purchase Order, Goods Receipt, Invoice Verification, Vendors credit memo and Check clearing sub-processes, Advance paid or down payment made to vendors.
• Configuration for the creation of Account Receivables invoices and posting of manual incoming payments with differences, clearing and reversals, interest calculation.
• Developed AR custom report for month end closing to capture the every detail of Closed and Open Customer invoices.
• Configured Fixed Asset Master Data - acquisitions, retirements, revaluation of fixed assets, customized depreciation keys for depreciation run - planned, special, unplanned depreciation.
• Customizing screen layouts for asset master data, asset sub ledgers and asset depreciation areas. Defining transaction types and account assignments for asset acquisitions and retirements.
• Involved in integration of Fixed Asset accounting with internal orders, maintaining settlement profiles for internal orders, Configuring capitalization of assets under construction, assigning cost elements.
• I was involved in Integration of New general ledger with Controlling for reconciliation activity through real time integration variant.

BearingPoint (Senior Consultant)

Confidential, LA

Responsibilities:

• Follow the Best Practices of SAP and install the relevant Business Content of SD, MD, WM, POS and FI.
• Configure the LO Cockpit elements and ensure the data flow for the Standard content as well as custom BI objects.
• Install the appropriate sections of Sales & Distribution and Purchasing and used in conjunction with the Retail Stock Ledger to provide adequate reports to merchandisers.
• Employ the standard DSO’s of Stock Revaluation, Retails Sales, Sales Price Revaluation and item movement for stock ledger along with adjustment of movements to furnish the data to Cumulative Stock Ledger
• Generate custom & complex Reports like Tawa Sales Summary Report (for Reconciliation based on FI), Merchandise item level detail, Monthly Buyer Sales Analysis (Buyer Performance).
• Various Reports on MultiProvider of ERMA Stock Ledger which comprises of Cumulative & Non-cumulative Stock Ledger infocubes and saved queries to MS Excel Workbooks.
• TEMPEffectively utilized the infosources and Datasources like Sales document header (2LIS 11 VAHDR), Sales Document item data (2LIS 11 VAITM), Delivery item data (2LIS 12 VCITM) and Billing Data item (2LIS 13 VDITM) etc.
• Involved in Cost center assessments to segments, CO-PA reporting, forms, Planning, Derivation rules and structures, Product and customer hierarchy, PA settlement, realignments and integration issues with SD.
• Involved in data migration from legacy systems to SAP system using LSMW.

BearingPoint (Senior Consultant)

Confidential, MI

Responsibilities:

• Responsible in system upgrade from BW 3.5 to BI 7.0 (Netweaver 7.0) with respect to ECC 6.0.
• Gathered applications/tables/BW objects/ BPS-SEM Objects to be maintained and upgraded
• Reports on Income Statement forecast (BPS QRY 005) and workbooks of Smart Lease Earning Rate wkbk 60 months (BPS QRY 009).
• Various BPS Layout developments on Smart Buy Carry In Asset and Revenue (BPS LYT AR 004), Smart Lease - Smart Buy Terminations(BPS LYT LE 004), Retail Whole Loan Adjustments (BPS LYT SF 002) etc.
• Ensure successful execution of Planning Folders which comprises of various layouts with Various GPS’s.
• Maintain TEMPeffective characteristic relationships and supplementary utilization of various planning functions like Revaluation, copy, delete etc.
• BPS-SEM upgrade involves in identifying the relevant Planning Layouts, Planning Folders and its subsequent planning objects.
• Identify Obsolete statements of Fox code and replace them with new statements by developing custom programs, ensure working conditions of characteristic relationships, function exits, Global Planning Sequences, ensure to maintain TEMPeffective performance of Layouts and thorough test to ensure the business functionality intact
• TEMPEffectively utilized Manual Planning and custom planning functions using User-exits (UPF * EXIT EXECUTE) at the required locations with data container XTH DATA.
• Generated reports of Impairments, Disbursements and Depletion rates
• Thorough utilization of Planning items which comprises of Planning/Multi planning Areas, Levels, Packages, Functions, Fox formulas and maintain characteristic relationship through function modules

BearingPoint (Senior Consultant)

Confidential, NJ

Responsibilities:

• Experienced in developing R/3 Generic Extractors using Function Module (with Delta Logic)
• Generated BEx query’s/reports on Product cost (SRC), ICP (MRC) and Sales to attain the Add-back Calculation (Reports: Actual & Planned Gross Profit Product Query, Product Addback Report and Sales Addback Report).
• TEMPEffectively utilized the Data slices and filter definitions at right junctions.
• Determine cost and sales variances by means of percentage and cost .
• Thorough noledge in creating product cost, icp and sales Info Objects/ Data targets/Process chains/Customized extractors
• Developed an email program to send emails to the end users at all obligatory steps
• Implemented customized delta mechanism through the customized programs
• Extensively worked on developing BSP Applications for Product Cost, Product registration, ICP, Actual Sales and Forecast Sales.
• In depth noledge of BSP Elements and developed diverse dynamic BSP applications by utilizing them
• Develop various BW reports and publish the same in Netweaver Portal.