.Net Developer Sql Server

Cell Phone 916-***-**** *******@*****.***

***** ******* *** ****

Euless TX 76040

James Fisk

Technical Skills: MS SQL Server 7, 2000, 2005, 2008, 2012, 2016 2019, DTS, SSIS, T-SQL, MS Project, SQL Reports, PowerShell, Team Foundation Server, Visual SourceSafe, Subversion, GitHub, Crystal Reports versions 6, 7, 8, 8.5, 9, 11, Crystal Enterprise 9, Business Objects 11, Oracle version 7.34, 8.06, 8.1.7.4, 9.2.0.5, 10g, PL/SQL, Apache, VB6, VB .Net, C#.net, C/C++, Visual Studio 2000-2017, Microsoft Office 2007-2016, Informix 7.23, Informix 7.31, Java for Oracle, MS VB Script, Solaris 9, AIX, Linux, MS Server 2000-2019, MS Windows XP professional, Perl, Bourne Shell, Korn Shell, C Shell, TOAD, Silverun, ERWin, Embarcadero ER Studio, TOAD Data Modeler, HTML, CSS, Java Script, ASP, Agile, TDD, Relativity, SSIS, PowerBI, Python 3.9, Flask, NodeJS, ExpressJS, ReactJS MongoDB, IBM MQ, PostgreSQL, WinSCP, GitHub, Maven, TFS, Angular, Neo4j.

PROFESSIONAL EXPERIENCE:

March 2024 to September 2024

Fidelity Investments

ASP.NET Developer/PL/SQL developer

Developed, enhanced, tested, supported, maintained, and debugged Alternative Investments Web Applications that Processed trades to Mainframe. Written asp.net/c#,with MVC and asp.net and JavaScript.

Oracle PL/SQL packages updated for additional requirements.

Used GitHub for version control.

SQL Developer.

Used Jenkins for build and deployment CI/CD.

Used Agile methodology for Project Management with Jira.

March 2022 to November 2023

Bank of America (Experis/Ettain Contract)

Fullstack .Net Developer/SQL Developer

Developed, enhanced, tested, supported, maintained, and debugged software applications that supported business units or support functions for c# middle ware.

Created new API for our product to handle lookups on ticker items. HTTP request retuning data as a Json file.

Used Jira to track projects.

Used Insomnia for web side debugging.

Used Bitbucket and artifact factory.

Supported Angular Java Script app.

Used jQuery HTML manipulation

Used Ansible/Jenkins for deployment.

Wrote SQL queries for reports for Compliance and Management

Fixed C# Code to Generate Excel reports in XML for Excel.

Supported users by using SQL to look up and support trade status.

Fixed SSIS jobs running under Autosys.

Used GitHub for version control.

June 2021 to Jan 2022

Berkshire Hathaway Automotive Irving Tx(Matrix Resources)

Full stack .Net Developer/SQL Developer

Applied knowledge of SSIS/DTS to streamline data integration processes, enhancing the efficiency of data transfer and transformation within the organization for warehouse from CDK Cloud Services PostgreSQL.

Converted data from PostgreSQL to SQL server using Python.

Created Linux Bash script to automate mail server.

Supported and update PHP help desk App.

Updated Pythons scripts for ETL on Linux Box

Wrote Scripts using WinSCP for SFTP of data from Vendors.

Updated Python/Flask website Rest API.

Installed/Created PostgreSQL Instance for Archiving of Historical Data.

Worked on Backups for SQL Server.

Used GitHub for version control.

C# project interface to Personnel and automatically remove fired people from Active Directory.

Java/Eclipse and Maven/ project to archive data from Cloud based PostgreSQL database on Linux.

Supported React/Nodejs web site.

Utilized in-depth SQL Server knowledge to design and optimize database structures, enhancing data retrieval and storage capabilities for improved application performance.

Neo4j for queries of vendor database.

Used React to update web page.

November 2019 to April 2021

Bank of America Addison Tx (Experis/Ettain Contract)

.Net Developer Agile

ASP.NET 4.61 update two websites from .net 2.0 to 4.61

Used Team Foundation Server for source control.

Deployed Websites to IIS server and configured.

Created .Net service to monitor a directory for incoming files and call the appropriate Python script for processing. Installed the File Watcher Service on App Server.

Python Scripts to process Main Frame reports to csv for ETL used Panda Data Frame to convert data from report files to SQL Server.

SQL Server 2019 stored procedures for bulk load and cube processing updated SQL Jobs load process.

Wrote PowerShell Scripts to copy directories and shares and create on Sit and UAT

Updated an Informix procedure return additional columns to SQL Server.

Used GitHub for version control.

February 2019 to October 2019

7-Eleven Inc. Irving Tx

.Net Developer Agile

Wrote Powershell scripts to SFTP files to vendors.

Wrote Powershell scripts to copy and import files.

Wrote SSRS reports for auditing and sales.

Wrote SSIS to export data for vendors.

Used PowerBi display monthly status of stores reporting.

Applied SQL updates for PDI enterprise.

Used PDI Enterprise to define imports and exports for sales data.

Created Web page with Node.js, Express.js, React.js and MongoDB.

November 2010 to December 2018.

Lehman Brothers Holdings Inc. Dallas Tx

SQL Server DBA\Developer

Designed Built and a Search and extraction system for 3.2 billion emails stored in zip files. Wrote C# zip extractor selectively extract the emails wanted not the whole zip.

Converted data from Oracle 9 to SQL Server with custom c# prigram. Managed Oracle 9 on Solaris and Windows

Wrote stored procedures and C# CLR to create metadata export files from SQL Server 2012 in concordance format for Relativity Document review.

Setup Redgate backups schedule for SQL Server databases.

Wrote Powershell Scripts to monitor Backup success or failure.

Wrote Python scripts to export data form Nuix.

Wrote C# programs to search text files for certain patterns using Regular Expressions.

Designed tables and wrote stored procedures for Reporting in SQL Server 2016.

Wrote SSIS packages to load data for reporting.

Wrote SQL Server Reports for what was processed and what was remaining.

Did Relativity imports and exported Relativity productions.

Loaded data into LAW databases for export to Relativity.

Used Power BI to create reports on key server metrics.

Developed RESTful site for Evada searches. Used ASP.Net to develop front end. Used IBM MQ for messaging.

Imported data from Informix using jdbc and c#

October 2009 to October 2010

Alvarez and Marsal LLC Dallas Tx (Robert Half)

SQL Server DBA, .Net Developer

Developed T-SQL Procedures

Developed SSRS Reports

Wrote SSIS packages to replicate data to Data Warehouse.

Tuned 2 terabyte database.

July 2009 to September 2009

Alcon Laboratories, Inc., Fort Worth TX (TechSystems)

SQL Server DBA

Upgrade SQL Server 2000 to SQL Server 2008.

Convert DTS packages to SSIS packages.

Deploy decision-support Databases for Affiliate Countries.

August 2008 to July 2009

ThinkCash LLC, Fort Worth TX

Development DBA

Performed SQL Server data modeling for OLTP and OLAP databases.

Used Agile Development Methodology.

Wrote SQL Reports.

Developed OLAP Cubes for decision-support.

Wrote DTS Packages

Wrote SSIS Packages.

Wrote T-SQL stored procedures and triggers.

Refreshed development environments.

Wrote C# Database Utilities for development.

Performed SQL Server security.

Wrote PowerShell scripts.

Used Subversion.

April 2008 to August 2008

Thomson Reuters Fort Worth, TX (Idea)

Database Developer/.Net Developer

Managed developers and worked with Stake holders.

Used Agile Development Methodology.

Designed Database in SQL Server 2005 for new software project.

Lead Architect, Developed Naming Conventions, processes for security and maintenance and backups.

Wrote T-SQL store procedures for project.

Developed Ajax .Net Screens and JavaScript for project.

Developed Web Services in SQL Server 2005 for SharePoint Connections

Developed SharePoint .net applications with MOSS

Used Team Foundation Server.

July 2007 to March 2008

Epsilon, Irving, TX

Database Developer

Developed Oracle 10G PL/SQL Code to load and transform data for a data warehouse.

Wrote SQL Queries to check data for inconsistencies.

Wrote Korn Shells to get files, run PL/SQL and generate logs on IBM AIX OS.

Developed Perl programs to parse log files.

Used SQL Loader to load files into raw staging tables.

Import/Export of tables to refresh test databases.

Wrote scripts and queries for Infomix.

March 2007 to May 2007

Advent Software, San Francisco, CA

Software Engineer

Wrote Web Service to execute SQL Server Integration Packages in VB.NET.

Wrote Service for .NET remoting in VB.Net.

Developed DTSX package for SQL Server 2005.

Developed stored procedures and triggers for SQL Server 2005.

February 1999 to October 2006

Chiron Corporation, Emeryville, CA.

Lead Systems Engineer

Database Experience

Managed Junior DBAs

Five years as Informix and SQL Server 2000 DBA.

Installed and setup MS Project Server.

Created Informix backup Scripts using onbar and Veritas.

Patched Informix database.

Install SQL Server 2000.

Wrote SQL Server 2000 stored procedures and triggers.

Created Backup schedules for SQL Server 2000.

Used SQL Server 2000 DTS and Transact SQL to import data to an application.

Recovered SQL Server 2000 database.

Over seven years of experience as Oracle 7, 8i, 9i, 10g DBA.

Experienced in Backup and Recover of Oracle databases.

Experienced in SQL*Loader, Export and Import utility.

Wrote Oracle stored procedures and triggers.

Applied patches to Oracle client for various projects.

Connectivity Support ODBC, OLE DB, Oracle SQL Net, and Oracle Names Server.

Oracle Migration Work Bench converted Access databases to Oracle.

Created table spaces and users for schema creation.

Database Application Support.

Experience as 24x7 production dba as well as application (development) dba.

Experienced in oracle SQL*Plus and PL/SQL Programming.

Upgraded Oracle 8.04 to 8.15

Applied patches to Oracle Database.

Used ErStudio for Database Schema design for various projects.

Scripting Experience

Created VB scripts to Update ODBC registries when changing Oracle Client.

Wrote various administration scripts in Perl, VS script, Korn Shell, C Shell and Bourne Shell on Solaris.

Modified Sitescope monitoring scripts to restart services for a project.

Web Experience

Worked on DMZ upgrade from Netscape to Apache servers for www.chiron.com.

Supported and moved Chiron Corner (Perl based shopping cart).

Wrote DBA Web pages in ASP, HTML and Java Script.

Oracle 9ias Administration.

Solaris version of Apache and ColdFusion MX Administrator.

Support Experience

Supported Trackwise.

Supported Tax Server.

Supported Archibus.

Equity Edge Stock Options upgrade and support.

MS IIS6 and .NET (dot net) support and Administration.

Crystal Experience

Upgrade Crystal Enterprise 8.5 to Crystal Enterprise 9.

Upgrade Crystal Enterprise 9 to Business Objects Enterprise 11

Crystal Reports and Crystal Enterprise Support and Administration.

Wrote Crystal Server Pages for Crystal Enterprise Server.

Created Crystal Reports for Apollo Training.

Wrote various Crystal Reports both standalone and for Crystal Enterprise.

Development Experience

Programmed Oracle Java stored procedures.

VB6 applications to support Data Entry for the Labs.

Designed and created Oracle schema with triggers and stored procedures.

Wrote asp.net application to generate web report from Oracle database.

Wrote data conversion from Training Server to SABA Learning Management System in PL/SQL 9i and created back end scripts for Administration.

Business Objects 11 developer VB .Net and C# .Net, asp.net

Developed custom Crystal Reports scheduler in VB.

Technical Environment: SQL Server 2000/7.0, Oracle 7/8i/9i/10g, Crystal 8.5/9, C#. NET, VB.NET, Windows Server 2000/2003, Solaris, Crystal Enterprise 9, Business Objects 11, Apache, and ColdFusion MX.

August 1997 to February 1999

Spear Technologies, San Francisco, CA.

Systems Analyst/Designer/Programmer

Wrote programs in Delphi II for Repetitive Maintenance, and Bill of Material.

Designed and prototyped modules for Fleet Maintenance package.

Designed and wrote stored procedures and triggers in Oracle PL/SQL for modules.

Used Silverun to model database design and integrate sub modules into main schema design.

Developed Oracle database upgrade scripts for new releases.

Technical Environment: Windows NT, Oracle 7.34, Delphi II

January 1996 to August 1997

Providian Financial Corp., San Francisco, CA

Sr. Programmer/Analyst

Used Erwin Data Modeler for Database design.

Converted call center application (SmartScreens) from MS Access backend to Informix in VB for Windows 3.1 client.

Wrote stored procedures and triggers in Informix for SmartScreens.

Lead Programmer for call center applications and supported more than 600 users on the system.

Worked on Computer Telephony Integration (CTI) with SmartScreens.

Worked on disaster planning, security, and backup systems for the bank.

Wrote several Unix shell scripts using C shell and Korn Shell scripting languages.

Technical Environment: Windows 3.1, VB3/4, and Informix 7.

EDUCATION:

California State University Stanislaus, Turlock, CA

4 Years Math/CS 5/82

Refresher: Compiler Theory, Operating Systems, Computer Architecture, Coding & Information Theory and Neural Nets 5/91-5/92

Contact this candidate