Applications Architect Resume Profile
5.00/5 (Submit Your Rating)
TX
OVERVIEW
- A well-seasoned professional experienced in Application Development in various roles including Solution Architect, Project Manager, Business Analyst, Quality Lead, Technical Lead, Developer and Database Administrator.
- Very comfortable facilitating discovery and joint application design sessions as well as creating materials that clearly communicate system design and interactions for presentation to the IT project team, business stakeholders and Senior Management.
- Strong presentation and conceptual design skills with focus on reusable and extensible web services as well as putting configuration in the hands of the process owners.
- Well-versed with Microsoft-based .NET frameworks and database technologies
TECHNICAL SKILLS
- Languages: C , VB.NET, Visual Basic 6, VBScript, JavaScript, C/C , COBOL, FORTRAN
- Technologies: WPF, WCF, WF, WinForms, IoC/Dependency Injection, LINQ, Crystal Reports, Reflection, OOP, TDD, nUnit, Mock, Realtime, Multi-Threading, Windows Services, Web Services, ADO.Net, Log4Net, MSMQ
- Web
- Technologies: IIS, ASP.NET, ASP, MVC 4/Razor, HTML, CSS, AJAX, XML, XSD, jQuery, JSON, SOA, SOAP, WSDL, REST
- Database: Microsoft SQL Server 2005/2008R2/2012, SSAS, SSIS, SSRS, T-SQL, SQL Server Management Studio, SQL Profiler, Oracle 8i/9i/10g, PL/SQL, Sybase, DB2
- Development
- Environments: Visual Studio all versions thru VS2012
- Version
- Control: Team Foundation Server, SubVersion SVN , Tortoise SVN, Visual Source Safe
- Continuous
- Integration: TFS, Cruise Control.Net, TeamCity
- Applications: CA ERWin, MS Expression Studio, MS Office Word, Excel, PowerPoint, Access, Outlook , MS Project, MS Visio, MS Publisher, MS FrontPage, WinRunner, Test Director, RoboHelp, MS Windows Help Compiler, Installshield, Toad, Red Gate SQL Tools, Beyond Compare, Target Process
Employment History
- Confidential
- Applications Architect
- Confidential
- Solution Architect
- Confidential
- Solution Architect/Technical Lead
- Confidential
- .Net Developer
- Confidential
- Application Architect
- Confidential
- Application Architect
PROFESIONAL EXPERIENCE
Confidential
Applications Architect
- Business Objective: LifeSynch was purchased by Humana and its systems are in the process of being integrated into existing Humana infrastructure and systems.
- Results: A Data Warehouse was created with appropriate reports using Microsoft SQL Server, SSAS, SSRS, and SSIS to provide both a predefined set of reports as well as reliable data that could be used for ad-hoc reporting.
- My Role: As the Applications Architect, I am responsible for designing the changes required to LifeSynch systems and coordinating between the LifeSynch and Humana teams to ensure that process conversions occur smoothly. In addition, I performed the role of Tech Lead to mentor team members and perform code reviews.
Confidential
Solution Architect
- Business Objective: Moving beyond their traditional product offering of printed portrait collections, Portrait Innovations began offering additional products including mugs, canvases, calendars, books, and posters with additional products to follow. With the fast paced introduction of these products during their busiest season of the year, PI had reporting and tracking requirements that could not be met with their current reporting environment. A data warehouse with appropriate reporting capability was needed to gain an understanding of how the new products were impacting the traditional portrait sales as well as provide information to management to determine the value to the organization of the new product offerings.
- Results: A Data Warehouse was created with appropriate reports using Microsoft SQL Server, SSAS, SSRS, and SSIS to provide both a predefined set of reports as well as reliable data that could be used for ad-hoc reporting.
- My Role: As the Solution Architect, I was responsible for determining the data to be housed in the Data Warehouse, ensure that proper processes were put in place to obtain and aggregate the data, and ensure that the appropriate reports are available to management.
Confidential
Solution Architect/Technical Lead
- Business Objective: Provide value-add protection benefits that can be used as a tool to acquire new SunTrust checking account customers while also retaining their existing base. In addition, SunTrust would be able to generate incremental revenue through the upsell of fee-based protection benefits.
- Results: Project is currently completing the design phase of the life cycle.
- My Role: As the Solution Architect, I was responsible for translating the Business Requirements into a working solution that encompass Web, Middle, and Data Tiers as well as interfacing with existing backend systems.
Confidential
RBS Hub Online
- Business Objective: Provide the Royal Bank of Scotland a Hub of benefit services that are used as a tool to acquire new bank customers while also retaining existing customers.
- Results: Successfully completed implementation of the Hub.
- My Role: As the replacement Technical Lead, I was responsible for ongoing technical management of the project during the final phase of implementation. I worked with teams located both in the US and UK to diagnose and resolve production and testing issues. I also interfaced with service suppliers to ensure interoperability with the Hub.
Confidential
Wells Fargo Mobile
- Business Objective: Implement a mobile version of the Wells Fargo Privacy Protection website to be used by iPhone, Android, and Blackberry phones.
- Results: Successfully enhanced the existing architecture to allow for mobile device content for this project and as the basis for future mobile versions of the hundreds of Affinion Group websites/brands.
- My Role: As the replacement Tech Lead, I was responsible for ensuring that the solution was implemented as planned by working with software developers, content developers, quality assurance, and the business team. Numerous challenges were encountered and overcome with this first mobile content project.
Confidential
.Net Developer
- Business Objective: Upgrade the architecture of the print processing system to allow for future growth as additional States are added. Upgrade includes the addition of two states.
- Results: Upgraded architecture allowed for future growth and maintenance through the implementation of WCF services, MSMQ, IoC/Dependency Injection, and TFS.
- My Role: As a developer, I was responsible for conversion of services to run under the new architecture . In addition, I acted as the single point of contact with the QA team for the printing system.
Confidential
Application Architect
- Business Objective: Design and development of a custom application to facilitate the cutout of lines of business in an SAP environment.
- Results: Designed, developed, and implemented a custom web-based application using Microsoft .Net technology in conjunction with SQL Server and Oracle Database Management Systems.
- My Role: As the project lead, I was responsible for the complete design and development of the application using VB.net and C in Visual Studio 2008. I was also responsible for all database design and implementation for both SQL Server and Oracle.
Confidential
Application Architect
- As the Vice-President of Application Architecture, I was responsible for a suite of highly customizable applications to meet the needs of customers across a wide range of industries.
- With a project life-cycle of 6 to 18 months, I was involved in all aspects of project management and planning, requirements definition, system installation and configuration, disaster recovery planning, custom modifications, user acceptance testing, training, go-live, and on-going support.
- Internally, I was responsible for the implementation of a formal SDLC methodology including Change Management and Quality Assurance, selection of tools including issue tracking and automated testing, and implementation of issue tracking using TestDirector and automated testing using WinRunner.
- Frequently, as one of the two point of contact with a client, I was responsible for making presentations to and interfacing with many different audiences within the client's organization, ranging from management to end-users, including non-technical as well as a range of technical areas Security, Networking, Database, Server Management, etc.
- The following are a representative sample of projects for which I was responsible:
Confidential
- Business Objective: LANL implemented the application suite in a multi-phase approach. The first phase consisted of implementation of the core application suite. The second phase consisted of upgrading the suite to the .Net Framework and minor enhancements. The final phase consisted of implementation of value-added enhancements to optimize the application suite to their business environment.
- Results: Successful installation and implementation of the application suite as well as code conversion and enhancements to the core applications consisting of Corrective Action Manager, Trending, Executive Dashboard, and Query Tool.
- My Role: As the lead consultant and subject matter expert, I was responsible for all aspects of the implementation for Qualitech Solutions. I worked with LANL to define the infrastructure requirements for their implementation, designed and was technical lead on all code enhancements, and designed and implemented all database changes.
- I was responsible for developing and implementing the upgrade strategy and plan for converting over 350 custom DLLs from VB6 to VB.net and C . Based upon LANL experience and feedback, successful upgrade in this timeframe was unheard of for the sheer size of the system. I was able to accomplish the upgrade in less than 2 months due to the strict adherence to coding standards in all components of the system.
Confidential
- Business Objective: OPG implemented the Trending application in a pilot program prior to rollout to the entire organization. During the pilot, it was determined that their configuration would require changes to reduce both the processing window and database storage.
- Results: Successful pilot and decision to implement across the entire organization based upon the processing window being reduced from over 36 hours to less than 3 hours and database storage being reduced by 75 .
- While OPG pushed the envelope for the Trending application, their processes were no different than other customers' using this application. Design changes resulted in an application that was far more versatile for customers and opened the functionality of the application to new users within the customer's organization.
- My Role: As the lead consultant and subject matter expert, I was responsible for all aspects of the implementation for Qualitech Solutions. I worked with OPG to define the infrastructure requirements for their implementation, identified issues and proposed solutions during the pilot, designed and was technical lead on all code enhancements, and designed and implemented all database changes.
- Major changes involved converting the Analysis program from a single threaded VB6 application to a multi-threaded VB.net Windows Service and developing a web-based interface to control and monitor its operation. In addition, by implementing some additional minor changes, I was able to allow the restart of failed tasks during the processing of an Analysis job removing the need to restart the entire job and further controlling the processing window.
Confidential
- Business Objective: CFI provides Customer Satisfaction monitoring and improvement services to their clients. In order to present the result of their Customer Satisfaction surveys and facilitate monitoring of the recommended changes based upon those surveys CFI desired to implement QSI's Executive Dashboard as well as new functionality for Satisfaction Improvement Tracking.
- Results: Successful integration of Executive Dashboard and Satisfaction Improvement Tracking into the reporting process for CFI's customer. In addition, by implementing automated configuration from CFI's existing system, Executive Dashboard was reconfigured with each data load alleviating the need for the initial system configuration as well as CFI manually re-configuring the system as changes were implemented in their reporting process saving CFI from on-going costs.
- My Role: As the lead consultant and subject matter expert, I was responsible for all aspects of the implementation for Qualitech Solutions. I worked with CFI to define the infrastructure requirements for their implementation, identified issues and proposed solutions during the initial implementation, and designed and was technical lead on all code enhancements, and designed and implemented all database changes.
- Working with CFI, I was able to develop user interface changes that exceeded their expectations on presentation and drilldown of Performance Indicators including different groups of subordinate Performance Indicators.
- By re-directing CFI's focus from a manual configuration to an automated configuration, I was able to cut CFI's cost during the initial implementation and eliminate them during ongoing operation.
Confidential
- Business Objective: FPL required a new application to interface between QSI's Corrective Action Manager and INPO's Nuclear Network to extract operating experience data for review and evaluation by FPL personnel to allow them to reduce and/or prevent repeat of incidents based upon experience gained at other nuclear facilities.
- Results: Successful implementation of Operating Experience Manager with integration into Corrective Action Manager providing FPL with a high quality interface to INPO's Operating Experience data and the ability to create related entries in the Correction Action Manager system with bi-directional links between the two systems.
- My Role: As the lead consultant and subject matter expert, I was responsible for all aspects of the implementation for Qualitech Solutions. I worked with FPL to define the requirements for new application, designed and was technical lead on all code development, and designed and implemented all database changes, worked with FPL personnel to install in their environment and trained the trainers.
- I was also responsible for creating a VB.net Windows service to download XML data from INPO's Nuclear Network FTP site, extract data, and load it into the Operating Experience database.
Confidential
- Business Objective: Having acquired multiple nuclear power plants, FPL chose QSI's Corrective Action Manager as the single Corrective Action system to be used by all sites.
- Results: Successful implementation of Corrective Action Manager, Trending and Query Tool at three nuclear sites and the Corporate Office.
- My Role: As the lead consultant and subject matter expert, I was responsible for all aspects of the implementation for Qualitech Solutions. I worked with FPL to define the infrastructure requirements, develop application requirements, designed and was technical lead on all code enhancements, and designed and implemented all database changes.
- In order to implement business rules based configuration options, I was responsible for completely redesigning the database and application to reduce the number of hard-coded screens and provide functionality to control field status. As project leader I directed the project team on their individual assignments and was responsible for ensuring the integration and functionality of the completed changes.
Confidential
- Business Objective: Develop an application to build resumes and implement the Five-Factor Model of Personality to produce the WorkPlace Big Five Profile assessment.
- Results: ResumeFit provides a comprehensive resume system that improves candidate representation and gives employers the ability to make more well-informed candidate selection decisions. ResumeFit's comprehensive resume system is revolutionizing the way candidates and employers think about the role of the resume, the information submitted by the candidate, and the science utilized to identify good job fit.
- My Role: I was responsible for database design and developing the data access tier. I also developed a DLL that would process expressions to derive a result based upon expressions stored in the database.
Confidential
- Business Objective: Taking advantage of de-regulation, New Horizons Electric wanted to purchase electricity from multiple suppliers based upon pricing, however the supplier required a notification of changes in demand. QSI was contracted to develop the Dynamic Signaling Algorithm application to handle the processing.
- Results: The completed application allowed New Horizons Electric to save 10's of millions of dollars annually.
- My Role: I was responsible for sub-system that communicated to custom developed hardware that handled communications between New Horizons and the various suppliers. This sub-system processed load data, updating status information in the DSA database and sending updates to the suppliers. In addition, it interfaces through a Digital I/O interface to display status information as a backup to the monitoring application.
Confidential
- Business Objective: Areva NP wanted an enhancement to QSI's Corrective Action Manager software to allow more control based upon signatures as well as adding the ability to handle sub-signatures.
- Results: The completed application allowed New Horizons Electric to save 10's of millions of dollars annually.
- My Role: I was responsible for sub-system that communicated to custom developed hardware that handled communications between New Horizons and the various suppliers. This sub-system processed load data, updating status information in the DSA database and sending updates to the suppliers. In addition, it interfaces through a Digital I/O interface to display status information as a backup to the monitoring application.
Confidential
- Business Objective: After Areva NP acquired Framatome, they wanted to implement Framatome's DeCAP system across Areva NP. Due to various constraints imposed by Areva NP, changes were required to conform to their environment. Chief among these was the requirement to use Oracle as the DBMS rather than SQL Server.
- Results: The application was updated to allow access to both Oracle and SQL Server DBMSs. In addition, because of upgrades to both Oracle and SQL Server, access was allowed to both Oracle 8 and 9 as well as SQL Server 7 and 2000.
- My Role: I was responsible for identifying the changes that needed to be made, implementing, and testing them. The implementation was done in such a way that future data access changes could be implemented with a greatly reduced level of effort.
Confidential
- Business Objective: HJA had sold a third party software package to Duke Energy to be used in their collections department. Shortly after implementation, the software developer decided that they would only support Hospitals and so Duke Energy would be left without support. HJA contracted with QSI to develop a product with the equivalent functionality.
- Results: The new application was installed at Duke Energy without loss of productivity and with additional functionality.
- My Role: I was responsible for integrating QSI's Query Tool report write into the new application to produce reports and letters.
Confidential
- Business Objective: After Framatome acquired Duke Engineering Services, they desired to re-design WebCAP to become a more marketable application. The existing WebCAP had hard-coded screens to handle a single process.
- Results: The new application version of the application was developed to have 20 pre-defined steps that could be configured and used by multiple processes. Additional steps were taken to allow the configuration of the fields and signatures visible on each step to provide a more customizable system.
- My Role: I was responsible for re-design of the database and application. I also acted as lead developer to manage the development team to ensure that all functionality was implemented correctly.
Confidential
- Business Objective: NMP purchased Duke Engineering Services' WebCAP application and contracted QSI to implement the application along with a set of enhancements.
- Results: The new application was installed at Duke Energy without loss of productivity and with additional functionality.
- My Role: I was responsible for database design and data layer development as well as conversion of data from the legacy system into the new system.
Confidential
- Business Objective: Diablo Canyon purchased QSI's Trending application and agreed to be the test site during development.
- Results: The new application was installed at Duke Energy without loss of productivity and with additional functionality.
- My Role: I was responsible for designing the architecture of the new application and then all database design and data layer development.
Confidential
- Business Objective: Duke Energy needed to replace their Safety Tagging application that was a mainframe Natural application due to the cost of maintaining the application. Another vendor was working with the project team to replace the application with a Windows-based Client/Server application. Inexplicably the completion of the application was not a priority for the vendor, however was a priory for Duke Energy, I was brought onto the team to interface with the vendor to get the application completed.
- Results: It quickly became apparent that a continued relationship with the vendor would only prolong the project to an unacceptable timeframe, so an in-house solution was proposed, accepted and completed, getting buy-in from three Nuclear Sites as well as Corporate Office.
- My Role: I was responsible initially for interfacing with the vendor, and then after proposing the in-house solution, lead the design and development to complete the application and still make the implementation date. Working with Equipment team, I was able to leverage the build upon the architecture developed for their applications to integrate Safety Tagging functionality into their system.
Confidential
- Business Objective: Duke Energy implemented a new DB2 based mainframe application called Passport to track equipment at the various Nuclear Sites. In order to ensure that the data in the system was complete and correct, they needed a way to validate all fields related to a piece of equipment. Once validation was complete the application would be discarded.
- Results: A Windows-based Client/Server application was developed to all marking data as verified in a shadow database. An un-foreseen result of the project was that the validation program was considered to be far superior to the Passport functionality that the application was never discarded and became the user interface for the equipment database.
- My Role: My initial involvement with the project was to design the system for validation. Although the coding was done by others, after it became apparent that the application was not going away, I was brought back into Equipment Team to design and develop a more robust and extendable architecture because of the additional functionality that was being integrated into the system.
Confidential
- Business Objective: JGR operates two NASCAR racing teams. One of the greatest challenges faced during a race is to determine the best time for the driver to make a Pit Stop. NASCAR operates a wireless modem feed that could be read by used to monitor the position of the cars during the race. JGR wanted to use that information to help make critical decisions.
- Results: A Monitor application was developed to allow the race team to monitor the positions of the cars and calculate their consumption of fuel and tire wear. In the first year that the application was used, the 20 car, driven by Tony Stewart, was the winning driver for the year.
- My Role: I was tasked with designing and developing the Monitor application as well as a Service to read the wireless feed. As the only developer on the team, I also represented QSI as the Project Manager.
Confidential
- Business Objective: The Company produces a bottle filler that is controlled by a collection of Station processors communicating with a MidUnit processor, which in turn is connected to a PC used by the Operator to control and monitor the Weigh Scale Filler. The Station and MidUnit processors were expensive custom built boards. The Company desired to have an off-the-shelf replacement for the MidUnit processor.
- Results: By removing the MidUnit processor completely and moving its function to the PC, the entire cost of the MidUnit was replaced as well as hardware failure point. By adding an interface card for RS-422 communication with the Station processors and an interface card to control Digital I/O the hardware functionality was duplicated on the PC. A new Service was written for the PC to replace the software running on the MidUnit processor. A cost savings of over 50,000 was achieved on each Weigh Scale Filler.
- My Role: I was responsible for researching the replacement options for the MidUnit processor and determined that the greatest cost savings, both initially and during the life of the Weight Scale Filler, could be had by using the processing power of the PC., the removing the MidUnit processor completely and moving its function to the PC, the entire cost of the MidUnit was replaced as well as hardware failure point. I was then tasked with developing the Service to replace the MidUnit software as well as an interface DLL to allow the Weigh Scale Filler software to operate without change in both the Hardware and Software MidUnit environments.
- Because of my prior work with US Bottlers on the Weigh Scale Filler software, I was familiar with the environment and knew the challenges faced in implementing and maintaining a Weigh Scale Filler. I also brought knowledge of hardware interfaces. I was then able to bring to the Company's attention the possibility of cost savings through modernizing their hardware and software.
Confidential
- Business Objective: RTTI wanted to develop a CRM application that would have as its major selling point, the ability to produce and track quotes/purchase orders for configurable equipment.
- Results: Beacon was developed to implement the functionality desired in the CRM solution. In addition to functionality provided by Beacon, it interfaced with Word and Excel to produce documents and with Outlook to send and receive email that could be tracked by the system.
- My Role: Working with the RTTI, I designed the architecture of the system, performed all database design, and developed the application and its interfaces with Word, Excel, and Outlook.
- I also was responsible for implementing the system at the first couple of customer installations and addressing all issues that were identified to ensure the success of the implementation and the satisfaction of the customer.