SUMMARY:

• Over 8 + years of IT experience in Business Intelligence, Data warehousing, Data architecture and Data Modelling. Experience including analysis, modelling, design and development of Tableau Reports and Dashboards for analytics
• Strong Knowledge and hands on experience of SDLC methodologies and Business Process Models (BPM) like Agile Modelling and Waterfall model.
• Experienced in Tableau Desktop 9x/10.x
• Involved in admin activities like publishing, creation of subscriptions, granting access to users, managing extracts and installations.
• Ability to analyse and dissect user requirements and build front - end BI applications according to specifications.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading Parameterized, Conditional, Table, Matrix, Chart, Ad-hoc and Sub Reports.
• Mastered in using Filters, sorts, groups and sets, reference lines, Bands and Boxes in different kinds of charts.
• In depth knowledge in Tableau advance analysis features like Actions, Calculations, Forecasting, Parameters and Trend Lines.
• Mastered the ability to design and deploy rich Graphic Visualizations Parameters using Tableau.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Aws Redshift Cloud by using SQl Workbench
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownership, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Practical understanding of the Data modelling (Dimensional & Relational) concepts like Star-Schema modeming, Snowflake Schema modelling, Fact and Dimension tables.
• Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005/2008 R2/2014/2016 Reporting Services (SSRS), SQL Server 2005/2008 R2/2014/2016 Integration Services (SSIS) and in SQL Server 2005/2008 R2/2014/2016 Analysis Services (SSAS) in Business Intelligence (BI).
• Been part in writing technical requirement documents and low-level design documents.
• Experienced in requirement gathering/analysis, design, development, testing and production support of reporting and analysis projects.
• Proficient in Oracle Database and UNIX Shell Scripting.
• Involved in Full Life Cycle Development of Reporting Projects includes Requirements
• Involved in Gathering/ analysis, Design, Development, Testing and Production rollover.

TECHNICAL SKILLS:

ETL tools:: SQL Loader, Informatica Power Centre 8.1, 7.1, 6.2.

BI Tools:: Tableau Desktop 10.x, Tableau Server, Tableau online, Tableau Public, Tableau Reader, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), SQL server Integrating Services (SSIS), Alteryx 11

Libraries: Python, Spark, Scala, Panda, Numpy, Scipy, Pydoop, PySpark

Databases: SQL server, Oracle 8i,9i,10g, Teradata, SAP hana, Redshift, hadoop

Data modelling: ER/Studio 3.5/4.0, Erwin 4.1

Languages: Python, PySpark, MS-SQL, MySQL, hive, HTML5, CS3, JavaScript and XML

Web Servers: Apache web server, Microsoft IIS 4.0, Jboss 6.4

OS: Windows XP/03/07/10, OS X, Linux/Unix

FrontEnd: Microsoft Project, Microsoft Office, Microsoft Excel Tools

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Tableau Developer

Responsibilities:

• Conversant in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test, implementation and report.
• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.
• Generated high detail-oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geocoding.
• Build from the ground up reliable infrastructure services in AWS to deliver highly scalable services.
• Developed various types of charts and graphs like donut charts, funnel charts, bar charts, line graphs, pie charts.
• Also, created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Blended data from multiple databases such as MS Excel and Oracle, SQL database by assigning primary key from each database.
• Configuration of AWS in built SNS/SQS setup for job scheduling
• Use parameters to give users control over certain values.
• Combine data sources by joining multiple tables and using data blending
• Responsible for dashboard design, look and feel and development.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPad, iPhones, and other smart mobile phones.
• Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Experienced MS BI Developer, specializing in designing, development, implementation and maintenance of Database and BI Applications using MS SQL Server 2012/R2/2008/2005 and MS BI Stack (SSIS, SSAS, and SSRS) and Tableau.
• Created Test Cases and documented the Test Results.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.

Environment: Tableau 8/9, Tableau Server, SQL Server 2008 R2, SSMS, MS Excel, Business Objects

Confidential, PA

Tableau Developer /BI consultant

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.0, 8.2and 8.1.
• Also, involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Report generation using SSRS and Excel services, Power BI and deployed them on SharePoint Server.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Reviewed Business requirements and prepared the dashboards as per the requirements.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Extracted data from different sources connecting them and used the same to create dashboard
• Modified the existing dashboard as per the user requirements. Used Tableau Desktop for creating different interactive views and dashboards.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization.
• Used Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Wrote UNIX and SQL scripts for pre-& post session processes and to automate daily loads.
• Performed unit test/integrated testing scenarios which were used to obtain the UAT's.
• Developed narratives that describe the technical process in business terms.
• Communicated on daily basis with stakeholders and clients on Tableau related activities.

Environment: Tableau 9.0, 8.1, 8.2, Teradata 13, Oracle 10g, Crystal Reports 2008, SSRS, SSIS,SSAS,MS Office Suite.

Confidential - Atlanta, GA

Tableau Developer /BI Consultant

Responsibilities:

• Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the report’s specifications document and report inventory.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Interacted with the existing database developers and DBA to understand the existing schema.
• Performed data preparation for tableau workbooks using Alteryx and Sandbox tables.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Prepared dashboards using calculation fields, parameters and Action Filters.
• Created visualizations for Polaris job usage report to know the number of jobs across all the divisions and regions.
• Developed dashboards to show survey, design, construction and information to field contractors
• Developed Construction Detail report, where all the construction information like nodes, footages and passages can be viewed all together.
• Created Hyper build report where we can get all the open tasks, estimated cost and jobs.
• Modified existing reports to remove duplicate footages for all construction reports.
• Created Polaris financial reports, forecasting reports, capital tracking reports.
• Implemented Row Level Security for all the divisions.
• Scheduled extract refresh for daily, weekly and monthly reports.
• Using the Tableau desktop for the dashboard development activities such as creating the calculations, calculated fields, hierarchies, filters, Actions, Defining the various indicators, gauges for the various KPIs and Measures with various charts and Graphs.
• Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Created customized and interactive Tableau dashboards using multiple data sources - Oracle, SQL Server, CSV files
• Worked with customers to define reporting needs and implement Tableau reports to satisfy needs
• Created custom database connections, join-tables as needed, create & manage Extract and Monitor Queries using SQuirreL SQL Client.
• Have always completed the committed story for the sprint while following Agile board.

Environment: Tableau Server 10.2, 10.4, 2018.1, Tableau Desktop 10.2, 10.4, 2018.1, MS SQL Server 17.4, Oracle 10g, MS VISIO, Microsoft Office Suite, Alteryx 11.7.4.

Confidential - Eatontown, NJ

Tableau Developer

Responsibilities:

• Researched existing systems and processes for report generation, developed / documented business requirements and held meetings with Investment teams (Primary, Secondary, Private Credit, etc) to complete the development schedule.
• Designed and developed Summary/ Aggregate tables using procedures and views from SQL Server
• Designed, developed and published customized interactive reports /dashboards and scheduled data refreshes for reports on Tableau Online.
• Created Adhoc reports to users in Tableau by connecting to excel sheet, flat files, and CSV files.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending feature in Tableau.
• Provided guidance and insight on data visualization and dashboard design best practices for Tableau report development
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data.
• Developed and reviewed SQL queries with use of joins clauses in Tableau Desktop to validate static and dynamic data for data validation.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Technical oversight of the entire Tableau Online infrastructure from user setup to performance tuning.
• Performance tuning of workbooks, data sources, and providing best practices for user community
• Provided production support for Tableau users.

Environment: Tableau (Desktop/Online) 10.x, Microsoft SQL Server, JIRA, Informatica, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential

Tableau Developer

Responsibilities:

• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Wrote SQL queries for producing data for reports.
• Analysis of Key Performance Indicators (KPI's) from two main information systems: Procurement (ADPICS) and Finances (FRM).
• Designed and developed two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Published 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.
• Conducting user trainings on interact, filter, sort and customize views on an existing visualization generated through 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.
• Participated in preparing detailed technical documents from the functional specifications.
• Involved a key member in development of E-R modelling (Logical design) of database incorporating business logic and user requirement.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• 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.

Environment: Tableau, SQL Server, T-SQL, SQL Server Management Studio, Microsoft Excel.

Confidential

SQL Developer

Responsibilities:

• Requirement gathering and assisting business analysts in creating use cases.
• Communicated the development effort and delivery dates to the client.
• Created different types of reports like cross-tab, master-detail report and charts for trend analysis to cater the need of business analysts.
• Created ad-hoc reports using SAP BO in developing Parameterized, Drill Down, Drill Through,
• Chart, Graph, Linked, Dashboard, Scorecards, Drill-down and Drill-through reports.
• Excellent experience in writing SQL queries, dynamic queries, ad-hoc reports, data scrubbing and massaging, imports, exports, data verification, validation.
• Expertise in Business requirement gathering to Actual Deliverable encompassing entire cycle of Blue print / Design / Implement / Maintain.
• Worked on creating dashboards in finding the right balance between manipulating data using Tableau versus using a programming language.
• Experience in handling Client Relationships.
• Decisive professional with strong troubleshooting and management skills.

Environment: Tableau, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel