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.