IT liaison, SQL Server 2017, SSIS Packages Charles H. Klotz 1640 Chattahoochee Run Drive​​404.242.2231 Suwanee, GA 30024 ​​
[email protected] SQL Business Intelligence Architect- over 20 years’ experience independently employing a broad knowledge of principles, practices and procedures in multiple fields of specialization to plan, design, develop, and support systems and projects. • Strong problem solving and analytic skills • Specialties are relational database design using SQL Server, T-SQL & SSIS package design • Proven ability to translate business needs into technical specifications • Known for Team diplomacy, good communication skills as customer liaison • Strong knowledge of SQL for reporting and database structures, including developing complex SQL queries • Generated positive results Managing geographically diverse cross functional teams • Excellent track record of carrying out complex assignments, requiring development of new or improved techniques and procedures. Work History Senior Specialist-AT&T, Atlanta, GA​​​​​​2/2002- Present SQL Server (Telecommunications Network Provisioning) • Managed the deployment of production reporting applications for several AT&T provisioning functions for team members located across Europe • Designed, implemented, and maintained various SQL Server databases for reporting • Migrated/Re-engineered databases from SQL 2000/2008 to SQL 2014 • Linked servers to Oracle data sources (pass-thru queries, etc.) • Organized and programmed for disparate raw data feeds from multiple sources • Developed techniques for normalization and robust database design • Enhanced other team members’ technical abilities via informal training SSIS Package Design (Telecommunications Network Provisioning) • Deployed results to web-based reporting resources • Created numerous SSIS packages for management reporting • Utilized complex TSQL queries, table value functions, etc. • Trained other team members on the basics of SSIS package design Primary Languages - T-SQL, C# (for SSIS package design), Visual Basic, MS-Visual Studio Programmer/Analyst-Concert Telecommunications Vinings, GA ​​11/2000 to 2/2002 Project Support Specialist- Boeing Missile Systems Division, Duluth, GA 9/1985 to 10/2000 Education: B.S. Industrial Management (IM), Georgia Institute of Technology, Atlanta, GA
©