SUMMARY

• Over 8 years of IT experience in design and development of Business Intelligence applications using TIBCO Spotfire Professional, Business Objects XI 3.1/R2, Crystal Reporting 2008.
• Developed Dashboards with multiple Data Sources (Excel, TXT, MS Access, Oracle, SAS) Using TIBCO Spotfire Professional.
• Created Reports Master Detail, Cross Tables, Charts (Line, Bar, Combination) Using Business Objects, TIBCO Spotfire.
• Expertise in complete Life Cycle Development Process of a reporting solution that involved Gathering Business Requirements, Analyzing Business Needs, Documenting Business Information.
• Good at Universe Designing, Developing, Maintaining and Resolving loops, Chasam trap, Fan trap using Alias, Context. And also creating classes & objects (Dimensional, Detail, and Measure), defining Joins & Cardinalities and testing with Check Integrity.
• Worked using various data providers like Universes, Personal Data Files, Stored Procedures and Freehand SQL to generate reports.
• Good at Data source setup on the development server machine to make all sources available for the reporting purpose.
• Used calculated columns, Custom expressions, Action controls, Property controls in the Spotfire Reporting to provide the best solution to the business.
• Expert in using information designer to create the Data Elements and Information links.
• Created two different information links and combined at the report level using External Column Option to get the combined data in a single visualization.
• Created custom data elements and free hand SQL with in the information links.
• Created complex statistical and financial reports, trend over time reports, ranking, and forecast reports, executive Dashboards using Tibco Spotfire and Business Objects.
• Experienced in creating Repositories, Folders, Groups, Users, assigning privileges to users and maintaining the Repository.
• Generated complex reports by linking data from multiple sources using functionalities such as Combined Queries, Master Detailed, Slice and Dice, Drilling methodology, Scope of Analysis, Merge, Filters, Ranking, Sections, Graphs and Breaks.
• Worked on developing reports using Crystal Reports 2008 using Business Views and Universes as data providers.
• Worked extensively on system upgrades, data analysis, data migration, business automations, performance tuning and production support.
• Trained users in report development and running ad-hoc queries in Business Objects.
• Expert in planning, designing, developing, modifying, updating, maintaining and distributing Universes and Reports.
• Worked with the defect tracking tool Clear Quest to track the testing process.
• Understanding complex SQL queries and Good at writing SQL quires.
• Able to work on own initiative or as part of a team, backed by excellent organizational and communication skills along with the capability to solve problems as they arise.

Report/OLAP/DSS Tools: TIBCO Spotfire 6.5/5.0.1/4.0 , Business Objects XI 3.1(R3.1)/R2/R1, Designer, Desktop Intelligence, Web intelligence, Webi Rich client, Crystal Reporting 2008

Data Modeling/Oracle Utilities: TOAD, Teradata SQL Assistance

Databases: Teradata 13/12, Oracle 10g, Sybase, SQL Server 2000/2005 and MS Access

Software Applications: MS Office

Markup Languages: HTML, DHTML, XML

Operating Systems: Windows XP/2003/2000/NT/98

Languages: C, C++, SQL, PL/SQL

Confidential, NY

Spotfire Developer

Responsibilities:

• Developed complex Spotfire workbooks from scratch based on client needs and providing Detail-On-Demand.
• Loading the data into database tables into the development environment to test the report functionality.
• Good at the using Cross tables, Charts(Pie Chart, Tree Map, Heat Map, Bar Chart, Line Chart), Calculated Columns, Creating Hierarchies, Bookmarks and complex reports with multiple filters with Spotfire Professional
• Creating cross table using multiple data tables with in the text area using HTML code and implementing java script to include the calendar icon and make synchronizing with the property control.
• Developed the Alert status dashboard which gives the number of alerts generated per that day and which status is the alert in and gives the all the detailed information about that alert.
• Created Information links and data elements using Sybase, Oracle data base and free hand SQL. Created the complex information links and filters and loading data as On-Demand.
• Used function External Column option to join two information links and creating a combined data table.
• Accessing reports using Web player and modifying changes that needs to be changed with in the professional.
• Testing the data by executing the SQL statements and within the database and documenting the test results.
• Adding On-Demand data table to improve the performance, Created Materialized views for improve the performance of the reports.
• Good at using OVER functions, Date functions within the calculated columns and custom expressions. Created raking on a column based on the statistical value of that column.
• Created custom expressions, calculated columns, Action controls and property controls.
• Maintaining the data source folders and report folders using the tool option library administrator. Good at creating data modeling and data elements.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting Spotfire and Business Objects.
• Creating Webi Report using functionalities like sorting, filtering.
• Testing the Business Object Reports and Spotfire reports, validating data from the report and database and updating testing document.

Environment: TIBCO Spotfire 6.5/5.0, Spotfire Web Player, Business Objects XI3.1, Oracle 10g, Sybase, TOAD for Sybase and TOAD.

Confidential, TX

Spotfire Developer

Responsibilities:

• Involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Created complex Spotfire workbooks (DXP) from scratch based on client needs and providing Detail-On-Demand.
• Designing reports Cross tables, Charts, Calculated Columns, Creating Hierarchies, Bookmarks and complex reports with multiple filters with Spotfire Professional
• Used different visualizations like Bar chart, line chart, and Combination chart.
• Created Information links using SAS Data sets, Oracle data base and free hand SQL.
• Used function External Column option to join two information links and creating a combined data table.
• Using Web player to check the report is accessible through it with out having any formatting issues.
• Creating the report as a Power point presentation copy and sending to the Business users to use in their presentations with the clients.
• Adding On-Demand data table to improve the performance, Created Materialized views for improve the performance of the reports.
• Developing the reports using Tableau connecting to the data source Excel files, Oracle data bases.
• Good at using OVER functions, Date functions with in the calculated columns and custom expressions. Created raking on a column based on the statistical value of that column.
• Created custom expressions, calculated columns, Action controls and property controls.
• Worked with end users to explain TIBCO Spotfire workbooks, creating ad-hoc reports.
• Also involved in converting the Tableau and Business Objects reports to Spotfire Dashboards.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts/Filters.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting Spotfire and Business Objects.
• Creating Deski Report using functionalities like sorting, filtering.
• Unit Testing the Business Objects Reports and Spotfire reports and updating unit testing document.

Environment: TIBCO Spotfire 5.0.1, Spotfire Web Player, Tableau 8.2, Business Objects XI 3.1/R2, Oracle 10g, TOAD, SQL Server 2008, SAS.

Confidential, New Berlin, WI

Spotfire Developer

Confidential is the top shipping company providing different services. Confidential provides services in All over USA and also do International shipping to some other countries. This Project involves in the design, development and maintenance of Spotfire Dashboards.

Responsibilities:

• Involved in the complete lifecycle of IMPB, Revenue recovery projects within the Confidential, involved in different phases of the project like Requirements gathering from Business users, participated in project sessions with the Project core Team.
• Analyzing the requirements from SRS and BRS documents.
• Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end user use
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports Using Business Objects, TIBCO Spotfire.
• Loading data into Spotfire and checking the data loaded properly.
• Designing reports Cross tables, Charts, Calculated Columns, Creating Hierarchies and complex reports with multiple filters with Spotfire Professional.
• Working with Information links and creating data elements with the help of Information designer.
• Created Business objects Webi reports used various techniques like Sectioning, Breaks, Ranking, Filtering, and Scope of Analysis to develop the reports.
• Developed Spotfire Dashboards / Reports Using Action Control, Property Control to navigate from one page to another page and also to access data dynamically.
• Created customized reports using complex SQL queries, Created Database connections and Spotfire Dashboard file (DXP) in Spotfire server.
• Creating the Solution specification documentation for the reference purpose.
• Delivered the adhoc reports using different data sources like Excel, TXT, SAS data sets provided by the business users.
• Involved in Developing, and Deployment of Spotfire dashboards on the server.
• Providing the maintenance and assistance to the users and fixing the production issues.
• Did basic unit testing for reports before going to the testing.

Environment: TIBCO Spotfire 4.0/3.0, Business Objects XI 3.1/R2, Teradata 12/13, Oracle 10g, Toad, Teradata SQL assistance.

Confidential, Houston, TX

Senior Business Objects Developer

Confidential is one of the largest companies in selling, marketing and distributing their food products to different facilities like Education institutes, Hospitals and Restaurants. This Project involves the design, development and maintenance of Spotfire Dashboards for their sales and financials.

Responsibilities:

• Involved in requirement gathering from the business users and their specifications. Analyze the requirements and planning development phases.
• Interacted with Business users to develop reports as their requirements.
• According to the user specifications designed and developed the Spotfire DXP file and used different visualizations Bar chart, Combined chart to represent the data.
• Providing the different set of filters that the users can limit the data and can interact with the visualizations and see the performance of the business.
• Created the information links based on the oracle data base. Created joins between the tables.
• Created Conditions, Filters at query level and also at report level.
• Generated Reports from Scratch, Cross-tab crystal reports, creating Parameters, Formulas.
• Created complex reports on the web using Web Intelligence and distributed them to different users through Info view portals.
• Extensively used Calculated columns and Property control to develop the reports. Used OVER, Date and Ranking functionalities to develop advanced Spotfire Reports.
• Creating Sub reports in crystal Reporting and linking sub report to main report.
• Experience in managing and making changes to the Existing Reports and changes in Universes to satisfy Users requirements.
• Creating User/group security, application security, data row level security, scheduling and distribution strategies

Environment: Spotfire Professional 3.0, Business Objects XI 3.1, Web Intelligence Rich Client, Crystal Reports XI, Oracle 10g.

Confidential, Pittsburgh, PA

Senior Business Objects Developer

The project aimed at building an ad-hoc reporting system that would allow analysts and executives run queries across every component of the warehouse via intranet. Several Universes and reports were built to address complex reporting across different divisions of company like health insurance, hospitals.

Responsibilities:

• Gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designed, Developed Universes by defining joins cardinalities between tables applying contexts and alias tables to resolve loops.
• Defined and Created Hierarchies as per the business rule for the reports to be viewed at selected reporting level.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Created different types of reports such as Master/detail, Cross Tab and Charts.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Used Alerts to draw attention to a particular block of data by highlighting it.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used multi dimensional analysis (Like Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
• Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Generated several Templates in both DeskI/WebI.
• Generated complex reports like Inventory, Buyers, Excess Materials, Products sales, revenues, regions wise demand and exported them to the corporate repository.
• Exported reports into XL, PDF, CSV and XML formats as per the client requirement.
• Used Scheduler for scheduling and distributing the documents.
• Documented parameters, fields, and logic used for developing of reports and universe.
• Designed crystal reports for daily and monthly reports, product list, and sales transactions.
• Preparation of critical, Master Detail, Sub Reports, Cross Tab and Summary reports using Crystal Reports.
• Used features such as functions, running totals, and parameters, conditional formats to develop highly formatted Crystal Reports.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Used Xcelcius for presenting dashboards to End users.
• Migrated Business Objects 6.5 content (users/user groups, Universes, reports) in to Business Objects XI R2 environment using the Import Wizard.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.
• Interacted with users to know their approach and assist in developing and modifying Reports accordingly.

Environment: Business Objects XIR2 (DeskI, WebI), Tibco Spotfire 3.0, Crystal Reports XI, SQL server 2005.

Confidential, Silver Spring, MD

Business Objects Developer

Responsibilities:

• Interacted with business users, managers to gather requirements and develop universes and reports per requirements.
• Worked with linked and derived universes and resolved the loops in the resulting universes.
• Created cardinalities, contexts, joins and aliases for resolving loops and checked the integrity of the universes.
• Exported the universes to the repository to make resources available to the users with Oracle backend.
• Set up groups and users for Business Objects deployment. Managed user profiles using Supervisor. Created user objects, predefined conditions and prompts for dynamic user selection
• Automated document Scheduling, Publishing and Distribution for WebI and Infoview clients, using the Broadcast Agent Server
• Worked extensively on different types of Transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Update Strategy, Lookup, Stored Procedures, Sequence Generator, Normalizer and Joiner to design new mappings
• Worked on Crystal reports 2008 for advanced functionalities which are not available within in WEBI
• Implemented Aggregate Awareness functionality in universes.
• Setup hierarchies for multi-dimensional analysis in the universe. Implemented Drill Down and Open Document functionality in Desk I reports.
• Tested new and modified reports with different test cases and verified data against GUI application before sending reports for user acceptance testing.
• Worked with the database administrator to create aggregate tables, indexes to speed up query time.
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports to provide a transformational approach to the way staff members and clinicians access and report on data
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Scheduled reports to business users and owners using Broadcast Agent.
• Created reports in WebI from multiple data providers and synchronized the data using the merge dimensions feature.
• Created Universes by defining connections and retrieving data from database.

Environment: Business Objects XI R2(CMS, CCM, Desk I, Supervisor, Import Wizard, Performance Manager, Report Conversion Tool), Crystal Reports XI R2, Web Intelligence 6x, Info View, Informatica, Windows XP, UNIX, Oracle 9i, PL/SQL, SQL

Confidential

Business Objects Developer

Confidential is a pharmaceutical company, which basically deals with manufacturing and marketing bulk drugs. This project is for the marketing department where the primary task is to create reports. The project focuses on analyzing the data, designing, building reports in the User Module. Reports included analyzing and producing results for North American vendors.

Responsibilities:

• Created different types of reports such as Master/detail, Cross Tab and Charts.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used various techniques like Sectioning, Breaks, Ranking, Filtering, and Scope of Analysis to develop the reports.
• Created required predefined prompts, prompt filters at the universe level to increase the performance.
• Developed the reports using functionalities like Alerts, Ranking, Sectioning, Grouping, Created variables to do some complex calculations within the report.
• Exported reports into XL, PDF, CSV and XML formats as per the client requirement.
• Maintained and Modified existing reports according to needs of users.

Environment: Business Objects XI R2, PL/SQL, Oracle 9i, Windows 2003.