KWADWO OWUSU-ANSAH

Address: Reynoldsburg, OH ****8; Email/Skype: ad2dh2@r.postjobfree.com; Telephone: +1-267-***-****; LinkedIn

PROFILE

17+ years of Overall IT Experience.

15+ years of IT Experience in USA.

17+ years of .Net Technology (VB.NET/C#.NET) and VBA/VB6 Experience.

17+ years of strong RDBMS Experience.

PROFESSIONAL SUMMARY

17+ years of total IT experience in complete life cycle of Software Development that includes requirements gathering, analysis, design, development, testing and deployment using Visual Studio 2003-2019.

Adept in project life cycle processes spanning from requirements consolidation, code development, user reviews, and application deployment.

Experience in .NET includes VB.NET/C#.NET, ADO.NET and ASP.NET. Have been involved in development of multiple internet/intranet and windows applications using .NET platform.

Proficient in Scientific and statistical programming using VB.NET/C#.NET and MS SQL Server.

Vast experience in GUI Development, client/server (N-tier) and Web Application Development using VB/VBA, VB.NET/C#.NET, ASP/ASP.NET, ADO.NET.

Specialized in designing and building Conceptual, Logical and Physical Databases using Database Normalization Techniques, MS SQL Server 7.0/2000/2005/2008/2012/2014/2016/2019, IBM DB2, MS Access and Oracle.

Successfully implemented Database Normalization Techniques, OLAP, ETL, Entity Relationship Modeling, Object – Relational Database Mapping Techniques, Data Serialization and Data Migration.

Proficient in designing and implementing object-relational database mapping (ORM) strategies to bridge the gap between object-oriented programming languages and relational databases.

Creation of backend Tables, Stored Procedures, triggers, User defined functions, Views, DTS packages, SQL Server Integration Services (SSIS); Scheduling SQL Server jobs; Restoring backups using MS SQL Server/T-SQL.

Proficient in developing .NET applications using Web Forms, Windows Forms (WinForms) and WPF.

Proficient in managing and configuring Azure Active Directory (AAD) for user and group management, authentication, and access control.

Knowledge of Azure AD reporting and auditing capabilities for monitoring and analyzing user activities/security events

Proficient in using Infragistics NetAdvantage, DevExpress, Farpoint Spread, Telerik Suite for ASP.NET and other third-party controls.

Extensively used Crystal Reports, MS Access and SQL Server Reporting Services (SSRS) to create reports.

Proficient in using MS Excel and MS Access to build complex tools, utilizing macros and other functionalities.

Vast experience in migration/conversion of legacy application (VB6) to current technologies, including .NET.

Knowledge in Serial (RS232) Communication.

Experienced in using Object Oriented Programming (OOP) concepts in Software Development.

Extensively used Software Design Patterns including Model View View-Model (MVVM).

Proficient Agile/Scrum methodology.

Proficient in designing and implementing service-oriented architecture (SOA) solutions to enable modular, scalable, and loosely coupled systems

Ability to use multithreading in programming, and proficient in unit testing; nUnit and MS Test.

Demonstrated ability to work independently and effectively with minimal supervision in a fast-paced environment with the ability to multi-task and effectively manage expectations.

Exposure to Health, Government (Agriculture), Trading and Supply, and financial/banking/insurance sectors.

TECHNICAL SKILLS

Languages

VB.NET/C#.NET, ASP.NET, Visual Basic 6 (VB6)/VBA, C++, TSQL, PSQL, Java, Talend

Databases

MS SQL Server 2000/2005/2008/2012/2014/2016/2017/2019/2022, MS Access, Oracle, MySQL, IBM DB2

Source Control

Team Foundation Server (TFS), Visual Source Safe (VSS), Tortoise Subversion (SVN), Git

Software Management Tools

HP Applications Lifecycle Management (HP ALM), Version One, Team Foundation Server (TFS)

Operating Systems

Microsoft Windows (NT 4.0, 95, 98, 2000, XP, Vista, Server 2003-2012, 7, 8, 10), Linux (Red Hat)

Other Applications

Version One, Citrix, Crystal Report (8.5/9/10/13), MS Visual Studio/InterDev 6.0, Windows NT 4.0 Real Media, MS Office Suite, MS Visio 2003, MS SQL Server DTS

Networking/Protocols

Windows Socket, TCP/IP

EDUCATION

Certificate in Database Administration October 2015

University of Illinois, Urbana-Champaign, IL

MSc. Software Engineering (Credits) September 2010

Drexel University, Philadelphia, PA

BSc. Computer Science June 2006

University of Science & Technology, Ghana

(Degree is evaluated to USA Equivalent by

World Evaluation Service, New York, USA)

PROFESSIONAL EXPERIENCE

Ohio Dept. of Mental Health and Addiction Service (OMHAS), Columbus, OH April 2021–To Date

Consultant (VB6 Developer/Database Administrator)

Description:

The Ohio Department of Mental Health and Addiction Services (OhioMHAS) provides statewide leadership of a high-quality mental health and addiction prevention, treatment and recovery system that is effective and valued by all Ohioans.

Responsibilities:

•Made suggestions on Application Development and translation of business requirements to application & database design

•Involved in hands-on design and modification of Winforms/WPF applications using VB6/VB.NET/C#.NET

•Migration of VB6/VBA and MS Access to .NET application and SQL Server database respectively.

•Modification of legacy VB6 and MS Access (VBA) applications as business needs.

•Designed and developed various abstract classes, interfaces and classes to implement various business logics.

•Created and revised logical and physical database. Built the entire database for CapacityPlanner software application.

•Created the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, complex stored procedures for application data access, constraints, and roles.

•Database deployment using Visual Studio SQL Server Data Tools

•Analysis and execution of data migrations from legacy applications

•Built and deployed SSIS packages to move data from different sources for further utilization by the business.

•Created and managed the clustered indexes and non-clustered indexes and optimized queries using execution plan.

•Created and managed database login, user permissions and involved in database performance tuning/monitoring

•Involved in ETL, SQL job creation and SSRS Report creation and maintenance as per business requirements.

•Contributed to DBA team standards and best practices.

Environment: MS SQL Server, SSRS/SSIS, MS SQL Management Studio, VB6, Visual Studio 2019(VB.NET/C#.NET), GitHub, Azure DevOps, Team Foundation Server (TFS), ServiceNow, MS Windows, MS Office Suite

BMW Financial Service, Dublin, OH August 2020–December 2020

Consultant (Software Development Engineer)

Description:

BMW Group Financial Services provides financing and leasing of BMW Group automobiles and motorcycles for retail and commercial customers. It also offers customers selected insurance and banking products. It operates in 54 countries and also has a portfolio of more than 4 million lease and credit financing contracts.

Responsibilities:

•Designed and developed various abstract classes, interfaces and classes to implement the business logic.

•Worked in a Scrum/Agile environment to plan and estimate work at different levels (story, sprint, release)

•Worked with development team to define tasks and test plans

•Designed and developed applets using .NET (Winforms/Webforms/WPF/ASP.NET)

•Modified complex stored procedures as per requirements.

•Maintenance and modification of .NET components as per requirement changes.

•Worked with business to identify and fix production issues (production support troubleshooting).

•Designed and developed a new normalized SQL database for the system.

Environment: C#.NET/VB.NET, Jira, Confluence, ADO.NET, WinForms/WPF/Webforms, MS SQL Server, SSIS, MS SQL Management Studio, XML, Web Service, MS Excel, Team Foundation Server (TFS).

Ohio Department of Agriculture, Reynoldsburg, OH July 2018–March 2020

Consultant (Software Development Engineer)

Description:

The Ohio Department of Agriculture is the administrative department of the Ohio State government responsible for ensuring the safety of the food supply, to maintain the health of animals and plant life, and to create economic opportunities for farmers, food processors and agribusinesses. I’ve been the consultant to develop Dairy Inspections and Licenses System (DILS) for the Dairy Division of the department.

Responsibilities:

•Gathered requirements, analyzed the existing system to determine the scope and limitations of the project.

•Designed and developed DILS using C#.NET (WinForms/WPF/WebForms), MS SQL Server and Telerik UI Controls.

•Wrote a Windows Service to import lab results from different sources (LIMS, Excel, SQL Server etc.) across a network.

•Developed custom controls, modules & interfaces in .NET

•Designed and developed a new normalized SQL database for the system.

•Created indexes on tables for faster retrieval of the data to enhance database performance.

•Designed reports using SSRS and Telerik Reporting.

•Designed, generated and converted Telerik reports to pdf format

•Wrote a service to autogenerate Telerik reports, convert them to pdf format and automatically email them to interested parties based on email distribution code.

•Wrote scripts to analyze and expose existing bad and orphaned data.

•Migrated data from old to new system using migration scripts and ETL

•Maintenance of legacy VB6/MS Access/SQL Server and Crystal Reports application.

•Supervised and mentored less experienced developers

Environment: C#.NET/VB.NET, ADO.NET, WinForms/WPF, MS SQL Server, SSRS, MS SQL Management Studio, Telerik Winforms/Controls, Telerik Reporting R1 2020 SP1 (14.0.20.219), XML, Windows Service, MS Excel, VB6/VBA, MS Access, Team Foundation Server (TFS).

RCIS (Zurich NA, formally owned by Wells Fargo), Anoka, MN March 2014–March 2018

Applications Systems Engineer

Description:

Rural Community Insurance Service (RCIS), the nation's largest crop insurance provider, provides insurance and superior services through leading agents to protect America’s farmers and ranchers. It’s been a leading innovator in crop insurance since the crop insurance business was privatized by the federal government in 1980. I’ve been part of the development team to develop and enhance the CiMax application, modifying and adding new features as per business needs.

Responsibilities:

•Development and enhancement of a product suite of applications using WinForms/WPF, Model View View-Model (MVVM) pattern and other third-party controls.

•Involved in requirements gathering.

•Extended and customized existing Windows Forms (WinForms)/WPF and Controls as per requirements changes.

•I was the SSRS ad-hoc reports developer. Designed and maintained SSRS Reports and Crystal Reports.

•Researched to determine the necessity of making certain changes to the existing system.

•Wrote complex SQL statements for data cleanup in production environment.

•Fixed bugs as and when they are reported in a fast-paced environment.

•Modified system to enable exporting reports to Portable Document Files (pdf).

•Maintenance and modification of .NET components as per requirement changes.

•Worked with users to identify and fix production issues (production support troubleshooting).

•Provided training and mentoring to less experienced developers.

•Participated in the QA cycle by guiding the development of testing scripts

•Review code and provide feedback relative to best practices and improving performance

•Conducted research in programming to implement new concepts and strategies.

Environment: C#.NET, VB.NET, WinForms/WPF/WebForms, Infragistics NetAdvantage, XML, ADO.NET, MS SQL Server/TSQL, SSRS, MS Excel, VB6, MS Access, Version One, Team Foundation Server (TFS), HP Application Life Cycle Management system (ALM), Workday, Version One, FarPoint grid, nUnit, SpecFlow.

The Vanguard Group, Malvern, Pa, USA October 2013 – December 2013

Senior Software Developer

Description:

The Vanguard Group is one of the world’s largest and most respected mutual fund companies, offering a large selection of low-cost mutual funds, ETFs, advice, and related services. I was contracted to mainly work on the integration of a newly purchased third-party component (Genesys 8.1) with the existing desktop application.

Responsibilities:

•Maintenance and modification of .NET and VB6 components as per requirement changes

•Integration of the latest version (8.1) of Genesys DLL (a third-party component) into an existing call center application

•Worked with Genesys DLL to capture participant’s (Caller’s) voice or data inputs, validated data and automatically loaded participant’s information from DB2 database to the running desktop application for use by the user.

•Worked with other team members to identify and fix production issues.

•Updated and maintained existing legacy application

•Eliminated retiring ActiveX and DLL controls/components and cleaned dead codes to reflect the changes

Environment: C#.NET, Team Foundation Server (TFS), (Genesys 8.1), Third-party control (Farpoint), Telerik control, XML, ADO.NET, DB2, MS SQL Server, MS Excel

Georgia Pacific, Atlanta, Ga, USA March 2013 – September 2013

Senior Software Developer

Description:

Georgia-Pacific is one of the world's leading manufacturers of tissue, pulp, paper, packaging, building products and related chemicals headquartered in Atlanta, Ga. I was part of the team involved converting technical specifications into software applications for the internal processes for Georgia Pacific.

Responsibilities:

•Designed and developed different modules and different Business Logic Components using VB.Net/C#.NET.

•Developed Windows Application using WinForms/WPF.

•Used ADO.NET objects such as Data Reader, Dataset and Data Adapter for consistent access to SQL data sources.

•Used LINQ to SQL Feature of .Net Framework for retrieving data from DB2/MS SQL Server.

•Took part in the design of the various layers (presentation and business) and database.

•Tied reports to WinForms which were automatically emailed to interested parties in pdf format.

•Created documentation for the complete process.

•Designed the interfaces needed for exposing the Business Components.

•Imported/Exported data from and into a text file (flat file) - parsing a file.

• Modified VB6 Application as per the requirement changes.

•Conversion/migration of VB6 applications to VB.NET.

•Created Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012.

•Wrote stored procedures for SSRS and nightly batch processing.

•Created dynamic reports using Crystal Report and MS Access.

•Involved in security design for the application.

•Implemented classes for data validation and performed edit check on the data.

•Wrote code to provide preview and printing functionality to the end users.

•Retrieved data using LINQ-to-SQL Classes, stored procedures, tables and views.

Environment: VB.NET/C#.NET 4.0/4.5, VB6, ADO.NET, DB2, SQL Server 2012, MS Access, Farpoint Grid, Telerik Controls, MS Excel

WebConnection Inc., Baltimore, MD September 2010- February 2013

Systems/Software/VBA Developer

Description:

WebConnection Inc. is one of the E-Commerce strategic design company which has its practices of internet consultation, website designing, programming and marketing of its products. Designed an E-Commerce engine to process real-time orders for new and existing customers under strategic management services for the roll-out of the marketing functionalities.

Responsibilities:

•Designed and Developed External Web Application using VB.NET/C#.NET.

•Designed and Developed Desktop Application using VB.NET/C#.NET (WinForms and WPF).

•Developed Business Logic Components using VB.NET.

•Designed databases using MS SQL Server 2005/2008.

•Designed the interfaces needed for exposing the Business Components using the Ajax toolkit controls.

•Handled production issues involving real-time application problems.

•Modified VB6/VBA Applications as per requirement changes.

•Designed the Cascading Style Sheets (CSS) to set the layout of the websites.

•Designed Report using Crystal Reports.

•Used ADO.NET objects such as Data Reader, Dataset and Data Adapter for consistent access to SQL data sources.

•Conversion of VB6 legacy applications to VB.NET.

Environment: ASP.NET/VB.NET/C#.NET 4.0, VB 6, ADO.NET, SQL Server 2005/2008, DevExpress, MS Access, Crystal Report 13.0

MYI Consulting, Chester, PA, USA February 2007 – August 2010

Software Developer

Description:

MYI (Managing Your Information) is an innovative information management and business consulting company that focuses on transforming information into value-added business solutions for highly compliant and highly regulated industries. Being a consultant, I worked on multiple systems/projects in a comprehensive project life cycle processes spanning from requirements consolidation, code development, user reviews, application deployment and training of users.

Responsibilities:

•Worked as a consultant on multiple projects as per needs of the clients.

•Defined requirements, project architectures and performed detailed systems design.

•Developed any necessary custom software assigned.

•Integrated off-the-shelf products into systems.

•Verified subsystems and systems.

•Designed and Developed Console Application using VB.NET/C#.NET.

•Developed Business Logic components, Data Access Layer,

and Windows Application using VB.NET/C#.NET WinForms and WPF

•Created documentation for the complete process.

•Designed the user interfaces needed for exposing the Business Components and handled real-time production issues.

•Created new SSIS packages to calculate the Adjusted Prima Facie Rate.

•Modified VB6 Application as per requirement changes.

•Created dynamic reports Crystal Report and MS Access

Environment: VB.NET/C#.NET 2.0/4.0, ADO.NET, DB2, SQL Server 2005, SSIS, VB6/VBA, VISIO

United States Dept. of Agriculture (USDA)/FSIS, Washington, DC July 2008 – July 2010

Systems Developer/Programmer (Consultant)

Description:

Development of a software system for the computation of the Cumulative Sum (CUSUM) Requirements for Accredited Laboratory Program (ALP) for United States Department of Agriculture (USDA) as defined in 9 Code of Federal Regulations (CFR) Parts 318, 381 and 439. I was part of three-person team responsible for onsite system requirement analysis. System design and development of the software system using MS SQL Server 2005/2008 and Crystal Reports 10 were carried out by me. I carried out system implementation and uploading of existing records from Lotus 1-2-3 using MS Excel and MS SQL Server DTS.

Responsibilities:

•Developed Windows Application using WinForms/WPF and developed web UIs using VB.NET

•Developed Business Logic Components and Data Access layer using VB.NET

•Created reports using SSRS and call reports to web pages.

•Designed the interfaces needed for exposing the Business Components

•Created new SSIS packages to transfer data from text files to SQL Server Database

•Handled production issues involving real-time application problems

•Interfaced SQL Server database with MS VB6 WinForms

Environment: VB.NET 3.5, ADO.NET, SQL Server 2005/2008, Crystal Report 10, SSIS, SSRS, VISIO, Lotus 1-2-3.

Contact this candidate