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.

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.

Confidential,Houston, TX Jun08 - Till Date
Sr.Business Objects Consultant
Merrill Lynch Global Commodities (MLCI) 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
Cisco (CSCO) 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
Franklin Templeton Investments 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

• Bachelor of Engineering in Electronics &Communications.