Gene Williams Email & Phone Number

Greenville, South Carolina Area

Developed and supported ETL processes for multiple databases utilized in reporting, with a focus on Oracle, Snowflake, and PostgreSQL.Implemented CloverDX and served as the primary team resource for the platform, handling administrative duties and upgrades.Provided training to team members on the use of CloverDX and other ETL tools.Extracted data from various systems using CloverDX, Shell Scripting, Python, or a combination of the three, adapting to the requirements of different data sources such as Snowflake, SQL Server, MySQL, Oracle, PostgreSQL, DB2, Neo4j, Cassandra, REST and SOAP APIs, command line output, flat files, spreadsheets, and SNMP.Utilized APIs including Azure Dev Ops (ADO), Jira, Salesforce, Neo4j, and Quickbase to streamline data extraction processes.

Greenville, South Carolina, United States

Collaborated with a team to successfully implement a data warehouse as an application backend.Utilized Talend to extract data from Couchbase and SQL Server databases, loading it into a centralized database in Redshift.Contributed to designing the database schema and developing the data dictionary.Authored comprehensive documentation outlining data transformations for future reference and understanding

Spartanburg, Sc

Collaborated with team members at the Gibbs Cancer Center and Research Institute on the Guardian Research Network project to load Spartanburg Regional data into a clinical data warehouse for matching cancer patients with clinical trials.Learned and applied the Oracle HDWF schema and OHADI ETL processes to successfully complete the project.Utilized SQL and tools such as Toad Data Point to profile source data, identify data quality issues, determine cleanup requirements, and establish data standardization methods.Developed ETLs using ODI to efficiently load source data into staging tables.

Greenville, South Carolina Area

Led Enterprise Data Warehouse team in supporting, maintaining, and enhancing systems using IBM DataStage and Shell Scripting on AIX and Distributed DB2 platforms.Utilized Shell scripting and PL/SQL to create and modify data extracts, writing ETLs for data loading and extraction for reporting purposes.Integrated new applications, designed and developed interfaces, configured applications based on business requirements, and provided day-to-day support for various systems.Led multiple projects to upgrade existing systems, including Electronic Marketing (IBM EME) and Direct Store Delivery (JDA SoftGrocer) systems, developing implementation and testing plans to ensure successful and timely implementation across teams

Greenville, South Carolina Area

Streamlined and stabilized a newly upgraded distributed pricing system through the implementation of procedural methods, technical fixes, and effective use of available tools.Led a successful team project to implement a standard suite of retail applications at a newly acquired grocery chain, aligning with the business needs and practices of the company.Assisted in merging corporate processes of two grocery chains to establish common systems, conducting extensive analysis to identify business and process gaps and proposing alternative approaches for reconciliation.Developed solutions and implementation strategies to standardize store level applications with new common corporate systems.

Bachelor Of Arts (Ba), Art/Art Studies, General

Associate'S Degree, Computer Programming/Programmer, General

Architecture