Daniel Simson

Principal Engineer, Software (Remote)

New Wave / General Dynamics
West Des Moines, IA

March 2015 - Present

The Chronic Conditions Data Warehouse (CCW) / Virtual Research Data Center (VRDC) are key systems for CMS and the White House strategy for improving health outcomes and reducing costs at national and local levels.

• Design, develop, code, test, and debug complex new software products, or makes significant enhancements to existing software.
• Research and integrates design strategies, product specifications, development schedules, and user expectations into product capabilities.
• Resolve complex hardware/software compatibility and interface design considerations.
• Conduct investigations and tests of considerable complexity.
• Researches emerging technologies to determine impact on application execution.
• Provides input to staff involved in writing and updating technical documentation such as user manuals, system documentation, and training materials.
• Troubleshoot complex problems and provides customer support for software operating systems and application issues.
• Advises hardware engineers on machine characteristics that affect software systems, such as storage capacity, processing speed, and input/output requirements.
• Prepares reports on analyses, findings, and project progress.
• Provides guidance and work leadership to less-experienced software engineers.

Senior Programmer/Analyst - Contractor

Credit-Suisse
Durham, NC

September 2014 to February 2015

The Derivatives Result Database (DRD) is a strategic central repository for front office valuation data for over the counter trades. This system is mission critical in the Credit Suisse front to back architecture and provides timely delivery of valuation data to key in house consumers.
I work in a global team environment modifying existing programs and creating new programs that ensure high quality data to the DRD system.

• Design and deploy database objects including tables, indexes, views, materialized views, object types, sequences and referential integrity.
• Develop and maintain database programs including packages, procedures, functions and triggers using PL/SQL.
• Develop scripts to import user supplied data from MS-Excel and MS-Access into the Derivatives Resource database.
• Serve as a liaison with Business Analyst, Project Managers and Database Administrators in a global environment to ensure the timely completion and installation of project tasks.
• Provide accurate time tracking against assigned project tasks.
• Participate in daily status meetings with other team members in London, Poland, Singapore and Pune.

Senior Programmer/Analyst

Agdata
Charlotte, NC

November 2013 to August 2014

The BASF fulfillment team calculates distributor, dealer and end user discounts and rebates throughout the year for all agricultural products offered by BASF. As a member of this team, I was responsible for the creation of programs that would calculate these discounts and rebates. I was also responsible for performing quality checks on programs and data produced by my peer developers. The annual amount of the discounts and rebates processed was in excess of 190 million dollars.

• Design database objects including tables, indexes, views, materialized views, sequences and referential integrity.
• Develop and maintain database programs including packages, procedures, functions and triggers using PL/SQL.
• Develop and support the Oracle PL/SQL code that performs the calculations for the all fulfillment marketing programs.
• Execute Quality Control checks of fulfillment source code created by other developers.
• As requested, support/fulfill requests for information and troubleshoot code.
• Develop and maintain code to support Excel workbooks for program reporting.
• Develop and maintain reports for fulfillment programs.
• Create and maintain technical documentation, process flows, etc.
• Train other team members as needed.
• Participate in weekly team meetings and conference calls.
• Track and enter time in time management tool.

Senior Programmer/Analyst-Staff Spec - ETL Developer

Wake Forest Baptist Medical Center
Winston-Salem, NC

August 2012 to October 2013

The development team at Wake Forest Baptist Medical Center is responsible for merging daily data from the new EPIC database with over ten years of legacy data in order to provide an accurate view of all aspects of the institution. I was responsible for creating ETL programs written in PL/SQL to extract and load data into this DSS system from both the daily on line system and the legacy data.

• Design database objects including tables, indexes, views, materialized views, sequences and referential integrity.
• Develop and maintain stored procedures using PL/SQL.
• Participate in weekly team meetings

Database Architecture and Senior Developer (AVP)

Credit Suisse
Durham, NC

January 2008 to February 2012

As a senior developer and database architect in the HR-IT department, I am responsible for designing and developing applications that are used by over twenty five thousand employees worldwide. These applications manage employee leave requests, overtime payroll processing and deferred compensation. Responsibilities also include designing and developing ETL programs that migrates data from the data warehouse for use in the Time and Leave Tracker system. Other programs include application security which allows or denies access based on a dynamic list of criteria. I was responsible for all enhancements. I serve as the subject matter expert for all HR-IT applications.

• Design database objects including tables, indexes, sequences, views and referential integrity.
• Develop and maintain database programs including packages, procedures, functions and triggers.

Senior Developer

AT&T
Greensboro, NC

March 2007 to January 2008

• Design database structures including tables, indexes and referential integrity using ERWin and Oracle Designer 6i.
• Create and maintain stored procedures, functions, packages and triggers for various customer service applications using PL/SQL.
• Perform PL/SQL code reviews for front end developers
• Establish, implement and maintain PL/SQL coding standards.
• Manage software development life cycle
• Evaluate new software and methods.

Database Architect / Senior Developer

GlaxoSmithKline
Durham, NC

March 2003 to March 2007

• Design database objects including tables, indexes and referential integrity using Oracle Designer 6i.
• Create and maintain stored procedures, functions, packages and triggers written in PL/SQL for a monthly ETL process. These programs extracted data from Glaxo’s sales reporting datamart.
• Tuned new and existing programs and reduced the processing time by half.
• Supervise contract development team. Regularly performed PL/SQL code reviews
• Establish, implement and maintain PL/SQL coding standards.
• Manage software development life cycle
• Evaluate new software and methods.
• Developed release management application using VB.NET

Database Architect / Developer

New Breed Corp
Greensboro, NC

October 2000 to March 2003

Ultimately responsible for the integrity of data transferred from New Breed's front end MS SQL-Server 2000 database to Oracle. This is accomplished through the use of Oracle's Heterogeneous database links, delimited flat files and linked servers.

• Design and implement relational database solutions of various complexities on both the Oracle 8i and MS SQL-Server 2000 databases.
• Create and maintain stored procedures, functions, packages and triggers written in PL/SQL that serve as the backbone of New Breed's warehouse management and EDI infrastructure.
Toolset includes: Oracle Designer 6i, Developer 6i on an Oracle 8i database, SQL*Navigator, TOAD.

Database Architect / Developer

Triad Guaranty Insurance
Greensboro, NC

October 1997 to September 1999

Worked in a team environment to analyze, design and code a complete database solution for Triad Guaranty. Developed stored procedures, functions, packages and triggers. Toolset included Oracle's Designer, Developer and SQL Navigator. I also assisted the Junior Oracle DBA as needed. In addition to these duties I also served as the PVCS Administrator.

Oracle DBA

Vanguard Cellular
Greensboro, NC

April 1996 to October 1997

Responsibilities Created new user accounts, monitored database space consumption, created new database objects.

Oracle DBA

Davidson College
Davidson, NC

June 1992 to April 1996

During the conversion I worked on both the legacy AIMS system and the new BANNER system. On the legacy system I developed Prime Info/Basic programs that converted data from the legacy AIMS system to BANNER. On the BANNER system I assumed the role of Oracle Database Administrator. As such, I ensured that the Oracle database was able to accept the incoming data by monitoring and adjusting the table space usage. After the conversion, I was promoted to the position of Oracle Database Administrator. In that role, I was responsible for the day to day health and well-being of the Oracle database and the BANNER software.

Prime Info/Basic (PICK) Programmer

Beaman Corporation
Greensboro, NC

January 1989 to June 1992

Prime Info/Basic (PICK) Programmer

Adelphi University
Garden City, NY

August 1986 to September 1988

Prime Info/Basic (PICK) Programmer

Lundy Electronics
Glen Cove, NY

August 1985 to September 1986

Data Entry / Computer Operator

Micron Instrument
Plainview, NY

January 1983 to August 1985