SUMMARY

• 7 years of IT experience in implementing Data Warehouse applications and Business Intelligence applications.
• Extensively used Business Objects Enterprise Xi3.1/XiR2/Xi/6.5, Informatica Power Center, and SQL Server 2008/2005/2000 , Oracle 10g, Teradata and DB2.
• Expertise in performance tuning of loading the OLTP Transactions and integration of the data into Data Warehouse(EDW) and data marts.
• I was maintained onsite - offshore team development and I had the opportunity to interact with the end user requirements gathering, Data analysis for the report specifications and Universe development.
• Worked on integration of SQL Server, SAP, Oracle, Teradata, XML, Flat file source systems into the Centralized Data Warehouse.
• Installed and configured the Business Objects Enterprise Xi3.1/XiR2 on Windows and UNIX machines.
• Strong experience in Upgrading/Migrating Business Objects from 6.5 to XIR2, XIR2 to XI3.1 and defining the infrastructure, server architecture, capacity planning, virtualization of nodes, high available failover systems, redundant server design and also implementing SSO integration using BO XIR3 features.
• Support and lead administration of BO environment and other BI tools, designing Universe, publishing & Scheduling the reports and dashboards to end users based on their security levels in a BI environment using Central management Console (CMC).
• Designed the universes from the sources SAP BW, Oracle, Teradata and SQL Server.
• Experience on identifying the metrics, Key Performance Indicators for Dashboards development.
• Created OLAP reports, Web I reports, Crystal reports, Adhoc reports and Dashboards.
• Worked on Business Objects 6.5.1, and 5.1: Supervisor, Business Objects Reporter, InfoView, Web-Intelligence 6.5, ZABO and BO Broad Cast Agent Scheduler.
• Experienced in migrating the BO info objects from Dev to test and test to production.
• Implemented Data Cleansing, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
• Designed and implemented the Star Schema/Snowflake schema methods, identifying the dimensions, measures, Hierarchy levels, Fact and Dimension tables.
• Substantial development experience in creating Stored Procedures, PL/SQL, Packages, Triggers, Functions and Query optimization.
• Experience in resolving on-going maintenance issues and bug fixes, and performance tuning of reports.
• I have good communication and user interaction skills and an ability to interpret economic and business logics in data warehousing perspective with a strong understanding of Database design and data architecture principles.

TECHNICAL SKILLS

Databases: Business Objects 5.1.5/6.0/6.5 , XIR2, XI3.1, Web Intelligence, Universe Designer, Desktop Intelligence, Infoview, CMS, CMC

ETL Tools: Informatica Power Center 8.1.1/7.1/6.5 , SQL Server 2000/2005, DTS Packages and SSIS.

Programming: C, C++, SQL, PL/SQL, XML, UNIX Shell Scripting

Data Modeling: Dimensional Data Modeling using Star & Snow Flake schema, Erwin 4.5/4.0/3.5/3.0 and Oracle Designer 2000

Operating Systems: Windows Server 2003/2000/NT/ XP, Solaris 10,UNIX and DOS

PROFESSIONAL EXPERIENCE

Confidential, OH

Sr. BO Developer

Responsibilities:

• Involved in Full life cycle design and development of Business Objects Enterprise Applications.
• Involved in gathering the requirements from Business Managers for reports development
• Designed specification documentation and get the approval from Business Managers about the reports layout.
• Designed and developed Business Objects reports as per the Business requirements.
• Created Classes and Objects (Measure, dimension and detail) in the universe.
• Used Designer Module to implement Universes, Joins between Tables, and created prompts and queries, parsing of Universes, and created Contexts and Alias Tables to remove cyclic dependencies.
• Resolved Chasm traps, Fan traps and Loop problems.
• Designed and Maintained Universes and exported them to the repository.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Created reports using standard company templates. A few of them were created based on the Department requirements.
• Formatted reports as per the user’s requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Gathered report requirements from business end users/clients and assisted business partners in retrieving business information from data warehouse and resolved any SQL query issues.
• Created user Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, and Drill filters.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Used Broadcast Agent for periodic generation and refreshing the reports.
• Used Broadcast Agent Console for monitoring the load on the BCA server and prioritizing the scheduled jobs.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.
• Developed the dynamic and customized prompts based on the hierarchy level information for predictive analysis of the reports.
• Identified the Metrics and sub metrics, Key performance indicators (KPI’s) for Dashboard development.
• Exported the reports and dashboards into centralized database to access them for daily business analysis.
• Created Dashboards to monitor business performance, insightful analytics, and role based dashboards with dashboard manager.
• Managed Users, Groups and their access privileges on the documents.
• Monitoring the daily job scripts for loading the data about business transactions from source systems to EDW
• Created Stored Procedures while generating the reports in CMC.
• Tuning SQL query performance, working with data warehouses, managing metadata, and developing Web services using DB2.

Environment: Business Objects XI 3.1, Central Configuration Manager, Central Management Console, Infoview, WEBi Rich client, Desktop Intelligence, Import Wizard, Xcelsius 2008, Windows XP.

Confidential, OH

Sr.Crystal Xcelsius Developer

Responsibilities:

• Responsible for monitoring daily reports and maintaining all the relevant Universes.
• Developed interactive dashboards using Crystal Xcelsius by importing data from excelsheet.
• Involved in using Crystal Xcelsius to transform Microsoft Excel spreadsheet data into interactive Flash media files.
• Worked with Query as a Webservice for creating webservice queries.
• Used dynamic visibility and bubble chart functionality exclusively as wel as worked with label based menus.
• Involved in using formulas and custom functions like flow-control structures to generate reports using Crystal Reports XIR2.
• Used Performance Manager to build Dashboards and Score cards to provide the users with unique business information.
• Created Metrics Universe to create Dashboards.
• Prepared High Level and Program Specification documents.
• Designed dashboards turning static Excel sheets into engaging data presentations, dynamic charts and graphs, and interactive visual analytics using Crystal Xcelsius.
• Used Trend Analyzer component of Crystal Xcelsius to insert linear, logarithmic calculations into charts, tables at runtime.
• Created Drop Downs, List boxes in dashboards (Crystal Xcelsius) providing User Selection.
• Responsible for gathering the required data and designing the dashboards for the organization metrics from the scratch.
• Involved in creating many components like bar charts, stacked column charts and combination charts.
• Expertise in using Office Excel for formatting the raw data using VLOOKUP, macros and creating pivot tables.
• Extensively used dynamic visibility for different dashboards to make it easier for the end users. Implemented multi level dynamic visibility using Label Based Menu and Radio Buttons.
• Used drill-down functionality for displaying historical data.
• Involved in creating PDF’s and power point slides for presentations.
• Created a lot of single value components like gauge, slider, dial and progress bars.
• Created number of stop light components using bubble charts and expertise in fixing alerts for different types of data.
• Experience in gathering the end user requirements and transforming them into business rules.

Environment: Xcelsius 2008, Query as a Webservice, Business Objects XI 3.1/ XI R2, Central Configuration Manager, Infoview, WEBi Rich client, Crystal reports, Desktop Intelligence, Import Wizard, Oracle, SQL Server 2005, PL/SQL Developer, Windows XP.

Confidential, TN

Business Objects Developer

Responsibilities:

• Designed and developed Business Objects Universes to support the new sales reporting requirements of business users.
• Automated document Scheduling, Publishing and Distribution for WebI and Desktop Intelligence clients, using the Central management Console (CMC).
• Designing and implementation of Universes using Business Objects Designer.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module for generating reports.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Exported the universes to the Repository to making resources available to the users.
• Generated reports using business Objects Report Designer.
• Created parameterized crystal reports and customized existing reports for presentations using Summary reports, Detail reports, Cross-Tab reports and Sub-reports.
• Assigned the privileges to users using Central Management Console (CMC).
• Created and customized application dashboards using Performance management to meet the requirements of higher level analysis.
• Developed dashboards and scoreboards for detailed analysis using Xcelsius 2008.
• Troubleshooting and customization of reports after upgrade.
• Created complex reports by linking data from multiple sources, using functionalities like Slice and Dice, Drill Down, Master Detail, etc.
• Extensively worked with local Repositories, Central Repositories, Job Server and Web Admin client tools.

Environment: Business Objects 6.5.1/XI R2 Central Management Console, Supervisor, Designer, Desktop Intelligence, Crystal reports, Infoview, WEBI, Oracle 9i, PL/SQL Developer, Sybase, SQL Server, Windows 2000.

Confidential, Colorado Springs, CO

SAP Business Objects Developer

Responsibilities:

• Designed Universes by defining joins, cardinality between tables, linked the existing Universes using BUSINESS OBJECTS 5.1.
• Developed complex universes by using advanced features like aggregate aware, Conditions and hierarchies to Perform linking of universes by Kernel method to optimize the universe development and performance improvement.
• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Develop the Dashboard presentation using the Business Objects and Crystal Xcelsius.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created complex reports using multiple queries and involved in tuning the reports in order to increase the accessing speed.
• Published existing reports to corporate intranet through Web Intelligence.

Environment: Business Objects 5.1, SQL Server, Broadcast Agent, Xcelsius, Oracle 8i, PL/SQL, Info View, Application foundation, Tomcat 4.x, Apache, Windows 2000.