Sql Server C#
Resume:
FRANK PHILIPS
www.linkedin.com/in/frank-philips-*b14201a
469-***-****, ********@*****.***
Summary
Sr. Software Engineer with over 20 years of diverse technical experience, including C#, .NET, Web Services, Web/API, SQL Server 2000-2014,
Experience in software development life cycle involving Requirement analysis, Design, Development, Coding, Testing, Maintenance, and Implementation of various applications based on Client Server, Web Applications and Business Solutions using C#.NET, .NET 4.5/4.8, VB6/ CORE 3.1/ .Net 6, .Net 8, ADO.NET, ASP.NET, MVC, Design pattens, IIS, Entity Framework, LINQ, SQL Server, IIS, Razor, DOM skills and Visual Studio.
Full-stack technical expertise in developing applications, databases, and architectures.
Good experience with JavaScript, React, angular 16 and Typescript.
Strong experience with deploying Azure from scratch and working with docker.
Expert with MySQL, SQL server MongoDb, Db2, and Cosmos DB, PowerBI
Integration tools BizTalk 2020 and Azure Integration Services.
6 years of integration experience.
PROFESSIONAL EXPERIENCE
Cincinnati Contracting Services (February 2023 to Present)
Integration Software Developer
Working with the latest version of. Net 7/8
Responsible for rewriting COBOL code to C# and Python scripts, and React 18.
Converted Stored Procedures from DB2 to SQL Server 2022
Responsible for converted middleware MQSeries to Storage queues and Service Bus queues and then Installed RabbitMQ in AZURE
Developed and Upgraded applications to .net core for cross platforms functionary Docker, Kubernetes, Windows, and Linux.
Created new microservices and RESTful API’s
Convert Basic Assembler Language programs to C#.
Used async and await keywords to create multithreaded processes.
Used multiple features of Azure for .NETCORE.
Proficient with Software development methodologies like Waterfall, Agile, CI/CD.
Development of UI using angular 16 and middleware using web Api.
Created necessary SQL Server table, and model objects in .NET.
Created Object Relational Mapping (ORM) using ADO.NET, nHibernate, Entity Framework, LINQ, and Lambda expressions.
Worked closely with various business and technology stakeholders.
Create and execute unit and integration test plans.
Perform Agile testing – create and execute test scripts. Exclusively responsible for the design, develop, deploy, and support stored procedures.
Upgraded (H.I.S.) Host Integration Server 2016 to Host Integration Server 2020 and BizTalk Server 2016 to Biztalk Server 2020.
Converted legacy Mainframe COBOL/DB2 system to .NET Core, C# Windows Forms and SQL Server 2022
The system utilizes an Inversion of Control (dependency injection), factory pattern, design patterns, and singleton pattern.
Visual Studio 2022, C# .Net 4.5, DevOps, Security DevOps, Get, CI/CD, SQL Server 2022, batch job processing, LINQ, and XML, Endeavor.
Created SQL stored procedure, Indexes, and performance tuning.
Ensure that deployed software is scalable and reliable.
Added new Integrations with BizTalk 2020, Setup new severs for new integrations using MSMQ adaptors.
Set up Cosmos DB to hold user Id and passwords for system entry.
Global Payments, Plano, TX (December 2020 to February 2023)
Senior Software/Integration Developer
Lead a team of developers to convert Mainframe COBOL to Microfocus COBOL converted DB2 stored procedure to SQL Server 2022, converted CICS map to UI screens.
Converted assembler IO modules to APIs, and upgrading middleware MQ Series to Rabbit MQ.
Established and maintained a close working relationship with various business and technology stakeholders,
Led the team, helped developers ramp up and performed code reviews.
Helped deploy and ensured that deployed software is scalable and reliable.
Created and executed unit and integration test plans.
Updated necessary SQL Server table, and model objects in .NET.
Created Object Relational Mapping (ORM) using ADO.NET, nHibernate, Entity Framework, LINQ, and Lambda expressions.
Develop C# WebApi services in an Agile environment.
Extensively used the repositories like Github and BitBucket.
Worked closely with various business and technology stakeholders.
Followed 2-week sprints, performed Agile testing, created, and executed test scripts and Python.
Exclusively responsible for the design, development, deployment, and support stored procedures.
Generated event messages and dropped them on the Azure service bus.
Extensively used Visual Studio 2019, 2021, C# .Net 4.0/4.5, DevOps, Security DevOps, Azure, react, JavaScript, angular 12, Get, CI/CD, SQL Server 2017, batch job processing, LINQ, JSON, XML, GCP, ChangeMan ZMF.
Created SQL stored procedure; Indexes and performance turning.
The system utilizes an Inversion of Control (dependency injection), factory pattern, and singleton pattern.
Created new integration using BizTalk Server 2020 ESB and Azure Integration Services
Used Crystal Reports Viewer to adjust formatting of the reports.
Stream Energy (February 2016 to December 2020)
Senior Integration Developer / Senior Software Developer
Managed and maintained a close working relationship with various business and technology stakeholders.
Created RESTful APIs to connect with back-end Repositories and SOAP services.
Lead a team of 4 developers, helped team with new deployments, ensured deployed software is scalable.
Created and executed N- unit and integration test plans.
Responsible for designing, developing, testing, and deploying an enterprise system that runs in Microsoft Azure which includes websites, web apps, Api apps, windows services, web services, middleware used Azure Service Bus queueing and client applications.
Created necessary Azure SQL database, table, and model objects in .NET.
Created Object Relational Mapping (ORM) using ADO.NET, Entity Framework, LINQ, and Lambda expressions.
Develop C# Web Api services in an Agile environment.
Performed performance and code reviews for team.
Created NoSQL databases (Table PartitionKey and RowKey) for User sign in.
Perform Agile testing – create and execute test scripts Exclusively responsible for the design, develop, deploy, and support RESTful, and SOAP services.
Generated event messages and dropped them on the Azure service bus.
Visual Studio 2019, C# .Net 4.0/4.5, DevOps, Get, CI/CD, SQL Server 2017, Ninject, Azure Portal/Functions, Batch job processing, Azure Logic Apps, WebApi, LINQ, JSON, and XML.
Created SQL stored procedure; Indexes and performance turning.
The system utilizes an Inversion of Control (dependency injection), factory pattern, singleton pattern.
Converted CICS programs to Cone
Created Logic App to integrate data partners.
Created reports with Crystal reports with the Visual Studio 2016 version.
QT Technologies (September 2012 to December 2015)
BizTalk Administrator - Developer
Developed C# Web Api services in an Agile environment.
Wrote new snap-in as we brought new airlines online.
Wrote an error handling system, as errors incurred the system would send message to the enterprise service bus.
Wrote a windows service to read messages from middleware IBM MQ queues and MSMQ queues then call the WebApi to validate and load it in a SQL Server database.
Messages are sent directly to fueling computers to fuel the aircraft.
The system utilizes an Inversion of Control (dependency injection), factory pattern, singleton pattern.
Software used Visual Studio 2010/2012/2013, C# .Net 4.0/4.5, and BizTalk 2010/2013/2013 R2 64 bit.
Created Object Relational Mapping (ORM) using ADO.NET, Entity Framework, LINQ, and Lambda expressions.
Created new and updated Biztalk Integrations
Previous Consulting Assignments (Project details available upon request)
Commercial Metals Company (June 2011 to June 2012)
Senior Software Developer/Biztalk Developer-Admin
Responsible for installation and configuring of BizTalk 2010 in Production, Test, Pre-Production, and development.
Wrote interfaces the used the BizTalk Enterprise Service Bus.
The interface was exposed as a WCF HTTP interface using BizTalk 2010.
The messages are taken in from a SharePoint 2010 frontend application and passed to SAP via BizTalk 2010.
The BizTalk 2010 communicates with the SharePoint in WCF and SAP via the BizTalk SAP adaptor.
Programs were written in Visual Studio 2010, C# .Net 4.0, and BizTalk 2010 64 bit.
Slalom Consulting (May 2011 to June 2011)
Senior Software Developer
Responsible for installation and configuring of BizTalk 2010 in Production, Test, Pre-Production, and Development.
Also, wrote interfaces the used the BizTalk Enterprise Service Bus.
Help write documentation for best practices for the development of the BizTalk application.
Installed BizTalk 2010 adaptors SAP, Oracle, SharePoint.
Installed Visual Studio 2010, C# .Net 4.0 and BizTalk 2010 64 bit.
Avanade (July 2010 to May 2011)
Software Developer
Exclusively responsible for integration application programming and installation of the interfaces to the Dealer Management System.
This system utilized (H.I.S.) Host Integration Server 2010 BizTalk 2010 to replace AS/400 using SNA.
The HIS computer would communicate with the Mainframe via SNA over TCP/IP.
This would be exposed as both WCF and Web Services interfaces.
Designed and coded the wrappers for COBOL code moved off the AS/400 to communicate with the HIS computer.
The BizTalk 2010 communicates with the Mainframe in EDI version 200.
Programs were written in Visual Studio 2010, C# .Net 4.0 and BizTalk 2010 64 bit.
Matrix Resources (February 2010 to June 2010)
Senior Software Developer
Exclusively responsible for integration application programming and installation of the interfaces to the Order management system.
This system utilized a windows service to pool an Oracle database for orders that are ready to be sent out.
Once orders are in staging tables, the BizTalk Server would pick them up and send them to the WCF client.
Also created a WCF client for return messages.
The programs in C# .net, BizTalk 2009, WCF.
Programs were written in Visual Studio 2008, C# .Net, and BizTalk 2009.
Vaco Technologies (March 2009 to February 2010)
Senior Software Developer
Exclusively responsible for integration application programming and installation of the interfaces to the Tarrant Court system.
The Court system is on a z/OS Mainframe using C.I.C.S. (H.I.S.) Host Integration Server 2009 to communicate with windows form via BizTalk 2006 R2.
This system allowed you to assign booking numbers, send fingerprints to the state and F.B.I.
Also, it allowed you to browse the F.B.I database.
The programs both in C# .net, BizTalk 2006, WPF, and WCF.
Programs were written in Visual Studio 2008, Visual Studio 2008, C# .Net and BizTalk 2006.
Tyler Technology, Inc. (April 2008 to December 2008)
Senior Software Developer
Exclusively responsible for integration application programming and installation of the interfaces to the Odyssey court system.
The interfaces will communicate with external systems like C.I.C.S., AS/400 and mainframes.
The interfaces output file drop to local folder.
The input to Odyssey was via .net web services.
Created testing tool to verify that the interfaces were working.
The web services were both in C# .net, BizTalk 2006, and WCF.
Programs were written in Visual Studio 2008, Visual Studio 2008, C# .Net and BizTalk 2006
Pay Day One, Inc. (October 2007 to April 2008)
Software Developer
Exclusively responsible for redesigning the enterprise service BUS, the BUS utilized several Microsoft, and non-Microsoft products.
The BUS uses a product called Neuron Enterprise Service Bus, and BizTalk Server 2006.
The features of the BUS are to talk to third party vendors such as Trans Union, Equifax, and Experian for credit information.
It also communicated with Department of Homeland Security to search the terrorist database.
These programs were exposed as web services and WCF programs.
The web services were both in C#, BizTalk, and WCF. Programs were written in Visual Studio 2005, also converted Delphi code to C# Windows Forms and .Net.
RamQuest, Inc. – October 2004 to September 2007
Senior Software Developer
Exclusively responsible for installing, maintaining and implementing .Net Web Services to expose varies title company data for Land America Title Company. The data is store in SQL Server 2000 and SQL Server 2005 data bases. In all there were 500 to 600 Web Services. About 120 programs were developed in BizTalk 2004. BizTalk 2006 conversion was started on 6/2007. The web services were both in C# and BizTalk. Programs were written in Visual Studio 2005, also converted Delphi code, and VB6 to C# and .Net.
Department of Defense - January 2002 to October 2004
Senior Software Developer
Exclusively responsible for installing, maintaining and implementing BizTalk 2002, 2004 message switching applications. This application utilized comma-delimited data from United States Air Force bases and loaded them into SQL Server data bases. Developed applications to split the suspended queue data and send it to the individual Air Force personal via email.
Wrote Web Service to expose BizTalk orchestration. Converted Visual Basic 6, BizTalk 2002 code to C#, .Net and BizTalk 2004. Added SQL Server 2000 adapter to existing web services. Added SMTP adapter to new web services. Converted all existing code from Visual Basic 6 to C# Windows Forms and .Net.
Installed BizTalk 2004 enterprise wide and began migration of BizTalk 2002 applications. Upgraded operating system from Windows 2000 Advanced Server to Windows 2003 Server enterprise edition.
Created new web service for ticket database in c#.
Converted CICS and DB/2 to C#, ASP.NET, ADO.NET and SQL SERVER 2000
Created new channels and ports for the BizTalk 2002
Mapped data using the BizTalk Data mapping program.
Created new AIC for validation.
Created BizTalk Web Services.
Provide on-call support 24 hours a day, seven days a week.
Install and fully configured z/OS 1.3.
Used SMP/E to install and configure NETVIEW 1.3, CICS41, TS13, TS22 View Direct 6.2
Defining LPARs for Production and test.
Use HCD to configure new tape drives (IBM 3490), DASD (3390-9), LAN Card (3088).
Use SMP/E the perform maintenance on z/OS 1.3 and CICS TS13
Configured HIS (Host Integration Server) 2000.
Converted 200 COBOL report writer to COBOL V3.1.
Upgraded SNA Server 4.0 to HIS 2000.
Created XML data file between MVS systems and Biztalk.
Configure new display and independent PU’s .
Microsoft, Inc. (June 1999 to December 2001)
Systems Programmer
Converted CICS and DB/2 to ASP.NET, ADO.NET and SQL SERVER 2000
Created new channels and ports for the BizTalk 2002
Mapped data using the BizTalk Data mapping program.
Created new AIC for validation.
Created BizTalk Web Services.
Provide on-call support 24 hours a day, seven days a week.
Used SMP/E to install and configure z/OS 1.1, NETVIEW 1.3, CICS41, TS13.
Use HCD to configure new tape drives (IBM 3490), new DASD (3390-9), and LAN Card (3088).
Upgraded SNA Server 4.0 to HIS 2000.
Configured HIS (Host Integration Server) 2000.
Coded new system in C#, C++ and windows forms.
Systems were written for .net Framework 1.0.
Configured BizTalk Server to communicate with IBM Mainframe via MQSeries.
Installed and fully configured MQSeries 1.2, 2.1 and 5.2.
Installed and fully configured OS/390 2.7, 2.9, 2.10 and z/OS1.1.
Installed and fully configured CICS/TS 1.3 and 2.1.
Installed and fully configured DB/2 5.1, 6.1 and 7.1.
Installed and fully configured IMS 6.1 and 7.1.
Installed and fully configured JES 328X 3.1.
Installed and fully configured Netview 1.3.
Installed and fully configured TCP/IP for OS/390 and z/OS.
Installed and fully configured ADCD 07, 09, 10 and z/OS 1.1.
Wrote utilities to communicate from Windows to the IBM Mainframe in C#.
Setup BizTalk Server 2000 to communicate with the IBM Mainframe via MQSeries.
Set up SQL Server 2000 to communicate with IBM DB/2 databases on the Mainframe.
Converted COBOL to Micro Focus Cobol programs.
Created VTAM parameter on the IBM MAINFRAME for the HIS.
Computer Link, Inc. – November 1998 to March 1999
Consultant Systems Programmer
Worked on Year 2000 conversion project.
Responsible for the conversion of ASSEMBLER and COBOL II programs to year 2000 compliance.
Formatted reports and expanded dates.
Performed test evaluation, program changes unit and system testing of batch processing.
Re-wrote ASSEMBLER interface modules from 370 ASSELBMER to XA.
New Boston Systems – July 1998 to November 1998
Consultant Systems Programmer
Assigned to the Sabre Group’s ticketing project.
Responsible for the conversion of BAL PL/I and COBOL II programs to year 2000 compliance.
Formatted reports and expanded dates.
Performed test evaluation, program changes unit and system testing of batch processing.
Interfaced reformatted TPF RTA ticketing tapes to VSAM files.
Education and Certificates
Master of Science, Computer Information Technology Rochville University, 2008
Bachelor of Science, Aviation Management Pacific Western University, 1995
Microsoft Certificates: MCPD 2.0, 3.5, 4.0, MCITP BizTalk 2010, MCITP Database Developer 2008, MCSE 2000, MCDBA 2000, MCSA 2000
Contact this candidate