SUMMARY:

• 11+ years of professional IT experience in Data Warehousing, Design, Analysis, Development, Implementation, Administration and Maintenance using SAP BO 4.2/4.1/4.0/XI 3.x,Tableau 8.1/9.3, Netezza 7.3, Oracle 11g/10g.
• Around 7 years of Tableau Experience in Enterprise Environment in Tableau 8.1 and 9.1/9.3 as a Developer and Analyst
• Experience in creating Dashboards using Tableau Desktop and Published to Tableau Server.
• Experience in configuring reports from different data sources using data blending.
• Trained business users on tableau usage and functionality for ad hoc reporting needs.
• Knowledge in Tableau Administration Tool for Configuration, adding users, data connections, scheduling tasks by integrating with other platforms like SharePoint.
• Experience in implementing Data blending, Customized queries and advanced visualizations, and Action filters in Tableau.
• Experience in designing and building the Multi Source / Single Source Universes using Information Design Tool (IDT) / Universe Designer, and updating the existing Universes.
• Experience in Installing and Upgrading BO XI 3.1 Suite to BO 4.0 SP6 / BO 4.2
• Developing canned/ad - hoc reports, scheduling the processes/reports and administering the BO activities.
• Expertise in Administrative activities of Business Intelligence tools such as Business Objects 4.x/XI 3.1
• Extensive knowledge and experience in Agile Development Methodology.
• Experience in designing and developing the Universe and updating the existing Universes, developing canned/adhoc reports, scheduling the processes and administering the BO activities using Business Objects.
• Conversion of Deski Reports to WEBI reports using Report Conversion tool (RCT).
• Technical hands-on expertise in using Business Objects BO 4.1/ 4.0/XI 3.1/XI R2/6.5 (IDT, Designer, Reporter, CMC, CCM,BI Launchpad, Web Intelligence, Desktop Intelligence) and
• Configured and enabled the SSO using the Windows AD Authentication.
• Expertise in Xcelsius dashboards using Live Office, QAAWS and other data sources.
• Experience in ETL using MS BI SQL Server Integration Services (SSIS 2008).
• Extensive Experience in setting up environment for BOXI, which involves creating the groups in CMC, adding users, mapping the row level and object level securities.
• Excellent analytical and communication skills that are required to effectively work in the field of applications development and maintenance

TECHNICAL SKILLS:

OLAP: Tableau 9.x/8.x (Desktop, Server), Business Objects 4.2/XI3.x (BI LaunchpadIDT, Universe Designer, WebI 4.2/XI3.1, Desktop Intelligence), SSRS

ETL: Informatica Power Center 9.1/8.6, MS BI (SSIS 2008)

Databases: Netezza 7.3, Oracle 12c/11g/10g, MS SQL Server 2012/2008 R2, SAP HANA 1.0

Tools: Toad, SQL Server Management Studio, Visual Studio, Eclipse

SAP: SAP BW/BI 7.x, BEx Query designer

Web: HTML, XML, JSON

Languages: SQL, PL/SQL, Java, JSP, Servlets

OS: UNIX, Windows NT, Windows 2008 R2/2000

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Tableau Developer / BO Developer, Reston, VA

Responsibilities:

• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Worked extensively with Advance analysis Actions, Calculations, Parameters using Tableau.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD.
• Preparing dashboards using calculated fields, groups, sets and hierarchies in Tableau.
• Created and assigned Schedules to Workbook and Data sources for Incremental and Full Refresh.
• Generated Dashboards with Quick filters, Parameters and cascading Prompts to handle views more efficiently.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Generated Dashboards with Quick filters, Parameters and cascading Prompts to handle views more efficiently
• Published Workbooks by creating user filters so that only appropriate teams can view it
• Performance tuning of workbooks, data sources, and providing best practices for user community
• Created WBS (Work Breakdown Structure) for the new Report Requirements.
• Developed the report/dashboard prototypes for end users in Business objects/Tableau to get sign off for actual designing.
• Responsible for updating and maintaining existing Multi Source / Single Source Universes based on changes in user requirements and changes in data.
• Created complex Master Detail reports by Passing Input Control Values as filters from the main report to child report.
• Created Derived Tables in IDT based on the report requirement.
• Responsible to support the issues with reports on the BO environments (Development, UAT, Test and Production).
• Resolved post upgrade issues like report schedule issues, report failures during migrations and server settings and creating additional servers to handle the scheduled Jobs.
• Scheduled reports for different file based / schedule based events, distributed in email, PDF and HTML format.
• Created incident and change tickets using BMC Remedy.
• Worked extensively with the functionalities like Input Controls and creating Master - Detail reports using Hyper linking feature, Group values, Pre-defined conditions, Calculations and Ranking.
• Responsible for responding to and resolving assigned support tickets on Business Objects issues in 4.2/ 4.0 environment within defined SLA's
• Created the reports using Freehand SQL feature in SAP BO 4.2
• Involved in Training & Supporting end-user reporting needs using BO 4.2/4.0

Environment: Tableau 9.1/9.3 (Desktop/Server), Business Objects BO 4.2, Netezza 7.3, Oracle 12c, Windows

2008 R2

Confidential

Sr. Tableau Developer / BO Developer, Houston, TX

Responsibilities:

• Interacted with Business Users to understand and document the requirements.
• Documented user requirements by translating Functional requirements into Technical Requirements.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Migrating the content from BO XI 3.1 to BO 4.1 using Upgrade Management Tool (UMT).
• Installed BO 4.0 Support Packs, Patches and upgrades to ensure the SAP Business Objects systems are up to date with latest bug fixes.
• Created complex Webi reports on SAP BEx Queries using BICS connection.
• Created complex Master Detail reports using hyperlinks by passing prompts with Open Document functionality.
• Promoted the BO content from Dev to Test to Prod environments using Promotion Management after testing and user signoff.
• Created Pareto and Trending Charts at Region, Country and Facility Level to track the WO processing and efficiency over a range of time.
• Created Webi reports using multiple Data providers and synchronized the data using Merged Dimensions and Force Merge.
• Involved in Preparing the Work Breakdown Structure (WBS) for the new Requirements.
• Created reports using Business Objects functionalities like Input Controls, Query Stripping, and Drill down, @Functions, Master/Detail and Formulas etc.
• Worked with several features like Query Stripping, Input Controls, and Scope of Analysis and Drill functionality.
• Made the necessary changes in Webi processing and Adaptive processing servers to stabilize the BOBJ environment.
• Administered Business Objects Enterprise using Central Management Console (CMC), Central Configuration Manager (CCM).
• Responsible for writing the SQL queries for the data validation and testing the reports.
• Experience in Training & Supporting end-user reporting needs using BO 4.0/4.1

Environment: Business Objects BO 4.1/4.0 SP06 (BI Launchpad, IDT, Web Intelligence, Designer, Dashboard Designer, Promotion Management, Upgrade Management Tool (UMT), Dashboard Designer, CMC, CCM)Tableau 8.1, SAP BW 7.3, Tomcat, Windows 2008 R2

Confidential

Sr. Business Objects Admin / Developer, Fort Mill, SC

Responsibilities:

• Interacted with Business Users to understand and document the requirements.
• Installation of BO4.0 in all phases of environment i.e. Development and Production environment.
• Migrating the content from BO XI 3.1 to BO 4.0 using Upgrade Management Tool (UMT).
• Installation of BO4.0 SP6 Support Packs, Patches and upgrades to ensure the SAP Business Objects systems are up to date with latest bug fixes.
• Resolving the Post Upgrade issues from BO XI 3.1 to BO 4.0
• Conversion of Desktop Intelligence Reports (Deski) to WEBI reports using Report Conversion tool (RCT).
• Resolving the conversion issues after converting from Deski to Webi.
• Made necessary changes in Webi processing and Adaptive processing servers to stabilize the BOBJ environment
• Implemented Agile Development practices according to the application requirements
• Created simple to complex Webi reports and also used the new features in BO 4.0.
• Creating users and groups assigning the access levels.
• Used the @ Functions such as @ Aggregate Aware, @Select, @Prompt in designing Universe
• Monitoring the day to day activities on the servers.
• Utilized Tableau server to publish and share the reports with the business users.
• Migrating the Universe/Reports from Development to Production using Promotion Management.
• Configuring SAP BI Mobile application on both iPad and Android.
• Deployed BO universes and reports from Development environment to Production environment using Promotion Management.
• Expert in designing and developing the Tableau visualization solutions.
• Creating webi reports based on Multi Data Providers.
• Responsible for writing the SQL queries for the data validation and testing the reports.
• Configured SSO for Business Objects XI 4.0 on Windows AD
• Trained business users on tableau usage and functionality for ad hoc reporting needs.
• Knowledge in Tableau Administration Tool for Configuration, adding users, data connections, scheduling tasks by integrating with other platforms like SharePoint.
• Experience in implementing Data blending, Customized queries and advanced visualizations, and Action filters in Tableau.
• Migrating the Reports and Universes between different environments using Promotion Management.
• Designed and developed Webi reports and deployed to display on Android and iOS based Tablets.
• Managed scheduled and notification options for documents to the desired users.
• Experience in Training & Supporting end-user reporting needs using BO 4.
• Created Dashboards using Cascading Prompts and Dynamic Visibility functionality in Design Studio
• Involved in helpdesk support for resolving user issues

Environment: Business Objects BO 4.0SP6/XI 3.1 (BI Launchpad, IDT, Web Intelligence, Designer, LCMDashboard Designer 4.0, Promotion Management, Upgrade Management Tool (UMT), LCM, CMC, CCM)Design Studio 1.2, Report Conversion Tool (RCT), Oracle 11g, Tomcat, Windows 2008 R2

Confidential, NJ

Sr. Business Objects Admin/ ETL Developer

Responsibilities:

• Interacted with Business Users to understand and document the requirements.
• Participated in designing and development of Reporting Application using Agile Development Practices.
• Creating the Universe with required classes and objects, and specified the hierarchies.
• Created simple to complex Webi reports
• Trained business users on tableau usage and functionality for ad hoc reporting needs.
• Knowledge in Tableau Administration Tool for Configuration, adding users, data connections, scheduling tasks by integrating with other platforms like SharePoint.
• Experience in implementing Data blending, Customized queries and advanced visualizations, and Action filters in Tableau.
• Managed scheduled and notification options for documents to the desired users.
• Involved in preparing reports for the project manager, these reports include routine reports such as status reports.
• Experience in Training & Supporting end-user reporting needs
• Administered Business Objects Enterprise using Central Management Console (CMC), Central Configuration Manager (CCM), and Publishing.
• Creating users and groups assigning the access levels.
• Designed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation
• Utilized Tableau server to publish and share the reports with the business users.
• Expertise in designing and developing the Tableau Visualization.
• Converted Crystal Reports to SSRS and also created new reports using SSRS.
• Extracted data from flat file sources and loaded it into SQL Server.
• Created Agent Job and Scheduled the Driver Package based on client requirements.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation
• Monitoring the day to day activities on the servers.
• Involved in helpdesk support for resolving user issues

Environment: Business Objects XI 3.1 (Designer, Web Intelligence, LCM, CMC, CCM), Live Office, MS BI (SSIS), SQL Server 2008, SSIS 2008, Tomcat, Windows 2008

Confidential, IN

Sr. Business Objects Developer IN

Responsibilities:

• Requirements gathering from the business users to build the reporting application
• Migration of BO Enterprise 6.5.2 to BO Enterprise XI R2 and WebI 6.5.2 to Enterprise XI R2
• Upgrading Universes and Reports from BO Enterprise 6.5.2 to BO Enterprise XI R2 and WebI 6.5.2 to Enterprise XI R2.
• Expert in defining and documenting best practices for Tableau report development.
• Designed and developed Universe against AQR Data Mart and Data Warehouse
• Administration of Business Objects Enterprise using Central Management Console (CMC), Central Configuration Manager (CCM) and Publishing
• Used Import wizard to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to BO XI environment.
• Trained business users on tableau usage and functionality for ad hoc reporting needs.
• Knowledge in Tableau Administration Tool for Configuration, adding users, data connections, scheduling tasks by integrating with other platforms like SharePoint.
• Experience in implementing Data blending, Customized queries and advanced visualizations, and Action filters in Tableau.
• Expert in connecting to varied data sources including Oracle 11g, DB2 and Excel.
• Created Reports using various Data Providers using Business Objects XI R2/6.5
• Involved in migration and deployment of the universes and reports across multiple domains
• Developed Reports using Desktop Intelligence and WebI
• Expert in developing dashboards, charts, pivots in Tableau Desktop.
• BOBJ SDK used for customization BOBJ reports access through portal.
• Extensively used report conversion tool for converting desktop reports to web intelligence reports.
• Created Derived Tables for report generation.
• Wrote stored procedures using SQL, PL/SQL, to be used in Reports development.
• Interaction with users in analyzing requirements for report development and also involved in helpdesk support for resolving the user issues

Environment: Business Objects 6.5.2/BO XIR2 (Supervisor, Designer, Reporter, CCM, CMC, Desktop Intelligence, Import Wizard, WebI 6.5.2/XI R2, SDK, InfoView), PL/SQL, Oracle 10g, Erwin, TOAD, IIS, Tomcat, Apache, Windows 2003

Confidential, WA

Sr. Business Objects Developer

Responsibilities:

• Installation and upgrading Business Objects Client and Server Products from BO v5.1.8 to BO v 6.5.2
• Requirements gathering from business users to build the reporting application and training them on Universes and generating reports
• Used Universes as source for the Business Objects reporting and analysis
• Developed new reports based on Business Requirements
• Scheduling and distributing documents through Broad Cast Agent
• Designed and Developed Technical User Documentation and involved in training the end users
• Involved in migration and deployment of the universes and reports across multiple domains
• Resolving loops using contexts and aliases to remove the cyclic dependencies
• Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, @Functions, etc
• Responsible for attend the tickets - analyze, fixing them within the specified time limits

Environment: Business Objects 5.1.8/6.5.2 (Supervisor, Designer, Reporter), WebI 2.7/6.5.2, InfoViewOracle 9.1, ASP, TOAD, IIS, Windows 2003

Confidential, CO

Business Objects / ETL Developer

Responsibilities:

• Designed and developed Universes for reports generation
• Created Users and Users Groups and assigned profile to Users using Supervisor
• Used Broadcast Agent Publisher for Report Bursting, so that each individual receives only his particular information in Excel format
• Developed mappings using different transformations to transform the data and load it to Target Database
• Created and configured Sessions to load the data from source to target database using Server Manager
• Maintained stored definitions, transformation rules and targets definitions using Informatica Repository manager
• Created the batches to run several sessions sequentially and concurrently
• Created Dash Boards using Application Foundation and made the environment an End User friendly interface

Environment: Business Objects 5.1.3, Broadcast Agent Publisher, WebI 2.6 (Reporter, Explorer, InfoView), Oracle 8.1, WebLogic Application Server, PL/SQL, UDB, Informatica Power Center 7.1, Windows 2000

Confidential

Programmer/Analyst

Responsibilities:

• Created the mappings according to the design documents.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.
• Created workflows.

Environment: Informatica 6 .1, Oracle 9i, PLSQL, HP UNIX.