Candidates About

 

Hemamalini Annanthu Santharam

 

SAP BW/BI/BO/HANA Techno Functional Consultant

·         Around 7 years of SAP BI/BW experience in Client Server Environment. ·         High expertise in SAP BW v3.5/ BI v7.4 Development, Support & Testing ·         Experience in SAP BW-IP, SAP ABAP and SAP HANA. ·         Experience in SAP Business Objects 4 in Design Studio, Webi, Universe designer, Xcelsius, Crystal Reports and SAP Lumira ·         Experience with Waterfall and/or Agile Project Management Methodologies

 

Professional Summary

Ø  An experienced SAP techno-functional developer with  7 years of SAP BI/BW in software industry.

Ø  Actively involved in End to End Implementations, Upgradation,  Support & Configuration of SAP BW projects

Ø  Implementation experience in various industries like Materials Management, Manufacturing, Finance and Retail.

Ø  Extensive experience in client interaction, requirement gathering, system analysis and design, training documentation and system migration.

Ø  A quality-focused individual with strong technical and functional knowledge.

Ø  Highest level of professionalism, solid work ethics, committed to excellence and willing to learn

Ø  Strong analytical and problem-solving skills with good interpersonal and communication skills.

 

SAP BW – Proficiency

Ø  Worked in Implementation, Enhancement, Testing and Support Projects

Ø  Involved in BW 3.5 – BI 7.4 upgrade experience, and SAP BW full life cycle implementation using Waterfall methodology through the phases of Requirement, Design, Implementation, Verification and Maintenance

Ø  SAP BW technical expertise in developing and enhancing DSOs, Infocube, Multiprovider, Info Sources, Info Objects maintenance, Info sets, Update rules, Transfer rules, Hierarchies, Process chains, Extractors, Data source and Complex Transformations

Ø  Extensively involved in creating Info Cubes in the areas of Sales and Purchase Modules.

Ø  Extensive knowledge of SAP ECC,SD, FI, MM, PP with respect to BW from project planning to go-live support.

Ø  Customizations - Data source enhancements, Generic Extractors, User Exits,  logistics Cockpit configuration and customization, Data extraction from flat files for Master & Transactional data, Update/Transfer rules creation, Business Content Activation, direct and flexible update of Master data

Ø  BW operations - Data load management, event processing, experience in scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Data Mart, Open Hub Service,WAD, Performance Tuning, Aggregates and BW Transports

Ø  Knowledge in ABAP routines for Start Routines, End Routine and Expert Routine

Ø  Testing - Test Scripts, Test cases, Master/Transaction data and Report data Validation. Proficient in using Quality Center for Test Planning, Requirements Management and Defect Reporting and Tracking.

Ø  Interacted with other teams like Informatica and other SAP team to complete QA Testing.

Ø  BW Reporting expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, Workbooks, Calculated & Restricted Key Figures, Structures, Variables, Exceptions, Conditions, Web application designer, and Report to Report Interface

Ø  Involved in two Upgrade projects from BW 3.5v to BI 7.4.

Ø  Strong experience in resolving high priority tickets based on SLA agreement with Remedy tool

Ø  Worked in the Inbound or Outbound logistic, Materials Management, and  Manufacturing

Ø  Experience in Integrated planning and Real Time data Acquisition

Ø  Familiar in creating the planning applications using BI Integrated Planning in creating the Planning models, Aggregation levels, Variables, Data Slices, Characteristic Relationships, Planning functions and Planning Sequences and Input enabled Queries

Ø  Familiar With Business Objects in Universe, Webi, Xcelsius, Design Studio and Crystal Reports.

Ø  Loaded Data into SAP HANA from BW using BODS and 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.

Ø  Experience in SAP HANA Data provisioning Techniques.

Ø  Knowledge of Microsoft Word, Excel, Access and PowerPoint Projects.

 

Technical Skills

Ø  Data warehouse: BW 3.5, BI 7.0, BI 7.4

Ø  SAP Modules: SD, MM, FI, CRM, HR, PS and CO

Ø  Languages: ABAP/4

Ø  ERP Packages: SAP ECC 6.0, R/3 4.7

Ø  Testing tools: Quality Center 9, Control M

Ø  OS: Windows 7/XP

Ø  Reporting Tools: SAP BOBJ Universe, Webi, Design studio, Crystal reports, BEx Reporting and  Web Reporting, SAP Lumira

Ø  Software Products:  SAP HANA Studio

 

Trainings Attended

Ø  SAP HANA HA100 (Introduction to SAP HANA)

Ø  SAP BW 362 (SAP Business Warehouse on HANA)

Ø  SAP BW-IP

Ø  SAP BOBJ

Ø  SAP ABAP

Ø  SAP BI 7.3 ,7.4

 

Education

Ø  Master of Business Administration (Technology Management) - Anna University, Chennai, India

Ø  Bachelor of Engineering (Electronics & Communication) - Anna University, Chennai, India.

 

Achievement

Ø  Received many accolades from my managers and vertical heads for the Sony Corporation

Ø  Successfully lead Technical team and completed NIKE

Ø  Conducted BW Trainings for Infosys New Joiners which covers Data Modeling, Reporting, Data Extraction and all other BW concepts.

Ø  Got appreciation from ES Academy Infosys as Star trainer in ESA_Oct10_SE batch SAP Stream Training.

 

Professional Experiences

 

Company:  In house

October 2015 - Current

Role: SAP  Technology Analyst

Responsibilities

·         Support internal sales and marketing team to research and analyze recent trends in SAP BW

·         Created Input ready query using real time Infocube in Integrated Planning and published the reports in using Web Application Designer 

·         Followed Agile Methodology

·         Designed data model including Actual and Plan Basic InfoCubes and a Multiprovider.

·         Configured Aggregation Levels, custom Filters, custom Functions and Planning Sequences

·         Configured standard functions including copy, delete, revaluation and distribution with keys to support planning and forecasting models.

• Configuring input ready queries with the BEx Query Designer
• Worked in BEx Analyzer Workbooks and Web Interfaces for planning

·         Developed simple custom functions utilizing the Formula Extension (FOX) programming language

·         Attend various SAP education courses to learn and understand newer capabilities of latest service pack releases

·         Understand business visions and missions and act as a bridge between the business and developers

 

Client:  Rockwell Collins                                 

October 2011 -  May 2014                                                

Role: SAP BI/HANA Consultant

Modules: SAP BI 7.4, HANA, SAP Lumira,  SAP R/3 ECC 6.0 (Implementation of SAP BW on HANA)

Responsibilities

·         Created BW Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need.

·         Building Models (Attribute, Analytic and Calculation Views) in HANA.

·         Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.

·         Experience in SAP HANA Data provisioning using SAP Landscape Transformation, Flat File Uploader, ODP SAP Extractor and ODP HANA information views.

·         Worked on mixed scenarios between BW and HANA and all kinds of Join types in SAP HANA

·         Distributed data from an SAP BW system into external data marts, analytical application using Open Hubs and APD.

·         Designed and developed custom HANA optimized DSO objects, Composite Providers, Transient Provider, Open ODS, ADSO and activated Transformations for these data targets and evaluated data in BW report.

·         Worked in SAP Lumira (SAP Visual Intelligence) reporting tool to create customized Reports by inputting data from  SAP HANA and creating Visualizations by connecting to an SAP HANA view.

 

Client:  Nike Corporation                                

May 2010 -  Sep 2011

Role: Senior SAP BW /BOBJ Consultant

Modules: SAP BI 7, SD, MM, QM,WAD Business Objects XI R3.1  (Enhancement)

Responsibilities

·         Worked in enhancements on Data modeling and BW Reports based on Client request

·         Developed OLAP universes and to generate Webi, Crystal reports from sales, purchase departments using SAP BW as data sources.

·         Worked in WAD tool to customize reports and to upgrade reports to latest version using SAP Migration tool.

·         Developed Webi reports, extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks, Alerts, input controls.

·         Using Prompts to Restrict Data, Using complex Filters, Applying Condition & Filters, Displaying Data in Tables and Charts, Using Breaks and Sections, Making Crosstab and Master Detail Reports, Formatting of Reports, Using Default and Custom Sorts, Ranking Data to see Top or Bottom Values.

·         Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies , local variables, Alerts, Ranking and multiple data.

·         Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports.

·         Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors.

·         Have work experience in Design studio .

·         Worked in Information Broadcasting to automate execution of BW reports and sending reports to user via email

·         Worked with Informatica Technical team in mapping objects for sending data from BW to external system.

·         Experience in APD Analysis Process Designer

·         Created Test scripts based on functional/ technical requirement at Interface, Data model and Report level and performed end to end testing of BW objects and Reports

·         Used Quality center tool to update Test cases, Test scenarios and Test scripts

Client:  Sony Corporation                                  

Feb 2009 - April 2010

Role: Senior SAP BW/BOBJ developer

Modules: SAP BI 7, SD, FI-CO,COPA , CRM, MM, PP, Xcelsius, Crystal Reports (Enhancement/Prod Support)

Responsibilities

·         Worked in Generic data sources and LO Extraction

·         Created DSO, Cubes, BW Reports, Workbooks and Process chains 

·         Created, modified and tested BW Query Reports with Variables, Filters, Free Characteristics, Restricted key figures and Calculated Key Figures 

·         Migrated BW objects from version BW 3.5 to BI 7.0

·         Customized and maintained Data Sources in Billing, Sales Order, and Delivery Order for the SD module and Purchasing Order Item for MM Module. 

·         Experience in Inbound or Outbound logistic, Materials Management, and Manufacturing .

·         Created Dashboards using Filters, Combo box, List View, List Box, List Builder, Line Chart, Column Chart, Pie Chart, and Spreadsheet Table.

·         Crystal Reports: Planned, created formatted reports, multiple  groups, Integration with SAP  Data  Source,  manipulation  formulas,  applying conditions and exporting reports to Excel and Word.

·         Designed Crystal reports from a number of different data sources with a number of formats including PDF, spreadsheet, or graphic using Crystal Report XI

·         Developed Standard, Summary, Cross Tabs, grouping, sub reports, summary detail reports, linking sub reports, Custom Formatting Techniques in Crystal Reports Environment.

·         Modified BW queries in the Crystal reports using BW query designer with Crystal XI R2 professional tool

·         Rectified Data load Errors by doing Root cause Analysis and fixing it

·         Performed Monthly Reconciliation (Excel-based) on COPA report and FI-AR Report by comparing R/3 and BW data

·         Created documentation (User Customization Guide) for various enhancements

·         As a part of the 24 / 7 Production Support Schedule, involved in Debugging and Monitoring load failures, Update Routines, Transfer Routines, Transformation, Process chains, Scheduling data loads,  Planning ECC outage for filling up of setup tables for Logistics (LO) Extractors, minimizing the Init load and setting the V3 jobs

·         Worked in Production Support high priority Tickets and Minor Enhancement tickets using Remedy Tool

Client:  APPLE Inc, California USA                                   

Feb 2008 -Jan 2009

Role: SAP BW developer

Modules: SAP BW 3.5, SAP BI 7, SD, CRM, MM (Enhancement/Support)

Responsibilities

·         Worked in BEx  Query Designer and Analyzer to build Queries, Global and Local structures, Restricted & Calculated Key figures, Variables, Exceptions, Conditions and Workbooks/Views

·         Validated data by comparing PSA, data target and BW Report for given selections

·         Executed and analyzed Bookmarks in the web using various Conditions, Filters, Exceptions, Drill downs prior to UAT

·         Worked in BW V3.5 to BI V7 objects Migration cut over activity, Transported BW objects and compared data

·         Worked in production support & other enhancement tickets.

Client:  LENOVO                              

March 2007-Jan 2008

Role: SAP BW developer

Modules: SAP BI 7, ABAP, FI, CRM (Implementation)

Responsibilities

·         Used Waterfall Approach which includes Requirement, Design, Implementation, Verification and Maintenance

·         Worked in Data Modeling, new Reports creation and enhanced existing Reports

·         Worked in Generic Data source creation on views/tables, enhancing existing data source by appending new structure and Flat file Data source

·         Expertise in BW data Modeling area including creating new Info objects for Key figures and Characteristics, designing of ODS Objects/ Info cubes etc in BI 7.0 version.

·         Created Info packages, DTP & scheduled daily full/delta data loads.

·         Involved in Performance Enhancement features such as Cube Indexing and maintaining Aggregates

·         Remodeling of existing cubes to accommodate new Key figures & Characteristics.

·         Master data (Texts, Attributes and Hierarchies) & transaction data load from R/3 data sources, Non – SAP systems and from Flat Files

·         Developed Process chains for Master & Transactional Data

·         Enhanced Extract Structures by adding new fields and populating them with the user/function exits in CMOD

·         Developed BW sales Reports  in BEx Query Designer

·         Vigorously used Aggregates, Restricted & Calculated Key Figures for filtering and Formula variables as per the requirement of Query

·         Worked with SAP Open Hub service for sending data from  BW to external systems

·         Documentation and End user Training.