Kevin A. Solomon

980-***-**** Charlotte, NC aczi1g@r.postjobfree.com

Information Technology professional with exceptional record of team management, business and technical analysis, application development, and database analysis. Established 26 year record of effectively facilitating cohesion between business stakeholders and technology.

Professional Qualification

Experienced at managing an application development team through the DMAIC Software Development Life Cycle in an agile or waterfall environment.

Strong data analysis background, adept at coding SQL queries against a variety of databases – Teradata, SQL Server, Oracle, DB2, Access, and Borland Paradox.

Experienced in the ETL process in MS SQL Server environment – building SSIS packages to extract data, developing custom utilities for data modification, and utilizing scheduled utilities to batch load data in creation of data warehouses.

Excellent written and interpersonal communication skills – adept at facilitating communication between business stakeholders and technology, eliciting requirements, and translating those requirements to technical specifications.

Experienced in database modeling and designing system architecture.

Accomplished at creating Business Process Flow documentation, Business Requirements Documents (BRD), and Technical Specification Documents.

Hands on application coding experience in .NET (VB and C#), and Visual Basic.

Professional History

Bank of America 4/2010 – Current

Business Tech Integration – Global Wholesale Bank Tech & Ops – Data Management

Performed gathering and analysis of complete data lineage, from system of record to end point application for all identified KBEs (key business elements).

Documented all controls surrounding movement of data between systems.

Loaded all ancillary data surrounding the KBEs into the Metadata Repository.

Performed UAT functions for Metadata Repository maintenance release.

Application Programmer – Customer Banking Technology & Operations - Claims

Led small team through agile process, remediating line of business created applications (Excel, Access, VB6, VBA) into current technology (.NET, SQL Server).

Created ETL procedures in Access and SQL Server (SSIS) platforms to pull and process data for analysis and reporting to business users and executives.

Main liaison between technology team & Risk officers and Application Governance.

Designed and built Credit Bureau Dispute application for Credit Fraud Claims.

Led project to build out group’s 8 servers, spanning 4 environments.

Performed administrator duties on vendor applications – Recon Plus, IDTCMS.

Trained Level 2 and Level 3 production support personnel on application portfolio.

LexisNexis, Charlotte, NC 1/2010 – 4/2010

Contractor performing a business analyst role during a major migration of plans and data to the corporate flagship screening platform.

Performed GAP analysis of a new screening platform to document missing functionality and disconnected reports.

Create business requirements for changes needed to a new screening platform and ancillary applications to maintain current functionality.

The Newport Group, Charlotte, NC 9/2009 – 12/2009

Contractor performing a technical / data analyst role, documenting ancillary applications used at a remote office to administer qualified retirement plans.

Backwards engineered undocumented legacy MS Access applications.

Created requirement documents that detailed application functionality, and requirements for implementing that functionality into the enterprise framework.

Standard Insurance, Cleveland, Ohio 2006 – 2009

Acquired from Invesmart Incorporate in purchase.

Programmer analyst, interacting with programmers, project managers, development team, testers, database analysts, and infrastructure support in designing all new internal applications to manage a new line of investment business.

Extensive experience managing JAD sessions for transitioning outdated legacy systems into current technologies. Spearheading gap analysis efforts on existing applications, and procured requirements from Subject Matter Experts, Department Managers, and Technical Leads.

Created custom C# and VB.NET applications to perform data analyst and mapping of 401(k) client data being migrated to a new recordkeeping platform. Create ETL process to migrate data between platforms.

Managed team of developers that deployed upgraded C#.NET applications from legacy VB6 systems, implementing SOAP, XML and web services technologies.

Collaborated with stakeholders on the design of a 401(k) participant statement for plans transitioning administrators, eliciting requirements, designing the statement format, and developing the report application through VB.Net and SSRS.

Responsible for creating and documenting UAT test cases, as well as managing QA analysis, test tracking and bug fixes, through Mercury Quality Center.

Invesmart Incorporated, Cleveland, Ohio 2000 – 2006

Acquired Parsons, McKee, Sommers & Co. in initial start up phase.

Sr. Systems Analyst implementing procedures to coordinate 12 independent regional offices acquired in the startup of Invesmart into one nationwide entity providing independent 401(k) advice and administration.

Managed full cycle development of Defined Benefit (Pension) administrative systems, from initial client contact and requirement documentation to application design, installation, training and support.

Manage full cycle development of customized annual benefits enrollment systems – using technologies that included interactive touch screens and optical character recognition scanners.

Elicited requirements and developed technical specifications for a retirement modeling system. Developed application and coded automated SQL queries for regression testing. Installed at client site and provided user training.

Parsons, McKee, Sommers & Co., Cleveland, Ohio 1988 – 1999

Systems Analyst who developed leading edge applications used in the employee benefits services area.

Developed interactive voice response 401(k) account management system.

Managed design team in creation of touch screen interactive systems covering areas of retirement planning, annual benefits enrollment, financial planning and document research.

Ported mini-computer pension calculation systems to PC environment.

Designed company’s first internet presence.

Led Y2K team in identifying applications effected by the change to a new century.

Software Knowledge: Visual Studio .NET – VB.NET & C#.NET, Team Foundation Server, Visual Basic 3.0 to Visual Basic 6.0, Visual Source Safe, Borland C++, Crystal Reports Version 4 to Crystal Reports XI, Teradata, Oracle 9i, Oracle 10g, MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008, SSIS, SSRS, MS Access, Paradox, HTML, XML, SQL Navigator, Oracle SQL Developer, TOAD, Mercury Quality Center

Education and Certifications

MCAD - Microsoft Certified Application Developer - 2005

MCSD - Microsoft Certified Solutions Developer - 2006

ICM School of Business, Bachelors of Science, Computer Science, 1985-1989.

References:

Furnished upon relevant request.

Contact this candidate