| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE -- EMAIL AVAILABLEhttps://LINKEDIN LINK AVAILABLEDependable and motivated database developer experienced in multiple industries (health, financial, insurance, nuclear) having excellent communication skills and passion for reporting.Strong database development with SQL Server (T-SQL, SSIS and SSRS) and MS AccessDeveloped new, enhanced and fixed existing databases, tables, functions, queries and stored procedures using indexes and other performance tuning techniquesImported data using SSIS / ETL from Access and FoxPro tables into SQL Server tablesCreated and ran numerous T-SQL scripts to analyze, delete, insert and update data in SQL Server tablesMet with managers and other staff to gather requirements for enhancements and new queries / code.Excellent reporting experience with SSRS, Crystal Reports and Access.Net full stack programming experience with VB.Net, C#, ASP.NET and SQL ServerExcellent communication skills working with co-workers in all departments and levelsExcellent troubleshooting and problem solving skillsCreated technical and user documentation for projects and unit test cases for testersSKILLS:Languages: ASP .NET 2003, 2005, 2010 & 2017, C# 2012, 2015 & 2017, Visual Basic .NET 2003, 2005, 2010 & 2019, T-SQL, Visual Basic, Visual FoxPro, C, HTML, CSSDatabases: SQL Server 2000, 2005, 2008, 2012 & 2017, Access, Excel, FoxProOther Tools: Visual Studio, WinForms, Web Forms, Azure DevOps Server (Team Foundation Server), Visual Source Safe, Crystal Reports, Integrated Services (SSIS), ETL, Reporting Services (SSRS), Agile Methodology, SharePoint, Windows Presentation Foundation, Silverlight, JIRA, GitEXPERIENCE:JoAnns Fabric August 2018 PresentSales ClerkGreet JoAnns customers.Cut fabric per customers orders and put away fabric.Best Crowd Management August 2021 PresentEvent SecurityCheck peoples bags when going through the mags.Guard doors and hallways to keep out people.Preferred One / United Health Care August 2021 August 2022Sr. Data AnalystCreated SQL queries, Crystal Reports and SSIS packages to get data for other departments.Ran SSIS packages and stored procedures to process data for clients.Worked with business groups to gather requirements for reporting needs.Responsible for running daily, weekly, monthly and quarterly processes.Skill set utilized: SQL Server, SSIS, T-SQL, Crystal Reports, Visual Studio 2019, ExcelE91 February 2020 May 2020Professional Consultant Software EngineerClient: NACS, Inc.Migrated VB.NET code to Visual Studio 2019 (Windows 10) for HMI applications.Worked with clients to test software interaction with the machines.Skill set utilized: VB.NET, Visual Studio 2019Artech Information Systems LLC August 2018 December 2019Professional Consultant Application Systems Engineer / Application .NET DeveloperClient: Medtronic, Inc. October 2019 December 2019Converted Visual Basic code to C# for a Smart Card Reader application.Researched and corrected code to call .DLL files for accessing the reader and card.Checked in code using Git.Client: Wells Fargo, Inc. / Equiniti August 2018 July 2019Created weekly T-SQL scripts for multiple departments and tax purposes.Researched issues in ASP.NET, C# applications.Analyzed financial owner and address data using T-SQL.Reset employees voicemail passwords and other access daily.Skill set utilized: SQL Server 2017, T-SQL, ASP.NET, C#, Visual Studio 2017, GitCognizant Technology Solutions April 2018 May 2018Professional Consultant Staff SupportClient: 3M, Inc.Successfully installed 75 patches and updates on 7 application servers to fix vulnerabilities.Participated in Agile sprints using JIRA on SharePoint to manage the tasks.Documented file upload process prior to migration of the Ironwood application as a JIRA task.Skill set utilized: Agile Methodology, JIRA, SharePoint 2010Genesis10, Inc. January 2016 December 2017Professional Consultant Software DeveloperClient: Xcel Energy, Inc. Monticello Nuclear PlantUpdated Excel VBA code to analyze and organize key performance indicators for graphs used by managers before and during their most successful outage in more than three decades.Created an Access (GUI forms) and SQL Server security application for plant users to schedule deliveries and visitors, including Access reports and exporting to Excel.Enhanced a multi-tier web application (ASP.NET, C# and HTML) to use new data source (SQL Server) and created unit test cases for testers.Created an Access (GUI forms) and SQL Server security shift operation log application for the Security team.Skill set utilized: Visual Studio 2015, C#, ASP.NET, Web Forms, HTML, SQL Server 2008, T-SQL, Access 2010, Excel 2010, SharePoint 2007 & 2013, Azure DevOps ServerYork Solutions, Inc. October 2015 November 2015Professional Consultant .NET DeveloperClient: Data Recognition Corporation, Inc.Created numerous T-SQL scripts to analyze, insert and update SQL Server tables.Enhanced code in an ASP.NET, VB.NET and SQL Server GUI forms web applications.Mentored another developer during sprints.Skill set utilized: Visual Studio 2010, ASP.NET, VB.NET, SQL Server 2012, T-SQL, Agile Methodology, Azure DevOps ServerAGS, Inc. April 2015 September 2015Professional Consultant Programmer AnalystClient: Maximum Solutions, Inc.Fixed and enhanced forms and code and optimized reports.Added new functionality for creating package items (cheese burger basket, birthday party) in a Windows Presentation Foundation, Silverlight, VB.NET and SQL Server application.Skill set utilized: Visual Studio 2012 & 2012, VB.NET, SQL Server 2008, T-SQL, Windows Presentation Foundation, Silverlight 5 Toolkit, Crystal Reports 2012Mainsl Services, Inc. July 2014 February 2015Programmer AnalystMigrated two Access participant directed health care services (PDS) payroll programs to C# and SQL Server.Exported calculated payroll data to formatted Excel files for the CFO.Ran two PDS programs payroll programs weekly and fixed inconsistencies.Skill set utilized: Visual Studio 2012, C# 2012, SQL Server 2008, T-SQL, Access and ExcelRobert Half, Inc. April 2014 June 2014Professional Consultant SQL Server DeveloperClient: Helgeson / ParagoUpdated tables using T-SQL and imported Excel and text files.Created and enhanced stored procedures and Crystal Reports.Skill set utilized: SQL Server 2008, T-SQL, Crystal Reports 2005, JIRA, SharePoint 2007Alto Consulting & Training, Inc. May 2013 October 2013Professional Consultant Programmer AnalystClient: US BancorpCreated tables, stored procedures, reports, forms, code and classes to enhance and support a rate calculation and processing VB.NET GUI Windows application used to track and publish interest rates for use throughout the banks daily operation.Created eight interest rate reports (simple to complex) using SSRS to be run from the VB.NET application.Created stored procedures to get data for reports and forms for the VB.NET GUI Windows application.Worked with T-SQL to query tables and to create SQL scripts to update tables via stored procedures on a daily basis.Used advanced T-SQL programming techniques to work with data in a large, highly normalized database.Skill set utilized: VB.NET 2010, SQL Server 2008, T-SQL, Visual Studio 2010 &v2012, SSRS, Windows 7, Visual Source SafeBuxton Consulting, Inc. February 2013 April 2013Professional Consultant Programmer AnalystClient: McKesson, Inc.Enhanced and fixed ASP.NET and VB.NET Web programs.Created and maintained tables and stored procedures for Web programs.Skill set utilized: VB.NET 2010, ASP .NET 2010, SQL Server 2008, T-SQL, Visual Studio 2012 & 2012, Agile Methodology, DevExpress, HTML, Windows 7, Visual Source SafeVan Wagenen Financial Services, Inc. February 2007 January 2013Programmer AnalystEnhanced and fixed DOS and Visual FoxPro programs.Migrated FoxPro applications to new VB .NET GUI Windows applications, SQL-Server, Integrated Services and Crystal Reports.Created and maintained more than 50 Crystal Reports and VB.NET code to supply data for the reports.Created new forms in a VB.NET GUI Windows application and code to import data from different file types, manipulate the data and save it to SQL-Server tables.Enhanced and maintained numerous individual and team VB.NET GUI Windows applications, SQL-Server, SSIS, ETL and Crystal Reports projects.Responsible for daily mainframe data download process to FoxPro tables and reports.Skill set utilized: VB.NET 2003, 2005 & 2010, SQL Server 2000, 2005 & 2008, T-SQL, Visual Studio 2010 & 2012, Visual FoxPro 6.0, DOS FoxPro, Windows XP, SSIS, ETL, Crystal Reports, Visual Source SafeSuperior Consulting Services, Inc. June 2006 December 2006Professional Consultant Programmer AnalystClient: Schwebel Goetz & SiebenRepaired multiple Access databases saving them considerable time and money.Client: UCAREAssisted in converting a Visual Basic 6 application to a VB.NET 2005 GUI Windows application. Created screens that worked with a data access layer to manipulate the data between the application and the SQL 2005 database.Client: TennantAssisted in researching, designing, developing, testing and documenting a dynamic, multi-lingual web application using VB.NET 2005 with SQL 2000.Client: Minneapolis Park & Recreational BoardResearched and solved security issues to allow them to re-gain control of several Access databases.Client: InternalEnhanced SCS intranet programs written in ASP.NET, VB.NET, HTML, CSS and SQL Server.Skill set utilized: VB.NET 2003 & 2005, ASP .NET 2003 & 2005, SQL Server 2000 & 2005, T-SQL, Visual Studio, Access 2003, Visual Basic 6.0, HTML, CSS, Windows XPBlackstone Technology Group, Inc. April 2005 June 2006Professional Consultant Programmer AnalystClient: QwestConverted Excel applications to Access Windows applications allowing users to enter and manipulate data via GUI forms and export the data to three different formatted Excel spreadsheet billing invoices using VBA.Designed and developed an Access Windows application to import text files, process and format the different services and dynamically create a phone bill in Excel for more than 240 clients. Reduced time by more than 90% and increased accuracy.Skill set utilized: Access 2003, VBA, SQL, Excel 2003, Windows XPTech-Pro, Inc. November 2004 February 2005Professional Consultant Programmer AnalystClient: Carlson Companies, Inc.Analyzed, documented, enhanced and fixed multiple databases to institute several incentive plans, reduced time and effort of the user and exported 30 plans into Excel.Skill set utilized: Access 2003, VBA, T-SQL, Excel 2003, Windows XPHudson Financial Solutions, Inc. September 2004 November 2004Professional Consultant Programmer AnalystClient: Land OLakes, Inc. October 2004 November 2004Exported data from their data warehouse into a relational Access database. Created 75 reports and pivot charts to determine gross margin of profitability.Client: Internal September 2004 October 2004Developed a database that combined more than 2.5 million records of financial information.Automated database and query processes for multiple cash recovery projects.Skill set utilized: Access 2002, VBA, T-SQL, Excel 2002, Windows XPLong Term Care Group, Inc. May 2000 - May 2004Programmer AnalystDeveloped, enhanced and fixed more than 100 Access reports using queries and VBA for internal and external clients in our eight reporting Windows application databases.Proactively worked with the claims manager to adjust fees on a report for all clients, which collected thousands of dollars of claims fees immediately.Responsible for the departments end of month process (EOM) for running, validating, fixing and explaining reports in test and production periods. Documented the EOM process.Skill set utilized: Access 97, VBA, T-SQL, Excel 97, Visual Source Safe, Windows 2000Dahl Consulting, Inc. April 2000 - May 2000Professional Consultant Programmer AnalystClient: Long Term Care Group, Inc.Learned data base model, enhanced Access reports and volunteered for EOM.HireTech, Inc. October 1999 - February 2000Professional Consultant Programmer AnalystClient: NordicWare, Inc.Developed a GUI Windows application for the IS department to give employees rights to database programs and for the employees to select from a list of database programs to run.Developed several GUI Windows applications for managers to view and manipulate data from various sources and enhanced existing EDI Inbound and Outbound processes.Skill set utilized: Visual Basic 6.0, T-SQL, Access 7.0, Windows 98Brady & Co. / Intellimark, Inc. October 1997 - October 1999Professional Consultant Programmer AnalystClient: Scanning Dynamics, Inc. September 1999 - October 1999Researched Visual Basic source code to convert an application from 16-bit to 32-bit.Client: Norwest Mortgage, Inc. July 1999 - August 1999Documented screen fields in a PowerBuilder mortgage application.Client: Medtronic, Inc. October 1997 - April 1999Developed several GUI Windows applications for the sales reps to use out in the field.Developed several GUI Windows applications for internal staff including a program to schedule national sales meetings and a program to calculate and graph 401K and stock investments for the sales reps.Skill set utilized: Visual Basic 5.0, T-SQL, Access 7.0, Crystal Reports 6.0, Wise, Windows 95Buffets, Inc. April 1997 - August 1997Programmer AnalystDeveloped a program to generate reports on manager and restaurant data on three levels.Developed two programs to allow restaurant managers to schedule workers.Skill set utilized: Visual Basic 4.0, T-SQL, Access 2.0, Crystal Reports 5.0, Magic, Windows 95ISI Systems, Inc. January 1993 - April 1997ProgrammerEnhanced their two major products to comply with the industry standards.Designed and implemented a GUI Windows reservation schedule for their conference rooms.Skill set utilized: Pascal, Visual Basic 4.0, T-SQL, C, Access 2.0, Paradox, Windows 95Emphasys Software, Inc. May 1991 - January 1993Technical Support SpecialistConverted clients' business files from IBM S/23 to a newer operating system.Supported clients over the phone and modem; received four recognition awards.Skill set utilized: Workstation Basic, MS DOS, Novell, UNIX, AIX, viEDUCATION:B.S., Computer Science, University of Minnesota, Institute of TechnologyIntroduction to Programming with Python, New HorizonsMicrosoft BI Tools: Power BI for Excel Users, ONLC |
