Application Developer II
Resume:
Lionel J. Carter
DeSoto, Texas 75115
**************@*****.***
Professional EXPERIENCE:
Atterro, Inc. (ProStaff), Irving, TX February 2013 - April 2015
Systems Engineer - Nautilus Hyosung America (Contractor)
. Created Inventory Management System in Access 2010 and VBA.
. Performed maintenance and enhancements to the Inventory Management System
database.
. Migrated data from Access to Oracle database, and created PL/SQL
procedures and Java 2E scripts for web interface.
. Created VBA applications using Excel 2010 to deal with data ETL to a
standard format for data processing and report creation.
. Created stored procedures, test scripts, and functions in PL/SQL.
Monitronics International, Farmers Branch, TX February 2012 - December
2012
Senior Access Developer - (Contractor)
. Performed maintenance and enhancements to an Access 97 database.
. Worked in an Agile-Scrum environment to migrate from the Access 97
database to a Java 2E web-based application.
. Used SQL Server 2008 R2 as the back end database for the new web-based
application.
. Created VBA code to help create automated reporting and distribution.
. Managed data tables from an SQL server through SQL programming and Access
97.
WorldLink, Inc., Frisco, TX November 2011 - January 2012
Senior Access Developer - Samsung Telecommunications (Contractor)
. Created automated shipping forecasting tool via Access 2007, Excel 2007,
and VBA.
. Performed maintenance and enhancements to the National Retail database.
. Processed EDI transactions from various platforms, file formats, and
vendors.
. Created VBA applications using Excel 2007 to deal with data ETL to a
standard format for data processing and report creation.
. Managed data tables from an SQL server through SQL programming and Access
2007.
Safety-Kleen Systems, Inc., Dallas, TX December 2009 - November 2011
Oil Pricing Analyst
. Provided user training and technical documentation after creating new
databases.
. Developed, maintained, and enhanced MS Access databases to create
automated reporting and analysis for fleet department and senior
management.
. Used VB and VBA within all databases to automate reporting and data
processing.
. Created GUI's to assist the user with data input and reporting.
. Created reporting using SQL Server 2008 R2, MS Access 2010, and complex
automated Excel 2010 formulas, and VBA.
Lionel J. Carter Page 2
Affiliated Computer Services, Dallas, TX April 2005 - September 2009
IBM OIO/New Business Asset Manager
. Managed mainframe software for over 70 mainframe customers.
. Developed relational databases to assist in pricing, new business models,
and sysplex configurations using VB, SQL, and MS Access 2003.
. Generated executive reports using SQL, MS Access and MS Excel 2003 on a
weekly basis.
. Provides automated pricing quote reporting upon request.
Innovative Systems Group, Dallas, TX May 2004 - September 2004
Project Leader / Database Administrator - Blue Cross (Contractor)
. Provided user training and technical documentation after creating new
databases.
. Assisted Program Manager with procedures and project planning.
. Developed, maintained, and enhanced MS Access databases to create
automated reporting and analysis using VB and VBA within the database.
. Created GUI to assist the user with data input and reporting using SQL
Server.
The InSource Group, Dallas, TX March 2003 - December 2003
Database Developer - TXU / Oncor (Contractor)
. Created and enhanced MS Access databases to create automated reporting
and analysis.
. Used VB and VBA as languages to drive the database instead using macros.
. Built user-friendly GUI for data input and analysis.
. Used SQL to provide complex reporting for senior management and
executives.
Ashland Chemicals, Dallas, TX January 2002 - March 2003
Access Developer / DBA (Contractor)
. Duties involved creating, maintaining, and updating Access databases to
handle entire company product structure.
. Also handled database security and created groups and user accounts.
. Responsible for creating production reports for the production department
using SQL queries and macros.
. Experience creating tables using SQL/VBA mixture.
Inet Technologies, Richardson, TX July 1999 - October 2001
Technical Support Engineer / Technical Writer
. Assisted customers with telecommunications diagnostic and network
surveillance equipment.
. Assisted customers with SS7, ANSI, J7, ITU, and various protocols.
. Built scripts in c-shell and korn shell according to specifications.
. Created database to manage customer contacts for 3000 + customer sites
using Access 2000.
. Created documentation for training and technical support purposes using
Word and Visio.
. Performed system integration for the GEOPROBE product.
EDUCATION:
DeVry Institute of Technology, Irving, TX June 1999
Bachelors of Science / Electronic Engineering Technology
Contact this candidate