MARIO E. STERN

ad0nvi@r.postjobfree.com

860-***-****

TECHNICAL SKILLS

Programming Languages: MS .NET 2017 C#, VB.Net 2013, 2010,2008, TFS, Azure, AWS, SSIS/DTS, SSRS, MVC 3, MVC 4.5, JQuery, Angular,js, Node,js, DevExpress, AJAX, .NET C#, C/C++, XML, ASP.NET, .NET Visual Basic, Java, JDBC, HTML, JavaScript, CSS, DHTML, Classic ASP 4.0, Crystal Reports, Active Reports, IBM WebSphere, PHP, CVS, XSLT, AJAX, MS Access, ClearCase, LDAP, NUnit, OOP, OOD, Git, VSS, Mongo DB, SDLC

Operating Systems: Windows 2010, Windows 8, Windows 7, XP, IIS, UNIX

Databases: MS SQL Server 2, Sybase 11, DB2, Oracle 8i, Oracle 9i, Oracle 11i

Professional Affiliation: Member IEEE

EXPERIENCE

General Dynamics Electric Boat, Groton, CT Feb 2021 – Mar 2023

Java web development with a JSP front end with Oracle DB hosted on Oracle WebLogic Web Host Server.

The application is used on a US Navy research submarine to track requisition items onboard also a shore based system that correlates the same functional ability on shore.

Investigate production code to find and fix processes errors as reported by the business users.

Virtusa Ins, Windsor CT, Nov 2019 – Dec 2020

.Net Azure Cloud Architect

C# API with Entity Framework development with Oracle DB backend and React.js deployment to Azure Gov cloud.

Working with customer in discovery and feature mapping to arrive at the total development effort and subsequent cost for new application development,

Investigate production code to find and fix processes errors as reported by the business users.

Travelers Insurance, Hartford, CT / Cognizant Apr 2019- Nov 2019

BOND BPS Software Developer Consultant

Part on Bond Production Support team for Travelers, Bond Insurance Division

Direct support of trouble shooting various batch synchronization a that support the BOND sales.

Use .Net the troubleshoot and formulate workaround processes to code changes that are too complex to implement as a quick fix.

Design and implement complex SQL quarries to track business rules affecting data.

The database is hosted on AWS data service.

IMCORP Corp, Manchester, CT July 2017- April 2019

Software Developer –Consultant

MVC Web application that implements complex business rules for IMCORP’s power signal analysis.

.NET Web MVC 5.0 application development with My SQL database support.

The application is hosted on Rackspace Web Service

.

UHG United Health Care / INSYS March 2017 – July 2017

Analyzing business application requirements for functional areas such as finance, marketing, and human resources.

• Working on the design, development, documentation, analysis, testing and modification of computer

systems, based on system design specifications.

• Writing program code, testing, and debugging software applications

• Recommending system changes and enhancements

• Documenting software specifications

Polamer.US, New Britain, CT April 2016-March 2017

Software Developer –Consultant

NET C# application development. C# API application interface design and implementation.

Complex MS SQL cursor operation to combine diverse data tables into desired configurations to implement business rules.

.NET Web application development with MS SQL database support.

The application and SQL database hosted on MS Azure Web Service.

JavaScript Canvas used to implement graphs to run on terminals throughout the facility to show device status of the production CNC machines.

WCF service deployed on a IIS Wed Service,.\ Agile TDD .NET 2015

American Professional Computer / Kaman –Bloomfield, CT

Software Architect \Developer –Consultant Feb. 2015 –March 2016

Created command build files to create Java JAR and WAR file for deploying on Apache. The application tracks Kaman’s supplier deliveries utilizing an Oracle 11i database.

Win Form application development with MS SQL database support.

Agile TDD .NET 2015 MVC 4.5 application development. I am involved in the design and implementation of production management system on Kaman’s Joint Programmable Fuse. The system utilizes touch screens and barcode readers to read in data as a product is assembled. The data is stored and retrieved from a MS SQL 2008 R2 database server. I designed the database and the table relations. I also designed and implement the GUI and the classes that support the business logic and data retrieval and insertion.

TFS 2013 used for saving of source code.

Ranstand Corp. – Fiserv- Glastonbury, CT August 2014-February 2015

Software Developer –Consultant

PrintNetT and Agile TDD NET 2013 MVC 3.0 C# developer on Fiserv’s FOS team.

Wrote functions in.NET C# to read from text metadata file and output formatted XML files. The application takes data presented in XML and formatted into GUI layout in native TNO file output. The TNO input issued as Fiserv’s monthly banking and financial statement that are printed and mailed for Fiserv supported client Banks and Credit Unions.

Part of the development teams that implement customer driven changes and enhancements to XML data output as the projects are created.

Implemented and made changes to the C# parsers as was require to mitigate discrepancies in the statement.

Java 8 application development with Oracle 9i data base

CDI- Hamilton Sundstrand- Windsor Locks, CT Jan 2014 - August 2014

Software Engineer –Consultant

.NET 2005 to .NET 2013 MVC 3.0 web application migration development and application maintenance.

Utilized C# and uses ADO for RDMS in support of Hamilton Sundstrand Finance Department

Wrote a C# win application to use binary read to decode VSS 6.0 passwords that the admin had forgotten.

Aetna\ RCHG - Hartford, CT

Sr. Software Developer Consultant July 2012 – December 2013

Application developer assigned to Aetna’s tools migration and integration team migrate various .NET MVC 3.0 web application throughout Aetna to Window 7 using NET 2010.

Savantage Solution- Springfield, VA

Software Developer Consultant February 2012 – June 2012

TDD NUnit. Agile NET C# web application development utilizing .NET 2010 C# and the Razor

MVC framework on the US Army CHESS application. The application supported an Oracle backed.

Wrote PLSQL quarries as needed. I also used JQuery to extensively format the GUI user interface. The application was slated to be the primary portal used by the US Army for processing and to register and make available non-combat related goods throughout the US Army’s inventory.

PepsiCo- Somers, NY May 2011 –January 2012

IT Specialist Consultant

Multi-Threaded application development for MS Mobile using .NET C\C++ through IBM MQ Series to Sybase database. The application is used by Pepsi US Sales to facilitate sales of Pepsi products throughout the Unites States.

Utilize C++ memory allocation and deallocation to facilitate linked list structures as needed.

HCG-Global- Farmington, CT January 2011 –April 2011

Software Developer Consultant

Created reports using Crystal Reports report writer. The reports were populated from BOE object feeding from MS SQL 2008 database views.

Scheduled reports to be sent as email as needed.

CIGNA- Bloomfield, CT September 2009 – December 2010

Application Development Senior Specialist

Production support for CIGNA Clinical IT. Worked with HPSM tickets to resolve user reported problems in a timely manner.

Used SSIS/DT to update SQL tables from existing data tables.

Responsible for the Data Warehouse ETL process that does the distribution of data from CIGNA’s data synchronization between various system utilizing MS SQL and PL/SQL Oracle data sources.

Assist Senior Managers in determining project feasibility, the timeframes, and resources for completion. From the technical perspective monitor expected results and benefits against established performance criteria including budgets.

IBM RAD 7.5 application support and development with Oracle 11i PL/SQL

Full SDLC system planning and implementation.

SharePoint document storage and retrieval and video presentation.

Goodrich Corp. - West Hartford, CT November 2006 – September 2009

Software Developer

MVC based methodology application development with MS.NET 2005, 2008 VB ASP.NET, C#, HTML, JScript, JavaScript.

Create MS SQL 2003 and SQL 2005 data tables and stored procedure as required and used DTS extensive to update data table for existing txt and csv files and data tables.

Created MS SQL 2008 SQLSSIS packages to import external data source from Excel and other files.

Used Crystal Report and SSRS to create modules used to display data in matrixes views as needed for dept. managers.

Worked extensively with business users to develop programming specifications and testing scenarios as the sites are developed and deployed.

Write C\C++ OOP applications as needed to do low level directory searches to facilitate Goodrich Engineering services Teamcenter implementation group.

Technologies: MS.NET C#, VB.NET, MS SQL, Oracle PL/SQL, C\C++, VB 6/0, HTML, JScript, JavaScript

Created Windows Service Dll to facilitate a Service to watch a directory for files and move them to storage directory when found.

SharePoint document retrieval and storage.

AAA- Hamden, CT February 2004 - November 2005 Consultant Developer – CT

Facilitate the development and deployment of CT AAA wireless response vehicle tracking and direction system.

Principal C\C++ designer of CT AAA’s wireless client\server mobile GPS tracking system.

The system used a Garmin GPS tracker and communicated over a broadband wireless network to a server that kept track of the mobile connections and communicated with a RPG module running an IBM AIS 400 system.

Novell, Inc. - Shelton, CT January 2003 - February 2004

Software Engineer IV

Software developer on Novell’s Silverstream/eXtend. I was responsible for integration testing with several app servers including BEA Web Logic and IBM WebSphere.

Responsible for MS.NET Framework web services for compatibility and interoperation with Novell’s eXteNd Composer’s transport protocols including Soap RPC, Asynchronous and Synchronous.

Worked with IBM WebSphere and BEA WebLogic as they interfaced with Novel’s eXtend cross platform web enabling transport mechanisms.

Create Web Services with data populated XML documents with different schema scenarios.

Design application to be deployed on several directory services including WebLogic, IBM WebSphere, and Novell’s E-Directory Service.

Create XML documents and complex stored procedures in MS SQL 7.0. Oracle 8i, MySQL for JDBC compatibility testing with the application as client and as service provider.

Use Mercury WinRunner to create test scripts to test JAVA functions.

Technologies: UUDI Web Services with SOAP, JDBC, XML, XMLS, MS SQL DTS, Oracle 8i, MS.NET, Oracle 8i, PL SQL.

Navisys, Inc. - Farmington, CT April 2001 - June 2002

Senior Developer

Application programmer on Navisys’s LifeCad/MP system. The application utilized a PowerBuilder front end with business logic in C\C++ DLLs which perform extensive stored procedure calls over CORBA connection layer to server-side DLLs running on UNIX or NT. The application supported both Oracle and Sybase.

Code complex SQL statements to retrieve and insert values into a table and implement triggered procedures where appropriate along with C++ programming code. The application was ported from COM to CORBA to support the UNIX operating system.

Solely responsible for modifying the IDL layer to synchronize values across the interface and working with COM internals.

Perform Unit and Integration testing of new code as necessary to ensure that code performs to specifications and identify and correct bugs.

Technologies: C/C++, CORBA, SQL, COM, UNIX, NT, Oracle, Sybase.

Pitney Bowes- Shelton, CT May 2000 - April 2001

Project Engineer –

ClickStamp Online web application developer.

Responsible for installation pre-release testing on Pitney's ClickStamp Online web application. Design and implement functional and GUI test scenarios using Segue SilkTest and WinRunner.

Enhance data retrieval times and reduce user interface delay.

Extensive use of complex SQL statements to return values from Oracle to test data integrity.

Technologies: SQL Plus, Oracle, SQL, Segue Silk Test, WinRunner.

Aetna US Healthcare, Inc.- Middletown, CT March 1998 - May 2000

System Delivery Specialist

Principal designer of an enterprise-wide web-based application that allowed the automation of the QA lab reservation and administration. In addition, the application keeps a record of all transactions and is used to track QA Lab utilization throughout Aetna.

Web application development with ASP and ADO to access data from an MS SQL database.

Use n-tiered architecture to bring together several DB2 databases under one integrated GUI interface.

Create testing script for varied application testing as necessary.

Automation testing using Rational Robot and Mercury WinRunner for Aetna’s TUMS Total Utilization Management System which provided data for claims processing.

Created utilization reports with Crystal Reports for the QA Lab utilization metrics.

Technologies: Classic ASP 4.0, ADO, MS SQL, Crystal Reports, Rational Robot, WinRunner.

Phoenix Home Life- Hartford, CT May 1996 - March 1998

Associate System Analyst

The system allows remote satellite offices to tap into Phoenix’s existing legacy system and produce reports and graphs of premium calculations for new insurance policies.

Develop an insurance illustration system in Visual C++.

Responsible for designing and coding new C++ classes for incorporation into the larger framework and developing the framework itself.

Programming Resource Co.- Hartford, CT December 1995 - May 1996

Programmer Analyst

Vantage Computer Systems (Intern) Wethersfield, CT July 1994 - Oct 1995

Programmer Analyst

Connecticut Department of Transportation (Intern) Rocky Hill, CT

Programmer Intern January 1994 - July 1994

EDUCATION

Central Connecticut State University December 1995

BSc Computer Science

Hartford State Technical College June 1992

AAS Computer Science

US Army, Honorable Discharge October 1980 - July 1987

Contact this candidate