Justin Beckham
Data Manipulation Specialist at American Direct Mail- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
American Direct Mail & Marketing
-
Advertising Services
-
1 - 100 Employee
-
Data Manipulation Specialist
-
Jan 2015 - Present
Burbank, CA • Manipulate, clean, and scrub data in various formats provided by mailing customers for upload into USPS mailing system using MS Excel, MS Word, text, PDF, and AccuZip databases • Mail Merge and align variable data using MS Word to print on blank or pre-printed letterhead/labels • New PC setup and configuration of all 3rd Party software and User support for software
-
-
-
Ocwen Financial Corporation - US
-
United States
-
Financial Services
-
700 & Above Employee
-
Business Data Analyst – Mortgage Insurance Claims
-
Jan 2013 - Mar 2014
Coppell, TX • Developed and maintained MS Access database with click button Dashboard for daily, weekly, monthly, and quarterly management reports • ODBC setup to various sources including Oracle 10g, 11i, and MS SQL Server for use with MS Access to collect, compile, and analyze data for adhoc reporting. Very basic SQL knowledge with limited Oracle SQL Developer and TOAD exposure • Lead analyst for mapping codes and translation of dataset at cell level from LPS to RealServe and from FiServe to… Show more • Developed and maintained MS Access database with click button Dashboard for daily, weekly, monthly, and quarterly management reports • ODBC setup to various sources including Oracle 10g, 11i, and MS SQL Server for use with MS Access to collect, compile, and analyze data for adhoc reporting. Very basic SQL knowledge with limited Oracle SQL Developer and TOAD exposure • Lead analyst for mapping codes and translation of dataset at cell level from LPS to RealServe and from FiServe to RealServe software platforms • Functioned as an Individual Contributor to the team, but with daily team interaction • Daily communication with offshore teams via teleconferences, GoToMeeting, individual calls and emails • Department go-to person for questions and issues related to platform changes and OS upgrades, Citrix profile migration, and network migration • Collaborated with 3rd party software development team for UAT beta testing software deployments • Documented new and streamlined processes using Standard Operating Procedure (SOP) guidelines, training associates as required Show less
-
-
-
-
Data Compliance Analyst/Lease and Move-In Verification Specialist
-
Feb 2011 - Dec 2012
April 2014 - January 2015 Dallas/Fort Worth Area • Analyzed and scrubbed existing data set for consistency and completeness before and after software upgrade using MS Access and Excel to find any anomalies, correcting and reporting as necessary • Small Business IT support including PC/Laptop setup and configuration of OS and 3rd party software, and network setup with basic security evaluation and implementation • Verified property was ready for move-in and all associated paperwork was correct and complete
-
-
-
Motorola Mobility (a Lenovo Company)
-
United States
-
Computers and Electronics Manufacturing
-
700 & Above Employee
-
Inventory Analyst/Auction Sales Manager/BOM Specialist – Reverse Logistics
-
Aug 2003 - Oct 2010
Dallas/Fort Worth Area • Moved iDEN/Nextel RMA returns process from FL distribution center to TX distribution center setting up all external and internal RMA processes including inventory locations, Accounting-Product Codes (APC), and audit processes • Daily Inventory control experience responsible for inventory disposition and material moves using Oracle, TCOPs and Yantra, managing up to four employees for help with weekly cycle counting and Acceptable Quality Level (AQL) sampling of DC bound… Show more • Moved iDEN/Nextel RMA returns process from FL distribution center to TX distribution center setting up all external and internal RMA processes including inventory locations, Accounting-Product Codes (APC), and audit processes • Daily Inventory control experience responsible for inventory disposition and material moves using Oracle, TCOPs and Yantra, managing up to four employees for help with weekly cycle counting and Acceptable Quality Level (AQL) sampling of DC bound material • Created and maintained global part numbers and BOMs for finished goods and sub-assemblies using PDM/PLM system and Oracle • Determined EOL dates for DC products and performed lifecycle changes using PDM/PLM system • Led discovery group that determined BOM accessories and Value Added Services (VAS) that could be added to refurbished and EOL phone kits and auction items to boost sales • Placed demand for recurring inventory depletion using Oracle Demand Planner • Participated in multiple stages of New Product Introduction (NPI) supporting engineers and technicians with all aspects of documentation and training • Point of contact for all communications with 3rd party ecommerce marketplace and auction customers relating to sales, service, questions, and issue resolution of auction material • Proven customer issue resolution record by tracking, identifying, and fixing recurring problems • Developed a deep understand of using MS Office products to analyze and automate daily tasks and to manipulate data and create reports for visual presentation to management Show less
-
-
Education
-
Weatherford College
Associate of Science (A.S.), Pre-Engineering/Computer Science -
Motorola University
Six Sigma Yellow Badge