Paul Najera: in Santa Fe Springs, CA

Create manuals documenting IT operation processes. Create report distribution program. Modify stock transfer program, Modify checks for switch to new bank

Joined a team to upgrade an Wynne’s ERP system called Rentalman. My task was to upgrade or enhance the company’s home grown programs to new file layouts. Create new reports in SQL & Axiom Reporter. Create a program to download files from the IBMi (AS400) to the data warehouse on the network.

Monitor all processing, schedule jobs, maintain IBMi(AS400) backups and other system operations duties. Create or modify RPGLE or AS400 Query Reports. Assist in migration off the IBMi system by creating data files and reports. Assist user.

• Worked with team to migrate Retail Banking System (Fiserv’s Comprehensive Banking System) to new Oracle based system (OSI, Open Solutions Inc) by Extracted Data from the AS400 for conversion to new OSI Bank System. • Resolved balancing issues by developing complex queries to compare old and new systems during conversion from AS400 to Oracle system • Create and maintained custom Oracle reports using SQL, BRIO and SQR report-writer for Accounting, Retail Banking and Marketing departments • Administered C-View user query tool and assisted corporate users to query the Oracle database • Create or modify RPGLE or AS400 Query Reports

• Generate reports using IBM Query & RPG. • Supervised two other RPG programmers, managed workflow • Created loan acquisition program • Created project tracking program • Won 2006 Clear Excellence award, for creating program that saved the business unit and branches 1 hour of work each day, increasing productivity and saving about $200,000 per year • Give training classes to end users on IBM Query • Responsible for putting on new releases of canned software and retro fitting them with company’s specifications • Backup on night & day computer operations • Responsible for printing and distribution of reports, and special forms • On call to troubleshoot problems with EOD processing • Setup, monitor and resolve communication problems for branches and internal departments • Backup & Restore Files & Programs • Fix users problems • Used canned software, Fiserv’s Comprehensive Banking System (CBS), HarrisData’s A Accounts payable and fixed assists, ISGN’s Loan servicing system (LSAMS).