SUMMARY

• Over 8 years of experience in Information Technology in the 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 the 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 the 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

Sr. Business Objects Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the 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 the universes to meet Drill Analysis needs of the 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 the data returned by Query and used Filters to restrict the unwanted data from the 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 the source data, for enterprise data warehouse schemas and provided the 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 the 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 the 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 the 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 the 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 the DBA to create aggregate tables and materialized views to improve the performance of the query by cutting down on the size of the result set at the data provider level.
• Created restrictions on objects and classes based on universes privileges.
• Developed universe user documentation guide for the end users reference
• Worked on Creating the Crystal Reports from Scratch including the 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 the results in Excel and send the report to the 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 the business requirements.
• Involved in Installing and configuring Business Objects XI R2.
• Worked in the Team closely with Functional Architect, DBA and Analysts to get a clear understanding on the 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 the 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 the 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 the universe so as to make the 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 the 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 the 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 the performance of the reports.
• Worked with DBAs to create aggregate tables and indices; and partition the data when necessary to improve query performance.
• Created detailed full client reports with multiple data providers, sub queries and calculation contexts where necessary.
• Created the reports using Universes as a main data provider and using the 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 the user requirements.
• Maintained users and groups; and created new ones using Supervisor client tool in accordance with the existing security model.
• Developed dashboards using Xcelsius 4.5 using QaaWS as the data source.

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

Confidential

Oracle Developer

Responsibilities:

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

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