Sign in

Sql Server Developer

Middletown, California, 95461, United States
November 07, 2018

Contact this candidate


Jacqueline H. Macfadyen

San Francisco Bay Area

410-***-**** cell


•15 years IT experience covering multiple facets of technical, network and programming support

•10 years of .NET and SQL programming experience

•10 years of experience in application, desktop, end-user and network support

Technical Competencies

Software: Microsoft Dynamics CRM 2011-2016 & 365, MVC, Microsoft Office 2010, 2013 & 2011 (Mac), Open Office 2.0 Dreamweaver MX 2004, Active Directory and Exchange Management Nagios, Netcool, Backup Exec, Arcserve, iBac, Visual Studio 2008-2017, Toad, Team Approach 5.0.13, SAS 9.2, SSMS, BIDS, SSIS, SSRS, XCode, Eclipse, Netbeans, Flowfinity, Viewpoint, JWS, Command Alkon, Crystal Reports

Operating Systems: Windows 95, 98, NT, NT Server, Windows 2000, Windows 2000 Server, Windows 2003 Server, Windows PE,XP Pro, Windows 7-10, Windows 2008 Server; Windows 2012 Server; OS/2; CentOS, Solaris 10, Solaris 9, Red Hat Linux Enterprise 4, Mandrake 10.1, Gentoo, Mandriva, Ubuntu, Mac OS X, ACF2, iOS 6-7

Programming Languages: HTML, JavaScript, CSS, Visual Basic, Wiki Syntax (both Tiki and Media Wiki), familiarity with Perl, bash scripting, AS/400 query writing, PHP, C#, ASP.NET, MVC 4 & 5, PL/SQL, VB.NET, T-SQL, Objective-C, Java, Ruby, XML, Python, ASP.NET Core, PL/SQL, T-SQL, LAMP

Services and Protocols: Apache, NRPE, Tomcat, SNMP, SCP, SSH, Telnet, NTP, IIS 7.0, Nagios, JBoss, Wireshark testing, FTP, SFTP, JSON, XML

Hardware: Extensive hands on experience with Windows servers and workstations, Macintosh and AS/400.

Databases: MS SQL Server 2008 R2, 2012, 2014 (including SQL Agent), Oracle 9i, Oracle 12, MySQL, SQLite

Professional Experience

Syar Industries, Napa, CA May 2018 -present

Application Integration Developer: CRM - C# - .NET - SQL Server - MVC

•Develop ETL strategies using SSIS, and C# to integrate data between a large variety of legacy systems.

•Develop reports using SSRS to complement and enhance existing Crystal Reports for the Viewpoint ERP.

•Develop proof of concept for a mobile application for time management and inspection tracking using Flowfinity.

•Develop SQL Server database for reporting.

•Currently developing a proof of concept for a .NET Core application to track asphalt scheduling.

•Other custom solutions and programming as needed.

American Board of Foot and Ankle Surgery, San Francisco, CA May 2017 – May 2018

Senior Software Developer: CRM - C# - .NET - SQL Server - MVC

•Develop ETL strategies using SSIS, CozyRoc and C# to automate the transfer of data from our vendor to our data warehouse.

•Edit and develop reports using SSRS for CRM.

•Develop MVC 5 portal to view legacy data from CRM 4.0

•Develop SQL Server database and portal to view scoring information using SQL and C#

•Develop and maintain an operational data store used to create reports for major CRM entities using CozyRoc extensions for SSIS to connect to CRM and Stored Procedures in SQL Server to update the database.

•Currently developing an MVC 5 application to replace SharePoint.

•Implement the use of SSIS and CozyRoc extensions to connect with the CRM on an organizational level, including the training of junior developers on how to use SSIS.

•Currently developing an operational data store for secure historical exam results dating back over 20 years.

•UAT testing for Microsoft Dynamics 365 upgrade

•Other custom solutions and programming as needed.

Pharmacy Technician Certification Board, Washington, DC October 2014- April 2017

Enterprise Applications Manager: CRM - C# - .NET - SQL Server

•Develop ETL strategies using SSIS and C# to automate the transfer of data from our test provider to Microsoft Dynamics CRM.

•Develop reports using SSIS with CozyRoc extensions for CRM for bi-yearly state reporting.

•Edit and develop reports using SSRS for CRM.

•Develop integration between Dynamics CRM and Zendesk using C#, JavaScript and Python.

•Support and train staff on Advanced Find and other CRM functionality

•Develop forms and custom pages using .NET for Sitefinity

•Develop payment monitoring and duplicate detection system using SSIS and C#

•Maintain a local copy of our CRM database

•Maintain a real time reporting operational data store with major CRM entities.

•Other custom solutions and programming as needed.

Humane Society of the United States, Gaithersburg, MD March 2012 – October 2014

Lead Integration Developer: C# - .NET - SQL Server

•Develop ETL strategies using SSIS and C# to automate the import of data from flat files into data warehouse and for transmission between the Team Approach Oracle 9i database and Microsoft Dynamics CRM.

•Develop Ruby and C# scripts to support daily operations including the retrieval and submission of data via SFTP and JSON APIs.

•Develop program to validate data from vendors prior to upload.

•Develop SQL Server stored procedures, views, functions and indexes.

•Spearhead automation of daily tasks

•Design forms in Microsoft Dynamic CRM using JavaScript and in SharePoint using Business Intelligence.

•Develop and implement monitoring scripts for Windows server and assist with the development of database standards and related staff training.

World Wildlife Fund, Washington, DC August 2007 - March 2012

Programmer Analyst: C# - .NET

•Created extensive system of change logs for the direct mail tool to keep track of user changes and generate daily reports.

•Developed web-based direct mail tool for program managers to keep track of their mailings, tasks, packages and important dates for various mailings throughout the year. Our analytics group utilized the data from this tool to track the success of various mail campaigns.

•Created web-based tools for: basic file maintenance, format checking and procedure automation prior to upload to database.

•Developed interface in support of nightly General Ledger processing.

•Created reports using Microsoft Reportviewer and augmenting the Team Approach application.

•Administered Windows 2003 SAS and Sun Solaris 9 servers including the reboots and the restarting of services.

•Administered Team Approach application and supported end users.

•Created C# scripts to monitor SAS user sessions as well as disk space on the SAS servers.

•Created several automated shell scripts to collect vendor files via FTP, run lockbox reports to mitigate errors and migrate files to the appropriate folders for processing.

•Created ad-hoc on the fly reports using UNIX shell scripts and PL/SQL, Perl, HTML, SAS, C# and VB.Net in support of the Team Approach application.

Idealstor, Gaithersburg, MD May 2007 - August 2007

Network Engineer

•Administered backup software/hardware using Windows Server 2003, Windows XP Pro and Windows PE.

•Created/restored ghost images. Experience with PHP, MySQL, batch file scripting, Perl, HTML.

•Assisted customers with hardware and software issues. Setup KB Publisher for customer-facing knowledge base.

•Installed Bugzilla for development team.

SunRocket Inc, Vienna, VA September 2005 - May 2007

NOC System Administrator

•Provided highest tier of customer support.

•Manage roll-out of new end-user hardware.

•Supervised, coach and train NOC team members. Assign daily activities for night shift team.

•Monitored services on both Red Hat Enterprise 4 server as well as CentOS (a Red Hat Linux based OS).

•Analyzed process output and diagnose errors in preparation for escalation.

•Administered Nagios alert system and configuration of NRPE when new services were required for monitoring on Cent OS, Mandrake 10.0, Red Hat Enterprise 4, Solaris 10, and Windows 2003 servers.

•Wrote and edited Bash and Perl scripts as required for Red Hat Enterprise 4, Cent OS and Mandrake 10.0 servers. Use Nagios, Netcool, and custom tools for the monitoring and surveillance of the network and systems infrastructure.

•Experience with Apache, PHP, MySQL, Perl, BASH, HTML CentOS, Mandrake 10, Solaris 10, Red Hat Enterprise 4.

•Implemented Tiki Wiki on CentOS server for the purpose of documenting new procedures, blogging immediate changes and logging pending events in an online calendar, linked to main Wiki page.

•Monitor and support network for nationwide VoIP telephone company.

Micros Systems, Columbia, MD January 2005 -September 2005

Technical Support

Troubleshooting both Windows NT and Windows 2000 Professional and optimizing performance. Support RES software, run SQL queries and commands to resolve certain commonly known bugs and issues.

MRC Group, Las Vegas, NV May 2003 - September 2004

Assistant Programmer

•Programmed client text into Survey Systems 8.1 and exported to the web server.

•Develop JavaScripts for exporting web surveys and assist in writing macros to streamline processes. Utilize ASP, HTML, JavaScript, Visual Basic and Microsoft Access to assist in the design and implementation related tools.

•Designed and implemented system for monitoring quotas, respondents and errors.

•Maintained over 70 Seepoint touch screen computers, cleaning and aligning them as needed.

•Monitored the collection of dial data for new television promos and pilots (Nielsen’s extranet software package)

•Performed attended and unattended installs of Windows XP, 2000, 98, and 95. Install and configured Novell Netware Client. Monitor and setup videoconferencing using Polycom system. Edit and dub video masters onto DVD and/or VHS using a combination of DV Capture-AVI, Storm Edit, and Nero Burning ROM.

•Provided support for data control; including the cleaning of data in SPSS and the creation of tables in Microtab 2004.

•Provided end-user desktop support for Windows 2000 and printing.

American President Lines, Jacksonville, FL July 1998 - December 2002

Network Security Administrator

•Wrote AS/400 queries to obtain both archived and non-system report data, joining multiple files to produce desired results.

•Audited security tables to identify and correct data integrity issues (e.g. blank fields, duplicate Ids, ids with incorrect user information, invalid contractor accounts).

•Prepared site for Y2K compliance (setup new systems, installed compliant software, etc.). Assist with ISO9002 audit.

•Performed weekly and daily tape backups using both the 3490 and 3590 tapes.

•Participated in disaster recovery operation in which 50 sites had to be pointed to a back-up AS/400 unit under very hot time restraints.

•Maintained documentation on security administration procedures for all supported systems.

•Managed Global Network ID’s using Active Directory and provide VPN Support.


University of Maryland University College December 2014- May 2018

MS in Software Engineering

University of Maryland University College September 2012- December 2014

BS in Computer and Information Systems

Certifications & Training

Dynamics CRM 2015/2016 Extending/Developer Boot Camp May 2016

Contact this candidate