Kyle Lewis Email & Phone Number

Roanoke, Virginia, United States

Responsible for integrating new and non-standard data for credit risk team that aggregates commercial credit exposures from systems of record and performs general ledger reconciliation for consumption by downstream reporting groups (SEC, regulatory, Basel Capital, etc.).Create/manage quick, tactical solutions for new requirements & data sources. Inform requirements for strategic solutions. Work with finance, audit, and regulatory compliance teams to ensure critical data elements in the data mart meet downstream reporting requirements.Designed and implemented ETL to produce accurate-as-possible balances for monthly fronting exposures for consumption by Basel Capital and Enterprise Risk Aggregation teams.Ensure data is accurate, consistent, complete, and fit for purpose. Standardize and normalize data across portfolios.

Responsible for providing data and analysis to ensure adherence and compliance to government mortgage regulations.Develop customized reporting and dashboards primarily through Microsoft SQL Server Reporting Services front end.Create, modify, and utilize stored procedures, jobs, and SSIS packages for ETL processes, and ensure all data is moved, updated, and loaded as needed and on schedule.Ensure all code and reporting follows proper life cycle development process and that all documentation complies with internal regulations.Primary Tools Used:SQL Server 2008 and 2010, Visual Studio 2005, 2008 and 2010, RapidSQL, Teradata, DB2, SQL Server Management Studio 2008 and 2012, and Team Foundation Server.

Provided technical consultation and 24/7-365 support for tiers 2 and 3 applications for Corporate Security.Analyzed reporting requirements, created code for both ad hoc and “canned” reports, validated report data through testing, oversaw the promotion of reports from test into production.Analyzed business requirements (BRD) and designs, and wrote technical specifications to design or redesign computer solutions for Corporate Security.Ensured all application databases (Microsoft SQL Server Databases) and servers were patched, maintained, and upgraded appropriately. Additionally, ensured lower environments are scrubbed of sensitive data.Verified program logic by overseeing the preparation of test data, testing, and debugging of supported applications.Developed original code and documentation, participated in the development of department technical procedures and user guides, and provided coding guidance and training to less experienced staff.

Roanoke, Virginia Area

Roanoke, Virginia Area

Roanoke, Virginia Area

Ba, English And German

Ma, Liberal Studies - Milton Studies