SUMMARY:

• Over 9+ years of SAP BW& BI/BO and Good knowledge in SAP HANA and part of implementation and Support.
• Having very good logical skills suitable for process design, development & implementation.
• Having good knowledge in Extraction, Modeling, Reporting, and Performance Tuning.
• Involved in developing Info objects, Transformations, DTP’s, DSO’s, and Info cubes.
• Involved in maintenance and creation of SAP BW/BI objects as per Business requirements
• Having good knowledge in SAP HANA
• Extensively worked on creation and monitoring of the process chains.
• Extensively worked on Ticket handling and solving the errors.
• Hands on Experience and Technical Proficiency in Data Extraction, Data Loading, Delta Management, Data Modeling, Info objects, DSO Object (Standard and Write - optimized), Info Cube, Multi-Providers and Infosets and BEx Analyzer.
• Having Experience on (SAP-BOBJ) creating the Xcelsius reports, Crystal Reports and Webi with the help of SAP BW Query and SAP ERP using BW and publish the reports in business objects.
• Expertise in working with Lo-Cockpit extraction and Generic extraction using with Tables and Views.
• Extensively worked on Lo and Non-Lo Data Source Enhancements.
• Managing data loading with both full update and delta management, also scheduling and monitoring.
• Involved in solving performance-related issues for query performance and data loading performance by using indexes, compression, aggregates, partitioning the Info Cube
• Using ABAP Routine and Functional module and Data Source Enhancement Variables.

SAP HANA:

• Having good knowledge in SAP HANA
• Having good knowledge in SAP HANA Studio.
• Having good knowledge in SAP HANA data models (Attribute view, Analytic view, calculated view, Schema, Tables), Procedures using SQL scripting.
• Having good knowledge in Creating Calculated Attributes
• Having good knowledge in extraction of data from Excel, External data base, SAP BW, SAP ECC, and SAP LANDSCAPE TRANSFORMATION (SLT) to HANA Data Base.
• Having good knowledge in Creating and executing Data Service Job in SAP BODS to populate HANA.
• Having good knowledge in Data Transportation.
• Experienced in Creating new Classes and Objects in the Universe based on Functional Specifications, Universes, Resolving Loops, Traps and Testing the Universe.
• Experienced in creating Derived Tables according to end user requirements.
• Well versed in all phases of BI project including Planning, Estimation, Solution, Requirement gathering, Design, Development, Enhancement, Testing and Maintenance activities.
• Ability to meet the deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Keen analytical skills with great attention to details, evaluating projects, reviewing data flow, data validation, problem identification and resolution.
• Highly organized mentor, able to quickly assess needs and provide tools to resolve difficulties, enhance learning and improve performance.

TECHNICAL EXPERIENCE:

ERP: SAP -BI 7.0, SAP- BW 3.5, SAP- R/3 & SAP ECC 6.0.

Documentation Tools: MS-Office Products (MS-PowerPoint, MS-Word, MS-Excel)

Operating Systems: Windows 98/NT/7/Vista and XP

Reporting Tool: BEx Explorer, BOXI 3.1,R2 (Xcelsius, Crystal, Webi), Power BI, Tableau 8.0.20

Data warehouse Concepts: OLAP, Multidimensional Data Modeling, Star-Schema, Snowflake Schema

Languages: C, C#

ETL tools: SSIS, BO Data Integrator.

Databases: SQL Server 2008/2012/2016 and MS-Access

WORK EXPERIENCE:

Confidential, Charlotte, NC

SAP BI/ BO Technical Consultant

Environment: Environment: SAP BI 7.0, SAP ECC 6.0

Responsibilities:

• Involved in Supporting & Maintenance of Project modules.
• Modified and maintained Universes using Designer module to include objects like Dimensions, Details and Measures according to the Functional Specifications.
• Created new objects and classes in the Universe based on the report creation requirements.
• Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity.
• Resolved data mismatch issues that are raised from end users.
• Created Web Intelligence Documents by writing SQL Queries for Derived tables in the universe as per the Functional Specifications.
• Worked with functional consultant for mapping the source data (R3/non R3) to target Data Sources in BI.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Developed various Charts, Graphs and drill down reports in Webi.
• Created bar charts, pie charts and exported them to power point, PDF and presented them in user meetings.
• Created custom info objects, characteristics and key figures. Involved in creation of custom Info areas, Info Cubes.
• Worked on creating conditions, filters, ranking in Webi reports.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alert, Variables, Formulas, Filters, Sorts, Query prompt, Hyperlinks in Webi.
• Created a backup of WEBI Reports and Universes in BIAR format using Import Wizard.
• Extensively used Toad and Query Analyzer to verify if the data pulled by the report is correct compared to the database data.
• Involved in Report bursting for Personalizing and distributing documents using CMC.
• Created various dashboards using XCelsius and Crystal Reports.
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing.
• Monitoring of the process chains and analyzing the reasons for the frequent failures of the processes.

Confidential, Providence, RI

SAP BI/ BO Technical Consultant

Environment: SAPBI 7.0, SAP ECC 6.0.

Responsibilities:

• Extensively used Designer to design universes for different business groups.
• Extensively involved in extraction of data by customizing predefined extract structures (LO Cockpit) and Generic Data Sources.
• In Logistic Extraction Cockpit: Maintained extract structures for CRM and Sales & Distribution.
• Created classes, aliases, simple reports using cascading prompts as per Functional specifications.
• Created Info Objects, Info Sources, ODS objects, Info Cubes, Multi Providers, Info Sets, Update rules, and Transfer rules.
• Good Knowledge on queued delta, un-serialized and direct delta methods, loaded the data from R/3 to BW.
• Involved in extracting data from SAP R/3 by generating Generic Data Sources (Tables/Views).
• Used joins concept by taking different tables from different data sources in the Universe.
• Used the formatting options like cross tab representation, sections, breaks, data sort Options, font, colors.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Extensively created Business Objects reports like charts and tables.
• Implemented row and object level security in business objects universe Designer.
• Performed unit testing of the reports.
• Involved in extensive testing of universes and reports during version migration of business objects.
• Used slice and Dice, Drill Down, Drill Up, Prompt filters, Cascading list of values etc.
• Implemented Row & Object level security for different user groups as per the Functional Specifications.

Confidential, Dublin, OH

Business Objects Report Developer

Environment: Business Objects 5.1 Oracle8i, MS SQL and Windows 2000.

Responsibilities:

• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Gathering requirements and writing specifications for Business Objects reports.
• Used alerts, filters, sorts (custom and inbuilt) and rankings in the reports
• Used multiple data providers such as universes and personal data files in generating reports.
• Involved in migration and deployment of the universes and reports across multiple domains
• Resolving loops using contexts and aliases. Implemented row level and object level security.
• Created reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc.
• Used supervisor module for disabling /enabling access resources.
• Created and scheduled full client reports and Webi reports with Broadcast Agent Server.

Confidential, Houston, TX

Business Objects/ETL Designer

Environment: Business Objects 5.1 Oracle8i, UNIX and Windows 2000.

Responsibilities:

• Installing Informatica Server and Informatica PowerMart Client 5.0 and configuration.
• Installing Business Objects 5.x ZABO and Web Intelligence 2.5.
• Collected User requirement for mappings and functionality.
• Designed Data Mappings, implemented Transformations like Expression, Rank, Lookup, Sequence, Source Qualifier,
• Router and Aggregator etc to load data from staging area to DW.
• Created Universe with 90 Classes, more than 900 objects using inner/outer and equiv. joins as per requirement.
• Designing multiple Universes for user Reporting.
• Resolved loops using Contexts and Aliases. Tested the integrity of the Universe.
• Linked different Universes, which are from multidimensional data sources.
• Created conditional objects and used Universe level security restrictions.
• Exported the Universe to the Repository to make resources available to the users.
• Created the reports from various Universes using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulas etc.
• Retrieving and Publishing documents from and to corporate repository.
• Scheduling the documents and distributing the Documents through Broadcast Agent Server.

Confidential

Business Objects/ Universe Designer

Environment: MS SQL server 2005, Business Objects XI R2

Responsibilities:

• Analysis of the specifications provided by the client, Understanding the business.
• Build the new universe as per the user requirement by identifying the required tables from the Data mart and by defining the universe connections.
• Used derived tables to create the universe for best performance and used contexts and aliases to resolve the loops in the universe.
• Involved in development of complex reports using methods like Slice and Dice, Drill Down, Cross Tab, Master Details and Formulas.
• Creating User Prompts, Conditions and filters to improve the report generation.
• Creating Hierarchies from providing drill down options for the end user.
• Involving communication with users, Managers and business analyst for understanding the business logic and database.
• Created the standard reports to get the complete underlying information for further analysis.