William Matthew Graphman

This project is the second in a series of projects in which we are migrating our business away from an aging commerce platform to the NOPCommerce platform. This project will be building out a MVC front end application and leverage our Web Service layer built upon the NOPCommerce API. The project is scheduled to take 10 weeks of development before going into UAT. I am one of two architects on this project as my partner is using this project as his initiation into his new role as software… Show more

This project is the second in a series of projects in which we are migrating our business away from an aging commerce platform to the NOPCommerce platform. This project will be building out a MVC front end application and leverage our Web Service layer built upon the NOPCommerce API. The project is scheduled to take 10 weeks of development before going into UAT. I am one of two architects on this project as my partner is using this project as his initiation into his new role as software architect within our organization. Show less

Client requested a website CMS setup for their campaign. Instantiated Joomla 3 and setup up various widgets for their site which included info request forms, donation link to PayPal and calendar.

I have been working with a local Christian High School to develop a fund raising solution to promote their school. This application developed in C#.Net and MS SQL Server, allows the school to manage their sponsors and participants. They can get real-time estimates on the amount of money that has been raised and they have the ability to track participants year over year. The principal and I will be making the website along with their program material available to private schools in Indiana… Show more

I have been working with a local Christian High School to develop a fund raising solution to promote their school. This application developed in C#.Net and MS SQL Server, allows the school to manage their sponsors and participants. They can get real-time estimates on the amount of money that has been raised and they have the ability to track participants year over year. The principal and I will be making the website along with their program material available to private schools in Indiana, Ohio and Illinois on the 30th of September, 2011 at a Christian School Administrators Conference. Show less

We helped to launch the CHIRP Immunization registry in the State of Indiana and was so successful that we pushed the project way ahead of schedule and keep the success going.

The purpose of this project is to streamline the process by which a potential sales lead enters our Salesforce environment. The current process relies heavily on manual data entry and periodic batch uploads. This team will implement a common API that can be utilized by our landing pages as well as 3rd party lead providers. We then plan on interfacing with a Cloud service that will scrub and augment our address, phone and email data to verify that we have the cleanest data possible. Finally… Show more

The purpose of this project is to streamline the process by which a potential sales lead enters our Salesforce environment. The current process relies heavily on manual data entry and periodic batch uploads. This team will implement a common API that can be utilized by our landing pages as well as 3rd party lead providers. We then plan on interfacing with a Cloud service that will scrub and augment our address, phone and email data to verify that we have the cleanest data possible. Finally we will be taking our static lead ranking system and creating a customization rules engine around key metadata elements that will allow the business to refine and re-calibrate the final lead ranking score as needed. All of this to improve our lead conversion rate which could bring in millions of additional dollars of revenue into our company and reduce manual manipulation of data. Show less

In an effort to improve the accuracy and flexibility of modeling the accrued revenue, the IT Team has begun a project that will involve the construction of application that will allow our finance team to create various Revenue Models that will be systematically applied to our workflow data and stored in a data mart. We then plan on providing them with the tools Power Pivot or Tableau, to mine the data and generate the reporting that is necessary.

This project is focused on replacing our legacy OMS with a new enterprise-wide system based on the open source NOPCommerce platform. The goals will be to provide a common user experience for our internal sales reps in both divisions of our organization. The same platform will also work as the foundation for our online bookstores, thus eliminating years of segregation between our services and our products.

Developed a robust Jury Management solution for Morgan County Judicial system in Morgan County, Indiana. The application was originally developed in Visual Foxpro in 2000. In 2008, the application was ported over to C#/ASP.Net on the MS.Net platform and Microsoft SQL Server. This application allows the Jury Commissionaire to manage jury selection and responses in a significantly more efficient manner. Features include randomized Jury Draws, Assignment of draws to different courts, managing… Show more

Developed a robust Jury Management solution for Morgan County Judicial system in Morgan County, Indiana. The application was originally developed in Visual Foxpro in 2000. In 2008, the application was ported over to C#/ASP.Net on the MS.Net platform and Microsoft SQL Server. This application allows the Jury Commissionaire to manage jury selection and responses in a significantly more efficient manner. Features include randomized Jury Draws, Assignment of draws to different courts, managing jury availability and importing of new potential jurors via various file formats. Show less

This project focuses on the creation of a scalable and easily configurable ebook distribution platform. The objective is to automate the process of taking raw ebooks files and injecting appropriate metadata, applying appropriate structure and then distributing them out to the various vendors that we partner with. The solution will combine Service Oriented Architecture with a sophisticated configuration engine stored in a SQL Server Database. Leveraging .Net 4.5, Entity Framework 6 and… Show more

This project focuses on the creation of a scalable and easily configurable ebook distribution platform. The objective is to automate the process of taking raw ebooks files and injecting appropriate metadata, applying appropriate structure and then distributing them out to the various vendors that we partner with. The solution will combine Service Oriented Architecture with a sophisticated configuration engine stored in a SQL Server Database. Leveraging .Net 4.5, Entity Framework 6 and ASP.Net MVC, our Dev team will build out a series of various plug-in services that will be available to the managing service. The manager will take each project through its recommended steps applying each plugin as necessary. At the end, the project related files will be submitted to their respective destinations and through various methods including FTP or Web Services. Once delivered, a monitoring service will watch for the projects to become available on the vendors storefronts. Once available, the service will update the status in our system. Overall this project should reduce the rejection rate from our distributors and therefore reduce the time to market for our ebooks. The solution reduces a number of manual steps involved in the process and improves tracking and monitoring of all projects from start to finish. Show less

This project involves leveraging some new technology for me, that being SOLR search technology. The objective is to design and build a solution that monitors our customer data for individuals that have been identified as sanctioned by the federal government. Combining a WCF service that performs a search against a SOLR core built using the SDN List, we will be instituting an SSIS package that routinely scans through our various data stores to make sure that no customers have been tagged as… Show more

This project involves leveraging some new technology for me, that being SOLR search technology. The objective is to design and build a solution that monitors our customer data for individuals that have been identified as sanctioned by the federal government. Combining a WCF service that performs a search against a SOLR core built using the SDN List, we will be instituting an SSIS package that routinely scans through our various data stores to make sure that no customers have been tagged as possibly being a sanctioned individual. Show less

Our next major project is the sun-setting of a legacy application that manages the fulfillment of marketing services to our customers. This functionality will be built out in the cloud on our Salesforce.Com / Force.Com platform using the sophisticated workflow engine that we currently use for our production fulfillment. We will then be migrating the data/status into Salesforce to unify all of our product delivery divisions.

This project picks up where the CRM migration left off. During this project the goal is to migrate all of the production fulfillment process and workflows into Salesforce. Key challenges that our team will face include the movement and reorganization of terabytes of file data as well as over 100 gigabytes of SQL database data. Complexity is added with the additional conversion of legacy royalty information and the consolidation of two downstream systems which handle our marketing services… Show more

This project picks up where the CRM migration left off. During this project the goal is to migrate all of the production fulfillment process and workflows into Salesforce. Key challenges that our team will face include the movement and reorganization of terabytes of file data as well as over 100 gigabytes of SQL database data. Complexity is added with the additional conversion of legacy royalty information and the consolidation of two downstream systems which handle our marketing services fulfillment and our Order Management System. All of this with a very compressed timeline and a slightly smaller team than the CRM portion of the project. Show less

Update - The team has successfully completed the migration of all CRM information from our legacy system into Salesforce. The final push involved over 60 million rows of data into 5 different Salesforce objects. The teams accuracy rating was above 99%. Congratulations to the team for an outstanding deployment.

This is the first phase of a much larger project which is to migrate our remaining core legacy system into our unified Saleforce.Com platform. This phase focuses on the… Show more

Update - The team has successfully completed the migration of all CRM information from our legacy system into Salesforce. The final push involved over 60 million rows of data into 5 different Salesforce objects. The teams accuracy rating was above 99%. Congratulations to the team for an outstanding deployment.

This is the first phase of a much larger project which is to migrate our remaining core legacy system into our unified Saleforce.Com platform. This phase focuses on the migration of CRM data onto Salesforce and then integrating the Salesforce CRM back into the workflow engine provided by the legacy system. Thereby keeping our sales and marketing teams focused on Salesforce and the larger more sophisticated production teams in the legacy system. Show less

This project involved the migration of production workflow that was contained in a stand-a-lone Filemaker Pro database application and incorporating the workflow and the data into our Salesforce/Force.Com platform. Data migration was a major piece of this project along with the creation of a web portal for Freelancers to register, check project status, and download and submit assets into our cloud storage.

DARMHA is a mental health assessment .net web application. DARMHA changed the way states collected data for children and adults. After DARMHA was created. State after state rushed to jump on the band wagon to quickly and efficiently collect data for the federal government.

Automates the assimilation of upwards of 300 distinct files supplied by various sources in different formats so that the business may process the quarterly royalties faster and more accurately. This project spanned nearly 10 weeks in development and utilized resources distributed among multiple offices and regions. This application resolves many issues revolving around the business’ number one customer concern and will save the organization significant dollars with its implementation.

Took a legacy Palm OS application used to gather inventory information and re-designed and developed in VB.NET on the MS Compact Framework using SQL CE on a Motorola MC1000 handheld unit. This application collects data independently and then the user can drop handheld into the cradle and sync the data from the handheld onto the legacy Access database stored on the host system.

Designed a set of secure web page additions for our existing website framework in addition to a stand-a-lone administrative interface for the management and collection of W9,W8 and EFT/ACH information from our Authors.