Resume

JOHNATHAN HAINES

Endicott, NY • jhaines3@yahoo.com • (571) 528-8954 • LinkedIn

ETL | Database Development | Business Intelligence | Software Development

PROFESSIONAL SUMMARY

Certified IT professional with over 15 years of experience driving system performance, enhancing operational efficiency, and increasing data quality. Success delivering custom technical, data, and software solutions across various platforms, systems and environments. Demonstrated expertise in database optimization, software development, and data integration. Proficient in ETL and SQL Server development, with extensive experience in business intelligence using SSRS and SSIS.

AREAS OF EXPERTISE

PROFESSIONAL EXPERIENCE

Manager Business Consultant Mar 2023 – Present

Aetna Contract to Hire – Remote (Woonsocket, RI)

● Deliver ticket, defect, and production support, prioritizing and resolving customer and internal issues and requests.

● Streamline operations and drive efficiency by developing workflows for Market Prominence using PL-SQL.

● Formulate reports using proprietary reporting system – Report Exporter.

Software Developer (contract) Oct 2022 – Apr 2023

By-Light LLC – Remote (Severn, MD)

● Improved processes by developing complex stored procedures, scalar, and table functions using T-SQL on MSSQL SQL Server 2020.

● Enhanced user experience by building dynamic web pages utilizing C# and MVC framework.

● Facilitated efficient operations and troubleshot issues while supporting VA VetPro application.

● Strengthened project management and collaboration by implementing Agile/Scrum methodologies using Jira.

Business Intelligence Developer (contract) Dec 2021 – Sepr 2022

ULLICO Insurance Services – Remote (Silver Spring, MD)

● Optimized data management by formulating SSRS Reports, PowerBI Reports, and SSIS Packages.

● Leveraged T-SQL on MSSQL SQL Server 2020 to construct complex stored procedures, scalar, and table functions.

● Deployed ASPx.net, C#, MVC, and Report Manager to create user friendly web pages.

Database Administrator (contract) Sep 2020 – Dec 2021

HII-TSD, WV – Remote (Newport News, VA)

● Heightened software efficiency by writing, testing, and debugging SQL and PL/SQL.

● Maximized file auditing by developing web application using C#, connecting to Restful Web Service SQL Server and Oracle.

● Communicated with SQL Servers via Microsoft T-SQL, stored procedures/complex queries, and deployed analysis projects using SQL Server Integration services.

● Collaborated cross-functionally to performance tune ETL processes, test ETL Mappings, and support ETL process for legacy data warehouse using Informatica.

● Demonstrated proficiency in SQL data manipulation, cursor control, and transaction control statements alongside SQL functions, operators, and pseudo columns.

Career break from Jul 2018 – Sep 2020

Data Analytics & Business Intelligence Developer Feb 2018 – Jul 2018

Matrix Resources LLC. – Atlanta, GA

Client: Wells Fargo

● Key in enhancing construction of compliance data warehouse by developing SSIS projects; collaborated with project managers to gather and map requirements.

● Tuned SQL queries for optimized performance using execution plans across Teradata, MSSQL, and Oracle platforms.

● Provided platform to transform raw data into actionable information by delivering complex data analysis solutions.

● Encapsulated business logic by creating stored procedures using T-SQL.

● Documented data flow from source to target, following standard Wells Fargo documentation practices.

● Outlined execution plans using Auto Sys and deployed SSIS Packages.

● Showcased deep knowledge of ETL processes and procedures.

Big Data Developer Oct 2014 – Nov 2017

TCS – Boise, ID

● Supported product traceability and optimized supply chain, processes, product delivery, and data analysis by combining data from multiple source systems.

● Mapped data warehouse, data marts, MSSQL, or Oracle to Avro, TSV, or CSV formats for ingestion into Hadoop and Teradata; ensured alignment with business needs by collaborating with business analysts to identify and understand source data systems.

● Developed, user tested, and performance tuned SSIS Packages, engineered custom SSIS script tasks/components/templates, deployed SSIS Packages, and scheduled SSIS packages using Active Batch jobs.

● Stored values used for components of Data Flow Tasks via SSIS Variables.

● Drove performance and efficiency by tuning SQL queries using execution plans across MSSQL and Oracle.

● Created and streamlined stored procedures for business logic using T-SQL.

● Employed BCP to develop ETL Extracts and C#/ASPX to design ETL Params website.

● Configured packages for dynamic execution and created Batch files for script execution, both in development and production environments.

● Documented data flow from source to target using WIKI pages, while executing complex data analysis on existing data.

Website Developer & BI Developer Jan 2014 – Aug 2014

Blue Cross of Idaho – Meridian, ID

● Underpinned claims services, external providers, and general pricing reports by developing complex data analysis solutions and creating internal and external SSRS reports.

● Collaborated with business analysts to understand source data systems, mapping data to data warehouses and data marts, and creating complex SSIS packages for data extraction.

● Created and scheduled jobs using SQL Server Agent, designed and documented ETL processes, and performed data transformations such as Aggregate, Sort, and Conditional Split

MS SQL Server Developer & SSRS Developer Dec 2011 – Dec 2013

Eloyalty – Austin, TX

● Delivered project that populated data warehouse, imported data from Excel, cleaned/scrubbed data, added validations using SSIS, and loaded data to staging and data warehouse.

ADDITIONAL EXPERIENCE

SQL BI Developer & SSAS Developer, Molina Medicaid – Molina, ID, Mar 2009 – Dec 2011

MS SQL Server Developer, SSAS, & SSIS, Idaho Department of Fish and Game – Boise, ID, Jul 2004 – Mar 2009

EDUCATION

Bachelors Degree, Information Technology, Kaplan Online University – Des Moines, IA

Bachelors Degree, Aerospace Engineering, University of Maryland – College Park, MD

CERTIFICATIONS

Security+

UPGRAD – Data Science & Business Analytics Certificate

TECHNICAL PROFICIENCIES

loading