SUMMARY

• SAP BI consultant wif 10 year of professional experience. Currently leading SAP BI Onsite project based on enhancement wif 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 teh 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 teh 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 Creating Data Archiving Process (DAP) and using Near Line Storage (NLS) in reporting.
• Experience in teh 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 teh 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 wif excellent interactive and interpersonal skills to communicate wif team members, developers, clients and end users at all levels.
• Efficiently managed teams of various sizes and worked wif teh team to achieve company and client's goals
• Working on Design and Development of SAP Lumira Discover - An application that uses statistical and data mining algorithms to discover starting visualizations and interesting insights on any data.
• In dis role I is responsible for driving technical architecture, design, product standards, code review.
• Responsible for providing technical guidance to teh team.
• SAP Lumira delivers beautiful analytics, allowing customers to easily convey and share knowledge, discover hidden patterns and transform teh business.

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
• SAP Analytics (Predictive Analytics, Lumira )
• 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, MN

Responsibilities:

• Working as a BW lead wif teh capacity of team size 85.
• Working on HANA Views, Optimizing Data loads wif teh use of SLT and minimizing HANA space.
• Build and enhancing objects in various business areas like MTD, MTO, GTS, CRM, RTR, LEX, etc.
• Developed data flows and work flows using BODS.
• Expertise in teh 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.
• Build solution to generate reports using Open ODS and minimized teh support activities.
• BI project planning including effort estimation, resource alignment & 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.
• Created Data Archiving Process (DAP) and optimized reporting on Near Line storage (NLS).
• 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, Michigan

Responsibilities:

• Working as a BW lead wif teh 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.
• Created Data Archiving Process (DAP) and optimized reporting on Near Line storage (NLS).

Confidential, Delaware

Responsibilities:

• Worked as a BI lead wif teh 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

Responsibilities:

• Worked as a BW lead wif teh 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 teh business requirement technically as well as functionally.

Confidential

Responsibilities:

• Worked as an offshore Coordinator wif teh 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 wif 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 teh 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 wif 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 wif teh 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 teh 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 teh client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Cooperated wif teh Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Build and enhanced BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set and Open Hub.
• Integrated BO wif 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 wif 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 teh data to Layer 1, Layer 2 DSOs and Cubes.
• Created a comprehensive P2P reporting solution on top if teh cubes by creating MultiProviders and InfoSets, so that user can link between Purchase Orders, Requisitions and Services wif an estimated budget of 1 Million.
• Design & developed Non-SAP Delivery consumption Module using customized flat file upload programs wif 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 teh P2R complex reports for auditing and monitor teh business process rules. Like no posting after business hrs. posting date change document counts. Process SLA breach alert report, etc.

Confidential

Responsibilities:

• Worked as a SAP BW/BI Consultant wifin a team of 15 associates.
• Onsite Offshore Coordination for Work, Management, etc.
• Understanding teh business requirements and design teh flow as per requirement; developing teh flow as per design.
• Performed unit testing and Integration testing.
• Reporting teh 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, UK

Responsibilities:

• Worked as a SAP BW/BI Consultant wifin a team of 4 associates
• Played teh BI/BW Senior developer as well as teh BI architect role for teh complete client BW system which includes gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, Redesigning teh existing models as wells as teh Reporting structures, Unit testing, trouble-shooting, integration and user acceptance testing, documentation, training and maintenance.
• Worked wif several users both at execute as wells as non executive levels to gather requirements and transformed them into a data model.
• Coordinating and halping teh client’s developers on various BI technical as well as application aspects.
• Developed complex ABAP code in teh end routines and start routines of teh Transformation to satisfy teh existing functions and latest business needs.
• Used teh issue log on teh share point to communicate teh status as well as issues to teh team members and business owners.
• Created various transports, collected teh required objects and migrated to teh 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 wif teh End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universes and published reports.
• Creating, enhancing, and testing of universes and reports in coordination wif DBA and architects.
• Developed complex queries and reports using different data providers in teh 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 teh 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 wif 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 teh SAP BOBJ XI 4.0 ramp up
• Involved in teh SAP Business objects Data services (BODS) implementation and POC and exposures to teh components like Designer, Job server and Engine and Repository. Key role played in Integration of Business objects and BODS wif SAP BW and POC.
• Designed and developed Universes in Business objects on various Infoproviders and presented teh reports to users
• Designed and developed teh process for extracting, transforming, and loading data using teh SAP Business Objects Data Services into SAP BW Data targets. Transformed teh data to suit to business needs. Verified and improved teh quality of your source data.

Confidential

Responsibilities:

• Worked as a SAP BW Consultant wifin a team of 15 associates taking care of multiple modules such as PM, MM, SD, QM, PS, FI, etc.
• Interacted wif teh End Users, Business Analysts and responsible for Involved in training sessions.
• Developed complex queries and reports using different data providers in teh 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 teh 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 wifin 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 teh 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 teh data from R/3 to BW and used various update methods.
• Created Workbooks of different layout and style and query wif selections, formula and different Variables wif 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 wif quality Server.
• Created navigational attributes depending on teh drill down requirement of teh client.
• Involved in teh 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 wif 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 wif full cycle of remedy ticketing tool to deal wif CR and tickets opened by clients and also keeping track of all open and pending tickets wif 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 Project

Responsibilities:

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

Confidential

Developer Support Project

Responsibilities:

• Database: MS SQL 2000
• Platform: SAP R/3 5.0 ECC
• Team Size: 3
• TCODE used: VA43, SE80, SMARTFORMS, SO10, SE37, NACE, SE10,etc

Confidential

Developer Support Project

Responsibilities:

• Platform: SAP R/3 5.0 EE
• Team Size: 5
• TCODE used: VA03, SE80, SE71, SO10, SE37, NACE, SE10,etc
• Job Description: Coding for SAP script, Client Support, Creating SAP script for invoice of order