Sql Data Analyst Resume Samples

HIGH QUALITY

The best examples from thousands of real-world resumes

EXPERT APPROVED

Handpicked by resume experts based on rigorous standards

DIVERSE EXAMPLES

Tailored for various backgrounds and experience levels

SQL Data Analysts handle a variety of domains, industries and tools used in the data analyst industry. Typical work activities performed by these experts include importing and modeling data, assisting management with decision making, analyzing and presenting data, cooperating with business analysts and engineers, and optimizing databases. Those interested in an SQL Data Analyst position should showcase in their resumes database management expertise, organizational skills, teamwork, problem solving orientation, and attention to details. Successful resume samples mention a Bachelor's Degree in a relevant field like statistics, information management or computer science.

For more information on what it takes to be a Sql Data Analyst, check out our complete SQL Data Analyst Job Description.

Want 2-3x more interviews (guaranteed)? Get a Professional Resume Rewrite from ZipJob

1

Senior SQL Data Analyst

Developed SSIS Packages to provide data integrity between production and test environments.

  • Used Microsoft SQL Server 2005 an 2008 to develop procedures to maintain the company's legal and contractual compliance.
  • Provided project development for all internal pending requests.
  • Created automate processes through stored procedures utilizing T-SQL to facilitate additional production capacity and not overburden the main data server
  • Optimized stored procedures in to extract, transform and load (ETL) data to ensure reporting infrastructure was maintained according to current service level agreements.
Candidate Info
8
years in
workforce
3
months
at this job
BA
Business
2

SQL Data Analyst

  • Reviewed data and classified the tables/measures functions by using multiple queries, views and procedures
  • Designed database schema contains over 30 tables such as users, groups, threads and posts
  • Established the connection between legacy system and Discuz forum software using MySQL and SQL Server
  • Migrated data from legacy system to Discuz through SQL Server and completed 99% records mapping
  • Resolved kinds of software or database related issues such as data loading and migration
Candidate Info
2
years in
workforce
6
months
at this job
BS
International Economics And Trade
MS
Information Technology & Management
3

SQL Data Analyst

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and other T-SQL code to implement business rules

  • Created parameterized reports and adhoc reports using Report builder.
  • Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.
  • Performed unit testing and path testing for application.
  • Designed and implemented a user interface to access data using PowerBuilder.
  • Created triggers for cascading update and delete operations to maintain data integrity.
  • Worked with ADO.NET objects to connect to the databases.
Candidate Info
2
years in
workforce
2
years
at this job
BS
Information Technology
4

SQL Data Analyst

Created Risk Adjustment Processing System (RAPS) file from row claim data for Medicare and Medicaid programs and submitted to CMS. Downloaded a risk adjustment return file from CMS, and integrated to a database.

  • Developed SQL program to create a customized RAPS file and a customized RAPS return integration for clients based on client request.
  • Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects.
  • Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.
  • Developed data loading programs that integrate RAPS file data for further financial impact analysis.
  • Analyzed a financial impact of a RAPS file using a risk score of each HCC (ICD9), based on the CMS-HCC Model.
  • Extensively investigated different data issues and communicated with clients to resolve the issues.
  • Downloaded data from FTP site, integrate data to a database and extract data for analysis.
  • Trained within and outside the team to give basic understanding of the CMS risk adjustment process.
  • Established departmental procedures, metrics and work flow where none previously existed.
  • Assisted managers and business analysts in developing reports, presentations, and analysis for upper management.
Candidate Info
3
years in
workforce
2
years
at this job
BS
Mathematics
MS
Applied Statistics
MS
Mathematical Statistics
5

SQL Data Analyst

Created Risk Adjustment Processing System (RAPS) file from row claim data for Medicare and Medicaid programs and submitted to CMS. Downloaded a risk adjustment return file from CMS, and integrated to a database.

  • Developed SQL program to create a customized RAPS file and a customized RAPS return integration for clients based on client request.
  • Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects.
  • Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.
  • Developed data loading programs that integrate RAPS file data for further financial impact analysis.
  • Analyzed a financial impact of a RAPS file using a risk score of each HCC (ICD9), based on the CMS-HCC Model.
  • Extensively investigated different data issues and communicated with clients to resolve the issues.
  • Downloaded data from FTP site, integrate data to a database and extract data for analysis.
  • Trained within and outside the team to give basic understanding of the CMS risk adjustment process.
  • Established departmental procedures, metrics and work flow where none previously existed.
  • Assisted managers and business analysts in developing reports, presentations, and analysis for upper management.
Candidate Info
2
years in
workforce
2
years
at this job
MS
Mathematical Statistics
6

SQL Data Analyst & Developer

Sarbanes-Oxley-compliant contract consulting & data analysis for metal coating client firm.

  • Diagnosed & customized EDI data & middleware, saving the client from large non-compliance fines.
  • Troubleshot & enhanced ERP software & databases & maintained their interfaces.
  • SQL, Inovis TrustedLink EDI, Movex (Lawson), Infor ERP XA, Infinium.
Candidate Info
5
years in
workforce
1
year
at this job
BS
Math / Computer Science
MBA
Master of Business Administration
7

SQL Data Analyst

  • Used SSRS to create versatile reports and presentations for business groups and sales associates.
  • Wrote and executed SQL queries using Query Analyzer to provide custom reports to marketing and sales
  • Coordinated meetings to gather business requirements to improve usability of Onyx CRM and implemented changes to resolve pain points for these users.
  • Carried out the importing of thousands of 3rd party sales leads each week into the Onyx database using DTX packages and performed processes to maintain data hygiene.
  • Worked closely with the marketing group to gather requirements for custom reports and client lists to support advertising campaigns.
  • Provided varied support of the Onyx CRM software to over 600+ internal users worldwide
  • Operated as a liaison between the technical support group and development teams to increase awareness of customer issues and resolve problems outside of my group’s reach.
Candidate Info
12
years in
workforce
4
years
at this job
C
Project Management
AS
Arts
8

SQL Data Analyst/quality Assurance Department

Designed and developed specific databases for collection, tracking, and reporting of data using Visual Studio Management.

  • Designed, coded, tested and debugged custom queries using Microsoft T-SQL and Crystal Reports per defined technical specifications.
  • Managed the extraction, transformation, and population of data files and databases (MS SQL Server 2008, Excel, and Access)
  • Worked directly with customers and team members to determine project scope and specifications. Provides research and analysis to support intelligence organizations.
Candidate Info
7
years in
workforce
3
years
at this job
C
Oral Radiology & Dental Assisting
AAS
Applied Science
AA
Information Systems
9

SQL Data Analyst

SQL querying to deep dive into the datasets to search for business insights

  • Extensive experience in Relational and physical data modeling for creating logical and physical design of Database and ER Diagrams.
  • Worked extensively in forward and reverse engineering processes.
  • Fluent with TSQL or PL/SQL
  • Good Knowledge of ETL Processes such source, mapping, transformation, staging areas and created various ETL documents such as ETL Mapping documents, Data Mapping documents.
  • Trained new recruits in data compilation, strategic research, data extraction, integrated insights, and analyses
Candidate Info
4
years in
workforce
1
year
at this job
10

SQL Data Analyst

[company name] is an IT consulting company providing program management, requirements gathering, and strategic planning services to companies who are driving big changes in our modern world; from defense and healthcare, to technology and financial services.

  • Obtained and analyzed the informational business requirements from various clients.
  • Created database tables with various constraints including primary key, foreign key, etc.
  • Loaded data from flat data files into SQL Server database tables using bcp, bulk insert, and table import; Created ETL packages using SQL Server SSIS Designer to extract data from flat file and excel files
  • Reformatted the data and inserted the reformatted data into staging table, performed data cleansing and data type conversions and then loaded into destination table
  • Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL stored procedures, user defined functions (UDFs) for data analysis
  • Extracted data from SQL Server database tables into flat data files and Excel sheets using table export and BCP for easy data migration
  • Loaded flat and Excel files into Access database and developed SQL scripts to create desired queries (views) for data analysis
  • Generated variety of business reports from SQL server using excel with pivot table and pivot chart
  • Created excel reports with pivot, drill-down and drill-through functions from Access
  • Designed macros to transfer data between Excel and Access with task automation and generate reports with automatic formatting using VBA scripts
Candidate Info
4
years in
workforce
3
years
at this job
BS
Chemistry
MA
Chemistry

Your Resume, Made Easy.

You are looking for your dream job and need a resume? My Perfect Resume is your solution and takes the hassle out of resume writing. Create the perfect job-worthy resume effortlessly in just a few clicks!