SUMMARY:

• Around 9 years of experience as BI Developer, Design Extensive focus on Data Warehouse and Setting up MS BI, R, ETL, SQL Server / Databases Development and Staging Environments.
• 3.5+ years Tableau Developer, Tableau 10.5 to 9.1 developing and testing analytic and operational dashboards, Data Visualization, R - Programming Tableau Server Visual Analytics, BI, Power BI, Quick view, Qlik Sense, Architecture and Management.
• Involved in requirement gathering/analysis, Design, Development, Testing and Production of Reporting and Analytics projects, Data Warehouse, implementation and maintenance of client server applications, providing Business Intelligence and OLAP solutions to Health Care, Insurance and Banking Sectors.
• Collaborate with other Business Users / IT in converting the Business data requirements to Tableau Visualizations and dashboards.
• Working on 1 million rows and 500 GB of data size in BigQuery (Google BigQuery) Extract Schedule, weekly Extracts scheduling & authentication R-Programming.
• DB: Relational, Columnar, in-Memory DBMS; Multidimensional Cubes.
• Database replication, Alteryxfile & system cloning, remote boot, connecting to Excel, Text Files and Databases using Tableau, Good Understanding of Tableau architecture & Server side concepts.
• Ensure designed systems are highly reliable, self-recovering, and require little or no supporting manpower, self-learning on Hadoop /Tera data R, Python, Qlik Sense, and Elkview.
• Develop and follow established programming, data management, Change Management and SDLC processes and standards, including naming conventions, formatting and program structure
• Building Visual Analytics, Advance Chart/Graph Types using complex calculations. Led Sears’s migration from Tableau 9.0to Tableau 10.0 Self learning Tableau 2018.
• Authored Data Visualization Blog for Sears’s Information Analytics Team.
• Dashboards with Trends and Rate of Changes for members of Shop Your Way Program Optimized Tableau Workbooks for Targeted Interactions Analytics and Inventories.
• Improved performance of Operational Dashboards for Teradata-based Data Warehouse.
• Designed 30+ near-real-time monitoring Dashboards for Tableau Server.
• Optimized Data Extracts, Connections and data refreshes for corporate Tableau Server.
• Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions Microsoft .Net.
• Knowledge in Job Scheduling, Replication, Performance Tuning, Normalization / De-Normalization concepts, database design methodology.

TECHNICAL SKILLS:

BI Tools: Tableau, MSBI

ETL Tools: Microsoft SQL Server Integrated Services

Reporting Tools: Tableau 10.x/9.x/8.x/7.x, SSRS, Power BI

Database: SQL, Oracle, DB2, Teradata, SAS, T-SQL

Database GUI: Teradata, SQL Server, SQL assistant, SQL Developer, DB2

Methodologies: Waterfall, Agile

Programming Languages: SQL, Python, R, PL/SQL, HTML, Core Java

IDE’s: Eclipse, jGrasp, PyCharm, Dream weaver, Rational Rose

Framework: Hadoop, Django, Flask

Software Packages: Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential -Springfield, MA

Tableau Developer

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications
• Developing Tableau data visualization using Donut charts, Waterfall, Cross Map, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Dual axis, Triple axis, scorecards, dashboards using stack bars, scattered plots, Gantt charts and various other charts based on the business desired.
• Designing, developing, testing, and maintainingTableau reports and dashboards based on user requirements.
• Working closely with business in creating dashboards based on the data from various Data sources.
• Utilizing Tableau server to publish and share the reports with the business users.
• Collaborated with the security team to develop various Tableau services.
• Involved in upgrading Tableau Versions.
• By using Tableau Server, providing row level securities to different users to access dashboards.
• Distributing Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Creating New Schedule's and checking the task's daily on the server
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Extracting data from databases like SAS, DB2, SQL server and Excel files for getting data to Tableau for creating various dashboards.
• Creating Business requirement documents and plans for creating dashboards.
• Creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Expertise in understanding visual design principles like colour, layouts, and graphics.
• Providing customer support to Tableau users.
• Provide guidance to developers and team members on Tableau development, dashboard usability, user experience design and design best practices.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Strong report/dashboard design experience and passionate practitioner of effective data visualization.
• Implementing ETL best practices and optimizing ETL procedures so-as-to populate data warehouse schemas efficiently and reliably. Emphasis on reusability of ETL objects and procedures in-order-to facilitate ease of maintenance.
• Build various Excel power pivot reports for business users.
• Design & build SSIS ETL (Extract, Transform & Load) process load data from heterogeneous sources like DB2, flat files, SQL Server and to perform complex transformations to derive and load data in Dimension tables, granular and aggregated Fact tables for various SSRS and POWER VIEW, POWER BI reports.
• Implementing ETL best practices and optimizing ETL procedures so-as-to populate data warehouse schemas efficiently and reliably. Emphasis on reusability of ETL objects and procedures in-order-to facilitate ease of maintenance.
• Created multiple reports in SSRS and power BI/Pivot like:-
• Collection Effectiveness Report (to measure the effectiveness of existing collection process).
• Account Phases Report (to track the progress of customer accounts through various phases).
• MRC Final Resolution Report (to classify accounts after they are final/closed).
• Open Ails by date (to display Ails pending the longest).
• Ails 360 Snapshot by Account or Meter (Display all relevant information for Ail accounts or meter).
• Design packages to re-run from point of failure and implement custom error handling.
• Conduct code walkthroughs / peer code reviews to verify that code is scalable, easily maintainable and meets company programming conventions / standards.
• Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
• Developed data visualization reports and build dashboards using Microsoft Power BI
• Filter and Sorting Data using Power View in Excel 2013.
• Used Team Foundation Server (TFS) for version control, source control and reporting.
• Create a Calculated Column DAX Formula in Calculated Columns, Measures, and Row Filters.

Environment: Tableau Desktop 10, SQL Server 2008, SSIS, SSRS, Power BI, Excel, SAS, SQL Server, Salesforce, DB2, Excel, Access Database, CSV files, CDW, EDW, Windows 8.

Confidential - Seattle, WA

Tableau Developer

Responsibilities:

• Involved in gathering business requirements and designing functional Specifications for Tableau dashboards from Business users
• Created Maps to provide the count of providers in different geographic locations. Created drill down capability using the Action filters.
• Extracted raw data from an Oracle and used SAS to read it and run statistical analysis.
• Distributing Tableau reports using techniques like Packaged Workbooks, PDF to different user com-munity.
• Involved in identifying the gaps between Functional and Technical process and giving recommendations for the improvement of deliverable for the business users.
• Worked with business in gathering requirements from the existing reporting tool (Business Objects).
• Involved in preparing Functional Specifications, Technical Specifications, Testing Plans and other documentation as required by SDLC.
• Upgraded Tableau version 9.0 to Tableau version 9.1.
• Experienced with Tableau server infrastructure like publishing and row level securities.
• Creating dashboard from various data sources like Oracle, CSV and Excel files.
• Creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on analyzing the requirements and the sources data. Worked on mapping document to map the required columns from the data sources..
• Analyzed and created dashboards by using Business Objects.
• By using BO, created complex to simple hierarchical levels of reporting as per user requirements.
• Worked closely with the ETL team, to populate the data as per the reporting requirements.
• Providing customer support to Tableau users.
• Involved in writing complex queries using joins and sub-queries.
• Created SSIS packages to load the daily transactional data into the database.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets and Load them into various SQL server tables using different transformations.
• Worked with the business analysts, architects and project manager to understand the new requirements and enhancements.
• Created SQL Server Reports using SSRS .
• Identified the data source and defined them to build the data source views in SSAS to build the cubes.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services ( SSIS ).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Generated documentation of analysis, design, testing in all phases of development
• Working on the SSIS packages for new enhancements, fixes and development. Troubleshooting and managing the development solution provided by vendor.
• Support the existing data warehouse projects and carry out special requests to provide security for reports etc.

Environment: Tableau 9.0/9.1, SSIS, SSRS, SSAS, SAS, BO XI R4.1, SQL Server 2005, Excel, CSV files, Windows 8.

Confidential - Phoenix, AZ

Tableau Developer

Responsibilities:

• Created and implemented Tableau best-practices on migrating and governing the dashboards in multiple environments
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• 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 different connections 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.
• Involved in upgrading the Tableau server from 8.0 to 8.3 versions and involved in maintaining the server heath by regularly taking care of backup and cleanup activities.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, 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.
• Collaborated with .NET developers to integrate the dashboards with .NET Framework.
• 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 DB2 and MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Involved in the migration of OBIEE reports to Tableau and created better visualization in tableau as per the business requirements.
• 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/extract dynamic and static datasets.
• Hands on development of analytics dashboards and working with complex data sets.
• 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.
• By using Tableau server, providing row level securities to different users.
• Working on analyzing the existing BI infrastructure and coordinating with various teams to install and configure single node Tableau server environment.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau Server, Tableau Desktop 8.x, Oracle, DB2, Excel, OBIEE, Windows 2008 R2, .NET, Web API.

Confidential - New York City, NY

Tableau Developer

Responsibilities:

• Involved with Business Analysts team in requirements gathering and defined detailed Technical Specification documents.
• Involved in identifying the gaps between Functional and Technical process and giving recommendations for the improvement of deliverable for the business users.
• Analyzed and created dashboards by using Business Objects
• Translated business needs into data modelling initiatives.
• Developed visualizations using sets, Parameters, Dynamic sorting, Filtering, Parameter driven analysis.
• Used Tableau features like Data blending, Extracts, Parameters, Filters Calculations, Context Filters, Hierarchies and Actions Maps etc.
• Design and development of Tableau visualization solutions using operational dashboards.
• Expertise in understanding visual design principles like colour, layouts, and graphics.
• Created Relationships, actions, calculated fields, sorting, groupings, live connections, in-memory in both Tableau and Excel.
• Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.
• Created Tables, Views, Constraints, Indexes and developed Complex database objects including Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL with exception handling
• Used SQL extensively by using Joins, Sub Queries, Set Operations, and Advanced OLAP Functions.

Environment: Tableau Desktop, Tableau Server, DB2, MS Excel.

Confidential

Tableau Developer

Responsibilities:

• Supported, managed, and maintained organizational clinical data in company's SQL Server System
• Maintained patients' information on Clear Health & Aries database systems
• Responsible for weekly analysis of new data entered in system database
• Converted existing BO reports to Tableau Dashboard.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop Down menu option and Parameters using Tableau.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements
• Prepared user guides and training manuals for new users and current clients
• Acted as an In-House Business Analyst to facilitate teams of data and business analysts
• Handled Ad-hoc reporting and querying for staff data requests though SQL Server 2005, 2008 and 2012
• Initiated meeting as lead to understand and gather requirements and document processes
• Reported federal funding and grants on a periodical basis
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding aggregations to the Cube.

Environment: Tableau Server, Tableau Desktop9.0/9.1, Snowflake, MYSQL Server, Informatica 9.1, Excel, TSQL, UNIX, SQL

Confidential

Data Analyst / Tableau Developer

Responsibilities:

• Created SQL Queries for testing the Tableau Dashboards.
• Migrated excel sheet data in to sheet and published on tableau server.
• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Data blending implemented on databases and generated interactive dashboards.
• Created Adhoc reports to users in Tableau by connecting various data sources.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau Adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and reference lines.
• Generated tableau dashboards with combination charts for clear understanding.
• Performed the activities on production servers to deploy the changes made during the iteration.
• Coordinated with production support and DBA team in refreshing the existing Database instances from the production servers of the UI Screen.
• Involved on using MS Excel Formulas like Look Up, Conditional, Date and Time, Conversion, text to validate data.

Environment: SQL Server 2005 Enterprise Edition, MSBI, T-SQL, Enterprise manager, VBS