Les Smith

Folsom, United States

Summary

Languages:

English, Spanish

Favorite Python Packages:

pandas, sqlalchemy

Experience

Expert Python programmer skilled in modern and robust programming practices:

Program Architecture

Template Programming (cookiecutter, jinja2)

Data Frameworks (panda, sqlalchemy)

Source Control (branching, merging in svn and git)

Unit Testing (unittest, scripting , environment setup)

Automated code document generation (pydoc) from comments

Mentoring and assisting other programmers

Relational Databases (Postgres, mysql, SQL Server, Oracle )

Other languages (Java, powershell, .net)

ETL and Reporting Tools (Informatica, SSIS, Pentaho, SAS)

PL/SQL, T-SQL and other procedural SQL technologies

Domain Expertise

Health care claims and reimbursements

Government programs such as ADA, Medicaid and Federal to State grant programs

PROFESSIONAL EXPERIENCE

1/2017-Present Opera Consulting

Automation Expert

Python Programming

json and xml parsing

.net Programing

Powershell scripting

Report Development using Report Builder and SSRS

Affordable Care Act Data Reporting and Extracts

SQL Server Queries, Procedures and Views

SSIS ETL Design and Development

Version control and release management using github

Unit testing, code reviews , mentoring

8/2015-11/2016, Blue Shield California (MBI Consulting)

Database Developer

Design and implement ETL framework using Python and SQL

Create Python classes and modules for Change Data Capture

Data and password encryption using Python libraries

Version control and release management using svn

Create SQL scripts for data extraction and reports

11/2014-8/2015, Priority Health (314e Corporation)

Database Developer

Extraction of data from Facets (health insurance management system) for Federal reports

Creation and scheduling of Facets jobs

Oracle PL/SQL stored packages, procedures and functions

C sharp programming to retrieve data from databases and webservices

Review of reporting requirements and data analysis

Job scheduling and automation of file transmission for Federal CMS required reports

Attending Federal CMS Webinars to understand requirements

Perl scripting

Creating Deployment packages from change controls and version control (SVN)

Linux, Solaris, Unix and Windows environment

5/2014-12/2014, Blue Shield California (MBI Consulting)

Database Developer

ETL implementation with Netezza Database distributed host database

Development of Framework for Database Loading

Quality Control and Testing Setup

Perl and Bash Scripting

Solaris Unix and Windows environment

8/2013-4/2014, Truven Health Analytics, Sacramento, CA, http://truven.com

Database Developer

ETL implementation with Oracle 11 PL/SQL and SQL including external tables, materialized views, scheduler (jobs, chains, programs)

Implementation of ETL to create extracts for Federal compliance for State of Idaho

Design and propose additions to data model

Best Practices Champion for version control, commenting, documentation and readable code

Importing and integrating text files from third party vendors into database

Linux, Solaris Unix and Windows environment

Report query and report development using Business Objects

Skills

Big Data, Git, Linux, MySQL, NumPy, Pandas, PostgreSQL, SQLAlchemy, Web Scraping