Alfonso C.

Project: Trade & Tax Solutions  Develop an interface between Trade & Tax Solutions application (2TS) and Audit application of Tributary Administration Secretary (SAT). The interface is a web service developed on C# with .NET Framework 2.0, this interface sends an audit result that was taken from SQL Server.  Modify modules of 2TS application which is developed on C#. Project: Sinorh project for Delphi Automotive Systems  Support users of Sinorh application, this is a Human Resources application for 50 Delphi Mexico plants and with 200 users approximately.  Maintenance of Sinorh application modules, Pensions Plan, IMSS, Vacations, Saving Found, among others.  Creation of new utilities for the existing modules in Sinorh application which it developed in COBOL and the information was stored on DB2 db with 25’000,000 registers approximately.  Implement Sinorh application in new plants of Delphi (Hermosillo, Silao, Ramos and Chihuahua).  Migrate from other Human Resources application that was developed on VB .NET and Borland Delphi 6 to Sinorh application.  Migrate Sinorh application to a new human resources application, developed with C# and SQL.  Planning Sinorh implementation altogether with the client.  Maintenance to interface between Sinorh application and Meta4 payroll application.  Document changes of Sinorh. Project: Payroll Receipts project for Lear Corporation  Develop changes to Payroll Receipts web application which is developed with C# using the .NET Framework 2.0.  Implement Payroll Receipts application in 42 Lear Corporation plants with 168 users.  Support Payroll Receipts application users with password reset and update employees’ information, the data base are stored in SQL Server 2008.  Develop a module to send a reminder email to users through SMTP.  Develop reports in Crystal Reports XI which are exported to Excel or Adobe Acrobat.  Develop an interface between Payroll Receipts application and LMS application to transfer employees’ information to the database and load it with a bulk insert function stored on a SP and it was invoked from a windows service that I developed on C#. Project: Labor Time Tracking System (LTTS) project for Lear Corporation  Develop modules and new reports for LTTS application which is developed in Borland Delphi 6 and the reports with the ReportBuilder control.  Develop new stored procedures and tables in SQL Server 2008 to generate reports and to send data to the application.  Implement LTTS application in Furukawa Lear Corporation plant for 50 users.  Monitoring the interface of labor time of the employees.