SUMMARY

• 7+ years of IT experience in Data Warehousing, Business Intelligence using Business Objects XI 3.1, BO Designer, DeskI, InfoView, WebI, Performance Management, Crystal Reports, Xcelsius, Query as a Web Service (QaaWS), ETL, Data Services XI 3.1, Informatica power center tools, Oracle 11g/10g/9i/8i, SQL Server 2008/2005, MS Access.
• Good experience in planning, building, and managing successful large - scale BI Data Warehouses and decision support systems.
• Hands-on experience in Installation, Migration and Administration of Business Objects XI 3.1 and previous versions.
• Experience in Developing, Maintaining & Modifying Universes using Business Objects Designer.
• Worked extensively with Business Objects functionalities like Alerts, Filters, Query Prompts and Drill filters and worked with multiple data providers.
• Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc.
• Design, develop, optimize and maintenance of BI Data Integrator jobs.
• Integration of Business Objects Data Services with SAP and Non SAP Data Sources like Oracle 11g, 10g, 9i, 8i SQL Server, DB2, and Sybase
• Good Exposure to Business Objects Architecture, Crystal Reports Server and .Net Components.
• Expertise in Creating Reports and Sub Reports using Crystal Reports XI.
• Designing Effective Report Templates and Custom Formatting Techniques in Crystal Reports.
• Expertise in Performance Manager and Dashboard manager, creating Metrics and Analytics in dashboards according to requirements.
• Experience in deployment of Crystal Reports XIR2. From Various Sources Oracle, TeraData, MS SQL Server, DB2, Sybase and Access
• Extensive experience in Performance Tuning and Query Optimization, Optimizing universe through Linked Universes, Aliases and Contexts.
• Developed Ad-hoc reports, scheduled Reports and administered BO activities.
• Excellent understanding of OLTP & OLAP, Star Schema & Snow-flake Schema.
• Created Reports using Query as a Web Service (QaaWS). Experienced in Developing and implementing Live Office connectivity to BO.
• Developed Xcelsius dashboards for presentations, live data dashboards with alerts, Calculators, Historical data comparisons.
• Worked step by step with various businesses to gather, analyze and document data.
• Experience in diversified project sectors such as Insurance, Telecom, Manufacturing and Pharmaceutical.
• Excellent leadership, communication skills with impressive analytical and multi-tasking abilities.

TECHNICAL SKILLS

Business Intelligence: Business Objects (XI 3.1, XI 3.0, XI R2), Supervisor, Designer, InfoView, WebI, DeskI, BI, QaaWS, Report conversion Tool, Broadcast Agent Server, Crystal Reports (XI/10/2008), Xcelsius 4.5/2008.

Data Warehousing and ETL: Universe Design, Fact and Dimension Table Design, TOAD, Datamart, Erwin/ Data modeling, Data Services and Informatica PC 8.6.0.

Database: Oracle (8i/9i/10g/11g), SQL Server (6.5/7.0/2000/2005), MS Access (2000/2002), MySQL.

Programming: C, JAVA, UNIX/shell scripting, PL/SQL, and HTML

Operating Systems: windows 7, windows 2000, windows 95/98, Vista, UNIX.

Packages: MSOffice

PROFESSIONAL EXPERIENCE

Confidential, CA

Business Object Consultant

Responsibilities

• Installed and Deployed BO XI R3.1 for teh Finance system as well as InfoAdvantage Application system.
• Migrated set of existing Finance reports from BO 6.5 to XIR3 using teh Import Wizard.
• Converted Reports from BO Desktop Intelligence XI R3 to Web Intelligence XI R3 Report
• Imported User/Group profiles from BO 6.5 to BO XI R3 and Authenticated User security Rights appropriately.
• Gatheird user requirements for Advantage 3.8 Application to development in Web Intelligence XI R3 reports
• Installed Business Objects patches, hot fixes & new releases
• Trained end users on using Infoview (Webi) for Adhoc reporting.
• Extensively used Calculations, Variables, Break points, and Sorted inputs. Drill Down, Slice and Dice, Alerts for creating Business Objects reports.
• Resolved loops and chasm traps in universes by creating table aliases and contexts.
• Extracted Data using SQL and performed Unit testing and helped teh client in user acceptance testing (UAT).
• Developed several Complex Reports, various features include multiple groupings, drilldowns, parameter fields, functions, Type Conversions, formulas, Running Totals and conditional suppressing, formatting using Crystal Reports
• Involved in performance testing of all teh reports, which helped in analyzing its performance before moving into production.
• Ran SQL scripts using Control Center (DB2 database) for data validation of BO reports.
• Comparing data from COBOL Mainframes and transforming data into ETL Data Integrator to DB2
• Created new mappings and updated old mappings according to changes in Business logic
• Performed major role in understanding teh business requirements and designing and loading teh data into data warehouse (ETL).
• Used ETL (Data Integrator) to load data from source to destination.
• Used Data Integrator client tool for defining Source & Target definitions and coded teh process of data flow from source system to data warehouse.
• Implemented Slowly Changing Dimensions - Type me & II in different mappings as per teh requirements.
• Used Business Objects Web Administrator to schedule and monitor ETL Jobs.
• Used Debugger to troubleshoot teh mappings
• Successfully installed Business Objects products on windows platform.
• Designed Universes, incorporating all teh business requirements
• Created BIAR file for repository Backups using Import Wizard.
• Webi Reports were created and deployed through Info View.
• Installed Business Objects patches, hot fixes & new releases.
• Trained teh users in Business Objects and in using teh newly developed universe and in Report writing (Web Intelligence) by Using Query Panel, Slice & Dice, Drill functions, Formatting teh reports, Managing documents using InfoView etc.

Environment: Business Objects XIR3 (CMC, InfoView, Designer, Web Intelligence, Desktop Intelligence, ETL, DB2 Database, Windows NT.

Confidential, Boston, MA

Business Objects Consultant

Responsibilities:

• Involved in requirement gathering from Business Users & Teams and translated teh Functional requirements to Technical requirements & specifications.
• Designed Business Objects Universe based on teh XI Repository and developed Business Objects reports and Crystal Reports.
• Developed Complex Reports that involved multiple data providers, Master/Detail charts, cross tab charts, complex variables and calculation contexts.
• Customized Dashboards with various metrics and Analytics and by defining goals and metric trends.
• Used teh platform and data integrator transforms as a part of mapping.
• Migrated Business Objects XI R2 content (users/user groups, Universes, reports) in to Business Objects XI 3.1 environment using teh Import Wizard.
• Creating reports using Crystal Reports with BO universe as Data source.
• Created Prompts, conditions and Filters to improve teh report generation. Also used Alerters to improve teh readability of teh report.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality
• Created jobs, Workflows and Dataflow
• Scheduled Business Objects documents for automatic refresh and to different destinations.
• Created variables, @prompt (Interactive objects), formulas etc.
• Extensively used Variables, Drill down, Slice and Dice in teh creation of reports.
• Created Hierarchies for providing drill down options to end-user.
• Exported teh universes to teh Repository to make resources available to teh users.
• Created both full client and WebI Reports in XI 3.1 based on teh business requirements and Modified required Reports by adding new columns based on teh result set.
• Logged defects and submitted change requests using defects module of Test Director.
• Provided end user support for production reports and program data guidance to management for decision making.

Environment: BusinessObjectsXIR3/XIR2, Web Intelligence, Info View, Designer, DeskI, Oracle 10g/9i, SQL Server, DB2, QaaWS, Report Conversion Tool, TOAD, Windows and UNIX, Crystal Reports, Xcelsius.

Confidential, Dallas, TX

Business Objects Consultant

Responsibilities:

• Involved in dimensional modeling of teh data warehouse to design teh business process.
• Extracting data, transformed and loaded into Oracle database according to teh specifications.
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier/Joiner on data and extracted according to teh business rules and technical specifications.
• Created teh Local Repositories, Central Repositories, Profiler Repositories in Oracle 10g and configured teh Local, Profiler repositories with Job server and Management console.
• Worked with Slowly Changing Dimensions.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Improved teh performance of teh mappings using various optimization techniques.
• Performance tuning of teh ETL - by utilizing dynamic cache for Lookups partitioning teh sessions.
• Designed and Developed existing Impromtu reports in Crystal Reports Developer 8.5
• Configured and trained users to use Crystal Reports 8.5 developer.
• Tipped teh developers with tricks in crystal reports development.
• Developed jobs to load teh SAP R/3 tables into staging area and developed transformations that apply teh business rules given by teh client and loaded teh data into teh target database.
• Based on teh requirements, extracted teh data from ECC 6.0 and loaded into BW 7.0 using Data Services XI R2 SP1 as an ETL tool.
• Developed/modified Universes based on requirements from end users; created Objects including Dimensions, Details and Measures; created Hierarchies to provide drill down functionality to end-users.
• Created new Universes and linked with teh existing Universes.
• Created reports using Universes and Free hand SQL as Data providers.
• Built Full Client and WEBI reports, developed Trend Analysis Reports and Comparison Reports with drilling capabilities for teh end-user to generate ad-hoc reports.
• Analyzed reports using Slice and Dice, Drill Up/Down, Cross tab, Master Detail, and Formulas.
• Created Aggregate Tables wherever necessary.
• Created Test Scripts to ensure in-depth functionality of Reports; tested reports based upon data generated by Enterprise Transaction and Customer Information systems.
• Extensively used context and alias to solve teh loops.

Environment: BusinessObjectsXIR2/3.1, WebI, MS SQL Server, Oracle 10g/9i, PL/SQL, Crystal Reports, Crystal Xcelsius, UNIX.

Confidential, Woonsocket, RI

Business Objects Consultant

Responsibilities:

• Worked on migration of BO version XIR2 to 3.0 providing all groundwork including installation and upgrade.
• Created Users/Groups/Sub-Groups and assigned profiles to restrict unauthenticated access to resources.
• Created initial Classes & Objects for Universes in both on/off line modes.
• Designed and built universes.
• Implemented Slowly Changing Dimensions - Type me & II in different mappings as per teh requirements.
• Used Business Objects Web Administrator to schedule and monitor ETL Jobs.
• Used Debugger to troubleshoot teh mappings
• Successfully installed Business Objects products on windows platform
• Created hierarchy and conditions in teh universes.
• Involved indesigning Universeand migrating existing adhoc ‘Crystal Reports Explorer 11’ to WebI
• Designed, developed and tested reports based upon data generated using Business Objects 6.1.
• Created reports using Business Objects functionalities like Queries, Slice & Dice, Drill down, @Functions, Formulae etc.
• Used Broadcast Agent and WEBI, BCA Console, Admin Console.
• Created links in BO reports to link summary and detail reports using open document syntax.
• Created Full Client reports using different Data providers like Oracle, MS-Excel, and MS-SQL server.
• Created Unit Test Case’s and Tested in different Enviornments (Dev, Test, Prod).

Environment: Business Objects 3.0, Broadcast Agent, WebI, Oracle8i PL/SQL, Crystal Reports.

Confidential, OH

Business Objects Consultant

Responsibilities:

• Involved in gathering and analyzing End User and Business Owners requirements, user interviews and drafting end users specifications and Business Intelligence needs.
• Designed, implemented and deployed some highly complex Business Objects Universes.
• Worked on universe performance issues, rectifying loops and in correct joins.
• Created classes, objects, Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving Loops and checked teh Integrity of teh Universes.
• Teh scope of teh reporting systems included manufacturing materials management, finance and cost accounting.
• Optimized and Tuned Reports performance by Analyzing tables, Checking Optimizer Modes and Partitioned tables
• Used SQL Query’s to generate business objects reports using free hand SQL as a data provider.
• Involved in QA phase to test teh Classes, Objects and Reports.
• Prepared documentation including requirement specifications.
• Designed teh Data Mart model with Erwin using Star Schema methodology.
• Creating Dimensions and Facts in teh physical data model.
• Documented teh metadata to capture from teh sources
• Created Sessions and batches to extract teh data.
• Involved in teh creation of jobs using work flow manager to validate schedule run and monitor teh jobs.
• Involved in designing teh procedures for getting teh data from all systems to Data Warehousing system.
• Used teh Power centre Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Wrote Unix Shell Scripts to automate teh process.

Environment: Windows NT, Oracle 7i, SQL, SQL*Loader, SQL Server, Erwin 3.5.