BI Consultant Resume

SUMMARY

Database Architect with 20 years of experience in database programming, data modeling, ETL and data warehousing. Proven track record of delivering high quality solutions in agile environments using a mix of industry standards and innovative thinking. Highly experienced at team leadership and mentorship of less experienced team members.

TECHNICAL SKILLS

Computer Languages: PL/SQL, SQL, T - SQL, Perl, C/C++/C#, Visual Basic, Python, Powershell

Databases: Snowflake, Postgres SQL, Oracle, SQLServer, DB2, MySQL, MariaDB

Database Tools: Matillion, PL/SQL Developer, DataStage, Erwin, DBMain, Toad, Toad Modeler, DBDesigner4, Talend, Informatica, Oracle Enterprise Data Quality, SSIS, Pentaho DIS, Spark

Web: HTML, CGI, Web Design

Operating Systems: Windows NT/2000/XP/7/10, Linux/Unix

Office Software: Lotus Notes, Microsoft Word/Excel/Powerpoint/Visio, Latex

Knowledge and Practices: Cloud Architecture, Data Mining, Data Modeling, Structured Analysis and Design, Data Warehousing, Artificial Intelligence, Business Intelligence and Reporting, Agile Development (Scrum), Master Data Management, Data Governance

PROFESSIONAL EXPERIENCE

BI Consultant

Confidential

Responsibilities:

Designed and built a system to parse and load expense data to keep the company in compliance with Federal regulations
Designed and built a system to monitor Audit systems and ensure that they were running properly
Imported data mart data into Salesforce
Reviewed potential SSIS/Salesforce components and selected one for company use
Migrated ETL systems from SSIS to Matillion

Database Architect

Confidential

Responsibilities:

Modeled all new schema changes as well as revamped existing schemas to follow best practices
Improved database performance at all levels of the application and reporting databases reducing slow query times by over 50%
Designed and Implemented a rapid updating Dashboard ETL system that had been attempted and failed numerous times before
Reduced ETL nightly job runtimes from ~8 hours to ~2.5 hours
Automated many recurring processes to be faster, more accurate, and require less human effort
Developed ETL jobs using Pentaho Data Integration
Mentored team members on SQL best practices and query performance

ETL Developer

Confidential

Responsibilities:

Developed ETL jobs using SSIS and T-SQL
Designed and Implemented a comprehensive ETL Control and Monitoring system
Refactored many processes and Data Models to bring the system up to best practices
Mentored junior developers in T-SQL and SSIS best practices

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship