SUMMARY:

• Around 9 plus years of IT Experience with strong emphasis in Business Intelligence (BI) and Data Warehousing (DW) in the role of BOBJ developer, designer and SME.
• Worked in implementing different kinds of reports using SAP Business Objects 4.2/4.1/XI R3.1/R2 - CMC, BI Launch Pad, Info View, Import Wizard, Universe Designer, Web Intelligence (WebI), Crystal Reports, Design Studio, Lumira, Dashboards (Xcelsius), Business View Manager, Business Explorer (Bex).
• Extensive experience in developing Universes, Reports (Full client/Thin client/Rich Client) and Corporate Dashboards from various sources like Microsoft SQL Server, Oracle, Netezza and Teradata.
• Worked on creating OLAP universe in IDT and UDT using BEX queries, Multi-Providers, Info cubes and HANA Models in SAP BO integrated environment for reporting application.
• Over 2 years of experience in integration of SAP BI and BOBJ and migration of BEx reports to BOBJ.
• Experience using BEx Designer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries.
• Experience in migrating / updating BO objects from XI 3.1 to BO 4.1 SP3.
• Expertise in working with BO 4.1 Design Studio 1.5/ 1.6 and Lumira 1.3.
• Very Strong understanding of Data warehousing concepts such as Star Schema, Snowflake Schemas and Multi-Dim Models.
• Experience with ETL tools like Informatica, BODS, SSIS etc

PROFESSIONAL EXPERIENCE:

Confidential, STUART, FL

SAP BO Developer

Responsibilities:

• Involved in migration of around 70 DESKI reports (BO 3.1) to BO 4.1 using Report Conversion tool (RCT).
• Identified and resolved issues promptly that resulted during the migration of the reports using RCT.
• Developed new reports from scratch that is required for some of the Macro based DESKI reports.
• Converted about 40 Informatter reports to SAP BO 4.1 reports from scratch.
• Tested and validated the converted reports.
• Published and scheduled the reports to production if needed.
• Analysed and resolved the production issues that are raised by the business users when needed.

Environment: Deski 3.1, Web Intelligence 4.1, Informatter, Oracle etc.

Confidential, SAN FRANCISCO, CA

Senior BI Consultant

Responsibilities:

• Major responsibilities include working closely with the System analysts to understand the requirements, getting the sign off from the IT PM, Business PM, System Analysts for implementing the report, maintaining of WebI Reports, proper documentation of the reports for future reference.
• Involved in working across cross functional IT teams to understand the business requirements and recommend solutions.
• Involved extensively in defining flexible queries using filters, Variables, Exceptions, Restricted key figure and calculated key figure in Bex Analyzer.
• Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way to give detailed levels of information, required in areas of SD . Worked on Currency conversion as per user requirements.
• Generated reports based on reporting requirements on purchase order summary, purchase order details, sales order summary, sales order details, invoice details and BPS report.
• Developed flexible queries using filters, navigational attributes in BEX Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Developed RRI reports, generated drill down reports using BEx Analyzer and customized reports for web reporting.

Environment: Crystal Reports for Enterprise, Oracle 11G, SVN Tortoise, Service Now, Jira, SQL Developer tool, Web Intelligence, UDT etc.

Confidential, LONG BEACH, CA

Senior BI Developer

Responsibilities:

• Designed Business Layer/ Sementic Layers using Business Objects 4.2
• Worked with SQL joins, cardinalities,Families, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies .
• Validated the report data by comparing with the facets data while testing the validity of the reports.
• Designing " Multi resource Enabled Universes in Information Design Tool " using SAP HANA as one of the source .
• Used Information Design Tool for creation of Universe for HANA reporting.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Created design studio dashboards for healthcare using crosstabs, scaling factors in infocharts,cascading filters for universe, Filter Bar, Progress Bar using SAP HANA.
• Experience working on SAP BW BEx Query Designer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae et c. to develop the Webi reports.

Environment: XIR4.2 (CMC, SIA, CMS, Designer, DESKI), Intelligence, SAP HANA, Design Studio 1.6, Info View, Toad 9.0, Import Wizard, Conversion Tool, Oracle 8i/9i/10g, Netezza, MS Access, DB2, NZ etc

Confidential, DODGEVILLE, WI

SAP BI Consultant

Responsibilities:

• Designed Universe using Business Objects 4.1 as per the requirement.
• Designed front-end reports using BEx Analyzer, used Restricted and Calculated Key Figures, Variables, Exceptions, and Conditions.
• Developed various Dashboards using objects/functionalities such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab, filter across data sources, highlight data in context etc. using Tableau 9.
• Worked on transforms, Jobs, Workflows, Data flows, scripts etc in Data Service to extract, cleanse and load into target Data Base.
• Created Universe and Web Intelligence reports using BEx queries.
• Created few Lumira visulalizations for the business users.
• Involved in coordinating with the offshore team to get the updates from them and resolve any issues/concerns accordingly.

Environment: Business Objects XIR2/XIR4.2, Web Intelligence 4.1, Tableau deski 9.0, SAP BW, SAP BEx Etc

Confidential, LAS VEGAS, NEVADA

BI Consultant

Responsibilities:

• Understand the datasources, tables, views, filters, conditions and logic that are used in Web Focus reports and Cyrstal reports for 2011.
• Designed Business Layer/ Sementic Layers using Business Objects 4.0/4.1 namely School Data and HR Business layers as per the requirement.
• Controlling Reports data by working with Business layers. Using Filters, Sorts and Rankings.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Designed and developed cross tab reports, reports with sub-reports (linked and unlinked) and chart reports.
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• Implement new reports for the business users involving complex calculations, Sections, Breaks, Conditional formatting for both the webi and crystal reports for enterprise.
• Testing the reports after moving to QA for each and every object, conditions, Breaks and sections to comply with the old reports.
• Involved in performance tuning of the webi reports and crystal reports to improve the performance of the reports.
• Involved in formatting sections, tables, inserting and organizing multiple breaks.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors etc.
• Had interaction with users and held meetings to understand the issues and resolving them accordingly.

Environment: Business Objects 4.0/4.1 (CMS, Designer, Rich Client), Web Intelligence, Crystal reports for 2011, CR for enterprise, BI Launch Pad, Info View, Oracle, SQL Server, MS Access, Microsoft SQL Server 2000/2005 etc.

Confidential, Miami, FL

SAP BO Developer

Responsibilities:

• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Enhanced several standard reports like Overall Budget: Assigned Funds in the Commitment Budget, Annual Budget (Periodic Representation) Commitments and Actuals as per client requirement in Funds Management using SAP BEx Query Designer .
• Developed reports on InfoCubes/multiproviders using BEx Analyzer/Explorer (RRMX) to facilitate summarization of data.
• Created and maintained roles for reports using PFCG. Developed Report-report interfaces (RRI), filtering, conditions, exceptions, variables, currency conversions, drilling, and navigational attributes.
• Extensively worked on Classes, Objects Loops, F an Traps, Chasm Traps, Cardinalities, Contexts, Aliases, Derived Tables, Hierarchy, Conditions, Drilling functionalities, Sectioning, Ranking, Filtering, Queries, Slice and Dice, Drill down, Prompts, Functions, Formulae, Complex filters, Alerter, Merge Dimensions, User Defined Objects (UDO), multiple Data Providers, Ranking, Local Variables, @Functions, @Select, @Prompt and @Where.
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by the end users.
• Developed flexible queries using Filters, Variables, Exceptions, Conditions, restricted key figures and calculated key figures to facilitate data analysis in a drill down or summarized way to give detailed levels of information using Bex analyzer.
• Worked with Developers for performance tuning of the queries to improve user experience.
• Created reports using Web Intelligence, published and maintained critical business documents.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development .
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps charts using functionality.

Environment: Business Objects 4.0 (CMC, CMS, Designer, Rich Client), Web Intelligence, Desktop Intelligence, Info View, Nettezza, Tableau, SQL Server, MS Access, Microsoft SQL Server 2000/2005 etc.

Confidential, La Palma, CA

Business Objects developer.

Responsibilities:

• Used DI objects like transforms, scripts, Data flows, Work flows in initial load and delta load mappings.
• Used Merge, Merge Join, Union All, Derived Column, Audit etc for transformations & to add columns with lineage metadata and other operational audit data.
• Created OLAP universes on Info cubes, Multi Providers and BEx Queries using Universe Designer.
• Used Bex Queries to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures.
• Responsible for creating crystal reports using Crystal Reports 4.0 version using Teradata.
• Set filters, suppression formulae and used highlighting expert to show the data the users would like to see in a more concise and presentable format.
• Created various report formats such as Sub Reports, Cross Tab Reports, Standard Reports, OLAP Reports, and Master Detail Reports .
• Created Contexts and aliases for resolving Loops in the Universes .
• Analyzed Data using Slice and Dice and Drill Mode, etc. and Formatting Reports
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc
• Controlling Reports data by working with Universe and queries. Using Filters, Sorts and Rankings.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Used custom LOV files from personal files and applied conditions of LOV files.
• Generated multiple hyperlinked reports with complex cross-tab reports with multiple queries, conditions, global filters and multiple data providers.

Environment: Business Objects XIR2/XIR3.1,4.0 (CMC, SIA, CMS, Designer, DESKI, Web Intelligence, Desktop Intelligence, Info View, Teradata SQL Assistant, Crystal Reports 2011 Oracle 8i/9i/10g, SQL Server, MS Access, Oracle, SAP BW (OLAP/MOLAP), Microsoft SQL Server 2000/2005, Windows 2000/XP Server.

Confidential, Louisville, KY

Sr. Business Objects Report Develope r

Responsibilities:

• Interacted with Business Users, Business Owners and Database teams on Business Requirements.
• Interacted with Business Users to understand and document the requirements and translate these to Technical Specifications for Universes and Business Object Reports.
• Worked with Business team on the new change requests, fixing defects in Business Objects reports and enhancements after migration.
• Interacted with the Business Analyst and the end users in taking requirements for building the universes from the Financial data marts.
• Creation of Universes right from the scratch with underlying Data marts, which are from different Databases.
• Created 5 Complex Universes which involved user defined objects which included complex Financial Calculations.
• Developed Extensive WebI Reports using Nettezza as the backend databases.
• Extensively worked on Classes, Objects Loops, F an Traps, Chasm Traps, Cardinalities, Contexts, Aliases, Derived Tables, Hierarchy, Conditions, Drilling functionalities, Sectioning, Ranking, Filtering, Queries, Slice and Dice, Drill down, Prompts, Functions, Formulae, Complex filters, Alerter, Merge Dimensions, User Defined Objects (UDO), multiple Data Providers, Ranking, Local Variables, LOV’s, @Functions, @Select, @Prompt and @Where..
• Created queries to extract data from database for multi-dimensional analysis using Slice & Dice, Master Detail and Drill up/down/by/through functionality.
• Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports.
• Involved in formatting sections, tables, inserting and organizing multiple breaks.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors etc.

Environment: Business Objects XIR2/XIR3.1 (CMC, CMS, Designer, DESKI), QlickView 9, Web Intelligence, Desktop Intelligence, Info View, Toad 9.0, Import Wizard, Crystal Reports 2008, Oracle 8i/9i/10g, Netezza, SQL Server, (OLAP/MOLAP) etc

Confidential, WI

Business Objects Report Developer

Responsibilities:

• Analyzed Business Objects Old Universes and Reports. Developed and designed Business objects reports using Designer and Reporter XI R2 Version.
• Analyzed different data connectivity's that can be used in connection to BOBJ Enterprise like QAAWS, Live Office, BI Web Services, and BEx Queries/Business Intelligence Connection Services and presented the Mockups explaining the Pros and Cons each data connectivity has.
• Created Dashboards Converting Business Data requirements into conceptual and logical data model.
• Developed dashboards capable of drill downs exposing different levels of data.
• Implemented Dashboards that allow executives to analyze Purchase Orders which were complete within budget and time limits.
• Designed / developed reports from variety of different data sources with a number of formats including PDF, spreadsheet, or graphic using Crystal Report XI.
• Developed and implemented Universes by defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business Objects Designer.
• Created Hierarchies at various levels for drill down reports and Customized LOV’s in Universe using designer.
• Worked with Data services to move data from legacy systems and enforce quality and reduce redundancy.
• Implemented Aggregate Awareness for summary data with optimal query execution.
• Worked on cross-tab and master detail reports. Created Crystal reports using the Universes as the main Data Providers.

Environment: Business Objects XI R2, Web-Intelligence, Xcelsius 2008 SP3, Desktop Intelligence, CMC, Designer, Toad, Oracle10g, SQL, PL/SQL, Teradata, Windows 2000 and Windows XP, Crystal Reports 10, BMC Analytics, Data services etc

Confidential, Redmond, WA

BI Report Developer

Responsibilities:

• Designed and Built Universes using Designer by defining joins, cardinalities between tables and applying contexts and aliases to remove cyclic dependencies.
• Existing SQL Server Reporting Services reports rewritten to Business Objects for communication with Netezza database.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance.
• Applied mandatory Universe and Class filters to restrict the data.
• Created new universes and also modified the existing universes by adding new tables and objects based on the new report requirements
• Applied Object level and Row level securities in designer using security restrictions option.
• Created linked objects in the Universe to enable contextual report linking (hyper linking) between Business Objects and Web Intelligence reports.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data providers, sections, breaks, drill down reports and hyperlinked reports.
• Created drill down, drill through, sub reports and linked reports using MS SSRS 2005 as well as managed the subscriptions.

Environment: SQL Server 2005, SSRS, Business Objects XI R2, Query Analyzer, Index Tuning Wizard, Windows Server 2003 Enterprise Edition, Team Foundation Server.

Confidential, IL

Business Objects Developer

Responsibilities:

• Updated the existing Universe by adding new tables, Classes, Objects and creating predefined conditions and prompts for the new reporting requirements.
• Created Business Objects reports with various functionalities as prompts, slice and dice breaks, formulae and calculations.
• Created graphical representation of reports such as bar charts, pie charts as per the end user requirements. Migrated the universe and canned reports to the production environment.
• Also involved in migration of 6.5 to XI and has performed all the necessary steps to ensure the safe working of the XI R2 reports.
• Developed drill down reports using Crystal Reports and developed various chart reports.
• Create custom LOVs (List of Values) and custom Hierarchies for drilling down to lower levels in the reports.
• Organized data in the reports by using Filters, Sorting, and Ranking, formatted reports as per business requirements and Set Alerts to enable exception highlighting.
• Scheduled reports based on specific time, events and calendars in various formats such as Excel and PDF.
• Documentation of requirements, parameters and criteria for creation of reports.

Environment: Business Objects XI R2, Web-Intelligence, Xcelsius 4.5, Desktop Intelligence CMC, Designer, Toad, Oracle10g, SQL, PL/SQL, Crystal Reports 10

Confidential, OH

Business Objects Developer

Responsibilities:

• Migrated the reporting system from the existing 5.1.6 version to Business Objects 6.5.1 using the split method.
• Applied security features of Business Objects like report level & object level security in the universe so as to make the sensitive data secure.
• Designed, Developed and maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Updated the existing Universe by adding new tables, Classes, Objects and creating predefined conditions and prompts for the new reporting requirements.
• Created custom LOV’s (List of Values) and Hierarchies for drilling down to lower levels in the reports.
• Used different functionalities of Business Objects like slice and dice, drill down while creating the reports.

Environment: Business Objects 5.x/6 (Designer, Reporter), Desktop Intelligence, Web Intelligence. PL/SQL, Oracle, SQL Server