Applications Manager Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Danna Derrah

danna@comcast.net

503-708-9876

 

Work Experience

Cascade Microtech                                                                           

Beaverton, OR

Business Analyst - Applications Manager     July 2007 – July 2011   

Managed IT Applications group responsible for all business related applications world wide. 

• Maintained corporate ERP system (Qad’s Mfg/Pro).  Responsible for ongoing support, enhancements, and upgrades
• Managed small team responsible for maintaining all SQL database applications supporting manufacturing and all external and internal web applications
• Supported all financial applications including GL, AP, AR, Budgeting and Financial Reporting, Fixed Assets, and Payroll 
• Responsible for maintaining SOX compliance as well as security for all business applications.  Managed all software Change Control for ERP system 
• Acted as Database Administrator for corporate ERP system (Progress Database)
• Performed Project Management for major upgrade of corporate ERP system
• Lead Analyst for conversion of newly acquired manufacturing site in Dresden, Germany from their legacy ERP system to Cascade Microtech’s corporate ERP system 

New Edge Networks                                                                         

Vancouver, WA

Business Systems Analyst     Nov 2005 – March 2007   

Support Oracle Financial and Purchasing applications for Finance/Acctg group.  

• Wrote business requirements and detailed specifications for interfaces to Oracle Payables and GL
• Performed system testing and data validation for custom interfaces and reports.
• Used SQL for ad hoc report development, data mining, and system troubleshooting. 
• Provided general application and system admin support for Oracle Apps.  
• Maintained system security and user accounts,  printer setups, and all other system profile setups. 

Independent Contractor        

Portland, OR

IT Consultant                         Jan 2005 – Nov 2005   

Provide clients with a  wide variety of services and expertise including systems analysis and design, process re-engineering, and  Progress 4GL programming.  Utilized COGNOS BI Reporting Tools  of ReportNet and Framework Manager.  Experienced in Project Management, Certified in Mfg/Pro Manufacturing module.

Developed Data Warehouse applications:  ETL (Extract, Translate, Load) using Progress 4GL

• P:erformed detailed analysis of data mapping from DRP/MRP legacy system into Data Warehouse. 
• Developed end user reports using both Progress 4GL and COGNOS ReportNet. 
• Performed testing and data validation for new reports and Data Warehouse load applications.
• Performed administration of DataMart maintaining both the database and business layer views using COGNOS Framework Manager. 
• Designed new DataMart business views to support key Management Dashboard reports
• Created dashboard reports with ReportNet.

Matrix Consulting, LLC

Portland, OR

Consulting Partner                 1996 thru Dec. 2004  

Over 10 years experience with MFG/PRO ERP Software.  Provided implementation services for MFG/PRO Manufacturing, Distribution and Finance modules, process re-engineering, and general project management and systems analysis.

Key Projects/Clients

1998-2004       SanDisk, Inc. 

• Sarbanes-Oxley project
• Wrote and updated internal IT procedures
• Wrote audit scripts and detailed test procedures
• Conducted internal audits of application controls required to meet Sarbanes-Oxley requirements.
• Project manager and primary business analyst for implementation of Mfg/Pro in Japanese subsidiary (SDKK)
• Performed analysis and developed business requirements for both Retail and OEM Order Management, Shipping and Invoicing, Inventory Control, GL, AP, and AR functions
• Worked with Retail Sales organization to streamline order entry and shipping process.
• Conducted on-site training classes for SDKK staff
• Developed test plans and led pilot testing of all modules.

·         Senior business analyst for the rapid implementation of MFG/PRO at SanDisk, at the time a  $160 million manufacturer of memory products.

o   Taught training classes and consulted in all areas of the software. 

o   Led development of procedures for inventory control, work order management, shipping, invoicing processes

o   Directed Accounting in development of  Standard Cost process and multi-currency setups.

o   Continued working with SanDisk as they have grown to $1 billion in sales.

o   Developed requirements for processing Retail RMA orders.

·        Lead Analyst in implementation of Distribution Order System

o   New functionality improved ability to manage their supply chain. 

o   Addressed inventory tracking, planning activities, and shipping/receiving of orders

o   New processes improved material movement from suppliers, US operations, and contract manufacturers throughout Asia and then to Retail Distribution sites in US and Europe.

·        Lead analyst on a project to automate the intercompany ordering process (Enterprise Material Transfer)

o   Developed requirements and detailed specifications for customization of standard Mfg/Pro functionality.

o   Automated the intercompany order creation, transfer, and confirmation process reducing Retail Sales Order booking cycle by 2 days.

1999-2000       Grass Valley Group

ERP implementation systems lead for this former division of Tektronix, Inc as they were divested and incorporated as a separate company.  Project involved migrating from a highly customized 8.6 version of Mfg/Pro to a standard 9.0 version.  

·         Assisted Sales Operations in defining their Configured Orders process

·         Developed shipping processes for Global Shipping initiative.  

·         Led implementation of  Enterprise Material Transfer module providing intercompany ordering process. Developed procedures, process flows, and policies for order entry flow between US Operations and subsidiaries in Asia and Europe.

·         Developed a process for Service Part Inventory replenishments for their multi-site service organization

·         Assisted in development of AR and AP processes.

Additional Mfg/Pro experience: 

• Project manager and primary business analyst for implementation of Mfg/Pro in Japanese subsidiary of FEI.

Maxtek Components Corporation

Beaverton, OR

IT Manager                            1994-1996 

Managed IT operations for  the former Tektronix division Hybrid Components Operation (HCO).  The division was divested and reorganized as a separate company, Maxtek Components Corp. 

·         Established Maxtek’s initial IT infrastructure:  included hiring of staff, Desktop HW/SW, setup of networks, and acquisition of LAN HW/SW and Business Systems HW/SW. 

·         Performed re-implementation of Mfg/Pro ERP system

·         Established corporate policy and standards related to email, desktop hardware/software, printing. and security.

Skills

Project Management

Systems Analysis and Design and Process Re-engineering

Software Development Life Cycle (SDLC)

Relational Database Design

MS Office (Word, Excel, and PowerPoint), MS Project, Visio

DataWarehousing  -  COGNOS ReportNet and Framework Manager

Conducting training classes (Mfg/Pro Financials, Distribution, Mfg, Costing, Progress Report-Writer)

Oracle System Administration (user security, printer setups, system profiles, etc)

Oracle Reports/Report Builder and SQL using SQLNavigator and SQL*Plus

Progress 4GL programming

Progress DB administration and Unix administration (Sun Solaris and Linux)

Misc programming languages (COBOL, Turbo Pascal, Mark IV and Mark V Rpt Writers)

 

Education

University of Portland,  BA in Business Administration.  Graduated with honors

Additional Work Experience

1992-1994  Tektronix, Inc.

IT Manager/Team Lead for Integrated Circuit Operations and Hybrid Component Operations (HCO and ICO).  Provided first line IT support for HCO and ICO, internal component divisions.   Project manager for MFG/PRO site implementations of both divisions.   Managed division’s LANs,  custom pc and mainframe based applications, liaison to corporate IT.   Developed and modified custom applications in Progress, Turbo Pascal, Fortran.

1991-1992   Freightliner Corp

Programmer/Analyst for order processing applications.   Design, code, test programs in the order translation and order processing systems.  Work with other development groups to ensure proper functioning of interfaces  COBOL, IMS DB-DC, structured program analysis and design, off hour support

1983-1991      Tektronix. 

Systems Analyst, Corporate IS - Order Processing

Decision Support Analyst,  Corporate Decision Support:  provided Ad Hoc reporting in support of Marketing and Sales.  Responsible for ongoing maintenance and support of the Corp Order History system including daily, weekly, monthly batch updates.  Provide support to division IT so consistent reporting standards are followed throughout the corporation.

Download Resume Format