Sql Server Data Entry

Ruel B. Sucgang

B*, L** Christianville Subdivision, Christianville Executive

Talon 5, Las Piñas City 1740, Philippines

Mobile No.: +639**-***-**** (Globe) /Email Address: ****.*******@*****.***

PROFESSIONAL SUMMARY

More than 10 years developing desktops and web software applications.

Strong background in systems development life-cycle (SDLC)

Object oriented programming (OOP)

Correction of software defects and updating it with new features.

Enhancements and maintenance of software applications.

Translation of business manual operation into technical specifications.

Ability to handle multiple projects simultaneously in a team environment.

Ability to prioritize and execute tasks in a high-pressure environment

High-level performer who is willing to deliver more than what is expected.

TECHNICAL SKILLS

.Net Web and Windows Applications

oMicrosoft C#.Net / VB.Net /ASP.Net (ASPX) / ASP.Net MVC

Web API

WCF

Web Service (SOAP)

Entity Framework (Database First)

ADO.Net

Dapper version 1.50.2

Ajax / JQuery / Javascript

Lambda

LINQ

CSS / Html / Bootstrap

Xml / JSON

Angular JS 1.x

Microsoft Visual Studio 2005, 2010, 2012, 2015

Microsoft SQL Server 2005/2008/2008 R2 Advance, 2012

Microsoft Azure

Crystal Report

Microsoft Visual Basic 6.0

Microsoft Visual FoxPro

Fox Pro DOS

Infragistics components

OutSystems Platform version 10

Source control

oMicrosoft Visual Source Safe version 6.0

oMicrosoft Visual Studio Team Foundation Services

oTortoise SVN

PROFESSIONAL EXPERIENCE

Banco De Oro

BDO Corporate Center, 7899 Makati Avenue, Makati City

C#.Net Developer Consultant, July 19, 2017 – Present

Executive Payroll System Migration Project:

Migration from win app to ASP.NET-MVC

Responsible for the front-end/back-end programming based on the functional specifications

oBug fixing

oStored procedure creation/adjustments

oGUI enhancements

Technology used: Visual Studio 2015 / ASP.Net-MVC / C#.Net / VB.Net / AngularJS 1x / JQUERY / MySQL / Microsoft SQL Server 2012

Seven Seven Global Services, Inc.

2701 27th Floor The Orient Square Building F. Ortigas Jr. Avenue, Ortigas Center, Pasig City

RAD Level-3 Software Developer, December 27, 2015 – May 27, 2016

Assigned to:

Deutsche Bank

Net Quad Center Bldg., Bonifacio Global City, Taguig City

Electronic Transportation Order Application Project:

Responsible for the front-end/back-end programming based on the functional specifications

oBug fixing

oStored procedure creation/adjustments

oGUI enhancements

Provides the stakeholders with the Software Design Document (SDD)

Provides the business analyst with the System Integration Testing (SIT) to evaluate the system’s compliance against specified requirements (unit and regression testing).

Preparation of test scripts and performs the UAT with the end users.

Provides assistance deploying the application in the production.

Technology used: Visual Studio 2013 / ASP.Net / C# / Javascript / Microsoft SQL Server 2012

LDAP Service Component Project:

Provides the stakeholders with the SDD and SIT.

Provides the application with the Extension Method to search for the employee details in the Global Directory (real time).

Integrate this component in the client’s existing web and desktop applications.

Provides test scripts to perform the UAT.

Provides assistance deploying the application in the production.

Technology used: Visual Studio 2013 / Visual Basic .Net

Employee Cost Center Batch Update Project:

Provides the stakeholders with the SDD and SIT.

Creates new application to handle the following requirements:

oStored procedure to handle the cost center batch update

oGUI to handle the default settings

oTransaction logs

oIntegrate required components

Provides test scripts to perform the UAT.

Provides assistance deploying the application in the production.

Technology used: Visual Studio 2013 / C# .Net / Microsoft SQL Server 2012

OK2Accrue Database Cleanup Management Back-End Project:

Provides the stakeholders with the SDD and SIT

To provide a stored procedure to handle the deletion old transactions from the database based on the specified retention period. Its main function is to free up disk space on the database server.

Provides the database administrator a simple application to configure the settings of the DB cleanup process.

Creation of stored procedure that automatically creates the SQL Job for the processing of the weekly task.

Provides test scripts to perform the UAT.

Provides assistance deploying the application in the production.

Technology used: Stored Procedure/Microsoft SQL Server 2012

Archon Consulting & Systems Services, Inc.

Ayala Avenue, Makati City

C# Programmer, May 27, 2015 – September 4, 2015

Assigned to:

Fresh Remix

Ayala, Makati City

Fresh Exchange Windows Application 3-Month Project:

Provides the stakeholders with the SDD and SIT.

Responsible for the front-end programming based on the functional specifications

oEnhancement of the GUI based on the end-users request/requirements.

oProvides program functionalities similar to Microsoft Excel.

Provides test scripts to perform the UAT.

Provides assistance deploying the application in the production.

Technology used: Visual Studio 2012 / C# / Microsoft SQL Server 2008 R2

Radix Systems Services Corporation

601 Globe Telecom Plaza II, Pioneer Street, Mandaluyong City

C# /VB.Net Programmer, November 12, 2007 – April 27, 2015

Assigned to:

Citra Metro Manila Tollways Corporation (CMMTC) – Skyway

3rd Floor Toll Operation Bldg., Doña Soledad, Bicutan Parañaque City

Account Management System Application Project:

Responsible for the front-end/back-end programming based on the functional specifications

oThis is a team project and I am assigned to develop new functionalities in the application:

User access rights management

Patron information management

Payment data entry transaction

Generation of official receipts

Audit trail

Revision of other data entries in the application

oBug fixing

oStored procedure creation/adjustments

oCreation of financial reports

oGUI enhancements

oAudit trail

Provides the stakeholders with the Software Design Document (SDD)

Provides the business analyst with the System Integration Testing (SIT) to evaluate the system’s compliance against specified requirements (unit and regression testing).

Preparation of test scripts and performs the UAT with the end users.

Provides assistance deploying the application in the production.

Provides assistance to the end users after a successful deployment in the production server.

Technology used: Visual Studio 2010 / C#.Net / ASP.Net MVC 4 / Web API / Microsoft SQL Server 2008 R2

Lane Computer Software Application Project:

Provides the stakeholders with the SDD and SIT.

Assigned to develop the following functionalities:

oPayment transaction by means of cash and E-Pass tags.

oMaintenance for all equipments and devices in the toll gates.

oExtension methods to ensure synchronization execution of the lane equipments and devices.

oDynamic creation of database structure (tables, stored procedures and functions) at runtime to ease the deployment process.

Provides test scripts to perform the UAT.

Provides assistance deploying the application in the production.

Technology used: Visual Studio 2010 / Visual Basic .Net / Crystal Report / Microsoft SQL Server 2008 R2

Security Bank Auto-Replenishment Intranet Application Project:

Provides the stakeholders with the SDD and SIT.

Assigned to develop a stand-alone application with the following functionalities:

oReal time replenishment request from SB card via web service (SOAP)

oCredit card auto replenishment for walk in and batch transaction

oReversal transaction once the system failed to receive the bank response.

oPosting of transactions in the AMS database.

oParsing of XML response

oAudit trail

Provides test scripts to perform the UAT.

Provides assistance deploying the application in the production.

Technology used: Visual Studio 2010 / ASP.Net-MVC / LINQ / Lambda Expression / C# .Net / Web Service (SOAP)

Image Scanning Component Project:

Provides the stakeholders with the SDD and SIT.

Assigned to develop the following functionalities:

oAn interface for the scanning of patron’s printed documents

oNew interface in the AMS application to handle the configuration settings of the scanned images.

oStored procedures to save all images into a database

oRetrieve images from database and display it in the patron profile information.

Provides test scripts to perform the UAT.

Provides assistance deploying the application in the production.

Technology used: Visual Studio 2010 R2 / C# .Net

Auto Replenishment Stand-Alone Application Project:

Provides the stakeholders with the SDD and SIT.

Assigned to develop the following functionalities:

oCredit card auto-replenishment

oGeneration of text files containing the requests, send to different banks for approval

oProcessing of text files containing the response of bank’s response.

oRequest activity logs

oBatch posting of bank response

Provides test scripts to perform the UAT.

Provides assistance deploying the application in the production.

Technology used: Visual Studio 2010 / Visual Basic .Net / Microsoft SQL Server

Service Request Web Application Project:

Provides the stakeholders with the SDD and SIT.

Assigned to develop the following functionalities:

oData entry to handle the multiple user requests

oAdjustments in the requests

oCreation of tickets

oMonitoring ticket status

oEnrollment of employee details to allow the service request

oSystem Maintenance

oUser access rights

oOutput generated report to Microsoft Excel

oAudit trail

Provides test scripts to perform the UAT.

Provides assistance deploying the application in the production.

Technology used: Visual Studio 2010 / ASP.Net-MVC / AJAX / C# .Net / Entity Framework / CSS / JQuery / LINQ / Lambda Expression / Microsoft SQL Server 2008 R2 / Web Service (SOAP)

POS Intranet Web Application Project:

Provides the stakeholders with the SDD and SIT.

Assigned to develop the following functionalities:

oData entry to handle the multiple payment transactions.

oGeneration of printed official receipts

oSystem Maintenance

oEnrollment of users to access the application

oUser access rights

oGeneration summary/daily journal reports

oAudit trail

Provides test scripts to perform the UAT.

Provides assistance deploying the application in the production.

Technology used: Visual Studio 2008 / ASP.Net (ASPX) / C# .Net / CSS / Microsoft SQL Server 2008 R2

Pre-Encoded Transit Cards Stand-Alone Windows Application Project:

Assigned to develop the following functionalities:

oRead/write of toll cards using the MT-85 device.

Technology used: Visual Studio 2005 / Visual Basic .Net

Amkor Technology Philippines

KM 22, East Service Road, South Super Highway, Muntinlupa City

C#.Net Programmer, March 22, 2007 – November 09, 2007

INSITE Web Service Project:

Assigned to create new web services for the existing application

Web application adjustments in the inline and code behind

Technology used: Visual Studio 2005 / ASP.Net / C# .Net / Infragistics components

General Electric Philippines

Pasong Tamo Extension, Makati City

C#.Net Programmer, April 11, 2006 – November 24, 2006

Global Business Solution Web Application Project:

A solo project, assigned to develop the creation of service requests and the monitoring of approvals.

Program adjustments based on additional requests

Bug fixing

UAT and production deployment

Technology used: Visual Studio 2005 / ASP.Net / C# .Net / SQL Server 2005 / CSS

Philippine National Bank

2nd Floor PNB Financial Building, Diosdado Macapagal, Roxas Boulevard

.Net Programmer, August 22, 2005 – March 31, 2006

Global Remittance Solution Web Application Project:

A team project, I was assigned to develop a bank remittance transaction.

Parsing of text files

Creation of listener checking the text file if already existing

Bug fixing

Program conversion created from Visual Basic 5.0

UAT and production deployment

Technology used: Visual Studio 2005 / ASP.Net / C# .Net/ Visual Basic.Net / SQL Server 2005 / CSS

Philippine Bank of Communication

PBCom Tower, 6795 Ayala Avenue Corner Rufino Street, Mkti. City

Visual Basic.Net Programmer, August 09, 2004 – August 15, 2005

Financial Management System Windows Application Project:

Provides the data entry for bank’s financial transactions

Parsing of text files

Stored procedure adjustments

Bug fixing

UAT

Technical documentation

Technology used: Visual Studio 2005 / Visual Basic .Net / SQL Server 2005 / Infragistics components

Fixtures, Furniture and Equipments Inventory Windows Application Project:

Bug fixing

Provides additional functionalities in the inventory and billing system

GUI enhancements

Technical documentation

Technology used: Visual Studio 2005 / Visual Basic .Net

Macondray & Co., Inc

2263 Pasong Tamo Extension, Makati City

MIS Supervisor/Software Engineer, February 01, 1995 – March 2004

Accounting System Windows Application version 1.0 Project:

System maintenance

Troubleshoots errors during the generation of financial report

Technical documentation

Technology used: Fox Pro 2.0

Accounting System (enhanced version) Windows Application version 2.0 Project:

Provides the stakeholders with the functional requests

Assigned to develop the following functionalities:

oProvides improvements in the financial data entry transaction

oBug fixing

oRevision in the master file data entry and financial reports

UAT

Production deployment

User manual / technical documentation

Technology used: Visual Basic.Net / Crystal Report / Web Service / SQL Server 2005 / Crystal Report

Human Resources Web Application Project:

Assigned to create the employee information / pooling (resource management)

Inquiry of employee leave balances

Employee leave request

HR monitoring of leave requests and approval

Time keeping

User Manual / Technical documentation

Technology used: Asp.Net 2005 / Visual Basic.Net / SQL Server2005 / CSS / HTML

Inventory Management System Windows Application Project:

Assigned to create data entry of incoming and outgoing materials

Transfer to bodega

Materials maintenance

User Manual / Technical documentation

Technology used: Asp.Net 2005 / Visual Basic.Net / Crystal Report / SQL Server 2005

EDUCATION

Computer Programming

1988-1989

Datamex Computer School

Buendia Makati

TRAININGS AND CERTIFICATIONS

M.I.S. Net

Mastering Visual Basic 6 [ Serial No.: 1013AC ]

Programming with MS Visual Basic.Net [ Serial No.: 2373 ]

Informatics:

Macromedia Flash [Serial No.: 172052]

Adobe Photoshop [Serial No.: 174929]

Dynamic Web Pages Development [Serial No.: 176651]

I-Net+ [Serial No.: 172071]

New Horizons:

Active Server Pages 2.0 Levels 1 and 2

Manasoft Technology Corporation

Microsoft Visual FoxPro

Contact this candidate