lasydney.blogg.se - Sql tools for data analysis

Generated variety of business reports from SQL server using excel with pivot table and pivot chart.

Loaded flat and Excel files into Access database and developed SQL scripts to create desired queries (views) 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.

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.Reformatted the data and inserted the reformatted data into staging table, performed data cleansing and data type conversions and then loaded into destination table.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.Created database tables with various constraints including primary key, foreign key, etc.Obtained and analyzed the informational business requirements from various clients.Assisted managers and business analysts in developing reports, presentations, and analysis for upper management.Established departmental procedures, metrics and work flow where none previously existed.Trained within and outside the team to give basic understanding of the CMS risk adjustment process.Downloaded data from FTP site, integrate data to a database and extract data for analysis.Extensively investigated different data issues and communicated with clients to resolve the issues.

Analyzed a financial impact of a RAPS file using a risk score of each HCC (ICD9), based on the CMS-HCC Model.

Developed data loading programs that integrate RAPS file data for further financial impact analysis.

Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.

Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects.

Developed SQL program to create a customized RAPS file and a customized RAPS return integration for clients based on client request.