Project Manager Sales
Resume:
Phone: 818-***-****
***********@*****.***
Roxana Alva Professional Experience
Monrovia Growers August
Senior Programmer Analyst Left Monrovia from 8/05 for few months and
worked for Film Musicians Fund, returning
on 04/06 when they offered $10,000
increase
. Upgraded Harris Data Systems ERP to new version 14.2
. Improved efficiency and fix of Credit/Debit Memo System.
. Created, maintenance and download Customer Pre-Pricing process.
. Created Item-Price List, Pre-Pricing, Dispatch Log for Loads process,
using RPG/ILE, html and xml commands.
. Created new Sales Commission Project and Salesman Loans (Interface
with JDE One World: General Ledger, A/P).
. Created Order Item History Transaction Inquiry.
. Manhattan Logistics Log pro TMS interface with Harris Data System.
. Improved Charge Back commission process, and Manual Payment interface
with JDE One World. Fix and auto-send commissions and Draw & Loan
reports to Salesman. Include non-assigned division Salesman to get
commission sales. Update of Booking and Forecast Open Orders when
changing territories among salesman. Created History Log for Salesman.
. Ship Date Inquiry, Sales History Report, and Sales Analysis Reports to
handle Special Items.
. Created new Period Close to update the Open Invoices in ERP against
the JD Edwards One World paid invoices.
. Fixed Taxes and Freight for Shipper, Clean Shipper, Order
Acknowledgement and Order Copy.
. Improved Charge Back commission process, and Manual Payment interface
with JDE One World. Fix and auto-send commissions and Draw & Loan
reports to Salesman. Include non-assigned division Salesman to get
commission sales. Update of Booking and Forecast Open Orders when
changing territories among salesman.
. Created Alternate Customer Information.
. Created automatic receiving of Plant Material System, interface with
Availability System. Received Item Status - Too Small.
. Created the Shipping Performance report.
. Created new Undo-Order Sales Price. Fix Re-Price programs.
. Created Audit Charge Backs reports.
. Created Inquiry/Report Catalog Price.
. Global Design phase of the JDE Enterprise One 8.12 - ERP
implementation project, Order Management, Logistics Management and
interface with A/R, A/P, General Ledger. Including CNC roles for
Package Builds and Security.
. Converted AS/400 applications to connect to JD Edwards Enterprise One
Database.
. Created custom JDE Enterprise One applications using One World Tool
Set (Form Designs, Business Functions, Report Writing): Item Cross-
Reference and Retail Price, Salesman Loan Maintenance, Sales
Commissions System.
Analyzed, studied and translated business and information needs into
design, building and programming of the systems. Worked with users to
identify business needs, negotiated options and set up applications quality
assurance. Coordinated projects in all phases of development cycle with
others IT team members.
Used RPG/ILE with embedded SQL, CL/LE, Abstract, DBU, RLU, Esend (E-mail,
FTP and Report Distribution), Turnover, Visual RPG, SEQUEL ASC View Point,
Sequel, Websphere Tools, SQL, DB2, JD Edwards Enterprise One, Create!Form,
MS Project.
Film Musicians Secondary Market Fund August 2005 - March 2006
Senior Programmer Analyst
. Fund Systems: Producer Contributions, Royalties Distribution, Created
New Replacement Checks System, Taxes pulling data from AS/400 files to
ACCESS to print different forms W-2, 1099, 1042, RL1, Canada Taxes.
Also loading data from AS/400 to Website Server using Putty, mySQL
PHP, and html. Wages Omission Reserves. Website updates and database
administration.
Used AS/400, COBOL/400, RPG/ILE, DB2, PHP, html, mySQL Database
Administrator, Navicat on Linux, Evergreen AS/400 Report Downloader, Putty,
Access.
Wherehouse Entertainment, Inc. March 2001 -October 2003
Senior Programmer Analyst Reason
for leaving: Bankruptcy
. Migrated Merchandising System from Mainframe to AS/400. QA Tested and
implemented User Critical and Batch jobs.
. Created new System for Used Products. SPIF Incentive Program Tracking
System.
. Re-profiled System for Hot Products. PCC Maintenance System. Brick &
Mortar and Internet Company System, New Buyer System, New Purchasing
Order System, Packing System.
. Automated jobs using ROBOT scheduler and interfaced AS/400 reports to
be sent to users E-mail.
. Data and Application Architecture including Database Design,
Relationship Model, Physical and Logical Files, Standards, Repository,
Data Research and Analysis, Application Flow Charting for every
System, On-line Screens Design, Planning QA reports. Interfaced with
top executives for Financial, Payroll, Merchandising, Music, Used
Products, Inventory and Accounting Areas.
Used Cobol/ILE, RPG/ILE, CL, DB2, SQL/400, DBU, View, RLU, ROBOT Scheduler,
EDI, SQL Query, Access, SQL Server 2000, Visual Basic 6 ODBC, Visio.
Warner/Chappell Music, Inc April
1998 - March 2001
Systems Analyst Programmer
. Created and developed music publishing systems for the entertainment
industry to be used in Europe, Asia, Oceania, North and South America.
. Interfaced with Copyright, Royalty, Legal and Financial top executives to
design new systems or maintain them, creating applications Flow Charting,
Data Modeling, On-line screens design.
. Systems: Cue Sheet System, Third Party Print System, Circulation and
Shopping System, Poppy System (Centralized world wide data in one Inquiry
System, including Folio, Song-Registration, Contract, Film, Society,
Writer/Publisher, Channel). Label Claims System, Hire Library System for
new company at Miami. Multiple conversions such as Society-
Writer/Publisher Canada Conversion, Songs for Hong Kong, Films and Cues
for Italy, Project Manager for Copyright and Legal Departments, etc.
Used IBM/AS400 Cobol/400, RPG/400, CL, DB2 in Client Server, DBU, View,
RLU, EDI, Erwin Informatica package to structure data files from different
AS/400s to one.
Career Objective
. A position in a company performing a broad range of tasks including
business strategic planning, re-engineering, application systems
analysis, data analyst, developing data models and implementation.
Education
Catholic University of Peru - B.S. Industrial Engineering
Certificate EIT Wall LIC: XE098298 - California
Training
I Series DevCon 2006 and 2007 Conferences
ORACLE:
Report Writing Rel.8.96 (JDE Enterprise One)
Development Tools Part I
CNC & Systems Administrator Accelerated Rel 8.94 Ed 1
JD Edwards World & Enterprise One Customer Briefing: "Protect, Extent and
Evolve your Solution"
IBM:
AS/400 Tutorial, AS/400 Fundamentals, AS/400 Implementation, CL/400 Control
Language, SQL/400, Interactive Program Design, DB2, Cobol/400, Business
Strategic Planning BSP/SA, Business Strategic Planning Implementation BSPI,
AS/400 Change of Version Seminar. PL/1 Program Language, Cobol S/38
Structure Programming, Information Systems Planning, Introduction to
Information Systems, Relational Theory, Systems Structure Design.
OFINE:
Introduction to Micro-computation, SQL Mainframe, Introduction to CICS, Job
Control Language JCL, Introduction to Data Administration and Processing,
Systems Architecture, Terminals Operation, Operatives Systems, Advance
Technology of Computers, VM/CMS, Data Administration, Introduction to Data
Communication Systems, Introduction to On-line Systems, Techniques of
Programming, Access Method VSAM, Disk Operating Systems, Introduction to
Projects Administration, Utilities Programs, Equipment Utilization,
Procedure of Systems Planning
Pierce College:
Visual Basic, VBA
UCLA Extension:
Java
Hawkeye Information Systems:
Hawkeye/Pathfinder
Technical Skills
Language/Software: Visual Basic, VBA, SQL Server, PHP, mySQL FTP,
Cobol, WORD, EXCEL, ACCESS, Cobol/400, DB2/SQL, SQL/400,
JCL, QMF, EDI, CL/400, BASIC, XEDIT, AUTOCAD12, FLOW
CHARTING, TURBOFLOW, C, JAVA, RPG/400, RPG IV, RPG/ILE,
HAWKEYE, TURNOVER, ALDON, Cobol/ILE, VISIO, ROBOT, DBU,
View, RLU, MS Project, JD Edwards One World Tools.
Development Platforms: WindowsXP, Windows Vista, LAN, DOS, AS/400-
OS/400, Client/Server, Linux, JD Edwards One World, JD
Edwards Enterprise One.
Contact this candidate