SUMMARY:

• 9 + years of experience in software design, development, implementation and maintenance of BI tools and applications, data visualizations, data analysis and report development using Tableau, Power BI, SQL and Microsoft Business Intelligence Tools.
• Passionate individual with a multi - disciplinary background in analytics and programming to facilitate smart decision-making by analyzing colossal amount of data available.
• Experienced working with Tableau Desktop, Tableau Server, Tableau Reader and Tableau Mobile in various version of Tableau 18.1, 10.x, 9.x and 8.x and other BI technologies like Power BI, SSRS and Alteryx.
• Experience with Tableau API such as R, Python and Web data connector integration.
• Experienced in SQL Server/Oracle/Teradata Database Administration and Development for very large and complex databases such as, SQL Server 2012/2014, SQL 2008 R2, Oracle, DB, MYSQL, Netezza and Apache hive.
• Possess strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization to support application Developers.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin Power Designer 15, and Microsoft Visio.
• Proficient with design and development of various dashboards utilizing Tableau visualizations like bar graphs, scatter plots, pie charts, histograms, demographic visualizations, heat maps and highlight tables.
• Proficient in performance optimization and using best practices for developing reporting solutions in Tableau.
• Experienced in publishing and sharing workbooks, data sources with user filter to tableau server, setting schedules, subscriptions, authorization and permissions, scheduling incremental refresh extracts and updating server data that are using extracts.
• Experienced in Publishing Reports to Azure based Power BI services and scheduled subscriptions and used various sharing options (workspace, Content Pack, and Apps).
• Experienced in aggregating data and configuring reports from different data sources using data blending.
• Experienced in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting and Dashboard prompts
• Skilled in using ETL packages to apply control flow tasks (For Loop, For Each Loop, Execute SQL task), and data flow tasks using various transformations (Conditional Split, Data Conversion, Look up, Merge, Union all).
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in developing and extending OLAP Cubes, Dimensions, and data source view Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including the status.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server.

PROFESSIONAL EXPERIENCE:

Senior Tableau Developer

Confidential - Rochester, NY

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL
• Server for design, development, Performance testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views/reports 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 was broken into regions allowing business user to understand where we have most users vs. least users.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• 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 Trend Lines and changed the formatting of the dashboard.
• Created Bar charts and tableau Reports as per the business Requirement and created the own template by pulling the table or view from vector wise
• Gave permissions to specified Business users to access the Report.
• Replace the data sources by adding the flat table for improving the performance on tableau side.
• Publish the workbooks on QC and Production Server.
• Used Parameters and Calculation to build the report and Edit the Alias and Replace the References.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advance features of Tableau software like to link data from Actian Vector together on one dashboard and to filter data in multiple views at once.
• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• 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.

Environment: Tableau Desktop/Server 10.1, 10.3,10.5, Oracle, Python, Web data Connector, JIRA

Sr. Tableau Developer

Confidential - Pennington, NJ

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources coming from SQL Server, Oracle, and Excel.
• Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Defined best practices for Tableau report development and effectively used data blending feature in the tableau.
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Created different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heatmaps and Highlight tables
• Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, sets while dealing with huge volume of data.
• Used parameters and input controls to give users control over certain values.
• Created Data extracts for better performance of dashboards and accessing data offline.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Tested dashboards to ensure data was matching as per the business requirements and checked if there were any changes in underlying data.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the business change to ensure that the views and dashboards were displaying the changed data accurately.
• Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.
• Developed automated ETL packages using SSIS to routinely feed data into the staging area and prepare the data before loading into the data warehouse for generating reports.
• Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed.

Environment: Tableau (Desktop/Server) 10.x/9.x/8.x, Oracle 11i, TOAD, SQL Server, SQL BI Suite (SSIS), C#, Java API, Microsoft TFS, SharePoint, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint).

Senior Tableau Developer

Confidential - Yonkers, NY

Responsibilities:

• Worked on the requirement gathering for the reports.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic.
• Worked with Source System Subject Matter Expert (SME) to ensure that the extracts are properly mapped.
• Analyzed the requirements and their usage for different reporting purposes using Tableau and Power BI Visualization tools
• Analyzed the database tables and created database views based on the columns needed.
• Created several types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop, and Power BI to provide better data visualization.
• Experienced in generating diverse types of Reports like Ad-hoc reports, Dashboard reports, linked reports, Sub-reports, Parameterized reports, Drill-down and Drill-through reports by using T-SQL, and Tableau.
• Extensively used data blending, embed functionalities and customized geocoding in Tableau and Power BI.
• Developed dashboards, workbooks and data views depending upon the business requirements and published in Tableau Server.
• Created actions in worksheets and dashboards for interactivity and to compare data against different views.
• Experienced in performance tuning of reports in Tableau
• Extensive experience in creating dashboards using sets, calculations, parameters in Tableau.
• Developed and maintained multiple Power BI dashboards/reports and content packs
• Designed and modelled data sets with Power BI desktop based on measure and dimension requested by customer(user) and dashboard needs.
• Experienced in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines and generated on-demand and scheduled reports for business analysis or management decision using Tableau and Power BI.
• Developed effective and interactive Dashboards using Parameters and Actions. Created dataflow diagram and documented the whole data movement process.
• Executed and tested required queries and reports to optimize performance before publishing.
• Mentored business power users to create reports/dashboards using tableau desktop and Power BI.

Environment: SQL Server, Oracle 10i/11g, Tableau 9.2.4/9.3, Tableau Server 9.2.6, Power BI, C#, Excel, MS Access, Microsoft TFS

Sr. Tableau Developer/ Sr. Data Analyst

Confidential - Bellevue, WA

Responsibilities:

• Analyze complex business process/user stories and execute functional and data integrity test cases.
• Employ technical and functional knowledge of applications and enterprise standards to evaluate and resolve complex testing risks/issues and managed through resolution.
• Participate in Agile Methodology (Scrum) from requirements gathering to maintenance and monitoring progress.
• Liaise with BPMO, stakeholders and business partners to develop test strategies, end to end integration strategies and acceptance criteria.
• Function as a mentor/lead and provided training to less experienced staff and assist in designing and development of adhoc reports for all team members (onsite and offshore).
• Assess website performance to improve customer experience and insights.
• Utilize Big Data and Hadoop File System (HDFS); create Hive tables; load and analyze data using impala queries.
• Create SQL queries to process the data and generate data cubes for visualization. Implement schema extraction for Parquet and created External Hive Tables on top of CSV file formats.
• Execute query using Impala SQL, Spark SQL and use BI tools to run ad-hoc queries directly on Hadoop.
• Utilize Tableau to connect to Hive ODBC connector and generate daily reports of data. Created extensive Tableau reports and various interactive dashboards to publish on Tableau Server.
• Create strong dashboard designs utilizing familiarity with best practices around visualization and design.
• Deliver production support to Tableau users and write Custom SQL to support business requirements.
• Organize functional, regression testing efforts as well as coordinate with automation and business teams (UAT) and defined test strategies, test plans, test cycles and test execution timelines with effective collaboration across, project teams, vendors and business teams at all levels for planning, issue identification and resolution, risk mitigation and production implementation.
• Produce mapping documents for every mapping as well as Data Migration documents for smooth transfer of project from development to testing environment and then to production environment.

Environment: Tableau (Desktop/Server) 10.x/9.x, Teradata, SQL Server, Oracle 12c/11g, Hive, Spark-SQL, Impala, Java API, Putty, Unix, Microsoft Office suite.

Tableau Developer/ Data Analyst

Confidential - Cincinnati, OH

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, quick filters, data source filters, global filters, context filters, actions, Hierarchies feature in tableau.
• Executed and tested required queries and reports before publishing.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Monitored the report performance and send the results to end users. Maintain reports in Tableau server and coordinate with Tableau admin for site user permissions and views.
• Implemented best practices and standards in developing Tableau reports. Integrated Tableau dashboards into internal web portal using Java Script API.
• Worked on the backend database development which was the source data for the tableau.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau server, allowing end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Environment: Tableau 8.x/7.0, Tableau Server 8.0/7.0, Oracle 10g, Oracle SQL Developer, JavaScript, SQL, Share Point, Agile-Scrum, Rally, Asp.Net, JavaScript.

Data visualization Consultant/Tableau Developer

Confidential - Cincinnati, OH

Responsibilities:

• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process
• Deep involvement with the design and advancement of Tableau visualization solutions.
• Extensive use of joins, blending, custom SQL, attributes, hierarchies, action filters, extract filters, data source filters, parameters, table calculations, LOD expressions, sets, groups, bins in Tableau Desktop.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Installed Tableau Server on premise and migrated the dashboards form vendor Tableau server to in house Tableau server.
• Establish and deploy Tableau Server architecture to support redundancy and scalability.
• Interacted with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Wrote API's to get data from the backend Tableau server for list of users, permissions, groups, group to user mapping, permission to group mapping, user to permission mapping.
• Configuring Users based on Active Directory and logged in through Run as User account
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons.
• Analyze the client requirement and review the change request, based on priority.
• Preparing Dashboards using calculations, parameters in Tableau and developing Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Access and change extremely large datasets through filtering, grouping, aggregation, and statistical calculation.
• Experience in standardizing Tableau for shared service deployment.
• Developed trend lines, statistics, log axes, groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Worked extensively on advance analysis actions, calculations, parameters, background images, maps.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to MS SQL directly and created the dimensions, hierarchies, and levels on Tableau desktop.
• Performed SQL reporting with the ability to create SQL views and wrote custom SQL queries.
• Connect to MS SQL directly and created the dimensions, hierarchies, and levels on Tableau desktop.
• Performed SQL reporting with the ability to create custom SQL queries.

Environment: Tableau (Desktop/Server), Teradata, SQL Server, Oracle 12c/11g, Hive, Spark-SQL, Impala, Java API, Putty, Unix, Microsoft Office suite.