Projects

EDCON Store

• Developed modules or program based on the client request using SQL Stored Procedure and SSIS 2008.

• Used Data Manipulation Language (DML) like Select, Insert, and Update Statement in generating report in SSRS.

• Tested the modules using Unit Test Plan.

• Run Merge Replication Daily

COACH

• Developed the technical specification using C#.NET and SQL Stored Procedure

• Tested the modules using Unit Test Plan.

• Used Data Manipulation Language (DML) in generating data to be used in another server or environment like Oracle RPAS.

• Supported client for any issues or new requirement should be added to the system

• Created functional specification of the requirements coming from the client through requirements traceability matrix.

Projects

COSTPLUS (Expense revenue allocation for quickbooks).

• Work with a team to develop Accounting System, a web-based application tool that will be marketed to financial professionals to help them easily bill associates to their respective clients.

• Developed and implemented new feedback system for user concerns, bugs and defect tracking regarding the use and functionality of new interfaces.

• Coded web designed interface using Microsoft C#/Asp.net, JavaScript, and HTML.

• Analyzed business requirement and converted it to a technical requirement that can be understand by Software Developer.

• Used Data Definition Language (DDL) in creating table structures in the system when the requirements are new to be used in storing data.

• Used Data Manipulation Language (DML) in selecting, inserting, updating, and deleting data in the database.

• Created, modified, maintained and optimized SQL stored procedure.

PAYREV (Payroll, expense and Revenue allocation)

• Primary task was to maintain the system and develop an extraction program that will get data from CostPlus, Quickbooks, and from table and save it to an excel file for reporting purposes.

• Developed and web-based application using Microsoft C#/Asp.net, JavaScript, and HTML that runs on intranet technology.

• Designed database table to maintain the integrity of the data.

• Created various interactive web pages using HTML and JavaScript and integrated those web pages to the system.

• Created, modified, maintained and optimized SQL stored procedure.

AMS (Attendance Monitoring System)

• Developed and designed reports to monitor the attendance of associates.

• Maintained and updated the report programs using Crystal report.

• Created, modified, maintained and optimized SQL stored procedure.