PROFILE:

• Certified SAP HANA Consultant with Experience in various Implementations, Rollouts, Migration and Production Support assignments.
• Software professional with 14 years in Information Technology. 4 Year in SAP HANA, 3 Years of in SAP BI/BW, and 7 Years in Informatica in Oil & Gas, Insurance, Retail, Banking, Healthcare, and Education sectors.
• Worked very closely with SAP process teams in understanding the functional requirements
• Functional Expertise of SAP HANA modeling from an E2E perspective.
• Experienced in various modeling artifacts of SAP HANA like Attribute Views, Analytic Views, Calculation Views and Other topics viz. Analytic Privileges, Decision Tables, Variables, Input Parameters, Calculated Columns, Restricted Columns
• Strong understanding of HANA Join Types (Inner, Outer, Referential, Text)
• Data Provisioning using SLT, DXC, SDI, SDA, and Data Services into SAP HANA.
• Manage data provisioning, migration and cleansing from legacy to target system using BODS
• Ability to consume the information models in the BO tools like Analysis Office, Explorer, Crystal Reports, Dashboard etc.
• HANA Data modelling experience in creatingAttribute View, Analytical View, Calculation View, CDS Views, Stored Procedure, SQL Scripting, Table Functions, Decision Tables and Analytical Privileges.
• Utilization of HANA best practices, and HANA performance Optimizations (HANA PlanViz, Expensive Statements Trace, and HANA Memory Consumption).
• Knowledge of selecting BI client based on product capabilities and Business requirement.
• Involved in Support and Monitoring activities after go - live.
• Job scheduling
• Working in globally distributed teams
• Functional Expertise in SAP NetWeaver BW 7.40/BW on HANA including various BW concepts and their applications.
• Unicode conversion and testing
• Undergone complete life cycle Implementation of BW 7.x which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring, LO-Cockpit, Info-cubes, Multi-Cubes, SPOs, DSO objects, InfoPackages, Transformations and DTPs, BEx- Analyzer and BEx Query.
• Functional expertise in SAP Business Warehouse (BW) - Data Extraction, Transformation and Loading (ETL processes), Data Modeling (InfoObjects, InfoCubes, DSO, MultiProviders), Enterprise Reporting and Analysis.
• Techno-Functional Expertise in InfoCube functionalities like Compression, Selective-Request Deletion and Repartitioning, Remodeling.
• Functional Expertise with BW on HANA Concepts like HANA Optimized InfoCube, HANA Models in BW, BW models in HANA, etc.
• Strong skills in performing System, Acceptance, Regression, Stress, Performance, Load, Functionality, Front End and Back End Testing.
• Extensive Experience in testing Extraction, Transformation and Loading (ETL) mechanism-using Informatica.

TECHNICAL SKILLS:

Modelling Tools: HANA Studio, SAP-BW

Reporting Tools: BAnalysis for Office, Crystal Reports, Dashboard, Explorer. Webi, IDT

Dashboard Tools: SAP BO Dashboards/Xcelsius, SAP BO Design Studio.

Exploration Tools: Lumira, Explorer

ETL Tools: Informatica (Power Mart / Power Center), and Ab Initio, Business Object Data Service (BODS)

BEx Tools: Query Designer, BEx Analyzer, Web Application Designer

Programming Languages: SQL Scripting, C, C++, ABAP Misc

Project Management: Autosys (Job Scheduling), Shell Scripting, Hana Live, Blueprinting, Requirements Analysis, High Level Design (Overall Architecture), Low Level Design(Individual Report), Developments, Enhancements, Unit & Integration Testing, UAT Support, Cutover, Go-Live Support, Transition to Support Team.

PROFESSIONAL EXPERIENCE:

Confidential, CA

SAP HANA Consultant

Environments: SAP HANA, SAP BODS / SLT, SAP UI 5, SAP BI Tools

Responsibilities:

• Involved in information gather phase
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.
• Replication of the selected tables from ECC to SAP HANA. Performed transformations during the replication process.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Monitoring the replication process using SAP HANA studio and SAP LT replication server.
• Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA studio.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Migrating standard Infocubes to In-Memory optimized Infocubes
• Migrating standard DSO’s to In-memory optimized DSO’s
• Importing the BW Models in to HANA using HANA Studio
• Consuming the HANA Models in BW by creating the Transient Providers

Confidential

SAP BW / HANA Consultant

Environment: SAP HANA, ECC 6.0, SAP BI 7.3, Business Objects

Responsibilities:

• Created HANA modeling scenarios - creation of schemas, tables - columns/row, SQL Script Procedures, Loading data into table, developed Attribute Views, Analytical Views and Calculation views Graphical and SQL Script - CE Functions based views for report requirements
• Create Reports on SAP HANA Analytic views using SAP HANA MDX Provider
• Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.
• Decision Tables in HANA
• Created universe on HANA Analytical Views and Calculations Views using IDT of SAP Business Objects
• Working on Analysis appliance using BO Design Studio
• Set up and replicate Data using the DXC provisioning

Confidential, WV

SAP BW Consultant

Environments: SAP HANA, SAP BODS / SLT, SAP UI 5, SAP BI Tools

Responsibilities:

• Involved in activating the business content data sources
• Involved in the loading of the data into Infocubes.
• Interacting with the business to gather the requirements.
• Carried out data loadings depending on the requirement
• Worked in transporting the objects through the project landscape.
• Data loads from R/3 for master data as well as transaction data.
• Worked on Information Broadcasting
• Created the custom DSO’s and Info set.
• Created Transformations, DTP’s.
• Involved in Unit testing.
• Uploaded Transaction Data from the Flat File as the Source System.
• Worked on Start Routines and End Routines.

Confidential, CA

SAP BW Consultant

Environment: SAP ECC 6.0, SAP BW, SAP Portal, Ariba, Solution Manager, ChaRM, Quality Center, SAP - TAO, FTS, OTC, RTP, QM, (PP, FI, MM, SD)

Responsibilities:

• This project basically involves in Extracting the data from SAP R3, building up the Data Targets, providing validated reports to the user and Setting up the procedures for ETL process.
• Involved in creation of Info Areas, Info Objects, Info Cubes, and DSO’s, and created required Transformations and DTP to load data into Data Targets.
• Creating the generic data sources, Uploaded Master Data and Transaction Data from Different Source systems.
• Involved in preparation and review of Unit Test Plans & Documentation
• Designing and mapping source and target structures to load transactional data and master data.
• Involved in transporting the cubes, Transformations and Multi Providers from Development to Quality system.
• Activated and Installed relevant Business Content Info Objects.
• Create Process chains for Master data and transaction data loads.
• Designing universe based on sap ECC as a source system

Confidential, TX

Sr. Informatica Developer

Environment: Informatica Power center 6.1/7.1, Oracle 9i, SQL Server 2000, SQL, PL/SQL, TOAD, Windows NT, Unix.

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Participated in requirement gathering meetings with business analysts and ETL architect to understand Source Data, Data Warehouse data model, Technical Metadata, etc. 
• Documented required technical metadata such as source and target definitions. 
• Created technical design specifications for mappings, sessions, workflows, etc. 
• Worked on different OLTP data sources such as Oracle, SQL Server and Flat files for data extraction. 
• Created complex mappings in Informatica Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Sorter, Lookup, Joiner transformations etc., 
• Implemented Type II slowly changing dimensions using date-time stamping. 
• Created reusable transformations and mapplets to reuse while creating ETL mappings. 
• Configured and used the Debugger to troubleshoot the Informatica mappings. 
• Proficient in using Informatica workflow manager, workflow monitor, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions. 
• Worked with DBA team to fix performance issues at Database. 
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations. 
• Worked with export and import utilities in Repository manager. 
• Involved in upgrading from Informatica Power Center 6.1 to Informatica Power Center 7.1 which is used as ETL tool for loading data into EDW from transactional databases
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with the ETL processes.

Confidential, CA

ETL Developer

Environment: Informatica Power Center 6.1, Oracle 8i, SQL, Windows 98/2000, Shell scripts,

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.