SUMMARY

• Over eight years of experience with an emphasis ondata warehousing, BI, BW, Mobile BI, OLAP, ETL, SAP Business Objects universe design and reporting module.
• Over eight years of experience using business intelligence tools, Business Objects (BOBJ)Tools in various versions - BI4(BOBJ 4)BO XI 3.1/R2/R1/ 6.5.1/ 5.1, SAP BW on Windows and UNIX environments.
• Three years of experience in analysis, design and development of various data warehousing projects using SAP Business Objects data services 4.0/XI3.2/3.1, and data integrator XIR 2/11.7/11.5.
• Worked on various development platforms like Windows NT 4.0/2000/2003 Server/ XP/98/95, UNIX andRDBMS like Oracle, SQL Server, Informix, MS Access, Teradata, Netezza, DB2 UDB and Sybase.
• Extensive experience and solid understanding ofdata warehousing, data marts,star,snow flake schemamodeling,dimensional modeling,entity-relationship modeling,OLTPandOLAP concepts.
• Proficient in utilizing the crystal reports and Xcelsius 2008 Query as a Web service.
• Proficient in creating reports using business objects functionalities such as queries, master/detail and formula, slice and dice, drilling, cross tab and charts.
• Work experience in advanced Xcelsius concepts like, what if analysis, dynamic visibility, narratives, interactive charts, hierarchies and experience in connecting Xcelsius/ QaaWS, live office.
• Experienced in developing complex reports using business objectsWebi Rich ClientandCrystal reports enterprisehaving parameter/formula fields and selection formulas, grouping and sub reports.
• Proficient in designing and building universes by selecting and joining tables, setting cardinalities and resolving loops by using aliases and contexts and checking integrity of universes.
• Extensive experience in Oracle development using dynamic SQL, PL/SQL, Views, Indexes, Triggers, Stored Procedures, Nested Tables and Oracle Objects etc.
• Extensively involved in managing repositories, connections, creating and managing users/groups, assigning resources to users and importing/exporting users.

TECHNICAL SKILLS

Business Intelligence: Business Objects 4.1/4.0/3.1/3.0/ XI R1/R2/6.5.1/6.1b/5.0x - Central Management Console, Central Configuration Manager, Platform InfoView, Web / Desktop / OLAP Intelligence, SDK,Data Integrator, Set Analysis, Designer, Supervisor, Administrator, Application Foundation, Enterprise Performance / Information Manager, Dashboard Manager, ScoreCards.

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.5/8.1/7.1/6.2/5.1 , Informatica Developer 9.x/8.x, Power Exchange 9.1, 8.6.1, 8.1., Informatica Data Analyzer, Power Analyzer, MQ Series, SQL*Loader, SQL Server DTS Package, Power Exchange (Power Connect), Metadata Manager, Informatica Data Quality, Informatica Data Explorer, SSIS, Data stage, Abinitio etc.

Reporting & Analysis Tools: Crystal Reports XI/10/9/8/7/6, Crystal Enterprise XI/10/9/8, Crystal Reports 2008,Business Objects XI, Crystal Management Console, Crystal Migration Wizard, Crystal Import Wizard, BO Web intelligence, BO Dashboard Builder, Xcelsius 2008

RDBMS: Oracle 11g/10g/9i/8i, MS Access 2003, SQL Server 2000/2005.

Data Modeling Tools: Erwin r7.1/7.2, ER Studio V8.0.1 and Oracle Designer

ETL Tools: Informatica Power Center 9.x/8.x

Programming Languages: SQL, PL/SQL, T-SQL, C, C++, .Net, HTML, XML.

Application Server: Tomcat 4.1

GUI: Visual Basic 6.0, Visual C ++ 6.0

Operating Systems: WINDOWS XP/NT/00/98/95, UNIX

Web Server: Apache 2.0, IIS 6.0

Others: TOAD, SOAP, SQL NavigatorTeradata SQL Assistant, SQL Loader

PROFESSIONAL EXPERIENCE

Business Objects Developer

Confidential, Des Moines, IA

Responsibilities:

• Analyzed the business requirements and created business requirements document and Mockup reports using Microsoft excel.
• Involved and analyzed creation of SAP BOBJ 4.0/XI 3.1 Web Intelligence Reports with different functionalities like cascading prompts, drill down, linking reports, charts and graphs, ranking, scope of analysis and alerts.
• Created complex reports in Web Intelligence using advanced functionalities like report level prompts, scope of analysis and ranking.
• Created various graphs using various chart functionalities.
• Defined row level security at universe level as per user entitlements, enabling IT to create one report and make it available to global users based on their rights.
• Created the universe using the information design tool.
• Improved the performance and reduced the coding with the use of (@functions (@aggregate aware, @select, @prompt and @where).
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and use case modeling.
• 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.
• Defined alias and contexts to resolve loops and also tested them to ensure that correct results were 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.
• Exported the universe to the repository to make resources available to the users.

Environment: Business Objects 4.1, Teradata 13.10, Teradata SQL Assistant.

Business Intelligence Analyst

Confidential, Topeka, KS

Responsibilities:

• Involved majorly in financial analysis for KPI and KDP report which is done on a weekly and monthly basis.
• Played a key role in reporting decisions for various key executive reports.
• Designed executive dashboards for various trends for productions figures across various channels.
• Migrated BO from XI3.1 to BO 4.0 installed and configured BODS XI 4.0 SP1 in development and production server.
• Involved in dashboard design for various reporting strategies across different sales units.
• Designed and developed reports for financial analysis and pending analysis at the regional level of the organization.
• Created the reports using the universe as the main data provider and writing the complex queries including sub-queries, unions, and intersects.
• Analyzed the business requirements in using the pivot table, vlookup and hookup functions in excel.
• Worked on cross-tab and master detail reports. Also represented the same as line charts/ bar charts / pie charts of the same.
• Created document on usage of info view for offsite users with no full-client business objects installed on their machines.
• Developed executive dash boards in Infoview and SAP BO Xcelsius 2008.
• Extensively used new features of business objects 4.0 in creating universe using multiple data providers.
• Defined aliases and contexts to resolve loops in the universes.
• Created user conditions and Filters to improve report generation and readability of report and displayed the summary of data by creating charts.
• Designed and developed ETL routines in BODS, modified or created new data services jobs to meet project requirements.
• Created connections with different databases like DB2, SQL server and Teradata
• Extensively worked on the central management console in version 4.0.
• Involved in training portal administrators about XCelsius Model and how to configure XCelsius with different methods to connect to universe (Using Live Office, QAAWS).
• Created customer fact sheet dashboard for business needs and automated the dashboard using live office.

Environment: SAP BO Data Services 4.0/BO 4.0/XI3.2/3.1/3.0 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator XIR2/11.7/11.5,Business Objects 4.0/XI 3.1(Designer, WEBI),WEBI Rich Client, DB2 LUW, Teradata 13.10, Teradata SQL Assistant, Oracle 11g, TOAD, MS Excel 2007.

BO Developer

Confidential, Atlanta, GA

Responsibilities:

• Build business objects universes and wrote reports.
• Documented user requirements, translated functional requirements into technical requirements and developed implementation plan and schedules.
• Developed report mock-up samples before user interaction to analyze the business requirements.
• Worked with the team closely with functional architect, DBA and analysts to get a clear understanding on the by Torntv V9.0">application.
• Tuned and enhanced universes with SQL queries for the report performance.
• Streamlined SQL generation from Universes by implementing Aggregate Aware functions and @Variables.
• Created complex reports by using multiple data providers to combine three reports as a single report in Deski, WebI.
• Responsible for creating the Deski and Webi reports (On demand, Audit Reports, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab and graphical, etc.).
• Created Webi reports using all the BO functions like Drill Down, Prompts, Dimensional and measured variables to show accurate results.
• Developed dashboards using Crystal-Xcelsius with data source as Live Office.
• Migrated BO from XI3.2 to BO 4.0 installed and configured BODS XI 4.0 SP1 in development and production server.
• Troubleshooting and rectifying Universe, Webi Rich Client and live office errors.

Environment: Business objects 4.0, Crystal Reports 2011, Webi Rich Client, Deski, Business Objects XIR3, SSRS, DB2 LUW, SQL Server 2005/2008, Oracle 11g, Facets4.81, Facets interfaces (IFOX), Facets extensions.

Business Objects Developer

Confidential, Des Moines, IA

Responsibilities:

• Participated in gathering functional requirements and data specifications for business objects universes.
• Responsible for creating reports for data services group using business objects WebI and Crystal Reports.
• Worked with multiple data providers in a report and added slice and dice capabilities.
• Use of designer module to implement universe, Joining the Tables, create prompts and queries, Parsing the Objects, applied contexts and alias tables to remove cyclic dependencies.
• Dealt with multiple star schemas within one universe design experience with advanced functions in designer (customizing LOV's, creating contexts and predefined filters) Experienced in interpreting data models
• Maintained the repository (i.e., security, universe and document domains).
• Generated the business objects reports using the universe as the main data providers and wrote the complex queries including sub queries, unions, intersect and aliases.
• Linked different universes, which are from multidimensional data sources.
• Created conditional objects and used universe level security restrictions.
• Created the reports from various universes using business objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulas etc.

Environment: Business Objects XI R3 (Designer, WEBI), Live Office, Crystal Reports XI, Crystal Xcelsius 2008, Oracle 9i, DB2 LUW and Windows XP

Reports Developer

Confidential, Chicago, IL

Responsibilities:

• Interacting with business users and business analysts to understand and document the requirements and built universes for end user reports generation using business object XIR3.1 designer.
• Designed the management universe by objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and created the objects, which are grouped into classes for convenience and business intelligence reporting.
• Created derived tables at the universe level to match the business requirements.
• Worked extensively on custom LOV’s in defining and maintaining them over the business objects universe.
• Worked extensively with the major functionality of business objects like Breaks, Alerter, Filters, Sorts, Query Prompts and Drill filters.
• Used the Slice and Dice feature, set variables, alerts and group values in the reports.
• Created, managed and formatted standard reports, master/detail reports and cross tab reports using report manager.
• Used SQL loader to load flat files into oracle database and used PL/SQL Stored Procedures and Functions to a format data for the end-user report requirements.
• Created complex reports and exported them to the corporate repository.

Environment: Business Objects XI 3.1 (Designer, Desktop Intelligence, Web Intelligence, Webi Rich Client, Central Management Server, Central Management Console, CCM) Crystal Reports 2008, Crystal Xcelsius 2008, Live Office, SQL Server 2005, DB2 LUWand Oracle 10g.

Server Analyst/Programmer

Confidential, Rochester, MN

Responsibilities:

• Acted as a liaison between client area and technical organization by planning, conducting, and directing the analysis of complex business problems to be solved with automated systems.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that are effective and meet business requirements.
• Developed complex reports that involved multiple data providers, master/detail charts, cross tab charts, complex variables and calculation contexts.
• Worked on developing database objects when required such as Stored Procedures, Views, Packages, and Functions.
• Used various Xcelsius components like Charts, Maps, Single Value and Selectors.
• Used dashboard manager to build dashboards and deploy them across the organization to monitor business performance
• Checked the integrity of the universes and exported the universes to repository making it available to users.
• Converted Deski reports to Webi using report conversion tools for enhancements.
• Used the Slice and Dice feature, set variables, alerts and group values in the reports.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: Business Object XI R3, Web Intelligence (WEB I), Webi Rich Client, Deski,Info View, Import Wizard, Report Migration Tool,UML, MS Visio, MS Office, MS Project, Crystal Xcelsius 2008, Xcelsius Designer, Live Office, Sql Server 2005/2008, DB2 LUW, Crystal reports XI.

Data/Report Analyst

Confidential, Atlanta, GA

Responsibilities:

• Gathered, analyzed and documented business requirements, clarified business rules and data design requirements, functional requirements and data specifications for business objects universes and reports.
• Interacted with business users, business owners to know their business views in developing and modifying universes.
• Created hierarchies, complex objects using various @functions and aggregate aware objects, derived tables in the universe.
• Worked extensively on different data providers like flat files, excel files and free hand SQL for the creation of documents.
• Built complex reports in Web Intelligence by using combined queries (union and intersection), nested queries.
• Responsible for setting up the users/groups, database connections and assigning privileges to the users.
• Created parameterized crystal reports using charts, cross-tab reports, sub-reports and running totals.
• Implemented drill hierarchies on Web Intelligence by making hierarchies containing dimensions in universe design.

Environment: Business Object XI R2, Data Integrator XI R2, Erwin, Crystal reports XI, Web Intelligence (WEB I), Info View, Import Wizard, Report Migration Tool,UML, RUP, Requisite Pro, MS Visio, MS Office, MS Project, Crystal Xcelsius, Xcelsius Designer, Live Office, Oracle 10g, TOAD, SQL server 2000/2005, DB2 LUW, Windows 2003.

Oracle/Crystal Reports Developer

Confidential

Responsibilities:

• Installation and configuration of Crystal Reports 8.0.
• Created Tables, Views, Stored Procedures, and Queries to meet the reporting needs by using SQL server 7.0, SQL Server 6.5, and MS Access.
• Developed various Drill-Down, cross tab and grouping reports using crystal reports depending on business requirement.
• Involved in creating various PL/SQL Stored Procedures, Views, Functions and temporary tables for data input to the crystal reports.
• Exported reports into various formats like EXCEL, PDF, HTML and WORD for the user.
• Developed various charts and graphs like Bar chart, Line graphs, pie -charts etc by using chart expert of crystal reports.

Environment: Crystal Reports 8.0, Crystal Management Console, Broadcast Agent 2.7, SQL Server 7.0, SQL Server 6.5, and MS Access.