Technology, Software Programming, Risk Assessment, Business Analysis Expert Consultant Resume
{/sliders}
Resume of BOL
{/sliders}

  • Technology
  • Software Programming
  • Risk Assessment; Business Analysis
  • Project Management
  • Public & Private Sectors

A senior consultant capable of implementing optimal, and/or leading-edge solutions. Worked with a wide array of programming languages, database systems, and other software products to architect and deliver the best solutions to meet customers’ needs.

Through extensive and varied experience, acquired the skills and knowledge-base that allow quick and effective solutions. Provides strong technical skills and a deep understanding of the dynamically changing technological environments by keeping abreast of emerging technologies. Several areas of expertise include: technical project management, development of documentation specifications, systems development life cycle (SDLC), project risk assessment, business analyst, and team management, to list a few.

Consultant, Kevin Kennedy Associates, Inc.
Providing expert technology, programming, and business assessment consulting services to a wide variety of clients.

 

Data Warehouse / Solution Architect, UPSIDE Commerce, Redmond, WA
(Core technologies; Microsoft Stack,Visio for Enterprise Architects.)
Developed architecture and processes flows diagrams for the conceptual design documents to implement a data warehouse reporting solution that would integrate and analyze sales data from a myriad of ERP systems. This solution would leverage the following technologies; XML, XSD Schemas, custom ETL processes, SSIS, SSAS, MS SQL Server 2008, MSMQ, C# in order to transform data from the staging server into the NDS and DDS data stores for reporting purposes.

 

Project Management / Solution Architect, The Resonance Group, Seattle, WA
(Core technologies: T-SQL Scripts, SQL Server 2008, ASP.net and C#)
  • Engaged key stake holders in order to properly gather and document business requirements, develop project timelines, and assess project risks.
  • Re-designed logical and physical data models, views and procedures based on newly gathered requirements.
  • Architect and implemented the reporting solutions data access (DAL) and business logic layers (BLL) that afforded marketing companies the ability to analyze their customers’ response survey data across heterogeneous data sets. The scorecards and reports generated from the collected survey data help the agencies understand their customers’ perceived effectiveness of the marketing campaigns, and branding strategies the agencies developed for their customers’ targeted audience.
Solution Architect, Microsoft Corporation, Redmond, WA
(Core technologies used; WCF Services, C#, Assembly, Windows 2008 Server, Windows 7, NET 3.5, Visual Studio 2008, SQL Server 2008, Team System and LINQ.)
  • Created the conceptual design for this solution to allow customers a one click solution for Microsoft anytime upgrade utility by leveraging SOA methodologies and WCF capabilities. This solution will allows any Window 7 users the ability to upgrade their operating system electronically to a version that will best suit their computing needs from an e-reseller of their choosing as it will integrate with and / or replace the standard windows anytime upgrade utility included with the operating system.
  • Developed the single click upgrade solution prototype for Microsoft’s Windows 7 product line by using C#, WCF Services, ASP.net and SQL Server 2008.
Consultant, Direct Technology, Data Architect , Microsoft Corporation, Redmond, WA
(Core technologies used; C#, SQL Server 2005-2008, XML, Stored Procedures ( T-SQL ), WCF Services, Windows 2003 Server, .NET 3.5, Subversion (SVN), Visual Studio 2008 Team System, Visio for Enterprise Architects and LINQ.)
  • Engaged key stake holders in order to understand and define business requirements and outline risk associated with changes needed for the production environment due to new requirements needed by the public relation managers representing thirty-five international agencies.
  • Re-architect, documented and implemented the PRIME central physical data warehouse to support newly defined requirements.
  • Designed data models to prototype the logical design in order to make sure newly requested requirements could be seamlessly integrated into the production environment without extensive downtime and to make certain new requirements for the international user base were supported.
  • Re-designed and implemented data tier layer (stored procedures, C#, T-SQL) and business tier layer (C#, WCF Services) in order to support new score card algorithms and data tree hierarchies for precise cross domain reporting analysis of public relation metric data using SQL Server 2005 / 2008, T-SQL, Stored Procedures, CTE Queries, C# and .NET 3.5.
  • Designed and implemented ETL data transformation interfaces to support current and unknown future data feeds for easy integration and implementation of data adapters for the PRIME central reporting data warehouse using C#, .NET 3.5, XML and LINQ.
Solution Architect , Microsoft Corporation, Redmond, WA
(Core technologies: C#, Sockets, SQL Server, MOSS 2007, SharePoint API, Moodle, PHP, T-SQL, Active Directory, mySQL, SharePoint Web Services, Visio for Enterprise Architects and Microsoft Solution Framework [MSF].)
  • Gathered and developed business requirements for the Office SharePoint Server 2007 / Moodle Integration solution by interviewing key stake holders using Microsoft Solution Framework (MSF) methodologies, and best practices in the envisioning and planning phases for the vision / scope, conceptual, logical and physical design documentation.
  • Architect and designed the logical and physical data models for the integration of the Office SharePoint Server 2007 and Moodle (Modular Object-Oriented Dynamic Learning Environment) / mySQL environments. This solution allows universities and schools within their domain bi-directional data and document transmissions and searching capabilities across multiple Moodle instances from a central SQL Server / Office SharePoint Server 2007 hybrid repository.
  • Designed and deployed the development environments. These test and development labs consisted of Office SharePoint Server 2007, MS SQL Server, Active Directory, DNS, mySQL, Apache, PHP, custom web services and Windows 2003 Server hosted in VMWare 2.x.
  • Designed and created a custom auto discovery network crawler to locate all Moodle instances across the enterprise domain. This crawler allowed real-time data communication between Office SharePoint Server 2007 and multiple Moodle instances. The technologies used were C#, TCP/IP, Sockets, SQL Serve.
  • Developed custom interfaces to synchronize modified Sharepoint list data and document libraries with Moodle based data and documents using C#, MS SQL Server 2005, Sharepoint API, Windows SharePoint Services Web Services, and MOSS 2007.
Data Warehouse / Solution Architect , Microsoft Corporation, Redmond, WA
(Core technologies; MS SQL database servers, custom XML / XSD schemas, C#, Stored Procedures ( T-SQL ), LINQ, .NET 3.5, Active Directory, DNS, LINQ, Visio for Enterprise Architects and Microsoft Solution Framework [MSF].)
  • Facilitated and led the collaboration and development of the business requirements for the Public Relation Insights and Measurement Effectiveness (PRIME) initiative by interviewing key stake holders within different business divisions at Microsoft as well as third party Public Relation Agencies. This solution would allow for seamless metric reporting and dashboard data integration of the PRIME metric data between the different Microsoft marketing groups which was not previously possible. In addition, this solution also helped Microsoft’s product teams better position their marketing dollars by analyzing the metric data against different campaigns run throughout the fiscal year.
  • Applied best practice methodologies in the development of documentation by using Microsoft Solution Framework (MSF) to define the: Vision and scope of the project, Documentation of the conceptual, logical and physical design, Risks associated with the project and Current and Future milestones of the project.
  • Architect and implemented Microsoft’s PR Insight Measurement Effectiveness (PRIME) data warehouse reporting solution for marketing executives, product teams’ managers and business group leads to afford them the ability to analyze and research the PRIME metric marketing data captured from external US and International public relations agencies.
  • Developed a scorecard reporting engine for Microsoft’s marketing teams to display the effectiveness of campaigns, events, publication and message perception of Product Teams’ targeted audiences. These reports also helped Microsoft to identify inaccurate scoring elements submitted by International and US based Public Relations Firms using C#, Excel Object Model, T-SQL scripts and Stored Procedures.
  • Designed ETL processes to import metric data from US and international based users.
  • Designed and deployed virtualized test lab environments to replicate production environments.
Consultant, DTC Systems, Inc.
Senior Consultant, Microsoft Corporation, Redmond, WA
(Core technologies; SharePoint Portal Server, Active Directory, SQL Server, Active Directory, C#, ASP.NET, Visual Studio, Microsoft Solution Framework (MSF) and Visio for Enterprise Architects)
  • Developed business requirements and architect the solution for the GSP Training Portal by interviewing US and International based stake holders, third party training vendors, field representatives and students using Microsoft Solution Framework (MSF) methodologies, and best practices in the envisioning and planning phases for the vision / scope, conceptual, logical and physical design documentation.
  • Managed the implementation and branding (look and feel) of the GSP training portal website by working with graphic designers and business partners of the GSP Portal Training Site.
  • Developed custom event handlers to assign permissions on selected list for field representatives’ access to class scheduling and student records.
  • Architect and managed virtual development and testing environments for the GSP Training solution using MS SharePoint Portal Server 2007, MS SQL Server 2005, Windows 2003 Server and Microsoft Virtual Server.
  • Developed custom user controls to interact with Active Directory for class scheduling.
Consultant, Nitefrog.com
Data Warehouse / Solution Architect, ArtSoft tm , Groveland, CA
(Core technologies; mySQL, SQL Server, T-SQL, NetBeans and Visual Studio and Visio for Enterprise Architects.)
  • Designed and developed proprietary ETL data extract and load algorithms of sales data records from internet commerce art related sites that would allow the clients of the ArtSoft system to:
    • Increase their sales revenue by displaying current market trends and projected times of days, size of piece, themes and categories of artwork to be sold
    • Allow coinsurers of art collectors the opportunity to study artist selling trends and price deviation in order to see if potential investment was consistent with their sales records over time.
  • Designed and implemented proprietary algorithms to forecast market values of up- and-coming artist that would allow investment opportunities for art collectors and galleries.
  • Architect and implemented ArtSoft’s database system to support clients'; sales and marketing analysis, metrics and eCommerce transactions using data normalization methodologies, OLTP, PHP5.x, mySQL, NetBeans and Apache Web Servers.
Senior Architect , TFC International, San Jose, CA
(Core technologies; MS SQL Server 2005, C#, T-SQL Scripts, Stored Procedures and ASP.NET 2.0.)
  • Architect and implemented a prototyped closed loop direct marketing solution to assist marketing companies in targeting and communicating with their customer base as well as track and report on key performance metrics using MS SQL Server, T-SQL, Stored Procedures, C#, ASP.NET 2.0.
  • Designed and deployed a customized (ETL) data transformation services to extract marketing data from a vast array of proprietary client databases into the TFC dashboard analytic data warehouse for use in their BI marketing application suite using MS SQL Server 2005, T-SQL, Stored Procedures, C#.
  • Architect and developed a direct marketing response tracking and reporting system that consolidated multiple disparate marketing response data sources that allowed marketing management (AAA) to track and analyze their direct marketing strategies to help them streamline the delivery of their marketing campaign for higher success rates using MS SQL Server 2005, T-SQL, Stored Procedures, C#.
Architect , Directors Desk, Spokane, WA
(Core technologies; XPS, NET 3.x, C#, SQL Server, ASP and Visual Studio)
  • Architect XPS integration with Directors Desk core solution by developing process flow diagrams using Visio for Enterprise Architects in order to facilitate programming efforts to keep project on track and on scope.
  • Designed and developed custom window services to automate the conversion of corporate documents into Microsoft’s XPS formatted documents for online viewing using Windows 2003 Server, SQL Server 2005, Visual Studio 2005, ASP, .NET 3.0 and C#.
  • Designed and implemented custom libraries and interfaces to expose XPS technology to antiquated ASP web-based applications for real-time compilation of corporate XPS documents into a single master board book for online and offline viewing of executive documents and financials using SQL Server, Visual Studio and C#.
Consultant , Groveland Community Services District, Groveland, CA
(Core technologies; Springbrook Accounting System, MS SQL Server, SCADA, Allen Bradley and HMI.)
  • Analyzed GCSD Supervisory Control and Data Acquisition (SCADA) and Water Management Systems system by interviewing key stake holder and field supervisors in order to document known and newly found issues within the current system as well as defining new requirements for the design and implementation of a new solution for GSCD water treatment facilities. This new solution would help bring the antiquated SCADA and Water Management Systems up to date and in compliance with governmental standards by: Using wireless technologies, Integrating an advanced Human Machine Interface (HMI) solution and Upgrading meters, RTU’s, sensors and remote stations. This would allow GCSD management and field supervisors the ability to efficiently monitor and collect system data in real time, therefore reducing risk of system failure due to antiquated devices, hardware and software that were in service.
  • Managed and architect the integration of GCSD district databases and Springbrook’s accounting solution in order to allow GCSD to report, analyze and forecast customers’ water usage to help allocate water storage for peak season cycles using Stored Procedures, T-SQL, C#, Excel for displaying key metrics and MS SQL Server 2000.
  • Managed the redesign and implementation of the district internal network to use a three tier firewall solution to secure district databases and customer billing information from the risk of outside intrusion as well as remove performance degradation of network data transmissions.
Consultant, NVision Consulting
Data Warehouse / Solution Architect, MACH Energy, Walnut Creek, CA
(Core technologies; Oracle, PL/SQL, C++, Delphi, Sockets, EDI and Windows Services,).
  • Designed, modeled and implemented MACH Energy’s utility analysis and billing data warehouse usage system.
  • Engineered automated tariff calculation algorithms for cost optimization and proprietary billing usage rules.
  • Developed and implemented custom ETL routines to import energy meter data and historical usage.
  • Designed and implemented import/export / ETL routines to extract data from the US National Oceanic & Atmospheric Administration (NOAA) ftp servers into MACH Energy data warehouse to track weather variances across US territories.
  • Setup replication processes between oracle servers to port data from data warehouse to web backend database servers.
Data Architect / DBA, KbaseOnline.com, Discovery Bay, CA
(Core technologies; Oracle 8i, Java, JDBC, Java, TCP/IP Sockets, SMTP, NNTP, Intermedia, PL/SQL Packages, Stored Procedures, utlsmtp system and triggers.)
  • Designed, implemented and maintained KbaseOnline Oracle 8i based data marts and databases.
  • Developed ETL import routines and search algorithms to extract and load data from a myriad of external feeds using Java, JDBC, Oracle Intermedia, PL/SQL, Packages and Stored Procedures.
  • Designed and developed the email engine / queuing system using Oracle utl smtp system package, PL/SQL routines, triggers and stored procedures to allow moderators and users of the forums up to the minute interaction to all new and updated postings.
  • Tuned and modified Oracle PL/SQL stored procedures by analyzing query execution plans, modifying / adding table indexes, re-ordering from and where clauses, updating table statistic as well as using hints to allow the optimizer to follow the correct execution path and maintain peak performance.
  • Automated data backup, updating of Intermedia indexes, table indexes and statistics using PL/SQL and Oracle based jobs.
Lead Software Architect, Solid Data Systems, Santa Clara, CA
(Core technologies; C++, Oracle 7.x / 8.x, UNIX, TCP/IP Sockets.)
  • Re-architect Solid Data’s I/O Dynamics for Oracle application that allowed administrator to monitor disk I/O and performance of Oracle server running on UNIX platforms. The application was created using C++, Visual Basic 6, Tee Charts Pro for graphing I/O file activity and distribution, Microsoft Active Data Objects (ADO), Oracle for OLE (OO4O).
  • Developed a custom telnet client for I/O Dynamics for Oracle to capture UNIX (Solaris, HPUX) systems drive statistics to help detect I/O contention and bottlenecks using C++ and Winsock 2.0.
Data Architect / Consultant, L9 EHealth, San Francisco, CA
(Core technologies; Oracle 8i, ASP, PL/SQL, C++, Sockets, COM, HIPPA Compliance, EDI.)
  • Designed an Oracle based database backend to interface with the United States Military health care management system that supports the Longevity9 health care management tracking system to track the care of military personnel with chronic diseases.
  • Re-Designed and implemented the Longevity9 health care management tracking system written in Visual Basic to an Internet/Intranet based application using Microsoft Transaction Server (MTS) Active Server Pages (ASP), Dynamic HTML (DHTML), JavaScript, VBScript, COM, Oracle 8i databases, PL/SQL stored procedures and packages and Internet Information Server 4 (IIS).
  • Tuned and modified Oracle PL/SQL stored procedures by analyzing query execution plans, modifying/adding table indexes, re-writing where clauses and using hints to allow the optimizer to follow the correct execution path.
  • Designed and developed a high-speed secure encrypted messaging and video server and clients for doctors and their patients to communicate securely (in conformity with HIPPA requirements) one on one in real time or in offline mode securely from any computer with internet access with L9Ehealth patented smartcard technology using C++, Delphi, TCP Sockets and Oracle 8i database.
Data Warehouse Architect / DBA, New Energy Ventures, Walnut Creek, CA
(Core technologies; EDI, Delphi, MS SQL Server 7, Stored Procedures, T-SQL and ETL)
  • Architect, designed and implemented corporate data warehouse to store energy meter usage for reporting, billing and marketing analysis, as well as integration of billing systems using MS SQL Server.
  • Re-designed and implemented a distributed Electronic Data Interchange (EDI) File Parsing Transfer Engine for maximum performance and removal of data redundancy and inconsistency. This redesign of the import utility for meter data was increased from 1 million records per 24 hours period to 2 million records per hour.
Database Architect / DBA, Visa, Hayward, CA
(Core technologies; MS SQL Server, Replication, TSQL, Visual Basic 6, CDO, Active Directory, C++. ADSI, Exchange. )
  • Designed and implemented database replication for Visa International corporate sites including Canada, Hong Kong, England, Singapore and United States using SQL Server 6.5 transactional based replication and 7.0 merge replication technologies.
  • Developed and maintained an intranet management event tracking system to provide communication between Visa international locations using SQL Server, Stored Procedures, Triggers, Visual Basic 6, Active Server Pages (ASP), Cold Fusion and JavaScript.
  • Created and implemented a Microsoft Exchange based workflow applications using MS Exchange Forms Designer 4.0, Visual Basic 4, Collaboration Data Objects (CDO) and MS Exchange Client 5.0 to facilitate administrative protocols such as creation and modification of Windows NT 4.0 and Exchange 5.0 Server user accounts.
  • Designed and developed an MS Exchange Server 5.5 service to import and modify new and existing exchange user accounts using Visual Basic 5.0, Visual C++ 5 and Collaboration Data Objects (CDO).
  • Created and designed an organizational charting program to illustrate the corporate organizational structure and modify Windows NT 4.0 and Exchange 5.5 Server group accounts using Visual Basic 5.0, Collaboration Data Objects (CDO), Lightweight Directory Access Protocol (LDAP), Active Directory Services Interface (ADSI) and Visual C++ 5.0.
DBA / Project Lead, Computer Curriculum Corporation, Santa Clara, CA
(Core technologies; Oracle, Vantive, MS SQL Server, PL/SQL, TSQL, VB 6, CDO, Stored Procedures, ADO.)
  • Developed data migration and import algorithms for legacy sales orders, billing and invoicing data systems running on HP3000, Turbo Image and Oracle 7.1. The data was migrated to Vantive 8.0 and SQL Server 7 using Visual Basic 6.0, PL/SQL, VBA and Transact SQL ( T/SQL).
  • Converted Oracle 7.1 packages, stored procedures, functions and triggers to MS SQL Server 7.0 based system using Transact SQL.
  • Migrated marketing data from SQL Server 7.0 to Exchange Server 5.5 public folder using Visual Basic 6.0, ActiveX Data Objects (ADO) and Collaborated Data Objects (CDO).
  • Designed and developed an ad-hoc query system to display historical sales data and billing information using Visual Basic 6.0, SQL Server 7.0, Transact SQL, Access and Excel 97.
Performance Engineer, Veritas Software, Mountain View, CA
(Core technologies; Oracle, MS SQL Server, SQLio, Server Bench, C++, Windows Servers)
  • Designed and developed a custom three-tier benchmark applications using Visual C++ 5 to study and report the effects of disk I/O contention under different raid and partition configurations. The solution also tested and analyzed Oracle and MS SQL database performance on the Microsoft NT 5.0 (Windows 2000) beta platform across the different disk configuration in order to find optimal performance with new volume manager for Windows 2000 using Visual C++, Oracle, MS SQL Server, NT5, NT4.
  • Analyzed the performance differences between Microsoft Windows NT 5.0 Server (aka Windows 2000) and Windows NT 4.0 Server CPU / memory utilization and disk I/O performance difference by using SQLio and Server Bench. These comparisons were in order to create a higher performing and more efficient disk manger for the Microsoft Windows NT 5.0 Server known as Microsoft Windows 2000 Server.
Software Developer / Project Lead, Genentech, South San Francisco, CA
(Core technologies; MS SQL Server, TSQL, VB Enterprise, RTF, Stored Procedures.)
  • Re-engineered Genentech’s Single Point of Contact (SPOC) Access based system to a Client/Server application using Visual Basic 5.0 and SQL Server 6.5 databases.
  • Re-designed and migrated MS Access databases to a normalized SQL Server 6.5 database using ER Win case tools, Visual Basic 5.0, Remote Data Objects (RDO) and Transact SQL stored procedures.
  • Developed Visual Basic 5 Class Libraries using object-oriented methodologies to create custom reports for the new re-designed Single Point of Contact application using Rich Text File (RTF) formats.
  • Designed and integrated an automated Fax-On-Demand Reporting System using Visual Basic 5.0, customized Rich Text File (RTF) format as well as Crystal Reports 5.0 Professional for SPOC.
Pacific Bell, San Ramon, CA
Software Developer / Project Lead
(Core technologies; MS SQL Server, RDO, TSQL, VB Enterprise, Stored Procedures, Windows NT Server.)
  • Designed and implemented a Client / Server reporting engine for operator services that would track and report employee’s performance and forecast staffing requirements for senior level management by analyzing operator call center data.
  • This solution also allowed management to assign shift rotation, break times and holiday leaves based on historical operator call trends using SQL Server 6.5, Transact SQL, Stored Procedures and Visual Basic 5 using DAO and RDO methodologies.
  • Designed and implemented backup strategies for Windows NT and SQL Server.
Lead Network Engineer , BZW Barclays Global Investors, San Francisco, CA
(Core technologies; Windows NT Server 4.0, Novell 4.x, TCP/IP.)
  • Presented business analysis of companies’ corporate wide server and desktop environments.
  • Created corporate standardized automated installation scripts for Windows NT 4, 3.51 servers and workstations and software installs.
  • Configured NT 4.0 corporate environment to integrate with Novell 4.x (NDS / Bindery) using Microsoft's and Novell’s network clients.
  • Troubleshot TCP/IP network issues as well as software and hardware conflicts on Windows 95, NT Server and Workstation.
Software Developer / Project Lead, Logistix, Silicon Valley, CA
(Core technologies; MS SQL Server, T-SQL, Stored Procedures, DCOM, Visual Basic 4 Professional)
  • Designed and developed a client / server windows based call center tracking systems to record, process and delegate incoming support requests to I.S. staff personnel. In addition, this system tracked help desk staff’s performance and efficiency to departmental managers by analyzing response times to open request and open to closed case ratios by staff team members using MS SQL Server 6.x, T-SQL, Stored Procedures, DCOM and VB4 Professional.
  • Designed and implemented the MIS department workflow procedures and processes to assign and delegate incoming help desk requests to IS staff in order to help increase staff’s productivity and decrease response times for end user issues.

 

Let us quickly locate the best and most qualified expert or expertise you need.

800-700-4944

Full Name*
Please fill in the required field.

Email*
Please fill in the required field.

Phone*
Please fill in the required field.

Company
Please fill in the required field.

Client Need
Please fill in the required field.

Invalid Input

FEATURED CONSULTANT

Peter Habicht, Lead Consultant
Peter specializes in welding and metallurgical engineer with 40 years industry experience in commercial nuclear power plant construction.

CONSULTING OPPORTUNITIES

  • Poly(methylmethacrylate) Manufacturing Operations / Processes Consultants
  • Cell Phone Technologies Expert

RAPID RESPONSE

Our Business Model
At Kevin Kennedy Associates, we’ve revolutionized the consulting business by streamlining the way our clients interact with experts.