CAREER SUMMARY:

Marine Corps veteran with 15 years professional IT experience including: Database Development, Data Analysis, Web Development Extract, Transform & Load (ETL), Structured Query Language (SQL) & Business Intelligence (BI) Knowledge.

SKILLS:

• MS SQL Server 2000 - 2016, SSIS, SSRS, Oracle, MySQL, PostgreSQL, DB2, Data Architecture, Data Modeling, Data Analysis, Data Integration, Data Transformation, Complex Query Analysis, design and optimization, Stored Procedure Design and maintenance, Database Functions, Triggers, ETL, Normalization, Report Design & Development, MS Excel/Database Report Integration.
• C#, JavaScript, ASP, VBScript, HTML, PHP4 programming languages
• Toad, Visio, IBM System Navigator, IBM Infosphere Data Architect, Visual Source Safe, Editplus, SVN, ADO, ODBC, Mantis & Redmine
• Business Analysis, Functional Analysis, Testing/Quality Assurance, technical documentation, Small team leadership, Project Coordination, Training/Mentoring

CAREER PROFILE:

Senior Database Developer

Confidential, Phoenix, AZ

Responsibilities:

• SQL Developer for the Arizona Registrar of Contractors. Responsible for data migration from their home grown system to SalesForce.
• The contract requires quickly learning the current model, extracting, transforming, mapping and loading the data into SQL Server staging tables for SalesForce. 

Senior Database Developer

Confidential, Scottsdale, AZ

Responsibilities:

• SQL Developer for Native Indian loan institution. Primary role is data validation to ensure all data is clean and accurate
• . Designed and developed first version of a system (stored procedures, functions, views and SQL Server Agent jobs) which will automatically detect, capture and communicate specific business events to their respective business units (i.e. fraud alerts, improperly balanced accounts, Standard Operating Procedure Compliance, etc).
• This is the first application of it's kind for the institution.
• The data from this system assisted in the acquisition of a $100M business deal. The use of this system has also assisted in identifying unexploited areas of profitability.
• Instrumental in performance and query optimization taking one of the company's recent daily jobs from 2.5-3 hours down to 1 minute.
• Optimize and build out existing and new data models.
• Developed and implemented other solutions including:
• Interactive SSRS reports for various departments
• Stored procedure to perform security audits on Stored Procedures, Views and Tables including time-stamps, users and types of updates performed.
• Stored procedure and table updates between development and production environments.
• Table structure comparisons between development and production environments.
• SQL Server agent monitoring for jobs running beyond a predetermined threshold.
• Tools used: SQL Server 2016, Red Gate SQL Prompt, MS Excel

Senior Database Developer

Confidential, Los Angeles, CA

Responsibilities:

• Primary Database Developer for one of the company's largest health care client's. Responsible for translating highly complex business rules into intelligent database driven decision making for highly customizable mail products.
• Designed and created several automated processes to maintain private insurance and Medicaid programs.
• Designed and created a dashboard consolidating information from 3 independent systems into one cohesive monitor.
• Trained junior analysts/developers and support personnel in processing several thousand customized member mailings through Confidential proprietary enterprise system.
• Designed and created an automated monitoring system to assist the production support group with maintaining the integrity and production of Confidential proprietary enterprise system.
• Tools used: SQL Server 2008-2016, SSIS, SSRS and MS Excel

Database Designer/Analyst

Confidential, Los Angeles, CA

Responsibilities:

• Designed, created and reviewed data models for various projects. Advised management on the development of data standards to enhance and improve institutional effectiveness for enterprise college database model and government compliance projects.
• Made recommendations to management and Director of IT and Data Management to determine, document and maintain data standards.
• Developed scripts for ETL using SQL for DB2
• Tools: DB2 7.1, IBM System i Navigator, IBM Infosphere Data Architect, MS Excel

Senior SQL Developer

Confidential, CA

Responsibilities:

• Primary responsibilities included troubleshooting SSIS Package and Report Development.
• Skills used included data transformation, data analysis, stored procedure reporting & development.
• Tools: SQL Server 2012, SSIS 2012
• Designed technical process documentation in MS Word.

Senior DB Developer

Confidential, Burbank, CA

Responsibilities:

• Primary responsibilities included Report Developer and Data Analyst in a Linux/Windows environment using PostgreSQL/SQL Server 2008 R2. Developed PostgreSQL skills to support in-house applications. Skills used included data-modeling, data integration, data transformation, data analysis, ad-hoc reporting with automated delivery, writing complex stored procedures, functions, automated ETL customized Excel spreadsheets. Tools: SVN, EMS for Postgres, Mantis
• Developed data dictionary scripts enabling development team resolve in-house application issues in tables and stored procedures, reducing resolution times from hours to minutes.
• Most significant development project completed was a training reimbursement system for ADP disbursement with a team of 4. Primary role was assisting in design of tables and stored procedure development. This 4-5 month project was completed in approximately 3 ½ weeks with no defects.
• Redesigned technical and functional requirements documents in MS Word to making documentation easier to read, navigate and digest for users and technical personnel.

Level II Application Support/Data Analyst

Confidential, CA

Responsibilities:

• Responsible for diagnosing and resolving daily digital asset delivery issues to 100s of business partners, including iTunes, Google Music and Spotify. Developed, created solutions for digital distribution failures and system improvements.
• Writing technical documentation for newly resolved re-occurring issues was an integral part of this fast-paced environment.
• Automated a daily report process, reducing completion time from 30 minutes to 15 seconds.

Data Analyst

Confidential, Phoenix, AZ

Responsibilities:

• Developed complex stored procedures, T-SQL and PHP scripts and templates to increase productivity for ETL processing, data validation and course enrollments.
• Developed T-SQL driven application with stored procedures to allow Client Services to resolve repetitive client requests without IT’s participation, reducing turn around times by as much as a 2-3 days per request (typically 8-12 client requests per day).
• Received employee of the month award for exceptional job performance (May 2010).

Web Database Developer

Confidential, Scottsdale, AZ

Responsibilities:

• Developing and maintaining Confidential ’s internal and external web sites for audiences ranging from less than 100 to 100,000+.
• Skills used for this position were functional analysis, quality analysis, ASP, T-SQL, AJAX and JavaScript, testing. Tools: Editplus, SVN

Web Database Developer

Confidential, Scottsdale, AZ

Responsibilities:

• Developing and maintaining Confidential ’s internal and external web sites. Skills used for this position were PHP, MYSQL, AJAX and JavaScript, functional analysis, testing/quality analysis. Reason for leaving: 944’s purchase of a CMS eliminated the need for web developers. Tools: Editplus, SVN

Branch Manager

Confidential, Phoenix, AZ

Responsibilities:

• As Branch Manager, redefined loan processing procedures which lead the company to achieving the highest closing ratio in the nation for First American Title (one of the largest title companies in the country).
• Using the business and functional requirements for a loan officer developed an Excel spreadsheet to assist loan officers in quickly assessing how much potential clients could borrow, estimated profit margin and debt to income ratio. This Excel spreadsheet reduced the time loan officers invested on unclose-able deals and allowed them to accurately assess risk, saving the company several man-hours per loan.
• Also served as company’s LAN Administrator and Desktop Support Specialist.
• Received Navy Achievement medal for developing Database Management System which saved over 18,000 man-hours annually.
• Received Navy Achivement Medal for developing Database Management System to maintain, monitor, and audit records multi-billion dollar inventory, saving over 1500 man-hours per year
• Received Meritorious Recognition for maintaining accurate and timely aircraft records with an understaffed department.