John E. Black II
**** ****** **. *******, ** ****6
Home: 909-***-**** Mobile: 760-***-****
ablsv6@r.postjobfree.com www.linkedin.com/in/johnblackii
[pic]
Professional Summary
Experienced manager with skills in leading direct reports, cross-functional
teams, managing full SDLC, track and publish progress, determining and
documenting new project requirements. Excellent organizational skills
along with strong analytical and problem-solving skills combined.
Experienced in presenting to senior management, representing senior
management, meeting with customers, leading training sessions, accepting
ownership, and coordinating multi complex projects at the same time.
Candidate has proven ability to reduce expenses thru technical knowledge
and management of projects as well as a propensity to meet required
deadlines.
Platforms:
Windows Unix Teradata (EDW) NT Server
Mainframe
NT/2000/2003/XP WebSphere
Certifications:
Windows XP Natural 2 DB2 HP Business
Windows NT MS Certified Partner
J2EE WebSphere Adabas Partner IBM Business
Partner
Skills:
Project Extract Systems Development Agile
Manager transform load Life Cycle (SDLC) Waterfall
Subject Matter (ETL) DB2 Utilities Hyperion
Expert (SME) Data mining Service oriented Essbase
WebSphere FTP architecture (SOA) MKS SDLC
EDI X12 Natural networks Martin
Mainframes DB2/Adabas TCP/IP Tate
MS Office Cobol .Net C# Visual Age
MS Project Swishmax Visual Basic 6.0 for Java
Data Warehouse NetObjects MS ACCESS SOX
Fusion Six Sigma SQL SME
Visio Dreamweaver Visual
Informatica SQL server Studio 2008
Industries Served:
Railroad Retail Newspaper
Federal Government Federal Aviation Administration
Manufacturing Education
State Government
Department of Oil and Gas
Defense
Accounting
Awards and recognitions:
Numerous awards between 2005 and 2006 - Director of TS award for
2009 for the reduction of CPU serving as Subject Matter Expert
usage resulting in savings of 1 (SME) and aiding in successful
million dollars per year. implementation of cross team
2009 - Recognition for integration system.
Train team applications with Web 2005 - Recognition for quick
team applications. response to U.S. Customs issue
2008 - Recognition for restoring preventing BNSF from being assessed
data saving time and financial fines.
loss associated with having to 2005 - Recognition for connecting
recreate rail road with need to transport
2007 - Award for successfully Katrina relief supplies from CA to
connecting the Web to Mainframe LA.
legacy systems. 2005 - Award for leadership role in
2007 - Award for successful creating SQL and coding standards
integration of BNSF system with which resulted in increased
CSX system allowing seamless productivity and additional CPU
business between the two savings.
companies.
Education:
. Associates Business Technology (ABT) 5/1986
EXPERIENCE:
Burlington Northern Santa Fe Railroad (BNSF) 9/1993 - 7/2010
. Design, code, test, implement, and support WebSphere applications
accessing legacy processes on mainframe platform.
. Solely responsible for development of J2EE process to make
communication between Web and mainframe possible. Code, test, and
support programs with API wrapping applied.
. Served as SME on Train, U.S. Customs, and Yard and Industry teams.
. Lead team of developers in converting code purchased from Canadian
National Railway to handle U.S. Customs processing. Worked with
executives and field users to create a usable and productive system.
Teamed with DBA group to create tables to support system. Designed,
coded, tested, implemented, documented, trained, and supported new
system. Served as SME to facilitate the cross team functionality
associated with this process.
. Lead group of developers and managers to develop coding and SQL
standards to decrease CPU usage and lower maintenance costs.
. Redesigned process to extract data from Teradata system and re-insert
back into DB2 for user to query.
. Lead and performed performance enhancements that resulted in savings
of 1+ million dollars per year. Used Six Sigma process to identify
and track progress of issues. Assigned as SME for DB2 performance.
. Leadership role in successful merger and consolidation of 2 multi
million dollar corporations. Performed as developer, DBA, scheduling
coordinator, and team lead. Made presentation to executives on
consolidation options.
. Created process that would allow particular users to continue to work
if mainframe connection was lost. Saved the company from losses due
to downtime. Users are able to complete necessary work via ACCESS
database using stand alone PC.
. Create process that would support third party application to access
secured data to identify hazardous materials. Assigned as SME due to
data sensitivity.
. 24/7 Production support
. Lead team of developers in creation of Teradata Data Warehouse.
. Educated developers in the ETL process, created best practices
processes and recommendations.
. Created ETL process for over 100 tables.
. Designed and implemented databases on Teradata
. Created training document and trained team of developers and managers
on Teradata usage.
. Worked with team of developers to create necessary data for dashboard.
. Created process to allow backup and retrieval of DB2 data from Car
Accounting System (CAS) and Revenue Accounting System (RAS) preventing
application performance issue. Presented solution for RAS/CAS issues
to executive committee.
J. B. Computer Consulting 1995 - Present
. Installed network hardware and configure routers and switches.
. Created process to extract program data and create ACCESS database
using data.
. Created process within Visio to import data from ACCESS database and
produce flowchart using data via Visual Basic (VB); later converted to
SQL server.
. Refreshed PC.
. Developed custom programming using C# and Visual Basic.
. Designed, developed and implemented Web sites.
. System setup and configuration.
. Customized computers with specified hardware.
. Product support for third party systems.
. Hardware diagnostics
. Commercial off the shelf (COTS) support and installation.
. COTS training.
. Virus detection and removal.
Department of Defense 7/1992 - 9/1993
. Responsible for design, analysis, coding, testing, and implementation
of CARNAC system.
. Designed and implemented file structure to be used with CARNAC.
. Site manager for consultants on project.
. Worked with State of Arizona, Department of Public Safety, and
Criminal Intelligence group to collaborate on solution.
. Data mining and ETL processing to create consolidated data source.
Price Waterhouse 1/1992 - 7/1992
. Successfully completed project on time despite being 18 months behind
schedule when assigned to the project.
. Responsible for design, analysis, coding, testing, and implementation
of DORIS system for the State of Wyoming, Department of Revenue
Accounting Information system handling tax and minerals.
. Shared management of team of developers and documenters used to assist
in the creation and documentation of system.
Farah Jewelry 7/1991 - 12/1991
. Worked directly with owner to analyze needs and produce working and
usable system.
. Responsible for full SDLC.
. Create data from old paper system.