SUMMARY:

• Over 2 years of experience in SAP HANA1.0 data modeling with SAP HANA Studio for creation of Attribute View, Analytic View, and Calculation View. Executed 2 full life - cycle implementations in SAP HANA1.0.
• Experience with Data Provisioning from SAP ECC, SAP BW and non-SAP sources via SLT, BODS and DXC.
• Knowledge of HANA security including User Management, Roles and Privileges.
• Strong experience in Business Objects (BO) 4.0/XI 3.1 including Central Management Console (CMC). Worked on migration of the Business Objects from lower versions to XI R2, 3.0, 3.1.
• Strong experience in Business Objects data services/Integrator XI/3.2/4.0 (BODS).
• Built Universes and Created Reports using WebI, Live Office, Xcelsius, and Crystal Report.
• Experience in developing Dashboards and Scorecard using Dashboard manager to effectively represent KPI’s and visually accentuate critical business controls based on the Customer needs.
• Expertise in creating reports with features like Drill down, Slice and Dice, Ranking, Alerts, Section and Grouping. Hands-on in broadcasting/publishing reports to the Enterprise Portals, Portal integration and Web Analyzer.
• Over 7 years of experience in SAP BI 3.5x/7.0 having worked on extractions from SAP and non-SAP sources, developing SAP BW Objects, Extended Star Schema modeling; used expert knowledge of data warehousing concepts. Managed historical data from heterogeneous sources like MSOffice, flat file, Oracle, SQL Server, DB2.
• Thorough knowledge of data warehousing principles including data modeling, extract / transform / load, job scheduling, indexing, OLAP processing, defining and using aggregates based on queries and execution plans.
• Experience in Creation of BEx queries on BI 3.5x/7.0 (Reporting).
• Good understanding of business process flow in SAP Modules like SD, MM, PP, FI/CO modules.
• Developed reports in the FI/CO modules with concentration in GL Accounts (both AP/AR).
• Knowledge on User-Exits, BADI, Work flows, BAPI, ALE and IDOC to enhance standard SAP functionality.
• Experience with SAP BW administration using the BW Administrator Workbench, installing Standard Business Content objects, Customizing Business Content objects, Custom data warehouse development, managing ETL jobs, automation of BW jobs, Process Chains Creation & Maintenance, troubleshooting failed processes.
• Thorough understanding of installation, configuration and customization of BW objects including Info Cubes, DSO, Multitudes, Info Objects, Info Sources, Info Packages, Transfer Rules, Update Rules, Process Chains, ETL jobs, Data sources, DTP, Transformations, Real-Time Data Acquisition, BEx Analyzer, Web application designer.
• Extractions: LO, FI, CO-PA, Master data extraction, Generic Extraction, Delta management, Business Content (Installation & Enhancement), extraction using DB connect.
• Hands on experience in Production Support including Process Chains maintenance, Data load monitoring and fixing the failed loads. Work experience on data cleansing & modeling, and performance tuning and aggregates.
• Experienced with Microsoft Office, HTML5, ASP.

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Environment: SAP HANA, WebI, SAP BW

SAP HANA Consultant

Responsibilities:

• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Created Summary and Aggregation tables based on functional requirement specifications.
• Created Dimensional Data Models from Operational Data Sources.
• Developed Jobs, Workflows and Data Flows according to specifications and implemented their business logic.
• Developed Data Flows for dimensionand fact tables, and loaded the data into targets in Data Warehouse.
• Created scheduled batch jobs for processing flat files, XML files, XSD, DTD's as source as well as Target.
• Made use of global variables, Local Variables and Parameters between Work flow and Data flow as per business requirements.
• Created Web intelligent reports on the relation universe which was created using Information Design Tool (IDT).
• Built Cross Table, Column and Stacked Charts according to functional requirement provided by business users.
• Created report filters in the UDT (Universe Design Tool) to improve WebI report performance.
• Worked on Performance tuning of WebI and BEx reports by using Query Stripping, BI Indexes, BI statistics, Aggregates, and Partitioning of Info cube.
• Daily monitoring and maintenance of SAP HANA nodes in the production and in the development environments.

Confidential, Plano, TX

Environment: SAP HANA, ECC

SAP HANA Consultant

Responsibilities:

• Decided on extract strategy for new development in the HANA landscape.
• Selected applications (cubes and DSOs) targeted for HANA Optimization.
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development.
• Designed, developed and debugged Information Models (Attribute, Analytic and Calculation Views) to model data for reporting team.
• Designed and Debugged ETL process to extract data from Sources systems (SQL Server, XML and Flat Files).
• Transform as per business requirements and load the data intoSAP HANAdatabase using SAP BODS and SLT.
• Developed Attribute, Analytic and Calculation views for Sales, Inventory and Finance tables replicated from ECC to HANA via SLT.
• Analytic View for GL accounting to build a WebI report for FAGL data.
• Calculation view for Stock Overview to build a BO Explorer for Inventory Stock overview.
• Analytic view for Sales Order Analysis to build multiple WebI reports and dashboard for Open Sales Order analysis.
• Developed multiple attribute views for use in analytic views to avoid using physical tables and improve performance.

Confidential, Naperville, IL

Environment: SAP HANA, ECC, BI 7.3, BO 4.0, Microsoft SQL 2008

SAP BW/HANA Consultant

Responsibilities:

• Using SAP Business Object data services 4.0, replicated data from both ECC and the Flat files into the SPA HANA.
• Also used trigger base SLT replication for ECC initial load and replication of ECC data.
• Created Attribute views, Analytical views, and Calculation views.
• Created IDT (Information Design Tool) connection to build WebI reports on top of BEx Queries through BICS
• Created Analytical privileges to control the data for the various business requirements.
• Applied security and administration by creating the users and roles for the organizational level visibility.
• Worked on Smithfield Foods Healthcare SQL database migration into SAP BW System using FTP Process.
• Designed Flat file Data sources, DSO and Info cubes for Medco and Catamaran Data Providers.
• Recognized Master data and Transaction data flows which are coming from single Flat file.
• Created authorization relevant info objects to setup security design for all Smithfield Foods IOC (Independent of Companies) and imported all the way to Business Objects system.
• Worked on Performance tuning of WebI and BEx reports by using Query Stripping, BI Indexes, BI statistics, Aggregates, Partitioning of Info cube and also OLAP based Cache.
• Built BEx queries based on reporting needs utilizing CKFs, RKFs and variable selection functionalities.
• Created IDT (Information Design Tool) connection to build WebI reports on top of BEx Queries through BICS.

Confidential

Environment: SAP HANA, SAP BW 7.3/7.0, SAP BO, SAP-R/3

SAP BW Developer

Responsibilities:

• Design and maintenance of Info objects, Info Cubes, DSO, Multiproviders and Infosets in SAP Netweaver BW 7.3.
• Design of Queries using restricted key figures, calculated key figures, Variables, Filter, Free Characteristics.
• Creation of workbooks and web reports.
• Unit Testing.
• SAP HANA data modeling with HANA Studio for creation of Attribute View, Analytic View, and Calculation View.
• Extraction of data from Excel, external database, SAP BW, and SAP ECC to HANA Data Base.
• SAP ECC table data model and analysis.
• Involved in replication of data from the database to SAP HANA using SAP Business Objects Data Services.
• Selection of POC queries.
• Created Procedures; Table types and used them in defining procedures.
• Created reports using Webi for interactive analysis, formatted reports for enterprise reporting using Crystal Reports.
• Created BEx reports for search and exploration.
• Created reports with SAP BO using OLAP tools.

Confidential, Santa Clara, CA

Environment: ECC 6.0, NWP, SAP BW 7.0, SAP BO 4.0

BW BOBJ Developer

Responsibilities:

• Project involving development of the Dashboards and loading the data into the various info providers for the requirement and generating the BEx Queries.
• Integrated with the team and end-users to get to understand the Business requirements.
• Primary duties included production support for different SAP applications.
• Involved in the development and Configuration of SAP Business Intelligence, SAP HANA and SAP Solution Manager.
• Designed E2E forecasting process using BPC.
• Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports. Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.
• Involved in creation of Reports, Formatting reports, generation of charts, as per user requirements.
• Developed Xcelsius presentations/visualizations for profitability Analysis, Distributor Sales Analysis, Monthly Sales Analysis, Forecasted Sales What if Analysis.
• Created web services that include the details of the vendor balance report and the customer payments, profit and loss statements.
• Developed dashboards which get the complete details of the sales info for the client to analyze the scenario and a stimulation model for the projected sales for the various products.
• Enhanced LO Structure to include additional fields using user exits
• Developed ODS object to load Sales Order Data using the LO structures
• Activated Sale cubes, purchasing cubes from Business Content
• Tested developed objects before sending to production
• Developed queries against the Info cubes and ODS objects using BEx Analyzer and ad-hoc reporting.
• Have used different reporting tools - data reports, active reports, and crystal reports in generating complex reports.
• Involved in Weekend, Month End and Year End Support.
• Involved in Open Hub, DBCONNECT and BPS.
• Created aggregates on various cubes to improve the queries performance.
• Created Start routines, Transfer Routines and Update rules to meet various functionalities.
• Supported Existing FI& PA Applications.
• Worked closely with BASIS team on configuration issues, OSS notes and works around.

Confidential, New York, NY

Environment: SAP BI 7.0 (NW2004s), BW 3.5

SAP BI Consultant

Responsibilities:

• Involved in the business requirements (Reports and Data Analyses) gathering exercise (Business Blueprint phase). Also helped team to distinguish between SAP R/3 Reports and BW Reports.
• Assisted team in using ASAP methodology for all phases of BI implementation.
• Modeled and developed custom DSOs, info cubes and multi cube in order to fulfill the business requirements.
• Involved in creating Info cubes, DSOs, Multi providers, Info sets, Info sources, Info packages, Update rules, Queries, Info spokes, and Process Chains.
• Created reports in WebI Rich Client as per Business requirements.
• Created trend reports with charts and drill down on charts.
• Query development in BEx Query Designer with filters, free characteristics, formulas, selections (restricting), reusable objects like calculated (CKF)/restricted (RKF) key figures, conditions, exceptions, cells calculation, variables and display in BEx Analyzer/ Report Designer.

Confidential, Canton, OH

Environment: SAP R/3 4.6, BW 3.1c, 3.5, BEx Analyzer

SAP BW Consultant

Responsibilities:

• Actively involved in the complete life cycle implementation of SAP BW.
• Involved extensively in developing the project plan, in blue printing the statement of works for the different sources, documenting the Info provider manual.
• Implemented ODS, infoproviders and multi-providers to support sales analysis reporting requirements.
• Developed process chains to automate the initialization and delta updating of all data.
• Created source system and datasources to extract historical data from flat file.
• Worked in the design of physical and logical data modeling.
• Created master data Info Sources for uploading master data and hierarchies.
• Created and activated FI cubes, activated and customized profit centre accounting cubes, accounts payable cubes and accounts receivable cubes, designed star schema structures for customized cubes and published management cockpit information reports with web interfacing.
• Actively involved in Data source enhancements, generic extractors, user Exits and customized delta built up for the data sources, V3 Updates, controlled by pull/push principle from OLAP system.
• Worked extensively on generic extraction in COPA.
• Created Extract Structure, Transfer Structure, Replication of Data Sources. Actively involved in ETL activities like Transfer Rules for Communication structure and later by defining Update rules.
• Enhanced the Info cubes by adding custom Info Objects to reflect modified R3 business process. Created several custom info Sources & Info Objects in BW and mapped them with R/3 fields using transfer rules and extractors.
• Actively involved in extracting required data from the Data Source of PSA to ODS.
• Used BEx Analyzer to build queries, queries with maps and charts, and worksheets to access BW data targets.
• Defined and modeled queries to satisfy business analysis.

Confidential, NJ

SAP BI BO Consultant

Responsibilities:

• Gathering/assessing of business requirements (functional specifications and technical specifications) and designing star schema for the requirements for operational & analytical reports in FI, CRM etc.
• Working on BI 7.0 Data Warehousing Workbench: designing functional/physical data model, backend configuration, testing, cutover/go-live planning, production support of Info Objects, Info Cubes, Data-Store Objects (DSO/ODS), Multi providers, Info sets, Open Hub Services, Info spokes and Process Chains.
• Developed Multi Dimension Models by consolidating business objects (BO).
• Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into staging area.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports.
• Extracting master data / transactional data in BI landscape (data from both SAP R/3 and external source systems) with customs extractors, modifications/ enhancement (user-exit) of business content extractors, generic extractors, and master data extractors, transformation rules (ABAP/4 routines), transports and process chains.
• Reconciled and validated data targets like Info cubes and ODS objects with R/3 and BW data analysis.
• Developing complex queries in BEx Analyzer and publishing the queries to Enterprise Portal.
• Query development in BEx Query Designer with filters, free characteristics, formulas, selections (restricting), reusable objects like calculated (CKF)/ restricted (RKF) key figures, conditions, exceptions, cells calculation, variables and display in BEx Analyzer/ Report Designer.