Database Developer Resume

Summary Statement

Skilled Database Developer with a background in computer science and design. Excellent knowledge of OLTP databases, ETL, Data Warehouses and Reporting with Microsoft Business Intelligence Stack.

Highlights

Highly skilled with Business Intelligence Stack applications: SQL Server Management Studio, Integrated Services, Analysis Services and Reporting Services.
Expertise in Transact-SQL scripting with database objects such as Stored Procedures, Views, Indexes (Clustered and Non-Clustered), UDFs as well as various Joins (Inner, Outer, Self) and Constraints (Keys, Identity, Check, Default, etc.).
Knowledgeable with query and Stored Procedure optimization techniques by implementing the correct usage of indexes, table partitions, joins types, and various other methods to ensure the quickest execution time.

Education

Bachelor of Science in Technical Business Management

Professional Experience

Database Developer with Confidential,
July 2012 – November 2012

Used Microsoft SQL Server 2008 R2.
Worked primarily as a junior/entry level developer, advancing into a consultant position with two clients.
Created OLTP databases both through scripting and through ER Win, having all designs Normalized to the 3rd Normal Form reduce possible abnormalities and redundancies in data. Implemented proper constraints and relationships according to requirements to ensure database and relational integrity.
Constructed Cubes in Analysis Services by creating Dimensions and Fact tables, designed as a Star Schema and having Fact tables in the lowest level of granularity (atomic level) as possible.
Designed a fully functional end-to-end system from OLTP to reports generated from a Cube. Implemented an ETL strategy that allows an incremental load of historical data and new records into the Data Warehouse by conforming to a Slowly Changing Dimensions Type 2.
Demonstrated mastery of generating report types: Parameterized, Cascading Parameterized, Ad-Hoc, Matrix, Tabular, Click-Through and inserted graphical representations of data in the form of gauges and charts.

Developer with Confidential,
November 2012

Used Microsoft SQL Server 2008 R2
Took part in a four-person team where each member was assigned various duties pertaining to active reports used in the company dashboard. Addressed modification requests by users by adding additional parameters, adding new fields, or otherwise modifying the data source for desired results.
Worked with the Senior Developer to convert scripts used for reports into views.

Developer with Confidential,
October 2012

Used Microsoft SQL Server2005
Worked with the DBA to add modifications to existing reports by adding parameters, fields, or similar changes to the underlying script.
Updated tables in the production database as directed by the DBA.

Pre-Professional Experience

Pricing Accuracy Team Member with Confidential,August 2011 –June 2012

Assisted customers with product sales and inquiries.
Updated store pricing information using handheld logistics devices.
Ordered products as needed for replenishing sales floor.
Trained new team members in developing skills needed for various positions.
Assisted in bi-monthly inventory process for an individual department.
Used various power equipment: forklifts, order pickers and pallet jacks.

Pricing Accuracy Team Member withConfidential,November 2010 – June 2011

Unloaded trailers and moved merchandise to the sales floor.
Stocked merchandise for maximum presentation.

Produce Accuracy Team Member with Confidential, April 2007-May 2010

Assisted customers with product sales and inquiries.
Updated store pricing information using handheld logistics devices.
Ordered products as needed for replenishing sales floor.
Trained new team members in developing skills needed for various positions.
Assisted in bi-monthly inventory process for an individual department.
Used various power equipment: forklifts, order pickers and pallet jacks.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship