Professional Summary

• Over 12 years of experience in SAP Business Objects.
• Hands on development Experience on Business Objects XI 4.0
• Well versed in SAP Business Objects (XI 4.0, 3.1, R2, 6x and backwards) with experience in CMC, Supervisor, Designer, Reporter, BCA Server (Publisher and Scheduler), Web Intelligence 2.5/2.6.1/6.0/XI R2/3.1/4.0, Info view, Application Foundation, Rich Client, Dashboards, Auditor and Schema Design.
• Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements.
• Experience in full SDLC from Requirements Gathering and Analysis, Evaluating Data Sources, Translating Requirements into Specifications, Business Case Development to Rollout, Production and Maintenance.
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Worked on Web Intelligence (Webi), Desktop Intelligence (Desk I) to develop and publish reports.
• Good knowledge and experience in using SAP BW, Teradata, DB2, Oracle 10g/9i, MS SQL Server 2008/2005, MS Access, TOAD,PL/SQL Developer, Query analyzer.
• Knowledge of SAP Business Warehouse BW 3.0/BI 7.0, Business Explorer (BEx), SAP R/3 and ETL process.
• Experience in developing SQL, PL/SQL procedures, database triggers and other components of database applications.
• Experienced in Free Hand SQL and Performance Tuning.
• Active in providing functional and technical support, detailed analysis, requirements gathering, data dictionary, testing and user training.
• Document all business processes, needs, flows and diagrams.
• Keep the project manager and supervisors informed of task accomplishment, issues and status.
• Experience in coordinating with offshore team for code deliveries and other activities.
• Created complex reports with multiple data providers/multiple universes/multiple data bases (Teradata, Oracle, SQL server, DB2).
• Excellent understanding of Online Transaction Processing (OLTP),Data Modeling, Star Schema, Snowflake . Fact, Lookup and Dimensions Tables
• Exposed to Data Warehouse assignments in various domains like Mortgage, Medical services, Sales, Insurance, Financial & Bank, Data warehouses.
• Excellent interpersonal, communication and presentation skills.

OLAP Tools

Business Objects XI 4.0/R3/R2/6.x/5.x/4.x, Web Intelligence 6.x/2.x, Infoview, Broadcast Agent, Application Foundation

Reporting Tools

Business Objects, Crystal Reports, Excel 2000/XP

Database(s)

ORACLE 10g/9i/8i, MS SQL Server 2000, MS Access

Front End Tools

TOAD, SQL* PLUS, PL/SQL Developer.

Programming Languages

C, C++, SQL, PL/SQL

Operating System

Windows 95/98/2000 /NT/XP, UNIX

Office suite

MS word, excel, PowerPoint

Project Mgmt Tools

Clear Quest, Req Pro, Documentum , Mercury, Peregrine

EXPERIENCE

Confidential,North Brook, IL Feb’ 11 – Till Date
Sr. Business Objects/XCelcius Developer/Analyst.

Allstate Insurance insures autos and homes in the U.S. and is one of the leading life insurer\'s.
Allstate Roadside Services is a division of Allstate Insurance. ARS provides services to a wide array of industries including BMW, Mercedes Benz, and Verizon wireless. Developed various types of Business Objects reports for partners on go basis as per their business need.

Role:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Developed user requirements documents and technical requirements needed to design and develop SAP Business Objects dashboards and reports.
• Created design specifications document to develop reports/dashboards taking into account all the data needed for the documents.
• Worked with several users, and interacted with them to gather requirements.
• Developed universes by using relational database (Oracle) as the back end.
• Involved in classifying the classes, measures and dimensions.
• Assist with the data model and design of the data mart.
• Create the security for the BO Enterprise by creating folders, users and user groups as per the specifications according to the different Departments.
• Perform Administration tasks and configure user\'s security and access privileges as per the requirements and help them in WebI development.
• Production Support the users with their reports and be responsible for solving admin issues with the Database connectivity, response time and security of users.
• Responsible for Solving Tickets generated by users regarding problems with Crystal reports, web intelligence reports and Universes.
• Designed and developed the Universe and updated the existing Universes for the purpose of building adhoc and canned reports.
• Involved in upgrade of Business Objects Version 3.1 to Business Objects 4.0.
• Converted Deski reports to Webi reports in BO 3.1 version.
• Developed Universes in Business Objects 4.0 using Information Design Tool and Universe Designer Tool.
• Developed WEBI report/dashboards / Universes (using IDT) in SAP Business Objects 4.0 Environment.
• Created user/user groups through Central Management Console (CMC) and involved in giving privileges to these groups.
• Train and educate end users about the use of universe and generation of reports.
• Converted the existing Deski reports into webi/rich clinet reports.
• Experience in Performance Tuning and Optimization of SQL statements
• Extensively used Designer to design various universes for different business groups.
• Created template documents with header, footer and company logo.
• Migrated reports to Xcelsius for better analysis.
• Created Dash boards using Crystal Xcelsius.
• Created query using QAAWS and using Dynamic query’s created Xcelsius Dash boards.
• Created Standard WebI reports with client customizations and formatting to serve as templates for the canned and ad hoc reporting.
• Documented all the changes made to the Universes and Reports for future references.
• Hands on knowledge of Business Objects XI 4.0.
• Resolved loops, chasm and fan traps using contexts, aliases and integrity checks.
• Worked extensively with @functions like @select, @prompt, @where and aggregate aware to write flexible SQL queries.
• Good knowledge in creating the derived tables in the universe as per the requirement
• Setting up different level of security in the object level, like row level restriction and object level restriction
• Setting up the data and roles in Bo User access and Role access tables as per the security requirement.
• Coordinated activities such as Development and Performance test with offshore teams and produce finding during the deployment readiness phase.
• Tested Business Objects reports and validated values as per user requirements.
• Provided round the clock production support.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Formatted the raw data retrieved from Universe Objects in excel spreadsheet using VLOOKUP,IF, AND, OR, CONCATENATE and many other excel formulae/functions.
• Acted as Subject Matter Expert (SME) in guiding offshore team to create and modify reports as per the client requirements

Environment: Business Objects XI 4.0/3.1, Crystal Report 2008, Oracle 11g, NCD, UDB DB2 v9.1, SQL Navigator 6.2, QMF, Windows XP.

Association Management Center (AMC) provides management and specializedadministrativeservices to trade associations and professional societies using a for-profit approach that runsnot-for-profitassociations like businesses.
Developed reports on “Personify” a .NET based application which is replacing legacy system TIMS. Converted all the existing Cognos reports to Business Objects reports.

Role:

• Created reports for different clients and for different business units like Membership, Meetings, Certifications, Finance, HR etc.,
• Using CMS maintained all the universe, webi, Deski, dash boards across different environments and given security privileges to different users in different departments.
• Migrated the whole project from Business Objects 6.5 to Business Objects XI R2.
• Using Import Wizard migrated the reports and universes across DEV, UAT and FIT.
• Thorough understanding of different functional components of logistics department
• Interacted with Business Analysts, Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Interacted with the Data Warehouse team and suggested ideas to improve the model of the Data Mart, which can help in tuning the SQL and improve the performance of
  generating reports.
• Created object level and row level securities in Designer using security restrictions option.
• Involved in the troubleshooting of Universe schema with loops, chasm traps, fan
• traps and cardinality problems and checked Integrity of the Universes.
• Created Stored Procedure based Crystal Reports label format reports for different meetings.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping etc.
• Developed Crystal Reports for Invoices, Notices and Mailing labels.
• Used mainframes reports and files to compare values with BO reports.
• Tested reports and involved in trouble shooting.
• Exported the Universes and reports to the Repository to make available resources to the users.
• Extensively Worked in Live Office to create connections between WEBI and Xcelcius Dashboards
• Created Complex Reports such as linking of Two Reports, Drill Down and Drill Up.
• Created Content plans for Security.
• Involved in understanding the end-user requirements and business processes in creating and designing universes, queries and reports
• Set up Universe level conditions to restrict data based on report requirements.
• Created Class andObjectsin the Universe Designer and following the Naming standards.
• Involved in production support based on the Remedy tickets modified/resolved the Reports.

Environment: Business Objects XI 3.1, Crystal Report 2008, MS SQL Server 2008, Teradata , TIMS, Personify, SQL Server Mgt Studio, Windows XP, UNIX.

Confidential,CHICAGO, IL Jan 09-Dec 09
Sr. Business Objects/ Crystal Reports Consultant.
The American Health Information Management Association (AHIMA) is the premier association of health information management (HIM) professionals.
Developed reports on “Personify” a .NET based application which is replacing legacy system IMIS. Converted all the existing Cognos and Access reports to Business Objects reports.

Role:

• Interacted with Business Analysts to know their Business views to create universe, Reports accordingly.
• Installed theBusinessObjectscomponents on UNIX and Windows OS.
• WebApplication Server andWebComponent Adapter installed inWebSphere Environment.
• Working Experience as Architect (Design, Develop and Installation).
• Implemented Single Sign-On in windows Active Directory Groups.
• Responsible for Maintaining the Environments Dev, Test like promoting the Business Objects contents across environments using Import Wizard, creating the BIAR File backups on regular basis etc.,
• Reports are developed for Publications, Financial, Membership, Certification Departments.
• Created universe, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Resolved loops using contexts to remove the cyclic dependencies.
• Created Measure class for measures, and created separate class for conditional objects.
• Defined cardinalities, Checked integrity, Detected loops and resolved them by using aliases and contexts to remove the cyclic dependencies.
• Created complex reports using cascading prompts, decode objects using both full client and thin client reporter.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations, etc.
• Created custom hierarchies which help the end user to drill down to lower levels.
• Extensively used breaks for white spaces and sections for better navigability.
• Created Crystal reports depend upon end user needs.
• Worked extensively with @functions like @select, @prompt, @where and @aggregate aware to write flexible SQL queries.
• Changed List of Values (LOV) in the universe prompts.
• Worked very closely with offshore team to deliver all the interfaces before the deadline.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerters, inserted Calculations, Filters, Sorts, and Query Prompts.
• Converted MS Acess based reports to Business Objects WEBI Reports.
• Created standard full client reports and Improved report response time by tuning BO queries.

Environment: Business Objects XI-R2, Crystal Report XI R2, Informatica 7, MS Access, SQL Server 2005, IMIS, DB2, Personify, SQL Server Mgt Studio, Windows XP, Unix.

Confidential,Chicago, IL Oct 2007 – Nov 08

Sr. Business Objects/ Crystal Xcelsius Consultant.

• Extensively used Business Objects to design and develop various Tabular, cross tab and Chart reports to be used by various User Groups.
• Involved in design and development of universes and reports for different KPIs like OTD, OTS, TU, OAD Etc.,
• Created complex reports using cascading prompts.
• Worked on performance tuning of queries for faster execution of reports on Oracle10g.
• Created complex reports using cascading prompts, decode objects using both full client and thin client reporter.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations etc.
• Created reports using combined queries like Union, Intersection, minus.
• Created Xcelsius Dashboards for logistics department using different chart types and tables on national, regional level.
• Coordinated with offshore team for report deliveries.
• Involved in data mapping session from the SAP BW extractors.
• Created Oracle tables, views for the SAP BW extractors.
• Created a Prototype universe for the SAP BW extractors.
• Involved in testing of data from the SAP system with the legacy data.
• Coordinated with DBA and Business objects designer group in solving various technical issues
• Designed queries in Bex query designer and created workbooks in Bex Analyzer using conditions, structures, calculated key figures, character variables, formula variables and text variables
• Worked with business users for defining reporting needs, help design flexible queries, pre calculated reports using BEX reporting features like variables, conditions, exceptions
• Creation and maintenance of OLAP universes source from BEx queries.
• Writing and editing of SAP BEx queries using Query Designer

Environment: Business Objects XI-R2 /3.0 suite, 6.1a, webi XI, Crystal Xcelsuis 4.5/2008, MS Access, Oracle 10g, SAP BW, Ab Initio, Windows XP.

Confidential,NY Nov’ 06 - Sept’07
Business objects/ Crystal Xcelsius Consultant.

Description: Implementing data warehousing on Xenos, Which is replacing the old legacy system NTAPS. Data warehouse has 12 components of finance trading that includes Reference, EPM, EUC, General Ledger, Accounts Payable, Corporate actions, Brokerage Effects, SLR, Settlements CAM and CAX.

Role:

• Used Import Wizard in migrating the Webi and Crystal Reports into one Crystal Enterprise repository.
• Created Corporate dash board through Dash board Manager, created Metrics and used different analytics in displaying the Business requirement of the company.
• Thorough understanding of different functional components of financial warehouse
• Involved in design and development of universes for different component models like CAM, CAX, TAX, TRD, SLR, Settlement.
• Has Experience in Financial Data created reports based of EPM/FMS data like EPM Attestation and Balances reports
• Worked on Creating Reports on Budgeting/Scheduling/Forecasting using BOXIR1/BOXIr2/Src tool
• Worked as a Business Analyst in gathering Analyzing and Creating Business Specs for creating Report specs
• Created many adhoc/Canned reports based of different Component using Business objects XIR2. WebI was used as the main tool.
• Also Created reports using Crystal XI by using universe or Business view as the data source
• Used Import Wizard in migrating the Webi and Crystal Reports into one Crystal Enterprise repository.
• Used different functionalities of WEBI like Breaks, Sorts, Filters, Merged dimensions, Sections in creating complex reports
• Created Customer Hierarchies and used scope of analysis for drill down of data purpose
• Created Classes, Objects in universe for Oracle andusing Business Objects XiR2 and exported to the repository
• Tested the Universes and Reports in different environments for the data representation and the performance issues.
• Has worked on End user computing and G/L data. Involved in creation of P&L Report.
• Used Requisite Pro software in Creation of Report spec and also Defect tracking.
• Used CVs for Version of Crystal report and EBI for versioning Webi/Deski Reports.
• Fine tuned universes and created new classes/objects to incorporate additional functionalities for report generation
• Created tables to extract model year related cost details from database
• Generated complex reports involving numerous prompts and linking several data providers
• Created complex variables, breaks, sorts, filter and conditions for various reports
• Extensively used extended syntax and complex formula to calculate cost at differing hierarchies
• Designed and created several classes and linked them to existing universes using complex join conditions
• Integrated and upgraded existing reports with added functionalities for comparison and cost-time trend analysis
• Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of comparison reports.
• Used several complex control structures to enhance the functionalities of existing reports.
• Worked very closely with offshore team to deliver all the interfaces before the deadline
• Coordinated with DBA and Business objects designer group in solving various technical issues

Environment: Business Objects XIR1/XIR2, Oracle 10G/9i Web intelligence 2.x/6.x, Crystal Reports XI, intellimatch, SRC, Toad, Informatica, Erwin 4.0, VBA Macros, Req pro, EBI, CVS

Confidential,Columbus, OH July 06 – Oct 06
Sr. Business Objects Consultant

AmericanElectric Power is one of the largest electric utilities firm in the United States, delivering electricity to more than 5 million customers in 11 states. Data ware houses was developed using Informatica as the ETL Tool. Business Objects was used for reporting purposes to identify trends and to facilitate information sharing.

Responsibilities:

• Involved in Full project life cycle (requirement gathering to implementation phase).
• Prepared the Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents.
• Created derived tables at the universe level to reduce the complexity of universe building.
• Specified the standards for universes, Classes, Aliases, Simple and complex objects.
• Created filter objects, and formatted objects and measures within the universe for faster report generation.
• Created Measure class for measures, and created separate class for conditional objects.
• Defined cardinalities, Checked integrity, Detected loops and resolved them by using aliases and contexts to remove the cyclic dependencies.
• Extensively used Designer to design various universes for different business groups.
• Created complex reports using cascading prompts, decode objects using both full client and thin client reporter.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations, etc.
• Created custom hierarchies which help the end user to drill down to lower levels.
• Extensively used breaks for white spaces and sections for better navigability.
• Created template documents with header, footer and company logo.
• Used Broadcast agent for report bursting for different business groups.
• Extensively used Web Intelligence Info view, reporter and explorer for querying, reporting and analysis tasks.
• Used schedule manage to schedule reports on timely basis
• Created reports prototypes using Web Intelligence XI for user presentation.
• Created object level and row level securities in designer using security restrictions option.

Environment: Business objects 6.5.1/XI r2, Web Intelligence 6.5/XI r2, Broadcast Agent, DB2, Informatica Power center 7i, Window 2000 Server

Education: Bachelor of Engineering in Mechanical Engineering.