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 conduct hardware/software tests, and ensure proper performance of the environment.

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 view of the complex data sets for the end user. Other functions include handling day-to-day systems administration and work with the user community to maximize their ability to utilize all system functionality. Aid in technical leadership as related to new applications, from strategic decision making to project planning and execution. Applies proven communication, analytical and problem-solving skills to help identify, communicate and resolve systems issues in order to maximize the benefit of IT investments

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 processes.Create and deploy Microsoft SSRS reports.

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 Orders, Transfers, Pricing & Promotional)

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.• Mentored co-workers in 5 other teams with SSIS and T-SQL.• Converted over 250 SSIS packages from SQL Server 2008 to SQL Server 2014 for 3 applications.• Performance tuned SQL’s (Oracle, DB2, SQL Server, MySQL and Teradata) in SSIS packages.• Created SSRS operational reports for Teradata Replenishment application.• Managed 6 offshore developers on creating SSIS packages for Teradata Replenishment application. • Collaborate closely with Size Profiling team to interface new attributes to JDA Allocation.• Designed and developed feeds for JDA Allocation to Purchasing Size Profiling application using COBOL and Oracle stored procedures.• Performance tuned Oracle SQLs for JDA Allocation feeds decreasing nightly batch run time.• Identified and Implemented changes to Merchandising Applications saving over $250,000 annually. • Designed and Modified the Inventory Forecasting Application using DB2, Oracle, MQ Series, CICS and Datacom. • Supported Merchandising Buying system using COBOL with DB2, Oracle, Datacom databases.

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.