IT veteran, known to bring a wealth of knowledge and experience to the

table, implementing modern business applications with user-friendly support

while reducing costs, supporting cross-project efforts, and creating world-

class systems. Able to cross-function, serving in capacity as an Analyst

as well as hands-on developer, bridging gaps between business and technical

users with strong verbal and written communication.

Offering the proven ability to devise, implement and manage software

solutions, while juggling collaboration, deadlines, and testing

administration duties without missing a beat. Competent with gathering

requirements, working with business partners, and crafting thorough

documentation while managing multiple high-impact deliverables and

providing stable, easily-maintained solutions to complex technical

environments.

Champion of looking beyond what is already there and seeing ways to make a

process better and improve it, using soft skills of critical analysis,

identification of root cause, and translation from business requirements to

reliable technical solutions.

"We are pleased to recognize John for his dedication, commitment, and

perseverance to help make our new system a reality." Presentation

ceremony, Project Leaders, Lowe's Companies

Key Accomplishments

. Designed and implemented upgrades for Nuclear Asset Suite, to allow

merging financial/GL processing with legacy systems. Created data

warehouse for Oracle feeds prior to Passport processing.

. Created Technical Documentation (Business/Technical Impact Analysis,

Specifications, Disaster Recovery) and satisfied Sarbanes-Oxley

requirements for a project that was missing all such documentation and

failed audit reviews. This also facilitated business analysts and

technicians to resolve outstanding defects and regain clarity on the

effort.

. Converted legacy commercial accounts into a new format, updating

systems and processing, and achieving a conversion rate that was 100%

error-free at go-live execution.

. Created complex software that provided more accurate business

forecasts and connected the planning and execution systems, increasing

collaboration with vendors and overall system integration.

. Successfully worked with tax analysts to understand and create logic

based upon complex IRS rules and regulations. Awarded the Northern

Trust Award for Signature Service for these annual efforts.

. For my contributions to creating a more positive and productive work

environment, I was awarded the Five Star Service Award for Excellence

by Hewitt Associates.

. Regular contributor to weekly meetings and member of Change Advisory

Board.

Technical Expertise

Project Experience

. Technical Writing, Requirements Analysis, Structured Code Analysis and

Design, Systems Development Life Cycle (SDLC) in Agile, Waterfall and

Rapid Application Development (RAD) methodologies, Testing, Defect

Resolution, Training Documentation (in native English), Issue Management,

Team Collaboration and Leadership, System Analysis, Database Analysis;

Supply Chain, PS Financials, Imports, General Ledger, Accounts Payable,

and interfacing systems.

Technical Knowledge

. Cobol, WebSphere MQ, CICS, PL/1, JCL, EDI, ETL processing (Informatica et

al), Java, TSO, JCL, Easytrieve, Crystal Services Quick Reports,

SAP/ERP, IBM Sterling (Gentran), BizTalk, UNIX, CA-ADS, SAS, Crystal

Reporting, C/C++, EasyTrieve, SAP ERP Financials, TSO/ISPF, IBM Utilities

(incl SyncSort), File-Aid, Expeditor, VSAM, Kronos, Endevor, Panvalet, CA

Librarian, Control-M, HP/QC Test Director, MS Office, Sharepoint, IBM

SQL/SPUFI (MS SQL Studio with T-SQL), Visual Basic, Assembler,

Tradestone, Powerbuilder, HP Quality Center, Remedy/BMC, HOGAN and UNIX

scripting

. MVS, Z/OS, OS/390, Unix, DB2, IMS, Teradata, Oracle, IMS, Data

Warehousing, MS Access, Client/Server environments

Professional Experience

Duke Energy

* Nuclear Interface Project NINT91c (2013 - 2014)

Senior Systems Analyst - Raleigh, NC (Contract)

Summary: Migrated all invoice processing from legacy Progress systems

into Duke's Nuclear Asset Suite, and within a six month timeframe.

. Designed and created database and interface between legacy Passport

and CAPS financial systems, processing EDI and WebMethods

transactions.

. Coordinated testing and defect resolution efforts with business, using

HP Quality Center to complete UAT testing, including running automated

and manual testing scripts, managing all defects via HP QC, and

working directly with business partners and developers. Project

success depended upon these efforts.

. Advised management of status and made recommendations to resolve

problematic events uncovered during testing. Identified major

milestone points and provided graphical interpretations in regular

status reports or meetings.

. Partnered with Business Analyst to upgrade existing business rules and

apply them to new and existing processing, in spite of missing support

documentation and working under strict federal nuclear guidelines.

. Provided comprehensive analysis of processing and generated new

support documents for compliance with Nuclear and Sarbanes-Oxley

regulations.

Lowe's Companies, Inc.

* Lowe's Services Platform: LEF/Lowe's Experience of the Future (2012 -

2013)

Senior Programmer Analyst- Mooresville, NC

Summary: Corporate restructure to entirely new platform/team. Created

platform, architecture, and business documentation to correct

deficiencies with system documentation (SLA, SOP, and Deployment

documents), thus allowing compliance with audit and Sarbanes-Oxley

compliance tests.

. Provided production support of vendor product interfaces which

impacted all retail stores.

. Reduced system down-time, increasing national store profitability and

the ability to accurately create employee schedule/demand forecasts.

. Reverse-engineered and created technical documents for the Workforce

Development system; confer with business analysts to add business

functionality to documentation.

. Provided regular status reports and participated in weekly team/CAB

meetings.

* Supply Chain Planning and Logistics, Imports (2012)

Senior Programmer Analyst- Mooresville, NC

Summary: Requested directly by Lowe's corporate HR to fill an open

position. Provided technical expertise to resolve critical production

issues including overnight on-call support. Designed/built enhancements

to systems per business-approved requests.

. Leveraged existing knowledge of system to eliminate gaps in batch

application processing which delayed critical-path delivery of data.

. Further modified and created custom job streams and logical procedures

to parallel with third-party vendors (Tradestone, JDA and

Manugistics).

. Crucial for implementation and go-live efforts, obtained necessary

requirements, analyzed programs, and drafted business, technical

design and test documents to satisfy different stages of testing.

This included extensive, detailed specifications and testing plans.

Wells Fargo Bank

* wholesale banking - Consolidation with wachovia (2011 - 2012)

Senior Developer Analyst - Winston Salem, NC (Contract)

Summary: Updated applications and ran full production data through night

batch conversion streams, to turn accounts from Wachovia's proprietary

format to Wells Fargo. Tested all batch processes before each full

production conversion event, and worked with a cross-country team to

ensure a smooth conversion into desired formats.

. Executed full end-to-end batch cycles of entire production nightly

processing system.

. Within a complicated testing environment, improved existing testing

procedures as well created a comprehensive instructional manual to

fully document the conversion process and the specific testing

protocols. Final documentation covered over two hundred pages, fully

detailing the process.

. Performed data warehousing, preparation of test/simulation

environment, scrubbing, and 12 monthly simulations of full production

data conversions.

Blue Cross Blue Shield

* Commercial Claims Processing (2010 - 2011)

Senior Application Developer - Columbia, SC (Contract)

Summary: As part of Healthcare Reform Legislation, updated and tested

applications to conform to current HIPAA regulations within a batch and

online environment. Interpreted and updated specifications based upon

feedback from business analysts, to ensure changes were correct and that

documentation remained in sync to coding changes.

. Ensured compliance with Federal mandates for processing healthcare

information, including extensive regulation surrounding HIPAA laws.

. Updated source applications and tested modifications per directions

of business analysts and subject matter experts.

Lowe's Companies, Inc.

* Imports - Supply, Forecasting, and Replenshment (2009 - 2010)

Senior Programmer Analyst - Mooresville, NC (Contract)

Summary: Directly requested by Lowe's upper management to fix and save a

core/critical failed project, as part of an exclusive 4-person expert

"rescue squad". Created vital business solutions and implemented them

under tight deadlines and close business scrutiny, for a new out-sourced

system that had completely failed. Performed extensive re-engineering of

200+ applications, in order to fix the entire integrated system.

. Critical to the success of the project, re-engineered code that was

incorrect, unmanageable, or unsupportable, and that had no supporting

documentation. Replacements were stable, structured and maintainable.

. Worked extensively with Analysts, to help them understand problems

with the design and logic of the original build and Tradestone

interfaces.

. Developed comprehensive, concise technical documentation where there

was none before, including full technical specifications and test-

plans. Created full system flowcharts and organizational checklists,

which was crucial to managing the project.

. Communicated with off-shore teams to address problems detected during

nightly cycles, allowing completion of overnight batch and

availability of data and online applications.

. Ensured the project would pass audits and Sarbanes-Oxley compliance

tests.

* Supply Chain Planning and Logistics (2006 - 2009)

Senior Programmer Analyst- Wilkesboro, NC (Contract)

Summary: Analyzed, designed, tested and implemented enhancements for a

complex supply chain application system, including client/server

interfaces. Monitored production batch cycles, performed problem

resolution, and generated ad-hoc reports for Business.

. Modified and created applications for Supply Chain, Replenishment, and

Logistics processing systems. These improvements allowed the business

to save millions annually due to improvements in efficiency and

communication between business segments.

. Generated more accurate forecasts, connecting planning and execution

systems via a new feedback loop functionality.

. Modified and created custom job streams and logical procedures to

parallel with proprietary third-party vendors (JDA and Manugistics).

. Crucial for success, performed interpretation of requirements and

analysis of programs, then crafted business, technical design and test

documents to satisfy different stages of testing.

. Also impacting deliverables, authored a system which produced

statistical forecast data, and reported any internal transaction

errors within the supply pathway. This allowed tracking and

identification of nearly 1.5 million inventory records which were lost

in processing weekly.

Hewitt Associates

* Fund Administration and Accounting (2005 - 2006)

Business Analyst - Lincolnshire, IL (W2)

Summary: Performed daily monitoring and provided technical support of all

SEC transactions conducted by Hewitt on behalf of their clients and

account managers. Created solutions for statistical analysis of

investment activities to account specialists, by implementing custom

reporting tools

. Automated old manual tasks, saving entire mutual fund balancing team

(6 people) on average 5 hours per day of manually

balancing/accounting.

. Improved SAS jobs to reduce errors and create an audit trail-again

lowering costs.

. Overhauled the old fund tracking system, increasing efficiency and

reporting accuracy.

. Re-organized department documentation, updating and correcting over

1,500 technical files.

Euclid Machine

* Project Manager - East Chicago, IN (W2) (2002 - 2005)

Summary: Supported activities of an Industrial developer which served

the major Midwest steel producers. Provided full support to staff to

assist them in performing their duties more efficiently and proactively.

Maintained vigilance of project timelines and budget limitations.

. Increased efficiency of record-keeping 100% by moving a manual process

to a vended software solution, helping trim resource costs and

creating a more accessible and secure audit trail.

. Worked with supervisors and technical teams in product development,

focusing on the success of each overall project through rigorous

monitoring of projects' critical paths, earned value, risk mitigation

and resource negotiations.

. Facilitated the creation of the project schedule; identified and

coordinated internal and external (offshore, multi-coast) resources to

execute the plan, then monitored and measured progress for periodic

reviews to upper management.

. Drove weekly Dev/QA management sessions to resolve defects, risks and

issues.

. Lead periodic program reviews conducted to executive management to

report project progress.

The Northern Trust Bank

* Commercial Investment, Retirement and TAX Systems (1997 - 2001)

Programmer Analyst and Team Lead- Chicago, IL (W2)

Provided 24/7/365 on-call support for Northern's Global Transactional

Accounting system. Supported applications for the historical analysis

and reporting of all SEC events, summarizing trends and providing

balances and transactional data for global account management.

. Provided 24/7 support to systems for Audit, Tax, and the

Investment/Equity departments. This played a fundamental role in the

success of many major projects to improve global data availability,

reliability and reporting.

. Excelled in cross-platform support of foreign systems to deliver

custom data feeds and reports for global customers and trust accounts.

. Provided reliable, maintainable applications, so resources were not

diverted from other projects while helping ensure project deadlines

were met successfully.

. Interpreted complex IRS tax laws and applied them to specifications

and applications, under absolute deadlines (April 15th) and multi-

department scrutiny.

Education

University of Notre Dame, South Bend, IN

Bachelor of Science, (Science / Pre-Professional)

Center for Executive Education, Medoza College of Business, University of

Notre Dame 2013

Certificate in Executive Management: Leadership Essentials, Finance &

Accounting for Non-Financial Managers, Leading the Strategic Enterprise,

Applied Leadership

Project Management Institute (2014)

Candidate for PMP/Project Management PMI Agile Certified Practitioner

(PMI-ACP)

Kaplan University, IA (2015)

Candidate for Master of Science IT, Project Management / Business

Intelligence

Contact this candidate