SUMMARY:

• Uses a proprietary language VGL to generate pharmaceutical protocol reports and labels.
• Queried and modified tables in Oracle.
• Used GIT as version control system and Visual Studio 2019.
• Used Xaml and C# .net to design productivity applications that generated VGL code.
• Used MS SQL for backend to Xaml C# application.

TECHNICAL SKILLS:

Languages: C#.net, VB.net, VB6, Angular 9, VGL, PowerShell, Python, VBA Macros, TSQL

Web Technologies: ASP.NET, HTML, MVC3/4/5 with Razor, WPF, XAMLVisual Studio 5 - 19 (Azure DevOps), IIS, SharepointTeam City, TFS, Tortoise, SVN, GITHTML3/5, CSS, JavaScript, JQuery, Bootstrap, Kendo,XML, Web Services, AJAX, JSON, AJAX Control ToolkitWeb API, WCF, Azure

Reporting: SAS, SSRS, Crystal Reports

Database: SSMS, SQL Server 2000/2017, Oracle,DTS, SSIS, Access, LINQ To SQL, LINQ To Entity,RavenDB, Solr, Toad, SAS, TeraDataCognos, Avaya Call Center Data, Orbit data WarehousingProject Management: Jira, ServiceNowHays Talent, IQVIA (Charlotte, NC )

PROFESSIONAL EXPERIENCE:

Confidential

.NETDeveloper

Responsibilities:

• Wrote C# code to create a self service password change feature for all Accucare System Jurisdictions
• Create SSRS reports for the Texas Medicare Accucare System
• MVC Entity Framework updates
• Modified SQL database tables and TSQL to add custom parameters for selected USA states.

Confidential (Charlotte, NC)

.NETDeveloper

Responsibilities:

• Legal department case management system application for ediscovery.
• Added to datatype selection Proofpoint searches for Bloomberg data.
• Added to datatype selection searches for case related email.
• Used Angular 9 with Core using Kendo and inhouse APIs for a 3rd party request screen.
• Wrote Angular 9 TypeScript controls ( dependency injection )
• MVC Entity Framework updates
• Coding for features related to preservation notices, remediation, cross border checks. Using C# with Workflow service.
• Managed extension searches (example tif, tiff) using C# and stored Procs.
• Created SSRS Reports for Vendor Engagement reporting.

Environment: Angular 9, C#, ASP.NET, Visual Studio 2019 (Azure DevOps), SSMS,MVC, Jira

Confidential (Des Moines, IA)

.NETDeveloper

Responsibilities:

• Created SSIS scheduled tasks and SSRS Reports of Real Estate Sales to generate Insurance Leads.
• Used CTE SQL in Stored Procedures.
• Used SSRS to generate form letters.
• ASP.NET apps for real estate applications.
• ASP.NET app with XML handler.
• Used PowerShell for real estate photo transfers.
• Used VB.net / ASP.net with HTML and CSS to create an application to allow business users to modify Newsaper Ad content.
• MVC Entity Framework updates
• Optimized SSRS within ASP.net speed up screen loads.

Environment: ASP.NET,C#, Visual Studio 2015, SSMS, MVC, Sharepoint, HTML, CSS

Confidential (Des Moines, IA)

.NETDeveloper

Responsibilities:

• Angular used for Past Due reports for Citi loans.
• Created SQL queries and stored procs to update bill printing data.
• Wrote MVC5 Webgrids to monitor printing queues.
• Wrote MVC5 Webgrids for searching worldwide customers of Confidential .
• Wrote jQuery for custom controls and modifying Webgrids.
• Used PowerShell for scheduled tasks.
• Used Angular JS and Angular 2 for controls for loan searches.
• Used SSIS for transfer across servers.

Environment: ASP.NET, Angular,C#, WPF, Visual Studio 2013, HTML5,MVC5, jQuery, SQL Server, HTML, CSS

Confidential (Lincoln, NE)

.NETDeveloper

Responsibilities:

• Modified and ran T-SQL to update Bookstore e-Commerce sites.
• Used Knockout for e-Commerce front ends.
• Customized Bookstore Websites modifying ASP.net, HTML and CSS.
• Used PowerShell and manually modified IIS to load-balance store sites.
• Repaired code to enhance the bookstore options using jQuery and C#.
• Used Onion Architecture and Inversion of Control to write a program to maintain bookstore site parameters. Used MVC Entity Framework.
• Ran routines and manually moved sites to a new hosting company.
• Updated Bookstore Image Server. WPF, XAML, SIlverlight and RavenDB.
• Modified e-Commerce payment services applications to meet PCI requirements.
• Used Amazon API for cross sales of books.

Environment: C#, WPF, Visual Studio 2013, HTML5,MVC5, jQuery, SQL Server2012, Solr, RavenDB. Team City, TFS, Knockout, Bootstrap, Azure, Sharepoint

Confidential (West Des Moines, IA)

.NETDeveloper

Responsibilities:

• Wrote C# code for a CMS system for Association of Boards of .
• WroteC# code using Kendo controls for Confidential website.
• Used Entity framework MVVM
• UsedAJAX Control Toolkitcontrols including Accordion control.
• WroteTSQLqueries in SQL Server 12.
• Deployed web applicationin production server.
• Wrote and modified CSS to design and update web pages.

Environment: ASP.NET, HTML, CSS,C#, Visual Studio 2012, HTML5,MVC4, jQuery, SQL Server2008, Linq to Entity.

Confidential (West Des Moines, IA)

.NETDeveloper

Responsibilities:

• Wrote Calculator routines to project annuity values for insurance agents and annuity owners.
• Used the Service Factory Pattern to share code between the different calculator functions.
• Obtained data from the Fujitsu COBOL functions.
• Replaced WCF REST and handlers with Web API.

Environment: ASP.NET,C#, Visual Studio 2012, HTML5,MVC4, Service Factory Pattern, WCF, Web API, Re-Sharper, VB6 to Fujitsu COBOL API connection, SQL Server2008.

Confidential (Des Moines, IA)

.NETDeveloper

Responsibilities:

• Used C# to write Control logic for the Tax and Tags Web Application
• Used jQuery and Twitter Bootstrapto emulate the Facebook Wall to track responses to trouble tickets.
• Modified Linq to Entity Tables.
• Used Razor to build input validation pages.

Environment: MVC3,Visual Studio 2012,C#, Repository Model, SQL Server2008Linq to Entity, jQuery, Azure Cloud.

Confidential (West Des Moines, IA)

.NETDeveloper

Responsibilities:

• UsedLINQ TO SQLto obtain data from SQL server database.
• Maintained ISSAC Applications including FNMA and FHLMC.Shared in production monitoring and troubleshooting.
• Wrote complex queries in SQL usingADO.NETfor ETL FHLMC regulatory requirements.
• Used SSIS for transfer across servers.
• Converted VB6 apps to C#.net.This assignment involved over 100 programs assigned to multiple programmers.
• Assisted in finding ways to shorten the tasks by using templates, shared routinesand code generating scripts.
• Wrote C# code for the FNMA Call-In application.
• Used Python to search the Active Directory for designated file types.
• Worked on an agile team which was able to meet time goals on multiple sprints.
• Used DevExpress controls for FHLMC web app..
• Used Bulk Insert from Linq to Entity to speed-up writing to the databases.
• Wrote a routine to parse input text files with varying formats and load the data into a SQL database.

Environment: Visual Studio 2005/10/12,C#, VB.net, VB6, SQL Server2008, Linq to SQL, Linq to Entity, ASP.net, HTML, CSS, jQuery, DevExpress, Sharepoint, TeraData

Confidential (West Des Moines, IA)

.NETDeveloper and Analytics Support

Responsibilities:

• Programmed in SAS for the Loss Mitigation team.
• Ran SAS production for the Loss Mitigation team.
• Created Ad Hoc SSRS reports.
• Loss Mitigation Active Inventory:
• Created a C# Web application that replaced an Excel VBA application.
• Used jQuery and Linq to SQL to make the Grid views to be dynamic.
• Used PowerShell to read XLS and csv into .net app.

Environment: ASP.NET,Visual Studio 2005/08,C#, SAS, SQL Server2008, SSRS, Linq to SQL, jQuery.

Confidential (Des Moines, IA)

.NETDeveloper

Responsibilities:

• Wrote MVC C# and client side C# within aspx pages and C# control and views.
• Wrote and modified CSS to design and update web pages.
• Used jQuery on client side validation and building dynamic lists.
• Used MVC written in Nhibernate
• Used jQuery with Ajax to connect to Nhibernate models and SQL databases.
• Tested database logic with Nhibernate .
• Modified SQL tables and wrote T-SQL stored procedures.
• Used Firefox FireBug to correct CSS problems.

Environment: ASP.NET,Visual Studio 2005/08,C#, SQL Server2008, SSRS, jQuery, FireBug, HTML, CSS

Confidential (Des Moines, IA)

.NETDeveloper

Responsibilities:

• Wrote C# ASP.net application coding.
• Added Grid view features with event handling.
• Worked staff to identify and correct problems in the Pawn Transactions Importing process.
• Modified SQL tables and wrote T-SQL stored procedures to maintain the Intergraph database.
• Modified XML parameters and IIS Services scripts to schedule Pawn Import data from pawnshops.

Environment: ASP.NET,Visual Studio 2005,C#, SQL Server2008.

Confidential (West Des Moines, IA)

.NETDeveloper

Responsibilities:

• Updated about 80 DTS packages to run in backwards compatibility from SQL 2008.
• Created additions to the centralized settings configuration file.
• Converted SSRS components.
• Wrote a custom logging system to be used with the SSIS.
• Converted DTS packages to SSIS. (Including the load of the loan origination file.)
• Wrote a C# routine (ran in SSIS) that modifies SSIS XML parameters.
• Replaced ActiveX scripts with VB.netRoutines including creating File Share Objects.

Environment: ASP.NET,Visual Studio 2008,C#, SQL Server2000/08, SSIS.

Confidential (Des Moines, IA)

.NETDeveloper and IVR Programmer

Responsibilities:

• Created a SSIS package for Enrollment.
• Included a SQL Cursor loop for building a file of variable length records.
• Updated the HTML for the OBS (Online Business Summary) to meet new insurance business requirements using WPF.
• Wrote C# Intranet applications: Calendar control for Want Ads, Human Resource management and
• Modified SharePoint C# applications.
• Modified and supported VB6 applications.
• Wrote scripts for the IVR application.

Environment: ASP.NET,Visual Studio 2005,C#, VB6, WPF, SQL Server2005/08, SSIS.

Confidential (Des Moines, IA)

Access Programmer

Responsibilities:

• Wrote Access queries Currency Swap receipts.
• Converted Access Queries to SQL Stored Procedures.
• Converted Queries to C# routines.
• Created SSRS reports for tracking Currency Swaps.

Environment: ASP.NET,Visual Studio 2005,C#, Access, SQL Server2000/05.

Confidential (West Des Moines, IA)

Operations Analyst

Responsibilities:

• Ran weekly and monthly production Excel Reports for the Payroll and Benefits call center.
• Wrote VBA to populate Excel reports with input files, replacing the manual process.

Environment: Excel, VBA, Crystal Reports, Cognos.

Confidential (Des Moines, IA)

COBOL Lead Programmer

Responsibilities:

• Analyzed and programmed an inventory system in Access for Federal Surplus Property.
• National Motor Voter Bill. Registration CICS program.
• Used VSAM alternate indexes. Utilized XPEDITOR to test the CICS program (approx. 20 screens.)
• Lead Programmer and Analyst. Directed programmers in the development of the Voter screens.
• Rewrote Election Results Reports utilizing COBOL. Used R-SCRIPT to allow for the transfer of data from Iowa client counties.
• Wrote ClCS programs for the Governor's Budget system.
• Programmed the WIC (Women, Infants, and Children) ADSO/IDMS application (comprised of 22 screens.)
• Wrote COBOL IDMS programs for Townships and County Budgets.
• Wrote COBOL programs and ran production for Iowa College Aid Scholarship program asThe primary analyst for the Scholarships program.
• Maintained and modified IDMS programs for the RISK system ( Confidential 's self-insurance system.)Used PowerBuilder to convert RISK system from ADSO.Tested the RISK system for Y2K compliance utilizing DataAger.Maintained PC Vehicle Dispatch Warranty programs that originated from car dealerships.
• Modified ClCS programs for the Fixed Assets Inventory system.

Environment: COBOL, CICS, ADSO, IDMS, VSAM, TSO, Xpeditor.