Las Vegas, NV *****
Excel 2007 (Excellent)
Access 2007 (Excellent)
PowerPoint 2007 (Excellent)
MS Word 2007 (Excellent)
All MS Office product macros
2008 - 2016 Ricoh USA Inc. Remote Position
Sr. Business Analyst
Create and maintain all reports relating to Open Equipment Order Roll on a daily and month end view basis.
Create and maintain all reports relating to Administrative Holds on a daily and month end view basis for the purpose of KPI reporting.
Take the lead on automating various reports utilizing Access 07, Perl, OBIEE and various excel pivots to build an application that runs the entire process within Access 07. This was accomplished on multiple reports that my team ran on a regular basis in order to free up processing time to enable additional resource time for team members.
Provide feedback on a regular basis regarding Order Roll reporting and the various scenarios that contributed to delayed order progression across time. Implemented numerous enhancements to the suite of order roll reports that better captured where the process was held up and which business unit was responsible for the progression of the linked order group.
Creation of numerous AdHoc reports to provide specific reporting requirements over large time intervals such as quarterly or the entire previous year when such data was available. Usage of SQL, Perl, MS Access, OBIEE and Excel Macro was integral and necessary in some of these requests in order to better serve the customers’ needs.
Jul 2005 – Apr 2008 Ricoh USA Inc. Tempe, AZ
SR. MGR – Information Systems
Manage 6 OMD paths (NWD/WED/CEN/GLD/NED/MAD)
Lead and continue to build a team of 12
Responsible for interviewing, hiring and training employees; planning, assigning and directing work.
Prioritize projects to best suit the customers needs.
Manage all Western purge schedules including staff availability and running the actual conversions if necessary.
Identifies and resolves issues in a timely manner, always keeping the customer in focus.
Solves or assists staff with solving complex procedural/software issues.
Ensure SOX Compliancy is ever present with my team.
Train and delegate routines to my staff to ensure cross training.
Jan 2003 – Apr 2005 Ricoh USA Inc. Tempe, AZ
Assist in data cleansing in preparation f or transition to Oracle. Includes weekly conference calls with data cleansing team and weekly reporting developed distributed by myself to Western Management.
OMD conversions upon request including, Rep Numbers, Customer Numbers, Sales Types, Model/SN and various other upon request.
Assisted with OMD path purge.
OMD Security Project – high level involvement with Western Region. Implementing and maintaining new security guidelines for SOX reporting.
Database development for successful Six Sigma Project – Vendor Credits (Canon). Black Belt on that project was Marcus Downey
Daily resolutions of various TPR requests pertaining to OMD and the Western web site.
Obtained Yellow Belt status for Six Sigma Initiative.
Various courses completed and passed with over 80% average on I-dot including but not limited to UNIX, VBScript and Database Development.
Feb 2001–Apr 2003 Ricoh Canada Inc. Edmonton, AB
Business Analyst – Information Systems
Server set up and configuration to enable Web Reporting via Crystal Enterprise.
High level involvement of systems merge which included all data Canada wide. Ran conversions and provided system status to all employees.
GAP analysis and implementation regarding business process reviews.
Application support and development of customized Canada wide network programs.
Extensive use of Oracle based software.
Script writing UNIX language.
Project Management from initial stages overseeing to completion using MS Project.
Flowchart development utilizing Visio.
Reporting – Oracle, Excel, MS Word, Access, Crystal Reports & Outlook.
Database development with administrator privileges using Access.
Meeting with an emphasis on exceeding internal customer needs.
Jan 2000 – Feb 2001 Ricoh Canada Inc. Edmonton, AB
Ensuring documentation requirements are met.
Verifying calculations and assisting the Marketplace with leasing options.
Calculating yields using T-Value and HP calculator.
Dispositions and Trade-ups.
Renewal & end of term implementation.
Reconciliation’s and weekly funding.
Bank wire transfers.
Book/Gain Loss reports.
Implementing and documenting for procedure of cross border leasing.
Mid lease contract changes and deferrals.
Jan 1998 – Feb 2000 Ricoh Canada Inc. Edmonton, AB
Customer Service Representative
Oversaw portfolio consisting of over 1800 active customer accounts.
Special needs invoicing.
Ongoing customer interaction and problem solving.
Working with internal teams to solve customer concerns.
Negotiating renewal of contracts and up-selling to existing customers.
Suspense account management.
Bankruptcy claims working closely with the Marketplace.
Name Association Phone
Richard Selph Former Manager 678-***-****
Simone Kainer Former Manager 713-***-****
SQL, MS Access, Excel, Word, Outlook, Lotus Notes, Power Point, OBIEE
Las Vegas, NV - ab, obiee, access, belt, perl, visio, ms word,...
Manager Customer Service, Assistant Prop Manager/Leasing Consultant
Las Vegas, NV - leasing, very, apartments, typist, doing, move,...
Customer Service Representative
Las Vegas, NV - financial advisor, agents, managing, advisor,...
Accounts Payable, Expense Reports, General Ledger, Reports, Reconcile
Las Vegas, NV - prepared, makati, 2003, taguig, 1999, ledger,...
Information Technology Security
Las Vegas, NV - linux, information security, code, cisco, analyzer,...
Business intelligence analytics data architect DBA software engineer
Las Vegas, NV - dba, seo, php, ron, mining, cognos, amazon, mysql,...
Manager Sales Associate
Las Vegas, NV - paint, warehouse manager, laborer, warehouse,...