SUMMARY:

• About 9 years of BI experience as Architect/Project Lead, Software Analysis, Data Analytics, Design and Development, and Implementation of SAP HANA (Data Provision, Model and Reporting),SAP BI/BO (Webi,Design Studio,Lumira,Crystal Reports, OLAP Aanalysis), SAP BW, SAP DS, Business and Client/Server applications in Business Objects and SAP ECC - 6.0. Experience in four full life cycle implementations.
• Team player with demonstrated collaborative working relationship.
• Possesses excellent communication and interpersonal skills. Adoptive to learn new technological skills.

TECHNICAL ENVIRONMENTS:

Reporting Tools: Webi, Design Studio,Lumira,OLAP Analysis for Office, Crystal Reports, Xelsius, and Tableau.

ERP: ECC 6.0.

Data Warehousing: SAP BW 7.0, 7.3, 7.4, 7.5, SAP BI R3.x, 4.0, 4.1, 4.2, SAP HANA 1.0, 1.2, 1.3, 1.6, 1.11,1.12,2.0.

SAP BO R3.x, 4.0, 4.1, 4.2.:

ETL Tools: SAP DS and Informatica.

Database: Oracle 9/10g/11g, MYSQL and DB2.

SKILLS & ABILITIES:

• Assessing Enterprise level requirements and provide proper Architectural experience (scalability, upgradations, maintenance and optimizing), integrating (associated patches and troubleshooting) and applying a sustainable Enterprise wide BI reporting framework and solutions.
• Full lifecycle implementation and upgradations in SAP Business Objects 4.2/4.1/XI4.0/XIR3/XIR2/6.X. Scaling up the business model with appropriate BI tools.
• Setting up administrative and users roles/security (local, LDAP or Enterprise accounts), monitoring performance in different environments (DEV,UAT and PRD) according to the SAP BO best practices. Including tuning and optimizing the servers, user footprint, user reports and universes using Central Management Console (CMC), Central Management Service (CMS) and Report Conversion Tool.
• Building complex Universes and Reports with multiple databases (Data Providers) and experience in development, testing and implementation. Expert in building and designing Universes based on user requirement and converting the existing. unv universe to .unx format. Experience in Dimensional Data Modeling (Star Schema).
• Extensive knowledge of Data services and Informatica Power Center to set up automated jobs for ETL purposes.
• Expert in Identification of Business & Data requirements as well as converting them into conceptual & logical data models.
• Mentoring and maintaining feedback from the business user with proper documentation and allocating proper roles to the BI team.
• Experience in Creating and maintaining Repositories, Folders, Groups, Users and Assigning privileges to users.
• Specialized in creating complex query reports using Oracle, SQL Server, MS Access and various RDBMS.
• Created and Maintained complex universes that supporting multiple levels of hierarchies for drill down and drill across reports.
• Extensive knowledge in developing Webi Reports with multiple data sources including OLAP cubes, BEx queries and relational data.
• Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting).
• Experienced in data migration using SAP BO Data Services & SLT replication methods.
• Expert in creation of Analytical and Attribute Views and complex models by using SQL script in Calculation Views.
• Involved in creation of calculated attributes, measures, restricted measures, calculated columns, filters, hierarchies, variables, in-put parameters to satisfy reporting requirements using SAP HANA studio.
• Created Analytical Privileges and Procedures for modeling.
• Developed data flows and work flow using BODS to implement ETL Replication.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer
• Configuring SAP HANA with SAP BO Semantic Layer and MS products (Excel, Analysis).
• Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
• Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter, currency conversion.
• Performed BW functionality and BEx functionality testing for post migration process of HANA. Interacted with the Finance Business Analysts on a daily basis for their KPI & report requirements. Managed, Configured and Performed Transports between multiple BW environments.
• Created Queries, and Reports using SAP BEx Query Designer, BEx Report Designer, BEx Analyzer (Business Explorer analyzer).
• Data Staging & Loading experience with proper data architecture best practices, info packages, delta functionality, flexible master data staging, and debugging loads using the Data Monitor.
• Performance tuning of Queries by maintaining aggregates, indexes, statistics and compression on InfoCube.
• Developed Web Interfaces using Web Application Builder and published in Enterprise Portal.
• BEx Reporting - Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, and Web application designer.
• Working knowledge in creating and using the BW components like Info Objects, data sources, PSA (Persistence staging layer), info sources and Info Cubes.
• Expert in setting up local and central repository for testing, development and production environment.
• Designed, developed and implemented solutions with data warehouse, ETL process, data analysis, and BI reporting technologies.
• Managed the central and local repositories using the Management console and Repository Manager.
• Implementing data cleansing, data transformation, stored procedures/triggers and necessary test plans to ensure successful ETL process.
• Scheduled automated test objects such as jobs, workflow, and dataflow both by import/export directly and backing up/ debugging in central repository.
• Hands on experience with any debugging issues.

PROFESSIONAL EXPERIENCE:

SAP BI/HANA Lead Consultant

Confidential

Responsibilities:

• Define highly complex business problems by meeting with clients to observe and understand current processes and the issues related to those processes.
• Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
• Developed data flows and work flow using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
• Provide proper step by step documentation for development team and train the in house team with day to day monitoring and development.
• Provide architectural insight for strategic planning of design, develop, and maintaining universes with SAP BO.
• Develop detailed tasks and project plans by analyzing project scope and milestones for highly complex projects in order to ensure product is delivered in a timely fashion according to software lifecycle standards.
• Direct lower level staff by reviewing tasks and milestones for adherence to quality of deliverables.
• Coordinate with business analyst to set up a technical functional design document for the said project.
• Establish all the necessary connection and obtain the data model from the DBA.
• Build the universe according to the specification and publish it to out to various environment for testing.
• Build associated report with various BI suite tools to meet the requirements.

SAP BI Lead Consultant

Confidential

Responsibilities:

• Assessing client needs to plan, implement and providing POC for the client with scope of BI implementation and architectural setup.
• Worked on planning, designing, developing, distributing and maintaining Universes with SAP BO.
• Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
• Developed data flows and work flow using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
• Provide proper step by step documentation for development team and train the in house team with day to day monitoring and development.
• Provide remote support for any trouble shooting.
• Adapting and fine tuning responsible servers according to the client usage.
• Setting up appropriate connection and server access for the BI suite.
• Setting up right and user security for the existing SAP user and new users. Importing secure shell security information via BW environment.
• Acquire and evaluate new business requirement to design a new universe using information design tool.
• Monitor and diagnose the load bearing issues with the BOBJ servers from the daily publications and reports failures.
• Plan and implement reporting data mart, real-time data strategy, reporting universe
• Provide proper step by step documentation for development team and train the in house team with day to day monitoring and development.
• Provide remote support for any trouble shooting.

Environment: SAP HANA, Business Objects suite 4.1 (WEBI, Crystal reports,Tableaue and Design studio), SAP BW 7.5, BEx query designer, Information design tool, Oracle-11 G.

SAP BO/BI/BW/DS Consultant

Confidential

Responsibilities:

• Performed BW functionality and BEx functionality testing for post migration process of HANA. Interacted with the Finance Business Analysts on a daily basis for their KPI & Webi report requirements. Managed, Configured and Performed Transports between multiple BW environments.
• Created multiple BEx queries from the BW environment to provide daily KPI Webi reports to management. Support BEx query metadata with respect to any assigned restrictions and access.
• Troubleshoot and ease the data transition for any hierarchical and variable issues arising from the BEx as data source in a Webi Report.
• Worked on various kinds of Performance Tuning techniques such as compression, aggregates and rollups for BEx queries.
• Build all the required Webi query on BEx query with defined hierarchical queries, associates scaling factors and associates nodes with the BEx queries. There by reducing multiple errors in the Webi reports.
• Applying report patches, upgrades and work around methods to solve any #errors associates with data sync from BEx query and Webi Queries.
• Monitor and diagnose the load bearing issues with the BOBJ servers from the daily publications and reports failures. There by fine tuning all the Webi and Crystal Reports.
• Structure and reorganize the administrative tasks by setting up master accounts, master/slave setup for the user rights and access, trigger based scheduled reports and publications. Thereby reducing the foot print by half and load on the production environment.
• Stabilize the BOBJ 4.1/4.0 reporting environment from daily publication and report failures.
• Plan and implement reporting data mart, real-time data strategy, reporting universe.
• Responsible for designing and delivering fully automated data sets via nightly jobs using SAP DS (ETL), Oracle Procedures and MYSQL jobs.
• Update older BOBJ 4.0 system to BOBJ 4.1 version and added 2 more windows based BOBJ 4.1 environments and calibrated the servers accordingly.
• Migrate older (in use) BOBJ 3.1 universe onto BOBJ 4.0 environment to support daily business needs until daily reports were stabilized.
• Developing strategy to move existing data feeds and stabilize the BOBJ 4.0 Universe due to numerous errors from ODBC connection issues, cartesian errors and improper joins.
• Successfully created large-scale 5 tier universe (snowflake schema) based on business model presented by the client. Incorporating appropriate SAP schema designs and architecture. The data source included the data sets, aggregate tables and views created in Oracle DB from MYSQL DB.
• Standardize all the dimension and measure for the ease of knowledge transfer to the business. Evidently ruling out the compatibility issues with multiple data sources.
• Tested and migrated the new universe from development environment to production environment.
• Tested, Scheduled and maintained SAP DS trigger jobs on daily basis to support business critical report.
• Troubleshoot issues such as inactive dimension, measure, syntax errors and incompatible joins.
• Work with SAP engineers to troubleshoot product defects effectively and upgrade to the required patch or support packages.
• Custom development of Webi and Crystal Reports.
• Designed and implemented scheduled jobs and dataflow structure for optimized batch load performance by setting up different throttles and BOBJ events for publications and reports.
• Assigning universal fail safe alerts for data loading and data validation process for the nightly jobs and reports. This helped with the transparency of the work with the team members, accountability and ease of knowledge transfer.
• Leading the deprecation process of SAP BOBJ 4.0 without affecting daily business need and salvaging data sets for smooth transition process.
• In the process of updating and documenting entire Software Development Lifecycle for the applications created.

Environment: Business Objects Enterprise 4.1/XI4.0/XI3.2 (Designer, WEBI, Crystal reports, Dashboard Designer), FICO,SD,SAP BW 7.5,BEx query designer, Information design tool, Universe design tool, Oracle-11 G, MYSQL, SAP Data Services.

SAP HANA Developer

Confidential, Cincinnati

Responsibilities:

• Created multiple OLAP connections to access the BW data via BICS connections.
• Set up the interface with CMC and BEx query in the information design tool.
• Created multiple queries in BEx Analyzer. Fine-tuned them for performance analysis to set up in SAP HANA.
• Subject matter expert in SAP BW components like Info Cubes, Multi providers, Info Source, Info Objects, Update Rules and Transfer Rules, Which Includes Data Modeling.
• Reporting Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions and Conditions.
• Performance tuning of Queries (BEx and Webi) by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same. Developed reports using different performance variables such as filter and prompts for better report functionality and quicker response time.
• Provided guidance and advice to SAP Customers, Pre-sales and Solution Architect resources on the development of HANA solutions.
• Translated business requirements and high level designs into a suitable technical design using HANA.
• Determined the size and scope of technical developments for HANA projects.
• Identified the skills, roles and capabilities required to deliver the technical elements of projects and estimated the required effort.
• Leveraged knowledge of data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
• Excellent Skills in Data services in design, creation, and implementation of jobs, work flows, data flows, scripts. As well as performing simple and complex transforms in dataflow using different data integrator, platform and data quality transforms.
• Configured Data services with HANA loaded metadata and created jobs, work flow, data flow by using data designer and scheduled the jobs to load data to HANA.
• Worked on creating Attribute Views, Analytic Views & Calculation Views.
• Expert in understanding of the complete Architecture (Database, Data loading, Data modeling & Administration)
• Configured SAP HANA Studio by adding/exporting/importing/start and stop the systems.
• Configure and monitoring overall performance, disk space, memory usage, traces and alerts with system monitor.
• In-depth knowledge and hands-on experience of HANA security/user setup configuration like creating users, grant roles to the users and adding privileges.
• Loading data into table definitions, suspending data loads, resuming data loads. Copying contents delivered by SAP.
• Exported and imported contents across different environments.
• Performed UNION & INTERSECTION between views to represent business cases.
• Configured Excel and BODS-4.0 to HANA for reporting
• Connected to IMCE from Reporting tools through Universe and direct interfaces to generate the reports
• Created & designed Universe for reporting from Information models
• Provided knowledge transfer to IT staff.
• Developed and foster a collaborative working relationship with clients.
• Worked collaboratively with project managers, SAP Offshore Consultants and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.

Environment: SAP HANA-1.0, Business Objects Enterprise XI4.0/XI3.1 (Designer, WEBI), SAP BW 7.0,BEx Analysis,BEx query designer,Information design tool, SLT replication Server, Oracle-11 G, Rational Clear Quest, Introscope, SVN.

SAP BO consultant

Confidential, Virginia

Responsibilities:

• Involved in planning sessions with project managers to analyze requirements and outline the solution.
• Performed Architect roles like Design, Development and Implementation.
• Involved in full life cycle of Business Objects Implementation.
• Involved in configuration of BW Objects like Info Cubes, Info Sources, Data Source, and Data Store Objects.
• Worked on BEx Query Designer, Calculated and Restricted Key figures, Exceptions and Conditions.
• Built the Universes as per the requirements by identifying the required tables.
• Developed Complex Reports using WEBI against OLAP Universes.
• Developed Complex Reports using Crystal Reports against SAP and non-SAP databases.
• Developed Complex Interactive Dashboards using Xcelsius.
• Developed Complex Reports such as Sub Reports, Drill Down, Drill Up, Shared Variables and Multiple Data Sources using Crystal Reports.
• Developed Interactive Dash Boards with Line, Bar, Combination Charts, Selectors for What-If Analysis.
• Created new Events, Folders, Profiles, Users and Groups in CMC.
• Created Custom Calendars, Events in CMC and Scheduled Reports based on Events and Calendars.
• Provided Security to Folders, Universes and Reports according to the User rights.
• Defined Custom Hierarchies in Universe Designer as per the business rule for the reports to be viewed at selected reporting level.

Environment: SAP Business Objects Enterprise XI4.0/XI3.1 (Designer, WEBI), SAP BI 7.0, Information design tool, Crystal Reports, Xcelsius, SQL Server 2008, Oracle-10 G, BEx (Analyzer, Browser), Rational Clear Quest.