SUMMARY

• Experienced Business Intelligence (BI/BO/BW/Tableau) Consultant Specialized in SAP Business Objects Enterprise Solutions and data visualization and dashboard solutions using Tableau.
• Significant exposure to SAP Business Objects Enterprise deployed in various industries Banking, Automotive, Industrial and Insurance.
• Proven record of improving efficiency and accuracy of reporting through systematic design, development and implementation.
• Exceptional communication and problem solving skills, adept Confidential forming and maintaining successful relationships in an internal and external team setting.
• 8+ years of experience in Business Objects Enterprise Suite BO 4.0/4.1,XI R3.1/R3/R2 (CMC/Supervisor, Universe Designer, IDT, InfoView, Business Objects/Desktop Intelligence, Web Intelligence Rich Client, Scheduler/Broadcast Agent,BICS, QAAWS, Import Wizard, Publisher Wizard, Report Conversion Tool), Crystal ReportsXcelsius(now known as SAP Dashboard Design), MS office for Analysis and Design Studio; databases such as Oracle 10g/9i/8i, Teradata 12, MS SQL Server 2005/2000, MS Access; as well as OLTP (ECC 6) and OLAP (BW 7) data models.
• 3+ years of experience and In - depth knowledge on Tableau Desktop and Tableau Server.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) Development, Testing, Migration, Administration, Security Management and Production Support on various platforms like UNIX, Windows NT/2000/XP/98.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Extensive TableauExperience in Enterprise Environment and TableauAdministrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Established Best Practices for EnterpriseTableauEnvironment and application intake and development processes.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Extensive experience in migrating BO WEBI, Xcelcius dashboards into Tableau interactive dashboards.
• Skills include design and development of dashboards, balance scores cards and report analysis. In depth experience in testing and deployment of Business Objects XI Solutions with exceptional abilities in support and maintenance.
• Good Knowledge of Dimensional Modeling like Star Schema and Snow Flake Schema to fit Query, and Reporting and Analysis requirements.
• Experience with multiple RDBMS including Oracle, SQL Server, DB2 and Microsoft Access and associated SQL Dialects such as Confidential -SQL, SQL PL and PL/ SQL.
• Well experienced in writing Complex queries, stored procedures, functions and packages using PL/ SQL Programming.
• Technical hands-on experience using Business Objects components like Designer, CMC,Web intelligence rich client, Desktop Intelligence, Info view, Import Wizard, Publishing Wizard and Query as a Web service.
• Excellent knowledge on BO XI/ 3.1 / 4.x Architecture and new features.
• Experience of using BO Data Integrator XIR2. Loaded data (FACT Tables, Dimension Tables) into data marts.
• Involved in the administration of Management Console for implementation of security Confidential Report level, Folder level and object level by assigning rights and required access level as per business requirement. Created Users, user groups, roles and assigned required rights to them.
• Good knowledge of BW Data Modeling and validating BW data with ECC’s relevant Application data
• Experienced in Creating Universes with measures and dimensions objects, join conditions, filters, LOV, defining cardinalities, aliases, contexts, aggregate awareness etc. using Business Objects Designer.
• Experienced in creating complex Business Objects Reports and queries with constant interaction with the end users. Repeatedly used functionalities such as Slice and Dice, Drill mode, Ranking, Scope of Analysis, Aliases, Contexts, @functions, Derived tables, Cascading Prompts, Filters etc. for Multidimensional Analysis.
• Expertise in Migration of Repositories (universes, reports, security privileges etc).
• Excellent communication and strong intrapersonal skills with ability to interact with end-users, managers and technical personnel.

TECHNICAL SKILLS

BI Tools: Business Objects 4.0/4/1/XI3.1-R2/6X, Reporter, Universe Designer, WEBI, Supervisor, Crystal Reports 10/XI/2008 Crystal, Analysis for Office, Data Source Migration, Desktop Intelligence, Administrator, CMC, CCM, Import Wizard, Migration Wizard, Data Integrator, Conversion tool and repository Migration Wizard, Live Office, QAAWS, XWIZ, SAP BI

BI Visualization Tools: XCelsius, Dashboard Design, SAP Design Studio, Lumira, Tableau

Languages: SQL, Oracle PL/SQL, MS SQL, HTML5, Java Script

Database Systems: SQL Server 2000/2005/2008, DB2, Oracle 8i/9i/11i, Teradata, MS Access, HANA

Operating Systems: Windows NT/ 2000/2003/2008 R2/XP, UNIX

Dimensional Modeling: Star Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables, Data Integrator. Informatica, ERWIN

Application Software: MS Word, MS Excel, MS Access, MS Power Point

Other Tools/ Utilities: SQL Navigator, TOAD, IIS5/6, apache, Web Sphere 6, BEA web logic 7

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Sr. Business Objects Developer

Responsibilities:

• Gather, document and translate client’s requirements into functional & technical specs, and wrote scope for the development.
• Managing multiple projects and support the business team for any issues.
• Involved with various database administrators to map the requirements and to propose new solutions.
• Built new reports and made changes to the existing reports based on user requirements using BO Webi and Crystal reports
• Made changes to the existing Ad-hoc Universe using IDT. Added new tables, created new objects, resolved loops and traps by creating contexts and aliases, renamed existing objects, created prompts according to the user requirements.
• Wrote multiple complex Teradata queries using Teradata SQL Assistant to use in the reports.
• Involved in the discussions for new project based on implement reporting, Sales Alignment, and invoice research in accordance to the adoption of a compliant Hierarchy for Revenue Operations processes
• Developed the new universe based on Teradata in IDT. As a part of Universe development, created connection, classes, different kinds of objects, cardinalities, strategies, resolved loops using aliases and contexts
• Implemented Row Level Security in the universe using CMC
• Developed multiple reports on the new universe and implemented the report bursting feature using CMC
• Performed admin role like security management by creating/maintaining user groups, roles, access levels etc
• Participated in migrating reports from BO 3.1 to BO 4.1using the UMT
• Hands on experiencing using Design Studio 1.3 .Created visualizations for analysis purposes.
• Created BIWS connections to provide inputs to Xcelsius dashboards from webi reports
• Involved in performance tuning of existing Dashboards and Dashboard Design alternatives
• Integrated Xcelcius dashboards with SharePoint portal pages
• Supported an existing universe built on multiple data sources by troubleshooting existing problems
• Converted existing .unv universes to .unx
• Created complex webireports using the multiple data providers and synchronize the data providers by merging objects to create a report
• Involved in making changes to the RESTful Web Service using Java SDK for business objects.
• Recommended standards of good practices of report development and maintenance of universes
• Performed administration tasks like moving universes and reports between PROD, QA and DEV environments using Promotion Management in 4.1
• The project involved development of reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs. Trained and supported the users to useBusiness Objects and resolved Trouble Tickets/Cases reported by user

Environment: Business Objects 4.1/4.0/ 3.x, UDT, IDT, CMC,Crystal,WEBI, Rich client, Xcelsius, Analysis for office, Lumira, Design Studio 1.3, Oracle 11g, Teradata 14, Teradata SQL Assistant, BO Java SDK

Confidential, St Louis, MO

Sr. Business Objects/Tableau dashboard Developer

Responsibilities:

• Built new universes as per the user requirements by identifying the required tables from Data mart (RDBMS) and BW BEx (OLAP) queries by defining the universe connections
• Built new reports, dashboards for FICO, GDS, CS, Trade Management, ORM teams using BO Webi, Crystal reports
• Involved in design and developing global template for Mobile users across Nestle Business users in
• Built new Universes/Reports on Point of Sales (POS) data for different Retailers and Trade Management from Trade promotion teams
• Developed multi source and single source Universes using IDT
• Created BICS connection for BW reporting in WEBI
• Involved in training and support for Business/power users on BO 4.1 new tolls Analysis for office and data discovery tool SAP Lumira
• Designed and developed BEx queries suitable for BO standard/adhoc reporting
• Participated in Cube/Multiprovider design discussions
• Took steps to use SAP Authentication once proper security/roles are implemented in BW
• Responsible for security management by creating/maintaining user groups, roles, access levels etc.
• Extensive work on the Audit Database to obtain accurate activity information and take timely actions
• Involved in migrating Cognos reports BO 3.1
• Expertise in Migrating the reports to BO 3.1 to BO 4.0/4.1
• As a part of Universe development, created Classes, different kinds of objects, cardinalities, Strategies, resolving loops using Aliases and Contexts
• Created Xcelsius /Design studio dashboards to various end user requirements
• Created Web services to provide inputs to Xcelsius dashboards via Qaaws
• Performance tuning of underlying SQL & MDX queries
• Responsible for moving universes and reports between PROD, QA and DEV environments using Life Cycle Manager (LCM) in 3.1 and Promotion Management in 4.x
• Responsible for User Support and Training for Business Objects and Webi and resolving Trouble Tickets/Cases reported by user
• As a Business Consultant performed feasibility analysis, Gap analysis and Impact analysis
• Supported, maintained and upgraded the existing legacy crystal reports
• Created complex reports using the multiple data providers and synchronize the data providers by linking the common objects to create a report
• Involved in design and architectural discussion during implementation of new subject areas
• Developed universe user documentation guide for the end users reference
• Interacted with business users for requirement analysis and to define business and functional specifications.
• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Extensively involved gap analysis and design documentation for migrating Business Objects WEBI and Xcelcius dashboards into Tableau dashboards
• Responsible for implementing effective Business dashboards& visualizations for senior management employing Tableau Software.
• Leading of visualization projects and initiatives within multiple divisions.
• Administrate Tableau Server, data content and report distribution.
• Gathering, cleaning and classifying data from multiple subsystems to support correct metrics distribution within the company
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Creating New Schedule's and checking the task's daily on the server
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in installing tabcmd to schedule the report's and setup email reports using command lines.
• Created Business requirement documents and plans for creating dashboards.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Extracted data from DB2, Flat files, XML Files, Flat Files and populated into EDW(SQL Server) and consumed by Tableau Desktop
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

Environment: Business Objects 4.1/4.0/ 3.x/6.5, UDT, IDT, CMC,Crystal,WEBI, Rich client, Analysis for office, Lumira,Design Studio, Tableau,SAP-BW, BEx, Cognos 8.x, Oracle 11g, SQL Developer MS Access, Tableau 8.x

Confidential, Richardson, TX

Senior Business Object Developer

Responsibilities:

• Attended Business meetings and assisted Business Analysts in gathering requirements.
• Involved in setting up the environments for DEV / QA / STG-1, STG-2 for this implementation.
• Designed universes and applied row level and objects level restrictions to different groups and users as required.
• Interacted with Oracle App’s team members to understand the BRD’s and convert them to tangible Technical spec’s to be used in report specifications.
• Coordinating with onsite team to update the business requirements. Work hand-hand during the entire product development.
• Used Java SDK to integrate the Business Objects Infoview into Confidential & Confidential ’s portal.
• Embedded reports directly into developed web applications and thick client report generation.
• Worked extensively on creating Universe’s for Order Management, Accounts Payable, Invoice and AccountReceivable Data Marts.
• Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes.
• Tested Universe and Reports, which includes Database connectivity.
• Resolved loops and contexts to ensure the correct results from the query.
• Objects in the universe, to ensure the correct mapping of the objects.
• Aggregate awareness to ensure the query is pulling correct level of aggregation.
• Verified the data by running the SQL against the database.
• Designed and Developed WEBI Reports using the features like Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze the data.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters.

Environment: Business Objects XI R2/R3 (CCM, CMC, Designer, Web Intelligence, Desktop Intelligence, and Import Wizard), SDK and Oracle Apps, Windows XP, Tomcat.

Confidential, Norwalk, CT

Business Objects Developer

Responsibilities:

• Involved in identifying the target data source.
• Interacted with Business Users and Business Analysts to gather the requirements and Business logics/Rules.
• Analyzed the warehouse Tables to design Universes by creating Classes and Objects.
• Designing the Universe, created Contexts and Aliases for resolving Loops in the Universes.
• Created Objects using different Business Objects functionalities like @ prompt, @variable, @select in the process of designing the universes.
• Linked the Universes to share the common objects between them.
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Updated and maintained Universes based on changing user requirements and data source changes.
• Conducted Performance tuning of Universes for time management purpose by creating alternate views and indexes.
• Created Complex Reports using Reporter module in Desktop/Web Intelligence functionalities like Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formulas.
• Created Alerts in various reports according to user requirement.
• Created templates for standardizing the structure of corporate documents.
• Worked on major functionalities like Breaks, Filters, Sorts, Query prompt and Drill filters.
• Worked closely with the Data Architect Team to ensure the implementation of Business Logic/Rules in the ETL Process.
• Scheduled and monitored reports using BCA.
• Designed the End user training materials and practice Exercises.

Environment: Business Objects XI R2, Desktop Intelligence, InfoView, WEBI, Oracle 9i, Toad, Windows 2000 Server

Confidential

Programmer Analyst (Crystal / BO Report Developer)

Responsibilities:

• Worked with users to define business requirements and design the necessary database fields to meet requirements,
• Coordinated with system testing group and review system enhancements to ensure they meet design specifications.
• Created Web Intelligence Reports using Formulas, Grouping, Parameters and Static/Dynamic
• Cascading Prompts to handle the customer’s requests from Tables, Stored Procedures, and Views.
• Created Dashboard reports using Crystal XCelsius.
• Wrote complex views, functions and stored procedures using SQL, PL/SQL to be used in Crystal Reports development. Reports were tested using SQL, PL/SQL.
• Actively involved with the team of developers in knowledge transfer, functionality issues, and database issues.
• Used Central Management Console (CMC) to perform administrative tasks related to user groups, accounts, report publishing, folder management.
• Wrote as a SQL, PL/SQL developer to write complex SQL, views, functions and stored procedures as required in the application.
• Worked on Migrating of Crystal Enterprise 9.0 reports to XI.
• Involved in training the end user on e-portfolio and info view.

Environment: Business Objects 6.5, Crystal Reports 10, Oracle 8i, Windows 2000