SUMMARY

• Over 9 years of Professional Experience in Data Warehousing as Business Intelligence Reporter using tools like SAP Business Objects XI 4.2, XI 3.1, XI 3.0, XI R2, 6.x, 5.x, Crystal Reports, Crystal Xcelsius, Dashboards.
• Experience in using Business Intelligence (BI) Tools like SAP Business Objects XIR3/XIR2/6.x/5.x to build complex universes and reports on multiple databases and experience in development, testing and implementation.
• Experienced in working with Business Objects modules like CMC, Designer, Info View, Web Intelligence, Performance Manager, Import Wizard, Publishing Wizard, Supervisor and Broadcast Agent, ZABO, EDMS.
• Experienced in installation, configuration, migration and administration of Business Objects XI R3 and the previous versions.
• Having Industrial Experience on Data Warehouse, Business Intelligence and Data Mart systems in implementation of Business objects applications for various verticals such as Dairy/farming Production, Insurance, Food Production Industry, Pharmaceutical, and Financial.
• Expertises in resolving join path problems like Loops and Traps in the universes using Aliases and Contexts.
• Expert in working with Business Objects Performance Management to create Dashboards and Analytics.
• Experience in Creating & Maintaining various complex Ad - hoc reports using Web I and Desk I/ Business Objects.
• Extensively used Business Objects reporting functionalities such as Filters, Ranking, Alerts, Sections, Breaks, Sorts, Query prompts and Drill filters.
• Extensively used Calculation Contexts, Variables, Drill down, Slice and Dice in making the reports easy for user analysis.
• Hands on experience in Installation and Configuration of Business Objects Enterprise XIR3 in Windows environment.
• Involved in Migration of Business Objects 6.5 content in to Business Objects XIR2 environment.
• Good experience in Crystal Reports XI/10/9, Business Objects Suite (6.x/XIR3) Designer, Desktop Intelligence, Web Intelligence, Broad Cast Agent, Central Management Console/ Supervisor, Performance Management / Application Foundation.
• Experience in developing Crystal Reports, Cross Tab Reports, Top N Reports for highlighting significant data, summary reports with drill-down capabilities.
• Involved in administration tasks such as managing user accounts and groups, controlling user access, scheduling reports and events.
• Extensive knowledge in all phases of software development life cycle. (Requirement Analysis, Design, Development, Testing and Documentation). Exposure to version tracking control systems (PVCS, Exchange)
• Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying for the Metadata Management solutions.
• Specialized in creating complex query reports using Oracle, SQL server, MS Access and various RDBMS.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, SQL Server 2008/2005/2000, DB2 UDB 8.0, MS Access, Teradata.

BI Tools: SAP Business Objects XIR4/XIR3/XIR2 (Info view, CMC, CMS, CCM, Designer, Desk I, Web Intelligence, Import Wizard, Report Conversion Tool, Performance Manager, Query as Web Services), Business Objects 6.5.1/6.1b/5.1.2 (Supervisor, Designer, Reporter), ZABO, Application Foundation, Crystal Xcelsius 4.5, WEBI 6.x/2x, Broadcast Agent 6.x/5x, Crystal Reports XI/10, Crystal Viewer.

ETL tools: Informatica (Power Center 5.1/6.2/7.1, Power Mart 5.1/6.2)

Front-end tools: TOAD, SQL Developer

Modeling Tools: Erwin 4.1/3.5.2, Visio 2000, UML 2.0

Programming Languages: SQL, PL/SQL, Oracle Forms 4.5/6i, Java, VB 6.0, UNIX Shell Scripting, XML, HTML, ASP.

Operating Systems: Windows95/98/2003/XP, Window 7, LINUX

Web Tools: Tomcat, Apache, Web Sphere, Web Logic, IIS

PROFESSIONAL EXPERIENCE

Confidential, Baraboo, Wisconsin

Sr. BI Consultant

Responsibilities:

• Duties included requirements gathering, documentation and the development of Business Reporting analysis and testing to meet those requirements
• Responsible for setting up the Users/Groups, Database connections, assigning privileges to the users using Supervisor.
• Modification of Universes to meet the Business Intelligence reporting and checked the Universes for Integrity and exported them to the Repository to make them available to the users and groups.
• Developing Corporate, Marketing Dashboards based of Live Office connections, BIWS connections, Universe, and Web Intelligence Reports using SAP Business Objects Xcelsius2008.
• Created Business Objects Web Intelligence reports, enhancements and fixes of the reports and customizing BO universes.
• Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
• Created derived tables to reduce the complexity of the universes and also created prompts to force the users to restrict the data in the process of building the universes.
• Involved in the troubleshooting of universe schema with Loops, Chasm and Fan traps and Cardinality problems by creating Aliases and Contexts as required.
• Created custom List of Values (LOVs) for better understanding of prompts by the end user.
• Created Adhoc and Canned reports and fine tuning them for faster execution.
• Created WebI Reports based out of Dairy Management System, Milk Procurement Information System and Kronos System.
• Created custom Hierarchies to support drill down functionality for in depth analysis.
• Extensively used Calculations, Variables, Breaks, Slice and Dice and Alerts for creating Business Objects reports.
• Linked Universes to share the common components using Kernel and Component approach.
• Generated complex reports using the various data Providers like Universes, Personal Data Files and Free Hand SQL.
• Created Web Intelligence documents and published them to Corporate Catalog.
• Worked with DBA for creating the aggregate tables to improve the performance of the SQL transactions and used Aggregate Awareness (@Aggregate Aware) in select statements to run a query against the aggregate tables in the database instead of base tables.
• Converted the existing full client reports to Web I reports using Report Conversion Tool.
• Imported existing users, groups, categories, Web I documents, connections, universes and restrictions to BO XI environment.
• Interacting regularly with end-users and process owners in various functional areas to identify ways to improve the effectiveness of existing reporting and analytics to drive effective business improvement.

Environment: SAP Business Objects XI4.2/XI3.1, Xcelsius2008, Designer, Web Intelligence, Desktop Intelligence, Oracle, TOAD, Windows Server 2003.

Confidential, Raleigh, NC

Sr. Business Objects Developer

Responsibilities:

• Gathering the user requirement and prepare the requirement specifications document. This involved interaction with the business users and understanding the current reporting system.
• Responsible for setting up the Users/Groups, Database connections, assigning privileges to the Users using Supervisor.
• Created centralized Repository with all three domains (security, universe and document) and distributed the BO Main key among the enterprise.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies, Strategies. Resolved the loops using Aliases and contexts and checked the Integrity of the Universes.
• Created Business Objects reports, enhancements and fixes using Web Intelligence and customizing BO universes.
• Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
• Worked in creation of multiple universe and document domains for development, test and production Environments.
• Developed Quality Doc Dashboards based of Live Office connections, QAAWS connections, Universe, and Web Intelligence Reports using SAP Business Objects Xcelsius2008.
• Created users, groups and assigned roles, privileges and also set row level and object level securities to different users and groups using Supervisor module.
• Good experience in creating and maintaining Secured, Shared and Personal connections.
• Migration of the Oracle R11 environment to R12 and Validation between two different source systems, compare values, calculations on the objects.
• Checked the integrity function for existence of loops and resolved them by using aliases and contexts.
• Involved in the performance tuning of the SQL queries by restructuring the Joins, creation of indexes etc.
• Manipulated the data by creating user defined objects using advanced database functions
• Involved in setting up of Aggregate awareness to enhance the performance of SQL transactions.
• Created the Reports using the universes as the main Data providers and writing the complex queries including Sub Queries, Unions.
• Formatting the Reports based on the user requirements using all the functionalities in Business objects like Slice and Dice, Drill Down, Alerter, User response, and Formulas etc
• Developed complex reports using @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), @Select and Cross Tab tables.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way and Hierarchies to provide the drill down functionality to end-users.
• Actively attended for the meeting in the team management to discuss the views and analysis of the documentation.

Environment: SAP Business Objects XIR 4.0, Xcelsius2008, CMC/Supervisor, Designer, Info View, Web I Rich Client, Oracle, LINUX.

Confidential, Madison, WI

Sr. Business Objects Developer

Responsibilities:

• Installed Business Objects modules, created Repository with multiple universes and document domains for Development and Test environments and distributed the Domain key among the enterprise.
• Created complex Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Managed the user, groups, repositories and the documents through Supervisor.
• Designed, created and implemented and tested dataflow, workflows, scripts and jobs for multiple projects.
• Full lifecycle project focusing on surveys, promotions, including Data Services and Designer components.
• Created ODBC database connections to the Clarity transactional database and to the Clarity Datamart database
• Responsible for gathering the user requirement; prepare the requirement specifications document, design, development, analysis and testing.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies, Strategies. Resolved the loops using Aliases and contexts and checked the Integrity of the Universes.
• Created Clarity BO reports, enhancements and fixes using Web Intelligence and customizing BO universes.
• Developed new Reports based on Business Requirements documents for IS Resources Management, Corporate Project Portfolio, Program, and Project Management at American Family.
• Involved in troubleshooting BO Central Management Console (CMC) problems.
• Performed report analysis to ensure existing documentation is accurately depicting the report information.
• Administer User Accounts, implement data security and personalization, and impart necessary involved in creating reports on the web using Business Objects Web Intelligence training and knowledge transfer to assigned project members.
• Generated Business Objects Reports involving complex Queries, Sub Queries Unions and Intersection.
• Created Users and Groups and assigned access levels to BO content as well as applications.
• Extensively used Designer to design various universes for different business groups.
• Used @ functions like @aggregate aware, @prompt and implemented custom hierarchies.
• Created complex reports using cascading prompts, variables and calculation context.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula's etc.
• Created a wide variety of charts from the table. Used reports and generated pictorial views in the form of 2D, 3D & Pie Charts from existing reports & Chart Wizard.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, Variables, and Formulas, Calculated data items, Filters, Sorts and Query prompt and Drill filters.
• Responsible for creating a Dashboard with graphical pie charts and speedometer representations with Crystal Xcelsius.
• Scheduled Reports using Crystal Reports and used the Business Objects Server Administration Tool.
• Actively attended for the meeting in the team management to discuss the views and analysis of the documentation for each stage of Implementation.
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing, data transformation and data loading.
• Works closely with the Database Administrators to address performance issues that arise, to monitor space for the database, to deploy code into the database, and trouble shoot problems.
• Performed unit testing, system testing and user acceptance test (UAT) for universe, reports, and security management.
• Created documentation for users to access and analyze data using Business Objects.

Environment: SAP Business Objects XIR 4.0, CMC/Supervisor, Designer, Info View, Web I, Crystal Reports, Xcelsius, Oracle, Toad, Windows XP.

Confidential, Decatur, IL

Sr. Business Objects Developer

Responsibilities:

• Installed Business Objects modules, created Repository with multiple universes and document domains for Development and Test environments and distributed the Domain key among the enterprise.
• Installed Business Objects XI 3.1 Designer and Import Wizard tools.
• Developed Dashboards using Performance Manager, Dashboard manager (XI R3.1) and Crystal Xcelsius (Standalone format)
• Designed, created and implemented and tested dataflow, workflows, scripts and jobs for multiple projects.
• Full lifecycle project focusing on surveys, promotions, including Data Services and Designer components.
• Installed the ADM PlanView Scoreboard Extension, Created ODBC database connections to the Planview transactional database and to the Planview Datamart database
• Responsible for gathering the user requirement; prepare the requirement specifications document, design, development, analysis and testing.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies, Strategies. Resolved the loops using Aliases and contexts and checked the Integrity of the Universes.
• Created Business Objects reports, enhancements and fixes using Web Intelligence and customizing BO universes.
• Developed new Reports based on Business Requirements documents for Projects, Resources, Work and Request Portfolios for PlanView Application.
• Assist in ensuring all existing BO reports work appropriately during the PVE10.2 upgrade project.
• Involved in troubleshooting BO Central Management Console (CMC) problems.
• Performed report analysis to ensure existing documentation is accurately depicting the report information.
• Provide guidance to I.T. team members in relation to Universe items or best practices for report promotions and/or report documentation.
• Generated Business Objects Reports involving complex Queries, Sub Queries Unions and Intersection.
• Created Users and Groups and assigned access levels to BO content as well as applications.
• Extensively used Designer to design various universes for different business groups.
• Used @ functions like @aggregate aware, @prompt and implemented custom hierarchies.
• Created complex reports using cascading prompts, variables and calculation context.
• Created different types of reports such as Master/Detail, Cross Tab, Chart and Tabular using universe as a main data provider.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, Variables, and Formulas, Calculated data items, Filters, Sorts and Query prompt and Drill filters.
• Responsible for creating a Dashboard with graphical pie chats and speedometer representations with Crystal Xcelsius.
• Performed unit testing, system testing and user acceptance test (UAT) for universe, reports, and security management.
• Interacted with Co Developers, Business Support Analysts and Business Users in gathering the requirements for the Report Requests.
• Attended PVE-Team meetings and Weekly Status meetings and documented each stage of Implementation.
• Created documentation for users to access and analyze data using Business Objects.
• Provided support and training for business users in using Info view and Web I

Environment: Data Services XIR 3.1, Business Objects XIR 3.1, CMC/Supervisor, Designer, Info View, Web I, Desk I, Crystal Reports, Xcelsius, Oracle, MS SQL Server 2005, Windows 7.

Confidential, Philadelphia, PA

Sr. BI Developer

Responsibilities:

• Experience with Installation and Configuration of all Business objects modules.
• Created Universes using the Business Objects Designer and connected to the database.
• Developed, implemented and maintained Universes using Business Objects Designer.
• Used Business Objects 6.5 for developing reports.
• Used Business Objects XI for securing the universes and extracting the universes from Metadata.
• Responsible for creation of the Universe with Classes, sub classes, Dimension Objects, Measure objects and Condition objects.
• Applied Row Level and Object Level securities to restrict sensitive data at designer level.
• Resolved loops in universes using Aliases and Contexts.
• Set up Aggregate Awareness to enhance the performance of SQL transactions.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Exported the Business Objects reports to the repository to be viewed by all the users on the intranet and the Internet.
• Involved in creating reports on the web using Business Objects and Web Intelligence. Involved in formatting the reports to the user requirements.
• Involved in Migration of Business Objects 6.5 content in to Business Objects XIR2 environment.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, list of values (LOVS), local variables, Alerts, Ranking and multiple data providers.
• Used Filters, Sections, Breaks, Sorts, Slice & Dice, Query prompts and Drill filters functionalities in making the reports easy for analysis.
• Created reports using Desk I and Web I in BO XIR2 environment.
• Developed Full client reports and Web I reports with various complex features and user accounts.
• Administer user accounts, implement data security and personalization, and impart necessary features involved in creating reports on the web using Business Objects Web Intelligence training and knowledge transfer to assigned project members.
• Scheduled Reports using Crystal Reports and used the Business Objects Server Administration Tool.
• Managed the user, groups, repositories and the documents through Supervisor. Actively attended for the meeting in the team management to discuss the views and analysis of the documentation.

Environment: Business Objects 6.5/XIR2(CMC/Supervisor, Designer, Desk I, Web I), CCM, Report Conversion Tool, BCA, Performance Manager, Crystal Reports, Teradata SQL Assistant, Windows 2003 Server.

Confidential, Pittsburgh, PA

Sr. BI Consultant

Responsibilities:

• Installed Business Objects and created Repository with multiple universe and document domains for Development and Test environments and distributed the Domain key among the enterprise.
• Configured Web Intelligence using Configuration tool.
• Responsible for setting up the Users/Groups, Database connections, assigning privileges to the users using Supervisor.
• Assigned Broadcast Agent to various groups using Web I Admin Console.
• Implemented security structures with Row Level restrictions and Object hiding.
• Defined categories of documents for different level of groups.
• Involved in gathering functional requirements from the business users.
• Design and Development of Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
• Created derived tables to reduce the complexity of the universes and also created prompts to force the users to restrict the data in the process of building the universes.
• Involved in the troubleshooting of universe schema with Loops, Chasm and Fan traps and Cardinality problems by creating Aliases and Contexts as required.
• Created custom List of Values (LOVs) for better understanding of prompts by the end user.
• Created Adhoc and Canned reports and fine tuning them for faster execution.
• Created custom Hierarchies to support drill down functionality for in depth analysis.
• Extensively used Calculations, Variables, Breaks, Slice and Dice and Alerts for creating Business Objects reports.
• Linked Universes to share the common components using Kernel and Component approach.
• Generated complex reports using the various data Providers like Universes, Personal Data Files and Free Hand SQL.
• Created Web Intelligence documents and published them to corporate documents.
• Defined categories of documents for different level of groups.
• Involved in day-to-day Business Objects Server maintenance.
• Optimized systems with load balancing with distributing components on different servers.
• Worked with DBA for creating the aggregate tables to improve the performance of the SQL transactions and used Aggregate Awareness (@Aggregate Aware) in select statements to run a query against the aggregate tables in the database instead of base tables.
• Created users/groups and defined privileges using Central Management Console. Migrating Business Objects 6.5 version reports to new version XIR2.
• Converted the existing full client reports to Web I reports using Report Conversion Tool.
• Imported existing users, groups, categories, Web I documents, connections, universes and restrictions to BO XI environment.
• Actively involved in giving demos to the users and prospective users about the functionality available in Business Objects.

Environment: Business Objects 6.5.1/5.1.8 (Supervisor, Designer, Reporter), Web I 6.0, ZABO, Info View, Broadcast Agent, Oracle 9i, DB2 UDB, SQL, TOAD, Sun Solaris, Windows 2000/NT.

Confidential, Memphis, TN

BO Consultant

Responsibilities:

• Gathering the user requirement and prepare the requirement specifications document. This involved interaction with the business users and understanding the current reporting system.
• Involved in the Installation and configuration of all components of Business Objects and configured the Web Intelligence using configuration tool.
• Responsible for setting up the Users/Groups, Database connections, assigning privileges to the Users using Supervisor.
• Installed & configured BCA Scheduler & Publisher BCAP.
• Assigned Broadcast Agent to various groups using Web I Admin Console.
• Created centralized Repository with all three domains (security, universe and document) and distributed the BO Main key among the enterprise.
• Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
• Worked in creation of multiple universe and document domains for development, test and production Environments.
• Created users, groups and assigned roles, privileges and also set row level and object level securities to different users and groups using Supervisor module.
• Good experience in creating and maintaining Secured, Shared and Personal connections.
• Involved in designing and developing of Universe for reports generation.
• Checked the integrity function for existence of loops and resolved them by using aliases and contexts.
• Involved in the performance tuning of the SQL queries by restructuring the Joins, creation of indexes etc.
• Manipulated the data by creating user defined objects using advanced database functions
• Involved in setting up of Aggregate awareness to enhance the performance of SQL transactions.
• Created the Reports using the universes as the main Data providers and writing the complex queries including Sub Queries, Unions.
• Formatting the Reports based on the user requirements using all the functionalities in Business objects like Slice and Dice, Drill Down, Alerter, User response, and Formulas etc
• Developed complex reports using @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), @Select and Cross Tab tables.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way and Hierarchies to provide the drill down functionality to end-users.
• Created Full Client reports using different Data providers like Oracle, Excel sheets, SQL server.
• Created report level contexts in Web Intelligence and Desktop Intelligence reports.
• Used Broadcast Agent for scheduling and distributing the documents.
• Gave my thoughts and ideas to the data-modeling team in designing a new data mart for future reporting applications.
• Trained business users in creating web intelligence reports.

Environment: Business Objects 6.5.1(Supervisor, Designer, Reporter),Web Intelligence 6x, Broad Cast Agent, ZABO, Crystal 9, Oracle 9i, MS SQL server 2000, Sybase 12.0,TOAD,ERWIN,Windows 2000/NT,UNIX.