SUMMARY

• Around 8 years of experience in Information Technology with experience in full life cycle implementations involving analysis, design, development, testing, deployment, post - production support/maintenance, documentation, and end-user training including 7 years experience in Business Objects.
• Experienced in Dimensional Database modeling & Design, preparing Software requirement specifications test Plans, UAT and test scripts
• Expertise in Business Objects suites: Installation, configuration and integration of systems, design, development and production rollout of Business Objects reporting Application.
• Expertise in Business Objects Reporting tools including (Business Objects XI3.1/R2/6.x/5.x, CMC, Desktop Intelligence, Web Intelligence, Import Wizard, and Report Conversion Tool), Crystal Reports XI/10/9, and Crystal Xcelsius 2008/4.5
• Expertise in creating highly formatted canned reports and well versed with universe designing, report writing.
• Excellent experience with DW Concepts such as Star schema, Snowflake Schema, Fact and dimensional tables. Experience includes designing, implementing and integrating various Data warehouse and Data Marts using Oracle 10g/9i, MS-SQL Server 2000, DB2.
• Expertise in Integrating and Extracting data into Business Objects environment from the SAP BW database system.
• Extensively worked on BEX, WAD reports.
• Experience in Migrating to BO XI R2/3.00 from previous versions (6.5.x and 5.1.x)
• Proficient in SQL, PL/SQL and extensively used PL/SQL in writing Views and Stored Procedures.
• Working knowledge of Business Objects Enterprise Performance Management & Xcelsius Dashboards
• Designed, Developed and maintained the Xcelsius dashboards in both Xcelsius 4.5 and 2008 using live data connecting via the Web Service connectors like QAAWS and LiveOffice
• Expertise in administration activities like creating and managing repositories, users, user groups, working with privileges in repository manager.
• Capable of improving the Business Process, have shown signs of Entrepreneurship, & Strategic project management. Exceptional technical, liaison, and interpersonal skills have helped me taste success throughout my career.

TECHNICAL SKILLS:

Reporting Tools: BI Tools - Business Objects Enterprise Suite XI 3.0/ XI R2/R1/6.x/5.x (Universe Designer, Desktop Intelligence, Web Intelligence, CMC, Supervisor, BCA), Crystal Reports XI/2008, Xcelsius 4.5/2008, Performance Management and Dashboard Manager, QAAWS, Live Office

Web Technologies: HTML, XML, VBScript

ETL Tools: Data Integrator, Informatica 8.1

Databases: SQL Server 2000/2005/2008, Oracle 10g/9i/8i, DB2, and MS Access, BW 3.5/7

Languages: PL/SQL, SQL, T-SQL, Java and VB.

Operating Systems: Windows 98/2000/NT/XP, UNIX

Servers: IIS 5.0/ 6.0, Web Logic Application Server 8.2 / 7.2 / 6.1, TOMCAT

Other Tools: TOAD, SQL Developer, Quality Center, MS Office, MS Visio 2003/2007, Erwin 4.1

PROJECT EXPERIENCE

Confidential, Mason OH

Sr. Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements for Business objects universe, reports and Dashboards from the Higher Level Management.
• Created Adhoc and complex canned reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values, local variables, Alerts, Ranking and multiple data providers, sections, breaks, drill down reports and hyperlinked reports.
• Developed Web Intelligence reports from the Universes developed on BEx Queries by combining data from SAP and non-SAP data in a single report, including data from XLS, CSV, and Text files.
• Created/Modified Universes, Reports from the underlying Databases for different business modules.
• Designed and Built Universes using Designer by defining joins, cardinalities between tables and applying contexts and aliases to remove cyclic dependencies.
• Resolved complex looping issues by creating multiple contexts and aliases to remove cyclic dependencies for the universes, which were built from the underlying Databases.
• Applied Object level and Row level securities in designer using security restrictions option.
• Given training to the Business Objects End users on BOE XI 3.1 New features and the New tool Web Intelligence Rich Client.
• Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.
• Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports, formatting sections, tables, inserting and organizing multiple breaks.
• Extensively worked on drill mode to view data in different Perspectives.
• Involved in Unit testing, System testing and User Acceptance Test (Dashboards and Reports) throughout migration process.
• Implemented Migration process for Business Objects XI R2 to XI 3.0, such as readiness assessment and deployment plan, Migration and system Upgrades.
• Provided administration support for the various Business Objects instances (Dev, QA, Prod), inclusive of server and service monitoring, report posting, universe migration, platform upgrades, universe creation and establishing user ids.
• Provided support in enhancement and maintenance of the Reports and Universes.

Environment: SAP BO XI R3.1 Enterprise (Universe Designer, Web Intelligence, WebI Rich client), Crystal Reports 2008, Xcelsius 2008, Qaaws, Live Office, BEx Queries, WAD, Oracle 10g, SAP Integration Kit, SAP Net Weaver BW 3.5/7.

Confidential, Seattle WA

Sr. Business Objects Developer

Responsibilities:

• Closely worked with the Business Analysts and Involved in the meetings with Business Users for requirements gathering and providing inputs on the WebI XI R2 compatibility to the users and the BAs.
• Prepared the Report Design Specs and helped the off-shore development team, understand the Report Design specs, Universe Schema and providing them the inputs on the reports development and unit testing.
• Assigning the work to the offshore team (evening off-shore call for assigning work and morning off-shore call for daily updates and discussing their development issues) and providing daily updates to the client manager.
• Actively involved in the daily triage calls and closely working with the QA team and providing them report defect clarifications.
• Developed ad-hoc reports based on the user requirements (for UAT purpose).
• Took the weekly backup of the reports and the universe in DEV environment and deploy/migrate them on to ST and Pre-Prod environments for Testing and UAT purposes respectively.
• Administrative tasks such as creating groups, users, creating folder and moving reports and providing security to folders. Setup user authentication and authorization.
• Worked closely with developers on the universe enhancements and universe gaps based on the user requirements.
• Updated the standard universe provided by based on the user requirements.
• Worked on the SQL Views and derived tables for universe objects creation based on the business requirements to simplify the complex reports development.
• Established join conditions and checked for their cardinalities. Created classes, sub-classes, objects, dummy prompt objects, cascading prompts, contexts, and aliases.
• Worked on complex queries involving the Budget, Entities (Site, Project, facility), Forms, Auditing etc., Linked the result set from multiple data providers and used the functionalities such as combined queries, Drill Down, Open Document, Slice and Dice, etc.
• Developed different types of standard reports with drilling capabilities in tables, cross-tab and charts with complex calculations, Variables, Breaks, Sorting, and Alerters etc.
• Performed report data integrity check through running the query against SQL Server using SQL Server Management Studio. Performed extensive Report Testing includes UAT and Regression testing.
• Worked on performance tuning of the reports and made the necessary changes to the report queries and the variables to improve the query response time.
• Applied changes to the reports developed by other vendors based on the QA defects and the user requirements.

Environment: Business Objects XI R2, Universe Designer, Web Intelligence, Import Wizard, Report Conversion tool, CMC, CMS, Oracle 10g/9i, SQL Server 2005/2008, and Quality Center.

Confidential, Richmond VA

BO Developer

Responsibilities:

• Involved in initial analysis, requirements gathering and capacity planning at the time of major corporate Business Objects version upgrade to XI R2.
• Created and updated universes using Designer in BusinessObjects XIR2 based on the reporting requirements
• Developed different types of standard reports with drilling capabilities in tables, cross-tab and charts with complex calculation, and multiple data provider’s in both Full Client and Web Intelligence environments
• Involved on testing migrated reports in Business Objects DeskI and WebI reports from BO 6.5 to XI R2.
• Created Schedule task and distributed to end users for period-end and special request reports.
• A developed report with VB Macros to pass parameters while the report is scheduled and automatically emails to end-users as agnostic document.
• Performed Audit function for user activity statistics and monitoring the environment.
• Applied and corrected variable context corrections for reports in Deski.
• Worked on changes to existing WebI reports according to XI R2 in compatibility to existing reporting environment.
• Applied changes to existing WebI reports by performing formatting and other changes.
• Mapped previous version reports to point to test universe for verifying changes and used additional data providers to test the DeskI reports.
• Actively participated in performance tuning sessions and suggested some model changes to improve the reports performance and overall system performance
• Developed some Merchant and Transaction based Dashboards using Xcelsius
• Created Technical and Design Documents, Test Consideration Documents, Run documents for new Reports and universes.
• Performed report data integrity check through running the query against SQL Server using SQL Server Management Studio.
• Performed extensive Report Testing includes UAT and Regression testing.
• Prepared test cases for migrated and tested reports.

Environment: Business Objects XI R2/6.5, Universe Designer, Desktop Intelligence, Web Intelligence, Import Wizard, Report Conversion tool, SQL Server 2000/2005, Oracle 9i

Consolidated Graphics, Houston TX

BI Developer

Responsibilities:

• Thorough analysis of the legacy systems and gathered business requirements to incorporate the changes to meet the reporting needs.
• Interacted with Data Architects to get a clear understanding of the Dataflow and Database Design/Structure.
• Created the BusinessObjects Universe, Classes and Objects with the Collections warehouse and DLF System.
• Potential usage of alias, context, and joins concepts to resolve the loops.
• Designed aggregated tables on the most frequently queried data, and used @aggregate aware functionality in defining dimensions and measures. Setup custom hierarchies for drilldown paths.
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts). Worked extensively with the major functionalities of BusinessObjects like Group By, query prompt, drill filter, and Breaks, Sorts, Ranking, Calculation using the Slice and Dice panel.
• Created user Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Used Broadcast Agent Console to manage the schedules and prioritizing the scheduled jobs.
• Created required restriction sets to maintain the security for the users uing Supervisor.
• Created complex reports using multiple data providers like Oracle, SQL and Excel to extract data and also to Validate.
• Performance Tuning of Reports by creating Linked Universes, Joins, Contexts and Aliases for resolving Loops and checked the Integrity of the Universes using Business Objects Designer module during development.
• Regular Production moves after the project got the UAT sign-off involving Universes, reports, groups and categories.
• Ensuring data accuracy, connectivity and format changes if any along with security model after the production move.
• Re-creating/validating the universe connections, report data source information to ensure data is extracted from the correct source.

Environment: BusinessObjects 6.5.1, Desktop Intelligence 6.5.1, Designer 6.5.1, Supervisor 6.5.1, Oracle 9i, TOAD, Windows 2003.

Confidential

BO/Crystal Developer

Responsibilities:

• Actively involved in creating and updating users/user groups and maintained user profiles using Supervisor.
• Created Classes and Objects (Measure, dimension and detail) in the universe.
• Used Designer Module to implement Universes, Joins between Tables, and created prompts and queries, parsing of Universes, and created Contexts and Alias Tables to remove cyclic dependencies.
• Designed and Maintained Universes and exported them to the repository.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Interacted with the business users to understand their requirements and documented the scope and specifications.
• Created reports using standard company templates. A few of them were created based on the Department requirements.
• Formatted reports as per the user’s requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Gathered report requirements from business end users/clients and assisted business partners in retrieving business information from data warehouse and resolved any SQL query issues.
• Created user Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Involved in the creating the reports on the web using the WebIntelligence.
• Generated complex reports using Business Objects.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, and Drill filters.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Used Broadcast Agent for periodic generation and refreshing the reports.
• Used Broadcast Agent Console for monitoring the load on the BCA server and prioritizing the scheduled jobs.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.
• Planned, coordinated and executed Business Objects deployment for End-users and documented the entire project.

Environment: BusinessObjects 6.5/5.1, Supervisor 6.5, Designer 6.5, Desktop Intelligence 6.5, Oracle 8i/7i, VBScript, MS Excel, Windows 2000