SUMMARY

• 9 years of experience in Design, Development and support for SAP Business Objects XIR2.0, XIR3.1, XIR4.0.
• Experienced in Development, Administration and Support solutions for SAP Business Objects XI 3.1(R3) / XIR2/R1/6.x/5.x,Server Intelligent Agent (SIA), Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Crystal Reports, Crystal Xcelsuis, Qlikview 9/11, Web Intelligence reports
• Developed Universes for Canned/Ad - hoc Reports using various Sources like Oracle, SQL Server, MS Access and DB2.
• Administration using Central Management Console to configure user and group security, categories, folders, universes, universe connections.
• Worked with multiple RDBMS including Oracle, MS SQL Server, MS Access and associated SQL Dialects such as Transact SQL (T-SQL), PL/SQL.
• Strong knowledge of Data Warehouse Schemas like Star Schema, Multi-Star Schema and Snowflake Schema.
• Experience in creating Dashboards using Xcelsius 2008 using Excel and RDBMS Data Sources.
• Experience in creating reports using SSRS with SQL Server 2008 data source.
• Experience in migrating BOXIR2.0 to BO XIR3.1 and BO XIR3.1 to BO XIR4.
• Developed, Deployed & Scheduled Crystal Reports in Crystal Enterprise.
• Created universes in BO XIR3.1
• Solid experience in designing, creating and maintaining Business Objects Universe, Business Views, WEBI reports and DESKI reports.
• Experience in Creating Complex Crystal Reports using graphs, charts, sub-reports.
• Responsible for functional testing of the applications.
• Working knowledge on Data Warehouse concepts (Star/Snowflake Schema) and different data sources ranging from Flat files, Excel, Oracle, SQL Server, UDB DB2 databases, Sybase IQ, XML and Tera data.
• Expert in RDBMS concepts and Experience Using Database Tables, Views, Stored Procedures, Functions, Triggers ODBC, SQL, Trans SQL, PL/SQL.
• Troubleshooting, Optimizing, fine-tuning of SQL queries for efficiencies
• Experience working with onsite and offshore models of project development.
• Good working knowledge in Configuring and Deploying Qlikview Dashboards.

TECHNICAL SKILLS

Reporting & Analysis Tools: SAP Business Objects, Business Objects BI4.0/XI R3/R2/6.5, Crystal Reports 2011,XI/ 10.0/9.0/8.5/7.0 , ), WEBI XI R3/R2, Crystal Xcelsius, SQL Designer, Ms Excel. Oracle 9i/8i, MS Access 2000, SQL Server, SSRS, Qlikview 9, 10 & 11.

ETL Tools: Business Objects Data Integrator (Data Services) XI 3.2.

Programming Languages: SQL, PL/SQL, T-SQL, C, JAVA, and HTML.

Platforms: WINDOWS VISTA/XP/NT/00/98/95, UNIX.

Others: Oracle Developer, TOAD, SQL plus, SQL Loader, Visio.

Defect Tracking: Team Track

Version Management: Clear Case, PVCS.

Domain: Banking, Commodity Trading, Pharma, Insurance.

PROFESSIONAL EXPERIENCE

Confidential, Exchange Place, NJ

BOBJ Developer

Environment: SAP Business Objects XI3.1, WebI, Universe, Crystal Reports, DB2, MS Access, Excel Macro

Responsibilities:

• Performed Impact Analysis on the reports due to the changes in existing source systems.
• Created Impact Analysis document for each of the report based on the findings during the Impact Analysis.
• Then created a consolidated Impact Analysis document with detailed description of Impact of source system on reports.
• This Consolidated Impact Analysis document is presented to end users and obtained their sign off as scope of the project for existing BO Reports.
• Modified existing BO reports and universes as per the requirements and Impact Analysis Documents and performed unit testing of the reports.
• Gathered requirements for existing Main Frame Decision Analyzer reports that are to be converted to BO.
• Created Universes for DA reports using features like Check Integrity, Cardinalities, and Aliases, resolving Loops, Contexts and Hierarchies.
• Created DA reports sourcing data from multiple data providers and using features like variables, merge dimensions.
• Converted existing DeskI reports to WebI reports.
• Involved in content promotion, user training, defect management etc.

Confidential, Berkeley Heights, NJ

BOBJ Developer / Admin

Environment: SAP Business Objects XI3.1, 4.1, WebI, Universe, Crystal Xcelsius, Qlikview

Responsibilities:

• Involved in complete SDLC for eQRMS application.
• Participated in business meetings to gather requirements for reports and created report requirement specification document.
• Created universes using features like Check Integrity, Cardinalities, Aliases, Loops, Contexts and Hierarchies.
• Created Classes, Sub-Classes and Objects (which include Dimensions and Measures).
• Created user defined @prompts, Smart Measures and complex conditions at Universe level for better performance.
• Based on approved RRS created reports using Web Intelligence 3.1 features like tables, charts, variables, folding/ unfolding, variables etc.
• Created design specification documents for reports and universes
• Using eRexS tool routed documents for review with business and technology and got approvals for documents.
• Created reports for Complaints, GxP Change Control modules using WebI 4.1 and involved in testing, bug fixing and deployments of the reports.
• Migrated DeskI reports to WebI.
• Migrated existing WebI reports from version 3.1 to version 4.1.
• Involved in build and deployment of reports and universes.
• Responsible for setting up of Business Objects environments like DEV, TEST, UAT and PROD.
• Installed business objects XI R4.1 on windows servers
• Created users, groups, folders and assigned user level as well as folder lever securities.
• Performed tasks like adding nodes, removing nodes, monitor server status and starting, stopping, restarting servers, adding servers, cloning servers and deleting servers

Confidential, New York, NY

BOBJ Developer / Admin

Environment: SAP Business Objects XI R3.1, XI R 4.0, Crystal Reports 2008/2011, WebIRich Client, Business View Manager, Universe B.O. XIR3.1, BO XI4, Oracle 11gBW, Sql Server 2008, Actuate 7, db2, MS Access, Eclipse, Tableau, QlikviewCrystal Xcelsius 2008/4.0, SSRS 2008, JAVA, Qlikview 9, Qlikview 11, Qlikview Server 9, Qlikview Publisher 9

Responsibilities:

• Migrated 500 plus reports from Actuate to BO during past 3 ½ years with a team of 8 using universes, Business Views and stored procedures as data sources.
• Created universes in BO XI R3.1, BO XI R4.O against huge Oracle database.
• Created user defined @prompts, Smart Measures and complex conditions at Universe level for better performance.
• Maintaining Universes and Reports to multiple Environments (Dev, Test, Pre-prod & Prod etc.).
• Resolved join problems, loops in Universe, worked on aggregate awareness, cardinality of universes.
• Created Dashboards using Crystal Xcelsius 2008 by importing excel data and connecting to RDBMS.
• Created Reports using SSRS using SQL Server 2008 as data source.
• Migrated Users, Universes and reports from Business Objects XI R3.1 to Business Objects XI 4.
• Design the jobs that extract, integrate, aggregate, load, and transform the data for your data warehouse or data mart.
• Schedule, run, and monitor jobs, all within Data Stage.
• Created custom functions for currency conversion, date conversion.
• Created business views and implemented data-level security to the users.
• Analyzed and explored reports using slice and dice and drill down functionality.
• Responsible for creating users, groups, folders, publishing reports in business objects XIR2, business Objects XIR3.1.
• Implemented dynamic cascading prompts.
• Created user defined @prompts and complex conditions at Universe level for better performance.
• Provided the security access management by creating users/groups and folders.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Creating Standard reports, Cross tabs reports, Ad-hoc reports using the features like Ranking, Sorting, and @functions to analyze the data.
• Created and maintained Cubes on BW Database as a data source for reports.
• Created WebI, Crystal reports using Universe as data source.
• Some of the features of these reports are.
• Responsible for setting up and maintenance of Business Objects DEV Environment.
• Responsible for installation and configuration of business objects XI R3.1, creating users, groups and folders, assigning securities, managing licenses
• Responsible for starting, stopping and restarting servers including Central Management Server, cloning servers, adding and removing nodes etc.
• Responsible for distributing work/tickets among team and update status.
• Given holistic solutions for product limitations like internal drilldowns, large number format, field truncation, Simplified Chinese fonts and RTF alignment.
• Experience with Report testing and to validate the results against the database.
• Fine tune SQL Queries and created stored procedures for performance improvement. 90% of jobs will run less than a min.
• Configured expressions and implemented business logic using set analysis.
• Published Qlikview Applications.
• Scheduled jobs in Qlikview Publisher for reloading of data and distribution of applications.
• Implemented various dashboards/applications for various sectors in organization.
• Provided training for the users how to use Qlikview applications and handling security.

Confidential, Stamford, CT

BOBJ Developer

Environment: Crystal Reports XI, 2008, WebI, Universe, Business View, Oracle 10G, 11G, SQL Server 2005, B.O. XI R2.0, B.O. XI R3.1, MS Access, Xcelsius 2008, Tableau, Qlikview 9, Qlikview Server 9, Qlikview Publisher 9

Responsibilities:

• Installed and configured BOBJ on Windows, UNIX.
• Involved various projects like Reporting System Development Project, Global Reporting Project, Trading Reports Development Project and Migration project.
• Involved in gathering requirements, Coding, Designing and Testing of reports and universes.
• Created Dashboards using Crystal Xcelsius 2008 by importing excel data and connecting to RDBMS.
• Created stored procedures using temporary tables to enhance performance of global reports.
• Converted key reports (balance sheet, income statement, accounts receivable, accounts payable, net ARAP, trail balance) in vision excel from sun accounting system into Web Intelligence and crystal reports using universes and Business views as Data sources.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results
• Created Standard reports, Cross tabs reports, Ad-hoc reports using the features like Ranking, Sorting, and @functions to analyze the data.
• Used Web Intelligence to create Reports. Involved in customizing the look and feel of Web Intelligence Interface.
• Created universes in business objects XIR2 and business objects XIR3.1 lligence to create Reports. Involved in customizing the look and feel of Web Intelligence Interface.
• Designed Universe by creating the BOBJ Data Model selecting/joining tables, indicating cardinalities, creating aliases and contexts to resolve the loops, creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe
• Involved in Creating Universes and Reports. Designed new Universes using features like Check Integrity, Cardinalities, Aliases, Loops, Contexts and Hierarchies.
• Created Classes, Sub-Classes and Objects (which include Dimensions and Measures).
• Responsible for testing and validation of the reports.
• Technical expertise in Analyzing, Design, Implementation and administration of security models with row level data security, role based security etc in BOBJ Universes and Central Management Console (CMC)
• Created business views using business view manager in business objects XIR2 and business objects XIR3.1
• Created users, groups, folders, publishing reports in business objects XIR2, business Objects XIR3.1.
• Implemented securities on users and groups in business objects XIR2 and business objects XIR3.1
• Implemented securities for users, groups in central management console
• Implemented data-level and prompt level security to the users in business views and universes.
• Migrated business objects XIR2 to business objects XIR3.1.
• Migrated Web Intelligence R2.0 to R3.1 and crystal reports XI to Crystal Reports 2008.
• Responsible for production support for the Reporting System, Global Reporting, Trading Reporting Systems.
• Scheduled jobs in Qlikview Publisher for reloading of data and distribution of applications.
• Created User Manual, Technical Documentation & Expression Documentation.
• Provided training for the users how to use Qlikview applications and handling security.

Confidential, St. Petersburg, FL

BOBJ Developer

Environment: .NET Framework 2003, Crystal Reports 10, Oracle 10G, SQL Server 2005/2000MS Access, Qlikview 9.

Responsibilities:

• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Installed and configured BOBJ on Windows.
• Created users, groups, server groups and setup security architecture
• Implemented BIAR file for Backups/Deployments.
• Technical expertise in Analyzing, Design, Implementation and administration of security models with row level data security, role based security etc in BOBJ Universes and Central Management Console (CMC)
• Deployed BO universes and reports from DEV to TEST/SIT/UAT and Production environments using Import wizard..
• Developed BOBJ Universes by Using Teradata Database as Data Source
• Designed Universe by creating the BOBJ Data Model selecting/joining tables, indicating cardinalities, creating aliases and contexts to resolve the loops, creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe.
• Implemented Cardinality settings, Joins, Conditions and Global Filters in Universe
• Worked in Aliases and Contexts to resolve looping problems and used Derived tables methods.
• Migrated Reports from BOXI 6.1v to BOXI R3
• Created Cascading Web Services for different Dashboards.
• Creating and Formatting the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, @functions and Formulae to analyze the data. Creating and distributing Report Templates to Users and Main Data Providers for creating these reports are - Universes.
• Created Web Intelligence Ad-hoc and canned reports.
• Created Reports with multiple hyperlinks to various reports using Open Document Syntax.
• Created Web Intelligence Rich Client reports using Universe.
• Creating Standard reports, Cross tabs reports, Ad-hoc reports using the features like Ranking, Sorting, and @functions to analyze the data.
• Used Web Intelligence to create Reports. Involved in customizing the look and feel of Web Intelligence Interface.
• Created user defined @prompts and complex conditions at Universe level for better performance.
• Provided the security access management by creating users/groups and folders.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Schedule jobs in CMC by Daily, weekly, bi-weekly and monthly basis and export the results in Excel and send the report to the user thru Email.
• Supported and solved the tickets for Crystal Reports in production environment.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Generated the BOXI reports involving complex queries, sub queries, Unions and Intersection.
• Developed universe user documentation guide for the end users reference.
• Installed & Configured Qlikview Server 9 on Production Server and Published Qlikview Applications.

Confidential, NY, NYC

BOBJ Developer

Environment: Crystal Enterprise 2008, SQL Server 2005, Crystal Reports XI/10.

Responsibilities:

• Co-ordinate with the QA team for the business requirements and also interacts with the business when required.
• Designed Universes for both the product lines in the company. We developed a total of 85 Universes for all the users.
• Also created linked Universes and universes using multiple databases/data providers.
• Maintained the Supervisor module in the absence of the lead.
• Had training sessions for the users when migration. Trained how to create WebI reports using Infoview and also trained the users on using the Alerters, Prompts.
• Used Application Foundation to build the dashboards for the Business users and placed on the Intranet.
• Scheduled reports using BCA to distribute the reports via server, scheduled some reports using SQL Scheduler. Planning to implement AutoSys for scheduling.
• Extensively used Calculations, Variables, Drill down, Slice and Dice, Alerts in the creation of reports.
• Involved in upgrading the technology from 5.1 to XIR2
• Created 32 Calendar Objects in common for all the universes, which can be used as Query Filters and also used for scheduling the WebI reports.
• Identified the bug regarding the Trusted Connections in XIR2, and working with BO technical support team.
• Was also involved in the production support while migrating to the new version of BO.
• Used to receive the requests from the user through the Test Director. This tool was also used as the knowledge base.
• Extensively used the OLAP methodology in generating the reports, like, Drill analysis, Slice & Dice etc…
• In parallel to Business Objects, worked on WebFocus 5 to create graphical reports, boardroom quality reports
• Designed the HTML front-end pages that contain the reports, along with graphs, images, and text; and add frames, check boxes, option button groups, and drop-down lists
• Created parameter driven reports using WebFocus 5 which included Filters, Output Options, Report Styling, Data Visualization, Sorting Options etc …
• Worked on ReportCaster to distribute the WebFocus reports by providing the Burst values to multiple recipients.

Confidential, Morgantown, WV

BOBJ Developer

Environment: Trackwise Team Access, Business Objects XI R2, WebIntelligence 6.1bCrystal Enterprise XI/10/9, Oracle 9i, SQL Server, Adverse Event recovery system.

Responsibilities:

• Involved in report requirement gathering.
• Actively involved in the creation and modification of user/user groups and maintained user profiles using Supervisor.
• Coordinate with the data team to develop the data models that suits the business requirements, worked closely with the Data Integrator team.
• Designed and maintained Universes and exported them to the repository.
• Created Classes and Objects (Measure, dimension and detail) in the universe.
• Used Designer Module to implement Universes, Joins between Tables, and created prompts and queries, parsing of Universes, and created Contexts and Alias Tables to remove cyclic dependencies.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Created reports using standard company templates. A few of them were created based on the Department requirements.
• Extensive use of BusinessObjects functionalities in formatting reports.
• Created user Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Monitored Business performance using Business Objects Dashboard Manager.
• Used Dashboard Manager to build personalized Dashboards and deploy them across the organization.
• Creating the reports in WebIntelligence using WebI Java Report Panel.
• Used Report Bursting technology to secure the data, based on user profiles.
• Extensively used Calculations, Variables, Drill down, Slice and Dice, Alerts in the creation of reports.
• Generated complex reports using Business Objects.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Used Broadcast Agent for publishing the reports.
• Used Broadcast Agent Console for monitoring the load on the BCA server and prioritizing the scheduled jobs.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.
• Planned, coordinate and execute BusinessObjects deployment for End-users and documented the entire project.
• Data Validation for Standard reports and Ad hoc reports. Used with Test director tool
• References will be provided upon request