OBJECTIVE

My objective is to reduce time spent on manual processes through automation, while leading others to create integrated solutions.W

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr. Sql Developer

Responsibilities:

• Specializing in Sql Server/Nextgen Data Migrations and systems integration
• T - sql stored procedure, functions, views, trigger, and index development, performance tuning
• ETL for compliance reporting: data imports and extracts based on layout specs, (s)ftp, tsql, SSIS, C#- CLR assemblies for Sql Server, SSIS script tasks, migration/integration utilities for documents and imaging, binary file transfers wif Sql Server
• Mirth Interfaces: HTTPS restful web services integrated wif Nextgen templates, ADTs
• Wrote a custom Cryptography class in Java/Eclipse for encryption using certifications in Mirth interfaces
• Maintain C# Claims application for 270/271 messages and response files
• Reporting: Crystal Reports, ad hoc T-Sql Reports, and SSRS, Excel Pivots
• Nextgen Template and Document development (Nextgen SDK and aforementioned T-SQL dev)
• Gather requirements from clients and quote project hours
• New development, maintenance, tickets, team and individual projects, head initiatives, code demonstration and peer review
• 100% Remote Development using VPN, Skype, Gotomeeting

Confidential, TX

Sr. Sql Developer

Responsibilities:

• Promoted to lead tech after only 10 months on teh job
• T-SQL stored procedures, functions, triggers, table design, data normalization, and performance tuning(execution plans, profiler)
• Lead teh provider directories data parsing project (VBscript/C#/T-SQL) - capture provider name, address, ph#, specialties, and healthplan associations from competitor PDFs and load their providers into a db for marketing purposes
• SQL Data mining using statistical analysis calculations such as Levenshtein distance and custom code
• Sql Server 2008R2/2012 Database ETL (SSIS, BCP) for HHSC report extracts and interface development
• Created HHSC reports for a number of provider file extracts/interfaces
• Trizetto software installations and maintenance (QNXT, CCA)
• Business analysis and project management, meeting facilitation for requirements gathering and discussion
• Testing/QA and implementation (change control process)
• Host teh peer code review meeting and mentor jr developers

Confidential, Allen, TX

Sr. Sql Developer consultant

Responsibilities:

• ETL activities: (utilizing sqlcmd, bcp, and/or ssis) ICS imaging, demographics, charts, insurance, and clinical data (extracting from any client database, loading into Sql Server 2005/8/12, and mapping/converting teh data)
• Stored procedures, functions, triggers, table design, data normalization, and T-Sql performance tuning
• Crystal Reports development
• Mirth HL7 interfaces (javascript)
• Project management, mentor junior developers in Sql, analyze project requirements to quote hours to help management win bids, track billable hours in daily timesheet
• Process and code documentation, participate in code reviews, perform program/code demos for clients and management
• Nextgen template development: system/practice utility templates
• Developed VB.net program to convert images into PDFs
• Worked remotely through VPNs and web-meeting software

Confidential, TX

Software Developer III

Responsibilities:

• Lead HL7 interface engineer on dual national PACS systems for both Maternal Fetal Medicine and Pediatric Cardiology (Mirth Interface Engine)
• Parsed xml wif Javascript, loaded tab delimited text files into SQL Server 2005/2008R2 using bulk insert, transform data and process interface transactions into Medical Records systems using stored procedures and triggers
• Developed and maintain a “Data Repair” system and UI for HL7 messages utilizing a Nextgen system template
• Coordinate and test Rosetta HL7 interfaces wif clinical resources, develop and maintain Mirth HL7 interfaces
• T-SQL Development and efficiency tuning: procedures, functions, triggers, indexes, design tables and normalize data
• Nextgen practice migrations - migrate demographics, charts/encounters, template sets, documents
• Part of team in 2010 that migrated 80 Crystal reports to SSRS
• Nextgen Template development (non-clinical utility templates)
• Project Mgmt, technical documentation, demos and code review

Confidential, Richland Hills, Tx

EMR Developer

Responsibilities:

• Development and support for Dev/Test/Production MS Sql Server 2000 and 2005 databases (user defined functions, stored procedures, table indexing, views).
• Develop reports in MS SQL Server Reporting Services, as well as ad hoc performance, research, and investigative reports
• Import xls and txt (delimited) data files for new partners/clients data migrations using C# and T-Sql, transform data using stored procedures and process into existing Nextgen table structures
• Develop form based C# applications to automate and assist in daily activities, data migrations, and reporting
• Automated teh Lab Unassigned process resulting in teh reduction of 40 hours of work per week for teh support/development group (sql stored procedures)
• Nextgen Template development based on doctor forum requirements
• Nextgen Template migrations from custom in house templates to Nextgen KBM standard templates

Confidential, Tx

Sr. Systems Analyst

Responsibilities:

• Lead a group of 3 other Traffic Engineers and interface directly wif VP and Director level management
• Developed SQL Server 2005 and MySQL data warehouses for network inventory (hardware utilization) and network traffic analysis (user defined functions, stored procedures, table indexing, database log file and physical size management)
• Import Call Detail records and network hardware port assignments into data warehouses (delimited txt and fixed length text) either from file extracts or directly from SSH/Telnet sessions into teh equipment (vbscript/Perl, T-sql bulk insert, Windows Task Scheduler, SQL Server Agent)
• Produce SQL reports for internal customers/groups on subjects such as: network cost/capacity/traffic, equipment inventory, operational metrics, order interval analysis, ad hoc reports
• Create scripts to manage program updates, automate daily SQL reporting, batch process logging/error reporting, network hard drive backups, Batch FTP
• Develop form based VB6/VBA Applications for Network Inventory Automation and Provisioning Order Fulfillment
• Install and configure Linux based source and RPM based programs, including configuration of XML files

Confidential, Tx

Application Engineer

Responsibilities:

• Won teh company’s quarterly performance award for 4th quarter ’05 after only 6 months of employment
• Developed and implemented HL7 interfaces wif client hospitals/clinics utilizing IDX ConnectR and Javascript/VBscript (Demographics, Charge entry, Appointment Scheduling, Charge Edits and notation) using
• TIF image batching, Automated bad debt writeoff process, Automated Medicare fee schedule creation, ANSI X.12 - 835 remit file parsing and payment posting (Sql Server 2005/Javascript/VBscript/xls/txt/Bash/Perl)
• Maintain/develop applications: Groupcast, XML configuration based web pages, MS Access, Cognos Impromptu
• Install, maintain, and update IDX Groupcast databases on an IBM P570 logically partitioned into 30 individual servers (AIX Unix)
• Shell scripts for UNIX/Windows maintenance/automation (Bash/VBscript)
• Created/maintained extensive documentation on processes/procedures, and code, while interfacing wif internal, and external (client) groups, remote and local

Confidential, TX

Manager of teh Network Elements

Responsibilities:

• Managed a team of 5 engineers, technicians, and developers in simultaneous concurrent projects, utilizing exceptional communication skills.
• Develop service level agreements and process models wif internal customers
• Design and document voice and data networks
• ETL activities: pull network hardware port assignments from hardware (ssh/telnet or import from txt files), load them into Oracle 9i/MS Access databases using VBA
• Develop/design Microsoft Access databases for inventory, operational measurements, and order fulfillment
• Produce monthly inventory utilization and order fulfillment reports for executive review(MS Access, VBA, Excel, SQL)
• Developed Visual Basic 6 applications for inventory/order fulfillment (10 users)

TECHNICAL SKILLS

Skills: MS SQL Server 2000-2012, C#/VB.net/VB6, Vbscript, Javascript, DOS batch, Bash scripting, Cognos, IDX Groupcast, AIX Unix, Linux/BSD, HL7, Nextgen EHR/EPM/Rosetta, XML, Cisco Tidal, Trizetto QNXT