Database Developer (perforance-forcused), ETL, VBA, XML, PHP

Jaazaniah Cole

ac9yio@r.postjobfree.com

Summary

I'm experienced in business reporting, business process automation, OLTP, OLAP, BI, DWH, and ETL. The data layer of systems I've written have been largely within MSSQL 2005/2008/2012, with ETL and application layers in Java, VBA, XML, and/or PHP, depending on business requirements. Taking simple data storage and adding OLAP and BI capabilities enabled many small and medium operations in the past to double their business without expanding labor hours. Reporting experience through the career includes SSRS and web-based PHP reports. Data integration and data mapping from source data experience includes SSIS, Altova products, and custom software configuration. Experience working with structured and unstructured data in ETL and reporting environments. I've also written SQL triggers for logging, ETL, and data consistency purposes. I've also maintained cubes in SSAS, and provided additional functionality through this role as well.

Strengths include:

●Multi-platform SQL development expertise

●Quickly learn new technologies

●Creative solution design

●Complex ETL design

●Agile methods

●Self-motivated, detail-oriented, performance-focused

Experience

Database Administrator at Goodwill Industries

June 2017 – July 2019 (2 years 1 month)

●Maintained databases within two domains.

●Developed links between all networks for remote site reporting.

●Created powershell infrastructure to deliver flexible system reporting.

●Aided Loss Prevention with reports.

●Compensated for Retail software shortcomings through procedures and triggers.

●Finished ASP.NET website project to replace legacy Excel system.

●Developed PHP/MSSQL website to support program management using flexible data tracking.

●Centrally managed store database corrections and sales setups through procedures and ad hoc queries.

●Deployed automated database maintenance procedures (indexes/stats/backups).

BI Developer

January 2017 – June 2017 (6 months)

●Developed SSIS packages and SQL-based structures and solutions.

●Analyze and design ETL packages, scripts, and custom functions.

●Design and Deploy new infrastructure for ETL which remains flexible despite schema changes.

●Performance tuning in a constantly changing environment.

Application Developer II at Experis

August 2016 - December 2016 (4 months)

●Further exposure to medical, claims, provider, patient data.

●Review and develop C# and Java code for ETL platform.

●Review, create, and optimizeOracle SQL queries and stored procedures.

●Performance tuning and review of Java-based ETL processes.

SQL Developer at FlipSwitch

November 2015 - July 2016 (9 months)

●Create and optimize SQL triggers, and stored procedures for a web based education service.

●Consult with Agile development teams as member of DevOps on matters relating to database design and maintenance for performance considerations.

●Support leadership through ad hoc ETL processes.

●Ensured compliance with state requirements through constant development of trigger-based migration platform, and advised on second version to alleviate the maintenance overhead.

●SQL Server and SSMS versions in use: 2008R2 and 2012, with one migration project from a legacy SQL 2000 server.

●Use of TFS for source control and environment promotion of code.

●Assisted in managing replication issues setup by the DBA on 2008R2.

●Trained reporting team on performance techniques for queries.

●Occasionally assisted reporting team using SSRS 2008

Project Engineer at Modular Mining Systems

March 2014 - July 2015 (1 year 5 months)

●Create and optimize SQL views, and stored procedures for a server-based application.

●Extended positional tracking software to enable region-based billing in near-real-time.

●Support for Auxilliary Microsoft Access databases individual clients maintained for reporting or other purposes. Integrated data between their SQL Server and MS Access. (2003-2008)

●Work with clients to analyze, trouble-shoot, and resolve client reports and requests.

●SSIS 2008 and 2012 work to correlate multiple data sources into the application's database.

●SSRS (2008 and 2012), Report Builder (2008 and 2012), and Crystal Reports (11) use to support client and business needs.

Senior Consultant at IBM

January 2012 - March 2014 (2 year 3 months)

●Worked 100% remote with few exceptions.

●Lead developer on the XML ingestion project, enabling multi-state tenancy to support business goals of expanding state coverage by 1/3.

●Data analysis of data sources from disparate schemas for the purpose of constructing ETL processes into our central schema.

●Served primary-contact role for SQL development questions, advice, and assignment for custom SQL project development on 2005 through 2012

●Bridged multiple data sources into the destination database, often times from mixed systems such as Microsoft Access, SQL Server, and Oracle.

●Employed Rapid Development and SDLC methodologies to design, develop, test and deploy ETL solutions for remote clients.

●Consulted and supervised sub-contractor development.

●Developed BI reports for clients and business employing SSRS (2005-2008), PHP, JavaScript, and dynamic AJAX systems.

●Configured SSIS (2005-2008) packages for custom integration projects.

●Developed office productivity tools using a mix of Java, XSLT, and SQL, for analysis of ETL solutions provided by third parties. These tools were proven to reduce analysis time of the solutions and reduced error rates.

Data Integration Engineer at i2 Group

August 2009 - October 2012 (3 years 3 months)

●Lead developer on the XML ingestion project, enabling multi-state tenancy to support business goals of expanding state coverage by 1/3.

●Data analysis of data sources from disparate schemas for the purpose of constructing ETL processes into our central schema.

●Served primary-contact role for SQL development questions, advice, and assignment for custom SQL project development on 2005 through 2012

●Bridged multiple data sources into the destination database, often times from mixed systems such as Microsoft Access, SQL Server, and Oracle.

●Employed Rapid Development and SDLC methodologies to design, develop, test and deploy ETL solutions for remote clients.

●Consulted and supervised sub-contractor development.

●Developed BI reports for clients and business employing SSRS (2005-2008), PHP, JavaScript, and dynamic AJAX systems.

●Configured SSIS (2005-2008) packages for custom integration projects.

●Developed office productivity tools using a mix of Java, XSLT, and SQL, for analysis of ETL solutions provided by third parties. These tools were proven to reduce analysis time of the solutions and reduced error rates.

Developer at American Red Cross

2008 - 2008 (less than a year) Contract position

●Developed a database application in MS Access for tracking patient information, patient procedures, doctor's orders and approvals, and nurse scheduling. Involved heavy use of sub-classed historical events records, and VBA procedures to control (and occasionally re-write) report behaviors.

●Wrote the comprehensive User Guide for this Clinical Services Tracker, and provided on-call support via email for the numerous forms and reports built into the system.

Skills & Expertise

●Solution Design

●Systems Analysis

●ETL

●Business Reporting

●Data Mining and Integration

●Microsoft SQL Server (2000-2016)

●SSRS (2005-2016)

●SSIS (2005-2016)

●Oracle SQL (9i-12c)

●SQL Tuning

●XML

●Data Analysis

●Data Warehousing

●JavaScript

●PHP

●Agile Methodologies

●Business Intelligence

●Crystal Reports (11)

Education

Pima Community College

CIS, 2010 - 2014

Contact this candidate