PROFESSIONAL SUMMARY:

• Business Object Administrator / Architect with 9 years of professional experience in IT industry developing, testing, administrating and supporting for Business Intelligence Data Warehouse environment.
• Exceptional ability in simultaneously creating new and modifying existing multiple reports using various versions of Business Objects XI 4.0/4.1/3.1/3.0/ XI R2/6.x and advanced functionalities like Optional Prompts, Data Tracking, Queries Slice and Dice Analyzer Tool, Drill Down, functions, cross tab, detail, formulas, variables and other functionalities employing all phases of Software Development Life Cycle (SDLC) of Business Intelligence Applications such as developing, testing, migrating and production support.
• Remarkable successes in designing and developing complex and large scale financial reports in Deski, Webi Rich Client, Infoview, Crystal reports underlining her hands on experience in migrating Business Objects 6.5/XI/BI 4.0/4.1
• Adept at extracting data from different databases such as Oracle 11G/10 G/9i, SQL Server 2010/2012, MS Access - 2010 with strong competency in Data Mart, Star Schema, Snowflake Schema, data requirement analysis and implementation of business applications emphasizing her expertise in BO Security, Folders, Groups and other related admin tasks.
• Working with multiple Universe development environment and BO Reports components packaging (BIAR) involving numerous client interaction with Business Applications, Business Data Flow and Data Relations.
• Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Maintained and managed versions of reports using Version control Management.
• Responsible for migration of universe and reports between different environment using Promotional Management
• Troubleshooting production environment/ monitoring the server performance.
• Worked on Auditor and Query builder to track and monitor the performance and troubleshoot BO Environment and end-user report issues.
• Regularly synchronized the DEV, Stage environments with Production reports.
• Responsible to support the issues with reports on the Business Objects Enterprise environments (Development, Test, UAT and Production)
• Administered day-to-day user activities with CMC.
• Used the Report Conversion Tool to convert legacy Desktop Intelligence Reports to Webi XI 3.1.
• Technical expertise in BO XI /BI 4.0(Designer, Desktop Intelligence, Web Intelligence, CMC,CMS)
• Worked on Information Steward to get the report list based on database tables/universe.
• Controlled the security system for all environments (Production/Stage/Development)
• Created groups for the users, folders for the reports and assigned rights to the user accordingly. Created object-level security in the universe for a group of users.
• Effective co-ordination/communication between Business users and other Technology team such as database administrators, business object administrators. Lead off Shore team and had active communication for report development and production support.
• Excellent understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products and outstanding ability to manage and deliver results on multiple tasks by effectively managing time and priority constraints.

TECHNICAL SKILLS:

Operating Systems:: Windows 2008/2010/2012 Server, UNIX, Linux and Solaris, Windows NT4.0, Windows XP Professional.

Languages: SQL, T-SQL

BI Tools: Business Objects BI 4.0/XI3.1/6.5.1,BO Supervisor, Universe Designer XI 3.0/R2, Webi XI/6.5.x/4.0 Dash Board Manager XI, Performance Management, Auditor 6.5.1,Webi SDK, ZABO, BCA, Live Office, Query as web service, Import Wizard, Business View Manager, Data Integrator, Crystal Reports Explorer, Report Conversion tool, Upgrade Management Tool, Version Control Management, Promotional Management, Query Builder, Query as a Web Services, CMC, CMS, Information Design Tool, Information Steward.

Databases: Oracle 11G/10G/ 9i, SQL Server 2000/2005, MS Access-2000

Web/Application Servers: IIS6.0, Tomcat 5.5, Apache

Other Tools: Crystal Xcelsius, Visual Source Safe, Vision, MS Project, MS Office, MS Word, MS Excel, MS Power point, TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Business Objects Administrator/ Architect/ Developer

Responsibilities:

• Successfully design, build and implement the BI 4.1 SP5 infrastructure with Clustered/Distributed environment
• Worked on extensively on Business Objects Implementation/ Windows Administration/CMS/CMC/Security/Tomcat Apache.
• Installed, Troubleshoot, upgraded SP and maintained the various Business Objects Servers.
• Installed Clustered/Distributed Production BI 4.1 SP5 on Windows 2008R2 server with CMS/Audit databases on Oracle 11g.
• Successfully implement SSO between Business Objects and Other Enterprise Applications using Enterprise Trusted Authentication
• Trouble shoots BO Infrastructure server hangs, crashes issue, reading thread dumps in critical Production environment to find root cause and respond timely manner to fix the issue. Initiative to address root cause in problem resolution.
• Promotion of Universes, Reports, Users, Groups, User Rights and Privileges from different environments Dev, IST, QA, Perf Test, UAT and Production.
• Managed access level for user and user group through CMC.
• Periodically worked on auditor/monitor in CMC to check the performance of reports in various BO environment.
• Worked with networking team to enable/configure required ports, firewall rules and implement load balancing/fail over content switch rules using Cisco load balancer.
• Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universes and published reports.
• Created reports using Business Objects functionalities like Queries, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Responsible to process Data mining activities to gather data and compile it to make a thorough analysis.
• New Implementation of Business Objects 4.1 and build new universes/reports.
• Worked on migrating legacy reports to BI 4.1
• Updating databases, systems and business intelligence tools.
• Created Data Visualization dashboard using SAP Business Objects Xcelcius Dashboard/ Lumira Dashboard.
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
• Responsible for writing the SQL queries for the data validation and testing the reports.
• Created mapping documents to outline data flow from sources to targets.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.

Skills Utilized: Business Objects Enterprise 4.1 SP5, Web Intelligence, Explorer, Dashboard Designer BI 4.1, Oracle 11G/SQL Server 2008, Enterprise Data warehouse EDW oracle 11G, Windows Server 2008, Central Management Console CMC, Central Management Server CMS, Information Design Tool, Explorer, Query Builder, BIAR, Upgrade Management tool BI 4.1, Promotional Management tool BI 4.1, Informatica Power Center 8.6, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer, TOAD

Confidential, CA

Business Objects Administrator/ Architect/ Developer

Responsibilities:

• Done full implementation of Business Objects 3.1 XI
• Successfully upgraded to 3.1XI to BI 4.0 SP5 (Standalone/ clustered servers)
• Successfully design, build and implement the BOXI 3.1 SP2 infrastructure with Clustered/Distributed environment.
• Installed Distributed Non Production BOXI 3.1 on Windows 2003 server with CMS/Audit databases on Oracle 11g.
• Installed Clustered/Distributed Production BOXI 3.1 on Windows 2003 server with CMS/Audit databases on Oracle 11g.
• Conduct network impact assessments, capacity planning and testing on infrastructure and all BO components to ensure environment and report to meet SLA
• Enabled and configured necessary ports on BOXI servers to establish client server connectivity.
• Test and fine tune the entire BO infrastructure, including server parameter configuration and tuning, sizing the environment based on the business requirements.
• Updated and Applied BOXI 3.1 SP2 and required Fix Packs to Production and Non Production environments.
• Performed Administrative tasks like Setting up user profiles, assigning rights and privileges for groups, setting up categories using CMC, and maintain Bo servers.
• Trouble shoots BO Infrastructure server hangs, crashes issue, reading thread dumps in critical Production environment to find root cause and respond timely manner to fix the issue. Initiative to address root cause in problem resolution.
• Experience in Training & Supporting end-user reporting needs using Business Objects.
• Worked with Developers/Business Users to consolidate the Business Objects reports / repository before upgrade to BI 4.0.
• Worked on Report Conversion tool Deski reports to Webi Report and Upgrade Management Tool/Life Cycle Management (LCM). Responsible for applying service pack and fix pack to BO installation and also deployed WAR files after upgrade. .BIAR Backup used for selective content recovery
• Interacted with Business users and managers in gathering business requirements.
• Analyzed, documented business requirements, functional requirements for developing universes and reports.
• Extensive Data analysis in order to create appropriate reports/universe for the users.
• Interacted with Users to know their Business views while gathering the report requirements and provided Several Report Mock-ups to finalize the requirements.
• Validated with business owners and stakeholders the current business rules to determine functional and technical requirement.
• Designed and maintained complex universes, resolved loops by creating aliases and contexts.
• Implemented object level security universe to in corporate security for sensitive information.
• Customized Universe level Prompts, filters, aggregate awareness as per functional requirements.
• Managed user row level security at universe level to customize data access for user groups.
• Created derived tables in the universe designer and custom SQL reports to enhance the capabilities of the report.
• Worked on @functions and custom LOV’s and cascading hierarchy.
• Wrote complex views, SQL, to be used in reports development on Enterprise Data warehouse EDW oracle database.
• Worked on ad-hoc and canned Web Intelligence reports.
• Design and developed information space and explorer views using explorer in BI 4.0.
• Coordination and work along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them.
• Recommended standards of good practices of report development and maintenance of universes.
• Managed overall performance tuning of reports/universe.
• Created and maintenance of universe connection in all environments
• Consolidate the Business Objects repository before migrating to BI 4.0.
• Migrated Web Intelligence reports and Universes from Business Objects 3.1 to BI 4.0 environment.
• Designed and developed dashboard using Dashboard designer.
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, SQL server 2010 and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, Filter, Expression and Update Strategy.

Skills Utilized: Business Objects Enterprise XI 3.1/BI 4.0, Universe Designer, Info view XIR3/ BI launch pad BI 4.0, Web Intelligence, Explorer, Desktop Intelligence, Dashboard Designer BI 4.0, Xcelsius 2008, Report conversion tool XI 3.1, Oracle 10G/SQL Server 2008, Enterprise Data warehouse EDW oracle 10G, Windows Server 2008, Central Management Console CMC, Central Management Server CMS, Information Design Tool, Information Steward, Explorer, Query Builder, BIAR, Upgrade Management tool BI 4.0, Promotional Management tool BI 4.0, Import wizard (BO 3.1), Informatica Power Center Designer 8.6/8.1, Informatica Repository Manager, Erwin, TOAD.

Confidential, NY

Business Objects Administrator/ Developer

Responsibilities:

• Performed Installation, configuration and administration of Business Objects XIR2 Enterprise Environment.
• Created users, groups and folders in BOXI3.1 Environment and applied Row and Object Level Restrictions.
• Created Enterprise Level Security Setup in BO XI3.1 Enterprise environment using Central Management Console.
• Migrated reports between environments using Import wizard. Created user and user groups and access level in CMC
• Monitoring and maintenance and troubleshooting BO server issue. Production support 24/7.
• Worked with business users to define product feature requests, business requirement specifications and change request, documented requirement and transformed them into functional and technical requirement specifications. Experience and proficiency in preparing planning documents.
• Develop complex universe and fine tuning the performance of universes.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies
• Used @functions like @select, @where and @prompt function to create prompts which helps the user to select the values dynamically
• Customized the list of values (LOV’s) which helps the end users to select the values.
• Maintained developed applications, and handled the change requests to modify existing Deski, Webi reports and universes.
• Developed Web intelligence reports with complex calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice and Alerter.
• Used Xcelsius to build Dashboard reports for top level management
• Created and maintained several web intelligence reports for the client using Business Objects Web Intelligence.
• Worked in a production support role where in typical issues have been resolved.
• Designed, developed and tested reports based upon data generated by enterprise transaction, customer information system using Business Objects
• Validated the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.

Skills Utilized: Business Objects Enterprise XI R3.1, Universe Designer, Info view XIR3, Web Intelligence, Desk top Intelligence, Xcelsius 2008, Oracle 10G, Windows Server 2008, MS SQL Server 2008.

Confidential, VA

Business Objects Administrator/ Developer

Responsibilities:

• Performed Installation, configuration and administration of Business Objects XI 3.1 Enterprise Environment.
• Key role for Designing Architecture for New BO XI Migration and Prepared Migration Plan. Successfully Migrated Business Objects system from Business Objects XIR2 to BOXIR3.1
• Responsible for migration of Universes, Connections, Full Client / WebI Reports and Personal/Inbox documents from the existing versions to new version.
• Converted migrated Full Client reports to WebI reports using Report conversion tool.
• Created Enterprise Level Security Setup in BOXI3.1 Enterprise environment using Central Management Console. Worked on Import wizard for migrating reports & universes.
• Involved in testing (Users, Universes and Reports (FC/WebI) throughout the migration process across the old system.
• Monitoring and maintenance and troubleshooting BO server issue. Production support 24/7.
• Review and study requirements gathering and business analysis and Data analysis JAD and pre JAD session interacted with the end user.
• Review Physical design, defined data types, Constraints, Indexes. Designed the Data Mart defining Entities, Attributes and relationships between them.
• Created List Reports and Cross Tab Reports and Drill Through reports. Worked with the Business users in generating Canned & Ad-Hoc reports for business use
• Worked on Dimensional modeling to design and develop Star Schemas in Universe Designer.
• Developed complex SQL codes at the database level Oracle 10g and Teradata.
• Created new Business Object reports and modified existing reports using Business Objects advanced functionalities like Optional prompts, Data Tracking, Queries- Slice and Dice- Analyzer Tool, Drill Down, @Functions, Cross Tab-, detail, formulas, variables and other functionalities.
• Designed and developed new Business Objects Universes and modified and maintain the existing Universes based on the report requirements.
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking

Skills Utilized: Business Objects Enterprise XI R3.1, Universe Designer, Infoview XIR3,Web Intelligence (Webi),, Oracle 10G, Teradata, Apache Tomcat, and Windows Server 2008, Import wizard.

Confidential, NY

Business Objects Administrator/ Developer

Responsibilities:

• Designing Architecture for New BO XI Migration and Prepared Migration Plan. Successfully Migrated Business Objects system from versions BO 6.5 to Business Objects XIR2.
• Responsible for migration of Universes, Connections, Full Client / WebI Reports and Personal/Inbox documents from the existing versions 6.5 to XIR2 using Import Wizard.
• Converted migrated Full Client reports to WebI reports using Report conversion tool.
• Studying the Data model during requirements gathering and interacted with end user for through understanding of the business requirement and creating reports.
• Designed, created and maintained Universes and created complex reports in DeskI and WebI.
• Created and maintained the universes and reports with formulas and techniques, migrated from development to test and to production environment.
• Created standard and Ad hoc reports using Business Objects
• Worked the Import Wizard extensively to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to move from one environment to other.
• Maintained the users and groups within multiple Global projects for application level security management.
• Published and scheduled reports/documents in Business Objects environment.
• Utilized performance tuning of reports in production environment, by tuning queries.
• Converted Deski reports to Webi Report using Report conversation tool.
• Created documentation for developed reports and simultaneously worked on multiple projects.
• Developed parameterized reports, which can be emailed and exported to User in Excel and PDF formats.
• Manage promotions between environments, version control and rollback functionality and dependency checking using CVS
• Xcelsius Various other forms of dashboard development, Data from Universe using QAAWS, Data from Webi reports, Crystal Reports using Live Office etc.
• Scheduled and maintain reports using CMC

Skills Utilized: Business Objects Enterprise XI R2/R3.1, Web Intelligence (Webi), Desktop Intelligence (Deski) Universe Designer, Info view XIR3/R2, and Oracle 10G, Apache Tomcat, and Windows Server 2003.

Confidential, NY

Business Objects Administrator/ Developer

Responsibilities:

• Performed Migration of Business Objects system from version BO 6.5.1 to Business Objects XIR2.
• Responsible for migration of Users, Universes, Connections, Full Client / Web I Reports from the existing version 6.5.1 to XIR2.
• Created new users in XI R2 using Central Management Console and set restrictions, assign privileges based on their profiles.
• Scheduled Business Objects reports through BCA Console in on regular intervals.
• Participated in Requirements Gathering and Business analysis
• Worked with the ETL team to create Automated Daily Load Status Check reports to validate the data between source and target data marts.
• Created and maintained complex Universes, classes, objects, conditions, joins and prompts.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes
• Maintained developed applications, and handled the change requests to modify existing Deski, WebI reports and universes.
• Developed reports with complex Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice and Alerter.
• Migrated Business Objects Universe and Reports from versions 6.5.x to Business Object Enterprise XI R2 version.
• Created users and groups and applied row level and objects level securities and object securities using CMC.
• Managed and configured Servers (File Repository Server, Report Application Server, Web Intelligence Server, Destination Job Server, Program Job Server, Event Server)
• Created reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc.
• Scheduled the reports to run daily, weekly and monthly, distributed the reports to the users via e-mail.
• Monitored failed reports. Exported reports in Excel, PDF and saved on Shared Network drive, e-mailed to users as per the requirements.

Skills Utilized: Business Objects Enterprise 6.5/XI R2, Info view XIR2, Web Intelligence (Webi), Desktop Intelligence(Deski), Universe Designer, SQL Server 2005,SQL,IIS6.0, Visual Source Safe and Visual Studio.Net 2005,Windows Server 2003.

Confidential, NY

Business Objects Administrator/ Developer

Responsibilities:

• Developed full client and WebI reports using Business Objects version 6.5.
• Gathered user-requirements/feedback, implementing them in reporting applications, testing, QA and delivery.
• Designed, created and maintained Universes.
• Trained power users to take advantage of the Business Objects environment for Ad Hoc query and report development.
• Created reports using two universes and multiple linked queries, Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerters, and Formatting Presentation Styles (Graphical).
• Documented report functionality for production support.
• Designed and developed reports using commands in report designer and passed data dynamically to designed reports using record set. The record set contains the user-selected parameters in the query. The reports generated run very quickly, as the query is applied at run time to the report.
• Created custom reports i.e. passed data to Excel application based on run time parameter selection from VB Application.
• Created Complex Universes and linked with the existing universe as needed.
• Managed cluster environment for better load balancing of various jobs for better server response times.
• Scheduled the reports using BCA.
• Handled Reporting Help desk support. Managed User cases using User Ticket Management System Software and escalated cases to other groups.
• Administered of Business Objects Enterprise Production Environment.
• Extracted data from various databases for developing reports.

Skills Utilized: Business Objects Enterprise XI, Business Objects 6.5,Webi 6.5,Infoview, Crystal Reports 7.0/ XI, SQL Navigator, Oracle 10 G, Crystal report 7.0, IIS6.0,Windows Server 2000.