Resume

Sign in

Sql Server Net

Location:
United States
Posted:
May 28, 2020

Contact this candidate

Resume:

KWADWO OWUSU-ANSAH

Address: Reynoldsburg, OH ****8

Email/Skype: addhdt@r.postjobfree.com

Telephone: +1-267-***-**** LinkedIn

PROFILE

14+ years of Overall IT Experience.

14+ years of IT Experience in USA.

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

14+ years of strong RDBMS Experience.

PROFESSIONAL SUMMARY

14+ 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, 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.

Creation of backend Stored Procedures, triggers, User defined functions and Views using MS SQL Server/T-SQL.

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

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

Extensively worked on database objects including Stored Procedures, Views, Tables, Functions, DTS packages, SQL Server Integration Services (SSIS); Scheduling SQL Server jobs; Restoring backups.

Experienced in working with multiple projects/assignments, managing them efficiently and working under high pressure to meet deadlines.

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.

Knowledge in Serial (RS232) Communication.

Exposure to Agile/Scrum methodology.

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, 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, Crystal Report (8.5/9/10/13), MS Visual Studio/InterDev 6.0, Windows NT 4.0 Option Pack/IIS, Real Media, MS Office Suite, MS Visio 2003, MS SQL Server DTS

Networking/Protocols

Windows Socket, TCP/IP

EDUCATION

MSc. Software Engineering (Credits) September 2010

Drexel University, Philadelphia, PA

Certificate in Database Administration October 2010

University of Illinois, IL

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 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.

•Wrote a service to automatically generate and email pdf reports to interested parties based on email distribution codes.

•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 MS Access/SQL Server 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 Controls, Telerik Reporting, 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 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 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), 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 needed by the operator

•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, business and database.

•Tied reports to WinForms which are 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 report server 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 as a whole.

•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

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

•Handled production issues involving real-time application problems.

•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 and WPF

•Designed and Developed Web UIs using VB.NET

•Developed Business Logic Components using VB.NET

•Developed 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