SUMMARY

• Total 9 Years of IT Experience in Implementation and Support of SAP HANA, BW, SAP Design Studio and Data warehousing Projects using IBM Data Stage 7.x/8.x, Teradata and Tableau.
• Strong Experience in designing, developing & maintaining SAP HANA Information Models such as Attribute, Analytic & Calculation Views including SQL Script based Calculation Views using SAP HANA 1.0 SP07, SP08, SP09, SP10, SP11, and SP12.
• Responsible for gathering requirements from the super users, functional analysts and ABAP team to provide the design options for the SAP UI5 and Design Studio Dash Boards.
• Worked directly with business users to determine, document and finalize their data requirements.
• Worked on multiple SCM modules including procurement, Quality management and Plant Maintenance for analysis and to facilitate reporting in SAP UI5 and Tableau.
• Worked on Configuring, Creating transformation and troubleshooting SAP LT Replication Server (SLT) to imported metadata and table definitions.
• Strong proficiency in SQL, and experience in writing Stored Procedures in HANA using SQL Script
• Strong Experience in identifying the bottle necks in the HANA model performance and optimizing the models.
• Experience on Building on Hana Models on ECC Tables, and validating the report data with ECC table data.
• Used HANA Live and created copies of the live views and modified them according the requirement.
• Fair understanding of SAP HANA architecture & SAP HANA concepts such as In - Memory Computing, Row Store, Column Store, Data Compression, Data Provisioning, Modeling and Reporting.
• Good Knowledge of HANA XS and developing User Interface with SAP UI5 by exposing the HANA models using Odata services.
• Experience in replicating the data from SAP/Non SAP sources to SAP HANA using BODS.
• Good Experience in Hana live views and Hana Analytics.
• Experience in creating virtual tables in HANA Schemas by using Smart Data Access (SDA), and Smart Data Integration (SDI).
• Strong experience in SAP BW HANA 7.4 and 7.5.
• Experience in BW Powered by HANA, HANA-Optimized Cubes and Advanced DSOs (ADSO) and Composite providers.
• Experience in Configuring, Consuming SAP BW objects and HANA models/views into design studio.
• Developed advance DSOs in HANA Studio using Eclipse tool and mapping the transformations to Advance DSO's, reloading data from standard DSOs and HANA cubes to Advance DSO's.
• Experience in Importing BW cubes into HANA studio/modeler and HANA views into BW.
• Worked with different features and components ofDesignStudiolike Crosstabs, Script editor etc. inDesign Studioto accommodate the requirements.
• Worked on Creating WEBI reports as per the requirement.
• Experience in Designing, Developing and Documenting of ETL Jobs in Data stage to populate tables in data warehouse and data marts using Data Stage Processing stages such as Aggregator, Filter, Join, Merge, Lookup and Transformer Stage etc.., and File Stages such as Sequential file and Data set.
• Created and modified many scripts of BTEQ, FAST LOAD, MULTI LOAD and TPUMP according to the business demand with the given transformation or business logics.
• Involved in identifying long running queries, scripts, Spool space issues etc..., and implementing appropriate tuning technique for optimizing the Queries.
• Proven ability to work creatively and analytically in a problem-solving environment

TECHNICAL SKILLS

SAP Tools: SAP HANA, SAP BODS, SLT, SDA, SDI

ETL Tools: Data Stage7x/8x, Teradata Utilities, SQL,PLSQL

Reporting Tools: Tableau, WEBI

Databases: Teradata, Oracle, SQL Server

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

HANA Modeler

Technologies: SAP HANA, SAP UI 5, SAP SLT

Responsibilities:

• Understanding the Business requirements and convert them into Blueprint
• Translating Functional Specifications into Technical Specifications
• Translate the Business KPIs intoHANA& Define the Reporting Layouts
• Translate the Business KPIs for Dashboards & Define the dashboard Layouts
• Define the Design Documents for theHANAModels
• Configuring Data Services for Metadata Import
• Design and Creation ofHANAAttributes views
• Design and Creation ofHANAAnalytic views
• Design and Creation ofHANACalculation views
• Design and creation of XSJS jobs
• Optimizing the existing HANA models for better performance
• Parameter mapping in calculation views to optimize the performance
• Currency Conversions
• Managing Attribute Mapping in HANA
• Creation of Constant and or calculated columns in HANA Models
• Creation of Analytics Privileges
• Creating Function using SQL
• Creating and exposing the OData Services in Hana for UI5 binding
• Validating Information Models in HANA
• Comparing Object Versions
• Checking Model References
• Displaying Audit Trails of Information Models
• Validation of Report Layout and Data in the Reports
• Validation of Data in the Reports vs ECC
• Conducting UAT sessions with the Business

Confidential

SAP BW HANA Developer.

Technologies: SAP BW 7.4, SAP HANA, Design Studio

Responsibilities:

• Worked on importingHANAoptimized cubes intoHANAstudio/modeler as Analytical Views
• Worked on creating information views inHANAbasedontheBWmodels.
• Workedonperformance optimization ofHANAmodels using Visualize Plan execution and analyzing the data model joins.
• Worked on Configuring and Consuming SAP BW objects andHANAmodels/views into design studio.
• Created and Implemented BI Applications/Dashboards and Visualization solutions utilizingSAPDesignStudio.
• Designed and Developed new Dashboards (DesignStudio) consuming data from HANA and BW.
• Troubleshootingdesignstudioapplications and dashboards

Confidential

SAP HANA Developer.

Technologies: SAP BODS, SAP HANA, SAP BO (IDT, WEBI)

Responsibilities:

• Importing Metadata: Created tables in HANA by importing the table definitions from the source systems using data services.
• Loading Data: Loaded data into table definitions imported from source systems (Oracle/Flat Files) using BODS.
• Configured BODS to replicate data from sources to HANA DB, used scripts to handle delta, Monitored and troubleshot the replication errors.
• Creating Packages: Created packages to group the Objects together logically in a structured way.
• Created Attribute views, Analytical Views and Calculated views as per the business requirements.
• Developed SQL based Calculation views, stored procedures, SQL Debugging and troubleshooting
• Worked on complex filters using filter expressions, dynamic input parameters using procedures, parameters
• Worked on Functional and technical error handling
• Worked on optimization of the HANA models
• Used Information design tool to create data foundations, Business Layer and publish connections and layers to the SAP BO repository.
• Involved in documenting the changes to the universe and reports functionality
• Creating WEBI reports as per the requirement.

Confidential

ETL and Reporting Consultant.

Technologies: Data Stage 8.5, Tearadata V14, Tableau 8.0

Responsibilities:

• Involved in low-level design and developed various jobs and performed data loads and transformations using various stages of Data stage and Teradata Utilities such as BTEQ, Fast Load, Multi Load and TPUMP.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Used Data Stage Director to scheduling the jobs, monitoring and validating its components.
• Worked with the reporting team to develop the code written and sort out the defects in the code.
• Worked on Teradata SQL Assistant querying the source/target tables to validate the scripts.
• Developed Data stage Jobs to call the BTEQ scripts, and to capture the log information.
• Designed, developed and optimized Tableau workbooks for senior business leaders, to effectively tell the story based on the underlying data
• Build compelling, interactive dashboards in Tableau that answer key business questions.
• Develops Tableau visualizations to support ad-hoc analyses.

Confidential

ETL (Data stage and Teradata) Developer.

Environment: IBM Web Sphere Data Stage 8.1, Teradata 13.

Responsibilities:

• Involved in low-level design and developed various jobs and performed data loads and transformations using various stages of Data stage and Teradata Utilities such as BTEQ, Fast Load, Multi Load and TPUMP.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Used Data Stage Director to scheduling the jobs, monitoring and validating its components.
• Worked with the reporting team to develop the code written and sort out the defects in the code.
• Worked on Teradata SQL Assistant querying the source/target tables to validate the scripts.
• Developed Data stage Jobs to call the BTEQ scripts, and to capture the log information.
• Worked on Parallel Jobs using Various Stages such as Sequential File, Copy, Filter, Join, Look Up, Merge, Funnel, Surrogate Key Generator, Change Capture, Change Apply, Transformer, Aggregator etc.
• Used Data stage Job Sequences to Control the job flow execution using various Activities such as Job Activity, Notification Activity, User variable Activity and Execute command Activity.

Confidential

ETL developer

Environment: Data Stage 8.1, Teradata 13, UNIX.

Responsibilities:

• Identified different source definitions to extract data from input sources and load into target using Data Stage.
• Involved in Extracting, cleansing, transforming, integrating, and load data into Teradata Database Tables using Data Stage and Teradata Utilities.
• Worked with Data stage Designer, Director and Manager in the development of Data stage Jobs.
• Created Job Sequences, by using Job Activity, Nested condition activity, User Variables Activity, Notification Activity, etc.,
• Used Data Stage Director for monitoring jobs, troubleshooting errors and resetting aborted jobs.
• Worked on Teradata SQL Assistant querying the source/target tables to validate the scripts.
• Monitoring the Data Stage Jobs.
• Providing the Job resolution for the failed jobs.
• Identifying the Long Running Jobs, and worked with senior team members for tuning the jobs to meet the SLA