SUMMARY

• 7+ years of Business Intelligence and Programming experience in Information Technology with 6+years of intense expertise as Business Objects developer and one year of accomplished PL/SQL developer.
• Well seasoned Business Objects (XI3.1, XIR2, 6.x) Consultant with experience in Designer, InfoView, Web Intelligence, Desktop Intelligence and Query as a web service..
• Strong understanding of Data warehouse concepts.
• Migrated Objects, Documents and universes from Business Objects 6.x to Business Objects XI R2 Enterprise using import wizard.
• Highly interested in Business Process Improvement, Quality Based Initiatives and process oriented project development.
• Broad proficiency on working with universes, multiple data providers, free hand SQL, PL/SQL, Stored procedures.
• Created Cardinalities, Joins, Contexts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Designed Universes using operational data sources like MS Access.
• Created analytical reports from MOLAP and ROLAP cubes.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports. Documented the SDLC process definitions.
• Developed Xcelsius Dashboards using Query as a web Service (QAAWS) and live office components of Business Objects.
• Exposure to Web services.
• Provides knowledge transfer to other team members.
• Excellent communication and interpersonal skills.
• Dedicated and a very good team player with the ability to work independently.

TECHNICAL SKILLS

BI Tools: BO 6.x/XIR2/XIR3/3.1/4.0, BI Launch pad / Infoview, Interactive Analysis (Web Intelligence), Information Design Tool, Life Cycle Manager, Universe Designer, Business View Manager, Crystal Reports 2008, Crystal Xcelsius 2008/Engage, Voyager, Dashboard builder, BRIO, COGNOS and Microstrategy., CMC Performance Management, Report Conversion tool and Import Wizard

Database: Oracle8i/9i/10g, SQL Server 7.0/2000/2005 , MS Access 2000, SQL*Loader, Teradata

Languages: SQL, PL/SQL,C,C++,ABAP,JAVA

GUI Tools: Crystal Reports 7.0/8.0/9.0/10/ XI/XIR2, VisualBasic6.0, Oracle Forms and Reports, Oracle Toad, Developer/2000.

Multimedia Web Designing: HTML/DHTML, MS Office, Adobe Photoshop, PageMaker

Operating Systems: Windows NT/XP/2000/98, MS DOS and UNIX

PROFESSIONAL EXPERIENCE

Confidential, El Paso, TX

Senior BO 4.0 Consultant

Responsibilities:

• Setup and maintain the User Security in the BO 4.0 Server.
• Migrate the User Security and BO Objects to different BO Environments using Life Cycle Manager (Environments: Sandbox, Development, Test and Production).
• Configured the BO Explorer 4.0(BO Mobile) for IPAD/IPHONE Application.
• Set - up the connectivity from the BO Server to the Source Database (Teradata, MS SQL Server).
• Install the latest service pack and fix pack on BO 4.0 Server.
• Update the BOBJ Server(Services) Parameters for the server to improve the performance of the servers.
• Fixed the errors/issues in the BO 4.0 Server environment.
• Create Universe (.UNV & .UNX) using the Universe designer and Information Design Tool to migrate the existing Microstrategy Reports to Business Objects Interactive Analysis Reports.
• Understand the Microstrategy reports and implement the same in BO Interactive Analysis and Crystal Reports 2011.
• Created drill through Interactive Analysis reports using the Open Document functionality.
• Created Xcelsius Dashboards using the LIVE Office/QaaWS Connection with dynamic filters in the dashboard (Butter Fat Content, Coliforms, Psychotropes %age, Total Quality Scorecard).
• Drill down from Dashboards to reports using the Open Document functionality.
• Train the users and developers on Business Objects Tool.

Environment: Business Objects 4.0 (Universe Designer, Information Design Tool (UNX), Interactive Analysis, Life Cycle Manager, CMC), Crystal Reports, Crystal Dashboard Design (Xcelsius 2011), Teradata 13.0, MS SQL Server

Confidential, Bellevue, WA

Business Objects developer/designer/Analyst

Responsibilities:

• Assist in defining the scope of a project, or phase of a project, utilizing qualitative criteria, technical and business specifications
• Provide creative source of ideas/solutions to address problems to enhance individual, team and client knowledge of Business Intelligence projects
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes
• Formatted reports as per the user’s requirements using all the facilities in Business Objects, which allows the users to analyze the data
• Created various summary Reports for different clients to calculate profitability ratios etc based on Region and Time Dimensions.
• Implementing security for users, groups and categories using CMC in BO XI R2.
• Created user conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts)
• Created WEBI reports & Crystal Reports and deployed them through Info View
• Published reports using Info view, and trained users for ad hoc reporting
• Extensively used Calculations, Variables, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Planned, coordinated and executed Business Objects deployment for End-users and documented the entire project
• Created Drill-down Reports to provide users with more detailed information and query linking
• Created Advance analytics like Speedometers, Interactive Metric Trends to gauge the performance of the Key Businesses
• Conducted information gathering workshops, determining data model, reporting specifications.
• Created Key Business Metrics, using Dashboard Manager and Performance Manager.
• Created Daily, Weekly and Monthly goals and plugged them with Business Metrics.

Confidential, Madison, WI

Business Objects Consultant

Environment: Business Object 6.5, Oracle 8i/9i, PL/SQL.

Responsibilities:

• Created multiple universes to support the reporting needs of each department.
• Creating the Business Objects data model, Create connection, Identify Target tables, and joining tables, Detect cardinalities, created aliases to resolve the loops
• Created Contexts to resolve loop including multi-fact tables, resolved Ambiguous queries.
• Created Complex Variables, Pre-Defined Filters using @ Functions.
• Created Complex reports by fetching data from multiple sources and synchronizing them using common dimension object.
• Interacted with business users to identify the source systems and worked with data extraction team.
• Created aggregated tables to pull summarized data form universes, created objects using @ Aggregate aware and identified compatible objects.
• Created Dashboard universes with self-joins and used @ select and @where Functions exclusively.
• Identified measure objects for the Key Performance Indicators and Dimension objects for the slices.
• Created Connections for Universes and pushed the universes into Application Foundations after all the updated are complete.
• Created detailed reports for all the important reports, e.g.: Number of Accts Assigned for collection created detailed report with Customer’s contact information.
• Created Master - Detail report, Cross-tab report trending graphs using global filters and ranking.

Confidential, Atlanta, GA

Business Objects developer/designer

Responsibilities:

• Created, modified and maintained Business Objects universes and metadata using Designer
• Created goal based analytics
• Setup and maintained user security using Supervisor
• Created and maintained Business Objects reports in Web Intelligence Info View
• Implemented BO monitoring features and usage reports to understand user activity and system use
• Assisted with all systems integration issues that impact the Business Intelligence reporting infrastructure
• Tuned Universe by creating Joins, Contexts, and Aliases for resolving Loops and checked the Integrity of the Universes using Business Objects Designer
• Created reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports
• Used the BO Auditor to audit users and user activity

Confidential, San Jose, CA

Business objects Analyst / Developer

Responsibilities:

• Interacted with Business Users to know their Business views in developing and modifying Universes and Reports accordingly
• Involved in gathering, analyzing, and documenting business requirements and data specifications for Business Objects Universes and Reports.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked for the Integrity of the Universes.
• Provided support in resolving Fan Traps and Chasm Traps.
• Linked different Universes using Kernel Master and Component approaches.
• Used multiple data providers in the reporter module in generating reports.
• Extensively created and used alerter, rankings, sorts, and drill-down (using custom hierarchies) in reports
• Used Aggregate Awareness in universe to optimize query performance
• Exported the universes to the Repository to making resources available to the users.
• Assisted in creating aggregate BCA server and scheduled for daily refreshing
• Awarded as the most valued tables in-order to use in the Universes.
• Tested classes and objects to organize the universe.
• Linked universes in designers and Linked data sources in creating the reports
• Reports were published to a team player of the month
• Used CRM Applications for Improved Customer relations to keep track of individual preferences by maintining one to one records.

Confidential

Business objects Analyst / Developer

Environment: Business Objects 5.x (Reporter, Designer, Supervisor), Oracle, and SQL

Responsibilities:

• Created sophisticated Drill Reports and Slice and Dice reports
• Designed and developed tables in MS-Access Database
• Involved in requirement gathering, designing the database as per the requirement
• Involved in creating tables for storing information about employee, appraisal data, location data, salary data and other required data
• Designed and Created Universe based on report requirements
• Creating Complex Business Objects Reports for all daily, weekly and monthly production runs
• Extracted data from multiple sources like DB2, SQL server, Flat Files and Oracle