Sr. Programmer / Database Administrator (full Stack) Resume
Elko, NevadA
SUMMARY
Experienced programmer with a track record of incorporating user and business requirements into cost - effective, intuitive, robust, and scalable solutions
TECHNICAL SKILLS
Programming Languages: C#, Visual Basic, JavaScript
Web/Mobile Framework: ASP.Net MVC, ASP .Net Webforms, Angular, Xamarin
UI Framework: Telerik UI for ASP.Net MVC, DevExpress for ASP.Net MVC and Webforms
File Formats: Json, XML, XSLT, XAML
IDE: Visual Studio (2017, 2015, and older)
Web Services: WCF, RESTful, Web API
Security: ASP.Net Identity, Membership, AzMAn, SSL
Design Patterns: MVC, Factory, MVVM, IoC (Unity MVC)
Database: Microsoft SQL (2014, 2012, 2008, and older), SQL Lite, Access
SLDC Tools: TFS (2013, 2012, and older), MKS Integrity, VSS
SDLC Practices: Agile scrum, Waterfall
Collaboration Tool: SharePoint (2013, 2010)
BI Tools: SSRS, SSIS
Reporting: SSRS, Crystal Reports
Extensible Web Server: IIS (7.5, 8.0, older)
Server Operating Systems: Windows (2012, 2008, and older)
Debugging Tools: VS Remote Debugger, Fiddler, IE Dev Tool, Chrome Dev Tool, Postman
PROFESSIONAL EXPERIENCE
Sr. Programmer / Database Administrator (Full Stack)
Confidential
Technologies used:
Xamarin Forms, MVVM, Unity Container, Azure services, ASP.Net MVC and Webforms, C#, Telerik UI for ASP.Net MVC, DevExpress UI for ASP.Net MVC and Webforms, XML, jQuery, Json, CSS, JavaScript, Bootstrap, SQL (replication, stored procedures, tables, functions), TFS, SSRS, SSIS, Entity Framework, Linq, Dapper, Visual Studio (2017, 2013, and older), IIS
Responsibilities:
- Wrote SQL Scripts and SSIS package to help migrate GED (Global Exploration Database) with over 80 million rows of data to aCquire database
- Wrote Grade Control, Hole Manager, and Density tool for Geology to work with acQuire database
- Worked with the team and stake holders to stream line business process and develop applications to boost employee productivity
- Worked on writing Electronic Drill Log using Azure services, Xamarin Forms (Android/iOS), and user interface (ASP.Net MVC) to manage users and reconciliation tool to push data into acQuire database - this project has been redirected
- Supported Geology department with application and data issues
Sr. Programmer / Database Administrator (Full Stack)
Confidential, Elko, Nevada
Technologies used:
ASP.Net MVC and Webforms, C#, Telerik UI for ASP.Net MVC, DevExpress UI for ASP.Net MVC and Webforms, XML, jQuery, Json, CSS, JavaScript, Bootstrap, SQL (replication, stored procedures, tables, functions), TFS, SSRS, SSIS, Entity Framework, Linq, Dapper, Visual Studio (2017, 2013, and older), IIS
Responsibilities:
- Wrote Skills Assessment Dashboard - a global web based application where Confidential executives view and compare geology skills assessment scores in 4 regions (North America, South America, Africa, and Australia) for the purpose of identifying areas that needs further development and rotation of personnel with specific skills set
- Wrote Skills Assessment Tool - a global web based application deployed to all regions (North America, South America, Africa, Australia) where geology managers assess geologists skills in many areas, enters comments and scores, and generates reports
- Wrote UGGC+ (Underground Grade Control) - a web based application for underground mining empowers geologist to create, modify, search, delete channels and samples, move samples, dynamically creates fields, and configure application behavior
- Wrote Assay Preference Editor - Database administrators web based tool use for editing assay preferences fields for the extraction application
- Wrote Drillhole Maintenance - heavily used by regional geologist to manage drill holes data contains geologist and drilling rep assigned, footage, coordinates, account codes, lab, and other related information
- Wrote Drillcost Contract - managed by drill services to create, view, modify, and delete drilling contracts
- Wrote Extraction Comparison - compares historical assay data. Data gets exported to an excel file with specific format using EPPlus api
- Wrote Fuel Cost Importer - drill services tool that matches GED contractor data with fuel logs from different system
- Configured and implemented TFS (2013,2012)
- Collaborated DBAs across Confidential regions (North America, South America, Africa, Australia) resulting to the success of Skills Assessment Tool implementation
- Collaborated with Global Employee Development Manager making Skills Assessment Tool application development, deployment and implementation successful
- Collaborated with DBAs for the successful implementation of UGGC+ application in South America (Peru and Suriname)
- Wrote application enhancements requested by stakeholders
- Wrote technical and user reference
- Managed web server (IIS) - deployed and configured applications
- Supported end users data and application issues
ASP .NET Developer (Full Stack)
Confidential, Milwaukee, WI
Technologies used:
ASP.Net MVC and Webforms, C#, DevExpress UI for ASP.Net Webforms, XML, jQuery, Json, JavaScript, CSS, Bootstrap, SQL (stored procedures, tables, functions, triggers), Google map API, Authorize.Net API, TFS, SSRS, SSIS, Entity Framework, Linq, Visual Studio (2017, 2013, and older), IIS
Responsibilities:
- Wrote Confidential Membership Portal - a web based public facing application serves member companies the ability to updated employee contact information and membership payment
- Wrote some of the pieces for Smart CRM proprietary software filling the gap in the business process. In the areas of accounting, sales, events, and marketing. Integrated 3rd party APIs from Bing, Google Maps, Act-On, RegOnline, and Survey Gizmo
- Wrote customized SSRS reports for accounting, sales, membership, housing and registration, tech and safety, education, statistic, and HR
- Wrote application enhancements requested by stakeholders
- Wrote technical and user reference
- Managed web server (IIS) - deployed and configured applications
- Supported end users data and application issues
SharePoint Developer Consultant
Confidential, Madison, WI
Technologies used:
SharePoint 2010 and 2013, C#, JavaScript, Visual Studio 2013
Responsibilities:
- Designed and implemented SharePoint site for Environmental Law Enforcement.
- Worked with SharePoint admin and stakeholders to setup and configure team site.
- Created document libraries, lists, custom content types, workflows, forms, views, and site permission configuration.
- The site is used for routing environmental cases for approval.
- This holds environmental cases moved between document libraries triggered by an event using features at the site level with event receiver
- Written custom codes using C# and JavaScript (Server and Client Object Model).
- Created few custom actions on ribbon buttons for specific document task, Info Path forms, SharePoint Designer, and SSRS
- Knowledgeable with SharePoint farm tiered architecture and administration
- Performed end user training
.Net Software Developer
Confidential, Atlanta, GA
Technologies used:
ASP.Net Webforms, C#, XML, XSLT, BizTalk, jQuery, CSS, Ajax, Json, JavaScript, Linq, Visual Studio 2010
Responsibilities:
- Wrote Solicitation Campaign search and import tool additional enhancement to the core application CRIF Action 5.2
- Wrote Employee Loan Rule additional enhancement to the core application CRIF Action 5.2
- Wrote middle tier codes that utilizes Biztalk API for Solicitation Campaign and Employee Loan Rule
Software Engineer
Confidential
Technologies used:
ASP.Net Webforms, C#, XML, XSLT, WCF, jQuery, Ajax, CSS, JavaScript, SQL (stored procedures, tables, functions, triggers), Visual Studio 2008, Crystal Reports, IIS
Responsibilities:
- Wrote back office application security using custom membership provider.
- Authenticating and authorizing users with any mixed scenarios using Active Directory, SQL, and WCF
- Wrote and executed test plans and procedures
- Wrote designed specs and test cases document
- Resolved software defects
Infrastructure Analyst
Confidential
Technologies used:
Windows Servers (2003,2000), Visual Studio2005, ASP .Net Webforms, VB .Net, SQL (stored procedures, database, functions, triggers), Crystal Reports, IIS, WMI
Responsibilities:
- Supported over 300 Windows Servers all sites in Asia region - Singapore, Thailand, Philippines, Malaysia, and Hong Kong
- Performed data back-up and restore, security patching, capacity management, operational procedure documentation, upgrade Planning, and security scan closures
- Network services administration (AD, DNS, DHCP, WINS, proxy, anti-virus, SMS)
- Wrote a Server Monitoring Tool - captures versions of anti-virus, applications, and hardware specs from all servers across Asia region
IT & Development Engineer
Confidential
Technologies:
Powercerv ERP, ASP.Net Webforms, VB .Net, SQL (stored procedures, tables, functions, triggers), Sophos Antivirus, MS Exchange 2003 server, ISA Firewall, Windows (2003 and older) servers
Responsibilities:
- Wrote ASP.Net (VB.Net) application that extends Powercerv ERP software monitoring orders and shipment status
- Analyzed and resolved ERP related issues using SQL 2000 Enterprise Manager
- Wrote SQL stored procedures and views used for accounting, customer relations, orders, and shipment reports
- Managed network, work stations, and windows servers. Wrote scripts to automate software installations, file and printer sharing
- Managed MS Exchange server 2003, Sophos antivirus client/server, and ISA Firewall
- Managed Mac desktop and laptops
- Automated operating system and application installation through network
- Supported local and US users using company standard software applications (MS Office, Outlook, Adobe, AutoCAD)
Service Engineer
Confidential
Responsibilities:
- Provided hardware and application support to offsite and onsite customers
- Setup and configure Desktop PC, Laptop, computer peripherals and software applications
- Provide in-house technical support fixing printers, computers, software applications, and hardware peripherals