SUMMARY

• Dynamic, result oriented Technical design developer with 7+ years of software experience and experience in Data Warehousing, Business Intelligence, Client Server applications and Reporting
• An insightful, result - driven professional with notable success while participating in Analysis, design, Development, Testing and Implementing BI solutions
• Extensively worked on SAP Business Objects BI 4.1/3.1/XIr2/6.5which includes Information Design Tool (IDT), Universe Design Tool (UDT), Web Intelligence Rich Client, BI Launchpad, Desktop Intelligence, Info view, Dashboards Designer, CMC, Xcelsius, Crystal Reports 2013/2011/2008/ XIr2, Crystal Reports for Enterprise (C4E), Live Office, Query as a Web Service (QaaWS), Upgrade Management Tool (UMT), Promotion Management (LCM)
• Proficient in design, development, deployment, Maintenance, Production Support of complex universes and updating of existing universes using Business Objects tools like Information Design Tool (IDT) and Universe Design Tool (UDT) using Relational and OLAP data sources.
• Extensive experience in developing semantic layers (Universe) in Business Objects based on the report requirements and dealt with various Universe related topics like Loops, Traps, Alias Tables, @ functions, Derived Tables, pseudo prompts, hierarchies, restrictions, LOVs and Universe Parameters
• DevelopedObject level and Row Level restrictions on different user groups and users at Universe level and also implemented Index Awareness for complex reports.
• Developed simple, medium and complex reports like On-demand, Ad-hoc, Canned, Slice and Dice, Alerterand Ranking reports using Web Intelligence and Desktop Intelligence tools and worked with Merged Dimensions, Sub-queries, Custom SQL while developing these reports
• Experienced working with various versions of Crystal Reports like 2013/2011/2008 and C4E for creating complicated reports including Sub-Reports, Parameter based Reports, Graphical Reports, Formula Based, Well-Formatted Reports, Drilling Reports, Analysis Reports, and Data Reports along with LOVs.
• Experience in generation ofvisualizations by using various connections like Live Office, SAP BW and QaaWS Connectionsetc and developed Filters, Label based menus, Flash Variable connections, SWF loader, Tabsets, According menus, Canvas Containers, List Builder, List Views, Sliders, Fish Eye menu, Play Selectors, Grids in Dashboards using Dashboard designer.
• Strong understanding of Relational Databases like Teradata 13/12/6.0, Oracle 11g/10g/9i/8i, IBM DB 2 10.1/9.8/9.1/8.1 , SQL Server 2012/2008/2005 , MS Access, Sybase 12.x/11.x, Vertica 7.0/6.1 and OLAP data sources like SAP BW/HANA and MS OLAP. Used various connectivity types like ODBC, JDBC, OLEDB,BICS and BAPI
• Strong Knowledge in designing and developing Data marts and EDW using multi-dimensional Models such as Snow Flake and Star Schema and excellent understanding of ER Modelling
• Trained users in Business Objects tools such as BI Launch Pad, Infoview, Web Intelligence, Dashboards and Live Office.
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals. Capable of working as a Team Member or Individually with minimum supervision.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.

TECHNICAL SKILLS

Business Intelligence: Business Objects 4.1/3.1/XIr2/6.5 (Information Design Tool (IDT), Universe Design Tool (UDT), CMC, Web Intelligence Rich Client, BILaunchpad, InfoView, Desktop Intelligence, QaaWS, LiveOffice, Crystal Reports 2013/2011/2008/ XIr2, Crystal Reports for Enterprise (C4E), Dashboard Designer 4.1, Xcelsius 2011/2008/4.5 , Instance Manager, BusinessViewManager, QueryBuilder, Analysis Edition for OLAP

ETL/Data Integration: Informatica 10/9.6/8.6/7.3 , Data Services 4.2/4.1/3.2/3.1 Data Integrator XI r2, Data Stage 8.1/7.5 and Ab Initio 1.13/1.11

OLAP: SAP R/3 4.0/4.5, ECC 6.0, SAP BW 3.5, SAP BI 7.0 / 7.3, BEx Analyzer, BEx Query Designer and MSAS

DW Methodologies: Multi-Dimensional Data Modeling (SAP BW 3.5, SAP BI 7.0), Data Warehousing Design (Star-Schema and Snow-Flake Schema), Logical and Physical Design

Utilities: TOAD, Rapid SQL, Quest Central, Queryman, SQL Developer

Databases: Oracle 11g/10g/9i, Vertica 6.1.2, Composite, Teradata 13, SQL Server 2008/2005/2000 , DB 2 9.7/9.5/8.0 , Sybase 12.x and MS Access

Programming: SQL, PL/SQL, Unix Shell Scripting

Operating Systems: SuSe Linux10.1/9.2, Sun Solaris, RHEL 6.5/6.3/5.7, IBM-AIX 7.1 and Windows 2012/2008/2003

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Business Objects Developer

Responsibilities:

• Participated in BO Upgrade from 3.1 to 4.1 and conducted atomic testing and functional testing for existing reports
• Developed .unx universes using IDT tool and converted some of the existing .unv universes to .unx using the IDT tool
• Changed the data provider for the existing reports by pointing to the new .unx universe
• Resolved joins related issues at semantic layer level like loops and traps by creating alias tables
• Created new Attributes, Filters and Complex measure objects in the universe
• Worked on the SQL Tuning and optimization of the Business Objects Reports
• Developed complex Web Intelligence reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement
• Scheduled and monitored reports by custom built instance manager which developed using BO SDK
• Handled various tickets for business objects issues for the end users in developing new reports and enhancing existing reports.
• Developed simple, canned and ad-hoc reports using various functionalities like queries, sub queries, Alerts, Slice and Dice, Drill Down, Master Detail and Formulas etc.
• Worked on Various Sub-Reports and Cross Tab Reports
• Worked on Database Expert, Section Expert, Select Expert and Group Expert and Hierarchical Grouping to develop the reports using Crystal Reports 2013
• Modified existing crystal reports and created new reports with cross tabs, sub reports and used Parametric Fields, Formula Fields and Summary Fieldsbased on the client requirements using Crystal Reports 2013.
• Interacted with Business Users and Business Analyst in gathering, analyzing, and documenting business, functional requirements and data specifications for Business Objects Universes and Reports
• Created Breaks, Filters, Sections at Different Levels of the reports and applied ranking in the Webi reports.
• Extensively worked with formatting the reports according to the user requirements
• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
• Implemented Object Level and Row Level Security at Universe Level
• Created custom LOVs, derived tables at Universe level
• Effective skills to build reports in Business Objects. Expertise in creating Xcelsius Dynamic Dashboards using SAP BI data/BEx Queries. Valuable knowledge on Xcelsius Dashboard components like Charts, Selectors (Filters, label based menus), Canvas Containers.
• Performed Unit Testing, System Testing and Performance Testing for each report

Environment: Business Objects 4.1/3.1, Crystal Reports 2013, Live Office, Dashboards Designer, BODS 4.1, SAP BW 7.0, R/3 4.0/4.5, ECC 6.0, BEx Query Designer, BEx Analyzer, Oracle 11g/10g, Vertica 6.1/7.0, RHEL 6.5

Confidential, Dublin, OH

Sr. Business Objects Developer

Responsibilities:

• Involved in Business Process Analysis, Develop & Implement Data mart.
• Interacted with Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in the designing and Building of Universes, Classes and objects
• Resolved loops and Traps using Aliases while designing Universes.
• Created Pre-defined filters to restrict data based on report requirements.
• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe
• Customized Universe level Prompts as per Functional Requirements.
• Created reports using Business Objects functionality's like Queries, Drill Down, Cross Tab, Master Detail and Formulae's.
• Created the reports using Business Objects functionalities like Combined Queries, Drill down, Cross tab, Master detail and Formulae.
• Created Standard Reports utilizing all the features on Web Intelligence like Optional Prompts, Functions, Alerters etc.
• Applied Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports.
• Extensively worked with formatting the reports according to the user requirements.
• Provide support for the Operations Risk Department workflow enhancement efforts includes Data issue identification and analysis, data mapping, data contents of reports and source of data contents.
• Developed Dashboards using Xcelsius 2008 and Dashboards Designer according to user specifications.
• Wrote complex views, functions and stored procedures using SQL, PL/SQL, to be used in Reports development.
• Recommended standards of good practices of report development and maintenance of universes. Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc.
• Modified existingcrystal reportsand created new reports withcross tabs and sub reportsbased on the client requirements usingCrystal Reports 2008/2011.
• Designed complex reports and Dashboards based on discussions with user groups and created various objects using built-infunctions (like prompt, select, where, and aggregate), complex report level filters and contexts and complex SQL queries and joins involving case statements etc.
• Always considering best business Practices using Business Objects on SAP and non-SAP sources for Web intelligence Rich Client, Crystal and Dashboards.
• Go exposed to SAP BW BEx Queries as data sources to Web Intelligence
• Was involved in training the end users over the newly developed crystal and Web Intelligence reports.

Environment: Business Objects 4.1/4.0/3.1, Crystal Reports 2011/2008, Live Office, Dashboards Designer, Xcelsius, SAP BW 3.5/7.0, R/3 4.5, ECC 6.0, BEx Query Designer, BEx Analyzer, Datastage, DB 2 9.5.4/9.7.4 , Teradata 13.10

Confidential, Hartford, CT

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.
• Designed and Document Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Created Full client, Web I and Crystal Reports based on the END Users and Business requirements and Modified the existing Reports based on the specifications and requirements
• Analyze the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports
• Involved in Building universe, inserting tables, detecting joins, detecting cardinalities and checked the integrity
• Created universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems
• Implemented the Object-Level Security and Row-level security in Universe. Implementing the Table Mapping in Universe to restrict certain data in a table to only one group of users
• Designed and developed extensive Business Objects reports like Simple, Complex, Cross Tab using multiple Queries, Prompts, combination chart and tables
• Created, maintained and modified the business critical reports using the Web Intelligence
• Created Standard Reports utilizing all the features on Web Intelligence in BOE XI 3.1 like Optional Prompts, Functions, Alertersetc
• Created complex reports using Merged Dimension and multiple data providers and synchronized the data providers by linking the common objects to create the common report
• Extensively worked on Unix Shell Scripting
• Responsible for creating the Deski and Webi reports (On demand, Audit Reports, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc)
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Center
• Good experience in Mentoring the BO development teams

Environment: SAP Business Objects 4.0/3.1/XIr2 Xcelsius 2008, Live Office, Crystal Reports 2008, Informatica Power Center 8.1.1, SQL Server 2008/2005, Oracle 10g, SQL,PL/SQL,Unix Shell Scripting, UNIX AIX 5.3

Confidential

Business Objects Developer

Responsibilities:

• Requirement gathering, Analysis, Documentation & Development of reports.
• Designing and developed universes and reports in accordance to customer needs and requirements.
• Ensure project delivery to meet scope, budget, schedule, quality requirements, and manage the expectations of project stakeholders.
• Testing and providing troubleshooting and technical solutions for the issues.
• Analyzed data after the reports were created for accuracy of data generated by the reports.
• Build the new universe as per the requirement by identifying the required tables from semantic layer and by defining the universe connections
• Optimized the Universe and Database table for improving report performance.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI
• Deployed reports on the web using Crystal publishing wizard and scheduled reports using e-Portfolio and Crystal management console
• Created new Attributes, Filtersand Complex measure objects in the Universe.
• Maintaining Reports from two different Universes.
• Created reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis.
• Defined and created Hierarchies as per the business rule for the reports to be viewed at various Drill-down and Drill-up reports.
• Providing support to the Web Users and Full client users for any specific or performance issues related to the reports.
• Created the new Views and Aggregate tables for report performance.
• Scheduled and monitored reports by using Broadcast Agent.
• Worked extensively on Web Intelligence for any new requests and performance issues.
• Developed complex reports merging queries, using aggregate aware function for calculating monthly and 3 day intervals, drill down, Slice and Dice, master/detail for analysis.
• Experience troubleshooting and solving business user ad-hoc report development problems.

Environment: Business Objects 3.1/XIr2, Crystal Reports XIr2/10, Performance Manager, Data Stage 7.5, IBM-AIX, Windows 2005, DB2 8.0, SQL Server 2005, Sybase, Rapid SQL 7.4.2, Quest Central 4.9, Mercury Quality Center 9.0

Confidential

Business Objects Developer

Responsibilities:

• Data Warehouse analysis and interaction with different system (Application & Database) administrators to collect the requirements for analysis.
• Involved in Performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Mapping of data from Source to Staging and Schema for reports.
• Designing, creating universes and reports using Business Objects/Web Intelligence.
• Prototyping and Drafting of all the Reports.
• Created various Reports with BO XIr2 and BO 3.1
• Formatted the Reports as per the Users requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Involved in installing, configuring B.O, Web Intelligence, creating users, user groups and performance tuning Created reports using Business Objects features like Slice/Dice, Drill Down, @Functions, Cross Tab etc

Environment: Business Objects 3.1/XIr2, Web Intelligence, Broadcast Agent, Oracle 9i, PL/SQL, UNIX, Windows 2003 and TOAD.