Sql Server Engineer
Resume:
Khristian Espinoza
**** * ***** ****** **** Apt *724 Henderson, NV 89074
Phone: (415) 316 8258Error! Bookmark not defined.[Your Fax] E Mail: **********@*****.***
Detail oriented IT professional with years of experience as a custom solutions software engineer and systems technician.
Skilled at operating in a wide range of platforms. Excellent written and oral communication skills; capable of explaining
complex software issues in easy to understand terms.
Technical Summary
3 years of Microsoft .NET experience using C#, ASP.NET including Windows and Web development.
n
3 years of PHP, MySQL, HTML, and CSS Web development on a Linux server.
n
5 years of relational database development including MS SQL Server, Oracle, MySQL, MS Access.
n
1 year of Microsoft Azure Cloud platform programming – SQL, BLOBs, Websites, Cloud Apps.
n
2 years of ZyTax (Excise Tax Reporting Software – recently acquired by Avalara) implementation on client
n
environments.
Experienced implementing IIS/Apache testing servers.
n
Have experience in Windows Active Directory, DNS, DHCP, File and Print Sharing Services.
n
Technical Overview
Programming Language Database Software Tools
C, C++, C# MS SQL 2000, 2008, 2012 Visual Studio .NET 2000, 2008, 2013
ASP.NET MS Access 2000, 2003 Visual SVN
HTML, CSS, Twitter Bootstrap MySQL SQL Server Management
XML Oracle SQL Server Integration Services
PHP JIRA
SQL Server TSQL VISIO
Education
University of Houston – Houston, TX May 2005
Bachelor of Science – Major in Computer Science, Major in Math – Graduated Magna Cum Laude
Professional Experience
Tax Advisory Services Group, LLC – Manila Philippines, Houston TX May 2012 – July 2013
Senior Consultant – Excise Tax (Indirect Tax) on Motor Fuels
n
Conducted meetings with the client to gather information and requirements on their business model and transactions.
n
Data analysis of client transactional and master data, and reconcile the transactions to the filed tax return.
n
Perform side by side testing using client’s current transactional monthly data.
n
Provide client support and training.
n
Implemented custom solutions (Microsoft based technologies) on client’s platform.
n
Knowledgeable with government regulatory and reportorial requirements.
n
Systems Engineer
C# .NET Developer for large scale engineering application modernization project.
n
Page 4
Responsible for business requirement decomposition, application development, and evaluation and technical peer review
n
of developed code as needed.
Responsible for the initial role of completing project development activities to the support role for the completed
n
application.
Team leader for Systems Development.
n
Responsible for training new developers on operations and implementation procedures.
n
Developed best practices software programming guide.
n
Conducted interviews for IT personnel positions.
n
Achievements
n
Manager responsible for initial startup of business process outsourcing between Houston and Manila.
n
Manager oversight for office administration including: payroll, vendors, bank transactions, human resources, and
n
interaction with government agencies.
Projects
n
Created a company specific EDI returns using TSQL and exporting the file through a SSIS package for:
n
Illinois
o
Ohio
o
Pennsylvania
o
West Virginia
o
Created a company specific tax reconciliation tool to compare tax paid on reported transactions and tax recorded on the
n
source system (sales or general ledger). It included matched transactions, matched but different gallon amounts,
transactions not matched in either sources. The solution used TSQL and exported the file through a SSIS package for:
Illinois
o
Indiana
o
Michigan
o
Ohio
o
Pennsylvania
o
West Virginia
o
Build and configure Windows 2008R2 server in Manila for file and print services, web and database development.
n
Wire Cat 5e network cables across the Manila office.
n
Setup software and other tools in the laptop for both tax and IT personnel.
n
Data transfer and VPN testing between Manila and Houston offices.
n
Developed a state certified ASP.NET web service where clients (Suppliers, Exporters, Importers, Transporters, Terminal
n
Operators) can upload a formatted CSV file, generate an Alabama XML EDI return, and submit the motor fuel return to
the Alabama web server. 3 tiered application with business logic separated from the GUI.
Developed an alternative ASP.NET Cloud Application running on Microsoft Azure where clients can upload a formatted
n
CSV file or input their monthly transactions, generate an Alabama XML EDI return, and submit the motor fuel return to
the Alabama web server. This project was used to test the feasibility, scalability, and flexibility of outsourcing
infrastructure to Azure.
Project leader and developer for ETL (Extract Transform Load) Windows application tool. This allows users the ability
n
to perform data transformations on source data and output the data to their designated output format.
Source and output data includes: CSV, Excel, SQL Database Tables, Access Tables (input only)
o
The users can create transformations using a GUI wizard or screens and have little or no SQL background.
o
WIX for Visual Studio was used to create the installer package.
o
Page 4
The database backend of the application worked with either SQL Server or SQL Server Azure and can be
o
configured though a XML file.
Project leader and developer for Access application conversion to ASP.NET web site. This application is a knowledge
n
warehouse with forms converted to web pages with Twitter Bootstrap and AJAX toolkit. 3 tiered application with
business logic separated from the GUI.
Technologies used: ASP.NET C#, SQL Server, Azure, WIX toolset, JIRA, SSIS, XML, Access, Excel, EDI, AJAX
n
toolkit, Twitter Bootstrap, Visual SVN, Visual Studio 2012, MS Enterprise Library
Clear Solution Rehab Services, INC Houston TX December 2006 – May 2011
Administrator
Managed day to day operations including: handling new and existing customer concerns; updating receivables on
n
customers; training new employees on daily business operations and computer systems.
Managed payroll for contractors and employees.
n
Maintained and secured computer systems.
n
Developed new applications to solve specific operations challenges and enhance productivity.
n
Projects
n
Configured a Windows Small Business Server for office use with the following services:
n
DNS service
o
DHCP
o
Active Directory
o
File and Print Sharing
o
Configured a (WAMP – Windows, Apache, MySQL, PHP) web server.
n
Created a resource planning system for:
n
Home health agencies and a list of their patients and information.
o
The company’s employees and contracted physical therapists.
o
Scheduling a patient and a therapist(s) for visits on a 90 day calendar period.
o
Uploading documents, referral sheets, notes on a patient’s chart.
o
Invoicing agencies on a weekly basis based on completed visits and exporting the report to Excel.
o
Calculating a contractor’s bill based on their completed visits every two weeks and exporting the report to
o
Excel.
Exporting various reports to Excel: to help track patient progress; monitor business activity; monitor
o
therapist’s timely submission of notes;
Technologies used: PHP, MySQL, HTML, CSS, Adobe Dream Weaver (Initial Layout), Excel, Apache Server,
n
PHPMyAdmin
Fuel Quest Houston TX December 2006 – May 2011
ZyTax Consultant
Conducted research and analysis on state excise tax on oil and gas.
n
Data analysis of client transactional and master data using Excel, Access, or SQL Server.
n
Implemented a custom ZyTax Tax solution software on client’s platform on site.
n
Conducted meetings with clients to ensure satisfaction and project milestones are met.
n
Trained new consultants on basic operations, and implementation procedures of ZyTax Software.
n
Conducted new product testing and debugging.
n
Page 4
Projects
n
Implemented ZyTax 4.xx on several client environments with a SQL Server or Oracle database backend.
n
Added enhancements in BOZ (Back Office ZyTax) Access database to extract and flag fuel bio diesel blending
n
transactions.
Software user testing and debugging on ZyTax Archiving Software, and General Ledger Reconciliation.
n
Implementation of archiving solution on client environment.
n
Technologies used: SQL Server, ZyTax 4.xx, Toad, Access (VB Macro), Excel
n
Other Skills
Innovative, flexible and is a high energy individual. Has great problem solving skills, is a fast learner, and is multitask
oriented. Keen to details, highly enthusiastic, has leadership potential, and can work with minimum supervision.
Contact this candidate