Summary

• Experienced Sr. Bo consultant and Developer with around 8 years of experience in tools like SAP Business Objects, Crystal Reports, Crystal Xcelsius, Oracle, SQL Server, DB2 and Sybase.
• Strong Experience in building Reports retrieving data using Universes, Personal data files, Free hand SQL methods and creating complex reports, ad-hoc Reports using the Desktop Intelligence and Web Intelligence tools.
• Well versed in Business Objects (Business Objects XI 3.1, R2, 6.5, 5.1) with experience in CMC, CCM, Infoview, Desktop Intelligence, Import Wizard, Supervisor, Designer, Reporter, Web Intelligence, Dashboards, and Scorecard.
• Experience and knowledge in Data Warehouse (EDW), Business Intelligence (BI).
• Expertise in BO-XI R2/R3 (Universe, Reports & Admin) and in BO-6.5 (Designer, Supervisor. Reporter, WEBI and Broad Cast Agent), Crystal report design, Dashboard Design.
• Expertise Knowledge in Data Warehousing concepts , SQL , design and development of Universes and for reporting solution in BO for Operational Reporting System.
• Experience in designing and developing Security Structure/ Model in BO XI R2/R3 environment and well experience in BO admin activities.
• Expert in Installation and Configuration of Business Objects Product Suite.
• Expertise in Universe developing and generating complex, ad hoc, dashboard Reports, Business views, List of values along with User Acceptance Test and Data Accuracy Test
• Extensively worked in Migration related projects as a BO Admin.
• Extensive experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like Windows NT/2000/XP.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Strong knowledge in developing products under Windows 2003/2000/XP/NT, UNIX environments.
• Excellent Communication with different user communities in organization.

Technical Expertise:

Operating System 

Windows XP/ Enterprise Server 2003 and 2008/NT, UNIX

Languages

T-SQL, PL/SQL, SQL Plus,DB2

Database

SQL Server 2008, 2005, Oracle 11g/10g/9i, IBM DB2, MS Access.

Tools

Business Objects XI 3.1, R2, 6.5, 5.1; Web Intelligence (WEBI); Desktop Intelligence (5.1 Business Objects), Crystal Reports XI and 2008, Xcelsius 2008 and Visio, Informatica 7, SSRS, SSIS 2008.

Packages

OLTP; OLAP, ODBC/API, ADO, DAO, OLEDB, XML, CSS,CCM,CMS,CMC,ECC,SDK, Trend Analysis, Full Life-Cycle Development, Star and Snowflake Schemas, Executive Dashboards, Oracle SQL Developer, SQL Plus, SQL Loader, Microsoft Visual Source Safe, MS Office, Server studio, Tibco Spot Fire, Data Integrator 11, BMC analytics, Infoview, Desktop Intelligence, Import Wizard, Supervisor, Designer, Reporter, Web Intelligence, Dashboards, and Scorecard.

Education 
Bachelor in Science, Confidential university, .

Certifications:
Business Objects Certified Professional
PL/SQL Certifier Developer
MS SQL Server 2008.

Professional Experience

Confidential, Louisville, KY
Sr. Business Objects Developer
June 2010- Till Date
Developed and Maintained a Reporting System for the EBPP and call center Departments from the under lying SAP Data marts which would help the HR and Finance Departments to view various reports related to their departments and also the Top level executives of Insight. SAP BW was used to populate the warehouse and Business Objects XI for Reporting purpose. 
Responsibilities:

• Created Universe level objects and measures using the business rules provided.
• Designed and developed the reports using Joins, Shortcut Joins, Contexts, and Cardinalities of the tables and structures of the Universe.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Importing and Exporting the Universes to repository to make it accessible to end users.
• Created query using QAAWS and using Dynamic query’screated Xcelsius Dash boards.
• Integrated Crystal Xcelsius dashboards with Business Objects Universe using QAAWS.
• Developed multiple dashboards so that the user can navigate from one dashboard to the other.
• Created Agent level reports, supervisor level and manager level reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Created reports of kind, Slice and Dice, Drill Down, Combined Queries, Functions, Cross Tab, Master Details and wrote formulae for easy-to-use benefit information system by using Crystal Reports.
• Defined sections and sub-sections for the reports in crystal reports using the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors.
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other. Created Revenue Dashboard, Sales figure Dashboard using Xcelsius 2008.
• Migrated reports, Universes, users from BO XI R2 to XI R3.1.
• Managed the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
• Installed and Configured BOBJ, Service Packs, Hot Fixes, Productive Pack etc on Engineering servers to extensively test the impact before installing them in Dev, QA and Prod.
• Defined BO XI 3.1 user security model, users, groups, and Role based user, Universe Security Authentication and Active Directory.
• Configured the Email/FTP setup in the DEV, QA, and PROD Environments.
• Created Auditor reports and tracked user access of reports and Universes.
• Migrated Universes/Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing) using Import Wizard.
• Scheduled the Web Intelligence/CR reports using the CMC by creating event based triggers.
• Involved in Production support activities and fixing the live data issues.

Environment: Windows Enterprise Server 2008 Apache Tomcat, BOXI R3.1 , Crystal Reports 2008, Oracle 11g/10g, TOAD, Designer XI, Web Intelligence XI, Info View, Designer, CMC, CMS, Xcelsius 2008, SQL, PL/SQL, Live office.

Confidential, WI. 
Business Object Developer 
Jan 2010 to May 2010
Confidential is one of the largest and strongest mutual insurance companies in the United States. With assets of $11 billion and a policyholder surplus of more than $3.3 billion, Sentry Insurance is rated A+ by A.M. Best, the industry\'s leading rating authority.
Responsibilities:

• Analyzed Business Objects old Universes and Reports. Developed Business objects reports using Designer and Reporter XI R2 Version.
• Provided report generation solution to the clients using different versions of Crystal Reports best suited for the business requirements.
• Developed components to allow automated generation of reports
• Designed / developed reports from a number of different data sources with a number of formats including PDF, spreadsheet, or graphic using Crystal Report XI.
• Developed and implemented Universes by defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business objects Designer.
• Created Hierarchies at various levels for drill down reports and Customized LOV’s in Universe using designer.
• Implemented Aggregate Awareness for summary data with optimal query execution.
• Worked on cross-tab and master detail reports. Also represented the same as line charts/ bar charts / pie charts of the same.
• Created few dashboards using BMC Analytics for the Agent level reports.
• Created Crystal reports using the Universes as the main Data Providers.
• Solid experience in creating application schema as tables, view and indexes. SQL tuning of reports to increase performance.
• Experience in writing scripts to drop the index before and recreating indexes after the data load to increase the performance.
• Generated various numbers of reports on a daily, weekly and monthly basis using Business Objects Report module.
• Created Dashboard reports in Xcelsius to measure the performance. Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble using Xcelsius 2008.

Environment: Business Objects XI R2, Web-Intelligence, Xcelsius 4.5, Desktop Intelligence, CMC, Designer, Toad, Oracle10g, SQL, PL/SQL, Windows 2000 and Windows XP, Crystal Reports 10

Confidential, Redmond, WA 
Reports Developer 
Apr 2009 to Dec 2009
Confidential is an American multinational corporation headquartered in Redmond, Washington, United States that develops, manufactures, licenses, and supports a wide range of products and services predominantly related to computing through its various product divisions.
Responsibilities:

• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscriptions.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Used Team Foundation Server (TFS) for version control, source control and reporting.
• Created classes and dimension and measure objects according to business requirements.
• Generated effective reports using formulae, sections, breaks, alerters and filters.
• Developed Dashboards using Application Foundation 3.0 to build flexible dashboards giving users a top-level view of key metrics and the ability to drill down from any metric to the operational detail.

Environment: SQL Server 2005, SSRS, Business Objects XI R2, Query Analyzer, Index Tuning Wizard, Windows Server 2003 Enterprise Edition.

Sr. Business Objects Developer/Admin
Jan 2008– Mar 2009
Confidentialr Alternative Asset Management division used the Octane application as the supporting tool to carry out their operations around the Fund of Funds (FOF) business. To complement their operational needs, migrated the existing Crystal Reports on to Business Objects and also develop new canned Reports using Business Objects and Web intelligence.
Responsibilities

• Developed Ad hoc, Workflow, Exception, Performance reports for National, Regional, Department level reporting.
• Made daily, weekly, monthly, semi annual reports as when required within the given timeframe.
• Used complex calculations, created variables, Breaks, Drill Down, Slice and Dice, Alerts, folding of tables.
• Created charts, tables to display summary of the data.
  Tested reports against ITSM (remedy user) for the verification of the data generated.
• Created Custom Filters, Global filters, Predefined Conditions in developing reports.
  Migrated Microsoft Excel, Access reports to Business Objects reports.
• Developed reports which show monthly, Year to Date Performance of the department.
• Created Aliases and Contexts for solving the join problems in Business Objects.
• Used various join methods like Equi-join, Theta-join, Outer-join, when creating Universes.
• Created Hierarchies and Predefined Conditions using Business Objects.
• Created various crystal Reports by pulling the OLAP data from Data Warehouse like Sales of Product, By Region wise, and Reports Based on time like Year, Quarter, Month, Week, Geographic Reports and Comparative Reports.
• Involved in various discussions with end user to analyze Meta data.
  Extensively used Calculations, Variables, Break points, and Sorted inputs. Drill Down, Slice and Dice, Alerts for creating Business Objects reports.
• Created user Conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Formatted the Reports to the Users Requirements using all the requirements in Business Objects like Slice and Dice, Drill down, @ Functions and Formulas etc.

Environment: Business Objects XI R2, Web-Intelligence, Xcelsius 4.5, Desktop Intelligence, Actuate, CMC, Designer, Toad, Oracle10g, SQL, PL/SQL, Windows 2000 and Windows XP, Crystal Reports 10

Confidential, OH.
Business Objects Developer
Aug 2006 – Dec 2007
Reporting and analyzing were performed using Business Objects 5.1. Created Business Objects Universes and developed reports using multiple universes feeding the data from different data sources.
Responsibilities:

• Involved in design, development of the complete Decision Support System using Business Objects.
• Multi source Extraction Transformation and loading into the Repository using Informatics Repository maintenance and security.
• Involved in importing Source/Target Tables from the respective databases and created Reusable Transformations, Mapplets and Mappings using Designer Tool set of Informatics.
• Created different sales report, revenue reports and involved in development and maintenance of Universe using Designer.
• Generated business objects reports with Slice & Dice and Drill down Capabilities for Reports on a periodic basis.
• Created, Modified and publishing reports using WebI. Created classes, objects and filters at Universe level and resolved loops using contexts and aliases.
• Worked on cleaning the current universe in terms of naming convention and designing the better security.
• Involved in resolving the loops, using contexts and checked the cardinalities, Integrity of the Universes.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulas etc.
• Developed complex queries using different data providers in the same report.
• Created reports based on the stored procedures.
• Scheduled Reports using Broadcast Agent.

Environment: Business Objects 5.x (Designer, Reporter), Informatica (Designer, Repository Manger, Server Manager), ODBC, PL/SQL, Oracle, MS Access, SQL Server, Windows NT.

Confidential
Business Objects Developer
Jan 2006 – Aug 2006
Confidential provides the planning and implementation of IT-enabled processes needed to support business. By focusing intensely on analysis of the IT sourcing needs, an enterprise can ensure that it has access to necessary resources- and even find a way to survive in the marketplace.

Responsibilities:

• Creating and Formatting the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, functions and formulae to analyze the data.
• Creating and distributing Report Templates to Users. Web-Enabling the Reports using web intelligence.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User notes.
• Installing the Business Objects and Creating Repository (Security, Universe and Document Domains).
• Used Business Objects for developing different types of reports based on the requirements.
• Source systems were studied thoroughly before writing OLAP Queries.

Environment: Oracle 9i, PL/SQL, Business Objects 6.x, Crystal Reports 8.5, BO Supervisor 6.0, Web intelligence 6.0, Broadcast Agent, Windows 2000.

Confidential

Developer May 2004 – Dec 2005

Maintained comprehensive information on all inventory items, gave up-to-date status on their availability, usage, receipts, on-order, pending inspection, committed quantities, etc. 
Responsibilities:

• Maintained Universes by defining joins cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Interacted with users to know their approach and assist in developing and modifying Reports accordingly.
• Created different types of reports such as Master/detail, Cross Tab and Charts.
• Created graphical representation of reports such as Bar charts, 3D charts and Pie charts etc.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus)
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Exported reports into EXCEL, PDF, CSV and XML formats as per the client requirement.
• Used features such as functions and parameters, conditional formats to develop highly formatted Reports.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

Environment: Business Objects 5.x, Crystal Report, Web Intelligence, Info view, Designer, Supervisor, Oracle 8.x, PL/SQL, UNIX, SQL Server.