SUMMARY

• Over 8 years of experience in Business Objects 4.0/XI3.1/XIR2/6.5.
• Experience in migrating Business Objects from XIR2 to XI 3.1 using Import Wizard.
• Solid expertise in Creating Complex Applications using Business Objects, Web - Intelligence, Import Wizard, Life Cycle Manager, Publishing Wizard, Report conversion tool, Designer, Planning, Metadata Manager, Crystal Enterprise 2008/XIr2/10/9/8.5/8, Xcelsius, Live Office, QaaWS, Dash Board Manager, Broadcast Agent, Auditor, Web Admin tool, Supervisor, Web Intelligence/Info view.
• Proficient in all phases of the Software Development Lifecycle(SDLC) including Requirements gathering, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Strong experience in building universes on Star schema & Snowflake Schemas.
• Experience in designing and developing Universes, Full Client/Web-Intelligence reports, publishing and scheduling using CMC and event manager
• Experience in creating Universes with measures and dimensional objects, Join conditions, Filters, LOV’s, cardinalities, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
• Created canned reports, complex ad-hoc reports using Business Objects Web Intelligence tools.
• Strong expertise in creating reports using the Business objects functionalities like Prompts, Slice and Dice, Drill Mode, Filters and Alerter.
• Expert in creating Dashboards, Scorecards using BO Dashboard Manager/Xcelsius 2008.
• Expertise in scheduling the documents using Central Management Console / Broadcast Agent.
• Experience in creating reports with Crystal Reports and dashboards with Crystal Xcelsius.
• Experience working with Crystal Xcelsius to display summary-level business data in a rich and intuitive format.
• Involved in using Crystal Xcelsius to Transform Microsoft Excel spreadsheet data into interactive flash media files for the upper level management.
• Experience in using various RDBMS like Oracle 10g/9i/8i, SQL Server 2005/2000.
• Involved in designing Databases and data marts on Oracle/Access. Widely used TOAD (Oracle), and SQL Query Analyzer (SQL server).
• Strong skills in Oracle including SQL, PL/SQL (Packages, Functions, Stored Procedures and Database Triggers and Cursors).
• Strong analytical, problem-solving, organizational, communication, learning and team skills.

TECHNICAL SKILLS

Reporting Tools: Business Objects 4.0/XI 3.1/ R2/6.5, Web Intelligence, Info View, Crystal Reports XI/10,QaaWS, Import Wizard, Publishing Wizard, Xcelsius 2008, Data Quality

RDBMS: Teradata, Oracle 10g/9i/8i, SQL Server 2008/2005/2000

Operating Systems: Windows2000/2003 Enterprise Server, AIX 5.3, Red Hat Enterprise Linux 4.0.

Languages: SQL, PL/SQL, UNIX Shell Scripts, HTML, DHTML, C, C++, VB 5.0/6.0

Tools: Confidential Load Runner 11.5, ERWIN 4.1/4.0, MS Project, TOAD 6.5 and SQL Navigator 4.1, Lotus Notes

PROFESSIONAL EXPERIENCE

Confidential, Franklin, TN

Business Objects Administrator/ Developer

Responsibilities:

• Installation, configuration and administration of Business Objects on windows platform.
• Installed, configured, maintained Multi-Clustered SAP Business Objects 4.0 plant on 64 bit Windows 2008 server and BO XI3.1 SP5 plant.
• Expertise in SAP Business Objects 4.0/XI3.1 installation/configuration/implementation and support in a Windows 2008 environment, SQL Server 2008.
• Clustered SAP Business Objects environment with multiple servers in processing and application tier
• Implemented LDAP/AD Configuration on Business Objects in windows environment.
• Stress testing using Confidential Load Runner 11.5, recording the script/scenarios to stress test the environment.
• Created users/groups and set privileges using Central Management Console (CCM) and security implemented.
• Created Batch files and scheduled them to back up Filestore (FRS).
• Maintained a large size users/groups security Administration. Created additional CMS(s) on each server.
• Enabled/Disabled servers in Central Configuration Manager (CCM) and Central Management Console (CMC).
• Created Server groups, Nodes, SIA (server Intelligent Agents) for efficient management of Business Objects. Added services and configured the servers to improve the performance.
• Upgraded the Business Objects XI 3.1 SP3 to Business Objects XI3.1 SP5.
• Resolved technical and logical issues in the business objects application.
• Defined standards for installing, maintaining business objects and documented onboarding/promotion process for Applications.
• Designed the Architecture diagrams for Business Objects and NOAD EQM servers using MS Visio 2010
• Defined, Implemented and handled failover process and data recovery process(Mandatory process)
• Created object level and row level securities in designer using security restrictions option
• Migrated the Universes, reports, Users, groups from environment to environment using Import wizard and SAP Business Objects 4.0 tool called upgrade management tool
• Installed Business Objects and Crystal reports runtime SDK on webservers for .net application teams.
• Created silent installation packages for Business Objects 4.0 client tools.
• Experience in side by side client and server installation (Business objects XIR2 SP4 and Business Objects XI3.1SP3 on same windows server).
• Resolved the database connectivity issue for Business Objects 4.0(with Teradata drivers,SQL server 2008)
• Created daily, weekly status reports using Xcelsius, Live Office and Qaaws.
• Part of the user training created linked / unlinked, sub-report using Crystal reports 2008 SP3.
• Promoted content (Universes, reports) from Development, QA, UAT and Production servers with NOAD EQM.
• Worked closely with production support team and led the off-shore and on-shore BI team.
• Monitored performance of Business objects, Web application and webservers with NetIQ tool.
• Installed, configured NOADEQM Server with business objects and provided the training to end users.

Environment: Business Objects 4/ XI release 3.1 SP5/SP3/R2, Confidential Load Runner, Web-Intelligence, Crystal Reports XI, Teradata, Oracle 9i/10g, PL/SQL, Xcelsius 2008, Windows 2003 server, HPSM, Site-scope.

Confidential, Peoria, IL

Business Objects Administrator/ Developer

Responsibilities:

• Responsible in upgrading SAP Business Objects XIR2 to XI3.1 SP3
• Designed SAP Business Objects Architecture based on Sizing requirements with good capacity projection.
• Expertise in SAP Business Objects XI3.1 installation/configuration/implementation and support in a Windows 2008 environment, IIS/TomCat, Oracle 10g, and SQL Server 2008.
• Clustered SAP Business Objects environment with multiple servers in processing and application tier
• Configured multiple application servers with load balancer and IIS to enable Single Sign-on (SSO) and Windows AD
• Installed Life Cycle Manager and configured with subversion as per SAP standards.
• Extensively used Import Wizard to migrate content from XIR2 to XI3.1/BO 4.0 and also content from Development, QA to Production and maintained versions control using Life Cycle Manager
• Created Custom Access Levels for assigning security for reports
• Designed security based on environment restrictions and as per SAP best recommendations
• Defined users and their profiles with appropriate access privileges.
• Applied Patches to resolve the bugs in SAP Business Objects XI3.1
• Expert understanding in SAP Business Objects tool trouble shooting and tuning.
• Worked as SAP Business Objects Platform support to work on day to day issues and also involved in communicating with other application teams to maintain platform stability
• Managed with off-shore team on daily activities
• Worked on VB Macros SDK to extract the data from CMS to maintain the statistics of the environment.
• Designed Monthly Business Review documents explaining server activities by business line
• Worked on Trouble Shooting of database connectivity, performance tuning.
• Worked on DR (Disaster Recovery) Project to architect the system for failover and scalability based on business requirements.
• Implemented Report Bursting feature using Profiles and Publications
• Participated in business requirements Analysis, Report Designing and development of Technical Specifications, Testing and Implementation
• Create the functions and formatting the reports according to user requirements.
• Trained Users on Infoview, Webi-intelligence, Universe and Xcelsius using SAP Knowledge Accelerator(KA)
• Done performance tuning of the reporting environment and mentored developers, end-users in the usage of SAP Business Objects
• Designed Production System support and handling opened user cases. Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Defined standards & production support documentation for other developers to follow.
• Designed migration strategies from development to test & Production.
• Scheduled Crystal reports and WebI reports.
• Conducted meetings with management and user community to understand the business requirements and convert Business requirements into technical specifications.
• Check the Job Server Trace, Job Server Monitoring and Job Server Error.
• Used Confidential Service Manager as help desk ticketing system

Environment: Business Objects XI release 3.1 SP3/R2, Web-Intelligence, Crystal Reports XI, Teradata, Oracle 9i/10g, PL/SQL, Xcelsius 2008, Windows 2003 server, HPSM, Site-scope.

Confidential, TX

Business Objects Administrator

Responsibilities:

• Coordinated with Users effectively, and Coordinated with Architect for resolving the reporting issues with users.
• Installed & Configuration ofBusiness Objects XIR2withCMSonIBM AIX 5.3 UNIXplatform.
• Clustered theCentral Management Server, Processing Servers&Application Server.
• Implemented Best Practices for Using Business Objects Suite of Products.
• Actively involved in gathering server sizing requirements for software/hardware.
• Managed Business Objects Security on Folders,Universes and Applications.
• Added User Profiles to Business Objects and granted access.
• Facilitated meetings across Departments for implementing a standard Architecture for deploying Business ObjectsXI r2across the entire Organization.
• Published Reports to CMC (Central Management Console) and involved inSchedulingandexportingthe reports in different Formats.
• Built and Managed Data Integration jobs and performed data transformations using Data Integrator.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Loaded data into Data Mart from Data Warehouse and scheduled jobs with Data Integrator.
• Worked on Audit Datamart project to load the data from Audit and CMS to Datawarehouse to maintain the history and also to join it other tables outside the box.
• Created Universes as per the user requirements and implemented with best practices.
• Implemented Row Level security and User restrictions at universe level.
• Created Reports using universe, Aggregate Awareness and index awareness, stored procedures, and freehand Sql as Data providers and writing the complex queries including Sub Queries, Unions, and Intersect.
• Experience in designing Web-Intelligence reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver the reports.
• Designed and developed several complex reports using Hyper linking, drill down features, sub reports, cross tab reports, labels, summary reports.
• Wrote Functions and Formulas on Webi reports to calculate the Percentages and Summaries based on the group levels.
• Developed web services using Query as a Web Service Wizard (QaaWS) and deployed it to the server for developing Xcelsius dashboards.
• Extensively worked on Crystal Reports XI to build standard reports, cross tab reports and OLAP reports.
• Created grouping, selection experts, parameters and summaries depending on requirements.
• Experience working with Crystal Xcelsius to display summary-level business data in a rich and intuitive format.
• Involved in using Crystal Xcelsius to Transform Microsoft Excel spreadsheet data into interactive flash media files for the upper level management.
• Created and developed Analytics and Alerts for individual Dashboards, specific to functional heads usingCrystal Xcelsius.
• Migrated and tested Canned and Adhoc reports from Business Objects XIR2 to Business Objects XI3.1
• Experience in writing test cases and test scripts to validate the queries
• Tested objects in the universe, to ensure the correct mapping of the objects.

Environment: Business Objects XI release R2/3.1, Web-Intelligence, Crystal Reports XI, Data Integrator 11.7, Oracle 9i/10g, PL/SQL, Xcelsius 2008, Windows 2003 server, UNIX.

Confidential, NJ

Sr. Business Objects Engineer

Responsibilities:

• Analysis of Client specifications and custom design applications.
• Worked on troubleshooting of different database connectivity, performance tuning.
• Installed Business Objects Enterprise and Published reports on Business Objects Enterprise Server and got involved in Business Objects Enterprise Administration.
• DefinedUsers, groups, categories & connections with CMC.
• ImplementedImport wizard & publisherfor migrating reports &universes.
• Facilitate with tech Support to Formulate a Strategy for Implementing good User support.
• Designed architecture & set up for development, production & test repositories.
• Implementedweb intelligencein distributed (clustered) Environment.
• Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
• Created Universes based on the dimensions, detail and measures required for the analysis.
• Experience in the development of reports for financial needs of the business using Business Objects Reports.
• Created Web Intelligence documents for user reporting needs, to retrieve data by building queries using Business Objects universes and to use Web Intelligence to enhance documents for easier analysis.
• Developed Webi reports with Parameters, Sub-reports based on Stored Procedures and Queries by using Business Objects reports.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
• Experience in Scheduling the Reports using Business Objects Enterprise.
• Published Reports in Business Objects Enterprise via Publishing Wizard and Business Objects Management Console.
• Installed and configured Crystal Reports XI and Created and Maintained/administer User groups in Crystal Enterprise.
• Created interactive excel dashboards and charts and graphs, created scorecards, metric analytics with Crystal Xcelsius.
• Experience working with Crystal Xcelsius to display summary-level business data in a rich and intuitive format.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Participate in developing “best practices” data warehouse standards for production support environment.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

Environment: Business Objects Enterprise XI R2, Crystal reports XI, Xcelsius 4.5, Web-Intelligence, SQL SERVER 2005, SSIS, T-SQL, UNIX and Win 2000.

Confidential

Sr. Business Objects Developer

Responsibilities:

• Interacted with Project Manager and Business Analyst to understand the requirements and modifying universe, report specifications.
• Modified, tested and maintained universes.
• Extensively used multiple data providers for building reports.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Built Custom Hierarchies in universe to facilitate drill down in the Webi reports.
• Created and maintained Business Objects Web Intelligence reports.
• Analyzed the reports using Slice and Dice, and Drill Down.
• Performed data validation by creating adhoc reports.
• Created different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Documented the deviations from the original specifications.
• Enhanced the reports by providing event-handling features.
• Optimized the usage of user objects, conditions and universe level filters.
• As a Supervisor created Users and Groups.
• Published the Business Objects reports to Webi.
• Experience in writing test cases and test scripts to validate the queries.

Environment: Business Objects 6.5, Oracle 8/9i, BO Designer, Web intelligence 2.6.x, Windows XP.