SUBJECT MATTER EXPERT (INFORMATION TECHNOLOGY ASSISTANT) Qualifications SAP, HP ALM, Network Configuration, Database Management, Document Management, Troubleshooting Resolution, System Development Execution, End-user Training, End-user Training, Customer Service, Website Maintenance, Mac, AUTOCAD Relevant Experience Recognized 1 top 4 agents, promoted twice excellent customer service Experience Subject Matter Expert (Information Technology Assistant) September 2013 Current Company Name － City State Responsibilities: -SAP Data Validation Population Real Estate, Fixed Asset Plant Maintenance Modules -Assist, Support coordinate Missions create Database/ SAP IDs testing enrichment loaded data. -Validate data extracted legacy databases. -Communicate missions confirm/ clarify submitted data. -Assist extraction validation mission data -Create automated data validation spreadsheets/templates -Prepare data upload Umoja performing required calculations adjustments. -Run LSMW's, order upload Entities data SAP, Conversion process. -Validate data loaded Umoja. -Run Reports Edit Mission Data SAP. -Create manuals, guidlines, instructions cheat sheets data conversion testing processes -Develop Excel spreadsheets calculate show statistics reoccurring problems. -Prepare test scenarios HP/ALM populate input data accordingly. -Coordinate functional teams preparation scenarios, input data execution test scripts. -Organise testing sessions extended-team testers. -Execute test scenarios part Umoja team guide extended-team testers execution. -Identify raise defects, coordinate responsible teams -Re-test failed scripts defect resolution. -Creation Training Materials Data Validation Testing SAP -SAP Test script authoring, execution defect resolution Product Integration Testing User Verification Testing -Supported Tier 3 Production Support Activities Accomplishments: -Created template assisted creation reports help automate formatting data, easier LSMW uploads, reduced time needed preparation data 1 hour eliminated transfer errors -Created automated Data Validation Spreadsheet, decrease validation time 40% improve quality validation enabling focus substantive, rather mechanical errors. Successfully Completed data conversion load activities Peacekeeping Missions Umoja Foundation Cluster 1 Cluster 2 deployment (approximately 30 entities). Each cycle consisted 3 Mock Data Conversion/Loads, Dress Rehearsal Production Load. Successfully accomplished (until now) Umoja Cluster 3 Data Conversion Load Cycles (Mocks 1-3 Dress Rehearsal) UNON, UNEP, ESCAP, UN-Habitat, OCHA-Geneva, Fixed Assets Equipment Real Estate Items. Continuing involvement Cluster 3 data conversion production Successfully supported completed Product Integration Testing (PIT) User Verification Testing (UVT) cycles Umoja Cluster 3 Information Technology Assistant (OSAU) October 2010 August 2013 Company Name － City State Responsibilities: -Conduct walk-throughs UN floors verify Locations, Staff Space configurations. -Assist Project Managers evaluate Vacancies, Overcapacities Room Type changes. -Interact Staff environment inquire changes floor answer questions. -Contact Staff Department Focal Points confirm discrepancies. -Record report discrepancies Staff Information make necessary changes UN Staff Telephone Directory (Untel) Voice/Data Messaging Service (VMS) Databases. -Record report discrepancies Floor plans make necessary changes Aperture -Clean, monitor maintain Aperture data assure accurate Floor plans. -Assist Property Management Inventory Control Unit Occasional Inventories Property Verifications. -Create reports SQL Microsoft Access Project Managers aide space planning. -Assist AFPS cleaning restructuring UN Staff Telephone Directory Database (Untel) processes. -Clean, monitor maintain UN Staff Telephone Directory Database (Untel) Voice/Data Messaging Service (VMS) Database assure accurate Staff location information. -Create new staff entries UN Staff Telephone Directory Database (Untel) Voice/Data Messaging Service (VMS). -Create run queries SQL Microsoft Access edit databases. -Upload update Untel Aperture databases. -Develop Excel spreadsheets calculate show statistics reoccurring problems. -Develop SOP's position help training efforts. -Develop, Create Maintain Document Management database online library using visual studios, department website (vb script ASP.net). -Beta Tester CAFM. -Assist contractor development CAFM space asset management system. -Occasionally assist computer hardware software installation troubleshooting. -Beta Tester Umoja Pilot project. -PIT Tester Umoja using HP ALM SAP. -Data collector Umoja Pilot Project using templates. Accomplishments: -Granted Administrative rights Untel VMS SQL Databases Aperture Floor plans due expertise responsibilities. -Improved efficiency Inventory process creating accurate location nomenclature Untel, VMS Aperture databases. -Increased accuracy level Staff Information Floor plans improving space planning occupancy reports. Performed Database/Website management tasks month vacant Supervisor post P3 level filled. -Managed, corrected improved data, queries processes resulting reducing SQL Database issues/ errors 50%. -Worked liaised software company contractors assist colleages fixing errors improve fuctionality CAFM system. Information Technology Assistant (PMICU) January 2008 October 2011 Company Name － City State Responsibilities: -Organize PMICU Stockrooms. -Perform physical inventory counts PMICU Stockrooms. -Process Work Orders using MP-2 iNeed (Work order software) -Print Barcodes Departments/Offices UNHQ. -Issue andReceive Furniture PMICU Stockrooms. -Help Staff members find Furniture better suites needs. -Coordinate/Arrange furniture relocation offsite locations. -Supervise 1 10 movers liquidation assets Secretariat Conference building vacate exercise. -Assist Furniture Disposals update Procure Plus records accordingly. -Coordinate IT Disposals OICT movers update Procure Plus records accordingly. -Administer IT disposal service contract. -Property Records Custodian (for FMS) -Manage Furniture using Procure Plus Build, Relocate, Transfer Remove records. -Upload Movers scanners Procure Plus database. -Develop SOPs position PMICU. -Obtain quotes submit requisitions -Enter delivered furniture Procure Plus. -Recommend purchases maintain stockroom counts. Accomplishments: -Granted Administrative rights Procure Plus SQL Database, due expertise responsibilities. -Assigned Property Records Custodian FMS. -Developed Standard Operating Procedures unit, including "Furniture Disposal Process" "Furniture Issuance Procedure", "Processing PO Orders Procedure", etc. -Developed classification system furniture used Unit Operations, warehouse physical inventories based UNCCS item codes. -Organized multiple new offsite stockrooms (45,000 sq ft). -Performed periodic stockroom counts 5,000 assets. -Organized relocation approximately 10,000 assets various stockrooms vacate excercise Secretariat building. -Handle deliveries furniture averaging $200,000. -Performed Location Verification exercise entire UNHQ Campus 2008 Physical Inventory. -Over 10,000 items identified, scanned updated Procure Plus thereby affecting $2.4M official UNHQ inventory. -Assisted removal furniture abandoned property liquidation Secretariat Conference buildings(apprx. 630,000sqft). -Relocated, Consolidated Organized Wood furniture appropriated stockrooms cut physical inventory count 50% Information Technology Assistant (BCSS) September 2007 December 2007 Company Name － City State Responsibilities: -Managed variety expendable non-expendable audio-visual supplies. -Arranged contents stockroom receiving areas manner maintains safe efficient working environment. -Participated periodic physical inventories UN equipment ensure accuracy serial barcode numbers. -Surveyed broken audio-visual equipment disposal. -Performed asset management Procure Plus -Cleaned data fields Procure Plus -Enter data incoming outgoing expendable non-expendable stock items. Accomplishments: -Granted Administrative rights Procure Plus, due expertise responsibilities. -Surveyed Assessed broken audio-visual equipment disposal. -Reduced disposal survey times, 30%, simplifying streamlining process/procedures. -Assisted editing IT equipment information Procure Plus. Technical Support Representative July 2005 September 2007 Company Name － City State Responsibilities: -Managed Inventory assigned IT products assigned work car. -Assisted yearly storewide physical inventory -Performed Customer Service. -Performed Client/Technician Phone Support. -Configured Secured Wireless Networks. -Diagnosed computer Hardware Software issues -Troubleshoooting Resolving computer problems including: Hardware, Software, virus, network, video, etc. -Evaluated needs clients sold necessary computer software solutions. Accomplishments: -Recognized 1 top 4 agents, promoted twice excellent customer service. -Increased customer loyalty 25% -Assisted customer conflict resolution help reduce customer product/service returns. -Worked efficiently effectively cut appointment wait time weeks 3-5 days. QA compliance September 2002 July 2005 Company Name － City State Responsibilities: Tracked managed resources, using Great Plains MS Excel. Assisted yearly warehouse inventory. Organized warehouse stockroom. Ordered supplies vendors. Processed outgoing order shipments. Processed Customer Credit Card Payments. Processed orders phone. Performed Quality Control. Ensured orders went correctly time Facilitated employee training. Accomplishments: Promoted within 3 months starting. Put charge 3 persons Improved work order processing system Improved speed efficiency work order processing 40%, simplifying process, efficient work coordination Created shipping supplies order sheet, ensuring accurate faster tracking supplies Increased profits increasing productivity improvements, commitment motivation Education Certification Network Security 2005 The Chubb Institute － City State US Certification Network Security The Chubb Institute Westbury, NY 2003 2005 Bachelor Science Computer Science Business Oneonta State University － City State US Bachelor Science Computer Science Business Oneonta State University Oneonta, NY Affiliations Foundation Cluster 1 Cluster 2 deployment (approximately 30 entities). Each cycle consisted 3 Mock Certifications Certification Network Security Skills Inventory, Database, Excel, Training, Stockroom, Sql, Databases, Sap, Statistics, Operations, Sops, Asset Management, Access, Asp, Asp.net, Cafm, Document Management, Inventory Control, Microsoft Access, Ms Access, Ms Asp, P3, Property Management, Restructuring, Space Planning, Telephone, Vms, Voice, Credit, Credit Card, Great Plains, Ms Excel, Order Processing, Packing, Payments, Qa, Quality Control, Shipping, Warehouse Inventory, Clients, Customer Service, Receptionist, Retail Sales, Solutions, Technical Support, Wireless, Wireless Networks, Network Security, Security, Adjustments, Clarify, Data Conversion, Data Validation, Deployment, Fixed Asset, Fixed Assets, Ids, Integration, Integration Testing, Integrator, Maintenance, Plant Maintenance, Real Estate, Subject Matter Expert, Testing, Autocad, Database Management, Mac, System Development