Bill Johnson Email & Phone Number

• Architect and implement enterprise level technical infrastructure solutions in support of business initiatives using SDLC project management processes. Design and manage SQL Server 2000, 2005 and 2008 database servers.
• Reviewed and documented architecture for technical initiatives, including vendor solutions to ensure alignment with strategic business outcomes.
• Designed and implemented improvements to system-wide processes, procedures and standards.
• Provided advanced technical escalation support for all enterprise level applications, processes, and enhancements.
• Successfully designed, implemented and documented an enterprise reporting architecture using SSRS and supporting efficient, customized reporting, and automated ETL data refresh using SSIS and integrated multi-server.
• Technical Infrastructure Lead on successful 2009 core banking conversion project. Designed the entire application infrastructure to ensure maximum business value while minimizing cost. The resulting multi-environment.

• Primary DBA, managing the design, implementation, maintenance and reliability of SQL Server database systems supporting multiple mission-critical, enterprise-wide business applications and providing technical expertise.
• Consolidated, re-engineered and standardized pre-existing database and server infrastructure to decrease cost and optimize performance.
• Driving force behind the creation of a systematic, detailed, deploy plan for the 2004 core banking technology conversion.
• Architected, developed and implemented a highly reliable automated, secure file transfer (FTP) system in SQL 2000 DTS for exchanging critical data with business partners utilizing PGP encryption.
• Provided consulting to end users and developers on TSQL and stored procedure coding, query optimization, and reporting.
• Tightened security on all database servers and implemented ongoing security controls.

• Maintained and managed enterprise database systems, running Sybase on AIX, Model204 under VM, and Microsoft SQL Server, including SQL failover clusters for high availability. Designed and developed software tools to.
• Architected, implemented, and maintained the enterprise web infrastructure for Russell, supporting over 175 IIS websites. Managed the integration and deployment of ongoing e-business capabilities for Russell for 7.
• Developed tactical and long-term strategies for relational and object databases, end user data access, web technology and e-business infrastructure, while serving on three Russell strategic architecture teams.
• Provided consulting and recommendations on technology standards and issues impacting integration, reliability, scalability, and feasibility of proposed database, web and e-business related initiatives and applications.
• Served as subject matter expert on Sybase and SQL Server database connectivity architectures.
• Authored and published several company-wide web and database technology articles targeted to business unit managers.

• Ensured the efficient operation, availability and integrity of enterprise VM/M204 database systems.
• Developed utility software to retrieve online documentation and enhance operational efficiency.
• Developed software to analyze and monitor databases and resolve data integrity issues.
• Provided expertise to users on data retrieval, database operations and processing.
• Managed database backup and recovery operations, and database optimization.

• Designed and developed enhancements to the Analytical Photogrammetric Positioning System (APPS) for Dept of Defense as part of innovative three person team. Resulted in an estimated 2 million dollar savings. Received.
• Designed and developed an interactive data verification and quality control system.
• Provided user training through briefings and demonstrations.
• Proven ability to produce efficient software in a fast paced environment under short deadlines.
• Designed and prepared sole-source procurement justifications for office automation network.
• As Cartographer, operated advanced NISTRI/OMI stereocomparators and performed analytical aerotriangulation and statistical analysis of geographic data. Developed software routines to increase processing efficiency.

Bachelor Of Arts, Geography (Cartography), Minor Geology, Mathematics, And Anthropology

Magna Cum Laude, Dean's Scholar, Top 1% of class.

Bachelor Of Science, Computer Science

Certificate, Geodetic Technology

School of Technology and Information Management (GPA 4.0/4.0)