Landy Johnson Email & Phone Number

Boston, US

Coppell, Texas, US

Irvine, CA, US

Applications developer using C#/VB.NET/SQL Server. Assignments include bug fixes, feature enhancements, learning systems, stabilize current environment.

• Multiple short-term tasks (from 1-2 days to 3-4 months) performed between other job positions/assignments, weekends. This covers the majority of the employment gaps below;
• In order to provide sales data to the Coca-Cola Business Services (CBS) unit and to facilitate Bottler incentive payments, we created an application to extract Customer, Product and Sales data from the Bottlers'.
• Bottler Support is handled mainly via remote access to the Bottler's computer via EchoVNC & TeamViewer and some on-site Bottler visits;
• Worked with Coca-Cola Corporate personnel in a support capacity to rectify issues that arose;
• Re-skin a classic ASP website utilizing HMTL5 and CSS3 concepts. Modify certain pages in the website to add functionality;
• Modified a legacy VB6 program to handle a change to a printer engine at a specific client while maintaining functionality for all users.

NL

Create an application to perform pre-update system checks not available in the software update installation package. This application checks Is App installed? Is an Update required? Is a delay requested? prior to calling the software update package. Compact & scalable. This application will run on 1,000+ user PCs. The projects also included a database.

Herzlia Pituach, Israel, IL

Help the company eliminate a project backlog of converting certain error-prone and/or time-consuming applications/processes written in Access into SSIS packages, using SQL Server2005/2012 & BDIS2012.

Atlanta, GA, US

• Member of massive (3 version) HME software (Computers Unlimited/TIMS) upgrade team – identify custom code in applications touching all aspects of the business units, using VB.NET, VB6, SQL Server and Access..
• To help the company track the efficiency of third-party, order-taking vendors, I created a tool using SQL Server SSIS package to extract new user information from Active Directory;
• To assist in identifying and correcting billing error, I created a system to modify/translate coded values in billing the billing system, with the added ability to dynamically modify the translated codes;
• Successfully managed the transition of my projects to the full-time staff that would be maintaining my projects upon completion of the contract.

Menlo Park, CA, US

• Streamlined and standardized, completely re-engineered the company's Provider Dispatch Notification process for emergency roadside assistance using XML/XSLT to create a PDF notification that is then programmatically.
• As a backup, I included an automatic fail-over method of distributing the requests via a file-system implementation of FaxPress;
• To allow the company to be proactive, instead of their existing reactive process, I provided a real-time, browser-based monitor application that allows the Operations Managers to identify transmission issues/errors.
• Allowing the company to increase their potential revenue streams, I created a WCF services that allows third-party booking of roadside assistance requests and that also provides the associated responses to the.
• Successfully managed the transition of my projects to the full-time staff that would be maintaining my projects upon completion of the contract.

Sunrise, FL, US

• In order to track and activate insurance coverage, I coded and implemented a Member Card registration website process.
• Assisted in reducing the backlog of Help tickets with minimal direction and instruction using VB.NET and SQL Server;
• To help standardize coding throughout the department, I created a class to perform differing mask edits on dynamic input fields;
• Successfully managed the transition of my projects to the full-time staff that would be maintaining my projects upon completion of the contract.

• Oversaw day-to-day duties of Contract and Full-time Employees, ensure milestones met, provide guidance and support;
• Worked with Claims Managers and Sr. Executives to create and maintain Claims processing systems for Mass Tort Liability settlements (Bodily Injury and Property Damage) in the Asbestos & Silica industries. Using.
• Redesigned the letter creation process that reduced the processing time from 6-hours to 20 minutes and created a distribution application that emailed, printed or created an Excel spreadsheet with Claim status;
• Reduced claims payment processing effort by creating an interface to upload check requests into Microsoft's Great Plains accounting system and download the associated check status to the Claims system;
• Saved the company approximately $40,000 importing our folder/file Claims documents system into the Laser Fiche document management repository. I created applications to import the documents using LFSO, created images.
• I helped reduce 2 FTE positions to 4 hours, once a month by using outside contacts to facilitate document destruction;

I am the father/manager of an aspiring actress

• Designed and coded a tool to create and easily implement a FAQ form into any application. This tool places the entry and maintenance of the Questions and Answers under the Business Units' control. I designed, coded and.
• Designed and coded a tool to create a Computer Based Training (CBT) course that allows the Business Units' to create and/or modify a CBT that meets their requirements without requiring the intervention of IT, the.
• Programmed major and minor modification to existing VB6 & SQL Server 2000 (T-SQL, Triggers, DTS) applications;
• Created numerous reports using Crystal Reports 8.0 and SQL Server 2000 (T-SQL);
• Assisted in restructuring of Visual SourceSafe database;
• Write Statements of Understanding (SOUs) and Detail Design Specs for User Request Items.

US

• In preparation for a massive, multi-year development project, we created a data-dictionary of all master databases, including cross-reference to all replicated data items, along with desktop and on-line applications.
• To address issues the client was having with server performance, I created a service application (VB6 & Win32 API) to perform unattended disk maintenance on the server (shut down SQL services, run disk checking.
• Provide support to Architects/DBAs as needed.

• Project Leader - Warehouse Applications, including Returns & Shipping. Shortly after taking over the Warehouse applications, I found and corrected an error in the shipping software that resulted in a recurring net.
• Visual Source Safe administrator: rebuilt VSS database, trained all users on proper use of VSS, implemented and enforced policies and procedures, and modified VSS application to provide useful reports;
• I saved a massive (20% of annual revenue) contract from being canceled by finding and fixing in approximately 6 hours a bug (introduced by the Vendor) that after 2 weeks, even the application's developer was unable to.
• To assist Network Support to be proactive on server issues, I created a service that monitored server communication and notified Support personnel when a server was unresponsive;
• I helped streamline many warehouse processes by working with Warehouse technical support as Level 2 Support (including project lead/programming responsibilities) of Kitting (phone component packaging), CPST (phone.
• Reduced Sales Department efforts for Echostar Incentive Disbursement by automating their manual process (UML/Visual Modeler, VB6 with SQL Server 2000/T-SQL);

Fort Worth, Texas, US

• Development of Single Item Scan project, a finished goods tracking system, utilizing OOA/OOD/OOP techniques in VB6 with a MSAccess database: full project cycle -- design, code, convert data, implement, and.
• Performed multi-platform Plant Support duties; Implemented many cost saving and process streamlining improvements;
• Created Windows-based interface between Optiplan (a Dos-based manufacturing work order system) and JBA manufacturing/accounting systems on AS400 (VB5 accessing FoxPro table files with upload to AS400, including.
• To reduce overall costs and printing efforts, I developed a UPC barcoding scheme that reduced 39 separate barcode labels to 6 standard barcode formats, that also increased the information available on each label. These.
• I was the liaison with our label printing software (AveryDennison) vendor technical support;
• Facilitated communication between numerous departments and the manufacturing facilities to ensure all departments worked together smoothly and that changes made in the systems of one didn't adversely impact the others;

Atlanta, GA, US

• Combined separate Sales and Accounting functions of the Consignment Inventory (VMI) System with a Client/Server application, utilizing VB3 and SQL Server 4.8 & 6.5 (including writing stored procedures): full project.
• Reduced Sales department efforts by singularly designing, coding, implementing and supporting a VB/VBA/Jet (VB3/Access2.0) Consignment system before C/S team project, reducing 2-3 days of work per week to a few hours;
• Designed and coded front-end for ASN/EDI project;
• Supported (with one other individual) entire Structural Panels and Softwood Lumber divisions Mill Office System on S/36 in RPGII (approximately 53 facilities);
• Original Level 2 MSOffice support individual for entire Building Products division. Helped setup remainder of team, major input in creating policies and procedures for Support Team. Mentor to Support Interns;
• Identify, fix, then solve major and minor support issues.

Norcross, GA, US

• Program design and coding for divisional manufacturing software on S/36 using ASNA’s RPGIII package.
• Singularly designed and coded application support files menu;
• Responsible for Wallace Labeling/Bar Coding labels design and coding for Mill and Partition Divisions;
• Responsible for the maintenance design, coding, and support of entire legacy Mill Division office system

Bachelor'S Degree, Computer Information Systems

Bachelor Of Business Administration (B.B.A.), Business Administration And Management, General

Associate Of Science (A.S.), Data Processing