Sql Server Quality Assurance

Frank R. Eberling

*** ****** *** #***, *********, OH 44113 216-***-**** abnnk3@r.postjobfree.com

Senior Data and Reporting Specialist

Insightful, results-driven IT professional with notable success directing a broad range of corporate IT

reporting and data initiatives while participating in planning, analyzing, and implementing solutions in

support of business objectives. Excel at providing comprehensive data design and system analysis.

Hands-on experience leading all stages of system development efforts, including requirements definition,

design, architecture, testing, and support. Outstanding project and program leader; able to coordinate

and direct all phases of project-based efforts.

Areas of Expertise:

Data Structure Design / Implementation Risk Assessment / Impact Analysis

Reporting Design / Automation Technical Specifications Development

Data Integrity and Quality Assurance Team and Project Leadership

Professional Experience

National City Bank, Cleveland, Ohio 2002-Present

Assistant Vice President – Senior Data and Reporting Architect

Develop, maintain, and upgrade automated reporting packages and data structures in the financial

industry. Coordinate design and implementation of data structures and reporting with project managers

and business units to insure on-time completion of project deliverables. Provide technical leadership to

junior team members, developing overall data and reporting architecture.

Key Projects:

Risk Analytics Data Store and Reporting Redesign:

Designed, purchased, and implemented a Windows 2003 Server with 17 terabytes of storage

used in risk reporting for the entire consumer bank

Utilized SAS, SQL, and DTS packages to automate the monthly load of data from several

platforms including Oracle, SQL Server, DB2, and mainframe files.

Created reporting for several outside business units utilizing SAS, Microsoft Excel/Access

Scripting, Microsoft Analysis Services, an d Microsoft Reporting Services .

W orked with internal auditors to ensure Sarbanes-Oxley (SOX) compliance.

Platform and reporting structure utilized on enterprise mission critical forecasting applications

including National City’s 7 billion dollar capital raise and quarterly risk reporting for the entire

consumer bank

In 2 years of operation the reporting platform has experienced zero unplanned downtime.

Small Business Customer Connections:

Participated as a subject matter expert and aided in the design of multi-terabyte data structures

and reporting used in mission critical account booking systems. Resulted in modernization and

automation of small business product approval and booking systems.

Designed stored procedures, views, DTS packages, and user defined functions in SQL Server to

provide real time reporting for business units.

Used a variety of reporting tools to accommodate the reporting needs of several business units

including Microsoft Access and Excel scripting, Microsoft Reporting Services, Microsoft Analysis

Services, and Crystal Reports.

nd rd

Received “Simply the Best” award, 2 quarter, 2005 and 3 quarter 2005 for efforts contributing

to the successful completion of the project.

Progressive Insurance, Mayfield, Ohio 1999-2002

Mainframe Systems Programmer/Analyst

Develop, test, and maintain mainframe applications and reporting in the insurance industry. Work with

business units to gather business requirements and implement solutions to facilitate their business needs.

Assigned to several mission critical projects and utilized as a technical resource by junior programmers.

Key Projects:

PROTEUS System Redesign

Participated in the migration of a mission critical policy processing system from the mainframe

VSAM files to DB2

Assisted with extensive data mapping exercises, database design sessions, and business

requirement gathering.

Created high complexity JCL and COBOL jobs to facilitate the gathering of data from front end

applications and transformation for load into the DB2 platform.

Creation and maintenance of CICS transactions and sc reens used for TDQ management.

Utilized mainframe tools such as SAS, Librarian, QMF, File Aid, and Syncsort to facilitate

reporting and information gathering tasks

Y2K Mainframe System Conversion

Reviewed, documented, and tested thousands of programs in written SAS, COBOL, and DYL280

to ensure proper Y2K readiness.

Identified and corrected hundreds of errors resulting in zero downtime as a result of Y2K.

Other duties included:

24/7 on call support or mainframe systems

Requirements gathering and ad-hoc reporting for multiple business units

Mentoring and training junior members of the team

Technical Proficiencies

Platforms: W indows 9x/NT/2000/XP/Vista/, Windows Server 2003, OS/390, CICS, TSO, UNIX

Software SQL Server 2003, SQL Server Analysis Services (SSAS), SQL Server Reporting

Packages: Services (SSRS), SQL Server Integration Services (SSIS), Crystal Reports, Librarian,

Syncsort, QMF, MS Access, MS Excel, Microsoft Sharepoint

Languages: SAS (TSO Batch, TSO Interactive, Unix, PC), COBOL, JCL, SQL(DB2, SQL Server,

Oracle), Visual Basic 6, VB.NET, VB Script, ASP.NET, HTML, XML

Education

Bachelors of Information Systems Technology

Cleveland State University, Cleveland, Ohio

Training

Attended training courses in SAS, COBOL, File-Aid, Syncsort, QMF, Librarian, SQL, Object

Oriented systems design, Consumer Lending products, Insurance Products and Underwriting.

Contact this candidate