Senior SQL Developer Resume

TECHNICAL SKILLS:

Skills / Languages: MS Office (13 Years), SQL (10 Years), Access 97 (13 Years), HTML (10 Years), Reporting Manager (10 Years), SSIS (5 Years), TWS (5 Years), C# (3 Years), ASP.NET (3 Years), JavaScript (1 Year)

Tools: MS Office, Visual Studio, SQL Management Studio, MS Reporting Manager, Fiddler, NServiceBus, Resharper Green

PROFESSIONAL EXPERIENCE:

Confidential

Senior SQL Developer

Responsibilities:

Developed SSIS packages to perform data migrations from legacy system to new system
Developed an ASP.NET Web Application in .Net Framework 4.5.2 using C# to accept incoming JSON files from clients to create new plans and benefit structures
Developed SSIS packages to pull data from the production server and migrate it to an archive server. Rolled the SSIS packages into a TWS job and scheduled it to run nightly
Optimized and documented stored procedures in SQL to prevent server deadlocks by reviewing the joins used, primary/foreign keys available, indexes, triggers, views and replication
Worked closely with the Software Quality Assurance department to perform unit tests on all code written to ensure 100% test coverage

Application Services Supervisor

Responsibilities:

Responsible for creating and reconciling weekly payments, voids and adjustments using Access ’97 databases with ODBC connections to SQL databases. Wrote SQL queries and used Reporting Manager to find discrepancies in billing prior to payments being issued
Developed new billing API and migrated existing data in Access ’97 to new SQL Server. Application was used to track all payments issued, adjustments and voids. When adjustments caused providers to have a negative balance, the system tracked and recouped against future payments
Created billing statements, detail reports and data extracts to send to our clients for each check run. Provided customer service and assisted clients with any questions they had with their bill
Created new reports in MS Reporting Manager to allow for better analysis and error prevention by my employees in the billing department
Performed all claim history, membership, benefit, and provider data loads from external clients using DTS and SSIS packages. Created TWS jobs for any reoccurring loads and scheduled them to run during non - business hours
Responsible for all Electronic Data Exchanges with our dental providers by taking in 837 Claim Files and providing 835 Remittance Files. Ensured that all data exchanges were HIPPA compliant

Systems Analyst

Responsibilities:

Supported Access ’97 and SQL databases by running SQL queries to perform routine updates and correct data issues
Ran Access ’97 macros to create payments, print checks and provider remittance reports for each client weekly
Balanced all weekly check runs for each client using total amount paid in claims with adjustments and voided checks deducted. Responsible for analyzing and trouble-shooting check runs that didn’t balance
Configured all benefit check edits and database workflow procedures for existing and new clients using SQL queries to perform data updates and inserts

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship