SUMMARY

• Over 8+ years of Experience in Business Intelligence with focus on Business Objects XI 4.0/3.1/R2/6.x/5.x (Designer, Infoview, Desktop Intelligence, WebIntelligence, DESKI, Crystal Reports, CMC, Query as a Web Service), Xcelsius.
• Expertise in designing, development and deployment of complex Universes.
• Interacting with end users to gather requirements and co - ordinate with them in UAT.
• Expertise in resolving joins path problems like Loops and Traps in teh Universes using Aliases, Contexts, and Aggregate Awareness in Business Objects Designer.
• Excellent experience and expertise in creatingTableauWorkbook's and Dashboards.
• Expertise in Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.
• Worked on SAP Business Objects 4.0.
• Experience in identification of Business, Data requirements and converting them into conceptual and data models.
• Extensive Knowledge in using Business Objects functionalities like Slice and Dice, Drill down, @ Function, Cross Tab, Master Detail, and Complex Formulas.
• Expertise in creating report with various levels of aggregation using extended syntax operators like ForEach, For All and IN.
• Extensive experience working with Tableau Software as a dashboard developer.
• Experience in creating Complex workbooks to visualize clients’ progress using scattered plots, bar charts by Tableau desktop.
• Knowledge on developing WEBI & Crystal reports out of OLAP Cubes.
• Experienced in developing complex reports using Business Objects WEBI Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Built Test Plans and Test scripts also engaged in Unit Testing (UAT).
• Implemented Row level/Object Level security in Universe Designer.
• Experience in developing WebIntelligence, Desktop Intelligence and Crystal Reports using various Data Sources such as SQL Server, Oracle, DB2, and SAP BW.
• Extensively worked on Business Objects Administration. Created Users and Groups and assigning security in Central Management Console (CMC). Scheduling of Reports in CMC on Daily, Monthly, Weekly basis.
• Created Style-guide, Templates & Technical Designs for teh Xcelsius 2008 Deliverables.
• Developed and implemented Xcelsius dashboards that deliver new analytical capabilities to executives.
• Extensive noledge in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Excellent team player, interfacing across business and technical groups and ability to work independently and exceptional ability to quickly master new concepts and applications.

TECHNICAL SKILLS

Reporting Tools: Business Objects XI 4.0/3.2/3.1/R2/6.x/5.x, Tableau(6.1/7.0/8), WEBI, Deski, Crystal Reports XI/2008, Xcelsius 2008, CMC, InfoView, QaaWS, Import Wizard, Report Conversion Tool, Live Office.

Databases: Oracle 11g/10g/9i, SQL Server 2008/2005/2000 , MS Access 2007/2000/XP, DB2Database Tools Toad, SQL Developer

Operating Systems: Windows 7/Vista/XP/2000/98, MS-DOS, UNIX, Solaris, Linux.

Web Servers: IIS 6.0/5.0, Apache Tomcat 5.0.27/4.1, Web Logic 8.0 and Web Sphere.

PROFESSIONAL EXPERIENCE

Confidential, NewYork City

Lead SAP BO Developer

Responsibilities:

• Member of Online BI and Analytic team, responsible of providing daily, weekly and monthly reports to support online business operation through analysis of key performance indicators and trends..
• Worked on motion chart, Drill down analysis using tableau desktop for BML Confidential & PayPal.
• Created ad-hoc reports in WebIntelligence (Info view) and published and maintained them in Central Management Console (CMC). Scheduled to run them on timely basis to be distributed to end users.
• Installed, administrated and trouble-shooted SAP BusinessObjects XI 4.0 on multiple servers (for load sharing) in Development and Production Environment.
• Involved in analyzing, documenting teh business requirements, functional requirements for developing universes and reports.
• Developed Hierarchies in teh universes to enable teh multi-dimensional analysis in teh reports using teh drill feature.
• Designed complex BEx queries and built reports using BEx analyzer & BEx web.
• Managed users and groups and implemented folder level and application level security in teh CMC
• Created additional job servers and WEBI processing servers for load balancing in CMC
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis) using WebIntelligence.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize teh data along a combination of Dimensions and Drill-down Hierarchies giving teh ability to teh end-users to view teh data from heterogeneous viewpoints and Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis) using WebIntelligence Rich Client.
• Created new and modified existing Hierarchies in teh Universes to create Drill enabled reports.
• Created reports using multiple data source, flat-files and merged teh dimensions to synchronize teh queries.
• Scheduled teh reports on daily, weekly and monthly basis by using Scheduler in CMC and used instance manager in managing teh scheduled reports.
• Also created demo-able marketing database (logical and physical data modeling) to show BI tools (Business Objects and Tableau) functionality.
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Worked as a liaison between client team, account team and BI development team.

Environment: Business Objects 4.1/ XI 3.1, WebIntelligence Rich Client, Tableau 8.0, Crystal Reports 8.0, Desktop Intelligence, Import Wizard, DESKI, Live Office, Xcelsius, QaaWS, BEX, Red Hat Linux 5, Tomcat 5/6, Oracle 11g, SQL Server 2012/2007, SQL Server Management Console.

Confidential, Kansas City

Sr. Crystal Report/ Business Object Developer

Responsibilities:

• Interacted with Business Objects users by conducting meetings to discuss teh projects/enhancements requirements.
• Drafting teh functional and technical documents.
• Responsible for UAT and production migrations.
• Responsible for Developing and Maintaining and teh Business Objects Universes.
• Migrated Cognos to Business Objects.
• Identify and resolve teh potential universe issues like loops, Chasm Traps and Fan Traps and resolved them using techniques like Contexts and Aliases.
• Extensively used formula fields, parameter fields, Running Total Fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Wrote training guide for end users (Developer Edition, User Edition) for Business Objects and Tableau.
• Worked closely with all team members in implementingTableauBI tool in teh project.
• Created crystal reports with Standard, Cross Tabs and Grouping.
• Created complex reports using functions like @variables, @prompt, condition Objects and aggregate Awareness Functions.
• Converted Deski Reports to Webi Reports using Report Conversion Tool.
• Created WEBI reports and exported teh report content as web service to feed teh input to Xcelsius dashboards.
• Created IDT connections in dev, test and prod for active reporting.
• Created multiple new universes in BO 4.0 as per teh requirements adding new classes and objects. These universes were designed to support multiple levels of hierarchies for drill down functionalities.
• Created WebIntelligence reports using combined queries.
• Developed reports using universe and excel data source and used merged dimensions to synchronize teh queries.
• Created publications using Dynamic Recipients and Enterprise Users. And delivered teh report content as inline email using HTML format.
• Creating teh Dynamic and static dashboards using LiveOffice and QaaWS as source.
• Providing teh production support and maintaining teh SLAs.
• Promoting teh code between teh environments.

Environment: Business Objects 4.1/ XI 3.1, WebIntelligence Rich Client, Tableau 7.0, Crystal Reports 8.0, Desktop Intelligence, Import Wizard, Live Office, Xcelsius, QaaWS, Red Hat Linux 5, Tomcat 5/6, Oracle 11g, SQL Server 2012/2007, SQL Server Management Console.

Confidential, CA

Sr. Business Object developer

Responsibilities:

• Worked closely with Business Users to gather teh requirements for development.
• Coordinating with ETL developers while building teh data and ensure that required reporting elements are populated in teh DWH
• User/group and Server administration in Central Management Console.
• Taking BIAR file backups for reports and universes on periodic basis using import wizard.
• Responsible for creating Universes for Ad-Hoc and canned Reporting.
• Improved teh performance with teh use of @aggregate aware, used Index Awareness on key columns to speed data retrieval.
• Used Crystal reports to feed data to Crystal Xcelsius Visualization an XML file as a data source.
• Created Sub Reports, prompt, groups in a report and created parameters, custom functions and expressions in Crystal Reports.
• Applied row level and object level securities on different groups in Universe.
• Created objects using @select and @where to decrease teh maintenance and increase teh accuracy in teh universe objects.
• Developed WebIntelligence reports by linking multiple data providers (excel and universe) in a single report.
• Developed new reports, dashboards and converting reports from different tools (Cognos 8.4, Brio, and SAS)
• Involved in Business Objects Production Support resolving teh tickets, troubleshooting teh end user reported issues.
• Created Live Office reports using WebIntelligence and Universe as data source.
• Created Xcelsius dashboards using various components like selector, accordion menu and charts.

Environment: Business Objects XI 3.1, WebIntelligence Rich Client, Infoview, Live Office, Solaris 10/RHEL 5, Oracle 11g, SQL Server 2007, Crystal reports 2008, Xcelsius Dashboards.

Confidential, Nashville, TN

Crystal Report/ Business Object Developer/ Admin.

Responsibilities:

• Interacted with Business Users in gathering business requirements.
• Managed users and groups and implemented folder level and application level security in teh CMC
• Developed complex reports in Crystal Reports 2008 from multiple data sources, used stored procedures and SQL queries.
• Developed reports with sub queries, from multiple databases, used groupings creatively in Crystal.
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Involved in migrating code between teh dev - test - production environments.
• Created critical visualization using Business Objects Crystal Xcelsius for teh Business Dashboard.
• Created predefined conditions in universe to make teh filters readily available for teh ad-hoc report writers
• Teh project involved development of reports using Business Objects and WEBI to cater Ad-hoc reporting needs.
• Developed queries by defining navigational attributes, free characteristics Restricted and calculated key figures for drill downs, filters and other features like RRI using BEX Analyzer and presented teh result in workbooks.
• Created reports using Desktop Intelligence(DESKI)
• Created summary reports in WebIntelligence using extended syntax operators like ForAll, ForEach and IN
• Scheduled teh reports to send as an email with excel and PDF attachments to teh users
• Created publications using Dynamic Recipients and Enterprise Users. And delivered teh report content as inline email using mHTML format.
• Coordinating with DBA and general supervisor for resolving technical issues
• Migrated Business Objects Universes, Users and user groups, and reports from Version 6x to XI 3.1 using teh Import Wizard.
• Used Report conversion Tool to convert deski reports to WEBI and provided out of teh box solutions for teh deski features which were not converted.

Environment: Business Objects XI 3.1/XI R2,CMC, InfoView, Import Wizard, Report Conversion Tools, Crystal Reports, Designer, BEX, WebIntelligence, Desktop Intelligence, Solaris, Oracle 9i/10g, SQL Server 2007, Xcelsius, Live Office.

Confidential, Ohio

Business Object Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document teh Requirements and translate these to Technical specifications for Designing Universes and responsible for analysis on crystal reports migration.
• Improved teh performance and reduced teh coding with teh use of @aggregate aware and tested teh aggregate awareness to ensure teh query is pulling correct level of aggregation.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Created Universes on top of SAP BW Info Providers for reporting with WebIntelligence.
• Used Analyzer in Business Explorer to analyze teh data in teh BW with WebIntelligence reports.
• Scheduled teh reports on daily, weekly and monthly basis by using Scheduler.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Developed WebIntelligence reports making use of several Queries (Union, Intersection, Minus).
• Used Prompts, Conditions to restrict teh data returned by Query and used Filters to restrict teh unwanted data to be displayed on teh WebIntelligence report.
• Developed WebIntelligence reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging teh common objects.
• Worked extensively with teh major functionality of Business Objects like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
• Migrated Business Objects XI R2 content (users/user groups, Universes, reports) in to Business Objects XI 3.0 environment using teh Import Wizard.
• Migrated Crystal Reports 8 to Crystal Reports XI and also responsible for testing and publishing reports.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

Environment: Business Objects XI 3.0/R2/6.5, WebIntelligence Rich Client, Xcelsius 2008, Crystal Reports, Infoview, Teradata 13.0, SAP BW, TOAD, Windows 2003 Server.

Confidential 

Responsibilities:

• Managed over 400 users and 30 groups in teh entire Business Objects suite
• Involved in resolving problems like ‘Chasm Traps’ and ‘Fan Trap’.
• Involved in SQL tuning for better performance while generating Ad-Hoc reports.
• Created and ran ad hoc queries to Test and validate teh data pulled in BO reports.
• Maintained teh whole environment (TEST, DEV and PROD) along with 8 main servers.
• Updated and maintained Universes to meet new reporting requirements
• Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Configured File Repository Servers, Crystal Report Job, Cache and Page Servers, LOV Job server, WebIntelligence Job and Report Servers, Desktop Intelligence Job, Report and Cache Servers, Destination Job Server, Program Job Server, and Event Server.
• Imported data from Business Objects 6.x & Crystal Enterprise 10 to Business Objects Enterprise XIR1
• Configured BO Server Products like WEBI and BCA Publisher & Auditor on different nodes in Distributed Environment
• Worked with database connections, SQL joins, cardinalities, loops, aliases, materialized views, views, aggregate conditions, parsing of objects, LOVs, and hierarchies.
• Deployed reports to Repository through Broadcast Agent Server
• Scheduled Business Objects Reports using Broad cast Agent and scheduler

Environment: Windows XP, server 2003, Oracle9i, Business Objects 6.5, Designer, WEBI, Publication Wizard, Broad cast Agent, Supervisor, Business Query, Info View. Oracle,, MS SQL Server.