SUMMARY

• 8+ years of IT experience in Data warehousing/Client/Server and web applications.
• Experience in the full development lifecycle including requirements definitions, design, programming/testing and implementation of major systems.
• Excellent knowledge in Business Intelligence and OLAP and Data Warehousing concepts.
• Over five years of expertise in administration and support solutions for Business Objects XI 4.X 3.1(R3.1)/XIR2/R1/6.x/5.x/,SDK, Server Intelligent Agent (SIA), Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Life cycle management, Auditor, Crystal Reports, Crystal Xcelsius, Query as a Web Service (QaaWS), Voyager, Live Office, SAP BW HANA, BEX Query Designer and Analyzer, data integrator and Dashboard Manager.
• Extensive experience in Building Universes and creating Adhoc Reports using Business Objects Web Intelligence R4.1/XIR3.1/XIR2/6.x/5.x and Crystal Reports 8.5/9/10/XIR2/2008
• Designed, implemented and migrated complex Universes and Business Objects Reports, classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases and derived tables.
• Expertise in working with all the modules of Business Objects like BOE,CMC,WebI Rich Client, QaaWs, Live office, Designer, DeskI and Crystal Reports, Xcelsius dashboards.
• Experience in designing Business Objects universes, complex Crystal and BO reports both Full and Thin Client Reports.
• Experience with generation of both Canned & Ad - hoc reports and with creating Drill Down, Slice and Dice, and Master Detail reports depending on the user requirements.
• Experience in creating simple and complex KPI dashboards using dashboard manager and Xcelsius.
• Experience in Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008, XML, Sybase SQL Server, DB2 UDB, MS Access and MS Excel.
• Experience in Data mart building, Data migration SQL, PL/SQL, cubes, Views, data base indexes.
• Experience in developing Complex Sub-Reports and Cross Tab Reports using crystal 2008 and Webi intelligence.
• Experience in creating reports which includes formatting optionssuch as Charting, Mapping, Grouping, Sorting,Alerting, Field highlighting, Drill-down, Drill through, Parameter prompts, Alerts and Formula.
• Experience in Scheduling and bursting Reports in Business Objects Enterprise and Crystal Enterprise.
• Experience in migrating Business Objects from earlier versions to latest version like XIR3.1 and XIR4.1
• Experience in creating QaaWs Web services for simple and complex KPI dashboards and scorecards.
• Experience in BO Installation, Creating Repository, exporting or importing BIAR files, adding Users and Groups, Assigning Password Security, Assigning Privileges to Documents and Universes.
• Experience in Crystal Enterprise administration and deploying Reports in Crystal Enterprise via. Crystal Publishing Wizard and Central Management Console.
• Experience with SQL Reporting services like SSRS, SSIS, and SSAS against database tables.
• Good Knowledge in SAP Lumira Dashboards and Explorer
• Experience creating report and data logical layer in various tools like Cognos, OBIEE.
• Experience in Transportation, claims, Health, Financial and Insurance industry.
• Experience in developing user manuals and documentation of the applications.
• Experience with UNIX and Windows operating systems.
• Experience using Configuration Management tools like PVCS and CVS.
• Excellent analytical, functional, design and development skills with excellent communication skills, both written and verbal. Ability to work in both individual and team environments.

TECHNICAL SKILLS

BI Tools: Business Objects 6.x, BO XI3.1/R1/R2/R3/R4.0 (BI launch pad,Rich client,Information Design tool,Universe Design tool,Desktop Intelligence, CMC, Designer, Web Intelligence (LCM), Dashboard Manager, performance Management, Webi Rich client, Crystal Reports 8.0/8.5/10.0 / XI, Crystal Enterprise 2008/ XI/XIR2, SAP BW, SAP Business Explorer (BEx) Analyzer, BEx Browser, Data integrator, XCelsius 2008, Oracle Query Builder

ETL Tools: Informatica, AbInitio, Datastage, BO Data integrator

Languages: SQL, C++, C, PL/SQL, UNIX, java, XML.

Web: IIS, Apache Server, Tom cat, VB script, JavaScript, XML,HTML, DHTML

Databases: Oracle 7.x/8i/9i/10g, SQLServer 2002/05/08, DB2 UDB, Sybase, MS Access

GUI Tools: VB.NET, ASP.NET, Visual Basic, Visual Studio, MS Office

QA Tools: Test director, HP Quality Center 8./8.2/9.0

Version Control: Rational Clear Case, VSS, PVCS

Others: sharepoint,Toad, fiddler

Operating System: Unix,linux,window7/window server 2008/XP/NT

PROFESSIONAL EXPERIENCE

Confidential, Frisco, TX

Sr. Business Objects Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution to satisfy the needs of Business Units and Supplier Partners.
• Analyzed the business and requirement to check the feasibility of implementation.
• Involved in Installation, Configuration, and Deployment of BOXI R3/R4 on windows.
• Extensively involved in troubleshooting of BOE installation and migration issues.
• Extensively used Business Objects Designer to design and maintain data mart.
• Designed universe as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Involved in BI integration using web services with SAP environments like webi and crystal reports.
• Created derived tables and views for Universe design to meet specific results in Webi and crystal adhoc/complex reports.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Extensively Used information Designer tool, Universe Design tool as a part of Universe development, created joins, Classes, sub classes, pre conditions, and different kind of objects, cardinalities, Strategies and user prompts.
• Resolved the loops using contexts. Check the Integrity of the Universes. Export the Universes to Repository for making available to users.
• Creating universe using IDT and UDT tools.
• Resolving loops using context and alias tables in IDT& UDT.
• Creating derived tables on database tables/views.
• Creating dimensions and measures objects in Business layer in IDT tool.
• Publishing universe using IDT tool to CMC server.
• Created multiple Business layers using IDT.
• Checking integrity check validating the universe via IDT & UDT tool.
• Created webi intelligence complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drill up and drill down analysis reports.
• Primary responsibilities include creating Business Objects Reports and publish them on Enterprise to fetch the reports for Development group.
• Created Business Objects Reports using Formulas, Grouping, Parameters and Static/Dynamic Cascading Prompts to handle the customer’s requests from Tables, Stored Procedures, and Views.
• Created complex reports using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports.
• Responsible for creating the reports (On demand, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc) for Business users using, BEx, crystal and Webi reports.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Published Scheduled and bursted crystal and Webi reports on daily and region basis and exported them in Excel/PDF format.
• Performed Reports SQL performance tuning and data validation and quality.
• Customized Infocube and ODS to store transactional data for Reporting.
• Customized/ configured Transfer structure for the Source system and Infosource, and activated the relevant BusinessContent.
• Customized/ configured Infoobjects, Data source, Infosource, Transfer Rules, Communication Structure, Update Rules, ODS object, Infocube, Infopackages.
• Periodic extractions are scheduled using Infopackage.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Created groups, Users and Profiles in BO Enterprise and set-up the privileges to access the reports via Infoview.
• Used import wizard to migrate users and Universes from BO XI R3 to BO XI 4.1 Server.
• Created Dashboard templates with Visualization and scorecards for different group usage for their best practices. Pulled data from existing reports using QaaWs and Live Office.
• Interacted with ETL team to resolve double counting and other performance issues.
• Developed and maintained Graphical KPI Dashboards in Xcelsius 2008 and integrate with BO Infoview. Webi and crystal reports.
• Installed and developed QaaWs Webserices for report user input and cascading user parameters.
• Worked with Dashboard Designer tool (Xcelsius)for creating simple dashboards and scorecards and convert those in to user interfaces like excel files, PowerPoint representations for better understanding.
• Created BW Bex queries via Query Designer and Analyzed the data using Query Analyzer tool.
• Experience in Web and mobile analytics like Email distributions, Mobile message distribution and Web oriented distributions.
• Extensively involved in Migration of Crystal and Webi reports in various environments.
• Developed Dashboard using Multiple Web Services (Qaaws) in Single dashboard bypassing the limitation.
• Used Flash variables passed the parameters from Parent Dashboard to Child Dashboard.
• Created hyperlinks on Dashboard to drill down for detailed analysis reports.
• Created customized Web Intelligence reports as a source data for Live Office to integrate Xcelsius on corporate Dashboards.
• Created WSDLs using QaaWS and implemented WSDLs into Xcelsius Dashboards. Integrated Dashboards into external portal applications using QaaWS.
• Extensively worked in both Production and Development environments of resolving their daily issues and Improvements.
• Generated universe and report user documentation guide for the end users reference.

Environment: Business Objects XIR4.1 (SP2)/4.0/XI 3.1, Crystal Reports 2008,Crystal XI/XIR2, BO Dashboard manager, Information Design tool, Webi Rich Client Crystal Xcelsius 4.5, Xcelsius 2008, SQL Server 2005/2008,SSIS,SSRS, MS Access, SAP BW HANA,SQL,PL SQL,MS Office, VSS, LCM,CMC, Unix, Linux, windows NT. MS Excel, fiddler and visual studio

Confidential, Philadelphia, PA

Business Objects developer

Responsibilities:

• Created Technical design documentation for universe and business objects reports specification after requirement gathering and analysis and coordinated with the testing team consultants to ensure the thorough and accurate testing.
• Interacted with business analyst and users to identify reports requirements and transform it in to reports specification and develop reports.
• Installed, tested, and maintained Business Objects XI (including Crystal) client and server software products.
• Developed reports Financial domain for each departments like Account payable, Account receivables and claims.
• Understanding the Claim process to generate the accurate values on the reports.
• Creating reports of kind, Slice and Dice, Drill Down, Combined Queries, Functions, Cross Tab, Master Details and wrote formulae for easy-to-use benefit information system by using Crystal Reports.
• Creating linked, unlinked, parameterized and on-demand sub-reports for various business needs.
• Resolved the loops using contexts. Check the Integrity of the Universes. Export the Universes to Repository for making available to users.
• Creating universe using IDT and UDT tools.
• Resolving loops using context and alias tables in IDT& UDT.
• Creating derived tables on database tables/views.
• Creating dimensions and measures objects in Business layer in IDT tool.
• Publishing universe using IDT tool to CMC server.
• Created multiple Business layers using IDT.
• Checking integrity check validating the universe via IDT & UDT tool.Created nested and conditional groups and formatting features in reports.
• Generated sub-reports, drill down, hyperlink reports and reports on demand.
• Used shared variables to process the data from the sub report in the main report and vice versa.
• Used parameters to query the data as per the user requirements.
• Analyzed PL/SQL stored procedures for accessing and manipulating data from database.
• Created Lovs, Hierarchy’s, Pre Defined Conditions, Resolving Data Base Connections and new objects to the Universes.
• Created joins between tables, prompts queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Worked on publishing wizard to deploy crystal reports to BO Server.
• Experienced in scheduling reports as per their frequencies in BO server with out any manual intervention.
• Experienced in Migrating Universes from test environment to Production Environment.
• Experienced in Set-up of SMTP Mail server for scheduled reports will be send to the client E-Mails without log-in to the Infoview.
• Creating nested and conditional groups and formatting features in the reports.
• Installation and Configuration of BOXIR4 in windows2007 advanced servers on DEV, QA, PROD in multi-tiered load balanced environments.
• Implemented Single sign on using Kerberos Windows AD Authentication for Business objects applications.
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and also working on Toad to tune the SQL.
• Wrote and Tested Oracle PL/SQL Statements, function using TOAD.
• Extensive use of derived tables and Customize the LOV’s as per requirements.
• Created complex objects and condition and resolving loops using context and alias.
• Created complex reports using multiple data providers, filter and breaks. Created complex variable and formula.
• BO System usage monitoring, BO Security design and implementation, BO Central Management Console, BO Info View.
• Developed custom audit reports on scheduled repository using SDK, to replace Legacy VB Macro method.
• Responsible for using Business Objects JSP SDK to create an interface between TRI Explorer frontend with Business Objects EPA reports.
• User Creation and Security at different levels of Hierarchy in management
• Implement Data Level Security in Universe, Folder, Application wise
• Created Xcelsius user parameter prototype dashboards using open doc functionality.
• Involved in Migration of Reports, Universes, User Groups, Users using Import wizard
• Involved in End User Training of WebI and Crystal Reports for ad hoc reporting.
• Installed Xcelcsius, Query as Web Service as Proof of Concept for a Pilot Project

Environment: Business Objects XI R3, Web XI, Crystal Reports XI, DB2, SQL server, Business objects Enterprise, Windows 2003 Server, TOAD, Jsp SDK,Crystal Xelcius, data stage, zena,Dashboard Manager, Linux,SAP BW HANA,BW Query Designer MS office

Confidential, Atlanta, GA

Business Objects developer

Responsibilities:

• Gathered requirements from the management for functionality, display and effectiveness of the reports.
• Formatted the report as per the business requirements.
• Installed and configured all components for Business Objects Enterprise Edition Version E 6.5.1.
• Created Repository, Distributed the BOMain key, Created Multiple Document and Universe domains for Development and Production Environment.
• Created users, user groups, assigned privileges, restricted access, provided row and column level security for all the products of Business objects.
• Analyzed the requirement to check the feasibility of implementation.
• Created Universes for the users to do Adhoc Reporting, slice and dice, drill down.
• Crated Universes, Classes, Objects, complex measure objects, Prompts, Predefined conditions.
• Resolved loops by either creating Aliases or Contexts or by defining Shortcut Joins.
• Checked the Integrity of the Universes.
• Published the Universe to different universe domains and made available to the Developers and End Users.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end functions, procedures, tables, views required by the business objects universes.
• Created various simple and complex reports mainly using business objects universes as the data providers.
• Crated reports with multiple data providers like universes, Free hand SQL, and Personal Data Files
• Created reports using Business objects functionality like Queries, Slice and Dice, Drill down, @Function, Formulae etc.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Created graphical representation of reports such as Bar charts, Pie Charts etc as per the End user requirements.
• Installation & Configuration of Business Objects XI r2 Enterprise Suite of Products.
• Migrated business objects 6.5.1 reports to Business Objects Enterprise XI.
• Created universes in BO XI and applied row level security to different business groups.
• All sorts of universe designing and reporting techniques involved in BO 6.5.1 were also performed in BO XI after migration.
• Installed and configured Business Objects XI r1 using Tomcat and Apache as Application and Web Servers.
• Enabled/Disabled different servers in Central Configuration Manager and Central Management Console
• Developed complex reports like Sub Reports, Cross Tab Reports by using Crystal Reports Version XI using SQL Server 2000.
• Tested the developed crystal reports and created test cases for the testing team.
• Reports with Parameter fields, formulas, heavy formatting were developed.
• Used the Import wizard to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to BO XI environment.
• Used the Publishing wizard to export different document types as objects to different folders in CMC.
• Created reports prototypes using WebIntelligence XI for user presentation.
• Trained the Business Users in report creation and also new features of Business Objects XI.

Environment: Business Objects 6.5.1, Business Objects Designer, Broadcast Agent, Supervisor, WebIntelligence 6.5.1 XI (CMC, CCM, Designer, DeskI) InfoView, Crystal Reports XI, Ms Excel, Windows NT/2000 Professional, Oracle 9i, MS SQL Server 2000, Windows Server 2003,Linux .

Confidential

Business Objects Report Developer

Responsibilities:

• Assisted in establishing a Business Objects environment.
• Responsible for fitting Business Objects into the Information Architecture of the company as well as supporting business users and developing new and maintaining existing reports.
• Generated several periodical reports like daily, fortnightly, monthly and yearly etc.
• Designed and developed extensive Business Objects reports, including complex reports using multiple queries, complex conditions on queries, combined queries.
• Designed reports that contain data from different data providers.
• Created several user objects according to the user requirements.
• Scheduled the documents using Broadcast Agent.
• Interacted with end users and business analysts to identify and develop business requirement and transform it into technical requirements and ultimately responsible for delivering the solution.

Environment: Business Objects Enterprise, Designer, Supervisor, WebI, BCA, Infoview, Oracle and UNIX, Linux.

Confidential

Business Objects Developer

Responsibilities:

• Drafted the business requirements of the management and other business users.
• Analyzed the transaction systems and design the required star schema according to business needs for the data mart
• Designed the Universes incorporating all the Business requirements.
• Created Aliases, Multiple contexts for catering different functional areas in a single user query and solved the loops problems.
• Created reports with Selection Criteria, Grouping, Sub reports, Cross tabs, Standard and Summary.
• Documented report parameters, fields, and logic used for developing of reports and universe in a word document.
• Generated Desktop Intelligence and Web Intelligence reports using open document methodology.
• Provided technical assistance/support to analysts, business community and respond to inquiries regarding errors, problems, or questions with programs/interfaces.

Environment: Business Objects XI 6.1, Universe Designer, Broadcast Agent, Desktop Intelligence and Infoview MS SQL Server 2000, T-SQL, SSRS, DTS, Oracle 8i/9i, Windows Server 2000,Windows NT,Linux, MS Access.