SUMMARY

• Over 18 Years of IT experience in analysis, design, development, and implementation. More than around 3+ years of SAP HANA, 12+ years of BW/BI, 3+ Years of BOBJ around 2 year of SEM (BCS, BPS) and around 10+ years of ABAP/4 experience, Involved in different phases of software development and 5 full life cycle BW implementations. Major areas of business expertise in BI 7.3,7.1, BW (3.5, 3.1c, 2.1c, 2.0b), SEM (3.5), FI - CO, SD, POS, MM, PP, PC, PM, HR modules, BO 6.5, BO-XI R2, BPC.
• Business Information Warehouse (BIW): Worked extensively in BW/BI to built custom BW applications, create complex enhancements, create and maintaining InfoObjects, InfoCubes, MultiCubes, InfoAreas, InfoCatalogs, InfoPackages, InfoSources and Aggregates in the Administrator Workbench. Data Modeling using BW Star Schema for optimized data reporting. Extractions. DB Connect, LO-Cockpit, Generic Extractors, Setup Tables, V3 Update, Enhancements using User Exits, Transfer Structures/Rules, Communication Structures, Update Rules, ODS/Cube design, Scheduling and Monitoring data loads. BEx Analyzer and Web Reporting: Queries, Workbook templates, Web templates for I-Views Reporting agent Exceptions, Alerts, Print layouts, restricted key figures, calculated key figures, Real Time Extractor and Integrated Planning.
• Experienced in Analysis, design and development using Administrator Workbench, Business Content, Metadata Repository and Business Explorer. Configuration, Data Modeling and Extraction from different source systems mostly flat files and OLTP.
• Performance Tuning: Worked on performance tuning using BW Statistics, Aggregates and Indexing. BW Installations and Upgrades including Plug-Ins. Performed Data Loads using the BW Process chain. Worked on Authorization Objects, rolls, and activity groups.
• Production Support. On Site Help Desk Support. Unit test, System test and Integration Testing. Developing the departmental standards and guidelines. Writing the functional and technical specifications for the functional and technical team. Troubleshooting developmental, analytical, and logical ongoing issues.
• Strategic Enterprise (SEM- BCS): Worked on configuration of BCS module to meet the global business GAAP requirements. Responsibilities include design, develop, Interunit elimination, Reclassification and allocation, Data Transfer, Currency Translation, Balance Carryfoward, Reconciliations, Validations and implement consolidation reporting. Joined SEM team at blueprint phase. Experienced in BCS project preparation, design, Implementation, testing, Technical Configuration of all relevant BW-Objects: Also involved in all related Infocubes, Infosource, ODS, multicubes, aggregates, process chain, flexible updates, technical business content etc. Data extraction from SAP R3 FI/CO. This role is a mix that is mainly focused on BCS but will also involve work.
• Worked on HR module for Infotype 1018.
• Business Objects 6.5, XI R/2: Created Universe, Reports. Worked on CCM, CMC, Services, Publishing, Scheduling reports, Dashboards, Reporting conversion tool, Xcelcius created user-friendly crystal, web reports.
• Knowledge of BPS
• Developed ABAP/4 Reports (Classical & Interactive), BDC Programs, Dialogue Programs, Screen Painter, Interfaces, Data Archiving and User Exits in Sales & Distribution (SD), Materials Management (MM), Finance and Controlling (FI/CO) & Production Planning (PP). Hands on Experience in SAP Upgrade Projects.
• Applied OSS notes
• Worked in variety of industries Investment Banking, Diary, Pharma, Oil & Gas etc.

TECHNICAL SKILLS

ERP: BI 7.X, BW (3.5, 2.0b), SEM (4.0 & 3.5) and SAP R/3 (3* - 4.7C), BOBJ.

SAP modules: HANA, BW, SEM (BCS, BPS), FI, SD, MM, PP and Archiving.

Comp. Languages: ABAP, PL/SQL, VB 5/6, ASP, JSP, Java Script and HTML

Databases: Oracle 8i/ 9i/10g, SQL Server, RDBMS and DB2

Business Intelligence: Business Objects XI R2/ 6.X, Web Intelligence 6.5, Crystal Reports.

Operating Systems: UNIX, Windows NT, Windows 95/98/2000, and MS-DOS

Others: BAPI, ALE/EDI, Share point, Quality Centre, Workflow & RFC

PROFESSIONAL EXPERIENCE

BI / Data Warehouse Analyst

Confidential

Responsibilities:

• Working on BW on HANA.
• Built Complex Calculation Views in HANA to enable data to Azure via BW4/HANA via SLT.
• Create DB connection to extract data from Oracle DB to HANA System used stored procudures.
• Create SDA connection in HANA to extract live data from ORACLE system.
• Involved in HANA Upgrade.
• Completed 2 projects using Agile (Kanban) methodology.
• Resolved issues in connecting to SAP Business Financial consolidation system.
• Implemented VIM (Vendor Invoice management) on BW.
• Woking on BI along with BFC (Business Financial Consolidation) team to report consolidated data.
• Involved in discussions with Business to understand the requirements and suggest the way to go ahead with new development.
• Activated and enhanced Assets flow.
• Creating/enhancing new data flow for Product Cost Estimate.
• Written some complex code to reconcile ECC data for Product Costing.
• Applied OSS notes.
• Developed financial reports in BO 4.0 Report and Power BI.
• Written complex ABAP logic for the Financial Reports.

Sr. SAP BI/BO Architect

Confidential

Responsibilities:

• Involved in discussions with Business to understand the requirements and suggest the way to go ahead with new development.
• Developing SPO BI 7.3 to load data in different partitions.
• Design and Develop dynamic Process chain to load around 140 company code data based on partitions.
• Developed Report/Workbooks using SAP Business Object Analysis for Microsoft (Excel and Power Point) release 1.3.
• Design and develop method to calculated YTD and load legacy data from informatica.
• Developed Transfer routine at infoobject level.
• Developed complex program to change and load Hierarchy data.
• Involved in SAP HANA Rapid Deployment Solutions for SAP HANA on BW.
• Convert Current Infocubes to HANA-optimized InfoCubes.
• Creating Schema to load data from Non SAP systems to HANA.
• Moving the Queries to DSO for Direct Reporting for better performance.
• Developed Webdynpro application to control the developed process chain.

Sr. SAP BI/BO Architect

Confidential

Responsibilities:

• Redesign BW data module to normalize the data from Multiple Source systems.
• Creating Conceptual, Logical and Physical data Model.
• Writing High Level Design Document.
• Normalizing data from multiple source systems.
• Mapping data flow from SAP BW into Informatica.
• Created Real Time Extractors to extract date to Webi reports using Infocube.
• Created Aggregate Aware universes
• Analyzing the current BO Webi reporting solution which done offline to make it more dynamic online reporting solution.
• Web Service created by Webi Rich Client (BIWS).
• SAP BPC used as intermediate Source system to populate Webi reports.
• Building Universe based on BEx queries & Infocube using SAP Business Objects Data Services.
• Build Drill down reports and Complex BEx Queries for Score card & Dashboard reports in Xcelsius.
• Developed APD to download files to load in DB2.

Sr. SAP BI Consultant

Confidential

Responsibilities:

• Responsible for designing Function specifications from detailed high level design document (DHD) for HM cluster.
• Involved in completing the technical specifications for Offline reporting MI cluster and reports according to the project documentation standards
• Involved in creating and executing test scripts as part of the integration and confirmation testing for every project releases.
• Played an vital role in the performance tuning of various Extractors by adopting the quality standards followed in GSAP-ABAP across clusters
• Involved in improving the Query performance by designing Steering table concept, which would suggest the mulitprovider in the query at runtime to fetch data from one of the Infoproviders, which are logically portioned based on Time zones via Customer exit.
• Involved in designing Broadcaster settings for offline reporting.
• Designed Load balancing program for distributing offline reports to 28 countries.
• Designed complex report with macros and Pivot table for distribution.
• Designed Web templates for online reporting.
• Developed Real Time Extractors and Cubes to validate report.

Sr. SAP BI /BO/ SEM BPS Consultant

Confidential

Responsibilities:

• Functional - Implementation - took a lead in setting up a SEM BPS/BI development environment & then designed the architecture for the new SEM/BI Development landscape.
• Involved in Sales Planning and provided support in designing the planning areas, planning levels, planning packages layouts, variables.
• Worked extensively on Planning Workbench (T.code BPS0) to design the sales planning as per Business Requirement.
• Created the Web Reports as per Business requirement using the T.Code BPS WB Web-Interface Workbench and Run the Web Reports by using the T.Code BPS BIF0.
• Modified existing Fox Formula.
• Implementing the Currency Translation Adjustment account (CTA) using BPS.
• Created Currency Translation Types.
• Created Cubes, DSO.
• Written & enhanced already existing Routines in Transfer Rules, Update rules and Standard Extractors.
• Implemented Delta mechanism on 0EC PCA 1 and 0EC PCA 4 extractors using Reversal Logic.
• Implemented Cost Centre Allocation Module.
• Enhanced the BO universes.
• Using Web Intelligence XI R2 through Infoview extensively for the creation of the reports.
• Supporting the Plan view Universes and Reports by fixing existing bugs and creating new/enhancing Business Objects reports and universes, Managing users and document access control.
• Created reports containing all the information regarding distributors and retailers using crystal reports.
• Created and modified the Crystal Reports for various financial groups using the Multiprovider as a main data provider.
• Resolving production support issues.
• Created Test Scripts for testing team.
• Used the Solution Manager for Issue and Change request management.
• Prepared TDD and Code Review Check List and uploaded in Share Point.
• Followed J&J SDLC polices

Sr. SAP BI 7 / BO-XI R/2 Consultant/ Project Manager

Confidential

Responsibilities:

• Functional - Implementation - took a lead role in upgrading to BI 7.0 from BW 3.5 environment & then designed the architecture for the new BI Development landscape. Improve Delta Management & suggested simplification options for existing system architecture. Build new Universe and used Report conversion tool for already existing reports.
• Leadership - Solely took the responsibility as a team lead in upgrading and implementing new functional requirements for Germany.
• Developed standards and procedures, including development design templates, functional and technical documentation, 3rd party product Infopack, and object naming standards, landscape(s), transports, roles, sandbox, design guidelines. Developed, training presentation for staff of “do’s and don’ts” of new BI System.
• Communication - Interaction with the management and decision-makers (Manager, Regional Managers & heads of departments) to identify business requirements and define project charter. Document reporting needs of the business service and support organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting (SAP functional & technical requirements), also did presentation on Both technical & non technical of BI functionality to project mangers & end users
• Conversion of old data flows to a data flow with transformation and data transfer processes.
• Created Enhancement in R/3 and BI.
• Written Routines in Transfer Rules and Update rules.
• Created a Process chain and Meta Chains for loading.
• Enhanced already existing DSO, Infocube and Multiprovider.
• Enhanced Business content Master data object.
• Created Aggregates based on the most important queries.
• Created Planning reports for users to enter planned data using BI Integrated Planning.
• Used new variable editor to edit Variable and Replace Variable.
• Created BEx Queries using Report Designer and complex Web Reports with Graphics.
• Revived and enhanced the already existing code/process for better loading Performance.
• Used Open Hub technology to transfer the data to other systems with restrictions using Transformation.
• Monitoring data loads and Production support.
• Estimated the man-hour’s new requirements for team members.
• Written Technical specifications.
• Trained the users about the functionalities of BI 7, Authorization, Delta Process and Extraction from R/3.
• Worked on the BO Services to start the BO server services using service Option.
• Created Universe.
• Worked on CMC for creating Folders, Objects, Groups, Users, Profiles and assigning Rights to the user. Created Server Groups to minimize the load on the system.
• Used Import wizard option.
• Used report conversion tool to convert reports.

Sr. SAP BW/HR Consultant/ Team Lead

Confidential

Responsibilities:

• Functional - Implementation - took a lead role in setting up a BW development environment & then designed the architecture for the new BW Development landscape for Europe wide implementation.
• Leadership - Solely took the responsibility for Refined Project Charter & Project Plan to accurately technically reflect required activities & their duration for all five stages of BW Project life cycle.
• Developed standards and procedures, including development design templates, functional and technical documentation, 3rd party product Infopack, and object naming standards, landscape(s), transports, roles, authorizations, sandbox, BW and design guidelines. Developed, training presentation for staff of “do’s and don’ts” of BW design.
• Communication - Interaction with the management and decision-makers (Directors, board members, heads of departments & Super users) to identify business requirements and define project charter. Document reporting needs of the business service and support organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting (SAP functional & technical requirements), also did presentation on both technical & non technical of BW functionality to end users.
• Lead the team of 4 consultants for global implementation in Europe and America.
• Explored the KPI’s based on the requirement analysis and modify the already existing KPI’s.
• Creating customized Cube, ODS and InfoObjects for Logistics module.
• Design the LO module for Generic Delta.
• Used routines (start routines, update routines) in update rules and transfer rules to update key figures in the InfoCubes. Created InfoSets, assigned user groups to the InfoSets and also defined InfoSet Queries to enable multiple variable selections on the master data.
• Created process chains to load Master and Transactional Data.
• Created Virtual Key Figures.
• Created a Process chain with infopack which deletes the data for a particular country which is about to go live.
• Implemented HR PA, PY, External Employees and Budget for the following countries Germany/UK/France/Poland/Ireland.
• Created Data Source on Position Infotype 1018 for Cost Distribution, Fraction Headcount (FTE) and Payroll.
• Extraction of data from Purchasing Module to find out the number of External Employees.
• Enhancing the already existing code for better loading Performance.
• Enhancing the Master and Transactional Datasource.
• Worked on SD business processes OTC (order to cash) and sales order processing, Delivery, shipping and billing.
• Worked on comprehensive process of Order to Cash cycle posting and reporting
• Worked on simplified Order to Cash cycle like order-to-invoice and invoice-to-cash.
• Developed report for analysis of shipment and point-of-sale data.
• Created BEx Queries and complex Web Reports with Graphics and Integrated Planning Report.
• Monitoring data loads and Production support.
• Trained the users about the functionalities of BEx and Web reports.
• Conducting Interviews on behalf of the client ( Confidential ).