PROFESSIONAL SUMMARY:

• Over8 years of strong professional IT experience with OLTP, OLAP, Data Warehousing and Business Intelligence experience using Business Objects 4.0/XIR3.1/XIR2, Crystal Reports, Xcelsius 2008.
• Over 2+ years of Experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• Hands on experience in administration and upgrading versions of SAP Business Objects with both client and server products.
• Strong experience in Business Objects (4.0,XI 3.1, XIR2) Full Client, Supervisor, Designer, Reporter, Web Intelligence, Info View, Import Wizard, Central Management Console, Central Configuration Manager, Application Foundation/Performance Manager (Dashboards, KPI’s),Live Office, Query As A Web Service (QaaWS).
• Good Experience in Business Objects Installation, Creating Repository, adding Users and Groups, Assigning Password Security, Assigning Privileges to Documents and Universes.
• Designed, implemented and migrated complex Universes and Business Objects Reports, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked teh Integrity of teh Universes.
• Well versed with creating universe, reports using Business Objects applications on Oracle,DB2& Teradata universes.
• Extensively used Import Wizard in moving reports and universes from one environment to other environment.
• Used UMT tool to migrate/promote objects from XI 3.1 to 4.0
• Strong noledge of complete SDLCE (Software Development Life Cycle Engineering) and software quality management.
• Very good understanding with SAP source systems as well as SAP BW.
• Hands On experience in Oracle 11g/10g/9i, MS SQL Server 2000/2005, Teradata, DB2.
• Good Communication and Interpersonal skills. Technically sound, Result - Oriented with strong Problem solving skills. Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to new environment with a strong desire to keep pace with latest technologies.

TECHNICAL EXPERTISE:

BI/Reporting Tools: Business Objects 4.1/4.0/XI3.1/XIR2,Tableau 7.0,8.0,OBIEE 11g

Operating Systems: Windows,UNIX

Databases: Teradata,Oracle11g/10g/9i

Languages: Oracle SQL, PL/SQL,SQL-Plus

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

IT Development Analyst

Responsibilities:

• Gather, analyze and document business requirements, clarify business rules and data design requirements, functional requirements and prepare specification documents for Business Objects universes and reports.
• Deep experience with teh design and development of Tableau visualization solutions.
• Experience with creation of users, groups, projects, workbooks and teh appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Teh ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Find ways to make graphs and tables visually exciting, and aesthetically pleasing, while at teh same time maintaining teh accuracy of teh core information content that is being communicated
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Proofread all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
• Created WebI reports, Crystal Reports based on user requirements.
• Assist in reviewing and analyzing existing system structures to provide solutions to enhanceand improvesystem.
• Create processes for new system and attend to ad-hoc issues related to day to day activities throughout project implementation and testing phases.
• Coordinating with other teams to improve teh quality of work.
• Designed, developed, deployed and maintained Universesusing Business Objects Designer tool(IDT).
• Created Aliases and Contexts for resolving Loops and Checked teh Cardinality and Integrity of teh Universe.
• Applied Row level and Object level securities to different groups to restrict teh data.
• Created prompts in report to restrict data fetch and ease data load.
• Restricting teh user access with help of Access Level privileges.
• As per teh Business requirement creating teh reports to cater to Order, Orders History, Pending Orders at Tasks, Processes and Tasks subject areas of teh application.
• Migrated universes/reports from Dev to Test and finally into Production environment after UAT(User Acceptance Testing)using Import Wizard & LCM.
• Provided teh security access management by creating users/groups and folders.
• Analyze user needs and provide software solutions.
• Extensively used LCM to migrate teh reports from one environment to another environment.

Environment:Tableau Desktop 7.0, 8.0 Tableau Server/Administrator, Crystal Reports, BOBJ 4.1,CMC,Infoview/Launch pad, LCM, Oracle, Unix/Windows Server.

Confidential, Rosemead, CA

Business Objects Report Developer

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing Reports.
• Involved in designing and Building of Universes, Classes and objects.
• Converted around 120 reports & 11 universes on top of Oracle, DB2& Teradata datasources.
• Migrates teh objects from one environment to other environments.
• Interacted with Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing Reports.
• Deep experience with teh design and development of Tableau visualization solutions
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Experience with creation of users, groups, projects, workbooks and teh appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Demonstrated noledge in dealing with various functionalities like global filters, guided navigation, customization, conditional formatting of reports to satisfy teh end users.
• Worked on design and development of Tableau visualization solution.
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Build test cases and tested teh Reports/Dashboards by comparing teh SQL Output on teh Data warehouse to teh values in teh Reports/Dashboards, documented teh test results.
• Performed Unit testing, integration testing to verify teh report functionality and debugged dashboard reports to verify data matches as expected.
• Installed and configured Business Objects XI 3.1 and Crystal reports 2008 on UNIX/Windows server and applied teh latest Service Pack and Fix Pack.
• Upgraded teh BOBJ XI 3.1 to BO 4.0 SP5 P6.
• Currently we are in teh process of upgrading teh BOBJ 4.0 SP5 P6 to 4.1 SP2 P1
• Deployment of web application servers Tomcat on UNIX Environment.
• Performed Server level settings to provide better performance to end users.
• Involved in designing and Building of Universes, Classes and objects.
• Resolved loops/Traps using Contexts and Aliases, Worked on Master and Component approach during teh linking of universes.
• Performing regular Business Objects activities like taking environment Back-up’s, cleaning teh temp files, removing log files to improve server performance.
• Continuously monitoring server usage, capacity and health of teh production environment.
• Developed Unix Shell Scripts in order to run daily cycle reports.
• Scheduled and ran extraction, loading processes and monitored sessions using informatica work flow manager
• Created Web Intelligence reports/ Adhoc reports using Universe on top of SAP BW Data.
• Migrated universes/reports from Dev to Test and finally into Production environment after UAT(User Acceptance Testing)using Import Wizard & LCM.
• Worked with Multiple data providers including Personal Data files and Freehand SQL to create reports.
• Created dynamic LOV’s based on report requirements.
• Used Filters and Conditions to achieve report functionality.
• Oracle database Installation, Upgradation and Maintenance on UNIX Platform.
• Production Support activities and fixing teh live data Issues.

Environment:: Tableau Server 7.0,Xcelsius 2008, Crystal Reports 2008, BOBJ 3.1,4.0,CMC,Infoview/Launch pad, Import wizard, LCM, Oracle, DB2, Teradata and Unix/Windows Server.

Confidential, Irvine, CA

Business Objects Admin/Analyst/Developer

Responsibilities:

• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features with reporting system and also to successfully implement business logic.
• Designed functional specification documents (FSD) based on requirement.
• Acted as a Liaison between End users and developers.
• Worked extensively on modules Central Management Console, Designer, Web Intelligence, Auditor, Publisher and Infoview.
• Responsible for defining teh scope of teh project, doing gap analysis and documenting them textually or within models.
• Migrated & upgraded Business Objects from XIR2 to XI 3.1.
• Designed universes using different database, defining teh necessary connections and exported them to repository.
• Managed user profiles using Supervisor and Set object-level security and row level security restrictions, as per teh client requirement.
• Designed and Documented Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies for Crystal and full client environments.
• Created standard and Adhoc reports using Business Objects functionalities like Slice and Dice, Templates, Drill Down, @Functions, Cross Tab, Master Detail and Formula’s, Breaks and Custom Sorts in reporting.
• Developed Crystal Reports and launched them from user interfaces.
• Worked with Business Objects XIR2 and Crystal Enterprise for Scheduling, and deploying reports accordingly to run on daily/weekly/monthly basis.
• Responsible for creating teh reports (On demand, Adhoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc).
• Coordinated and resolved Data Quality issues for smooth migration to production/maintenance of Reports and Universes to different environment within teh organization.
• Involved in Migration of Business Objects from 6.5 to XI R2.
• Extensively worked with security issues and user maintenance in Business Objects 6.5/XI/XIR2.
• Involved in creation of custom List of Values (LOVs) for better understanding of prompts by teh end users and Created complex reports by linking data from multiple data providers from different Sources.

Environment: Business Objects 6.5/XIR2 (SP2/SP3/SP4), Crystal Reports XI, Performance Management, Live Office, Linux, Windows XP, SQL server2000/2005, Teradata V4,Oracle 10g.

Confidential, Irvine, CA

Business Objects Admin/Developer

Responsibilities:

• Designed a questionnaire that helps in requirements elicitation from end-users which helps in Universe and Reports Design.
• Coordinating with end-users and business analysts to understand teh scope of business requirements, user expectations, and ensure teh accuracy of reporting specifications.
• Involved in different phrases of teh project like analyzing requirements, planning, execution and maintenance.
• Worked with installing, administration in both desktop and server products of Business Objects XIR2 onUNIXenvironment.
• Troubleshooting Business Objects XIR3 installation and migration issues on UNIX Environment.
• Created users, groups and access rights using Central Management Console.
• Built classes and objects in universes using SQL Server 2005 database.
• Implemented complex new Universes, Linked with existing Universes from Data marts.
• Worked with Xcelsius for creating simple dashboards and simple crystal reports and convert those in to user interfaces like excel files, PowerPoint representations for better understanding.
• Developed various Reports for Area wise, Regional, National, and Response Analysis using Crystal Reports/Business Objects XIR2.
• Extensively used report conversion tool for converting desktop reports to web intelligence reports.
• Business users to use Web Intelligence to create Adhoc reports as well as view existing published reports.
• Tested Business Objects full Client reports in teh Business Objects XI R2/ Crystal XI/9 environment.
• Created, maintained and modified teh business critical reports using teh Desktop Intelligence.
• Developed thick/thin client canned reports using Business Objects and Web Intelligence.
• Scheduled and monitored reports using Broadcast Agent Server.
• Participated in developing teh Relational Model (Logical & Physical) and in documentation of technical methods of development as well as business related information regarding teh design process.

Environment: Business Objects 6.5/XIR2, Crystal Reports 9, Sybase 11.1/12, Performance Management, Oracle 9I, UNIX, DB2, SQL and PL/SQL.