Database Analyst Resume Charlotte, NC - Hire IT People

SUMMARY:

Data Analyst with 4 years of experience in data manipulation, reporting, and analytics.
Experience utilizing Teradata SQL Assistant in conjunction with Integration Services and SQL Server to develop an ETL package for UI.
Excellent RDBMS skills in Microsoft SQL Server 2005, 2008, and 2012
Knowledge of software design & development methodologies.
Performed development work adhering to Software Development Life Cycle Activities (SDLC) and RUP.
Several years of development experience utilizing SSIS, SSRS, Microsoft SQL Server, and Teradata SQL Assistant.
A self - motivated professional and natural communicator possessing great technical, initiating, leadership and problem-solving skills and has proven to be a good team player.

TECHNICAL SKILLS:

Operating Systems: Windows 98/2000/XP/Vista/7/8/8.1/OS X

Programming: Core Java, SQL, Delphi, C++, VB.NET, C#

Scripting Languages: JSON, JavaScript, CSS

Environment: s: Visual Studios 2010 & 2012, Eclipse, Delphi 5 & Delphi XE2, IBM AS400

Middleware: Web Services, SOA

Business Intelligence Tools: Microsoft SQL Server, Teradata SQL Assistant, Integration Services

Repository: Subversion, GIT, Team Foundation Server

Markup Language: XML, HTML,XSLT

SORs: MSP, LIS, LPS, CORE

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Database Analyst

Developed, modified, and maintained ETL to create reports and populate UI utilizing Integration Services (SSIS) and SQL Server.
Developed complex SQL queries to test data generated by the ETL against the Teradata databases.
Collaborated with business analyst to discuss technical requirements for implementing changes to ETL package.
Created tables and views in Teradata, according to business requirements.
Created release documentation for business partners in order to maintain metadata dictionary.
Provided production fixes and involved with correcting production support issues.

Confidential, Charlotte, NC

Application Systems Engineer

Configured management controls within the Early Resolution mortgage application to meet government standards and business requirements.
Worked with SQA team to assist with Software Testing life cycle.
Responsible for analyzing and resolving configuration defects in production environment.
Collaborated with business analyst to discuss technical requirements for implementing changes to mortgage application.
Created functional documentation to clarify business requirements to end users.
Led trainings and demos to address application changes with senior management and end users.

Confidential, Charlotte, NC

Technical Implementation Analyst

Configured RTLS application environments for new and existing customer site implementations; configuration included interface setup, transforming and loading data into multiple SQL tables, user setup, and configure application server.
Worked closely with database administrators/application support team to troubleshoot SQL Server issues, test database updates, and provide them with application specific knowledge.
Updated functional documentation to support client system processing.
Identified and resolved escalated customer productions issues by conducting root cause analysis.
Analyzed application updates/upgrades by testing them in local environments.
Assisted development/project manager with analyzing project requests to determine feasibility and gather requirements.
Created technical implementation guide for configuration of proprietary company software.

Confidential, Charlotte, NC

Junior Programmer/Analyst

Provided support for current insurance web based application and developed new code using vb.NET and C# with a Microsoft SQL 2008 R2 backend
Responsible for monitoring several systems including Microsoft Server 2008 r2, IIS, SQL, middleware servers and IBM iSeries AS400 servers, troubleshooting issues and customer support to ensure ongoing satisfaction to all user
Responsible for Team Foundation Server 2010 and Sharepoint 2010 Administration.
SQL administrator for Insurance IT department
Responsible for code migrations through SDLC up to production environment
Executed implementation processes for new and existing customers.
Provided support for current insurance web based application and developed new code using vb.NET and C# with a Microsoft SQL 2008 R2 backend

Confidential, Davie, FL

Entry Level Software Developer

Participated in all phases of the SDLC between business requirements and integration testing using Delphi and Object Pascal.
Created internal documentation to enhance staff’s understanding of how database tables and software are related to one another.
Wrote Web Service methods that exposed a log in function to users of the system.
Assisted with technical support to aid clients and to increase knowledge of software.
Developed mobile web application using Ext JS 4 and utilized the Model-View-Controller design pattern.
Worked with senior developer to further programming knowledge.