Silvestre A. Carlos
***** ******** **, *** **, North Hills, CA 91343
Mobile Phone: 818-***-****
adxjs5@r.postjobfree.com
EMPLOYMENT HISTORY
Accounts Payable Supervisor
JKRS Residential Management Inc February 2022 to October 2022
North Hollywood, CA 91605
Processing
Processed all corporate invoices, subcontractor payroll, corporate utilities, legal fees, gas allowances, building rent, court fees, asset and management fees, employee health insurance payments, medical testing fees, background investigation fees, tenant related compensation.
Supervision
Supervised three (3) AP clerks in processing and documenting vendor and supplier payments in their respective properties. Ensure that invoices are processed according to invoice received dates and job verification are completed.
Training
Provide training for new property managers on what documents to process, how to order materials needed for the property they manage, how and who to contact in the A/P department for requesting record checks and status of invoices. Explain the processes needed for check request and cash disbursement.
Communication
Meet with Vendor Relations Supervisor on a weekly basis to address problematic invoices and missing work verification documents from suppliers and vendors. Meet with A/P clerks to address issues arising from the properties that they manage.
Development
Created different macro-enabled worksheets to facilitate faster data entry including validation and producing import files for upload to Yardi. Created a macro-enabled worksheet to process credit card disbursements by assigning the correct accounting code for each transaction and generating a summary by property and an import file for uploading to Yardi. Created a macro-enabled worksheet to convert emailed transactions from HD Supply and assign the correct accounting code and summarize by property code and generate an import file to Yardi for check preparation. Created a macro-enabled worksheet for use by the Accounts Receivable department in order to process report generated from Yardi and create a customized report that shows property and units that are delinquent per property manager.
Operating Environment and Software: Windows, Microsoft Excel, Yardi, Asana
IT Specialist
The Harman Press June 2020 to February 2022
North Hollywood, CA 91605
Projects Managed:
Hardware Inventory
The company have a lot of personal computers and servers that have not been inventoried and documented. Created an inventory list and documentation of all hardware and peripherals in the company, which includes testing and/or repair to determine usability and disposal. Used Excel and MS Access.
Website Maintenance and Management
There are three (3) separate businesses under the company and each business has its own website. Two of the websites have their own ordering module and product database. I managed the product images and price updates for these websites, using WordPress, EFI Direct Marketing and Taopix.
ERP Adminstration
Administered the company’s ERP for Printing Press. Managed user creation, access and query reports, software updates. Maintained the company’s product costing and link to the online ordering system (EFI). Managed online customers and built custom landing pages for new customers and their authorized users for each company.
Product Design and Management
Created and managed different customer products, based on customer requirements/files to provide on-demand and online ordering in their respective landing pages. Used EFI Direct Marketing software to design the ordering page and provide link to the company ERP (ePace) for processing online orders to the production queue.
Network and Server Management
Managed the company’s network using Cisco Meraki dashboard and equipment. Managed in-house servers and large format printers, and NAS (Synology) by doing updates and troubleshooting.
AWS Administration
Managed the company’s cloud-based servers using AWS. Create and managed server instance size, memory, cpu size, and storage using AWS EC2 and S3. Managed the company DNS using AWS Route 53. Managed website servers using AWS Lightsail. Backup servers using AWS Backup.
Desktop Troubleshooting and Support
Provided desktop support for users and OS updates for both Windows and MacOs.
VOIP Installation and Administration
Managed the VOIP of each user including installation, configuration and troubleshooting using AT&T office@hand UCaaS solution.
Email Administration
Managed the company’s email for the 3 sub-companies using Gmail Admin and Outlook for deployment. Including quota allocation for each user and maintaining email groups.
Operating Environment and Software: Windows, Microsoft Excel, MacOS, Salesforce, EFI-Direct Marketing, Word Press, Creative Cloud, Adobe Photoshop, Adobe Illustrator, Adobe InDesign, Synology, Cisco Meraki, AWS EC2, AWS S3, AWS Route 53, AWS Lightsail, AWS Backup, TCP/IP, SQL, PHP
IT Consultant
Sacha Sunday Enterprise Network February 2019 to June 2020
North Hills, CA 90040
Projects Managed:
Setting up client startup website
Provided different options on the technical aspects of the client’s website. Created initial website startup and implementation plan for client. Used online website developer, as client intended to manage and maintain their website. Client implemented a social media campaign that I developed and used the assets I provided for them.
Data pivots and reporting
The client is a company that provides media buys to different entertainment networks. Created a macro tool for them to automatically generate pivot tables and report format from exported data from their legacy system and importing to Excel. I created a landing template that provides filtering and reporting based on customer media buys per program and updates a dashboard to show KPIs and other performance metrics. Created macros and Pivot tables in Excel.
Excel Training Course
Conducted MS Excel Classes for client’s accounting staff. Created a lesson plan based on the goal of the department and expectation from their accounting staff. Performed knowledge assessment of each individual and created the appropriate level of training based on their skills. The goal of the training was to put the accounting department’s Excel knowledge at an expected level to achieve the department's goal.
Network re-cabling and mapping
Client fired their IT guy and needed access to their network, after it crashed. Performed network diagnostics and determined cause of failure is from a network switch. Discovered also that the cabling layout needs to be re-tested and mapped, as there was no existing documentation.
Operating Environment: Windows, Microsoft Excel, MacOS
IT Project Manager
CAL-Royal Products Inc. May 2006 to February 2019
6605 Flotilla street
City of Commerce, CA 90040
Projects Managed:
Warehouse Management and Controls
Studied existing processes, wrote new processes using industry best practices. Managed a diverse group of teams consisting of operational, supervisory, and executive people. Recommended and implemented new management controls to maximize existing technology and improve the order and delivery processes. Reduced the number of erroneous shipments by 45%, and increased repeat orders by 10% on the first 3 months of implementation.
Products Cataloging
Revision of product catalogue, classification, and product layout. Maintained the different product catalog, sweets, brochure, and website. Managed a team of 8. Implementation of New Products Information Sheet. generated 20% increase in customer base.
Email Campaign
Managed customer email addresses through customer self-enrolment, submission from salesrep, submission form customer service. Creates email campaign for new products and sales promotions using Constant Contact. Generates a report of email marketing success by checking email opens, clicks, and see who’s sharing our emails, then adjust our content based on what performs best.
Inventory Classification and Tagging
Designed and implemented classification and tagging system to improve productivity of pullers and stackers. Shipping productivity increased by 25% upon implementation of the
system.
Service Level Agreement Monitoring
Introduced and Oriented the Customer Service, Warehouse and Purchasing departments in managing and maintaining SLA among the departments and their internal and external clients. Defined and identified service level specification (SLS) and Service Level Objective (SLO). The SLS was used as an operational guideline for the implementation of each department’s services, and the SLO as a subset of the SLS contains the service parameters and goals to be achieved by the SLS. Overall total improvement of services was observed during the first 2 months of implementation.
Operating Environment: Windows 2003, Windows XP, MAS90 ERP, MS Project 2007, Adobe Illustrator, Microsoft Powerpoint, Microsoft Word, Microsoft Excel, Microsoft Visio, Microsoft Access, Adobe Creative Cloud, Adobe Photoshop, Adobe Illustrator, Adobe InDesign, Active Directory, Microsoft Exchange, Constant Contact
IT Project Manager
FactoryPrices4U.com March 2006 to May 2006
2300 Yates Ave.
City of Commerce, CA 90040
Projects Managed:
Data Center and Networking Setup
Prepared SOW and conducted the vendor selection process for the setup of the company’s network, Windows and UNIX servers and workstations
Product Mailing Campaign
Implemented an advertising campaign by doing a software selection on which software to use and how to best implement each. Provided scripts to automatically extract information from MS Outlook and use it for order processing and maintenance of mailing list.
Operating Environment: Windows 2003, Windows XP, Starship Shipping Software, MS Outlook, MS Excel, MS Word, HP-UX
QUALIFICATIONS/CERTIFICATIONS
Management
Engineering the Performance System, Kepner Tregoe, 2004
Core Skills for Building Commitment, DDI, 2004
Facilitating Improved Performance, DDI, 2004
Following Up to Support Improvement, DDI, 2004
Service Culture Workshop, DDI, 2003
Basic Management Program, ABS-CBN, 1998
Fine Tuning Modern Management to Filipino Culture, ABS-CBN, 1997
How to Relate with Employees and Handle Disciplinary Action, ABS-CBN, 1997
IMP– The Challenge of Leadership and Utilizing Effective Disciplinary/Corrective Action, ABS-CBN, 1997
IMP- Identifying Performance Expectations, ABS-CBN, 1997
Time Management, Meraclo Foundation Inc., 1987
GTEB Rules and Regulations, GTEB, 1985
Technical
Performance Monitoring and Troubleshooting, HP, 2005
Patrol Express, BMC Software, Feb 2005
Linux 201 – Linux System and Network Administration, QLinux, 2003
Linux 101 – Linux Installation and Basic Configuration, QLinux, 2003
System and Network Administration II, HP, 2003
System and Network Administration I, HP, 2003
IT Governance In Extended Enterprise Seminar, ISACA, 2003
Introduction to Firewalls, Intrusion Detection and Perimeter Protection, ISACA, 2002
CA940 - SAP R/3 Application, Security Concept, SAP Phils., 2000
BC360 - Technical Core Competence, SAP Phils., 2000
SAP50 - BASIS Technology, SAP Phils., 2000
BC400 - ABAP Programming, SAP Phils., 2000
SAP20 – SAP R/3 Overview, SAP Phils., 2000
Tune and Troubleshoot the Oracle 7 Database, Oracle Systems Inc., 1997
Oracle Symmetric Replication, Oracle Systems Inc., 1997
Database Administration (Database Backup and Recovery) Oracle Systems Inc., 1997
Database Administration (SQL Admin), Oracle Systems Inc.,1997
Introduction to Power Builder, UAP, 1996
S-Designor Overview, Powersoft, 1996
Introduction to SQL Server, Sybase, 1996
A Methodology in Developing Expert Systems, ACTC, 1987
LAN II – Selection Guidelines, ACTC, 1986
LAN I – Basic Concepts, ACTC, 1986
Basic Systems Analysis Skills, NCR, 1986
COBOL 74 Programming, NCR, 1985
Basic Assembler Language, Computer Power Unlimited, 1984
Advanced BASIC Language, Computer Power Unlimited, 1983
BASIC Language, Computer Power Unlimited, 1983
Basic Computer Systems, Computer Power Unlimited, 1983
Education
B.S. Management Information Systems (Credential Evaluation Equivalent)
Foundation for International Services Inc., 2006
Lynwood, WA 98087
Executive Development Program
Asian Institute of Management, 1998
Makati City, Philippines
Bachelor of Science in Aeronautical Engineering
PATS College of Aeronautics, 1983
Paranaque City, Philippines