Frank Kile Email & Phone Number

Greater Milwaukee Area

Wisconsin

Pewaukee

Tune queries and SSIS packages to increase performance and decrease resource consumptionDesigned logical and physical databases, SSIS packages, and Stored Procedures based on project requirements.Maintain databases of varied size, up to 5 Terabytes.Execute code changes for development, test, and production databases.Responsible for the maintenance and performance of the data warehouse, SSIS, and SSAS environments.Provided consultation to team members for project design, implementation and issue resolution.Develop and maintain secure file transfer scripts for client data.

Client Contract - Mssql Infrastructure Engineer

• Performed detailed design and estimates of work for IT projects.• Implemented complex database designs and configurations based on business requirements.• Transitioned completed projects to Support & Operations team and provided training on new technologies.• Designed and built the MSSQL 2012 Business Intelligence data lab environment providing users the ability to self-serve their reporting and analysis needs.• Built and supported the MSSQL database environment for the implementation of PeopleSoft Financials and provided training to the support staff.• Created the documentation, support governance, and deployment roadmap for MSSQL 2012 as an Enterprise level DBMS. • Provided consultation to Support & Operations team members for issue resolution on high priority systems.

Executed code changes for development, test, and production databases, including major version updates to internally developed applications.Maintained databases of varied size, up to 750 Gigabytes.Tuned queries and SSIS packages to increase performance and decrease resource consumption.Provided consultation to IT team members for project design, implementation and issue resolution.

Administered the maintenance and performance tuning of over 60 database servers, including off-site disaster recovery.Structured and maintained databases of varied size, up to 600 Gigabytes, totaling over 2 TB of production data.Designed logical and physical databases, SSIS packages, DTS packages, and Stored Procedures based on project requirements.Provided overall system administration of Business Objects and Data Integrator servers.Executed daily code changes for development, test, QA, and production databases.Administered the PeopleSoft SQL environments for Test, Development, QA, and Production.Responsible for the maintenance and performance of the data warehouse environment.Designed and implemented new procedures for disaster recovery, reducing the complexity and time needed for full SQL recovery at the DR location.Upgraded the code and databases for the data warehouse environment from SQL 2000 to SQL 2008 R2, including DTS conversions to SSIS packages.Developed and implemented a new invoice data mart for the enterprise data warehouse which consumes invoice data from four different mainframe systems and Peoplesoft, providing a coherent view of the sales data from all of Rexnord's manufacturing plants in one location.Provided consultation to IT team members for project design, implementation and issue resolution.

Responsible for maintenance and performance tuning of over 50 database servers, with several Terabytes of data, including off-site disaster recovery.Structured and maintained databases of varied size, up to 250 Gigabytes.Design logical and physical data bases, DTS packages, and Stored Procedures based on project requirements.Provide overall system administration of Intranet and Internet sites, and web related issues on 45 IIS servers.Developed and implemented technology upgrade plan for all web farms to IIS 6, and Application Center 2000 for content replication.Execute daily code changes for development and production databases.Implemented and improved data transfers, automating over 75 daily manual data transfers.Responsible for maintaining multiple development and production PeopleSoft environments.

Independent Consultant