PROFESSIONAL SUMMARY:

• 8 years of Experience in BI technologies as a Business Intelligence Consultant with a skill set of Business Objects XI3.1/XI3.0/XIR2/6.5.1/6/5.x, Business Objects Designer, Desktop Intelligence, Web Intelligence, Info View, Dashboard, Scorecards, Central Management Console, Xcelsius, Crystal Reports 2008/XI, Live Office, Query as a Web Service (QaaWS), OLAP, Oracle 11g/10g/9i/8i, SQL Server 2005/2008, MS Access.
• 8 years of experience as Business Objects Developer
• 3+ years of experience as Xcelsius Developer
• Experienced in Data Modeling, Star/ Snowflake schema modeling, Fact and Dimension Tables, Physical and Logical data modeling using Erwin 7.2/4.0/3.5, Toad Data Modeler, Microsoft Visio.
• In depth knowledge of designing Entity Relationship and Data Flow Diagram for Business processes. Strong understanding of data modeling and dimensional modeling concepts like Slowly Changing Dimensions.
• Sound Experience in designing, development and deployment of complex Universes.
• Migrated existing BO universes and reports to BOXI using Import Wizard
• Sound Knowledge in SAP Integration
• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, Cardinality, Aliases, Contexts, and Aggregate Awareness using Business Objects Designer.
• Worked on of new features of Business Objects XI including Index awareness, Derived tables and Central Management Console(CMC)
• Performance Tuning and Optimization of BO reports at all levels.
• Worked with Crystal Reports 2008/XI for creating complicated reports including sub - reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports and data reports.
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
• Worked extensively on various Business Objects functionalities like Queries, Slice and Dice, Cross Tab, Master Detail, Breaks, Alerts, Filters, Sorts, Ranking, Prompts, and Calculations.
• Worked in both ad-hoc and complex report environments.
• Technical proficiency in creating interactive dashboard and scorecards using Xcelsius and Performance manager
• Used Live Office and QaaWS (Query as a Web Service) to feed live data into Xcelsius 2008 to show product portfolio.
• Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and XML files.
• Expertise working with Data Integrator 6.5.1/XI Designer creating DI Workflows and Jobs and executing them in Dev and Test Environments.

TECHNICAL SKILLS:

BI Tools: Business Objects XI3.1/XI3.0/XIR2/6.x/5.x, Universe Designer, Web Intelligence, Desktop Intelligence, Infoview, CMS, CMC, Live Office, Import Wizard, Report Conversion Tool and QaaWS, Crystal Reports 2008/XI/X, Xcelsius 2008, Dashboard Builder, Predictive Workbench 3.1/3.0,Bex Query Analyzer, Broadcast Agent Server

ETL Tools: Data integrator XI, SAP BW 7.0, 3.5

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, MySql 5.1, IBM DB2, MS Access

Programming: C, C++, JAVA, VB.NET,SQL, PL/SQL, HTML, UML, XML, SQL*Plus

Data Modeling: Erwin, Microsoft Visio, Toad Data Modeler

Operating Systems: Windows XP/NT/2000/98/95, Windows 2003,Solaris 10,UNIX

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr. Business Objects Report Developer/ Data Analyst

Responsibilities:

• Part of Credit Portfolio Information Services (CPIS) team directly coordinating with high-end user to gather the new requirements and working with existing issues.
• Responsible for the System Study & Business Requirements Analysis & Documentation.
• Actively worked with the end users in finalizing the Functional Specifications. Created detailed Technical Specifications for each mapping based on these Functional Specs.
• Worked directly for Chief Credit Officer (CCO) and given solution of complex Analysis in shape of Rating Agency and Board Materials.
• Projects successfully implemented in production under ICRS are Non-Performing Analysis, Homebuilders and Credit Management Package.
• Designed & Implemented security architecture for Credit Reporting System.
• Involved in Data Modeling and Oracle Database
• Designed Universes for Integrated Credit Reporting System.
• Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.
• Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where).
• Resolved Chasm, Fan traps and Loop problems.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
• Prepared complex reports like Financial reports, HR reports, Standard and Ad-hoc reports using Web Intelligence 3.1, Desktop Intelligence 3.1 and Crystal Reports 2008
• Created reports based on General Ledger, Credit Product Group and Market Segment categories
• Created many reports according to the loans, commitments and outstanding to know the exact amount of change in each loan
• Created reports like Residential and Business Customers reports.
• Created reports like Reports by Period, Demographic reports and Comparative Reports.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Used Xcelsius to Visualize and to enhance the data presentation along with developing dynamic charts and graphics.
• Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.
• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Installed, Configured and Administered Business Objects products.
• Carried on Upgradation from Business Objects XI 3.0 to 3.1
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Performed unit testing, system testing and user acceptance test (UAT) for universe, reports and security management.
• Developed universe user documentation guide for the end users

Environment: Business Objects XI 3.1/3.0, Crystal Reports 2008 SP3, Import Wizard, Conversion Tool, Web Intelligence XI 3.1, Desktop Intelligence XI 3.1, Xcelsius 2008 SP3, Designer, Info View, Toad 9.0, Oracle 10g, SQL, PL/SQL and Windows XP.

Confidential, Santa Clara, California

Business Objects Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes.
• Created several Universes using Designer according to the Requirement.
• Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where).
• Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.
• Tested the aggregate awareness to ensure the 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.
• Exported the universe to the Repository to make resources available to the users.
• Scheduled the universes on daily wise, monthly wise and weekly by using Scheduler
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Applied row level and object level securities on different groups and users.
• Created several Webi reports, Deski reports and Dashboard reports for graphical presentation.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports..
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used multi dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
• Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis).
• Generated Reports based on time like Year, Quarter, Month, Week based on Geographic and Comparative reports.
• Exported reports into XL, PDF, CSV and XML formats as per the client requirement.
• Used features such as functions, running totals, and parameters, conditional formats to develop highly formatted Crystal Reports.
• Used Broadcast Agent Publisher, which enables distribution of information via email using an easy-to-use, subscription-based mechanism
• 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.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Xcelsius 2008.
• Used Xcelsius for presenting dashboards to End users.
• Created Revenue Dashboard, Sales figure Dashboard using Xcelsius 2008.
• Migrated Business Objects XI R2 content (users/user groups, Universes, reports) in to Business Objects XI 3.0 environment using the Import Wizard.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

Environment: Business Objects XI 3.1/3.0/R2, SQL Server2005/2008, Oracle 11g/10g/9i, Toad Data Modeler, Web Intelligence XI R2/ XI, Infoview, Live Office, PL/SQL, QaaWS, Windows XP, Windows 2003 Server

Confidential, Riverdale, MD

Business Objects Developer

Responsibilities:

• Work with business users and analyze the Reporting Requirements and Metric Analytics to come up with the technical specifications for the BO Reports from different sources.
• Building universes on top of SAP BW - Bex Queries using SAP Authentications.
• Worked on building Xcelsius Dashboards on top of universes build using SAP Integration Kit.
• Used QAAWS and Live office functionalities of BO to pull Data from SAP Universes.
• Experience in using QAAWS connections in Xcelsius with Refresh on Load option which enables pulling of Live Data from Universes as well as Web Intelligence reports on Demand from Data base.
• Design and develop various universes and configure Joins, Cardinalities, Loops, Contexts and Shortcut Joins
• Created Xcelsius dashboards for visual understanding of information and publish to BO Enterprise
• Created Xcelsius components like charts, menus and containers
• Mining data and performing statistical analysis using Predictive Workbench
• Work on Performance Manager to create various Metrics, Analytics and use Dashboard Manager to build Corporate Dashboards.
• Created different kinds of analytics including Gauge Analytic, interactive Metrics Trend and Metrics List
• Created Rules for Dashboard Manager like Events, Conditions and Actions
• Adopting strategies for List Of Values involving customizing the list of values, Cascading list of values and exporting the List Of Values with the universe
• Use LCM (Life Cycle Manager) for exporting BO Objects from one environnement to other.
• Use Database Expert, Group Expert, Select Expert, Section Expert to create different Crystal reports
• Use Section Expert with Conditional Formatting to create Hide / Suppress Summary Reports
• Developed and Converted Complex DESKI Reports to BOXIR2 - WEBI Using Report Conversion Tool.
• Migrated reports from 6.5 to XIR2 using Import Wizard.
• Used CMC (Central Management Console) to manage the universes, users/groups, reports and Security model to objects
• Designed Star and Snowflake schemas for Equities, Fixed Income, Client Coverage and Deals subject areas using Dimensional modeling and Erwin.
• Created reports using Business Objects functionalities like Multiple Data Providers (Merging), Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail
• Created Complex Queries in Desktop Intelligence and Web Intelligence including Complex Conditions (wildcard characters, In List, Different From), Subqueries, and Grouping Conditions
• Combine data from different sources and linking data providers (Merging)
• Design and deploy the security model for Analytics and Corporate Dashboards
• Worked extensively with the major functionality of BO like Breaks, Ranks, Variables, Alerters, Formulas, Calculated data items, Filters, Sorts, and Query prompt

Environment: Business Objects XI R2/6.5, Oracle 10g/9i, SQL Server 2005, Infoview, Crystal Reports XI, Web Intelligence XI, Xcelsius, SAP BW, SAP Integration Kit, QaaWS, Predictive workbench, Visio

Confidential, Columbus, OH

Business Objects Analyst/Developer

Responsibilities:

• Used Business Objects Designer to maintain Universes, identifying Measures, Details and other dimensional objects
• Extensively worked with Business View Manager for developing Business Views, dynamic Cascading Prompts
• Created many reports with Crystal Reports X with Business Views as data source
• Involved in creating the repository for Performance Management and creating different Analytics/Metrics and statistical functions on the metrics (time-rolls ups, moving averages)
• Designed the Corporate Dashboard Security on measures/metrics/analytics using the Access Restrictions in the universe
• Created critical visualization using Business Objects Crystal Xcelsius for the Business Dashboard.
• Used Crystal Report’s to feed data to Crystal Xcelsius Visualization an XML file as a data source.
• Resolved inconsistencies using aliases/contexts to maintain universe integrity and check for loops and traps including chasm trap and fan traps
• Created Crystal Reports using Crystal reports Formulas, Grouping, Parameters, Selection criteria to handle the customer’s requests from Tables, Stored Procedures, Views and Command Objects
• Create Hierarchy groups with Group Expert and Group Selection Formulas in Crystal Reports
• Use Conditional Formatting, Format Painter, Report Alerts and Suppress features of Crystal Reports to format the report
• Created Sub-Reports (Unlinked / Linked, In-place / On-Demand) with Shared Variables between the main report and the Sub-report in Crystal Reports
• Created cross-tab reports using Cross-tab expert in Crystal Reports
• Worked extensively with the major functionalities of Business Objects like Alerter, Group By, Query Prompt, Drill Filter, Indexes, Breaks, Sorts, Ranking, and Calculation using the Slice and Dice panel.
• Use Changed-Data-Capture (CDC) to extract only new or modified data and update the target system including handling overlaps and preserving generated keys
• Troubleshoot power users reports with errors like ( #Computation, #Multivalue, #Alerter, #Error, #Err, #Overflow, #Unknown)
• Created different types of reports, using Business Objects Reporting tool, such as Master/Detail, Cross-tab and Bar charts used in analyzing trends
• Created Users/Groups, roles and assigned required rights to them. Involved in the administration of Management Console for implementation of security at Report level, Folder level and Object level by assigning rights and required access level as per business requirement.
• Responsible for Code Migration from development to testing, testing to production including managing data connections to different databases.
• Responsible for ETL extraction transform and loading data from different heterogeneous source systems such as XML, Flat files using Business Objects Data Integrator XI
• Worked with different types of transformations like Query, SQL, Date-generation and validation.

Environment: Business Objects XI R2, Oracle 10g, SQL Server 2005, DB2, Infoview, Crystal Reports X, Web Intelligence XI, Erwin, Data Integrator XI

Confidential, IL

Business Objects Developer

Responsibilities:

• Created Universes using Business Objects and resolved loops and Join problems by creating Aliases and Context.
• Responsible for analysis meeting with end users and business units in order to define the requirements.
• Experience in translating business requirements in to technical/data element requirements.
• Involved in gathering the requirements for reporting from the end users.
• Used Broadcast Agent to schedule the reports.
• Migration of Universes and reports from development to Production environment.
• Modified Universe after analyzing areas of business and user requirements
• Use of slicing and dicing for generating master/detail and tabular reports
• Experience in creating application schema as tables, view and indexes
• Created Full Client Reports making use of Business Objects functionalities, like Multiple Data Providers, Prompts, Slice and Dice, Drill Down/Up.
• Involved in preparing detailed ETL design documents, unit test plans for the mappings.
• Scheduled and monitored using Broad Cast Agent.
• Created Dashboards based on the requirement.

Environment: Business Objects 6, Web Intelligence, Desktop Intelligence, Infoview, Oracle8i, Ms-Excel and Windows 2000.

Confidential

Business Intelligence Developer

Responsibilities:

• Involved in designing universes and objects by retrieving the data from various data sources and defining the necessary connections.
• Provided support to the Web Users and Full client users for any specific or performance issues related to the reports.
• Resolved Loops, Fan traps and Chasm traps with Aliases and Contexts.
• Creating Measure objects and hierarchies.
• Created custom LOV’s and Hierarchies for easy user selection drill down purposes.
• Exported the Universe/Reports to the Repository.
• Worked with multiple Data providers in a report and added slice and dice capabilities.
• Developed Cross-Tab and Drill Down reports.
• Used Broadcast Agent to schedule the reports.
• Formatted the Reports as per the Users requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Exported the reports in to PDF, Excel and Word formats.
• Extensive testing and migrating the reports or objects from Test to Production system.
• Worked along with the testing team to derive test cases for efficient Data reporting.
• Performed the knowledge transfer to other team members.

Environment: Windows NT, Red Hat Linux 7.2, SQL Server 7, Sybase 11.5, Business Objects 5.1.3, Web Intelligence 2.6.3, BCA Publisher, Apache, Visual Basic 6, MS Project