PROFESSIONAL SUMMARY

• Over 7 years of IT experience in Business Intelligence and Data warehousing Technologies.
• Diversified Experience in implementation of Business Objects in Finance, Insurance, Telecom, Manufacturing sectors.
• Extensive exposure in Dimensional Data Modelling, Physical logical Data Modelling.
• Complete Life Cycle Knowledge including Planning, Administration, Change Management and Migration process of Business Objects Enterprise 4.0/XI R2 to 4.1 in a Distributed and Clustered Environments
• Strong Experience in SAP Business Objects 4.x/XI reporting tools.
• Extensively Worked on Oracle 9i/10g/11g,MS-SQL Server 2005/2008 and PostgreSQL.
• Extensive experience writing complex SQL's and stored procedures using PL/SQL programming.
• Expertise in Tuning of SQL Queries for better reporting performance.
• Excellent Knowledge in Extraction, Transformation and Loading process using Informatica, SAP Business Objects Data Services BODS/BODI and Microsoft SQL Server Integration Services SSIS .
• Hands on experience working with SAP BW, SAP HANA 1.0 DB and modelling.
• Good Knowledge in SAP BI/BW components like Data source, User Exits, ETL activities like OLTP data extraction, loading Full/Delta Up-Load , Scheduling, Monitoring, Process Chains, Remote Cubes.
• Strong experience in writing System requirements, Technical specifications, Test plans and Test case documents.
• Involved in Training End Users and Preparing Training Material
• Strong time management and project coordination skills with simultaneous projects.
• Excellent Technical, Analytical and Problem Solving Skills. Ability to rapidly learn new Technologies.
• Experience in conducting small and large group presentations and proven to be highly effective in interfacing across business and technical groups.
• Flexible versatile to adapt to new environment with strong desire to keep pace with latest technologies.

Confidential

PROFESSIONAL EXPEREINCE

Sr. Business Objects Data warehousing Consultant

Environment:

SAP Business Objects 4.x/XI R3, SAP Dashboards 4.0/Xcelsius 2008, SAP BO Explorer, BODS BODI , Oracle 10g/11g, Toad 10.6, SQL Developer Windows 7 Professional, UNIX, Linux, Microsoft Share point Portal, XML, Tomcat, Apache.

Responsibilities:

• Created the Scope Documentation for the implementation of Consolidated funds Data Source.
• Assisted in creating Data Mart to support CF Data Source and various other Projects.
• Extensively involved in Dimensional Data Modelling, ETL Design input and Universe Design for CFDS.
• Interacted with the various Data Source Teams involved and gathered the Data.
• Developed strategies for data extraction from various source systems, transformation and loading into CFDS target system.
• Provided Solution to automate various scheduling processes using Business Objects Reporting Tool.
• Created Universes based on Reporting Requirements and modified existing universes to cater the Reporting Needs.
• Extensively worked on BO Web Intelligence and Full Client Canned and Ad-Hoc Reports.
• Converted the existing Full Client and WEBI Reports as part of the Migration.
• Created simple and complex Dashboards using BO Dashboards 4.1 with connectors using BI services, Qaaws and External interface connections.
• Created Package Build Forms for deployment from one environment to the other.
• Developed Test cases/scenarios with concerned users and obtaining necessary sign offs.
• Interacted with Business users to understand the issues and action the support tickets.
• Scheduled the Reports as per requirement and distributed it to different Functional Groups.
• Created Documentation for the whole scenario of the project.

Confidential

Business Objects DWH Consultant

Environment:

Business Objects XI R3/XI R2, Tableau 5/6, Informatica 8.x, Oracle 10g, Windows XP/2003 Server, Unix, Sun Solaris, Salesforce CRM, Oracle Applications, Agile, Erwin/Visio, Microsoft Share point Portal, Toad 9.7.2

Responsibilities:

• Involved in Gathering and Analyzing the Requirements from Business Users and Engineers.
• Understanding the Manual Process used for tracking the Lead Times on the Probe Cards Manufacturing.
• Documented the Data Source Mapping for the different Source Systems involved.
• Design Semantic layer/Universe Design and Dashboard Design.
• Created a Data Mart to support the Lead Time Management Tool and various other Projects.
• Worked on Informatica to Create Mappings, Workflows and Jobs for data Extraction and Loading.
• Installed and Configured Business Objects XI R3.1 on clustered environments of Windows and UNIX.
• Migrated Business Objects XI R2 to Business Objects XI R3 using Import Wizard and LCM.
• Extensively Worked with CMS and CMC components to configure and maintain BO environment.
• Configured Audit Database on all the servers and created the Audit Reports.
• Created Universes for Reporting Requirements and modified existing ones to cater the Reporting Needs.
• Extensively worked on BO Web Intelligence and Full Client Canned and Ad-Hoc Reports.
• Created Hyperlinked Web Intelligence WEBI Reports using Open Document Functionality.
• Created simple and complex Scorecards and Dashboards using Xcelsius 2008 and Qaaws, BI services and Live Office
• Performed Report Scheduling, Publication, Report Bursting Setup.
• Developed Test cases/scenarios with concerned users and obtaining necessary sign offs.
• Interacted with Business users to understand the issues and action the support tickets.
• Scheduled the Reports as per requirement and distributed it to different Functional Groups.
• Created Documentation for the whole scenario of the project.

Confidential

Business Objects Informatica Consultant

Environment:

Business Objects XI R3.0, Crystal Enterprise XI, Informatica 8.0, Oracle 9i, MS SQL Server 2005/2008, TOAD 8.5.1, People Soft HR System, Windows XP/2003 Server.

Responsibilities:

• Involved in Functional and Technical Requirements gathering from Business Users Divisions.
• Coordinated with the Design Team to create Datawarehouse and Data Marts.
• Created complex Universes for Reporting Requirements and modified the existing ones as part of enhancing the universes to satisfy the new and existing reporting requirements.
• Linked the Universes to shared common objects. Updated and maintained Universes based on changing user requirements and data source changes.
• Created Complex Web I Web intelligence , Crystal Reports and modified existing Reports.
• Created Reports from Multiple Data Providers each of the Data Provider being on a different Database Platforms as part of integrating the Data from the Plan View and PeopleSoft Application.
• Created On Demand, Ad-Hoc, Summary, Cross-tab, Conditional, Drill-down, Charts, Sub and Graphical Reports using Business Objects and Crystal Reports.
• Extensively used Business Objects SDK to customize look and feel of Business Objects Reports.
• Provided recommendations on performance enhancements in Pre/Post Production environments.
• Involved in Production support for fixing the issues pertaining to Business Objects Environment.
• Scheduled the Reports and Distributed Reports in multiple formats such as Excel, word, HTML PDF.
• Provided Technical support to Power/End Users
• Created Documentation for knowledge transfer KT .

Confidential

Environment:

Business Objects XI R2.0/6.5, Crystal Reports, Informatica 7.x/8.0, Oracle 9i, MS SQL Server 2005, TOAD, People Soft HR System, Windows XP/2003 Server.

Responsibilities:

• Trained on Business Objects Enterprise, Informatica ETL tool.
• Assisted our primary resource team working at client locations as an offsite developer.
• Involved in Functional and Technical Requirements documenting processes.
• Coordinated with the Design Teams in implementing Data warehouses and Data Marts.
• Created Universes, reports and scorecards as per the requirements.
• Created Informatica mappings, sessions and workflows for ETL operations and automated the job with Informatica scheduler.