SUMMARY:

• Experienced Data Analyst and Tableau Visualization Developer with 7+ years of experience in predictive modeling and data analysis, working on various projects for Retail Marketing, Finance and Retail Banking industries using MSBI, Tableau in Windows and UNIX environments.
• Data Visualization and Analytical professional experienced in using Tableau to:
• Analyze and obtain insights into large data sets, create visually compelling and actionable interactive reports and dashboards
• Define specification, design, and build of Tableau Desktop reports and dashboards
• Installation, set up and administration of Tableau Server designers, analysts and end users in Tableau Desktop and Tableau Server
• Experienced in Tableau Desktop, Tableau Server, Tableau Reader, Public and Mobile in various versions of Tableau 7, Tableau 8 and Tableau 9.x.
• Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Experience in Requirement Analysis, Gap Analysis, Change Management and Impact Analysis, Capacity planning, Proposal Development, Design validation, Technical leadership, and mentoring and user .
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for developing Business Dashboards, reports, scorecards.
• Experience in creating Databases, Tables, Stored Procedures, Views, DDL/DML Triggers, Cursors, User defined data types, Indexes using SQL.
• Experience with analytic tools such as MSBI SSAS, R, SQL and Visualization tools such as Tableau, Qlikview.
• Experience in Data Conversion and Data Migration across different databases like Oracle, SQL Server, MS access and flat files.
• Solid knowledge of On - Line Analytical Processing (OLAP), On-Line Transaction Processing (OLTP), and Software Development Life Cycle (SDLC).
• Excellent command on SQL SERVER 2014/2012/2008 , T-SQL and ORACLE PL/SQL Programming
• Hands on experience in SQL Server Integration Services (SSIS) package design, constructing, and deployment.
• Experienced in developing SSIS Packages, Stored Procedures, Views, Functions and Triggers using T-SQL (Transact-SQL).

TECHNICAL SKILLS:

Programming Languages: T-SQL, PL/SQL, Core Java, Shell Script, DQL.

Databases: MS SQL Server, MY SQL, Oracle, DB2, Teradata, Sybase.

Enterprise Tools: Tableau 9/8/7, SAS Enterprise Miner, Microsoft SSIS,SSRS, EMC Documentum Content Management, CA Technologies IT Service Management, TOAD, MS office, MS Visio, MS Project Management.

Data Modeling: Star Schema (ROLAP), Snow flake schema, CA Erwin.

Middleware: Oracle Weblogic 10/11g, IBM Websphere, Jboss.

PROFESSIONAL EXPERIENCE:

Tableau Consultant

Confidential, Hartford, CT

Responsibilities:

• Engaged with Senior Level Management to identify and collect enterprise requirements for implementing an analytic and data driven BI Solution.
• 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.
• Worked extensively with advanced 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.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Involved in creating dashboards and reports in Tableau 9.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.
• Lead a small team and gained Knowledge in Medical Information domain (Health Insurance and Clinical Data concepts and terminology).
• Identified key sizing and system design indicators to provide sustainable, high performing, and efficient Tableau Server solution against big data databases such as Hadoop.
• Created an architecture for Tableau Server implementation and lead project roll-out
• Lead departmental sessions to introduce power users to Tableau Desktop
• Created best practices for Tableau Dashboard design, created dashboards, KPI’s and user interface reports using Tableau
• Designed key business process dashboards for Claims Processing, Member Enrollment, and Call Center consists of over 100 Million rows

Environment: Tableau 9.0/9.1, Linux, Windows, MS SQL Server 2012, Oracle 10G, MS Outlook.

Sr. Tableau Developer

Confidential, Naperville, IL

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Conduct analyses of financial, demographic, behavioral, and economic data related to credit risk utilizing statistical modeling techniques such as linear, logistic and decision tree-based.
• 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.
• Lead functional, technical requirements and testing documentation for technical and functional users.
• Key Contributor in data model design.
• Extensively created and drafted Tableau Dashboards for Regional Marketing teams utilizing complex features such as Table Calculations and Out of the box dashboard actions for consumption via desktop and mobile.
• Responsible for best practice implementation of Tableau workbooks for Tableau 9.0 migration
• Planned and recommended data model designs suited best for Tableau needs.
• Created SSIS Packages for Incremental loading, Data Importing and Cleansing using SSIS 2012.
• Designed new SSIS packages to transfer data between different servers and loading them into Databases.
• Administered and created user, user groups, and scheduled instances as well as underlying security permissions in Tableau Server.
• Analyzed and communicated performance metrics to track business health and program effort.

Environment: Tableau 8.0, Microsoft SQL Server 2008 Enterprise Edition, SQL server 2012,MSBI SSIS 2012, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), Windows 7, Outlook.

Tableau Developer/Admin

Confidential, Dallas, TX

Responsibilities:

• Upgraded tableau 7.0 to tableau 8.0, gathered requirements, analyzed from raw data.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Expert in infographics and Dashboarding for data visualization.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Involved in customer strategies by grouping them into good or bad customers and high risk or low risk profile customers.
• 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.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• 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.
• Involved in license management SLA’s with Tableau support.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau server / Administrator, Tableau Desktop v6/v7, Windows Server Standard R2, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL.

BI Reports Developer

Confidential, New York City, NY

Responsibilities:

• Interacted with business process experts to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau
• Published Dashboards onto Tableau Server and from there dashboard consumers would choose viewing platform (laptop, iPad, other mobile devices)
• Created dashboards with Documentum dataset for following subject areas: Document Management, Personnel Administration.
• Created extensive joins for data blending from several different data sources
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Microsoft SQL Server 2008 Enterprise Edition, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), Windows 7, Red hat Linux, MS Outlook.

SQL BI Developer

Confidential, Albany, NY

Responsibilities:

• Dealt with requirements gathering, analysis, design, development, change management, deployment and user .
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing
• Wrote various stored procedures, Indexed views, dimensions and stored outlines for optimal performance.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Performed Data Analysis for automating various drugs related reports utilizing SQL Analysis Services.
• Designed, programmed, deployed and tested the requested Reports.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS2005.
• Reviewed application configuration to recommend best practice and tighter change management process.
• Installing Middleware Application servers such as Oracle Weblogic in to the Prod servers and creating managed servers, creating clusters.
• Deploying application code in to these servers and make sure the application is Up and running without any issues.
• Provided Operational support on 24*7 basis for the application.

Environment: MS SQL Server 2005, WebLogic Middleware Application, Unix, Windows NT server, Jenkins, SSRS 2005.

Content Management Analyst

Confidential, Albany, NY

Responsibilities:

• Interacted with business process experts to gather requirements and provided guidance for the Data team in how to structure data in Documentum.
• Created dashboards with data primarily coming from Documentum RDBMS and Oracle DB.
• Delivered successful solutions in the record time of three months, successfully created a DR environment and increased incident resolution to all time high of 95%.
• Team won the Delivery Excellence for the Q4 2013 resulting in more projects from the client billing worth of more than 6 Million $.
• Produced reporting documents and led weekly meetings with developing teams and business clients to discuss outstanding technical issues and deadlines that had to be met.
• Produced Dashboards and visual story boards highlighting the gap that’s needs to be addressed for speed document process and thus increased the productivity of the Clients application.
• Recreated existing dashboards using Tableau with added visual and interactive functionality such as drill-downs, actions, and links.
• Developed dashboards and reports highlighting the document misclassification and thus helped to reduce errors involved in document classifications.

Environment: Oracle 8.1, EMC Documentum, Unix, Windows NT server, Jenkins, Toad, PL/SQL, Windows XP.