We provide IT Staff Augmentation Services!

Application Analyst Resume Profile

3.00/5 (Submit Your Rating)

LowA

Hire Now

Work Experience

Confidential

Senior Analyst
  • Converted SQL databases from SQL Server 2008 R2 to 2012.
  • Analyzed the 2008 R2 database model and design.
  • Identified areas to improve the design.
  • Created the new model within SSMS.
  • Designed and re-wrote SSIS packages that could not be upgraded
  • Designed the new 2012 data warehouse for the Client/Clinical data.
  • Created and executed the jobs.
  • Coded the T-SQL procedures.
  • Designed and executed new SSIS packages.
  • Upgraded and optimized the existing SSIS packages.
  • Automated the running of SSIS packages using SQL Server Agent
  • Converted Microsoft Access databases back ends from SQL Server 2008 R2 to 2012 for process that were going to be discontinued in the near future.
  • Converted reports previously created using Microsoft Access to SQL Server Reporting Services.
  • Created reports utilizing SQL Server Reporting Services to display KPIs to customers.
  • Worked as a Project Lead on projects
  • Gather information from customers to create a business requirements document.
  • Utilized business requirements document to create technical specifications documents.
  • Created any SSIS packages needed for new data feeds into Data Warehouse.
  • Created and executed stored procedures.

Confidential

Analyst

Continued to perform previous duties and created additional ETL processes. Automated the month-end billing reports, reducing the amount of time to create and distribute the reports from 4 days to just 1 day. Involved in many process automation projects to streamline data collection and reporting. Performed data analysis to support different quality initiatives and contracts for Iowa Health System and all of its affiliates. Promoted to Senior Analyst on the Enabling Technologies team in the Strategic Analytics department.

Application Analyst

Confidential
  • Developed a new Data Warehouse utilizing SQL Server 2008 R2.
  • Created SSIS Packages to bring data from multiple data sources into the data warehouse.
  • Created a Center for Medicare and Medicaid Services CMS approved registry to submit data on behalf of physicians for their Physician Quality Reporting Services program.
  • Created SSIS packages to bring in the necessary clinical and billing data.
  • Created T-SQL stored procedures to calculate the performance on 32 metrics.

Confidential

Informatics Analyst

Pull and analyze data relevant to organizational initiatives including quality, electronic health records, coding, etc. , in the appropriate use of statistical methods, and in the interpretation of findings so that it is meaningful and understandable for a wide variety of stakeholders. Use statistical methods to transform both quantitative and qualitative data into information which can be used by management for strategic planning and evaluation of organizational operations, compliance, quality of care and process improvements. Support Compliance, Privacy and Security Officers in auditing and analyzing system access to patient Electronic Health Records and in other investigations. Played a very instrumental part in the reduction of the department's workload by 18.26 through process automation.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship