SUMMARY

• Over 7 years of experience in Tableau 2021.3/1,2020.4/1,2019,2018.3, 10.x/9.x/8.x/7.x Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server (2008,2012,2014,2016,2017), SSIS, SSRS
• Designed serval business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Online.
• Expertise in Tableau reporting while creating reports and dashboards using different sources coming from multiple sources such as Salesforce and spreadsheets.
• Designing, building, deploying, and publishing data analysis reports/dashboards for large volume of data.
• Extensive experience in Installation, configuration, upgrade, and administration of Tableau Desktop/Server.
• Designed and developer crosstab, conditional, drill - down, summary, sub reports, Ad hoc reports, parameterized reports, complex reports.
• Proficient in Tableau Data Visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Spearheaded troubleshooting of performance issues associated with Tableau reports
• Published Tableau dashboards on Tableau Server, Tableau Online and embedded them into portal.
• Experience in data visualization and presentation using Tableau, Excel (Pivot Table & Pivot Chart)
• Expertise in writing SQL queries, Dynamic queries, and complex joins for generating Stored Procedures, User-Defined Functions, Views, Cursors and Triggers.
• Skilled in Tableau Desktop for Data Visualization, Reporting and Analysis, Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Destiny Charts.
• Experience in Data Extraction, Data Integration, Data Modeling and Data Rendering in Tableau.
• Strong knowledge of database management in writing SQL Queries, Stored Procedures, Database Tuning, Query Optimization and resolving key performance issues. Knowledge on PostgreSQL and MongoDB.
• Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using onSQLServer 2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table chartandmatrix report)
• Able to communicate across both technical and business - oriented professionals
• Team Player with good communication and interpersonal skills and highly motivated to know more about the latest technology, software, products.

TECHNICAL SKILLS

Visualization tools: Tableau 2021.3/1,2020.4/1,2019, 2018.310.5/9. x/8.x/7.x/6.x, SSRS

Databases: SQL Server, MS Access

Utilities: MS Office Suite, MS SharePoint, MS Project

ETLandDatabase Tools: SQL Developer, TOAD, SQL Server Management Studio 2014, SSIS

Operating Systems: Windows

Data Modeling: Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagram

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, Texas

Tableau Developer/Senior Process Engineer

Responsibilities:

• Working on the enhancement of existing dashboards with current requirements on the Deposits and Credit Bureau Disputes (FCRA Program)
• Created Tableau scorecards, dashboards using stack bars, bar graph, scatter plots, geographical maps, heat maps, bullet charts for decision making
• Developed Complex Dashboards that take advantage of all Tableau functions, including data blending, actions, parameters etc.
• Created detailed level summary report using Trend lines, Statistics, log axes, groups, and hierarchies
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Worked with multiple teams inside the Organization to create Tableau Workbooks as per their needs
• Converted existing Business Objects reports into Tableau dashboards and embed views to SharePoint
• Wrote Complex Queries to extract data from snowflake and built tableau dashboard as per client requirement
• Created Ageing report since April 2021 for MBT team to meet 30 days SLO
• Currently supporting on creating process map for Military Protection team
• Created Operational Dashboard for Military Benefits and SCRA QA
• 90 days Reports were automated in tableau for the business to reconcile complete work items for the BAU Remediation effort
• Control Report for NSM to create NSM Consolidation work items
• Ad hoc reports were created as per requests from the business
• Created Operational Report (Daily EWL Volume), SCRA QA Pend, SCRA Executive summary dashboard, EWL Recon Report, Parent child relationship report
• Involved in data migration to snowflake from Netezza database
• Supported AML Team in creating AML Forecasting Report by retrieving data from Snowflake
• Maintained Asana Dashboard on daily basis by creating work items as per the requirement
• Worked with Level 5 Process mapping
• Worked with KC governance team to Perform all procedure updated, approvals and publish in KC
• Supported RPA team to reach remediation volume of ~10000 requests
• Enhancement of RPA to align with new MBT tool

Confidential, Baltimore, Maryland

Tableau Developer

Responsibilities:

• Worked on a health care application where we need to show various kinds of reports on tableau dashboard.
• Understand the Requirements and Functionality of the application from specifications
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements
• Utilized Tableau server to publish and share the reports with the business users also involved in administration tasks such as Setting permissions, managing ownerships, and providing access to the users and adding them to the specific group
• Worked on developing and maintaining complex T-SQL based stored procedures involving complex queries built on involving multiple tables, triggers, and user defined functions
• Worked on all aspects of the engineering of the service, including such topics as performance, testing, HA, dashboard design & tuning
• Developed dashboards and visualizations that empower decision makers

Confidential

Microsoft ETL (SSIS)

Responsibilities:

• Worked on designing, developing, and deploying of the ETL (Extract, Transformation and Load) strategy to populate the data from source data flat files of various types (Excel, DB files) using SSIS into a centralized database. Designed the OLAP, star schema and followed standard database design conventions
• Generated data extracts in Tableau. Configured data extraction by schedule, every alternate business day at 9 am.
• Organized dashboards in Tableau to analyze the membership strength, membership revenue and membership distribution by state
• Worked on developing Tableau based workbooks that are used to generate reports used to conduct analysis in the frequency of year to year, Quarter to Quarter, month to month, YTD, QTD and MTD
• Converted existing BO reports to tableau dashboards. Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Heat maps, Pie Charts and Bar Charts
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations
• Worked on migrating DTS packages (SQL Server 2000) to SSIS Packages (SQL Server 2008 R2)
• Participated in performance tuning of SQL Server 2008 R2
• Worked on designing, developing, and testing of strategies for Error Handling and troubleshooting SSIS packages
• Worked on developing and maintaining complex T-SQL based stored procedures involving complex queries built on involving multiple tables, triggers, and user defined functions

Confidential

SSRS Developer

Responsibilities:

• Understanding the functional and technical specification.
• Good experience with the design and development of reports.
• Develop, organize, manage, and maintain graph, table, slide, and document templates that will allow for efficient creation of reports.
• Regular involving in calls with customer and discussing about status and new requirements of the project.
• Preparing Dashboards using calculations.

Confidential

SQL Analyst

Responsibilities:

• Worked as an SQL Developer and establish strong relationships with end users and technical resources throughout established projects
• Worked closely with the development team to provide support for database objects (stored procedures/triggers/views) and performing code review
• Worked closely with Application Developers to ensure proper design and implementation of database systems
• Worked with Database administration including performance monitoring, access management and storage management Partners with development teams/vendors to provide reporting on in flight software development projects
• Created & developed SQL processes for channel performance data warehousing