Sql Data Analyst Resume Examples

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.

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

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.

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.

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.

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.

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.

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.

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

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