Professional Summary

• Over 8 years of IT experience in Analysis, Design, Development, Deployment and Installation of applications, Data warehouses, Business Intelligence, client server and web based.
• Strong exposure to SDLC which includes Requirements Analysis, Data Analysis, Data Modeling, Object-Oriented Analysis, Design, Programming, System Integration and Software Configuration Management, Testing.
• Well versed in Business Objects XIR3/XIR2/XI/6.x/5.x experience in (Supervisor, Designer, Reporter, CMC, CMS, INFO VIEW, Web Intelligence, Desktop Intelligence, ZABO, Application Foundation, SDK, Dashboards, Scorecards, Xcelsius), BODI.
• Strong experience in Migration of Business Objects to new versions XIR2/XIR3.
• Expertise in Designing/Developing the BO universes for various subject areas.
• Expertise in working with the UNIX/AIX/Windows systems.
• Good knowledge and experience in using Oracle 10g/9i/8i, MS SQL Server 2000/03,MS Access 2000/ 97/ 7.0.
• Strong experience in ETL process with Informatica Power Center 8.x/7.1/6.2/5.1.
• Excellent knowledge in implementation of Relational Database (OLTP) and Data ware housing systems (OLAP).
• Experience in writing Stored Procedures, Functions, Triggers, Cursors, packages using SQL, PL/SQL programming.
• Good knowledge in Dimensional modeling (star schema and snowflake schema)
• Experience in analyzing functional specifications and writing detailed test plans, test procedures, creation of test data, execution of test scenarios, and automation of test cases.
• Expertise in documentation using MS Office (Word, Excel, PowerPoint and Access).
• Excellent Interpersonal, Communication and Presentation Skills.
• Excellent team player, Quick learner, hard working and ability to adapt to new technologies very quickly, ability to perform independently.

Technical Skills

BI Tools: Business Objects Suite (Supervisor, Designer, Reporter, and Application Foundation) Dashboards, Scorecards. Business Object XIR3/XI R2 /XI/6.x/5.x (Web Intelligence, Desktop Intelligence, Crystal Reports, Crystal Xcelcius CMC, CMS, INFO VIEW, Broadcast Agent, Publisher), Essbase Hyperion.
Data Modeling: Erwin 4.1/3.5.2(Dimensional Modeling).
ETL Tools: BODI, Informatica 7.x/6.x/5.x Power Center and Power Mart.
RDBMS: Oracle 10g/9i/8i, SQL Server 2000, 2005, DB2, MS Access 98/2000, SAP.
Languages: C/C++, HTML, UNIX, SQL, PLSQL, SQL* PLUS.
Operating System: Windows 98/XP/NT/ 2000 Server, LINUX 7.0.
Application/Web servers: Web Sphere, Web logic.

Professional Experience

Confidential,Houston, TX Jun08 - Till Date
Sr.Business Objects Consultant
Confidential,is a leading global commodities trading firm. It’s innovative and wide-ranging product and service portfolio includes structuring, trading, and marketing of natural gas and power, crude oil, refined products, natural gas liquids, coal, emissions, metals, commodity indices, structured notes, and weather risk management.

Responsibilities:

• Participated in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Installed and configured the BOXIR3 Enterprise Suite.
• Migrated BOXIR2 Web Intelligence and Desktop Intelligence reports, Universe, Securities to BOXIR3.
• Designed, developed and managed Universes in Business Objects Designer.
• Defined Aliases and Contexts to resolve loops in the universes.
• Created New Classes and User Objects in designing the universes.
• Created Various Trading reports on Web Intelligence and Desktop Intelligence.
• Generated various reports in XIR3 as per the User requirements in Web Intelligence and Desktop Intelligence.
• Created Summary Reports, Detail Reports, Cross-Tab reports and Sub-reports.
• Developed critical reports like drill down, Slice and Dice, master/detail using graphs, charts for analysis.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects.
• Created Interactive Dashboards for the business users to analyze the future of the commodities in present market and new trading opportunities.
• Developed Analytics and Dashboards based on the User Requirement.
• Worked as Dashboard / Performance Manager for the Commodity Trading and analyze the ROI.
• Created reports using crystal Xcelsius for presentations using data from Excel sheets.
• Developed Test cases for Reports, Conducted Unit Testing and deployed for User acceptance Testing.
• Trained the Business users on the report features and to create their own reports.
• Scheduled reports using BO publisher.
• Created the Technical documentation and User guide on Universe design Report design functionalities and provided to the End-users.
• Worked on performance monitoring, stress and load tests, and worked on for performance improvements.

Environment: Business Objects XIR3/XIR2 (Desktop Intelligence, Web Intelligence and Info View), Oracle 10g, TOAD, SQL, PL/SQL

Confidential,San Jose, CA Aug07 – May08
Sr.Business Objects Consultant
Confidential,is the leading supplier of networking equipment and network management for the Internet. Products include routers, hubs, Ethernet etc. It designs and sells networking and communications technology and services.
Responsibilities:

• Interacting with the Business Representatives, Project managers, and Business analysts in analyzing the Business needs.
• Installation and Configuration of Business Objects XIR2 along with performance manager.
• Designed universes as per the user requirements.
• Migrated Business objects from version 6.5 to XIR2 Using import wizard and BIAR files.
• Created reports on Web Intelligence and Desktop Intelligence.
• Developed critical reports like drill down, Slice and Dice, master/detail using graphs, charts for analysis.
• Created Summary Reports, Detail Reports, Cross-Tab reports and Sub-reports.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects.
• Worked with Crystal Report XI for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Developed several Analytical dashboards according to the user requirements for Business Managers.
• Created various Personal and Executive Dashboards using BO performance Manager.
• Extensively used Xcelsius to create dashboards from data in excel sheets for presentations
• Designed security model for users to access the reports in CMC, CMS. .
• Created Users/Groups and Assigned user privileges.
• Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading (ETL).
• Created source to target mappings according to the business requirements using BODI Designer.
• Extensively used BODI to load data from flat files into staging area.
• Set the Object level/Row Level Restrictions to the different user groups based on their profile.
• Worked with the ETL team to create Automated Daily Load Status Check reports to validate the data between source and target data marts.
• Developed Test cases for Reports, Conducted Unit Testing and deployed for User acceptance Testing.
• Trained the Business users on the report features and to create their own reports.
• Scheduled reports using BO publisher.
• Created the Technical documentation and User guide on Universe design Report design functionalities and provided to the End-users.

Environment: Business ObjectsXIR2/6.5, BODI, Crystal Reports, Toad, Oracle 10g/9i, SQL Server 2005 PL/SQL, UNIX, Windows 2000/NT.

Confidential,Dublin, CA Sep05 – Aug07
Business Objects Developer
Confidential,is a leading Investment and wealth management firm with global operations. The data mart has three subject areas; Products, Accounts and Transactions which are used for generating reports on various products, accounts and transactions of Franklin Templeton Investments. In this project I am actively involved in Designing and maintaining the Universes and Lead the offshore team.
Responsibilities:

• Gather business requirements with client’s document and communicate results obtaining feedback as appropriate using Word, and Excel.
• Migrated Business Objects 6.5 reports, Universe to the BOXIR2 version using import wizard.
• Designed and Built the Products and Transactions ad-hoc Universes using Designer and linked the universes with other core universes in a RAD process.
• Created various reports in Desktop-intelligence and Web-Intelligence.
• Created many reports according to the investment deals, facility and outstanding to know the exact amount of net investment in each deals.
• Prepared month-end reports for General Ledger, Net Investment, Interest, Fees and Incomes.
• Created parameterized crystal reports and customized existing reports for presentations using Summary Reports, Detail Reports, Cross-Tab reports and Sub-reports.
• Created Hierarchies to provide the drill down functionality to end-users.
• Created parameterized crystal reports and customized existing reports for presentations.
• Developed Analytics and Dashboards based on the User Requirement.
• Worked as Dashboard / Performance Manager for the Net Investment and Interest to analyze the investment return..
• Set up groups and users for Business Objects deployment using the Central Management Console and assigned the access rights based on their profile.
• Set the Row Level Restrictions to the different user groups based on their profile.
• Trained Business users in creating Web Intelligence reports.
• Worked with the ETL team to create Automated Daily Load Status Check reports to validate the data between source and target data marts.
• Created technical and user documentation which has the step by step process of creating reports and using the functionality of Business Objects.

Environment: Business Objects XIR2/6.5, Crystal Reports, Informatica 7.7, Toad, SQL Server 2005, PL/SQL, Windows 2000/NT

Confidential,Beaverton, OR Aug04 – Sep05
ETL /Business Objects Developer
Confidential, is a major publicly traded sportswear and equipment supplier based in the US. It is the world\'s leading supplier of Athletics shoes, apparel and sports equipment. Digital Data Gap for planning the Nike.com Business in the US.
Responsibilities:

• Interactedwith the Business Users to gather report requirements.
• Requirements Analysis, Creating Design Documents, Development.
• Involved in Universe Designing, testing the new and updated universes using BO Designer.
• Used Designer Module to implement Universe, Linkages between Tables, created prompts.
• Created Contexts and Alias Tables to remove cyclic dependencies.
• Created reports on Web Intelligence and Desktop Intelligence.
• Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading (ETL).
• Created source to target mappings according to the business requirements using Informatica Designer.
• Extensively used Informatica to load data from flat files into staging area.
• Created reports using Free hand SQL, Stored procedure, Views.
• Trained the Business users on the report features and to create their own reports.
• Involved Writing and executing detailed Test Cases & Test Plans for Unit Testing and providing end user support.
• Worked on performance monitoring, stress and load tests, and worked on for performance improvements.

Environment: Windows NT/2000/XP, Oracle 9i/8i, PL/SQL procedures, Informatica7.0, TOAD, BO6.5, UNIX, Shell scripts.

Confidential,San Leandro, CA Jan03 – Jul04
ETL/Business Objects Developer
Confidential,is supplier leading manufacturer and distributor of frozen gourmet cookie dough, ready-baked muffins, and a variety of other premium bakery products to foodservice facilities and retail outlets throughout the United States, Canada, Central and South America and Europe.
Responsibilities

• Gathered business requirements, interacted with business analysts to develop Web I reports.
• Designed complex business objects universe for easy reporting.
• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, apply Contexts and Alias Tables to remove cyclic dependencies.
• Created reports on Business Objects full client, Web Intelligence.
• Created the reports as per the specification with standard template.
• Involved in testing the application and reports.
• Automated document Scheduling, Publishing and Distribution for WebI and Infoview clients, using the Broadcast Agent Server.
• Worked with the ETL team to create Automated Daily Load Status Check reports to validate the data between source and target data marts.
• Interacted with Informatica Developers understanding the data load process to resolve data quality issues.
• Developed Informatica mappings for creating Aggregate tables to increase the performance in Business Objects.

Environment: Business Objects 6.5, Web Intelligence, Informatica 6.2, SQL Server 2000, Windows 2000 Server, UNIX.

Confidential,India May00 – Dec02
Oracle developer
This project was developed for maintaining Accident information. This project consists of accident details that contains when it occurs, where it occurred and how many members died, and how many members injured etc.

Responsibilities

• Developed DDL Scripts for generating Tables, Views, and Functions etc
• Designing of the database and the tables.
• Building multi table relationship and writing stored procedure to clean the existing data.
• Created tables, views and indexes.
• Created Views for Extracting Data for Various tables for Report Generation.
• Performed Database Normalization.
• Coding of database Triggers, Stored Procedures and Maintaining Integrity Constraints.
• Developed SQL*Plus reports to allow the manager to analyze the data directly accessing Oracle Server.
• Supported production environment.

Environment: Oracle 8i, PL/SQL procedures, Windows 2000/XP, UNIX, Java, XML.

Education

• Bachelor of Engineering in Electronics &Communications