Database Analyst/Developer (Team Lead) Resume Bethesda, MD - Hire IT People

SUMMARY:

Business Intelligence at Confidential enabled firm to achieve revenue of $20 million per month.
Evaluation at Confidential, based on 10 criteria, was rank top 5% of faculty: part of team that designed the e - Confidential .
System enhancement project at Confidential Corporation and customer relationship management with the Confidential attracted and retained high revenue clients.
Tenacity at Confidential 24/7 operations center contributed to 0% backlog.
Versatile, meticulous, hardworking, reliable, highly organized, fast learner and self - starter.
A technical and business professional seeking to utilize unique skillset and experience.
Strong client-service, communication, problem-solving, interpersonal, leadership, time and project management, multi-tasking, Software Development Life Cycle (SDLC), collaboration, data analysis, system development, lifecycle management, programming, highly motivated, process-driven, and system testing skills.

INFORMATION TECHNOLOGY SKILLSET:

Data Query Language(s): Transact - Structured Query Language (T-SQL), PowerShell

Database Management System(s): Microsoft (MS) SQL Server 200x/ 2012/2014/2016 , MS Access

Query Execution Tool(s): SQL Server Query Analyzer (QA)/ Management Studio (SSMS)

Business Intelligence (BI) Tool(s): SSRS 200X, SSIS 200X, SSAS 200X

Script Repository (Version Control): MS Visual SourceSafe, Team Foundation Server (TFS)

Software Development Tool(s): C#, MS Visual Studio 2010/2012/2013

Service Management Tool(s): Remedy, MyIT Help

Video and Web Conference Tool(s): Cisco WebEx

Reporting Tool(s): Crystal Reports, Oracle Discoverer 3x/9x/10x

Data Analysis, Statistical and Financial Tool(s): MS Excel (Power Query/Pivot), SPSS, Text Pad

Project Management Tool(s): MS Project/Outlook/Word/Visio/SharePoint, JIRA, OTRS

Presentation Application(s): MS PowerPoint, Snag IT

Operating System(s): Windows 7X/9X/200x, Windows NT, Windows XP

Data Deduplication Tool(s): DoubleTake

Network Protocol(s): File Transfer Protocol (FTP), TCP/IP

Online Survey/Educational Application(s): TestPilot, Blackboard

PROFESSIONAL WORK EXPERIENCE:

Confidential, Bethesda, MD

Database Analyst/Developer (Team Lead)

Responsibilities:

Design and develop SQL Server databases for collecting, tracking, and reporting of firm s data.
Create and automate reports and files utilizing SQL Server, SSIS, SSRS and SSAS.
Write T - SQL code to extract data from MS SQL Server Database in support of ad hoc reporting.
Utilize Crystal Reports, MS Access/Excel & Discoverer to analyze data and produce reports.
Determine how new systems or system enhancements may improve business functions.
Design, code, test and debug business logic for software applications using T-SQL.

Confidential, Towson, MD

Faculty

Responsibilities:

Conducted hands - on technical exercises in utilizing contemporary information technologies.
Developed and presented lecture material in accordance with college standards of performance.
Utilized MS PowerPoint to present hands-on technical demonstration of technologies.
Coordinated training with university to ensure that students stay abreast of current technologies.
Utilized Peoplesoft to supplement traditional classroom simulation and manage class.
Prepared on-line examinations based on course curriculum and objectives.

Confidential, Baltimore, MD

Business/Data/Statistical Analyst

Responsibilities:

Performed data, quantitative, and statistical analysis to ensure optimal capacity of vessels.
Analyzed the shipping industry and documented work procedures in Lotus Notes.
Utilized Crystal Reports and tariff system to monitor shipments and commodity rates.
Assisted the information technology team to maintain system and properly route shipments.
Planned vessels capacity with various stakeholders to increase revenue for firm.
Interfaced with United States Customs & Coast Guard Services to implement federal laws.

Confidential, Baltimore, MD

Remittance Processor Specialist/Data Analyst

Responsibilities:

Assisted the credit card department in processing customers accounts.
Processed customers remittance in excess of $1 billion daily utilizing customers specification.
Processed customers checks in preparation of monthly bank statements.
Supervised at least 15 seasonal employees to ensure data integrity and maintain 0% backlog.
Collected, summarized, and analyzed data for banking industry reporting.
Utilized MS Excel to produce graphical financial data for bank s internal reports.