SUMMARY

• Business Intelligence Professional (8+ years’ experience) with strong background in the financial domain, good experience in credit risk, compliance (OFAC and AML), fraud, and onboarding.
• Also possess rich experience in data modeling, data manipulation, with outstanding leadership qualities, a burning desire to continually improve and help organizations meet their objectives through business intelligence solutions.
• Over 6+ years of Data warehousing experience and creating reports using Tableau Business Intelligence Solutions (Desktop/ Server) 10.x/9.x/ 8.x/7.0/6.0, OLTP and OLAP Microsoft SQL Server, Oracle SQL Server as a Developer in various companies.
• Broad experience creating effective, interactive and complex business reports/ dashboards using TableauBusiness Intelligence Solutions.
• Good working knowledge in evaluating data models to design Tableau solutions and fine tuning dashboards to increase performance
• Deep experience with the design and development ofTableauvisualization solutions tohelp users to identify critical KPIs and facilitate strategic planning in the organization.
• Strong experience in the optimization of dashboards performance by implementing performance tuning procedures and also by installing and upgrading Tableau servers
• Well versed in designing and development of various dashboards using customized charts like Sankey and Sunburst charts, as well as standardized chart/graphs likebar graphs,scatter plots,pie - charts,geographic visualizationand other making use ofactions,otherlocal and global filtersaccording to the end user requirement.
• Rich experience developing workarounds to customize Tableau Dashboards to meet business objectives
• Extensive knowledge in Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.
• Extensive experience in Microsoft T-SQL/PL-SQLstatements (DDL and DML) including features like Temporary Tables, Ranking Functions, Joins, Pivot, For XML path, CTE, While Loops etc.
• Hands on experience with Requirement Analysis, Functional Specifications, Technical Specifications, Data Cleansing, Data Modeling, Data Architecture, Gap Analysis, Data Transformations, Data Relationships and Reporting Analysis.
• Effective skills in applying various management tools like SWOT, Porter's generic strategies, Mc Kinsey 7s model and competitive analysis.
• Proficiency in writingBusinessRequirement Document (BRD), Functional Requirement Document (FRD), Test Case Document (TCD)

TECHNICAL SKILLS

• Tableau Desktop 6/7/8/9/10 2018. x
• Tableau Server 6/7/8/9/10 Tableau Online
• Tableau Public
• Tableau Reader
• TabCmd
• Microsoft SQL Server 2012/2008-R2/2008/2005
• MS SQL Server Integration Services (SSIS)
• MS SQL Server Reporting Services (SSRS)
• MS SQL Server Analysis Services (SSAS)
• T-SQL
• PL-SQL
• OLAP
• OLTP
• Erwin Data Modeler v7.0/v4.x
• Microsoft Visual Studio 2010/2008/2005
• Microsoft Access
• Microsoft Office(MS Word/ Excel/Powerpoint)
• MS Project
• HTML
• XML
• Java
• C++
• C#

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Used Tableau Desktop for blending databases and create interactive views and dashboards
• Created multiple scorecards and dashboards
• Performed data analysis on daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production
• Actively involved in new KPI generation forTableau Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Identified new metrics and enhance the existing KPI's.
• Worked extensively using Excel to validate the data and use as the source data files.
• Converted existing Excel reports in toTableaureports
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets usingTableau.
• Effectively used data blending, filters, actions, Hierarchies feature inTableau.
• Defined best practices forTableaureport development.
• Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports toTableaureports.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked with Teradata database and pull data to work on BI requirement.
• Provided Ongoing support to BI application running in production & troubleshoot.

Environment: Tableau (Desktop), Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook)

Confidential, Cincinnati, OH

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Used Tableau Desktop for blending databases and create interactive views and dashboards
• Created multiple scorecards and dashboards
• Performed data analysis on daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production
• Actively involved in new KPI generation forTableau Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Identified new metrics and enhance the existing KPI's.
• Worked extensively using Excel to validate the data and use as the source data files.
• Converted existing Excel reports in toTableaureports
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets usingTableau.
• Effectively used data blending, filters, actions, Hierarchies feature inTableau.
• Defined best practices forTableaureport development.
• Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports toTableaureports.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked with Teradata database and pull data to work on BI requirement.
• Provided Ongoing support to BI application running in production & troubleshoot.

Environment: Tableau (Desktop), Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook)

Confidential, Draper, UT

Tableau Developer/Admin

Responsibilities:

• Develop interactive data visualizations and develop automated processes for updating content used in standardized dashboards.
• Creates Users, User GroupsandProjectsthroughTableauserver Web and assignedroles and permissionsforTableauUsers Hold responsibility for integration points and the order in which these must be executed.
• Built compelling, interactive dashboards inTableauthat answer key business questions.
• Audits the datasets and data analyzed as required ensuring their continuity, accuracy and consistency.
• Perform administrative and support activities across a multi-environmentTableauinfrastructure including security administration, release management, troubleshooting and general systems maintenance
• Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
• Reviewed, assessed and promoted adoption and standardization ofTableausupport solutions.
• Generated insights out of voluminous and complex datasets and built story lines.
• Produce complex table calculations, use of parameters, actions, filters and other advanced options inTableau.
• Design excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
• Involved in reviewing business requirements andanalyzingdata sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Create views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements
• Optimized existing stored procedures and various T-SQL queries
• Wrote Dynamic Store Procedure to move data from Staging to Application
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Added more audits and alerts in SSIS Packages in case of package failure

Environment: Tableau Desktop 8, Tableau Server 8, WorkDay, TabCMD, MS SQL Server 2012, MS SQL Server Integration Services, SAP, MS Visual Studio 2010, Microsoft Office Visio, Microsoft Safe Source 2005 (VSS), Erwin r8, Ultra Edit tool, SharePoint, C#.

Confidential, Portland, OR

Tableau Developer

Responsibilities:

• Developed interactive Tableau visualizations after gathering Business Requirements, Interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Extended Tableau limits to create unconventional Tableau charts such as Sankey Diagram, Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, and logical calculations to create groups.
• Utilized performance tuning procedures to increase performance and help make dashboard more visually appealing and user friendly
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableau server.
• Participated in the daily stand up Scrum Agile meetings for reporting the day-to-day developments of the work done.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Effectively used data blending feature inTableau.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Analyzing raw data, drawing conclusions & developing recommendations.
• Worked on various kinds of data filtering as required in the dashboards/reports like quick filters, context filters, filtering measures, continuous and discrete filters.
• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
• Ensured high levels of data consistency between diverse source systems including flat files, XML and SQL Database.
• Developed and run ad hoc data queries from multiple database types to identify system of records, data inconsistencies, and data quality issues.
• Created users, groups, projects, Data connections, settings as aTableauadministrator.
• Created dashboards and reports inTableauand Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in creating database objects like tables, views, procedures, triggers, functions using SQLDeveloperto provide definition, structure and to maintain data efficiently.

Environment: Tableau8.1/8.0,TableauServer, Oracle, Microsoft SQL Server, Microsoft Office, Microsoft Visio, Windows 7, SQLDeveloper.

Confidential, Orem UT

MS SQL Developer /Tableau Developer/Admin

Responsibilities:

• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation and ETL processes
• Created Entity Relationship (ER) Diagrams to the proposed database
• Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram.
• Worked on the performance tuning part, as most of our applications have issues with the PL/SQL stored procedures.
• Designed, Developed and Deployed SSIS Packages
• Worked as a DBA and created creating tables, users, and permissions.
• Created database objects such as tables, views, stored procedures, Triggers etc.
• Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Identified columns for Primary Keys in all the tables at the design time and create them.
• Created functions to provide custom functionality as per the requirements.
• Be aware of potential blocking, deadlocking and written code to avoid those situations.
• Ensured that the code is written keeping in mind any security issues such as SQL Injection.
• Identified and written best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
• Participated in development and creation of Data warehouses.