SUMMARY

• Business Object Reports Developer/Data Analyst/Administrator with 9 years of professional experience in IT industry developing, testing, administrating and supporting for Business Intelligence Data Warehouse environment.
• Worked as a lead developer mentoring group of technical resource business objects administer/developers onshore and offshore.
• Exceptional ability in simultaneously creating new and modifying existing multiple reports using various versions of Business Objects XI 4.0/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/BI.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.
• TEMPEffectively administered and supervised the Business Objects environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• 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.
• Responsible to support the issues with reports on the Business Objects Enterprise environments
• 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/4.1(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)

TECHNICAL SKILLS:

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

Languages: SQL, T-SQL, PL/SQL

BI Tools: Business Objects XI3.1/ BI 4.0/4.1,BO Supervisor, Universe Designer XI 3.0/R2, Webi XI/6.5.x/4.0/4.1 Dash Board Manager XI/Dashboard Designer BI 4.0, 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 IDT, Information Steward.

Databases: Oracle 11G/10G/ 9i, SQL Server 2010/2012, MS Access-2010,Teradata

Web/Application: ServersIIS6.0, Tomcat 6.5, Apache 7.x ETL Tool Informatica Power Center 8.x/9.x, SQL Server Integration Services (SSIS) 2010.

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

PROFESSIONAL EXPERIENCE:

Confidential, CA

Responsibilities:

• Lead the tool standardization exercise to minimize the BI tools used in the organization.
• Leading and managing an enterprise-wide effort of identifying the Key Performance Indicators (KPIs) across all the domains of the organization.
• Building and maintaining relationships with the business partners to keep their active engagement in the BI projects.
• Conducted presentations for the senior leadership to communicate the status and escalate any issues requiring their intervention. Mentoring group of developers.
• Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart noledge 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
• 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.
• Updating databases, systems and business intelligence tools.
• Created Dashboard using SAP Business Objects Xcelcius 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.

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

Confidential, CA

Responsibilities:

• Building and maintaining relationships with the business partners to keep their active engagement in the BI projects.
• Assigning work to the team and managing group of developer onshore/off shore. Responsible for overall project delivery.
• Conducted presentations for the senior leadership to communicate the status and escalate any issues requiring their intervention.
• Established and enforced a standard format for the delivery of the data to the Enterprise Data Warehouse (EDW).
• Done full implementation of Business Objects 3.1 XI and Migrated to 3.1XI to BI 4.0
• 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 no 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 incorporate 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.
• 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 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.
• Maintenance and troubleshooting BO server’s issues using CMC/CMS.
• Responsible for migration of reports and universe between the environments through promotion management
• Maintenance of difference version of reports using version management.
• 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.
• Experience in Training & Supporting end-user reporting needs using Business Objects.
• Transferred CMC data between old and new version BI 4.0 either through CMC/BIAR File
• Designed and developed dashboard using Dashboard designer.

Skills Utilized: Business Objects Enterprise XI R3.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).

Confidential, NY

Responsibilities:

• 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
• Migrated reports between environment using Import wizard
• Created user and user groups and access level in CMC
• Monitoring and maintenance and troubleshooting BO server issue.
• Used Life Cycle Manager to create, copy, Edit and scheduled a job and maintained & managed different versions of the same document using Life Cycle Manager.
• 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

Responsibilities:

• 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 and maintained several custom reports for the client using Business Objects
• Generated reports using BO tools querying database.
• Created List Reports and Cross Tab Reports and Drill Through reports.
• Worked on Dimensional modeling to design and develop Star Schemas in Universe Designer.
• Worked with the Business users in generating Canned & Ad-Hoc reports for business use.
• 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.
• Worked with BO CMC Module for creating Users and User Groups for different teams and setting privileges, maintain folders.
• Scheduled reports using CMC
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking
• Created and updated multiple universes and resolved Loops by creating table aliases and contexts.
• Worked on Import wizard for migrating reports & universes.

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

Responsibilities:

• 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

Responsibilities:

• Participated in Requirements Gathering and Business analysis
• 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

Responsibilities:

• Developed full client and WebI reports using Business Objects version 6.5.
• Gatheird 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 me.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.