Sundaravathana

Email: ace8e8@r.postjobfree.com Phone: 978-***-****

Summary:

? Over 6 years of experience in IT industry covering Development, Analysis, Design,

Testing and System Maintenance of Business Intelligence based applications.

? Experience in full life cycle implementation for different modules following ASAP

methodologies which involves Gap analysis, Blue Printing, Realization, Data extraction,

Data modeling, Data loading, production Support, Testing, Documentation, Requirement

analysis, End user documentation, Reporting and Go-Live check.

? Extensive experience in Installation and Configuration, Creation of repositories and

security configurations, Performance tuning and optimization of BI solutions including

capacity planning, migration procedures, and usage analysis.

? Expertise on OLTP extractions from SAP R/3 and new products like CRM, SCM and

SEM using LO Cockpit, CO-PA, LIS, Generic Extractors and non-SAP R/3 extractions

using DB connect and also extracting data from flat files.

? Expertise in business warehouse components ? Info Objects, Standard and Custom

Info Cubes, DSO?s, Info packages, DTP?s and Transformations.

? Excellent knowledge of BW system, Data Warehousing concepts including data

modeling, ETL, Query, Report Design, BW Web Reporting and Open Hub Service.

? Experience in ABAP/4, Update/Transfer Routines, BDC programming.

? Worked on various kinds of Performance Tuning techniques such as Aggregates,

Rollups, Indexes, partitions, and Info cube compression techniques.

? Expertise in Integrating SAP BW 7.3 with SAP Business Objects 4.0.

? Migrated SAP BW WAD reports to Business Objects 4.0 reports.

? Implemented SAP Design Studio in Business Objects mode to rewrite WAD 3.5

reports.

? Expertise in Rewriting the reports and Dashboards using new Business Objects tools

like Analysis for OLAP, Design Studio,Dashboards 4.0, Crystal for Enterprise and

Explorer

? Extensive experience in design and development of Universes and Reports using Business

Objects

? Diversified experience in implementation Business Objects report management with in

Finance, Sales and Marketing, Pharmaceuticals and Retail.

? Expertise in Universe designing/developing and generating reports with complex, business

views, ad-hoc reports, dashboards, list of values (LOV) along with user acceptance test

(UAT).

? Expertise in using Import Wizard to migrate reports and universes between different

environments like development, testing and production.

? Experience in creating users and user groups, restricted access of the users as needed using

Central Management Console (CMC). Involved in managing users, groups, folders and

published reports.

? Migrated Business Objects environment from Business Objects XI R3.1 to Business

Objects 4.0

? Expertise creating Executive dashboards for the upper management showing summary

metrics for the Key performance Indicators (KPI?s).

? Built, designed, and tested various levels OLAP and OLTP reporting systems using Business

Objects product suite. Strong skills in interfacing Business Objects with Databases like

Oracle.

? Experienced in interacting with Business Users to analyze the business process and

requirements and transforming requirements into reports and dashboards.

? Articulate with excellent communication and leadership skills and the ability to develop

creative solutions for challenging client needs.

Professional Experience

ConocoPhillips, Bartlesville, OK May 11 ?

Present Sr. SAP BI/BO Consultant

Responsibilities:

? Collaborate with Project Managers and Business Relationship Managers to elicit

requirements, set priorities, build consensus, and guide the technical delivery of solutions.

? Ensuring that system development best practices are used.

? Coordinate and support QA and UAT for enhancements and productions fixes.

? Assessing BI related IT architecture components in the existing landscape to ensure

compliance with regulations, policies and standards.

? Worked on POC for BW on HANA.

? Worked on BW system upgrade to 7.31

? Integrated SAP BW 7.3 with Business Objects 4.0.

? Configured Single Sign on for all the Business Objects 4.0 tools to SAP BW systems.

? Migrated BEx WAD 3.5 reports to Business Objects reports.

? Implemented SAP Design Studio and performed the server side configuration and client tool

setup.

? Rewrite all the Visual composer applications to SAP Dashboards 4.0.

? Involved in Enterprise Portal upgrade to 7.3.

? Publishing Business Objects reports and dashboards to Enterprise Portal.

? Upgraded the BO 3.1 system to Business Objects 4.0.

? End user training on developing and executing Analysis for OLAP and Analysis for Office

reports.

? Rewrite some of the WAD reports to SAP Design studio as a part of BW upgrade project.

? Developed some complex Dashboards using Xcelsius and Dashboards 4.0 for key business

units.

? Implemented the BW Security Project, which involves properly securing the financial data

in BW system.

? Modified the financial data info providers with authorization relevant objects with in

structure to be secured by one authorization relevant info object using hierarchy.

? Created new financial roles with each role having new analysis authorizations inserted based

on hierarchy nodes defined for the role.

? Created new analysis authorizations for each financial role and insert them into associated

role.

? Modified the BW common use role BAXG: XM_COMMON as well as analysis

authorizations that are contained within role to ensure financial cubes are excluded.

? Understanding the scope of changes to a query after the security project implementation.

? Tested Integrated Planning by creating a scenario using real-time info cubes multi providers

and input-ready queries (for manual input).

? Interacting with business users to analyze the business requests for system enhancements and

projects.

? Design and develop a data model for BW requirements and enhanced some extractors to

include additional fields for data extraction.

? Enhancing existing reports to add new functionality based on end user requirements.

? Performing Unit case testing after BW security implementation and also for any other

enhancements.

? Worked on complex routines in transformations and customer exits for reports.

? Created several new queries in BEx using calculated key figures and restricted key figures,

all types of variables, structures and formula variables.

? Created conditions and exceptions in the reports as part of enhancement work requests.

? Created several web reports using WAD and published the reports to portal.

? Worked on performance optimization of queries.

? Identifying the queries and info providers that are not useful further as a part of company?s

transition work.

? Resolving production support ticket issues.

Environment:BW 7.3, ECC 6.0, BEx, BO 4.0, Design Studio, Dashboards 4.0, Spotfire

Sony Electronics Inc., San Diego, CA (Jan 11 ?

April11) Sr. SAP BI/BW Consultant

Responsibilities:

? Extensively Worked on SAP ECC Extraction of Financial data, CO-PA and Logistics.

? Extracted the Master and Transaction Data from Flat files and then loading into Info Objects,

DSOs and Info Cubes.

? Designed, built, tested, documented, and maintained data extractors, transformations, DTPs,

process chains, DSO Objects, Info Cubes, and Multi providers and also created Start

routines and End routines whenever needed.

? Enhanced the Data Sources as per the business requirements.

? Enhanced the Info Cubes by adding custom Info Objects to reflect modified R/3 Business

Process.

? Extensively used Solution Manager for Project Documentation, Maintaining functional and

technical specification documents and managing the Transports.

? Designed and developed process chains, load schedules for loading Master and Transactional

data.

? Performed Unit, Integrity tests and data consistency was verified with ECC 6.0.

? Interacted with the end users to understand their reporting requirements and creating

document of understanding.

? Developed front-end queries using Query Designer and Web Application Designer (WAD)

and publishing results on the web.

? Developed flexible queries with variables using filters, Navigational attributes and

Reusable structures.

? Used Restricted and Calculated Key Figures, Virtual Key Figures, Formula Variables,

Replacement path Variables, Customer Exit Variables, User entry Variables in the

Query Designer.

? Used Cell-Definitions, Structures, Exceptions, Conditions, and various User Exits in the

Reports.

? Designed global structures to incorporate query requirements.

? Created several Workbooks using BEx Analyzer by using the queries created using query

designer.

? Created Web templates for queries and Dash Boards using Web Application Designer and

also worked on the WAD to create specific templates based on the business requirements of

the user.

? Involved in implementing role-based authorization for BI report this involves in plant, Profit

center, and sales organization etc. based authorization.

? Worked on performance tuning using BI Accelerators, Creating Aggregates, Indexes,

Compression and setting Cache properties.

? Involved in various Production support this include trouble shoot and investigating the

production ticket issues and resolving issues in a timely manner.

Environment:BI 7.0, ECC 6.0, Business Explorer, SD, FI-CO, ABAP, WAD

1 Juniper Networks, Sunnyvale, CA Oct?09 ? Dec

?10

2 SAP BI/BO Analyst

Responsibilities:

? Involved in complete life cycle implementation of SAP BI. Involved extensively in

developing the project plan, in blue printing the statement of works for the different sources,

documenting the Info provider manual.

? Involved in interaction with Subject Matter Experts (SME's) for studying their business

requirements.

? Worked extensively on standard and custom defined LIS, LO extractors. Installed

relevant SAP business content. Used LO structures for extracting sales order, delivery

information. Logistics Cockpit configuration and customization.

? Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes

for a data warehousing and Data Migrations projects.

? Used LO-Cockpit extraction for sales order data, the data sources used for extraction

were 2LIS_11_VAHDR (Sales Doc header), 2LIS_11_VAITM (Sales Doc item) and used

extractors 2LIS_13_VDHDR for billing data.

? Responsible for job schedules for loading Master data (Texts, Attributes and Hierarchies).

? Created update rules and transfer rules using routines in ABAP and formula builder.

? Expertise in LO extraction steps of maintenance of extraction structure and delta load

types, scheduled deleting and filling setup tables, maintenance of delta queue.

? 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 detail level of information.

? Integrated SAP BW 7.0 with Business Objects 4.0.

? Created crystal reports and executive dashboards for business opportunities.

? Generated reports based on reporting requirements on purchase order summary, purchase

order details, sales order summary, sales order details and invoice details

? Created and maintained Report-to-Report interface (RRI). Created Web templates

using Web Application Designer to have a consistent look and feel of the reports for the end-

users.

? Involved in creating I-views for web templates. Involved in the final preparation of

performing the go-live check.

? Coordinated integration testing with process teams to validate data and seek end user

acceptance.

? Contributed a series of content development sessions among different business unit

managers to address business group-specific needs.

? Created Functional Design Specifications according to the Business requirements and

created Technical Design Specifications.

Environment:BI 7.0, BO 4.0,SAP ECC6.0 MM, SD, COPA modules, ABAP, Query Designer

&BEx Analyzer.

DexterPvt Ltd, Chennai, India June ?05 ? Sep?07

SAP BI Consultant

Responsibilities:

? Full Life cycle Implementation (BI 7.0) experience includes current system study,

Business requirement gathering, gap analysis, system design, configuration, Regression

testing, Go-Live and Production support for BI 7.0.

? Trained business users on the updated BI 7.0 features.

? Interacted with end-users to gather business requirements and transformed them into

technical work plan.

? Worked extensively on FI-CO, SD, HR, COPA. Loaded the data from ECC to BI and

used initialization with delta update and full update methods.

? Worked with IBPS in converting data from different info providers, queries and BI

objects into info objects or data source objects with new information.

? Implemented standard content for Personal administration (0PA_C01, 0PAPA_C02

cube) to analyze personal data such as head count based on nationality, gender, language,

personnel area, employee group and organizational unit.

? Created DTP?s, Transformations and DSO?s, Info cubes and Multiprovider?s.

? Modified and used standard BI business content Info Cubes and created custom Cubes

and DSO according to the requirements.

? Leveraged on the business content Info Cubes (0SD_C03, 0SD_S13, 0LES_C13, and

0LES_C02) to extract sales and shipping data and did enhancements to fill the user reporting

requirement.

? Created transactional Info Cubes and DSO objects for sales planning in SEM-BPS.

? Worked on BC Cost Center Planning Cube 0SEM_C18. Created Multi Planning Area,

level, Planning Folder, Variables, Planning Area and Package.

? Created Multi Provider on Sales Order/Delivery and Vendor Analysis Account

Payable Line Item cube (0FIAP_C03).

? Created ABAP routines to develop Transformation rules to populate fields or to modify

the existing data according to business requirements.

? Created Multi Providers and Info Sets on which BEx reports were developed and

published queries on web.

? Maintained Process chains to automate and schedule the background performance tuning

jobs of BW query using Indices, aggregates, Compression, Archiving and Partition.

? Modified older queries to accommodate new business requirements and to utilize the

enhanced features offered by

? Done changes to the Queries according to the client requirements to improve the

performance.

? Developed Reports like sales volume for product hierarchy, billing documents, incoming

orders and purchasing group.

? Exported Web templates from the BI to Enterprise Portal as I Views. Developed few

customized web templates using WAD to suit client?s requirement.

? Extensively involved in production support by loading Daily loads/Weekly loads into the

BI system from different source systems.

? Managed and monitored several data loadings, captured the errors and corrected the bugs

and applied several OSS notes for the errors encountered while loading the data.

? Created Query ?Open Manufacturing Orders? that displays the status of the orders that

are finally delivered and to analyze target quantities and scrap quantities.

Environment:BI 7.0, ECC 6.0, Business Explorer, SD, FI-CO, ABAP, WAD

Contact this candidate