SUMMARY

• Over 7 years of experience in Information Technology using Business Intelligence Tools in various versions - BI 4.1, BO XI R3 and XI R2 on Windows and UNIX environments.
• Experience as an Application Developer with all phases of Software Development Life Cycle (SDLC) including Requirement Gathering, Design, Development, Testing, Maintenance and Documentation.
• Experience in developing reports and dashboards using Desktop Intelligence, Web Intelligence, Crystal Reports, Excelsius/Dashboard Design Tool and Tableau.
• Experience in creating and modifying Universes using Universe Design Tool (UDT) and Information Design Tool (IDT).
• Experience with Business Intelligence Administration Tools like Central Management Console (CMC), Central Configuration Manager (CCM), Infoview /Admin Launch Pad, Import Wizard/Upgrade Management Tool (UMT) and Report Conversion Tool (RCT).
• Database Experience with Oracle, SQL, PL/SQL, SQL Server Management Studio, SQL Developer, TOAD and SQL*Plus.
• Technical expertise in setting up Business Objects environments including installation of client tools and server products.
• Experience with migration from BO XI R2 to BO XIR3 using Import wizard and also from BO XIR3 to BI 4.1 using Report Conversion Tool & Upgrade Management Tool.
• Expertise in creating complicated reports using Filters, Breaks, Folds, Sorts, Sections, Alerts, Ranks, Variables, Input Controls and multiple data providers.
• Experience with Infoburst, a comprehensive and powerful solution for scheduling, bursting, and distributing reports to extend the reach and effectiveness of the Business Intelligence deployment.
• Experience in Query Optimization and Performance Tuning of business applications and practiced several methods to improve the performance at database level, universe level and query level.
• Ability to work independently or in a team with minimum guidance.
• Excellent verbal, written and presentation skills along with strong analytical and problem solving skills.
• Flexible to adapt to new environment with a strong desire to learn the latest technologies.

TECHNICAL SKILLS

BI/Reporting Tools: Business Objects 4/XI R3/R2, Universe Design Tool, Information Design Tool, Desktop Intelligence, Web Intelligence Rich Client, Central Management Console, Central Configuration Manager, Info View, Report Conversion Tool, Import Wizard, Upgrade Management Tool, Query as a Web Service Designer, Crystal Reports, Business View Manager, Dashboard Designer, Infoburst, Informatica, SSIS, Tableau

Database Tools: SQL Server Management Studio, SQL Developer, TOAD, SQL* Plus

Operating System: Windows 8/7/XP/Vista, UNIX

Languages: SQL, PL/SQL, C, Basic Java, HTML,VHDL

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Business Objects/Crystal Reports Developer

Responsibilities:

• Involved in gathering, analyzing, documenting business/functional requirements and data specifications for report creation using Business Objects Web Intelligence and Crystal Reports.
• Interacted with business users often to know their business needs to effectively develop reports.
• Created and modified Business Objects Universes using Universe Design Tool (UDT) and Information Design Tool (IDT) according to the user requirements.
• Inserted new tables, created joins between tables, assigned proper join cardinalities, resolved loops, created objects/predefined conditions in existing Business Objects Universes when needed.
• Created Crystal Reports and Web Intelligence reports using Oracle and SQL Server databases as back end.
• Created complex Web Intelligence reports using multiple data providers by merging the common dimension objects and creating detail objects for any incompatible dimension objects.
• Creating Web Intelligence reports using Input Controls, Element Links and Document Links/Hyperlinks.
• Created numerous Web Intelligence/Crystal Reports having Cross-Tabs and Charts.
• Enhanced existing Web Intelligence/Crystal Reports by creating Filters, Sorts, Parameters, Formulas, etc.
• Designed and developed Crystal Reports using Universes and ODBC as Data Sources.
• Experience with creating and modifying DSN’s using ODBC Data Source Administrator.
• Configured the Database logon information for Crystal Reports in Central Management Console (CMC).
• Published and scheduled reports in BI Launch Pad to run on daily/weekly/monthly basis to different destinations as requested by the users.
• Wrote several SQL queries to query the database and use them as Command objects while creating Crystal Reports.
• Tested the reports for accuracy using the SQL queries and executing them in SQL Developer and SQL Server Management Studio.
• Optimized the database queries to make the reports run faster.
• Provided support for the existing Crystal/Web Intelligence Reports and modified them when needed.
• Created and modified numerous PL/SQL Views, Stored Procedures using temporary tables for data input to Crystal Reports.
• Designed, Developed and Supported Interactive Tableau Dashboards with connections to multiple data sources like Oracle, SQL Server.
• Designed and deployed Tableau Dashboards with Drill Down reports.
• Created Calculated Fields, Quick Filters and Parameters to handle views more efficiently in Tableau.
• Created Dashboards having various charts like Line, Bar, Pie, Combination.
• Resolved Trouble Tickets assigned to Engineering and Operations BI Group.
• Resolved Business Objects user issues while creating Web Intelligence reports.

Environment: BI 4.1, Universe Design Tool, Information Design Tool, Web Intelligence Rich Client, Central Management Console, BI Launch Pad, Crystal Reports 2013, Tableau 8.2, SQL Developer, SQL Server Management Studio.

Confidential, Cleveland, OH

Business Objects Developer

Responsibilities:

• Participated in project planning sessions with managers and team members to analyze business requirements and outline the proposed solution.
• Involved in administration of the Business Objects environment using Central Management Console (CMC) and Central Configuration Manager (CCM) Modules.
• Assisted Business Objects users with Account/Folder security.
• Promoted Business Objects content from Dev to Test and then from Test to Production servers using Promotion Management in BI 4.
• Created Business Objects Universes and reports in BI 4 and modified them whenever needed.
• Maintained Database connections for all the Universes.
• Created reports using Universes as well as Excel Sheets as data providers.
• Created complex Web Intelligence reports using multiple data providers by merging the common dimension objects from different providers.
• Extensively worked with Filters, Breaks, Folds, Sorts, Sections, Alerts, Ranks, Variables and Formulas while creating reports.
• Created Web Intelligence reports using new features like Grouping and Input Controls.
• Created various Crosstab reports and Charts.
• Involved in setting up of security restrictions for all Universes and reports to make them available to specific users/user groups for ad-hoc reporting.
• Scheduled reports and publications in BI Launch Pad.
• Resolved Business Objects issues on users machines using LANDesk Management Suite Web Console.
• Resolved tickets created in Remedy IT Service Management Suite and assigned to our BO group.
• Completely involved in the migration of Business Objects from XI R3 version to BI 4.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Converted and validated reports and maintained proper documentation.
• Used Upgrade Management Tool (UMT) to move Web Intelligence reports from XI R3 to BI 4.
• Interacted with customer support regularly in order to generate the reports required and to resolve any existing issues with report data.
• Involved in evaluating existing reports to identify potential areas of improvement and optimized report performance whenever needed.
• Strong experience with SQL and PL/SQL queries.
• Participated in team meetings to share technical and business knowledge that lead to better planning.
• Developed Business Objects user documentation guide for end users reference.
• Provided training to users on the latest SAP BI 4 version.

Environment: Business Objects XI R3, BI 4.1, Universe Designer, Desktop Intelligence, Web Intelligence Rich Client, Central Configuration Manager, Central Management Console, Info View/BI Launch Pad, Oracle 11g, Toad, SQL.

Confidential, Phoenix, AZ

Business Objects Developer/Administrator

Responsibilities:

• Completely involved in administration of the Business Objects environment using Central Management Console (CMC) and Central Configuration Manager (CCM) Modules.
• Created new BO user logins and applied security restrictions for proper usage of the reporting system.
• Created report servers when needed using Central Configuration Manager.
• Applied patches to Business Objects new job servers and Test and Production servers.
• Used Import wizard frequently to move reports from Development servers to Production servers.
• Created Business Intelligence Archive Resource (BIAR) files of the production server as backup using Import wizard.
• Exported Universes and reports to the Repository and restricted access to make resources available to the users for ad-hoc reporting.
• Implemented Security Features of Business Objects at row level, object level and report level to make the data secure.
• Created Business Objects reports in Desktop Intelligence and Web Intelligence and published them to corporate documents.
• Created reports using Universes, Excel Sheets and free-hand SQL as data providers.
• Extensively worked with Sections, Breaks, Filters, Sorts, Alerts, Ranks, Variables and Formulas while creating reports.
• Worked with Business Objects functions like @prompt, @where, @select etc.
• Scheduled and monitored reports using Business Objects Infoview and Infoburst.
• Involved in modifying distribution lists for scheduled reports as per user request.
• Involved in restarting the Infoburst scheduling and Cataloging service when Infoburst stalled and failed to execute scheduled reports.
• Involved in Catalog Management, Burst Management, Schedule Management, User Management and Group Management in Infoburst Scheduler.
• Was involved in setting up Business Objects report failure notifications in BO Infoview and Infoburst to identify report failures quickly.
• Performed Status check frequently and did troubleshooting in case of issues.
• Used Query as a Web Service to build Dashboards based on the reports built in Business Objects.
• Was involved in the Ramp-up Program for Business Objects latest release 4.0.
• Installed Business Objects 4.0 on a test server and tested various tools present in BO 4.0 like Universe Design Tool, Information Design tool, Interactive Analysis Desktop (Web Intelligence Rich Client), Central Management Console, BI Launch Pad, Report Conversion Tool and Upgrade Management Tool.
• Migrated Universes and reports from Business Objects XI R2/R3 environments to 4.0.
• Developed Business Objects user documentation guide for end users reference.

Environment: Business Objects XI R2, Business Objects XI R3, Business Objects 4.0, Designer, Desktop Intelligence, Central Configuration Manager, Central Management Console, Instance Manager, Info ViewInfoburst, Oracle 11i/10g/9i/8, Toad, SQL, MS Office.

Confidential, NJ

Business Objects/Crystal Reports Developer

Responsibilities:

• Involved in gathering, analyzing, documenting business/functional requirements and data specifications for Crystal Reports.
• Designed and developed reports using Crystal Reports. Responsible for creating the reports (Summary, Detail, on-Demand, Adhoc Reports, Graphical, etc).
• Provided Production support for the existing Crystal Reports and modified them when needed.
• Modified Crystal Reports using Universe as the main data provider.
• Used Crystal Reports Enterprise to schedule reports to run on daily/weekly/monthly basis to different destinations.
• Involved in building new Universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Created new Classes, Sub-classes and Objects as per the requirement and identified Objects as Dimensions, Details or Measures.
• Resolved Loops in the Universes creating Contexts and Alias Tables to remove the cyclic dependencies.
• Used Derived tables while creating Universes for best performance.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc reporting.
• Modified existing Universes by adding new classes/objects and prompts based on the business requirement.
• Used SQL against the database to cross check the data retrieved.
• Applied sections, Breaks, Report Filters and Query Filters and displayed the information in different Blocks in reports.
• Scheduled various reports on Daily, Weekly, Monthly and Yearly basis.
• Created various Charts, Cross Tab and Master/Detail reports.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Provided end user support and problem resolution for various issues related to BO.
• Tuned and Optimized reports to obtain better performance.
• Carried out training sessions on a one-on-one basis to educate clients about the application.

Environment: Business Objects XIR2 Designer, Desktop Intelligence, Web Intelligence, Info View, SQLOracle 10g, Toad, Xcelsius 2008, Live Office, Crystal Reports 2010, BO SDK, MS Office.

Confidential, PA

Business Objects Consultant

Responsibilities:

• Interacted with Business Users and Business owners in Gathering, Analyzing, and Documenting Business requirements, Functional requirements and Data specifications to develop/modify Business Objects Universes and Reports.
• Developed Universes by defining joins, cardinalities between tables, creating prompts, creating contexts and alias tables to resolve loops/traps.
• Created various kinds of Objects and grouped them into Classes while in designing the Universes.
• Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Worked extensively with business objects functions like @select, @Prompt and @Where to write flexible SQL queries.
• Interacted with various users for reporting requirements.
• Created Templates for standardizing the structure of the corporate documents.
• Worked on Query Panel, Prompts, Report Layout and Report formatting.
• Extensively worked with Sections, Breaks, Filters, Sorts, Alerts, Ranks, Variables and Calculations while designing reports.
• Worked on Query Panel, Prompts, Report Layout and formatting.
• Developed Ad-hoc reports to meet specific requirements.
• Involved in trouble shooting of various reporting errors.
• Scheduled reports using Business Objects Infoview.

Environment: Business Objects XIR2 Designer, Desktop Intelligence, Web Intelligence, Info View, SQL Server, TOAD, MS Office.

Confidential, Austin, TX

Business Objects Consultant

Responsibilities:

• Analyzed the system, met with end users and business units in order to define the requirements for new Universe development and maintained the existing Universes.
• Designed Universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects, which are grouped into classes for convenience.
• Created Universe Classes and Objects by retrieving the data from various Data Sources and defining the necessary database connections.
• Exported Universe across different environments from development to Production.
• Designed the reports and Universes as per the requirements.
• Formatted the Reports as per the Users requirements using Business Objects, which allows the users to analyze the data.
• Extensively used calculations, variables, drill down and slice and dice for creating reports.
• Developed report alerts based on conditions as per user requirements.
• Developed different types of reports with features like filtering, ranking etc.
• Carried out the performance monitoring and tuning of reports.
• Designed effective Report Templates for reusing in Reports.
• Provided Technical training to IT staff, basic training for report consumers and detailed end-user training for power users regarding the new XIR2 features.

Environment: Business Objects XI R2 Designer, Web Intelligence, Desktop Intelligence, Info view, Oracle 9i, SQL * plus, Windows 2003 Server, MS Office, Toad.

Confidential, OH

Business Objects Consultant

Responsibilities:

• Worked with Business Objects team to review the Universes for possible enhancements.
• Responsible for modifying existing Universes according to end user request.
• Involved in Installation and Configuration of all Components of Business Objects.
• Involved in resolving the Loops, Cardinalities, and Contexts and Checked the Integrity of the Universes.
• Created reports using Business Objects functionalities like Slice and Dice, Drill down, Cross Tab, Master/Detail, Custom Queries etc.
• Exported the Universes to Repository for making them available to the end users.
• As a part of Report development created the Reports using Universes as the main data provider and using the Business Objects functionalities like @ Functions and Formulas.
• Resolved Fan traps and Chasm traps in the schema using optimal solutions accordingly.
• Developed documents against existing Universe including universe-based full client report and free hand SQL reports.
• Worked extensively with the major functionalities in BO like Sections, Breaks, Filters, Sorts, Ranks, Alerts and Query Prompts.
• Provided Production support for the existing reports and modified them when needed.
• Scheduled and monitored reports using Infoview.
• Involved in Training end users in creating, modifying and interpreting BO reports.

Environment: Business Objects XI R2 Designer, Desktop Intelligence, Web Intelligence, Info View, Oracle 9i, Toad, SQL*Plus, MS Office, Toad, UNIX, Windows Server 2003.