SUMMARY

• Overall 10 years of experience in IT. 6+ years of professional experience as SAP BW/BO Consultant. 1+year of professional experience in SAP/HANA Consultant.
• Experience in implementations for different modules in Business objects Solutions XI 3.1/ BI 4.1and in SAP Business warehouse 7.0/7.3 which involves Gap analysis, Blue Printing, Realization, Production support, Testing, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Data loading and Reporting.
• Expertise in Universe and Information Design Tool (IDT), Web Intelligence, Crystal Report, and Xcelsius Dashboard Design for development. Data Provisioning to HANA all methods.
• Extensive Knowledge and experience in developing HANA Modeling Information models in Big DATA Solution HANA 1.0 SP8 including HANA Cloud.
• HANA1.0 - HANAand BW integration via SAP BODS
• Used various transformations like Map Operation, Case, Table Comparison, Row-Generation
• Validation, Data Integrator Transforms, Query History Generation, Key Generation etc.
• Pivot and Query. Used Currency Conversion all scenarios
• Map Operation, Date Generation, Row Generations
• Source and Target based ABC, SCD Type I, II,III
• Build dataflow, workflows, variables, and customized functions in BODS Projects.
• Use of Data Services Workbench for ETL needs
• SLT Real Time Replication for all Scenarios
• Extensively worked with CMC to migrated objects packages into QA and Production environments.
• Migrated content, security and structures from Business Objects XIR2 version to XIR3.
• Heavily used Attribute views, Analytical views, column store/row store tables, analytical privileges, data provisioning, delivery units, HANA SQL Script, Calculationviews, CE Functions (CE COLUMN TABLE,CE JOIN,CE PROJECTION,CE OLAP VIEW,CE JOIN VIEW,CE CALC VIEW,CE CALC,CE LEFT OUTER JOIN,CE RIGHT OUTER JOIN,CE AGGRAGATION).
• Generation of time data and Hierarchies, Tables, Procedures, Table type table, Sequence, Decision tables, Calculated column, Restricted column
• Created complex reports using Web Intelligence tool and distributed reports to various levels of users.
• Experience using SQL/PL SQL for analyzing reports, testing and improving the performance of the reports.
• Created different types of reports such as Standard, Crosstab, Drilldown, Sub Reports, and Hyperlink reports, Dashboards, Label Reports and Chart Reports for the end users.
• Created Webi reports on FI, Copa, and Operational data extracted from ECC to the BI7.0.
• Installed SAP HANA studio, SAP Hana client and SAP Hana client for Microsoft Excel.
• Performed data extraction on direct extractor connection (DXC), SAP data services, SAP landscape transformation.views, analytical Privileges, Column store views and performed SQL coding to push data into data base intensively. Used Smart Data Access.
• Extensively worked with SQL Script language to perform read only procedures for calculation views.
• Extensively worked with SAP HANA modeler studio with data provisioning, various views and SAP
• Hana information composer to upload customer flat file data into SAP Hana database.
• Configured SAP Hana data provisioning for replication with SAP source systems and non- SAP source systems.
• Configured SAP landscape transformation (SLT) to perform real time data replication from SAP source systems. SAP Data services (DS) to replicate data from non sap source systems. Direct
• Extractor connection (DXC) to replicate for standalone Hana business scenarios.
• Extensively used Crystal Report tool functionalities for the reporting needs (Custom formulas, running totals, Custom suppress, Drill down group Level, shared and global variables).
• Created complex reports using stored procedures and database views.
• Strong experience with Multi-Dimensional, Star Schema and Snow Flake Schema Data Models.
• Experience with Data Warehouse Concepts, Methodologies and SDLC.
• Extensively worked on creating complex workspace and analysis of data using OLAP reporting tool Voyager.
• Expert in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test (UAT) and data accuracy test.
• Have good hands on experience in ETL and Data Cleansing applications using SAP BODS, Informatica 9.0.1 Power Center, Oracle Warehouse Builder and PL/SQL.
• Experience in Analysis, Design, Development and Implementation of Business Intelligence tools such as SAP BO XI R3.1 Universe Designer, Web Intelligence Reporting, and Crystal Report 2008.
• Specialize in migration to SAP BO XI R4.0 Universe Information Design Tool (IDT), Web Intelligence Reporting, SAP Dashboard 4.0 (Xcelsius) and Crystal Report 2011.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Experience in working with new tools in BO4.1 Design Studio 1.2 and Lumira.
• Extensive experience in building Universes, and retrieving data using Universes.
• Expert in creating complex and sophisticated reports using Web Intelligence, Crystal Reports that had multiple data providers, drilldown, slice and dice features using Business Objects.
• Experience in creating Dashboards using Xcelsius 2008 and SAP Dashboard 4.0 using Live Office, QaaWS, and IDT for measuring KPI.
• Involvement in gathering business data requirements, analysis and understanding database to create robust semantic layers.
• Experience in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Strong knowledge of Data Warehousing concepts, Dimensional Modeling, Operational Data Store (ODS) and Data Mart.
• Extensively worked in designing and configuring back-end components including InfoObjects, Datasources, Transformations, Data Transfer Process (DTP), Hierarchies, Infosources, Update Rules, Transfer Rules, InfoSets, Infopackages, Infocubes, DSO's( Standard, Write Optimized, Direct update), Multiproviders and Process Chains.
• Proficient in ETL activities like Data Extraction, Loading (Full/ Delta upload) and Data Modeling and proficient in data extraction from SAP R/3 SD, MM, PP, PM, FI-CO and COPA.
• Extensively used Open Hub Service to extract data out of BW and feed downstream systems to support Legacy System reporting needs. Creating and scheduling process chains for data loading process.
• Improved data load and query performance by using Aggregates, Compression, Partitioning, Indexes and optimizing Data packet size. Evaluated statistical performance using BW Statistics for optimization.
• Expertise in working with BEx in building Queries. Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, RRI, Cell editors, and Customer Exit Variables for developing custom reports.
• Proficient in ETL activities like Data Extraction, Loading (Full/Delta upload) and Data modeling and proficient in data extraction using LO Cockpit and Generic Extractors.
• Heavily used Attribute views, Analytical views, column store/row store tables, analytical privileges, data provisioning, delivery units, HANA SQL Script, Calculationviews, CE Functions Generation of time data and Hierarchies, Tables, Procedures, Table type table, Sequence, Decision tables, Calculated column, Restricted column. Data Provisioning to HANA through SLT, DXC and SAPBODS.

TECHNICAL SKILLS

REPORTING TOOLS: BexAnalyser, Report Designer, Query Designer, WAD, Crystal Reports 2011, BO XI 3.1, Crystal Reports for Enterprise, Web Intelligence, Xcelcius, Dashboards 4.0,Design Studio 4.0,Lumira,BO Explorer

DATA WAREHOUSE: BI 7.3, BI 7.0, BW 3.5, HANA 1.0

LANGUAGES: SQL, HANA SQL SCRIPTS, PL/SQL

ERP PACKAGES: SAP ECC 6.0, 5.0, R/3 4.7, R/3 4.6

BUSINESS AREAS: MM, SD, PM, FI-CO

ETL TOOLS: BODS 3.x/4.0/4.1, INFORMATICA 9.0.1

RDBMS: SQL SERVER 2005, 2008, MS-ACCESS, ORACLE, HANA 1.0

PROFESSIONAL EXPERIENCE

Confidential

SAP BODS SME/HANA Consultant

Responsibilities:

• For Deltek Project Design and configure SAP-BODS solution that satisfies the business performance, functional, and technical requirements in support of Reporting Confidential needs, including: Design and configure an SAP-based advanced reporting/analytics solution that satisfies the business performance, functional Carry out the necessary planning activities to prepare the project including developing System blueprints.Work with the DataBus team to define the data migration plan for importing Securied Confidential Federal and non-Federal Finacial data into the HANA platform.
• Work with the DataBus in preparing, cleansing and loading data into the HANA environment and to define the Blueprint for Data Integration into HANA.
• Created new Subscriptions for Deltek Publication on DataBus to retrieve the Data Source.
• Define the Analytic Model required for Confidential Business Intelligence and Analytics.
• Design and build ETL jobs for loading NON-SAP data into HANA.
• Ensure delivered designs are scalable to meet future business development.
• Set up, and Test the Analytic Model required for Deltek project.
• Define and build the HANA views required for reporting Verify that the HANA database is properly populated with Deltek data.

Confidential

SAP BODS SME/HANA Consultant

Responsibilities:

• Design and configure SAP-BODS solution that satisfies the business performance, functional, and technical requirements in support of NCIRD needs, including: Design and configure an SAP-based advanced reporting/analytics solution that satisfies the business performance, functional, and technical requirements in support of NCIRD advanced reporting and analytic needs. Carry out the necessary planning activities to prepare the project including developing System blueprints.Work with the ABC team to define the data migration plan for importing ABC data into the HANA platform.
• Work with the ABC team in preparing, cleansing and loading data into the HANA environment and to define the Blueprint for Data Integration into HANA.
• Define the Analytic Model required for ABC Business Intelligence and Analytics.
• Design and build ETL jobs for loading NON-SAP data into HANA.
• Ensure delivered designs are scalable to meet future business development.
• Set up, and Test the Analytic Model required for ABC.
• Define and build the HANA views required for reporting Verify that the HANA database is properly populated with ABC data.

Confidential

BO/HANA Consultant

Responsibilities:

• Participated as a team member in discussion with business analyst and end user for Data Modeling, Business Content, Granularity, and Performance Tuning.
• Used LO-Cockpit extract structures (add extract structures) and data sources to extract data in SD and MM to facilitate the data to SAP BW.
• Worked extensively on administrator workbench (RSA1).
• Built DSO, InfoCube, Used ABAP routines to modify Transformations rules according to user requirements and also enhanced Info Objects that are mapped to Communication Structures
• Created Aggregates and Indexes and used Number Range Buffering for InfoCubes to improve performance.
• Generated standard and customized reports using BEx Query Designer.
• Published reports on web using Web Application Designer.
• Developed flexible queries using filters, exceptions, navigational attributes, to facilitate data analysis in drill down or in a summarized way to give detailed levels of information.
• Established BICS interface between SAP BW to BO 4.0 Environment.
• Web Intelligence reports included the utilization of master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Reports were created so that the users have the option of selecting prompt values from the prompts themselves or from the user input controls.
• Designed enterprise SAP Dashboard 4.1 using combination of Information Design Tool (IDT) and Live Office connectivity.
• Designed SAP Dashboards using analytics such as combo box, charts, list box
• Created users’ user group, folder security using central management control (CMC). Setting up row level/object level security at universe level.
• Trained the business users in using Lumira for self-service way reporting.
• Trained the users to get them familiar to Business Objects in order to help them run the system on their own.
• Involved in System Integration Testing (SIT)

Environment: SAP ECC 6.0, SAP BI 7.3, ABAP/4, Bex Analyzer, Query Designer, and Web Application Designer, SAP Business Objects 4.1 (Universe Design Tool, Information Design Tool (IDT), Web Intelligence report, Dashboard Design (Xcelsius), Live Office).

Confidential

IT Consultant

Responsibilities:

• Responsible for design, development and extraction from ECC Source system and flat files to BW for SD, MM, FI&CO.
• Designed the data flow for Service Level - Purchase Order Quantities and Purchase Orders
• Involved in developing Custom defined Infocubes as per the requirements
• Managed and monitored data loads with full upload and delta mechanism.
• Worked on developing Bex queries using Query designer 3.x.
• Established BICS connection interface between SAP BW to BO 4.0 and involved in creating Webi Reports and Dashboards 4.0
• Generated reports involving complex queries, sub queries, Unions and Intersection.
• Web Intelligence reports included the utilization of master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Experience in SAP BO 4.0 Universe Information Design Tool (IDT), Web Intelligence Reporting, SAP Dashboard 4.0 (Xcelsius) and Crystal Report 2011.
• Performed configuration of Business Objects 4.0. Involved in adding new group/user, assigning universe access to users.
• Designed enterprise SAP Dashboard 4.0 using combination of Information Design Tool (IDT) and Live Office connectivity.
• Trained the users to get them familiar to Business Objects in order to help them run the system on their own.
• Involved in System Integration Testing (SIT)
• Involved in meetings with business users in order to gather business requirements and prepared business blue print based on those requirements.
• Created summarized reports which includes display of Plan/Actual variance measures, analysis of full cost by cost center, overdue analysis, and analysis of payment history.

Environment: SAP ECC 6.0, SAP BI 7.0, ABAP/4, Bex Analyzer, Query Designer, and Web Application Designer, SAP Business Objects 4.0 (Universe Design Tool, Information Design Tool (IDT), Web Intelligence report, Dashboard Design (Xcelsius), Live Office).

Confidential, NY

SAP BW/BO Consultant

Responsibilities:

• Gathered requirements from functional users in Sales and Purchasing for cross-functional analysis.
• Configured and extracted data from the LO Cockpit extractors, SAP Inventory management by making use of the SAP defined data sources like 2LIS 03 BF, 2LIS 03 BX and 2LIS 03 UM
• Designed data model and transformations based on the business requirements
• Development of data model to satisfy the various functional requirements by implementing queries and cubes using business content. The main cubes developed are, Delivery Service (0SD C04), Purchasing Data (0PUR C01) and Vendor Evaluation (0PUR C02).
• Configured and customized Logistics Cockpit, LO Extractors and extracted LO structures like sales order, purchase order into corresponding BI content.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Universal Design: Universe planning building and implementation, design methodology, development cycle Creating Classes, Objects, schema, store procedures.
• Web Intelligence: Created Advance multiple Reports, Ad hoc query, tables, charts, Complex Filters customized formulas and highly formatted page layouts.
• Xcelsius: Creating chart with visualizing data range, Series, interactive model, map with graphics, Query as a Web Service.
• Crystal Reports: Planned, created formatted reports, multiple groups, Integration with SAP Data Source, manipulation formulas, applying conditions and exporting reports to Excel and Word.
• Deployed BO Reports/Dashboards in SAP Enterprise Portal.
• Connecting BOBJ using SAP and Oracle for reporting.
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.
• Used Structures, Calculated key figures, restricted key figures, selection, Formula, exception and conditions.
• Resolved Query Performance issues using transactions such as RSRT and RSRTRACE.
• Involved in entire System Upgrade and migrated data sources from BW 3.5 to 7.0.

Environment: SAP ECC 6.0, SAP BW 3.5,SAP BI 7.0, ABAP/4, Bex Analyzer, Query Designer, and Web Application Designer, SAP Business Objects 4.0 (Universe Design Tool, Information Design Tool (IDT), Web Intelligence report, Dashboard Design (Xcelsius), Live Office).

Confidential

SAP BW/BO Developer

Responsibilities:

• Involved in activating Business Content for Standard InfoObjects, InfoSources, InfoCubes related to Sales & Distribution, Material Management.
• Used the Business Content Sales Overview InfoCube 0SD CO3, for overall Sales Analysis. The transaction data is loaded from different Source Systems using the Info Sources 2LlS 01 S260 Sales Order, 2LlS 01 S261 Delivery, 2LlS 01 S262 for Billing Document and 2LIS 01 S263 for Sales Order/Delivery using LO-Cock Pit.
• Actively involved in Monitoring Data Transfers from Source Systems into BW using PSA
• Extracted data from MM modules and uploaded the data into the procurement cubes via 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL and activated the appropriate Business Content cube
• Customizations - Data source enhancement of business content cube by appending structure, User Exits and Customized Delta built up for the data sources
• Build Transactional and Master Process Chains for periodic upload of data.
• Performance tuning of Queries by maintaining Aggregates, Compression, rollup of InfoCubes.
• Involved in the Performance Tuning of InfoCubes and Query reporting.
• Designed and developed the Universe and updating the existing Universes, developing canned/ad hoc reports, scheduling the processes and administering the BO activities using Business Objects BOXI 3.0
• Modified several existing Bex. Reports to improve performance. To improve the performance of the reports reorganized the Dimensions. Provided Line Item dimensions and proposed the aggregates.
• Experienced in working with Business Explorer (Bex) and publishing the reports on web using Web Reporting tools.

Environment: SAP ECC 6.0, SAP BI 7.0, BW 3.5, SEM, SD, MM, PP, FI, BPS, ABAP/4, Bex Analyzer, Query Designer, and Web Application Designer, SQL 2008, SAP Business Objects XI R3.1 (Universe Design Tool, Web Intelligence report, QaaWS), Xcelsius 2008, Crystal Report 2008

Confidential

IT Developer

Responsibilities:

• Gathered requirements from functional users in Sales and Purchasing for cross-functional analysis.
• Coordinated with users to gather requirements and information on their needs.
• Created and set up Universes and established a Business Objects environment.
• Created classes, sub classes, objects, conditioned objects, cascaded LOVs, prompts and queries for business analysis and report generation.
• Specified the Joins, checked the cardinalities and resolved loops by either using Alias or Contexts.
• Generated reports involving complex queries, sub queries, Unions and Intersection.
• Web Intelligence reports included the utilization of master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Involved in report migration from Crystal Reports XI R2 to Crystal Reports 2008 in development. Troubleshoot the migration issue and report enhancement for better performance.
• Performed installation and configuration of Business Objects XI R2. Involved in adding new group/user, assigning universe access to users.
• Partially involved with a team in data mart designing.
• Utilized an ETL tool such as Data Integrator XI R2 package to design simple to complex mapping with different database store and file format.
• Performed System Integration Testing (SIT) and coordinated User Acceptance Testing (UAT) by preparing tests scripts for both.

Environment: Oracle 9/10g, SAP Business Objects XI R2.0 (Universe Design Tool, Web Intelligence report), Crystal Report XI R2, Crystal Report 2008, Data Integrator XI R2, Microsoft Office Excel.

Confidential, NYC

ETL Testing Analyst

Responsibilities:

• Created InfoPackages and scheduled the data into the data targets. Data Load management - Creation of Process chains, scheduling jobs.
• Production Support- Extensive experience in support, Data loads, Validation and trouble shooting of Transaction data and Master data, Change management, Transport Management, Performance tuning and process chains.Support, Optimization and revamping of scheduling and monitoring the system.
• Performed Unit and Regression testing. Performed Integrity tests and data consistency was verified with ECC 6.0.
• Analyzed business and technical requirements and developedTest Plan and Test Strategydocuments forFunctional and Performance testingof eachSAPapplication.
• Responsible forSAPFI/CO, RTCfunctional and regression testing (Profitability Analysis, Account Receivables, Account Payable, General Ledger, Cost Center Accounting, Inventory- Material movements, Revaluation, Invoice verification, and Batch stocks).
• Designed Defect management process utilizing Quality Center and provided analysis of the results, reporting issues/problems via defect reports and status reports.
• Worked and trained others to useadvancedQC component.
• Provided Process documentation, which includes data flow and how to guides to end users for post-production support.

Environment: SAP R/3 5.0, SAP BW 3.5, SD, MM, PP, FI, PCA, SCM, BEx Analyzer, Query Designer, Report Designer, Web Application Designer