Data Analyst / Reports Developer Resume Atlanta, Georgia - Hire IT People

SUMMARY:

Customer - focused and technically savvy Business Intelligence Developer with 15 years of Information Technology experience.
Skills include: Writing T-SQL queries and stored procedures in SQL Server 2005/2008/2012.
Developing meaningful Reports and Dashboards with SSRS and QlikView.
Hardcoding Visual BASIC user interfaces that connect to backend databases.
Building SSIS Packages to perform extraction, transformation and loading routines.
Creating Excel macros, vba modules, and pivot tables.
Analyzing and transforming raw data into useful information.
Identifying and resolving database issues related to T-SQL coding errors and data anomalies.
Successful at prioritizing and performing multiple tasks that have competing priorities.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

Data Analyst / Reports Developer

Responsibilities:

Main Focus: Build Clinical and Operational Performance Reports to drive business decisions.
Serve as main point of contact for data and report requests.
Collaborate with Clinical Group Directors and Business Analysts to gather, define, evaluate, and document requirements.
Write T-SQL queries including stored procedures to manipulate and aggregate data.
Build SSIS packages to extract, transform, and load data into and out of SQL Server databases.
Design reports in SSRS (Visual Studio) and export to Excel Pivot Tables for analysis.
Respond to and create ad hoc reports in Report Builder.
Identify and correct data quality issues including data discrepancies
Performance-tune slow running SQL queries when necessary.
Build and generate dashboards in QlikView.
Ensure all data is clean, accurate, and complete.

Confidential, Norcross, Georgia

Business Intelligence Developer

Responsibilities:

Primary Goal: Assisted with creating Business Intelligence Solutions.
Participated in Project Team Meetings to define project scope and agree on time estimates.
Worked in extremely large SQL Server Data Warehouse environment. (2 Terabytes)
Wrote T-SQL queries including stored procedures to alter, modify, and update data in SQL Server 2012 Databases.
Pulled varying amounts of data from SQL Server and Teradata Databases.
Developed, tested, and deployed SSRS Reports to SharePoint. (On-going Project).
Built SSIS packages that scrubbed and converted data, sent emails, handled errors, and populated new SQL Server 2012 Databases. (ETL Project)

Confidential, Overland Park, Kansas

Business Intelligence Developer

Responsibilities:

Major Goal: Assisted with Business Intelligence Solutions.
Participated in meetings with various Department Teams to discuss, determine, and document requirements.
Worked on BI Solution and created Reporting Project that consisted of scorecard reports.
Scorecard reports were used to monitor company employees work performance.
Created Performance Evaluation Reports that showed KPIs (key performance indicators)
Set up ETL Project (as part of BI Solution) and built SSIS packages to extract, transform, map, and load Excel, Access, and flat files into SQL Server 2008 Database.
Applied transformations in SSIS packages to clean, convert, transform, split, merge, join, and aggregate data.
Collaborated with Software Developers and created mortgage loan software application written in Visual BASIC.NET.
Finished all work on time and within budget constraints.

Confidential, Atlanta, Georgia

Data Analyst

Responsibilities:

Nature of position: Analyzed and evaluated sales transactions information.
Compiled, analyzed, modified, and cleaned incomplete sales data.
Attended meetings to discuss business needs related to collecting and evaluating sales data.
Created SQL tables, enforced integrity, and applied clustered indexes on large tables.
Wrote various T-SQL queries such as inner and outer joins, unions, and common table expressions.
Identified KPI’s (Key Performance Indicators) that determined which products and services sold better based on monthly dates and geographic locations.
Imported data from SQL Server into Excel spreadsheets and produced pivot tables to filter data.
Created weekly Sales Reports in Excel and Summary Reports in Crystal Reports.