Логист

- Assisted the company in transition to SAP by organizing historical purchasing information from multiple MS Excel documents into organized MS Access database
- Designed and built MS Access-based analytical 2,500 Entry Packets database (2-year imports, totaling $1,000,000,000) with links to original Entry Packets
- Contacted “Expeditors International” for original documents review, that seemed incorrect and made changes in the documentation
- Organized and scanned the corrected documents into PDF format files and placed them into the database on the corporate drive
- Organized and scanned Wire Transfers and Commercial Invoices into PDF format files, placed them on the corporate drive, and created links to them from the Access database
- Analyzed the database information for trends in pricing and volume depending on SKU and country of origin
- Illustrated the analysis with various MS Excel charts and graphs
- Created list of all SKUs included in the database using MS Access
- Perfected analysis of importing documentation (Ecuador, Thailand, and Malaysia)
- Created Bills of Lading and Purchase Orders using MS Excel
- Analyzed inventory reports (SAP headquarters report and warehouse report) in order to find mismatches and reported them to Strategic Sourcing and Customs Compliance Manager
- Provided translation of the Czech Customs document from Czech into English using MS Word

- Developed effective MS Excel-based management tools to measure and analyze financial information for energy efficiency savings
- Contacted local authorities for information about energy-efficiency related loans and grants using MS Outlook Express
- Analyzed financial documentation: electric bills, financial statements, and financial ratios to illustrate the positive effect of energy savings

- Forecasted potential electricity savings
- Provided Carbon prices forecast using moving average method and analyzing energy resources price changes
- Summarized the number of lighting fixtures in YMCA building using MS Excel
- Prepared a brief summary of PA, IN, and OH government energy efficiency programs
- Prepared a brief summary of programs offered by the following electric companies: Allegheny Power, PPL, Metropolitan, Penelec, Penn Power, and PECO
- Designed a survey for identifying potential clients using MS Word
- Summarized McKinsey report “Unlocking Energy Efficiency in the U.S. Economy”
- Organized data from electric bills from St. Francis University for 14 months and created graphs for analyzing potential savings using MS Excel
- Created a chart with PA electric companies and the areas of their services using MS Excel
- Summarized Copenhagen Climate Change conference of December 2009
- Summarized Energy Efficiency Program Options for Local Governments under the American Recovery and Reinvestment Act (ARRA) of 2009
- Prepared financial databases of potential funding sources totaling $20,000,000