SQL Developer/ Analyst Resume Birmingham, AL - Hire IT People

SUMMARY:

Design, implement and troubleshoot ETL processes used in the data mining of various hospital information systems, including laboratory, pharmacy, surgical and ADT data feeds.
Analyze varied and evolving data sources from HL7 interface or flat file interface
Design models to extract and transform data according to business needs
Design ERDs, Relational Models for Implementation Environment whenever database extension is needed
Designed ETL process to ETL data from HL7 or flat file interface to operational
Data models using SSIS or .NET windows services programmed by C#
Collaborate with internal partners to understand data needs
Utilize T - SQL, C#, regular expression, SSIS and other tools to build data auto validation and data auto modification

TECHNICAL SKILLS:

Programming languages: T - SQL, C++/C#, .NET, Python, Javascript

Software tools: SSIS, Visual Studio 2012, Visio, Monarch Model V7, Microsoft Office

Operating Systems: Windows (2000, XP, Vista, 7, 8, 10), Mac OS, Linux

Database: MS SQL Server 2005, 2008, 2012, 2014, 2016

Skills: Data modeling, Relational database design, Data warehouse, Database Development Cycle, Regular expression, Healthcare IT, ETL, Production model, HL7 Interface, Medical Informatics

Professional: Self-motivated, Creative Thinker; Detail-oriented; Troubleshoot, Excellent time management skills

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, AL

SQL Developer/ Analyst

Responsibilities:

Design, implement and troubleshoot ETL processes used in the data mining of various hospital information systems, including laboratory, pharmacy, surgical and ADT data feeds.
Analyze varied and evolving data sources from HL7 interface or flat file interface
Design models to extract and transform data according to business needs
Design ERDs, Relational Models for Implementation Environment whenever database extension is needed
Designed ETL process to ETL data from HL7 or flat file interface to operational
Data models using SSIS or .NET windows services programmed by C#
Collaborate with internal partners to understand data needs
Utilize T-SQL, C#, regular expression, SSIS and other tools to build data auto validation and data auto modification
Utilize T-SQL to develop various of scripts to create reports for clinical implementation specialists
Query optimization/tuning, knowledge of indexes, index management, Euery Execution plan/usage and statistics I/O
Troubleshooting and resolving database and application problems in SQL server environment
Transact-SQL Querying, Table Joins and sub queries, Sorting and Filtering data
SQL Data types and importance, Grouping and aggregating data, Table valued expression
Window functions including ranking, aggregate and offset functions
Excellent knowledge in creating Databases, Tables and Indexes using T-SQL.
Creating local and global temporary tables
Creating Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors
Table partition and data compression
Creating and modifying constraints
Pivot and un pivoting of data
Knowledge on SQL locks and SQL injection
Error Handling in SQL server
Index maintenance, identifying index fragmentation
Transaction management in SQL Server
Managing Log file growth
SQL Server profiler and agent
SQL deadlocks and optimization
Query Execution plan and usage
Performance Tuning and Query Optimization

Confidential, Johnson City, TN

Graduate Research Assistant

Responsibilities:

Developed new experimental and computational methods for discovery through genomics, epigenetics, and informatics.
Enable new discovery methodologies employing massively parallel sequencing and other high-throughput genomic and epigenetic technologies

Confidential

Database Developer

Responsibilities:

Developed solutions using SQL, and developed relational databases
Master a complex financial data model in order to efficiently extract data for delivery to downstream systems and end-users.
Translate business requirements into efficient software solutions.
Resolve issues by performing root cause analysis, coding immediate solutions, and documenting and recommending long-term improvements.
Developing or making needed revisions to internal applications
Manage Production database and perform database backup, recovery.

Confidential

Student Web Developer

Responsibilities:

Developed and maintained individualized websites for a range of divisions across the university
Assist in the technical administration of the campus intranet and calendar systems

We provide IT Staff Augmentation Services!

Sql Developer/ Analyst Resume

Birmingham, AL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship