Programmer Analyst, Data Analyst, Software Quality Assurance
Resume:
Lara K. Dionne
Hallowell, Maine *4347
Mobile: 207-***-****
email: acs0st@r.postjobfree.com
SENIOR IT PROFESSIONAL
** ***** ** ********** ** All Aspects of Software Development and Data Analysis
Having been in the IT field for so many years, I have worked in many roles from technical support and quality assurance to data analysis/database administration and application development. This gives me a well-rounded perspective that enables me to work effectively with all members of a technical team. I am self-taught in all my technical skills and able to work and learn independently.
TECHNICAL SUMMARY
Operating Systems: Windows 9x-7, Windows NT/2000, Windows XP, UNIX, Windows Vista
Database Management Systems: Microsoft Access, SQL Server, Oracle, SQLBase, Informix
Development Languages: Visual Basic/VBA, SQL, PL/SQL, Awk, COBOL, Centura, Tandem scripts
Development Tools: Rational Robot, Mercury Interactive TestSuite, Bendata Heat, Segue SilkRadar, PVCS, Tortoise SVN
Applications: Microsoft Access, Microsoft Excel, Microsoft Outlook, Microsoft Project, WinSCP, Putty (ftp), Tandem Relate, UltraEdit, Toad for Oracle, ControlM Enterprise Manager, Oracle Reports
EXPERIENCE
January 2015 – June 2015 State of Maine, Office of Information Technology.Augusta, ME
Programmer Analyst
Large scale data conversion of the Department of Health and Human Services’ (DHHS) client data. Quality assurance testing of same.
Data analysis for in-house stakeholders using Toad (SQL) against an Oracle database platform. Presenting said analysis in Excel in a business-user friendly manner.
Coding of PL/SQL programs to convert incoming client health and claims data for DHHS.
June 2014 – July 2014 Manpower Inc. Portland, ME
Data Analyst at IDEXX Laboratories
Hardware boot testing for proprietary IDEXX machines in support of the software release cycle with resultant data analysis in Excel.
Data analysis for in-house stakeholders in support of software and hardware release testing using Squirrel (SQL) against an Oracle database platform. Presenting said analysis in Excel in a business-user friendly manner.
Data analysis to support field calibration of IDEXX instruments.
Vocalist in the IDEXX corporate band.
April 2011–April 2014 WEX Inc. South Portland, ME
Programmer Analyst II
Independently took on the role of Network Operations documentation expert, a job that many assumed to be impossible as the role being documented was varied. This resulted in a reduced error rate and a reduction in time to get new hires up to speed.
On call production support for sales and site load files.
Creation of batch file processes for sales and site load files in production.
Certification to WEX ISO standards for new point of sale vendors and host networks. This involved creating test plans, coding the certification, supporting the testing effort, and unit testing the settlement files created during authorization testing.
Second tier technical support for customer service and merchant representatives. This involved complex SQL queries to analyze data and determine the cause of reporting, authorization or posting errors for credit card transactions.
Individual research in Toad for Oracle using SQL to determine the scope of data issues affecting our production clients.
Communication of production issues to a broad internal base of stakeholders so they could inform their client bases. Continuing to track the resolution of these issues and provide timely updates.
Working with external stakeholders, such as point of sale vendors and host networks, to resolve production issues.
2002–2004 Stone Ibis Consulting Hallowell, ME
Software Engineer
Developed software for Maine Children’s Alliance using Microsoft Access to document client interactions with the Children’s Ombudsman Program for the State of Maine.
Gathered end user requirements for said system as business analyst.
September 2002-February 2004 Allenbrook, Inc. Portland, ME
Software Engineer
Interacted with in-house customer support personnel and directly with clients to evaluate customer requests for software changes and data corrections.
Developed product enhancements in Centura and Visual Basic.
Determined prioritization of defects as team leader.
February 2000–February 2001 DeLorme Yarmouth, ME
Test Automation Coordinator
Evaluated potential test automation vendors and their products against DeLorme’s technical requirements.
Coordinated the implementation of Mercury Interactive’s TestDirector and WinRunner in DeLorme’s technical environment.
Developed modular automated test suite for application testing.
Created function library to reduce duplicate code and increase speed and efficiency in updating automated tests.
EDUCATION
Bowdoin College Brunswick, ME
B.A. in Psychology and French. Minor in Russian. Summa cum laude.
REFERENCES
Available upon request.
Contact this candidate