Résumé of “Nancy McGill” (Systems Engineer)
Overview
Currently my day-to-day focus is data integration and development using XML, XSLT, T-SQL and PL/SQL. This task also requires knowledge of NIEM and the N-DEx IEPD (which includes parts of LEXS). I have also had exposure to GJXDM, the basis for the current NCIC standard through this development.
My web design and development portfolio includes websites, graphics, and publications developed for small businesses, higher education, conferences, state organizations, non-profits, programs and special projects.
My volunteer work involves an array of project management, planning, fundraising, communication and entrepreneurship skills.
I also have extensive experience with teaching, presenting, conference and event planning, writing, and public relations. I have served on the planning committees for various technology conferences and events.
Specialties
Expert CSS, HTML, WordPress, XML, and web standards.
Proficient with jQuery, XSLT, SQL, PL/SQL, T-SQL, PrestaShop, Joomla, PHP.
Have used JSP, Java and C#.
Well versed in social media, blogging, web usability, layout, Section 508, accessibility, writing, public relations, design, event planning, project management, communications.
Certifications
- NIEM Practical Implementer
- Continuity Of Operations (COOP), Security Awareness, Privacy. (Up-to-date as of May 2011.)
- XSLT Training (2010)
- Online training in SQL, XML, jQuery, PHP/MySQL,, Dreamweaver
- Adobe Flash Training (2008)
- Appscan University - Web Application Security online course (2007)
- Cisco Networking Academy Web Design Course on Adobe software (2001-2002)
Education
- MS Journalism (all but thesis) Other, West Virginia University (Morgantown, WV), 2011
- BA Foreign Language cum laude, West Virginia University (Morgantown, WV), 1998
- BA History cum laude, West Virginia University (Morgantown, WV), 1998
Job History
Systems Engineer
Data Integration support for National Data Exchange (N-DEx)
Wrote XML, XSLT, PL/SQL, T-SQL, some Java and C# (very limited).
Worked with Oracle, MS SQL Server, Firebird databases.
NIEM, N-DEx IEPD (which includes some LEXS), XML Data standards, some GJXDM
First project entailed mapping data from an Oracle Database using PL/SQL directly to XML. Final product produced XML files at a rate of 160 records in 5 seconds.
Worked for 8 months on developing PL/SQL for the N-DEx Oracle staging database project.
Researched, tested, and verified that it is possible to perform the same direct SQL to XML code with T-SQL for MS SQL Server databases. This established the foundation for a N-DEx standard staging database being created for MS SQL Server as well.
Web application user interface design
N-DEx Quick Client Refined the user interface of the N-DEx Quick Client.
N-DEx Serial Review Application (currently in development) Designed the user interface and worked closely with application developers to create a user friendly web-based program that would enable secure manual review of sensitive data.
Freelance Web Consultant
- Web design and consulting Develop CSS stylesheets, XML (including XHTML, RSS), MySQL, PHP, WordPress, WordPress MU, ecommerce (PrestaShop, Miva Merchant, some Magento), blogs, social media
- Graphic and print design
- Public relations
Web Developer (Prof Tech 2)
Web Design, Development, and Maintenance
- Researched, planned and coordinated a strategic website overhaul over a three and a half year period.
- Stage 1 included revamping the administration, navigation, and content of the website.
- Stage 2 included a complete redesign and implementation of standards.
- Stage 3 included research and coordination of a complete conversion from a static HTML site to a content management system (WordPress MU). With one other team member converted over 10,000 static pages to the database-driven system.
Planned, designed, coordinated, and edited the departmental blog.
- Manage, coordinate, and develop OIT web projects
- Develop CSS layouts, design graphics, XML (including XHTML, RSS), database creation and administration (MySQL, SQL), PHP, WordPress, WordPress MU, also some ASP.NET and ColdFusion front-end design customization.
- Ensure W3C web standards for usability, accessibility (Section 508)
- Monitor web application security
- Apply and oversee style standards according to OIT and WVU web policies
- Provide end-user support for website content managers and users
- Assist Communications Coordinator with public relations planning and implementation
- Collaborate with project team members
- Serve on planning committee for WV Higher Ed Technology Conference (2008, 2009)
- Indirectly supervise student workers/Graduate Assistants
- Participate in groups such as the Statewide Internet Group, WVU Key Communicators
Writing
- Edit, write, and manage OIT Blog
- Write blog posts, Web content, press releases, copywriting, presentations, technical documentation
- Write and edit content for the web, news releases, and other publications
Adjunct Faculty
Teach public relations course on desktop publishing (PR319 – Public Relations Editing and Design). Students learn about the fundamental aspects of desktop publishing in a public relations context. Over a period of five years taught Spring and Fall semester classes (up to 20 students each semester) in a computer lab environment.
Program Manager
Leadership & Collaboration
- Manage, coordinate, develop and maintain all CoA Web projects Cascading Stylesheets, ASP, some ASP.NET
- Project Administrator - WVSeniors Project
- Coordinate public relations with assistant director
- Represent WVU Center on Aging at conferences and events
- Supervise interns, indirectly supervise applications programmer and program assistant
- Look into opportunities for partnerships with other organizations
Design & Development
- Web and print design/layout (Websites, newsletters, brochures, posters, postcards, business cards, reports and other publications, displays for exhibits at fairs and conferences, etc.)
- Graphics for web and print (Logo design, photo editing, etc.)
- Website usability and accessibility standards compliance
Writing
- Press releases, write and edit articles for newsletters, advertising copywriting, presentations, press kits, media advisories, grant proposals, reports
Web Developer
Leadership & Collaboration
- Managed and developed all Web projects outside WVNET.edu domain
- Took initiative to research, establish and market web services
- Wrote proposals and agreements
- Represented WVNET at conferences and events
- Presented and moderated sessions at WVNET Conferences
- Created and coordinated WVNET Conference “Web Development Track”
- Conference planning teams: WVNET Conference 2000-2002, 2000 WV IT Conference and Expo
Design & Development
- Designed and edited graphics for Web and print
- Redesigned display for fairs and conferences
- Designed brochures, posters, postcards, business cards, etc.
- Developed promotions and direct mailings
- Ensured web site usability and accessibility
Customer Support & Service
- Sold and supported all web hosting and development accounts
- Provided Tier II Macintosh tech support
- Wrote help documentation and articles
Program Coordinator
Designed and maintained Web sites. Designed posters. Developed and taught training course on web page graphics. Represented WVNET at conferences and computing fairs. Technical and customer support for WVNET modem account users. Wrote documentation.