PROFESSIONAL SUMMARY:

• Experienced in developing applications using ASP.NET 4.0, C# 4.0, MVC, Entity Framework, Angular, JavaScript, jQuery, Ajax.
• Experienced in SQL Server Database design, developing T - SQL queries, Stored Procedures, and Triggers to enforce business rules and logic on the server
• Interfaced with clients providing requirements analysis, documentation, timelines, project scope, and resolved day-to-day issues with emphasis on SDLC

TECHNICAL SKILLS:

Development Tools & Utilities: .NET 4.5, MVC4/5, Entity Framework, JavaScript, jQuery, ASP.NET 3.5, C# 4.0, VB.NET, SQL Server 2005/2017, SSIS, SSRS, Sybase, Oracle 11g, Crystal Report 11.0/2008, IBM Query, MS Access, VB6, Visual FoxPro 2.6/7.0

Applications:: MS Office 2012/2016, SharePoint, Team Foundation Server, Visual Studio 2005/2019.

Operating Systems: Windows XP/Vista/Windows7/8/10, Widows Server 2005/2016, UNIX.

Concepts:: Relational database design, programming and debugging

PROFESSIONAL EXPERIENCE:

Confidential, Chandler, AZ

.NET Developer

Responsibilities:

• Designed, developed and implemented web application with dynamically generated forms from Oracle database using MVC, Web API with Angular 8, jQuery, Bootstrap and CSS. Application is used for fulfillment processing and reporting. Utilized Repository and Factory patterns allowing for easy replacement of Oracle backend to SQL Server. Developed ETL processes using MS SQL 2016 and SSIS packages for daily imports. Created Windows Service app service and scheduled to run month end reporting.
• Developed CMS Web Site for ‘Fueling Our Schools’ company campaign using MVC5, jQuery, JavaScript with Ajax calls, Bootstrap, and CSS. Application was used to store information for each site to show compliance in registering for the program - such as Tax Forms, I9-Forms, site personnel. Site was also used to pull reports by store and business units.
• Developed several import/export utilities for the transfer of files up to 5GB utilizing Enterprise Library, ADO.NET, SSIS.
• Wrote highly configurable application in C# with data loading scripts including data transformations. Application was used for processing EDI files and replaced vendor software used for this task.
• Supported online content management portal and payroll applications.

Confidential, Chandler, AZ

NET Applications Developer

Responsibilities:

• Worked on Line of Business Applications implementing design changes and coding in ASP.NET, C#, MVC as well MS SQL.
• Enhanced Resource Management System tool adding custom validation to prevent incorrect records from getting added as well as bulk import features.
• Attended daily SCRUM sessions, design meetings and FSD meetings to ensure timeliness on delivering new enhancements on Confidential Security Software.

Confidential, Phoenix, AZ

.NET Applications Developer

Responsibilities:

• Design and develop line of business applications used by analyst in creating dynamic data driven insurance quoting web sites using MVC 4, jQuery, JavaScript, and SQL Server 2008/2012.
• Enhanced existing administrative tools written in MVC 4 and improved performance, reusability of code between applications, and overall appearance through CSS.
• Participate in SCRUM and code reviews on daily and weekly basis.

Confidential, Phoenix, AZ

.NET Applications Developer

Responsibilities:

• Worked with team in designing and developing application components and architectural proof of concepts for enterprise level aircraft maintenance system.
• Developed Data Access layer using Code First approach in Entity Framework and wrote services using WCF.
• Designed Mock Unit Tests utilizing dependency injection framework to test individual components and services.
• Participated in daily standup meetings, gathered requirements and helped with user story creation and prioritization as well as calculating project costs.

Confidential, Phoenix, AZ

.NET Applications Developer

Responsibilities:

• Developed new features in and maintained Department of Health Electronic Birth Registration system written in .NET 4.0 using MVC3, Oracle 11g stored procedures.
• Developed application to automate monthly benefits reporting using Entity Framework 4.0, LINQ to Entities and Oracle 11g stored procedures.
• Developed additional features using web services, ASP.NET 4, C#, SQL 2008 stored procedures for Department of Developmental Disabilities Professional Billing System application.
• Developed custom utilities for automating installation of 3rd party software and for data extraction using .NET C#, SSIS Packages.
• Developed SQL 2008 Stored Procedures use for negative testing of HIPPA 5010 transaction sets.
• Worked with QA and project managers in documenting and testing X12 EDI transactions against current guideline releases.
• Document, automate and troubleshoot installation processes for third party software.

Confidential, Phoenix, Arizona

Applications Developer

Responsibilities:

• Create/analyze data extracts and determine accuracy of results using .NET C#, SSIS Packages.
• Developed reconciliation report according to specifications pulling data from warehouse and multiple vendors using T-SQL, Stored Procedures use for improving the accuracy of Low Income Subsidy members.
• Developed data masking function in C# used for submission of test files.
• Worked with test leads and project managers in all aspects of SIT testing for X12 EDI transactions ensuring HIPAA 5010 compliance.

Confidential, Tempe, Arizona

.NET/Database/Developer

Responsibilities:

• Worked with team in developing a data access layer, business logic layer and databases for enterprise level application used in legal industry using ASP.NET, .NET 3.5, SQL 2008.
• Created SQL 2005/SSIS Packages for moving data into test regions.
• Created business objects, scripts and scripting tool for 3 party database vendor using C#, SQL Server 2008, T-SQL, SQL Azure.
• Actively participated in all facets of Scrum methodology including daily sprint meetings and monthly architect meetings.
• Created SQL 2008 database to integrate with CRM sales tracking and licensing information.
• Developed, tested and documented business objects using .NET 4.0, CSLA framework and WPF for presentation layer - also gained exposure to MVC3 framework.
• Wrote utility in C# to persist computer, disk, and processor id information to SQL 2008 database via stored procedures and ADO.NET used for licensing model.

Confidential, Phoenix, Arizona

Database Developer

Responsibilities:

• Created Access databases used for the reporting of Medicare Recipients coverage and eligibility information to government agencies and migrating legacy systems to VB/.NET and C#.
• Enhanced and corrected several complex reporting issues with in existing applications freeing up resources and allowing business analysts to focus on separate issues.
• Developed and gathered requirements for pharmacist technicians on new automation tool used for validating data passed from third party clients to reporting databases eliminating the need for manual processing of spreadsheets.

Confidential, Phoenix, Arizona

Database Analyst

Responsibilities:

• Responsible for the development of Monthly Customer Statements reflecting all patient account activity including payments, adjustments, and account balances for a Mail Order Pharmacy.
• Worked with Stored Procedures in Sybase that pulled all applied and unapplied General Ledger.
• Transactions, summed information into appropriate buckets, and inserted billing statement data into final detail and summary tables for reporting.
• Wrote scripts and T-SQL code in Sybase to validate results and prepared documentation for project.

Confidential, Phoenix, Arizona

SQL/Access Developer

Responsibilities:

• Created SSIS Packages utilizing VB.Net script components when necessary for data transfer along with front-end screens and reports using Access VBA, T-SQL, Stored Procedures, and SQL 2005/SSRS.
• Responsible for the support of MS Access, SQL Server, and Web development tools for both external and internal clients. This involved requirements gathering, analysis, design, coding, full documentation, and testing of several claims processing applications.
• Participated in daily Scrum sessions that consisted of - identifying and removing impediments and burndown charts,
• Re-wrote Client-side Microsoft Access application in C# and ASP.NET utilizing LINQ to SQL filter data as well as custom derived types.
• Built credibility, established rapport, and maintained communication with several major clients at multiple levels, including those external to the organization.
• Fully automated a month end process that transformed data into a variety of summary reports and graphs for Month End Processing (saving company 8 hours of manual input each month).