Mary A. Trankel, Ph.D.
406-***-**** (cell)
www.webtransformations.com
Country of Citizenship: United States
Education
The University of Montana, Missoula, Montana
Ph.D. in Sociology, June 1991. Graduate GPA 3.83. Areas of concentration
during graduate work:
. Criminology/Criminal Justice
. Applied Research Methods/Program Evaluations
. Social Psychology
. Complex Organizations
M.A. in Sociology, concentration in Criminal Justice, Dec 1987.
Carroll College, Helena, Montana
B.A. in Sociology, with minor in Criminal Justice, June 1980. Magna cum
laude, GPA 3.79.
Additional Training & Certifications
. September 4, 2009: ForceTen Developer Certification for Learning
Content Management System (LCMS) software by OutStart (formerly EEDO)
. September, 2009: Approved under State of Montana Master Contract for
IT Services (DOA06-1263B), RFP 09-1700P, for service categories:
o Distributed Applications
o Internet, Intranet, eGovernment
o Staff Augmentation
. March, 2004: Human Resource Specialist training through the USDA
Forest Service (conflict resolution, fact finding, report writing,
management advising).
. Spring Semester, 2004: Web Programming, University of Montana,
Missoula, MT.
. Spring Semester, 2003: Fundamentals of Computer Science II,
University of Montana, Missoula, MT.
. Fall, 2005: User Interface Design, University of Montana, Missoula,
MT.
. Autumn Semester, 2002: Fundamentals of Computer Science I, University
of Montana, Missoula, MT.
. January, 2002: Introduction to Oracle: SQL & PL.SQL, University of
Montana, Missoula, MT.
. December, 2001: Crystal Reports 8.0 Advanced-Level 1 & Level 2, New
Horizons of Missoula, Montana.
. August, 2000: Advanced Access 97, New Horizons of Missoula, Montana.
Skill Set/Competencies
Strengths include analytical skills and the ability to understand and write
about complex concepts very quickly-summarizing technical information in
non-technical terms without changing its essential meaning. I learn new
computer skills and software programs very quickly, and constantly strive
to challenge my own learning potential in technical arenas. Through
graduate training and consulting work I have used multiple software
programs to create technical reports, charts, graphs and presentations. I
am a detail-oriented person who takes pride in producing technically
accurate, stunning reports and graphical products.
I have hired and supervised 41 employees, and provided individual,
classroom and telephone-based training, technical assistance and customer
service on computer and research topics to employees and clients. The wide
variety of consulting activities I have completed during the past twenty
years attests to my flexibility and the speed with which I can acquire new
skills and knowledge.
As a result of my background in criminology and three previous jobs in the
criminal justice system, I have successfully passed criminal background
checks and personality profile tests. I also have a strong interest in
computer security issues.
Software
. Microsoft Access, MySQL, Oracle, Paradox, and Visual FoxPro databases
. MS Word, Excel, PowerPoint, and Publisher
. Macromedia Dreamweaver and HomeSite for web development
. Adobe PhotoShop, Acrobat Professional, LiveCycle Designer,
Illustrator, InDesign, Flash, and Captivate
. SPSS (Statistical Package for the Social Sciences)
. Crystal Reports
. WordPerfect and QuattroPro
. Video editing and production software, including Final Cut Pro,
Camtasia Studio, Pinnacle Studio, and GoldWave
Consulting Experience
June 1986 to Present
Self-employed Researcher and Business Consultant, d/b/a Trankel Research &
Analysis, LLC, and Web Development/Graphics Layout & Design, d/b/a Web
Transformations, LLC.
. technical writing on information technology subject matter;
instructional manuals and procedural documents
. software systems analysis, systems charts and diagrams, functional
specifications
. statistical data analysis, report writing, proposal writing, and
editing
. competitive market analysis
. needs assessments, feasibility studies, and program evaluations
. graphics and Flash animations
. audio narration and editing, video editing and production
. web site development; human interface usability design
. development of graphics for Web sites and print publications
. development of relational database programs and database-driven web
sites
Client List
. Health Habits Fitness-video training CD demonstrating kickboxing
basics such as equipment, wrapping procedures, kicks and punches
. DanceMaster-software user manuals developed in video format using
Adobe Captivate
. Powerful Purchase-development of web sites and Flash
slideshows/animation videos for NOKKEM and WickedLix Fruit Shooterz
products
. Nona Burroughs Babcock, Writer-Flash marketing video developed as a
book trailer
. Path-Wise Corporation-systems analysis for software development,
detailed interface mockups in PhotoShop, writing technical
specifications and explanations of features to guide software
developers, system flowcharts, user manuals and marketing documents
for potential investors
. State of Montana, Fish,Wildlife & Parks-web site and graphics
development, technical support and written explanations of procedures
for Fish & Wildlife project managers
. Health Habits Fitness-DVD video of NGA Bodybuilding & Figure Fitness
Competition
. Velocity Fitness-grants and loan financing research; development of
graphic designs
. Health Habits Fitness and Massage, Missoula, Montana-web development,
content management system for the web site, graphics development, and
creation of flyers.
. Triple-I of Colorado, Inc.-full-time/8 month technical and legal
research and technical report-writing on topics such as accreditation
best practices, analysis of software products and competitors,
broadband penetration, student trends in traditional vs. online
learning, technical standards such as AICC, SCORM, IEEE, ADL, and open
source standards
. Decorative Industrial Plating-implementation of a financial accounting
system and business data collection instruments, market research
survey, database development, and web site development, instruction
manuals and procedural documents.
. Skyline Recording Studios, Missoula, Montana-technical
writing/editing, development of business forms and informational
materials, web site.
. Clayton Floyd Insurance Agency-database development, market research,
report writing, development of graphics, forms and flyers.
. Montana Department of Public Health & Human Services, Child & Family
Services Division-five-year statewide evaluation of child abuse
prevention programs.
. Missoula Demonstration Project, Quality of Life's End: development
and administration of survey research forms, technical research
administration protocols, statistical analysis and report writing.
. Blackfeet Tribe of the Blackfeet Nation-survey research, database
application development, and written statistical data analysis report.
. Assiniboine and Sioux Tribes of the Fort Peck Reservation-survey
research, database application development, and written statistical
data analysis report
. Department of Social Work, The University of Montana-survey research
and statistical data analysis, report writing, joint journal
publications with several professors.
. Montana Association of Area Agencies on Aging-research and data
analysis.
. Rural Institute on Disabilities. The University of Montana-research
and data analysis.
. USDA Forest Services, Region I, Administrative Services Division-
region-wide (3 states) analysis of Administration service, including
qualitative and quantitative statistical analysis; group training to
implement research findings.
. Pine Hills Youth Correction Facility-multiple regression and factor
analysis for an evaluation of the juvenile sex offender treatment
program.
. Missoula City-County Health Department-survey research and data
analysis.
. Options Unlimited, sponsored by Women's Opportunity Resource
Development: survey research and data analysis; multiple program
evaluations.
. Women's Economic Development Group (WEDGO)-statistical data analysis
and reports.
. Missoula Community Business Incubator (MCBI)-statistical data analysis
and reports.
. Blaine County Jail, Chinook, Montana-comprehensive evaluation to
determine the feasibility of a secure detention facility in Blaine
County.
. Missoula City-County Public Library-user survey to improve Library
services.
. Elderphone Project of the Department of Aging Services-survey research
and report.
. Missoula Housing Authority-survey research to determine low-income
housing needs in Missoula, Montana; statistical data analysis and
summary report.
Recent Temporary Employment
State of Montana-Department of Fish, Wildlife & Parks
Information Technology Bureau
1420 E 6th Avenue
PO Box 200701
Helena, MT 59620-0701
December 5, 2006 thru January 16, 2007; and March 5 thru November 21, 2008:
Web Content Management Assistant (temporary employment)
Duties included: Assisting the Web Content Manager in developing and
updating Web pages, cascading style sheets, and other electronic documents
using Dreamweaver and a proprietary content management system.
USDA Forest Service
Missoula Technology & Development Center
5785 Hwy 10 W
Missoula MT 59808
January, 2002 thru November, 2006: Information Technology Specialist
(temporary position).
Duties included: Assisting the Publications Editor and Program Leaders in
developing Web pages and other electronic documents and training materials
produced through research conducted at the Center. Developed and modified
relational database programs and online data collection questionnaires.
Created presentations and web materials using PowerPoint, Adobe
Illustrator, PhotoShop, Adobe Acrobat, Macromedia Dreamweaver and HomeSite.
Took digital photographs and scanned slides and photos; created or
modified graphic materials; and created online training materials.
Provided information technology support to staff and program leaders.
Researched and developed in-house standards for the implementation of web-
based products that meet Section 508 Accessibility Standards). Developed
procedures and templates that allowed others to efficiently create new
documents with a similar "look and feel" that also met the technological
goals and information management policies of the agency. Trained and
supervised part-time staff in the production of web-based documents.
Developed and maintained dynamic database-driven web sites using Access,
Oracle, MySQL, Perl, PHP, Java, Javascript, and ColdFusion.
Teaching Experience
THE UNIVERSITY OF MONTANA, Missoula, Montana:
January 1991 through June 1991: Adjunct Professor teaching Group Process
and Applied Social Research, Social Work Department, The University of
Montana, Missoula, MT 59812.
September 1984 through June 1988: Graduate Teaching Assistant, University
of Montana Sociology Department teaching Principles of Sociology, Social
Problems, and Sociology of Deviance. Tutored students in Social Statistics
and Business Statistics.
SALISH-KOOTENAI COMMUNITY COLLEGE, Pablo, Montana:
Fall 1986 and Spring 1987: Visiting Professor teaching Developmental
Psychology, Introduction to Sociology, and Social Psychology.
PART-TIME DANCE INSTRUCTOR, Missoula, Montana:
Fall 1988 to present: Top Hat & Tails Round Dance Club. Teaching
choreographed ballroom dancing lessons. Member of the Roundalab
Professional Round Dance Teachers' Association since 1988. Membership
includes licensing under ASCAP and BMI to perform copyrighted music.
Achievements and Honors
Twice awarded Bertha Morton Scholarship for outstanding graduate work: in
1986 and 1988. Receipt of award placed me in the top 5% of all graduate
students at The University of Montana.
Award of Excellence for a professional paper presented at The University of
Montana's "Graduate Development Day Conference," Missoula, Montana, April
1987.
Professional Paper, Pacific Sociological Association Conference in Las
Vegas, NV, April 1987.
Publications and Papers
1999. "Black and White and Shades of Gray: A Portrait of the Ethical
Professor," Ethics and Behavior, 9(3), pp. 243-261, Lawrence Erlbaum
Associates, Inc., Mahwah, New Jersey.
1996-1998. Technical Assistance Briefs: Developing a Sound Program
Evaluation, Program Evaluation Components, Planning Overview for Evaluating
Home Visitation Efforts, Definitions of Research Terms, Developing a Survey
Instrument, Techniques to Increase Survey Response Rates, Commonly Asked
Questions About Research Procedures, Sample Evaluation Plan.
1998. Key contributor, Healthy Families America "Community Planning and
Site Development Guide," a technical manual on comprehensive outcome
evaluations for child abuse prevention programs.
1991. "Examination of Empowerment and Rape Myth Acceptance Among Male
Adolescents in a Sex Offender Treatment Program," doctoral dissertation,
University of Montana, Missoula.
1991. "AIDS Education for Rural IV Drug Users in Montana," by Mary Birch
and Mary Trankel, Human Services in the Rural Environment, Autumn 15 (2),
Eastern Washington University Journal, Cheney, WA.
1988. "Women in Law Enforcement," a research study involving in-depth
interviews with female and male police officers, sheriff deputies, highway
patrol, and probation officers in Montana.
1988. "Differences in Aggressiveness Between Female and Male Lead
Characters in Television Crime Dramas," by Trankel, Summers, Fowler and
Buskirk. Currently under review for publication.
1987. "A Content Analysis of Aggression Performed By Lead Characters in
Prime-Time Crime Dramas," by Trankel, Summers, Fowler and Buskirk,
professional paper presented at the Pacific Sociological Association Annual
Meeting in Las Vegas, Nevada in April 1987.
1987. "A Behavioral Inventory for Identifying Types of Aggression,"
professional paper, Graduate Development Day Conference, The University of
MT, Missoula, April 1987. Award for "best use of theory."
1985. "Intergenerational Transmission of Values: A Data-Based
Reassessment," by McBroom, Reed, Burns, Hargraves and Trankel, Social
Psychology Quarterly, Vol. 48, No. 2, pp. 150-161.
1980. "Emotional Stresses of Childhood and Adolescence as a Basis for
Future Coping Efficacy," undergraduate honors thesis, Carroll College
Library Document, Helena, Montana.