David Johns

Business Analyst

Allentown, Pennsylvania, United States

About

IT Business professional with demonstrated success solving complex problems and implementing strategic initiatives that improve operating efficiencies.

Experience

  • Business Analyst II at Guardian Life
    Sep 2012 - Present · 13 yrs 11 mos

  • Contract Project Coordinator at MDLinx
    Feb 2012 - Sep 2012 · 8 mos

    • Evaluate and determine feasibility for clients online survey’s based on customer requirements and MDlinx capabilities. • Use online tools, Excel and SQL to identify matches from client user lists to MDlinx’s user panel for online surveys. • Convert user lists to conform to MDLinx data requirements and update database using sql. • Test MDlinx internal website and provide usability feedback and report coding errors.

  • Business Analyst at Grace Media Group, Inc.
    Jul 2011 - Jan 2012 · 7 mos

    • Consulted with client to develop a database schema and user interface to increase visibility of project schedule and asset placement. • Worked with client to troubleshoot and resolve computer software and hardware issues. • Developed design for information storage system.

  • Senior Quality Specialist / Data Analyst at AAI Corporation
    Jan 2008 - Jun 2011 · 3 yrs 6 mos

    • Worked with process owners and six sigma teams to develop data analysis reporting tools that monitor processes and direct process improvements. • Developed a quality improvement process with a cross functional team to identify targets and track improvement progress. • Developed a bid trending tool to analyze inspection hours and inspection bids for 200+ projects. • Maintained quality reporting system with monthly and weekly reporting on SLA / KPIs using MS Access, Excel and the Oracle Quality module. • Planned, configured and implemented a Corrective Action System for AAI using off the shelf software. • Responsible for coordinating Oracle Quality module end user testing when upgrades and patch set initiatives were planned.

  • Process Analyst/Programmer at USG
    May 2002 - Sep 2007 · 5 yrs 5 mos

    • Work with SQL server databases to create historical process trends to aid in the resolution of process control questions; follow up with users to ensure problems are resolved satisfactorily. • Develop databases and data interfaces based on business needs using Access and MS SQL Server. • Provide expertise as a technical liaison to plant manufacturing departments while working in collaboration with third-party vendors to resolve technical issues. • Create functional specifications with engineering staff to design process solutions and implement changes using PLC and SCADA packages. • Ensure consistent 24/7 operation of windows 2000 servers and clients in a demanding manufacturing environment. • Configure and maintain manufacturing networks, troubleshoot and resolve connectivity issues.