Data Analyst Resume

SUMMARY

Driven by bottom line of any organization coupled with Core Technology skills to delivering exceptional services. Seeking a position as a Data Analyst/ETL Developer Tableau Developer/Analyst ; utilizing knowledge of relational database and Business Intelligence models to improve on efficiency and effectiveness of organization’s IT functions towards achieving an ultimate goal.

TECHNICAL SKILLS

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

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

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

Test Tools: HP Quick Test Professional 10/11, HP Quality Center 10

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

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 9.1, 9.2, 9.3, Excel and PowerPivot, SSRS, SSIS, Power BI, SAS

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

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 SQL Server databases
Utilize SSIS for ETL data modeling, data migration, and analysis
Prepare high level analysis reports with Excel
Provides feedback on the quality of data including identification of billing patterns and outliers
Analyze and Assess invalid and missing data in the All Payer Claims Data
Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts
Carrying out data extraction and data manipulation using SQL as per business requirements
Documenting the extent to which data fails to meet threshold reporting requirements

Confidential

Data Analyst

Responsibilities:

Responsible for extracting data from multiple systems and databases including SQL Server and Oracle to bring it into a centralized system.
Created and populated patient data using advanced SQL and PL/SQL queries and scripts and performed Teradata SQL performance tuning.
Worked on analysis of the Facets claims processing application in order to gather requirements to comply with HIPAA 5010.
Created transformation and mapping by using Informatica Design.
Maintained data consistency, Oracle database integrity and reported instances of data corruption.
Created mappings using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update strategy, Joiner, Normalizer, Union, Store procedure and XML transformations.
Performed numerous data extraction requests involving SQL scripts and UNIX.
Performed data migration between different environments and Third - Party Databases.
Performed drill down analysis reports using SQL Server Reporting Services.
Created data dictionary for the clinical aberrancy rules.
Analyzed HIPAA 4010 and 5010 standards for 837P EDI X12 transactions related to providers, payers, subscribers and other related entities.

Confidential

Tableau Developer/Analyst

Responsibilities:

Used Tableau server as a front-end BI tool and MS SQL Server 2012 as a back-end database to design and develop workbooks, dashboards, global filter page, and complex parameters-based calculations.
Working with team of developers, designed, developed and implemented a BI solution for Sales, Product and Customer KPIs.
Create compelling dashboards using tableau dashboard and prepare user stories to deliver actionable insights.
Connect Tableau server to publish dashboard to a central location for portal integration.
Implement Tableau mobile dashboards via Tableau mobile application.
Involve in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau.
Develop Tableau workbooks from numerous data sources using Data Blending.
Develop Tableau visualizations and dashboards using Tableau Desktop.