Sql Server Software Engineer

DAN EZRA GOLDEN ALEXANDRIA, VIRGINIA

*************@*******.*** 703-***-****

Skills Absence Management, Active Server Pages, Ad Hoc Reports, ADO.net, Benefit Plans, Business Analysis,

Business Objects WEBI and DESKI, Business Requirements, C#, Claims Reporting, Crystal Reports, CSS, DBA,

Documentation, Encapsulation, Extract Transform Load Tools, Government Healthcare, Healthcare Research,

Incidents Reporting, Industry Health Insurance, Hyper Text Markup Language 5, Inheritence, Information Technology

Insurance Reports, Intranet Development, Javascript, Lotus Notes, Macro Scripting (Excel), Medication Variance

Reporting, MS ASP.Net, MS Excel, MS IIS, MS Outlook, MS SQL Server 200*-****-****, MS SQL Server Business

Intelligence Development Studio (SSRS) MS Team Foundation Server, MS VBA (Excel), MS VB Script, MS Visual

Sourcesafe, Object Oriented Programming, Polymorphism, Risk Management, SAS Services, Stored Procedures

(Including Functions and Views), Training (Government)

Education American University; Bachelor Of Arts in Spanish Studies, Minor in Computer Information Systems

•

• Professional Background Over a decade of business analysis experience working for a risk

management services bureau, the country’s largest publicly traded managed health care

company, a large global outsourcing company, and a small home warranty insurance

organization. Contributed to ad hoc reports containing secure PHI-level HIPAA information

for government clients. Produced quarterly absence management claims trending analysis

reports. Proficient in Excel macro development scripts and prefers an environment where SQL

is the main focus. Maintains positive outlook and very organized approach under tight short

suspense deadlines.

• •

• SERVARUS RM (Data Analyst) • 2013-

2014

• Programming and Analytics Data Analyst and DBA for HIPAA Risk Management and

Employees Benefits applications. Updates reporting tools for Incidents modules, Mediation

Variances modules, and Claims modules in both C# and ASP.Net in one environment and ASP

Classic in another. Both environments utilize SQL stored procedures, functions, and queries to

reproduce reports correctly. Reports are client-based, over an audience of more than 30 clients.

•

• HEALTH NET FEDERAL SERVICES (Healthcare Data Analyst) • 2011-

2013

• Technical Analysis and Development Prepared and developed complex ad hoc reports for

government clients using SAS, Business Objects, and SQL that provided drill down analysis

to proactively identify clients own facility needs. Met with customers in person, on the phone,

or online to design financial, clinical, and operational reports. Manipulated and extracted cost,

utilization, and global positioning data to develop reports and trends. Summarized and

formatted information using tables, graphs, and other styles to support decision-making.

Documented and maintained databases to aid reporting and processes. Analyzed, researched,

and interpreted results, variances, and trends. Contributed over 20 programs written in MS

Excel VBA to aid team with making report formatting easier.

•

• 2007-

AON HEWITT (Senior Software Engineer)

2011

• Technical Analysis and Development Formatted lengthy Excel reports according to report

guidelines including manipulating pivot tables, SQL queries, macros, and graphs. Reports

included periodic deadlines – weekly, monthly, quarterly, and ad hoc. Performed functional

analysis and translated high-level business requirements into working technical plans.

Streamlined report queries, including building SQL Server functions, views, and jobs.

Participated in frequent interactive business meetings with over 30 different clients. Managed

client health benefit plans, company standards. Modified legacy reports to correct

longstanding problems and built new reports to address the changing needs of business.

Prepared extensive written documentation which served as basis for training material for rest

of team. Mentored and advanced professional development of junior colleagues.

•

• 2004-

PROFESSIONAL WARRANTY (IT Support Technician)

2007

• Multi-Platform Programming Singlehandedly wrote Core Product Date Checker program to

check specific date timeframes. Program is still used daily. Migrated two company databases

from ACT! to Intranet created in classic ASP, ADO, SQL Server. Normalized monthly

migration data. Used T-SQL stored procedures, VBScript, UDFs, queries, and ASP Classic.

Contact this candidate