Professional Summary:

• Over 7 years of experience in Information Technology with strong work experience as Business Objects Administrator / Developer.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance /Prod Support of Business Intelligence BO
• Strong Experience in Sizing/Virtualization, Application Installation and patching, Configuration, Migration, User authentication and Single Sign On SSO AD/Enterprise.
• Worked with all modules of Business Objects enterprise CMC, CCM, Import Wizard/UMT, Designer/UDT, DeskI/WebI, InfoView/Launchpad, Dashboards and its deployment.
• Substantial experience in BO Server Management, Security Model Design, User Group configuration, BO Content Promotion Import Wizard/ Promotion Management .
• Experience with Business Objects Security Implementation Row level, Object level , Connection level in both XI 3.1.x and XI4.1.x
• Experience in multiple migration project XIR2 to Xi3.1 and XI3.1 to Xi4.0 , report conversion projects DESKI to WEBI
• Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP OLTP data and complete lifecycle of project from design to development and implementation.
• Sound understanding of Dimensional Modeling, designing Star and Snowflake Schemas
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps Chasm, Fan and Loops.
• Proficiency in working with functionalities, Linking universe, Aggregate Awareness and other advanced functionalities.
• Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Hands on experience in developing Analytical Dashboard using Xcelsius with Qaaws and Live Office connectivity
• Participated in all phases of Software Development Life Cycle SDLC Requirement Analysis, Design, Development, Testing and Documentation .
• Experienced in Training Supporting end-user reporting needs / T-shooting issues on the go. Also, provided full prod support 24/7.
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals. Capable of working as a Team Member or Individually with minimum supervision.
• Have extensive working knowledge of all stages of Business Intelligence development in Human Resource, Payroll, Insurance, Manufacturing, pharmaceutical, and healthcare Industries.

Technical Skills:

• Operating Systems: Windows 2000/2003/R2/2008/XP/ Win7, Sun Solaris, UNIX.
• Business Objects/DW Tools : Business Objects XI 4.1/4.0/3.1/XIR3/XIR2 ,Performance Manager, Dashboard Manager, Info View, LaunchPad, Instance Manager, CMC, CMS, CCM, Designer, Query Builder, Data Federator, Auditing, Server Monitoring, Repo Diag tool, Crystal XCelsius 2008/ 4.0,BO SDKs, Tibco Spotfire, RoamBi, etc
• Reporting Tools: Business Objects WEBI, DESKI, Crystal Reports 8.0/9.0/10/XI/XIR2, 2011, CR for Enterprise, Excel 2000/XP, Qlikview, Actuate, Spot fire, Web Focus, SSRS Etc RDBMS: ORACLE 8i/9i/10g, MS SQL Server 2000/2005/2008,Teradata, MS Access, Sybase12.0.. Project Management Tools: Software Design Life Cycle SDLC , Agile, SCRUM, Joint Application Development
• SQL Utilities: TOAD, SQL PLUS, Query Builder BO
• ETL Tools: Informatica Power Center/ Power Mart 7.1/6.2/5.1, SSIS
• Packages: OLTP OLAP, ODBC/API, ADO, DAO, OLEDB, XML, SSRS, SSIS, CMS,CMC, Full Life-Cycle Development, Star and Snowflake Schemas, Executive Dashboards, Oracle SQL Developer, SQL Plus, SQL Loader, Microsoft Visual Source Safe, MS Office, Server studio, Data Integrator 11, BMC analytics. 4

Professional Experience:

Confidential

Role: SAP Business Objects Administrator/Developer

• Confidential is a Provider of human resources and services serving businesses worldwide with customers in the USA, Canada, Europe and Mauritius. Business Objects Provides Ceridian external clients a suite of BI applications to view, develop, analyze and schedule their signature Payroll /HR payroll and Workforce management report data from multiple Ceridian external systems.

Responsibilities:

• Migration from XI3.1 to XI 4.0 which includes Sizing, Virtualization, installation, configuration and maintaining and also responsible for applying service pack and fix pack to BO installation.
• Designed ETE security model for BO applications based on internal and external users InfoView Viewer , Report Writer , Power user and Admin master using custom access level.
• Promoted Universes, Reports, Securities and other BO content from the Development to Production environments after System Integration Testing SIT and then followed by Business Acceptance Testing BAT . Used Import Wizard/PMT for the promotion process across the environments.
• Worked on Configuring Single Sign-On SSO enterprise authentication using BO SDKs for BO integration as OEM with client external UIs.
• Configured Business Objects Servers and its associated services in a clustered environments to target max application performance.
• Identified BO product /other issues and worked with SAP to make sure the fix was applied in the future patch deployment list. Also, recently worked with SAP on launchPad UI customization to accommodate business requirements.
• Ensured all the environments are in synchronization and checked supported environments and hardware requirements from the Products Availability Report PAR document for the new installation.
• Worked with .net resource to help integrating BO into external systems using web services and .net APIs.
• Creation of new PowerPay service folders in CMC and implementing security in CMC at folders, Applications, Universe and Connections layer using brand new custom access level.
• Involved in building of Universes for HR/Payroll/EIM making extensive use of Universe Optimization Techniques such as Custom LOV, Shortcut joins, Aggregate Awareness, Index Awareness and other unv optimization techniques
• Created Joins, Contexts, and Aliases for resolving Loops and traps Chasm/Fan
• Configured access restriction sets Object Level/Row Level/Connection level at universe level to differentiate universe objects/data/DB connections for US and Canadian customers.
• Developed and tested reports based upon data generated by enterprise Payroll and customer information systems using Business Objects
• Extensively used WebI reporting functionality including Sorting, Hierarchies, Drill Down, Filter, Cross Tab, Functions, Report Layout, Prompts, Bar-Chart reports, Aggregates and formatting.
• Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.
• Worked on translating universe and reports in French language using Translation Manager Tool TMT
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
• Been main point of contact in the business meetings and Internal/external users for explaining the functionalities and application behavior of SAP Business Objects.
• Extensively worked with Network/firewall/sys admin teams during post OS security patch/Network updates validation. Arranged meeting with appropriate teams as necessary.
• Responsible for production support and resolving/trouble shooting issues like application latency issues, access issues, reporting, missing web app functionalities on the go. Also provided basic support on our three external UI systems CESA / IAM /InView which are integrated with BO as Original Equipment Manufacturer OEM .

Environment:

SAP Business objects XI4.0 SP6, XI 3.1 SP2/SP4.3, OEM Model, WEBI, Dashboards SQL Server 2008, Windows 2008/2003 R2, SSIS 2008, .Net Visual Studio 2010 professional, ASP .Net, Team Foundation Server TFS 2010, ClearQuest.

Confidential

Role: SAP Business Objects Administrator

Responsibilities:

• Extensively worked on CMC in maintaining Reports, Universes, Connections, Resources, Users User Groups, Categories and it's security model in BO XI 3.1
• Effectively administered and supervised the Business Objects SAP BI environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Identified gaps and Re-designed the entire security in development, test and production environment
• Worked with servers and server configurations on distributed Clustered servers using CMC and CCM.
• Responsible for Production Deployments. Promoting Business Objects Deployment to PROD and Non-Prod environments Dev to SYT, SYT to SIT, and SIT to PROD using Import Wizard.
• Scheduled the reports according to the user requirements based on the Oracle database connectivity
• Installing and testing Business Objects SP5 service pack in test environment
• Been main point of contact for validating Post OS patch or BO auto application maint to make sure ETE BO applications are running as expected involving network/system admin teams accordingly if any issue occurs.
• Maintenance of Security, Universe , Document Domains and row level Security.
• Published the business objects reports based on the user requirements.
• Expertise in Resolving the Daily issues in Production Environment.
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode were used for Multidimensional Formatting.
• Assisted with Unit, SYT, and SIT testing with HP Quality centers.
• Conducted the User Acceptance Testing procedures.
• Coordinate with Client CIGNA and presentation of proposed fix for the defects
• Working through the phases of SDLC using the agile methodology.
• Knowledge on Cerner solutions which helps optimizing service processes for healthcare organization.

Environment:

Business objects 3.1SP2, Crystal Xcelsius 2008, Crystal reports 2008, Oracle 10g/11g, Business view manager, MS Visio 2007, Quality Centre and Informatica 9.0.1 /Windows 2003 R2

Confidential

Role: Business Objects Administrator/ Developer

Responsibilities:

• Involved in Installation, Configuration, Security Model and Administration of Business Objects Xi3.1 SP1
• Responsible for migration of 15 universes and 400 corporate documents from XIR2 to Xi3.1
• Converted all existing DEKI reports to WEBI using Report Conversion Tool RCT .
• Implemented Single Sign On using AD Authentication.
• Importing the users from Active Directory group into Business Objects and providing the users and groups
• Implemented disaster recovery for the production environments.
• Wrote steps for daily back up of Input / Output FRS and the CMS database/repository
• Managed existing Servers, Server Groups, Folders, Objects, Universes, Connection applications from CMC and CMS.
• Worked with Central Management Console CMC to create folders, set security levels, managed the access privileges and scheduled the reports.
• Performed frequent daily BIAR back-ups.
• Implemented Row-level security using Designer and Applications ,Object-level security using CMC
• Responsible for scheduling the reports on a daily, weekly and monthly basis .Scheduled reports based on file events and used publications for report bursting.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance.
• Created linked objects in the Universe to enable contextual report linking hyper linking between Business Objects and Web Intelligence reports.
• Created graphical representation of reports such as bar charts, pie charts as per the end user requirements. Created reports using built in templates for a better presentation.
• Extensively used WebI reporting functionality including Sorting, Hierarchies, Drill Down, Filter, Cross Tab, Functions, Report Layout, Prompts, Bar-Chart reports, Aggregates and formatting.
• Developed Dashboards using Xcelsius 2008 to build flexible dashboards giving users a top-level view of key metrics and the ability to drill down from any metric to the operational detail
• Used Live Office and QaaWS to provide up to date Data for the dashboards
• Implemented Daily finance data for company Dashboard using Dashboard Design for easy tracking of daily performance.
• Implemented Dashboards that allow executives to analyze Purchase Orders which were complete within budget and time limits.
• Involved in Ensured all the environments are in synchronization and checked supported environments and hardware requirements from the Products Availability Report PAR document for the new installation.

Environment:

Business Objects XI R2/3.1, InfoView, Web Intelligence, Dashboards, CMC, CCM, Import Wizard, Oracle 10g, Windows 2003 server/UNIX, Live Office/QAAWS, Performance Management, Xcelsius 2008.

Confidential

Role: Business Objects/SQL Server Developer

Responsibilities:

• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to resolve loops.
• Updated the existing Universe by adding new tables, Classes, Objects and creating predefined conditions and prompts for the new reporting requirements
• Creating and Formatting the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, functions and formulae to analyze the data using Desktop Intelligence/Web Intelligence.
• Applied security features of Business Objects like row level object level security in the universe so as to make the sensitive data secure.
• Creating and distributing Report Templates to Users, Enabling the Reports using desktop intelligence.
• Created custom LOVs List of Values and Hierarchies for drilling down to lower levels in the reports.
• Developed reports using both Full client and WebI. Used Java report panel and HTML report Panel in the process of creation of reports.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Experience in managing Alerts, Security and Isolation levels.
• Performed Backup and restore of databases
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User notes

Environment: Business Objects XIR2 SP1, Desktop Intelligence, Web Intelligence, Designer, SQL server 2005, SSIS, MS-Access, Windows 2000.