Professional Summary

• Over 7+ years of proven experience in all Software Development Lifecycle stages of decision support systems with extensive use of Business Intelligence/tools/techniques, adhering to best practices and industry standards.
• Professionally Certified by Business Objects, acquired SABE210, SABE310, SABE410 certification from Business Objects
• Strong emphasis in Server Administration, maintenance and Support experience in Business Objects
• Vast experience & Expertise in Server Installation and configuration, Server Setup, security implementation, Backup strategies, Creation of repositories
• Diversified experience in functional and technical understanding and knowledge of Business Logic for requirements gathering and designing/developing universes/report to attain that goal.
• Technical hands-on expertise using Business Objects XI 4.1, XI 3.1/3.0/XI R2/6.x/5.x (Designer, CMC, Desktop Intelligence, Web Intelligence and InfoView, Import Wizard, Report Conversion tool, Publishing Wizard, CCM, Live Office, Query As a Web Service, Xcelsius).
• Expertise in Content Migration technique using Import Wizard and Report Conversion Tool for migrating the Universes and Reports between different environments like Dev, QA and Production & between different versions like BO 5.x/6.x to BOXIR2, XIR2 to XIR3/BI4 migration
• Have Extensive Knowledge and exposure with all modules in Business Objects, Business Objects XIR2, and Business Objects XIR3. (Infoview, Web Intelligence, Desktop Intelligence, Crystal Reports, Xcelsius using Live Office & QAAWS)
• Expertise in Creating Universes on different relational databases such as Oracle, SQL Server, Sybase, Teradata.
• Expert in deployment on Various versions of Tomcat, IIS
• Expert in LDAP & Windows AD Authentication, Experienced with SAP BASIS integration
• Sound experience with Business Objects for building report, designing universes and managing user profiles. Proficient in using both 2-tier and 3-tier reporting tools like Desktop Intelligence, Reporter and Web Intelligence.
• Extensively worked on InfoView to create Web Intelligence, Desktop Intelligence Reports using created universe. Extensively Worked on Combination Queries & Multiple Queries.
• Strong exposure to Business Objects Reporting Functionalities such as Master Detailed, Slice and Dice, Drilling Specific Reports, Filters, Ranking, Sections, Graphs and Breaks.
• Experienced in using Java/.Net SDK for integrating Business Objects reports in Java Portals.
• Expert in integration reports in Java frontend using OpenDocument functions.
• Expertise in Creating Xcelsius Dynamic Dashboards using Query As a Web Service Queries & Live Office. Worked on various Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab sets, Canvas Containers, Alerts, Marquee, Dynamic Visibility etc.
• Expert in creating custom code for automating processes like schedules, sequential installations, Disaster Recovery systems, BO services failure notifications, LDAP Refresh
• Proficient in working on Windows XP/2003/Win7 and UNIX environment.
• Experience in SQL, PL/SQL and very good exposure to Oracle 11g/10g/9i
• Very good domain knowledge in Media Industry, aiding in detail analysis of Business requirements and preparation of Analysis documents.
• Experienced in creating Metrics and Analytics to create Dashboards for better decision purpose.
• Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements with strong Problem solving skills·
• Self-motivated, Result oriented team player and quick learner of new concepts and technologies. Excellent interpersonal, project management, Leadership, time management, and presentation skills, communication and documentation skills. Capable of working as a Team Member or Individually with minimum supervision.
• Expertise in requirements gathering, analysis, design, and documentation of the requirements in a format that can be reviewed and understood by both the business and technical teams.
• Flexible and versatile to adapt to new environment with a strong desire to keep pace with latest technologies.

Technical Skills
BI tools: SAP Business Objects 4/3.1/R2/6.x/5.x, Enterprise Suite (Universe Designer, Desktop Intelligence, Web Intelligence, Dashboard Manager, Infoview, Report Conversion Tool, Live Office, QAAWS, CMC, CCM, Import Wizard, Query As Web Service, Life Cycle Manager), Crystal Reports 10/XI/2008, Xcelsius 2008/4.5
Web Servers: IIS, Tomcat Apache 5.0/ 5.5/6.0
Databases: Oracle 9i, SQL Server 2000, Teradata, MS Access, DB2
Design Tools: Erwin 4.x, MS Visio
Programming Languages: SQL and PL/SQL, Java, HTML, VB Script, .Net
Operating System: Windows XP/2003/Win7, UNIX (Sun Solaris 9)

Professional Experience

Business Objects Server Re-Architect, Nov 2011 - Till Date
Confidential
Westlake, CA, USA

IT Division of Baxter BioScience had multiple Business Objects XIR2 Servers supporting reporting for 2000 users across Europe & US territory. This project aimed to re-architect existing platform to centralized XIR3.1 servers bringing in data, users, and configurations from multiple servers to one. New Server is designed & architected with multiple distributed Web Tier & App Tier for 24*7 available fault tolerant system.

Role: Business Objects Server Architect & Migration expert.

Responsibilities:

• Understanding existing XIR2 multiple deployments & environments
• Understanding & analyzing server re-architecture & upgrade needs
• Installing XIR3 Dev, QA, PROD Servers on a distributed platform
• Configuring Servers for fault tolerant & session replication
• Configuring Windows AD authentication & enabling SSO
• Migrating Around 2000 Reports & 2000 Users from XIR2 to XIR3 Servers
• Post migration testing feature & configurations

Environment: Business Objects XIR2, Business Objects XIR3, IIS, .Net SDK, Windows OS, AD Authentication, Import Wizard, CMC, CCM

Confidential, Sept 2011 - Oct 2011
Confidential,
CA, USA
With XIR2 unsupported by SAP, Sony Pictures Entertainment carried this project to evaluate options to upgrade & get on the supported environment. Being first SAP branded Business Objects Version supporting 64 bit processing BI4 was preferred. This project was aimed to define Architecture of new server & upgrade plan.

Role: Business Objects Architect.

Responsibilities:

• Installing BI4 Servers
• Understanding features offered with new product and mapping it to reporting requirements at Sony Pictured Entertainment
• Evaluating features & requirements mapping from existing XIR2 servers to BI4 servers.
• Capacity planning & sizing new Servers considering existing applications & upcoming requests
• Chalking migration & testing plan

Environment: Business Objects BI4, Tomcat, Import Wizard, Report Conversion Tool, Life Cycle Manager, CMC, CCM, JAVA SDK UNIX OS, Windows OS

Enterprise Platform Administration, Sept 2010 - Aug 2011
Confidential, CA, USA
Confidential, has Business Objects as the enterprise wide reporting solution hosting 45 different applications. The enterprise implementation hosts all the application related reporting needs and also meets Business Intelligence needs of the organization. Business Objects Platform Administration project was responsible for the overall functioning of the environment and was responsible for troubleshooting, issue resolution, capacity upgrade, version upgrade, architectural changes of the environment. A 4500-user implementation with 300 user's concurrent usage is handled with multi-region (22 territories) rollout.

Role: Business Objects Administrator and Architect.

Responsibilities:

• Complete administration of the Business Objects platform at SPE.
• Interface and integration solution development across reporting solutions.
• Security design, implementation and audit across Business Objects platforms.
• Live office implementation.
• Monitoring Business Objects environment and responding to the Business Objects related requests.
• Performing Configuration Changes in Business Objects Environment.
• Doing performance checks on Business Objects environment.
• Performing Installation/ Upgrades activities for several Business Objects Servers.
• Content Migration, Archive activities for Business Objects Servers.
• Editing Business Objects tool functionality using Java SDK
• Integrating Business Objects reports in application frontend using Java & OpenDocument functions.
• Debugging report integration kit for reports integrated in frontend.
• Building new test plans for Business Objects environment.
• Break fixes in Business Objects environments.
• Debugging defects and fixing them in Business Objects servers.
• Version control management for integration code changes.
• Raising defects in Mercury Quality Centre.
• Generating weekly reports for time capture application in SPE.
• Performing Production support activities related to Business Objects environment.
• Daily server health check status reports for Business Objects servers.
• Engaged in performance issues under Enterprise Business Objects platform support.
• Design universe, reports and integration architecture.
• Monitoring Storage capacity of the Business Objects environments.
• Business Objects XI 3.1 architecture designing and implementation.
• Worked on LCM, process tracker modules.
• Worked on SAP integration, SharePoint integration.
• Dashboard implementation and architecture.
• Building of XI R2 and XI 3.1 SDK platform.
• Xcelsius dashboard designing and implementation.
• Creating custom code for automating processes like schedules, sequential installations, Disaster Recovery systems, BO services failure notifications, LDAP Refresh

Environment: Business Objects XIR2, Business Objects XIR3, Tomcat, Import Wizard, Report Conversion Tool, CMC, CCM, JAVA SDK UNIX OS, Windows OS

Confidential, Jun 2010 - Aug 2010
Confidential, CA, USA
Sony Pictures Gaming and digital Media use MediaMorph solution to manage the tracking and reporting Content (game, video and trailer) access across their global businesses. Analysis using MediaMorph help in analyzing the Digital content accessed online with various parameters like Page per view, time spent on page and, almost as importantly providing this information per territory or monthly/weekly/yearly helping them reorganize popularity of the recent releases.

Role: Business Objects Architect.

Responsibilities:

• Analyzing the pre-existing Excel based reporting
• Analyzing and inventory data for the automation of reporting solution
• Co-ordination with users & Offshore for deliverable
• Designing Universe to support reporting and analysis requirement
• Creating Webi Reports containing complex charts, Cross Tabs, Ranks, Filters, Breaks & Alerts
• Creating variables with complex calculation to convert time related entities and apply slice and dice
• Testing output of newly designed reports against the existing reporting system
• Quality implementation and documentation of newly designed system
• Implementing performance improvement techniques
• User demo and training about usability of the newly developed reporting systems
• Security setup implementation
• Migration of reports from Development system to Production system

Environment: Business Objects XIR2, Universe Designer, Web Intelligence, Import Wizard.

Confidential, Apr 2010 - Jun 2010
Confidential, CA, USA
This Project involved creation of dashboard solutionto provide a simple visual overview of the health and direction of Sony Pictures financial statements, i.e. balance sheets, income statements, profit and loss, operating statement and cash flow statements additionally with Drill down to perform complete analysis. The Dashboard also involved displaying of latest currency exchange, Box Office Weekly top 5 and Stock prices to make it a complete market & business view.

Role: Business Objects Architect.

Responsibilities:

• Gathering requirement by talking to end user and checking the existing reporting formats.
• Analyzing Dashboard requirement and designing dashboard workflow to support the financial analysis.
• Co-ordination with users & Offshore for deliverable
• ETL Design to support the dashboard data model requirement.
• Building universe and creating objects and filter for bringing required data.
• Creating Queries supporting data analysis using Query as web Service.
• Creating Xcelsius Dashboard using the Query As Web Service.
• Creating components like filters, Grid Tables, Bar chart, Dynamic visible components, Pie Charts, Hyperlinked Documents, Data Indicators, Images.
• Testing and Documentation of workflow.

Environment: Xcelsius 2008, Query as Web Service, Universe Designer, Live Office

Enterprise Platform Re-Platform, Apr 2009 - Mar 2010
Confidential, CA, USA
This Project involved analyzing the existing Business Objects Server & upgrading it with latest patch & re-design server to handle Enterprise Reporting load and configure it best suitable to Business Reporting need of multi-lingual support, Load Balancing. Install & configure new Server with Windows Operating system and decommissioning UNIX OS servers.

Role: Business Objects Administrator and Architect.

Responsibilities:

• Analyzing server load by checking application usage using Server audit Report.
• Planning new server design and decommissioning old server.
• Server sizing to support enterprise reporting need.
• Server Installation & upgrade.
• Server clustering & maintaining.
• Regression Testing & evaluation of patches to find out best fit for Sony Pictures reporting need.
• Finding solutions for the issues from regression testing.
• Configuring Multilanguage settings to support the reporting users belonging to worldwide territories.
• Applying parameters to improve performance.
• Changing server parameter to support reports running for long duration & to support reports bringing enormous data.
• Migrating content to new server using Import Wizard with the backup strategies.
• Security set-up for effective content management.
• Setting application rights & Folder level security.
• Troubleshooting Server errors to incorporate smooth release & replacement of servers.

Environment: Business Objects XIR2, Import Wizard, Report Conversion Tool, CMC, CCM, UNIX OS, Windows OS

BO XI-R2 Architecture, Nov 2007 - Mar 2009
Confidential, CA, USA
This project involved migration of Business Objects Web Intelligence reports/ Desktop Intelligence reports/ Universe/ Repository objects from different Business Objects versions like BO5.x, BO 6.x to Business Objects XIR2. There were total 15 applications based on various data sources and 1800 reports for migration & conversion. Security Design implementation, regression testing and remediation was done to maintain the quality of the reporting solutions.

Role: Business Objects Administrator and Architect.

Responsibilities:

• Analysis, Planning of Migration Project 6.x/5.x to XI R2.
• Inventory existing reports.
• Creating BO5.x & BO 6.x Sandbox for migration.
• Create a robust and scalable security model at BO Enterprise level.
• Created Predefined setting for the User profile like Power User, Report viewer.
• Created Auditor reports and tracked user access of reports and Universes.
• Implemented advanced data level security models at Business Objects universe.
• Modified Universes with pre-calculated aggregates from summary tables.
• Exported the universes to the Repository to making resources available to the users.
• Involved in Writing Detailed Level Documentation for reports and Universe design.
• Tuned the queries to improve the Performance of the existing Reports for various functional areas.
• Generated reports using free-hand SQL.
• Created full client and WebI reports. Modified the existing by adding new columns based on the result set.
• Involved in Migration of Business Objects system from version 5.x, 6.5 to Business Objects XI R2.
• Responsible for migration of Users, Universes, Connections, Full Client / Web I Reports from the existing version 6.5 to XI R2.
• Involved in testing (Users, Universes and Reports) throughout the migration process.
• Responsible for migrating Users, groups, connections from Business objects 6.5 to XI R2.
• Created new users in XI R2 using Central Management Console and set restrictions, assigned privileges based on their profiles.
• Used multiple data providers such as Universe and personal data files in generating report.
• Responsible for designing the reports according to client's requirement using Business Objects 6.5. Attend meetings with application owners and developers.
• Conversion of Deski reports to Webi reports using Report Conversion Tool.
• Logging defects in quality center & performing life cycle of defects till remediation.
• Test and remediate the migrated reports so that the results match those of the report prior to migration.

Environment: BO 5.0.3, BO 5.1.4, BO 6.5, BO XI R2, Web Intelligence, Desktop Intelligence, Import Wizard, Report Conversion Tool, Universe Designer, Supervisor, PL/SQL, Oracle 9i, MS SQL 2000, Sybase, Quality Centre

Horizon Sales Reporting Support, July 2007 to Oct 2007
Confidential, India
The Sony Pictures Home Entertainment division owns Horizon sales reporting for analysis of different entities including Competitor sales comparison, Sales Reporting, Profit loss, Point of sales calculation for worldwide territories like Japan, UK, US, Canada.
Different tracks are defined as per business, analysis entities & different territories. Business Objects is used to make the sales data available to users for decisions making.

Role: Business Objects Developer.

Responsibilities:

• Interacted with Business Users to gather, analyze and record requirements/specifications.
• Maintaining customers Issue log and responding to issues.
• Detected Cardinalities and Loops. Resolved loops using aliases & contexts.
• Tested and migrated universes and documents across testing/production repositories.
• Created complex reports using Business Objects functionality like Slice and Dice, Drill Down, Drill Up and Ranking.
• Aggregate awareness functions of Business Objects are used to route the query objects through most appropriate path while selecting from multiple contexts.
• Worked extensively with the major functionality of BO like Prompts, Breaks, Ranks, Multilingual Character support, Filters, Sorts, and Query Prompts.
• Tuned the queries to improve the Performance of the existing Reports for various functional areas.
• Involved in testing (Users, Universes and Reports) throughout the migration process.
• Managing users and groups and data security mechanism.
• Applied breaks on reports to get appropriate results and created cross tabs.
• Created different types of reports like Cross Tab, Charts using multiple data sources.
• Created reports using full- client and web intelligent and crystal reports.
• Gave my thoughts and ideas to data-modeling team to incorporate the design changes.

Environment: Business Objects XI R-2, Universe Designer, Web Intelligence, Import Wizard, Teradata 7.2, Quality Center

Confidential, Oct 2005 to Jun 2007
Confidential, India

Sony Pictures practice a market analysis using competitor market information. AC Nielson Reporting system was designed to support this analysis. Reporting solution is used to compare data with other studios which help analysing market share, Box office analysis based on movie release season, movie distribution media for better movie sell and revenue generation.

Role: Business Objects Developer.

Responsibilities:

• Coordinated with the end users to gather their requirements and discussions with database and ETL personnel to come up with the project design.
• Generated complex reports using Complex Queries, Sub Queries, Unions and Intersects.
• Built universes and set up parameters like Strategies, Controls, SQL and Links.
• Defined cardinalities and set up equi-joins, theta-joins and outer-joins.
• Detected loops and traps (chasm/fan) if any and resolved them with universe parameters, aliases and contexts.
• Inspected the integrity of the Universe to resolve faults and errors.
• Grouped objects into classes as per the end-user requirements.
• Evaluated universes parameters to support multilingual characters and performance.
• Designed various Charts and Cross tab supporting data analysis with Ranking and Drill, Alerts, Dynamic visibility.
• Created report for Point Of Sales, Revenue, Inventory and market analysis.
• Manipulated data in reports with breaks, sorts, ranking and alerts using both full client and Web Intelligence.
• Published Universe for ad hoc and canned reports to corporate documents with hidden objects and row restrictions.
• Managed users and set up privileges for universe and report access.
• Provided Training to end users for ad hoc reporting.

Environment: Business Objects XIR2, Universe Designer, Web Intelligence,Import Wizard, Teradata 7.2

Name & Likeness Royalty Reporting, Jan 2004 to Oct 2005
Confidential
Mumbai, India
Sony Pictures use a Royalty Reporting system used to generate royalty offered & expenses made to Actors based on usage of their names / photos used on the promotional items and sellable products like Coffee mug /T-shirts/DVD packing.
This Project involved conversion & implementation of a royalty calculation system to an automated Business Objects Royalty Reporting System.

Role: Business Objects Developer.

Responsibilities:

• Gathered requirements and project specifications and documenting the design process with the requirements.
• Understanding business logic used in Pre-existing Royalty calculation system.
• Analysis of implementation requirements and changes.
• Designing Entity Relation diagram for creating Data mart.
• Designed Universes by creating Business Objects data model by selecting/joining tables and determining cardinalities.
• Resolved loops problems by creating Aliases and/or Contexts.
• Defined classes and grouped objects as per the business standards and set hierarchies.
• Implemented Aggregate Awareness to expedite query process.
• Converted logic from Visual Basic system to Business Objects Reports.
• Created different canned reports involving Master/Detail, Cross Tab using Web Intelligence.
• Used filters, conditions, prompts and calculations to support user's requirements.
• Performed testing of design implementation for verifying generated outputs & system integration.

Environment: Business Object XIR2, Universe Designer, Web Intelligence, Import Wizard,
PL/SQL, Erwin 4.x, Oracle 9i database

Education - Bachelors of Engineering, India

Professional Reference - Available on request