SUMMARY:

• 16 years of IT experience with full project lifecycle in SAP: Requirement Analysis, Design, Development, Testing and Documentation of applications in SAP EPM/BPC, BI - IP, BPS-SEM, PCM, HANA with solid proficiency in Functional modules of FI, CO, GL, AR, AP CCA, PCA, COPA and AA. Thorough Knowledge in Simple Finance.
• Actively involved in diverse phases of SAP full cycle implementation of Project Preparations, Blue Prints, Implementations and Go Live Preparations and support.
• Participated in pre-sale activities and successfully gathered user requirements and supplement the same to the team by Technical and Functional Specifications
• Prowess in utilizing the tools like Enterprise Performance Management (EPM 10.0 & 10.1), Business planning (driver based) and consolidation (BPC NW 7.5 & BPC MS 5.0), Business Integrated planning and Business Planning Simulation (BPS-SEM) for Planning and partially for Consolidation.
• The exploits of EPM implementation include BPF, validations, custom & standard Run Package links using dynamic filters and EPM variants, automation of updating dimension property’s and Hierarchies, IC Eliminations, effective usage of BADI’s, Data extraction and Retraction from EPM Models to PCM using Staging Cubes and DSO’s in COV format (LINEITEMVALUE)
• Effective utilization of Transformations and conversion files on need basis along with dynamic filter values to DTP’s to make delta loads to Various EPM Models (Revenue, Opex, Capex, Cost and MR Models etc.). Developed simple to complex EPM Reports and Input schedules for user requirements.
• Proficient in Consolidation, Currency conversion, Cross company transaction, Intercompany eliminations, Ownership methods and calculations etc.
• Profound experience in Management and Statutory legal entity P&L Planning, Revenue Planning, Transfer Pricing Elements, Budget & Forecast etc.
• Thorough Knowledge in BW and BOBJ Reports & forms and be able to provide solutions on Oracle system
• Have written simple to complex query’s in SQL Server/Oracle of various projects on need basis

TECHNICAL SKILLS:

Analytical Skills: SAP BPC NW 10.1, EPM 10.0 /BPC NW 7.5 MS 5.0, PCM, HANA,BI-IP and BI 7.3 /BW,EPM Functions, EVDRE, MS Excel

Functional Skills: SAP FI/CO, COPA, PCA, Intercompany Eliminations (US) Planning and Consolidation, Equity and Minority Interest Journals, P&L, Balance sheetand Cash Flow

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

SAP BPC Consultant

Responsibilities:

• Gather Business requirements from MS Business users on Transfer Price
• Modelling in SAP BPC NW 10.1 and prepare functional and Technical Specification for Reports
• Provided Solution on Intercompany transactions of Transfer Price Elements like Commission, Royalty’s etc
• Provide Financial Statements of Budget and Forecast Transactions
• Provide consolidated Balance sheet of Confidential of its all Legal Entities
• Generate Management, Statutory Legal Entity P&L, Trend analysis reports and Input Schedules
• Transform the existing Cost Sharing and Shared services into BPC reports using complex Badi’s
• Built the Models of Transfer Price and trigger the custom badi’s to retrieve the results
• Built Reconciling BPC Templates and adjustments inputform at profit centers level
• An effective Logic Scripts to allocate the Revenue, WW COGS and Opex of actual vs Budget

Confidential, St. Louis, MO

Senior BPC Consultant

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)
• Effectively 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 what-if analysis.
• Effectively 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
• Effective 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 knowledge in MDX formulas, troubleshooting and extensive experience in Excel functions along with EPM functions
• Instantaneous solutions in BI IP for various client/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

Confidential

Principal Consultant

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
• Consolidate the accounts of legal entities and generate the Reports of P&L, Balance Sheet and Cashflow
• 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.
• 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

Confidential

Principal Consultant

Responsibilities:

• Migrate Confidential 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 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
• Ensure performance improvement compared to MS Version
• Generated complex Sales Reports of Weekly, BI weekly, monthly and Yearly data
• Effectively used Java Scripts in conversion files and VB Scripts for various EVDRE Reports
• Developed various staging cubes of Sales and BOM and scheduled the background Jobs for the transaction data loads
• Migrate all MS Reports and Input schedules of MS 5.0 to SAP BPC NW 7.5

Confidential

Advanced Business Analyst

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

Confidential

Team Lead

Responsibilities:

• Lead the team of eight on SAP BI IP development and supporting the users across various geographical locations
• Implemented the cycles of Monthly Rolling Forecast and Sales Operational Planning (SOP).
• Develop planning functions and input based planning sequences to fulfil the client needs
• Create Reports and input enabled query’s for Financial and Sales planning requirements
• Extract DP (Demanad Planning) and SNP (Supply Network Planning) details of APO into SAP BI for MRF.
• 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

Confidential

Team Lead

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.

Confidential

Senior Consultant

Responsibilities:

• Worked on New GL functionality on ECC 6.0 with document splitting, Setup by using Profit center as the reporting segment, Document reversals, foreign currency valuations and period end activities.
• 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.
• Performed perform SAP configuration assignments, implement interface between SAP and Sabrix Tax package, develop project plan, project proposal, and bank interfaces.
• 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.

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 effective 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.0
• 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 effective performance of Layouts and thorough test to ensure the business functionality intact
• Effectively 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

Confidential, NJ

Senior Consultant

Responsibilities:

• Develop R/3 Generic Extractors using Function Module (with Delta Logic) in SAP BI and SAP BPS
• 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).
• Effectively utilized the Data slices and filter definitions at right junctions.
• Determine cost and sales variances by means of percentage and cost .
• Thorough knowledge 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 BPS planning layouts) for Product Cost, Product registration, ICP, Actual Sales and Forecast Sales.
• Develop Planning areas, Planning levels, planning Packages, Planning Functions along with Planning Folders, Global filters, Planning Sequences and Global Planning sequences.
• In depth knowledge of BSP Elements and developed diverse dynamic BSP applications by utilizing them
• Develop various BW reports and publish the same in Netweaver Portal.
• Business transformation - from analysis, through the change process and on-wards to continuing business improvement.
• Resolve issues related to business use of implemented systems or processes by working with systems or process owners and project teams to find acceptable solutions.
• Works closely with the development team (internal and external) to assure a timely solution according to the specifications and implementation of business needs.
• Projection, formation rates, cost analysis and chart of accounts,Cost control,Reconciliations, Organization and audit tasks.
• Review of issues with the onsite team on a daily basis or as per the criticality of the issues rose.
• Developed conceptual design document for various in house small projects related to SAP enhancements.