We provide IT Staff Augmentation Services!

Data Analyst/tableau Developer Resume

Hanover, MD

PROFESSIONAL PROFILE:

  • A motivated and proactive individual with a wide range of IT knowledge and expertise gathered over the span of 6+ years in fields such as healthcare, Financial, and Banking domain.
  • Able to learn unfamiliar material and techniques quickly, exhibit great attention to detail, execute under aggressive deadlines, and adapt quickly to changing circumstances and systems to maintain strategic vision of the organization and link it with everyday work.
  • Very passionate about projects and able to carry out tasks that are time sensitive in an efficient manner to guarantee the growth and success of the organization.
  • A wonderful team player who values collaboration and communication, eager and possesses a very strong work ethic and can relate and work efficiently with diverse groups.

TECHNICAL SKILLS:

Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix

Databases: MS SQL Server 2005/2008/2012 , MySQL 5.2, 5.7, Oracle Sql developer 9i, 10g, 11g, IBM - DB2

ETL/Other Tools: SAS Base 9.x(SAS programing), SAS Enterprise Guide (Non- programming), SSIS (Visual Studio), Erwin Data Modeler, ER Assistant

Querying Tools: SQL Management Studio 2008/2012, SQL Plus, SQL Developer, PL/SQL

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 9.1, 9.2, 9.3, 10.2, 10.4, Microstrategy, Excel and PowerPivot, PowerBI, SSRS, SAS, Crystal Report

PROFESSIONAL EXPERIENCE:

Confidential, Hanover, MD

Data Analyst/Tableau Developer

Responsibilities:

  • Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts
  • Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data
  • Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different RDBMS
  • Utilize SSIS for ETL data modeling, data migration, and analysis
  • Business requirement gathering and translating them into clear and concise specifications and queries
  • Prepare high level analysis reports with Excel and Tableau
  • Provides feedback on the quality of data including identification of billing patterns and outliers
  • Developed Database Triggers and Views, Stored Procedures and Functions
  • Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server.
  • Wrote complex SQL queries using advanced SQL concepts like Aggregate functions
  • Viewed duplicate data or errors in data to provide appropriate communication within the department and accurate monthly reports.
  • Experienced in Data mapping, Data transformation between sources to target data models.
  • Wrote complex SQL queries to retrieve data from different tables utilizing Joins & Sub-queries.
  • Inspected reporting requirements and created various Dashboards.
  • Involved in extraction, transformation and loading of data directly from different source systems like, Excel, Oracle, flat files and SQL Server.
  • Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
  • Created quick filters, table calculations, calculated parameters and measures.

Confidential, Fairless Hills, PA

Tableau Developer, Data Analyst

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.
  • Analysed 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.
  • Analysed 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, analysing 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.

Confidential, Pittsburgh, PA

Data Analyst / Tableau Developer

Responsibilities:

  • Supported the company’s healthcare software functions, implementation and .
  • Make business recommendations based on data collected to improve business efficiency.
  • Collected data from all clients and made recommendations for improvement.
  • Ad-hoc data extraction through queries in SQL Server 2008, Excel, SAS, Tableau report or PDF.
  • Supported business lead for special assignment and to ensure production efficiency.
  • 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.

Hire Now