Nathan Reynolds

**** ** **** *****, ****** City, MO 64116 816-***-**** ac1ahp@r.postjobfree.com

Education:

BS, Computer and Information Technology, Minor in Management

Purdue University, May 2007

Job Experience:

Blue Cross and Blue Shield of Kansas City, Aug 2016 to Present

ETL Architect, Aug 2016 to Present

oTrain and coach ETL developers. Provide ETL technology roadmap. Explore new ETL technologies and techniques. Train developers in these. Build data integrations in IBM DataStage. Integrate existing data warehouse/data stage platform with Blue Cross Cloud integrations (Microsoft Dynamics CRM, Workday, etc). Perform code reviews. Use file transfer tools (Sterling file gateway) to move data to secure ftp locations for partners to access data.

Cerner Corporation, Jun 2007 to Aug 2016

Software Architect, Sep 2014 to Aug 2016

oPerform > 90% of team code reviews. Train and coach ETL developers. Manage upgrades of Informatica Power center tool. Complete the most complex development projects in Informatica Power Cerner. Create coding standards and best practices. Manage roadmap for database and ETL technologies. Interview and hire new Software engineers. Create complex PL/SQL functions and procedures in Oracle.

Sr. Software Engineer, Sep 2010 to Sep 2014

oPerform the job of Software Engineer. In addition, coach junior engineers. Complete more complex ETL projects in Informatica Power Center and MS SSIS. Perform some code reviews. Work with Software architect on advanced tuning, database improvements, ETL performance improvements.

Software Engineer, Jun 2007 to Sep 2010

oWorked at Florida Hospital in Orlando to implement Cerner Millennium installation.

oCreate ETL mappings in Informatica Power center. Meet with business partners to gather requirements. Turn business requirements into technical solutions. Create complex SQL and PL/SQL in tandem with Power center mappings. Tune database tables and queries. Improve Informatica session run times.

Technologies:

BI Tools:

Tableau -2 years OBIEE (10g, 11g)-9 years

Microsoft SSRS - 3 years Power BI – 1 year

Database:

Oracle (versions 9i, 10g, 11g, 12c)-9 years DB2 (versions 8, 9, 10)-10 years

Microsoft SQL Server (2005, 2008, 2012)-10 years Informix-3 years

Sybase (version 15)-1 year

Integration:

Informatica Power Center (versions 7.1.4, 8.6, 9.1)-9 years Microsoft SSIS-5 years

IBM Information Server- Data Stage (versions 8.5, 11.5)-1 year

Skills:

SQL PL/SQL

Data Warehousing ETL- Certified Kimball University ETL design

Data Modeling- 3NF, Star Schema, Snowflake

Contact this candidate