Expertise
I have years of experience helping organizations in positioning technology to support organizational transition and transformation. Although this has involved a wide variety of technology platforms my experience with vertical business solutions is focused primarily in three (3) areas:

• Communications including Telephony (Primarily AT&T and Bell Labs) – 25+ years and
  Collaborations via Synchrony (which includes interaction flow controls, workflow controls and case tracking)
• Energy Utility (Primarily Duke Energy) – 6 years
• Healthcare
  (working directly with healthcare providers and additionally with Cincom and IBM in product offerings) – 2 years
  

My expertise is in planning, design and implementation of database systems for a broad range of solutions including 24 by 7 (continuous operations) platforms, web-services, administrative systems and data warehouses. I also have many years of experience in technical team organization, development and management.

Mandatory Technical /Functional Skills:

• Process Design , Solutioning and building the architecture model from Requirements
  I have decades of experience defining and clarifying business requirements, translating business requirements into architectural plans and technical requirements and then turning that body of information into phased project plans. This includes experience from multi-organization undertakings within Bell Labs (where I served as Chief Architect) and Duke Energy to single organization product development efforts (where I served as CTO) and single man Healthcare reporting projects.
  
• Strong experience in ETL Design (has prior development and design experience in ETL)
  I have developed several ETL processes within Bell Labs and Duke Energy. The datahub approach within Duke Energy required near real-time data synchronization across platforms that included Oracle, MS-SQL and DB2 environments. The datahub synchronized several operational systems, customer portals and data warehouse systems.
  
• Creating LSDD, Concept documents, Solution approach document, Solution Design document.
  I have documented solutions in several fashions depending on the solution and situation. At CINCOM, I worked with IBM to document system interaction flows, background process flows and workflows to support “Care Coordination” including using HL7 and ICD-10 examples. In other situations, I have documented solutions that were more focused on “Best Practices” surrounding the systems and even the use of proper “Organizational Incentives” to ensure engagement with the Best Practices.
  
• Strong experience in Requirement gathering from Business and then translating to technical and functional requirements.
  I have experience in requirements gathering from both traditional Life Cycle development approaches and from Agile development approaches. At Duke Energy, I led traditional requirements gathering workshops to gain consensus from stakeholders while at Synchrony Communications and at TF Logic, I used an Agile approach that included prototyping and monthly cycle deliverables. In the Agile approach, the documentation would typically include a set of power point presentations to outline options for upcoming monthly deliverables representing the logical UML data-class structures and process outlines and when appropriate Screen-Shot or report prototypes.
  
• Performance Tuning Skills when creating the design - optimization.
  i have done significant performance tuning of databases and have managed several benchmark efforts that measure the overall performance. These efforts usually occur during development cycles but have been used to evaluate design options.
  
• Strong communication and Client facing skills
  I rely on power point, word documents and issue/case tracking to bring out the most important factors of the solution to ensure that all stakeholders can gain a perspective on impacts that must be managed within their “Best Practices” or other processes and procedures. The overall success of a project means that no one gets surprised and has ample time to evaluate options and integrating new tools.
  

Desirable Technical /Functional Skills:

• Healthcare background.
  Most of my Healthcare background has come from working with the IBM Healthcare vertical organization to prepare an integration of their products with the CINCOM products to coordinate multi-faceted treatment plans with clinics, therapists, nutritionists, family caregivers, etc. The other experience relates to single man projects with a group of doctors to provide reports to help optimize payments and with a group of lawyers to mitigate risks.
  
• Strong DBMS concepts (Oracle).
  I have 30+ years of experience with databases including Oracle. I have designed, implemented, tuned and re-developed other people’s un-optimized database designs.

Kindly complete the following skill Matrix and send back with your updated resume:

• Degree Major: Computer Science (R&D Management)
• Total IT Exp: 30 years
• Total exp as Solution Architect: 20 years
• Total exp with ETL Design: 10 years
• Total exp with healthcare domain: Approximately 2 years
• Work status: Available
• Expected Hourly rate: $125
• Whether it is w2 or C2C: C2C
• If C2C, please specify the corporation name: Wilson Consulting
• Available time slot for phone interview: Afternoons
• Current Location: Cincinnati, Ohio
• Are you able to relocate on your own expenses?: Maybe

Professional Experience

11/2011-10/2012 CTO (Chief Technology Officer) (Confidential)
I provided the technical vision for Confidential platform that supports real-time interaction guidance as part of the Synchrony Communications platform. The interaction guidance features are designed to provide scripting of interactions that can adapt to situations, personal preferences and the “personas” of the target audience. The guidance was designed to support multiple interaction channels including phone, email, chat, face-to-face including conferencing situations where any number of people can be designated as the addressees versus the subjects of the conversation.
(The initial target market for the platform is healthcare ACOs (Accountable Care Organizations) and Utility companies.) 

5/2011-11/2011 Architecture Vision and Business Plan (Confidential)
I provided the overall design along with Time & Cost (T&C) estimates and the organization ramp-up plan for the development of Smart-Homes within Smart-Neighborhoods within Smart-Communities. I also provided the overall outline for all technology RFPs (Request for Proposals) as the initial focus of developmental activities. 

5/2010-5/2011 MDM (Meter Data Management) & SmartGrid Consulting(Confidential)
For Confidential: I developed an RFP (Request for Proposal) for an MDM system which was transitioned into a Requirements Document which Duquesne used with their statement of work (SOW) for the MDM component of the overall project.
I also worked as a contributing member of the AMI (Advanced Metering Infrastructure) team which was lead by R.W. Beck to publish an RFP for AMI technology. I participated as part of the Duquesne “Core Evaluation Team” to perform vendor selection and implementation planning (to date).
For Confidential: I provided MDM development team oversight serving Lakeland Electric as a subcontractor of SAIC. My role was primarily as a reviewer/coach and occasionally as a contributor to keep the cost model down while ensuring that the delivery team was successful. (SAIC did the primary project management).

11/2009-5/2010 MDM Architecture Design(Confidential)
I developed a high level design and related Whitepaper for a new product offering related to energy management for utilities, “green builders” and for home energy management.

8/2005-11/2009 EDM/MDM Architecture Design(Confidential)
I worked on the pre and post merger teams (Duke/Cinergy merger) to define the vision and architecture for Energy Data Management (EDM) which is a slight expansion of what the industry calls Meter Data Management (MDM). This effort included conducting workshops to spread the vision and gather requirements, contribute to the RFP (Request for Proposals), coordinating with my business counterparts for vendor selection efforts and developed a major part of the related business case.

My contribution to the project includes the overall architectural solution, the logical and physical database designs, interface designs for integration of meter reading head-end systems, interfaces for integration of meter characteristics and meter programming, batch interfaces to billing systems and other downstream users such as Load Research, Distribution planning and transactional services designed to support web, IVR contact-center and Outage Management integration.
Technical Skills required: Oracle Database Design (PL/SQL), Oracle Lodestar

1/2005-8/2005 Meter Tracking Architecture Support (MTS)(Confidential) 
I provided architectural liaison support to the vendor for this project. Technical Skills required: Oracle PL/SQL.

1/2005-8/2005 AMR/AMI Architecture Design(Confidential)
I provided the information systems architecture and analysis support for this ARM/AMI (Automated Meter Reading / Advanced Metering Infrastructure) project. This project also identified the need for a Meter Tracking System and Energy Data Management system. Technical Skills required: UML/ERD Data Architecture.

8/2004-3/2005 Capital Expenditure and Risk Management (CapEx)(Confidential)
For this project I provided the analysis and design of data hubs and processes to provide better visibility to conditions that planners should be aware of as they develop capital spending plans and provides them with the ability to properly represent risks associate with doing or not doing a project and integrate the complete justification/risk picture into a project portfolio management tool. 
Technical Skills required: UML/ERD Data Architecture – Oracle PL/SQL & MS-SQL.

3/2004-7/2004 Data Base redesign – Confidential
I redesigned an existing database to enhance performance and scalability. This included content management as well as the e-commerce elements. MS-SQL Server and XML.

10/2002-3/2004 Data Architect – Confidential
I developed a data architecture for the content management associated with automotive listings, and auction management of vehicles in the eBay marketplace. This includes contact management and some limited CRM functionality. MS-SQL Server and XML.

8/2002-10/2002 MediSoft – Confidential
I developed a reporting system focused on a Therapist-Office use of the MediSoft practice management system. This includes reports for all scheduling and account management functions along with various “Action Audits” for tracking a number of account conditions. MS-Access used for reporting.

8/2002-9/2002 Confidential
I developed a reporting system for a local law firm as a stopgap solution to a long range “study control system”. The system is based on MS-SQL Server as the database with various views to establish “top down” and “bottom up” views of the data and uses MS-Access for report formatting.

6/2000-8/2002 CTO (Chief Technology Officer) Confidential
I trained and lead the engineering team to develop a product known as ThinkingFolders, which is a web-based repository with an integrated rules engine to support workflow control functions. The repository includes the support of WebDAV protocols for document-oriented services along with XML/SOAP services for all other data oriented objects. The product supports a very granular access control (grant) model that allows the users to share any kind of object with other users within the context of a site and between sites via inter-site affiliations. The platform uses MS-SQL Server and java based web-technologies.

Activities within the repository can trigger routine based rules to execute various actions on behalf of the user. The services are controlled and configured through what we call site-policies and user defined templates. The combination of the template model with execute-only access rights is designed to allow channel partners to provide third-party functionality while maintaining their own proprietary controls over their solutions. These templates can be grouped into libraries to support vertical solutions such as HR, e-learning, event administration, etc.

ThinkingFolders is based on a very robust data model that defines all objects, rules and other forms of data and meta-data that control all elements of work-flow, version management, web-service definition along with all forms of condition tracking and control.