PROFESSIONAL SUMMARY:

• Over 8 years of experience working in IT Industry with good knowledge in SAP Business Warehousing/Business Intelligence, Business Objects and over 2 years of experience modelling on SAP HANA database.
• Technical expertise on BW data modelling which includes creation of complete data flow from Data Sources to Info providers, using update rules, transfer rule and transformations, loading data using Info packages and DTPs and automate the data loads using Process Chains, implement routines at different levels.
• Underwent 3 complete life cycle Implementations of BW 7.x which includes Data - Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring, LO-Cockpit, Info-cubes, Multi-Cubes, SPOs, DSO objects, InfoPackages, Transformations and DTPs, BEx- Analyzer and BEx Query.
• Experience in creating custom extractors and Generic Extractors and extensively involved in enhancing of the Data Source.
• Designed queries in BEx Query Designer and created workbooks in the BEx Analyzer using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables.
• Expert in BO Design studio, Desktop Intelligence, Web Intelligence Rich Client, Information Designer Tool/Universal Design Tool, BI Launchpad, Data Services, Dashboard Manager, Crystal Reports, Central Management Console etc.
• Good exposures in BO 4.0 & 4.1 new features like multiple data source connectivity, processing data from structured & unstructured sources, data quality & metadata assessment and transform the data to user's preferred format etc.
• Designed reports with complex sub reports, cross tabs, Drill down, formulas, functions, parameters, multiple grouping, running totals, charts, graphs, mapping, conditional formatting.
• Extensive Experience in Native Hana and Hana Studio all aspects Data modeling scenarios Attribute View, Calculation View and Analytical View.
• Deep Understanding & expertise in SAP In-Memory HANA Architecture, Column store, row store tables in SAP HANA studio.
• Extensive Experience in activities of developing schemas, importing table definitions, adding connections.
• Experience with HANA scripts while creating complex SQL views for custom based HANA applications including BO integration with SAP Native HANA.
• Developed solutions in HANA with various scenarios including multiple parameters, variables, binding parameters/variables from top to bottom and vice versa.
• Extensive experience in Production support, Data loads, Validation and troubleshooting of transaction data and Master data, Transport Management, Roles & Security, System Checks, Performance tuning and process chains.

PROFESSIONAL EXPERIENCE:

SAP BW/HANA Developer

Confidential, Seattle, WA

Environment: SAP BW 7.5

Responsibilities:

• Requirement gathering, team member and extensively contributed to HANA Modeling.
• Worked fundamentally in creating the Technical Document based on Functional Document.
• Design and development of HANA attribute, analytic and calculation view to meet reporting requirements of sales by material and sales by customer.
• Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
• Worked extensively on SLT to replicate the data from BW to native HANA.
• Demonstrated to the end user’s utilization of the HANA views in the front end tools such as Tableau and SAP Business objects - Web Intelligence.
• Loaded the Data from Different Files such as Flat Files, Spread Sheets, and XML Files etc. to SAP BW on HANA.
• Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) on the BW on HANA database Scenarios and imported them to the HANA studio tool.
• Developed various HANA Models/Views, using non SAP Source system for real time data reporting requirement in Financial Month End Closure reporting
• Design, build and deploy the provisioning of SAP data into SAP HANA platform to support real time report replacing BW extractors.
• Design, build and maintain virtual data model (SAP HANA views) using SAP HANA Studio.
• Developed Virtual Provider with BW objects upon HANA Models to use Navigational attributes and Master data related to BW Objects.
• Responsible for building different Data Models (Attributes, Analytical and Calculation Views) in SAP HANA extracting data from multiple sources.
• Developed Composite Provider to combine both data from BW & HANA and designed BEx queries upon these Composite Provider.
• Transported various HANA views to higher landscapes.
• Worked on Performance Optimizations by using Input Parameters to avoid the performance breakdowns.

SAP BW/HANA/BO Developer

Confidential, Indianapolis, IN

Environment: SAP BW 7.4

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and support the Technical Development Specifications for SAP BW database and reporting objects.
• Worked on SAP BW components, Extract Structures, LO-Cockpit, Non Logistic Data Sources, COPA, Start routines, End routines, Info Sources, Info Objects, DSO's, Info Cubes and Multi Providers.
• Worked on both standard (Lo-Cockpit) and Generic extraction to pull various R/3 Systems data. Also worked on Flat File Extraction to pull non R/3 data into BW Systems.
• Reviewed existing BW standard documentation to add some recommendations. Architecting a solution for supporting a requirement for BW/BI.
• Designed simple to complex data flows as per the requirement using most of the BI objects (Infoobjects) and infoproviders (Multiprovider, Infocube, DSO etc.). Used ABAP for transforming some of the data to support report level calculations.
• Created cubes and DSO’s objects for pharma business. Created generic data source for custom requirement and enhanced data sources as required.
• Created Technical specifications and standard modeling documents for HANA.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Created virtual info provider based on HANA models. Created WEBI report based on HANA models using IDT.

SAP BW/BI/BO Developer

Confidential, Detroit, MI

Environment: SAP BW 7.4

Responsibilities:

• My responsibilities include requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
• BI Design - Info Cubes design, Data Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Transformations, Info Packages using AWB. Proficient in Data modeling using MDM and BW extended star schema models.
• Experience in ETL i.e. Data Extraction, Data Transferring, Data Loading such as SAP BI
• BI Reporting - Implemented the Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting, Reporting Agent and Broadcaster.
• BW operations - Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load) Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.
• Performance tuning of Queries (SAP BW BEX) by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same.
• Reporting Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, RRI, and Jump queries.
• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.
• Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, transformations creation, Business Content Activation
• Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation.
• Documented functional and technical specifications for production support and project enhancements.
• Assisted in ongoing communication with BW end-users on business process and systems changes, and issues resolutions.

SAP BW/BI/BO Consultant

Confidential, Kankakee, IL

Environment: SAP BW 7.3

Responsibilities:

• Preparation of Project Plan, Functional Specifications and Technical Design Documents for Blue Print
• Extensively involved in customizing the standard BW business content to pull information from various SAP systems.
• Worked extensively on various functionalities of SAP BW like Extraction, Modeling and Reporting. Implemented Start and End routines within Transformations
• Created the required Info Sources and Info Packages to load the appropriate data via ODS and directly in the cube based on requirements.
• Loading data in real time Infocubes via flat files and input enabled queries.
• Initial work on Upgrade of SAP BI 3.5 system to SAP BI 7.3 - Project planning, pre-upgrade activities, post upgrade activities, system integrity checks, Migration of data model, Cutover Activities.
• Creating data model including cubes, DSO, and other objects. Extraction of data from legacy system.
• Developed and Customized Info Objects to match report requirements by creating variables in BEx and creating Info Cubes based on the data content. Created multiple cubes such as Demand cube, Supply Cube and Inventory cube.
• Writing ABAP code in transformations and update rules as per requirement.
• LO Extraction: Support during system copy and upgrade, stopping jobs in source system and scheduling jobs for extraction of data. Maintenance of LO data extractors of Purchasing, SD Sales, Shipping, Billing.
• Enhancement of LO data sources like 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 12 VCHDR, 2LIS 12 VCITM, 2LIS 13 VDHDR and 2LIS 13 VCITM
• Setting up and Handling of Inventory data source (2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM)
• Enhancement of BW reports and creating new ones as required by the user, writing custom exit routines in BEx query and creating CKF's and RKF's.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Crystal Reports.
• Involved in designing Universe and migrating existing Desktop Intelligence (Deski) Reports to Web Intelligence (Webi) report.
• Developing new BEx Queries and designing workbooks using BEx Analyzer.
• Creating Webi Reports in BO 3.x on top of BEx Queries.
• Worked on BEX Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to the required level of information.
• Maintaining Transport Request sequence and production support including process chain monitoring and fixing issues.

SAP BI/BW Consultant

Confidential, Findlay, OH

Environment: SAP BW 7.3

Responsibilities:

• Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Developed several queries and the workbooks using BEx Analyzer according to end users requirement for SD (billing document, deliveries, planned sales/ actual sales).
• Involved in activating the Master Data sources and loaded the master data in SD and MM.
• Created and maintained the info cubes in SD for Billing, Deliveries and Sales Orders Overview.
• Worked on Info Objects, Data Sources, ODS and Info Cubes to facilitate corporate reporting
• Worked on the extraction of data from LO cockpit-SAP R/3 to BW.
• Extensively worked in LO-Cockpit extraction of the Datasources 2LIS 02 ITM, 2LIS 13 VDHDR and others.
• Responsible for building and maintaining the Info Cubes / Info Providers, in Purchasing for Purchasing Data (0PUR C01), Vendor evaluation (0PUR C02) from the standard Business content.
• Created transfer rules, update rules and the start routines wherever required.
• Maintained and created aggregates to improve the performance.
• Extensively used BEx analyzer, created queries with variables, filters, exceptions, conditions, calculated key figures, restricted key figures.
• Also participated in cutover activity and keep track of the Transport Requests handled by different teams.
• Worked with the users for developing reports and trouble shooting in Unit Testing.
• Developed Meta Chain (Process Chains) to automate the data loads, for complete Transaction data loads & Master data loads.
• Worked on Cut-over activities and data validations and post Go-live support.

SAP BW Developer

Confidential, New Jersey

Environment: SAP BW 7.3

Responsibilities:

• Developing flows from info-objects to MultiProviders.
• Created MultiProviders, Info cubes, DSOs, transformations, DTPs in order to meet the end user reporting requirements.
• Installing Business Content Info Cubes and DSOs and used BC Data sources.
• Working on Data Extraction from SAP R/3 using Generic, LO Extractions, Data Loading (Full/Delta Upload).
• Creation of Generic Data Sources from table, view.
• Created Process Chains to automate the loading process for master and transactional data.
• Created Aggregates and used Line item dimensions to increase the performance of the query.
• Performance tuning by compressing the cubes and creating batch indexes.
• Creating Structures for reusable purpose, creating Conditions & Exceptions analyze reports.
• Created custom queries using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures and created aggregates for frequently used queries.