AT&T

AT&T Atlanta, Georgia & Remote May 2018 - February 2024, Data Analyst/AB Testing Analyst Performed ad hoc data analysis and engineering using SQL on Vertica, Teradata, and Snowflake data warehouses Lead analyst for AB testing with responsibilities including: performing tasks on Adobe Analytics and Target, ensuring AB testing metrics were gathered per requirements of stakeholders; assessing lift, hypothesis results and confidence levels at completion of tests; responsible for analysis of multiple ongoing tests Created and administered Tableau Dashboards, Workbooks, Views, and Data Sources Used R and python to perform ad hoc and automated analytics tasks including data mining, machine learning modeling and data visualizations

Cox Automotive, Inc

Cox Automotive, Inc, Atlanta, Georgia June 2016 - May 2018, Database/Business Intelligence Analyst Participated on agile team for purposes of moving data (ETL from data sources including ad hoc flat files, Adobe Analytics, & MS SQL Server into Vertica data warehouse) and provide analytics to internal & external stakeholders Installed, administered, designed and managed reports using Tibco JasperReports Server and Studio Administered SQL Server database including SSIS jobs, DDL changes, creating indexes and views, and troubleshooting using ad hoc queries, updates, deletes and inserts Created and administered Tableau Dashboards, Workbooks, Views, and Data Sources Experience using Salesforce reports and Workbench to extract data and create internal reports

TravelClick

TravelClick, Atlanta, Georgia April 2014 - February 2016, Database Analyst Managed migration and ETL of data from raw text files to Microsoft SQL Server to Oracle DBMS, working with account managers, business intelligence team and developers. Monitored, quality checked and queried data in each step of ETL process to ensure data integrity and reliability, including setting up automatic scripts for future checks

Landis+Gyr

Landis+Gyr, Alpharetta, Georgia Data Support and Implementations Engineer September 2012 - April 2014 Lead Gridstream Advanced Metering Infrastructure system installations, troubleshooting installation issues on various customer environments, providing support and management to clients worldwide Developed PowerShell and batch (.bat) scripts for use in monitoring Gridstream IT systems (integrating Microsoft Messaging Queues, Windows Services, & Application Pools) Work with Oracle and Microsoft SQL Server database systems and data warehouses, including SQL development, data analysis, read, write & update queries, and executing procedures Work with clients internationally including America, Canada and Guam on client site, which included documenting client processes and leading training sessions and discussions Performed first article testing (FAT) on initial hardware (meters) and software (meter configuration) for large scale Gridstream AMI utility projects Reported bugs and defects of the application and followed their fixes through the software development life cycle all the way to production environment Read C# using Visual Studio to identify root cause of issues Setup and tested AMI smart meters with client specific meter programs and requirements Documented CRM tickets to ensure future issues can be searched and resolved easily On the cherry picker in Guam, inspecting a Collector

ista

ista North America, Alpharetta, Georgia Account Manager and Operations Analyst February 2011 - September 2012 Focused on the long term client needs as well as day-to-day issues, including visiting clients onsite Long term client needs included strategies for customer base expansion and projects to automate manual processes, which would save time and money for application users Directed implementations into new markets for clients to expand their customer base Managed product releases, including user acceptance testing and production verifications Developed SQL with Microsoft SQL Server 2008 to read, write, update and execute scripts in the database Traveled to Frankfurt, Germany as member of the North America team in the company bowling tournament Bowling in Frankfurt

Meridian Technologies, Inc

Meridian Technologies, Inc - Jacksonville, FL August 2009 - December 2010, Database Developer & Consultant As consultant to Bank of America, part of the Direct Investments and Personal Retirement Technology Team to develop a client referral program to support global client coverage and relationship deepening, performing any duty involving Oracle DBMS or PL/SQL scripts Responsible for data migration of over 80,000 ‘referrals’ from legacy system to new system using PL/SQL (created stored procedures, functions, sequences, and tables in Oracle 10g) Experience with querying Oracle 10g DBMS using PL/SQL, including query optimization Participated in ETL development training with IBM Websphere DataStage Formally recognized for flexibility and openness to change Participated in high and low level design sessions as well as requirements gathering and data mapping documentation Attended 30 hours of project management training and 6 hours of IT project communication training