JA

joel anthony

Marketing Database Developer (On-site & Remote) · Choice Hotels Inc

Frederick, MD

In My Own Words

? Business Intelligence Developer with over 1 year of experience in supporting large scale data in 4 service areas (Database, ETL, Operations, Admin Operations)
? Marketing Database Developer with over 2 years of relevant experience in process automation, database development and data management
? Self-motivated with a strong analytical mindset that automated workflow processes that resulted an increase of 80% productivity for the involved clients
? Possess ETL working experience with large scale dataset and working knowledge in SQL, data conversion / migration, with working knowledge of RDBMS databases

Work Experience

Marketing Database Developer (On-site & Remote)

Choice Hotels Inc

2019 – 2022

Rockville, MD Choice Hotels Inc is one of the largest hotel chain franchise company that provides hospitality to its clients. Marketing Database Developer (On-site & Remote) Jun 2019 - Jan 2022 Supporting databases such as SQL Server, Vertica, Oracle, Redshift with data platforms such as Unica and Cheetah Digital

* Using databases, data platforms data to design, engineer and implement email life cycles for the processes listed below: ? Executing script on MS SQL Server to retrieve large scale data sets from client's data mart via RDC (remote desktop connection) ? Ingesting and transforming large scale data from external to internal data warehouse to implement API or triggered processes such as customers cart abandonment, new subscribers, promotion fulfillment and more ? Designing, implementing auto updates custom reports with Cheetah Digital platform for internal and external processes to track weekly, monthly metric by defined criteria ? Designing and implementing data logic through Unica flowcharts for ETL processing and building complex query for table creation, data validation, table purging, data migrations and backups in Redshift and Oracle * Serve as transition with the IT department for Database and Marketing to handle the following: ? Ensuring data integrity, availability from ETL processes to data warehouses and data platforms ? Performing quality check and transform data as needed for planning and implementation of marketing campaigns and processes with third party's partners * Oversees +30 projects while managing multiple tasks and serving as a liaison between third party's partners and the IT department to: ? Acquiring business data requirements with specifications and providing solutions, insights, and updates on the project completion timeline ? Designing and automating marketing and business data processes that uploads encrypted files to the partners SFTP accounts

Business Intelligence Developer

Access and JLG

2017 – 2019

Hagerstown, MD GDC is a data consulting company that uses BI to deliver data to its clients. Business Intelligence Developer Dec 2017 - Jan 2019 Supporting 40+ processes in different service areas such as DBA, ETL, Operations, Support Operations * Database Service Area ? Assisting the Service Area Lead in creating bash scripts, stored procedure to alter, migrate, create insert, update, and delete records in the data warehouse ? Performing Migrate, Online Vacuum Catalog, Purge and loading table growth data for metric analysis * ETL Service Area ? Performing Export, Import and Compile of DataStage files from Dev to Prod ? Rerunning and Testing DataStage Jobs, Sequences and troubleshoot errors in case of job failure ? Modifying SSIS packages to implement derived column from source to destination connection * Operation Service area ? Initiating 2-4-hour process (example: Sales Inventory Operations Planning) to transfer 50,000+ records from iSeries environment through Netezza Database to Cognos Environment ? Validating datasets through SQL Server Management Studio (SSMS) while using DataStage to run sequential dependencies jobs to transform and load datasets in Cognos Environment * Operation (Admin) Service Area ? Designing and implementing ETL (Extract Transform and Load) process in Excel through Visual Basics and Macros ? Extracting 1,000+ internal users' datasets and performing validations to ensure accuracy and dataset integrity ? Processing dataset loads to produce reports and providing visuals (graph dashboard) to display users' performance and efficiency percentage

Education

Master of Science in Information Technology

Hood College

2017

Master of Science in Information Technology

Bachelor of Arts

Shepherd University

2014

Bachelor of Arts