SUMMARY

• Overall IT - 9 years of experience in the analysis, design, development and implementation of Data Warehousing and other applications using Object Oriented Analysis, Design and Methodologies.
• Business Intelligence: 7 years of Business Intelligence experience in building universes, developing reports, and analyzing OLAP data. Worked in various BO environments linking data from multiple sources, applying several functionalities, and using various Data Providers. Trained users in producing documents and running queries. Worked with many types of team members for different tasks. Tested reports for validating and verifying data.
• Business Objects: 7 years of experience with complete life cycle implementations using Business Objects XIR4/XIR3/XIR2/6.5/5.1 (CMC, CCM, Supervisor, administrator, Designer, Infoview, BO Reporting, Desktop Intelligence, Web-Intelligence 6.0/2.7/2.6/2.5 , Performance Management, Dashboard Manager, Set Analysis, BOE SDK, WebI SDK, Broadcast Agent, Publisher, Application Foundation 6.0/2.5 & Crystal Xcelsius 2008/4.5), Crystal Reports 9, 10 & XI.
• Database: 7 years of experience in Oracle 10g/9i/8i, DB2, MS SQL Server 2000/2005 SQL*Loader, T-Sql, PL/SQL and TOAD.
• Data Modeling: Good Knowledge in Data Modeling, Star Join Schema, Snow-Flake, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Interfaced with vendor and offshore team leads to develop the Reporting Strategy adhering to client’s enterprise standards.
• Exceptionally motivated and skilled in effective time management and meeting user requirements with uncompromising detail.
• Fair ETL data integration & Data Warehousing experience with Microsoft SSIS 2005.
• Ability to adapt to new technologies very quickly.
• Excellent interpersonal, communication and presentation skills.
• Complete understanding of the Software Development Life Cycle.

TECHNICAL SKILLS

Business Intelligence: Business Objects XI R4/XI R3/ XI R2/6.5/5.1 (Desktop IntelligenceWebIntelligence, CMC, CCM, SDK, Infoview, Designer, SupervisorAdministrator, Broadcast Agent, ZABO, Application Foundation 6i/2.5), OLAP Intelligence, Crystal Xcelsius 2008, Crystal Reports 9/10/XI

Data warehousing: Informatica PowerCenter V7, Informatica PowerMart 6.2/5.1, Repository Manager, Designer, ERwin r7.2/4

Data Modeling: Dimensional Data Modeling experience in designing Star and Snowflake schemas as per Ralph Kimball/Inmon Methodologies and Relational Data Modeling using Erwin

Databases: Oracle 10g/9i/8i, MS SQL Server 2000/2005, DB2 UDB 8x, Access 2000/2003, Teradata

Development Tool: TOAD, SQL Management Studio, T-Sql, PL/SQL developer

Programming/Web Technologies: Visual Basic, PL/SQL, HTML, ASP, Java

Operating Systems: Windows 98/2000/NT/ 2003 Server UNIX, Sun Solaris, Linux

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Sr. SAP Business Objects Developer

Responsibilities:

• Involved in Analyzing the End users functional and technical requirements.
• Designed universes by defining Joins, Cardinalities between tables.
• Resolved the loops, cardinalities by contexts and aliases and checked the Integrity of the Universe.
• Created classes and objects by retrieving the data from various data sources and defining the necessary connections. Created predefined conditions, and prompts in the process of building the universes.
• Implemented row level security in the universe to allow the data to be viewed only by authorized person.
• Exported the universes to dev, test and prod domains to make resources available to the users.
• Extensively used multiple data providers for building reports.
• Involved in creating Web I XI R3 reports using Info view and Webi Rich Client with many features of drill down and alerters and filters etc.
• Developed linked WebI reports by extensively using OpenDocument function
• Involved in developing dashboards using Crystal XCelsius and connected dashboards to live data sources using web-services.
• Created reports using Business Objects functionality such as Drill Down, Master/detail, Crosstab, Charts, Bar and Line Graphs, Prompts and Formulas, Breaks, Sorters and Alerters etc.
• Coordinated with DBA and ETL in solving various technical issues and also to stream-line universe design and optimize query performance
• Performed query tuning using TOAD and solved performance issues.
• Involved in preparing SIT and Unit Test Cases as per Development standards. Prepared Technical design documents for all the reports developed.
• Involved in BO Admin activities like Creating users, groups, managing BO servers to add/delete, enable/Disable them.
• Maintained SSIS ETL packages and did minor enhancements and fixes to them.
• Resolved various technical issues and also worked on to stream-line universe design and optimize query performance

Environment: BO XI R2/BOXIR3/BOXIR4 (CMS, CMC, CCM, Designer, Desk I, Web I, T-Sql, Import Wizard, Performance Management), Crystal Xcelcius 2008,TOAD,ORACLE 10g/9i,SQL Server 2005/2008,Mircosoft Excel 2003, PL SQL,SQL, UNIX

Confidential, St. Louis, MO

Sr.SAP Business Objects Developer

Responsibilities:

• Interacted with End Client in requirement gathering and Involved in analysis of the given requirements.
• Involve in enhancements of existing universe and Reports through Remedy tickets and work towards resolutions.
• Designed the universes according to the requirements by identifying the tables/Views.
• Created Contexts and Aliases for resolving Loops and join problems in the Universes
• Created classes and objects by retrieving the data from various data sources and defining the necessary connections
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes
• Created derived tables at the universe level to reduce the complexity of universe building.
• Created reports using Business Objects functionality such as Drill Down, Master/detail, Crosstab, Charts, Bar and Line Graphs, Prompts and Formulas, Breaks, Sorters and Alerters etc.
• Write T-SQL Queries for maintaining databases and creating reports in business object and Webi.
• Create and maintain T-SQL queries required to support BO reporting needs.
• Involved in preparing SIT and Unit Test Cases as per Development standards. Prepared Technical design documents for all the reports developed.
• Coordinated with BO Admin in managing the Central Management Server to add/delete, enable/disable BO Servers.
• Used Crystal Xcelcius interface to import Excel data and formulas, and output interactive dashboards, animated charts and graphs, financial presentations, and business calculators directly to PowerPoint, Word, PDF documents.
• Was Involved with team in migrating Universes, reports and Objects from XIR2 to 3.1 using Import wizard and Report Conversion Tool
• Coordinated with DBA and ETL in solving various technical issues and also to stream-line universe design and optimize query performance
• Performed query tuning using TOAD and solved performance issues.
• Involve in peer-reviews to identify defect and suggest better ways of implementing.

Environment: BO XI R2/BOXIR3 (CMS, CMC, CCM, Designer, T-Sql, Desk I, Web I, Import Wizard, Performance Management), Crystal Xcelcius 2008,TOAD,ORACLE 10g/9i,SQL Server 2005/2008,Mircosoft Excel 2003, PL SQL,SQL, UNIX

Confidential, Madison, WI

Data Warehousing Consultant/Business Objects Developer/Report Developer

Responsibilities:

• Involved in Analyzing the End users functional and technical requirements and respective impacts on reports.
• Designed, created and maintained Universes for Business Objects and Web Intelligence users using Business Objects Designer Module.
• Created universes by defining Joins, Cardinalities between tables.
• Created classes and objects by retrieving the data from various data sources and defining the necessary connections
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes
• Created Contexts and Aliases for resolving Loops and join problems in the Universes.
• Deployed universes in the repository by exporting and importing universes between universe domains, and over different repositories.
• Created both full client reports and Web I reports using Info view with many features of drill down and alerters and filters.
• Generated various reports on a daily, weekly and monthly basis using Business Objects Report module.
• Created reports using Business Objects functionality such as Slice and Dice, Drill Down, Master/detail, Crosstab, Prompts and Formulas, Breaks, Sorters and Alerters etc.
• Involved in writing free hand SQL, as data provider for retrieving data when universe doesn’t provide required data.
• Involved in Scheduling reports based on Specific time, events and calendars and in various formats such as Excel and PDF using Broad Cast Agent.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Involved with the group which provided support and ideas for migration from 6.5 to BO XI R2 & BO3.1
• Migrating existing BO 6.x universes and reports to BOXI R2& R3using Import Wizard to affect new System (Interchange).
• Converted the existing full client reports to Web I docs using report conversion tool to affect new System (Interchange).
• Used Central Management Console (CMC) in creating users and groups and assigning privileges to different groups and users.
• Applied row level and object level securities to different groups and users in the designer wizard.
• Developed various SQL, PL/SQL blocks to optimize the query performance using SQL*Plus
• Resolved issues during the migration from Test to Production environment.
• Resolved any SQL query issues. Escalated and tracked unresolved issues,
• Coordinated with BO Admin in managing the Central Management Server to add/delete, enable/disable BO Servers.
• Coordinated with DBA and ETL in solving various technical issues and also to stream-line universe design and optimize query performance
• Worked with team in developing Business Objects Data Integrator jobs to extract data from various source systems
• Conducted presentations training sessions and created training documents for the Business users on the use of Business Objects reporting tool and overview of the Universe.

Environment: Business Objects 6.5.1(Supervisor, Designer, Reporter), Web Intelligence, BCA 6.5.1, 3 Tier BO, BO XI R2 (CMS, CMC, CCM, Designer, Desk I, Web I, Import Wizard, Performance Management), BOXIR3, Crystal XI, BO XCelsius 2008, ORACLE 10g/9i, TOAD, Windows 2000 Server, Informatica Power Center, SQL Server 2005, Mircosoft Excel 2003, PL SQL, SQL, UNIX & Autosys.

Confidential, Indianapolis, Indiana

Business Objects Report Developer

Responsibilities:

• Participated in requirements gathering, analysis.
• Created functional requirement specifications through end-user meetings and analysis of business requirement documents.
• Involved in setting up users through Supervisor and assigning privileges to these users to meet security requirements.
• Setting up row level and object level securities on the universes to various groups and users using supervisor.
• Created Universes from multiple data sources which were coming from different databases
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes
• Resolved issues like loops by creating aliases and contexts as required to remove the cyclic dependencies
• Exported the universes to dev, test and prod domains to make resources available to the users.
• Creating standard full client/WebI reports, created canned and ad-hoc Reports Using Business objects user module.
• Created reports using Business Objects features like Slice/Dice, Drill Down, @Functions, Cross tab, Ranking, Filtering etc.
• Scheduled and Monitored Reports through using BCA in various formats like PDF, Excel and .rep
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Involved in installing Business Objects XI suite, creating users, user groups and categories
• Created users and groups using Central Management Console (CMC) and assigned privileges to different groups and users. Created folders and categories in CMC.
• Migrating existing BO 6.x universes and reports to BOXI R2using Import Wizard.
• Applied row level and object level securities to different groups and users in the designer wizard
• Created reports using both Desk I and WebI with multiple data providers.
• Involved in publishing various objects and folders to the repository in InfoView and CMC and also scheduling options using the publishing wizard.
• Developed various SQL, PL/SQL blocks to optimize the query performance.

Environment: Business Objects 6.5.1(Supervisor, Designer, Reporter), WebIntelligence, BCA 6.5.1, 3 Tier BOBOXIR2 (Designer, DeskI, WebI, ImportWizard, Performance Management), ORACLE10g/9i, TOAD, SQL, PL SQL, SQL*PLUS, MS EXCEL, HTML, Windows 2000 Server, Unix, Autosys

Confidential, Madison, WI

Database Assistant

Responsibilities:

• Responsibilities included Database maintenance and management
• Created users and granted access privileges.
• Created Stored Procedures and Functions to call various oracle developer modules.
• Created indexes on some columns of tables to increase application performance.
• Installed, tested, evaluated, implemented & maintained DBMS related system software & tools.
• PL/SQL scripting & stored procedures.
• Monitored and tuned database performance including SQL tuning. Tested, enhanced and debugged codes.
• Routine database maintenance & SQL data extraction.
• Developed and maintained university website by using dream weaver editor.
• Involved in troubleshooting and Maintenance of computers, printers and other software or hardware related devices.
• Assisting students in writing SQL, PL/SQL Statements and Core Java.
• Conducting lab sessions and helping students in programming.
• Created weekly lesson plans and grading criteria for homework

Environment: Oracle 10g/ 9i/8i, MS SQL Server, MS Access, Microsoft Word,SQL* Plus, SQL, PLSQL, UNIX, WINDOWS, Dream Weaver Editor, JDK, Eclipse

Confidential

Jr. Analyst

Responsibilities:

• Involved in gathering requirements from users, analyzing the data and compose the analysis and developing design Documents.
• Integrating various Database Technologies for smooth functioning of the Online Transaction System
• Involved with team in developing JSP and HTML pages for the Product, Order Module, Catalog module, shipping module.
• Wrote Triggers and Stored Procedures and also to enforce referential integrity.
• Involved in fine Tuning and Performance and Query optimization of the Database.

Environment: JDK 1.3, Eclipse, Oracle 8.x, MS Access, SQL Server, MS Word, SQL/PLSQL