SUMMARY:

• Over 7+years of experience in Information Technology field with strong emphasis in Business Intelligence and Data Warehousing Tools.
• Experience in various Business Domains like Retail, HealthCare, Finance and Manufacturing.
• Extensive experience in Business Intelligence tools using Business Objects XIR3.1/ XIR3/ XIR2/ XI/6x/5x Administration (Supervisor/CMC), Universe Design (Designer), Report development (Desk I/Web I/Rich Client), Info View, Import Wizard, Broadcast Agent, Crystal Reports.
• Hands on experience in working and implementing Crystal Reports 2008/XIR2/10/9/8, Crystal Xcelsius 2008/4.5/3.5/3.0.
• Experienced with all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administrating, Security Management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.
• Experience in designing and developing the Universe according to user requirements, designing Canned/Ad-hoc reports.
• Created complex universes by employing various techniques including loop detection, prompts, conditions, classes, object dimensions, measures, multiple contexts and hierarchies.
• Designed and development of Business Objects OLAP Universes on SAP BEx Queries and SAP BW Infocubes.
• Created various objects using built-in @functions (like @prompt, @select, @where, @aggregate aware), complex SQL queries and joins.
• Extensive knowledge and solid understanding of Data warehousing, Data Marts, Star Flake Schema and Snow Flake Schema modeling, Fact tables and Dimensional tables and implementedSCD.
• Expertise in creating Dashboards, Metrics, Rules and Goals, corporate/personal dashboards, Alerts.
• Extensive knowledge with Xcelsius Dashboards using QAAWS and Live office.
• Exceptionalexperience in Oracle 10g/9i/8i, SQL Server 2008/2005, Sybase, Teradata, DB2 etc
• Experience in data retrieval methods using Business Objects Universes, Personal Data Files and Free Hand SQL methods and XML files.
• Designed and developed ETL processes (Data Integrator), data flows, and Data Marts based on business requirement specifications.
• Experience in implementing row level security and universe level security within Business Objects.
• Created few thousands of reports in both Desktop Intelligence (Full Client) and Web Intelligence (Thin Client).
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.
• Solid understandingandexperience in setting upof Repository and Experience in creating users and user groups, restricted access of the users as needed usingCentral Management Console (CMC).
• Experience with SQL tuning & SQL optimization to maximize query performance.
• Performed Migrations from earlier versions 5.x, 6.x to XI R1/R2/R3 architectures.
• Worked with Crystal Report XIR2 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Experience in documentation using MS-Office (MS-Word, MS-Excel).
• Good Knowledge on ETL for Data Extraction from disparate sources, data transformations and loading into the target database.
• Experienced in Training and Supporting end user reporting needs using Business Objects.
• ASelf-starterand aTeam player. Capable of working independently as well as motivating a teamof professionals.
• Possess excellent communication skills. Quick learner, possess excellent analytical and technical skills.

TECHNICAL SKILLS:

Business Intelligence: Business Objects XIR3.1/XIR3/XIR2/XI/6.5/5.0.x (Supervisor, Reporter, Designer), Performance Manager, QAAWS, Report Conversion Tool, Dashboard Manager, ZABO, Web Intelligence XIR2/6.x/2.x, Info view, Broadcast Agent 5.0, BO XIR3/XIR2 (CMC, CMS, CCM, Designer, Desk I, Web I), Crystal Xcelsius, Xcelsius
Reporting Tools: Crystal Reports 2008/XIR2/10/9.0/8.0/7.0, Crystal Xcelsius 2008/4.5
ETL Tools: Informatica Power Center 7.x/6.x, Data Integrator XI/6.5.0.1
Databases: Oracle 11g/10g/ 9i/ 8i, My SQL, MS Access, SQL Server 2008/2005/2000,
Sybase, Teradata, DB2
Programming Languages: SQL, PL/ SQL, C, C++
Web Technologies: VB, HTML, XML, DHTML
Operating System: Windows NT/XP/2003/2000/98/95, DOS, UNIX
Data Modeling: Erwin 4.5/ Visio
Packages: MS-word, MS-Excel, MS- Power point

EDUCATION:

Bachelors of Technology in Computer Science

PROFESSIONAL EXPERIENCE:

Responsibilities:

• Involved in Migration of Universes and Reports from XIR2 to XIR3.1 and alsoin testing (Universes & Reports) & troubleshooting issues throughout the migration process.
• Interacted with High End Business Users and Business System Analysts to gather the Requirements.
• Participated in the full software development life cycle.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Extensive use of PROC SQL to perform queries, Join tables.
• Conducted analysis and generated tables, listings and graphs using SAS.
• Created SAS data sets, cleaned data, extracted data and merged data sets using Base SAS.
• Read data from Excel and flat files into SAS and transferred data between databases.
• Presented the results and reports in PowerPoint for customers.
• Created many datasets and dumped the tables in the user database, further used them for reporting.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Created different reports containing charts showing funded contracts by different divisions, market share.
• Applied securities using Filters in Business View Manager to certain users and groups depending on their profiles and revoked the restriction when needed.
• Developed Custom hierarchies to support drill down reports for in-depth analysis.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerter.
• Created complex reports using user defined functions and condition objects.
• Used Web Intelligence, Crystal Reports for querying, reporting.
• Used Functions like @Prompt, @Select, @Where in the Designer to handle User requests for report generators and increase the performance.
• Tuned the queries to improve the Performance of the existing reports for various functional areas.
• Created SQL queries on SQL Query Analyzer and ran the queries against the database in order to validate data returned by the report.
• Conducted User Training sessions for all our customers and educated them how to access the reports on portal.

Environment: Business Objects XIR3.1/XIR2 (CMC, CMS, CCM, Designer, Desk I, Web I, Info View, Dashboard Manager, Performance Manager, Import Wizard), Crystal Reports 2008, SQL Server 2008/2005, PL/SQL, Teradata, Windows 2003 Server, UNIX, Xcelsius 2008, SAS 9.1/9.2.

Responsibilities:

• Installed and configured Business Objects XI R3 Enterprise on Windows 2003 Server.
• Involved in Migration of Users/Groups, Universes and Reports from XIR2 to XIR3 using Import Wizard & alsoin testing (Users, Universes & Reports) & troubleshooting issues throughout themigration process.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Interacted with Business Users and Business Analysts to gather the Requirement andBusiness logics.
• Participated in the full software development life cycle.
• Created Universes from multiple databases for different business groups from different databases.
• Involved in the design of the universe and identified the tables that are to be used and all possible relations between the tables to build the universes.
• Involved in data integration to retrieve the appropriate data for universe creation.
• Created Contexts and Aliases for resolving loops and join problems in the Universes.
• Created universes, classes and objects, predefined conditions, prompts, custom hierarchies, pivot tables by retrieving the data from various data sources including stored procedures and templates and defining the necessary connections.
• Applied Row level, Object level securities using Designer to certain users and groups depending on their profiles and revoked the restriction when needed.
• Responsible for creating and managing business objects Repository.
• Exported and Imported universes and documents to and from repository.
• Developed Custom hierarchies to support drill down reports for in-depth analysis.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerter.
• Interacted with end users regularly in order to generate the required reports. These reports were generated using Business Objects functionality such as Slice and Dice, Drill Down, Master/detail, Prompts and Formulas.
• Created complex reports using user defined functions and condition objects.
• Extensively used Web Intelligence, Info View and reporter for querying, reporting and analysis the tasks.
• Used Merge dimension in Web I to merge data from multiple data sources.
• Scheduled full client reports and Web Intelligence reports with Broadcast Agent Server based on Specific time, events and calendars and in various formats such as Excel and PDF.
• Handled Embedded Functions like @Prompt, @Select and @Where in the Designer to handle User requests for report generators.
• Created base reports and sub reports using Desk I, Web I from multiple Data providers and used the merge dimension option to synchronize the Data in Web Intelligence reports.
• Tuned the queries to improve the Performance of the existing reports for various functional areas.
• Used performance manager to build Dashboards and Score cards to provide the users with Visual representation of corporate data.
• Created SQL queries on SQL Plus and TOAD, ran the queries against the database in order to validate data returned by the report.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Xcelsius.
• Created web services using Query as Web Services for dynamic data.
• Conducted User Training sessions for Business Objects tool usage by preparing power points and provided detailed documentation for universe and reports.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Environment: Business Objects XIR3/XIR2 (CMC, CMS, CCM, Designer, Desk I, Web I, Info View, Dashboard Manager, Performance Manager, Import Wizard), Broadcast Agent, Data Integrator XI ,Crystal Reports 2008, Oracle 11g/10g ,SQL Server 2008/2005, PL/SQL, DB2, Sybase, Windows 2003 Server, UNIX, Xcelsius 2008.

Confidential, Duluth, GA (May 2008- May 2009)
Senior Business Objects Developer

Responsibilities:

• Installed & Configured Business Objects Enterprise XIR2 on Windows 2000 server and created Repository.
• Performed universe migration from Business Objects 6.5 to Business Objects XI R2.
• Interacted with the end users, Project Manager and other resources in understanding the requirements and writing universe, report specifications.
• Worked with customers for analyzing business requirements & planned to create multiple universes based on the analysis & business complexities.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool and Published Reports using Broad cast Agent Publisher.
• Developed complex new Universes, Reports and Linked with existing Universe, and resolved Loops, Fan Traps, Chasm Traps by using Cardinalities, Contexts and Aliases to remove the cyclic dependencies between the tables.
• Worked on Data Integrator 6.5.0.1.
• Involved how to define database Data Stores and File Formats to allow Data Integrator to connect to the source or target database and files.
• Created Classes, Sub Classes, Dimension Objects, Measure Objects to capture complex formulae in multiple universes, checked the Integrity of the Universes and exported the Universes to Repository for making available to users.
• Created Variables, Functions, Grouping Objects, and inserting Prompts at report level in Business Objects XIR2 as well as Business Objects 6.5.1.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompts and Drill filters.
• Created the reports using Business Objects 6.5 functionalities like Slice and Dice, Drill Down, Drill Across, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Created reports using Oracle Databases, Personal Data Files and SQL Server as the data providers.
• Resolved the performance issues in report generation and tuned the universe for better performance.
• Expertise in writing and implementation of the packages, triggers, stored procedures, functions, views, materialized views and indexes using PL/SQL and SQL.
• Extensively generated Crystal Xcelsius Dashboard visualizations through Crystal Xcelsius 4.0.
• Formatted the raw data retrieved from Universe Objects in Xcelsius spreadsheet using VLOOKUP, IF, AND, OR, CONCATENATE and many other excel formulae/functions that are supported inXcelsius.
• Worked on complex Crystal Reports that require running totals, sub-totals, sub-reports, prompts, cross-tab, multiple groups, hierarchical grouping and conditional display of groups, fields, and messages.
• Involved in using Formulas to generate reports using Crystal Reports XI.
• Involved in writing detailed and high level documents for reports and universe design.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Environment:Business Objects XIR2/6.5.1 (Supervisor/CMC, Designer, Desk I), Web Intelligence XI/6x, Broadcast Agent, Oracle9i, SQL, PL/SQL, MS SQL Server 2000, DB2, Excel, Windows 2003 Server/ XP, Crystal Xcelsius 4.0, Crystal Reports XI.

Confidential, Minneapolis, MN (Sept 2007- Apr 2008)
Business Objects Developer

Responsibilities:

• Involved in Migration from existing 6.5.1 systems to Business Objects XIR2 in Development Environment.
• Migrated Business Objects Users/Groups, Universes, Reports (Web I & Desk I) & Personal Data Files from 6.5 to XIR2 using Import Wizard.
• Involved with Business users and Process Technology groups to structurally define the business rules and successfully implement in the project.
• Installed & configured Business Objects XIR2 on Windows NT system.
• Created New Users and managed Existing Accounts.
• Created Security to the end-users in CMC in BO XIR2.
• Designed product service and accounting universes in designer module for ad-hoc reporting requirements.
• Created Contexts and Aliases for resolving Loops in the Universes.
• Involved in resolving issues relating to pre implementation of Reports.
• Implemented different level of hierarchies for drill down reports.
• Analyzed data using Slice and Dice and Drill Mode methods and formatted Reports.
• Controlling Reports data by working with Universe and Queries using Filters, Sorts and Rankings.
• Created Cross-tabs, Metrics and Charts etc.
• Used various Functions like Prompt (for user defined queries), Where (for creating conditional filters), and Select.
• Involved in writing detailed level documentation for reports and universe design.
• Provided end user training for basic and advanced reporting skills.
• Used scheduler to schedule the reports so that they can get refreshed every day.
• Involved in performance tuning of reports that were running slowly. Did performance tuning at the report level, Designer level and database level.
• Developed Dashboards for detailed analysis using Application Foundation.
• Created reports using Oracle Databases, SQL Server as the data providers.
• Dealt with the new functionalities and features of the BOXI R2 version.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius. Interacted with the end users and provided Production Support.

Environment: Business Objects XIR2/6.5 (Designer, Central Management Console (CMC), Desktop Intelligence, Crystal Reports, Import Wizard, Repository Migration Wizard, Universe Designer, Web Intelligence, Oracle 9i, PL/SQL, Toad, SQL Server 2000, UNIX, Windows NT.

Confidential, San Jose, CA (Jan 2007-Aug 2007)
Business Objects Developer

Responsibilities:

• Participated in requirements gathering, analysis and structured Business Intelligence platform based on user requirements.
• Involved in Installation, Configuration and Deployment of Business Objects Suite.
• Involved in setting up users and assigning privileges to these users to meet security requirements.
• Designed and Built Universes, Classes and objects, employing integrity check.
• Setting up object level and row level securities on the universes to various groups and users.
• Exported the universes to dev, test and prod domains to make resources available to the users.
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes.
• Resolved issues like loops by creating aliases and contexts as required in removing the cyclic dependencies.
• Creating standard Desk I/Web I reports, created canned and ad-hoc Reports Using Business Objects user module.
• Created reports using Business Objects features like Slice/Dice, Drill Down, Cross tab etc.
• Formatted the reports as per the Users requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Scheduled and Monitored Reports.
• Training to end user and power users.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Converted the existing full client reports to Web I docs using report conversion tool.
• Involved in fixing/converting Crystal Reports to Business Objects full client report.
• Personalizedthe Dashboards to include existing analytics, or setting user-specific alerts and metrics, Involved in building Dashboards and Scorecards to track critical Key Performance Indicators (KPI).
• Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.

Environment: Business Objects 6.5 (Supervisor, Designer, Reporter), Web Intelligence, BCA, Dash Board, Crystal Reports, Crystal Xcelsius, Oracle 9i, PL/SQL, Windows 2000 Server.