Sign in

Developer Sql Server

United States
November 20, 2018

Contact this candidate


Collins Frimpong.

E–mail :

Phone Number: 347-***-****


Over a total of 6 years of experience in .NET application development, software development and project management; including application design, requirements gathering, documentation, maintenance, testing, implementation, and agile project management.

Expertise in developing applications using Java, J2EE, JDBC, JSP, Servlet, LDAP, Hibernate, AJAX, HTML, XML, XSL, Java Script, Java, C++,PHP,CSS, Visual Studio 2014,2012

Expertise in T-SQL,MYSQL,PLSQL,Microsoft, SharePoint, Microsoft SQL SERVER 2008,2008R2,2012,2014,2016,SSIS,SSAS,SSRS,Windows PowerShell, Computer Networking, using Toad for Oracle, SSMS, Windows Server 2008,2012 and 2016.

Technical Skills Set

Programming and Scripting Languages Known:

-Visual C#.NET, Java, C++, Visual Basic.NET, Python, HTML, CSS

Relational Database Platforms Known

-Microsoft SQL Server (2008/2008R2, 2012/2014, 2016), Microsoft Access, MySQL, Oracle

Operating System Platforms

-Windows 7, 8, 8.1 and 10, Linux (Ubuntu) Operating System environments; Windows Server 2008, 2012 and 2016;

Technical Certifications and Education

Bachelor’s in Computer Science and Engineering from University of Mines and Technolog

Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics

Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014

Microsoft Certified Professional

Professional and Project Experience

C# Developer, Rhema Systems, Accra (Ghana) March, 2015 – 2018

-Designed and developed Web Forms using ASP.NET Controls, CSS and HTML to facilitate the registered users

-Developed classes in Business Layer and in Data Access Layer in C#

-Used Custom Validations and User Validation to give access to registered users

-Developed Business Logic classes for Transaction Module using Business Services

-Used Win Forms controls and Custom User Controls to provide standard interactive User Interface

-Created database objects using SQL Server including complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications

-Used LINQ for webpage development.

-UI Designing, Development and Testing of Web Forms using ASP.NET, C#, XML ADO.NET and .NET Framework

-Implemented Exception Handling, Logging and Validation of incoming requests

-Documented the modules developed front-end screens

-Developed T-SQL Stored Procedures for Generating Reports

-Used JavaScript validations with ASP.NET controls.

-Used Unit testing to test the applications.

SQL DEVELOPER, Ghana Grid Company, February, 2014 – February, 2015

- Analyzing different user requirements and coming up with specifications for the various database applications

-Developed and Optimized Stored Procedures and Functions using T-SQL

- Monitored the performance of the database and checked on the execution time

- Installing and configuring the necessary components so as to ensure that the database is accessible

-Monitored and tuned database resources and activities for SQL Server databases

-Performed and automated SQL Server version upgrades and patch installs.

- Responsible for performing SQL development and SSIS /SSAS/SSRS development

-Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse

- Work with other developers to facilitate creation of high performing data centric components and applications

- Review the designs, code, and test plans of other developers and provide recommendations for improvement or optimizations

-Performing environment/application upgrade

-Database administration including performance monitoring, access management and storage management

-Transformed data from different sources such as Flat files, Excel, XML, oracle, SQL using ETL tool SSIS

C# Developer Websoft Solutions Ltd. Ghana, January, 2013 – January, 2014

-Worked with Oracle and SQL Server databases and Stored Procedures.

-Used XML to create Web-based tools for transactions on SQL databases.

-Troubleshoot and resolved bugs in .NET applications to ensure optimal development environment.

-Applied Entity Framework model to interact database objects with objects in C#.

-Implemented Interfaces and Inheritance in .NET applications where necessary to enhance extensibility of our applications and also to help in more loosely couple applications

-Designed web-based ASP.NET and MVC applications linked to firm-wide SQL.

C#/.NET Developer (Team Lead) CodeWeb Company Ltd, January, 2012 –, December, 2012

-Troubleshoot and resolved bugs in .NET Applications

-Extensively worked with MVC design patterns.

-Implemented the design of functionality through use cases, business process flows, UI designs and UML modelling

-Designed Database tables, schemas, Triggers and Stored Procedures.

-Implemented unit testing, integration testing and system testing.

-Implemented ADO .NET classes and namespaces to create data access components and utilized reference objects.

BSc in Computer science & Eng.

Contact this candidate