Manager Sales

First Name: JAISHANKAR

Last Name: SANKARIAHNAIDU

Email: abhzs2@r.postjobfree.com

BO

Architect/Admin/Sr. Developer

Started working on BO XI 4.0 Ramp up

SUMMARY

Around 9 years of experience, focusing on emerging technologies associated

with Business Intelligence, Business Objects and Data Warehouse Expertise.

> Excellent implementation and production support skills in Business

Objects XI 3.1, 3.0, XI R2, 6.x, 5.x (Architect, Admin, Developer),

Xcelsius 2008 Dashboard, BO Security, Crystal Reports, BO Migration,

Web Intelligence(Thin client), Desktop Intelligence(Thick Client),

QAAWS, Live Office, Dashboard Manager, Performance Manager, OpenDoc,

Auditor, Meta Data Manager, Publication by Schedule and Bursting

Email, FTP, Life Cycle Manager(LCM), BO Mobile, BO Widgets, BO Data

Integrator 11.7, Data modeling, ETL, Roambi Mobile BI

> Independently handled 5 Business Objects and 4 Xcelsius end-to-end

Implementation by connecting different data sources

> Independently handled BO Installations and Migration from 5.x/6.x to

XI R2/3.0/3.1

> Pioneer in creating Complex Reports and Actionable Dashboards and

Scorecards

> Lead the team to successful end to end BO Implementation and BO

Migration from 5.x/6.x to XI releases and upgrade from XI 2.0 to

3.0/3.1

> Extensive Administrator skills on BO Servers, BO-SAP Integrations,

Server Sizing and Server Maintenance

> Architect Server load balance in cluster environment and developed Web

I, Desk I, Crystal and Xcelsius dashboards on top of data sources -

SAP BI 7, BW 3.1, SAP BI 7, Oracle, SQL, DB2, Teradata, SQL Server and

Sybase

> Worked on both Dimensional (star and snowflake) and Entity-

Relationship(ER) Data

> Experienced in working with Business Managers, Architects, End users

and all the stake holders in documenting requirements, providing

estimates, creating High and Detail Level design specifications.

> Worked with business users to identify additional report requirements

and document client requirements. Created Templates for standardizing

the Structure of corporate Scorecards and documents.

> Translated business requirements into architecture and functional

requirements

> Done extensive GAP analysis for Business Objects Reporting

> Worked on below Department Managers to create Scorecards, Dashboards

and detail reports:

o MFG/Operations - Plant Compliance, Supplier Compliance, Trended

Inventory, Production Sales inventory

o Sourcing - EDI, Vendor Management

o HR - Workforce and Turnover

o Sales and Marketing - Territory/Brand management, Corporate

Incentive Test.

o Finance -Sales Order, Billing, Backlog, Margin, Daily Average

Given Training to Department managers and end users in Business Objects

Reporting.

PROFESSIONAL HISTORY OVERVIEW

Engagement Role Scope of Work Year

Intelligroup Senior Business Objects Dec 2008

Principal Architect, Administrator, to till

Consultant Access Security, Universe, date

Client ( Hubbell, Web I, Xcelsius Dashboard

USA developer, Crystal reports

and Trainer to the client

Client ( Hershey, - Hubbell & Hershey

USA

Cognizant Tech Senior Client Requirements, Jan 2008

Solutions US Associate Administrator, Design, to Nov

Corp, Teaneck, NJ (Project Data modeling, Development 2008

07666, USA Lead) of ETL jobs in Data

integrator and BO XI R2

Client ( Trane, Web Intelligence report

USA creation

Cognizant Tech Senior Collecting Client Oct 2006

Solutions, Associate Requirements, Designing, to Jan

Bangalore, India (Project Migration/Development, 2008

Lead) Administrating servers (BO

Client ( 3M, USA XI R2) and High level

Framework Documentation

Datamatics Ltd, Associate BO Administrator (v6.5), Jul 2005

Bangalore, India Software Reporting, Universe to Oct

Client ( Astra Consultant Developer, Supervisor, 2006

Zeneca, India BCA, Client Requirements

Hewlett Packard, Business Data modeling, BO Jun 2003

Bangalore, India Process reporting, Universe to July

Client ( World Engineer Design, Extraction, 2005

wide HP Validation, Quality Check,

Operations Reporting and

Configuration

ASAP Info Consultant Configuration, EIM etc Jul 2002

Systems, to Jun

Bangalore, India 2003

Educational Qualification - Master of Technology

RELEVANT EXPERIENCE

Intelligroup

Client Name - Hershey Foods, Hershey, PA

Project Name - Business Intelligence (BO) Implementation

Period - Mar 2010 - Till Date

Software - BO XI 3.1, Xcelsius 2008, Web I, Crystal reports 2008,

Teradata, SAP BI 7.0, Oracle, Sql server

Project Summary:

Hershey decides to roll out Enterprise Level Business Objects as their

Front End reporting tool. Currently they have Cognos as reporting tool and

decide to move all Cognos reports to BO reports and all future reporting

needs will be leveraged by Business Objects tool. Hershey does not have any

BO full time resource and I am the only consultant who started BO

implementation and trained all Cognos Developers on Business Objects.

1. As an Architect, laid down the complete BO road map for Hershey, as

Hershey doesn't have any Business Objects Resources in their team

2. Architect Business Objects reporting strategy for both SAP and Non SAP

Source data

3. Architect Business Objects Security and Access Restriction and apply

those security in CMC

4. Keep updating Hershey on BO XI 4.0 tools set and future road map for BO

5. Involved in all BO Tools selection for Hershey's new reporting

requirements

6. Architect roadmap to call reports, dashboards and scorecards from

external portal (Java Portal)

7. As a Senior developer, created Supply Chain and Executive Dashboard in

Xcelsius

8. Customized Xcelsius Dashboard as per different business needs

9. Created complex BO Universe, Web I for Finance, Marketing and Supply

Chain

10. Created document and uploaded in portal for Roadmap, Tool Selection

scenario and Training documents

11. Created Publication for mass publication of reports

12. Complete end to end monitoring Server performance and Server timeout

issues

13. Implemented and trained Hershey Team on Life Cycle Manager

14. Trained Client team on Xcelsius and Universe, Web I reporting

Client Name - Hubbell Incorporated, Spartanburg, SC

Project Name - Business Intelligence Migration

Period - Dec 2008 - Mar 2010

Software - BO XI 3.0, XI R2, Xcelsius 2008, Web I, SAP BI 7.0, SAP Net

weaver Portal, Crystal reports 2008, Sql server

Project Summary:

Hubbell decide to upgrade their SAP BW 3.x to SAP BI 7.0 and to implement

Business Objects and SAP Net weaver Portal as front end reporting tool on

top of BI 7.0. Finance, Sales and Marketing, Sourcing, HR, Manufacturing

data are critical to first phase of implementation to get maximum BI to get

business decision data.

15. Install BO 3.0 Servers and Configured on top of SAP BI 7.0 with BO-SAP

Integration kit

16. Installed Xcelsuis and Crystal reports 2008 environment and integrated

to SAP BI.

17. Configured Security access for end users in CMC

18. Created Universe, Web I reports for Finance, Sales and Marketing and

Sourcing

19. Created Xcelsius Dashboards, Scorecards and published in Info view and

SAP Portal

20. Created Crystal Reports for high level structured reports

21. Created Dynamic Publication to leverage automatic and quick publication

of reports

22. Created BEX queries as a source for all BO Universes

23. Complete end to end monitoring Server performance

24. Publish all the reports, dashboards and scorecards in SAP Net weaver

Portal.

25. Trained Client team on Xcelsuis and Web I reporting

Cognizant Technology Solution (US/India)

Project - 1:

Client Name - Trane, La Crosse, WI, USA

Project Name - Trane Enterprise Data Warehouse (EDW)

Period - Jan 2008 - Nov 2008 (Team Lead)

Team size - 4

Software & Tools - BO XI Data Integrator 11.3/11.7, BO XI R2 Web I, Oracle,

Sybase, DB2

Project Summary:

Trane as a Manufacturing Client plans to stream line all their data marts

to one place by Business Objects Data Integrator (BODI) to achieve the goal

of having one-source to trust the data. Currently all the loads are

happening through PL/SQL Packages. As first phase all Finance and HR

modules are completed and the ETL architecture is build out by BODI.

1. Install BODI 11.3/11.7 and BO XI R2 Web Intelligence Environment like

BO CCM, CMC, Servers, Designer, etc., both in Trane (Onsite) and

Cognizant India (Offshore)

2. Configuring BO XI R2 Servers in Windows 2003

3. Scheduling the Web I reports with minimal load to BO servers

4. Adding Users with the corresponding Authorization and Authentication

5. Support 24*7 with On-call support during weekends.

6. Study the existing Start schema data model and data load and design

the ETL as per BODI Standards

7. Design BO ETL Jobs, workflow and dataflow for various business

applications of Trane

8. Develop the jobs, reports and migrate the same to Production

9. Participate in all data modeling sessions from reporting perspective.

10. Providing support during the User Acceptance Support.

11. Go Live - supporting the move of the developed objects to BO XI R2

production.

Project - 2:

Client Name - 3M, Minneapolis, USA (working from offshore Cognizant,

India)

Project Name - 3M Business Objects Migration

Period - Dec 2006- Jan 2008

Team size - 29 (Team Lead)

Software & Tools - BO XI R2, Dashboard Manager, Teradata, Oracle, Sql

Server

Project Summary:

3M, as a part of its business strategy, plans to upgrade its current

Business Objects environment from 5.X to Business Objects XI R2 WebI

Platform. Below are the detail steps:

1. As a BO Tech lead, setting up the 3M Migration Environment at

Cognizant Offshore

2. Architect BO Migration Strategy for Servers and reporting assets

3. Document all best practices, pain points occurred during the migration

4. Installation of BO Performance and Dashboard Manager

5. Migrated around 7,800 BO 5.x Desk I Reports to BO XI R2 Web I for all

Teradata data sources.

6. Analysis of Free hand SQL BO 5.X reports for Teradata Data Source and

redeveloping the same in BO XI R2 Webi either by using the existing

universe or by using Teradata Database view and enhancing Universe

with new objects.

7. System testing of the migrated reports.

8. Providing support during the User Acceptance Support.

9. Go Live - supporting the move of the upgraded Business objects reports

to BO XI R2 production environment.

10. One month of post Migration Support after the reports are moved into

production.

11. Dimensional data model - star and snowflake schemas

Project - 3:

Client Name - Abbott Laboratories, IL, USA (working from offshore

Cognizant, India)

Project Name - Abbott GPO BICC

Period - Oct 2006- Dec 2006

Team size - 4

Project Summary:

The Global Pharmaceutical Operations of Abbott (GPO) has come up with a 3-

year roadmap and a BI strategy addressing the business need, technical

platform and BI management/ governance aspects. This roadmap provides the

strategy to build Business Intelligence Competency Center (BICC) to support

the GPO BI needs.

Project - 4:

Client Name - Cognizant Technology Solutions, Chennai, India

Project Name - Insight Compass

Period - May 2007- Jan 2008

Team size - 12

Software & Tools - BO XI R2, AIX 5.1, DB2, Oracle, Sql Server

Project Summary:

Cognizant technology wants to realize the customer revenue, customer

satisfaction; customer forecast revenue, Account manager's revenue to

Cognizant, Revenue per associate. They had some of the above reports in

Cognos with just 120 Licenses. So there are 7 full-time Finance employees

who generate reports in excel from Cognos and split the excel based on

Customer Security and send to the Account Manager and Vice President.

Insight Compass came with Solution Approach to deliver the reports directly

to Account Manager and Vice President by Business Objects reports. This

approach benefits Cognizant to track the customer very closely on revenue,

satisfaction and realize revenue earlier.

Datamatics Ltd

Client Name - AstraZeneca Pharma India Limited (AZPIL), Bangalore

Project Name - Astra Zeneca Business Intelligence Project

Period - July 2005- Oct 2006 (Team Lead)

Team size - 4

Software - BO 6.5.1, BCA, Email Publisher, Application Foundation

6.5(Dashboard), Oracle, Sql Server

Project Summary:

AZPIL has decided to implement Business intelligence on Sales and

Marketing (phase I) and GL (Phase II) in order to assist the Sales and

Marketing and Finance personnel and top management with critical real time

information such as Total sales achieved, Average Price realization made,

Area wise Sales etc., in a very user friendly format.

26. Install and configured BO 6.5 WebI server, Dashboard, BCA, Email

Publisher, BO tools for remote clients

27. Maintenance of server settings with respect to the Load Balance

28. Managing User profiles/security by Supervisor and Admin Console

29. Created Universe for General Ledger and Sales & Marketing

30. Scheduled Reports as per business needs (remote users) through BCA

(Broadcast Agent)

31. Email Publication (BO 6.5) through Microsoft Outlook for remote users

32. Dashboard Manger (Application foundation) for high level business

analysis

33. ER data model - OLTP data for Sales and Order.

Hewlett Packard

Project Name - Leap Frog Project

Period - June 2003- July 2005

Team size - 26

Software & tools - Business Objects, WebI, BO 6.5.1, TOAD, Oracle, Sql

Sever, Siebel, MS Access

Project Summary:

34. Created Reports for EMEA and ASIAPAC Customers by Business Objects

35. Customized the Siebel Applications as per the business needs.

36. Extraction, Deduplication, and Validation of Accounts and Contacts for

38 Countries (Asia Pacific, EMEA and USCC) using BO reports.

37. Responsible to Update Data Quality Reports (totally 530 reports)

monthly for 38 Countries in the following website:

http://finance.hp.com/bangalore/processes/of/cdm/index.htm

38. CAS - CID Address Standardization and NCRF (New Customer Reference

file)

39. EMEA PRM Reporting for 26 Countries, Candidate Validation and

Enrichment of Data

Achievements (Cognizant Technology Solutions):

. Completed BO report migration for 3M of around 7800 reports from BO 5.x

to BO Xi R2

. Worked for Trane, La Crosse, Wisconsin as a Consultant for both Reporting

and ETL - ( BODI) Business Objects Data Integrator

. Worked for Abbott Client to draft the entire BICC (Business intelligence

Competence Center)

Achievements (Datamatics):

. Completed Astra Zeneca India BO implementation for Phase I & II (Sales &

Marketing and Finance)

. As a BO Trainer, I have given training to various levels of business

users (from VP Finance to business analysts) in Various BO components

. Collected various statistics to improve server and report performance

. Configured Microsoft Outlook with BO Publisher to send Email reports (in

Excel and PDF) for remote users.

Achievements (Hewlett Packard):

. Played a Key role in reducing the duplication from 27.8% to 0.1% for 36

Countries within 6 Months.

. Worked effectively both as Technical and Functional with 36 CRM's by

country and 26 PRM's (EMEA) by country.

. Got 1 Silver Award for Quality and 2 Bronze Awards, one for handling

different projects and increased the business in every quarter and the

other for Quality Control.

Reference:

Olin Bob Robert, Pascal

Vouille

Senior Director of Systems Development, WW Customer Information

&Quality Manager

Hubbell Incorporate, Hewlett Packard, 19447 Pruneridge

Ave.

Spartanburg, SC, Cupertino, California. 95014-0683

Mobile No: 864-***-**** Tel No: +1 (408) 447-

3987

Email Id: abhzs2@r.postjobfree.com Email Id:

abhzs2@r.postjobfree.com

Upon request - I can send

more reference

BUSINESS OBJECTS:

Implementation and Migration - EXPERT

Production Support - EXPERT

Server Install / Administrator - EXPERT

Universe Developer - EXPERT

Web I/Desk I report Developer - EXPERT

XCELSIUS 2008 Dashboard - EXPERT

CRYSTAL Reports - EXPERT

BO - SAP Integration - EXPERT

BO Data Integrator - Advanced

Contact this candidate