SUMMARY

• Experienced Data Analyst and Tableau Visualization Developer wif 8+ 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
• Training 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 training.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for developing Business Dashboards, reports, scorecards.
• Experience in creating variance reports, financial reports, drill through, and other common type of reports
• Experience in creating Databases, Tables, Stored Procedures, Views, DDL/DML Triggers, Cursors, User defined data types, Indexes using SQL.
• Experience wif analytic tools such as MSBI SSAS, R, SQL and Visualization tools such as Tableau, Qlikview.
• Deep understanding of key business applications as primary sources of data for presentation and data layer application solutions
• Experience in Data Conversion and Data Migration across different databases like Oracle, SQL Server, MS access and flat files.
• Built and expanded reports available for both internal support and external customer/carrier reports, which included increasing teh scope of data extracted and utilized for reporting purposes
• Created numerous ad - hoc analysis, dashboards, reports, graphs, and charts
• Experience wif analysis, data, databases, and business intelligence
• Hands on wif mashups, pivot tables, and lists, bar graphs, line graphs, box and whisker plots, tree maps, scatterplots, histograms, Pareto charts, control charts, small multiples, spark lines, and network paths
• Excellent in applying Actions and Quick Filters
• Expertise in Data Warehouse development working wif Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Data Integrator wif DB2 UDB, Oracle, and SQL Server.
• 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).
• Strong knowledge on ITIL framework along wif teh implementation of best ITIL practices using Industry leading ITSM tools. Outstanding knowledge on Incident Management, Change Management, Problem Management and Production Support engagements

TECHNICAL SKILLS

ETL/BI Reporting Tools: Tableau Suite of Tools 9.x,8.1, 8.0. 7, 6, 5.1 which includes Desktop, Server, online and Public and Administration of Tableau Server and SAP Business Objects XI R2, XIR3,OLAP cubes.

Databases: MS SQL Server 2000/20 R2/2012, MS Access 2000, Teradata,Oracle 11g/10g/9i/8i/8.0.

Programming Languages: SQL, TSQL,PL/SQL, Java, C and C++

Operating Systems: UNIX, Linux, Ubuntu and Windows

Application Servers: WebLogic, WebSphere

Web Services & XML: SOAP, WSDL, XML, and XSLT, Amazon web services(AWS)

Scripting Language: JavaScript, JQuery, Shell

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Sr. Tableau Developer

Responsibilities:

• Responsible for interaction wif business stake holders, gathering requirements and managing teh delivery.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Used Sheet filters to produce multiple chart types in a single view.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for teh different cost types.
• Found efficient ways to make tables and graphs which were visually easy to understand and at teh same time maintaining teh accuracy of teh core information content.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Creating users, groups, projects, Data connections, settings as tableau administrator.
• Developed Dashboards using OLAP cubes.
• Ad-hoc ETL, Reports requirement runs.
• Extensive usage of Amazon web services(AWS) for connecting to teh data sources on cloud using Amazon redshift services
• Use of Java script for creating teh client side validations in teh web pages wif dashboards.
• Use of Java script for embedding teh dashboards on teh webpages.
• Involved in creating dashboards and reports in Tableau 8.1/9.0 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
• Analyzed user and business requirements attended periodic meetings for changes in teh application requirements and documents.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created visualization for logistics calculation and department spend analysis.
• Performed Parallel Testing or Production Testing, which ensures that teh new system will perform correctly in a production environment and interface correctly wif other production systems.
• Platform monitoring, availability and performance management, and service reporting (KPI)

Environment: Tableau Desktop 8.x/9.x, Tableau server / Administrator, SQL developer, SSIS,OLAP, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Confidential, Dallas, TX

Sr. Tableau Developer

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively wif 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.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Extensive use of Teradata Database to create teh Reports.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Used Teradata utilities fast load, multiload, tpump to load data
• Installed Tableau Server 9.0 in Dev, QA, UAT and Prod environments.
• Installed patches on teh server and documented upgrade plan from tableau 8.0 to 8.1
• 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.
• Create, customize & share interactive web dashboards in minutes wif simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along wif user acceptance test and data accuracy test.
• Access dashboards from any browser or tablet.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues wif DBA's, system performance wif System Architects.
• Use of Java script for creating teh client side validations in teh web pages wif dashboards.
• Involved in license management SLA's wif Tableau support.
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users
• Worked closely wif Change Management and Release Management during Production support activities.
• Use of Java script for embedding teh dashboards on teh webpages.

Environment: s: Tableau Desktop 8.0/7.0, Tableau server / Administrator, SQL developer, SSIS, OLAP, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Teradata, Windows 2007 server, Microsoft office 2007.

Confidential, Naperville, IL

Tableau Developer/Admin

Responsibilities:

• Upgraded tableau 7.0 to tableau 8.0, gatheird requirements, analyzed from raw data.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Mentoring and enabling team members to complete coding and testing assignments in coordination wif offshore teams.
• Develop, Organize, manage and maintain graphs, tables and document templates for teh efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Implement infographics and Dash boarding for data visualization.
• Interact professionally wif diverse group of professionals in teh organization including managers and executives.
• Experience in standardizing Tableau for shared service deployment.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• 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 wif Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in converting OBIEE content into Tableau BI content.
• Experience in providing Tableau server and tableau desktop training.
• Experience wif Teradata.
• Experienced wif trouble shoot of Teradata connection.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.

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

Confidential

BI Developer

Responsibilities:

• Interacted wif business process experts to gather requirements and provided guidance for teh Data Warehouse team in how to structure data for optimal use in Tableau
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS
• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.
• Created automated stored procedures for day end operations using SQL Server agent
• Created SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Extensive experiences in developing Normalization, Stored Procedures, Views, Triggers, ETL processes, relational database theory, N-Tier development. and Complex Queries on SQL Server 2000/2005/2008
• Used multiple transformations in SSIS to meet teh business requirements by extracting data from heterogeneous source systems, transform and finally load into teh Staging Data base
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS
• Published Dashboards onto Tableau Server and from their dashboard consumers would access teh reports.
• Created dashboards wif 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 teh data on teh fly wif teh 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 teh views and dashboards were displaying teh changed data accurately.
• Tested dashboards to ensure data was matching as per teh business requirements and if their were any changes in underlying data.
• Involved in license management SLA’s wif Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Participated in meetings, reviews, and user group discussions as well as communicating wif stakeholders and business groups.

Environment: Tableau 6.x, Tableau Server, 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, MS Excel, Weblogic Middleware, Apache Tomcat.

Confidential 

SQL BI Developer/Reports Analyst

Responsibilities:

• Dealt wif requirements gathering, analysis, design, development, change management, deployment and user training.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping teh 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 teh requested Reports.
• Written complex T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity.
• Set up ETL Jobs to run on a nightly basis into teh Data marts using SQL Server Agent.
• Designed new SSIS packages to transfer data between different servers and loading them into Databases.
• Involved in maintaining teh Error-Logging for teh SSIS packages.
• Participated in business discussions wif teh users and created requirements from which teh dashboard blue prints and graphic rich tableau dashboards are created.
• Designed interactive reports wif Sub-Reports, Drill Down, Drill Through, and Drop Down wif Filtering ability using SQL Server Reporting Services (SSRS).
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS.
• Developed new and modified existing SSIS packages to extract data from teh traditional databases.
• Provided Operational support on 24*7 basis for teh application.

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