PROFESSIONAL SUMMARY:

• Over 9 years of extensive experience in Report design, Dashboard development, data quality testing, Quality Assurance and Testing of Software applications.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Experience in SAP BO Full Life cycle implementations on different modules.
• Proven ability to deliver and ensure success in high - pressure/high-risk situations.
• Involved in many aspects of the SDLC including requirements gathering, proof of concept delivery, implementation, user support and maintenance.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created incremental refreshes for data sources on Tableau server.
• Worked on moving Tableau Dashboard from Development to Production Live Environment.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards in Tableau.
• Experienced in all activities of full life cycle implementation including Project management, requirement analysis, Data Modelling, Design, Specification development, Reporting, Web publishing, Portal integration, Performance tuning, testing, Documentation and maintenance in BO
• With Strong Knowledge in all phases of Software Development Life Cycle (SDLC) of BO such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/98.
• Business analyst experience interacting with end users, functional/technical experts and management toidentifying, analyse and developing the reports that meet the business needs.
• Strong knowledge of business/process data flow in organizations and experienced in data modelling Concepts.
• Hands of experience on Information Design Tool for Creating BICS Connection, Business Layer, Data foundation Layer in SAP BO 4.0/4.1
• Hand of experience on Universe Design Tool for Creating Universe.
• Extensively worked on development of Web Intelligence, Desktop Intelligence Reports.
• Hands on experience writing SQL Queries.
• Experience in SAP BO upgrade strategy, project planning, landscape design, test strategy and execution.
• Good knowledge on troubleshooting and problem solving skills.
• Excellent communication, interpersonal and analytical skills with ability to manage and work effectively to Meet deadlines in fast paced environment.

TECHNICAL SKILLS:

Operating Systems: Windows 9x/NT/2003/2008,UNIX

Languages: C, PL/SQL

RDBMS: Oracle 8i/9i/10g/11g, MS SQL Server 7.0/2000/2005, MS Access 2000Visualization Tools: Tableau 8.1/8.0/7.0/6.0

OLAP Tools: Business Objects 4.1/4.0/ XI 3.1/ 6.X, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, CMC,CCM,LCM,Promotion Management Performance Management, Report Conversion tool, Import Wizard, Publishing Wizard, Upgrade Management Tool

BI Tools: SAP BW 7.0, BODS

Other Tools: Toad, Putty, Sub Version

Rational Tools: Clear Case Explorer

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr Tableau Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports and reports with advanced features such asconditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Responsible for developing provisioning reports for various groups and upper management.
• Created Complex Dashboard, Reports using WEBI having multiple metrics and trends and created Hyperlinks for each of the Metric to open a detail report using Open Documents
• Experience on writing SQL Queries.
• Experience on BW Analyzer & Query Designer.
• Strong verbal and written communication skills, ability to work effectively with user departments.
• Worked towards the goals of quality, time and budget.

Environment: Desktop OS: Win2000 Professional, Server OS: Windows 2003/2008; MS SQL Server 8.0/2005,XML, Tableau 8.1/7.0,SAP Business Objects 4.1/4.0, IDT, UDT, WEBI BI: SAP BW Query Designer, Analyzer

Confidential, CA

Tableau Specialist

Responsibilities:

• Defined best practices for Tableau report development.
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, Ipad)
• Created calculated fields using Tableau for implementation of color coding and proper aggregations for data coming from SAP BW
• Created extensive joins for data blending from several different data sources
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps,
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau Desktop
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server based Tableau dashboards with automatic updates.
• Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• Created several dashboards with various chart types such as stacked bar charts, scatter plots, heat maps, and text tables that demonstrated insightful trends over a period of time.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Tested Dashboard for data accuracy and Functionality.
• Migrated Reports & Universes from Development to Testing and to Production Environment using Import Wizard.

Environment: Tableau 6.0, Business Objects 3.1, Universe Designer, Oracle 9i, Unix, SAP BW 7.0

Confidential

Business Objects Developer

Responsibilities:

• Directly coordinating with user to gather the new requirements and working with existing issues.
• Generated Cross Tab, Charts & Vertical Business Objects Reports using Web Intelligence Rich Client Using Universe.
• Migrated & upgraded Business Objects from 6.5 to 3.1 Using Import Wizard.
• Designed Universes for Financial Billing system and Order processing
• Created Objects and prepared Reports like financial reports, HR reports, standard and adhoc reports, and Universes.
• Involved in joining the tables by creating aliases to resolve the loop
• Created Reports based on subtotal of Currency and General Ledger category
• Created many reports according to the investment deals, facility and outstanding to know the exact amount of net investment in each deals
• Prepared month-end reports for General Ledger, Net Investment, Interest, Fees and Incomes
• Prepared reports for deals, facility and outstanding for the information of expiry date and effective date f each category
• Prepared report for CIT Net Investment Trial Balance
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Perform unit testing, system testing and user acceptances test (UAT) for universe, reports and securitymanagement.
• Created Charts Visualizations using SAP Business Objects Explorer.
• Developed universe user documentation guide for the end users .
• Tested Universe and Developed BO Reports for data accuracy and format specifications given by the client.
• Prepared Unit test cases for all Developed BO Reports and Universes and Capture the Bug and fix them.
• Successfully Migrated Developed Reports from Development Environment to Testing Environment and nce testing is done then moved them to Production Environment using Import Wizard.
• Taking the Backup of Existing BO Reports and Universe using Import Wizard.
• Worked on Informatica, and used functions like lookup, date, conversions, etc in Mappings.
• Responsible for creating mapping and transformation specifications based on the business requirements from various business teams.
• Used Merge, Merge Join, Union All, Derived Column, Audit etc for transformations & to add columns with lineage metadata and other operational audit data.

Environment: Business Objects 3.1/6.5, Import Wizard, Report Conversion Tool, Web-Intelligence, Desktop-Intelligence, Designer, Info View, SQL Server2000,TSQL, SQL, PL/SQL Windows 2003.Informatica.

Confidential

Business Objects Developer

Responsibilities:

• Published reports in Business Objects Enterprise XI R2 using Central Management Console and Publishing Wizard.
• Assigned Scheduling Rights as per the User Requirements
• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management
• Work with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Work with production team to coordinate and assist in rollout of releases.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Worked with BO support in troubleshooting issues and provide logs as per request for resolving several complex issues
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Provided solutions to various groups for scheduling reports using Packages and event based job scheduling.
• Co-ordinating with various groups in scheduling releases between environments.
• Deployment of Crystal Reports via various methodologies Central Management Console(CMC), Publishing Wizard, Infoview, Import Wizard.
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Experience on Developing Crystal Reports.
• Daily reporting to Management on status, issues, migrations, escalations and progress.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Assist with website deployment architecture (e.g. web servers, databases etc.) and code optimization.
• Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.
• Experience managing user accounts and group accounts in Crystal enterprise environment.
• Used Clear case Explorer to Take Backup of Webi Reports and Universe.

Environment: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, Windows 2k3/2k, Universe Designer, Web Intelligence. Oracle 10g, Clear case

Confidential

Business Objects Developer

Responsibilities:

• Used multiple sub reports, pass through parameters and pass by parameter linking for generatingcomplex reports for management.
• Work with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationshipbetween objects.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit
• Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Monitoring Scheduling Reports
• Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.

Environment: Business Objects 3.1, Universe Designer, Web Intelligence. Oracle 10g