SUMMARY

• Over 8+ 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 to identifying, 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

Reporting Tools: Tableau 8.0/7.0, SAS, SSRS, Crystal Reports 9.0/8.5,OLAP

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, Warren, NJ

Tableau Developer/BI Consultant

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Installed tableau servers on AWS cloud.
• Understanding of AWS pricing model and providing AWS cost optimization techniques.
• Implement and manage continuous delivery systems and methodologies on AWS
• Understand, implement, and automate security controls, governance processes, and compliance validation
• Define and deploy monitoring, metrics, and logging systems on AWS.
• Implement systems that are highly available, scalable, and self-healing on the AWS platform
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• 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 KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.
• Experience in development of MDX queries to extract and modify the data from Multi Dimensional data sources (Cubes).
• Had an experience in leading a small team and Knowledge in Medical Information domain ( Health Insurance and Clinical Data concepts and terminology).
• Having a experience with Big Data ( about 4 millions of rows).

Environment: Tableau Desktop 8.1, Tableau server / Administrator, Hyperion IR, SQL developer.

Confidential, Concord, California

Tableau Developer

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.
• Built complex formulas in Tableau for various business calculations
• 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 7.0, Business Objects 3.1, Universe Designer, Oracle 9i, Unix, SAP BW 7.0

Confidential, NYC

Reporting Developer - Tableau

Responsibilities:

• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Resolved various performance issues and analyzed the best process distribution for different projects.
• 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 on several complex visualizations that all had to do with improving the programs offered to various schools in NYC.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS)/DBA, Oracle 11g, Toad, MS Office, Team Foundation Server, Visual Studio 2010, WCF web service

Confidential, Richmond, Virginia

Tableau Developer

Responsibilities:

• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
• In charge of the team that build tableau architecture and dashboards using Tableau desktop, Tableau Server and Tableau Online.
• Working with User for requirements and part of the team developing the software.
• Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server
• Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ) and Measure
• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
• Created Web Intelligence Ad-hoc and canned reports in 3.1.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Troubleshoot issues with existing reports in the production environment.
• Created Views, Stored Procedures and validated data for the Performance.
• Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, stored procedures, business views.
• Experienced in developing Dashboards using Xcelsius 2008.
• Provided daily production support and administration of portal operations, such as problem resolution.
• Worked closely with Data Modelers in designing various data warehouse schema techniques
• Create complex reports against SAP BEx Queries.
• Created the reports on the web by using Web intelligence .
• Worked on the data provider that forms the basis of the ad-hoc analysis

Environment: Tableau 7.0 (Desktop and Server), BusinessObjectsXIR3, Designer, Crystal Reports, Xcelsius, Web Intelligence, Info view, Oracle 10g, SQL Server 2008, Windows 2003Server, .NET and Java based Applications.

Confidential

SQL BI Developer

Responsibilities:

• Directly interacting with clients to elicit the requirements and translate them into terms that development team can comprehend.
• Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLEDB Sources, Excel Spreadsheet, text files into Data Warehouse.
• Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
• Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Created star schema in SSAS and developed SSRS reports based on the cube.
• Facilitate User Acceptance Testing (UAT) and production rollouts, and the defects detected were tracked and managed using HP Quality Center.
• Produced reporting documents and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that had to be met.
• Involved in maintaining and updating database objects like tables, views, procedures, functions using basic SQL queries to provide definition, structure, and to maintain data efficiently.
• Assist BAs in the team with appropriate documentation and domain knowledge.
• Perform data modeling, periodic report validation and data analysis by writing SQL queries using TOAD.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in writing queries for stored procedures, clustered and non-clustered indexes.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Environment: SQL Server 05/08, MS Office, MS Excel, MS SQL Server 2005 Management Studio, Windows XP Server.