Data Sap

Chandra Peddada

Mobile: 615-***-****

E-mail: **********@*****.***

SUMMARY:

Dedicated SAP BW4HANA certified consultant with 21 plus years of overall IT experience, which includes 15 plus years of SAP BW and 6 plus years of legacy mainframe experience

Worked with Top Four consulting companies like Deloitte and CapGemini serving SAP BW consulting services to their prestigious clients

Expert in SAP BW4HANA features: ADSOs, Composite Providers and Open ODS views using HANA studio

Expert in Data Provisioning using SLT, creation of data models using BODS, architecting solutions keeping in mind the data volumes and suggesting for dynamic tiering options.

Adept in HANA Modelling using multiple scenarios like Attribute views, Calculation Views and Analytical Views. Experienced in creating Graphical views in HANA.

Knowledge of SQL procedures, table functions and triggers.

Working knowledge in performance tuning, creating logical and physical partioning.

Knowledge of Security like providing analytical privileges and authorization concepts.

Excellent professional experience in Software Development Life Cycle that includes requirement gathering, design, project implementation, system test and implementation, user support and training

Involved in full life-cycle implementations of multiple SAP BI/BW projects using ASAP methodology

In depth technical experience in SAP BI/BW and good functional knowledge in FI/CO, SD, MM, SRM(EBP) APO, HR, CRM, CATS and EM modules

Well experienced in Data warehousing concepts, Designing effective client specific BW systems, Data Modeling, Performance Tuning, Data Extraction and Data loading for both applications specific as well as generic from R/3, ECC, CRM, SRM and Non SAP systems like Maximo, other legacy applications

Functioned various pre and post activities of the Upgrade from 3.5 to SAP BW 7.0 (2004s)

Extensive experience with SAP BW Accelerator (BWA) setup and index creating as well as the new features like Transformations, Start and End-routines, DTP, Data acquisition etc.

Extensively worked with Basic Infocubes, Real time Infocubes, DSOs, Multi Providers, Infosets, Data validation and error- handling, Start and End routines, update rules, transfer rules, APD and Open hub.

Implemented Multi-provider model to include current and last 2 years cubes in the reporting key. At year end, data flow will automatically adjust to move to required cubes

Enhanced the BI Content data sources and extended the structures using user exits to support the business needs. Creating, Collecting and Releasing transports (ECC, BW and BEx)

Worked with CO-PA & LO cockpit data sources and data extraction

Created various types of customer exit variables for Bex query designer and populated these variables using Enhancement user exits

Created Infopackages and DTPs to handle Full and Delta loads and Process chains to automate the master data (attribute-text-hierarchy) as well as Transaction data loads from ECC to BW

Experience with SAP BEx Analyzer, BEx Browser, Query Designer, Web Application Designer and SAP Business Objects, Xcelsius, Webi, Crystal reports, Analysis for Office and other reporting tools

Involved in the SAP Business Objects Data services (BODS) implementation and POC and exposures to the components like Designer, Job server and Engine and Repository. Key role played in Integration of Business objects and BODS with SAP BW and POC at DTE Energy

Expertise in executing SAP BW-BPS functionality, creating Planning objects like Planning Areas, Planning Packages, Planning Functions, layouts variables using Panning workbench. Also worked with retraction from SAP BW to ECC and CRM systems

Proficient in developing various project deliverables like Functional and Technical specs etc.

Excellent communication, interpersonal and project management skills

Strong ABAP4 programming, analytical, problem solving, and debugging skills

Performance Tuning: Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning

Expert in trouble shooting and bringing necessary solutions to various SAP BW related issues

Extensive experience in client training in Data Warehousing and Reporting Analytics. Conducted trainings and workshops for end-users and project team members

Efficiently managed and worked with the team to achieve teams as well as client’s goals

Positive attitude and very open minded in Sharing and Transferring both the technical as well as the business knowledge to peers and other project members

Team player and fast learner and Very Passionate to learn and Master new Technologies

STATUS: US Citizen

EDUCATION: Bachelor of Science in Engineering

CERTIFICATIONS: SAP BW & SAP HANA

Skills & Environment: SAP BW4HANA,SAP BW 7.4, SAP BW 7.0 (2004S), BW 3.5/3.0, SAP R/3 versions (3.0 - ECC 6.0), APO, SAP CRM, SAP SRM, Maximo, SAP Business Objects, SAP BODS,SAP HANA, SAP BW BPS, Business Explorer (BEx), BEx Analyzer, BEx Browser, WAS 6.2, PL/SQL, Oracle 9i/8i/8x, Perl, XML, UNIX, OS400, AS400, Linux, ABAP4, IDOC, BAPI, ALE, User exits, TRFC, DDIC, Windows XP/NT/2000/98/07, Mercury, Service center, Kintana, Test director, Solution Manager, IBM 3090, COBOL, CICS, DB2, VSAM, IMS DB/DC, EASYTRIEVE, TSO/ISPF, JCL, MVS, RC Update, Endevor, Intertest, Spufi, Expeditor, Net wise, Visio, Power Builder, Share Point, Microsoft Outlook, Office Communicator, Cognos and MS office 2007 & 2010

HIGH LIGHTS:

In Year 2017, Trained in SAP BW4HANA and Presented the POC on various Mixed approach Scenarios to Costco IS Key decision making team

In Year 2016, Trained in SAP BW Powered by HANA and Presented the features to the Dev team

In Year 2012, Trained in SAP BODS and Presented the features to the 3M SAP BW Project team

In Year 2011, Trained & certified in SAP HANA and Presented the features to the General Mills SAP BW Project team

In Year 2009, Presented the proof of concept on SAP Business Objects on the existing SAP BW system to DTE Energy

In Year 2009, Trained in SAP Business Objects – conducted by SAP and sponsored by DTE Energy

In Year 2008, Presented the proof of concept on how to bring the Procurement data from IBM Maximo to SAP BW and reporting to DTE Energy

In Year 2007, Presented the proof of concept on US DOT reporting using client’s legacy data into SAP BW Business Content Info Cubes to ABX Air

In Year 2005, Presented the proof of concept on Open Hub Service (2004s) & APD (Analysis and process designer) to Deloitte Services LP

In Year 2004, Trained in SAP Net Weaver '04 – Ramp up training conducted by SAP Philadelphia and sponsored by Cap Gemini.

In Year 2004, Attended and got certified the SAP BW Certification exam conducted by SAP Philadelphia and sponsored by Cap Gemini

From Apr 2004 to Mar 2005, Involved in various workshops conducted by Cap Gemini, giving presentations on SAP BW to various clients for promotion, providing BW assistance in various pursuits made by Cap Gemini and training and mentoring BW action learning consultants

From Aug 1997 to Dec 2003, legacy Mainframe development experience using COBOL, CICS and DB2 in various huge implementations with clients related to Government and Financial sectors

EXPERIENCE:

SAP BW4HANA Tech lead Costco, Issaquah, WA Oct 2014 – Present

Responsibilities:

Presently playing the BW4HANA Tech lead for the Costco FI reporting reconstruction platform project to integrate existing Costco BW, BPC and Implementer teams as well as the technologies using Agile methodology

Part of the above projects, Design and developing various Base and custom models using the various BW4HANA features like ADSOs, Composite providers, Data flows etc., to full fill the requirements

Key role playing in the Integration of BPC and HANA integration as part of the project exposing to Analysis which includes POC scope and deliverables

Played the BW Senior architect for the client’s SAP BW 7.4 system which includes gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, Redesigning the existing models as wells as the Reporting structures, Unit testing, trouble-shooting, integration and user acceptance testing, documentation, training and maintenance

Designed, developed and implemented new BI model using features like Transformations, end-routines, DTP, Data acquisition etc.

Worked with various standard as well as custom BI/BW objects for FI, CO, SD, and MM of ECC.

Worked on customization and enhanced the extract structure to support business needs

Designed and developed various Data targets and Info providers like DSO (ODS), Info cubes, Infoobjects, Multiproviders and Infosets using Admn workbench (EDW, RSA1)

Developed Transformations to cleanse the data and enhance the master and transaction data using Formula Builder and Start and End routines with ABAP4 to suit the business requirements

Populated various data targets like Infoobjects, DSO’s, ODS and Infocubes, with Master data and Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging area (PSA)

Debugging the Extractor checker, Start and End Routines

Worked with Datamarts, Myself source, Generate export Datasource and Replication

Created Infopackages for Full, Initial, Early init, Delta and Full repair loads for both Master data and Transaction data and automated using Process chains

Extensively performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems

Developed Queries to access data from various BW Infoproviders like DSO, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer

Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures

Collecting and Releasing transports (BW and BEx). Worked with basis team for space related issues, establishing RFC connections to various source systems, applying required notes, moving objects from development box to QA and Production

Prod support (on call) by monitoring the daily loads, troubleshooting the issues & fixing the errors

Performed the analysis for loading and query performance

Trained the client’s technical as wells as the business teams on how to use the ongoing application

Worked with the security team to evaluate and create the required Roles and authorization and other related issues

Sr. SAP BW Consultant 3M, Saint Paul, MN Jan 2012 – Sep 2014

Responsibilities:

Worked with the users to get the requirements, performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team

Participating and finalizing the functional requirements from the business users

Responsible in converting the functional requirements to technical designs

Successfully implemented CRM, SD, MM and FI/CO modules Developed custom function module extractors, used ABAP routines in transformations

Providing project work load and timelines to the business users

Responsible for defining technical strategy and tactical plan for implementing data and information delivery solutions

Worked on Global and regional reports

Participated in design reviews, spec reviews, code reviews, test plan reviews

Worked with various standard as well as custom BI/BW objects for FI, CO, SD, and MM of ECC.

Worked on customization and enhanced the extract structure to support business needs

Designed and developed various Datatargets and Infoproviders like DSO (ODS), Infocubes, Infoobjects, Multiproviders and Infosets using Admn workbench (EDW, RSA1)

Developed various transformations to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements

Populated various data targets like Infoobjects, ODS and Infocubes, with Master data and Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging area (PSA)

Debugging the Extractor checker, Start routines and End routines

Performance Tuning – Evaluated statistical performance and provided recommendations for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning.

Open Hub interface to transfer data from BI to Flat Files to load to an external system.

Worked with Datamarts, Myself source, Generate export Datasource and Replication

Created DTPs, Infopackages for Full, Initial, Early init, Delta and Full repair loads for both Master data and Transaction data

Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,

Performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems

Developed Queries to access data from various BW Infoproviders like DSO, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer

Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures

Created various interfaces from BW to various non-SAP systems using APD and OPEN HUB.

Reconciliation of BI reports with the ECC & legacy data as wells as the reports

Sr. SAP BW Consultant General Mills, Minneapolis, MN Nov 2010 – Dec 2011

Responsibilities:

Played the BI/BW Senior architect role for the client GMI’s Campaign Management Conversion project, which includes gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, conversion of the existing models to enhanced model with additional features right from Coupon planning to execution as wells as the unit testing, trouble-shooting, integration and user acceptance testing, documentation, training and transition

Worked on understanding and analyzing the CRM Market Campaign Planner process as well as the related data in the CRM, ECC and legacy BW systems. Raising the required questions.

Key role played in the Business objects reporting requirements, design sessions and the Gap analysis

Worked on analysis of the AS IS existing complicated model to convert it into an enhanced model for all the stages which includes the Planning, Projection, Settlement, Redemption, Distribution and Reporting

Key role played in reviewing, understanding, analyzing the existing complex BPS functions. Layouts and

Other BPS related objects and suggested the necessary inputs to BPS developers

Designed the new BW model to satisfy the old features as well as enhanced features and integrate with front end like CRM planner and Business objects as well as the source systems CRM, ECC, legacy BW and Flat files

Developed various documents like Data flow, Data mapping, Data dictionary, Functional and Technical specs to support the enhanced design

Created various BW backend objects which includes real time cubes, Basic cubes, DSOs, Datasources, Infosources, Transformations, DTPs, Open hub spokes and Process chains

Developed complex ABAP code in the end routines and start routines of the Transformation to satisfy the existing BPS functions and latest business needs

Developed DTPs and Infopackages and created various routines with ABAP for the selections. Used semantic keys.

Developed Classes and Methods and included in the End routines, start routines and DTP routines to avoid redundant code.

Created 16 complex Bex queries on the Multiproviders to support BOBJ universes. And also created various other Bex queries on the others Infoproviders to support the business needs

Created various Customer exit variables to support the queries. Used ABAP in the enhancements to fill these variables. Rolling 12 is one example with these variables

Supported BPS developers whenever required while development as well as testing phases.

Involved in the SAP BOBJ XI 4.0 rampup

Involved in the Retraction and Extractions process from and to between real time cubes and source systems

Handled the huge loading for historical conversion from the CRM, ECC and the legacy BW systems in D and Q environments

Identified, designed, developed and loaded the required Master data objects to support the new model

Involved in Unit and QA testing and performed the tuning to improve the query as well as the loading performance. Created and refreshed the BWA indexes as well as DB stats.

Used the issue log on the share point to communicate the status as well as issues to the team members and business owners

Created various transports, collected the required objects and migrated to the target systems

Developed, conducted and presented various training to the users as well as the project members

Sr. SAP BW Consultant Detroit Energy, Detroit, MI Apr 2008 – Oct 2010

Responsibilities:

Played the BI/BW Senior architect as well as the BI architect role for the complete client DTE’s BW system which includes gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, Redesigning the existing models as wells as the Reporting structures, Unit testing, trouble-shooting, integration and user acceptance testing, documentation, training and maintenance

Worked with the legacy systems users to understand the huge volume of legacy data stored on the oracle systems as wells as Mainframe DB2 systems and designed the arching structure on the BI system to store the huge volume of legacy data

Involved in the integration and implementation of SAP Business objects and SAP BODS with SAP BW and also prepared and presented POC

Designed and developed Universes in Business objects on various Infoproviders and presented the reports to users

Designed and developed the process for extracting, transforming, and loading data using the SAP Business Objects Data Services into SAP BW Data targets. Transformed the data to suit to business needs. Verified and improved the quality of your source data

Performed various FI and Maximo related huge data loadings from legacy systems to BI system

Worked with several users both at the execute as wells as non-executive levels to gather requirements and transformed them into a data model using extended star schema concept

Coordinating and helping the client’s developers on various BI technical as well as application aspects

Representing DTE’s BI system and coordinating with SAP on the road mapping setting done by SAP

As a part of the BW 3.5 to BI 7.0 upgrade team performed various Pre and Post upgrade activities supporting the basis teams as wells user groups

Developed various deliverables like BBP, Functional and Technical specs, Data mapping and Data flow documents, Gap & Impact analysis documents, Step by step solution and Transport seq

Involved in preparing Business Requirement Documents and checked Business Content to identify necessary Business Objects

Worked with Non-SAP Maximo team to understand the data and converted the data to suit to BI

Designed, developed and implemented new BI model using NW 2004s features like Transformations, end-routines, DTP, Data acquisition etc.

Worked with various standard as well as custom BI/BW objects for APO, HR, SRM and FERC, FI (GL/AP/AR), CO, SD, MM, HR and EHS of ECC.

Worked on customization and enhanced the extract structure to support business needs

Designed and developed various Datatargets and Infoproviders like DSO (ODS), Infocubes, Infoobjects, Multiproviders and Infosets using Admn workbench (EDW, RSA1)

Developed Transfer Rules and Update rules to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements

Populated various data targets like Infoobjects, ODS and Infocubes, with Master data and Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging area (PSA)

Debugging the Extractor checker, Transfer rules and Update rules

Worked with Datamarts, Myself source, Generate export Datasource and Replication

Created Infopackages for Full, Initial, Early init, Delta and Full repair loads for both Master data and Transaction data

Created process chains using various process to automate data loading, activation of ODS, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,

Extensively performed huge data loads into ODS and Infocubes from ECC as well as the legacy systems

Developed Queries to access data from various BW Infoproviders like ODS, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer

Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures

Collecting and Releasing transports (BI and BEx). Worked with basis team for space related issues, establishing RFC connections to various source systems, applying required notes, moving objects from development box to QA and Production,

Prod support (on call) by monitoring the daily loads, trouble shooting the issues & fixing the errors

Reconciliation of BI reports with the ECC & legacy data as wells as the reports

Performed the analysis for loading and query performance

Trained the client’s technical as wells as the business teams on how to use the ongoing application

Worked with the security team to evaluate and create the required Roles and authorization and other related issues

Sr. SAP BW Consultant ABX Air, Wilmington, OH Jul 2007 – Mar 2008

Responsibilities:

Played the BI lead as well as the BI architect role for the complete full life cycle BI Implementation which includes conducting AS-IS and TO-BE sessions, gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, unit testing, trouble-shooting, integration and user acceptance testing, documentation and maintenance

Worked with several users to gather requirements and transformed them into a data model using extended star schema concept

Developed various deliverables like BBP, Functional and Technical specs, Data mapping and Data flow documents, Gap & Impact analysis documents, Step by step solution and Transport seq

Involved in preparing Business Requirement Documents and checked Business Content to identify necessary Business Objects

Worked with legacy AS 400 team to understand the data and converted the data to suit to BI

Designed, developed and implemented new BI model using NW 2004s features like Transformations, end-routines, DTP, Data acquisition etc.

Installed, activated, implemented and enhanced various Business content objects for FI (GL/AP/AR) of ECC. Worked on customization and enhanced the extract structure to support business needs

Worked with LO cockpit data sources and data extraction

Designed and developed various Datatargets and Infoproviders like DSO (ODS), Infocubes, Infoobjects, Multiproviders and Infosets using Admn workbench (RSA1)

Debugging the Extractor checker, Transfer rules and Update rules

Post Go-live support (on call) by monitoring the daily loads, trouble shooting the issues & fixing the errors

Reconciliation of BI reports with the ECC & legacy data as wells as the reports

Performed the analysis for loading and query performance

Trained the client’s technical as wells as the business teams on how to use the ongoing application

Created Open Hub interface to transfer data from BI to Flat Files to load to an external system

Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning

Customizations - Enhanced the Business Content Objects data structures of FI related and customization; configuration, update/transfer rules creation

Sr. SAP BW Consultant Deloitte Prof Services, Nashville, TN Apr 2005 – Jul 2007

Responsibilities:

Involved in complete life cycle Implementation which includes gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, performance tuning, unit testing, trouble-shooting, integration and acceptance testing, documentation and maintenance

Worked with several users to gather requirements and transformed them into a data model using extended star schema concept

Developed various deliverables like Functional and Technical specs, Data mapping and Data flow documents, Gap and Impact analysis documents

Supported and performed various pre and post upgrade activities related to NW 2004s BI Upgrade

Designed, developed and implemented new BI model using NW 2004s features like Transformations, end-routines, DTP, Data acquisition etc.

Used NW 2004s BI Open Hub service to develop various spokes with Transformation and DTP

Involved in the implementation of BI Accelerator and have good exposure to BIA index maintenance, BI Accelerator monitor and BIA TREX admin tool. Performed the activities like building, filling, dropping and monitoring the indexes in various environments throughout the landscape for the BI Accelerator implementation

Worked with Kintana work bench and Test director for logging various ongoing issues and resolutions

Involved in preparing Business Requirement Documents and checked Business Content to identify necessary Business Objects

Installed, activated, implemented and enhanced various Business content objects for FI (GL/AP/AR), CATS, HR, EM and LO (SD & MM) of R/3, and Sales analytics modules of SAP CRM. Worked on customization and enhanced the extract structure to support business needs for the Vendor analytics from the information captured from the system Arriba

Designed and developed various Datatargets and Infoproviders like ODS, Infocubes, Infoobjects, Multiproviders and Infosets using Admn workbench (RSA1)

Developed Transfer Rules and Update rules to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements

Populated various data targets like Infoobjects, ODS and Infocubes, with Master data and Transactional data from SAP R/3, SAP CRM, legacy systems and file interface via Data Staging area (PSA)

Debugging the Extractor checker, Transfer rules and Update rules

Worked with Datamarts, Myself source, Generate export Datasource and Replication

Created Infopackages for Full, Initial, Early init, Delta and Full repair loads for both Master data and Transaction data

Created process chains using various process to automate data loading, activation of ODS, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,

Extensively performed huge data loads into ODS and Infocubes

Developed Queries to access data from various BW Infoproviders like ODS, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer

Created Jump queries (using RRI), Restricted Key Figures, calculated key Figures, Filters, Conditions, Variables and Structures, Exceptions, Pre-calculation of Web templates & value sets using reporting agent.

Analyzed, designed and developed Infospokes for both Master and Transaction data to support MDR (Master Data Repository)

Created Hierarchies both internal and external. Populated them using file interface, R/3 and also updated them manually. Worked with Navigational attributes both time dependent and independent

Created Generic Datasources using Database Views, Tables, Infoset queries and Function modules

Created and worked with CO-PA data sources and extraction

Involved in Performance tuning: Created Aggregates, Drop and Create Indexes for Infocubes, Buffering, Partitioning, DBSTATS, Compression, Delete PSAs and Temp tables to improve loading as wells as query performance. Worked with various transactions like RSRT, RSRV etc., for analyzing queries, cache and repairing various BW objects. Worked on Global work process overview to monitor the work process load and identify locks

Worked with Technical content for loading the content from R* tables and analyzing the content to improve the system performance. Used various function modules to copy aggregates, delete logs etc.

Collecting and Releasing transports (BW and BEx). Worked with basis, transport and security teams for space related issues, moving objects from development box to QA and Production and authorization issues etc. Production support (on call) by monitoring the massive process chains, trouble shooting the issues & fixing the errors

Involved in an Upgrade project from BW 3.0 to BW 3.5 and performed the pre and post upgrade tasks

Sr. SAP BW Consultant Limited Brands, Columbus, OH Apr 2004 – Mar 2005

Responsibilities:

Enhanced the complete FI reporting structure to suit the new structure after the business was reorganized.Modified various infoProviders and data targets and converted the current data to match the new structure within a very tight time frame

Succesfully implemented FI/CO reporting solution.Installed, activated, implemented and enhanced various Business content objects for FI (GL/AP/AR), and MM of R/3. Worked on customization and enhanced the extract structure to support business needs

Worked on the Vendor analytics of SAP SRM (EBP) to support the reports like E-Procurement Account Assignment,Bid Invitations and Bids,Procurement Process–Single Documents,Purchase Contracts – Single Documents and Shopping Carts – Single Documents

Created and worked with CO-PA data sources and extraction

Stabilized the extraction process by modifying the process chain and set up for error handling

Modified user exits of Master and transaction extractors, start and transfer routines both in update and transfer rules. Configured and Appended various extractors and

Contact this candidate