Post Job Free

Resume

Sign in

Sql Server .Net C#

Location:
McHenry, IL
Posted:
November 24, 2023

Contact this candidate

Resume:

RICHARD E. WASILEWSKI

**** ****** **. 815-***-****

Wonder Lake, IL 60097 ad1e1k@r.postjobfree.com

Professional Profile

Professional Developer with 17+ years of experience in implementing and developing INFOR SyteLine Cloud Suite Industrial (CSI) ERP systems, SQL Server Reporting Services, consuming web services / remoting and interfacing with SQL server back ends. Developing .Net C# web applications including Allstate’s Web Quoting E-Commerce web site. Utilized Capability Maturity Model (CMM), Agile and Method One development methodologies. Expertise in SyteLine ERP system, Experience in Silkroad and Interwoven TeamSite content management systems. Experience with the SyteLine Mongoose framework. Experience with Salesforce customer relationship management. Additional 10 years of experience in software development, implementation and enhancement of existing systems. Organized and detail-oriented with excellent troubleshooting and problem-solving skills.

Technical Skills

Development Tool: INFOR Mongoose framework, Microsoft Visual Studio, SQL Server Business Intelligence Development Studio, SharePoint

Languages: C#, SQL, ASP.Net, SSRS, VB.Net, SSIS, Java, JavaScript, Visual Basic, VB Script

Structure: XML, HTML, ASP.Net, ADO.NET, MVC

Applications: INFOR SyteLine 9.00.20 and 10+ releases, SQL Server, SharePoint, Business Contact Manager, Salesforce, InfoPath, Rdb

Operating Systems: Windows11, 10, XP, 7

Software: Microsoft Office – Word, Excel, PowerPoint, Access, Outlook, MS Project, Visio

Tools: Enterprise Manager, Team Foundation Server, JIRA project management, GIT

Hardware: Windows, Windows Server, Web Server, Dec/Vax

Professional Experience

Application Automation Consultants, Inc. August 2019 – Present

Independent Consultant/Developer

Developing Forms, Events, processes and Reports for INFOR SyteLine Cloud Suite Industrial(CSI) 9.0 and 10.0+ ERP system in a manufacturing environment, Develop Mongoose reporting reports, DataViews, DataView reports, SQL Server Reporting services, SyteLine Mongoose Application development, Forms development, Component creation within the SyteLine ERP system.

OTTO Engineering January 2013 – August 2019

Consultant/Developer

Lead developer managing 6 developer resources on the Implementation of INFOR SyteLine 8 and 9.01 ERP system in a manufacturing environment, Develop SQL Server Reporting services, SyteLine Mongoose Application development, Forms development, Component creation within the SyteLine ERP system, interface WEB applications to the new ERP system for use by the organizations manufacturing, internal teams and management.

Managed assignments of multiple developer contractors, responded to customer requests and internal department requests in a timely manner, identified Issues and worked with Software Vendors to resolve them, provided updated developer status reports to management on a weekly basis, worked with internal customers to identify and resolve any issues encountered, provided technical resources to developers to identify alternative methods to accomplish development and apply internal best practices/standards.

Initially I was brought in to help Implement the details gathered by the Business Analysts/Programmers. After learning the SyteLine application I became lead and drove the project updates.

Form development for specific business needs was created using the SyteLine libraries and development environment. Forms for data entry were created for customer service order entry, engineer design, job processing, employee information and accounting.

I became an expert in SyteLine developing the code behind, component classes, inline scripts and .net code to make the form behave as expected. I performed form sync’s by using remote desktop to access Dev, Test and Production environments gathering the form and license for promotion.

Developed Table structures, stored procedures, functions, views and triggers to meet business needs.

SSRS reports were developed taking advantage of my SQL skills. I develop SQL scripts for reports keeping in mind that it is better to deliver the data exactly as needed to display on the report. SSRS handles the data display. This allows modifications to the calculations for the data to be kept separate from the report designs.

Upgraded from SyteLine 8.0 to 9.0 and to the current release 9.0.20 all the forms and code specific to the business, design changes, merging fields on forms that are SyteLine standard but had been modified for business purposes were made.

Application Automation Consultants, Inc. November 2012 – January 2013

Consultant/Developer

Develop SQL Server reporting (SSRS) on the web for use by the organization’s internal teams and management.

MasTech Corporation, Pittsburg, PA – Chicago Client August 2012 – November 2012

Consultant/Developer

Analyze SSIS packages to define requirements for updating historical information on a 2 billion row enterprise database.

Provide expertise to implement cross-browser implementation for sales and marketing tools and reporting capabilities in the ASP.Net application. Firefox, Safari, Chrome and Internet Explorer.

Make Corporation, Oakbrook Terrace, IL Jun 2011 – August 2012

Consultant/Developer

Create new functionality, updates and support for an Enterprise database application, using VB.Net, ASP.Net, with an Oracle back end.

Provide new application functionality as requested by the user community.

Convert VB applications to the .Net platform, rewriting the application to utilize object-oriented coding techniques.

Support the Enterprise application with features and functionality that the user community requests.

Encore Consulting, Rolling Meadows, IL Jul 2010 – May 2011

Consultant/Developer

Create web service interface and application development/support for B2C web application, using VB.Net, C#, ASP.Net, SQL server and MVC.

Created Web Services for interface with IPhone and backend processing with validation and PDF Formatting.

Developed new B2C application utilizing Entity Framework, MVC, and C#.

Brook Source, Chicago, IL Jan 2010 – May 2010

Consultant/Developer

Perform web service interface and application development for Director Liability application, using VB.Net, ASP.Net, SQL server, CSLA.

Programmed web services to process client information against quoting engine to automate external applications through Quoting, Binding and Issuance. Using VB.Net and SQL Server 2005.

Working with SalesForce loading Contacts, Organizations and Opportunities. Adding additional field requirements and designing screens.

Application Automation, McHenry, IL Jan 2009 – Jan 2010

Consultant/Developer

Developed applications that retrieve information from SharePoint for processing, create updates to SharePoint based upon results received.

Created applications that identify a task and create that task in a SharePoint for assignment to customer representatives.

Create SharePoint site for testing application processes and Workflow using InfoPath.

Develop web services interface and application development for Credit Analysis application, using.Net, C#, SharePoint, and SQL server.

Programmed applications to process client information against D & B to determine credit worthiness. Using .Net, C# and SharePoint.

FOUNDERS INSURANCE, Des Plaines, IL June 2008 Oct 2008

Web Developer

Perform web service and application development for claims application, using VB.Net and SQL server.

Wrote stored procedures to update a SQL Server database with quoting information. Retrieve data for validation of webservice data.

Wrote web services for the upload of information with verification against schemas into SQL tables.

ALLSTATE INSURANCE, Northbrook, IL Apr 2001 – June 2008

Career Progress:

Web Developer, Consultant Level 2005-2008

Web Developer, Professional 2003-2005

Developer 2001-2003

Development

Developed applications for the Allstate.com web site in the Internet Marketing Technology (IMT) division. Performed development using Visual Studio 2003 / 2005, C#, ASP.NET, XML, HTML, ASP, SQL and Java and other technologies.

Worked on the web quoting E-Commerce web site that allowed customers to Quote, Bind and Issue a policy.

Worked in Web Quote and Bind (WQB) division developing the Web Site for Property Quoting using Visual Basic, ASP, Java, Visual Basic Script, SQL, and XML.

Provided development of applications to support Internet Marketing. Direct contact with marketing personnel on development and implementation of projects that enhanced the user experience and furthered Marketing goals.

Quality/Process Improvement

Performed Quality improvements keeping all other areas informed of activities that affected them.

Identified new processes designed to improve implementation of SQL Database updates.

Assisted with the transition of outsourced quality applications to the Northbrook Technologies, Northern Ireland (NTNI) organization.

Coordinated and identified resources necessary to implement a solution to the Allstate’s Chinese web site that eliminated a possible spoofing issue.

Implemented solutions to Search Engine Optimization (SEO) to further Marketing’s efforts which provides Allstate agent information to Google for inclusion on Google Maps.

Support

Effectively assisted Marketing in implementing Push To Talk (PTT) within landing pages, Web Quote and Bind (WQB) and the Auto Insurance Guide in a time frame consistent with Marketing’s goals.

Provided expertise to support Marketing with resolutions to issues that arose with the content management application.

Supported the Marketing Team with expertise and issue resolution related to Campaign Management and tracking.

Analyzed, designed and prepared integration testing for the Allstate Financial Technology (AFT) organization on the Term Life Quoting implementation.

Assisted Marketing Department to develop better inter-departmental relationships and improve their technology investment.

Supported Marketing in their efforts to meet tight timeframes and assisted with resolving web application issues in a timely manner.

Tutored and mentored college interns while performing normal responsibilities resulting in the hiring of 2 interns.

APPLICATION AUTOMATION CONSULTANTS, INC., McHenry, IL 1990 – 2001

Owner/Consultant/Software Developer

Provided System Development and technical support at client site for installation, conversion, new application development and general programming and system needs on assignments ranging from 6 months to 3 years in length.

Developed PC Software for Management Information including a JIT ordering application, a product analysis system and a relational database for the Marketing Department of a food products manufacturer.

Participated in several conversions of acquired financial institutions to a centralized Data Center.

Implemented the conversion to Systematics Financial Software for a community banking chain.

Education

CHICAGO CITY COLLEGE-Loop Campus, Chicago, IL; COLLEGE OF LAKE COUNTY, Grayslake, IL

Computer courses

Continuing Education:

Project Management-Essentials; Scope, Schedule, and Cost Management; Managing Project Managers

Internal Consulting: Partner with Your Client; Translate Client Goals into Effective Results

JavaScript Programming

Upgrading Web Development Skills from ASP to MS ASP.NET

Introduction to XML and the Microsoft .NET Platform

Programming the Microsoft .NET Framework with C#

Programming with Microsoft ADO.NET

Core Data Access with Microsoft Visual Studio 2005

Advanced Data Access with Microsoft Visual Studio 2005

Core Web Application Technologies with Microsoft Visual Studio 2005

Advanced Web Application Technologies with Microsoft Visual Studio 2005

Developing Microsoft ASP .NET Web Applications Using Microsoft Visual Studio .NET

Developing XML Web Services Using Microsoft ASP.NET

Enterprise Java Beans (EJB) with WebSphere Studio Application Developer

Web Services Development using RAD v6

Updating Web Server Skills to Internet Information Services 6.0

Attended management training sponsored by MAP (Management Activities Program).

Developed managerial abilities at the Managerial Grid Training Program.



Contact this candidate