Senior SAP BI BO Consultant

Description

SKILLS

RESUME

SUMMARY:

Sandeep Chandran has been in the Information Technology Industry for the past 8 Years and 2 months. He has been working in the data-warehousing technology for the past 98 months primarily on BI tools like Business Objects, Crystal Reports, Cognos and databases like Oracle, SQL Server.

He has been involved in all phases of Data warehouse projects during his tenure that includes Requirements gathering, Onsite-Offshore coordination, Analysis & Design, Development, administration and production support.

He has been working primarily as a Senior BI-Developer responsible for coordinating and successfully executing project.

Overall 8 years of sound experience in IT industry.
5 years of experience in SAP BI (BI 4.0,4.1 & Crystal Reports).
2 years experience as BO Administrator (SAP BI 4.x)
2.3 years of experience in Cognos

TECHNICAL SKILLS

Expert in Universe development (IDT) and Report development (SAP BI 4.x,Crystal report enterprise).
Worked on reports with complex query on query, sub query and combined queries.
Expert in complex reporting scenarios.
Have a good understanding of business objects architecture.
Have worked in BO 3.1 to 4.0 migration project and fixed several report issues in 4.0 environments.
Involved in Installation, Configuration, and Deployment of SAP BI 4.0, 4.1 servers.
Promoted universes and reports to the production with the help of Promotion Management/L

Main Skills

Other Skills

BugZilla

Programming Languages

Metadata

Crystal report

SAP Business Objects

BOBJ

database

windows environment

Windows XP

Crystal Reports 2008

Toad

Kerberos

databases

SQL

Computer Science

PL/SQL

SAP

SQL server 2000

Data warehouse

SAP BI

ServiceNow

Windows

C++

Powerplay

Windows XP Professional

Cognos BI

System Integration Testing

SAP BO

Unit Test

Business Objects

Windows 7

Unit Testing

Crystal Reports

backend

Clearcase

System Testing

Information Technology Industry

ETL

servers

Oracle 10g

Cognos

SQL Server

Cognos Report

Cognos reportnet

MS SQL Server

Java

SQL Server 2005

SAP BW

Perforce

MS Office

DB2

Oracle

user acceptance Testing

authentication

Bug Fixing

UAT

Reporting Tools

Oracle 9i

Work & Experience

17.07.2012 — 19.10.2012

Onsite Coordinator

PROJECT PROFILE: 3 Project Title SAP-GD BOXI 3.1 Migration Duration 07/17/2012 - 10/19/2012 Location Montreal, Québec, Canada Hardware Client laptop, Pentium Based PC's. Operating Systems Windows XP Professional, Windows 7 Databases & Tools Oracle, DB2,Report conversion tool Reporting Tools BO XI R3. PROJECT DESCRIPTION: Client has engaged CTS India to migrate to a new infrastructure and framework for reporting services that uses the SAP Business Objects Enterprise business intelligence (BI) platform and technologies. The project deals with migrating BO 6.5 reports to BO XI R3. The scope of the project includes Report conversion, Unit Testing, Fixing, System Testing, User Acceptance Testing and Support. CLIENT DESCRIPTION: Client is a leader in the North American rail industry. Following its acquisition of Illinois Central in 1999, WC in 2001 and GLT in 2004, as well as its partnership agreement with BC Rail in 2004, Client provides shippers with more options and greater reach in the rapidly expanding market for north-south trade. ROLES AND RESPONSIBILITIES: Project Role: Onsite Coordinator * Migration of BO6.5 reports to BOXI reports using Report Conversion tool. * Determine the complexity of reports. * Analyze and fix the BO migration issues * Quality Check of reports. * Onsite Offshore coordination. * BO Support Helpdesk activity for End users. * Quality Check of reports * Deployment of reports in production environment. * Involved in Defect Management and Defect Prevention Activities. PROJECT PROFILE: 4 Project Title SAP BO Report Development Duration 11/02/2011 - 04/15/2012 Location Kochi Hardware Client VM, Pentium Based PC's. Operating Systems Windows XP Professional, Windows 7 Databases & Tools SAP Bex 7.0 Reporting Tools SAP BI 4.0 PROJECT DESCRIPTION: Client has engaged SAP Field Services to develop a new infrastructure and framework for reporting services that uses the SAP Business Objects Enterprise business intelligence (BI) platform and technologies. The project deals with developing BO 4.0 Reports. Source of data is SAP BW and reports are connecting through Bex Queries. The scope of the project includes Technical Documentation of Report Specifications, Report design and development and System Testing and User Acceptance Testing. ROLES AND RESPONSIBILITIES: Team Lead * Leading a team of 6 members * Involved in the allocation of tasks allocated for resources in team. * Analyzed report requirements and developed Web intelligence reports connecting Bex queries. * Modifying SAP Bex 7.0 Queries. * Preparation of Unit Test Cases * Quality Check of reports * Providing training for new resources on BO 4.0 and BeX Queries. * Knowledge transfer for new resources. * Coordinating with network team to resolve project environmental issues. * Deployment of reports in production environment. * Involved in Defect Management and Defect Prevention Activities. * Involved in translating reports to multiple languages using SAP BO TM 4.0

11.05.2012 — 21.12.2012

Offshore Technical Lead

PROJECT PROFILE: 2 Project Title SAP-GD BOXI 3.1 DESKI to WEBI Migration Duration 11/05/2012 - 12/21/2012 Location Cochin, Kerala, India Hardware Client VM, Pentium Based PC's. Operating Systems Windows XP Professional, Windows 7 Databases & Tools Oracle, DB2,Report conversion tool Reporting Tools BO XI R3.1 DESKI and WEBI Project Description: The Client has engaged CTS India to migrate their existing BO XI 3.1 DESKI reports to convert to BOXI R3.1 WEBI reports. The scope of the project includes Report conversion, System Testing and user acceptance Testing and defect fixing. Duration: Oct '12 to Dec'12 Client Industry: Insurance Project Role: Offshore Technical Lead at Cochin, Kerala, India ROLES AND RESPONSIBILITIES: * Migration of reports to BOXI WEBI reports * Determine the complexity of reports. * Assign tasks to team. * Interact with team to resolve all the technical issues. * Analyze and fix the BO migration issues * Providing training to new resources on BOXI. * Quality Check of reports. * Onsite Offshore coordination.

23.03.2010 — 30.11.2010

Module Lead

PROJECT PROFILE: 5 Project Title SAP-BO-Crystal Migration Duration 03/23/2010 to 11/30/2010 and 06/02/2011 to 10/30/2011 Location Kochi Hardware Client VM, Pentium Based PC's. Operating Systems Windows XP Professional, Windows 7 Programming Languages MS SQL Server 2005, Actuate Tools Used Crystal Reports 2008,Oracle PROJECT DESCRIPTION: Customer has engaged SAP Field Services to develop a new infrastructure and framework for reporting services that uses the SAP BusinessObjects Enterprise business intelligence (BI) platform and technologies. The project deals with migrating Actuating Reports to Crystal Reports The scope of the project includes Technical Documentation of Report Specifications, Report design and development and System Testing and user acceptance Testing CLIENT DESCRIPTION: One among the leading Financial services giant in world. As of 2009, they are the fourth largest bank holding company in the United States by domestic deposits. Customer has retail banking operations in more than 100 countries and territories around the world. ROLES AND RESPONSIBILITIES: Module Lead * Leading a team of 4 Members * Involved in Requirement Analysis * Involved in Technical Documentation * Developing Crystal Specification report from Actuate Spec. * Development of Crystal Report * Preparation of Unit Test Cases * Executing the test cases. * Involvement in System Integration Testing * Deployment of reports in production environment. * Involved in Defect Management and Defect Prevention Activities.

12.02.2010 — 20.01.2011

Team Member

PROJECT PROFILE: 6 Project Title SAP-GD Cognos to BO Migration Duration 12/02/2010- 01/20/2011 and 04/01/2011 to 05/30/2011 Location Kochi Hardware Client VM, Pentium Based PC's. Operating Systems Windows XP Professional Databases & Tools Oracle 10G Reporting Tools Business objects XI R3, Cognos reportnet PROJECT DESCRIPTION: This project is a migration from IBM-Cognos to Business objects BI. Project requires strong knowledge in Business Objects BI enterprise, IBM-Cognos BI and Powerplay transformer. Around 3 years of experience and good exposure to the Cognos, Business objects Enterprise suite. The project mandates an experience in data model design and high exposure to Cognos cubes and Relational models in Cognos. CLIENT DESCRIPTION: Client is undertaking an initiative to implement a migration project from Cognos BI to Business objects. This is to unify the Reporting system of two groups within organization, which were working as two separate companies before. In the current environment there are multiple reporting platforms used by different teams. Currently one division of the company is using Cognos based reporting system and another division is using Business objects as there reporting platform. As the costs involved in maintain two separate reporting platforms is more, Customer planned to have single reporting platform for both the divisions. They have selected Business Objects for this purpose. For this purpose, existing Cognos reporting system is migrated into Business objects. ROLES AND RESPONSIBILITIES: Team Member * Analyze the existing Cognos reporting environment in order to identify the technology differences between Cognos and BO * Act as an SME in Cognos report studio and Cognos Power play. * Assisting the BO team to identify the technical limitations in migrating from Cognos to BO and discussing different options with user. * Assisting the BO team in UAT to validate the BO reports with the Cognos reports * Assisting the ETL team to create Data mart by providing the details regarding Cognos cubes and different logic involved to develop the cube. * Developing BO reports and doing report review to ensure quality deliverables. * Developing Crystal reports and doing report review to ensure quality deliverables.

07.12.2009 — Now

Cognizant Technology Solutions Private Limited

Senior Associate

Till Date 5 Years and 5 months

09.01.2009 — 27.11.2009

Team Lead

PROJECT PROFILE: 7 Project Title BOXI Migration Project Duration 09/01/2009- 11/27/2009 Location Bangalore Hardware Client VM, Pentium Based PC's. Operating Systems Windows XP Professional Databases & Tools Oracle 9i Toad for oracle Reporting Tools BO XI R3., BOXI 6.5 PROJECT DESCRIPTION: BOXI Migration Project includes the migration of around 200 core BO 6.5 reports into BOXI 3.1, Unit Test and Bug Fixing of these reports. ROLES AND RESPONSIBILITIES: Team Lead * Estimating the work * Allocating the work to team members * Consolidating test reports done by individuals * Helping team members to resolve BO specific Issues. * Writing test cases for the reports. * Unit testing the reports. * Fixing the issues.

08.01.2009 — 27.08.2009

Team member

PROJECT PROFILE: 8 Project Title Cognos 8 POC Duration 08/01/2009- 08/27/2009 Location Bangalore Hardware Pentium Based PC's. Operating Systems Windows XP Professional Databases & Tools MS SQL server 2005 Reporting Tools Cognos 8 BI tools PROJECT DESCRIPTION: This was a Proof of Concept executed for a leading IT firm. The goal was to implement Business Intelligence using the Sales and Trade Promotions data, to demonstrate the Cognos reporting capabilities. The key objective was to measure and analyze the Revenue and Performance of Agents depends on sales of a particular product of Airline. Cognos Framework manager was used to design the model with MS SQL Server 2005 as the database. Cognos Report studio 8.4 was used to develop the reports. ROLES AND RESPONSIBILITIES: Team member * Functional Analysis of the source Files. * Designing and developing the Data Warehouse using various ETL tasks to clean data and make it in a uniform format. * Creating relationships among tables in SQL Server 2005. * Developing the Dimension model in Cognos framework manager. * Creating reports in report studio based on requirements.

05.01.2008 — 06.01.2009

Specialist Tour Operators Management Information (STOMI)

PROJECT PROFILE: 9 Project Title Specialist Tour Operators Management Information (STOMI) Duration 05/01/2008- 06/01/2009 Location Bangalore Hardware Client VM, Pentium Based PC's. Operating Systems Windows XP Professional Databases & Tools MS SQL server 2000 Reporting Tools Cognos Reportnet PROJECT DESCRIPTION: This is a maintenance and enhancement project. Caters to Specialist tour plans. It's managing the information on bookings done for the seasons. Once the season begins, the customers should be able to View the no of bookings by flight & accommodation unit on a daily basis. It also provides the inventory information of accommodation and flights. This MI project handles information of Specialist offices in different overseas countries. ROLES AND RESPONSIBILITIES: Team member * Analyzing the system/ application. * Taking backup of existing reports. * Analysis of Requirements, Development, Unit Testing and Post development Support for Cognos reports. * Testing of developed reports by writing queries to verify data at backend. * Monitoring SQL server 2000 Jobs. * Documenting some of the existing process in the application. PROJECT PROFILE: 10 Project Title Planning and Yield Management Information (PYMI) Duration 05/01/2007- 05/01/2008 Location Bangalore Hardware Client VM,Pentium Based PC's. Operating Systems Windows XP Professional Databases & Tools MS SQL server 2000 Reporting Tools Cognos Reportnet PROJECT DESCRIPTION: This is an ongoing maintenance and enhancement project. Caters to Planning & Trading and Finance departments. 'Planning' team takes interest in comparing the sales plan VS actual holiday purchases on a daily basis. Once the season begins, trading function should be able to View the no of bookings by flight & accommodation unit on a daily basis. Finance- Keeping Track of Revenue. Finance department is interested in the contribution/profit on each booking. Tracking and solving issues raised by client. . ROLES AND RESPONSIBILITIES: Team member * Communicating with the Onsite coordinator for gathering the functional/business requirements of the entire Project. * Functional Analysis of the source database. * Modifying the Dimension model using Powerplay transformer depend on the requirements. * Developing the Powerplay cubes. * Testing of developed cubes by writing queries to verify data at backend. * Tracking and fixing of UAT issues. * Involved in the Analysis of report outputs in Cognos to fix the issues from ETL side.

28.03.2007 — 27.11.2009

Sonata Software Ltd; APS Trust Building

System Analyst

2 Years and 8 Months PROJECT PROFILE: 1 Project Title SAP BI 4.1 Development Project, SAP BI 4.1 Support Project Duration 12/24/2012- Till Date Location Cochin, Kerala, India Hardware Client VM, Pentium Based PC's. Operating Systems Windows XP Professional, Windows 7 Databases & Tools SQL Server, Oracle, EC and Query tool Reporting and Metadata design Tools SAP BI 4.0, 4.1 WEBI, Crystal report enterprise edition ,BO 4.0,4.1 IDT Project Description: Client is one among the leading organization in Oil and Gas industry (Europe and US). The Client has engaged CTS India to develop new reports and universe for few of their departments. The data in client production system(Energy Components), which is stored in SQL server to create BI on top of that information. The scope of the project includes Requirement gathering, Client meetings, Universe design, report development, user acceptance Testing and BO Administration activities. Duration: Dec 24 th '12 to Till Date Client Industry: ManLog/Energy & Utilities. Project Role: Offshore Project Lead at Cochin, Kerala, India Project Responsibilities: * Universe design based on the report specification. * Develop reports based on the universe. * BO Admin activities for the Support project * Installation of SAP BI 4.x on windows environment and implementing Windows AD configuration (SSO). * Troubleshooting various environmental issues like AD authentication issues, server performance issues etc. * Upgrading of SAP BI servers and implementing security * Creating Users and user groups. * Assign tasks to team. * Interact with team to resolve all the technical issues. * Providing Support for all the BOBJ issues. * Quality Check of reports. * Onsite Offshore coordination.

01.01.2005 — 31.12.2021

freelancermap GmbH

× Newsletteranmeldung erfolgreich Sie haben sich erfolgreich für den freelancermap Newsletter angemeldet.

ZEITLICHE UND RÄUMLICHE VERFÜGBARKEIT; Informationen für Agenturen

Informationen für Freelancer

Project Manager: Jabir.NM- 91-9895305854 Project Manager: Jaykrishnan Ramachandran-91-9895761487 ZEITLICHE UND RÄUMLICHE VERFÜGBARKEIT Flexible to any location preferably in US/Canada/Europe,Dubai KONTAKTANFRAGE VERSENDEN Sie können diesen User nicht kontaktieren, da dieser auf Ihrer Blacklist steht. Nachricht: Betreff * Anschreiben * Absenderdaten: Name * Firma E-Mail * Telefon * Plz * Stadt * Land * Land wählen Deutschland Österreich Schweiz Großbritannien USA Russische Föderation Spanien Italien Liechtenstein Ukraine Ungarn Neuseeland Frankreich Slowakei Antigua and Barbuda Algeria Albanien Ägypten Argentinien Armenien Australien Bahamas Bahrain Bangladesch Barbados Belarus Belgien Belize Benin Bermuda Bolivien Botswana Brasilien Bulgarien Chile China Costa Rica Dänemark Dominikanische Republik Estland Finnland Georgien Grenada Griechenland Guadeloupe Guatemala Guinea Guyana Haiti Hongkong Indien Indonesien Irak Irland Island Israel Jamaika Japan Jordanien Kamerun Kanada Kazakhstan Katar Kenya Kirgisistan Kolumbien Kroatien Kuba Kuwait Lettland Liberia Litauen Luxemburg Mazedonien Malaysia Malta Marokko Mexico Monaco Montserrat Mosambik Namibia Nepal Niederlande Norwegen Oman Pakistan Paraguay Peru Philippinen Polen Portugal Puerto Rico Rumänien Sambia Saudi Arabien Schweden Senegal Zimbabwe Singapur Slowenien Sri Lanka Südafrika Tadschikistan Thailand Tschechische Republik Tunesien Türkei Uruguay Usbekistan Venezuela Vereinigte Arabische Emirate Yemen Zypern Libanon Serbien Bosnien-Herzegowina Vietnam Nigeria Moldawien Marschallinseln Palau Samoa Cookinseln Angola Grönland Trinidad und Tobago Equador Fidschi Inseln Papua-Neuguinea Tansania Äthiopien Kongo Swaziland Niger Ghana Südkorea Nordkorea Mongolei Kambodscha Myanmar Azerbaijan Syrien Afghanistan Iran San Marino Montenegro Mauritius Uganda Palästina Panama El Salvador Honduras Libyen Malediven Nicaragua Madagascar Sudan Website Anfrage verschicken × Profil herunterladen Welche persönliche Daten sollen in dem Dokument sichtbar sein: Name Telefon E-Mail Stunden-/Tagessatz Profil herunterladen AUFTRAGNEHMER * Informationen für Freelancer * Informationen für Agenturen * Projekte finden * Musterverträge * Berufshaftpflicht * Preise und Leistungen

AUFTRAGGEBER; HILFE UND SUPPORT

Informationen für Recruiter

* Business Mitgliedschaft * Enterprise Mitgliedschaft * Datenschutzmodul * Top-Projekt * Automatischer Projektimport * Preise und Leistungen HILFE UND SUPPORT * FAQ * Kontakt * RSS * Sitemap * Preise und Leistungen

ÜBER UNS

Unsere Partner

ÜBER UNS * Kundenecho * Werben Sie bei uns * Presse * Unsere Partner * Werden Sie Partner * Karriere

SOZIALE NETZWERKE

SOZIALE NETZWERKE * facebook * Twitter * LinkedIn RECHTLICHES * Datenschutz * AGB * Impressum

RATGEBER UND BLOG; FREELANCER KOMPASS

Die freelancermap-Marktstudie für Freelancer

RATGEBER UND BLOG Der freelancermap-Blog bietet Ihnen spannende Ratgeberartikel rund um das Thema Freelancing und Selbstständigkeit FREELANCER KOMPASS Die freelancermap-Marktstudie für Freelancer, Selbständige und Freiberufler CASE STUDIES Lesen Sie spannende Erfolggeschichten von begeisterten Kunden!