Data Analyst Resume Washington DC - Hire IT People

SUMMARY

Detailed - oriented professional wif 5+ years of IT experience in teh Healthcare, Financial, Government and Banking domain.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Data Analyst

Responsibilities:

Provided SQL Server Analytical and reporting support for a dataaggregation and analytical project in tracking large bank loans to determine bank risk.
Created workflow designs and used MS Excel to do data analysis, using pivot tables, VLOOKUP, macros,
Cleaned, processed and loaded data manually and through automated ETL systems and developed reports using Tableau and MS Excel.
Elicited, analyzed and refined business requirements from stakeholders, documents and reports for generating solutions.
Created a Data Model Diagram and Data Models using Erwin Data Modeler.

Confidential, Irving, TX

Data/Business Analyst

Responsibilities:

Maintained patients’ information and supported teh company’shealthcare software functions and training.
Ad-hoc data extraction through queries in SQL Server 2012 and MS Accessand presented report in MS Excel and SSRS.
Performed data migration and data integration development tasks to put data in a centralized location. UtilizedSSIS to move dataintoSQL Serverfrom OLTP source.
Used reverse engineering in creating Data Models and Data Model Diagrams
Weekly analysis of new data entered into database
Sat in JAD Sessions to halp document, elicit and understand requirements and business rules.

Confidential, Boston, Massachusetts

Data Analyst

Responsibilities:

Created complex SQL queries and scripts to extract and aggregate data to validate teh accuracy of teh data.
Performed daily integration and ETL tasks by extracting, transforming and loading data to and from different SQL Server databases
Utilized SISS for ETL data integration and data migration.
Performed data analysis wif MS Excel, using VLOOKUP, pivot tables, Macros/excel formulas.
Cleaned, analyzed and validated invalid and missing data to ensure high data quality.
Identified and document limitations in data quality that jeopardize teh ability of internal and external data analysts
Translates data into visual representation of information and present to appropriate department
Used Erwin Data Modeler for data modeling

Confidential, St. Louis, Missouri

Data Analyst

Responsibilities:

Worked wif users and developers to verifyimpacts of changes to design and cost estimates of teh designs.
Performed ETL functions and data mapping for several systems using Microsoft Visual Studio 2010 for source control, Visual Studio 2008 for data mapping, and Microsoft SQL Server Management studio to hold code and run stored procedures.
Monitor, review and facilitate SharePoint-based Enterprise Change Management process.
Extracted, analyzed and built reports using MS Excel and Tableau.
Users and developers were virtually connected throughout teh United States. Teh project was to process mortgage loans for teh various government refinance programs. We used government established rules to categorize loans as meeting (HAMP, FHA and FNMA) authorized refinancing options.