SUMMARY:

• Around 16+ years of IT Experience.
• SAP BI / BW ~ 13+yrs
• SAP BW on HANA ~ 3+yrs
• SAP ABAP ~ 11+yrs
• SAP BOBJ ~ 5+yrs
• SAP IP/BPC ~ 2+yrs
• Played the role from Developer, Consultant, Architect, Project Lead & Project Manager in various projects over the period.
• Been part of multiple types of projects: Implementation, Roll - outs, Upgrade, Enhancements, Support & development.
• Knowledge and experience of multiple domains.
• Experience in SAP BW/BI till 7.4 on HANA, HANA Studio, BOBJ 4.1, ABAP & ECC 6.0, Tableau 10.1 Development, BPC/IP Planning Modules & BPC Backend BADI/Retraction Script Logic.
• Knowledge of Order to Cash, Bill to Pay, Made to Order process of Supply Chain.
• Knowledge of Financial Requirement of business from Balance Sheets, Operational Gross Margin, Profit Center Accounting, Cost Center Accounting & Financial Consolidation Statements.
• Knowledge of Inventory Management: On-time Production planning reports, Stock Overview, Movement analysis, Purchasing Spend analysis & Costing Reports.
• Knowledge of Customer Reporting: On time In full shipments, Order to Bill Reports, Pending Shipment and Backorders, Partner Incentive Programs, Multilevel Discounts Strategy & Pricing Conditions.
• Knowledge of Banking & Insurance: Investments planning, Corporate Finance Management, Corporate Mortgage, Treasury & Risk Management, Collections Management & Credit Management.
• Involved in BI Hands-on development & Testing of Extraction, Data sources, DSO, Infocube, Multiproviders, Composite providers, Infosets, Process Chain, Broadcasting, Transformations and Open hub configuration.
• Implemented number of BOBJ deliveries that includes Webi Reports, Dashboards, Analysis for Office reports using BICS to BI and Universe connections as well.
• Lead the team offshore and onsite to successfully delivery the business requirement in time and with highest customer satisfaction.
• Most of projects required Client Interaction and client facing with first hand input from business starting from analyzing requirements and setting up timelines to delivering.
• Been part of Business Blueprint, Analyze, Project Timelines, Development, Unit Testing, Functional Testing, Documentations, Quality Control, Performance testing and finally on-time Delivery.

TECHNICAL SKILLS:

Domain Knowledge: Oil & Gas, Automobiles, Manufacturing, Banking & Insurance, Financial Services, Media & Information Services, Retail, Pharmaceuticals & Utilities.SAP BW/BI (up to version 7.4): Re-Architecture, Data Modeling, Data Extraction, Reporting, Open Hub, Broadcasting, Planning, WAD, Process Chains development & Monitoring & Production Support.

SAP BWBPS / IP: Designing Planning models and developing Planning Levels, Planning functions, planning package.

SAP BOBJ 4.1: Webi Reports with filters, breaks, Merged queries and formatted layouts. Scheduling and with Graphs. Implementation of multiple report with Analysis for Excel version.

SAP BPC 7.5: Knowledge of working in BPC 7.3, Creating Appset, Applications, dimensions, Layouts, EVDRE, Executing Package, Load Master & Transaction data, Creating users, teams, task profile & member access profiles. Knowledge of MDX script logic for Rate conversion and others. Also, been part of Custom BADI implementation & Retraction to ECC and scripting the logic for spread.

SAP ABAP: DDIC, Reporting, Module Pool, Smartforms, BDC s, Function Modules & Modularizations, User Exits, Infosets, Performance reviews & Production Support, CDS Views on HANA.

SAP HANA: New HANA based modelling on SAP BW 7.4, Composite Providers, Open ODS View, Attribute Views, Analytical Views & Calculation views along with CDS views in ABAP Modeler.

Visualization: Dashboards, Map based reports, Graphs using Tableau 10.1, Summarized analytics using R Scripting.

General: Power user on MS Excel, MS Word & MS PowerPoint.

Oracle & D2K: PL/SQL Queries.

PROFESSIONAL EXPERIENCE:

Confidential, El Segundo, CA

SAP BI Architect & BOBJ, HANA, BPC Development & Support

Responsibilities:

• Analyze the current High visibility reports and redesign the dataflow to make them available faster accurate and with better user experience to business.
• Re-design the Sales Statistics dataflow & Provide end-to-end solution for Metering technology group.
• Support business with BPC requirement on BI Side.
• Design and implement SAP BI Solution so as to effectively improve the current dataload timings and faster reporting using BOBJ 4.1 with BI 7.4 HANA.
• Implemented multiple new Universes, Webi Reports with scheduling and dashboards.
• Optimized couple of old Universes and migrated to new BOBJ 4.1 version to make it performance wise better.
• Developed and implemented Tableau based visualization solution with Map based graphs and dashboards for management.
• Participated in BO 4.1 upgrade, BI 7.4 on HANA upgrade and re-design.\s

Environment: SAP BI 7.4 on HANA, SAP BO 4.1, SAP Analysis for Office, SAP ECC & SAP CRM, SAP BPC 7.5, SAP Solman & Multiple External systems.

Confidential, El Segundo, CA

SAP BI/ABAP/BPC Consultant

Responsibilities:

• Support Enhancements of on-going Projects for SCM, FI, MM, COPA and Planning.
• Plan and implement the Backend development for BI and BPC as per the requirement directly collected from the Business.
• Developed and Implemented SCM project for Executive to have On-Time-In-Full analysis.
• Designed and implemented FLU project for seasonal requirement and complex reporting schedule.
• Implemented various mini-projects for Business with multiple reporting needs.
• Worked to implement Clinical Trail Budget planning BADI for BPC and instrumental in designing the Script to do Spreading/Phasing across years.
• Implemented Retraction logic BADI for another BPC Cost Center Planning from BPC to ECC via BI.
• Part of team to upgrade BI 7.1 to 7.3 and BPC upgrade from 7.5 to 10.
• Take up new enhancements - Document Design Specs, Tech Spec, Testing documents and get it approved and design the Data model, getting developed and tested and deliver it successfully.

Environment: SAP BI 7.1/7.3, SAP R/3 ECC 6.0, SAP BPC 7.5/10

Confidential, Piscataway, NJ

SAP BI/BW Consultant

Responsibilities:

• Support Enhancements of Projects for SD, FI, COPA, SRM, CRM & Planning.
• Define the architecture for the Hub Profitability based on the inputs from the business to access COPA, Sales planning data from BPS and Inventory stock data thorough query and APD.
• Enhancements to CCA (Cost Center Accounting) & PCA (Profit Center Accounting) data flow into BI.
• Implement and test the new Change request.
• Guide the offshore in the development and testing.
• Take up new BI Projects - Get the FS approved and design the Data model, getting developed and tested (Unit, Acceptance & Regression) and deliver it successfully.

Environment: SAP BI 7.1, SAP R/3 ECC 6.0, SAP SCM, SAP SRM, SAP Solman &xMAM.

Confidential, Piscataway, NJ

SAP BI/BW Architect

Responsibilities:

• Design and implement architecture and data modelling for project on OGM, CRM, SCM, FI and Planning.
• Define the architecture based on the inputs from the business.
• Providing guidance to develop a BI strategy, consulting support, enhancement, and integration based on business requirements and information gathering.
• Utilize the team to get the required design implemented and tested.
• Connect with the business users and clarify their doubts and providing them the reporting as per their desire.
• Manage offshore team and their development work.

Environment: SAP BI 7.1, SAP R/3 ECC 6.0, Vistex, iPOS, Predictix, Sabrix& SAP XI.

Confidential

SAP BW Project Lead / Developer

Responsibilities:

• Design, Implement new projects & support enhancements for CRM, FSCM, FI, IPM, Rights & Royalties.
• Utilized SAP Netweaver BI 7.0 Data Warehousing Workbench to design and configure InfoObjects, InfoCubes, Data Store Objects, InfoSources, DataSources, Data Transfer Processes, InfoPackages, Extractors, Transformations, Data Loads and Process Chains.
• Meeting with business and functional owners for requirements gathering and high-level design review sessions to derive and execute action plans, meeting deadlines and standards.
• Providing guidance to develop a BI strategy, consulting support, enhancement, integration based on business requirements, information gathering and recommend appropriate business systems
• Performed data modelling, application development, technical product assistance and tuning to meet customer performance and functional requirements.
• Infoprovider design, development in data extraction & reporting in the application areas IPM, CRM & FSCM configuration.
• Documentation and delivering functional & technical specification documents, and assisted architecture analysis and design using BI Tools.
• Created reports in BEX and WAD and publishing and testing in Portal.
• Distribution of Development work within the team.
• Implement SAP Best Practices available for Media Industry.
• Resource Management.

Environment: SAP BI 7.0, SAP R/3 ECC 6.0, SAP CRM, SAP FSCM, SAP BO XI.

Confidential

BW Lead / Developer

Responsibilities:

• Design and implement the project for CML, CFM, FI, Treasury and PA.
• Gather Requirement from Business users and the functional consultants.
• Creation of Blueprint and timeline for each final deliverables.
• Implementation of SAP Treasury & Risk Management - Investment part in SAP BI based on the best practices.
• Implementing the IRDA - Insurance Regulatory and Development Authority norms and provide the required solution.
• Creation of Generic extractors, Infocubes, DSO, Infoobjects, Multiproviders, Infoset, Bex Queries for the IRDA requirement as well as Final Accounting reports.
• Getting Quality checked & UAT done.

Environment: SAP BI 7.0, SAP R/3 ECC 6.0

Confidential

SAP BW Developer

Responsibilities:

• Weekly meetings and Daily status update of the tickets to the Client.
• Managing and planning the BW resources in the team in accordance to the client requirement.
• Aligning business process reporting with the BW data and generating the required functionality.
• Visited client-site to understand and improve the specific Sales force analysis module - a commission process in BW
• Organize team meetings to discuss any complexity within the team.
• BW Data Modeling, Monitoring Loads, Process improvements etc.
• BW Data Modeling for new requirements.
• Enhancement of data sources and writing user exits (Master data and transaction data) on R/3 and BW. Developed complex Bex Reports and workbooks for Sales analysis reporting.
• Implemented SD, MM, FI, and QM & PP by the team. Had been involved in most of the areas.
• Functional specifications and validate technical designs created by developers against functional specifications and create test cases and test scripts.
• Gather requirements, document and deliver functional specification documents, and assisted architecture analysis and design using BI Tools.
• Developed Infoobjects, Infocubes, DSO, Multiprovider& Process chains as per design and the documents.
• Daily Loads monitoring and error resolutions.
• Query Designing and workbook development.
• Co-ordinate with on-site for requirement specification and issues.
• Developing Complex reports and testing them.
• Leading and mentoring the new colleagues on the project.
• Modules: MM, SD, FI, CO & WM.

Environment: SAP R/3 4.7, SAP BW 3.5 / BI 7.0, SAP BO XI

Confidential

SAP BW Developer

Responsibilities:

• Designing Technical specs, Code Review, Unit Testing & Documentation.
• Co-ordinate with on-site for requirement specification and issues.
• Developing Complex reports and testing them.
• Leading and mentoring the new colleagues on the project.

Confidential

SAP ABAP Developer

Responsibilities:

• Implementing the unification of Business Area in all FI Reports & Interfaces.
• Creation of varied CO Reports used to check various costing of material, labour& O/h.
• Designing the Smartforms.
• Analyzing the requirement directly from enduser and helping them in designing Functional Spec for further developments.
• Coding the requirement in the identified Exits or BADI’s.

Environment: SAP R/3 4.6c

Confidential

SAP ABAP Developer

Responsibilities:

• Providing performance efficient code and replacing the old codes.
• Train the fresher on ABAP Query and ALV.
• Understand FI requirements and send Tech Specs.

Environment: SAP R/3 4.6

Confidential

SAP Consultant / Legacy Transformation

Responsibilities:

• To extract the Data in specific requirement from Oracle for use in SAP.
• Elimination of any pre-upload error by various checks and through coded programs.
• Upload the data to sessions to be executed at scheduled time.

Confidential

SAP Consultant / Legacy Transformation

Responsibilities:

• To extract the Data in specific requirement from Oracle for use in SAP.
• Elimination of any pre-upload error by various checks and through coded programs.
• Upload the data to sessions to be executed at scheduled time.

Environment: SAP R/3 4.6c

Confidential

Software Programmer

Responsibilities:

• Getting user requirement for new reports.
• Develop same onsite and getting it tested for final approval.
• Centralize the data by synchronizing with Central Server on daily basis.