Sr. Consultant

Location:

Chicago, IL

Posted:

April 06, 2017

Contact this candidate

Resume:

Suresh Teegala Mobile: 224-***-****

SAP HANA/BI/BW Sr. Consultant email: **************@*****.***

Career Summary

Having Dynamic 11+ years of experience in project designing, development and deploying solutions using SAP BI/BW & SAP BO Reporting Tools.

Worked in SPS10 of SAP HANA Live for Modeling Views and Virtual Data model.

Experienced in using CE functions, SQL, PL/SQL, Procedures, decision tables in SAP HANA.

Good exposure with data replication to SAP HANA using DXC, SLT, BODS, Flat files and Smart Data Access (SDA) in HANA environment

Expertise in using SAP HANA Studio Modeling Views and developed complex Information Models.

Converted HANA views to BW as Transient Provider & Virtual Providers and changed BW models to HANA Optimized Models and providing the best modelling solutions with front end Reporting.

Experienced in SAP BI/BW (BW 7.4, BW 7.3, BI 7.0, BW 3.5), SAP BO (4.0) and SAP HANA 1.x

Creating Artifacts- packages, attribute views, analytic views, calculation views Analytic Privileges, Procedures, Functions, Sequences, Views, Synonyms, Triggers, Decision tables, CE Functions.

Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Migration of HANA views to BW and import of BW Info providers to SAP HANA and providing the best modelling solution.

Replicated data from ECC to HANA using SLT based table Data Provisioning and also performed operations like, Load, Replicate, Stop, Suspend and Resume as part of Data Provisioning

Strong knowledge of Extraction, Transformation and Loading (ETL) processes.

Worked on SAP HANA Roles to Users, Developers, managing schemas, import/export content.

Extensively worked on SAP HANA Analytical privileges, granting access and restrictions to users on various views within the data modeling.

Objects Transportation using LCM is done using delivery Unit for Package container at SAP HANA.

Expertise in BW Modeling Objects to HANA Optimized Models at BW 7.4 and created Composite Providers, Virtual Providers, Transient Providers & designed BO Reports as per Customer Needs.

Used SAP BODS to extract data from SAP ECC and Relational Databases to load it to SAP HANA using different Transformation Techniques.

Extensively worked on Extraction which involves Extracting the data from R/3 to BW by using Generic Extractors for FI-CO & SD Models.

Month end closing activities – settlement of CO-OM data, immediate data corrections & data refresh.

Creation and Realignment of COPA data source based on operating concern.

Extensively involved in setting up the procedures for extracting the data from ECC by using the LO COCKPIT and GENERIC extractors.

Created and maintenance of Info Objects, DSO, Cubes, Transformations, DTP, Datasources.

Created and maintained queries in BEx Query Designer and BEx Web Application Designer for analysis and web reporting respectively which are published in Enterprise Portal

Involved in prioritized tickets regarding extractions, performance issues and load failures. Analyzed and corrected production problems as they occur in the SAP BI

Successfully scheduled repair full loads for master data attributes and master data texts whenever new attributes or texts enhanced.

Scheduled data loads from SAP R/3 to BW, Monitored data loads which are running hourly, daily, weekly & monthly basis and solving errors when errors occurred.

Developed and modified end routines for extracting data using extractors and data targets as per customer requirements.

Strong skills in BW related ABAP for bringing data from different extractors and Data targets.

Designed queries using BEx Analyzer Reporting tool for data presentation.

Handling on reconciliation issues by checking the data between R/3 and BW systems.

Working on process chains to automate the Deleting indexes in Infocube, Process Infopackages, creating indexes, DSO activation, further updating, PSA request deletion & Attribute change run.

Involving in Unit testing, Integration testing, Regression testing and User acceptance tests.

Regularly involved in Load monitoring of daily, weekly & monthly Data Loads using Process chains.

Developed queries for overhead management and profitability analysis and integrated in Workbooks.

Involved in understanding the functional concepts of cost centers, orders, WBS elements, Income statement which helps to handle the reconciliation issues from R/3 to BW.

Developed Adhoc reports using BO Explorer & Dashboard Designing tool.

Worked on Designing dashboards using Web services & Live Office connections to generate dashboards for Live Data.

Worked with multiple charts i.e. pie chart, bar chart, straight table, Radar chart, Gauge chart, pivot table & different functions in Explorer

Worked on SAP BO 4.0, designed, development and managed Universes in Information designing tool (IDT) which include creation of data foundation, business layer based on adhoc requirements which caters several business units.

Used Life cycle manager tool for taking back up's and for transporting across the environments. Used Promotion Management Tool to migrate Universe & Reports from DEV to QA to PROD

Scheduled various reports on a weekly and monthly basis and sent the output to users. Developed WEBI, Crystal and Xcelsius Dashboard's using LIVE Office, QAAWS.

Fine tuning of the performance issues by handling the indexes, aggregates and compression

In case of data load failures, involved in analyzing the errors, and took corrective actions

New company connections for Cost centers, Income statement and for month end reports.

Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded to targets.

Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain good team work.

Quick learner and good team player with strong interpersonal and communication skills.

Academic Profile

B.Tech (Bachelor of Technology from Engineering), 2001, JNTU, HYDERABAD.

Technical Skills

Operating Systems : Windows XP/ Windows 7/ NT/ and UNIX.

ERP : SAP R/ 3 4.7, ECC 6.0

Databases : SAP HANA, SQL & Oracle

Data warehousing And ETL : SAP BW 3.5, BI 7.0, BI 7.3, SAP BI 7.4

Programming Language : ABAP Basics-Specific to BW, SQL and CE Functions.

Reporting Tools : SAP Business Objects Crystal Reports, WEBI, SAP Lumira, SAP

BO Analysis Office, Dash Boards & BEx Reporting. SAP Business

Objects BI4.1/ BI4.0/ XIR3.1, Information design Tool (IDT),

Universe Design Tool, WEBI, WEBI Rich Client, Explorer, SQL

Server 2008, UNIX, SQL, PL/SQL

Projects

# 1.

Project Eagle

Client

CF Industries, IL.

Role

SAP BI/BW Sr. Consultant

Duration

Oct 2015 to Mar 2017

Environment

SAP BW 7.4, SAP 7.3, SAP Business Objects Crystal Reports, WEBI, BO Analysis Office, Dash Boards & BEx Reporting. SAP Business Objects BI4.1/ BI4.0/ XIR3.1, Information design Tool (IDT), Universe Design Tool, WEBI, WEBI Rich Client, Explorer, SQL Server 2008.

Details:

CF Industries, a global leader in nitrogen fertilizer manufacturing and distribution, owns and operated world scale nitrogen complexes and serves agricultural and industrial customers through its best-in-class distribution system. Transforming natural gas into nitrogen, helping feed the crops that feed the world and supporting a cleaner and healthier future.

Products UAN/Ammonia/Granular Urea/Ammonium Nitrate and Located in US/Canada/UK.

Responsibilities:

Built New Custom Extractors for Shipment & Suspense Deliveries as per user requirement and built complete data flows between ECC and BW and Built BEx & WEBI Reports.

Shipment is used for the physical ship date that must be within the ship start and ship end date range on the contract line for the orders that is referring.

Developed semantic partitioning objects (SPO), and utilized HANA functionality to optimize the InfoCubes, and utilized memory capabilities to take advantage of HANA views- analytical, calculated, and attribute using SAP BW and SAP HANA.

Knowledge & experienced in VDM (Virtual Data model) and created Calculation views on Private Views, Reuse Views and Query Views on transactional and master data tables of SAP Business Suite.

Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.

Data Provision Techniques for HANA used DXC, SLT, BODS, Flat files and Smart Data Access.

Experienced in working with all the new feature of SAP Net Weaver BW 7.3 and SAP BW 7.4 powered by SAP HANA, with all integration scenarios of BW and HANA.

Involved in full cycle of migrating SAP BW on HANA database, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.

Published HANA Models into BW as Transient Providers, Composite Providers and Migrated of BW Info Cubes and DSOs to HANA optimized Models.

Expertise in production support issues which involved debugging ABAP Routines, Process Chains Monitoring, Data source Enhancement, Remote Cubes, Multicubes, fixing errors and daily ETL Data load (Full/Delta upload) Monitoring of the BW jobs and designed Process chains for Daily, Weekly, Bi-Monthly and Monthly data loads.

Developed custom enhancements, editing functional modules, and developing start routines, end routines, conversion routines and lookup from other targets for data transformation.

Using delivery unit collected Packages (which contains Attribute Views, Analytic Views and Calculation Views) Procedures and transported from D-Q-P using Admin role.

Suspense Deliveries will be done via an interactive screen where the records in suspense with the error condition will be displayed with other relevant information to help the users take actions to resolve the suspense and allow the record to PGI successfully.

Worked on Audit Control Reports in analysing the issues when there is difference in data between ECC and BW data in some of the reports like Billing, Sales Conditions and deliveries.

CHARM Solution Manager Tool is used for Transporting of objects from Dev Test QA PROD.

Application Life Cycle Manager Ticketing tool is used to log issues by the user for Support activities.

Expert in designing and developing of Modelling, Extraction & Reporting like standard and custom InfoCubes, Infoobjects, Transformation, Infopackage, DTP’s, DSO, Datasource, Characteristics, Keyfigures, Multiproviders, Enhancement of extractors, Business content Installations, Creating Process chains, Semantic Partition, Objects, Composite Providers, Data Flows & Query-designing.

Developed new enhancements for including the fields to the extractors as per user requirement

Logic change in End Routines for looking up the fields from one target to different targets as per customer need in BW.

Worked on User Exit Programs in BEx queries for populating time periods as per user requirement.

# 2.

Data One

Client

Bayer, Pittsburgh, PA.

Role

SAP BO & BW Consultant

Duration

May 2013 to Sept 2015

Environment

SAP BW 7.3, SAP BW 3.5, SAP Business Objects Crystal Reports, WEBI, BO Analysis Office, BEx Reporting. SAP Business Objects BI4.1/ BI4.0/ XIR3.1, Information design Tool (IDT), Universe Design Tool, WEBI, Explorer, SQL Server 2008, UNIX, SQL, PL/SQL.

Responsibilities:

Has extensively worked with Accelerated SAP Methodology in Implementation, Designing, Development, Roll-out, Upgrade, Enhancements and Supporting.

Worked extensively on Business Explorer Suite tools. SAP BO Analysis Office, BEx Query Designer, BEx Web Application Designer, BEx Analyzer & BEx Web Analyzer.

Involved in escalating prioritized tickets regarding extractions, performance issues and load failures. Analyzed and corrected production problems as they occur in the SAP BI

New company connections for Cost centers, Income statement and for month end reports.

Extensively worked on Extraction which involves Extracting the data from R/3 to BW by using Generic, Application Module Extractors.

Developed queries for overhead management and profitability analysis and integrated the queries.

Involved in understanding the functional concepts of cost centers, orders, WBS elements, Income statement which helps to handle the reconciliation issues from R/3 to BW.

Monitoring of whole system like of BIA indexes, checking reporting indicator, checking RFC connections, checking the reporting indicator.

Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded to targets.

Working on process chains to automate Deleting indexes in Infocube, Process of info packages, creating indexes, DSO activation, further updating, PSA request deletion and Attribute change run

Experienced in SAP Business Objects Administration, CMC, Deployment, Life Cycle Manager

Proficient in all phases of the Software Development Lifecycle(SDLC) including Requirements gathering, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.

Strong experience in building universes on Star schema & Snowflake Schemas. Resolved loops by using Aliases & Contexts, Shortcut joins.

Worked on SAP BO 4.0, designed, developed and managed Universes in Information designing tool (IDT) which include creating data foundation, business layer based on adhoc requirement which caters several business units.

Worked with Crystal reports for Enterprise building structure reports against Universe based on IDT.

Used Life cycle manager tool for taking back up's and for transporting across the environments.

Migrated Universes .UNV (previous versions) to .UNX from 4.0

Designed, developed and managed Universes in Business Objects Designer for generating the, reports for marketing, partnership and customer support application business users.

In Web Intelligence, developed wide variety of advanced and complex reports using functionalities like, Cross Tabs, Forms, Tables, Sections, Breaks, Sorts, Ranking, Prompts, Drill-Up, Drill-Down, Drill-Across, Drill-By, Charts, Formatting Cells and Blocks, Conditional formatting using Alerts, Formulas, Variables, Functions, Report Filters, Combined Queries, Sub Queries, Merged Dimensions

Scheduled various reports on a weekly and monthly basis and sent the output to users. Developing WEBI, Crystal and Xcelsius Dashboard's using LIVE Office, QAAWS.

Created Crystal Reports using Crystal reports formulas, Grouping, Parameters, Hyperlinks, Sub Reports, Running Totals and Hierarchies to handle the end user requests.

# 3

SAP BI Support

Client

VALLOUREC STAR, Youngstown, Ohio, OH

Role

SAP BW/BI & BO Consultant

Duration

Sep 2012 to Apr 2013

Environment

SAP Business Objects Crystal Reports, WEBI, SAP Lumira, BO Analysis Office,

Dash Boards & BEx Reporting. SAP Business Objects BI4.1/ BI4.0/ XIR3.1, Information design Tool (IDT), Universe Design Tool, WEBI, WEBI Rich Client, Explorer, SQL Server 2008, UNIX, SQL, PL/SQL.

Responsibilities:

Interacted with Client frequently understanding the requirement for creating various types of reports.

Monitoring of info packages and analyzing the reasons for frequent failures of info packages

Developed load strategy and created process chains to schedule the loads on daily, weekly & monthly

Involved in setting up the procedures for extracting the data from ECC by using the LO COCKPIT and GENERIC extractions

Experience in data modeling using different types of attributes, standard and custom Info Cubes, Infoobjects, InfoSources, DSO, Multiproviders, Datasources, Transformations and routines.

Creation of BEx queries from Query designer and Creating workbooks using BEx Analyzer and Extensively Worked on SAP BO-Analysis Office.

Handling of new enhancements as per client requirements.

Experience in SAP Solution manager to create Change request and transport objects.

Co-ordination with Data Load Monitoring, Basis and other Functional teams to solve the loading, dump and functional related issues.

Worked on various kinds of reports in Crystal. Mailing Labels, Cross tab (Grid value functions), On-demand Reports, sub reports, Charts, Reports using Universe, Reports using Stored Procedure, Reports using open document URL's, Reports using Business Views, Crystal with embedded SWF files. Formatting issues related to export to excel

Designed and Developed Webi Reports like Crosstab reports, Tabbed reports, Synchronizing queries using merged dimensions, Charts

Generated WEBI Reports using the Universe as the main Data provider and also using the personal data files provided by the users

Created Crystal Reports using Crystal reports formulas, Grouping, Parameters, Hyperlinks, Sub Reports, Running Totals and Hierarchies to handle the end user

Extensively worked on Performance issues like Indexes, Statistics, Compression of Info Cube and rolling up the Data to the Aggregates.

Preparation of Test scenarios and Test case Documents for Unit, Integration and User acceptance testing before and after transporting of Objects into Production system.

# 4

SAP BW Support

Client

John Deere, HQ. Moline, IL

Role

SAP BI & BO Consultant

Duration

Nov 2011 to Aug 2012

Environment

SAP ECC 6.0, SAP BI 7.0, and SAP BW 3.5. SAP Business Objects Crystal Reports, WEBI, Dash Boards & BEx Reporting. Universe Design Tool (UDT), WEBI, WEBI Rich Client, Explorer, SQL Server 2008, UNIX, SQL, PL/SQL.

Responsibilities:

Created Generic Data sources using Tables and Views for extracting Master and Text Data.

Created and maintained queries in BEx Query Designer and BEx Web Application Designer for analysis and web reporting respectively which are published in Enterprise Portal

Successfully scheduled repair full loads for master data attributes and master data texts whenever new attributes or texts enhanced.

Fine tuning of the performance issues by handling the indexes, aggregates and compression

Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain good team work.

New company connections for Cost centers, Income statement and for month end reports.

Created and customized the COPA data source using operating concern and replicated the Datasource to SAP BW and loaded the transaction data to the data targets.

Experience on analyzing the Cost centers and income statement reports.

Involved in understanding the functional concepts of cost centers, orders, WBS elements, Income statement which helps to handle the reconciliation issues from R/3 to BW.

Monitoring of whole system like of BIA indexes, checking reporting indicator, checking RFC connections, checking the reporting indicator.

Data Flow migration from BW 3.5 to BI 7.X

Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded to targets.

Involved in postponement of transaction data whenever there is a master data load failure.

Scheduled data loads from SAP R/3 to BW, Monitored data loads which are running hourly, daily, weekly & monthly basis and solving errors when errors occurred.

Designed queries using BEx Analyzer Reporting tool for data presentation.

Handling on reconciliation issues by checking the data between R/3 and BW systems.

Worked on process chains for Deleting indexes in Infocube, Process of info packages, creating indexes, DSO activation, further updating, PSA request deletion and Attribute change run so on.

Using open hub to export data from BI to External systems (flat file, table, 3rd party tool).

Performance tuning of queries using aggregates, indexing of InfoCube.

Daily monitoring of Info Cubes, DS objects requests, and back ground Batch Jobs (SM37).

Actively involved in Load monitoring of daily, weekly & monthly Data Loads using Process chains.

Extensive hands on experience in handling the creation and loading hierarchies.

# 5

SAP BW/BI Implementation & Support

Client

E.ON at Mumbai India

Role

SAP BW Functional Consultant

Duration

Apr 2009 to Oct 2011

Environment

Responsibilities:

Responsible for requirement gathering and analysis of the business requirement that could be satisfied with SAP business content and created the necessary objects required.

Customized LO cockpit using enhancements wrote User-Exit programs to populate enhanced fields.

Involved in creating new data flow / data model. Created new InfoCube, ODS, Info-sources, data sources, new Characteristics and Key figures.

Also involved in Re-initialization of Data Sources from SAP R/3 and Business Content Activation.

Created different analytical reports using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure, Exception, Conditions, Cell Restriction, Filter and different Variables with different processing types.

Designed the Process Chains with different ways of loading the data.

Responsible for job schedules for loading data and monitoring Process Chains to run periodic loads.

Designed queries using BEx Analyzer Reporting tool for data presentation.

Monitoring of whole system like of BIA indexes, checking reporting indicator, checking RFC connections, checking the reporting indicator.

Dropping and rescheduling chains of daily loads.

Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded to targets.

Monitoring the data loads from various source systems by means of process chains/batch jobs.

Error Debugging and rectification, solving issues, problems faced during Data loads.

Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.

Interacting with business partners and gathering information about the key points and BI Key reports.

Monitoring Data load activities and recovered failures in Dev, Quality system as a part of unit testing.

Scheduled data loads from SAP R/3 to BW, Monitored data loads which are running hourly, daily, weekly & monthly basis and solving errors when occurred.

Handling on reconciliation issues by checking the data between R/3 and BW systems.

Maintaining Work History for all the tickets until it is closed down.

Preparation of utilization reports and analysis of resource utilization

Schedule the meetings and trainings regularly on updates and analyzed KPI reports and SLA issues.

Conducting periodic trainings and knowledge transfer to the team members.

As a consultant leading the 6 member’s team to manage the activities of different BW systems.

# 6

SAP BW Support

Client

Centrica Mumbai India

Role

SAP BW Consultant

Duration

Apr 2008 to Mar 2009

Environment

SAP ECC 6.0, SAP BI 7.0, and SAP BW 3.5.

Responsibilities:

Involved in postponement of transaction data loads, whenever there is a master data load failure.

Monitoring the data loads from various source systems by means of process chains/batch jobs.

Error Debugging and rectification, solving issues, problems faced during Data loads.

Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.

Interacting with business partners and gathering information about the key points and BI Key reports.

Monitoring Data load activities and recovered failures in Dev, Quality system as a part of unit testing.

Involved in solving prioritized tickets regarding extractions, performance issues & data load failures.

Scheduled data loads from SAP R/3 to BW, Monitored data loads which are running hourly, daily, weekly & monthly basis and solving errors when occurred.

Handling on reconciliation issues by checking the data between R/3 and BW systems.

Involved in bug fixing that is occurred because of the issues in routines.

Maintaining Work History for all the tickets until it is closed down.

Preparation of utilization reports and analysis of resource utilization.

Involved in daily, weekly, monthly Application Monitoring activities.

Dropping and rescheduling chains of daily loads.

# 7

SAP BW Implementation

Client

AGS, Pune India

Role

System Engineer

Duration

Apr 2006 to March 2007

Environment

SAP ECC 6.0, SAP BW 3.5. 3.0

Responsibilities:

Responsible for requirement gathering and analysis of the business requirement that could be satisfied with SAP business content and created the necessary objects required.

Customize LO cockpit using enhancements & wrote User-Exit programs to populate fields.

Involved in creating Generic Extractors using Table, Function Module and View.

Involved in creating new data flow / data model. Created new InfoCube, ODS, Info-sources, data sources, new Characteristics and Key figures.

Involved in Re-initialization of Data Sources from SAP R/3 and Business Content Activation.

Created analytical reports using Formulas, Selections, Structures, Calculated Key Figure, Restricted Keyfigures, Exception, Conditions, Cell Restriction, Filter, with process types.

Designed the Process Chains with different ways of loading the data.

Responsible for job schedules loading data & monitoring Process Chains to run periodic loads.

As a consultant leading the six members to manage the activities of different BW systems.

Designed queries using BEx Analyzer Reporting tool for data presentation.

Contact this candidate