Project Manager Analyst

**** ******* ***, *** *******, CA *****

**********@*****.*** http://www.linkedin.com/in/jimgettman

__Objective__

DATA MART AND PROCESS ARCHITECT / SENIOR ANALYST / USER EXPERIENCE DESIGNER

Making information and processes work for business, and interfaces work for

people - Specializing

in rapid development and deployment for small but innovative and growing

companies and teams

__Skills__

Development Leader - multi-disciplined experience with Formal, Agile &

Iterative methods, Mil-Spec and commercial software quality assurance, code

walk-through and testing

Communicator - Articulate and refined at written and oral presentations,

proposals, software design, requirements communications, and process flow

specifications, conflict resolution, auditing and process reviews

Project Manager - Software development team leader, SOX Project Manager,

Site manager for ERP and MRP-II implementations, Program Manager in US Air

Force IMIP program.

Analyst, Designer and Architect - In-depth experience in Information

Technology and Internet, for aerospace, manufacturing and finance with

Windows, Unix and database systems; leading justification and

implementation

Technologist - Business Objects Data Integrator (ETL), Universe Builder,

Informatica (ETL and Administration), Actuate/Crystal Reports, Unix,

Windows, RCS, Perforce, TWiki, SharePoint, MediaWiki / WikiMedia, ER-

Studio, BaaN, ERWin, T-SQL, SDLC, MS-Office/Project/Visio, OLAP, Apache,

trading systems - SWIFT, FIX, ISITC

__Experience__

ANDREWS ELECTRONICS, Consumer Electronics Parts Distributor

February 2009 to January 2010

Environment: Custom-developed warehouse, E-commerce and management

applications running on Unix and Windows XP Server. Data Mart with shell

script, ODBC and MS-SQL-Server. (Private company being sold back to prior

owner and undergoing management restructuring.)

Business Analyst reporting to CEO (promoted from Systems Analyst reporting

to IT Director)

. Designed and implemented low-cost Data Mart used to generate daily B2B

reports for major customers

. Designed customer-facing and internal Web applications

. Developed statistical methods for proprietary inventory lead time

analysis

. Designed and led implementation of a deferred core billing and tracking

systems

. Supported managers developing proprietary inventory optimizations for

200,000 SKUs using Excel 2007

DECURION, Owner of Robertson Properties Group, Pacific and Arclight

Theaters April 2008 to November 2008

Environment: Purchased retail and management applications running on MS-SQL

and Windows XP Server. Business Intelligence based on Business Objects

Data Integrator, Universe Builder and Crystal Reports. (Private company

with focus on new age employee development; layoffs from 234 to 150 in

progress.)

Senior Data Analyst

. Designed, implemented and tuned Enterprise Data Warehouse in 4 weeks

using ER/Studio and SQL scripts

. Learned Business Objects Data Integrator on the fly, designing and

implementing ETL from ADP E-Time

. Learned Business Objects Universe Builder on the fly, designing and

filling Data Mart for labor analysis

. Developed and implemented team standards and workspace for documentation

and knowledge sharing

. Cooperatively managed all IT projects and improved processes as member of

Transition Learning Group

__Experience_(Continued)__

POINT 360, Media Post Production "From Camera to Customer, Turn to Us"

November 2006 to November 2007

Environment: Custom web applications built offshore and locally by agile

and iterative methods using Oracle Db and MySQL on Linux, MS-SQL on Windows

2000 Server and VB.NET IIS interfaces built with MS Visual Studio,

Infragistics components and MS Visual Source Safe. Systems designed using

MS Excel, Word and Visio; Erwin, PL/SQL and Sparx Enterprise Architect.

(Public company, active in mergers and acquisitions with many legacy

applications; laid off after 40% of business divested.)

Systems Analyst (working as Business Analyst and Project Leader)

. Led Sarbanes-Oxley IT project working with company leadership and

consultants, developed and implemented internal policies and procedures

to assure SOX compliance within 6 months

. Used Erwin to design database and security for Incident and Change

Management - custom developed system on Oracle 9i DB and Microsoft

Visual Studio VB.NET Web UI to track IT service requests and planned

changes to IT systems. Used Jira and Microsoft Visual SourceSafe for

issues and releases

. Designed Oracle PL/SQL Triggered Asynchronous Update method for data

warehouse assuring current data, audit trails, record accountability,

rollback and recovery

. Implemented MediaWiki Knowledge Base for collaboration on IT projects

. Webmaster for www.point360.com, led project updating company website in

two phases: new Dream Weaver static site with HTML and CSS; new database

site with mobile interface, flex menu, SEO, new graphics, edit-in-site

user content management, history, rollback and approval cycle

THE CAPITAL GROUP, Premier Mutual Fund Company and Investment Manager

October 2000 to July 2006

Environment: Scores of custom investment applications built on diverse

technologies. Transitioning from Sybase DB on HP-UX to Oracle DB on

Solaris, and from PowerBuilder UI to browser interfaces of many types.

Financial communications are by SWIFT, FIX, OMGEO, Reuters, Bloomberg and

other systems. (Private company with diversified ownership and long-term

growth strategy; Resigned as Brea facility moved to Irvine)

Programmer Analyst, Production Support Services

. Implemented release controls for PSS applications and worked as primary

release coordinator

. Developed Disaster Recovery procedures and resource tracking system,

coordinated team DR exercises

. Represented Investment Systems Group on Remedy Users Committee,

administered Remedy application proposed and reviewed system

enhancements, consulted on gap analysis for Remedy upgrades

. Administered and supported Informatica PowerCenter ETL for all

departments and uses

. Suggested, justified, won approval for, and managed Production Support

Monitor project - analyst and project manager developing and deploying

web-based process and system monitoring tools to track batch flow and

real-time systems status for pro-active incident response

. Suggested, justified, won approval for, and managed Production Support

Services Knowledge Base project, guided open-source TWiki application

through 3 month IT governance process, piloted application, wrote

training materials and trained users, result was improved incident

response for mission-critical systems

. Facilitated production release meeting to review and coordinate releases

for all investment systems, preparing production release notes and

sharing understanding, and creating release knowledge base

. Developed training materials and led classes teaching others to support

trade processing and settlement

. Provided primary on-call support for SWIFT, FIX, and 15 custom trading

and communication systems

. Designed, justified, won approval for, and project leader implementing

Firecall - secure web application and process for SOX compliant password

storage, retrieval with usage notification and follow-up, password

expiration and update

__Experience_(Continued)__

Programmer Analyst, Trade Processing Systems

. Trained in Informatica PowerCenter ETL, evaluated Informatica for trade

processing, selected CG-developed custom database transfer method due to

acknowledged issues with locks, batch loads and process control

. Wrote complex T-SQL extracts and loads supporting ad-hoc reporting,

delivering data in Excel pivot tables

. Led several SWIFT and OMGEO OASYS Global upgrades and migrations to new

technology

. Proposed, developed and implemented Unix email interface for TPS and

SWIFT systems - emails processed by concurrent daemons into multiple

attachments or inclusions based on number and size targets, submitted to

Lotus Domino server via sendmail, and archived for validation and re-

issue

. Implemented TPE - temporary privilege escalation, improving system

security and emergency response

. Implemented Remedy in TPS dept., preparing procedure manual, configuring

system and doing all training

. Transitioned TPS and SWIFT primary support to centralized support group

writing training materials, leading training classes, writing service

level agreements and getting them approved

Contractor, Trade Processing Systems

. Contract-to-hire transitioning career from manufacturing to investment

systems, made associate in 6 months

. Primary support for TPS - trade processing and settlement systems, and

SWIFT - bank communications started handling support calls from 4 AM to 1

PM after 2 weeks training, reduced escalation from 75% to 25%, saving

developers from off-hours duty

. Reduced support calls by 50% using root-cause analysis even as

application volume doubled

ROPAK CORP., Corporate Office, Injected Plastic Packaging Manufacturer

December 1992 to October 2000

Environment: Transitioned applications from Unix files and terminals to

Windows / LAN clients and from regional SCO Unix servers to WAN with single

HP-UX server running MK (formerly BAAN then Manman/X) with ANSI X3.64

interface. Updates designed using MS Excel, Word and Visio; managed using

Excel and MS Project. (Public company, bought out by Linpac Mouldings,

PLC; laid off during resin price crisis)

Project Manager

. Project Manager implementing inter-site logistics and master scheduling

at 10 plants - used integrated inventory and capacity planning reports

and teleconferences to coordinate North American production into single

available-to-promise system supporting national accounts marketing effort

. Coordinated mold sharing and inventory planning to diversify regional

products with existing assets

Senior Systems Analyst

. Conducted employee reviews, made recommendations for hiring, promotion

and discipline

. Unix system administrator - found and removed non-secure accounts,

administered IP LAN and WAN

. Project Leader implementing Manman/X and MK, BaaN tools based ERP systems

at two plants

. Implemented MRP at all plants - training and processes reduced inventory

by 10% and late shipments by 66%

. Implemented location control (LN) module to support inventory aging and

revision control at one facility

__Experience_(Continued)__

Systems Analyst

. Manufacturing lead for ERP at 7 sites in USA and Canada - coordinated

multiple upgrades, converted data using Unix scripts to adapt and

validate, and macros to build thousands of BOMs per conversion weekend

. Designed and implemented custom production entry system - combined

production issue, hours and warehouse receipt to single screen, reduced

data entry time by 75% and eliminated reconciliation

. Manufacturing modules and data conversion pilot leader - wrote company

procedures and mapped all data for conversion, coordinated super-user

team approving pilot results for implementation

. Project coordinator for final ERP selection process - prepared gap

analysis and feature weighting by area of interest, worked with top

executives, accounting and plant leaders to finalize decision and

architecture

WESTERN GEAR, Applied Technology Div., Aerospace gearbox and actuator maker

August 1981 to December 1992

Environment: Business systems ran on diverse IBM computers, Engineering and

Manufacturing on DEC VAX and diverse HP systems, Marketing and Accounting

on Apple and Compaq PC systems. (Private company, taken public, bought out

twice; laid off as operations moved to Utah by Lucas Aerospace, PLC)

Information Systems Analyst, Lead

. Implemented on-line knowledge-base automating all quality system and IT

procedures

. Developed skills-matrix for IT staff to maintain essential systems during

factory downsizing

Quality Systems Analyst, Lead

. Software QA Representative to DOD and Aerospace customers, DOD-S-2167, GE

S-1000 - over2 years assuring delivery of mission-critical control and

test software in agile process with zero defects

. DBA for Quality Systems - assured system backup and performance,

installed upgrades

. Supervised two employees, $200,000 annual budget

. Created defect reporting and material review system supervisory program

that added audit trails and accountability for all transactions

. Used Cognos and SAS tools to build custom management quality trends and

audit tracking reports that resulted in improved practices, increased

product safety, and reduced liability

Quality Systems Analyst

. Wrote SPC chart and graph tool for tracking operator product acceptance -

developed unique method for single-part statistical process control

reducing defect rates in small production lots

. Designed/wrote QA planning system using Oracle/SQL modifications to Mcapp-

II, designed custom font precluding record forgery and eliminating

ambiguous characters

. Justified, implemented and managed optical disk storage and retrieval for

quality records

Project Manager, MAN-TECH Technical Modernization dept

. Designed and implemented scheduling and control program, safety

perimeters and sensors and part handling tooling for GE-FANUC cell robot

. Led in-house training in IDEF0 process modeling and effectiveness review

__Experience_(Continued)__

Industrial Engineer, Advanced Technology

. DBA for manufacturing applications - MOST, Multicapp, prepared

$120,000/year budget

. Implemented Maynard Operation Sequence Technique to estimate standards

for new operations

. Contributed significantly to successful Phase 0 proposal to US Air Force,

resulting in $250,000 grant

. Performed operation delay studies highlighting tooling issues in work

centers, leading to procedures to plan tooling on bills of materials

based on tool consumption rates

Capacity Planner

. Developed statistical analysis showing optimal production overload and

lead-time parameters

. Automated capacity tracking reports on PCs reducing preparation time from

20 to 2 hours

. CRP/SFC team leader for implementing AMAPS/G MRP-II system - designed

transactions and interfaces between shop floor data collection system and

new ERP system

. Implemented full input/output/queue tracking, reducing production lead-

time by 25%

__Education__

WEST COAST UNIVERSITY, Los Angeles - B.S.M.E., 3.52 GPA while working full-

time

RIO HONDO JUNIOR COLLEGE, Whittier - AA Engineering, Dean's list 3

Semesters

LA SERNA HIGH SCHOOL, Whittier - SAT 730 math, 690 English

__Other__

BOARD PRESIDENT, Western Gear Federal Credit Union 1987-2002

. Led growth from $5 to $7 million in assets despite layoffs and eventual

factory closure

. Directed merger evaluation and approved merger with larger credit union

when bank-sponsored government regulations precluded expanding customer

base by smaller credit unions

FOUNDING PARTNER AND PRESIDENT, AccessByDesign 1994-1995

. Led team of 4 web designers in sales, marketing and development

. Wrote HTML and CGI applications using Unix and Windows based tools

. Profitable business with three part-time employees

Contact this candidate