SUMMARY

• More than 10+ years providing data - driven solutions through Tableau, Power BI, SQL server, Hadoop, Alteryx, AWS Athena, Python, SSIS, Oracle, and Redshift
• Around 7 years of rich experience in end-to-end implementation of Tableau and Power BI projects, along the lines of designing, developing, and enhancing complex Dashboards
• Around 6+ years of experience comfortably meeting with Senior VPs, Directors, Project Managers to gather and analyze requirements
• Over 6 years of hands-on experience designing clean and efficient Tableau Dashboards using advanced features, complex interactivity, and customized charts to meet requirements
• Highly skilled in Tableau performance tuning, troubleshooting existing dashboards and performance management.
• Expert in evaluating data models and building ETL processes to automate reporting processes
• Well versed in using Row Level security (data security), authentication and permissions to secure dashboards.
• Strong understanding of data systems (BI analytics, data blending, data warehousing, data ETL, etc.) on process automation and standardization.
• Well versed in developing and tuning complex SQL queries for enterprise reports and dashboards.
• Hands-on experience administering users, user groups, and scheduled instances for reports in Tableau.
• Rich experience creating documents like BRD, FRD, user stories, user manuals, and design manual
• Fully versatile and willing to take on new challenges across different projects and technologies

TECHNICAL SKILLS

RDBMS: SQL Server, MySQL, Hadoop, Impala/HIVE, Oracle, Teradata, Netezza

Reporting Server: Tableau, OBIEE, Actuate

Reporting Tools: Tableau, Actuate suite, BIRT, MicroStrategy& OBIEE Alteryx, and Python

Enterprise Environment: Maximo, Business Objects, MSBI Stack (SSIS & SSRS)

ETL: Alteryx, SSIS, Informatica 8.1.1/8.6.1 & Objects Data Integrator

Microsoft Office: MS Word, MS Excel, MS. PowerPoint, MS. Access, MS. Outlook

PROFESSIONAL EXPERIENCE

Confidential, Ohio

Senior Tableau Developer

Responsibilities:

• Successfully collaborated with multiple teams and worked with multiple data sources to develop new dashboards, migrate reports from other tools (Cognos, Power BI, and MicroStrategy), and enhance existing dashboards.
• Utilized advanced features in Tableau like Extensions, APIs (JavaScript and Python), customized charts, analysis action, calculations, parameters, background images to enhance user’s experience.
• Analyzed requirements and data to determine suitability of data, discover patterns, and relevance of requirements in relationship to the overall business goals
• Created clean dashboards with good performance, strong security (using Row Level Security), and effective interactivity
• Successfully improved Performance & tuning of Data extracts for Tableau and SQL scripts used in extracts
• Scheduled extract refresh (Incremental and Full refresh) using Tableau server, Alteryx, and Python.
• Wrote complex SQL queries using advanced features like stored procedures, CTEs, complex joins, dynamic SQL, to report performance

Confidential, Florida

Senior Tableau Developer

Responsibilities:

• Effectively collaborated with various SMEs and business-side stakeholders to analyze and prioritize requirements and developed dashboards that address key business issues
• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Utilized advanced features in Tableau like Extensions, APIs (JavaScript and Python), customized charts, analysis action, calculations, parameters, background images to enhance users experience.
• Created database objects such as tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Expertly used advanced chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, funnel charts etc., to assist business users in solving complex problems.
• Scheduled extract refresh (Incremental and Full refresh) using Tableau server, Alteryx, and Python.

Confidential, California

Sr. Data Analyst/Tableau Developer

Responsibilities:

• Developed, enhanced, tested, and maintained Tableau dashboards that address key business issues.
• Utilized advanced features in Tableau like Extensions, customized charts, analysis action, calculations, parameters, background images to enhance users experience.
• Defined and utilized best practices for Tableau report development.
• Supplied expert recommendations and training on security, performance, and best practices to stakeholders and less experienced Tableau Developer
• Skillfully employed various workarounds to meeting functional and non-functional requirements
• Migrated dashboards from Power BI, MicroStrategy, and Cognos into Tableau
• Collaborated with business users to analyze requirements, determine scope of projects, and address concerns of business questions
• Extracted data from various sources and scheduled refresh using Tableau Server, Alteryx, Python
• Created materialized views to effectively summarize data for Tableau to increase performance

Confidential, Missouri

Tableau Developer

Responsibilities:

• Delivered complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Collaborated with various business stakeholders to understand their decision-making parameters, analyze the available data to build Tableau dashboards.
• Analyzed business requirements, performed data wrangling, data profiling, and Gap Analysis
• Interacted with the existing database team members and DBA to understand the existing schema.
• Effectively coordinated and designed interactive dashboards with metrics and KPIs to ensure efficiency
• Successfully tuned server Tableau Dashboards and SQL queries to enhance user’s experience
• Skillfully involved in the design of policies to ensure High Availability of Tableau Server and good governance of self-service BI environment
• Ensured user security for views using User filters.
• Queried database using stored procedures, user defined functions, complex joins, dynamic SQL, and Temp Tables.
• Troubleshooted and conducted performance tuned stored procedures and triggers.
• Identified performance bottlenecks especially in data model, data integration components, data load and implemented performance tuning to make the dashboard work efficiently.
• Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, Development, Testing, Reporting, Go-live and Reconciliation.
• Professionally established Tableau best practices in creation and design of reports, developing SQL queries, and building advanced tableau dashboards.
• Expertly resolved numerous performance challenges and implement best process distribution for 8+ projects, facilitating users in Tableau dashboard development
• Swiftly accomplished all tasks related to advance analysis actions, calculations (LODs), parameters, background images, maps, trend lines, and statistics
• Created groups, hierarchies, and data sets to develop summary levels and detailed reports
• Demonstrated experience and ability in working with business users to gather and document requirements and manage scope
• Created and designed executive dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts and publishing them to tableau server.
• Capture & clarification of business requirements through a range of analysis techniques (data flow diagrams, sequence diagram, case tool analysis, gap analysis and work & process flow diagrams).
• Expertly used advanced chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, funnel charts etc., to assist business users in solving complex problems.
• Analyzed data sources, constructed data decomposition diagrams, provided data flow diagrams, and documented the process.
• Updated new business requirements into technical designs
• Created Tables, Views, and Stored Procedures as data sources for dashboards to optimize Tableau performance.
• Published data to Tableau server and schedule independent refresh schedules of published data sources
• Skilled in writing complex Tableau calculations using LOD, Date functionsand applying complex, compound calculations to large, complex data sets.
• DistributedTableau reports using techniques like Packaged Workbooks, PDFto different user community.
• Organized data and wrote complex SQL queries, stored procedures.
• Created dashboards using calculation, parameters in tableau and created calculated fields, sets and hierarchies.
• Worked with datafromdata sources like Salesforce,Amazon Redshift, DB2, SQL server and Excelfiles for getting data toTableau for creating various dashboards.
• Proficient in evaluating data models to design Tableau solutions and fine-tuning dashboards to increase performance.

ENVIRONMENT: Business Skills