PROFESSIONAL SUMMARY:

• Over 14+ years of experience in software industry which includes, experience in analysis, design, development, testing and implementation of Enterprise applications using SAP BW/BW4HANA, HANA (Native), S/4 HANA Analytics, SAP BODS, SQL, Power BI, Tableau, Business Objects, IBM Mainframes and QA Testing tools.
• Accomplished organizational goals by overseeing various phases of Software Development lifecycle (SDLC) i.e. Requirement Gathering, Technical and Functional documentation, Development/Customization, Production Support and QA Testing.
• Experience in SAP HANA 2.0, SAP HANA1.0, designing Schemas, and creating Packages, developing Information models like Analytic Views, attribute views and calculated views using HANA Studio, Data Provisioning (SLT, BODS, SDA), SQL Scripting, Analytical Privileges.
• SAP HANA modelling and scripting experience including ability to write complex stored procedures, Table Functions and HANA views using SQL.
• Completed two full cycle SAP BW 7.3 to BW4HANA in place conversion projects.
• Excellent experience SAP BW on HANA modeling objects like using LSA++ data models, Composite Providers and exposing BW objects in HANA Views, Advanced DSO etc.
• Experience with data extraction from SAP/Non - SAP Source Systems using SLT, BODS, SDI and SDA.
• Excellent experience in S4 HANA real time reporting and reporting BW4HANA with S4 HANA CDS Views.
• BW 7.5 on HANA: Open ODS view using Hana tables and virtual tables using SDA, Composite provider, ADSO, Field based, and IO based modelling, SAP Hana Live, Migration from LSA to LSA++, modeling using Hana Live.
• BI Modeling: Info Cubes design, Info Sources, Info Object maintenance, ODS/DSO Objects, Creating Update rules, Transfer rules, Transformations, DTP’s, Open Hub Destination etc.
• Customizations and Extraction: Data source enhancements, Generic Extractors, User Exits, Logistics Cockpit configuration and customization, Transformations, update rule
• BI Reporting: Built custom queries, BEx Analyzer, BEx Query designer, Webi reports with sections, breaks, Dashboards using Bex query, Query as web service, Analysis for office and Analysis for OLAP, BO Explorer
• Modeling - Extensive experience inBWArchitecture, Extended Star-Schema, Multi-Dimensional Modeling, Data Flow Strategy, Defining Dimensions, Info Cube, Multiprovider, Infoset, Data Source, Info Source, Info Object.
• Customizations - Experience in activating standard Business Content, extending and enhancing Info Cubes according to the requirements, Data source Enhancements, User Exit Variables, Virtual Key figures, Routines (Start, End and Export) and Formula Builder.
• BEx Reporting - Expertise in front-end Business Warehouse components for Queries, Input Ready Queries, planning workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, Ad-hoc Queries and Web application designer, Web Items.
• Strong Mainframe Programming experience and excellent skills in CICS, DB2, COBOL, VSAM, JCL, Easytrieve and SAS.
• Excellent analytical, team leading, team management, consulting, and inter-personal skills with high learning ability, has a positive and structured approach towards work and good communication skills.
• Quick adaptability to new technologies so keeps abreast of changing trends and meets new requirements successfully.

TECHNICAL SKILLS:

SAP Components: ECC 6.0, S4HANA and SAP IS-Oil

Programming language: C++, SQL, PL/SQL, COBOL and JCL (Job Control Language)

Databases: Oracle 9i, 10g, MS SQL Server 2008, 2012 and MS Access

Operation Systems: Windows 9X, XP, MacOS X and Linux

Methodology: Agile and Waterfall

BI Tools/ETL Tools: SAP BW, SAP Business Objects, Analysis for OLAP, Power BI,: Tableau, Web Intelligence, BEX Query designer and Lumira.

Data Provisioning: SAP BODS, SLT and SDA

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant - SAP BW/HANA consultant.

Responsibilities:

• Interact with client to know their business needs to better define and understand requirements, feasibility check and provided several mock-up reports to finalize the requirements.
• Designed and developed HANA 2.0 Container objects using SAP WEB IDE and replicated the SAP/Non-SAP tables into EDH using SLT Replication Server.
• Developed Native HANA Information Model-Calculation Views (Dimension, Cube with/without Star join) to define multidimensional data model.
• Developed very complex HANA Calculation Views. (Projections, Aggregations, Ranks, Joins, Unions, and Scripts)
• HDB module: Roles, Tables, SQL Scripts, Stored Procedures, Flow Graphs, Virtual Tables, Synonyms and Calculation Views
• Worked on Smart Data Access (SDA) which transfers the data from the source system tables virtually in SAP Hana system.
• Done Unit Testing, SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Worked on Tableau and Analysis Office tools to build the end user reports & Dashboards.
• Worked on Cut-over activities and data validations and post go-live support.
• Responsible for requirement gathering by working with business and technical users, analysts, Project managers and Interacted with Business stake holders to understand their structured and ad-hoc reporting requirements and User Stories.
• Performed analysis, design then created Functional and technical BW specifications document as per business requirement.
• Used the ODP (Operation Data Provisioning) to connect the standard/custom BW extrators to extract Accessory tier fields like Market type and Universal etc.
• Created new info objects/info providers on BW4HANA through HANA design studio and also enhanced ADSO structures with new fields.
• Enhanced the transformations (in B4H) with new fields mappings from source system to target Location data target, and also used lookup rule and assign key fields along with new fields to fetch data into product location data target.
• Worked on Smart Data Across (SDA) to create Virtual data in BW/4HANA from S/4 HANA.
• Created Composite Provider and open ODS views for 2 different data flows and joined 2 open ODS views in composite provider for reporting purpose.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip
• Worked on Cut-over activities and data validations and post go-live support.
• Scheduled and monitored Process Chain jobs for data materialization into EDH/BW4
• Created Business Design Document, PowerPoint presentations and Demos for prototyping Proof of Concept
• Developing HANA Information Models such as Attribute Views, Analytic Views and Calculation Views on the HANA system.
• Creating Global and Local parameters and variables at Job/Workflow/Dataflow levels
• Created DATA models of SAP HANA Calculation View Graphical/ SQL Script.
• Used Join, Union, Aggregate, Rank and Start Join Nodes in Calculation Views
• Worked with Semantics/Data foundation/ logical Join in HANA data models and Created Calculated columns/ Hierarchies in SAP HANA Attribute view.
• Created Variables, Input parameters, restricted, calculated columns to derive from other columns and counter to count based on characteristics
• Hands on Data-Provisioning techniques for Real time Data migration process using SLT SAP Landscape Transformation to perform real-time data replication into SAP HANA and data loading into HANA using SAP BODS.
• Created BODS Jobs/Workflows/ Data flows to extract Data from Oracle Database to HANA
• Executed Data Extraction Transfer Loading (ETL) using SLT, SAP Data Services 4.0 to import .csv files into SAP HANA tables to reflect exchange live rates application.
• Used the Data Services interactive debugger to troubleshoot errors and monitor the data at various points in a job.
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
• Help business users create AO report on the HANA calculation view created for reporting.
• Responsible for requirement gathering by working with business and technical users, analysts, Project managers and Interacted with Business stake holders to understand their structured and ad-hoc reporting requirements and User Stories.
• Performed analysis, design then created Functional and technical BW specifications document as per business requirement.
• Part of the requirement maintained new entry in ECC custom table for new one-time customer along with distribution channel, demand channel and Sales Type and replicated data into BW system to extract BOPIU sales.
• Maintained the TVARVC Table with new customer one-time customer along with distribution channel, demand channel and Sales Type.
• Enhanced the Order Delivery Integration DSO with new fields with mappings from the source ECC standard extractors 2LIS 11 VAITM, 2LIS 11 VASTI, 2LIS 12 VCITM and 2LIS 12 VCHDR.
• Enhanced the Export routine code with conditions and filters with lookups into DMD Channel Sold-To & TVARVC tables to meet BOPIUS sale criteria data extraction.
• Created customized info objects, DSOs, DTPs, Transformations along with mappings to fetch the Open BOPIUS sales and PGI’ed.
• Created export data sources and replicated in APO BW Node/system to merge the BOPIUS open & PGI’ed sales into Demand planning and SNP Planning Area for forecast and replenishment.
• Created HANA calculated view (Script Based) to fetch BOPIUS Open sales through SLT tables (VBAK, VBAP & ZTSD ORDER H) and PGI’ed sales through DSO tables data dynamically and to consume data into down streams for reporting purpose.
• Collected all impacted transformations in existing data flow to avoid any breaking in production system.
• Validate unit testing results against newly developed objects and aggressively involved in Domain Testing, Regression testing, user acceptance testing and BVT.
• Provided the demo to product owners and business stake holders with newly developed objects and data flow along with test results.
• Conducted KT sessions with new development details to support teams to support business after hyper care period.
• Capture the BW objects in sub tasks through transport request and assigned to Active control.
• Worked on transportation of objects across the land scape like development, Quality, pre-production, and production systems.
• Prepared cut-over activity steps for production deployment and get it reviewed with release management, business and support teams.
• Worked Extensively on Data Warehouse Workbench and customized info objects, DSOs, ADSO’s, Info Cube, Open Hubs, Data Sources, DTPs, Transformations, Start Routines, End Routine, Field routines, Read from Data Store Rules and multi providers.
• Defined logical file name and Path to extract the flat file with retail sales history and on-hand data from Sprint into data source from Cellera path.
• Defined logical file name and Path to extract the flat file with On Order and in-transit data from Sprint into data source from Cellera path.
• Created new DSO for data staging from Sprint legacy systems. Created transformations and implemented/Written ABAP code logic in start and end routines with Unified/non-Unified SKU & Location validations and CHAR/Numeric conversions in field routines to filter the correct data for staging from flat files.
• Enhanced Export routine with Unified/non-Unified SKU and Location conditions for existing T-Mobile retail sales data flow to merge with Sprint retails sales data.
• Created custom Error Log Table and implemented the Transformation with logic in start & end Routines to filter out the invalid entries into Error Log table from Sprint systems for re-processing.
• Created BODS job to trigger the Error log table data as email attachment to business for re-processing.
• Created ADSO in HANA studio to implement the data flow for On-Order, In-Transit and On-Hand sales from staging DSOs and created HANA calculation View for dynamic data extraction and reporting.
• Created export data source and replicated into APO BW system to implement data into DP & SNP Planning area for replenishment and forecasting.
• Imported and re-imported tables in the BODS datastore for newly created BW objects/info providers, included the new objects in target/output structure and implemented the mapping between source and target objects.
• Defined Path, Source and target system details in Initial Script.
• Collected all impacted transformations in existing data flow to avoid any breaking in production system.
• Validate unit testing results against newly developed objects and aggressively involved in Domain Testing, Regression testing, user acceptance testing and BVT.
• Provided the demo to product owners and business stake holders with newly developed objects and data flow along with test results. Conducted KT sessions with new development details to support teams to support business after hyper care period.
• Capture the BW objects in sub tasks through transport request and assigned to Active control.
• Worked on transportation of objects across the land scape like development, Quality, pre-production, and production systems.
• Prepared cut-over activity steps for production deployment and get it reviewed with release management, business and support teams.

Environment: SAP BW 7.5, ECC 6.0, BODS 4.0, HANA 2.0/1.0 SPS5, SAP AO, WebI, SolMan

Confidential

SAP BW/HANA consultant

Responsibilities:

• Involved in requirement gathering for development, Data modeling and designing reports as per the requirement.
• Also Involved in Installing BI Technical Content
• Performed analysis, design, development and implementation of standard or customized Info-Cubes and ODS Objects
• SAP BW on HANA modeling objects like composite Providers and exposing BW objects in HANA Views, Advanced DSO etc
• Created composite providers and analytical privileges
• Consumed data from HANA calculation views as source to build BW models
• Created multidimensional modeling involving data from BW generated models
• Used currency conversion from local to USD in calculation views
• Built information views out of data extracted using BODS and SLT.
• Expert in Modeling for complex situations with utilizing all types of views including script/GUI, procedures, SQL scripts, CE Functions.
• Created new BEx queries and worked on web intelligence (WebI) rich client for creation of WebI reports as per the client requirement.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Worked for full end to end SAP BI/BW 7.01 implementation
• Worked on Gap analysis for Reporting requirements and Conducted work shop for gathering reporting requirements from the client
• Business content installation has done for SD, MM IS Oil and QM modules standard master data objects and info cubes with data flow before Development of Info Objects, Info Sources, Transfer Structures, Data marts, transfer rules, Update rules, transformations, data store objects, info cubes and process chains
• Migration of data sources, transfer rules, updates rules to BI 7 Data sources and transformations
• Worked on generic extraction as per client requirements
• Created new BEx queries as per the client requirement for the modules SD, IS Oil and FICO
• Worked on creation of universes using universe designer on BI Info cubes and query’s
• Worked on web intelligence rich client for creation of WebI documents
• Worked on unit testing, integration testing, user acceptance testing and regression testing
• Responsible for Creating Charms using Solution Manager and moving the transports across the landscape.
• Worked on Cut-over activities and data validations and post go-live support.
• Created Process chains and automated daily loads for Transaction and Master Data loads.
• Worked for full end to end SAP BI/BW 7.01 and BOBJ XI 4.0 implementation
• Conducted work shop for gathering reporting requirements from the client.
• Business content installation has done for SD, MM, IS Oil and QM modules standard master data objects and info cubes with data flow before.
• Development of Info Objects, Info Sources, Transfer Structures, Data marts, transfer rules, Update rules, transformations, data store objects, info cubes and process chains.
• Migration of data sources, transfer rules, updates rules to BI 7 Data sources and transformations.
• Worked o generic extraction as per client requirements
• Created new BEx Query’s as per the client requirement for the modules SD, IS Oil and FICO
• Worked on transportation of objects from development systems to quality and production systems.

Environment: SAP BO 4.1, SAP BI/BW 7.0, ABAP

Confidential

SAP BW consultant

Responsibilities:

• Installed necessary Business Content objects like Queries, Workbooks, Info Providers, Updated Rules, Info Sources and Transfer Rules etc
• Loading of Master data (Texts, Attributes and Hierarchies) / Transaction data
• Created custom Info Objects, Characteristics and Key figures
• Involved in creation of custom Info Areas, Info Cubes
• Loading data from the external file system i.e. flat file
• Created Process chain for Master and Transactional data loads separately.

Environment: SAP BW 3.0 & R/3 4.7 and ABAP

Confidential

IBM/ SAP HANA

Responsibilities:

• Dun & Bradstreet is one of the leading credit bureaus in the world. Credit bureaus are independent organizations (mostly commercial, for profit organizations) which collate information from the various lending organizations like Banks, credit card companies, housing finance companies and even keep track of any Bankruptcy proceedings in the courts. Credit Bureau reports are available to prospective creditors (Banks, Financial Institutions) or others like potential landlords, life insurance companies, etc. A credit bureau helps banks to take quick decisions on credit requests as they have objective source of the consumer’s credit repayment history and total credit availed by a consumer.Analyzing the specs given in PRD/DOE
• Developing the code according to the specs and self-reviewing the code
• Auditing the output files according to the specs
• Sending the QA material to PM situated at client place
• FTP the file to customer or releasing the JES to BH
• Closing the DOE orders (if present) in ACDB5 region
• Closing the PRD/DOE in Time Keeper and Sending the daily/wkly report of the status to TL.

Environment: IBM Mainframes, File-aid, Endeavor, Util50 and DOCO, Rexx