Resume for Joan M. Ware (formerly Joan M. Hellerich)

Address: *** *. ****** ** ****** Hwy, San Diego, TX 78384 Mobile Phone: 618-***-****

Email: aduykv@r.postjobfree.com

Occupation Description/Summary:

Report Writer, Software Tester, Programmer, Customer Service Rep, Database Administrator, Crystal Info Administrator Experience:

11/12 – 12/22

Self Employed Freelance Web Developer Remote/Working from home Working as an independent contractor designing web sites, using HTML5, XHTML, CSS3 and JavaScript. Other skills acquired include Python, PHP, and VBScript.

11/11 – 10/12

Bankers Life & Casualty Company Insurance Salesperson Swansea, IL Working as an independent contractor / insurance sales agent, licensed to sell Life and Health Insurance products in the state of Illinois. Position is 100% commission based. Interacted with customer to endeavor to meet their insurance needs within their budgets and with their best interests in mind.

01/07 – 10/07

CDO Technologies Programmer/Database Administrator O’ Fallon, IL Worked as an independent contractor for local software development company. Used T-SQL, Active Reports, SQL SERVER 2000, WinXP, Win Vista, ASP, Cold Fusion, Java, VB.NET etc. Programmed, tested and implemented software products for use by local government entity. Interacted with customer to ensure that their software needs had been met. 10/05 – 10/06

UNI-CARE SYSTEMS, INC. Programmer/Database Administrator Remote/Working from home One-year term, working remotely as a Database Manager and Programmer for the State Reporting Department. Used T-SQL, Crystal Reports 10, Pro-filer, SQL SERVER 2000, Enterprise Manager, Profiler Trace Tool, WinXP, VB.NET etc. Managed SQL Server Databases at my remote work location for purposes of testing, troubleshooting, and in-house development. Programmed reports and delivered to customer. Assisted customer with installation and management of reports and report processes. Assisted customer with further testing of installed applications and reports. Thoroughly tested reports written by other Programmers / Report Writers, both in-house and at customer site. Used Microsoft Source Safe for version control. 08/05 – 10/05

Express Personnel Software Tester and Script Writer Springfield, IL Short-term assignment for a well-known client in Springfield, Illinois. Performed software testing duties, using VB Scripting, Mercury Quick Test Professional, and Mercury Test Director. Performed other miscellaneous duties within the IT department. 12/03 – 08/05

Cingular Wireless Customer Service Representative Springfield, IL Perform wide range of duties, including:

• Correct billing issues.

• Provision accounts with proper access, depending on cell phone technology and rate plan.

• Route incoming calls to proper channels.

• Troubleshoot wireless equipment:

o Check for IRDB and alpha-tag updates.

o Distinguish network issues from equipment issues. o Determine which cell site is being used, and whether or not the condition of the cell site is an issue. o Research equipment and account history.

o Investigate accuracy of equipment profile, and correct or update as necessary.

• Interview and train user in proper use of equipment.

• Educate user in all aspects of price plans and features.

• Correct network issues whenever possible.

• Petition help from other departments whenever necessary.

• Update account history of any known changes, problems, and resolutions. 10/01 – 07/03

ExxonMobil Mine Examiner/Longwall Operator Carlinville, IL Worked as part of a 5-person team to keep the longwall shear, shields, panline, and computer running smoothly. Evaluated the condition of the mine, by use of observation and by use of special tools to determine safety level of work areas and compliance level with appropriate state and federal laws. Extracted coal by operating continuous mining machine and longwall shear in safe, yet productive manner. Became proficient in working well with others as a team player. 03/98 – 10/01

Magellan Behavioral Health Programmer/Database Administrator Maryland Heights, MO Performed duties of programmer as well as duties of Business Analyst, Database Administrator, Seagate Administrator, Application Tester, Technical Writer, Specification Writer, and Version Control Administrator. My main duties while working at Magellan included writing Crystal Reports drawing from a Microsoft SQL Server database. I programmed the stored procedures using T- SQL. I became proficient in using triggers, cursors, sub procedures, and linked servers. I also wrote stored procedures that automated the error-checking of the Crystal Reports by comparing the results of one report against another. I mainly used Crystal Reports with Microsoft SQL Server databases and NT4.0 operating system, but also used Actuate report writing tool and Oracle databases with Unix operating system. I also gained experience writing Crystal Reports against an Oracle database (using PL/SQL) and writing Actuate reports against a SQL Server database. I was also involved in moving the data from server to server and setting up securities. Basic duties also included moving data from mainframe to SQL Server, as well as moving from one SQL Server to another, using DTS and BCP. I also served as half of the two-person Seagate Info (Crystal Reports) Administration team. As part of that team, I helped to oversee and troubleshoot our 8.0 Crystal Reports, which were written for our Nortel Symposium Cal Center Server. I also error-checked and assisted the programmers who designed Crystal Reports against an HP9000 server, using an AS/400 application to pull it through. I also helped to oversee and troubleshoot all of the other Seagate/Crystal issues that arose for many of our other employees. Performed troubleshooting duties on some Access applications. Also developed some applications using VB6.0. Used Merant Version Control to version reports, applications and code. Became proficient in working well with others as a team player, lead project manager, trainer, and/or resource. 06/97 – 03/98

Timber & Transportation Programmer St. Peters, MO

Performed full cycle of business system duties. Met with clients to assess needs, interviewed workers, evaluated systems, programmed software, and installed software on clients’ systems. I have been involved in many phases of the analytical cycle, including interviewing clients, writing specifications, presenting bids, programming, and installing software and systems on clients’ computers. Used Access, VBA, and Visual Basic programming languages and techniques. 05/97 – 07/97

Arch Mineral Backup Manager St. Louis, MO

Performed Backup duties, rotated backup media, routed proper back-up media to off-site storage site, ran pre-programmed jobs in specified order, and contacted programmer if job abended. Worked with JCL, MVS/SDSF, Lotus Notes, Unix, MicroVax, LANS, and WANS.

Miscellaneous employment prior to 1997:

Administrative Assistant, Mine Examiner, Surveyor, Real Estate Agent Education:

Lake Fenton High School - Fenton, Michigan High School Diploma Courses included Bookkeeping, Geometry, Trigonometry, and 2 years of French. Received scholarship and honorary awards for accomplishments in bookkeeping and trigonometry C.E. School of Commerce - Omaha, Nebraska

Courses included Business Law and Accounting

Consolidation Coal Company Training Center - DuQuoin, IL Courses included Surveying, Mapping, Geometry, Trigonometry, and Calculus Wabash College – Marissa, Centralia, & Albers, IL

Courses included EMT Training, Psychology, Electricity, Mine Ventilation, and Mining Law Kaskaskia College – Centralia, IL

Computer Courses included training in Lotus, Access, and Word Rend Lake College – Ina, IL Associate Degree in Mining Technology Associate Degree in Mining Technology

Courses included Surveying, Speech, Electrical Blueprint Reading, Hydraulics, Mining Law, Human Relations, Mine Health, Safety & Rescue, First Aid, Mine Atmosphere, Advanced Welding, and Advanced Electricity. Vatterott College – Sunsett Hills and St. Ann, MO Associate Degree in Computer Programming Courses included Client/Server Applications, Systems Analysis, Networking, Visual Basic, Access, COBOL, C++, and DOS.

TechSkills – Creve Coeur, MO

Pre-certification courses for Microsoft and Oracle exams. Solutech – St. Louis, MO

Microsoft Certified Courses in SQL Server Administration ERA Heritage Real Estate School – Belleville, IL

Obtained State of Illinois Real Estate Agent License. Practiced Real Estate in the State of Illinois.

Sold almost $1 million my first year, working part-time. Won a vacation to Branson, Missouri for listing 6 properties within 1 week. Designed and maintained my own web pages, using HTML from scratch. SoloLearn-- Online Courses

SQL, CPython, Python, PHP, C++, C#, JavaScript, JQuery, etc. Special Mentions and Awards:

• Letter of Commendation for work with Telex, mainly due to my ability to translate French into English.

• Awarded Scholarship during senior year to Baker Business University.

• Special Mention Awards for success in Trigonometry and Bookkeeping.

• The second individual in the history of Clinton County to acquire real estate via purchase of another individual’s redemption rights.

• Sold almost one million in first year of selling real estate, while working as a part-time agent.

• Served, and represented the UMWA on a very prestigious political commission after being chosen to serve by the International Headquarters of the United Mine Workers of America.

• Due to diligence and disciplined study habits, passed four core MCSE exams within four months while working full time as a programmer analyst.

• Acquired Microsoft Certified Professional (MCP) certification in Windows NT4.0.

• Obtained the following State of Illinois Mining Certifications: o Shot Firer

o Electrical Hoisting Engineer

o Mine Examiner

o Mine Manager

o State Mine Inspector

o Emergency Medical Technician (EMT)

• Obtained the following Federal recognitions:

o Qualified to accept employment as Federal Coal Mine Inspector o Federal low-to-medium voltage electrical card

o Federal high voltage electrical card

Technical Skills:

HTML; HTML5; XHTML; CSS3; VBScript; JavaScript; SQL; T-SQL; PL/SQL; VBA; VB6; VB.NET; C++; COBOL; Cold Fusion; Visual J++; Java2; Access; MS Power Point; MSWord; MSExcel; ASP; SQL Server 6.5, 7.0 & 2K; Active Reports; Crystal Reports 4.5, 5, 6.0, 7.0, 8.5 & 10; Seagate Info Administration; SQL Server Administration; NT 4.0 Administration; Actuate; Front Page; Adobe Dreamweaver; Win 3.5 thru XP; Windows Vista; Microsoft Visual Studio; Project 97; MVS/JVC; Unix; Sun Solaris; Lotus; AS/400; RPG; DTS; BCP; AMISYS; Microsoft Project; Clarify; Telegence; Mercury Quick Test Professional; MS Source Safe, and Merant Version Control

Contact this candidate