Confidential Freelance Website Design Development Performed the following on wordpress websites: PHP, HTML, Jquery, Javascript and CSS custom coding. MySQL database setup and administration. Image creation and editing where necessary to improve appearance of websites. Setup extensive applications with PHP coding. Demo site is located at Major Projects/Websites - OTD - Car Dealers signup and can add car deals with 30 different fields of information including pricing. Members signup and can do searches on car deals filtering on those 30 fields along with pricing. Created cron jobs that run daily to execute member searches and send them emails if matches are found. Another cron job that updates statistics for dealers on numbers of times their ads came up in searches and also how many times they were clicked on.
- Nyprep - Online school with courses and tests. Course with 18 chapters and approximately 800 course pages in those chapters. Created chapter timer so users had to spend minimum time on chapter to continue. Each chapter also has a test with 10 random questions drawn from 100 in database. Users also have to score 70 on the test to continue.
- Draperiesbysandi customers fill out detailed forms which are bundled into an order and then are submitted to the website owner for a price quote. Owner sends quote back to client with an automatic link where they can pay the price that was quoted for the total order.
- Gcommerce Template template for Ecommerce sites to load thousands of products in multiple categories and subcategories using easy input forms to enter data into the database. Product pages had different content displayed when visitor clicks on different tabs and also a custom created review system .
- BBT Event Calendar client sells bike tours in NYC. Created site where he can load tours and they are on calendar on proper month and day with color coding by event type along with custom pricing and times.
- Woocommerce DB customer has a drop-ship website where he sells 20,000 products from 2 different vendors. All product details are provided and updated by vendors on XML or CSV files. Created solution that would load all product details from these files and then update all of the different fields in the multiple Woocommerce database tables that are used for products.
Confidential Operations Manager - Supported Web-Based Business in the following ways:
- Accounting: Provided accounting services including Travel Expense Reimbursements, Payroll, Payroll Taxes, Billing, Accounts Receivable Payable, Bank Reconciliations, General Ledger Processing, Financial Statements and Tax Returns.
- Customer Support: Monitored communications email and phone for problems, resolved issues or problems and communicated wih customers.
- Website design, development and support: Maintained website which included PHP, CSS and HTML coding using wordpress. Also redesigned website multiple times including proofreading of content for errors along with editing images for proper size and visual attractiveness. Wrote PHP code for an online test to control the test and how visitors would navigate it. Also supported Multiple Domains, Hosting and FTP.
Confidential Business Services Analyst - Financial Forecasting created new forecasts by analyzing financial structure, trends and other inputs. Updated forecasts, reviewed variances, investigated and corrected variance problems, analyzed financial performance for needed accrual, amortization and deferral Journal Entries and processed those entries. Learned new SAP system for ledger review and also posting Journal Entries. Assisted manager with financial decisions.
- Responsible for the financial shutdown of the Flint V8 Engine plant and the financial start-up of the Flint Engine South plant. Analyzed both account situations to develop a transition plan, identifying, transferring or terminating all revenue and expense items.
- Assisted EDS Accounts at plants in retaining ongoing revenue by analyzing related billing documents and creating documentation. Presented findings to the EDS Client that billings were valid which resulted in EDS retaining the revenue.
- As part of the Time Tracking Implementation - helped create a project-plan for deployment and also create training materials for users. Created a presentation for management about how the system works and the impact upon EDS business. Gathered requirements on what information the structures should produce. Designed and created the project structures. Advised assisted users as a System Expert on project structure guidelines and setup.
- Improved software tools to increase accuracy of output, correct errors, and save time by creating, modifying or correcting databases and spreadsheets.
- Became an Agreement Specialist for EDS investigated and resolved several billing and documentation problems.
- Customer billings - executed all billings to customer including researching and developing all supporting documents and information needed.
- New Billing agreements - gathered customer requirements researched equipment, developed Bills of Material, Bills of Service, Proposals and Contract forms with price detail sheets.
- Conducted communications / negotiations with local GM comptroller on new contracts.
- Completed several different types of Ad-Hoc Requests for Financial Information most with very little lead time.
- Major Projects
- Statement of Work SOW Contract Creator Maintainer Ongoing
- Researched all fixed price services provided at plant, interviewed team members on time spent, equipment used and support levels provided to develop system support prices. Created 300 page SOW document describing all services to be provided, with supporting text and metrics along with pricing for those services approximately 1.8 million / year . Maintained the SOW on an annual basis.
- SOW Analysis - Machine Tool Division
- The local customer was questioning the charges being billed in the SOW. Assisted local management in defending this ongoing revenue by performing a detailed analysis on 5 years of source documents and changes to the local agreement to rebuild the SOW pricing detail was nonexistent which was presented to the customer. All revenue was retained.
- Expense Analysis at Willow Run
- Created a process for visiting plant sites and analyzing their financial records in great detail to assist local management in answering upper management questions about the site's financial performance. Discovered that the forecasted expenses were overestimated and also acquired credits for expenses that shouldn't have been incurred lowered forecasted expenses by 56k per month .
- SOW Central Update Team
- Helped develop a project plan to centralize the annual update of 40 SOWs. Created a training class and instructed the update team on the update process, SOW guidelines, history and pricing. Was available to the team as a Process Expert on all SOW questions. Improvements over prior updates included the documents being completed on time and greater accuracy and consistency.
- Other Experience / Training
- Extensive experience with: BASIC programming language, Microsoft MS Excel, MS Word, MS Access, MS Powerpoint, and SAP. Experience with SAP and Business Objects.
- Typing 30 words per minute.
|