Applied Skills

• Operating Systems - Win XP, Vista, 7, Windows Server,

• ETL/DBMS/Other Tools- MS SQL Server, SAS EG, Dremio, Snowflake, PG Admin, PostgreSQL, Python, R

• Querying Tools - SQL Management Studio 2008/2012, SQL Developer, PL/SQL

• Querying language - SQL, PL/SQL, TSQL

• Business Intelligence Tools - Tableau, Excel, SAS, Snowflake

Professional Credentials Overview

USAA – San Antonio, TX Data Analyst / Tableau Developer

Jan 2021 – Present

Responsibilities:

• Created specifications for reports and analysis based on business needs and required or available data elements

• Analyzed complex business problems and issues using data from different sources to provide insight to analysts and decision makers

• Identified and interpret trends and patterns in datasets to locate influences and partner with internal customers to define the business problem and data needs

• Identified and implement innovative approaches to address business problems and solutions by following written risk and compliance policies and procedures for business activities

• Developed business deliverables that leverage business intelligence platforms, data management platforms, or SQL-based languages

• Ensured risks associated with business activities are effectively identified, measured, monitored, and controlled. PROFILE OF QUALIFICATIONS TECHNICAL SKILLS PROFESSIONAL SYNOPSIS

• Performed a quality check on data migrated to new sources by investigating and doing a deep analysis to underline any data errors occurred during the migration from the source to the target, and point out the discrepancies for remediation

• Validated data and processes to ensure accuracy, completeness, and consistency of data

• Utilized SAS, Dremio and Snowflake in data and analytics problem solving

• Produced high quality work deliverables with high attention to detail

• Made business recommendations based on data collected to improve business efficiency.

• Ad-hoc data extraction through queries in SQL Server, Excel, SAS, Tableau report or PDF.

• Supported business lead for special assignment and to ensure production efficiency.

• Collected data from all clients and made recommendations for improvement.

• Used data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their Data

Responsibilities:

• Created Views and Database Triggers, Stored Procedures and Functions using SQL such that information entered by a certain WM can make appropriate changes to the respective tables.

• Wrote complex SQL queries using advanced SQL concepts like Aggregate functions

• Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server.

• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Explain, Stats, Cast and volatile tables on SQL server

• Involved in extensive data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.

• Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.

• Experienced in Data mapping, Data transformation between sources to target data models.

• Analyzed reporting requirements and develop various Dashboards.

• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

• Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).

• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters.

• Responsible for developing, analyzing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.

• Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.

• Used statistical techniques such as regression, cluster analysis, factor analysis, time series forecasting, experimental and design, etc. to solve business problems.

• Used SAS to solve problems with data and analytics.

• Interacted on a day-to-day basis with several different groups to achieve a common deliverable

Northwest Texas Healthcare - Amarillo, TX Data Analyst /Tableau Developer

Huntington Bancshares – Columbus, OH Tableau Developer / Data Analyst

Nov 2018 – Dec 2020

Jul 2016 – Oct 2018

Responsibilities:

• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

• Restricted data for particular users using Row level security and User filters.

• Developed Tableau visualizations and dashboards using Tableau Desktop.

• Developed Tableau workbooks from multiple data sources using Data Blending.

• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server

• Created complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.

• Performed daily integration and ETL tasks by extracting, transforming and loading data to and from different SQL Server databases

• Utilized SSIS for ETL data modeling, data migration, and analysis

• Prepared high level analysis reports with Excel

• Provided feedback on the quality of data including identification of billing patterns and outliers

• Gathered user requirements, analyzed and designed software solution based on the requirements

• Analyzed and Assessed invalid and missing data in the Claims Data

• Identified and document limitations in data quality that jeopardize the ability of internal and external data analysts

• Translates data into visual representation of information and present to appropriate department

Liberty Mutual – Boston, MA Data Analyst

Oct 2014 - Jul 2016

Responsibilities:

• Made business recommendations based on data collected to improve business efficiency.

• Ad-hoc data extraction through queries in SQL Server 2008, Excel, SAS, Tableau report or PDF.

• Issued SQL commands matching the business requirements to Teradata RDBMS

• Supported business lead for special assignment and to ensure production efficiency.

• Collected data from all clients and made recommendations for improvement.

• Data analysis, reporting using Tableau and SAS.

• Use data visualization tools to provide an easy-to-understand interface for end users to quickly identify key themes within their Data

• Designing the Reports as per client Requirement and created the reports using Excel file, SQL Server and Oracle databases.

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.

• Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.

• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

• Created demos in Tableau Desktop and published onto Tableau Server.

• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.

• Deployed Tableau Dashboards and worksheets in clustered environment.

• Documented a whole process of working with Tableau Desktop and evaluating Business Requirements.

• Interacted on a day-to-day basis with several different groups to achieve a common deliverable.