Charles Williams Email & Phone Number

Web administration for Durango Botanic Gardens and OnlyTheDot.com. Managing technical back end issues from databases to SSL certificates and DMARC information.

Tulsa, Ok, Us

• Integrated disparate data sources with Salesforce using CData's DBAmp.• Built SSIS processes and stored procedures to facilitate bimodal data movement with Salesforce.• Customized vendor supplied DBAmp stored procedures for the bank's architecture, security restrictions, and design.• Mentored junior members of the team in database fundamentals, enterprise scheduling, development protocols and design.

Grand Prairie, Texas, Us

• Re-established & led the weekly Application Approval Board and collaboratively revised the district software acquisition standards with stakeholders.• Purchased and managed licensing for district edutech with ~$1MM spend. • Managed and participated in help desk L1, L2 & L3 support for rostering and transferring data between 30+ software applications.• Multiple ETL projects for data integration leveraging automation, Python and SQL Server for data quality assurance and formatting.

Dallas, Texas, Us

• Managed an Agile team of near-shore developers in creating and monetizing SaaS using various technologies by establishing standards, protocols, project management, peer reviews, and change management.• Business development included RFI & RFP analysis, response and strategizing with other senior level technologists and the company president.

Chicago, Il, Us

• Active voting member of the international Harley-Davidson Design Review Board. Future software architecture and design were presented and reviewed by a select panel against various criteria.• Managed DataStage developers responsible for the data pipeline from the loan system (Oracle Financial Services Lending & Leasing) to the accounting and analytic data marts encompassing multiple systems, databases and processes.• Developed and enhanced Securities and Exchange Commission (SEC) compliance reporting using DataStage.

Chicago, Il, Us

• Managed mixed Agile development team migrating an enterprise customized loan management system to Oracle Financial Services Lending & Leasing (OFSLL) on Linux over five years.• Vendor management for payment file processing redesign including standardization and pre-validation.• Redesigned Office of Foreign Asset Control (OFAC) customer and vendor data submission process to use standard frameworks, processes, and enterprise scheduler, Control-M.• Managed and conducted Controlled Self-Assessment for internal security audits of application, database, and server access.• Created shell scripts, tables, indexes, keys, views, functions, dynamic SQL, procedures, packages, cursors, exception handling, and external tables as needed to provide required functionality.• Created software builds using Jira, Subversion and the HD Tool Kit for delivery to distributed environments.• Provided batch processing 24/7 rotating on-call support for the loan management servicing application.

- Managed A/R ETL and reporting with Oracle Application Express & Discoverer as well as multiple Access databases.- Reports optimized with materialized views and analytic functions.- Automation with shell scripting and VBA coding for health insurance coverage eligibility verification.

London, Gb

Migrated (ETL) 35MM rows using PL/SQL on Unix including MD5 encryption, validation, and refinement. Execution was designed to maximize use of the dual core database server. Processing completed in a few days without locks, errors, data integrity issues or downtime in a live environment at an average migration rate of 200 rows per second.

Managed a team of five, maintaining and supporting the company's multiple production applications including the primary invoicing system, Order Entry, and MP2. Systems involved complex multiple interfaces, and roughly 60 forms with multiple screens and hundreds of reports. Responsibilities also included site visits for requirements gathering and troubleshooting.

Issy-Les-Moulineaux, Paris Region, Fr

Primary database architect of the Batch Management and Property Daily Reporting systems using Oracle Designer. Developed custom Oracle Developer 2000 Reports and custom Oracle Forms in a Oracle Applications environment. Designed and developed various custom packages, procedures, views and functions using PL/SQL. ETL of lodging information from various hotel brands into a central auditing, analysis and distribution system. Participated in gathering business requirements with users and authored a dozen associated technical documents (MD070). Defined value sets and registered menus, forms, and reports.

Richardson, Texas, Us

- Managed a five-person development team supporting & enhancing a web based Violation Processing System for the North Texas Tollway Authority using Oracle Designer & Developer 2000 Report Builder on Windows.- Designed and developed standard global web modules shared across applications.- Extensive use of APIs and PL/SQL for custom business rules.- Automated ETL of complete Texas Department of Motor Vehicle license plate to address cross-reference information for violator plate lookup post image OCR.- Created a complex high volume double sided violation invoice mailer.