As an experienced developer, I have been presented with various problems to resolve
over the years. I have listed several of the projects that I thought were both interesting
and challenging in some way, as examples of my experience.
Data Extraction:
Designed and implemented complete end-to-end process to extract and push data to third party,
and dual reporting to validate the end results were being achieved.
Upon doing the requirements gathering in this project, there were several areas to focus on.
- The generation of the files being pushed to the vendor
- Any potential errors in the data being sent
- Completion of the actions on the side of the vendor
CT Scan Extractions:
Created Stored Procedure which extracted Patients having appointments 2 business days ago.
Upon doing the requirements gathering in this project, there were several areas to focus on.
- The generation of the files being pushed to the vendor
- All Patient appointments 2 business days old, skipping weekends and holidays
- Adhere to patient requests to be on the "Do Not Call List".
Active Directory Sync (Automated with HR):
Designed and implemented process to query HR records from third party and do scheduled updates
to Active directory, keeping records in sync and controlling access and other information.
Requirements in this case, included employee records, software access and needed to be real-time.
- Created Web listener, to capture submissions by HR
- Ran scheduled tasks to validate data several times a day
- Generated report for Infrastructure team to reconcile
Support Console with Intelligence:
Designed and implemented web-based console to be used by major cable company. Allowing their
support team to properly respond to caller's questions and issues. Console would offer company
approved responses to predefined selections input by support team, based on the customer situation.
Requirements in this case, included employee records, software access and needed to be real-time.
- Must allow multiple Call Centers to access software upon logging on to Active Directory
- Must provide a process to a positive outcome when customers were troubled.
- Generated report of highest and lowest conversions of inbound callers
Automated Billing System:
This project required an in-depth understanding of all billable services. The goal was to automate
the creation of invoices for a large membership based business.
Requirements included handling monthly, annual and daily services provided.
- Generate a complete list of all clients and their base chargeable subscriptions
- Compare allotted services with usage and generate overage changes
- Generate Invoices for each and display a review for approval of appropriate personnel
- Generate reports displaying a rise and drop in monthly charges and usage.