Professional Summary

• Over 10 years of experience in Information Technology that includes 8 plus years of expertise as Business Objects Developer/Administrator/Architecture.
• Extensive experience in different versions of Business Objects that include Business Objects 5.1, 5.1.6, 6.1a, 6.5 and BO XiR2, BO3.1
• Expert in BOXI3.1 installation and configuration.
• Extensive experience in supporting/maintaining/troubleshooting large amount of reports/universes/End users issues.
• Expert in Business Objects reports/Desktop Intelligence, Designer, Supervisor, Web Intelligence, Infoview, Broadcast Agent, BCA Publisher & Administration modules.
• Hands on experience in Installation & Configuration of Business Objects Enterprise XiR2
• Expert in trouble shooting issues during installation of Business Objects Enterprise XiR2
• Efficiently lead small to large sized teams in various assignments
• Worked as Production Support Lead for the Business Objects Reporting environment.
• Knowledge in Dimensional Data Modeling with good understanding of Star & Snowflake schemas, fact & dimensional tables
• Expert at optimizing, debugging and testing SQL Queries and stored procedures written in Oracle & SQL Server
• Excellent team player with very good Communication skills and problem solving abilities.
• Responsible for Report Deployment Strategy

DATAWAREHOUSING SKILLS

Reports/Designer: Business Objects5.1, 5.1.6/6.1a/b, 6.5, XI R2, BOXI3.1, BI4.0, Web Intelligence, Info view, Zabo, Business Objects Designer, Supervisor, CMC, Crystal Reports, Data Federator, QaaWs, Xcelsius.

TECHNICAL SKILLS

• Operating Systems Windows NT, Windows 98/XP/2000/2003/2008, UNIX, Linux.
• Databases Oracle 8i/9i/10g, SQL Server 7.0/2000, MS Access
• Languages SQL, PL/SQL, C, .NET , K-Shell, Java
• Application Development Tools Visual Basic 5.0/6.0
• Internet Technologies HTML, DHTML, ASP, VB Script, IIS, Apache Tomcat, WebSphere,

Certification And Education

• BOXIR2 Certified Engineer
• SAP BO3.x Certified Engineer
• BS in Mechanical Engineering

Work Experience

Confidential, Boca Raton FL Jan ’07 Till Date
Senior System Analyst / Tech Lead Business Objects SME
Team size - 8

Description: Work as a part of Production Support team in Confidential and SME of Business Objects. Tech Lead of Business Objects deployments. Supporting and maintaining 1200 Reports and 400 Universes with around 6000 users. Along with BO SME role, supporting and administrating different applications. And, providing support to team 24/7 on any BI related issues.

Responsibilities:

• Technical Lead for business Objects deployments.
• Designed fault tolerance and fail over architect for Business objects environments.
• Installation and configuration of BOXIR2 and their modules.
• Installation, configuration and migration of BOXI3.1 from BOXIR2.
• Configured Authentication to current environment to use Active Directory account for SSO login system.
• Involvement in strategic, functional and Architect decisions.
• Restructured security model to support organization security and for batter and easy maintenance.
• Created monthly process to make documents of repository detail information.
• Involvement in day to day migration work.
• Providing BI Solution to internal business customers.
• Installation / Configuration of Data Federator application and integration with BOE application.
• Supporting onshore / offshore developers with ongoing daily issues.
• Involvement in project requirement gathering and providing solution to deliver it on time.
• Installation and configuration of BO and their modules on Loaner box for POC purpose.
• Implemented DR systems and to support it started routine maintenance and back up processes of repository and CMS database.
• Enabled auditor on environments to audit the usage of system.
• Customized infoview application for batter look and user friendly.
• Established release cycle to maintain work flow.
• Involvement in Load testing of system to check performance of application.
• Customized infoview URL and redirected through IIS.
• Providing solutions to End Users with all the issues of logging and accessing infoview.
• Maintaining environment clean and error less.
• Increased performance of system by scheduling reports.
• Configured SMTP on server to allow users to schedule report and send them to other resources.
• Involvement in Hardware testing of Business Objects Servers.
• Involvement in administration of Cold Fusion, SQL server and websphere to support team.
• Configured AutoDesk Software and its group to borrower licenses for AutoCAD.
• Working on testing of new BI 4.0 products to fit in organization.

Environments: BOXIR2, BOXI3.1, BI4.0, QaaWs, Xcelsius, Data Federator, Windows 2003/2008 server, SQL server 2003-2008, Oracle 9i-10i, websphere, Cold Fusion.

Confidential, Atlanta GA
Business Objects Consultant Nov ’06 – Jan ’07
Team size: 4

Description: Confidential has Business Objects 6.5 implementation. They had issues with the BCA publisher, Web Cluster services and some of the services were not functioning as per expectation. This is a short term assignment with Business Objects Inc.

Responsibilities:

• Trouble shooted the issues.
• Uninstalled & Re installed BCA publisher
• Configured the publisher.
• Configured the Web cluster.
• Applied hot fix from business objects.
• Resolved the issues with the license keys.
• Ensured that the Test Server was functioning properly and provided the stable environment
• Documented the observations and the solution

Environment: Business Objects 6.5, Windows2003 server, Windows XP, BCA Publisher, Oracle 9i.

Confidential, Dearborn, Michigan. Aug ’04 – Nov ’06 
Senior Business Objects Analyst/Developer
Team size:

Description: The project requires supporting the Business Objects application that has around 30 BO universes in use, which are pointing to various databases including ORACLE & SQL Server databases. The project supports around 700 Business users for various Reports and Universes.

Responsibilities:

• Installed & Configured Business Objects Enterprise XiR2 Premium Edition
• Created, Modified, tested and maintained universe.
• Customized the universe by creating user/pre-defined objects so as to match the requirements
• Created and maintained around 30 Business Objects reports.
• Created the users, user groups and handled the user security.
• Built Cross-Tab reports
• Resolved major issues affecting the reporting environment.
• Experienced with different snowflake schema to creating a universes.
• Provided reporting solutions for simple to complex scenarios.
• Added/created complex objects to the universe to enhance the report functionality.
• Supported PL/SQL script tuning to improve the Data warehouse performance.
• Performed data validation by creating ad hoc reports.
• Used Free hand SQL to create the reports which were not within the scope of universe
• Involved in documenting the changes to the universe and reports functionality.
• Involved in preparation of user’s guide and fine-tuning the specification.
• Documented the deviations from the original specifications.
• Worked with top management at Ford and helped them fine tune the reporting requirements/specification so as to ensure comprehensive reporting solutions
• Enhanced the reports by providing event-handling features.
• Optimized the usage of user objects, conditions and universe level filters
• Extensively used multiple data providers for building reports.
• Lead the production support team to handle issues with the reports and the universe

Environment: Oracle 9i/10g, Business Objects 6.1a, 6.5, XI R2, BO Designer, Web intelligence, Infoview, Windows XP/2000/2003 Server , Unix, SQL server.

Confidential, Stamford-CT May’03 – Aug ‘04 
Business Objects Developer 
Team size: 8

Description: Confidential is one of the largest wealth management businesses, a global investment banking firm and a key global asset manager and the market leader in Swiss Corporate and individual client banking. Business objects were used to providing reporting solutions. Reports like Daily Ranking Report, Long term Rank and percentiles (Net), daily report and category customer report were developed.

Responsibilities:

• Involved in Installing the Business Objects, creating Repository, creating Users and User Groups using supervisor models.
• Responsible for requirements gathering and writing specifications
• Involved in designing, developing & testing the universe for report generation.
• Created & tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Created graphical representation of reports such as Bar charts, Pie charts etc as per the End user requirements.
• Developed full client and webi reports.
• Wrote free hand SQL to validate the report data.
• Wrote PL/SQL stored procedures and created reports using stored procedure data provider.
• Exported the reports to Broadcast Agent Server, which is used to Schedule and Monitor the reports.
• End User Training in basic and advanced reporting.
• Responsible for driving the user group meetings and finalizing the specifications.
• Testing of Universe and Reports, which includes
• Database connectivity.
• Tested objects in the universe, to ensure the correct mapping of the objects.
• Tested resolved loops and contexts to ensure the correct results from the query.
• Tested the universe structure to ensure the tables are properly updated along with the database.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.

Environment: BusinessObjects5.1.2/5.1.6, Web Intelligence, Oracle 8i, SQL server, Windows NT, HTML.