Experience profile:

• Total IT Experience: Seven Years
• Business Objects Enterprise XI3.1/XIR2/6.5/5.1: Six Years
• Report Development: Five years
• Universe Design: Five Years
• Performance management, Dashboard Manager, Xcelsius: Three years
• Data Modeling (Star Schema, Snowflake Schema & Datamarts): Three years
• Database (Oracle 10g, SQL Server 2000/2005, Teradata­, DB2, SAP BW): Seven years­­­­­­

Summary:

• 7 years of IT experience in implementing Data Warehouse applications and Business Intelligence applications.
• Extensively used Business Objects Enterprise Xi3.1/XiR2/6.5/5.1,SQL Server 2008/2005/2000, Oracle 8i/9i/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.
• Coordinated with onsite-offshore team development and interacted 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.
• 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, Webi reports, Deski reports, Webi Rich Client reports, Adhoc reports and Dashboards.
• Experienced in migrating the BO info objects from Dev to test and test to production.
• 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.

Technical SKILLS:

Reporting Tools:Business Objects XI3.1/R2/6.5/, Web Intelligence, Universe Designer, Desktop Intelligence, Infoview, CMS, CMCDatabases:Oracle10g/9i/8i, MS SQL Server, IBM DB2, Teradata V2R6/V2R4, Sybase 12.0/11.x, PL/SQLProgramming:C, C++, SQL, PL/SQL, XML, UNIX Shell ScriptingData Modeling:Dimensional Data Modeling using Star & Snow Flake schema, Erwin 4.5/4.0/3.5/3.0 and Oracle Designer 2000Operating Systems:Windows Server 2003/2000/NT/ XP, Solaris 10,UNIX and DOS

Project Experience:

CLIENT: Confidential, MA Apr’10 - Present
Role: Sr. Business Objects 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.
• Developed Xcelsius 2008 Dashboards on top of QaaWS and Live Office connections.
• Created Universe for Ad-hoc and Canned Reporting purpose based on DDL.
• Used dynamic visibility and Excel functions to control and manipulate the data.
• Implemented Open Doc to drill down to detail webI report from Xcelsius Dashboard.
• Exported Xcelsius to repository to make it available for users through info view.
• Used relative path URL to migrate Xcelsius Dashboards from one environment to other Environment.
• Created WSDLs using Query as a Web Service (Qaaws) from different Data sources and implemented WSDLs into Dashboards.
• Widely Used several components like Charts (Line, combination, column, stacked, pie, and area charts), Selectors (According menu, check box, combo box, List views, scorecards with alerts and spread sheet table ), Single value (dials, Gauge and progress bars), Others (calendar and Print), Background to show charts and tables in reflective colors and URL buttons to connect to historical data in other dashboard
• Maintained Proper Excel tab layout and standardized all dashboard by using spread sheet formatting, Color coding to identify data type, labels and formatting to identify data. Used color to identify tabs grouping.
• Designed, developed, deployed and maintained universes used Business Objects designer.
• Designed and developed Business Objects reports as per the Business requirements.
• Designed, developed, maintained and tested Universes for supporting ad hoc queries.
• Resolved Chasm traps, Fan traps and Loop problems.
• Implemented drill functionality into Web I reports and Linked reports.
• Developed the dynamic and customized prompts based on the hierarchy level information for predictive analysis of the reports.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• 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.
• Worked on multiple data providers to develop the dashboards coming from different sources.
• 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
• 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, Oracle, SQL Server 2005, PL/SQL Developer, Windows XP.

Client: Confidential, MN Feb 08 – Mar 10
Role : Production Administrator

Responsibilities:

• Design and developed New Universes.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables and by using contexts and alias tables to remove cyclic dependencies.
• Created Predefined conditions, Prompts and Custom Hierarchies in the process of building the universes.
• Maintained Report Tracker System to open new Report Tickets and prioritize them accordingly.
• Manually scheduling the recurring reports.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard
• Involved in scheduling of reports on file based events for month end processing and monitoring of these reports.
• Providing support for the reports in production in case of any data or performance related issues.
• Tuning SQL query performance, working with data warehouses and managing metadata.
• Monitoring the daily job scripts for loading the data about business transactions from source systems to FDW
• Managing Users, Groups and their access privileges on the documents.
• Involved in migration of reports from testing environment to production environment and also lower version to higher version of BO using Import Wizard.
• Resolving tickets opened by users for BO Production issues as well as access related issues.
• BO server management and recycling of BO servers for any environment related issues.
• Working on WRM’s and making changes to reports already existing in Production to resolve performance issues or adding of additional prompts, etc.

Environment: Business Objects XI 3.1/ XI R2, Central Configuration Manager, Central Management Console, Infoview, WEBi Rich client, Desktop Intelligence, Import Wizard, Xcelsius 2008, Oracle, SQL Server 2005, PL/SQL Developer, Windows XP.

Client: Confidential, Rockville, MD Apr’ 07 – Jan’ 08
Role: 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.

CLIENT: Confidential, Colorado Springs, CO Jun ’05– Apr’07
ROLE: 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.