SUMMARY

• SAP BO/BI/HANA/BODS consultant with overall 7+ years of experience in SAP BI 7.3/7.0/3.5/3.0 and SAP BO 4.0 environment. Exposed to the functional areas of SD, MM, FI - CO and general business process of SAP-R/3.
• Expertise in Designed andimplemented SAP HANA data modelinglike; Attribute View, Analytic View, and Calculation View.
• Expertise in SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)Executed Data Extraction Transfer Loading(ETL) usingSAP Data Services4.0
• Expertise in Configuration and Development of SAP BW/BI components like Info Cubes, DSO Objects, Info Package, Data source, Info Objects, Multiproviders, infoset, Virtualprovider,
• Expertise in Data Extraction, Transformation, and Loading. (ETL), Full/Delta uploads. Update rules, Transfer rules, Events, Creating and Monitoring Errors in PSA and DTP, modifying the error records and reloading the data.
• Expertise on DSO, and Info cube administration and monitoring. DSO administration and maintenance, Performance improvement. Performing Aggregate, Compression and Process Chain.
• Expertise in job scheduling tools, and Process chains, Scheduled, Monitored and managed data loads with full update and Delta mechanism.
• Experienced on Business Content, LO Cockpit, and Generic Extractions. Uploading master data, and transactional data, both from flat files and SAP R/3, ECC Systems. Involved in identifying and activating the necessary Business Content.
• Expert on Bex query designer, Bex web analyzer, Columns, Rows, local structures restricted key figures, Variables, Exceptions, and conditions, calculated key figures, restricted key figures, Structures, Variables, Workbooks and SAP BW /BEx report development.
• Expert on reporting and using analysis tools. Performing Information Analysis in BEX Analyzer, Broadcasting. Defining BW workspaces, working with Commands. Creating Planning applications.
• Expert on Reporting with the SAP- BO. Sap Crystal Report Enterprises. Sap Crystal report, Web Intelligent, Dashboards, Sap BO Analysis - OLAP, Sap BO Analysis - Microsoft, Sap Bo Design Studio, Sap Lumira. Sap HANA views .
• Expert in advanced Features, things like Open Hub, Analysis Process Designer, and Remodeling.
• Implemented 2 full life cycle BI projects for FI/CO, SD, MM, HR modules
• Followed and implemented ASAP methodology
• An excellent team player as well as an individual contributor with good communication and interpersonal skills.

TECHNICAL SKILLS

DATABASES: MS SQL Server, MS AccessOracle, Teradata, ODBC, IBM

RELATINAL DATABASES-: SAP ERP, SAP R/3, SAP ERP 6, SAP HANA etc

OLAP DATABASES-: MS SQL Server Analysis Services 2008, 2012

HEYPERION ESSBASE: SAP HANA, SAP NETWEAVER BW 7.0,7.3,7.4, BEX QUERY BEX ANALYZER, SAP BUSINESS OBJECTS BI CLIENT TOOLS- 4.x, Web Intelligence 4.x, Sap Crystal Report 2011, Sap Crystal Report for Enterprise, Sap BO Analysis - Microsoft, Sap BO Analysis - OLAP, Sap BO Dashboards, Sap BO Design Studio, Sap Lumira, Sap BODS, SEMANTIC LAYER TECHNOLOGY, Universe Design Tool (UDT), Information Design Tool (IDT), USER INTERACTION, BI Launch Pad, Live Office

OPERATION SYSTEM: Windows 98/2000/2003/ XP/Vista, UNIX, Other Tools: MS VISIO, MS Outlook, MS Word, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, HOUSTON, TX

SAP BO/BI/ HANA/BODS DEVELOPER

Responsibilities:

• Designed andimplemented SAP HANA data modelingusingAttribute View, Analytic View, and Calculation View.
• SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)Executed Data Extraction Transfer Loading(ETL) usingSAP Data Services4.0
• Performed datamodeling and develop Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Created Universes on top of SAP HANA views using IDT(Information design tool). Create Local project, Connection, Data Foundation and Business Layer and publish the universes to the CMS repository to make resources available to the users.
• Building a Web Intelligence reports using various prompts, report filters like Equal to Operators, Not equal to Operators, greater than operator, and less than operator and etc. Using swap a row or column, Breaks defined, Sorting, Alerting, Ranking, Drill-down, Creating charts, Highlighting data using conditional formatting, Filter by measure, Ranking data, Publishing, and sharing reports to the end User.
• Creating an Sap Lumira document through all its workflows on top of SAP HANA Analytic views and Calculation views. Creating dataset from SAP HANA views in offline and online mode.
• Using SAP Lumira Data manipulation to prepare data to be able to better use it for analysis, visualization and presentation.
• Creating Sap Lumira visualizations using different number of charts in Visualize room. Creating additional calculations and apply ranks and sorts on measure, filters, Hierarchies and Navigation in Charts. Creating stories using different layout, such as interactive boards, infographics and report layout.
• Publishing and sharing the documents with other people and end users like Sap Hana, Sap Exlpoer, Sap Lumira Cloud, Sap Lumira Server, Sap BO and Microsoft Excel file.
• Creating a Business Object Dashboard on top of SAP HANA using universes (IDT). Developing a Business Objects Dashboard reports (formerly known as xcelsius) using different visual components like (charts, containers, selectors, Single values, maps, texts. Building a unique Business Object dashboard using different properties like drill down, Behavior, appearance and Alerts, and so on. Using Art background components to make a report to be unique and clear to understand. Publish and export the dashboard, into Adobe PDF, Excel, word, and Microsoft power point to the users.

Environment: SAP Business Objects 4.0, SAP HANA, SAP BODS, CSV files, flat files, Excel

Confidential, Houston, TX

Sr. SAP BO/BI Consultant

Responsibilities:

• Creating a report using BEx Query designer, defining filters, creating characteristic structures, and key figure structures, like ( Restricted key figures, calculated key figures) Creating Selections and Formulas.
• Generating reports and performing data analysis using BEx Analyzer tools, analysis toolboxes and BEx design tools, like(conditions, exceptions, and etc) Performing information analysis in Bex analyzer, like applying filters and navigation options thing like ( Back one Navigation Step and back to start, Drilldown, swap, convert to formula, Sorting and etc.
• Creating reports and performing Data analysis using SAP BusinessObject Analysis, Edition for OLAP . Things like charts, crosstab, filtering data, Sorting, Conditional Formatting, Calculations, Formatting Data, Saving and sharing workspaces(exporting, and printing Reports)and etc.
• Designed andimplemented SAP HANA data modelingusingAttribute View, Analytic View, and Calculation View.
• Using SAP LT Replication Server (SLT)Executed Data Extraction Transfer Loading(ETL) usingSAP Data Services4.0
• Performed datamodeling and develop Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in Sap HANA Studio.
• Created Universes on top of SAP HANA views using IDT(Information design tool). Create Local project, Connection, Data Foundation and Business Layer and publish the universes to the CMS repository to make resources available to the users.
• Designing Business Objects Universes. RELATIONAL Universes and OLAP resources using IDT, Things Like Local project, Session, Data Foundation and Business Layer and publish the universes to the CMS repository to make resources available to the users.
• Designing Business Object Universes using Universe Design Tool ( UDT), like Personal connection, Secured connection, Shared connection and export the universes to the CMS repository to make resources available to the users.
• Building a report based on BEx queries using the Rich Internet Application accessible from the BI launch pad and Web Intelligence Rich Client installed from the SAP Business Objects suite by using BICS connection.
• Creating a web Intelligence documents using Web interface, Rich Internet Application interface within the BI launch pad. And Web Intelligence Rich Client, a standalone interface depending with client request.
• Building a Web Intelligence reports using various prompts, report filters like Equal to Operators, Not equal to Operators, greater than operator, and less than operator and etc. Using swap a row or column, Breaks defined, Sorting, Alerting, Ranking, Drill-down, Creating charts, Highlighting data using conditional formatting, Filter by measure, Ranking data, Publishing, and sharing reports.
• Creating reports Crystal Reports Enterprises tool with Standard, Summary, Cross Tabs, grouping, Sorting, totaling data, formulas, parameters, Alerts, formatting data elements, and etc.
• Restricting the data using the Prompts and filters. Graphical reports Developed using Cross tab, PIE and BAR Charts with Drill down option using Drill down Report and also using in combining the cross tab and vertical bar charts.
• Creating a Business Object Dashboard using different data source connectivity, like Web Service query, Web service connection, Sap Netweaver Bw connection, Crystal Report Data consumer, Interface Connection, Live Office and BI consumer service BICS.
• Developing a Business Objects Dashboard reports (formerly known as xcelsius) using different visual components like (charts, containers, selectors, Single values, maps, texts.
• Building a unique Business Object dashboard using different properties like drill down, Behavior, appearance and Alerts, and so on. Using Art background components to make a report to be unique and clear to understand.
• Publish the dashboard, save spreadsheet model and visualization file, Export as e.g. Adobe PDF, Excel, word, and Microsoft power point to the users.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Report.

Environment: SAP Business Objects 4.0, BW/HANA/BODS/ CSV files, flat files, Excel Safe. Vantage ERP

Confidential, Dublin, OH

SAP BI/BO Consultant

Responsibilities:

• Involved in creating and managing of Info Areas, Info Object Catalogs, Info Objects, Application components, PSA, DSO’s, Info Cubes, DTP, Info package, transformation, Multiproviders, and Infosets.
• Activated and installed required objects from Business content.
• Worked on extracting the data using LO Extraction and Generic extraction.
• Day-to-day responsibilities include analysis of data requirements and translation of these requirements into dimensional data models.
• Involved in Production support system like Process chain monitoring and ticket handing.
• Uploading master data and transactional data both from flat files and SAP R/3 Systems.
• Monitoring and Error handling in PSA like modifying the error records and reloading the data.
• Involved in front-end BI Components like Queries, Formula, Variables, Calculated Key figures, restricted key figures, Structures, Selections, Exceptions, and Conditions Developed Queries using Filters, Restricted Key figures, Calculated Key figures and Variables for Characteristics, Key figures, Hierarchies, etc.
• Creating BW reporting using BEx Query designer, BEx Analyzer, BEx WEB Application Designer
• Involved in designing and developing the Universe and updating the existing Universes, developing canned/adhoc reports, scheduling the processes and administering the BO activities using Business Objects 4.0
• Exposure to Business Objects XI Enterprise suite using Desktop Intelligence, Designer Web Intelligence reporting.
• Creating reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, grouping, sub reports etc.
• Creating reports using Infoview with Graphical, bar pie charts, Cross Tabs, sections, breaks and publish reports also etc.
• Designing Business Objects universes, complex BOBJ reports both full client and Web Intelligence Reports.
• Develop Xcelsius (Dashboard) and Crystal Reports
• Performed the Integrity check and finally exported to the repository.
• Involved in requirements study, design reviews and analysis of input/output flow.
• Used supervisor module for disabling / enabling access to documents and access to universes.

Environment: SAP BW, BI 7.0, BO, SAP ECC 6.0, Windows 2003

Confidential, Boston, MA

SAP BI/BO Consultant

Responsibilities:

• Extensively worked in Business Information Warehouse Info Cubes, DSO Objects, Data sources, Info objects.
• Worked with PSA in monitoring the data transfer from source system into BI.
• Created Info packages and scheduled them in order to load Master and Transactional data from SAP R/3 as well as flat file source system into BI.
• Created several DSO objects which act as data staging.
• Configured Data sources in R/3 by using LO Cockpit (LBWE) initialized the setup tables.
• Involved in Data source Enhancements.
• Involved in the upgrade preparation of BW Extractors from R.3 4.7 to ECC 6.0. Checked the validity and consistency of all Extractors prior to and post upgrade.
• Involved in identifying test scenarios, i.e. extractors, process chains, user exits and programs.
• Involved in Managing of Info Cubes, which involves Info Cube Content, Performance issues like Indexes, Statistics, Compression of Info Cube and Rolling up the data to the Aggregates.
• Designed various BEx Reports using Formulas, Selections, Structures, Calculated Key Figure and Restricted Key Figure.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Involved in migration and deployment of the universes and reports acrossmultiple domains
• UsedBusiness Objects DeveloperSuite (Publisher View, CMC, Designer, and InfoView) to perform various tasks specific to every component.
• Designed and Build Universes, Classes and objects for Category Management System.
• Designed Universe by creating the Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the Objects like Dimensions, Details and Measures, which are grouped into Classes and Checked the Integrity of the Universes. Also created some universe level filters.
• Exported the universes to the repository to make resources available to the users. Created reports for various Portfolios using the Universes as the main Data Providers.
• Use of Reporter, Designer, Query Panel and Data Provider; handling of ODBC issues
• Worked on Universes, Query Panel, Prompts and Report Layout and re-formatting.
• Developed three types of reports like Graphical Reports, Data Dump Reports and formatted Reports in Web Intelligence as per the requirement from clients.

Environment: SAP BW, BI 7.0, BOBJ, SAP ECC 5, 6.0, Windows 2003