Engineer Sql Server
Resume:
Troy Sosamon
Centennial, Co **015
Cell 303-***-****
****@*******.***
Objective: To find a challenging position using my 25 years of Full stack and SQL experience as a senior developer. I can determine project needs and see them through to completion.
Education: University of Colorado – Boulder; B.A. – Computer Applications in Economics.
Work/Project History:
Nationwide Remarketing – Consultant 2015 – Present
This company is in the Automotive business buying and selling cars online.
Designed Database and wrote Stored Procedures in MS SQL 2014.
Designed and build windows UI front end using C#.Net for managing inventory.
Wrote API interfaces to various third parties to transfer data between systems using several proposals, rest services, JSON end points and others. These APIs are used in the automated pricing engine, automated SMS texting interface, sending assignments to vendors, getting updates from vendors….
Setup and manage servers for system with redundant backup site.
Wrote public facing website for generating bids online and inventory management. https://www.carbidnow.com/, https://www.carbidnow.com/stock/Account/Login.
Manheim Auto Auctions – Consultant 2002 present – Sr SQL systems engineer
This company is in the Automotive Auction business. In 2002 they used SQL Server 2000. Later we upgraded the system to 2005 and in 2013 we upgraded to 2008 R2.
Wrote Stored Procedures, Trigger, and Functions in MS SQL
Designed database structures and implemented in SQL Server.
Wrote front end UI screens using VB.NET and C#.NET
Designed and implemented online auction system which use several technologies:
oOnline Bidder DB which uses linked servers to move real time auction data to a designated high volume SQL server so massive numbers of users will not cause production DB to crash.
oThe Real Time Audio/Video streaming was accomplished by developing a custom Flash Media Server application.
oThis high volume auction system requires 200 megs of bandwidth. This was hosted in a Via West data center to handle the bandwidth. I designed the data center, installed the equipment and managed.
oThis also required a network of Cisco firewalls and routers.
Helped create a complete user manual for end users
Designed and implemented a GAAP compliant GL accounting system for tracking of inventory, payables, expenses and revenue.
Designed title document tracking system and paperwork scanning. These documents are scanned as BLOBs and stored in an image database on the data warehouse SQL DB.
Developed photo storage database that holds all of the photos of units in a SQL DB. These are also stored at the data warehouse in a SQL DB. Designed Data Warehouse document management system. We have SQL Server BLOB database built using partitioned views. This structure holds over 300 Million photos and scanned images all available real time.
Wrote web Services VB.Net to support automatic system to move assignments across systems between clients and vendors.
Wrote Data Buyer import system that takes buyer information (name, address, dealer license…) from a third party provider and loads the data into all of the necessary DBs. This directly loads the third party data into a dedicated buyer master DB and then moves the data to the necessary production DBs using linked servers, scheduled task and stored procedures.
CMG – Consultant 2010-2012 – Sr Programmer – Accounting systems.
This was a credit card issuer company
Wrote GL application to book transactions to a General Ledger
Wrote DTS processes to load external transaction files in to SQL DB
Wrote automated FTP process to pick up transaction files from card processor
Employee Assistance Programs International, Inc: Director of Information Technology 1/97 to 2002.
EAPI was a Mental Health benefits provider
Performed IT management functions
Wrote Client Scheduling system to handle multiple counselors at multiple locations with varying schedules ensuring Mental Health privacy issus using R:base (a SQL compliant DB)
Wrote Medical Claims processing system.
Managed phone system and wide area network communications
Developed custom reporting from Phone ACD system
UMMG Software: Senior systems engineer, 4/96 to 12/96.
UMMG was a credit card issuer company
Wrote salesman commission payment system in R:Base
Designed DB to book sales commissions to GL
Managed communications/phone systems and wide area networks
Designed ACD reporting system
Built banking ACH system to auto draft customer accounts
Benefit Management Systems, Inc: Systems Engineer, 10/91 to 4/96.
BMS was a healthcare consulting company
Wrote and managed several SQL based healthcare/benefits systems.
Capital Associates International: Programmer Analyst, 3/89 to 10/91.
CAI was a high tech leasing company
Wrote paperwork tracking system using SQL
Worked on Unix system programming UI.
Database Projects:
Salvage Auto system – SQL - accounting, auction, paperwork tracking, Date Warehouse
Credit Card processing – SQL –Credit card transaction accounting system
EAP Client Scheduling Database
Document Scanning and Storage
Multi-Level Commissions System – Accounting
Human Resources/Benefit Tracking Database
ACH Processing System
Automated Report Faxing/scanning
Claim Processing System
Inventory/Billing System
Bus Ridership System
Bus Scheduling System
Litigation Support Tracking Database
Property Management Database
Application Software Experience:
MSSQL – T-SQL, Stored Procedures, Triggers, Functions, Automated Tasks, Linked Servers, dynamic SQL
MySql database systems
R:base – SQL database systems
Crystal Reports
HTML – website development
Java Script
Network Projects
Windows Server – IIS Servers
Wide Area Networks using TCP/IP and IPX/SPX
Virtual Private Networks
Firewalls – Watchguard
Cisco Routers & Firewalls
Automated FTP transfers
Domain Hosting
DNS setup
Email Server
Telephone Projects
Norstar phone system
Symphony ACD
Custom ACD reporting
Norstar voice mail
CoLo Facilities management
Long Distance management
T1/Digital communication installations
Phone system programming & maintance
Contact this candidate