Manager Data
Resume:
Douglas M. Fox
San Antonio, TX 78258
******@***.***
Technical Profile:
Hands-on Technical leader, administrator, developer, analyst, project manager and support specialist with 15+ years contributing to advanced IT projects and database performance, project management and team Management. Track record of exceeding operational objectives for employers. Industries that have been part of my professional development are: Banking, Communication, Telephony, Healthcare and Education. Skilled in release management, administering SQL Server and MySQL from production servers, data migration, data mining, technical writing, security, reporting, query tuning and ETL tuning. Expert in obtaining data from many sources Informix, Oracle, DB2, Flat files and many more. Expertise in troubleshooting and maximizing database configurations. Passionate in producing the most effective, efficient IT resources and implementing new technology.
Project Management Network Infrastructures Customer Service Database Development QA Systems Business Support Performance Management IT Resources PL/SQL Source Code Libraries Log Shipping Application Development Global Team Leadership Policies/Procedures Development Regulatory Compliance Data Analysis Strategy Development System Migration Backup Operations Risk Mitigation Troubleshooting SQL Server Support T-SQL Queries Azure Replication Configurations/Settings DTS/SSIS Packages Technical Documentation Clustering Database Mirroring ETL PCI compliance SSRS Web Development
PROFESSIONAL EXPERIENCE
IBC BANK (June 2016-December 2020)
Application Development and Software Delivery Manager
Yearly budget of over 3.5 million dollars.
25 Direct reports all developers into a highly high performing team. Started with 3 developers and 7 Application Specialist
Over saw DBA team with 5 DBAs and upgraded over 180 clusters, fined tuned servers and queries.
Define and drive long term product strategy based on relationships with key customers and technology partners.
82 separate applications supported.
Upgraded, administered and supported 3 SharePoint Farms with over 25 servers hosted in Azure
Architected and delivered 7 Major core applications
Management and execution against project plans and delivery commitments.
Management of departmental resources, staffing, and enhancing and maintaining a best-of-class engineering team
Evolution of the software engineering practice within the organization, including better reporting, tools, and evolution of development methodology and tools.
Upgrade of all database from 2008,2012, 2014 SQL server to 2016, 2017 and 2019 SQL.
FCE Benefits (March 2015- June 2016)
Employee Benefits
Enterprise Architect\SQL DBA
Architect of new Claim System and Plan Building System
SSRS Environment with over 120 different reports to support business.
Move Data Bases From Older Technologies to MS SQL Server 2012 and 2014
Set up of new MS SQL Environments including SSRS and SSAS environments
Creation of data warehouse.
Standardization of security.
Set up of EDI Processing
Standardization of data base security and system security.
Data management initiative creation and implementation.
Took over Web development management.
oManaging group of 5 developers and 6 external providers.
Consolidation of AS\Replication servers.
DR environment created.
Log Shipping Replication
Resolve Issues with log files and maintenance.
Review,Enhance Current SSIS packages, Stored Procedures
oSSIS Packages are not efficient and created many issues.
oCurrent running stored procedures are mostly written with cursors reengineering of stored procedures to be more efficient
Daily Trouble Shooting.
oFix long running queries
oSecurity Issues
CaptureRX (April 2014—March 2015) San Antonio, TX
Health Care Company dedicated to the administration of the 340b plan.
Senior SQL Developer/ Team lead
Enhance Current ETL Process
oCurrent ETL process has many issues, long running processing, incorrect processing.
So far, fixed ETL process from running over 19 hours a day to 14 hours
Data processing has been fixed to a 75%
Review and Enhance Current SSIS packages
oSSIS Packages are not efficient and created many issues. Fixed 15% of SSIS with an improvement of 55% in overall performance.
Daily Trouble Shooting.
oDue to incorrect ETL processing data had issues that needed daily attention.
oAlso due system processing issues.
Report Generation
oEnhancement of current reports, setting up SSRS environment and transforming current report structure to an SSRS environment.
Enhancements to current Administration Software of application.
oCurrent Admin system written in C# which needs many enhancements to enable final user to do more and rely less on IT support.
Daily operation support.
Adhoc Reporting
Time Warner Cable (April 2007 – March 2014) San Antonio, TX
Cable, Internet, Telephone Company
Senior DBA (Data Architect) /Application Development Manager
Responsible of all SQL for the BI group
oThis includes all daily processing including indexing, clean ups and maintenance overlooking the West Region DBAs’ 7 Total DBAs’ included in the team over 45 SQL Clusters and 5 UNIX Oracle Servers. All DBAs’ different work load and skills effectively identified correct line of work for each one and we had a very successful group.
oDaily review of long running queries to optimize them
oConstant work with reporting team helping to create efficient queries.
Architect of Common TWC database used for all employee data and customer data, two very large data warehouse created, among many other databases.
Responsible for ETL process for the West Region of TWC including Creating and maintaining SSIS packages, Internal ETL process thru Bulk inserts, from flat files to database.
Lead on any database migration and development projects for One Time Warner, Including the migration from AS\400 to Oracle to MS SQL.
Fix all long running Queries.
Creation of all SSIS packages needed ranging from simple import to complex SSIS packages for daily ETL.
Set up all new SQL servers for Business Class.
Set up of daily replication of Sales Force into MS SQL database for Business Class.
Set up replication between Milwaukee AS\400 servers into MS SQL servers.
Architecture of Business Class Databases to have common reporting data capabilities.
Consolidation of all Texas Servers from 25 SQL servers to 5 and then for the West region from 525 to 25.
SQL Server Patching and upgrades.
Unification of all data for residential coming from all types of databases to include MS SQL, Oracle and AS/400(DB2).
Over 250 Application Data Bases
oMaintenance of these data bases
oAnalyze all long running queries and identify improvement of them to include all stored procedures.
Responsible of routing system for the entire west region.
Responsible for all changes for several Region Applications in VB.net, C#.net.
Was responsible of the San Antonio Internet.
Application Developer Manager
Maintenance of legacy systems (asp) and re-developed in .net using AS/400 data and local SQL server.
In charge of SQL data bases.
5 Cluster 2005 MS SQL Server.
10 Separate 2005 servers
Maintenance, Development, and troubleshooting work flows in AVAYA IC.
Developed Sales Application used to capture all new sales, transfers and upgrades for Time Warner San Antonio, which created a complete work flow all the way from billing to creating work order for installation housing under one roof sales, updating billing information in the AS/400 system, creating work order. That same work order initiated work flow that included all operation department’s serviceability to install.
100% PCI compliant done in VB.Net in production over one year error free and due to regionalization it was decommissioned.
Developed frame work for work flows all in vb.net used by Texas Region.
Presently running 3 mayor applications which integrate all departments.
New Application Development done with same frame work done with a week and half average.
Developed reporting for call center extracting data from AVAYA IVR and AVAYA IC.
Established current Software Development Cycle used in the west region.
Harcourt Educational Measurements (June 2001 -April 2007) San Antonio, TX
Educational- Provider of many of the State Test.
Software Engineer, Data Base Developer -DBA/Item Bank Manager.
Software maintenance of Item Development Tools written in Power Builder using Oracle as a data base Storage and exporting to XML.
Technical and programming lead in all Harcourt Item Banks (Data warehouse) all in File Maker Pro using different technologies (such as: Access, Visual FoxPro, DBF tables and Data Bases, Visual Basic, Word, Excel, Oracle, J2EE, XML...) to achieve the desired outcome, plus importing and exporting data to many different formats and platforms. These Items Banks are more than just a repository of data; there are more of a tool for the creation of state test and other functionality.
Developed and lead several major Item Banks (Data warehouse) for states item repository and test building over the Web. Over seeing a group of 10 members.
Create Scripts, programs, and data base structures to check and maintain Data Base integrity and security, this is for when data is keyed in, imported or manipulated in any way, form or manner. Including procedures for backup, and security check.
Manage and manipulation of data from different sources for different uses and integrate them into Item Bank (item warehouse).
Daily Problem resolutions.
Assessment to upper management for the different types of technologies available for the decision-making.
Manage Item Bank Coordinators to successfully obtain all data needed for the item banks.
RailAmerica (EDS) Contractor (Oct 2000-June 2001) San Antonio, TX
Transportation company owner of railroads across the US and Canada
Contracting as Senior Software Engineer
Developed DTS packages for Data Transformation from AS/400 system to MS-SQL server.
From DTS packages developed VB6 program for Transformation using parameters permitting transportation easy transportation of software.
Daily Problem resolution.
Set up and maintenance MS-SQL Server and Data Bases.
Previous experience available upon request:
Education:
ITESM (Tech of Monterrey)
Major: Computer Science Minor: Business Administration
ITESM (Tech of Monterrey)
Master of System Administration and Finance
Contact this candidate