SUMMARY

• Over 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 4.0XI3.1/R2/6.x/5.x, CMC, Desktop Intelligence, Web Intelligence, Import Wizard, and Report Conversion Tool), Crystal Reports 2008/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, Sybase, Teradata.
• Implemented RDBMS concepts by analyzing the data from the Data Marts
• Created Full Client reports using different Data providers like Teradata, Excel sheets, SQL server, Oracle.
• Expertise in Integrating and Extracting data into Business Objects environment from the SAP BW database system.
• Experience in Migrating to BO XI R2/3.1 from previous versions (6.5.x and 5.1.x).
• Extensive experience in creating Tables, Views, Indexes, writing Stored Procedures, using T SQL (DML and DDL) as well as analyzing and debugging existing complex stored procedures.
• 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 4.0/3.1/ 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, Congo's 10.1/8.4

Web Technologies: HTML, XML, VBScript

ETL Tools: Data Integrator, Informatica 7.1,SSIS.

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

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

PROFESSIONAL EXPERIENCE

Confidential, KS

BI Analyst & Developer

Responsibilities:

• Worked in an agile environment, Interacted with Business Users and Managers in gathering business requirements for universe, reports and dashboards.
• Worked as an Analyst and Developer in two different roles.
• Analyzed, Designed and configured the classes and objects in Universe.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loop and checked the integrity of the universes.
• Providing effort estimation, Release plan and development status tracker.
• Coordinate with offshore resources to track the daily status on the report development and testing.
• Mapping documents between application labels and database columns to universe objects.
• Weekly external meeting with CSC clients and IT Manager to force see any application issues raised during report development, analysis and testing for data quality. Weekly internal team meeting with all onsite and offshore developers to track the deliverables status for the upcoming bundle/release plan.
• Created the reports using Business Objects functionalities like Queries, Drill Down, Cross Tab, Master Detail and Formula, and organized data in the report by inserting Filters, Sorting, Ranking and highlighting data.
• Closely worked with the ETL team to analyze any data discrepancies.
• Worked with the IT team to bring in the data required into Business Objects Universe so as to make available for super users to create Ad-hoc reports.
• Extensive experience in creating ETL solutions with different data sources like RDBMS, Flat file, XML, Excel

Environment: SAP Business Intelligence 4.0, BI Launch Pad (Info View), UDT, IDT, Web Intelligence, Crystal Reports, QAAWS, Live Office, SP3, SAP Business Objects Dashboards 4.0, Import Wizard, Oracle 11g, PL/SQL, Oracle E Business Suite, Oracle Sql Plus.

Confidential, Richmond, VA

BI Developer

Responsibilities:

• Created Business Objects (BOBJ) Universe on top of Oracle and Teradata database.
• Migrated Reports and Universe to Teradata.
• Created Universe for Audit Data warehouse reporting.
• Created various LOV filters in Universe and sorted them based on the requirements.
• Created the reports using Business Objects functionalities like Queries, Drill Down, Cross Tab, Master Detail and Formula, and organized data in the report by inserting Filters, Sorting, Ranking and highlighting data.
• Prepared complex reports like standard and ad-hoc reports using Web Intelligence.
• Responsible for unit testing as well as Pre-UAT.
• Worked with the IT team to bring in the data required into Business Objects Universe so as to make available for super users to create Ad-hoc reports.
• Assisted Business users in Ad-hoc report creation.
• Implemented different concepts like Hierarchy, Aggregate awareness, Derived tables in the universe design
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Diagnosed, investigated, analyzed and resolved issues regarding application and end user support.

Environment: SAP Business Intelligence 4.0, BI Launch Pad (Info View), UDT, IDT, Web Intelligence, Crystal Reports, QAAWS, Live Office, SP3, SAP Business Objects Dashboards 4.0, Import Wizard, Teradata, Teradata SQL Assistant, Oracle 11g, PL/SQL, Oracle E Business Suite, Oracle Sql Plus.

Confidential, Ann Arbor MI

Business Objects Developer/Data Analyst

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.
• Created Different Universes for separate reporting requirements, which run against Teradata Database.
• 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/4.0 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.
• Implemented Migration process for Business Objects XI R2 to XI 3.1, 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.
• Used Sybase IQ for reporting and advanced analysis as per user requirement.
• Provided support in enhancement and maintenance of the Reports and Universes.
• Reviewed the Metadata Repository in order to generate by running projects using Statistics.

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

Confidential, San Francisco CA

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.
• 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.
• Using Teradata database as backend, developed universes for end client reporting requirement.
• 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.
• Extensively used different databases like Teradata, Oracle Sql server, Excel sheets.
• Performed report data integrity check through running the query against SQL Server using SQL Server Management Studio.
• 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,Teradata and Quality Center.

Confidential, NY

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.
• Scheduled reports and automatically emails to end-users as agnostic document.
• Performed Audit function for user activity statistics and monitoring the environment.
• Worked on changes to existing WebI reports according to XI R2 in compatibility to existing reporting environment.
• 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.

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

Confidential

BI Developer

Responsibilities:

• Thorough analysis of the legacy systems and gathered business requirements to in corporate 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 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.