We provide IT Staff Augmentation Services!

Sql Server Developer Resume

Manassas, VA

PROFESSIONAL SUMMARY:

Technology professional with strong verbal and written communications skills and analytical skills for writing relational database solution for businesses. A self - starter who is able to work independently or lead a team to a collaborative solution, I am a fully proficient SQL developer with excellent grasp of data warehousing and such processes as extracting, transforming and loading.

SKILL:

Databases: SQL 2012 & 2016, Oracle 11g/12c

Operating Systems: MS Dos, XP/Vista/windows 7/10, Windows Server 2000/2003/2008/2012 , UNIX

Programming: SSIS, T-SQL, SQL, PL SQL, R-Studio

Software Applications: Microsoft Office Suite (Word, Excel, PowerPoint, Access), Tableau

Relevant Skills: Database Management, Software Testing, Project Management, Trello

CAREER PROGRESSION:

SQL Server Developer

Confidential, Manassas, VA

Responsibilities:

  • Designed logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
  • Involved in Migration of database from SQL Server 2008 to SQL Server 2012.
  • Designed ETL solutions that pulls data from heterogeneous sources into an enterprise wide data warehouse
  • Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Created database and database objects like tables, Views, Stored Procedures, Triggers and User Defined data types and Functions.
  • Created indexes for the quick retrieval of the data from the database and Triggers to enforce data and referential integrity.
  • Weekly received .txt and Excel files to update tables in the database.
  • Created scheduling Jobs, Alerts, and SQL Mail Agent.
  • Performed quality assurance and testing of SQL server environment.
  • Fine-tuned SQL queries to improve query performance and reduce runtime.
  • Wrote Ad-hoc queries for Business analysts to extract required daily data.
  • Helped train Business Analysts and Data Analysts on basic query writing.
  • Extracted data from database and export to Excel files for Data Analysts to categories the data.
  • Documented all requirements and scripts for future references.

Intern Database Developer

Confidential, Chicago, IL

Responsibilities:

  • Generated and/or uploaded data transmission files as per file specifications.
  • Designed and programmed re-usable SQL code to prepare data for analysis.
  • Contributed to KEDB, RCA’s and standard operating procedures.
  • Wrote Ad-hoc queries for Business analysts to extract required daily data.
  • Communicated with business customers to establish data requirements. Participated in designing, developing and administrating transactional and analytical data of the business.
  • Created various dashboards & ad-hoc reports using Tableau
  • Prepared ad-hoc reports using Excel and deploy report to web portal.
  • Used MS Visio to represent system under development in a graphical form by defining use case diagrams, activity diagrams and workflow diagrams.
  • Performed extensive QA on incoming and outgoing data to ensure format and standard compliance.
  • Involved in data processing tasks related to conversion, extraction and mining valuable information from the ODS.
  • Worked in an Agile environment.
  • Supported various daily, weekly and monthly processes.

Customer Service Agent

Confidential

Responsibilities:

  • Checked in passengers at the airport and supported them in the ticketing and reservation procedure.
  • Escorted passengers to the aircraft daily and accommodated clients with special needs.
  • Assisted staff members for smooth and safe operations, matching the standards set by the state.

Machinist Mate / Engineering

Confidential

Responsibilities:

  • Performed planned maintenance and troubleshooting of the engine and water evaporators for safety.
  • Watch standing and maintained security throughout the ship.
  • Trained new and junior personnel on maintenance and job-related tasks.

Hire Now