Teresa JB Lockwood
Albuquerque, NM 87111
***********@*******.***
Objective
Seeking employment as Report Analyst, working with users to define and
design reports, using MS-SQLServer, Integration Services, Crystal Reports,
and Reporting Services.
Strengths
. Organizational, interpersonal, and communication skills
. Able to work independently and in team situations
. Detail-oriented
. Breadth of experience
Recent Professional Experience
Software Developer/Report Specialist June 2009 - Present, Sept 2004 -
May 2008
ACS - CompIQ, A Xerox Company - Albuquerque, NM
Responsible for all reporting functions of IQReview, a web-based
Workers Compensation medical bill review system, using MS-SQLServer
2000 thru 2008, Crystal Reports XI, Excel, and ASP.Net. Create,
maintain, and optimize Stored Procedures, User Defined Functions,
Tables, and Views. Work with software lease clients to define
reporting requirements and deadlines. Create and maintain over 500
reports, letters and forms using Crystal Reports XI and Excel. Built
ASP.Net pages to handle report submission and scheduling. Update and
maintain nightly data warehouse functions. Create and run adhoc SQL
queries as requested by clients. Supervise 4 employees.
Report and Document Specialist
May 2008 - June 2009
First Community Bank - Albuquerque, NM
Worked with multiple departments to provide reporting and data
extraction functions, using MS-SQLServer 2005, Integration Services,
Access, Excel, and Crystal Reports. Created and ran ad hoc SQL
queries as requested. Responsible for formatting all loan documents
using eDocArchitect. Provided backup to external and internal website
developer, using Adobe Dreamweaver, Adobe Photoshop, and HTML.
Education
Bachelor of Science in Computer Science and Mathematics: New Mexico State
University, Las Cruces, NM GPA: 3.113/4.0
Albuquerque Technical-Vocational Institute
GPA: 4.0/4.0
. Oracle 8.0- SQL/PL/SQL
. Visual Basic 6.0
. HTML, Web Construction
. Database Management (Access)
Also proficient in MS Word, MS Excel, and MS Publisher.
Additional Experience
Programmer/Analyst - Information Systems Division, City of Albuquerque (2
years)
Headed team to develop Automated Purchasing System using ADABAS data
base and its associated 4th generation language NATURAL on an IBM 3084-
Q64. Managed multiple customers concurrently. Wrote comprehensive
user guide.
Programmer/Analyst - Ranchers Exploration- Albuquerque, NM (2.5 years)
Sole programmer/analyst for publicly traded gold and silver mining
corporation. Developed and maintained accounting applications
(Purchasing, Payroll, GL, Investor Dividends) using COBOL on a
Burroughs B1855. Supplied technical support and training to end
users.
Webmaster - Southwest Decoratives (1.5 years)
Revised existing website using HTML and Adobe Pagemill. Also
developed inventory numbering system for use with Wizard Order
Processing software.
Major Fundraiser Coordinator - NM Quilters Association (2 years)
Coordinated the Balloon Quilt Raffle. This involved overseeing a $10K
budget and the efforts of 60 other volunteers, as well as contracting
with the Albuquerque International Balloon Fiesta.
Science Fair Committee Member (4 years), including 2 years as Chairman -
Osuna Elementary School
Oversaw registration, display, judging, and awards of Science Fair
exhibits.
Troop Assistant - Girl Scouts (3 years)
Designed PVC display for cookie booths. Coordinated additional
fundraising activities. Assisted with badge activities for troop
members.
Newsletter Editor - NM Quilters Association (2 years)
Responsible for layout, design, and contracting the printing of a 20-
page bi-monthly newsletter. Oversaw a $5K budget.
Newsletter Editor - Arroyo del Oso Elementary School (5 years)
Responsible for layout, design, and typing of a bi-weekly newsletter.