Over 9 years of total IT experience in the Analysis, Design, Development and Implementation of Relational Databases (OLTP) and Data Warehousing Systems (OLAP) using Business Objects suite, Business Intelligence BI/BW 7.0, BEx Queries, Crystal Reports, Informatica, BO Data Services, Teradata V12, Oracle, MS-SQL Server and IBM DB2 databases

EXECUTIVE SUMMARY

• Over 5 years of work experience using Business Objects BO XI 4.0/ XI 3.1/XI R2/6.5 Designer, CMC, Info view, Web-Intelligence, DESKI, Import Wizard, Publishing Wizard, Metadata Manager, Crystal Enterprise 2008/XIR2/10/9, XCelsius 2008, Live Office, QAAWS, Enterprise Dash Board Manager, Broadcast Agent and Supervisor
• Proficient in managing all phases of data ware house life cycle, including requirements gathering, analysis, preparing Business specifications, designing technical specifications, Software requirement specifications, designing and developing reports, performance tuning, testing, migrating to production and post production support
• In Depth understanding of Data Warehouse concepts, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, Physical & Logical Data Modeling, Fact & Dimension tables
• Strong experience in Design, Development, Deployment, and testing of Universes using Business Objects Designer against SAP BW and Relational databases (Oracle, MS SQL Server, DB2 sources)
• Good exposure and understanding on the new release BO XI 4.0. Knowledge and experience working on the new features and applications added in BO XI 4.0 IDT (Information Designer Tool), Workspaces, Data foundation, business layers and Query objects, Business Launch pad, Web Intelligence, Interactive analysis, Dashboard designer
• Good working knowledge on SAP BI/BW 7.0 with exposure on BEx queries, BEx Analyser, Info cubes
• Good understanding on the Business Objects XI3.1/XIR2/6.5 Enterprise Architecture (Central Management Server, Web component Adapter, I/O File repository server, Web Intelligence server, List of values server, Report Job server, Event server, Page/Processing server, Cache server and RAS (Report Application Server)
• In-depth knowledge in migration, working and implementation of Business Objects Enterprise Reports 6.5/ XI R2/ XI 3.1
• Experience in training the users on generation AdHoc reporting and the WebI tool navigation.
• Working knowledge of ETL tools like Informatica 9.1/8.5/7.1, BO Data Services XI 3.2, BODI 11.5
• Expertise in working on SQL with Databases like Oracle11g/10g/9i, MS SQL Server 2005, IBM DB2 V8 and Tera data V12
• Diversified experience in implementation of Business Objects, Crystal reports within Financial, Banking, Publishing and Media and Public sectors.
• Proven ability to work in cross-functional teams with high sense of ownership and strong customer focus
• Highly efficient and committed in demanding and rapidly changing environments
• Excellent communication, interpersonal, analytical skills and a good team player.
• Ability to effectively multitask, meet deadlines, quickly adapt to different project environments.

EDUCATION

Bachelors of Engineering

TECHNICAL SKILLS

BI Tools: Business Objects XI 4.0/3.1/R2/6.5, IDT, Universe Designer, Desktop Intelligence, BI Launch pad, Web Intelligence/Info view, Import Wizard, 
Publishing Wizard, CMC, Live Office, QaaWS, XCelsius 2008/4.5,  BEx Designer, BEx Analyzer, Info cubes, EPM Dash boards, Crystal Reports  2008/XI/10/9.0 
ETL Tools: Informatica 9.1/8.5/7.1, BO Data Services XI 4.0/3.2, BO Data Integrator 11.5
RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005, Tera data V12, IBM DB2 V8 Programming Languages: SQL, PL/SQL
Front End Tools: ERwin 4.1, TOAD and SQL Developer
Operating Systems: WIN XP/2003/2000, UNIX
ERP: SAP R3, SAP BW/BI 7.0

PROFESSIONAL EXPERIENCE

Confidential, Eagan, MN October 2011 – Present
Role: SAP Business Objects Developer, Decision Support, ONE VISION Project

Responsibilities:

• Responsible for designing and development of reports and dashboards from SAP BI/BW and the relational data sources from the warehouse
• Closely worked with the Business Analyst, BI lead and the architect in understanding the BRS and SRS documents based on the business requirements
• Performed the gap analysis to understand the feasibility in designing the dashboard layout per business requirement
• Worked on the ‘OTC’ Executive Dashboards design for the decision support for ‘One Vision Project’
• Identified the KPIs required in the Xcelsius dashboard. Extensively worked on the design layout of the DW status and Executive dashboards for the Load status information and the performance information of the Key metrics for the Executives
• Extensively worked on the development of the Executive dashboards layout using Xcelsius components
• Extracted the reports information for the KPIs by using the Live Office connections importing the data connecting to the underlined Web I and Crystal reports
• Worked closely with the team and evaluated the design strategy and layout for the executive dashboard in align with the ‘One vision’ GPO deployment
• Created the Underlined reports in Web I and crystal reports using the warehouse relational data and SAP tables as sources
• Worked on imposing dynamic display in the dashboard using the different Xcelsius components like Combo boxes, Scorecards for the Alerters (based on the threshold) and mapping these components to the data in the Live Office spread sheet
• Prepared the model sheet based on the dashboard layout design in the .xlf file of the dashboard using the Live Office spreadsheet.
• Mapped the report(s) data imported in the sheets to the Model sheet of the dashboard to display the KPI in the dashboard visualization dynamically for analysis and decision support
• Scheduled the underlined reports in CMC
• Exported the dashboard as a .swf file into the Business objects repository
• Applied different refresh options in the Live Office to have the data refreshed during the run time of the .swf file of the dashboard
• Prepared detailed documentations on the dashboards design and updated with the latest versions
• Trained the end users on the detailed design and analyzing the dashboard functionality
• Worked on planning, designing, developing, distributing and maintaining Universes with SAP BI/BW BEx queries as a data source
• Used Query Designer, BEx Analyzer and Business Objects InfoView, Crystal Reports for reporting.
• Using BW query builder designed and formatted Crystal Reports based on SAP Business Information warehouse
• Developed OLAP Universes on top of SAP BI Info cubes/BEx Queries and created WEBI reports
• Worked on SAP BW 7.0 analyzing the existing BW modeling, created BEx reports on top of info cubes
• Created Queries, and Reports using SAP BEx Query Designer, BEx Report Designer, BEx Analyzer (Business Explorer analyzer)
• Closely worked with the ETL team on the required transformations and scheduled jobs in Informatica design process.
• Created medium universes using the IDT (Information Designer Tool) in SAP BO XI 4.0 from the relational data sources for work flow reporting
• Created connections and extracted tables from OLAP sources, performed joins to build a relational schema (data foundation)
• Good understanding of creating local, shared projects in Universe design and synchronizing them
• Good exposure on the single and multi source enabled data foundations
• Created metadata objects from the Info cubes and data foundation
• Published the Universe the repository and deployed for the SAP BO reporting and data analysis
• Followed the Universe design best practices while implementing the business requirements
• Extensively worked on the different locales in the Web I Interactive analysis
• Worked on the development of workflow reports using Web I reports in XI 4.0
• Good understanding on the new dashboard Design tool and all the new features added in BO XI 4.0 including the new naming terminology

Environment: SAP BI/BW 7.0, BEx Query, Info cubes, Business Objects XI 4.0/3.1, IDT, Universe designer, Business intelligence Launch pad, Web I, Info View, CMC, Informatica 9.1, SQL Developer, Crystal 2008, Xcelsius 2008, Oracle 10g R2, Windows XP

Confidential, Minneapolis, MN April 2011 – September 2011 
Role: Business Objects Consultant, Internal Data warehouse reporting and Migration project

Responsibilities:

• Responsible for designing and development of Universes from relational database sources
• Interacted with Business users, Business Analyst, gathered business requirements, and presented the proof of concept
• Performing requirements analysis, design, and technical delivery of critical business reports for decision support in the data warehouse sitting on top of Oracle data base
• Designed and built Universes using Designer, created and modified Web I, Crystal reports from the underlying Oracle and SQL server databases for different business modules
• Designed the logical semantic layer using the Universe designer tool by defining joins, cardinalities between tables and applying contexts and aliases to remove cyclic dependencies (Loops/traps)
• Resolved complex loop issues by creating multiple contexts and aliases to remove cyclic dependencies in the universes
• Applied Row level securities using security restrictions option in the Universe. Created the Object level security in the CMC
• Handled Embedded BO Functions like @Prompt, @Select, @ Variable, @Where, @Aggregate awareness in the designer to handle user requests for report generators. Set up Aggregate tables to enhance the SQL performance
• Analyzed all tables and created various indexes to enhance query performance working with DBAs
• Worked on custom hierarchies in the universe level to enable scope of analysis and various drill options during reporting
• Worked on universe level filters to restrict the data at Universe level. Applied filters on the objects. Created derived objects in the universe
• Created Derived tables for improving performance and used short cut joins to resolve join problems
• Worked on editing the List of Values (LOVS) to create dynamic and cascading prompts
• Worked extensively on the Web I functions like multiple queries, combined queries, report and block filters, and various reporting cosmetic options like section, breaks, ranking, sorting and formatting options
• Created Linked, Unlinked, Parameterized and On-demand sub reports in crystal designer for various business needs, scheduled reports for different file based / schedule based events, distributed in email, PDF and HTML format
• Created complex Cross Tab, Master Detail reports with Slice and Dice, Drill Down functionalities using WebI
• Designed reports that include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts
• Developed different types of standard reports with drilling capabilities in tables, cross-tab and charts with complex calculations, Variables, Breaks, Sorting, and Alerters
• Generated WebI reports involving complex queries, sub queries, Unions and Intersection
• Customized the reports with graphical representation using line and bar charts as per end user requirement
• Created Periodic reports: daily report, weekly, monthly and annual reports, till and employee reports
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports
• Demonstrated the business users the Web I reports and CMC (admin) functionality in detail

Environment: Business Objects Enterprise XIR3.1, Universe Designer, Web Intelligence, Import Wizard, Info view, Crystal Reports 2008, Windows 2003, Oracle 10g r2, MS SQL Server 2005

Confidential, Texas State CPA, Austin, TX September 2010– March 2011 Role: SAP Business Objects Consultant, SECO Project

Responsibilities:

• Worked with Business Analyst, Business Users and Managers for gathering, analyzing, documenting Business Requirements, Functional Requirements and technical Specifications for Business Objects universes and reports
• Prepared the (BRS) Business requirement specifications and functional requirement documents (FRD)
• Worked on planning, designing, developing, distributing and maintaining Universes with SAP BI/BW and relational databases (IBM DB2) as the data sources
• Used BO Universe Designer for semantic layer, Business Objects Info View, Web I and Crystal Reports for reporting
• Designed the universes on top of IBM DB2 databases from scratch and exported them to the repository
• Designed, developed and maintained universes for supporting ad-hoc and canned reports
• Defined cardinalities, created joins, performed check integrity, resolved loops by creating aliases and contexts to remove the cyclic dependencies
• Created cascading List of Values (LOVs) for better understanding of prompts by the end users
• Created complex reports using cascading prompts to restrict data fetch and ease data load
• Created filter objects, formatted objects and measures within the universe for faster report generation
• Created different types of reports, like Tabular, Master/Detail, cross Tab using multiple queries
• Used filters, conditions, Prompts, Drill Down, @Functions, etc
• Extensively used breaks for white spaces and sections for better navigation
• Created Web I Reports using Drill down functionality creating custom hierarchies
• Used Filters and Conditions to achieve report functionality
• Worked on creating reports using the dimensions, measures filter options and KPIs
• Created detail and summary reports to fold/Unfold sections corresponding to breaks in current blocks
• Extensively used Web Intelligence Info view for querying, reporting and analysis tasks
• Created reports like Quarterly reports, Demographic reports and Metric exception Reports
• Created complex Web I reports by linking objects from different data providers and using Merge Dimension Option
• Created Web I Reports using Drill down functionality within different hierarchies
• Worked extensively with the Performance Management tool involving the creation of dashboards
• Designed and formatted crystal reports that have SAP BW as data sources using BW query driver.
• Worked on BEx Query designer defining custom queries by selecting measures, characteristics from the key figures and dimensions lists and dragging them to the columns area.
• Created Crystal and WebI reports using the SAP BW query designed using BEx query designer as source data.
• Designed and formatted crystal reports that have SAP BW as data sources using BW query driver
• Worked on BEx Query designer defining custom queries by selecting measures, characteristics from the key figures and dimensions lists and dragging them to the columns area
• Created Crystal and WebI reports using the SAP BW query designed using BEx query designer as source data
• Created various Dashboards using ISAS, GSMS data like SECO Stimulus Contract details, Sub recipient Details, Vendors, Invoices, Voucher Details, Payments details for different vendors
• Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes
• Migrated the universes from DEV to Acceptance and PROD Environments
• Trained the users on the Ad Hoc reporting and on navigating the Business Objects tool

Environment: Business Objects Enterprise XI 3.1, Designer, Web I, Info View, XCelsius 2008, Dashboard Manager, Import Wizard, SAP BI/BW 7.0, BEx Designer, Business Objects Data Services XI 3.2, IBM DB2 V8, Windows XP/2003

Confidential, Columbus, OH March 2009 – August 2010
Role: SAP Business Objects Developer, SAN Project

Responsibilities:

• Performed an Initial Study of the current reporting application, to finalize the data elements required for reporting
• Responsible for analyzing business requirements and developing queries and reports using Business Objects
• Installed and configured Business Objects Enterprise XI 3.1 on the Windows 2003 Server
• Worked on designing Universes and Building of classes and objects
• Resolved loops and traps using Contexts and Aliases while designing Universes
• Proposed to set up Universe level conditions to restrict data based on report requirements
• Worked in development of reports using WEBI to cater Ad-hoc reporting needs
• Created reports using Business Objects functionality’s like prompts, filters, using slice and dice, Drill options, Cross Tabs, breaks, sections/Master Detail and Formulae
• Created Web I Reports using Drill functionality creating custom hierarchies and defining scope of analysis
• Created Complex Web I reports using Open Document functionality to link the different data in the reports
• Migrated reports from Development/Testing environment to Production Environment
• Used report filters, block filters and Conditions to achieve report functionality
• Created Dashboards and Score cards to provide the users with business information using Performance Manager
• Experience working with Xcelsius to display summary-level business data in a rich and interactive format using graphs and different components in Crystal Xcelsius 2008
• Involved in using Xcelsius to transform Microsoft Excel spreadsheet data into interactive flash media files for the Executives
• Connected to the Web I reports and crystal reports using Live Office and imported the data into Live Office spread sheet
• Using Query as a Web Service Wizard (QaaWS) queried directly the Universe Objects, applied prompts for restricting data at the dashboard level
• Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes

Environment: Business Objects Enterprise XI 3.1, XCelsius 2008, Designer, Dashboard Manager, Infoview, Web Intelligence, Import Wizard, Qaaws, Xcelsius 2008, Metadata Manager, Informatica 8.5, Windows 2003, MS-SQL Server 2005, Oracle 10g

Confidential April 2005 – December 2008 Role: Business Objects Developer, Retail Assets Division

Responsibilities:

• Working closely with the Business Analyst to understand the Ad hoc and standard reporting requirements.
• Analyzing the existing Logical Data Model of the warehouse.
• Facilitated meetings across Departments for implementing a standard architecture for deploying Business Objects across the entire Organization.
• Facilitated with tech support to formulate a strategy for implementing good user support.
• Actively involved in gathering server sizing requirements for software/hardware.
• Implemented Best Practices for using Business Objects suite of products.
• Responsible for Creation of the Universe with Classes, Objects and Condition objects.
• Designed Business Objects Universes for star schema & snow flake schema data models.
• Developed Hierarchies to support drill down reports in Desktop Intelligence tool.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Written PL/SQL stored procedures, functions, database triggers & Packages.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Designed Test cases for UAT of Reports for end users.
• Performed tuning of SQL queries for better performance.
• Scheduled reports to run and refresh daily using Broadcast Agent Server.

Environment: Business Objects Enterprise 6.5, DESK sI, Supervisor, sInformatica 7.1, Oracle 9i, Windows 2000.