- Featured in:
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
No results found
Candidate Info
years in workforce
months at this job
Business
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
years in workforce
months at this job
International Economics And Trade
Information Technology & Management
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
years in workforce
years at this job
Information Technology
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
years in workforce
years at this job
Mathematics
Mathematical Statistics
Applied Statistics
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
years in workforce
years at this job
Mathematical Statistics
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
years in workforce
year at this job
Math / Computer Science
Master of Business Administration
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
years in workforce
years at this job
Project Management
Arts
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
years in workforce
years at this job
Oral Radiology & Dental Assisting
Applied Science
Information Systems
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
years in workforce
year at this job
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
years in workforce
years at this job
Chemistry
Chemistry
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
years in workforce
years at this job
Business Computer Systems
SQL Data Analyst/ Database Administrator
Responsible for work flow, productivity and the overall management and monitoring of the Electronic Medical Record Database with the main goal to achieve the highest level of quality patient care which responds to the needs of the community that is also accessible, affordable and appropriate. Working closely with, and report to the Chief Information Officer, and participates in planning and program development, quality assurance and continuous quality improvement, budget development, reporting and ensuring compliance with regulations and licensing requirements
- Operate help desk and active support via telephone, E-mail, Web and onsite as needed.
- Develop, test and document Medinformatix Electronic Medical Record templates according to design specifications
- Develop, test and document Medinformatix Electronic Medical Record clinical development and reports using standard SQL based query and reporting tools
- Performing trouble shooting, diagnostics, customization, minor development, remote training.
- Setup, install, and testing existing developed databases as well as implemented, monitored, and maintained disaster recovery.
- Monitored and fine-tuned databases performance
- Use analytical skills to troubleshoot data problems surfaced through the reports as needed.
- Use and support enterprise level report writing tools to develop standard clinical and financial reports for both departmental and enterprise use as well as maintain and support existing reports against required standards of performance.
Candidate Info
years in workforce
year at this job
Business Administration
SQL Data Analyst/i.s. Specialist
Developed an in-house application which allowed users who were on-call to synchronize database information to a laptop
- Database support (SQL Server, MS Access)
- Ran jobs to migrate data from a UNIX database to a SQL Server database using DTS packages created in SSIS
- Normalized databases to consolidate into an enterprise system
- Developed database application using VBA
- Solved business problems applicable writing queries
- Assisted customers in solving application problems
- Designed and Developed reports using Crystal Reports
Candidate Info
years in workforce
year at this job
Computer Information Systems
SQL Data Analyst II
Identified and developed data processing tools through automation and standardization using data analysis and design. Demonstrated a high level of motivation, efficiency, and ability to meet any objective with proven ability to troubleshoot with a high degree of initiative and good judgment.
- Data manipulations/scrubbing
- Update and enhance data imports and exports
- Data Analysis
- Data Extracts
Candidate Info
years in workforce
year at this job
Electronics And Communications Engineering
Electrical Engineering
SQL Developer/sql Data Analyst
- Responsible for monitoring of scheduled SQL jobs running SSIS Packages for daily loading of production data. Troubleshooting the cause of the failure and rerunning the package.
- Setting up the automation process of downloading real estate MLS listings feed and photos.
- Perform data analysis for data integrity, perform data cleansing & normalization of data.
- Building stored procedures involving complex joins, sub queries, aggregate functions, User defined functions using TSQL and advanced SQL for a variety of business requirements.
- Scheduled windows batch jobs and SQL jobs using SQL Server Job Agent.
- Handle tickets/issues affecting production and staging data on the web sites.