Data Analyst Sql Developer

Timothy Meece

Contact Information:

Phone: 214-***-**** Email: **********@*****.*** https://www.linkedin.com/in/timmeece/

Professional Summary

Experienced ETL and Data Warehouse professional with over 10 years of expertise in database systems such as Teradata, Oracle, SQL Server, DB2, and ETL tools like Datastage and Informatica. Skilled in optimizing SQL queries, automating data workflows, and troubleshooting production issues. Adept at managing large datasets and supporting critical business processes through data analysis and extraction. Proficient in tools including Alation, Oracle SQL Developer, and Unix Shell scripting.

Technical Skills

Operating Systems: Alation, Amazon Redshift, Windows 10, Linux, Unix, Boomi, Swagger UI

Tools: Unix Shell Scripting, Informatica PowerCenter 10.2, DataStage, CA Autosys 11.4, Teradata Parallel Transporter, Toad Datapoint 5.2, Oracle SQL Developer, Teradata SQL Assistant, BTEQ, SQL, SSIS, Red Gate SQL Data Compare, Quality Center, Perl, Jira

Databases: PostgreSQL, Hadoop MS SQL Server, Amazon RDS, Teradata, DB2, Oracle, NoSQL

Professional Experience

Volante Consulting — Consultant/ETL Developer

September 2023 – Current date

Provided data services supporting data analytics for the clients of Volante, utilizing NoSQL data sources.

Performed data cleansing services on data sources for Volante and their clients improving data quality.

Blue Cross Blue Shield of Michigan — ETL Developer/Data Analyst

June 2023 – September 2023

Produced data extracts for 5+ departments, leveraging SQL and Redshift, reducing manual workload.

Developed and optimized SQL queries, improving job run times, using Alation, Redshift, and SQL Developer.

Ensured data reliability by proactively monitoring and resolving Hadoop cluster, NoSQL issues.

Florida Blue Cross – Tampa, FL — Data Analyst / Production Support

October 2022 – May 2023

Supported AOR Management Service, improving data analysis accuracy through thorough SQL testing for healthcare data.

Developed and executed complex SQL queries on DB2, Postgres, NoSQL and MS SQL Server, reducing query runtime.

Ensured API and ETL integrity by implementing automated testing using Swagger and Boomi, identifying and resolving critical issues.

Cigna – Hartford, CT — Data Analyst

March 2022 – March 2023

Supported migration of pharmacy-related web applications to AWS RDS, improving system efficiency.

Developed comprehensive data mapping and workflow documentation, reducing onboarding time for new team members.

Goldman Sachs – Dallas, TX — Contractor, Production Support

August 2021 – February 2022

Provided production support for ETL processes, reducing errors in equity, fixed income, and FX transactions.

Automated ETL workflows using Shell and Python, reducing manual intervention, and resolved 10+ Informatica workflow issues.

Bank of America – Plano, TX — Production Support Data Analyst

November 2020 – July 2021

Managed release and deployment for the Customer Relationship Hub, streamlining 85+ inbound source systems.

Monitored and resolved DataStage job issues within SLAs, and developed Shell scripts to automate batch process management, improving efficiency.

Blue Cross Blue Shield – Richardson, TX — Data Engineer / Developer

January 2015 – October 2020

Developed and optimized ETL processes using IBM DataStage, Teradata, and DB2, reducing processing times.

Assisted in MSSQL DBA tasks, improving database performance, and developed customized solutions for Mede Analytics.

Southwest Airlines – Dallas, TX — Data Analyst / ETL Tester

April 2011 – December 2014

Created automated data warehouse testing processes, ensuring 99% accuracy in ETL data loads using SQL and Shell scripting.

Authored comprehensive BRDs and data mapping documents, improving system integration efficiency.

Education

BA in Missions and Bible Translation

Lincoln Christian College – Lincoln, IL

Certification in Field Linguistics

Summer Institute of Linguistics – Dallas, TX

Contact this candidate