Summary

• Extensive experience in Business Intelligence tools like Business Objects 5.x, 6.x, XIR2/R3 Administration, BI 4.0, Abinitio, Informatica, Crystal Reports XI/10/9/8x and Development including Performance Manager with databases like SQL Server 2000,2005 and Teradata on Windows platform.
• 8 + year hands-on experience in Business Objects, full lifecycle Implementations.
• Business Objects Enterprise XI R2 Administration Level Certified
• Well versed in full System Development Life Cycle (SDLC) methodologies starting from collecting business specifications, confirming design decisions regarding data, interfaces, designing/developing/auditing the Universe/Reports and documenting the entire life cycle.
• Installed and Configured Business Objects in Windows and UNIX Environments.
• Performed Migrations from earlier versions to XI R1/R2/R3/BI 4.0 architectures and recreated security models in all versions of business objects.
• Extensively worked on developing reports using Crystal Reports XI using Business Views.
• Technical expertise in Designing, Implementation and administration of security models with row level data security, role based security in Business Objects
• Experience gathering business requirements and transforming them into appropriate specifications for development team.
• Good working knowledge in Databases – SQL Server 2005, SQL Server 2000 and Teradata

CERTIFICATIONS:

SAP Business Objects certified professional Business Objects Enterprise Level 3

SKILL SET:

RDBMS : SQL Server 2000, Oracle 9i/8i/7.0, Teradata, MS-Access.
ETL Tools : Abinitio, Informatica, Business Objects Data Services
Reporting Tools : BI 4.0, Business Objects XIR3/r2/6.5/5.x (CCM, CMC, Designer, DeskI, Web Intelligence, Supervisor, Reporter, Info View, BCA), Crystal Reports XIR2/XI/10/9x, Xcelsius, Metadata Manager and Lifecycle Management
Change Management : HP Service Desk, Rational Clear Case for versioning.
Operating Systems : Windows 2000/2008/XP/NT 4.0/98, UNIX, Sun Solaris, Linux.
Web Technologies : IIS 4.0/5.0/5.1 Server, Web Sphere Application Server, Java, Java Script, SQL, PL/SQL, CSS, ASP.NET, VB.NET HTML and UNIX Shell Scripting
Microsoft Tools : MS Office, MS Excel, MS PowerPoint, MS Outlook, MS SharePoint
GUI Tools/IDE : .NET Frame Work, Visual Basic 5.x/6.0, MS Word, MS Excel, Developer 2000.

EXPERIENCE:

Confidential, Richmond, VA April ‘10– Present
Business Objects Architect/SME

• Member of Business Intelligence Platform/Production Support team.
• Designed SAP Business Objects Architecture based on Sizing requirements with good capacity projection.
• Installed and Configured the Business Objects Enterprise from XI R3 to BI 4.0
• Responsible in upgrading SAP Business Objects XIR2 to XI3.1 SP3
• Expertise in SAP Business Objects XI3.1 installation /configuration /implementation and support in a Windows 2008 environment, IIS/TomCat, Teradata, Oracle 10g, and SQL Server 2008.
• Working with SAP HANA/BW project team to integrate SAP HANA/BW and SAP BI.
• Production trouble shooting, report and dashboard debugging and testing, post-Implementation review of new/changed reports and dashboard\'s maintenance of a custom reporting solution used for client reporting
• 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 and Configured Metadata Manager on Standalone Server and clustered with Production environment for better performance.
• Established process & methodology to identify the fixes and impact on customizations in jsp’s from BOXIR2 SP2 to XI R3 version
• Resolve all issues related to Business Objects (including all server, network, database, SSO and client applications) functionality – coordinate troubleshooting activities with SAP Business Objects Technical Support and required resources - all break/fix issues
• Develop and deploy crystal report and Webi report, universe, and dashboard design standards for all customers
• Creating new Universes in Business Objects XI R3 and applied row level and object level securities to restrict sensitive client information
• Creating new classes, objects and conditions, detected cardinalities and loops and resolved the loops by creating Aliases and Contexts and checked the Integrity of the Universes.
• Exporting the universes to the Repository to make the resources available to the users.
• Grant users access to XI folders
• Folder/Group Setup/Assign users to groups (Security) (as approved)
• BO XI Enterprise maintenance and testing Database connections
• Decommission reports (Crystal, WebI) as requested by COF (through the release strategy process)
• Monitor and manage HPSD requests
• Setting Sitescope alerts for all servers

Environment: SAP Business Objects 4.0,Business Objects XI R2 and XI R3 3.1, Crystal Reports XI Release 2, Xcelsius, Metadata Manager, Lifecycle Management, SQL SERVER 2005, Teradata, Oracle, Web Intelligence XI R2, Windows Server 2008

Confidential, Dallas, TX Feb ‘08– Mar ‘10
Business Objects Administrator/SME

• Installed and configured Business Objects XIR2.
• Created CMS, PM and Audit Databases on SQL Server 2005.
• Installed and Configured Business Objects on Both Client and Server Installations.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Configured Central Management Server (CMS) Cluster on Windows 2003 and Unix server.
• Maintained Central Configuration Manager (CCM) for Administration
• Maintained Central Management Console (CMC) for Folder Level security set-up, Report Scheduling, Users, User Groups, Servers and Server Group administration.
• Configured Desktop Intelligence, Web Intelligence Job Servers for Scheduling Purpose.
• Analyzed BOXI Premium License Keys, also Maintained Concurrent and Normal Users
• Created Profiles for Report Busting in BO XIR2 assigning through Profile Targets and Values.
• Involved in interacting with business users, gathering and analyzing source data for enterprise data warehouse schemas.
• Customized webi with Webi SDK and integrated with java portal
• Created standards for Universe and Report designing.
• Created standards and sign-off sheets for the Universe and Report promotions.
• Involved in design development and trouble shooting.
• Created number of users in both Development and Production environments.
• Revised the Group Structure in both Development and Production Environments.
• Scheduled many reports using InfoScheduler.
• Maintain the event-based reporting (EBR) models (Critical Reports, Call Center reports, Operational/ODS reports)
• Proficient in full life cycle design and development of Business Objects reporting Applications.
• Upgraded BO XI R2 environment into BO XI R2 SP2
• Interacted with end users regularly in order to gather the requirements.
• Conducted training sessions to educate users about using the Business Objects tools and also about the user management.
• Presentation of the advanced features of Business Objects to end-users to enable them to develop queries and reports easily.
• Created users/groups and defined privileges using Central Management Console.
• Installed Performance Management and created Repository in XI r2.
• Migrated number of reports from Dev /Test to Production environments.
• Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to BO XI environment.
• Publishing Crystal reports to a Business Objects Enterprise system.
• Created reports using Desktop Intelligence and Web Intelligence in BO XI r2 environment.
• Created complex reports using Business Objects Crystal Enterprise XI & X.
• Manually scheduling the recurring reports.
• Performed the knowledge transfer to other team members. Provided application and user on-call support

Environment: Business Objects XI R2, Crystal Reports XI Release R2, SQL SERVER 2000, Oracle, Web Intelligence XI R2, Windows Server 2003, UNIX, Teradata

Confidential, India Sep ‘07– Jan ‘08
Abinitio Module Lead, Reconplus Project

• Designed and Development work as per the requirement
• Writing Requirements and Technical Specification to support the Application.
• Application Design, Development and implementation.
• Prepared Unit Test Cases and system Test cases and Review of Test Plans.
• Performed Unit testing and System Testing.
• Perform Knowledge Transfer to team members
• Ensuring extensive usage of Enterprise Patterns (re-usable Ab Initio graphs for specific ETL processes) across all the ETL components developed.
• Closely worked with the QA team for the System Testing phase in non-production environments.
• Coordinating production implementation phase from Offshore

Environment: Ab initio GDE V1.14, SQL SERVER 2000, UNIX

Confidential, India Jun ‘07– Aug‘07
Abinitio Module Lead, FCS Chargeback Project

• Interacting with the client Business Analysts and Technical Leads to understand the requirements and designing the high level ETL flow for the process.
• Implementing performance tuning, coding standards and use of standard and centralized environment wherever possible and following Ab Initio best practices.
• Preparing implementation, rollout and rollback plan and managing the Change Control management process.
• Served as a single point of contact for the client for all the post production technical issues.
• Closely worked with the QA team for the System Testing phase in non-production environments.

Environment: Ab initio GDE V1.14, SQL SERVER 2000, UNIX

Confidential, Dallas, TX Dec ‘06– Feb‘07
Abinitio Module Lead, Integration Project

• Extensively worked on the Design, Development and Unit Testing of Ab Initio graphs and writing UNIX Shell scripts for specific utilities
• Develop technical and detailed design documents for the ETL process.
• Worked with the testing team for the System and Integration testing phase.
• Worked with the Production Support team for the Warranty period to transfer knowledge on the ETL flow and job dependencies.

Environment: Ab initio GDE V1.14, SQL SERVER 2000, UNIX, Microsoft Excel

Confidential, India July ‘06– Dec ‘06
Abinitio Module Lead, Data Exchange – II

• Analyzing user story requirements for each sprint cycle and conducting meetings with the client technical team to get deeper insight on the requirements.
• Creating development estimations and maintaining Project dashboard and technical documents for each module.
• Ensuring extensive usage of Enterprise Patterns (re-usable Ab Initio graphs for specific ETL processes) across all the ETL components developed.
• Closely worked with the QA team for the System Testing phase in non-production environments
• Coordinating production implementation phase from Onsite.
• Built reports with multiple data providers and added slice and dice capabilities.
• Extensively used various techniques like Sectioning, Ranking, and Filtering to develop the reports.
• Tested and migrated reports from Test to Production.
• Worked with the testing team to derive test cases.

Environment: Ab initio GDE V1.13, Business Objects 6.5, SQL SERVER 2000, UNIX, Microsoft Excel

Confidential, Banga Jan ‘05– Jan‘06
Developer, Service Support System

• Extract data from OLTP in the form of requirements.
• Testing and Preparing mapping documentation were part of my responsibilities.
• Developed various reports as per the requirement by using Business Objects.
• Creating new classes, objects and conditions, detected cardinalities and loops and resolved the loops by creating Aliases and Contexts and checked the Integrity of the Universes

Environment: Business Objects 6.5, Informatica 6, Universe Designer, Oracle and UNIX

Confidential, Bangalore Jan ‘04– Dec ‘04
Developer, Business Intelligence Solution

• Interacting with the client technical team to understand specific requirements with respect to various interfaces of the project
• Data are populated to Data mart from large flat files and databases.
• For the ETL Operation Power connect was used to create a logical model of the Data Warehouse and generate Code to Extract, Transform and Load the Data into the Data warehouse
• Developed Cross-Tab and Drill Down reports.
• Used Broadcast Agent to schedule the reports
• Worked with multiple Data providers in a report and added slice and dice capabilities

Environment: Business Objects 6.5, Informatica 6, Oracle, Java and UNIX

Bachelor of Electrical and Electronics Engineering, Confidential, India