SUMMARY

• Over 12 years experience in Business Intelligence Reporting tools like SAP Business Objects XI R4.1(Universe Designer, Information Design Tool, BI Launch Pad, CMC, Promotion Management, Version Management), XI R3/XI R2/XI R1 (Universe Designer, Web Intelligence, CMC, Dashboard 4.0/ Xcelsius 2008.
• Extensive experience in Business Intelligence ETL tools like Data Services 4.0 / Data Integrator 11.7.
• Experience in Business Intelligence Reporting tools like Micro Strategy 10.3(Developer, Desktop, Portal tools)
• Experience in Data Integration tool Pentaho 6.
• Experience in building corporate dashboards using Tableau 9.0, Dashboard 4.0
• Experience in Design, Development, Maintenance, Testing, Administration, Implementation and Support.
• Experience in Project Management (create project plan, give guidance, lead, documentation). Followed SDLC process for life cycle of the project.
• Extensive experience in administration of Business Objects / Tableau.
• Imported universes, reports using Promotion Management in SAP Business Objects XI R4 and Import Wizard in SAP Business Objects XI R3.
• Implemented Row level security at universe level and group level security at CMC.
• Generated Audit reports for administration.
• Performed report bursting using Publisher.
• Created Technical design documents.
• Comprehensive experience in gathering and analyzing the requirements from end - users and trained users in Business Objects.
• Very Strong in SQL and good exposure to Oracle 12C/11g/10g/Oracle 9i, 8.x, 7.x, Teradata and MS SQL Server 2008.
• Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.

TECHNICAL SKILLS:

BI Tools: SAP Business Objects XI R4.1 (Universe Designer, Information Design Tool, BI Launch Pad, CMC, Promotion Management), XI R3/XI R2/XI R1 (Universe, Desktop Intelligence, Web Intelligence), Micro Strategy 10.

Administration: Central Management Console, User Creation, Audit Reports, Promotion Management, Import Wizard, Version Management, Group Security, Tableau administration

Analytic Tools: Dashboard 4.0, Xcelsius 2008, Tableau 9, Google Analytics

ETL Tools: Data Integrator 11.7/Data Services 4.0, Informatica, Pentaho

RDBMS: Oracle 12C /11g/10g/9i/8i/7.x, MS SQL Server 2007, MS - Access, SQL PLUS, TOAD, Teradata, SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth TX

Sr Business Objects Developer

Responsibilities:

• Designed new Universes based on the canned and adhoc report requirements.
• Maintain existing universes and reports.
• Created projects in MicroStrategy
• Created documents, reports, dashboards using MicroStrategy
• Created data integration jobs using Pentaho
• Created new dashboards for Budget and Confidential IT SLAs.
• Created project plans, give guidance team, lead projects.
• Did administration of Business Objects, Data Service and Tableau
• Deployed code to Test and Prod environments.
• Tuned performance in designer by using Shortcut joins Array Fetch size.
• Created / Modified universe that support dynamic selection of tables based on user input.
• Resolved Fan Traps / Chasm Traps / Loops that produces in correct results on the report by creating context / Alias.
• Created derived tables, custom lovs.
• Was part of gathering the requirements from end users.
• Created system design documents
• Applied security features of Business Objects like row level & object level security in the universe so as to make the sensitive data secure.
• Used Designer Module to implement Universe, Joining the Tables, Create Prompts, parsing the Objects, apply Contexts and Alias to remove cyclic dependencies such as Loops.
• Created document to setup design standards for universe development.
• Exported the universes to repository in order to make universes available for adhoc reporting.
• Deployed universes and reports using Project Management
• Created, modified and maintained the business complex Reports using Deski / WebI report modules.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, alerts for creating reports.
• For performing Multi Dimensional Analysis I created Master/Detail, Cross Tab by using Slice and Dice in Business Object Report Module.
• Created comparison reports, graph reports, multi tab reports, merged dimension reports.
• Tuned the Performance of the existing Reports for various functional areas by tweaking where clause of the reports, removing unnecessary Outer joins between tables.
• Converted Deski reports to Webi reports.
• Automated Year End Changes to reports.
• Created Publications to generate Month End reports
• Created dashboard for Budget Management system that provides budget information like Obligation vs Remaining amounts by Office, Funds. Provided drill down from summary to details by Service Center, Divison and to TERP / Transfer. Summary by OMB Investment.
• Created summary dashboard for Travel and Training budgets
• Built Confidential IT - SLAs drill down charts that displays performance metric information for various modules like Help desk, Average time to resolve, Mean time to resolve, Laptop on Day 1, Top Tier1 resolution percent
• Created Self service dashboards that tracks the issues that are self resolved by user, password resets, self help page views using google analytics, DSM catalogs.
• Maintain Landing page for SLAs drill downs.
• Built Projection charts using Tableau
• Created Stacked bar charts
• Built demographic chart using Tableau
• Used advance filtering in Tableau
• Used Parameters and filters
• Rank charts using index.
• Built line, bar and dual axis charts
• Created new universes in UNX format.
• Developed universes using multiple data sources
• Conversion of UNV to UNX universes
• Involved in conversion of Performance Management to Xcelsius Dashboard
• Built new dashboards using QAAWS.
• Created / Modified Speedometers and IMTs analytics.
• Created demographic maps using Dashboard
• Build Executive dashboard using Dashboard
• Created / modified new data flows, work flows, jobs for various modules like Monthly Cost Allocation, VAT, Fixed Assets, etc.
• Used different types of transformers (Query transformers, Key generation, comparison,..) in coding data flows.
• Did coding for Dimension tables, Reference tables and Fact tables.
• Used comparison and history preserving transformers in designing history preserving dimension tables.
• Designed complex techniques in developing data mart.

Environment: Business Objects XI R4 (Universe Designer, Information Design Tool,, Desktop Intelligence, Web Intelligence, CMC), Data Integrator 11.7, Data Services, Publications, Performance Management, Scheduler, Oracle 10g, Xcelsius /Dashboard4.0, Tableau 9, Google Anaytics, Microsoft Project, Visio., MicroStrategy, Pentaho

Confidential, Houston TX

Sr. Business Objects Developer

Responsibilities:

• Interact with Business Analysts to gather the requirements.
• During requirement process used to gather report requirement like functionality, prompts, report fields, grouping, sort order and business rules.
• Interact with DA’s to understand the structure of the tables.
• Designed new Universes based on the canned and adhoc report requirements.
• Involved with Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Created Generic ODBC and client connections for Oracle.
• Used Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects, apply Contexts and Alias to remove join path problems such as loops.
• Exported the universes to the Repository to make resources available to the users.
• Created, modified, and maintained the business complex Reports using Business Objects Report modules.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, alerts for creating reports.
• I created Master/Detail, Cross Tab by using Drill down and Slice and Dice in Business Object Report Module.
• Call reports through viper .net framework and display in report placeholder using open document function.
• Created Comparison Reports by linking different data providers and graph report.
• Tuned the queries to improve the Performance of the existing Reports for various functional areas and by assigning indexes to columns.
• Developed Stored Procedures to improve the performance of the Reports using complex queries.
• Scheduled Reports using Broad Cast Agent.

Environment: Business Objects 6.5 (Universe, Desktop Intelligence and Web Intelligence), Scheduler, Oracle 11g, Windows XP professional.

Confidential, Deerfield, IL

Business Objects Developer

Responsibilities:

• Interacted with the Users and Business Analysts to gather the requirements.
• Designed new Universes and modified the existing Universes based on the report requirement
• Involved with Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Created Generic ODBC and client connections for Teradata.
• Used Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects, apply Contexts and Alias to remove join path problems such as loops.
• Exported the universes to the Repository to make resources available to the users.
• Created, modified, and maintained the business complex Reports using Business Objects 6.5 Report modules.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, alerts for creating reports.
• I created Master/Detail, Cross Tab by using Drill down and Slice and Dice in Business Object Report Module.
• Created Comparison Reports by linking different data providers, graph report and linking one report with another report using opendocument function.
• Tuned the queries to improve the Performance of the existing Reports for various functional areas and by assigning indexes to columns
• Tuned in designer by using Shortcut joins, Aggregate Awareness and Array Fetch Size
• Made use of summary tables necessary for Structured Reporting.
• Developed Stored Procedures to improve the performance of the Reports using complex queries.
• Created the reports on the web by using Web intelligence.
• Scheduled Reports using Broad Cast Agent.

Environment: Business Objects Suite 6.5 (Reporter, Supervisor, Designer), Broadcast Agent, and Web Intelligent, Teradata, Oracle9i, Windows 2000 Server.

Confidential, Monroe, CT

Business Objects Developer

Responsibilities:

• Interacted with the Users and Business Analysts to gather the requirements.
• Involved in Installation and Configuration of all Components of Business Objects.
• Involved in setting privileges to different User Groups Coordinating with Supervisor and DBA using Supervisor Module.
• Designed new Universes and modified the existing Universes based on the report requirements.
• Created Universes using different Relational Data sources like oracle 9.1, SQL Server 2000 and MS Access 2000.
• Involved with Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Created ODBC and client connections for SQL Server 2000, Oracle 9.1 and MS Access.
• Used Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects, apply Contexts and Alias to remove cyclic dependencies such as Loops.
• Exported the universes to the Repository to make resources available to the users.
• Created, modified, and maintained the business complex Reports using Business Objects 6.5.1 Report module.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, alerts for creating reports.
• For performing Multi Dimensional Analysis I created Master/Detail, Cross Tab by using Drill down and Slice and Dice in Business Object Report Module.
• Tuned the queries to improve the Performance of the existing Reports for various functional areas and by assigning to indexes to columns
• Tuned in designer by using Shortcut joins, Allocating Weight to the table, Aggregate Awareness and Array Fetch Size
• Developed materialized view and summary tables necessary for Structured Reporting.
• I used the new feature of business object such as Derived Tables.
• Applied security features of Business Objects like report level & object level security in the universe so as to make the sensitive data secure.
• Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the Reports using complex queries
• Created the reports on the web by using Web intelligence.
• Extensively worked on Broadcast Agent for scheduling and distributing the documents.

Environment: Business Objects Suite 6.5.1 (Reporter, Supervisor, and Designer), Broadcast Agent, and Web Intelligence, Business Objects Dashboard Manager, Oracle9i,