rebekah.mullen

merhbt@r.postjobfree.com

www.linkedin.com/in/rmullen

http://sql-ramblings.blogspot.com

Highlight of Qualifications

Professional Summary:

• Designed, loaded and maintained SQL Server (2005/2008) databases intensely using SSIS and TSQL using star and snowflake schemas, 3NF with SCDs

• Created and managed over 2000 active SSIS packages (2005/2008) to populate production data warehouses from over 1000 different raw sources

• Actively participated and led discussions for database design strategies as well as indexing and keying

• Participated and led both small and large (10+) team environments

• Used SQL Profiler and query execution paths to optimize index placement and queries

• Self-motivated to accomplish projects in a timely manner without compromising quality

Technical Skills:

• SSIS (SQL Server Integration Service) 2005/2008

• TSQL programming (2005/2008) using triggers, functions and stored procedures

• Intense use of ETL from various raw sources

• MS SQL Server 2005/2008

• Efficiently designing, indexing and querying star, snowflake, object oriented and 3NF databases

• SSRS (SQL Server Reporting Services) 2000/2005

• MS Visual Studio/BIDS (2005/2008)

• MS Visual Source Safe 2005

• Subversion (Ankh and Tortoise plugins)

• Agile SCRUM

• Oil Field Applications: Petra, Production Access, IHS Production, PowerTools, Aries, GWIZ/BOLO, HPDI, ESRI, Wellcore, Prams+, Longbow

Relevant Experience

TGS-NOPEC (Bought out Suhaka Consulting), Denver, CO - Oil and Gas Industry : Database Developer

11/2009 – 5/2011

• Technologies Primarily Used: TSQL, SSIS 2005/2008, SSRS 2005, SQL Server 2005/Express/2008, MS Visual Studio 2003/2005/2008, MS Visual Source Safe 2005, MS Access/Excel 2003/2010,

• Primary Duties: Responsible for designing and performing ETL on data warehouses using star, snowflake and 3NF schemas. Used SSIS to populate various data warehouses including one that was delivered directly to the client. Collaborated with management and programmers to obtain requirements to add new facts and dimensions as well as produce useful information from the databases. Responsible for suggesting indexes to add to the databases. Led teams to kick off projects as well as smaller teams as projects progressed.

• Highlights:

o Created and maintained 2000+ SSIS (2005/2008) packages to populate over 10 terabytes of data from various file sources, types, and databases into data warehouses

o Used advanced TSQL to clean and load data as wells as represent it in required formats

o Actively participated and led small (2-3) and large (10+) teams to make enhancements to existing data structures and collaborated with team members and presented recommendations for indexing as well as helped junior members in the team with queries and stored procedures

o Compiled manuals and detailed documentation for workflow and products

o Responsible for maintaining database health and collaborate with IT staff for backup schedules

Suhaka Consulting (Bought out by TGS-NOPEC), Denver, CO - Oil and Gas Industry : Database Developer

10/2006 – 11/2009

• Technologies Primarily Used: TSQL, SSIS 2005/2008, SSRS 2005, SQL Server 2005/Express/2008, MS Visual Studio 2003/2005/2008, MS Visual Source Safe 2005, MS Access/Excel 2003/2010,

• Primary Duties: Responsible for designing and performing ETL on data warehouses using star, snowflake and 3NF schemas. Used SSIS to populate various data warehouses including one that was delivered directly to the client. Interfaced with clients to gather requirements for their databases. Sources varied from electronic files to stacks of paper. Collaborated with management and programmers to obtain requirements to add new facts and dimensions as well as produce useful information from the databases. Responsible for suggesting indexes to add to the databases.

• Highlights:

o Created and maintained 2000+ SSIS (2005/2008) packages to load data in from over 1000 different sources to populate a data warehouse ready for customer delivery

o Used advanced TSQL to clean and load data as wells as represent it in required formats

o Actively participated and led small (2-3) and large (10+) teams to make enhancements to existing data structures and collaborated with team members and presented recommendations for indexing as well as helped junior members in the team with queries and stored procedures

o Compiled manuals and detailed documentation for workflow and products

o Responsible for maintaining database health and collaborate with IT staff for backup schedules

FIML Natural Resources, LLC: Data Analyst, Economic & Financial Analyst Assistant

6/2005 – 1/2007

• Technologies Primarily Used: MS SQL Server 2000, MS Access, MS Excel, VBA, TSQL, SSRS 2000, MS Visual Studio 2003, Altiris Console Report Generator

• Primary Duties: Wrote training manuals and trained personnel to use a 3rd party application as well as wrote different .NET applications to augment the functionality. Provided 24hr support for the application Collaborated with senior administrators to manage three servers.

• Highlights:

o Developed, administered, and integrated database applications to improve workflow, preserve data integrity, automate procedures, and develop an extensive report repository

o Developed KPI reports using SSRS 2000, MS Visual Studio 2003, Altiris Console Report Generator

o Implemented third-party database applications and provided internal application support

o Responsible for providing 24 hour support

o Compiled manuals explaining database business procedures, data flow, and software use

o Conducted software reviews and technical interviews for two third-party software package purchases

o Performed financial business analysis evaluations on the company and all asset groups associated

Miscellaneous Information

• Permeability, Pore Pressure, and Leakoff-Type Distribution in the Rocky Mountain Basin

Presented at the 2002 Society of Petroleum Engineers conference (SPE Paper #75715-PA)

http://www.onepetro.org/mslib/servlet/onepetropreview?id=SPE-75717-PA&soc=SPESPE

• Blog: http://sql-ramblings.blogspot.com

• TGS-NOPEC “Bright Spot” award for outstanding performance in third quarter, 2010

Education

B.S. Mathematical & Computer Science

Computer Science Emphasis

Colorado School of Mines

Golden, Colorado

B.S. Economics

Colorado School of Mines

Golden, Colorado

Contact this candidate