SUMMARY

• Over 8 years of Business Intelligence solutions with experience in all stages of software application development life cycle.
• Strong experience in Developing BI reporting applications using Business Objects, Crystal Reports.
• Good Knowledge in Data Warehouse and Transactional database design and development, Data modeling, Business Intelligence Concepts.
• Expertise in OLAP/OLTP system study, analysis of database schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling
• Expertise in gathering business requirements and preparation documents such as of Business Requirements Documents (BRD), Functional Specification Documents (FSD), Meta Data document, Report Requirement Document, Project Specification Document, Technical Specification Document, and Requirements Traceability Matrix.
• Expertise in all modules of Business Objects suite (XI R3, XIR2, 6.x and 5.x) with experience in Central Configuration Manager (CCM), Central Management Server (CMS), Central Management Console (CMC), Desktop Intelligence, Import Wizard, Publishing Wizard, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View and Crystal Reports.
• Involved in Migration of Business Objects 6.5 content in to Business Objects XIR2/R3 environment.
• Expertise in resolving Join path problems like Loops and Traps in the Universes using Aliases and Contexts.
• Experience in Creating Repositories, Folders, Groups, Users, Assigning privileges to users and maintaining the Repository.
• Extensively used Business Objects Reporting functionalities such as Aliases, Context, Slice and dice, Drilling Methodology, Filters, Sorts, Ranking Sections, Graphs, Query Prompts and Breaks.
• Experienced in developing Dashboards using Xcelsius& Dashboard manager.
• Extensively worked on Query As A Web Service (WSDL’s) while getting the query data from Business Objects Enterprise to Xcelsius 2008 / 4.5 .
• Involved in Scheduling and publishing reports in Crystal Enterprise Environment/ Business Objects Enterprise XI R2 Environment.
• Good working knowledge of implementing object and row level security in Business Objects XIR2/XIR3.
• Specialized in creating complex query reports using Oracle, SQL Server, Teradata, DB2, MS Access, MS Excel, XML and various RDB.
• Extensive experience in working on both UNIX and Windows environments.
• Experience in Unit testing which included data validation using SQL scripts, data integrity, functional testing, integration testing, regression testing and system testing, post production support.
• Exposure to Data Modeling, Normalization, and Business process Analysis, Reengineering and Logical & Physical database designs.
• Experienced in working with Business Managers, Analysts, End users and all the stake holders in documenting requirements, providing estimates, creating High and Detail Level design specifications.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals/teams at all levels.

TECHNICAL SKILLS

OLAP Tools: Business Objects 6.5/XIR1/ R2/ R3/ R3.1( Business Objects Designer, Desktop Intelligence, Web Intelligence, WebI Rich Client, Universe Builder, Voyager, Central Management Console, InfoView), Xcelsius 4.5/2008 (Live Office, QAAWS), Crystal Reports 9/10/XI/2008, SQL Server Reporting Services 2005/2008.

ETL Tools: BusinessObjects Data Integrator, SAP BW 3.5/BI7, InformaticaPowercenter.

Programming Languages: PL/SQL, Transact - SQL, Unix Shell Scripting, Java, J2EE, Advanced C, C++, C# .NET, VB .NET, and ASP.NET.

Databases: Oracle 8/8i/9i/10g/11g, SQL Server 2000/2005/2008 , Teradata V2R5/V2R6/12, MS Access, MS Excel.

Database Tools: PL/SQL Developer, Toad, SQL*Plus, SQL*Loader, PL Edit, SQL Server Management Studio.

Web Technologies: XML, XSLT, VBScript, Java Script,.NET Framework, HTML, DHTML.

Operating Systems: Windows NT, Windows 95/98/2000/XP, Linux, IBM AIX, Unix.

PROFESSIONAL EXPERIENCE

Confidential, Mclean, VA

Business Objects Consultant

Responsibilities:

• Gathered requirements from Business Managers and prepared Business Requirements Documents & Technical specification document out of it.
• Created new classes and objects in Universe Designer and made structural changes to the existing universe to include new objects by updating tables and joins. Also handled testing and debugging of Universes after enhancements and modifications were made.
• Resolved join problems such as Loops, Chasm and Fan traps by creating Aliases, Contexts and used the features available in the Designer to separate queries on measures.
• Responsible for BO reports upgrade from Version 6.5/XIR2 to XIR3.1.
• Created and deployed WEBI Reports through Info View.
• Generated Custom LOV’s (List of Values) and Custom Hierarchies for drilling down Reports which allows the users to analyze the data.
• Created Master detail, Charts and Cross-tabs reports to view data in an analyzed way by using WebI and DeskI.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, complex Calculations, and Filters, Sorts, query prompts, opendoc calls and cascading prompts.
• Created Users and moved those to Groups and set privileges on BO Enterprise Central Management Console.
• Published Reports on to BO Enterprise CMC and scheduled those as per the Business Requirements and set the distribution method.
• Developed a Windows application in order call the reports onto Windows form using Crystal Viewer.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, Functions and Formulas, Filters &Alerters for creating Complex reports.
• Develop customer facing Dashboards/Reports using Xcelsius.
• Created and Customized Application Dashboards using Xcelsius to meet the requirements of higher level analysis and Maintained the consistency among the Xcelsius dashboards.
• Created Various Analytical, operational, what-if model dashboards using Qaaws and Live office.
• Created various Views and Stored procedures using PL/SQL for Crystal Reports.
• Used Performance optimization techniques while writing PL/SQL code.

Environment: Business Objects XIR3/XIR2 (CCM, CMC, Designer, Desktop intelligence, Web Intelligence, Rich Client, Info View, Import Wizard, Report conversion tool, Live office, Qaaws), Xcelsius 2008, Oracle 10g, Teradata 12, Quality Center, UNIX, and Windows 2003.

Confidential, West Chester, PA

BO/Crystal Report Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports
• Worked on installation and configuration of Business Objects XI r2 Enterprise Suite (Desktop Intelligence, Designer, Central Management Server and Central Management Console) in the development environment.
• Created new reports after gathering the requirements from business user or modifying the existing ones using Java Report Panel (Infoview).
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Created reports using the business object functionality like queries, Slice and Dice, Drill down, functions and formulae.
• Created reports using functions such as running sum, universe name, user response and concatenation.
• Measure objects and User objects were created keeping in view of the end-user requirement.
• Created Hierarchies from providing drill down options for the end-user.
• Extensively used alerters and filters in reports to highlight critical data
• Used Business Objects report level functions like Breaks, Customized filters to display relevant data.
• Generated pictorial views in the form of graphs, pie charts and crosstabs from existing Reports with XcelsiusDashboarding.
• Created Charts, graphs and Bar diagrams according to end user preferences withXcelsius
• Created Technical Design Documents and created Mock ups for the reports.
• Coding and testing of new reports and mocking up data as necessary.
• Created user Prompts, conditions and filters for various reports to specify the reporting parameters as per business requirements.
• Created Dashboards using different analytics like Interactive Charts with alerters and goals Using Excelsius.

Environment: BO XI r-2 (CMC, Web Intelligence, InfoView, WebI, Crystal Reports, Oracle 9i, MS SQL Server 2000, Toad, PL/SQL and Excel, Windows 2000 Server/professional, Tomcat 4.0, Apache Server 1.3,Unix, Sun Solaris.

Confidential, Tampa, FL

BO/Crystal Report Developer

Responsibilities:

• Gathered business requirements and performed detailed analysis.
• Gathered User requirements from end users.
• Created the reports using universes as the main data provider.
• Created Aliases and Contexts for Solving the Join problems in Business Objects.
• Use of BO Designer Module to implement Universes, linkages between tables, creating
• Prompts and queries, parsing the Universes, applying contexts and alias tables to Removecyclic Dependencies
• Worked with Business Objects Supervisor for creating repository, creating and managingthe universes, creating categories, creating and managing the users, giving accesspermissions for Business Objects Reports.
• Created charts to display summary of the data. Created User conditions and Filters to improvereport generation. Also used Alerts to improve the readability of the report.
• Used various join methods like Equi-join, Theta-join, Outer-join, when creating Universes.
• Created Classes, different kind of objects and cardinalities.
• Resolved the loops using Contexts and checked the Integrity of the Universes.
• Exported the Universes to Repository for making it available to users.
• Created hierarchies and predefined conditions using Business Objects.
• Extensively used Data Integrator to cleanse and populate target database
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to developthe reports.
• Exported the reports in to PDF & Excel formats.
• Unit testing of the reports.
• Used Crystal Xcelsius to visualize and bridge the gap between data analysis to enhance the data Presentation.
• Extensively used Crystal Xcelsius to improve Dashboards and Scorecard presentation
• Reconstruction of Pre-Created Crystal Reports on Combined Profitability to Business ObjectsReports
• Designing and building of Universes, Classes and Objects based upon revenue, costsperformance and customer management systems.
• Resolution of loops, fan traps, chasm traps using contexts and aliases and its combinations,Checking of cardinalities, maintaining integrity of the Universes.
• Built Universes using Business Objects Designer.
• Created reports using Business Objects for business requirements.
• Created Reports showing the sales of various drugs in a particular Year, Quarter and Monthusing Business Objects.
• Designed the Universe by creating the Business Objects data model, selecting/joining tables, indicating cardinalities, created aliases to resolve the loops, used Aggregate function andCreated the objects which are grouped into classes based on Business Functionality.
• Created Reports using the Universe, Stored Procedures and Free Hand SQL as the Data providers.
• Created the reports using Business Objects functionalities like Drill Down, Cross tab, Master-Detail and Formulas etc.
• Formatted Reports as per the user requirements using extensively the functionalities in Business Objects, Used Slice and Dice, Drill Down, Filters, Conditions, Cross Tab, Master Detail and Formulas etc
• Developed Hierarchies to support drill down reports which allows the users to analyze the data.
• Involved in Importing/Exporting the Universes to repository to make available to the end user.
• Used Web Intelligence for web based query and reporting.
• Publishing reports using Info view and training users for ad hoc reporting.
• Implemented reporting using n-vision, Crystal Reports, Business Objects.
• Implementing security among the Business Object tools using CMC.

Environment: Business objects XIR2, Crystal Xcelsius 4.5, WebI, Info view, Designer, Data integrator, Report writer, Oracle10g/9i, SQL, and UNIX.

Confidential

Database Developer/ Report Developer

Responsibilities:

• Used Crystal Reports for designing of reports and multi grouping of data at report level as per client requirement.
• Displayed pie charts, bar graphs more understandable for top-level management using Analyzer in the reports.
• Deployed reports in Crystal Enterprise and setup of Scheduling, Publishing is done. Set up of Users, Groups, User Ids, Single sign-on, Report viewing privileges for Users are done in Crystal Enterprise.
• Extensively involved in using of formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Displayed reports for users on web browser by e-launch pad, e-portfolio using Crystal Enterprise.
• Extensively involved in SQL coding creating complex queries, Views, Stored procedures, Functions to give better results at Crystal Reports.
• Creation of packages, procedures, functions and triggers to boost the application performance.
• Created stored functions to manipulate table values before fetching it to the reports using queries.

Environment: Crystal reports 9, Crystal Enterprise 9, Oracle 8i/9i, SQL Server 2000, SQL*Plus, Toad, MS Excel, ASP, HTML/DHTML, VBScript, IIS Server, Web component server, Windows 2000, UNIX.