Robert S.

Robert S.

.NET Developer / Programmer / Database Administrator

Green Lane , United States

Experience: 20 Years

Robert

Green Lane , United States

.NET Developer / Programmer / Database Administrator

72000 USD / Year

  • Immediate: Available

20 Years

Now you can Instantly Chat with Robert!

About Me

Programmer/Analyst/Consultant with a strong background in Database Design. Possess exceptional research, troubleshooting, and problem resolution skills, as well as extensive hardware, software, networking, and database administration capabilities. In...

Show More

Portfolio Projects

Description

.NET Developer, Consulting-Temp, www.rcstewartweb.com, Green Lane PA - Since May 2015.

Working in Computer Software, Banking, Entertainment, Manufacturing, Healthcare industries.

Senior Analyst Applications, Sands Casino Bethlehem , PA, 03/19 to present

  • Received Pennsylvania State Gaming License 3/11/19 - 3/11/24.

· Responsible for the miniatous, support and development of IBM ISERIES RPGLE, CLLE, programs running on a multiplatform client server Hotel, Gaming , Financial, Inventory management and Payroll systems.

  • Provide analysis and operational support between users and vendors for Infinium financial reporting and payroll, Stratton Warren Inventory management, Kronos timekeeping and Cognos reporting software systems.

Programmer Analyst, PMC Pharmacy, Horsham , PA, 06/18 to 03/19

· Worked with Microsoft Access, MYSQL, SQL Server Management Studio, Visual Studio 2017, C#, .NET, HTML, JCRIPT, Excel. Helping to support the daily operations of PMC’s Access/MSQL Pharmacy Management software, Multiple projects in SQL server, C# .NET and Website programming with Html, PHP, and OpenCart technologies.

Consultant Programmer temp, LevelOne LLC, Malvern PA , 12/2017

· Worked with SQL Server Management Studio, Visual Studio 2017, C# , MVC , Microsoft .NET, HTML, JCRIPT, Excel. Created Sequel Server database files by porting existing Excel programs for a C# MVC Company Reporting Recurring Tasks Asp.net system.

Programmer/Analyst temp, Univest Corporation of Pennsylvania, Souderton PA, 06/2017

  • Worked with SQL Server Management Studio, Visual Studio 2017, C# ,Visual Basic, Microsoft .NET, HTML, Excel. Crystal Reports. Helped support Asp.net Customer Relationship Management (CRM) systems and Jack Henry JHA AS/400 - Iseries Banking software.

Show More Show Less

Description

NET Developer temp, CMC Energy, Fort Washington PA, 12/2016

· Data Analysis and SSRS, SQL Server Reporting Services using SSMS , Microsoft Access, Microsoft Visual Studio, Visual Basic, SQL Stored procedures supporting E.R.M.S. management system written utilizing Microsoft Visual studio 2013, 2015 and Sequel Server data tools 2012.

Consultant NET Developer, Knex, manufacturing, Hatfield PA, 07/2016

· Programming for Toy Manufacturing Company – C#, Webforms custom written ERP system utilizing Microsoft Visual studio 2012 and Sequel Server management studio 2008.

Software Engineer, Clemens food group, Hatfield PA, 06/2015

· Software programming for Food Manufacturing Company to support custom ERP system written in Visual Basic .NET and Sequel Server Management studio 2008 which ran the day to day operations of the food manufacturing and reporting system.

Caring for loved one, full time - work from home parent Green Lane PA 04/2009 – 04/2015

Database Administrator, Cananwill Premium Financing, Hatboro PA. 06/2008 – 03/2009

  • Responsible for Security, Integrity, and Availability of production data for AS/400-Sequel Server 2005 premium finance systems using Aldon change management, AS/400 DB2 and Sequel Server T-SQL.
  • Monitor the completion status for daily, weekly, monthly database backups and maintenance programs.
  • Provide reporting for adhoc data requests using AS/400 COBOL, RPGLE, EXCEL and Crystal Reports.

Show More Show Less

Description

Database Administrator, Cananwill Premium Financing, Hatboro PA. 06/2008 – 03/2009

  • Responsible for Security, Integrity, and Availability of production data for AS/400-Sequel Server 2005 premium finance systems using Aldon change management, AS/400 DB2 and Sequel Server T-SQL.
  • Monitor the completion status for daily, weekly, monthly database backups and maintenance programs.
  • Provide reporting for adhoc data requests using AS/400 COBOL, RPGLE, EXCEL and Crystal Reports.

Consultant Programmer to GSI Commerce, Valley Forge PA. 06/ 2007 – 05/2008

  • GSI Commerce is a leading provider of outsourced e-commerce solutions that enable retailers, manufacturers

to operate e-commerce thru Java based websites that are interfaced with GSI’s Supply Chain Management

  • Responsible for analysis, design and program RPGLE e-commerce applications in an AS400 environment.
  • Trouble-shooting, debugging and implementing software code with ALDON change management system.

Interface Analyst Programmer, NextGen Health Care Information Systems, Horsham Pa. 03/2006 - 12/2006

  • Responsible for all HL7 Interface Analysis, installation, troubleshooting and ongoing customer support.
  • Plan, schedule and implement new installations through collaboration with customer management, technical and operational resources coordinated with third party vendor and Nextgen data systems interface resources.
  • Provide Microsoft SQL Server knowledge to create complex queries and install stored procedures.

Database Administrator, Abington Memorial Hospital, Abington PA. 05/2005 - 02/2006

  • Served as DBA for the implementation of CBORD Nutrition system and INFOGENESIS POS terminals.
  • Responsibilities include on call trouble shooting and problem resolution for daily operations, monitoring of server logs and backups, disk volume management and applying hot fixes and service pacts.
  • Provided backup and downtime procedures to ensure hardware/software utilization at maximum capacity and minimize loss of production time to users and adherence to HIPAA requirements.

Show More Show Less

Description

Consultant Programmer to Air Products & Chemicals, Allentown PA. 01/2003 – 08/2004

  • Completed programming revisions to over 300 Crystal Reports, using Oracle and MS Sequel Server databases.
  • Maintained intranet web pages for monthly reporting system for Semiconductor division.
  • Administer Hyperion / ESSBASE for Windows client-server databases for accounting departments.
  • Maintained existing VBA programs for creation of Excel reports for the accounting controllership department.

Senior Programmer / Analyst, for Consulting, Insurance and Manufacturing companies. 1985 -2002

  • AS/400 programming with RPG IV, RPGILE, DB2,COBOL400, Query400, DFU400, CLP, CLLE.

§ Design, Code and Test systems solutions based on requirement specifications.

§ Maintain system documentation (both within the code and within technical design documents

§ Working in Manufacturing environment using Mapics, Lawson, RPG400, CLP400 software systems.

Working in Insurance Financial environment using WINS, COBOL400 software systems.

Show More Show Less