Brad Williams Email & Phone Number

Chapel Hill, Nc, Us

Chapel Hill, Nc

Raleigh-Durham, North Carolina Area

Salt Lake City, Utah

▪ Managed delivery of technical aspects of ADP’s outsourced benefits administration systems. As the Systems Analyst, I was tasked with primary responsibility for configuration and system performance of a web ­based database system that facilitated employee benefit enrollments for clients via a hosted Internet portal.▪ Worked extensively as the technical liaison between Account Executives and System Developers to tailor upcoming releases based on client feedback regarding enhancement requests, bug fixes, and regulatory changes requiring system modification.▪ Designed, tested, and implemented configuration changes to ADP’s suite of benefits administration systems and custom interfaces for external carriers and client vendors.▪ Supported system processing and creation of outputs for clients, vendors, and other ADP product areas.▪ Documented client requirements and enhancement requests and translated into system designs.▪ Automated manual processes resulting in efficiency gains.▪ Designed, created, and automated ongoing reports for internal and external clients.▪ Created test plans to verify the accuracy of all system output, upgrades, and implementations.▪ Provided ongoing support for escalated issues involving data discrepancies, system errors, and product development requests.▪ Main point of contact for questions from account managers regarding system capabilities, project timelines, software enhancements, and upgrades.▪ Wrote database queries, reports, and scripts used for troubleshooting and data issue resolution.▪ Led process improvement initiatives, drove change control opportunities, and helped create training materials for associate analysts.▪ Technologies used include proprietary software, Oracle, XML, Javascript, TOAD, Tortoise, Quickbuild, Jenkins, Database Explorer, FoxPro, Crystal Reports, Report Writer, Access, Excel, PowerPoint, Citrix, and SharePoint.

Winston Salem, Nc

▪ Responsible for design, implementation, and maintenance of a database and website system that enabledannual and ongoing enrollments for health and welfare benefit plans for clients.▪ Interpreted client requirements into enrollment system design using SQL coding.▪ Designed and implemented system user interfaces.▪ Created and implemented test plans used to validate the efficacy of system changes.▪ Verified the accuracy of all system inputs and outputs.▪ Coordinated, tested, implemented, and validated system enhancements and upgrades.▪ Technologies used include proprietary software, SQL Server, Transact SQL, and Microsoft Access.

Greensboro, Nc

▪ Responsible for overall operation and performance of Guilford County Schools’ Student Data Warehouse.▪ Utilized SQL Server Data Transformation Services to extract over 20 separate Student data domains distributed throughout the district.▪ Cleansed and normalized data prior to loading production data into a DB2 environment by creating ad hoc queries, stored procedures, and automated DTS packages.▪ Queried data in order to satisfy federal and district reporting requirements.▪ Created backup and restore routines for temporary, staging, and production database environments.▪ Technologies used include SQL Server 2000, IBM DB2, Hyperion Intelligence Query Tool, Microsoft Access, and Microsoft Access Projects.