Data Analyst Resume
0/5 (Submit Your Rating)
Gainesville, FL
SUMMARY
- 6+ years’ experience of healthcare data analysis in MS SQL Server (TSQL, SSIS, SSAS, SSRS), Access, Excel.
- Strong data management and reporting experience on quantitative analysis.
- Strong team player with great verbal, written communication and interpersonal skills.
- Proven capability to approach problems effectively and creatively.
- Quick learner, self - starter and hard worker. Responsible and detail-oriented.
TECHNICAL SKILLS
Database: MS SQL Server 2008, MS BI and DW, Oracle 11g /10g
Reporting: SSRS, MS Access 2007/2010, T-SQL, Crystal Report 2008
Developing: MS visual studio
Analysis: SSAS
ETL tool: SSIS, SQL loader
MS Office: Word, Excel, PowerPoint, Integration of Excel and Access
PROFESSIONAL EXPERIENCE
Data Analyst
Confidential - Gainesville, FL
Responsibilities:
- Developed SSIS packages to extract data from variety of sources (hospital EMR, lab test, administrative data, etc.), transformed data and loaded them into CDW.
- Closely worked with the doctors, business end users, to collect business requirements for report development in both SQL Server and Excel.
- Created quarterly reports in SSRS and Excel for hospital and clinic use to analyze and monitor the patient count and treatment effectiveness; generated ad hoc reports to provide decision-making Support for executives.
- Worked on writing T-SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic.
- Created ETL packages using SQL Server 2008 SSIS Designer to extract data from flat file, reformat data, and insert reformatted data into fact table, load different types of dimension and fact tables into data warehouse, deploy SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio (BIDS).
- Developed projects using SQL Server 2008 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified cube and dimensions, deployed key performance indicators (KPIs) on SSRS and created different metrics, added new measure groups and dimensions; created data-mining solutions in BIDS, deployed them to SSAS instance, trained the model and queried the model using DMX.
- Created drill-down, drill-through, sub and linked reports using MS SSRS 2008 as well as managed subscription of reports. Built reports from SSAS cube using MDX query designer; configured report server and deployed reports on web server and SharePoint.
Environment: Servers: SQL server 2008 R2 (64bit) management studio, SSIS, SSRS; Clients: Windows XP/7
Data Scientist
Confidential - Gainesville, FL
Responsibilities:
- Loaded data from flat data files into SQL Server 2008 database tables using bcp, bulk insert, and table export/import; loaded data from flat data files and excel sheet into Oracle database using SQL*Loader and SQL Developer.
- Power user of advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL or PL/SQL functions.
- Successfully loaded the data from ChIP-Seq and Microarray experiment to SQL Server 2008 R2, analyzed and published results in prestigious journal using SQL Server and Access as reporting tools.
- Used NCBI biological databases cross-reference other database with Primary Key, Foreign Key and linked their related knowledge together.
- Retrieved and modified data using SQL Server 2008 and BIDS and acquired disease information from different databases.
- Designed and implemented a database application based on Access 2007 to record, analyze and report survey data from IRB-approved study conducted at UF for local back pain outpatients.
- Environment: Servers: SQL server 2005(32bit)/2008 R2 (64bit) management studio, Oracle 10g; Red Hat Linux; MS Excel and Access; Clients: Windows XP
