Resume

Seeking Remote Positions

Sue Darby

Data Analyst, Business Analyst & Technical Writer

Skills

Technical Writing
Procedures
Websites
Workflow Diagrams
Formatting

Technologies

HTML, CSS
Universal Modeling Language
JSON, XML, JavaScript
WAMP

Windows, FTP, C, APIs, Document Management, Databases, Android, Content Management, Angular, DITA, Unity/C#, Perl, BASIC A, MYSQL, Linux

Applications

Excel, Word, PowerBI
OneDrive, Teams
Access, Project, OneNote
Facebook, Twitter, Pinterest

Adobe Acrobat, SharePoint, Visio, Star UML, Visual Studio Code, GitHub, Adobe Pro, Google Drive Office Suite, Databases, WordPress, PHP, Dropbox, Dreamweaver, FileZilla, Corel Draw Suite, Slack, Trello, PHPMyAdmin, Visual Basic.NET, Freemind, Gmail, HubSpot

Soft Skills

Attention to Details
Time Management
Organization Skills
Data Science

Customer Centric Service, Self-motivated, Mentor Team Members, Marketing

Technical Writing

Hobbies

Civil Rights
Computer Building (Scratch Builds and Upgrades)
Website Development, Programming
Reading Science Fiction, Fantasy & Non-Fiction
Sewing
Gardening
Table Top Role Playing Gaming (D&D, Cyber Punk etc)

Pattern Drafting, Dollhouse Scale Miniatures, Dolls, Historic Costumes, Photography, Crafts, Creative Writing, PC Games (Minecraft, Wynn Craft, Titan Quest, Sacred, Oblivion)

Education

Charter College

Alpha Beta Kappa, Dean’s List, Perfect Attendance

B.S. Degree in Business Management & Technology: Concentration in Business Applications

B.S. Degree in Business Management & Technology

Associate of Applied Science Degree in Computer Science : Concentration in Business Applications

Associate of Applied Science Degree in Business Management Practice

Certificate in Computerized Office Associate

Certificate in Computerized Office Specialist

Microsoft Office Master Certification

EdX

Microsoft DAT206x Analyzing and Visualizing Data with Excel

Microsoft DAT207x Analyzing and Visualizing Data with Power BI

Microsoft

Microsoft Office Master

MSOE: Microsoft Excel 2003 Expert

MSOE: Microsoft Word 2003 Expert

MSOS: Microsoft Access 2003

MSOS: Microsoft PowerPoint 2003

MSOS: Microsoft Excel 2003

MSOS: Microsoft Word 2003

I am a technical writer with experience in writing procedures for using software. I excel at writing for any audience.

I am a business analyst who specializes in facilitating communication between IT & managers. I excel at improving processes, writing detailed procedures and project management.

I am a data analyst with 15+ years experience using Excel. I excel at developing data tracking systems and reports in SharePoint as well as aggregating data from databases and formatting it for presentations.

Projects

Clean Mal ~ As part of a small group within a larger team responsible for correctly parenting public sector and commercial accounts. Detailed research and analysis required to ensure compliance with established business rules. Use of multiple internal systems including MSRA, Calc and SDS for reports and processing. Processed approximately 300 accounts per month.

Settings compliance ~ Development of a single tool to capture data, aggregate, and generate individualized notices. Development of a macro to take 1000+ final notices to a mass email merge of PDF files. Additional tool developed for compiling statistics and tracking the progress of the project for reporting. This includes documenting the process and training the team. Time savings for team of 66%.

Application Tracking System ~ Created an interim data tracking system using SharePoint to measure the time frames for processing applications. The in-house database did not have this function. I trained co-workers in use of various views and troubleshoot system as necessary as site admin. Team efficacy improvement 74%.

System is used for generating reports on where applications and changes are in the processes. This system is being used as inspiration and a guide for building new reports within the Harmony System.

CPR Waivers ~ Built tracking system in SharePoint to track requests for CPR & First Aid Waivers from providers. System brought abuse of the process to management’s attention and generated regulatory changesSystem was incorporated into Harmony Database during development.

Habilitation Homes Project ~ A specific type of provider was not found in the main database, DS3. This project modified the database, collected the missing information, entered it and connected it correctly and developed several reports to track the missing data and ensure the integrity of the data moving forward. Added over 450 new contracted providers to system increasing tracking of vulnerable adult and child safety.

In addition to the initial entry and connections for each contracted home, maintenance for each record is conducted as the host agency is recertified. Additionally, reports have been created to track and more easily see which homes contract with each agency or agencies. This ensures there is less fraud and Medicaid abuse.

While the new database, Harmony was being developed, I was consulted on the connections, reports and data needs of this group of providers.

Archives ~ As the division subject matter expert was part of the development of the SharePoint Site that tracks all the files that are sent to Archives or Off-Site Storage. Working closely with the techs I helped find and fix bugs in an older system for calculating retention times, update the form to match the required form for Archiving and work as an administrator of the site adding new team members to the site. Archived over 3,000 provider files.

Previously the Archive SharePoint site, built in SharePoint 2007 and converted to 2010 was not computing retention times correctly. I took the lead to work with the SharePoint Developers to update and improve the system. In the process working closely to test and deploy fixes and becoming a site admin for the test and production sites due to my knack for finding the problems or suggesting where the issue might be within the code. When the new system, Harmony went live in 2018 this system was retired.

Critical Incident Reports ~ In 2009 the State of Alaska implemented mandatory reporting of neglect, abuse and fraud for vulnerable adults. There initially was no process in place to track the incoming reports. I developed a spreadsheet that tracked basic data and over time modified repeatedly to generate various types of information for the Commissioner (state) and (CMS) Center for Medicaid & Medicare Services (federal) level reporting. Based on my system IT built a SharePoint site and then built the process into Harmony during development. Tracked 1,000+ incidents resulting in increases in safety for vulnerable adults and children.

Current Work

Websites, Programming & Technical Writing

Continuing Education Topics

Learning Jira Software 7.0-7.4
Technical Writing: Quick Start Guides

Agile Software Development
Applying Lean, DevOps, and Agile to Your IT Organization
DevOps Foundations: Lean and Agile
Lean Foundations
Lean Technology Strategy: Building High-Performing Teams
Lean Technology Strategy: Running Agile at Scale
Lean Technology Strategy: Starting Your Business Transformation
Managing International Projects
Project Management: Technical Projects
Scrum: The Basics

Bootstrap 4 Essential Training
Choosing a Cloud Platform for Developers: AWS, Azure, and GCP
CSS Essential Training
HTML Essential Training
HTML: Structured Data
Introduction to Web APIs
IoT Foundations: Fundamentals
JavaScript Essential Training
Learning GitHub
Learning REST APIs
Making Sense of the CSS Box Model
Programming Foundations: Databases
Programming Foundations: Fundamentals
Responsive Layout
Succeeding in Web Development: Full Stack and Front End
User Experience for Web Design
UX Foundations: Accessibility
Version Control for Everyone
Web Programming Foundations

Installing and Running WordPress: Local by FlyWheel
WordPress 5 Essential Training
WordPress 5 Essential Training: Site Administration
WordPress: Accessibility
WordPress: Advanced Custom Fields
WordPress: Building Child Themes
WordPress: Building Progressive Themes with WP Rig
WordPress: Custom Post Types and Taxonomies
WordPress: Workflows

CompTIA A+ (220-1001 and 220-1002) Cert Prep: The Basics
CompTIA A+ (220-1001) Cert Prep 1: The Basics
CompTIA A+ (220-1001) Cert Prep 2: Microprocessing and RAM
CompTIA A+ (220-1001) Cert Prep 3: Core Hardware
CompTIA A+ (220-1001) Cert Prep 4: Storage and Peripherals
CompTIA A+ (220-1001) Cert Prep 5: Display Technologies
CompTIA A+ (220-1001) Cert Prep 6: Physical Networking
CompTIA A+ (220-1001) Cert Prep 7: Understanding Networking
CompTIA A+ (220-1001) Cert Prep 8: Internet and the Cloud
CompTIA A+ (220-1001) Cert Prep 9: Portable Computing
CompTIA A+ (220-1001) Cert Prep 10: Printers
CompTIA A+ (220-1002) Cert Prep 1: Getting Started
CompTIA A+ (220-1002) Cert Prep 2: Implementation Considerations
CompTIA A+ (220-1002) Cert Prep 3: Windows and More
CompTIA A+ (220-1002) Cert Prep 4: Command-Line Interface and Scripting Languages
CompTIA A+ (220-1002) Cert Prep 5: Troubleshooting Operating Systems
CompTIA A+ (220-1002) Cert Prep 6: Networking, Security, and More
CompTIA A+ (220-1002) Cert Prep 7: Portable Computing
CompTIA A+ (220-1002) Cert Prep 8: Security and Organization

Building Self-Confidence
Creating a Career Plan
Creating Your Personal Brand
Data Science & Analytics Career Paths & Certifications: First Steps
Excel and Visio: Generating Diagrams Automatically
Finding a Remote Job
Getting the Most from Recruiters While Job Hunting
Insights from a College Career Coach
J.T. O’Donnell on Making Recruiters Come to You
Job Search Strategies
Managing Anxiety in the Workplace

The Alaska Collaborative of Telehealth and Telemedicine (AKCTT) is a statewide, non-profit, non-partisan forum committed to developing a coordinated, interagency approach to standardized telehealth care delivery in remote and urban Alaskan communities.

  • Facilitate communication between board, directors and members
  • Organize and maintain records for non-profit; schedule meetings and record and distribute minutes and collaborate to develop agenda
  • Create promotional materials for outreach events

2018 - Present

Barony Of Ravenstone

Order of the Rose

  • Design and construct Heraldry Banners for Ravenstone, Astral Winds, Lupine Moon, Frozen Coast, and IceFire Bay for use at Court Events and Games
  • Lead Arts & Sciences group in constructing
    • Game tabards
    • Introduction to sewing course
    •  30 belt favors
  • Design, draft, test, and constructed court garb loosely based on historic garments
  • Order of the Rose Award for Service to the Realm

Ongoing

Technical Writer, Author

Sue’s Tiny Costumes makes patterns in the micro scale from 1/2″ tall baby dolls to 18″ lady doll patterns.

  •  Project management of a variety of pattern drafting projects
  • Published author of 2 books and over 100 sewing patterns
  •  Photography of finished items for patterns and website

Awards and Publications

  • Pattern Making for Dolls ~ Registration Number / Date: TXu001082134 / 2003-02-26
  • Pattern Drafting for Miniatures ~ Registration Number / Date: TXu001082114 / 2003-02-26
  • International Doll Magazine, Pattern Consultant 6 published patterns 2004-2005
  • Dolls In Miniature- article 2005
  • Doll Castle News- article 2005
  • State Fair 2005 Little Bo Peep and her Sheep (Kitty Collier & Tiny Betsy)
  • Anaheim Doll Show – 2nd Place Costuming Letha Marie

2018-2019

Launch Consulting

Data Analyst

Data Analyst for Public Sector Microsoft O365, Azure, and device sales. Tight knit team of 5 caring for managed and unmanaged public sector sales accounts for Microsoft.

  • Extensive use of Excel for tracking and reporting using pivot tables, conditional formatting, and filters
  • Reporting via MSRA to determine if a request fits in the business rules for processing
  • Database management via Calc and SDS (internal systems)
  • Developed training materials including documenting business process and flow charts.
  • Record training sessions and developed written procedures
  • Research of additional accounts that could be parented
  • Tested validity, accuracy and consistency of new and existing intelligence data
  • Verified and updated account information in company computer system.
  • Maintained library of templates and reusable knowledge assets to facilitate business intelligence activities.
  • Checked figures, postings and documents for correct entry, mathematical accuracy and proper coding.

2008-2017

State of Alaska

Senior Services Data Analyst Technician

Part of a collaborative team of 10-15 professionals and quickly became a sought out subject matter expert in Excel, SharePoint, and process improvements. 

  • Appointed SharePoint Administrator for 2 sites to develop tools for team including technical documentation for non-technical users
  • 66% improvement in workflow processes via macro programming and process design
  • 74% time gain for team from programming of tool to track certification process

85% increase in data collection, clean up, and notification efficiency

2006-2008

Nine Star Education & Employment

Computer Instructor & Career Development Specialist

AmeriCorps Member in Career Development Center of Nine Star Education and Employment Services. Delivered a high level of personalized customer service, computer skills to a diverse group of customers.

  • Instruct 50+ individuals in basic computer skills and Microsoft Office applications
  • 50% improved time management; reduce management’s information systems data entry
  • Collect and present computer student statistics and career development data to 60+ professionals

Education

Charter College Bachelors of Science ~ Alpha Beta Kappa

Certifications

Solano Community College

Continuing Education

2019

2017

2015

Relevant Classes

  • Advanced Web Development
  • Javascript
  • Visual BASIC.NET
  • Perl
  • Technical Writing
  • Project Management
  • Marketing
  • Statistics
  • Research Methodologies
  • Telecommunications
  • Contract Management
  • Human Resources
  • Operations Management

Workplace Training

  • COGNOS
  • HIPAA Security
  • Archiving Basics
  • Introduction to Supervisor Training
  • Basic Care Coordinator Training
  • Introduction to Office 2007

Where do I or have I used these programs?

CMS: WordPress, Drupal, Dreamweaver,  Joomla

 WordPress, install via cpanel and manually via FTP. Configure basic settings, install theme and plugins. Troubleshoot conflicts and custom changes to HTML, CSS, JavaScript and PHP researching for additional information as needed. Total current number of sites is 14 with subdomains. I personally use Infinite WordPress to manage updates, themes, plugins and backups.

 

Samples Collage

Prior to using WordPress for all of the sites I used Joomla or Drupal as well as hand coding in HTML CSS and using Dreamweaver for development. I currently use VS Code for all my hand coded sites and work.

Databases: Azure, SharePoint, MMIS, DS3, Citrix, Access, Enterprise, COGNOS, MYSQL, PHPMyAdmin, CPanel

The robust Azure & SharePoint system used by Microsoft in combination with Excel and Power BI was a great system to work with for modifying accounts and tracking data. 

Citrix was a database that was used to track various types of data for the clients that Nine Star served.

 

web management 2020

 

DS3 is the main database currently in use with Senior and Disability Services but it is in the process of being replaced. DS3 originally was a Cold Fusion based system but has migrated to a .NET framework.  The replacement system is named Harmony and went live in the winter of 2018.

 MMIS or Medicaid Medical Information System has been replaced by Enterprise and is a good system that Harmony will eventually interface with. This system’s report manager, COGNOS provides a robust system to track data.

Graphic Art Suites: Corel Draw, Inscape, Gimp, Paint Shop Pro, Visio, Star UML, Dia, Freemind

Battle Plan

The Corel Draw Suite is a main tool for my drafting and design work for sewing patterns and technical writing. Inkscape is the Open Source version of it and is used to do various drawings in .svg formats.

Umls are used to diagram processes in Visio and Star Uml.

One of my main tools is Freemind, Freeplane and now Scapple for mind mapping ideas and outlining books.

Office Suites: Office 365, Master Certified Microsoft Office 2003, Microsoft Office 95-2016, Microsoft Outlook, Microsoft Project, Microsoft Visio, Microsoft SharePoint 2007-2016, OneNote, Open Office, Adobe Pro, Adobe DC

I use or have used all of these office suites heavily. They are the main stay of my workflows.

I am certified in MS Office and have continued my education using State of Alaska Trainings for SharePoint eventually earning the respect of the IT administration team and 

open-office

granted my own sandbox to work in as well as full control over the Provider Certification Unit site and the Division’s Archiving site.

I used OneNote to compile a reference manual of all of the procedures for the Certification unit.

Word and Excel were used heavily to do mail merges as well as many other tasks including checklists and data tracking as well as graphs and charts for reports up to the Federal level.

Adobe Pro was used to “jailbreak” documents into Word and Excel, date stamp incoming certification applications and many other tasks including as a pivotal tool in a massive mail merge. I also used it to create the Certification Application and add fill in fields to ensure that applications were legible and data entry was accurate.

This is but a small portion of the variety of software and tools I use or have used on a daily basis. The list could go on and on!

My “Official Job”

During the process of reclassification, I was asked to rewrite my job description. This is what was accepted resulting in my reclassification to Senior Services Technician.

Under general supervision, this position performs a variety of support and technical functions in
the administration of the Provider Certification & Compliance Unit for the Medicaid Home and Community Based Waiver and Personal Care Assistance program. This position provides support and assistance to program managers and is responsible for program specific work of a senior service-oriented agency, develops and maintains systems to track certification information and prepares reports for professional staff which are used internally and externally. The position serves a key role in the Provider Certification Unit as related to regulatory compliance, client health and safety, and continuous quality improvement.

    • Create and maintain system generated reports for Provider Certification & Compliance Unit process of certification of Medicaid provider applicants, waivers, onsite provider reviews, and other quality assurance processes.
    • Uses various reporting tools to compare data available internally and externally to correct deficiencies in data sets such as providers not showing up on the interactive public Search Tool but are active in the internal DS3 database.
    • Participates in planning and developing system work orders to improve systems support for the unit.
    • Maintains systems to ensure data integrity.
    • Produces reports for management use; assists professional staff in analyzing data and creating reports. Enters and edits data and creates spreadsheets.
    • Enter and track data related to provisional background checks of employees in agencies that obtain initial certification approvals. Work closely with certification application evaluators to communicate changes in background check status for these individuals for follow up measures.
    • Implementation of a centralized repository of required forms and letters into a SharePoint site to use as a resource.
    • Develops Certification forms for internal use and edits Certification Application forms ensuring accessibility for the public.
    • Builds & maintains UMLs of unit processes, writes or updates written processes as assigned
    • Develops Universal Modeling Language (UML) tools for clarifying processes. Ensures procedures are updated as shared electronic documents for the unit.
    • Assists with printing, copying, mass mailings, and organizing materials for meetings, training sessions, investigations, and site reviews or provides lead support to supportive staff.
    • Provides support and maintenance of the unit`s copiers, fax machines and other machinery in the office. Conducts routine maintenance, troubleshooting and periodic repair status checks. Facilitates repair calls as necessary.
    • Prepares materials for dissemination to providers, including recertification notifications
      Prepares mailing lists, merges documents, tracks and archives mailing lists for compliance history.
    • Provides detailed information on program regulations; advises the public on program applicability and requirements; explains related laws, rules, regulations, policies, and procedures to potential providers; advises and assists potential providers in setting up services. Must stay abreast of regulation, policy and systems changes.
    • Provides technical assistance to applicants and providers regarding certification application process, setting up Background Check accounts, and corresponding with the SDS fiscal agent for billing purposes.
    • Processes incoming initial and renewal applications for Medicaid Waiver and Personal Care Assistance Certification Application for completeness of required information according to state and federal regulations.
    • Monitors Provider Certification email inbox which is the publicly posted email and web portal for all providers and applicants. Various reports of incidents, inquiries, complaints and questions flow through this email and must be routinely monitored and re-routed. An in-depth knowledge of SDS programs and their inter-relationships must be maintained in order to able to manage this duty. Responds to and takes appropriate action when within prescribed parameters, redirects to the correct professional staff when beyond knowledge base or those parameters, routes various emails to specific professional staff for decisions and action. Must use good judgment to determine level and routing of communications.
    • Serves as subject matter expert on records retention procedures and archiving/off-site storage processes and advises professional staff on these procedures.
    • Helps keep Provider Certification records and files organized and complete. Ongoing filing and policy and procedures toward electronic record keeping.
    • Provides records copies for various records requests for criminal cases, public requests, etc. Ensure complete records are provided.

File Maintenance

Pile of files I came back to after taking a long weekend....

Pile of files I came back to after taking a long weekend….

While being a clerk has been one of my titles the same duties carried over to being a Senior Services Tech. The number of files for provider certification has varied over the years but has always been more than 800. That is agencies and individual care coordinators that the division certifies.
 
Each of those providers has multiple files. A hard file, an electronic file and a database entry. Each has to reflect the others and older materials have to be archived just in case there is an audit in the future.
 
The processes I complete almost unconsciously have been either developed or modified by me in the last several years. I do the primary process of issuing reminder letters, entering providers and various notes into the database and preparing the file for review.
 
After the review process is complete I take the final file and add it to a current file replacing older materials and archiving them or creating a complete new file as needed. During this file process I check that the required items are present via a tagging system developed internally that matches a checklist. Any files with errors are returned to the worker who signed off on the application for corrections.
 
In addition to the certified agencies there are a number of other agencies or providers that the division cares about and it has fallen to me to keep track of these providers as well. Some are a once a year quick database only update and others require detailed maintenance and changes as part of the general certification process as they are a setting that is contracted to a certified provider. No matter what the number of provider records I maintain numbers over 1200.
 
An additional type of file I care for is the closed providers which by the time the file gets to me I have to deconstruct and label it to enter it into a separate database. This is a tracking system I am one of the administrators for and have steered many changes and improvements to the system.
 
This is just a teeny peek at a segment of the things I do.
  • Contact Me

    All image on this site are ©2019 Sue Darby.

    Photographs are taken by Sue Darby please ask for permission and link to this site if you wish to use one.

  • Contact Me