SUMMARY

• 8+ years of experience in the total life cycle of Software products including requirements analysis, solution architecture, solution design, implementation, integration, testing and maintenance.
• Expertise in Development support solutions for Business Objects 4.0/XI 3.1/XI R2/R1/6.x, Central Configuration Manager (CCM), Central Management Console (CMC), Crystal Xcelsius, Query as a Web Service(QaaWS), Crystal Reports 2008/XI R2/XI/9.0 and Live Office.
• Experience in gathering, analyzing and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Experienced in developing Desktop Intelligence, Web Intelligence and Crystal Reports using different data sources.
• Expertise in designing Universes for Ad - hoc query, canned reporting and analysis using the Universe Designer Tool (UDT)/Information Design Tool (IDT).
• Created Universes using various Database sources including Oracle (10g, 9i & 8.x), MS SQL Server … DB2 … AS400 DB2, Teradata, Sybase and SAS.
• Experience in building dashboards using Dashboards 4.0/Xcelsius … using QaaWS, Live Office and Excel XML Maps connections.
• Expertise in using Crystal Xcelsius to create user appealing Dashboard reports.
• Experience in building queries using SAP BEX Query Designer.
• Experienced in setting up of Repository, creating, managing users and user groups.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports.
• Expertise in writing and implementation of the Packages, Triggers, Stored Procedures, Functions, views, Materialized Views, indexes at Database level and Form level using PL/SQL and T-SQL.
• Hands on experience in Data Modeling using Erwin tool and implementing Star Schema and Snowflake Schema for various Dimensional Modeling and Data Marts.
• Strong experience in Business Intelligence area with Crystal Reports/ Crystal Enterprise suite.
• Installed Crystal Enterprise and published reports on Enterprise Server and got involved in Crystal Enterprise Administration.
• Good working knowledge of OLAP for building enterprise reports.
• Unique ability to understand long-term project development issues at all levels.
• Excellent Interpersonal, Written and Oral communication skills, Fast Learner and Self Motivated.
• Experienced in Production Support role 24/7 to resolve the issues.

TECHNICAL SKILLS:

Data Warehousing / OLAP / BI Tools: Business Objects 4.0/XI 3.1/XI R2/R1/6.x (Central Management Console, Central Configuration Manager, Central Management Server, DeskI, Import Wizard, WebI, IDT, Designer, Info View, Performance Manager, Dashboard Manager), Business Objects Data Integrator, Business Objects 6.5 (Reporter, Designer, Supervisor), Broadcast Agent (Document Agent/Publisher), WebI X1 3.1/XI R2/R1, Crystal Xcelsius … Crystal Reports XI … Liveoffice. Administration Business Objects

Databases: Oracle … MS SQL Server … MySQL 5.1, IBM DB2 … MS Access.

Operating System: Windows … Windows 2003, Solaris 10, UNIX

Version Control & Others: Sub Version, Microsoft Excel, TOAD, SQL Navigator, Erwin

WORK EXPERIENCE

Sr. Business Objects Developer

Confidential - Rochester, MN

Responsibilities:

• Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Involved in interacting with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Gathered and captured all existing Customization/enhancements in available BO system. Involved in preparation of BRD (Business requirement document) and GAP analysis in order to include each and every enhancement during Upgrade. Understand the business data flow.
• Responsible for Designing and building Universes using Universe Design Tool (UDT).
• Resolved Loops, Chasm and Fan Traps using Contexts and aliases in Universe Designer.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Created Web Intelligence Reports with different functionalities like cascading prompts, drilldown, charts, graphs, ranking, Scope of Analysis and alerts.
• Created parameterized Crystal Reports and customize existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, used Crystal syntax to create formulas for the reports.
• Created Ad-hoc reports using BO functionalities like Master Detail, Formulas, Breaks, Calculations, Alerts, Slice and Dice, DrillDown and @Functions.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Created Explorer Information Spaces for Sales and finance metrics.
• Built Dashboards with high variation of data using Live Office, QAAWS and BI Web Services.
• Implemented security features of Business Objects like row level, object level and report level to make the data secure.
• Developed BEx Queries for reporting on InfoCubes, InfoSets and Multi Provider by defining Structures, Variables, Formulas, Exceptions, Selections, Navigational Attributes, conditions providing drill down functionality in reporting.
• Extensively worked on Query building, filtering, Restricted Key figures, variables and query variants using BEx Analyzer.
• Created virtual key figures and calculated Key figures to satisfy the reporting requirements.
• Involved in displaying data from legacy systems and relational databases and in creating, modifying reports using tables, views, functions and stored procedures.
• Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: Business Object 4.1, Xcelsius, Dashboards, Crystal Reports 2011,Designer, Web Intelligence, CMC, DB2, SQL, PL/SQL, SQL Server 2008, Teradata, TOAD, Erwin 6.1

Business Object Developer/Crystal Reports Developer

Confidential - Philadelphia, PA

Responsibilities:

• Worked as a Business Analyst for requirement gathering for business and functional reporting.
• Work included Universe Designing, Requirement Gathering, Setting up Joins, Cardinalities, and Solving Traps using Contexts and Aliases and Updating Universes based on additional Requirements etc. Using Designer.
• Developed Crystal Reports from SAP BW (Business Warehouse)
• Created Crystal Reports with ole object extracting image file from the database and URL links.
• Created custom formulas to display RGB colors in crystal reports.
• Customized the formatting of the Crystal Report using formula's at the section level.
• Created formula's for Crystal Reports 2008 and stored it on the Crystal Repository to be used across the organization. Created reports with dynamic grouping based on parameters.
• Designed logic for Xcelsius 2008, Dashboard in Microsoft Excel for Data Visualization.
• Involved in using Job Server in creation of real time jobs. And also involved in Performance tuning at source, transformation, and target levels.
• Creation of ETL Processes for the added new Subject areas, Develop Data Extraction, Transformation and Loading Program using Data Integrator.
• Involved in Creation of jobs that specify data mappings and transformations by using Data Integrator Designer.
• Used Data Integrator to load data from different sources (SQL, Text files) to the target database.
• Performed Unit, System and Regression testing of the Business Objects Data Integrator ETL jobs
• Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into staging area
• Involved in designing, developing and performance tuning Micro Strategy reports and documents.
• Created Jobs, Workflows, Transformations and Data Flows according to requirement to integrate source data in to Target data warehouse.
• Analyzed various Data Warehouse Models like slowly changing models, Conceptual Models, Logical Models. Also Designed and developed Data Integrator scripts for data transformation.
• Extracted data source for cube from SAP transactional system and flat files.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc. by using Chart expert of Crystal Reports.
• Used and monitored Info View, CMC and also assigned Roles, and set User Groups and rules and according principles and also monitored security and other CMC controlled functions.
• Developed Drill Downs report using Graphs in Crystal Reports 2008.

Environment: Windows Server 2000/2003/XP, Universe Designer, Crystal Reports 2008, Data Integrator, Xcelsius 2008, WEBI, Info View, SAP BW, CMC, Oracle 10g, DB2, SQL Server 2005.

Business Object Developer

Confidential - Atlanta, GA

Responsibilities:

• Collected requirements from business and functional user and transformed into design specification for other developers in the team.
• Developed Existing Universes and added additional Links, Joins according to the requirement and sorted Loops, Traps.
• Created Views, Stored Procedures, Queries and tables to create the reports.
• Team lead for crystal development with responsibilities to set up the Crystal Server, Info view, reporting structure, role and rights.
• Developed new reports using Crystal Reports XI and Oracle 10g as database.
• Developed reports out of legacy database such as Microsoft Access.
• Developed reports by joining more than one database such as SQL server, Oracle database.
• Created dynamic and static parameter based report and scheduled it on the Crystal Server.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc. by using Chart expert of Crystal Reports XI.
• Created company specific formula and used Crystal repository to store generalized formulas for reusability. Also Used Stored Procedure to generate reports.
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports version XI.
• Used Data Integrator in ETL activities.
• Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.
• Involved in migration of Business Objects Documents to Micro Strategy Documents.
• Creation of different data stores to get SAP tables, Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into oracle staging area. Performed Unit, System and Regression testing of the Business Objects Data Integrator ETL jobs.
• Created On-Demand Sub reports and Hierarchical Grouping.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for user.
• Passed parameters dynamically to Crystal Report in .net application at runtime.
• Developed Drill Downs report using Graphs in Crystal.
• Trained all the Users of the Reports on using Info view and exporting reports to various formats.
• Tested the reports in for quality and end user validation to match the amount and quantities figures against the transactional system.
• Developed Crystal OLAP reports using Microsoft Analysis service as the Data Warehouse.
• Developed Dashboards using Crystal Xcelsius.

Environment: Windows Server 2000/2003/XP, Data Integrator, Designer, Crystal Xcelsius, Crystal XI, Data Integrator, WEBI, Oracle 10g, Micro Strategy, SQL Server 2005, Microsoft Access.

Business Objects Consultant

Confidential, Parsippany, NJ

Responsibilities:

• Designed and developed the Universes. Designed a Visual Basic script in the DEA Universe, which allowed user to enter the Report Start and End Dates.
• Enhanced Business Objects Reporting (Comprehensive Universe), Secure Integrated Data Reporting (For development of WebI), and Involved in the Creation of dynamic security tables and Maintained User profiles and security levels using Business Objects Supervisor.
• Created adhoc and production Reports for both domestic and global use.
• Met regularly with users to gather business requirements and review universes for changes and enhancements.
• Created and published the reports on Webi 2.5 to make them accessible through the corporate Intranet.
• Involved in Installation of Business Objects Desktop Products including Business Objects and ZABO.

Environment: Business Objects 5.1.5, Web Intelligence 2.6, ZABO, Webi SDK, JSP Windows NT, Sun Solaris Unix 4.0, Sybase 12.0 on Unix Server, SQL Server 2000, VBA, Macros, Erwin.