SUMMARY

• Certified BI Developer/Analyst with 9+ years of experience in Tableau, data discovery, data visualization, data analysis, report development, MS SQL Server / ETL Developer in design, implementation & administration of Business intelligence solutions (SSIS/SSRS/SSAS) with Microsoft SQL server in development, testing, Staging & production environments.
• Over 8+ years of experience working with Senior managements and VPs, Credit Risk SMEs, Project managers, and directors from different teams to gather and analyze requirements as well as providing training and expert level recommendations for data solutions.
• In depth experience in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Well versed in designing and development of various dashboards reports, utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Dendrogram, 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 business/client requirement.
• Tableau administration experience V10 to new V2022
• Experience with AWS S3 buckets, AWS CLI setup, AWS ECS Instances setup
• Worked on AWS security groups inbound and outbound rules setup
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Senior VPs, Business Users, and Program Managers.
• Extensive Experience in various Tableau Desktop reporting features like Measures, dimensions, Folder, Hierarchies, Extract, filters, Table Calculation, Calculated fields, Sets, Groups, Parameters, Forecasting, blending.
• Utilized Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• 7+ Expertise in writing SQL Queries, Dynamic-queries, sub-queries, and complex joins for generating Complex Stored Procedures, Triggers, CTE, User-defined Functions, Views, and Cursors
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc.
• Highly skilled in tuning Databases across multiple servers and Tableau Dashboard to increase performance.
• 7+ Well versed in implementing Row Level security, utilizing permission to secure dashboard access to only the appropriate people.
• 8+ Extensive experience in working with Tableau Desktop, Tableau Server, and Tableau Reader, Tableau Prep in various versions of Tableau.
• 7+ Strong proficiency and hands-on experience of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Alteryx, Dimensional Modeling and Reporting tools.
• 7+ Designing, building, and testing workflows in Alteryx
• 7+ Implementing ETL process in Alteryx to extract data from multiple sources (CVS, Excel, XML, SQL server and converting data from multiple sources to into meaningful and easy to understand formats for various stakeholders
• Experience in working with Cloud service like AWS
• Experience leveragingBI tools in helping organizations address key business issues, improving competitive advantages, and facilitating decision making using BI tools like Tableau, Power BI, Excel.
• Highly skilled in using T-SQL for developing complex and well-tested Stored Procedures, Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity SQL Joins, and Indexes.
• Strong writing and oral communication skills, focused, quick thinker, creative and adaptive to new tech/platform, very passionate in solving business problem.

PROFESSIONAL EXPERIENCE

Confidential, UT

Senior Data Analyst/BI Developer

Responsibilities:

• Developed interactive Tableau Dashboards per business requirements.
• Worked various SMEs, Directors, and Senior VPs to designed effective, interactive, and visually appealing dashboards using Tableau Business Intelligence Solutions.
• Designed and developed ETL workflows and dataset in Alteryx
• Used Alteryx for data prep. And then output to Tableau for Viz. and reporting,
• Processed data in Alteryx to create TDEs for tableau reporting.
• Strategically cleaned up existing dashboards and extracts to comply with policies established by Center of Excellence (COE).
• Migration of infrastructure, Data and application from prem to cloud environments and from lower to higher environments
• Worked on Tableau server administration functions.
• Upgrade the server, install new server
• Experience in configuration create license for management
• Backed-up the server, create security and authentication with the aid of SAML< SSO
• Worked on multiple Migrations from on prem to the cloud
• 24/7 support of production databases and ensuring databases are constantly up and running effectively
• Increased overall company and departmental efficiency rate by over 30% by providing adequate and optimum database performance with efficient backup and restore processes/policies
• Analyzed and created capacity plans and projections quarterly for future database growth.
• 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.
• Designed and created databases, tables, views, store procedures, indexes, and triggers for databases
• Extracted data from various sources and scheduled refresh using Tableau Server, Alteryx.
• Successfully tuned several Tableau Dashboards and queries to perform according to standards
• Used T-SQL and SQL to create, run custom queries and reports to generate data for reports
• Accomplished wide range of development activities involving requirement gathering, documentation, code, and reports developments, to testing and release/deployment
• Efficiently combined data from multiple sources using Data Blending, Cross Database, data models (physical and logical Tables)
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop
• 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 reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently
• Implemented strong security by utilizing User row level security for data in the Dashboard
• Expertly wrote complex Tableau calculations using LOD, Date functionsand applying complex, compound calculations to large, complex data sets.
• Trained end client users on Tableau Desktop by providing step-by- step guidance from basics to advanced functions in Tableau including working with calculations, parameters, and date functions.
• Extracted datafromdata sourceslikeSalesforce,Amazon Redshift,SAS, DB2, SQL serverandExcelfiles for getting data toTableaufor creating various dashboards.
• Created materialized views to effectively summarize data for Tableau to increase performance

Confidential, UT

Data Analyst/BI Developer

Responsibilities:

• 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.
• Gather requirements/Designed and developed Alteryx workflows and dataset
• Revamping of existing Alteryx workflows
• Rebuilt broken Alteryx workflows
• Designed and developed ETL Alteryx workflows and dataset
• Designed and developed ETL workflows and dataset in Alteryx
• Used Alteryx for data preparation and validate using google doc.
• Created and designed executive dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts and publishing them to tableau server
• Trained end client users on Tableau Desktop by providing step-by- step guidance from basics to advanced functions in Tableau including working with calculations, parameters, and date functions
• 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 promptly 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
• Analyzed and assess requests to create professional presentation, quality deliverables in the form of dashboards & reports to provide additional insight to any critical indicators
• 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).
• Successfully worked with multiple sources, performed various LOD calculations, new dashboard development, troubleshooting the existing dashboards and performance management
• Successfully improved Performance & tuning of Data extracts for Tableau and SQL scripts used in extracts
• Identified performance bottlenecks especially in data model, data integration components, data load and implemented performance tuning to make the dashboard work efficiently.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

Confidential

Tableau Developer

Responsibilities:

• Successfully accomplished a wide range of development activities involving requirement gathering
• Developed interactive Tableau Dashboards per business requirements
• Expertly wrote complex Tableau calculations using LOD, Date functionsand applying complex, compound calculations to large, complex data sets.
• Implemented and Scheduled Replication process for updating our parallel servers in autonomous sites
• Designed and created databases, tables, views, store procedures and triggers
• Make recommendation on systems hardware and software implementation for management approval and took responsibility for complete and timely implementation
• Organized and co-ordinates daily operations and project delivery meeting to identified all possible problems and ensure they are rectified to keep project on schedule and report any project variance to the appropriate upper management personnel.