Consultant, Kevin Kennedy Associates Inc.
Providing expertise in information technology management and enterprise solutions architecture, business / process / product analysis, and related expertise to a wide variety of clients.
Enterprise Data Architect / DBA, consulting firm, Fort Wayne, IN
Roles included Lead Data Architect, Business Analyst, System Analyst, and Integration Analyst in Distribution Centers Management System (Inventory Tracking, Billing, Shipping, Warehousing, Procurement, Auditing, and Billing). Integration between ERP, SAP, Local apps, Intranets, and other internal/external databases. Developed Technical Specs and implemented systems designs based on functional/technical requirements. Worked on SAP XI interfaces for SAP Portal / EDI -X12 / Gentran GIS hub which post deliveries and customs shipments updates into multi-receivers systems of SAP and non-SAP receivers. Utilized integration methods with Webservices using SOAP WSDL objects, HTTPS, Idocs communication, RFC/Bapi calls, JDBC adapter, and File adapter connectivity. Worked with XI team for inbound and outbound asynchronous messaging. Hours divided between being 60% analysis & architecture, 20% coding, and 20% directing, monitoring progress, and working with off-shore developers.
Solution Technical Lead / Enterprise Architect, CitiGroup -Technology Department, Warren, NJ
Was in charge of all technical aspects of the project, including gathering requirements, pricing, architecture, solution development(including team), deployment, support, and documentation ($5Mil, 8Month Solution, 13 People Team). Served key role in all business and technical communications and approvals with the client. The Desktop Migration Management Solution was designed to allow managers to effortlessly handle and automate 400,000 desktop migrations to Vista OS, with all their existing business core applications. The Web Application solution integrated with so many systems to do Machine Hardware/Software Inventory, HR, Licensing DB, Packaging DB, SMS, Backup/Recovery, etc. Effective and efficient in identifying, defining, and scoping the department / top management business needs / requirements. Success in managing and balancing the scopes, timelines, costs, resources, deliverables, integrations, and potential bottlenecks. Low level involvement on all aspects of the solutions SDLC, including planning, architecting, prototyping, developing, testing and implementing the solution. Successfully managed the team despite all the communications challenges (team was scattered across 3 countries, USA, Canada, and India, and language was a barrier). Identifying, scoping, and integrating 17 different processes, solutions, and data sources, ranging from Web Services, Excel Uploads, NT Scripts, Direct DB Connections, and SharePoint. Worked with systems owners in identifying & creating short / long term strategies to open up their systems for integration, establishing enterprise level dependable data to avoid anomalies, supporting I/O data exchanges, and accounting for security on the app, process, and user level. Designed secure / encrypted Enterprise Service Oriented Architecture (E/SOA) to provide interfaces for system layers other external solutions to integrate/consume and mine the system's data. Typical weekly hours were distributed as follow: 75% Scoping, Requirements Gathering, Planning, Architecture, Designing, and Prototyping. 5% Solutions Development, Integration, Implementation, Architecting and Coding. 20% Management Level Meetings, Reporting, Documentation, Support, etc. Primary Tools Used (Hands-on): Management Tools: Reports: Various CitiGroup programs. Project Tracking: MS Project, SharePoint 2003/2007. Communications: Excel Reports / Communication Templates. Architecture Tools: Diagramming:- MS Visio. Entity Relationships:- ERWIN ERD, ER-Studio, and Enterprise SQL 2005. UML Case tools:- VS2005 Team Suite Architecture Edition, UML Architect, and Visio 2005 Architecture Edition. Mockups:- PowerPoint, HTML, Visio, and Acrobat. Development Tools: .Net (C#, VB.Net, ADO.Net), ASP.Net, ASP, ASMX, WinForms, Windows Services, XML/XSL Transformations, MS SQL and T-SQL, and Infragistics ASP.NET Components. Solution Technologies: .Net Web Application built on top of Ajax Infragistics, Windows Services for nightly jobs, Secure Encrypted Enterprise Service Oriented Architecture (E/SOA), and WinForm app for monitoring performance/health.
Solution Development Lead/ Architect, International Truck & Engine, Fort Wayne, IN
Played visible key role in supporting, establishing, advancing, and automating some of the department inner/intra processes, system engineering methodologies, and inter department communications by enhancing/integrating existing solutions, developing new ones and/or utilizing/integrating 3rd party solutions. Was effective in identifying, defining, and scoping the department and management needs; evaluating, managing, and balancing the scopes, timelines, costs, resources, deliverables, and potential bottlenecks; planning, architecting, prototyping, developing, testing and implementing Enterprise Level Solutions / Processes. Provided Enterprise Level Software solutions to streamline and automate tasks, work flows, communications & notifications, data exchange, reporting, and documents sharing/managements. Accounted for time, scope, recourses, development, technology selection, political and implementation considerations to maximize the Return-on-Investment (ROI). Successfully led huge appreciated key efforts to identify, recognize, and establish a One Standard Set of Core DVP Data Terms (data types) to be used by the 400+ user department with over 17 distinct interactive user roles, as no three users in the department were before able to communicate DVP data efficiently/successfully with each other or easily exchange any program data using the existing (specific user and role dependent) non-synchronous various data terms. The new well accepted terms resulted in massive communications stream down, full understanding what these terms represent, how these terms relate to one other or existing processes, thus raising productivity, communication, and inner department data exchange abilities to the next level. Once the Data Terms and related Processes were defined, we scoped and established approved detailed deliverables to provide automate, auto-generate, and simplify data entry/management needs throughout the different roles and program DVP life cycles, thus increasing productivity, communications, accountability, and decrease the work load demands on the different roles almost or even sometimes more than 1/2. Was responsible for maintaining the Intranet, DBs, Application and Integrating existing applications/solutions. Also in charge of supporting and training the users on using the existing and new solutions, applications, and how to best apply the related System Engineering methodologies and processes, which benefited all parties and boosted the return on value of the solutions/applications. Typical weekly hours were distributed as follow: 45% Scoping, Requirements Gathering, Planning, Designing, and Prototyping. 35% Solutions Development, Integration, Implementation, Architecting and Coding. 20% training, Documentation, Support, etc. Primary Tools Used (Hands-on): .Net (C#, VB.Net, ADO.Net), WinForms (incl'd VSTO), Web Apps (ASP.Net, ASP), XML/XSL Transformations, MS SQL - T-SQL(Store Procedures, DTS, Triggers) for product development / maintenance, MS Access, Java and NHypernate. MS Project, SCRUM, MS Visio, ER-Studio, UML Case tools, MS Office Suite. Total Command Language (TCL) for writing and maintaining scripts for UGS Team Center Requirement (TCR) which is a Java thick client that engineers use to manage requirements. Other tools that I worked on include MS Sharepoint, Serena TeamTrack, ActionWorks, Optimal-J, Uniface, and IronSpeedDesigner.
Solution Architect / Sr. Consultant, MAXIMUS, Cleveland, OH
Fully responsible for architecting, managing, and developing a .Net CVST dynamic thick client application for court system scheduling. Holding a highly visible role. After dividing the project to logical phases, charted scopes & delivery objectives for each phase, established tasks & timelines, architected platform, designed n-tear interfaces, and supporting various DBs, developed/delivered a successful solid extensible enterprise solution that allowed the company to sell the product to many Court System both domestically and internationally, attracting new highly profiled clients/work orders. To accomplish this solution, -personally- utilized the following: MS Project, Visio, RUP, UML Case tools, Borland Together UML, and MS Office Suite (including PowerPoint) for project management, design and architecture. .Net (C#, VB.Net, ADO.Net, Soap, Data Serialized Object Exchanges, …), XML/XSL Transformations, MS SQL - T-SQL(Store Procedures, DTS, Triggers), and Oracle DBMS Server -PL/SQL for product development. WinForms, WebServices, Soap Services, CSV, XML, Form, URL, FTP Posts, for data exchange services. MS Windows 2000 & 2003, MS SQL, Oracle, .Net, servers in n-Tear scalable redundant platform structure. IP, NT, SSL & Password Encryption, Plain Password, and other sub security methods for verifying/authenticating data, medium-agents, and clients. Typical weekly hours were distributed as follow: 5% Projects Management, 25% Design & Architecture, 65% Hands-on-Coding, 5% Other. Primary Tools Used (Hands-on): VB.Net, C#.Net, ADO.Net, VB COM+, MSSQL, T-SQL, SOAP, SQLXML, XML, XSL, XSD, DTD, Oracle, CSV Data Exchange Solutions, SSL, NT, IP Security, scope level flexible integrated APIs), UML, HTML, DHTML, XHTML, JavaScript, VBScript, ActiveX, Java, C++, Macromedia Flash, Adobe Photoshop
Product Integration Manager / Enterprise Integration Architect, AutoByTel, Columbus, OH
Fully responsible for leading the development efforts, goals, and direction of all of WebControl's integration solutions (WebControl: Auto Dealership Industry #1 Internet Sales Management and CRM Product), which enriched its enterprise level capabilities and offerings and generated the company more than $7 million in profits. In addition to setting direction, establishing standards, designing solutions, architecting and coding, was also involved in aiding major B2B clients in their cross-integration efforts all the way from planning - to - development, and from implementation - to - support (clients included Honda, Mazda, MBUSA, Who'sCalling, BlackBook and Mitsubishi). Successfully led all their enterprise B2B integration solutions effort by establishing solid, well-planned, designed and developed products/services/standards. End result of overall architecture has proven to be stable, scalable, cost effective, platform independent, and very well received by all internal and external B2B clients. Accountable for two high profile and very complex enterprise level B2B sensitive projects required a high level of political sensitivity and business savvy. Achieved success with very tight timelines, dealing with a high degree of stress, and interaction with a wide variety of individuals and teams in all phases of the SDLC, including training at the point of completion. Holding a highly visible role of an Integration Architect/Manager, -after evaluating the prior existing few, limited, non-scalable, high-support-intensive, costly, and weak integration applications,- took the initiative to present a business case for a new extensible solid integration platform. Once approved, divided the project to logical phases, charted scopes & delivery objectives, established tasks & timelines, architected platform, designed n-tear interfaces, and working with a team of 10 resources available to this project, developed/delivered a successful solid extensible enterprise solution that allowed the company to provide many new B2B services/products, attract new high profile clients, and put the company on the map again as a solid industry leader. Ensured the attributes / values proposed by the new solutions are fully maximized while accounting for future areas of opportunity to leverage new approaches, goals, and technologies in later phases. To accomplish these solutions, the following tools were utilized: MS Project, Visio, RUP, ER-Studio, UML Case tools, SharePoint 2003, and MS Office Suite (including PowerPoint) for project management, design and architecture. Coldfusion, XML Transformations, MS SQL - T-SQL(Store Procedures, DTS, Triggers, Business Reporting, SQLXML), VB COM+, .Net (C#, VB.Net, ADO.Net, Data Serialized Object Exchanges), HTML (including JavaScript, DHTML, XHTML, VBScript, ActiveX) for product development. Encrypted Secure Service Oriented Architecture utilizing Web/Soap Services, CSV, XML, Form, URL, FTP Posts, MSMSQUE, and MS DTSs, for both real time and batched data integration, exchange, transformations services. MS Windows 2000 & 2003, MS SQL, MSSQLXML, MSMSQUE, .Net, and Coldfusion servers in n-Tear scalable redundant platform structure. IP, NT, SSL & Password Encryption, Plain Password, and other sub security methods for verifying/authenticating data, medium-agents, and clients. Typical weekly hours were distributed as follow: 25% Projects Management, 45% Design & Architecture, 25% Hands-on-Coding, 5% Other. Primary Tools Used (Hands-on): VB.Net, C#.Net, ADO.Net, VB COM+, MSSQL, T-SQL, SOAP, SQLXML, XML, XSL, XSD, DTD, Oracle, CSV Data Exchange Solutions, SSL, NT, IP Security, scope level flexible integrated APIs), SharePoint 2003, Cold Fusion 5/MX, UML, HTML, DHTML, XHTML, JavaScript, VBScript, ActiveX, Java, C++, Macromedia Flash, Adobe Photoshop
Senior Software Engineer, First Union -Agents' Annuity Portal, Columbus, OH
Contributed development, integration, architecture, system analysis, training and consulting services to an online B2B annuity insurance solutions portal. Assisted as part of a large team in developing the company's award-winning enterprise annuity solution portal that cost the company $3 million. Integrated to many external systems for tracking Insurance, Agents, Carriers, Securities, Annuities, Sales. Led development efforts that enhanced the company's main web site to be stable, dynamic and secure. Trained and assisted sales, QA and developers on the solutions and platforms from both business and technical aspects. Primary Tools Used (Hands-on): Adobe Acrobat Export Solutions, ASP, MS SQL, T-SQL, XML, XSL, MSMQUE, C#, VB.NET, VB6 COM, ASP, HTML, DHTML, VBScript, JavaScript, MS-SQLXML, SAP Integration ETL / IDoc
Senior Web Consultant, AT&T Solutions, Columbus, OH
Designed, created architecture, developed and delivered two major solutions that served BankOne's T1 Alliance (AT&T, BankOne, Lucent, IBM, and Avaia). Solutions included: 1) Enterprise T1 Alliance Asset Management/Tracking Solution that integrated and processed data from the different parties and fed to AT&T's Billing Engines, and 2) Site Tracking Product. The solutions allowed AT&T to reclaim over $8 million of lost revenue per month. Utilized RAD methodology to deliver multiple solid and fast solutions with little initial requirements. Led the front, middle, and some backend team development efforts across the solutions. Assisted the database team in architecting and developing the backend database (Data warehouse and Data marts). Integrated and exchanged data across internal and external systems, and DBs. Assisted, trained and supported different internal and external users on the solutions. Primary Tools Used (Hands-on): DHTML, JavaScript, ASP, XML, ADO, COM, VB, VBScript, MS SQL 7/2000, Sybase, Oracle, DB2, MS Access, SAP FI & SD, SAP XI, MS Visio, MS Project, MS Office Products Solutions & VBA, Visual Studio 6, Macromedia Suite, Borland JBuilder, SQLOracle, DBArtison, Windows NT4/2000/2003 Server, Sun Solaris
Senior Web Solutions Engineer/Consultant, Norstan Consulting, Columbus, OH
Filled critical role as part of development team, personally responsible for the data gathering, modeling, design and development of the front- and client-end of the solution, while maintaining active communication and collaboration with the back-end and middle-tier teams. Trained sales, clients and support staff on use of the product. Integrated the web portal back-end with Siebel and SAP. Primary Tools Used (Hands-on): ASP, JavaScript, VBScript, VB COM+, Oracle, MS SQL, T-SQL, XML, II5, Siebel, SAP FI, SAP XI / IDocs Integration, LDAP, Oracle Designer
Advance Software Engineer, GSWA, Columbus, OH
Assisted in gathering web site requirements, provided estimates, developed project plans, created look and feel, coded web applications, tested, developed solution methodologies, and provided training on the various technologies and tools. As the lead front-end developer of an 11-person team: Created University Sales training web solutions. Created a dynamic informative portal for a client's sales staff. Created dynamic Flash/XML/DHTML solution as part of a client's digital marketing campaign to its customer. Primary Tools Used (Hands-on): ASP, JSP, II5, Apache, Java, Flash, XML, DTML, JavaScript, Oracle, Adobe Acrobat Solutions
