SUMMARY

• 6+ years of working experience as Tableau Developer, DataModeler, Data& Business Analystwith high proficiency in Dashboard reporting, requirement gathering, Datamodeling including design and support of various applications in OLTP,DataWarehousing, OLAP and ETL.
• Strong experience inDataAnalysis,DataMigration,DataCleansing, Transformation, DataImport, andDataExport through the use of various ETL tools such as Informatica.
• Hands on Experience in development of Reports and Dashboard in Tableau. Working Experience in design and development of Tableau visualization solutions.
• Use Tableau Desktop to analyse and obtain insights into large data sets.
• Proficient in developing security metrics program and creating Tableau dashboards and various visuals in Tableau.
• Created Parameters to achieve desired functionality and create risk metric analysis by coordinating with users.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter and calculations.
• Experience in testing and writing SQL & PL/SQL Queries, Stored Procedures, Functions, Triggers and Packages.
• Excellence in delivering Quality Conceptual, Logical and PhysicalDataModels for Multiple projects involving various Enterprise Applications.
• Hands on experience in business process engineering and all phases of SDLC (software development life cycle) involving Requirement Analysis, Software design, development, implementation, testing, maintenance and Object Oriented Design (UML).
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complexdatamanipulations.
• Advanced metrics presentation skills including attention to detail, consistency andappearance. Good knowledge on decision - making skills on complex /ambiguous metrics related information.
• Responsible for developing, analyzing and reporting key risk indicator and keyperformance indicator metrics that enable management to make timely and effectivedecisions related to threats, risks and control requirements.
• Advanced Excel, Modeling, Data Manipulation skills and chart creation, creativity, and visual representation of data.
• An excellent team player to work under time constraints and technically strong person who has the capability to work with business users, project managers, team leads, architects and peers.

TECHNICAL SKILLS

BI Reporting Tools: Tableau Suite of Tools 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.

ETL Tools: Informatica, Datastage, Talend

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, R language

PROFESSIONAL EXPERIENCE

Confidential, Uniondale, NY

Sr Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within TableauDesktop.
• Created views in TableauDesktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableauserver.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel.
• Blended the data from multiple databases into one report by selecting primary key's from each database for data validation.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• 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 TableauDesktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in TableauDesktop and published them on to TableauServer, 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 TableauServer 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:TableauDesktop 7/8/9,TableauServer,TableauPublic, MS Office Suite, Oracle SQL Server R2, MS Excel, MS Access.
• Responsibilities:
• Gather and analyze the business requirements and then translate them to technical specifications
• Building and publishing customized interactive reports and dashboards reports in the tableau server
• Created parameters, quick filters, context filters and sets to display top products based on their sale, profits, quantity order and shipping cost
• Experience in configuring reports from different data sources using data blending
• Implemented geographic maps and use custom images and also geo coding for the data view
• Experience in creating different visualizations using bars, lines and pies, maps, scatter plots, Gantts, packet bubbles, bullets, heat maps and highlight tables
• Extensively worked on creating actions, calculated fields and calculated tables for preparing dashboards and worksheets in Tableau
• Created report schedules on Tableau server.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Installed & Configured Tableau on Windows servers.
• Excellent experience and expertise in creatingTableauWorkbook's, Publishing workbooks and Dashboard.
• Findefficientways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Responsible for Developing aDashboard.
• Working knowledge onTableau Server / Administration.

Environment: s: Tableau Desktop 7.0, Tableau Server, MS Excel, MS SQL Server 2005, MS SQL Server 2008, TSQL, UNIX, Linux RHEL 5.4.

Confidential, Auburn Hills, MI

Tableau Developer

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications
• Building and publishing customized interactive reports and dashboards reports in the tableau server
• Created parameters, quick filters, context filters and sets to display top products based on their sale, profits, quantity order and shipping cost
• Experience in configuring reports from different data sources using data blending
• Implemented geographic maps and use custom images and also geo coding for the data view
• Experience in creating different visualizations using bars, lines and pies, maps, scatter plots, Gantts, packet bubbles, bullets, heat maps and highlight tables
• Extensively worked on creating actions, calculated fields and calculated tables for preparing dashboards and worksheets in Tableau
• Created report schedules on Tableau server.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Installed & Configured Tableau on Windows servers.
• Excellent experience and expertise in creatingTableauWorkbook's, Publishing workbooks and Dashboard.
• Findefficientways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Responsible for Developing aDashboard.
• Working knowledge onTableau Server / Administration.

Environment: s: Tableau Desktop 7.0, Tableau Server, MS Excel, MS SQL Server 2005, MS SQL Server 2008, TSQL, UNIX, Linux RHEL 5.4.

Confidential, Boca Raton, FL

Tableau Developer

Responsibilities:

• Experience with the design and development of Tableau visualization solutions.
• Deep experience with the design and development of Tableau visualization solutions.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Migrated existing Micro strategy Reports to Tableau workbooks.
• Created Tableau extract files for improving the performance.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Installed and upgraded Tableau server and experienced in server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extracting data from different sources connecting them and used the same to create dashboard
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Created data blending in case of merging two different datasets.
• Interacted professionally with a diverse group including executives, managers.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, MS SQL Server and MS Excel.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Responsible for Developing a Dashboard.

Environment: Tableau Desktop 9.0, 8.0, 7.0, 6.02, Tableau server / Administrator, Oracle 10g, Microsoft Excel 2007, MS Access, Microsoft office 2007.

Confidential, Plano, TX

Tableau Developer / SQL BI Developer

Responsibilities:

• Created stored procedure using nodes method to load XML file data into SQL server tables.
• Wrote User defined functions, views, trigger, and indexes for various purposes based on the requirements.
• Rewrote poorly performance stored procedure, functions, triggers, views and indexes.
• Created reconsolidation reports for conversion purpose using various joins.
• Involved in reviewing business requirements and analyzing data sources form Excel/MySQL for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users using Tableau.
• Projected and forecasted future growth in terms of number of subscribers in various services by developing Area Maps to show details on which states were connected the most and publishing it on Tableau Server.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from MySQL, Oracle, SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• 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.
• Rewrote various business process and tested result in MS Excel using various functions and sub query with not exists.
• Involved in updating functional requirement document after development and created documentation for deployment team.

Environment: Windows, Tableau Desktop (Version 6.0.10 - Version 6.1.11), Tableau Server (Version6.0.10 - Version6.1.11), SAS, MS Office Suite, Oracle 10g, SQL Server, MS Excel, ERWIN, MS Excel.

Confidential

SQL Developer

Responsibilities:

• Analyzed available data from MS Excel, MS Access, and SQL server 2000/2005.
• Designed new database on SQL server 2008R2.
• Normalized the data, created different tables, views, indexes, triggers and efficient stored procedures and Functions.
• Checked Performance Tuning of the Database by optimizing the queries with modification in T-SQL queries. Normalized tables, established joins and created indexes wherever necessary.
• Building query execution plans and making sure each and every query is using appropriate indexes.
• Involved in backup and recovery strategies.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Monitoring MS SQL Server performance and network issues.
• Performance monitoring and tuning of SQL servers.
• Created tables and views.
• Maintained and tuned various data objects within the SQL Server Schema.
• Managing the use of disk space, memory & connections by monitoring.
• Involved in transferring old data from various sources like flat files, MS Access, and MS Excel into MS SQL Server 2000 using DTS Packages.
• Designed new SSIS packages to extract data from various sources, transformed it based on Business needs and loaded it to OLAP servers for further analysis.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert.
• Worked on developing Reports and managing reporting services.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Used Tableau to design Reports and Interactive Dashboards.
• Built complex formulas in Tableau for various business calculations.
• Created and assisted users in Tableau dashboard development.

Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition, T-SQL, MS Access, MSBI, MS Excel, & Windows 2003 server, TFS, Business Intelligence technologies like SSIS, SSRS, VSTS2008, BIDS, Tableau Desktop 6.1.