John L. Cleveland Professional Summary
MBA and proven MIS professional
with 20 years experience as an applications analyst, data architect and
developer (.Net and Java) , plus the ability to lead projects, teach others, and
mentor. Expertise includes Oracle 8i,
9i, 10g and 11g Development and 11i (Financials) and Data Architecture with a
background using Rational Software Architect, PowerDesigner,
Popkin, PowerDesigner, Embarcadero, Altova and ERwin. Experience in Data
Stage and Informatica. Extensive business analysis and financial experience with
DoD, including previous projects at U. S. Transcom (DEAMS), the U. S. Air Force,
the U. S. Army and with the U. S. Post Office.
Programming and web application development experience in C#, VB.Net and
J2EE.
· Mashup/Dashboard Experience, including Flex, IBM Mashup Center, Five years experience with Teradata and associated tools and utilities.
·
Current DoD top secret clearance (awarded November 2008).
·
Knowledgeable about DITSCAP/DIACAP process, including certification,
validation, maintenance and reporting, both for the U. S. Air Force and the U.
S. Army.
·
12+ years experience designing, building and deploying enterprise
solutions with exposure to multiple software packages/vendors, programming
languages and technology platforms.
·
Experience architecting and/or
developing solutions enabling the utilization of the following Financial
products/protocols, including Oracle Financials. MS Dynamics Navision, DEAMS,
Cognos, XBRL, SAP, PowerPivot, Tableau, Excelsius, Abacus Enterprise Workflow
·
Strong focus on successful delivery of COTS implementations.
·
Extensive experience with the .NET framework
·
Extensive experience designing and/or developing solutions in a Service
Oriented Architecture (SOA) and associated Web Service Specifications WS
·
Proficient with J2EE and J2SE technologies.
·
Extensive experience with systems architectural concepts and patterns,
UML, refactoring,
·
Demonstrated ability to stay current with Application Architecture best
practices, existing and emerging technology platforms, architectural and systems
engineering industry trends
·
Experience with a variety of software platforms including MS SharePoint,
IBM WebSphere, Eclipse, JBoss, JDeveloper, content management systems, search
engines, rules engines (JRules, Blaze Advisor), BPM, ETL.
·
Experience with data architectural concepts, frameworks and technologies,
with exposure to both transactional and data warehousing systems
·
Experience with leading ETL platforms such as SSIS, Informatica, and Data
Stage
·
Experience with formal software development methodologies, with a focus
on Rational Unified Process and Agile.
·
Demonstrated ability to prepare and deliver presentations to executives
on architectural approaches to gain consensus, including an ability to translate
complex technical topics to audiences with a range of technical sophistication
·
Very advanced interpersonal and communication skills developed for years
as a teacher, public presenter, businessman
·
Flexible, energetic with an ability to
work well with others in a virtual, geographically dispersed team environment.
·
10+ years of experience developing .NET SharePoint Services
–
most recently SharePoint 2010
·
12+ years experience in Oracle SQL.
·
Cognos, Kronos, SAP, Microsoft Dynamics experience.
·
10+ years experience in Oracle PL/SQL application development.
·
15+ years experience with SQL server, 5 with Teradata, 6 with DB2
·
Ability to work well in a dynamic environment.
·
Worked with many different U. S. military systems, including GCLS (SAP
Business Objects), PAT, ISDDC, GATES, WPS, IBS-CMM, IBS-SuS, DLA Fusion,
Discover, E-SS, EC-SS, LIMS-EV, FAS, DEAMS, IDAR, OARS, GAFS, PIC, REMIS, SMART,
and others.
References:
Technical Skills
Employment History
Business and Data Analyst and MIS
Business Objects Consultant
K-Force/SoftWorld, ASC Associates, Scott AFB, O’Fallon, IL November 2009 –Present
·
Contract: Used ERwin Data modeler
for SBSS to GCSS transfers.
Developed Event Management/Alerting System prototypes using Business Objects,
Teradata, Oracle, SQL Server.
·
Used J2EE in WebSphere and C# and Visual Basic inVisual Studio 2010/2008
to create widgets (also Adobe Flex, Java and SilverLight) that wired together in
IBM Mashup Center for new SDDC dashboard applications.
·
Assisted data transfers and extractions for the new Supply Chain Control
Center (SC3) at Scott AFB which handles supply and logistics for the entire U.
S. Air Force. Set up and configured
Informatica Powercenter for SC3 ETL processes.
·
Also used Adeptia ETL. Involved in setting up and complying with USAF
Security and data architectures.
Use IBM Data Stage, Altova and Informatica
·
ISDDC, TFMS, IBS, DEAMS, Carrier Systems.
Consultant Programmer and MIS Consultant
Lockheed-Martin/Data
Network Corp., Scott AFB, O’Fallon, IL
April 2008
–
August 2009Contract:
Used ERwin Data modeler for TMDS to TRDM conversion.
Completed transportation models (air, water, ground) event tracking and
HazMat tracking. Set up and configured Erwin and Informatica for myself and
others. Developed application
architectures to integrate with USAF Security parameters.
Compliance with DIACAP and transition from DITSCAP.
Tri-Cor Industries, Scott AFB, O’Fallon, IL August 2008 – April 2009
Contract: Modeled data and
relationships for TMDS to TRDM conversion.
Developed SharePoint applications for the Department of Defense.
Created Association Model linking all stage and based table, all staging
tables and history stage tables and all base tables to all history tables,
including more than 2,800 entities/physical objects and 5,000 migrated foreign
keys/relationships. Set up
and configured Informatica and ERWIN for myself and others to model and perform
ETL. Developed security infrastructure
to integrate with USAF security procedures, including DIACAP.
Utilized Data Stage and Informatica depending on which project we were
assigned.
Anthem Blue Cross Blue Shield, St. Louis, MO January 2008 – August 2008
Consultant: Data
Architect/Application Architect.
Used PowerDesigner to create enterprise-wide Data Warehouse for Inquiry
Management and Case Management Utilization system.
Maintained SharePoint 2007 site for management and SME’s.
Managed web site and used Informatica to model and create Web Services.
Modeled Anthem Blue Cross security features.
Nestle
–
Purina, St. Louis, MO
July 2007
–
January 2008
Consultant: Data Architect/Web
Developer. Assisted in Mapping Data
Elements for a new Insurance Industry Venture.
Helped analyze and clean data for ETL in data warehouse. Used Informatica
PowerCenter and IBM Data Stage Help
set up transfers between and among insurance underwriters and various banks,
including security procedure architecture.
Scott AFB, Fairview Heights, IL
July 2006
–
July 2007Consultant:
Application Software Architect/Data Analyst.
Prepared the architectural diagrams for Spirals 1 and 2 of the DEAMS
transition from 128 military legacy financial/accounting systems to Oracle 11i
system. Helped code and create data
mappings in JDeveloper BPEL Process Manager, Altova Suite, StyleVision and
others. Wrote and edited Functional
and Technical documents.
Developed database to track all project elements, including Oracle 11i tables
and fields, OAGIS BOD fields, SFIS field names, RFQs, RICE documents for easy
team access. Also responsible
for modeling data and security architecture
for 137 legacy systems integrated with DEAMS Oracle 11i infrastructure.
Familiar with DIACAP transition security authorization, certification and
reporting. Used
Informatica and IBM Data Stage.
Washington University, St. Louis, MO March 2006 – July 2006
Consultant: Programmer/Architect.
Developed modules to track potential enrollees.
Performed ETL of data using IBM Data Stage.
IBM/Allysys, St. Louis, MO January 06 – March 2006
Consultant: System
Architect/Programmer/Analyst.
Helped IBM design fleet management financial system for the U. S. Postal System,
including producing UML diagrams in Rational, Websphere Business Modeler, and
ERwin. Assisted in design of the
Main, General Ledger, Payroll, Accounts Payable and Vehicle Utilization
components. Helped integrate
security systems for large fleet-management systems.
Used Data Stage and Altova.
Impact Technologies, St. Louis, MO December 2005 – December 2006
Consultant: Programmer/Data
Analyst/Architect. Used C# and
Visual Studio 2005 to design application to track call center activity.
SharePoint 2003 development and administration.
Created interface using
Infragistics and other third-party software applications.
Boeing, St. Louis, MO November 2004 – December 2005
Contract: Architect/Programmer/Data
Analyst. Worked with Visual Basic
6.0/VB.NET COTS to build front end from Java-based SDS framework.
Created application in C# and VB.Net (Visual Studio 2003/2005).
Developed SharePoint 2003 interface.
Developed OAGIS XML BODs for TMS.
Designed Medical Claims and Tracking Components.
Developed all business event flows (BEFs).
Integrated security and other features for Boeing’s Sustainment Data
systems. Worked to make sure
security standards complied with DITSCAP/DIACAP.
Informatica and Data Stage in Environment.
British Petroleum/SAIC
July 2004
–
December 2004
Consultant: Programmer/Data
Analyst/Architect/System Manager.
Provided tech support back up for systems at Toledo and other British Petroleum
refineries. Developed applications
in C# and VB.Net for BP refineries.
Managed OSIs PI, Baytech’s WinBliss, Maximo, Oracle 8i and other systems at some
of the world’s largest refineries.
Managed health and disability claiming systems and several large conversion
projects.
Magellan Behavioral Health, St. Louis, MO
June 2004
–
August 2004
Consultant: Programmer/Data
Analyst. Enhanced medical claims
payment system. Managed large
programming and conversion projects.
Repaired flaws in WebChecks system used to manage and print millions of
dollars in checks.
U.S. Army, Augusta, GA December 2003 – June 2004
Consultant:
Programmer/Architect/Analyst. Led
design enhancements to ARMS, Delphi database and resource management project at
Ft. Gordon, GA. System tracks
military resources all over the world by all service branches.
Wrote C#/VB.Net applications to gather data and pass it along to Delphi
data-management systems. Developed
enhancements based on ERwin diagrams of competing system.
Integrated system with Oracle Financials (11i).
Documented existing COBOL systems.
First exposure to DOD procedures, including DITSCAP.
Worked with several ETL tools, including Informatica.
Northrop Grumman/US Post Office, St. Louis, MO
June 2003
–
December 2003
Consultant: Program Analyst.
Worked in Oracle and SQL databases and accessing information with TOAD,
SQLPlus, and C++/C#. Completed
custom applications to access information on SQL 2000 databases.
Worked on national facilities management software project Programming in
PowerBuilder and Java (WebSphere), BEA WebLogic, utilizing Java Struts, Solaris,
AIX, Business Modeler. Worked to
integrate facility-management system
security features. Altova
and Informatica in Environment.
Anheuser-Busch, Sunset Hills, MO November 2002 – June 2003
Consultant: Quality Assurance.
Documented existing SQL and Oracle systems for the first time and
developed XML-based on-line documentation and systems with transfer to
C#/Crystal Reports system. Wrote
reports in VB.NET and C#, utilizing Crystal Reports and Active Reports 9-10, to
gather data from can and bottle processing plants and make it available on the
network for plant engineers.
Managed UNIX and VAX-based data and systems currently in preparation for switch
to .Net technologies.
Premcor Refining Group, Inc., Hartford, IL July 2001 – November 2002
Programmer/Data Analyst/Server, Architect and Network Administrator
·
Maintained and administered plant-wide information SQL and Oracle system
in refinery, including servers and network.
·
Created and managed reports, wrote programs and disseminated information
from Oracle and SQL databases. Used
TOAD and other utilities to view, manipulate data and create stored procedures.
·
Managed the plant Intranet and developed several custom applications and
content for the Web. Used ASP and
Visual InterDev.
·
Developed programs and disseminated information.
Maintained UNIX, VAX and NT/2000 systems.
Developed and published online training programs for Premcor personnel in
XML/DHTML
Computer Services Plus/Ultimedia, Inc., Fairview Heights, IL July 1993 – August 2001
Owner/Manager/Founder. Wrote custom
computer programs based on specialized needs of clients, including several using
SQL 7-2000 databases. Clients
included regional banks
–
Eagle Banks, Southwest Missouri Bank, and Wells Fargo
–
plus law firms, medical offices, trucking companies, and more.
Sold and installed home/office computer systems.
Supervised a staff of 40 and performed programming, data management and
computer maintenance. Did several
ETL projects for customers, using early versions of Ascential Data Stage.
Previous experience including working as writer, photographer, editor, and sales
manager for several small newspapers and trade magazines.
Learned basic database management on some of the earliest personal
computers, and discovered an appreciation for computers and a knack for
programming, which led to pursuing it as a career.
Teaching Experience
Southwestern Illinois College, Belleville, IL June 1992 – Present
Computer and Programmer Instructor (Part Time)
·
Taught Visual Basic, C++, Java, JavaScript, SQL 7, Access, XML/HTML, CGI,
Microsoft Access, FrontPage, CorelDraw, Adobe Illustrator and several other
computer and technical classes.
Taught SWIC’s
first JavaScript and CGI classes.
·
Served on SWIC’s
technical and business department curriculum advisory committees. Awarded SWIC
Instruction Plaque for Mentoring Interns.
ITT-Technical Institute, Arnold, MO
June 2003
–
December 2003
Computer Programming Instructor (Part Time)
·
Taught Advanced C++, Java, J2EE, Data Structures, and HTML/XML, SAP,
College Math, 3D
Modeling, 3D Max and SAP, and advanced College Math.
Education
Southern Illinois University, Edwardsville, IL
1983
Masters of Business Administration with specialization in Management Information
Systems
University of Illinois, Champaign, IL
1972
Bachelor of Art in Communications with specialization in Print Journalism