Rex Marshall Email & Phone Number

Lawrenceville, Georgia, United States

Responsible for understanding Gwinnett County’s enterprise Public Safety environment to ensure the environment is secure from any threats, ensuring that the technical components of the environment are in sync with the business needs of the organization, understanding and maintaining the High Availability and Disaster Recovery environment, design and.

Lawrenceville, Georgia, United States

Primary responsibility is to develop reports, dashboards and other data visualization tools to assist Public Safety departments such as Police Department, Fire Department, Sheriff’s Office, Community Services, Corrections and Magistrate court in data analysis. It will require gathering data from multiple databases and sources and combine into a simplified.

Remote / Dallas, TX

For a major restaurant chain, the primary responsibility is to drive design, development and maintenance of data warehouse / ETL processes.Works closely with the business intelligence team to understand the data needs / requirements of the organization and implement and support SSIS packages to fulfill those needs.Create documentation outlining ETL.

Remote / Johns Creek, Georgia, United States

• SSIS DEVELOPER CONSULTANT
• For a major retail client convert a Forecast & Replenishment system over to a new Cloud base JDA system by extracting business rules from SQLs in a legacy systems SSIS packages.
• Creating new Data Mapping from the combined legacy and cloud systems business rules.
• Create new source SQL’s in GCP BQ using the Data Mapping and combined business rulesfor Master Data(Item, Location, Demand Unit, Demand Forecasting Unit, Stock Keeping Unit) and Transactional Data(History, On Hands, On.

Norcross, Georgia, United States

• Collaborates closely with new Financial Clients for initial set up of Credit Card Reconciliation Reports and creating new drill down Billing Reports using SSRS and SQL Server.
• Analyze and optimize Production report schedules to upload Financial Reports to clients faster.
• Identified and performance tune SQLs in Stored Procedures for Financial Reports.

Johns Creek, GA

• Reviewed an existing Civil Recovery Payment system with 5-day lag processing time and design a real time process using SSIS, SQL Server, and Tibco MFT.
• Designed and implemented new process to load/receive Civil Case data to/from a 3rd party vendor using SSIS, SQL Server, Stored Procedures, and Tibco MFT which including over 10 years of historical data.
• Created SQL Server Scripts to scan 7 production SQL servers with 36 databases with over 30,000 tables for Highly Sensitive Data and replaced Highly Sensitive Data with generic message for PCI compliance.
• Managed 2 offshore developers for Asset Protection Application for ISN conversion project.
• Collaborate with third party vendor to install a process to send and receive Civil cases using SSIS, SQL Server, and Tibco MFT.
• Designed, tested, implemented SSIS packages to extract data from SQL Server, DB2, Oracle, MYSQL and Teradata and load into DCM Replenishment application.

Dunwoody, GA

• Maintained Pensions Reporting application using VB and DB2.
• Supported Pensions Payment System using mainframe batch COBOL and DB2.
• Coded and Tested Y2K changes for Pensions Payment System using COBOL and DB2.