ad2sqq@r.postjobfree.com

707-***-****

Novato, CA ****5

Skills

Technical Summary

Systems:

Unix (Linux, Solaris, HP, Sun) MS Windows 98-Windows 10)

Software: DBMS Oracle, Access, DB2, Ingres, SQL Server, MySQL, Postgres, Greenplum, Snowflake, Sybase, Azure, MS Dynamics, Mariadb

Testing Tools: DBT

Development Tools/IDE: Eclipse, NetBeans, Pycharm, Visual Studio 2005-2008

Source Control:Sourcesafe, CVS,SVN, Docker, Jira

Languages: SQL, PL/SQL, T-SQL, Java, C#, HTML, Shell programming, Perl, Python

Applications: Relational Junction, Salesforce, Business Intelligence(Tableau and Board), Data Warehouse, PeopleSoft HR, Payroll and Financial, Bally CMP and SDS

Cloud:AWS and GCP

Education And Training

03/2021

AWS Certified Solutions Architect Associate

01/2013

BS degree:

Management

University of Phoenix

Numerous professional and technical development courses (see LinkedIn profile:https://www.linkedin.com/in/keith-smith-804b027

Keith W. Smith

Summary

Experienced software, cloud and database developer with strong business, technical and analytical skills.

Experience

Student

05/2023-present

Updated and added additional skills through online classes from Udemy and Codefinity. Focused on Snowflake and Python, but also took classes in Power BI, Data Modeling, SSIS, DBT, Microservices

First Republic Bank - Software Engineer

11/2021 - 05/2023

Software Engineer supporting Regulatory and Corporate Technology group supporting BSA/AML (Bank Secrecy Act/Anti-Money Laundering) applications and databases

Data Analysis in SQL Server of data issues related to BSA/AML systems

Ad-hoc SQL Server and Snowflake queries as needed by users

Monitor ETL jobs in Snowflake

Create ETL jobs in Snowflake

Analyze data discrepancy issues in SQL Server and research any failures for ETL jobs

Created sophisticated reporting in C#/SSIS for FINCEN reporting

Documented technical specifications and project testing methods for future reference.

Created Python web scraping program to automate manual QA processes

Completed AWS training: AWS Certified Solutions Architect Associate SAA-C02 and AWS Certified Security

Sesame Software - Senior Software Engineer

07/2017 - 11/2021

Java database integration developer specializing in data integration using JDBC, metadata and SQL

Created prototype of new product, RJWarehouse, which adds additional integration of datasource to the existing RJSalesforce product and allows integration between multiple DBMS as sources and targets

Integrated Relational Junction products with Snowflake running on AWS as the first cloud-based data warehouse. Automated the process of creating database, schema, file format and stage and used PUT and COPY INTO commands to load data. Analyzed data to insure the data integrity and that the data in Snowflake matched the data in the source datasource.

Also integrated Relational Junction products with:Microsoft Dynamics, BigQuery, Pardot, Bullhorn, Couchbase, Dynamodb, Teradata, SAP Hana, Oracle ADW, Netsuite, MongoDB, Vertica, Quickbooks, Access, CSV, JSON, XML, Excel, and Greenplum and Teradata

Redwood Credit Union - Programmer/Analyst III

05/2015 - 07/2017

Lead for Data Management Strategy Team

Lead Data Analyst for Data Warehouse

Created SSIS packages to Extract, Transform and Load Loan and Member application data into data warehouse

Technical lead for Data Gap Analysis with all lines of business within the credit union

Created training program for Data Warehouse system

Created long-term planning and began work on creating a data management roadmap

Evaluated Business Intelligence software and made selection which best suited the needs of RCU (Board BI)

River Rock Casino - Programmer/Analyst

01/2008 - 05/2015

Designed and created Data Warehouse extraction program(Java, SQL Server 2008 R2,SSIS and bcp)

Created Tableau Worksheets and Dashboard for corporate KPI's

Created Campaign Management system for marketing which is used for creating prizes and tags in Player development system (CMP) and analysis reports for prize redemption by prize and campaign

Created Player Development Business Intelligence system in VS 2008 (C#,SQL Server 2008 R2) and executive dashboard using data from the data warehouse

Created Java programs to convert legacy Financial and HR system to PeopleSoft

Project Lead for PeopleSoft custom application for Casino Management Reporting

Project Lead for Visual Studio (C#) Inventory Cycle Count mobile application

Created Java program to Integrate Time Management system (Kronos) with PeopleSoft Time and Labor

Created analytical reports for Food and Beverage Product mix by Profit Center and Day of Week with Daily and Weekly quantity and gross sales averages

Converted legacy Security system (Foxpro) to ITrack Security application (SQL Server 2005)

Created Proposal Workflow application in VS 2008 (C#,SQL Server 2005)

Responsible on a daily basis for support of PeopleSoft HCM system

Employee of the Month-January, 2011

L3 Communications, Titan Group, US Coast Guard - DB Programmer

12/2005 - 01/2008

Responsible for maintaining and enhancing Access form-based Student Tracking and Reservation system

Additionally responsible for administering SQL Server database

Lead developer for web-based application to replace Access form-based Student Tracking and Reservation system.

SRJC - Student

12/2003 - 12/2005

Time in non computer-related jobs

KDS Solutions - Independent Consultant, Oracle Developer/Designer

Campbell, CA

03/2001 - 12/2003

Database designer for large scale Quality Assurance product

Database expert in a team of 7-10 (on-shore and off-shore) developers responsible for developing a leading-edge Web based Quality Assurance application for mid to large sized manufacturing companies

Responsible for Data Design and part of the 4 member design team

Project being developed using Java, JSP and Oracle 9i

Developed prototype of web-based Configuration system using MS Visual Interdev/Studio 6.0 and SQL Server 7 as the backend database

Upgraded existing Microsoft Access/Excel Quality system into MS Sql Server

Created web based query system for accessing Quality data from a number of data sources using ASP/SQL Server

Designed, coded, and implemented ASP/SQL Server/Visual FoxPro configuration system for use by external customers.

Sesame Technology - Web Developer

06/1999 - 09/2000

ExtraView, a high-performance problem management product that is completely Oracle and Web-based

Used PL/SQL and Oracle Application Server 4.0.8 and Oracle8i to deliver HTML front-end

Worked with clients to incorporate requirements into product releases

Added complex new features, including specifications and code enhancements

Converted client legacy data

Installed Linux, Oracle software and database, configured and tuned OS and instance parameters.

Developed back-office functionality for a new web site for maintenance of customer data and prototype of main web site, using Java servlets

Cisco Systems, Inc. - Tools Engineer

02/1996 - 05/1999

Lead for web-based Project tracking application

Designed, lead and implemented Project and Idea Tracking application using MS development tools MS InterDev (Visual Studio), Oracle Database, and Visual Basic

Database Consultant for web-based Network Management software

Analyzed existing system for deficiencies and performance tuning

Made recommendations for future releases

Wrote summary reporting module in PL/SQL.

Cisco Systems - Oracle Developer

Santa Clara, CA

05/1994 - 05/1999

SW Engineering Tools Group - Tools Engineer, Project manager

08/1985 - 02/1996

For email based Call tracking system for Tools group

Designed, coded, and implemented email based Call Tracking system using mail, perl and Apriori Call Tracking system

System allowed users and engineers to use/track Calls through email

Engineer for DDTS to Care Interface

Worked with a project group to implement an interface from the Clarify Call Tracking System (Care) use by Customer Advocacy to the DDTS Bug tracking system used by Engineering.

Cisco - Consultant

05/1994 - 08/1995

Supported, Call Tracking system (Clarify)

Wrote reporting system for IS tracking of required support guidelines

Additionally served as Oracle development DBA.

Pyramid Technology - Performance Analyst

Santa Clara, Ca

07/1993 - 04/1994

Sr. Database Analyst

08/1988 - 06/1993

System Administrator

06/1987 - 07/1988

U.S. Army - Computer Operator

10/1980 - 02/1987

MIS - Performance Analyst

For the Customer Benchmarking/Consulting Group for this vendor of high-end Unix servers

Also worked in, as Oracle DBA and Unix system administrator.

.

Contact this candidate