Experience Summary
8 + years of IT work experience, including 7 + years of Business Intelligence and data warehousing experience in building Business Objects universes, developing reports, and analyzing OLAP data.

• Proficient experience in design and development of Universe. Expert in creating Classes and Objects for Universe based on the warehouse schema.
• Experience with multiple RDBMS including Oracle, SQL Server, DB2 and Microsoft Access and associated SQL Dialects such as T-SQL, SQL PL and PL/SQL.
• Well experienced in writing Complex queries, stored procedures, functions and packages using PL/SQL Programming.
• Technical hands-on experience in creating Business Objects Web Intelligence and Desktop Intelligence reports using Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expertise in CreatingXcelsiusDynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge onXcelsiusDashboard Components like Charts, Selectors, Tabsets, Canvas Containers
• Designed & Developed Crystal Reports such as List reports, Parameterized reports, Form Letter, Mail Label, Sub Reports, Cross tab reports based on base tables, views, Business views, Commands, Universes and Stored Procedures involving formulas, sub totals, running totals and sub reports.
• Developed interactive dashboards and data presentations from Excel spreadsheets and other data sources using Xcelsius 2008.
• Excellent experience in Scheduling Reports using Info-View Portal.
• Technical hands-on experience using Business Objects components like Designer, CMC, Web intelligence rich client, Desktop Intelligence, Info view, Import Wizard, Publishing Wizard and Query as a Web service. Excellent knowledge on BO XI Architecture and new features.
• Experience of using BO Data Integrator XIR2. Loaded data (FACT Tables, Dimension Tables) into data marts. Extensively used Data Integrator Designer.
• Involved in the administration of Management Console for implementation of security at Report level, Folder level and object level by assigning rights and required access level as per business requirement. Created Users, user groups, roles and assigned required rights to them.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Sound Business knowledge in several functional areas including Banking, Insurance, Finance, Human Resources, Health care, Materials Management and Marketing.
• Excellent ability in writing specifications and gathering requirements from the user and maintaining proper documentation for future reference.
• Excellent communication and strong intrapersonal skills with ability to interact with end-users, managers and technical personnel. Having good knowledge on OOPS concepts and RDBMS.
• Quick learner and Interested in learning new technologies

Technical Proficiency

Reporting Tools: Crystal Reports 2008/XI R2/XI/10.0, Crystal X-Celsius
Performance Management, Web-Intelligence, and
SQL Server and Reporting Service (SSRS).
BI Platform: Business Objects XI 3.0/XI R2 /6.5/6.0/5.1.
ETL: Business Objects Data Integrator XI, Informatica.
OLAP Tools: Designer, Info View, CMC, Report Conversion tool, Import Wizard and Voyager
Databases: SQL Server (2005/2008), Oracle (10g/9i/8i), DB2 8.1, MS-Access.
Data Warehouse Solutions: SAP BW 3.5/ BI 7.0.
Operating System: Ms-DOS and Windows Vista/XP/NT/2000/98/95.
Programming Languages: C, C++, Visual C++, SQL and T-SQL.
Web Server: Windows 2000/2003 Server and MS SQLserver 2000/2005.
Scripting Languages: XML, HTML, VBScript and Jscript.
Other Tools: MS Word, MS Excel, MS Access, Toad, Crystal Viewer, Visual Source Safe, HP Quality Centre 10.

Professional Experience

Confidential,
NJ
Business Objects Developer Feb’11 – Till Date

Pearson is the world\'s leading education company. From pre-school to high school, early learning to professional certification, our curriculum materials, multimedia learning tools and testing programs help to educate more than 100 million people worldwide - more than any other private enterprise.

Theworld-famous Penguin brand is the label of quality from novels and classics to cookbooks - and much more - around the world. We publish an unrivalled range of fiction and non-fiction, bestsellers and classics, children\'s books and illustrated reference treasure chests in over 100 countries.

Roles & Responsibilities:

• Involved in Multiple projects depending on the RFS (Request For Service) received form the users.
• Developed Universes Using Universe Designer in XI R2.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae etc.
• Involved in all Analysis, Development, Testing, Tuning and Maintenance, as well as resolved problems during implementation.
• Developed Xcelsius presentations/visualizations for profitability Analysis, Distributor Sales Analysis, Monthly Sales Analysis, Forecasted Sales What if Analysis
• Interactive visualizations were made for executives to visually evaluate different scenarios by adjusting key variables
• Updated data for crystal Xcelsius visualizations by using export setting commands. Complex data was retrieved from excel files, Flash files using Flashvars property as well as dynamically from external XML data sources
• Created complex Xcelsius dash boards to reflect User Adoption Metrics
• Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and XML files
• Created various simple and complex reports using drill down/up, slice and dice, breaks, filters and alerts.
• Created reports using free hand SQL when the existing universe has not supported the report
• Written PL/SQL programs on Oracle Database. Performed performance tuning.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Wrote SQL Scripts to create, alter, and drop database objects, like tables, views, and sequences
• Scheduled reports for user as requested in Business Objects InfoView Portal and created recurring instances of the report to run on Daily/Weekly/Monthly basis and exported reports into various formats like PDF, HTML, EXCEL and WORD.
• Documentation for moving Business Objects from XI R2 to XI R 3.1.

Environment: Business Objects XI R2, Desktop Intelligence, Web Intelligence, Info View, Xcelsius, TOAD.

Confidential,
TN Feb’10 – Feb’11
Sr. Business Objects Developer

Smith and Nephew is a global based health care company. Smith & Nephew designs and develops advance medical devices to help provide effective treatment by surgeons and other medical representatives around the world. Biologics Analytics Reporting is a project to develop reports on Finance, Billing and AR cubes in SAP BW using Business Objects. Global Market Monitor is a project to compare the growth of Smith & Nephew to its competitors worldwide using Business Objects WebI and Xcelsius for dashboards.

OIV Ortho Inventory visibility is a prototype project where we have analyzed inventory data for our various locations and also calculated work of cost of sales (WOCOS) in order to determine inventory VS sale trending and presented that in an Xcelsius dashboard

BI Efficiency is a project on the servers where we have created a new cluster for a new VM instance in order to improve the user request from on-demand users.

Roles & Responsibilities:

• Interacted with Business Users, Database Team to know their requirement in developing and updating universes.
• Responsible for providing the impacts, and risks on the upcoming requirements.
• Created Universe after the XIR3.1 upgrade, so the canned reports work without incompatible error.
• Involved in the development of various complex ETL packages using ETL tools such as DI (Data Integrator)
• Converted Webi reports from the Deski Reports using Report Conversion tool in Business Objects XI R2.
• Documented procedure for the whole team, participated in creating Functional Users guide.
• Created functional specifications from the Business Requirements Document.
• Analyzed the pro’s and con’s of Business Objects XI R2 vs Business Objects 6.5.
• Created reports in XI R2 to test functionality.
• Created reports with Multiple Data Sources, Drill Down, Slice/Dice and Charts.
• Developed Xcelsius dashboards based on business requirements using QAWS (Query as a Web services).
• Created complex Xcelsius dash boards by connecting directly with multiple data sources.
• Created complex Xcelsius dash boards to reflect User Adoption Metrics
• Provided the solution for xcelsius Dashboards for Clients Inpatient and Outpatient Business Lines for their Healthcare Domain.
• Scheduled reports in Business Objects Info View Portal and created recurring instances of the report to run on Daily/Weekly/Monthly basis and exported reports into various formats like PDF, HTML, EXCEL and WORD for user as requested
• Created new Business Objects Users and User Groups using Business Objects
• Involved in defining Security roles for Users and User Groups, and assigned different privileges to users depending on their profile.
• Designing multiple Universes for user Reporting.
• Extensively used Import wizard to migrate Universes and Reports between Development, Test and Production Environments.
• Involved in providing the complete Business Objects XiR2 reporting solution and during the course of action have build Universe using Designer, Business views using Business View Manager, Analytical reports using Desktop Intelligence and Webi.
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Variables, Break, Alerter.
• Imparting training the end user in basic and advanced Ad Hoc reporting as well as creating queries, formatting results, and share them with others using Web Intelligence.
• Involved in System Test, User Acceptance Test.

Environment: Business Objects XI R2/R1, 6.5, Web Intelligence, Desktop Intelligence, Crystal Reports XI R2, SSIS, Xcelsius, Qaaws, Oracle 10g, MS SQL server, HP Quality Centre 10, Windows NT.

Confidential,
Mar’09 – Dec’09
Sr. Business Objects Developer

UBS Wealth Management Research (WMR) offers various research reports on the Commodity markets like, market outlooks and price forecasts, explanations of key drivers, such as geopolitical, macroeconomic and industry factors, educational reports on commodities investing and reports on individual commodities.
Primary role in this project was to identify and analyze the business requirement, gathering user requirement, and deployment.
Roles & Responsibilities:

• Designed and developed new Universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Creating Classes and Objects.
• Resolved loops by creating Aliases and Contexts and checked integrity of universes.
• Created Filters, @prompts and setup Hierarchies for Multidimensional Analysis.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Generated Web Intelligence and Desktop Intelligence Reports using the Universe as the main Data provider. Applied Sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks.
• Worked extensively with the major functionalities of Business Objects like Alerter, Group By, Query Prompt, Drill Filter, Indexes, Breaks, Sorts, Ranking, and Calculation using the Slice and Dice panel.
• Designed, developed and published the reports using Crystal Reports XI with Standard, Summary, Cross Tabs, SQL, Command Objects, grouping and sub reports.
• Created Stored Procedures, Views and Functions using SQL Server 2000 and Oracle 10g.
• Created easy-to-understand dashboards using crystal Xcelsius to deliver complex company data.
• Scheduled the Crystal Reports using CMC.
• Developed universe user documentation guide for the end users reference.
• Involved in System Test, User Acceptance Test.
• Provided training for end users for generating their own report including complicated report.

Environment: Business Objects Enterprise XI R2, Windows XP, Designer, Desktop Intelligence, Web Intelligence, Crystal reports XI, CMS, SQL Server 2000/2005, MS Access, DB2 and Oracle 10g.

Confidential,
Apr’08 – Mar’09
Sr. Business Objects Developer

Samsonite is the leading manufacturer of luggage in the world and the top seller of luggage in the United States, Europe, and Japan. In addition to its world-renowned Samsonite label, the company also markets the popular American Tourister brand. Under those names, Samsonite offers a full line of luggage, including softside and hardside suitcases, garment bags, casual
bags, business cases, and other travel bags and accessories.

Roles & Responsibilities:

• Involved in Creating Users and User Groups and assigned different privileges to them depending on their profile.
• Analyzed the required data elements, Source Applications reporting package group in different departments like operations, Management.
• Created Different Universes for separate reporting requirements which run against Teradata Database.
• Created classes and objects and gave business names and logically grouped them together.
• Resolved issues like Loops, Fan Traps & Chasm Traps by creating Aliases, Derived Tables and Contexts as required in removing the cyclic dependencies.
• Used different business objects @functions like @select, @where, @prompt.
• Created Full Client reports using different Data providers like Teradata, Excel sheets, SQL server, Oracle.
• Extensively used slice and dice for generating master/detail and tabular reports.
• Created Reports from Excel files using Business Objects through Personal data files.
• Utilized various crystal reports features including conditional formatting, use of multiple groups and group sorting, parameter passing using dynamic and cascading prompts and complex formula usage.
• Created the connectivity to business Objects from Teradata Production Data base.
• Published the Reports generated by the user in Info View for reusability by different users.
• Created metrics and included them in the dashboards in Webi by using predefined analytic templates.
• Created Detail Design Documents & Trained users at different levels of Report Creation.
• Involved in System Test, User Acceptance Test.
• Exported reports into various formats like PDF, HTML, and EXCEL for user.

Environment: Business Object 6.5.1/XI R2, Broadcast Agent, Web Intelligence (CMC, CCM, Designer, DeskI, WebI, InfoView), Crystal Reports 10.0, MS-Excel, Windows NT/2000 Professional, Teradata.


Confidential,
DetroitJun’07 - Mar’08
Business Objects Developer, Support Developer

General Motors Corp., the world’s largest automaker, has been the global industry sales leader since 1931. Founded in 1908, GM today employs about 321,000 people around the world. It has manufacturing operations in 32 countries and its vehicles are sold in 200 countries.

• Developed Universe using Designer module in Business Objects.
• Deployment of Business Objects on clients as well as server products.
• Established user groups and users and assigned privileges.
• Ad-hoc reports were used for Business Objects User modules for various Portfolios using the Universes as the main Data Providers.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae etc.
• Involved in all Analysis, Development, Testing, Tuning and Maintenance, as well as resolved problems during implementation.
• Created CrystalXcelsius dashboards using excel and universe as data source.
• Created Drill Down dashboards using CrystalXcelsius.
• Created Crystal Xcelsius dashboards using charts, bars graphs, selectors and maps and exported to InfoView.
• Involved in System Test, User Acceptance Test.
• Involved in providing the support to end-users during the warranty period.
• Troubleshooting production problems and worked effectively with other team members to identify and address problems.

Environment: Business Objects 5.1, Broadcast Agent, Web Intelligence, Erwin, Oracle, Informatica.

Confidential,
VA Jun’06 – May’07
Business Objects Developer

Nextel Communications, Inc. provides wireless communications services in the United States. The company provided service to approximately 16.2 million subscribers. It offers its services primarily to small, medium, and large businesses; government workers; and individuals through its sales force and indirect sales agents, which consist of local and national nonaffiliated dealers. The project involved working as a complete Business Objects Professional with Supervisor/Designer/ Reporter responsibilities as well as involved functioning as an analyst. I was Involved actively in creating universes, generating queries and testing the queries for data integrity.

Roles & Responsibilities:

• Designed, developed and tested business objects reports.
• Created and maintained Universes using Designer.
• Was involved in reporting crucial data to the top management using Web based reports. Accomplished the report deployment using Web Intelligence.
• Created Hierarchies, complex objects using various @functions, aliases, contexts, Aggregate objects in the universe.
• Worked with Power Center -Designer tool in developing mappings and Mapplets to extract and load the data from flat files, Oracle, SQL Server 2000
• Involved in gathering the requirements to create the reports by conducting user interviews.
• Created various simple and complex reports using drill down/up, slice and dice, breaks, filters and alerts.
• Created reports using free hand SQL when the existing universe has not supported the report
• Provided training to the users, developed user guides, training docs, requirement docs etc.
• Written PL/SQL programs on Oracle Database. Performed performance tuning.
• Maintained Supervisor by creating user accounts and assigning privileges.
• Worked on Info view and generated Business Objects Web Reports using Web Intelligence to handle web based queries.
• Resolved loops in universes with multiple look-up tables using contexts. The universe was extensively tested for chasm traps and Fan Traps.
• Troubleshooting production problems and worked effectively with other team members to identify and address problems.

Environment: Oracle 9i, Business Objects 5.x, Web Intelligence, ZABO, PVCS version control system, Win 2000, Erwin, Data Stage, PL /SQL,SQL Server 2000.

Confidential,
Oregon Aug’05 – May’06
Business Objects Developer

The business purpose of this application is to Request New data code, Request new description for an existing data code and request for Status rules update on existing data code. Users of freightliner and Engineering department use this application to modify and create data codes on IMS.

Roles& Responsibilities:

• The project involved development of library of reports using Business Objects (BO) to cater the Engineering ad-hoc reporting needs. It required extensive interaction with the users and the management in the collection of information for their reporting needs. Created the reports using BO functionalities such as drill down reporting, slice and dice, master-detail reporting, sorting etc.
• Involved in the design and development of Universes, Classes, Objects and Conditioned Objects for Business Analysis and Report Generation
• Used different functionalities of Universe such as Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes
• Exported reports to the Broadcast Agent (BCA) and used BCA server to schedule, monitor and publish the reports
• Involved in BO Administration - authenticate users, provide privileges, and make resources available to users through repository
• Involved in creation of stored procedures and VBA procedures to retrieve the data faster and generate the reports quickly.
• Involved in training users in Business Objects
• Provided complete documentation and presentation at the end of the contract to help users in developing various reports using different functionalities and methods used in creation of reports.

Confidential,
DE Sep’03 – Jun’05
Data warehouse Consultant

Incyte is a Wilmington, Delaware-based drug discovery and development company with a growing pipeline of novel small molecule drugs. Incyte is a leader in the pharmaceutical industry. Data warehouse is designed specifically for the needs of the corporate secretary. With this Data Warehouse, you can eliminate most tedious and repetitive corporate management duties.

Roles & Responsibilities:

• Designed Universes in two phases, the first phase involved in creating the structure like tables and columns of a database joined by joins and also resolving the loops with aliases and contexts. The second phase involved in enhancements of universe like complex classes, objects, joins or conditions.
• Created reports from various Universes using different Business Objects functionalities and Data from different source systems put in a centralized database for this system.
• Designed and developed extensive Business Objects reports, including complex reports using multiple queries, combination chart and tables, setup of Business Objects Universe for each reporting group Assist in establishing a Business Objects environment.
• Worked with the customers to resolve various issues associated with the reports.
• Analyzed, Designed, Built and Tested reports while working directly with end-users and technical members of the team.
• Created canned and ad-hoc reports and charts using Business Objects reporter module.
• Involved in formatting the reports to the users requirements using all the functionalities in Business objects like Slice and Dice, Drill Down, @Functions and Formulas.
• Created Master/Detail and Cross Tab reports to view the data in an analyzed way.
• Good experience in working with Ranks, Alerters, Filters, Prompts and Grouping variables and User Objects on reports.
• Scheduled and monitored reports using Broadcast Agent (BCA).

Environment: Business Objects 5.1(Supervisor, Designer, Reporter, ZABO, Broadcast Agent, Application Foundation) Oracle 8i and TOAD.

Confidential,
India Nov’02 - Aug’03
Oracle PL/SQL Developer

BHEL, India had implemented Inventory Management System in its various plants. The aim of this project was to enhance certain modules of the inventory management system for BHEL

Roles & Responsibilities:

• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Wrote SQL Scripts to create, alter, and drop database objects, like tables, views, and sequences
• Created stored procedures, triggers, and functions to retrieve data from the database using PL/SQL
• Developed SQL Applications for extracting the data from the Oracle tables
• Created user defined Exceptions while Handling Exceptions
• Involved in complete documentation using MS Office
• Troubleshooting production problems and worked effectively with other team members to identify and address problems.

Environment: Oracle 7i, PL/SQL, Reports 2.5, SQL plus 3.1