We provide IT Staff Augmentation Services!

Sr. Bpc Consultant Resume

TN

SUMMARY

  • Strategic, innovative and driven Information technology leader with twenty years of experience in executing information technology strategies in alignment with corporate objectives to achieve excellence in building strong systems and delivering optimal business results.
  • Experience working in the functional areas of Finance, Sales, Logistics, CRM, CPM and SRM.
  • Experience in configuring Cloud data sources, Cipher cloud encryption, and its integration with BI environment.

TECHNICAL SKILLS

  • BI 7.4, BI 7, BW 3.5, Integrated Planning, BPC 10.1, 10.0 and Business Objects XI 3.1, 4.0, Cloud
  • Sales/Revenue, Capital Expenditure, Cost Center/expense planning, Headcount/staffing, Cashflow/ liquidity planning. Consolidation: Intercompany matching, elimination.
  • Dimensions, Business Rules, Control Settings, Logic Script, Work Status, Journal, Audit Reports, Consolidation monitoring, EPM Add - in, Properties, Data Manager, Transformation, Mapping, Conversion, Validation, Script Logic (SQL, MDX), Allocation, Currency Conversion
  • Services, Direct Extractor Connection, Flat File Uploader Hana data modelling using Attribute view, Analytic view, and Calculation view. Developed complex sql scripts in calculation views, Accessing Analytical and Calculation views from EXCEL. Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting. Involved in SAP HANA Security including User Management, Roles, and Privileges. Smart Data Integration/ Integration and replication, SLT, SAP Data.
  • Web Intelligence (WEBI), Information Design Tool (IDT, Dashboards, Explorer, Lumira,
  • Office Analysis, Dashboards, Explorer, Lumira and Office Analysis.
  • Project Charter, Scope Management, Requirement Analysis, ROI AnalysisCosting and Budgeting, Project Scheduling, Testing /QA/Rollout/ SupportBusiness/ IT Planning, Vendor Management

PROFESSIONAL EXPERIENCE

Confidential, TN

Sr. BPC Consultant

Responsibilities:

  • Designed and developed Planning and Consolidation model.
  • Configured Consolidation and support models (Ownership and Rate).
  • Designed dimensions and properties to support consolidation solution i.e Account, Entity, Intco, Flow, Group, Currency, Category, Time, Data Source.
  • Configured Ownership model to provide information on list of companies be consolidated in each group, consolidation method, consolidation percentage, ownership percentage, control percentage.
  • Designed business rules on currency conversion, elimination and adjustments, carry forward, Account-based calculations.
  • Hierarchy: Created multiple hierarchies for management and legal reporting.
  • Maintaining the exchange rates in the rate application.
  • Modified BPC process chain to support master data loads from BW to BPC.
  • Reconciling the data of BPC consolidation, planning extracts with BI, ECC application.
  • Reports: Developed balance sheet report, P&L report, variance report
  • Designed the input template in which the data is entered to parent member and the record is submitted to the base member. This was achieved without writing any BADI. In addition, the data could be entered to any level through drill down and the data is always submitted to base member.
  • Defect Resolution: Fixed defect during UAT.
  • Client Interaction: Actively interacted with BPC application owner from the client side. The objective was to understand the new client need and provide them with solution and also evaluate the support status on weekly basis.
  • Input template: Developed input template related to forecasting, budgeting, multiple stress test scenario and rate input.
  • Developed reports & input template using EVFunctions, EPMFunctions, FPMXLClient.
  • Report Distribution: Created distribution template to see the report for top management and other non BPC users.
  • Cut-Over activity: Loaded historical data, opening balances, current year data to BPC application.

Confidential

Sr. BPC Consultant

Responsibilities:

  • Report: Organized data and developed reports on Balance Sheet, Net Income, variance report as per the business requirement.
  • Designed dynamic, static, multiple EPM report within one template and organized data from multiple cube in one template.
  • Input template: Developed input template related to forecasting, budgeting, multiple stress test scenario and rate input.
  • Other reports include Discounts, Prices, Rates, Expenses, Fixed and Variable Costs, Variances, etc.
  • Data Manager: Modified Data Manager package to load data from staging table to BPC.
  • Transformation & Conversion: wrote transformation and conversion file for automated master and transaction data load from source system.
  • Script Logic: Wrote script logic for customized calculation by client and also wrote allocation logic for Corporate expenses.
  • Client Interaction: Actively interacted with BPC application owner from the client side.
  • Dimension Properties: Created process to maintain aporx 40 dimension properties in the whole environment shell.

Confidential, Secaucus, NJ.

Senior SAP BW/HANA Technical Lead

Responsibilities:

  • SAP BI 7.4- ECC6.0 & SAP BO 4.1, HANA 1.0
  • Responsible for end to end Project execution. Led a team of BW developers (onshore and offshore team members.)
  • Responsible for SAP Business Intelligence, Business Object, SAP HANA developments, enhancement & support activities and onsite coordination.
  • Involved in UAT, requirement gathering with functional consultants & business end user.
  • Executed functions such as project estimations and customer interactions for issues such as releases, work-stack and delivery schedules, assigning work to the offshore team.
  • Involved in Business Blueprinting, Gap Analysis, Solution Designing, Data Modeling, ETL
  • Worked on BW-Bex queries, DSO, info cubes, info Objects, multiprovider, process chain, DTP, transportation of objects, web intelligence report, Xcelsius & design studio, IDT/UDT universe design tool and HANA studio modeling/ support/ enhancement.).
  • Designed solution to extract data from SAP ECC, CRM-On prem, MRS and Non SAP data sources (standard and custom) such as CRM Cloud, its integration and replication to SAP BW environment.
  • Created complex BW Backend Flows for KPI Reporting and sending files thru Open Hub.
  • Analyzed. Created & Reviewed Transport strategy during Cut-over activities communicated the same with Functional Teams and Basis Team.
  • Worked with Business (Client) and Security team to identify Security Matrix for Reports, and other deliverables.
  • Implementing performance improvement steps for time to do daily data loads for data flows with very high volume of records, optimizing the process and saving resources.
  • Worked along with Basis team for setting up Non SAP source system connections, testing them and replicating the data sources to SAP BW environment.
  • Worked with Basis Team in applying latest SAP notes and patches across development, Quality and Pre-prod and Production environments.
  • Worked with MIS teams to resolve slow network response and other performance related and encryption issues.
  • Reviewed, provided input and approved Functional Specs to Finance Functional team for FSCM Reports (AR).
  • Assisted in SIT Cycles completion, resolving open defects, with Functional Teams and Business (client). Assisted client in testing reports, and various testing scenarios to completion before scheduled completion dates.
  • Worked on various minor and major enhancements projects for existing BW
  • Identified and validated the overall positioning of Mercury within the Enterprise Solution Landscape, including integration with the Enterprise Data Warehouse and Enterprise Reporting platforms
  • Completed an end-to-end design review with a broader non-Mercury (mainly ITS) audience, providing guidance and feedback on the technical design, including ongoing Extended Architecture Review team sessions
  • Created Technical specifications and standard modelling documents for HANA.
  • Developed & designed Attribute views, Analytic views, and Calculation views.
  • Export & Import of Packages
  • Security & Authorization objects (Analytic privilege, System privilege, SQL privilege & Package privilege)
  • Completed an end-to-end design review with a broader non-Mercury (mainly ITS) audience, providing guidance and feedback on the technical design, including ongoing Extended Architecture Review team sessions

Confidential

Senior BW/BPC Lead

Responsibilities:

  • Designed multi-currency solution to convert local currency into any other currency as desired by the client.
  • Redesigned the input template in order to improve the performance. In the new template the performance is improved by 60%.
  • Designed the input template in which the data is entered to parent member and the record is submitted to the base member. This was achieved without writing any BADI. In addition, the data could be entered to any level through drill down and the data is always submitted to base member.
  • Defect Resolution: Fixed defect during UAT.
  • Client Interaction: Actively interacted with BPC application owner from the client side. The objective was to understand the new client need and provide them with solution and also evaluate the support status on weekly basis.
  • Input template: Developed input template related to forecasting, budgeting, multiple stress test scenario and rate input.
  • Developed reports & input template using EVFunctions, EPMFunctions, FPMXLClient.
  • Report Distribution: Created distribution template to see the report for top management and other non BPC users.
  • Cut-Over activity: Loaded historical, forecast and budget data as cut over activity

Confidential, San Jose, CA

Senior BW/HANA Technical Lead

Responsibilities:

  • Hands on experience on SAP HANA Studio 1.0
  • Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning .
  • Replicated data from different non SAP sources using Smart Data Integration .
  • Created Technical specifications and standard modelling documents for HANA.
  • Developed & designed Attribute views, Analytic views, and Calculation views.
  • Security & Authorization objects (Analytic privilege, System privilege, SQL privilege & Package privilege)
  • Worked on SLT, BODS process flows for Data-Provisioning to SAP HANA
  • Expert in understanding of the complete Architecture (Database, Data loading, Data modeling & Administration)
  • Loading data into table definitions, suspending data loads, resuming data loads
  • Monitoring and troubleshooting data loads
  • Conducted HANA training workshops.

Confidential, Rockville, MD

Senior BI Analyst/Sr. Software Engineer

Responsibilities:

  • Enhanced the complete FI reporting structure to suit the new structure after the business was reorganized. Modified various info Providers and data targets and converted the current data to match the new structure within a very tight time frame
  • Successfully implemented FI/CO reporting solution. Installed, activated, implemented and enhanced various Business content objects for FI (GL/AP/AR), and MM of R/3. Worked on customization and enhanced the extract structure to support business needs
  • Worked on the Vendor analytics of SAP SRM (EBP) to support the reports like E-Procurement Account Assignment, Bid Invitations and Bids, Procurement Process - Single Documents, Purchase Contracts - Single Documents and Shopping Carts - Single Documents
  • Stabilized the extraction process by modifying the process chain and set up for error handling

Hire Now