SUMMARY

• Over 8+ years of Data warehousing experience and used all modules in Business Objects like Supervisor, Designer, Business Objects, Web Intelligence, CMC, Performance Management and Dashboards.
• Expertise in all versions of Business Objects (5.x/6.x, XI R1, XIR2 and R3.1, BI 4.0).
• Skilled in defining and implementing the various components of a data warehouse such as Operational source systems, Data staging, Data presentation and Data access tools.
• Strong in designing Star Schemas and Snow Flake Schemas.
• Expertise in deploying OLAP tools, Materialized Views, and partitioning techniques for highly responsive Decision Support Systems.
• Over 4 years of experience in implementing SQL server database applications.
• Worked on Oracle and Tera data database over 3 years.
• Excellent domain expertise in Finance, Banking, Insurance and Manufacturing.
• Involved in Requirement Gathering, Business Analysis, functional and Technical Documentation by interacting with Critical Confidential Business users like Stock Traders, brokers and stack holders.

TECHNICAL SKILLS

Business Intelligence: Business Objects 5.X/6.1/6.5/XI - r1/r2/r3.1,BI 4.0 Performance Manager and Dashboards, Crystal Xcelsius 2008.

ETL Tools: Informatica 8.5.1/8.1/7.1.2/6.1/5.1 , Data stage 7.5, BODI

Programming: SQL, PL/SQL & HTML, Java, C+, Fortran and Basic, EXCEL

RDBMS: Oracle 11g, 10g, 9i,8i,8i, SQL Server 2000,2003, 2008, Tera data 13.1/13.0, MS Access

GUI Tools: Designer/2000

Machines: Confidential /Compatible PC, Apple Mac

Operating System: Windows 9X/NT/2000/XP, 2008 R2, Unix, Linux, Sun Solaris 7/8, HP-UX

PROFESSIONAL EXPERIENCE

Confidential, Seattle, Washington

Sr Business Objects Admin

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Worked on upgrading the Business objects from XI to XI R3.1 and then XI R3.1 to BI 4.0.
• Worked on conversion of Desktop intelligence to Web intelligence.
• Worked on Implementing business plans and Migration strategies for BOXI Migration.
• Worked along with production support team to fulfill the end user requirements and in finding the best solutions for the user tickets.
• Extensively worked with BOXI Instance manager in monitoring of report status and user interaction.
• Troubleshooting BOXI installation and migration issues and Audit reports for making managerial decisions.

Environment: Business Objects XI 3.1/XIR2 (SP2/SP3/SP4)/XI 3.1, BI 4.0 Crystal Reports 11/ 2008, Performance Management, Data Quality, Live Office, Crystal Xcelsius 2008, Tera-data, SQL and PL SQL, Windows 2008 R2.

Confidential, Silver Spring, MD

Sr. BO Admin

Responsibilities:

• Involved in publishing, developing, and Deployment of crystal reports in whole Crystal 10 Enterprise Suite.
• Worked along with UAT support team in creating and testing of different test cases against the Crystal and Bo reports of the Kaiser.
• Involved in finding out solutions for different problems like overlapping, truncations, multi valued, folder access issues, hard coded restrictions, data visibility.
• Worked on metadata and created universes and reports.
• Used metadata to get the characteristics of a resource.
• Used metadata for documenting the data products.
• Reports by Customer, Integrated clinical data with BOXI environment.
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting.
• To increase the performance using Xcelsius, Designer business object XIR3.1 Reports by Period, Demographic reports and Comparative reports.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Environment: Business Objects XI 3.1/XIR2 (SP2/SP3/SP4)/XI 3.1, Crystal Reports 10 / 2008, Performance Management, VBA Macros, Data Quality, Live Office, Crystal Xcelsius 2008, Tera-data, SDK, Macros, SQL and PL SQL, Windows, MS Word 2007, MS Excel 2007.

Confidential, Harrisburg, PA

Sr. BO Admin

Responsibilities:

• Responsible for development of Technical design documentation for reporting system.
• Directly coordinating with user to gather the new requirements and working with existing issues.
• Implemented Migration process for Business Objects 6.5.1 and Crystal reports 10 to XI R2, such as readiness assessment and deployment plan, Migration and system Upgrades, Co-Existence Planning, Deployment services and delivery.
• Configured and set for migration from 6.5 to XI R2 for Demo and real time examples for evaluating the entire migration process and methodology to provide the suitable solutions to the users.
• Installation and configuration, Creation of repositories and security domain with user groups and security implementation
• Mentored developers, end-users in the usage of Business Objects
• Mentored other IT staff & Conducted Corporate for end users on Business Objects XI R2.

Environment: Business Objects XI R2 Enterprise Suite (Designer, Desktop Intelligence, CMS, CMC, Web Intelligence), Crystal Reports XI, Xcelsius 2008, Windows 2003, SQL Server 2005 and, Erwin, Oracle 9i, SQL, PL/SQL, TOAD.

Confidential, Kansas MO

Sr. BO Admin

Responsibilities:

• Involved in system analysis & design of EDW and source system analysis.
• Implemented Migration process for Business Objects 6.5.1 and Crystal reports 10 to XI, such as readiness assessment and deployment plan, Migration and system Upgrades, Co-Existence Planning, Deployment services and delivery.
• Migrated Objects from development to test to production environments.
• Implemented Publishing wizard & Import wizard for migration of reports.
• Implemented Best Practices for Using Business Objects Suite of Products.
• Developedvisualizationand from excel sheets usingxcelsius 4.5
• Created/Administered users/user groups/Security in Supervisor/CMC.
• Defined production support strategy for the reporting issues and involved in 24/7 support functions

Environment: Business Objects 6.5.1/XI, informatica 7.1.1, BOSDK, Crystal Reports XI r2, Erwin, xcelsius 4.5, SQL 2003 and 2005, Oracle9i/10g, Confidential AIX 5.3, DB2, Toad, UNIX, J2EE.

Confidential, Danbury, CT

BO Admin

Responsibilities:

• System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.
• Prepared Business/Technical Requirements, Design Templates, Development Standards documents and Detailed Design documents.
• Implemented and given session to train Power Users/Managers in BO functionality and to use the reports Design & Developed dashboards and deploy them across the organization to monitor the performance.
• Upgraded from Bo 6.5 to BO XI.
• Created event based schedules of the reports and built an emailing mechanism to indicate success/failure of the schedule.
• Scheduled the reports using the customized script and sent the reports to e-docs.
• Closely worked with business end users on production support related issues.

Environment: Business Objects 6.5.1/XI Enterprise Suite (Designer, Desktop Intelligence, CMS, CMC, Web Intelligence), Crystal Reports XI, Windows 2003, SDK, SQL Server 2005, DB2, Oracle 9i, SQL, PL/SQL, TOAD, Control-M.

Confidential

Developer/Admin

Responsibilities:

• Member of the warehouse design team, which interacted with the business community and database administrators to identify the business requirements.
• Understanding the underlying OLTP and Data Warehouse to identify the attributes and data sources. Determined the Dimension, Measure and Detail objects.
• Exported the universe to the Repository to make the resources available for the users.
• Created Reports for various Portfolios using the Universes as the main Data Providers.
• Built full client and WebI reports. Published and Scheduled Business Objects Reports to users using Scheduler.
• Set up Groups and Users for Business Objects deployment and managed user profiles using Business Objects Supervisor.
• Involved in the end users and project documentation.

Environment: Business Objects 5.x, Web intelligence 2.x, Designer, Supervisor, Broadcast Agent, Informatica 5.1, Oracle 8.0, PL/SQL, UNIX, Windows NT.

Confidential

Programmer/Analyst

Responsibilities:

• Created reports using Business Objects (BO)
• Designed Universe for Reporting using Business Objects Designer module
• Performing data check and formatting check.
• Developed report specs for Frequency & Severity Trending application and completed generating the reports.
• Providing ongoing production support for the Business Objects.

Environment: Business Objects 5.1, (BO Reporter, Supervisor, Designer, Web Intelligence, Oracle 8.0&9i, Visual Basic 6.0 and Unix, Win NT.

Confidential

BO Developer/Analyst/tester

Responsibilities:

• The data mart was built using Star Schema data model to look at the invoice amounts from various dimensions
• It was targeted for ford campaign program in a global scenario.
• Responsible for testing and development of universes.
• Responsible for pilot testing and writing testing scripts.
• Responsible for end user .
• Responsible for business Analyst documentation.
• This data warehouse is implemented on oracle.

Environment: Crystal Report 4.5, Oracle 7.3, and Win NT.