http://bphillips76.spaces.live.com
Summary
Software architect and senior partner with Composable Systems, LLC specializing in service-oriented business solutions using the latest Microsoft technology. Worked with Microsoft development technology since 1997 and holds the Microsoft Certified Solution Developer (MCSD), Microsoft Certified Database Administrator (MCDBA), and Microsoft Certified Systems Engineer (MCSE) certifications. Contributes regularly to the Microsoft development community by speaking on topics such as Smart Client, ASP.NET, BizTalk, SQL Server, and Mobile development, presenting DevCares courses, and blogging on topics of interest to developers. Technical director for KY.Net Developers Association. Charter member of Microsoft ArcCouncil in Louisville. Microsoft Most Valuable Professional (MVP) in Client Application Development.
Skills
• Oracle 7.34-10g, SQL Server 4.21-2005, SQL Server 2005 Analysis Services, Essbase 6.5
• .Net 1.0-2.0, ASP.Net, Visual Basic, C#, Visual C++ 6-8, Smart Clients, Mobile Clients
• Windows Workflow Foundation, Windows Communication Foundation, K2.net Enterprise Workflow, Bluespring
• p&p app blocks and factories: composite UI, smart client, mobile, enterprise library, updater
• ActiveReports.Net, Crystal Reports 7-10, SQL Server Reporting Services
• REXX, JCL, z/OS, TSO, FOCUS
• Rational Suite, UML, Rational Unified Process, Extreme Programming, Agile
• Sagent, BizTalk 2002-2006, DTS, SQL Integration Services
• PeopleSoft 7.5, SmartStream 6.5, Microsoft CRM 1.2-4.0, eConnect for Great Plains
• SharePoint 2003-2007
Certifications
• Microsoft Certified Systems Engineer (MCSE) NT 4.0, Exchange 5.5, Windows 2000, Windows 2003
• Microsoft Certified Database Administrator (MCDBA), SQL Server 7.0, 2000
• Microsoft Certified Systems Engineer Developer (MCSD) VB6, C#
• Microsoft Certified Professional Developer - Enterprise (MCPD) – In progress
• Microsoft Certified IT Professional (MCITP) SQL Server 2005 – In progress
• Oracle PL/SQL
• Six Sigma Green Belt
• Project Management Professional (PMP) – In progress
• Microsoft Most Valuable Professional (MVP) in Client Application Development.
Engagement History
State-Level Chamber of Commerce Organization
SharePoint 2007 / Forms Server / CRM 3.0 / Bluespring project
• Designed and implemented dual-authentication SharePoint-based bid management application. Application was workflow and document driven. Architecture allowed end-users to modify all parts of the application with minimal assistance from IT.
• Extended SharePoint to support anonymous audiences.
• Created custom web parts to extend Form Server functionality.
• Integrated SharePoint with Bluespring workflow and Microsoft CRM.
Created CodeSmith templates to automatically generate browser-enabled InfoPath forms and the workflows needed to consume those forms.
Print Management Company
BizTalk 2006 /SharePoint 2007 / Reporting Services project
• Created fault-tolerant BizTalk application integrating thousands of POS terminals at client locations in North America with a print campaign management system which processed millions of customer transactions to create custom print mailings.
• Created CodeSmith templates to automatically generate multi-level schemas used in SQL UpdateGrams.
• Created an automated process to migrate legacy database to new platform using a mapping spreadsheet and the NetTiers generated object layer.
• Created a Reporting Services Report Model to replace existing reports and allow end-users to modify their design and create new ones.
• Created OLEDB driver to allow SharePoint lists to be used as relational data sources.
Tier 1 Automotive Logistics Company
Smart Client project
• Re-platformed existing 24/7 shop floor application by converting Access applications to web forms and windows forms applications.
• Partitioned application functionality into CAB modules and consoles according to job roles.
• Implemented ClickOnce for application updates.
• Rewrote code base for Windows CE 4.2 and 5.0 clients to support any generic hand-held scanner vendor.
Investment Management Company
BizTalk / CRM project
• Create a generic framework allowing dynamic mapping of legacy data to CRM entities with end-to-end exception handling.
• Created CLR stored procedure to send messages to BizTalk HTTP adapter.
• Created CLR stored procedure and associated Service Broker objects to manage message queues destined for BizTalk.
Mortgage Industry Independent Software Vendor
Smart Client project
• Created a best practice proof of concept using .Net 2.0 and smart client technology.
• Integrated Enterprise Library and the Composite UI application block to create a rendering engine that can dynamically layout Windows Forms controls and bind them to generic data sources.
• Designed form designer for rendering engine.
• Designed partially connected architecture for off-line data access with synchronization capabilities.
Training Center Management Company
BizTalk / CRM / Great Plains project
• Interviewed stakeholder and gathered functional requirements.
• Implemented eConnect and MSMQ queues to integrate BizTalk and Great Plains.
• Created a custom adapter in BizTalk 2004 to allow records to be sent to CRM 1.2.
Supply Chain Company / Franchisor
Commerce Server project
• Created and implemented a process for migrating Site Server 3.0 to Commerce Server 2004.
Heavy Equipment Manufacturer
ASP.Net project
• Lead the development of an ASP.Net six sigma application for analyzing marketing and customer data.
• Used custom Enterprise Library application blocks for configuration.
• Integrated with third-party single sign-on service.
Domestic Products Manufacturer
Windows Forms project
• Upgraded Windows Forms shipping application to use new Adobe Acrobat 7.0 with digital signature functionality.
• Tuned SQL Server for FileNet installation.
State Level Public Agency - Department of Transportation
SharePoint 2003 / SQL 2005 Analysis Services project
• Developed web part to allow end-users to build their own MDX queries and browse cube data from SQL 2000 and SQL 2005 servers.
• Developed web part to allow end-users to retrieve GIS maps and data linked to the cube web part above.
State Level Public Agency - Department of Transportation
K2 workflow / SharePoint 2003 project
• Developed a long-running 20 step process using K2.net Enterprise Workflow and InfoPath.
• Created a custom InfoPath form using the .Net Toolkit for InfoPath to enforce custom business rules before the form could be submitted.
• Created a custom SharePoint web part to allow the users to view their tasks for a single K2 process and allow the users to dynamically configure the destination users for tasks and emails.
Heavy Equipment Manufacturer
Smart Client project
• Managed the development of a Windows Forms engineering application using Smart Client technology. Translated into 6 different languages and dialects.
• Used updater application block to enable world-wide deployment of application and database updates.
• Created an add-in for Visual Studio.Net 2003 to automate the creation of application updater block manifest files and MSI packages.
• Developed Used the Windows Installer SDK to enrich the dialogs in the MSI packages created by the Visual Studio setup project.
• Wrote a managed C++ wrapper to encapsulate Window’s security API for use in the C# custom installer classes.
• Wrote a shim in unmanaged C++ to remedy Intellisense file locking bug in Visual Studio IDE.
Investment Management Company
ASP.Net project
• Created an application suite to perform a metadata based conversion of Microsoft Access applications to the ASP.Net platform with SQL Server 2000 as the back-end database with very little manual intervention. This tool migrates all tables, indexes, queries, forms, macros and modules to appropriate objects in the ASP.Net and SQL Server namespaces. Reports are converted using the import wizard in SQL Server reporting services. The resulting application is automatically ready for parallel testing.
• Used the tool above to convert the company’s compliance trading system, containing hundreds of Access objects, to ASP.Net and SQL Server 2000 in 1 week with only 1 bug reported. For 3 years previous to this, all other attempts had failed.
• Used the tool above to convert 2 other enterprise level Access applications to ASP.Net and SQL Server 2000.
• Created an enterprise level ASP.Net application that managed the market index data used in bond trading. The application integrated with other systems using database views and web services. Used the .Net Reflection namespace to provide object security at the page and control levels for all aspx pages that inherit from an internal base class. Integrated the spreadsheet control from the Office Web Components to provide mass update functionality with an Excel look and feel. Integrated with Active Directory to obtain email address for alerts and group membership for rights assignments.
• Created an ActiveX component in Visual C++ 6.0 to disable ActiveX warnings when creating COM objects in vbscript and javascript in Internet Explorer. Relieves IT personnel from visiting each machine to change Internet Explorer security settings while maintaining the same level of security when accessing Internet sites.
• Created a module in Visual C++ 7.0 that used the detours library to intercept Win32 API calls and effectively allow legacy console applications to be called from backend processes without the burden from stdio handles.
• Create a tool to report on the properties of DTS packages in the msdb database and optionally move those DTS packages to another server while allowing the developer to change the database connection information contained in them.
• Created a Visual Studio Integration Partner (VSIP) package to extend Visual Studio.Net 2003 to provide metadata driven application design similar to that found in the PeopleSoft’s Application Designer and PeopleTools products.
• Discovered a hack to allow ASP.Net applications to access Active Directory without appropriate privileges using the Win32 function RevertToSelf.
• Currently starting a project to replace a legacy middleware system with BizTalk 2004.
• Currently creating an end-user reporting wizard for use with SQL Server Reporting Services with ASP.Net as the user interface.
Credit Card Processor
ASP.Net / Workflow / SmartStream project
• Lead a team of 4 developers in support and development of 6 enterprise wide applications.
• Created a data interchange application to submit jobs to the mainframe JES via FTP, check their processing status, and parse their output into Excel formats.
• Created an end-user designer to allow users to create their own reports based on Essbase cube data.
• Automated the transformation, verification and transfer of 18 GB of data from various systems for month end reporting.
• Created extended stored procedures using Visual C++ 7.0 on SQL Server 2000 to access low-level console functions not provided by xp_cmdshell.
• Developed and maintained various VB.Net and C# applications and migrated applications from VB 6 to VB.Net.
• Created an application to automate the duplication of any program's user interface by using native Win32 API calls.
• Created a VB.Net/C# component that can evaluate Excel formulas for use in user-configurable business rules and calculations.
• Created a VB.Net component that can write native Excel binary files eliminating the need to use Excel for server-side processing.
State Level Public Agency - Department of Education, Pre-Kindergarten
ASP.Net / BizTalk / VSTO project
• First .Net state level implementation in the education sector nationwide.
• Length: 2 years. Cost: $2.6 million.
• Lead a team of 8 developers and all aspects of development throughout the lifecycle of the project.
• Used TripleDES encryption to protect sensitive data in the database.
• Served as the database administrator of this application’s database which contained 1,200 stored procedures and 600 tables.
• Wrote an object oriented language independent code generator based on XML representations of database metadata and XSLT which produced 50% of stored procedures and 85% of non-UI code in this application.
• Wrote a letters and forms management system based on Microsoft Word, .Net Web Services, and SQL Server 2000 which would store template documents in the database and retrieve them for data merging and printing.
• Extended the VB.Net port of Visual SourceSafe 6.0 to provide source control management for database views, stored procedures, and functions.
• Wrote ASP and VB 6.0 SOAP clients to access .Net Web Services to integrate existing client applications with this project. (Much of the data in the application is encrypted.)
• Wrote a self-service ad-hoc report tool for use by power users and junior developers featuring database independence, easy integration with ActiveReports or Crystal Reports, and custom formatting and layout available at the end-user's fingertips. The cost benefit averaged $50,000 per year per project.
• Wrote an automated code reviewing tool to check code for department standards using Regular Expressions. Allowed immediate review of all code before publishing to QA.
• Wrote an Application Integration Component for BizTalk 2002 allowing dynamic data import and export from the web application using the BizTalk Mapper as the transformation definition tool.
• Wrote an application engine allowing developers to concentrate on sound database design, proper implementation of business requirements, and rich user interfaces while reducing errors introduced into the system by writing and fixing errors in custom code in the data access, business logic, and presentation layers.
Speaking Engagements
Microsoft DevCares – Windows Workflow Foundation, Indianapolis, IN July 2006
Microsoft DevCares – Source Control with Team Foundation Server, Louisville, KY December 2006
Microsoft DevCares – Microsoft ASP.Net AJAX, Louisville, KY January 2007
KY .Net User Group – Preparing Your Applications for Windows Vista, Louisville, KY January 2007
Microsoft DevCares – Windows Vista - Connect with Users, Louisville, KY February 2007
KY SharePoint SIG – Windows SharePoint Services - Deep Dive, Louisville, KY March 2007
Microsoft DevCares – Microsoft Office 2007 as a Platform, Louisville, KY March 2007
Microsoft DevCares – Internet Information Server, Louisville, KY April 2007
Microsoft DevCares – Visual Studio Orcas / LINQ, Louisville, KY May 2007
Work History
Composable Systems, Inc, Louisville, KY 1/2007-present
Senior Partner/ Solutions Architect
Crowe Chizek and Company, LLC, Louisville, KY 6/2005-12/2006
Senior Architect / Practice Manager
ING Investment Management, Atlanta, GA 6/2004 – 6/2005
Senior Developer
Nova Information Systems (US Bank), Atlanta, GA 9/2003 – 5/2004
Lead Developer
Enterprises Computing Services, Woodstock, GA 4/2002 - 8/2003
Lead Developer / Software Architect
Syngenta, Greensboro, NC 9/2001 - 4/2002
Lead Developer / Database Administrator
Centers for Disease Control and Prevention, Atlanta, GA 4/2001 - 9/2001
Lead Developer / Database Administrator
Amplified.com, Atlanta, GA 4/2000 - 2/2001
Database Administrator / Developer
Atlanta Systems Consultants, Atlanta, GA 9/1999 - 4/2000
Database Administrator / Developer
Curtis 1000, Atlanta, GA 10/1998 - 9/1999
PeopleSoft / SQL Server Administrator
CDI Information Services, Morrisville, NC 12/1997 - 09/1998
System Administrator
Education
Excelsior College, Albany, NY 4/2002 - Present
Bachelor of Science - Computer Information Systems (3.9 GPA)
Military
United States Army, Fort Bragg, NC 6/1994 - 10/1997
Spanish Linguist / Intelligence Analyst
• Graduated the Defense Language Institute - Basic Spanish course with the highest rating (3, 3) on the Defense Language Proficiency Test.
• Graduated the 98G Voice Interceptor course at Goodfellow AFB, Texas as a Distinguished Graduate by ranking in the top 5 percent of the class.