Samuel Davison Email & Phone Number

Atlanta, GA, US

Help to establish a metadata-driven ETL framework using AWS Services. The framework processes over 150 files a day, that’s over 1TB daily. The framework is easy to use and flexible to handle data files of different sizes with a variety of fields and datatypes. It also simplifies the onboarding of new data files into the ETL process. Reducing the onboarding.

• Site Integrators provides application development and integration outsourcing for small to large-sized organizations. Leveraging years of software development experience, we deliver cost-effective, scalable and.
• Created custom SSIS task components to integration Hadoop HDFS and Oozie with SQL Server Integration Services.
• Created custom SSIS task components to integration AWS with SQL Server Integration Services.
• Created Android and Windows Phone apps that provides real-time FAA airport delay information to pilots.
• Created a Windows Phone app that provided users with current legislation information from the U.S Congress.

Atlanta, Georgia, US

• Developed Change Data Capture (CDC) ETL process in AWS using EMR, Lambda, CloudWatch, API Gateway, S3, and Dynamodb
• Created custom Hive SerDe to read tab delimited text files that have escape tabs in some records.
• Helped to upgrade Hadoop Cloudera CDH4 to CDH5.
• Helped to implement a Hadoop Big Data solution using Cloudera CDH4.
• Architected an ETL data change capture process to load over a 100GB of data a day into Hadoop from several different sources using Python, Spark, PySpark, Hive and Oozie. This process identifies the delta records and.
• Lead the process to implement a BizTalk 2010 environment, from the initial proposal to installation. This system currently support the integration of 4 newspapers with millions of subscribers and advertisers.

US

• Developed classified ads web sites using Ruby on Rails and MySQL
• Planned and developed integration layer that move ads from AJC classifieds web sites to third-party vendors such as Monster.com and AutoTraders.com
• Developed an ETL process to download classifieds ads payment information from classifieds sites and load them into AJC’s ad revenue system.
• Developed an ETL process to upload accounts and order information to SalesForce.com using SSIS.
• Developed an ETL process to upload customer statements to a third-party printing and mailing vendor.
• Helped in the initial development of AJC’s ad revenue BI portal using SSIS, SSRS SSAS and SharePoint.

Duluth, GA, US

• Architected and developed multiple event registration web sites for companies such as Entrust, Dell Computers, and Alcatel.
• Architected and developed a customer web portal that integrated Nth Degree’s legacy order management system to allow customers to enter, modify and check the status of their orders.
• Helped to develop and maintain a Data Warehouse and reporting system using SQL Server, ASP and Crystal Report.
• Upgraded and maintained a web based “time tracking” application that helped managers to monitor labor costs on current projects.
• Architected and developed a web based event management application that replaced a Microsoft Access 2.0 application.

Duluth, GA, US

• Helped to develop and maintain a data mart application that allowed production managers to better summarize production data to analyzied their department productivity.
• Helped to maintain a budgeting and forecast application for the entire manufacturing operation with an annual revenue of over a billion dollars.
• Helped to evaluate and implement a new budgeting application, ADAYTUM. Reviewed the functionality and implemented the integration with Oracle 8 and AS/400

• Helped to develop and maintain an integrated “shop-floor” system that tracked the status of modems as they moved down the assembly line.
• Helped to maintain consumer rebate fufillment web site.

• Helped to develop and maintain transportation rating software for the trucking industry, including carriers such as Old Dominion, Southeastern Freight, and Yellow Freight.

Business Administration/Computer Science And Information

Computer Science And Information