SUMMARY:

• Business Objects Consultant with 9 Years of experience in Full Life Cycle BI & Reporting solutions analysis, design, development, integration, enhancement and upgrade of business intelligence applications using SAP Business Objects Enterprise and Informatica Power Center and Tableau Desktop and Tableau Server.
• Experience in handling the components of Business Objects XI R 3.1 (Universe Designer, Desktop Intelligence, Web Intelligence, Import wizard, Report Conversion Tool, CMC, Info view, CCM).
• Experience in handling the components of Business Objects 4.1 (Universe Designer Tool, Information Design Tool, Web Intelligence, Report Conversion Tool, Upgrade Management Tool, Central Management Console, BI Launch Pad, CCM)
• Experience in Tableau (Desktop and Server), creating various Reports and Dashboards using different visualizations like Bars, Lines, Pies, Maps, Scatter plots, Bubbles and Highlight tables.
• Experience in creating Webi reports using features like grouping, sorting, Running totals, Charts. Organized data in the report by using slice and dice and using drilling options.
• Experienced in implementation of Business Objects with Retail, Telecom, Wealth Management and manufacture domain.
• Proficient in using the reporting tools like Crystal Reports, Dashboards
• QaaWS, Live Office connections have been used to refresh dashboards.
• Experience on developing Dashboards using Lumira & Design Studio.
• Experience in creating aggregates, hierarchies, charts, filters, quick filters, table calculations, trend lines
• Created Customized and interactive dashboards using multiple data sources.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau
• Expertise in developing interface layer called Universe using UDT & IDT
• Expertise in using Business Objects Universes (UDT) & (IDT), Bex queries, personal data files and custom SQL methods as a source & Experience on reporting using BEx, Webi and Tableau
• Experience in managing, publishing and scheduling reports using BI Launch pad.
• Involved in Migration of existing Business Objects Universe and Reports from version BO XI R3.1 to Business Objects 4.1 using Upgrade Management Tool (UMT).
• Created Dashboard using Qlikview and Tableau.
• Expertise in creating complex queries in BEx Query Designer/Analyzer using Conditions, Exceptions, Filters, Calculated Key Figures, Restricted Key Figures, Variables, & Structures.
• Strong experience with client interactions, understanding business applications, business data flow and data relations.
• Ability to meet deadlines and handle multiple tasks and flexible in work schedules.
• Comprehensive Knowledge in writing Unit Test Cases and also proficient in Test Driven Development.
• Extensive experience in using databases like Oracle, SQL Server, HP Vertica.
• Extensive experience in writing and creating Views, Complex Queries, Sub Queries using SQL.
• Effective skills to build reports in Business Objects. Expertise in creating Xcelsius Dynamic Dashboards using SAP BI data/BEx Queries.
• Expertise in Dimensional data modeling techniques namely Star Schema, Snowflake Schema Data Models using ETL tools like Informatica Power Center 9.1
• Have work experience on other tools like HP Quality Center , HPSM and Clear Quest.
• Worked on POCs using Lumira, Tableau

TECHNICAL SKILLS:

Operating System: Windows 7/8/10, XP, Windows 2008

Reporting Tools: SAP Business Objects 4.1/ 3.1/ XI R2/ 6.5, Dashboard Design 4.1/4.0 Tableau 8.3/9.1/9.3, Web Intelligence, UDT, Information Designer, Desktop Intelligence, CMS, Infoview, CMC, Dashboard, Import Wizard, Live Office, Xcelsius/Dashboards, Crystal reports, Lumira, Design Studio, Qlikview

Languages: SQL, PL - SQL, UNIX Scripting

Database: Oracle 11g/10g/9i/8i, SQLSQL Server 2008, Vertica, MySQL 5.5/5.6/5.7

OLAP: SAP BW/BI, Bex Analyzer, Bex Designer, BICSETL: Informatica Power Center 9.1

DB Applications: Toad, Oracle SQL Developer, SQL Server Management Studio

Utility Tools: HP Service Manager, HP Quality Center, Putty TortoiseSVN

PROFESSIONAL EXPERIENCE:

Confidential, Providence, RI

SAP BO Developer

Tool: Set: SAP Business Objects 4.2 and 3.1, Web Intelligence, Universe Design Tool, Information Design Tool, Central Management Console, UMT, SQL, Oracle 11G, Netezza, Sybase, SQL Server and Windows 7, Crystal Reports

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for business object universes and reports
• Involved in creation of High level design document for new requirements.
• Analyzed requirement changes for enhancements and included them in existing HLD
• Designed and documented Universe and Report Requirements Definition, Security strategies, and Report Distribution strategies
• Created Relational connections using Information design tool.
• Implemented universes using IDT.
• Scope includes creating Webi Reports with stand templates of BlueCross BlueShield.
• Created connections, data foundation and business layer in universe.
• Created Joins like IINNER, outer joins, short cut join and Complex joins.
• Set join cardinalities in data foundation layer of universe.
• Created LOV's based on query results, hierarchy, static list, SQL expression and customer navigation path, parameters in business layer of universe.
• Applied Index awareness, set up aggregate awareness and implemented data security profile in the universe.
• Converting Universes. UNV to. UNX and setting up Universe security in Information Design Tool (IDT).
• Created WEBI reports utilizing all the features on Web Intelligence like Optional Prompts, Functions, filters, input controls, Sections, Breaks, Ranking, drill, scope of analysis, merge dimensions, calculation contexts, force merge, combined queries, hyper linking and using report level variables.
• Publish, distribute and schedule Web Intelligence reports using BI Launch Pad.
• Used publication feature in WEBI to publish multiple reports to dynamic and enterprise users.
• Measure, Dimension and Detail objects are created to meet the needs of end user requirements so that every possible query can be achieved.
• Involved in the Performance tuning of the reports both at the Universe level and the report level.
• Modified Universes and changed the Web Intelligence reports as per the requirement changes.
• Used promotion management tool for migrating reports from one environment to another environment.
• Resolved loops using Contexts and Aliases and Shortcut joins
• Used various @Functions like @Aggregate aware, @Prompt, @Where, @Variable and @Select
• Resolved the issues occurred during migration from 3.1 to /4.2
• Responsible for project delivery by coordinating with Business Stake Holders, Business Analysts, QA team and UAT teams.
• Gathering and analyzing business requirements to understand the implications of creating & customizing database objects in the EDW.
• Status reporting and estimation of Efforts and publishing time lines for each Change Request.
• Implement development activities for universes and perform unit testing before moving the code for QA testing.
• Planning and monitoring of Change Requests and owning the delivery of Change Requests until deployment
• Coordination with other downstream application teams in case of a Change Requests impacting multiple applications (usually the case)
• Created standard report templates with the help of WebI

Confidential, Woonsocket, RI

SAP BO Lead Developer

Tool: Set: SAP Business Objects 4.1 and 3.1, Web Intelligence, Universe Design Tool, Information Design Tool, Central Management Console, UMT, SQL, Oracle 11G and Windows 7

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for business object universes and reports
• Involved in creation of High level design document for new requirements.
• Analyzed requirement changes for enhancements and included them in existing HLD
• Designed and documented Universe and Report Requirements Definition, Security strategies, and Report Distribution strategies
• Created relational and Relational connections using Information design tool.
• Implemented universes using IDT.
• Created connections, data foundation and business layer in universe.
• Created Joins like equi-join, theta-join, outer joins, short cut join, set join cardinalities in data foundation layer of universe.
• Created lov's based on query results, hierarchy, static list, SQL expression and customer navigation path, parameters in business layer of universe.
• Applied Index awareness, set up aggregate awareness and implemented data security profile in the universe.
• Converting Universes .UNV to .UNX and setting up Universe security in Information Design Tool (IDT).
• Created WEBI reports utilizing all the features on Web Intelligence like Optional Prompts, Functions, filters, input controls, Sections, Breaks, Ranking, drill, scope of analysis, merge dimensions, calculation contexts, force merge, combined queries, hyper linking and using report level variables.
• Publish, distribute and schedule Web Intelligence reports using BI Launch Pad.
• Used publication feature in WEBI to publish multiple reports to dynamic users.
• Measure, Dimension and Detail objects are created to meet the needs of end user requirements so that every possible query can be achieved.
• Involved in the Performance tuning of the reports both at the Universe level and the report level.
• Modified Universes and changed the Web Intelligence reports as per the requirement changes.
• Used promotion management tool for migrating reports from one environment to another environment.
• Measure, Dimension and Detail objects are created to meet the needs of end user requirements so that every possible query can be achieved.
• Resolved loops using Contexts and Aliases.
• Used various @Functions like @Aggregate aware, @Prompt, @Where, @Variable and @Select
• Migrated the content from SAP BO 3.1 to SAP BO 4.1 using UMT.
• Resolved the issues occurred during migration
• Responsible for project delivery by coordinating with Business Stake Holders, Business Analysts, QA team and UAT teams across the regions.
• Gathering and analyzing business requirements to understand the implications of creating & customizing database objects in the EDW.
• Status reporting and estimation of Efforts and publishing time lines for each Change Request.
• Implement development activities for universes and perform unit testing before moving the code for QA testing.
• Planning and monitoring of Change Requests and owning the delivery of Change Requests until deployment
• Coordination with other downstream application teams in case of a Change Requests impacting multiple applications (usually the case)
• Created standard report templates with the help of crystal reports.
• Having good knowledge in the requirement thus helped the complete team to deliver the project on time.

Confidential, Houston

SAP BO Developer

Tool: Set: SAP Business Objects 4.1 and 3.1, Web Intelligence, Universe Design Tool, Information Design Tool, Central Management Console, UMT, SQL, Oracle 11G and Windows 7, Crystal Reports, Dashboard

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for business object universes and reports
• Involved in creation of High level design document for new requirements.
• Analyzed requirement changes for enhancements and included them in existing HLD
• Designed and documented Universe and Report Requirements Definition, Security strategies, and Report Distribution strategies
• Designed and developed complex Webi reports using merged dimensions, charts, drill down, drill across and element linking functionalities.
• Migrated from SAP BO 3.1 to 4.1
• Created relational and Relational connections using Information design tool.
• Implemented universes using IDT.
• Created connections, data foundation and business layer in universe.
• Created Joins like equi-join, theta-join, outer joins, short cut join, set join cardinalities in data foundation layer of universe.
• Created lov's based on query results, hierarchy, static list, SQL expression and customer navigation path, parameters in business layer of universe.
• Applied Index awareness, set up aggregate awareness and implemented data security profile in the universe.
• Converting Universes. UNV to. UNX and setting up Universe security in Information Design Tool (IDT).
• Created WEBI reports utilizing all the features on Web Intelligence like Optional Prompts, Functions, filters, input controls, Sections, Breaks, Ranking, drill, scope of analysis, merge dimensions, calculation contexts, force merge, combined queries, hyper linking and using report level variables.
• Publish, distribute and schedule Web Intelligence reports using BI Launch Pad.
• Used publication feature in WEBI to publish multiple reports to dynamic users.
• Measure, Dimension and Detail objects are created to meet the needs of end user requirements so that every possible query can be achieved.
• Involved in the Performance tuning of the reports both at the Universe level and the report level.
• Modified Universes and changed the Web Intelligence reports as per the requirement changes.
• Used promotion management tool for migrating reports from one environment to another environment.
• Measure, Dimension and Detail objects are created to meet the needs of end user requirements so that every possible query can be achieved.
• Resolved loops using Contexts and Aliases.
• Used various @Functions like @Aggregate aware, @Prompt, @Where, @Variable and @Select
• Migrated the content from SAP BO 3.1 to SAP BO 4.1 using UMT.
• Resolved the issues occurred during migration
• Responsible for project delivery by coordinating with Business Stake Holders, Business Analysts, QA team and UAT teams across the regions.
• Gathering and analyzing business requirements to understand the implications of creating & customizing database objects in the EDW.
• Status reporting and estimation of Efforts and publishing time lines for each Change Request.
• Implement development activities for universes and perform unit testing before moving the code for QA testing.
• Planning and monitoring of Change Requests and owning the delivery of Change Requests until deployment
• Coordination with other downstream application teams in case of a Change Requests impacting multiple applications (usually the case)
• Created standard report templates with the help of crystal reports.
• Having good knowledge in the requirement thus helped the complete team to deliver the project on time.

Confidential, Palo Alto

SAP BO Lead Developer

Tool: Set: SAP Business Objects 4.1, Web Intelligence, Universe Design Tool (UDT), Central Management Console, Upgrade Management Tool, SQL, Oracle 11G and Windows 7, Information Design Tool (IDT), Tableau desktop 8.3 and 9.1, Tableau Server

Responsibilities:

• Interacted with Business Users and Business Analysts to understand the business requirements and converted Business requirements into technical specification documents
• Responsible for creation of universe using Information design tool, reports using web Intelligence and migration of reports, universes.
• Responsible for creation of Sell through and Inventory sales and supply web intelligence reports and universes using IDT and enhancing existing universes using UDT.
• Implemented universes using IDT.
• Created connections (. cns), data foundation (. dfx) and business layer (. blx) in universe.
• Created Joins like equi-join, outer join, short cut join, set join cardinalities in data foundation layer of universe.
• Created lov's based on query results, hierarchy, static list, SQL expression and customer navigation path, parameters in business layer of universe.
• Used @Aggregate Aware function to allow the users to do reports on multiple dimensions and to increase the performance of reports.
• Created contexts as per the report requirements and also resolved the loops.
• Implemented row level and objects level security in universe to organize the report users.
• Created WEBI reports utilizing all the features on Web Intelligence like Optional Prompts, Functions, filters, input controls, Sections, Breaks, Ranking, drill, scope of analysis, merge dimensions, calculation contexts, force merge, combined queries, hyper linking and using report level variables.
• Involved in migration of the BO reports, universes using Life cycle management (Promotion Management tool).
• Responsible for taking universe backup for existing universes (LCMBIAR) in production environment as part of weekly activity.
• Providing and revoking access to the business objects users. Implemented security setup to authorize all the users according to their level and privileges to help them navigate to the right folders.
• Run the existing adhoc BO report once in a week for UAM reconciliation process to capture the count of the number of users who have actually requested for enabling and revoking BO access.
• Monitoring scheduled reports and sending the daily report.
• Monitoring HPSM ticketing tool everyday to keep track of the requests, incidents, change requests.
• Responsible for creation of design and change requests if required.
• Also implemented this project using Tableau as a pilot project using Tableau Desktop 9.1
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Executed and tested required queries and reports before publishing dashboards and Story’s.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Majorly focused on Tableau BI tool to create tableau dashboard proto types as per the business requirements and acted like an end - to - end Tableau Implementer (Tableau Analyst, Tableau Developer) throughout the project.

Confidential, Palo Alto

Sr Business Object Developer

Tool: Set: SAP Business Objects 3.1, Web Intelligence, Universe Design Tool (UDT), Central Management Console, Import Wizard, SQL, Oracle 11G and Windows 7 Professional, Information Design Tool (IDT), UMT, Tableau Desktop and Tableau Server and Informatica

Responsibilities:

• Worked with business stakeholders & business analysts on requirement gathering and requirement assessment and data analysis.
• Designing conceptual, logical, and physical data models to meet the reporting requirements.
• Responsible for design & development of universes and reports.
• Business Objects Testing at Report Level, Universe Level, and Data Source Level.
• Used Tableau for Data Visualization analytics in order to get the meters with success& failure
• Developed two Universes which include different Subject Areas.
• Involved in weekly Team Meetings with Application Development Team members on analyzing the projects.
• Involved in All phases of Testing with respect to the Project Development.
• Involved in Resolution of defects in a specific time frame.
• Involved in Universe Development applying Aggregate awareness and contexts for improving queries performance
• Worked on improving the performance of reports by analyzing the universe and database indexes.
• Prepared and demonstrated various Dashboards for Clients from disparate data sources using Tableau.
• Used prompt objects at universe to make Reports confined to a particular case as per business requirement
• Provided training for the users
• Performing root cause analysis on the data quality failures.
• Worked with actively with ETL Informatica team to attain the best optimal performance.
• Need to support the users with their usage issues as per the priority levels.

Confidential, Palo Alto

Sr Business Object Developer

Tool: Set: SAP Business Objects 3.1, Web Intelligence, Universe Design Tool (UDT), Central Management Console, Import Wizard, SQL, Oracle 11G and Windows 7 Professional, Information Design Tool (IDT), UMT

Responsibilities:

• Worked with business stakeholders & business analysts on requirement gathering and requirement assessment and data analysis.
• Designing conceptual, logical, and physical data models to meet the reporting requirements.
• Responsible for design & development of universes and reports.
• Business Objects Testing at Report Level, Universe Level, and Data Source Level.
• Testing at all phases of Business Objects.
• Working on the Reports related to the Hyperlinks.
• Generating various reports on Daily, Weekly, and Monthly basis.
• Used Tableau for Data Visualization analytics in order to get the meters with success& failure
• Developed Two Universes which include 10 Subject Areas.
• Involved in weekly Team Meetings with Application Development Team members on analyzing the projects.
• Responsible for maintaining Business information to support in development operations.
• Used WEBI Infoview for Accounts - Report Development for Smart Connect Project.
• Involved in All phases of Testing with respect to the Project Development.
• Involved in Resolution of defects in a specific time frame.
• Involved in Universe Development applying Aggregate awareness and contexts for improving queries
• Worked on improving the performance of reports by analyzing the universe and database indexes.
• Prepared and demonstrated various Dashboards for Clients from disparate data sources.
• Used prompts objects at universe to make Reports confined to a particular case as per business requirement.
• Provided training for the user
• Performing root cause analysis on the data quality failures.
• Worked with ETL team to attain the best optimal performance.
• Need to support the users with their usage issues as per the priority levels.

Confidential, Palo Alto

Sr Business Objects Developer

Tool: Set: SAP Business Objects 4.1, Web Intelligence, Information Design Tool, Universe Design Tool, Central Management Console, Promotion Management, SQL, Oracle 11G and Windows 7, Tableau Desktop 8.3, Dashboards.

Responsibilities:

• Working with Business Objects Enterprise Platform team on the Requirement Gathering, Assessment, and Gap Analysis.
• Involved in Design & Develop ETL processes to extract data from source, transform as per business rules and load into Audit Data mart.
• Involved in universe design and development.
• Developed the audit universe using IDT as per the business requirement.
• Applied row level security and business layer security in the universe as per the requirement.
• Developed different audit reports for active and inactive users, Monthly usage per application, top 10 users and top 10 applications based on usage statistics.
• Created weekly, monthly and quarterly reports based on calendar.
• Responsible for Unit Testing and Integration Testing to check whether the data was loaded into the warehouse as per the business standards.
• Built reports & dashboards for end users for analyzing the business trends.
• Worked with Query Browser and QaaWS in case for getting the data into the dashboard.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Sending the dashboards to users by emails with the help of admin team with subscriptions.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Given training/demos to users on Tableau Desktop for user community.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Built complex formulas in Tableau for various business calculations
• Responsible for creating the documentation
• Performed unit testing and extensively supported SIT and UAT.
• Training End Users, Business Analysts, and High level Management groups on the Decision Support System & its capabilities.
• Distributed the audit reports for the regional business leads on the timely basis.

Confidential, Palo Alto

Business Objects Developer

Tool: Set: SAP Business Objects 4.0, Web Intelligence, Universe Design Tool (UDT), Information Design Tool (IDT) and Windows 7 Professional, SQL, HP ALM, CMC, Promotion Management, Crystal Reports, Oracle 11G, UMT

Responsibilities:

• Worked extensively in leading, developing and implementing report solutions on Business Objects 4.0, Web Intelligence, Dashboards, UMT and Business Objects Universe Designer and Information Design Tool and Crystal Reports.
• Review and understand functional requirement documents prepared by the business analysts and prepare detail technical design document, to share with rest of the team both at Onsite/Offshore
• Involved in the full software lifecycle covering planning, requirement gathering, design, implementation, testing, documentation, delivery, maintenance and Support.
• Experience on BO Administration (Configuring and troubleshooting clustered environments, Load balancing, Failover and Contingency scenarios, User creation and maintenance, Repositories, IIS and managing CMC and Job servers)
• Expertise in designing Universe from scratch, migrating to different environments, designing WebI reports and maintaining them on Business Objects 4.0
• Work with various teams such as Testing team, Release Management team, and teams from other applications to support their activities
• Created financial related report templates using Crystal Reports 2011.
• Extensively supported the application after post production and also during warranty.

Confidential, Palo Alto

Business Objects Developer

Tool: Set: SAP Business Objects 3.1, Web Intelligence, Universe Design Tool, Central Management Console, Import Wizard, SQL, MySQL 5.6, Oracle 10G and Windows 7 Professional

Responsibilities:

• Developed 3 Different Universes from the scratch in this project.
• Analyzing the functional specifications provided by the client
• Creating TSD (Technical Specification Documents) for the Reports.
• Used @Prompt function in to create prompt based conditional objects in the universe.
• Created contexts to resolve the loops.
• Created @aggregate aware function based objects to report on different subject areas.
• Used @select and @variable functions
• Created complex variables to achieve the requirements.
• Participate in the Code review, impact analysis and post-release analysis.
• Migrating Universes and Reports from Dev to QA and QA to PROD with adhering to the Business Continuity Management process.
• Having good knowledge in the requirement thus helped the complete team to deliver the project on time.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Managing and maintenance of multiple Data Providers for generating reports.
• Developed reports as per Business requirement with various BO features.
• Implemented hierarchies and involved in performance tuning.
• Upgraded from BO 3.1 to BO 4.1.
• As part of HP split we have separated the content into companies based on the business logic and validated the data vigorously.