SUMMARY

• 8+ years of experience in Business Objects Development using various Business Objects (BOBJ) Product Suite including Business Objects Explorer, Xcelsius, and Crystal Reports.
• Experience in Business Objects Enterprise (BOE) Development and Administration through versions Business Objects 4.0/XI 3.2(R3.x) / XIR2/XI/6.x/5.x.
• Expertise in gathering, analyzing and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
• Experience in creating universes using Information design tool, and universe design tool.
• Good knowledge of various schemas in database/universe design.
• Experience in creating joins, and setting cardinalities between tables in a schema.
• Experience in creating hierarchies/navigation paths, calculated measures, and using derived tables in the universe.
• Experience in resolving loops, and creating contexts.
• Developed reports in SAP BOBI 4.0/XI 3.1 using features including Drill, OpenDoc, Hyperlinks, Data Tracking, Input Controls, and Merging Dimensions.
• Implemented breaks, and sections in DeskI reports and WebI rich client.
• 3 years of experience in building dashboards with Xcelsius 2008/4.5 using QaaWS, Web service connections, Live Office, XML, and SAP BW Net Weaver connections.
• Experience in creating Information Spaces, and Exploration view sets using Business Objects Explorer.
• Performing Migrations from earlier versions 5.x, 6.x to XI R1/R2 architectures and recreating security Models in XI.
• Implemented both Single Pass Method and Incremental Method for Migrations.
• Expertise in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.
• Proficient in design, development, coding, implementation and support.
• Solid Experience in writing SQL queries, stored procedures, stored functions, packages, database triggers, exception handlers, Cursors, PL/SQL records & tables.
• Experience in writing SQL Queries and tuning SQL queries.
• Expertise in databases to include Oracle 10g/9i/8i/7x, MS SQL 2008/2005/2000/7/6.5 , DB2,Tera Data and MS Access.

TECHNICAL SKILLS

OLAP/DSS Tools: SAP Business Objects 4.0/XI 3.1/R2/R1/6.x/5.x/5i,BO SDK, Crystal Reports, SIA, Central Management Console, Central Configuration Manager, Designer, Desktop Intelligence, Web intelligence, Webi Rich client, Info View, Report Conversion Tool, Crystal Xcelsius 2008/4.5, Query As A Web Service (QaaWS), SAP HANA 1.0.

RDBMS: Oracle 10g/9i/8i/7/5, DB2/400, SQL Server 2000/2005/2008 , TeraData, MS Access 2000, SAP BW.

Languages: HTML,JAVA,JSP, PL/SQL, SQL, Shell Scripting

Utility Tools: Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader, AQT

Operating System: MS - DOS, Windows 2008/2003/XP/NT/2000/98/95, Unix, HP-Unix, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

SAP BO Developer

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in complete Architectural Design of BO Xi 3.1 as Global Reporting Portal.
• Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.
• Involved in the designing and Building of Universes, Classes and objects.
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Set up Universe level conditions to restrict data based on report requirements.
• Developed and created classes with Dimension, Detail & Measure objects and developed custom hierarchies to support drill down reports.
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Customized Universe level Prompts as per Functional Requirements.
• Check the integrity of the Universes, and export the universes to Repository for making available to users.
• Designed universes against the different database, defining the necessary connections and Exported them.
• The project involved in the development of reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs.
• Created reports using Business Objects functionality's like Queries, Drill Down, Cross Tab, Master Detail and Formulae's.
• Created the reports using Business Objects functionalities like Combined Queries, Drill down, Cross tab, Master detail and Formulae.
• Created Standard Reports utilizing all the features on Web Intelligence in BOE XI 3.1 like Optional Prompts, Functions, Alerters etc.
• Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports.
• Extensively worked with formatting the reports according to the user requirements.
• Analyze data processes to support the automation, efficiency and reporting of Bank reporting.
• Coordination and work along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them.
• Developed Dashboards using Xcelsius 2008 according to user specifications on top of hyperion essbase cube.
• Created members in cube and loaded cube with data from data mart tables by running data stage ETL jobs.
• Wrote complex views, functions and stored procedures using SQL, PL/SQL, to be used in Reports development.
• Responsible for writing the SQL queries for the data validation and testing the reports.
• Worked with business users to understand and analyze the data to day production issues.

Environment: SAP Business Objects XIR 3.1 SP3, Designer, Infoview, Web Intelligence, Data Stage 8.1,Sql, PL/SQL, SQL server 2008, Xcelsius 2008,Oracle 10g,DB2, AQT, Hyperion Essbase.

Confidential, Columbus, OH

SAP BO Developer/Crystal Report Developer

Responsibilities:

• Gathered business requirements and deliverables for report requirements along with functional end users in the business areas.
• Modified existinguniversesand implemented new universes according to the reporting needs by detectingcardinalities, resolving trapsand usingcontextsand also developedhierarchies and derived tables.
• Developed complex webi reports usingcombined queries, merging dimensions, complex functionsat the report level andcomplex filtersto satisfy the end user requirement.
• Created Classes, Measure Objects, Dimension Objects, and Detail Objects and applied Hierarchies based on Business logic.
• Created complex reports using reporter module in Web Intelligence functionalities like Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formula.
• Generate reports withparameters, sub reports, cross tabs, chartsusing Crystal Reports.
• Experienced in working with different templates likehorizontal table, vertical tables, Cross tab tables andcharts.
• Extensively worked on creating prompts atuniverse levelandWebi querylevel.
• Worked on creatingQuery filters, quick filtersandInput controlsin Webi report.
• Experienced in working with grouping, ranking, report variables and differentfunctionsinWEBI.
• Developedflexible queriesusingfilters, navigational attributes, variablesinBEx analyzerto facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Created WEBI reports & Crystal reports and deployed them through BI Launch Pad with Bex as source.
• Modify the existing reports by addingnew logicand deletingexisting logicas the line of Business changes periodically.
• Used Restricted and Calculated Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Worked on SQL and Scripts for solving the problems in Crystal Reports.
• Developed Dashboards usingXcelsius 2008 components usingmaps, Pie Charts, Staked Bar, List Views etc creatively using best Xcelsius components effects for better interaction.
• Involved directly with offshore team. Assigned work to offshore and monitored progress to ensure timely delivery of projects.
• Coordinated with QA Analysts and business partners to support offshore/onsite projects.

Environment: Business Objects 4.0/XI 3.2/XI R3 (Designer, WEBI, Web Rich Client, Crystal Reports XI, 2011, Xcelsius 2008), SAP BODS 4.0, SAP NetWeaver BW 7.3, Oracle 11g, Toad.

Confidential, Tampa, FL

Business Objects Report Developer/Crystal Report Developer

Responsibilities:

• Involved in designing Functional / Technical Specification documents.
• Developed universes from BEx queries using Information Design Tool.
• Created hierarchies/navigation paths in the universe using Information Design Tool and further used these hierarchies for reporting.
• Developed reports specific with these Open Document, and Data tracking new functionalities.
• Experience in installation of Business Objects 4.0 and migrating reports from 3.2 to 4.0.
• Installed Crystal Xcelsius 2008 SP3 and developed dashboards using various components.
• Developed WEBI report/dashboards / Universes (using IDT).
• Developed Universe in BI 4 using IDT.
• Developed Xcelsius 2008 Dashboards on top of QaaWS and Live Office connections.
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
• Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.
• Created crystal reports withdrill downoption,Parameter fields, formulae, and heavy formatting.
• Createdcrystal Cross Tab Reports,Pie and Bar Charts, and Parameter Reports,Running totals,Sub Totalsandembedded linked and unlinked sub-reportsto separate and organize key information and to promote reusability in data reporting.
• Implemented Open Doc to drill down to detail webI report from Xcelsius Dashboard.
• Exported Xcelsius to repository to make it available for users through info view.
• Used relative path URL to migrate Xcelsius Dashboards from one environment to other Environment.
• Created WSDLs using Query as a Web Service (Qaaws) from different Data sources.
• Created Web Intelligence Rich Client reports on Universe.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Generated Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
• Created Web Intelligence Ad-hoc and canned reports.
• Tuning the queries to improve the performance of the report refresh time.
• Created dashboards with multiple hyperlinks to various reports using Open Document Syntax.
• Worked closely with DBAs to create aggregate tables to support Universes and dashboard.
• Developed Webi Reports based on ETL Audit tables to track Record submission, loaded records, Errors in records and Error details.
• Moved universes, reports between environments using Promotion Management in BI 4.0, and Import Wizard in XI 3.2
• Providing support for the users on application usage and conducting training walk through of salient features of the application.

Environment: Business Objects 4.0/XI 3.2/XI R4 (Designer, WEBI, Web Rich Client, Crystal Xcelsius 2008, QAAWS), SAP NetWeaver BW 7.3, Oracle 10g, SQL Server 2008/2005, Toad, Tomcat 6.

Confidential, Herndon, VA

Business Objects Developer/Crystal Report Developer

Responsibilities:

• Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.
• Developed Report Mock-up samples before User interaction to analyze the business requirements.
• Worked in the team closely with Functional Architect, DBA and Analysts to get a clear understanding on the Application.
• Developed universes to accommodate complex database design approaches.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Streamlined SQL generation from Universes by implementing Aggregate Aware functions and Variables.
• Created highly formatted reports to visually represent data.
• Developed dashboards using Xcelsius 4.5 using live office and Qaaws as the data sources.
• Created Webi Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Created complex reports involving master/detail and cross-tab and Combined queries and sub-queries.
• Created live reports in a drill down mode to facilitate usability and enhance user interaction.
• Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of campaigns.
• Developed Dashboards using Crystal-Xcelsius with data source as Live Office.
• Developed customized Webi reports as a source data for Live Office.
• Scheduled Reports using scheduler Infoview as well as CMC.
• Collecting report & Visual requirements from users/business owner.
• Troubleshooting and rectifying Universe, Webi & Live Office errors.

Environment: Business Objects XI R2/R3,Crystal Reports XI, Crystal Xcelsius 4.5, Live Office, Oracle Database, Teradata, PL/SQL, SQL scripting and Windows Server 2008.

Confidential, Spring Field, IL

Business Objects Administrator/Developer

Responsibilities:

• Installed and Configured Business Objects on both Client and Server machines.
• Converted reports from XIR2 to XI R3 using the report conversion tool.
• Customized the infoview page with the company’s logos and information.
• Created user defined prompts and complex conditions at Universe level for better performance.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure.
• Used the BEx queries from BW team to develop universes.
• Created DeskI reports using multiple data providers.
• Created DeskI reports using free-hand SQL.
• Created Cascading Prompts, and filters on the Reports.
• Implemented Filters, conditions in the Universe to the run the Reports quickly.
• Created single sign-on for many reports using the URL functionality to access them directly.
• Created dashboards for higher levels of management on the Financial Actual Budget and Target Budget.
• Created Views, Stored Procedures and validated data for the Performance.
• Used the Business Objects Scheduler to Schedule and Monitor the Reports.
• Provided training for business users in creating Ad-hoc WebI reports.
• Audit reporting system implementation on UAT and Production Environments.
• UAT was one of the important processes that we had developed during this project.

Environment: Business Objects XI R2, XIR3, SAP NetWeaver BW, Oracle 10g, Essbase Hyperion Analyzer, DB2, Sun Solaris and Web Logic.

Confidential

Business Objects Consultant/Crystal Report Developer

Responsibilities:

• Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.
• Supported Business Objects Environments as a Primary Role.
• Worked in the Team closely with Functional Architect, DBA and Analysts.
• Created Derived Tables in the Universe to meet the Reporting Requirements.
• Installed and Configured Business Objects on Both Client and Server Installations.
• Created users and user groups using Central Management Console.
• Created URLs with parameters to run the report for OpenDoc functionality.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Created user defined @prompts and complex conditions at Universe level for better performance.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Scheduled crystal reports to run as per the business user’s requirements.

Environment: Business Objects XI R2, Crystal Reports XI, Oracle 9i, LDAP, Vitria, Sun Solaris and WebLogic.

Confidential

BI Analyst

Responsibilities:

• Analyzed the business requirements of the project by studying the Specification document.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL,SQL *Plus, SQL*Loader and Handled Exceptions.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Created PL/SQL stored procedures by using bulk bind for inserting, updating data in process tables.
• Designed the front end interface for the users using Forms 6i.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Performed Unit Testing.
• Worked with Development team to normalize the database and optimize Queries.
• Created Users on the database and granted permissions based on the user job profiles.
• Created tables to store the information about employees.
• Backup & Restore and point in time recovery of databases and testing of Disaster Recovery.
• Participated in creating maintenance plan for database maintenance.
• Migrating Databases from Development to QA to Production environments.

Environment: Oracle 8i, PL/SQL, Microsoft SQL Server 2000, Windows 2000 Server/2003 Server, Windows 2000 Professional/Windows XP, Microsoft Projects, VBScript.