TECHNICAL SKILLS:

• Six years of SQL Analytics/Tableau Developer.
• Eight years of Nursing
• Eight years of High School Chemistry teaching

• Tableau Developer
• Connecting to various file types, data source pages, adding more data sources, using live versus extracted data, bringing in more data with Joins.
• Identify and select effective and accurate visualizations to analyze data.
• Work with marks, change mark types, aggregation & number of marks, building views, highlighting, level of detail and use of “show me” to rapidly create best practice graphs.
• Build date and non - date hierarchies that drill down, sort data with one click options or more advanced sorting, enhance analysis with groups and visual groupings.
• Use calculations and parameters to dynamically group data.
• Make constant, dynamic, and combined sets for use in analysis.
• Accurate use of filter shelf with different types of data and use of filters to add interactivity to views.
• Differential use of summary versus record level filtering and use of data source filters.
• Use parameters in a variety of ways to enhance interactivity, formatting views and control the layout of analysis
• Accurate use of pre-attentive visual features to create accurate and effective visualization.
• Improve on analysis by customizing and building useful tooltips.
• Add trend lines to an analysis and access information about the model to determine if the trend is of analytical value. Also add lines (and bands, distributions, and box plots) to a view to enhance analysis.
• Use tableau to forecasts and evaluate or show information about the forecast.
• Cluster data in Tableau right from the analytics pane.
• Create visualizations that are compatible with the 11% of population that are color blind.
• Appropriate use of different color palettes for grouping and highlighting items and encoding quantitative values.
• Use row and column shelves in conjunction with Marks card to create basic charts like the bar, pie, and line charts.
• Use views and other elements to create an interactive dashboard, add pieces to an interactive dashboard and control their layouts, customize and format various aspects of a dashboard.
• Customize versions of a dashboard for optimized viewing on a tablet or phone with device designs.
• Enhance the interactivity of dashboards using highlight, filter, and URL actions
• Share the story behind data using story points.
• Use geographic roles, plot location data in tableau desktop and editing unrecognized locations.
• Create and import the custom geocoding CSV files.
• Bring a background image into Tableau and plot data on that image.
• Dissect a simple calculation to see what the various aspects of calculation syntax are in tableau.
• Creating and using table calculations with an emphasis on Quick Table Calculations.
• Modify table calculations to gain greater control over exactly how the calculation is performed and use of LOD expressions. Dive deeper into Level of Detail Expressions and how nested LOD Expressions are evaluated.
• Distribute tableau analysis as a packaged workbook, publish it online or on tableau server.
• Identify distribution analysis problems: describing a single distribution, identifying possible outliers, comparing two or more distributions, identifying whether two or more numbers come from the same or different distributions.
• Use correlation analysis to establish statistical relationship between two random variable: direction, strength and shape.
• Use of scatterplot, scatterplot matrix and table lens to do correlation analysis.
• Identify multivariate analysis problems, including comparing similarities and differences of a number of items on two or more common variables; identifying similar items, finding outliers, and clustering.
• Design and create multivariate heatmaps and parallel coordinate plots in Tableau with the appropriate interactivity to allow the user to explore the data.

Oracle SQL Skills.

• Retrieve data using the SQL select statement or using subqueries
• Restricting and sorting data
• Use single-row functions to customize output, conversion functions and conditional expression
• Report aggregated data using group functions
• Display data from multiple tables using joins and use subqueries to solve queries
• Use the set operators and manage table using DML statements
• DDL and data dictionary views
• Create sequences, synonyms, indexes and views
• Managing schema objects and manipulating data by using subqueries
• Controlling user access and managing data in different time zones

WORK EXPERIENCE:

Confidential, Waxahachie, TX

Tableau Developer

• Create hierarchies at national, state and county levels to compare performance and monitor targets through creation of bullet graphs and multivariate graphs.
• Produce monthly trend graphs of hospital acquired infections and use heatmaps to compare and rank hospitals at county, state and national levels.
• Monitor surgical infection rates and use graphs quarterly to compare results against targets.
• Build and publish customized interactive reports and dashboards.
• Create action filters, parameters, highlights and calculated sets for preparing worksheets and dashboard in Tableau.
• Effectively use data blending to retrieve data from different sources.
• Grant varying privileges to different personnel hierarchies in the system.
• Execute and test required queries and reports before publishing.
• Convert metric insight reports to tableau reports.
• Create, customize, and share interactive dashboards with simple drag drop features on tableau online or on tableau server.
• Export completed projects as a tableau package for interactivity with underlying data.
• Design dashboards to fit any browser on a desktop, laptop, tablet or smart phone.
• Share the story behind data and analysis with story points.
• Involved in creating ad hoc analysis and reporting requests in a timely manner.
• Work extensively with advance analytics involving calculations, parameters, background images with logos, Maps, trend lines, log axes, groups, hierarchies, sets to create detail level summary report and dashboard using KPI's
• Create organized, customized analysis and visualized projects and dashboards to present to senior Level Executives.
• Good SQL reporting skills with the ability to create SQL views and write complex SQL queries.

Confidential, Dallas, TX.

SQL Data Analyst

• Execute and test required queries and reports before publishing.
• Created database tables with various constraints including primary key, foreign key, etc.
• Loaded data from flat data files into SQL Server database tables using bulk copy program(bcp), bulk insert, and table import
• Reformatted the data and inserted the reformatted data into staging tables, performed data cleansing and data type conversions and then loaded into destination tables
• Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations and user defined functions (UDFs) for data analysis
• Extracted data from SQL Server database tables into flat data files and Excel sheets using table export and BCP for easy data migration
• Generated variety of business reports from SQL server using excel with pivot table and pivot chart
• Worked directly with customers and team members to determine project scope and specifications, provides research and analysis to support intelligence organizations.
• Wrote and executed SQL queries using Query Analyzer to provide custom reports to marketing and sales
• Worked closely with the nurses to gather requirements for custom reports and client lists to generate monthly reports for facility administrators and quarterly reports for regional managers.
• Operated as a liaison between the technical support group and nursing staff to increase awareness of customer issues and resolve problems outside of the nurses’ reach.