Sales Data

Name: Nanda Gopala Anantha

EMAIL ID: **********@*****.***

Phone: 614-***-****

Professional summary:

Over 10 years of experience in SAP BI/BW 3.0B 7.4, 7.3, 7.0 BW On HANA, BPC and, ABAP, BODS 3.x expertise in back end modeling and front end development for manufacturing, aerospace, automobile, Consumer electronics, power generation, and food and beverage industries.

Designed and created SAP BW Upgrade tool.

Excellent functional experience in COPA, MM, IM, PM, SD, PS, PM, FI-GL and Warranty & Claims

(After Sales) Modules.

Translate business needs and functional requirements into system design and technical specifications.

Proficient in gather, analyze, design, developing & support of custom BW objects using BW LSA

(Layered Scalable Architecture).

Configured SOAP connection to provide data from BW data models to third party (ICH) systems.

Experienced in implementation and upgrading Projects.

Extensive experience in Modeling, Data Extraction Transformation and Data Loading (ETL), BEx Reporting, Web Application Designer (WAD), Analysis Process Designer (APD), Web Templates, Reporting Agent and Information Broadcasting, and BOBJ-WEbi reports.

Performed Data load management, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up- Load), Monitoring, MultiProviders, Infosets, Data Mart and Open Hub Service.

Expertise in BW Performance Tuning: Experience in Performance tuning of Queries by maintaining Aggregates, creating and maintaining BIA, Compression, partition, Process chains, indexing of info cubes and use of statistics for the same.

Expertise in BW reporting using BEx Analyzer, BEx Browser, Web Application Designer, and implementing BEx Queries, Calculated and Restricted Key figures, variables, workbooks and facilitate data analysis in a drill down or summarized way to give detail level of information.

Expertise in Business Objects XI 4.0/3.1/3.0/XI R2/6.x/5.x(Desktop Intelligence, Web Intelligence, Universe Designer, Crystal Reports, Xcelsius, Central Management Console and Business Objects Administration).

Ability to connect the SAP R/3 and other legacy systems as source systems to SAP BW.

Strong written and oral communication skills

Strong planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency, productivity, and profitability.

Efficiently managed teams of various sizes and worked with the team to achieve company and client’s goals.

Technical Skills:

Data Warehouse

BI 7.4, 7.3, BI 7.0 BW 2.OB/3.5/3.1c/3.0b/2.1c,and Data Services 3.x, BODS Databases & Tools

HANA, Oracle, MS Access, MS SQL Server

Scheduling Tools

Control M

Programming

Languages

ABAP, JAVA, C and C++

Web Tools HTML, Remedy 7.0

Reporting Tools

SAP BW BEx, BO WEbi, XCelsius 2008, Qlikview, Tableau, SAP BOBJ Design Studio

Environment Windows 2000/ NT/ XP, Linux 5.2/ 6.2, MS DOS Professional Experience:

Project #1

Duration: Aug 2014 to June 2015

Designation: SAP BI Lead Consultant

Ecolab’s (Nalco)

FI & COPA

Environment: SAP BW Powered HANA 7.4 SP9 and ABAP, BODS and TABLEAU Responsibilities:

Provided solution and developed to integrate different subsidiary companies data into Ecolab format.

Created Integrated FI data model to consolidate three organizations data.

FI Gross spend and Profit & loss data model designed for three systems

Implemented Actual GL Plan/Production volume & Shipped volume EDW to EPM

Creating functional and technical specs for BW on HANA database model.

Created APDs for Production & Volumes using multiple BEx reports & Generated Flat File for EPM system

Written Code in APD to lag calendar month USA and other countries data

Written code in APD transformation routine to prefix negative symbol for

Written code in APD to consolidate multiple reports customer shipments, Drop shipments, inter & intra shipments data

Written code in APD EPM Drop Shipment Destination view to derive destination country

Extracting data from different source systems and creating enterprise performance module reports.

Mapping logic has been implemented while updating level 1 to level 2 data model to track Gross spend, Profit and Loss against to Fright, Plan/Production, Material, warehouse and Admin accounts.

Proficient in designing LSA++ architecture

Created Composite provider using Union & Join for actuals and plan data models.

Created ABAP Utility programs like archiving flat file data in AL11 and deleting data from centralized flat file distribution DSO.

Written logic to filter the required data for G/L accounts at DTP level.

Provided solution to restrict unwanted F4 values BEx Variable through BADI.

Written utility programs to delete data from DSO

Generated Tableau reports with Trend lines.

Generated Tableau Dashboard for Gross Spend and P&L Reports

Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.

Designed composite provider on top consolidated layers

Crated Function modules for BEx customer exit variables Project #2

Duration: Feb-2014 – July 2014

Designation: Sr. BI lead Consultant

General Energy

Environment: SAP BW 3.5 & 7.3, BPC and ABAP

Responsibilities:

Solution provided and developed process chain status dashboard for higher management

Worked collaboratively with business teams and business analysts to gather and analyze the requirements to provide quantity in gallons and liters in existing report system across sales, billing and delivery reports.

Solution provided and developed for frequent data load job failures at DTP

Solution suggested and developed to reconcile BW and ECC data for sales and billing modules

Hands-on BI IP solution expertise, with ability to design in the BI IP Planning objects.

Experienced in BI-IP (Integrated Planning) tool – development of Real time Info cubes, Multiproviders, aggregation levels, filters, planning functions, planning sequences Input ready queries and variables

Experience of front end tools Web Application Designer, Query Designer, BEx analyzer.

Good at writing FOX functions and ABAP user-exits - Good ABAP knowledge desired

Loaded data into Dimensions and Applications from an external source using a flat file. Collaborated with IT and business partners to identify source data fields and to define the transformation rules.

Ability to build process chains for any IP Planning functions / Sequences / Data loads.

Familiar with BI IP Best practices and standard

Project #3

Duration: Aug 2013 to Jan 2014

Designation: Lead BI Consultant

Consumer Energy

Environment: SAP BW 7.0 and ABAP

Responsibilities:

Developed the Data warehouse functionality and architecture from business specifications by modeling, designing, developing, testing and implementing the appropriate Back End structures needed to meet business requirements.

Written global routines to avoid special characteristics issue

Designed and developed utility ABAP programs to find where used list of particular value in BEx report to minimize man-hours.

Designed and developed billing condition data source and relevant data models for new reporting requirements on top of existing process.

Written ABAP routines for BEx queries to meet changing business reporting requirements.

Designed and developed generic data source for condition record number and implemented appropriate backend structures.

Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.

Involved in Unit/Regression/Security testing.

Developed customer exit to check security values for individual users for Sales organization, division, Territory and distribution channel

Created WAD reports and broadcasted through process chains. Project #4

Duration: Sep 2012 to July 2013

Designation: Sr IT Lead Consultant

Sony Electronics

Environment: SAP BW 7.0, 7.4 and ABAP

Responsibilities:

Worked as a Lead consultant for Sales Module.

Analyzed functional documents and created technical design documents for sales reports.

Designed and implemented sales data models and created Promoter target sales reports for store managers.

Involved in Full life cycle of the project for migration process from SAP BEx reports to SAP BO XI (requirement gathering to implementation for post and migration process).

Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.

Created age analysis BEx report used as a source for SAP BOBJ Designer studio report and enhanced the backend data models according to the new reporting requirement.

Excellent skills to develop reports using Web Intelligence Rich Client 4.0.

Developed WebI Reports(on demand, Ad-Hoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down)

Created Standard Reports utilizing all the features on Web Intelligence in like Optional Prompts, Functions, and Alerts etc.

Recommend and implemented best practices for automation of data acquisition from the data sources.

Provided proactive investigation, review, assessment, design and implementation of methods to improve existing processes, performance.

Improved ABAP code performance of Global variables by using Export/Import technique.

Proposed and developed design solution by Creating ABAP function modules instead repeated logic in different transformations to enhance reusability.

Created process dependency documents for support team and user training documents for smooth flow of the system.

Serve as a technical and functional expert on the SAP BW HANA Platform.

Created Attribute, Analytical and Calculated views as per the requirement needs.

Proven experience in implementations of SAP BW HANA with strong knowledge of SAP BW standard business content and ECC data sources/standard and custom extractors

Extracted FFV data from source system to HANA database using Data Services and created report.

Project #5

Duration: Apr 2011 to Aug 2012

Designation: Sr BI Analyst

ConAgra Foods

Environment: SAP BW 3.5 & 7.0 and ABAP

Responsibilities:

Responsible for load distribution among team members for handling day to day user issues/tickets along with handling the high priority tickets.

Scheduling weekly meetings and preparing effort estimation chart of the team members. Monitoring and restructuring of Process Chains to minimize load times.

Understanding Client’s business processes in MM and SD and involved in the change of existing MTI (material to Inventory) architecture, created DSO’s Cubes and MultiProviders.

Created BIA indexes to accelerate the performance of the Queries.

Understanding the Architecture and undergone knowledge transition and prepared AID documents as per the requirements.

Analyzing and providing the solution to the customer’s causes with the tickets making enhancement for the existing reports and structures.

Created SOX / test case documentation for changes to the existing objects.

Extracted, loaded and monitored daily, weekly and monthly data from R/3 by process chains for MTI, and Sales.

Created MultiProviders for new reporting requirements.

Solved and closed tickets as required and never missed the (SLA).

Extensively worked on Control-M tool for job scheduling.

3. X Authorizations migrated into BI 7.

Project #6

Duration: May 2010 to Mar 2011

Designation: Sr IT Consultant

ConAgra Foods

Environment: SAP BW 7.0 and ABAP and BODS

Responsibilities:

Worked collaboratively with business teams and business analysts to gather and analyze the requirements and created technical specification documents.

Developed the Data warehouse functionality and architecture from business specifications by modeling, designing, developing, testing and implementing the appropriate Back End structures needed for reporting requirements.

BI flat file data loads converted into BODS flat file data load.

Written Start Routine in Transformation to populate Master data Unit price and Standard price from Material Master data

Created APD’s to provide SAP BI report data to third party systems for consolidation.

Developed optimized Data Service objects, created repositories, projects, workflows, data flows, scripts, data stores.

Development of Customized Info Cubes for the gaps between reporting requirements and standard business content.

Written the User exit for populating the data for the fields, which have been appended to the extract structure.

Created Different Rule Groups for the Transformations. Project #7

Duration: Jan 2008 to Apr 2010

Designation: Sr IT Consultant

Mercedes-Benz, Daimler Plant

Environment: SAP BW 3.5 and 7.0 and ABAP

Responsibilities:

Worked as Lead developer.

Worked closely with business analysts and SMEs to understand, analyze, the functionalities of the existing system (Warranty & Claims and After Sales) to design and develop custom data models for reporting needs (Age wise analysis report).

Experienced in building custom BW solutions including the design of BW Info Cubes, DSO’s, multi providers, Infosets,data extraction, transformations and loading data into BW from flat files and Oracle data bases.

Written an End Routine in transformation to make zero where order value is repeated for same set of document number and item number to avoid duplicate order value.

Written an End Routine in transformation to Flag First Invoice date for report calculations for first overall dealer execution.

Configured E-mail notifications to aware of process chain status to management.

Assigned Workbooks to user roles and given proper authorizations to business users.

Successfully solved very critical problems for BEx report output, like displaying Production and Repair Year/Month in sequence (irrespective of data exist or not in target).

Created info package routine to find flat file in SAP Directory.

Created ABAP programs to check either any file exist with name of current YYYY MM(Year/Month) if exists, then it will trigger the relevant process chain.

Handled pre and post upgrade activities in development and production systems and solved post-Upgrade authorization problems like activating 0TCAACTVT and 0TCAKYFNM info objects.

Project #8

Duration: Aug 2007 to Dec 2007

Designation: Sr IT Consultant

Honeywell Aero Space

Environment: SAP BW 7.0 and ABAP

Responsibilities:

Worked as a BI Developer

Involved in Blueprint Phase for Project System module, analyzed the data, assess and recommend best possible BI architecture for consolidating all the necessary reports.

Created Technical specification documents and developed data models and reports.

Written Start and end routine in transformations to customize the data models to meet the reporting needs.

Enhanced data source 0WBS_ELEMT to add sales order number and written ABAP code to populate sales order number.

Developed & maintained quality ABAP code for enhancements, reports, interfaces adhering to standards.

Project #9

Duration: July 2006 to July 2007

Designation: Sr IT Consultant

Anheuser-Busch

Environment: SAP BW 3.5 and ABAP

Responsibilities:

Evaluated the SAP systems to identify the necessary tables and columns to acquire the data for PS system relevant backend objects.

Created technical specification documents and Visio data flow diagrams for PS and PM Modules.

Designed, developed and tested the data models and created reports.

Written ABAP code for delta mechanism for non-delta supported data sources such as Project System data sources

Created documents for end user training.

Created restricted key figures, structures, variables, exceptions, and calculated key figures in reports.

Modified text elements data as per the client requirement in the ABAP program SAPLRRSV.

Developed process chain to get data from XI to BW and BW to ICH, through ABAP program by using process chain

Project #10

Duration: Aug 2005 to July 2006

Designation: SAP BW Consultant

HLL

Environment: SAP BW 3.5 and ABAP

Responsibilities:

Created SOAP Connection for Workflow ODS’s

Created InfoSpoke (Open Hub Service) to send data from BW to ICH through process chain with ABAP Program.

Posted data into XI Directory and transferring data to (BW Delta Queue) system and then uploading into data targets and testing and documenting this process.

Performed LO’s configuration using LO cockpit, and worked on V3 updates.

Enhanced performance tuning of queries by maintaining aggregates based on BW statistics, and compression and indexing of InfoCubes.

Developed reports using variables, filters, calculated key figures, restricted key figures, and conditions, and analyzing in the BEx Analyzer and organizing workbooks for future reference

Performed maintenance of update rules, transfer rules, update routines, and transfer routines as per client requirements

Set up flat file extraction for legacy data, assigning data sources to the InfoSource, defining transfer structure, and metadata maintenance for the InfoSource and source system

Created BEx Reports and Extracted data from BEx report through RSCRM_BAPI and updating in AL11 data make it available for other systems

Written code in CMOD for customer exit variable and data source enhancement. Educational Details:

Masters in Information Technology 2003, from Manipal University, Karnataka, India

Contact this candidate