PROFESSIONAL SUMMARY:

• Over 12 Years of experience in IT industry with 7 years in Business Intelligence Reporting, Data modeling, Design, Development, migration, Implementation and Testing of Database/ Data Warehouse/Client/Server systems.
• Complete project life cycle (SDLC) experience in various projects.
• Strong customer interfacing experience. Core to my experience is quick understanding and appreciation of the current state of the client and his needs.
• Good hands on experience in Business Objects 3.1/4.0 installation, configuration and administration of complex BO environment.
• Good experience in configuring and administering security in XI3.1 and BI 4.0
• Experience in migrating content between various BO environments.
• Goods hands on experience in migrating Business Objects reports from XIR2 to XI 3.1/4.0.
• Business Objects Administration experience in a Linux/Unix and Windows environment
• Good Experience with SAP, Windows AD, SharePoint, and LDAP integration.
• Good experience in customizing Business Objects using Java SDK.
• Good hands on experience and expertise in designing and developing the BO Universe and administering the BO activities.
• Expertise in all modules of Business objects suite (Reporting, Data Services integration and performance management).
• Hands on experience in ETL tools like Business Objects Data Integrator and Informatica.
• Sound Knowledge in Design & Analysis of Data Modeling, Metamodel and Star/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Experience in working with Oracle, DB2, SQL Server and Sybase Database Servers.
• Experience in Writing PL/SQL and UNIX Shell Scripting
• Experience in Java/J2EE, JSP, Servlets, HTML, EJB and XML
• Excellent analytical, problem solving skills and a motivated team player with excellent inter - personal skills.
• Good communication, decision making, organizational and analytical skills.

TECHNICAL SKILLS:

BI Tools: Business Objects Version 4.0/,3.1/IR2, (Central Management Server, Designer, WebIntelligence Rich Client, Desktop Intelligence, Infoview, Central Management Console, Central Configuration Manager, Publishing wizard, Import Wizard and Lifecycle Manager), Crystal Reports 2008.

ETL tool: Business Objects Data Services 4.0/3.0 and Informatica.9.1

Databases: Oracle 11g/10g,9i, MS SQL Server 2005, DB2, MS Access, Sybase v7.2

Languages: Java, JSP, Servlets, HTML, SQL, PLSQL, Shell Scripting

Application Servers: BEA WebLogic8.1, Apache Tomcat 5.5

Operating Systems: Windows NT/2000, UNIX (Sun Solaris/HP UNIX/AIX)

DB/Modeling Tools: Toad, Ervin 4.0

PROFESSIONAL EXPERIENCE:

Confidential

Business Objects Administrator

Responsibilities:

• Provide support for SAP Business Objects Suite - Includes installation, configuration, monitoring, and upgrade management.
• Installation, setup, configuration and tuning of Business Objects XI and 4.0 environments on Windows and UNIX.
• Administering and maintaining Business Objects 4.0/XI3.1/XIR2 on development, Test, Pre-Production and Production environments.
• Designing and maintaining Business Objects XI 3.1 universes, Webi, Crystal and Desktop Intelligence reports.
• Provide 24x7 platform support. Complete service requests and problem cases
• Administering security settings using Central Management Console on XI 3.1, 4.0
• Migration of reports from development to Test and upon validation to Pre-Production and Production environments.
• Responsible for Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Configure BO Clusters and integrate SSO / LDAP/Windows AD.
• Develop programs and scripts to automate tasks and monitor systems
• Create documentation to support design, build and unit testing of Business Objects reports as well as project management documentation.
• Run unit testing and validation of Business Objects reports and universes.
• Work with other BI team members to test reports and influence Data Model design and data transformation logic enhancements to support report requirements

Environment: Business Objects 4.0/3.1 (CCM, CMC, Web Intelligence Rich Client, Designer, Infoview, Publishing Wizard, Life Cycle Manager, SDK, Import Wizard, Xcelsius dashboard), BO XIR2,, SQL Server, Oracle11g, SQL, PLSQL, Apache Tomcat 6.X.

Confidential

Business Objects Administrator

Responsibilities:

• Migration of Business Objects reports from version XIR2 into XI 3.1/4.0
• Installation, configuration and maintenance of Business Objects system and provide Business Objects technical support to resolve client technical issues.
• Customizing the parameters in Business Objects Servers.
• Worked on the Business Objects Clustering.
• Worked on User administration, audits reports, server logs.
• Managing Schedules/refreshes, Instances and monitoring
• Responsible for Configuration of File Repository Servers, LOV Job server, Web Intelligence Job and Report Servers, Desktop Intelligence, Job, Report and Cache Servers, Destination Job Server, Program Job Server, Event Server and auditing database.
• Responsible for Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Analysis of business problems and planning the universe solution, designing the schema, building the universe and distributing the universe to users.
• Developing and modifying Web Intelligence reports and scheduling reports in CMC.
• Involved in the design, development, enhancement and debugging of the applications.
• Interacting directly with customers to get the detailed reporting/Data requirements.
• Modifying the complex Business Objects universes and reports based on client’s business requirements.

Environment: Business Objects 4.0/3.1 (WebIntelligence Rich Client, Central Management Server, Central Management Console, Universe, Infoview, Publishing Wizard, Import Wizard), BO XIR2,, SQL Server, Oracle10g, SQL, PLSQL, Apache Tomcat 6.X.

Confidential

Business Objects Administrator

Responsibilities:

• Validating and fixing the migrated reports in XI 3.1 environment.
• Migration of Business Objects reports from version 5.1.7 into XI 3.1
• Installation, configuration and maintenance of Business Objects system and provide Business Objects technical support to resolve client technical issues.
• Customizing the parameters in Business Objects Servers.
• Creating Security model for Hamilton Sundstrand Business Objects group.
• Worked on the Business Objects Clustering.
• Involved in the design, development, enhancement and debugging of the applications.
• Responsible for Data loading into target Data warehousing using Business Objects Data Services ETL tool.
• Interacting directly with customers to get the detailed reporting/Data requirements.
• Writing complex queries and SQL tuning to maximize query performance.
• Creating complex Business Objects universes and reports based on client’s business requirements.
• Worked with the subject matter experts in the Analysis of business problems and planning the reporting solution.
• Customizing the reports based on the Business Objects XI 3.1 environment.
• Analysis of business problems and planning the universe solution, designing the schema, building the universe and distributing the universe to users.
• Developing and modifying Web Intelligence reports and scheduling reports in CMC.
• Involved in the design, development, enhancement and debugging of the applications.
• Interacting directly with customers to get the detailed reporting/Data requirements.

Environment: Business Objects XI 3.1 (WebIntelligence Rich Client, Central Management Server, Central Management Console, Universe, Infoview, Publishing Wizard, Import Wizard), SQL Server, Oracle10g, SQL, PLSQL, Apache Tomcat 6.X.

Confidential

Business Objects Administrator

Responsibilities:

• Coordinating as a technical lead for the Business Objects module with the client and the offshore team.
• Analysis of business problems and planning the universe solution, designing the schema, building the universe and distributing the universe to users.
• Developing full client and Web Intelligence reports and scheduling reports.
• Installation, configuration and maintenance of Business Objects system and provide Business Objects technical support to resolve client technical issues.
• Involved in the design, development, enhancement and debugging of the applications.
• Responsible for Data loading into target Data warehousing using Business Objects Data Services ETL tool.
• Interacting directly with customers to get the detailed reporting/Data requirements.
• Writing complex queries and SQL tuning to maximize query performance.
• Creating complex Business Objects universes and reports based on client’s business requirements.
• Worked with the subject matter experts in the Analysis of business problems and planning the reporting solution.

Environment: Business Objects XI 3.0 (WebIntelligence Rich Client, Central Management Server, Central Management Console, Universe, Infoview, Publishing Wizard, Import Wizard), Business Objects Data Services XI 3.1, UNIX, Oracle9i, SQL, PLSQL, Apache Tomcat 5.5 and Erwin.

Confidential

Business Objects Administrator

Responsibilities:

• Coordinating as a technical lead for the Business Objects module with the client and the offshore team.
• Worked with the subject matter experts in the Analysis of business problems and planning the reporting solution.
• Designing the schema and building the Business Objects Universe.
• Interacting directly with customers to get the detailed reporting/Data requirements.
• Designing and developing complex WebIntelligence reports in various modules.
• Report migration within various Business Objects environments.
• Administrating the BO repository through Central Management Console.
• Installation, configuration and maintenance of Business Objects system and provide Business Objects technical support to resolve client technical issues.
• Involved in the design, development and enhancement and debugging of the applications.
• Responsible for Data loading from source system into target Data warehouse using Business Objects Data Integrator 3.0.

Environment: Business Objects XI 3.0 (WebIntelligence Rich Client, Central Management Server, Central Management Console, Universe, Infoview, Publishing Wizard, Import Wizard), Business Objects Data Integrator 3.0, UNIX, Oracle9i, SQL, PLSQL, Apache Tomcat 5.5 and Erwin.

Confidential

Business Objects Developer/Administrator

Responsibilities:

• Interacting with customers to get the detailed reporting/Data requirements.
• Analysis of business problems and planning the universe solution, designing the schema, building the universe and distributing the universe to users.
• Developing Desktop Intelligence and WebIntelligence reports.
• Scheduling the reports through CMC
• Installation, configuration and maintenance of Business Objects system and provide Business Objects technical support to resolve client technical issues.
• Involved in the design, development and enhancement and debugging of the applications.
• Responsible for Data loading into target Data warehousing using Business Objects Data Integrator 11i.
• Writing complex queries and SQL tuning to maximize query performance.
• Creating complex Business Objects universes and reports based on client’s business requirements.

Environment: Business Objects XI R2 (Desktop intelligence, WebIntelligence, Central Management Server, Central Management Console, Universe, Infoview, Publishing Wizard, Import Wizard), Business Objects Data Integrator 11i, Unix, Oracle9i, SQL, PLSQL, Apache Tomcat 5.5 and Erwin 3.5.2.

Confidential

Business Objects Developer/Administrator

Responsibilities:

• Worked with the business analyst team to interview the business users and capture simple, moderate and complex business requirements. Collaborated with business technicians to research existing business and system processes.
• Responsible for analyzing business requirements and developing queries and reports using WebIntelligence and infoview to provide Web-enabled data analysis solutions to business clients.
• Worked extensively on modules Central Management Server, Designer, WebIntelligence, Desktop Intelligence and Publishing Wizard.
• Created Objects, Predefined Conditions, Joins in the Universe.
• Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity of the Universe.
• Created various adhoc reports using Business objects.
• Maintaining the existing BO applications and providing User Support includes; resolving Data/Repository access problems, helping them in creating ad-hoc reports using the available BO functionality
• Documented the entire work done.
• Responsible for Data loading into target Data warehousing using Business Objects Data Integrator11i.
• Interacting directly with customers to get the detailed reporting/Data requirements.
• Writing complex queries and SQL tuning to maximize query performance.
• Creating complex Business Objects universes and reports based on client’s business requirements.

Environment: Business Objects XI R2 (Desktop intelligence, WebIntelligence, Central Management Server, Central Management Console, Universe, Infoview, Publishing Wizard, Import Wizard), Business Objects Data Integrator11i, SQL Server 2005, Unix, Oracle9i, SQL, PLSQL, Apache Tomcat 5.5..

Confidential

Business Objects Developer/Administrator

Responsibilities:

• Analysis of business problems and planning the universe solution, designing the schema, building the universe and distributing the universe to users.
• Developing full client and Web Intelligence reports and scheduling reports in Broadcast Agent.
• Installation, configuration and maintenance of Business Objects system and provide Business Objects technical support to resolve client technical issues.
• Involved in the design, development, enhancement and debugging of the applications.
• Responsible for Data loading into target Data warehousing using Business Objects Data Integrator 6.5.
• Interacting directly with customers to get the detailed reporting/Data requirements.
• Writing complex queries and SQL tuning to maximize query performance.
• Creating complex Business Objects universes and reports based on client’s business requirements.
• Administrating the repository through Supervisor (Users, Documents, Groups, Categories, Connections etc).

Environment: Business Objects 6.5 (Full client, WebIntelligence, Infoview Designer, Supervisor, BCA), Business Objects Data Integrator 6.5, SQL Server 2000, DB2, SQL, PLSQL, Apache Tomcat 5.5 and Erwin 3.5.2.

Confidential

Business Objects Developer

Responsibilities:

• Gathered the Report Requirements from the users and created the Universes and Reports.
• Defined Cardinalities and checked the Integrity of the Universes.
• Designed the Universes, created Contexts and Aliases for resolving Loops in the Universes.
• Created Documents both (full client and WebI), summary and detail with the functionality of Drill down to detailed document
• Extensively used Calculations, Variables, Breaks, Sorting, Drill Down, Slice and Dice, Alerts for creating Business Objects Reports.
• Provided Object level security using table mapping and used derived tables and defined the prompts at table level.
• Scheduled Business Objects Reports through Broadcast Agent and monitored scheduled reports through BCA console.
• Documented the Universe design and Reports development. Trained the end users in ad-hoc Report Development and participated in Production Support.
• WebIntelligence was used for web-based query and reporting.
• Worked in Business Objects Data Integrator to load the historical data into Data Warehousing.

Environment: Business Objects 6.5 (Full client, WebIntelligence, Infoview Designer, Supervisor, BCA), Business Objects Data Integrator 6.5, DB2, Oracle9i, SQL, PLSQL, Apache Tomcat 5.5.

Confidential

Business Objects Developer

Responsibilities:

• Creating complex Business Objects universes and reports based on client’s business requirements.
• Processing and scheduling of reports using Broadcast Agent.
• Responsible for Data loading into target Data warehousing using Business Objects Data Integrator.
• Administrating the repository through Supervisor (Users, Documents, Groups, Categories, Connections etc).
• Interacting directly with customers to get the detailed reporting/Data requirements.
• Writing complex queries and SQL tuning to maximize query performance.

Environment: Business Objects 6.5 (Reporting, Universe, Supervisor, WebIntelligence, Infoview, Broadcast Agent, Broadcast Agent Publisher), Business Objects Data Integrator 6.5 Sybase, SQL and PLSQL.

Confidential, San Jose, CA

Sr Business Objects Administrator/Data Integrator Developer

Responsibilities:

• Understanding requirement analysis, LeasePak data model and existing data in LeasePak target database.
• Analysis of business problems and planning the universe solution, designing the schema, building the universe and distributing the universe to users.
• Developing full client and WebIntelligence reports and scheduling reports in Broadcast Agent.
• Responsible for Data loading into target D/W using Business Objects Data Integrator.
• Responsible for publishing reports using Broadcast Agent publisher.
• Installation, configuration and maintenance of Business Objects system and provide Business Objects technical support to resolve client technical issues.
• Interacting directly with customers to get the detailed reporting/Data requirements.
• Writing complex queries and SQL tuning to maximize query performance.

Environment: Business Objects 6.5 (Reporting, Universe, Supervisor, WebIntelligence, Infoview, Broadcast Agent, Broadcast Agent Publisher), Informatica v7.1, Oracle9i, SQL, PLSQL, Apache Tomcat 5.5 and Erwin 3.5.2.

Confidential

Business Objects Developer

Responsibilities:

• Responsible for production support of over 30 major financial reports and 35 other business reports.
• Developing full client and WebIntelligence reports and scheduling reports in Broadcast Agent.
• Responsible for publishing reports using Broadcast Agent publisher.
• Installation, configuration and maintenance of Business Objects system and provide Business Objects technical support to resolve client technical issues.
• Interacting directly with customers to get the detailed reporting/Data requirements.
• Responsible for batch processing of Business Objects reports.

Environment: Business Objects 5.1.7 (Reporter, Universe, Supervisor, Web Intelligence, Infoview, BCABCA publisher), Informatica v5.1.1, Oracle8i, SQL, PLSQL, Apache Tomcat 5.5 and ERwin 3.5.2.

Confidential, Atlanta, GA

Business Objects Developer

Responsibilities:

• Responsible of creation of Business Objects universe from the datamodel and developing of full clients reports based on the universe.
• Creating complex Business Objects universes and reports based on client’s business requirements.
• Writing unit, system and integration tests and validate the test results independently.
• Maintenance and development of VBA scripts for automation of reporting solutions
• Carry out performance tuning of Reports.
• Administrating the repository through Supervisor (Users, Documents, Groups, Categories, Connections etc).
• Processing and scheduling of reports using Broadcast Agent.
• Responsible for data loading from source systems to target database using Informatica ETL tool.
• Written complex SQL queries to generate Free-hand SQL Business Objects reports.
• Responsible for creating users, user groups, categories, database connections using Supervisor and assigning privileges to users and user groups.

Environment: Business Objects 5.1.7, Informatica v6.1, SQL, PLSQL, Oracle8i, Apache Tomcat 5.5, Shell Scripting, Unix and Erwin 3.5.2.

Confidential

Responsibilities:

• Analysis of the specifications provided by the clients
• Design and Development
• Coding using JSPs and Java Servlets
• Developed EJB Components.
• Database management and JDBC connectivity
• Testing - unit testing & integration testing

Environment: Java, Servlets, JSP, EJB, XML, JavaScript, HTML, Oracle8i, SQL, Apache Tomcat and Windows NT.