OVERVIEW:

Tableau Certified Consultant with around 7+ years of experience as Tableau Developer which includes Data Analysis, Dashboard development, Report & Design, Development and Implementation of BI/Data Warehousing, Web - based Applications and Database projects using Tableau, Micro Strategy, etc.

OBJECTIVE:

To use my business acumen, process thinking, and passion for data analytics and visualization glean key insights about their business, their customers, and their environment so that they can achieve their growth goals.

PROFESSIONAL SUMMARY:

• Expertise in designing and deploying data visualizations using Tableau Desktop.
• Created workbooks by importing data, and defining relationships (Excel, Oracle, MySQL).
• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
• Experience in working with complex SQL queries like Joins, Date functions, Inline functions and Sub-queries to generate reports.
• Excellent understanding of data warehouse specific Architecture, Design Procedures, ETL and workflow development, data cleansing and data quality validation.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Expertise in creating data contextualization and interactivity using a variety of actions.
• Defined best practices for Tableau report development.
• Created PowerPoint presentations for Business Analytics & Insights for Domestic and International Markets.
• Interacted with Strategic Development Teams, and Business analysts to analyze business needs and develop technical specifications to implement various BI solutions for Sales, Product and Customer KPIs.
• Expertise in latest BI Tools such as Spotfire, Qlikview and Qliksense.
• Experience in complex BI Reports, Dashboards, Project Management, Change management, and root cause analysis, Resolution methods, Time/Cost/Budget Management.
• Experience with sheet objects including advanced charts, creating metrics, Trend lines, attributes, filters, reports dashboards, Incremental Loading/Refresh, complex calculations to manipulate data.
• Using multiple measures like Individual Axes, Blended Axes and Dual Axes.
• Proficient in creating solution driven views and dashboards by developing different chart types including Heat maps, Geo maps, Symbol maps, Pie charts, Bubble charts, Funnel charts, Bar charts, Bullet graphs, Area charts, Scatter plots, etc.
• Created Master library with dimensions and measures and implemented security in BI Applications at Document and server level.
• Scheduling, authentication, and publishing workbook in the Tableau server. Developed applications in Tableau Desktop and shared the apps with the team using Tableau Public.
• Extensively built solution driven views and dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data using Tableau.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Experience in working with dirty data from various sources like SQL Server, Oracle, MS Access and Flat files etc., and performing data cleansing using ETL procedures.
• Involved in various stages of Software Development Life Cycle (SDLC) implementing Waterfall, Agile & Scrum.
• Expertise in Data warehousing concepts like OLTP/OLAP system study, analysis and E-R modelling, developing database schemas like Star schema and Snowflake schema used in relational, dimensional, multidimensional data modeling.
• Extensively worked on Informatica Power Center transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.
• Experience in developing and debugging Stored procedures and Triggers.
• Flexible, enthusiastic and project-oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS:

Tools: Tableau, MicroStrategy, TIBCO Spotfire, Informatica, IBM Rational Rose, DQ Analyzer, JIRA, SalesForce, MATLAB, SPSS, Minitab.

Databases: SQL Server, MS MySQL, MS Access, Oracle.

Languages: SQL, C programming, VHDL Programming, MATLAB, Python.

Operating System: Windows, iOS, MS DOS.

MS office: Outlook, Word, Excel, PowerPoint, MS Access, OneNote, Project.

PROFESSIONAL EXPERIENCE:

Data Visualization Specialist / Data analyst

Confidential, Austin, TX

Responsibilities:

• Extensive development of PoCs (Proof of Concepts) for the various KPIs (State Hospitals & Living Centers).
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow.
• Created Test Strategies (TS), and Test Plans (TP) and performed Functional testing, business requirement testing, data requirement testing and system integration testing.
• Prepared Quarterly Business Review Analysis for Medicaid and CHIP Services.
• Validated source data for accuracy and correctness at multiple levels to maintain data consistency.
• Converted, cleaned, analyzed, organized, and documented large data files (10,000 (for SH&LC) - 2 million records (Medicaid & CHIP)).
• Addressed the challenges to data integration, profiling the data for peculiar anomalies in the data source, and subsequently reworked the integration efforts.
• Coordinated with subject matter expert to evaluate, and track project objective, and business requirements, and suggested possible solutions and improvement strategies to address the data quality issues.
• Assigned tasks to all Testing Team members and ensured that all of them have sufficient work in the project.
• Ensured content and structure of all Testing documents / artifacts is documented and maintained.
• Used 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 Table Calculations, Conditions and Filters for various analytical reports and dashboards.
• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.
• Used SQL tools like Toad, Pl/SQL to run SQL queries and validate the data in the warehouse and datamarts.
• Developed and ran custom queries to return Centralized Accounting and Payroll/Personnel System (CAPPS) data on Oracle SQL Server.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Key advisor on performance indicators using SQL scripts, on multiple projects, giving expert guidance on reporting techniques, project management, and performance improvement.
• Used Performance recording on Desktop and on Tableau Server and Tuned the Performance of Dashboards.
• Provided UAT assistance and post implementation production support.

Environment: Oracle, Informatica, Tableau 2019.1, Tableau Prep Builder 2019.1, MS Visio, MS Access, MS Excel.

Senior Tableau Developer / Data analyst

Confidential, New Providence, NJ

Responsibilities:

• Evaluated Provider level data to assess provider data quality, and built data quality reports using DQ analyzer, SQL server, MS Excel.
• Re-created groups from different fields in the Data pane. Re-combined related members in a field and created new dimensions and measures for easier analysis and testing.
• Assessed the data quality and consistency within each provider file and built a ranked list of different types of relationships that establish unique providers.
• Identified other data sources that can enrich the relationship quality scores and documented them.
• Performed data extraction from Microsoft SQL server Relational Database.
• Coordinated with subject matter expert to evaluate, and track project objective, and business requirements, and suggested possible solutions and improvement strategies to address the data quality issues.
• Used Context filters and created Geographic map reports which explained company financial keys according to the members.
• Responsibilities included extraction, cleansing, joining and analyzing data using SQL queries, Excel Marcos.
• Drafted analysis documents and frameworks for future .
• Visualized data built presentable dashboards and stories on tableau and presented it to a team of experts.
• Liaison for project managers, managers, directors, and stakeholders.
• Created Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables, Informatica mappings to improve the performance of Tableau reports/Dashboards.

Environment: SQL Server, DQ Analyzer, Tableau, JIRA, MS Access, MS Excel, Teradata, Oracle.

Tableau Developer / Data Analyst

Confidential, New York, NY

Responsibilities:

• Worked on Tableau workbooks from multiple data sources namely, EMR, Billing System and Patient Satisfaction to realize Data Blending of practice variations to outcomes.
• Addressed the challenges of drivers of variation, and therefore, enabled the tracking of results of process improvements.
• Built data quality reports for each provider file also a summary data quality report for all the provider files.
• Identified potential reimbursement losses due to failure to meet appropriate use criteria and/or surgical complications.
• Identified variability in blood utilization, glycemic control, and early mobility.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups, and sets for various analytical reports and dashboards.
• Created Actions in Worksheets, and Dashboards for interactivity, and to compare data against different views.
• Converted applications developed in QlikView to Tableau to expand health Catalyst offering.
• Monitored Application Server and Tableau Data server activity to track performance and system availability.

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

Tableau Developer/ Business Intelligence Analyst

Confidential, Philadelphia, PA

Responsibilities:

• Building ARIMA models and Exponential Smoothing (ES) models. Experimenting with different methodologies such as Qualitative, Quantitative, and Drift forecasting. Resolving forecasting errors.
• Interacted directly with Audit Managers and their staffs, Business process owners, Finance and IT to design and implement data analysis solutions. Continually re-assessed these solutions in efforts to make them more efficient and effective. Developed methodologies that allowed for effective and repetitive data extraction processes.
• Design, develop, test and maintain Tableau functional reports based on user requirements.
• Participated on business requirement document preparation.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying the database.
• Interacted with business users and business analyst to understand the requirement and reviewed high-level design documents and functional specification document.
• Designed and optimized data connections, data extracts, schedules for background tasks and incremental refresh for weekly and monthly dashboard reports on tableau server.
• Worked on building queries to retrieve data into Tableau from SQL server and oracle, SQL developer and developed SQL statements for loading data from target database.
• Enhanced existing dashboards with new functionalities and tune ETL scripts for better performance.
• Developed user interactive sheets and reports as business needs and for writing SQL scripts to load the relevant data in Tableau applications.
• Created SQL stored procedures and views to fetch the data from database to build reports.
• Developed scripts for data reloading, mapping and transformation and maintained and updated the dashboard reports as required by the clients.
• Created views in Tableau Desktop that were published to internal team for further review and further data analysis and customization using filters and actions

Environment: Tableau Server, Tableau Desktop, Spotfire, SQL server, MS Excel, MS Access Informatica.

EDW Tableau Developer

Confidential

Responsibilities:

• Developed a comprehensive master data management (MDM) plan considering Processes, Data Capture and Harmonization and Centers of Excellence (CoE).
• Created, maintained and designed company production data and DBMS based products which includes SQL coding, planning and documenting the system.
• Developed multiple automation tasks like SQL server Job agent, windows Task scheduler, scripting. Tuned SQL queries and modified crystal report queries.
• Highly involved in mapping data from central repository to Oracle database, creating Visio diagrams, loading and maintaining data, and generating ad hoc reports.
• Provided support to end users and customers with software-related issues or problems as necessary.
• Support the goals of the Information system division and participate as a member of Information systems team.
• Generated reports on the daily basis according to client requirements using crystal reports.
• Excellent SQL developer skills, including stored procedures, indexed views, user defined functions, triggers and distributed triggers.
• Using SQL server import/export wizard and SSIS packages, loaded data from various sources like a flat file, excel and SQL server client to SQL server databases.
• Worked closely with developers and end users to ensure user satisfaction and technical compatibility.
• Determined alternatives for possible solutions and examined them by considering the business and technical suitability.
• Involved in documenting the modifications and intended functionalities of the interfaces.
• Developed ETL procedures to translate business rules and functionality requirements into ETL procedures.

Environment: SQL server, Tableau, SSIS, Informatica, MS Excel.

SQL Server Database Developer

Confidential

Responsibilities:

• Created logins, managed database objects like tables, views, stored procedures and indexes.
• Monitored SQL server performance using profiler, handling deadlocks, blockings and fine tuning long running queries that better results in efficient SQL processing.
• Design and implement data warehouse solutions for SQL server databases including replication strategy and Active-Active and Active-Passive clustering.
• Optimized queries that were taking long time to display desired result set.
• Created groups. Roles, users and assigning access privileges to users.
• Created new stored procedures and modifying existing ones as per business requirements.
• Performed data analysis to generate various trend reports.
• Troubleshooting ETL, OLAP analysis and reporting process failures.
• Performed parameterized reports, reports bursting, and scorecards.
• Involved in performing drill down the data, calculations, sort the data, add groups, subtotals, and color code the business data exceptions.
• Managed periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Created design of initial package, keeping in view and implementing appropriate SSIS controls.

Environment: SQL Server BI (SSIS, SSRS, SSAS), SQL Server Data Tools, SQL Server 2008 R2/2012 Enterprise Edition, MS Access, MS Excel.