Data Service

KAYRAS BHESANIA

**** ******** ******, *******, ** 94611

******.********@*******.*** 331-***-****

Technical Proficiencies

Programming .NET 3.0/ 3.5/ 4.0 (VS 2008, 2010, 2012), Java

Databases MS SQL Server 2008 R2/ 2012-14, PL/SQL, MS Excel, MS Access

Design/ SSMS,SSAS,SSRS, MS Visio/ ARIS modeling tools

Development

Professional Experience

Business Analyst – Decision Support, July 2014 – February 2015

Strata Decision Technology – Chicago, IL

• Combined SQL and Excel expertise with knowledge of US healthcare data (Billing,

Payments, Insurance, ICD 9/10 PX/DX, CPT codes) to investigate and resolve

reported errors in software in a triaged manner

• Leveraged SSAS (Cubes) to generate cloud-based real-time reports at patient,

charge code and department level for healthcare providers in the US

• Led data integration processes for 3 major healthcare providers; made extensive

use of MS SQL, usage of fact/dimension tables and resolving errors in data

• Trained new employees on the proprietary Strata Jazz platform and wrote client

and employee training user manuals

Data Analyst - Healthcare, November 2012 – June 2014

I5 Health Ltd. – London, United Kingdom

• Performed data mining and analysis for NHS North West England’s poster

presentation in the US on benefits of Non-Medical Prescribing

• Wrote T-SQL algorithms for Payment by Results costing for the National Health

Service in England (for admitted patient, out-patient and accident & emergency

attendances) to identify potential refunds for Clinical Commissioners

• Provided I.T. based Commissioning (decision) support to Clinical Commissioning

Groups via an industry - academia liaison

• Hands-on experience of data quality testing and analysis including using SSRS,

SSIS, Excel on NHS England datasets

• Automated Referral Facilitation Service weekly report generation for 64 GP

Practices in London using SQL queries, views, stored procedures, triggers and

designed RDL/ RDLC and Excel reports. Used MS SQL 2008 R2 for back-end,

SSRS, Visual Studio Report Server 2010 and MS Excel 2010 for generating reports

based on report complexity and client preference

Trainee Systems Officer, April – August 2011

Pakistan Petroleum Limited – Karachi, Pakistan

Academic Qualifications

MSc Software Engineering (Specialist), 2012

Queen Mary University of London, UK

BS (Computer Science), 2010

SZABIST University, Pakistan

Contact this candidate