Resume

Sign in

Sr. SAP HANA/BI/Data Migration Consultant

Location:
Exton, Pennsylvania, 19341, United States
Salary:
market
Posted:
January 15, 2018

Contact this candidate

Resume:

Umakanth Gannu LinkedIn Profile

ac31cx@r.postjobfree.com 973-***-****

Professional Summary:

Approximately 12+ years of experience in the IT industry in various Analytics, Data warehousing, Data Modeling, Data Quality and various BI Analytical tools, design, development, testing and implementation.

Expertise in SAP HANA 1.0 SP9/SP10/SP11/SP12 Modeling, Data provisioning (BODS, SAP Landscape Transformation (SLT) to perform real-time data replication, DXC, SDA, SDI, SDQ, ODP and ODQ) and Text analytics.

Expertise in Analytical dashboard tool creating with SAP Business Objects Design Studio, SAP Lumira which can be viewed on desktops, IPad and IPhone.

Expertise in SAP Business Objects BI Cloud/4.2/BI 4.1/4.0/3.2/3.1, Crystal Reports XI 2008 and XCelsius 2008, SAP Business Objects Data Services 3.1 to 3.2/4.0/4.1 and 4.2, Data Quality and Data Insight.

Experience in HANA Enterprise Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.

Excellent knowledge on: HANA Optimized InfoCubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.

HANA SQL Scripting & CDS [CORE DATA SERVICES] - Strong experience on Creating SQL, Stored Procedures with SQL Script and also with Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like – Tracing, Using the SQL Script Debugger.

Knowledge on OData implementation for Opportunity FIORI application, using standard OData model, building new OData model,

HANA Security & Transport - Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Create User, Roles & assigning the respective Privileges. Hands-on experience on all three modes of transport – Delivery Unit mode, Development mode, as well as on the ‘SAP support mode’, Apt in Direct metadata import – mass import of metadata, selective import of metadata.

Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.

Experience in Importing BW models Info Cube, DSO in HANA as Analytical view.

Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis BusinessObjects Explorer MS Excel.

Developed new reports against BW Source. BICS connection, Universe. unv and .unx built on IDT.

Comprehensive experience in gathering and analyzing requirements from end-users and trained users in Business Objects for ad-hoc reporting.

Expertise in working with various RDBMS tools like DB2, SQL Server, Oracle, Teradata, Sybase, Flat Files, Main frames into a staging area and database development experience with TOAD, Aqua Data Studio 4.7, Erwin.

Worked on Tableau, Qlickview for POC to create dashboards on various tools..

Excellent writing, verbal, analytical, communication, and interpersonal skills. Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Technical Skills:

Analytical/OLAP Tools

SAP HANA, SAP BW, Business Objects BI Cloud/ 4.2 / BI 4.1/5.0/5.1/6.1/6.5.1/XI/R1/R2, SAP Business Objects Design Studio, Crystal Reports, SAP Lumira, Explorer, Tableau, Qlickview, SAP Analytics Cloud.

ETL and Quality Managing tool

Data Integrator 11/11.7, SAP BO Data Services 3.1/3.2/4.1/4.2, Data Quality, Data Profiling, Data Federator, Data Insight, SSIS, SAP Information Steward.

Programming

COBOL, C, C++, JAVA, SQL, PL/SQL, .NET.

Internet Technologies

WebLogic, HTML, JavaScript, CSS.

Databases

Oracle 7.X/8.0/8i/9i, Teradata, SQL Server, DB2, Sybase, SAP HANA, SAP ERP, SAP ECC, S/4 HANA.

Data Modeling Tools

SAP HANA Studio, ER/Studio, ERWIN, Oracle Designer

Good Knowledge in

SAP CRM, FICO, HCM, Hadoop.

Professional Experience:

Client: Samsonite (Contract) Jun 17 – Till Date

SAP HANA/BI/Data Migration Consultant

Responsibilities

Involved in Collaborating with Client managers, DBA's, Reporting team, Business users and other Stake holders to understand SAP HANA, the existing landscape and identify key business use cases for the Poof of Concept POC.

Lead SAP HANA modeling and provide Analytics recommendations in the development of new solutions as well as the improvement of existing solutions.

Interacted with Business stake holders in order to understand their structured and ad-hoc reporting requirements, User stories, business rules for finance, sales and marketing domains.

Worked on conducting workshops to go over the new tasks with the system administrators and SAP Basis and also created an application by application migration approach from SAP BW to HANA system.

Setup Table Replication SLT for ECC and 3rd party table's real time into SAP HANA. Data replication enhancements created for custom fields when required during replication.

Using data provisioning methods like Business Object Data Services BODS non sap data Flat file upload and direct extraction connection DXC to acquire the data into SAP HANA Data Mart.

Worked on migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.

Worked on Activating and Importing BW models Info Cube, DSO in HANA as Analytical view.

Using Import selective Meta data for SAP BODS 4.2 imported Meta data in the ETL Process prior to on boarding data into sap HANA, created schemas and data provisioned using SAP LT Replication Server SLT.

Developed Business Object Data Services BODS4.1 jobs to pull external data from Flat files and Oracle into HANA database.

Developed Jobs to complete remediation of legacy data, data quality management, data profiling using both built in and custom functions.

Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical Specifications.

Used SAP Information Steward Data Insight to analyze data quality, data Profiling and to define validation rules for data migration in Data services, Standardized & Enrichment data after cleaning

Worked on SAP HANA Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.

Developed the following HANA Information Models: Attribute Views for master data, Analytic Views for star schema model and Calculation Views Graphical and SQL Scripting to Join/Union using HANA tables, attribute views, analytic views and Calculation views, in order to address complex business requirements created SQL Script based Calculation views.

Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE STUDIO.

Established BICS connectivity between SAP BW to BO 4.2 Environment.

Worked on migrating SAP BOBI WEBI / Explorer Info spaces assets to SAP HANA views.

Consumption of HANA information Models in BW by creating Composite and Transient Providers.

Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence WEBI.

Worked on Data visualization/dashboard design using SAP Analytics Cloud, SAP Business Objects Design Studio and Lumira with various Analytic, Basic and Container components and the dynamic functionality/formatting is provided using API References writing script coding in Java Script & CSS made compatible for desktop, IPad and IPhone.

Developed new and utilized the Design Studio Dashboards using Lumira designer and Created new Lumira Dashboards using Lumira Discovery tool

Interacted with the Business Users for their KPI & report requirements.

Environments: SAP HANA, SAP BODS, SAP Business Objects 4.2, SAP Business Objects Design Studio, SAP ECC, SAP BW on HANA, SAP FI/ IS/Retail, Flat files, JavaScript, CSS, Windows.

Client: SAP America (Contract) Dec 11 – May 2017

SAP HANA Modeler and SAP BI/Data Migration Expert

Responsibilities

Experience in gathering User Requirements, created detailed Functional Design Documents and converted to Technical document along with Report mockup design documents for the reports.

Hands on experience with SAP HANA landscape using functionalities like data provisioning, Modeling and Administration, and Information Composer.

Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.

Used Formats and Transforms including Flat File formats, Query, Table Comparison, History Preserving, Hierarchy Flattening, Match Transform, Validation Transform, Key Generation and Map Operation.

Extracted data from various SAP modules and Cleanse using SAP BO Data Services tools and maintained the data quality using business validation rules in the Data Quality transforms.

Used SAP Information Steward Data Insight to analyze data quality, data Profiling and to define validation rules for data migration in Data services, Standardized & Enrichment data after cleaning, supported Sales Operation team by extracting SAP CRM Customer data (Master Data) and enhanced processes for SAP Data Services to provide better quality data.

Extracted data load files from SAP BW using BEx queries and Loaded into Dimensions and Facts (Leads and Opportunities) data into the GCO and align the data to the GCO data model using SAP BO Data Services (BODS).

Performed Job Validation and Syntax checks and Dry Run to evaluate for errors, execution time and bottlenecks. Utilized the Debugging function adding Breakpoints, Try and Catch block, Target table Auto-Correct Load and Auto-recovery mechanisms

Expertise in end to end Data Migration process including Extraction, Data Profiling, Transformation and Generation of Load ready data files.

Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non-sap data Flat file upload and direct extraction connection DXC to acquire the data into SAP HANA Data Marts.

Comprehensive modeling experience in creating various views like Attribute, Analytic and calculation views and Hands-on experience with SQL scripts like stored procedures and CE scripting and well versed with BW7.4 on HANA working functionalities.

Established BICS connectivity between SAP BW to BO 4.2 Environment.

Worked on migrating SAP BOBI WEBI / Explorer Info spaces assets to SAP HANA views.

Experience in Configuring SLT, creating schemas, Implementation of transformation rules by maintaining table IUUC_ASS_RUL_MAP on the LT server, Configuration for non-SAP source system, within the LT replication server, defining RFC connection to source system, defining DB connection to HANA system, defining no. jobs for data replication, SLT issues and resolution on jobs.

Hands-on experience on various SAP Analytical tools (BO WEBI, BO Explorer, Lumira and SAP SBEE) to provide high-level insights like one stop shop for most of the business solutions like Actuals, revenue, targets, YOY, Contribution, Health metrics, Top 3/5 Insights and attainment in a Dashboard visualization and drill downs to the details for all global BMO users and Created and published stories in Lumira sever and Cloud.

Involved in Data visualization/dashboard design using SAP Business Objects Design Studio with various Analytic, Basic and Container components and the dynamic functionality/formatting is provided using API References writing script coding in Java Script & CSS made compatible for desktop, IPad and IPhone.

Worked on latest version SAP Business Objects 4.2 to migrate the existing WEBI reports to use direct connection to SAP HANA information Views.

Interacted with the Business Users for their KPI & report requirements.

Participated in designing, development, testing and roll out of HANA Models using Scrum methodology (Agile) development practices.

We use the SAP JIRA to create projects as Epic and Backlog items as the tasks to maintain the project workflow.

Creating IT direct tickets for an issues and coordinating with the support team.

Environments: SAP HANA, SAP Business Objects Cloud/4.2/4.1/4.0/3.2, SAP Data Services 4.2/4.0/3.2, Data Quality, Data Profiling, SAP SBEE, SAP Business Objects Design Studio, SAP ECC 6.0, SAP BW, SAP CRM, Flat files, HTML, JavaScript, CSS, .NET, SQL Server, Windows.

Client:

Sr. Business Objects Consultant Nov 10 – Nov 11

Responsibilities

Involved in the complete System Development Life Cycle.

Involved in functional requirements gathering meeting different business groups and preparing the technical specifications.

Worked with onsite/offshore team model for development efforts. Delegated tasks to the offshore team and ensured their successful completion.

Extensively worked on developing BOBJ universes for multiple projects and the migration to higher version.

Proficient in Agile methodology. Implemented 4 development projects using the Scrum methodology.

Involved in resolving the loops, fan traps, chasm traps using contexts and aliases, checked the cardinalities and Integrity of the Universes.

Worked on the vendor master, customer master and material master IDOCS: CREMAS, DEBMAS and MATMAS using ASAP methodology.

Developed workflows to load data into Customer Master Sales data (KNVV) and Partner roles (KNVP) from legacy systems using SAP Business Objects Data Services.

Extracting data from various sources, map and transform it to a target data model and actually load the data into the target, created lot of batch jobs and maintained versioning in DI Central Repository.

Used Maestro scheduler to schedule and monitoring the ETL jobs and sending notifications.

Published reports onto the SAP Business Objects Enterprise XI 3.1, scheduled periodic batch generation of reports including utilizing multiple distribution paths such as email, FTP, Info view and others.

Managed the users for the Data Services in Web Admin and whereas for the Business Object were manages the Users and Security model in the Central Management Console.

Environments: SAP Business Objects Data Services 3.2, Data Quality, MS Visio, SAP ECC 4.6, Flat files, Oracle 11g, SQL Server, SSIS, SEIBEL, Maestro Scheduler, Unix, Solaris, Windows.

Client: SAP America (Contract) Feb 10 – Nov 10

Sr. SAP Business Objects Data Services Developer

Responsibilities

Developed functional requirements and data specifications for ETL Process designed Star Schema model data warehouse, Designed data marts to load Fact tables and Dimension tablesInvolved in end to end implementation of this project Design, document, develop, test, install and support complex data extract, transformation and load (ETL) programs.

Responsible for creating Data Stores and File Formats extracting data from various sources (SAP BW, SQL Server, flat files map and transform it to a target data model and actually load the data into the target, created Data Integrator scripts, work flows, and data flows, utilizing built-in and custom DI functions.

Configured the mappings to handle the updates to preserve the existing records using History Preserve Transformation (Slowly Changing Dimensions Type-2).

Implemented data profiling and Data Quality methodologies by using Data Management best practices.

Implemented of Recovery Mechanism for unsuccessful batch jobs execution.

Implemented Performance techniques like table partition, bulk loading, degree of parallelism ...etc.

Environments: SAP Business Objects Data Services 3.2, Data Quality, Data Insight, ERWIN, SAP BW, Flat files, Data Profiling, MS SQL Server 2005, MS DTS/SSIS, 2005.

Federal Home Loan Bank of New York

Sr. SAP BO / Data Integrator Developer Sept 09 – Jan 10

Responsibilities

Extensively used Business Objects Data Services in creating jobs, workflows and data flows in extracting

the data from Data Warehouse, Business Objects Data Quality processing, including data cleansing,

matching, data profiling, and data enhancementInstalled and configured Business Objects Data Services in a multi-tier environment.

Developed and designed Data Marts in Star and Snow-Flake Schema. Published reports onto the Business Objects Enterprise XI R2, schedule periodic batch generation of reports including utilizing multiple distribution paths such as email, FTP, Info View and others.

Environment: Business Objects Data Services 3.2, Data Quality, Data Insight, ERWIN, Crystal Reports XI R2, Business Objects Reports, Web Intelligence 6.5, Business Objects Enterprise XI, Business Objects Designer, UNIX, Exceed 2008 and Citrix.

ITC Transmission, MI

Sr. Business Objects Data Integrator Developer May 08 – Aug 09

Responsibilities

Involved in the complete System Development Life Cycle.

Involved in functional requirements gathering meeting different business groups and preparing the technical specifications and generated logical Data Model using Erwin tool

Designed and developed ETL processes, data flows, and Data Marts based on business requirement specifications.

Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc. using Oracle Database 10g, ODBC sources, XML and CSV documents

Environment: Business Objects Data integrator 11.7, ERWIN, Crystal Reports XI R2, Business Objects Reports, Web Intelligence 6.5, Business Objects Enterprise XI, Business Objects Designer, Seapine Surround SCM Client as version control and Test Track Studio Client as Defect tracking system, Perl Scripting, SQL, PL/SQL, Oracle 9i /10g, XML, CSV, SQL Server 2008, Quest Toad 9.5 for Oracle, AIX, Windows XP.

Mercury Insurance Group, CA

Business Objects Data Integrator Developer Jan 06 – Apr 08

Responsibilities

Involved in Extraction, Transformation and Loading of Data Marts using BO Data Integrator, Monitored batch jobs in DI Administrator and documenting and maintain versions using DI Central Repository

Developed automated reports using Crystal Reports XI R2 and scheduled to run the packages monthly, quarterly, yearly, weekly, daily as designated and made documents ready for the user auditing.

Using Mercury Interactive Web-based test management tool (Test Director 7.6) to organize and manage all phases of the application.

Tools which were used during this tenure Crystal Reports XI R2, BO XI R2 BO Data Integrator 11.0.3, DB2, Oracle, SQL Server 2005, HP Reflection Mainframes, Clear Case, Test director, Aqua Data Studio 4.7

Medtronic, MN Mar 05 – Jan 06

Business Objects/Data Integrator Developer

Responsibilities

Involved in the complete System Development Life Cycle

Involved in reporting requirements gathering by interacted with the end users in order to design, creation, and implementation of Data Integrator scripts, work flows, and data flows, migration from Business Objects 6.5 & Crystal to BO XI, Crystal Reports, WEBI and Universe design Oracle as a DW target.

Education: Master’s in Computer Science passed on 2004.



Contact this candidate