My Mall & News

PHILIP G. WIK'S RESUME

(480) 951-2686

PROFESSIONAL OBJECTIVE
Lead Information Architect

PROFESSIONAL SUMMARY
More than twenty years of information technology expertise in client/server environments using project management, systems analysis, and applications programming.

Seasoned technical systems integrator, architect, administrator, coordinator, manager, developer, and analyst with expertise in enterprise application process and data modeling, cross-platform migrations and conversions, relational database design and normalization, and software reengineering.

Hybrid mainframe/client-server interfacing skills, with strong expertise in Oracle and UNIX.

PROFESSIONAL EXPERIENCE

Software Developer/Engineer

BOEING, Mesa, AZ     2005-2010
Cyber Senior Consultant

On the Enterprise Supply Chain Management Systems (ESCM) team that supports an established Oracle system that runs processes controlled by UNIX scripts. System assists in managing part availability to Supply Chain Managers for Boeing Mesa Support Systems. This position is a combination of sustaining effort and ongoing new development tasks to enhance the current system. Boeing's Rotorcraft Apache Longbow Helicopter Division in Mesa has 4,900 employees. Its primary customer is the US Army.

ESCM supports asset managers in identifying, predicting, and ordering parts for the Apache helicopter for Boeing customers.

Primary focal for sustaining effort, supporting Service Planning Optimization (SPO), Systems & Logistics Capability (SLIC), Total Asset Visibility (TAV) , Application to Application (A2A), ESCM, Material Resource Planning (MRP), Gold Online Data (GOLD), and Requirement and Demand Management System (RDMS) systems. This involves ensuring that Oracle instances and databases and working, correcting discrepancies between systems, and producing ad hoc reports for our users.

Participated in the Capability Model Maturity Integration (CMMI) system development level three life-cycle and Lean + initiatives.

Heavily involved in requirement definition, system design, sustaining effort, researching system anomalies, and ongoing new development tasks to enhance/automate the current system. Consulted with customers to research and identify advanced requirements for application or system design.

Updated and created UNIX/TCL scripts and Oracle procedures for the Systems and Logistics Capability (SLIC) to Gold Online Database (GOLD) effort.

Supported upgrade of the Service Planning and Optimization (SPO) and DMExpress Syncsort.

Involved in all aspects of major projects that our team undertook, including the Mesa Advanced Production and Remanufacturing System (MAPARS), the ESCM system re-write, and SPO upgrades.

Environment: Oracle 9i/10G, XML, Java, UNIX, SPO, SLIC, GOLD, TAV, APIs, JAVA, ClearCase, ClearQuest, Business Objects, ColdFusion.

HONEYWELL, Phoenix, AZ     2002-2005
Keane Senior Consultant

USA Keane focal point for supporting the Tucson Online Tracking System (TOTS) with Keane India offshore resources 7/24/365. TOTS is an in-house developed systems that collects labor, attendance, payroll, test, and inspection information for manufacturing and repair and overall. It consists of about 90 batch reports and 80 batch scripts on unix and about 170 Oracle 6I forms and reports with 400 users.

Systems administration support for DataStream, an asset performance management system, with reporting, work management, and auditing functionality for 200 users. It consists of J2EE (Java), EJB, JSP, and XML, Oracle Discoverer, Oracle 9iAS, and tomcat/apache web methods server.

PL/SQL and UNIX korn shell scripting to support Aerospace Services data warehousing CPU mainframe reduction effort, resulting in savings of $400,000 in three months. Developed Oracle stored procedures to facilitate data warehousing processing. Utilized FilePort, AWK, and C scripting to data-cleanse downloaded IMS mainframe files prior to loading the rows into Oracle tables on UNIX/AIX.

Environment: Oracle 8, 9i, and 10G, Oracle Web Server, Oracle forms and reports 6i, Quest/TOAD, UNIX/AIX, Korn Shell, Erwin, Informatica, AWK/SED, EXTRA Personal Client , TSO, JCL, WS-FTP, IMS DB, ERP/SAP.

UNIVERSITY OF PHOENIX, Phoenix, AZ     2002
Senior Systems Analyst

Developed, modified, and tuned Pro*C reports, Oracle forms, and PL/SQL stored procedures.

Maintained Osiris and Campus Tracking Oracle database systems with troubleshooting, optimization, and production support.

Environment: Oracle 9i, Pro*C, UNIX/Solaris, Korn Shell, Quest/TOAD, Oracle Developer, Forms/Reports Builder 6i, Quest/SQL Impact, StarTeam 5, HEAT, XML, Crystal Reports, MS/Office, PeopleSoft.

WELLS FARGO, Tempe, AZ     1999-2002
Systems Engineer

Automated Clearing House History Integration Project. Coded, tested, and installed Oracle packages on a UNIX/HP platform to accommodate 15 partition table split of the database.

Data center closure support. Migrated Wells Fargo Automated Clearing House NDM returns Connect Enterprise/Mailbox jobs, files, and schedules from Arizona to Minneapolis.

Created process to download 14 DB2 tables to NDM load to Unix Oracle tables. Created MS/Access canned procedures, forms, and views to access Oracle tables with daily downloaded data.

Environment: Oracle RDBMS, UNIX/HP, PL/SQL, Korn Shell, C, OCI, iPlanet Web Server, JavaScript, Java, MVS, PacBase, COBOL, JCL, MS Office.

NDC HEALTH INFORMATION SYSTEMS, Phoenix, AZ     1999
Lead Programmer Analyst

Managed the successful installation of Data Warehousing Engines aggregations using Oracle, PL/SQL, and UNIX, reducing monthly production time by 70 percent. Managed upgrades and 7 x 24 pager production support of web-enabled Territory Analyzer marketing system, generating annual revenues of $6 million. Managed direction of developers, analysts, consultants, and DBAs.

Environment: Oracle RDBMS, UNIX, PL/SQL, Visual Basic, C++, MicroStrategy DSS Agent, MVS, COBOL, JCL, MS Office.

AMERICAN EXPRESS, Phoenix, AZ     1998-1999
Consultant/Modis

Performed technical lead activities. Created new CICS/DB2 programs for World Wide Central Submission project. Coded CICS stack navigation subroutine, error detail program and suspends program with pop-up displays. Coded batch/DB2 reports. Created test case suites. Supported global financial capture Y2K testing using Method/1 system development life cycle methodology.

Environment: COBOL/IMS/DB2 transaction-based processing with client-server interfaces. Librarian, Changeman, REXX, HourGlass, Xpeditor, ConnectDirect, AbendAid, EZYEDIT, Word/Visio, and File-Aid products utilized.

ARIZONA PUBLIC SERVICE, Phoenix, AZ     1997-1998
Consultant/Interim Technology

Rewrote multi-program COBOL/IMS benefits statement system to read DB2 tables.

Environment: COBOL/IMS/DB2 with client server interfaces.

BRAIN DUMPS

CERTIFICATIONS