SUMMARY

• Over 8 years of experience in Information Technology in teh area of Business Objects Developer Suite 4.0/XI3.1/XI3.0/XIR2/6.x/5.x (Infoview, Designer, Desktop Intelligence, Web Intelligence, Central Management Console (CMC), Central Configuration Manager (CCM), Central Management Server (CMS), Import Wizard, Publishing Wizard, and Conversion Tool), Xcelsius 2008/4.5, Live office, QaaWS, Crystal Reports 10/XI/2008.
• Expertise in Designing Universes for Ad - hoc query, canned reporting and analysis using teh Designer Module.
• Experience in creating Universes with measures, dimension objects, Join conditions, Filters, LOV’s, cardinalities, Aliases, Contexts, Hierarchies, @functions, Aggregate Awareness using Business Objects Designer.
• Experience in resolving join path problems like Loops and Traps in teh universes using Aliases, Contexts, and Aggregate Awareness in Business Objects Designer.
• Expertise in creating reports using Business Objects WebI, WebI Rich Client, DeskI and Crystal reports using different Data Sources.
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Experienced in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries, Sub Queries.
• Expertise in building dashboards using Xcelsius 2008/4.5.
• Expertise in linking Crystal Xcelsius to BO Universes using QaaWS and Live Office.
• Expertise in creating standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Experienced in Installation, Administration and upgrading versions of Business Objects in development and testing environments.
• Expertise in Migration of Repositories (universes, Reports, Security, etc) from earlier versions to later versions.
• Extensive experience in using Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , DB2, MS Access.
• Strong Knowledge in designing and developing Data marts, Data warehouse using multi-dimensional Models such as Snow Flake and Star Schema.
• Experience in developing SQL, PL/SQL Stored procedures, packages database triggers and other components of applications.
• Experienced in Planning, Designing, developing and deploying Data Warehouses / Data Marts using different ETL Tools.
• Expertise in gathering, analyzing and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
• Worked with Auditor database, to keep track of user actions performed.
• Excellent interpersonal, communication, analytical and presentation skills.
• Trained users in business objects tools such as Infoview, Xcelsius and Desktop intelligence.

TECHNICAL SKILLS

BI Tools: Business Objects 4.0/XI3.1/XI3.0/XIR2/6.x/5.x, Designer, InfoView, WebI, WebIRich client, Desktop Intelligence, Crystal Reports 10/XI/2008, CMS, CMC, CCM, Import Wizard, Publishing Wizard, Report Conversion Tool, Data Source Migration Wizard, Xcelsius 2008/4.5, QaaWS and Live office.

Database: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , IBM DB2, MS Access 2000, MySQL 5.1, Sybase 12.0, SQL Server 7.0/2000, Teradata.

ETL Tools: Business Objects Data Services (Data Integrator) 12.2/11.7.3 , Informatica 8.0/7.1.

Web Technologies: VBScript, HTML 3.2/4.0, IIS 4.0/5.0, XML, ASP, Dreamweaver 4.0, MS FrontPage, Java Script, Apache 3.0, Tomcat 5.5/6.0, Web logic 9.2/10.3

Languages: C, C++, PL/SQL, SQL, ASP, VB Script, HTML, JAVA, JSP, Shell Scripting

Operating Systems: Unix, Windows 2003/XP/NT/2000/98/95, Sun Solaris, TSO/MVS, MS-DOS

Utilities/Tools: SQL Developer 2000, TOAD, Visio 2003 Professional

PROFESSIONAL EXPERIENCE

Confidential, Ohio

Senior Business Objects Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document teh requirements and translate these to Technical specifications for designing Universes.
• Migrated Business Objects XI R2 content (users/user groups, Universes, reports) in to Business Objects 4.0 environment.
• Used Business Objects Data Integrator for ETL extraction, transformation and loading data from heterogeneous source system.
• Delivered Proof of concept to demonstrate Data Cleansing, Matching and De-Duping.
• Performed ETL activities using Data Integrator XI R2 and Data Services, by extracting data from various Sources.
• Involved in Creating, Updating and maintaining existing Universes based on changes in user requirements and changes in data.
• Involved in creating new and modified existing Hierarchies in teh universes to meet Drill Analysis needs of teh user’s.
• Actively participated in defining Alias tables and Contexts to resolve loops and also tested to ensure dat correct results are retrieved.
• Applied row level and object level securities on different groups and users.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Used Prompts, Conditions to restrict teh data returned by Query and used Filters to restrict teh unwanted data from teh report.
• Involved in developing reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging common objects.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis).
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
• Used Xcelsius for presenting dashboards to end users.
• Created Revenue Dashboards, Sales figure Dashboards using Xcelsius.
• Extensively used excel features like Vlookup, Hlookup, MATCH, INDEX and Concatenate.
• Created interactive reports using different types of selectors with dynamic visibility, drill down and alert features in Xcelsius 2008.

Environment: Business Objects 4.0/XI R2, Xcelsius 2008, Crystal Reports 2008, SQL Server2008/2005, Oracle 11g/10g/9i, TOAD, Web Intelligence, Infoview, QaaWS, Windows 2003 Server/XP, Data Services.

Confidential, Colorado

Sr. Business Objects Developer

Responsibilities:

• Interacted with Users to gather requirements and analyze teh source data, for enterprise data warehouse schemas and provided teh related Mock-ups.
• Worked on installation and configuration of Business Objects XI R3.1 Enterprise suite.
• Upgraded BO XI R2 environment into BO XI R3.1.
• Designed, developed and maintained universes using Business Objects designer.
• Created user defined @prompts and complex conditions at Universe level for better performance.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard and BIAR.
• Developed Xcelsius 2008 Dashboards and integrated them into External Portal Applications using QaaWS and Live Office Connections.
• Created dashboards with multiple hyperlinks to various reports using Open Document Syntax.
• Identifying and Removing Bottlenecks in order to improve teh performance of Dashboards and Reports.
• Integrated Reports, Dashboards to third party external portal with OpenDoc Links.
• Created Web Intelligence Ad-hoc and canned reports using BO XI R3 environment.
• Developed reports using these new functionalities Delegated Search, Smart Measures (Database Delegated), Input Controls, Drop Down filters, Data Tracking and others.
• Created Reports Using Combined Queries, Sub Queries, Slice and Dice, Drill Down, Cross tab and Master Detail Reports.
• Created Alerter, filters and inserted Breaks in designing reports.
• Generated Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
• Used teh Universes, Stored Procedures as source for Business Objects Querying, analysis and reporting.
• Created Complex reports using Web Intelligence in BO XI R3.1 environment.
• Created WSDLs using Query as a Web Service (QaaWS) from different Data sources and implemented WSDLs into Xcelsius dashboards.
• Performed ETL activities using Data Integrator, by extracting data from various Sources.
• Experienced in Tuning SQL Statements and Procedures for enhancing teh load performance in various schemas across databases.

Environment: Business Objects XI R3.1/ XI R2 (Designer, WEBI, Web Rich Client), Crystal Xcelsius 2008, QaaWS, Live Office, Data Integrator XI R2, Oracle 10g, DB2, SQL Server 2005, Toad, SYBASE, Windows Server 2003.

Confidential, WA

Business objects Developer

Responsibilities:

• Migrated Business Objects XI R2 reports to Business Objects Enterprise XI R3.0.
• Used Import wizard to import existing user accounts, groups, categories, universes, reports, connections and universe restrictions to BO XI R3.0 environment.
• Performed Unit, System and Regression testing of teh Business Objects Data Integrator ETL jobs.
• Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into staging area.
• Debugging and testing SQL queries, views and stored procedures in Oracle and SQL Server.
• Worked with teh DBA to create aggregate tables and materialized views to improve teh performance of teh query by cutting down on teh size of teh result set at teh data provider level.
• Created restrictions on objects and classes based on universes privileges.
• Developed universe user documentation guide for teh end users reference
• Worked on Creating teh Crystal Reports from Scratch including teh Requirement gathering from end users.
• Created Reports with multiple hyperlinks to various reports usingOpen DocumentSyntax.
• Schedule Reports by Daily, weekly, bi-weekly and monthly basis and export teh results in Excel and send teh report to teh user thru Email.
• Created contextual links between Crystal reports and WebI documents using open document feature.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Performed tuning on existing reports for better performance.
• Performed unit testing, system testing and user acceptances test (UAT) for universe and reports.
• Created document on usage of Info View for offsite users with no full-client Business Object installed on their machines.
• Experience in training Business Objects end users.
• Created interactive Dashboards using Xcelsius 2008

Environment: Business Objects XIR2/ XI 3.0 (Designer, WEBI),Crystal Report XI, Crystal Xcelsius 2008, Oracle 10g, DB2, SQL Server 2005, Toad, Windows Server 2003.

Confidential, San Jose, CA

Business Objects Consultant

Responsibilities:

• Developed Report Mock-up samples before User interaction to analyze teh business requirements.
• Involved in Installing and configuring Business Objects XI R2.
• Worked in teh Team closely with Functional Architect, DBA and Analysts to get a clear understanding on teh Application.
• Created Derived tables at universe level to resolve report level complexity.
• Developed universes to accommodate complex database design approaches.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Streamlined SQL generation from Universes by implementing Aggregate Aware functions and @Variables.
• Presentation of teh advanced features of Business Objects to end-users to enable them to develop queries and reports easily.
• Created reports using Deski and Webi in BO XI R2 environment using teh BO functions like Master detailed, Drill Down and Prompts.
• Developed Web Intelligence reports for Sales and Sub-Sales reports for Daily, Weekly, MTD and YTD.
• Created and published complex reports using Business Objects Crystal Enterprise XI.
• Applied security features of Business Objects like row level, report level & object level security in teh universe so as to make teh sensitive data secure.
• Created users/groups and defined privileges using Central Management Console.
• Installed Performance Management and created Repository in XI R2.
• Developed dashboards using Xcelsius 4.5 using live office and QaaWS as teh data sources.
• Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.
• Troubleshooting and rectifying Universe, WebI& Live Office errors.

Environment: Business Objects XI R2,Crystal Reports XI, Crystal Xcelsius 4.5, Live Office, QaaWS, Oracle 9i, PL/SQL, SQL scripting and Windows 2000 server, Teradata SQL Assistant.

Confidential, Colorado

Business Objects Consultant

Responsibilities:

• Worked with end users to understand and identify problems in existing reports and collect requirements for teh new ones. Translated user reporting requirements into technical design documents.
• Maintained and improved existing full client reports on Business Objects 5.1 environment.
• Modified existing universes to enhance teh performance of teh reports.
• Worked with DBAs to create aggregate tables and indices; and partition teh data when necessary to improve query performance.
• Created detailed full client reports with multiple data providers, sub queries and calculation contexts where necessary.
• Created teh reports using Universes as a main data provider and using teh Powerful business objects functionalities like @functions, formulas and variables.
• Scheduled various canned reports on daily, weekly and monthly basis through Broadcast Agent in line with teh user requirements.
• Maintained users and groups; and created new ones using Supervisor client tool in accordance with teh existing security model.
• Developed dashboards using Xcelsius 4.5 using QaaWS as teh data source.

Environment: Business Objects 5.1, Oracle 8i, Crystal Xcelsius 4.5, Windows 2000, MS Access.

Confidential

Oracle Developer

Responsibilities:

• Responsible for teh designing teh advance SQL queries, procedure, cursor, triggers, scripts.
• Created and managed high transaction databases including allOracleobjects, triggers, procedures, user right, and functions.
• Responsible for teh fixation of teh errors in data by utilizing teh GUI interface of application and SQL scripting.
• Developed and performed teh quality assurance activities and unit testing.
• Maintained teh documents and create reports for teh business analysts and end-users.
• Responsible for teh management of teh database performance, backup, replication, capacity and security.
• Responsible for teh analyzing and designing of teh softwaredevelopmentlifecycle.

Environment: Oracle 9i, PL/SQL, SQL *Loader, SQL Developer, Windows XP, MS Office.