Senior Web and Database developer

Manuel Chapa

Bio

As a professional in Computer Science, my goal is to utilize and further develop my knowledge on Internet technologies and information systems in a professional environment.

Over 10 years experience in IT serving as a developer utilizing various programming languages including C#, ASP.Net, ASP.Net MVC, JQuery, Json, html 5, css, VB, VBScript and JavaScript C/C++, web services and classic ASP. I also have experienced as a database administrator of 29 Sql Server databases. Have worked with data warehouses and currently studying all aspects Sql Server BI framework.

Passionate about utilizing and developing further knowledge of internet technologies including ASP.Net and ASP.Net MVC, Sql Server, CSS, HTML, JavaScript, XML, etc.

Expert level in T-SQL Development well versed in SQL Server 2000/2005/2008/2012/2104. Have worked on SSRS and SSIS.

Technologist who has strived to master every type of programming paradigm including structured, object-oriented, prototype-driven, event-driven, AI and record driven

Microsoft Certified Web Applications Developer with Visual C# .NET and Visual Studio .NET Developer

Microsoft Certified SQL Server 2000 Database administrator, designer and developer.

Work Experience

Schlumberger Feb 2011 to Present

Senior Software Engineer

Developed modules for Planning, pricing and proposal oil services application using ASP.Net MVC, C#, Sql Server 2008/2012, JavaScript, JQuery and CSS.

Maintained and created modules for an ASP.Net application with an Oracle database on the backend; responsibilities included creating and modifying oracle packages and procedures. Optimized web application job upload, reducing processing time from over 2 minutes to less than 20 seconds. Modifying, creating and deploying web services. Database changes and web application.

Created modules using java applet technology to display micro-seismic events in 3D and 2D plots in real-time.

Created, designed and architecture of an application to monitor the health of oil field services equipment in real-time using ASP.Net MVC, C# and CSS.

Worked on an a system diagnostic application using .Net Web API, JavaScript, JQuery and JSON.

Deployed, installed and configured application for application in development and production servers.

Maintained image creation of windows embedded systems using ghost technologies.

Extended an real time java application by adding 3D and 2D modules.

BG Oil & Gas Sep 2011 to Jan 2011

Senior Web and Database Developer

Improved module algorithm execution speed from 6 minutes to 14 seconds using different programming and database techniques

Created ASP.NET application using SQL Server, C#, ASP.NET, Telerik and code Smith for the cargo schedule shipping optimization

Deployed, installed and configured application in DEV, UAT and production web servers

AIG Jul 2010 to Sep 2011

Senior Web developer

Responsible for the created back end programs utilizing C# .NET, T-SQL, SQL Server and Oracle to generate reports

Utilized an algorithm to identify the location of servers in the network

Responsible for fixing issues with SSIS and DTS packages

Worked on Network discovery using Service-now system

Troubleshooting Data and performance issues in Oracle and SQL Server 2008 databases

Land Staff LLC Dec 2008 to Mar 2010

Senior Database and Web developer

Optimized and administrated 29 databases in SQL Server 2008 and SQL Server 2005 fixing multiple issues such as locking and performance

Worked on migration of 15 databases to a new server

Served as an ASP.NET application and Database Lead Developer performing management of tasks and developers

Supported and enhanced an ASP.NET application using T-SQL, SQL server 2005, SQL server 2008 and Visual Studio 2008

Created an ORM mapping tool in C# (similar to nHibernate and .NET Entities framework)

Created code generation framework in C# (similar to code smith)

Created CodeSmith templates for class code generation based on SQL server tables

Developed a .NET reporting engine in C# and Visual Studio 2008

Created and implemented database backup plan

Recovered data to a point in time in SQL Server when needed

Fixed several performance issues with ASP.NET application using SQL profiler, T-SQL, database tuning advisor and table indexes

Worked on numerous data conversions from excel format to SQL server 2005 and SQL server 2008 using T-SQL, stored procedures and SSIS

Created several SSIS packages for data migration

Schlumberger Feb 2008 to Dec 2008

Web & Database Developer

Created single Ldap, role enable sign in for internal applications using ASP.NET 3.5, AJAX, T-SQL, LDAP and SQL Server 2005

Designed and developed an email inquiry management system using visual studio 2008, C#, ASP.Net 3.5, Ajax, T-SQL, SQL server 2005 database and .NET security framework

Created numerous reports using reporting services SQL server 2005 component

Created a wrap up ASP.NET application for those SQL server reports

Installed and configured reporting services server

Responsible for SQL Server 2005 database tuning, optimization and administration

Have reduced query execution time from 8 minutes to 10 second using various optimization techniques

Created complex transactional stored procedures, SQL functions and SQL CLR functions (CLR functions written in C#)

Promoted the use of VPC for development

oCreated VPC for development

Created window service that checks database and send email to users

Responsible for some windows 2003 server and Source safe administration tasks

Independent Consultant Feb 2007 to Dec 2007

Have done various contract jobs for Business & Decisions in UK

oWorked on other small business websites using ASP.Net, C# and SQL server 2005

Have been designing, developing an online application system using Visual Studio 2005, T-SQL, SQL Server 2005 and Microsoft recommended enterprise solution patterns (ESP)

Have used nested Master Pages, .NET 2 security framework and themes to develop the online application

Have created a small windows application that uses SMO to connect to a SQL server instance and a database, read SQL scripts and execute the SQL scripts in the database

Have used Reporting services from SQL Server 2005

Have used nested Master Pages, .NET 2 security framework and themes to develop the online application

EPS Software Jul 2006 to Feb 2007

Web Developer

Created an algorithm to determine the possible disease state paths for a patient and the shortest disease state path using a stack of stacks

oUsed builder and strategy design pattern to create algorithm

Primary developing tools were Visual Studio 2005, SQL Server 2005, Nunit, FxCop and Milos

oPrimary developing techniques were TDD (test driven development) and agile development

Created the UI and dll libraries to manage patient state and patient protocol eligibility information in a web system for cancer research

oThe dll libraries were created using TDD (test driven development) approach

Have been designing, developing an online application system using Visual Studio 2005, T-SQL, SQL Server 2005 and Microsoft recommended enterprise solution patterns (ESP)

GTI online solutions Oct 2005 to Jul 2006

Web Developer

Have worked on SQL Server database and ASP maintenance

Redesigned and Optimized T-SQL queries

oHave to use database techniques to make stored procedures faster and more efficient

Have been designing, developing an online application system using Visual Studio 2005, SQL Server 2005 and Microsoft recommended enterprise solution patterns (ESP)

Have used nested Master Pages, .NET 2 security framework and themes to develop the online application

Have created a small windows application that uses SMO to connect to a SQL server and a database, read SQL scripts and execute the SQL scripts in the database

Have used Reporting services from SQL Server 2005

Domino Systems Jul 2004 to Oct 2005

Web Developer

Have worked in the complete development cycle of many web applications, from gathering requirements and designing databases to testing and deployment using ASP.Net, VS .Net, C#, IIS, Source Safe, Html, JavaScript, SQL Server and T-SQL

Have created several complex DTS packages for various projects. Have created numerous stored procedures, triggers, etc

Redesigned and Optimized queries, designed several databases

Have worked on an e-commerce store using JSP, Java, Java Session Beans, Apache, Tomcat and JBuilder

Have worked on SPS and WSS (SharePoint Portal Server and Windows SharePoint Services)

oHave created and deployed a Web part for SPS and WSS

Worked on two Microsoft CMS applications, creating templates and creating dynamic navigation

OPMASP LCC Jan 2004 to Jun 2004

Software Architect and Co-founder

Gathered requirements for a web application for the healthcare industry

oTalked to users and domain expert about needs and improvements. Managed and estimated time of development

Designed and developed all the aspects of a three tier web application

Developed application using ASP.Net and C#

oUsed Design Patterns and Object Oriented principles to develop application. Researched and Evaluated ASP.Net Components to be used in application

Designed tables of the database

Developed numerous stored procedures

oUsed DTS to export/import data from one database to another

Used Excel as a tool to automatically generate stored procedure and C# code to improve productivity

University of Westminster Sep 2002 to Nov 2003

MSC Internet Computing

Designed, documented and implemented an E-bank application in Java

oUsed Rational Rose to create Class Diagram

Designed, documented and implemented an e-voting system using tomcat, apache, JSP, HTML, JavaScript and java beans

Created and implemented an online Jewelry store using Design Patterns, OO design principles, C# and ASP.Net (Working on all the phases of the life cycle of the project; requirements analysis, analysis, design, implementation and testing)

oUsed Rational Rose as a tool for creating Use Case, Component, Class, Activity and Sequence Diagrams

Dynasty Technologies, Inc May 2000 to Aug 2001

Associate Consultant

Developed complex DTS packages that read the information from 12 databases spread out throughout the U.S.; process the information of those databases record by record to finally load the data into a data warehouse

oDeveloped and design a VB class oriented programs that manipulated and configured DTS packages using SQL Server table information to load data from different databases (SQL Server and Oracle) into a data warehouse for a total automated loading. The DTS technology is platform and database independent and works with any database that supports ODBC. Windows 2000 platform used. Worked on windows scripts for process automation

Developed VB application with DLL libraries that communicate to an Oracle database. Task included installing Oracle database creating tables and SQL procedures to communicate to the database

Developed a part of a web application that publishes the news using ASP, VBScript, JavaScript, XML, HTML and DTD. Also, developed a C/C++ program that uses TCP/IP wrapper functions to obtained XML files from another computer using an URL. Used Visual Source and Macromedia

Installed and configured remotely through a firewall a three tier application on a Windows Computer, a Tru64 Unix box and a Tandem using Telnet and Net meeting

oTask included creating a database in the Tandem, configuring the UBB file for the tuxedo client and server, configuring the host and services files for the TCP/IP communication, modifying environmental variables in the three platforms; as well as, writing scripts on UNIX and Windows

LicEnergy Corporation May 1999 to May 2000

Project Engineer

Worked on several real time interfaces to communicate two different proprietary systems under Unix and windows environment using C/C++. Used low level programming such as link lists, double link lists, memory management, interruptions and semaphores. Developed a generic interface on C/C++. Worked on Unix scripts for process automation

Developed OPC client automation interface on VBA with SQL server on the backend

oWrote functional specification documents. Wrote manuals in Spanish. Installed software and dealt with clients on site

Specializations

Languages Expert in C#. Proficient in Java, VB, C++, VBScrip and JavaScript. Have used the following design patterns: Builder, Abstract factory, Observational, state, strategy, Singleton, provider, façade and adapter

Databases Expert in SQL Server 2000, 2005 and 2008 (Proficient in DTS, SSIS, knowledge of query optimization), proficient in SQL server reporting services, familiar with Oracle and Access; familiar with NonStop SQL. Expert in ADO.Net

Web Expert in ASP.Net, ASP.NET 2 and ASP.NET 3.5, proficient in ASP, JSP, Tomcat, JavaScript, Dreamweaver, HTML, XML, DTD, CSS, familiar with java servlets

Web Servers Proficient in IIS, have worked with Apache

OS Proficient in Windows 2000, 2003, 2008 Server, have worked on Unix (Solaris and AIX) and Linux (Red hat and SunSe)

Communication Protocols Have worked on COM, TCP/IP, Tuxedo and DCOM

Frameworks Expert in .NET and have worked with J2EE

Application Servers Have worked with Sun One

Developing Tools Expert in Visual Studio .NET 2005, Visual Studio 2008, 2010, Familiar with Rational Rose and UML. Familiar with MyGeneration, expert in Code Smith and .Nettiers. Familiar with FxCop, NUnit, MBUnit, knowledge in Dreamweaver. Familiar with JBuilder, Visual Source Safe

Methodologies Agile programming, Test driven development (TDD).

Other Knowledge in SPS and WSS (SharePoint Portal Server and Windows SharePoint Services). Familiar in MSCMS

Education

University of Northern Iowa 1994 - 1998

Major: BSc in Computer Science and BA in Mathematics (with side emphasis in Physics)

University of Westminster 2002 - 2003

Master on Internet Computing

Certifications

Microsoft Certified Web Applications Developer with Visual C# .NET and Visual Studio .NET Developer

Microsoft Certified SQL Server 2000 Database Designer and Developer

Awards/Recognitions

Graduated Magna Cum Laude

Finished second place in the 1998 ACM North Central Regional Programming Contest

Valedictorian of my class

First place in Cibolo state academic achievement competition

Contact this candidate