| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes .Net Web Sql Server Fort Worth, TX Sql Server .Net Irving, TX .Net Developer Sql Server Dallas, TX Sql Server Microsoft .Net Plano, TX .Net Developer Sql Server Irving, TX .Net Developer Sql Server Dallas, TX SCRUM Master, technical manager (ASP.NET, C#, SQL Server, web AP Roanoke, TX |
|
Click here or scroll down to respond to this candidateCandidate's Name NUMBER AVAILABLE EMAIL AVAILABLEStreet Address Scarlet Oak LaneEuless TX Street Address
James FiskTechnical 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 12.PROFESSIONAL EXPERIENCE:March 2022 to November 2023Bank of America (Experis/Ettain Contract)Fullstack .Net DeveloperDeveloped, enhanced, tested, supported, maintained, and debugged software applications that supported business units or support functions for c# middle ware.Used Jira to track projects.Used Insomnia for web side debugging.Used Bitbucket and artifact factory.Supported Angular 12 Java Script app.Used Ansible/Jenkins for deployment to IISWrote SQL queries for reports for Compliance and ManagementFixed 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.Optimize SQL for OLTP efficiently.June 2021 to Jan 2022Berkshire Hathaway Automotive Irving Tx(Matrix Resources)Fullstack .Net DeveloperApplied 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.Updated Pythons scripts for ETL on Linux BoxWrote Scripts using WinSCP for SFTP of data from Vendors.Updated Python/Flask website Rest API administered on IIS.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 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 for OLTP.November 2019 to April 2021Bank of America Addison Tx (Experis/Ettain Contract)Software Developer AgileASP.NET 4.61 update two websites from .net 2.0 to 4.61Used 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 UATUpdated an Informix procedure return additional columns to SQL Server.February 2019 to October 20197-Eleven Inc. Irving TxSoftware Developer AgileWrote 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 TxSQL Server DBA\Developer, C# DeveloperDesigned 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 WindowsWrote 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 2010Alvarez and Marsal LLC Dallas Tx (Robert Half)SQL Server DBADeveloped T-SQL ProceduresDeveloped SSRS ReportsWrote SSIS packages to replicate data to Data Warehouse.Tuned 2 terabyte database.July 2009 to September 2009Alcon Laboratories, Inc., Fort Worth TX (TechSystems)SQL Server DBAUpgrade SQL Server 2000 to SQL Server 2008.Convert DTS packages to SSIS packages.Deploy decision-support Databases for Affiliate Countries.August 2008 to July 2009ThinkCash LLC, Fort Worth TXDevelopment DBAPerformed SQL Server data modeling for OLTP and OLAP databases.Used Agile Development Methodology.Wrote SQL Reports.Developed OLAP Cubes for decision-support.Wrote DTS PackagesWrote 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 2008Thomson Reuters Fort Worth, TX (Idea)Database Developer/.Net DeveloperManaged 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 ConnectionsDeveloped SharePoint .net applications with MOSSUsed Team Foundation Server.July 2007 to March 2008Epsilon, Irving, TXDatabase DeveloperDeveloped 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 2007Advent Software, San Francisco, CASoftware EngineerWrote 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 2006Chiron Corporation, Emeryville, CA.Lead Systems EngineerDatabase ExperienceManaged Junior DBAsFive 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.15Applied patches to Oracle Database.Used ErStudio for Database Schema design for various projects.Scripting ExperienceCreated 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 ExperienceWorked 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 ExperienceSupported Trackwise.Supported Tax Server.Supported Archibus.Equity Edge Stock Options upgrade and support.MS IIS6 and .NET (dot net) support and Administration.Crystal ExperienceUpgrade Crystal Enterprise 8.5 to Crystal Enterprise 9.Upgrade Crystal Enterprise 9 to Business Objects Enterprise 11Crystal 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 ExperienceProgrammed 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.netDeveloped 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 1999Spear Technologies, San Francisco, CA.Systems Analyst/Designer/ProgrammerWrote 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 IIJanuary 1996 to August 1997Providian Financial Corp., San Francisco, CASr. Programmer/AnalystUsed 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, CA4 Years Math/CS 5/82Refresher: Compiler Theory, Operating Systems, Computer Architecture, Coding & Information Theory and Neural Nets 5/91-5/92 |
