Supply Chain Project

YUGANDHAR MANERI

B USINESS A NALYS T

Email: ***************@*******.***

Cell: 224-***-****

CAREER OVERVIEW

Accomplished Business Analyst skills in achieving operation efficiency and understanding of

business performance based on data and statistical methods.

Very good understanding of Business Intelligence and Data Warehousing concepts with

emphasis on Analytical Reports and ETL and having working experience in application development,

customization using Siebel Analytics and OBIEE technologies.

Over the span of 6 years I have worked on major programs / projects such as

Development & Enhancement in Data warehousing applications for Business Intelligence (BI) –

Motorola Mobility, INC

System Analysis, System Design and Development of Batch load processes using Business

Intelligence tools like Informatica and obiee in Telecom Data Warehouse System

Experienced Computer Systems Analyst with diverse industry experience in Telecom Domain.

Having Functional/Technical experience in supply chain management process which involves

Shipments, Inventory, Orders & Finance related Subject areas

CORE COMPETENCIES

Enthusiastic and adaptive to new technologies

Strong Analytical and problem solving skills

Forecasting and planning Business Systems analysis

Excellent communication skills and good in people relationships

Target and performance oriented

ACCOMPLISHMENTS

Automated the monthly metrics operations which provides the apt information to business on

improving work flow

Led a 8 person team of Business Analytics project which focuses on the supply chain operations

in Telecom domain

Attended trainings on ITIL process to improve the quality of process outputs

Oracle Certifications

EMPLOYMENT SUMMARY

Employer From To

Tata Consultancy Services 06– Feb– 2008 Till Date

PROFESSIONAL SYNOPSIS - PROJECTS

1 Feb 2009 – Till date

Motorola Mobility

Position - Application Developer

Motorola - OBIEE - Business Intelligence (BI)

Roles and Responsibilities

1. Participated in User Focus group meetings to gather requirements

2. Prepared Dashboard and Report specifications

3. Created meta data repository (.rpd) and configured with Physical, Business Mapping and

Presentation layers

4. Used aggregate tables as additional logical table sources to improve the performance

5. Used level based measures to provide additional logical columns for appropriate dimension

levels

6. Created initialization blocks and repository and session variables to implement security

7. Created role based dashboards and reports for end users

8. Worked on the fixing dashboard errors and analyzing the OBIEE infrastructure issues

9. Requirement Analysis for the change requests

10. Design and development of change requests

11. Worked on BI Answers to build Interactive Dashboard with drill-down capabilities

12. Worked on Automating the metrics using obiee tool

Since May 2012 Tata Consultancy Services

Title: MOTOROLA Mobility –EDW/MDW/Imaps (Planning transformation) Support

May 2012 – till date

Period

Motorola Mobility

Client Name

Data Warehousing

Domain

TeamMember

Position

Project

Information Management is a support and enhancement project of a Data Warehouse (EDW) of

Motorola - Mobile Devices sector. This is an one-stop-shop that serves the reporting needs of

Supply Chain, Finance, Service, Sales Forecasting,Supply and Demand Planning. Informatica

9.1 is being used to extract data from 13 different ERP & Non-ERP systems. Analytical and

Operational Reports are provided via Oracle Business Intelligence and Business Objects

applications. This is an ideal platform for reporting current as well as Historical data without any

performance hindrances

IMAPS aims at providing demand/supply reports to the customer. Provides customer the

information to view forecast/demand ratio in Mobile Devices. This project is mainly to make as a

single system to mange demand and supply for different regions. Source is ODP and Data ware

house is EDW, main aim of this project is to deliver reports to users based on which they can take

decisions regarding Demand and Supply.

Responsibilities:

1. Involved in application maintenance for the entire system.

2. Trouble shooting implementation / post implementation issues.

3. Handling trouble Service requests/concerns raised by users.

4. Identifying existing bugs or any performance issues in the existing system

5. Ensure that the Service/Problem requests raised by the customers are resolved and

the SLA is met.

6. Done History fix for the missed data.

7. Analyzing or identifying Data Issues If any be it related to BO /Informatica and fix the

same.

8. Suggesting performance tuning options to improve the productivity and application

enhancement.

Frequent communication with the customers to ensure that the reports are distributed on time

within SLA or intimate them if there is any delay

Feb 2009 - Mar 2012 Tata Consultancy Services

Title: MOTOROLA- OBIEE (Oracle Business Intelligence Enterprise Edition) Support

Feb 2009 – Mar 2012

Period

Motorola Mobility

Client Name

Technical Lead

Position

Project

OBIEE Support, maintenance provides 24/7 support to the OBIEE application, bug

fixes, small enhancements and performance tuning. The support team used to take care of

analysis, design and Implementation of change requests. Resolving the Issues raised by the

users of OBIEE application.

OBIEE is a comprehensive BI platform which provides information on several dashboard

reports like supply chain, GSPPR, BMC Incident management, Motorola SRT etc to the senior

management team. It includes a full range of easy-to-use and intuitive end-user tools such as

Interactive Dashboards, advanced reporting and publishing, full ad-hoc analysis over the Web,

proactive detection and alerts and more.

Responsibilities:

1. Solving the L3 issues created by users through MONET tool (Client Application)

2. Working on the fixing dashboard errors and analyzing the OBIEE infrastructure

issues

3. Having good knowledge on the processes that will run on Presentation servers and

BI servers

4. Working on the Apex related stuff

5. Setting up the call with the required people to resolve the infrastructure issues

6. Actively participated in doing the Major / Small / Emergency projects which comes as

an enhancements or project request

7. Fixing various data and application issues using Informatica and business objects.

8. Involving in production maintenance for the entire system.

9. Trouble shooting implementation / post implementation issues.

10. Identifying existing bugs or any performance issues in the existing system.

11. Monitor the whole Reporting and Data warehouse System and ensure that the data

being loaded in to the system on time.

12. Scheduling the BI reports using ibot

July 2008-Feb 2009 Tata Consultancy Services

Title: DSC/LSC/ISC - Digital Supply Chain/Lean Supply Chain/Integrated Supply Chain

July 2008 – Feb 2009

Period

Motorola

Client Name

Team Member

Position

Project

The project is about providing support to the DSC/LSC/ISC applications for Motorola.

• DSC is a web based application that provides supply chain related information to the

executive users in the form of dash boards and reports. This application is being used

by users globally. Data from DSC is also sent to executives over Q phone.

• LSC (eMart) is a web based application that provides inventory, forecast and sales

order information in the form of reports.

• ISC is a Data Warehouse application that provides supply chain related information

(Finance, Quality, and Sales Orders) to the executive users in the form of reports

The business logic for these applications are designed in PL-SQL, J2EE (struts), Informatica and

the OS being Unix

Responsibilities:

Involved in Monitoring and Analysis of tickets using BMC ticketing tool

1.

Involved in Monitoring of jobs running in all the three applications

2.

Handling enhancement request for all three applications

3.

Resolving Service requests/concerns raised by users

4.

Creating and handling monet tickets for issues related to Motorola through BMCtool

5.

Providing daily status to the clients on the application related issues

6.

Providing Root cause Analysis for the High/Critical incidents.

7.

Involved in the preparation of SOP and project related documents and uploaded the

8.

documents in Compass

9. Provide proper Handshake between the Applications

Feb 2008-May 2008 Tata Consultancy Services

Title: Initial Learning Period

Period Feb 2008 – May 2008

Position Trainee

Responsibilities

Took Training at TCS Training Centre in Trivandrum, Kerala. It provided a strong basis to

work in the IT industry with training in technologies like Oracle, UNIX, C and C++

Location Trivandrum, Kerala

Training Conducted:

Year Title Presented to Locatio

n

201 Bangalor

2 OBIEE Knowledge Transfer MMI e

Trainings Attended:

Year Title Location

200

8 Initial Training Program TCS,Chennai

200

8 IPMS,IQMS TCS,Chennai

200

9 Informatica Training TCS,Chennai

200

9 OBIEE Training TCS,Chennai

2011 ITIL Process TCS,Chennai

Contact this candidate