About
Pyramid Software Solutions - Milwaukee Web Design and Software Development
Pyramid Software Solutions
Welcome to Pyramid Software Solutions. We are a freelance web design and software development
company based in Milwaukee, WI. Unless told otherwise, I (Sean Peplinski) will be the only developer working on your project.
Depending on workload and project size, I may bring on 1-2 other developers to help work on your project. I will inform you
of this, and you will have an opportunity to meet any other developers before you make a commitment with us. Because of our
small company size, we are very customer focused and I am available by phone or email between 8:00am-9:00pm to field questions
and give you updates on the progress of your project.
Employment History
Oshkosh Corporation (Pierce Manufacturing division)
Title:
Senior .NET Developer
Dates:
7/1/2013 - 1/20/2015
Tools/Technologies Utilized:
- Microsoft SQL Server Management Studio
- Both C# and VB .NET desktop and Web Forms development
- C# MVC 4.0 Development
- Web API and WCF web service development
- Silverlight web application development
- WPF desktop development. Our WPF application also utilized Entity Framework
Description
One of the main applications I worked on in this position was the sales tracking system. This included proposals
our sales staff made to clients across the world, as well as opportunities for businesses that were not yet clients of ours.
This was an ASP .NET Web Forms application, but I was involved with the development/design of a conversion to MVC. Besides
working with the business analysts to develop new features for the sales team, I also spent a fair amount of time fixing
bugs and performance issues with either the SQL database, front-end (jQuery/Javascript), or back-end (C# ASP .NET).
Another application I worked on was a configuration system the engineering team would use to design/build equipment. The application included a complex rule-engine implemented through Silverlight with a MVVM design pattern. The application used WCF web services to communicate with the database storing rules and configuration information. I was involved with developing new features for this application, as well as a comprehensive overhaul to improve performance. Our team was able to reduce some operations from an execution time of 7+ minutes, to around 30 seconds. We were able to do this through optimization of the database schema, SQL queries, web service configuration/implementation and back-end processing.
The last application I'll touch upon was a WPF/Entity Framework application that allowed our inspection team to inspect completed equipment from their tablet. One interesting project was to interface camera/barcode scanner drivers of the tablet with our software to allow the inspection team to use their tablets to inspect equipment, take pictures of defects, and scan their employee badge to log in the database which employee made an update.
Another application I worked on was a configuration system the engineering team would use to design/build equipment. The application included a complex rule-engine implemented through Silverlight with a MVVM design pattern. The application used WCF web services to communicate with the database storing rules and configuration information. I was involved with developing new features for this application, as well as a comprehensive overhaul to improve performance. Our team was able to reduce some operations from an execution time of 7+ minutes, to around 30 seconds. We were able to do this through optimization of the database schema, SQL queries, web service configuration/implementation and back-end processing.
The last application I'll touch upon was a WPF/Entity Framework application that allowed our inspection team to inspect completed equipment from their tablet. One interesting project was to interface camera/barcode scanner drivers of the tablet with our software to allow the inspection team to use their tablets to inspect equipment, take pictures of defects, and scan their employee badge to log in the database which employee made an update.
MilwaukeeJobs.com (Local Job Network)
Title:
Programmer Analyst
Dates:
9/20/2007 - 7/10/2012
Tools/Technologies Utilized:
- Microsoft SQL Server Management Studio
- Desktop development (Visual Studio - VB .NET) and web development in MVC framework
- XML and DOM (document object model)
Description
In this position, I mostly developed back-end systems in the MVC framework and desktop environments. One of my tasks was to develop a
robust .NET desktop application that would "scrape" websites and process job feeds for customers
that paid to have their jobs copied from their website/feed to our database and front-end website (milwaukeejobs.com). The job feeds
were either formatted in XML or a propietary format, so the challenge was to develop readable, reusable code that could process the various
feeds reliably. This application was multi-layered between data access, business logic, and data processing of the feeds/websites.
I was involved with both the design and implementation of the application.
Other experiences from this position:
- Developing complex SQL queries for a moderate/large database schema.
- Database schema optimization as well as query optimization for performance.
- Daily support for job feeds/websites that may have changed causing the parsing program to fail.
Other experiences from this position:
- Developing complex SQL queries for a moderate/large database schema.
- Database schema optimization as well as query optimization for performance.
- Daily support for job feeds/websites that may have changed causing the parsing program to fail.