Sql Server Web Developer

Ygor Gonzalez

**** ******* **** **. ******,GA ***18

****.********@*****.*** 678-***-****

Profesional Experience

Objective

To obtain a full time position in a stable and growing organization where my diverse skills as a developer and database administrator can be fully utilized. Where I can continue to learn and excel in mastering my technical skills. To work along side a team of professionals where I can contribute and continue to be challenged.

Oct 2014 Present

IT Specialist at Norsan Group

Current responsibilities includes:

Report and fix any system downtime.

Maintenance of servers, network and workstations of chain of restaurants (15 locations) Install, configure and maintain software and hardware systems Analyze system issues and provide resolutions

Develop new applications to using SQL Server, C#

Maintain current applications and reports using c#, vb.net and SQL Server. Provide technical support to our personnel

Development Projects:

I design and develop a Web interface with SAP, using ASP MVC, C# and SQL server to manage the products inventory, reducing the inventory process from 4 days to 8 hours. I design and develop a web application to control the production process, The application manage the work schedules, shifts, operators, tasks and products to be precessed by the butchers and packers. Also the application with connect with SAP to register the products going out of our inventory (Goods Issue) and those new products created by processing others ( Goods Receipts). Technical Skills Used:

SQL Server 2008, SAP, Web Services, C#, ASP.net MVC, HTML 5, Bootstrap, jQuery

June 2012 September 2014

Web Developer at Kleo Inc

Contributed software engineering expertise in the development of products through the software lifecycle, from requirements definition through successful deployment. Create, maintain and modify data structures for the company product in SQL Server. Provide data management, scheduled jobs, database processes, write and maintain stored procedures.

Recognize and identify areas where there may be potential policies or procedures requiring changes or new needs to be developed.

Create interface with Authorize.net (AIM Method) and SecureNet API to process credit card payments.

Create interface with InfusionSoft API using Soap and c# to update and create the user contacts every time a user update their profile or register into the site Create interface with 3dcarts to receive and process remote shopping carts submitted via XML, allowing vendor using 3dCarts platform to submit orders electronically to our system. Generate and design procedures to transfer EDI Purchase Orders to 3dCarts via FTP. Program and design multi tenant Application allowing multiple customers get their own website in one sharing the same application and database.

Create an interface to allow the users through cXML PunchOut access to a catalog maintained on the supplier's Website.

Create web services allow the system to receive remote XML shopping carts (cXML) through http post allowing suppliers using cXML to sell their products. Create and Design custom interface to post Purchase Order to remote suppliers in three different ways, cXML via http post, email and EDI Files via FTP. Create web service to receive and process cXML Invoices, automatizing all the billing process and speed up about 80% all the payments to suppliers.

Designed and developed Web Services, Windows Services and Utilities in C#, C++, Windows Forms for administrative operations.

Technical Skills Used:

SQL Server 2008, ASP.NET, VB.NET, XML, Web Services, C#, ASP.net MVC, jQuery

July 2006 June 2012

Web Developer at Adopt A Classroom.org

Modification of existing application Programming of both VB.NET and ASP.NET modules in support of client side and portal based applications. Use of Web services to provide real time user updates from client trusted database to a public web portal.

Technical Skills Used:

SQL Server 2000, ASP.NET, VB.NET, XML, Web Services

December 2005 June 2006

Web Developer/DBA at Affinity Consulting Group, Inc Responsible for providing DBA and Programming support to Affinity Clients as assigned. DBA responsibilities include:

Execute backup and restore of internal client databases Detach and Attaching of databases for testing and deployment Ensuring normalization of client databases

Performed performance tuning of several client databases Responsible for writing Stored Procedures and Triggers Programming responsibilities include:

Develop specifications for new system modules

Modification of existing application

Programming of both VB.NET and ASP.NET modules in support of client side and portal based applications.

Use of Web services to provide real time user updates from client trusted database to a public web portal.

Technical Skills Used:

SQL Server 2000, ASP.NET, VB.NET, XML, Web Services

June 2003 November 2005

Developer/DBA at Premier Telecom Inc

Responsible for database administration and programming of the company web site. DBA responsibilities included:

Management of 3 SQL Server database instances on two separate servers All Backup and Restore needs

Setting up DTS packages for data imports

Programming of all Stored Procedures, Triggers and Rules Performance Monitoring and Tuning of all databases re indexing and rebuilding of indexes, clearing of logs

Setup and maintenance of database security and users Programming and running of special jobs to migrate and synchronize each database Developer / Analyst responsibilities included:

Responsible for designing, programming and implementing a web site which allows customers to check their call record, bill review, online payments and subscribe to a new service. Defined the company needs and users, expectations by applying formative research methodologies such as participatory design and analysis. Create design alternatives through evaluation of prototypes. Initiated design reviews, surveys and visits to identify the company needs and users expectations. Worked together with the marketing Department to create strategies that successfully promote the use and sales of the company products through the web increasing sales by 30%. Utilized SQL server, Active Reports and ASP.NET to develop the web and Internet Programs. Write interfaces (XML Web Services, Web Programs) within billing system, allowing all customers make payments and unblock theirs account online increasing collection rate by 50%. Provide support as needed to all company software products as well as operational aspects of the customer service department.

August 1999 June 2001

Web Developer at Net People (venezuela)

Responsible of creation of Classes and components on VB6 (business rules) to Access the database and stored procedures through ASP.

Responsible of Write stored procedures and triggers Create some Web interfaces in asp

Create a Shopping cart for Online Store using Intershop 3.0 and html. Supply assistance with all hardware and software installations. Technical Skills Used:

SQL Server 2000, ASP, VB6, SQL, Intershop, HTML

March 1999 August 1999

Consultant at INFOGESA (venezuela)

Assigned to PDVSA (oil Company of Venezuela).

Responsible for the development of systems for the financial department requirements with VB6 and oracle 8.

Develop programs in VB6 and Oracle for the generation of financial reports to the general manager of finances.

Develop programs using VB6 and Oracle to control the Risk of investment on Oil explorations. Assigned to INTESA

Write programs in asp and oracle to create the company site. Write ASP Pages that allow buy of some products online (shopping cart), send invoices to the client via email and send a purchase order to the business (B2B). Technical Skills Used:

: Oracle, ASP, VB6, SQL Server

July 1998 March 1999

VB Programmer at Compuconsult (venezuela)

Assigned to PDVSA (Oil Company of Venezuela)

Test, fix, and to adapt to year 2000 financial applications created with clipper, fox pro and VB 3.0. Write, test and modify programs in VB 3.0 to control an employees dinning to be year 2000 compliant.

Write programs in VB6 and Sql server, which load and display telephone billing information. Technical Skills Used:

: SQL Server, Visual Basic

November 1995 July 1998

Education

SEMINAR & COURSES

Programmer I Easy Survey Corporation (venezuela)

Write programs and applications based on internal requirements. Write SQL Server Scripts to create Statistical Reports to the advisers. Write data extraction programs to user specifications using BCP and SQL. Write and modify programs in VB 3.0 to create and maintain a Salary survey System. Create programs to read Security Keys to be assign to our customers. Create and maintain Setup and installation kits to be used by our advisers. Supply assistance with all hardware and software installations for personal computers and servers. Technical Skills Used:

: SQL Server, Visual Basic

January 1991 October 1995

Programmer at Meganetwork (Sybase of Venezuela)

Write programs and applications based on internal requirements. Write SQL Server Scripts to create Statistical reports Write data extraction programs to user specifications using BCP and SQL. Developed programs in VB and stored procedures on Sybase to create an electronic file system which store images by specifics keys and descriptions and be able to retrieve them through of queries.

Developed programs in VB and Sybase to create a system to control of magazine deliveries. Developed programs in VB and Sybase to manage a Retirement funds. Technical Skills Used:

: SQL Server, Sybase, Visual Basic 1.0, Crystal reports

1995 Associate Degree on Computer Science

Caracas Venezuela

MCP Designing and implementing Desktop Applications with Visual Basic 6.0 (70 176) Introduction to SQL

Fast Track to Sybase

Fundamentals of Systems and database Administration Sybase performance and tuning

Programmer for Windows (Visual Basic, Fox pro, Access) HTML

Visual Basic 6.0 Advanced

Contact this candidate