SUMMARY

• SAP BI consultant with 7+ year of professional experience. Currently leading SAP BI Onsite project based on enhancement with multiple BW systems landscape and AMS support.
• Working as an analytics expert in various BI proposals which include comparison study of different ETL tools fitment, BI effort estimation followed by bidding and sale.
• Had worked in 4 End to End life cycle implementation, mainly focused in design, development and implementation of SAP BI Net weaver 7.0/ BW (3.5, 3.1C), SAP ECC 6.0 & R/3 (4.7, 4.6C), SAP BO XI 3.X,SAP BO 4.0 and SAP HANA Modeler.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Experienced in SAP BW on HANA and migrating standard SAP Models to In - memory optimized models and Performance testing.
• Experienced in loading data from tables in HANA Database to BW data marts.
• Expertise in the front end business warehouse components like BEX analyzer, Query designer, Universe, Web Application Designer, Web Reports, WEBI, XCelsius (Dash Boards).
• Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Good Knowledge in Direct Extractor Connections.
• Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
• Worked on various support projects involving design and development of SAP BI objects for SAP and Non SAP models from business value addition point of view.
• Expertise in BW/ BI 7(NW 2004S) components like Extractors, Basic, Transactional and Virtual InfoCubes, DSO(ODS),multiproviders, Transformations, Data Transfer Process, Remodeling of the Info Cubes, Data Store Objects, Data Sources, Data source enhancement, multi-providers, Info sets, Transfer Rules, Update Rules, PSA, Open Hub Service, Data Mart, BW Transports, and BI content.
• Experience in the OLTP extraction of data of SAP LO-Cockpit, MM, generic extractions, Enhancements and extraction from flat files, non-SAP systems and DB connect.
• Experience in Performance Tuning using Aggregates, Rollup, MultiProviders, Indexing, Partition, and Compression.
• Knowledge in BW Accelerators, Star Schema, Extended star schema, Dimensional and Fact tables.
• Generated reports on the Multiproviders, InfoProviders and InfoCubes using Restricted key Figures, Calculated Key Figures, Structures, Characteristic Variables, Text variables, Formula Variables, Cell Editors, Exceptions, conditions, RRI, Jump queries etc.
• Used Open Hub Services, to push data out of SAP BI using Data Services.
• Worked extensively in business processes across various SAP functional modules like SD,MM PP,EHS, Vistex,etc..
• Proactive team player, quick learner with excellent interactive and interpersonal skills to communicate with team members, developers, clients and end users at all levels.
• Efficiently managed teams of various sizes and worked with the team to achieve company and client's goals

TECHNICAL SKILLS

• SAP BW 7.3
• SAP HANA
• SAP BW 3.5
• SAP BW ABAP ( DDIC, Reports, Object Oriented Programming, Debugging)
• SAP BOBJ (Universe Designer, WebI, Xcelcius, Crystal Reports)Experience of Business Content scenarios /Customized reports from following SAP Modules:
• Customer Relationship Management (Services)
• Sales and Distribution (Sales Analysis)
• Material Management (Purchasing and Inventory Analysis)
• Finance ( Account Payable, Account Receivable and General Ledger Analysis)
• ETL Effort Estimator Tool
• Business Blueprint Documentation
• Specification/Design/Technical Document

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Working as a BW lead with the capacity of team size 10.
• BI project planning including effort estimation, resource alignment and creating an interim project plan.
• Scheduling and conducting workshops for Knowledge sharing, reverse shadowing, enhancement gathering, analytical requirements understanding, etc.
• Analyzing and preparing various documents like, Technical, Functional, business blueprints for reports and Automation process of data loads, etc.
• Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.

Confidential, Delaware

Responsibilities:

• Worked as a BW lead with the capacity of team size 10.
• BI project planning including effort estimation, resource alignment and created an interim project plan.
• Worked on BW initial data load plan using mirror of source system to keep downtime near to 0.
• Scheduled and conducted workshops for Knowledge sharing, reverse shadowing, enhancement gathering, analytical requirements understanding, etc.
• Analyzing and preparing various documents like, Technical, Functional, business blueprints for reports and Automation process of data loads, etc.

Confidential, USA

Responsibilities:

• Worked as a BW lead with the capacity of team size 15.
• BI project planning including effort estimation, resource alignment and created an interim project plan.
• Scheduled and conducted workshops for Knowledge sharing, reverse shadowing, enhancement gathering, analytical requirements understanding, etc.
• Analyzed and prepared various documents like, Technical, Functional, business blueprints for reports and Automation process of data loads, etc.
• Developed various EHS Module related flow in BW system to fulfill the business requirement technically as well as functionally.

Confidential

Responsibilities:

• Worked as an offshore Coordinator with the capacity of team size 10 of various level from fresher to Team leads.
• BI project planning including effort estimation, resource alignment and creating an interim project plan.
• Scheduling and conducting workshops for Knowledge sharing, reverse shadowing, enhancement gathering, analytical requirements understanding, etc.
• Analyzing and preparing various documents like, Technical, Functional, business blueprints for reports and Automation process of data loads, etc.
• Maintaining Knowledge database and New Joiner training material, Process related material, etc.
• Tracking and updating various process related tracker to ensure client satisfaction and resource optimal utilization.
• Providing Solutions of New BW Data Model (for Business Content as well as Customized Objects) and keeping same practice across landscape with incorporating each regions business needs and consolidation of data at global level data targets.
• Worked on KT plans from onshore to offshore to increase offshore support force and to reduce the contractors’ dependencies
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Involved working with content models, attributes and measures, hierarchies.
• Monitoring and troubleshooting data loads.
• Worked on RDS to implement ETL Replication and also using Rapid Marts for SAP road map

Confidential

Responsibilities:

• Worked as an Onsite Consultant & Coordinator with the capacity of team size 7.
• BI project planning including effort estimation, resource alignment and creating an interim project plan.
• Scheduling and conducting workshops for gathering analytics requirements.
• Analyzing and preparing business blueprints for reports and Automation process of data load.
• Strategy definition for data extraction from SAP CRM and Non SAP systems (DB Connect / File System, etc.). Planning and executed the Initialization of data extraction and regularizing delta extraction and Process chain designing using new techniques available in BW 7.3.
• Solution designing of BW Data Model (for Business Content as well as Customized Objects).
• Various complex and customized reports for specific business requirements of CRM Lead management module.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Cooperated with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Build and enhanced BI objects dat include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set and Open Hub.
• Integrated BO with SAP ECC and SAP BI 7.0 to build Universes.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Hierarchies are implemented to support drill down reports.
• Customized queries using navigational attributes and filters in BEX analyzer and used customer exits as per client requirements.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Involved working with content models, attributes and measures, hierarchies.
• Monitoring and troubleshooting data loads.
• Worked on RDS to implement ETL Replication and also using Rapid Marts for SAP road map.
• Created new data source for Purchase Orders, Purchasing Requisitions, Account Assignment, and Services and extracted the data to Layer 1, Layer 2 DSOs and Cubes.
• Created a comprehensive P2P reporting solution on top if the cubes by creating MultiProviders and InfoSets, so dat user can link between Purchase Orders, Requisitions and Services with an estimated budget of 1 Million.
• Design & developed Non-SAP Delivery consumption Module using customized flat file upload programs with validation and tracking of delivered goods consumption and calculation of incentives for sales team. Used BW system for data upload and DSO and multiprovider for reporting purpose.
• Developed the P2R complex reports for auditing and monitor the business process rules. Like no posting after business hrs. posting date change document counts. Process SLA breach alert report, etc.

Confidential, Illinois

Responsibilities:

• Worked as a SAP BW/BI Consultant within a team of 15 associates.
• Onsite Offshore Coordination for Work, Management, etc.
• Understanding the business requirements and design the flow as per requirement; developing the flow as per design.
• Performed unit testing and Integration testing.
• Reporting the bugs in defect tracking system.
• Involved in Unit testing, Integration Testing, User acceptance testing etc.
• Developed BADIs, Routines in BW System.
• Extensively worked on Open Hubs and Delta load Mechanism for file output.
• Preparation of design change documents as and when required.
• Client trainings after every development module release.
• Performing role of project Defect Prevention Analyst to reduce effort and improve quality of development.

Confidential

SAP BW/BI Consultant

Responsibilities:

• Worked as a SAP BW/BI Consultant within a team of 4 associates
• Played the BI/BW Senior developer as well as the BI architect role for the complete client BW system which includes gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, Redesigning the existing models as wells as the Reporting structures, Unit testing, trouble-shooting, integration and user acceptance testing, documentation, training and maintenance.
• Worked with several users both at execute as wells as non executive levels to gather requirements and transformed them into a data model.
• Coordinating and helping the client’s developers on various BI technical as well as application aspects.
• Developed complex ABAP code in the end routines and start routines of the Transformation to satisfy the existing functions and latest business needs.
• Used the issue log on the share point to communicate the status as well as issues to the team members and business owners.
• Created various transports, collected the required objects and migrated to the target systems.
• Developed various deliverables like BBP, Functional and Technical specs, Data mapping and Data flow documents, Gap & Impact analysis documents, Step by step solution and Transport sequence.
• Applying different Delta mechanisms for SAP as well as Non SAP Systems and Data Staging from several Source Systems.

Confidential

Responsibilities:

• My Role was SAP BI/BW Onsite Module Lead on Indofil project and tasks are as below:
• Involved in System Study & Business Requirements Analysis & Documentation.
• Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart noledge on designed universes and published reports.
• Creating, enhancing, and testing of universes and reports in coordination with DBA and architects.
• Developed complex queries and reports using different data providers in the same report.
• Involved in managing full project lifecycle including: upfront requirements analysis, documentation, project plan management, user acceptance coordination, production rollout, end-user training and providing post implementation adoption management and customer service.
• Created BW Objects, Update rules and Info Packages, Data Targets and Multi providers in accordance to the application.
• Built Process Chains for Activities loads & Fact Sheet Loads
• Extensively worked on Transport requests.
• Implemented Elimination of Internal Business Volume when transactions occur in interim company warehouses.
• Business Objects: Experience in building Universes and Creating Complex and Ad-Hoc Reports using Web Intelligent and Xcelsius.
• Experience with SAP Business Objects, Xcelsius, Crystal reports, Live Office and SAP BEx Analyzer, BEx Browser, Query Designer, Web Application Designer and other reporting tools.
• Involved in the SAP BOBJ XI 4.0 ramp up
• Involved in the SAP Business objects Data services (BODS) implementation and POC and exposures to the components like Designer, Job server and Engine and Repository. Key role played in Integration of Business objects and BODS with SAP BW and POC.
• Designed and developed Universes in Business objects on various Infoproviders and presented the reports to users
• Designed and developed the process for extracting, transforming, and loading data using the SAP Business Objects Data Services into SAP BW Data targets. Transformed the data to suit to business needs. Verified and improved the quality of your source data.

Confidential

Responsibilities:

• Worked as a SAP BW Consultant within a team of 15 associates taking care of multiple modules such as PM, MM, SD, QM, PS, FI, etc.
• Interacted with the End Users, Business Analysts and responsible for Involved in training sessions.
• Developed complex queries and reports using different data providers in the same report
• Involved in managing full project lifecycle including: upfront requirements analysis, documentation, project plan management, user acceptance coordination, production rollout, end-user training and providing post implementation adoption management and customer service.
• Created BW Objects, Update rules and Info Packages, Data Targets and Multi providers in accordance to the application.
• Implemented Elimination of Internal Business Volume when transactions occur in interim company warehouses. Responsible of Unit test cases.
• Prepared Project Documentation and as well as technical documentation for End users and IT core team members.

Confidential

Responsibilities:

• Administration of SAP BI system and ETL Process Monitoring.
• Enhancement of BI Objects, Query designing, Model designing, ABAP Enhancement.
• Early Watch Report actions, Change in Full update to delta update for entire ETL process.
• Expertise in OLTP extraction from SAP R/3 using LO cockpit, FI-AR, AP, GL
• Experience in data extraction from non-SAP sources like flat files, and ORACLE 10.G by creating materialized views.
• Extensive work experience in building and designing reports using query designer, analyzer, and publishing using WAD to Enterprise portal.
• Expertise in creating and maintaining Process chains, Meta chains for Full/ Initialization / Delta data loads.
• Maintain BI statistics cubes, reports, data loads and followed performance optimization based on early watch report.
• Experience in handling tickets and providing solutions within given time frame under support environment, on various Ticketing tools like OSD, Remedy, Clarify

Confidential

Responsibilities:

• Providing support to SBS Germany and SIS Finland clients like Metso OYJ, Metso botnia, Metso minerals, Mera nova, Metso Sweden, Teboil, Outotech etc
• Involved in creating customized ODS and changing the Existing data model of an Info Cube by adding new Characteristics and Key figures.
• Worked extensively on LO Cockpit extractions, enhancing data sources, filling setup table, loading the data from R/3 to BW and used various update methods.
• Created Workbooks of different layout and style and query with selections, formula and different Variables with User Entry/Default Value, Replacement Path and Customer Exit as per customer requirement.
• Used RRI to navigate from query displaying all posting document to query displaying details about posting agent.
• Checking imported request and validating objects on production server with quality Server.
• Created navigational attributes depending on the drill down requirement of the client.
• Involved in the automated process of deletion of indexes, loading of data, recreation of indexes, rollup of data into aggregates, compression of cubes etc by designing process chains.
• Performed selective deletion, compression, rollup on cube. Validating info cube and DSO data with PSA and R/3 and finding reason for incorrect data. Actively Involved in Rectification of data Load Failure of Master Data Loads and transaction Loads.
• Well versed with full cycle of remedy ticketing tool to deal with CR and tickets opened by clients and also keeping track of all open and pending tickets with different priority.

Confidential

Developer Support

Responsibilities:

• Platform: SAP R/3 5.0 ECC
• Team Size: 4
• TCODE Used: VA43, VA03, SE80, SMARTFORMS, SO10, SE37, NACE, SE10,etc

Confidential

Developer Support

Responsibilities:

• Database: ORACLE
• Platform: SAP R/3 4.7 ECC
• Team Size: 4
• TCODE used: VA43, VA03, SE80, SMARTFORMS, SO10, SE37, NACE, SE10,etc