SUMMARY

• Over 6+ years of experience in Business Intelligence using SAP Business Objects XI R3.1/R2, BO Designer, Desktop Intelligence, Webi Rich Client, Crystal Reports 9/10/XI/2008, Xcelsius 4.5/2008, Infoview, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), Query as a Web Service, Live Office, Publishing Wizard, Import Wizard and Report Conversion Tool.
• Workable knowledge on Business objects XI 4.0
• Experience working with Raiser’s Edge application, Banner software.
• Excellent ability in writing specifications and gathering requirements from the user to develop Crystal Reports as per the needs of the client and maintain documentation of the reports for future reference.
• Complete Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing.
• Experience in Developing, Maintaining & Modifying Universes using Business Objects Designer.
• Experience on working with multiple databases like MS SQL Server 2008/2005/2000 , Oracle 11g/10g/9i/8i/8.0, DB2 400, and MS Access, MS Excel.
• Worked in various BO environments linking data from multiple sources, applying several functionalities, and using various Data Providers.
• Developed Xcelsius dashboards for presentations, livedata, dashboards with alerts, Calculators, Historical data comparisons.
• Worked extensively with Business Objects functionalities like Alerts, Filters, Query Prompts and Drill filters and worked with multiple data providers.
• Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc.
• Built reports using multiple data providers, external data providers and used merge dimension functionality.
• Extensive experience in Performance Tuning and Query Optimization, Optimizing universe through Linked Universes, Aliases and Contexts.
• Experience in diversified project sectors such as Educational Institution, Banking, Pharmaceutical, Insurance, and Manufacturing.
• Ability to quickly adapt to new technologies very quickly and different project environments.
• An excellent team member with interpersonal, communication and presentation skills along with Time management.

TECHNICAL SKILLS

BI Tools: SAP Business Objects XI 4.0, 3.1, R1/R2, Desktop Intelligence XI, Web Intelligence, Crystal Report 9/10/ XI/ 2008, Xcelsius 4.5/2008, Info view, Full Client, Business View Manager, Live Office.

Data Warehousing and ETL: Universe Design, Fact and Dimension Table Design, TOAD, Data mart, Crystal Reports Enterprise 4.0, Data modeling.

Database: Oracle (8i/9i/10g/11g), Oracle EBS, SQL Server 2000/2005/2008 , MS Access (2000/2002), MySQL.

Languages: C, C++, SQL, PL/ SQL.T - SQL, Java.

Operating System: Windows (all flavors), UNIX.

Packages: MSOffice.

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

Crystal Report Developer, PL/SQL

Responsibilities:

• Created Technical Design Documents, Report Specification Document and Data Mapping Documents for the reports.
• Designed, developed, tested and supported reports in Crystal Reports 2008.
• Designed and developed Crystal reports based on design specification and the prototype of the report.
• Extensively wrote PL/SQL statements to write complex queries and wrote Packages, Stored Procedures, views, custom functions.
• Created Drill down, Drill through, Parameterized, Cross Tab and on-demand reports for various business needs.
• Created user Prompts, conditions and filters for various reports to specify the reporting parameters as per Business requirement.
• Scheduled Reports for different schedule based events, distributed in email, PDF and HTML formats.
• Performed Unit Testing, Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts.
• Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks.
• Packages are created in PL/SQL and imported into the Crystal reports.
• Used Java SDK for embedding reports created in crystal reports into front end application.
• Exported Reports to enterprise once they are created.
• Used Clear Case and Clear Quest for files storing or tracking and ticketing system respectively.
• Interacted with the end users and provided Production Support.

Environment: Crystal Reports 2008, CMC, Oracle 11g, SQL Server 2008, Clear Case and Clear Quest.

Confidential, Fitchburg, MA

Crystal Report Writer/ Developer

Responsibilities:

• Worked on Crystal Reports 2011/2008.
• Designed and developed Crystal Reports, which included standard reports, cross-tab, summary reports.
• Banner data base is used where banner tables and views are stored from which banner forms and crystal reports are developed.
• Raiser’s edge application is used in order to develop a specific kind of reports on gifts records, Constituent records, campaign, and fund records.
• Validated the Crystal Report by writing queries against the transactional system.
• Customized the formatting of the Crystal Report using formula's at the section level.
• Created work around in Crystal Reports for issues such as, subreport within a subreport, passing parameters from main report to subreport, not allowing the use of multi-value or date range parameters.
• Usage of OLE object on reports to display pictures of students, staff and etc., which are located in ALBATROSS and linked to the database using path of the file.
• Developed Crystal reports for standard reporting purposes using COMMAND object, Sub reports,dynamic prompts with LOV’s built of business view manager.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for user.
• Worked extensively with functions of crystal reports likeRunning totals, highlight expert.
• Modify the existing reports by adding new logic and deleting existing logic as the line of user requirement.
• Developed various charts and graphs like Bar chart (side by side, stacked), line graphs, pie charts etc by using chart expert utility of Crystal reports.
• Responsible for creating the complex Crystal reports (On demand, AdHoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging report etc.)
• Implemented Security features like row level, object level security to make the data secure.
• Provided the security access management by creating users/groups and folders.
• Scheduling reports on weekly and monthly bases.
• Generated Reports based on time like Year, Quarter, Month, Week based on Geographic andcomparative reports, label reports, letter reports.
• Maintenance of Raiser’s edge information.
• Involved in Business Objects Production Support resolving the tickets, Trouble shooting and developing End user Notes.

Environment: Crystal Reports 2008, CMC, Raiser’s edge application, Banner software, Translation management tool, Oracle 10g/11g, SQL Server 2008.

Confidential, Phoenix, AZ

Crystal report Developer/Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the system for Business Objects Universes and Reports.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Created new Universes on Business ObjectsXI 3.1.
• Build Crystal reports and related SQL queries that are consistent with the objective of stated reporting or data analysis goals.
• Applied User and Group Restrictions in selected objects in universe level.
• Designed and created reports based on technical specifications provided.
• Created Crystal Reports with ole object extracting image file from the database and URL links.
• Created custom formulas to display specific format or to display correct information on crystal reports.
• Created reports with dynamic grouping based on parameters.
• Mapped data between Crystal Reports, Data Marts and the Enterprise Data Warehouse.
• Prepared time estimates for all Crystal reports developed.
• Extensive use of hierarchical drill down on different section levels.
• Created Views, Queries and tables to create the reports.
• Worked on complex Crystal report formatting patterns which involved sub reports, hierarchical grouping, calculations, and OLE objects usage and cross - tab usage.
• Created reports which have multiple sub reports inside the main report.
• Exported pictures from a flat file on to the crystal report using OLE object.
• Extensive use of running totals and parameters to calculate the annual budgets for each region
• Supported, modified and maintained Crystal reports that are currently in production.
• Some of the reports are created using free hand SQL and universe objects.
• Worked on cross-tab and master detail reports and represented the same using charts/ bar charts/ pie charts.
• Developed Drill Downs report using Graphs in Crystal.
• Used Mailing label report template for developing mailing labels for customers on monthly bases.
• Customized Dashboards with various metrics and Analytics and by defining goals and metric trends.
• Developed universe user documentation guide for the end users reference. Provided training for end users for generating their own report including complicated report.
• Created Executive Summary report which contains summary ofall reports (CEO Briefing book).
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Test the new SQL routines, validation routines per requirements.

Environment: SAP BO/BW, Business objects XI 3.1, Info View, Designer, Crystal reports, Window Server 2008, Live Office, Oracle, 11/10g, MS SQL Server 2008, Toad.

Confidential, San Francisco, CA

Business Objects Consultant

Responsibilities:

• Responsible for managing the Business Objects reporting environment including report specification, creation and development (report, template, Universes creation), production maintenance, distribution strategy.
• Worked on migration of BO version XIR2 to 3.0 providing all groundwork including installation and upgrade.
• Created initial Classes & Objects for Universes in both on/off line modes.
• Designed and built universes.
• Created hierarchy and conditions in the universes.
• Designed, implemented and deployed Business Objects Universes.
• Developed Crystal Reports from SAP BW (Business Warehouse).
• Worked on universe performance issues, resolving loops and traps.
• Created Aggregate Tables wherever necessary.
• Created classes, objects, Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving loops and checked the Integrity of the Universes.
• Designed and developed Web Intelligence reports.
• Created critical visualization using Business Objects Xcelsius 2008 for the Business Dashboard.
• Created Excel-based interactive visual analytics, dynamic charts and groups and business presentations with Crystal and Xcelsius.
• Delivered reporting content utilizing SSRS and SSAS.
• Created links in BO reports to link summary and detail reports using open document syntax.
• Conducted periodic user training for business users on slicing and dicing of power cubes, drill down techniques for extensive usage of the reports.
• Used Xcelsius 2008 as a Data Visualization Tool to transform some Microsoft Excel spreadsheet data into visuals such as Pie-Charts, Bar Graphs, Scorecards that can be shared via PowerPoint and PDF files.
• Created numerous reports in Business Objects, Created some reports by hard coding the query (SQL) in the tool.
• Improved the performance of the mappings using various optimization techniques.

Environment: Business Objects XIR3, SAP BW, Desk Top Intelligence,Web Intelligence, Info view, DeskI, Crystal Reports, Xcelsius, MS SQL Server 2008, SSRS Reporting, Report Conversion Tool, Oracle 10g, PL/SQL, TOAD, UNIX.

Confidential, Plano, TX

Business Objects Developer

Responsibilities:

• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Involved in creating Users, User Groups and assigned privileges to the users using CMC.
• Created Classes and Objects taking the information from the database. Also created measured objects.
• Linked Universes to share the Universes which had common dimension tables, classes and objects.
• Used derived tables to create the universe for best performance, and use context and alias tables to solve the loops and traps in the Universe.
• Responsible for creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes, views to increase the performance of the universe.
• Created Complex reports using User defined functions like @prompt, variable, condition objects and Aggregate awareness functions for SQL Enhancement.
• Linked universe based on Master/Kernel approach.
• Created various reports using Business Objects functionalities like Sub-Queries, Slice and Dice, Drill Down, Functions, Cross Tab and Formula's.
• Embedded Webi reports in to Microsoft Excel using Live Office.
• Mapped actual LOV data to more user-friendly labels that are displayed in the prompt LOV.
• Create reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
• Scheduled recurring daily, weekly and monthly reports (Webi and Deski) in CMC and used Calendar based scheduling for the reports custom dates.
• Developed ad-hoc as well as scheduled reports. Developed reports in different formats like Cross-tab, Section, List Reports, and Drill through reports. Report Performance optimization and tuning enhancements. Introduced @Aggregate Awareness functionality in the universe.
• Developed application modifications/enhancements to meet established requirements and specifications.
• Migrated Reports and Universes from Version XIR2 to Business Objects XI 3.1.
• Developed training material and Mentored employees on the Business Objects XI R2 suite of products.

Environment: BusinessObjects XI R2/3.1, Desktop Intelligence, WebI, MS SQL Server 2008, Oracle 10g/9i, PL/SQL.

Confidential, Alpharetta, GA

Business Objects Developer

Responsibilities:

• Designed, implemented and deployed some highly complex Business Objects Universes.
• Migrated universes and reports to PROD, SYS and DEV environments from BO 6.5 to BOXIR2 version to their respective domains.
• Involved in Analysis, Development, Testing, and Maintenance and Resolved problems during Migration.
• Worked on universe performance issues, rectifying loops and in correct joins.
• Created classes, objects, Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving Loops and checked the Integrity of the Universes.
• The scope of the reporting systems included manufacturing materials management, finance and cost accounting.
• Optimized and Tuned Reports performance by Analyzing tables, Checking Optimizer Modes and Partitioned tables.
• Used SQL Query’s to generate business objects reports using free hand SQL as a data provider.
• Involved in QA phase to test the Classes, Objects and Reports.
• Complex Reports using Drill down, Cross tab and Charts (time series graphs, column, line, pie). Used the drill functionality, ranking, sorting, complex alert and complex variables in full client reports.

Environment: Business Objects XI R2/6.5,Desktop Intelligence, Oracle 9i,UNIX.

Confidential

BOBJ Developer

Responsibilities:

• Created and managed users and their groups for different areas, repositories, and documents through Supervisor module.
• Created & Modified Universes for various functional areas of high level reports group using Designer.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Resolved loops in Universes using table aliases and contexts to remove cyclic dependencies.
• Created Derived Tables in the Universe to meet the Reporting Requirements.
• Designed complex report using Web Intelligence with several variables.
• Joined multi data providers using merge dimension option of web intelligence.
• Created complex prompts to enhance universe capabilities and make usage of the universe extremely easy.
• Developed cascaded prompts using List of value.
• Various Programming tasks included developing Reports using free hand PL-SQL, and T-SQL procedures.

Environment: Business Objects (Designer, Reporter) 6.1, Supervisor, Oracle 9i, PL/SQL, T-SQL.