Hi, I'm

Rachael Herman

Data & Systems Analyst

Databases

Analysis

Systems

Code

Statistics

Rachael Herman

I’m passionate about data and helping businesses leverage it with technology to make business operations more efficient and foster growth.

About Me

Skills

Proven experience delivering high-quality projects on time and on budget. Talent for quickly mastering new topics, with a strong passion for developing new skills. Diplomatic and tactful. Accustomed to handling sensitive, confidential records. Able to maintain a good sense of humor and optimism under pressure. Strong problem-solving, mathematical, statistical and analytical skills with exceptional business acumen. Excellent communication and organizational skills with a team-focused attitude.

Some Tools of the Trade

I have experience in: SAS, RStudio, PostgreSQL, Microsoft SQL Server, Visual Studio, Sublime Text, IDLE for Python, IntelliJ, Jupyter Notebooks, Chrome DevTools, Microsoft Power BI, Tableau, Google Data Studio/Looker Studio, Git and GitHub (Check out my profile!), Microsoft Excel (including VLOOKUP and PivotTables), Power Query, Microsoft Access, WordPress, Google Analytics, Talend, Snowflake, BigQuery, HubSpot Marketing (previously certified in content and inbound marketing), Metadata.io, Contently, CoSchedule, Hootsuite, and more.

Languages

SQL, R, SAS, Python, HTML5, CSS3, JavaScript, PHP, and Java (beginner level)
Programming
75%
Information Systems Analysis & Design
80%
Database Design & Management
85%
Data Analytics & Visualization
90%
Business Intelligence & Statistics
90%
Content Marketing and Management
95%
Communication and Organization
100%

Knowledge

Here are the kernels of wisdom gained from a lifetime of craft development through gumption, grit, and grind.

Lifelong Learner

Education

With insatiable curiosity and a desire to constantly improve my skills, I’ve spent most of my life learning through university courses, online programs, forums, webinars, and more.
Please visit my LinkedIn Profile to see recent LinkedIn Learning courses, certifications, and other topics.

Real World

Experience

  • Your Imprint (Contract), Marketing & Systems Analyst 2008 - 2022

    • Customized analytics reports and dashboards in Power BI, Tableau, and Google Data Studio to visualize core KPIs, saving time in manual reporting work
    • Compiled business requirements for development projects and performed user and systems testing with validation, resulting in project success and revenue increases for multiple small businesses
    • Aggregated unstructured and structured data to identify and promote best-selling products and services; led to hundreds of thousands in new revenue for multiple small companies
    • Collected data on top user devices to redesign websites and maximize conversions; led to more than 30% increase in sales for a retail client and higher profitability in multiple small businesses
    • Modernized communications with customers through automation using cloud platforms, resulting in increased lead generation and conversions for multiple clients
    Hard Skills
    • Collaboration with subject matter experts to establish business requirements and implement projects
    • Creation and querying of relational databases
    • SQL and MySQL
    • SAS, R, and Python programming for statistical analysis and business intelligence
    • HTML, CSS, JavaScript, and PHP in WordPress
    • Excel, PowerQuery, Power BI, Google Data Studio, and Tableau for data visualization and analysis
    • Information systems analysis and design through the SDLC processAgile and waterfall methodologies for project management
    • Google Analytics, Search Console, and Tag Manager
    • Advanced SEO skills
    • A/B testing and analysis on marketing campaigns
    • Regression modeling
    • Content strategy and management
    Soft Skills
    • Astute business acumen
    • Insatiably curious
    • Organized and detail-oriented
    • Creative problem solver
    • Analytical and mathematical skills
    • Lifelong student
    • Excellent communicator
    • Leadership skills and a team player
    • Respectful and compassionate

  • Multiple Companies, Medical & Legal Transcriptionist 2006 - 2015

    • Transcribed medical and legal dictations, edited voice recognition files, and worked independently; required to understand and translate confidential information
    • Oversee day-to-day operations of large accounts and provide transcription analytics to managers and clients, leading to improved productivity on a remote team of 75
    • Prepare medical reports for acute care hospitals, clinics, and surgery centers ensuring compliance with requirements of HIPAA and tight deadlines
    • Accurate and exceptional knowledge of radiology, acute and clinical care
    • Proficient documentation of legal, law enforcement, and court records with 99% quality
    • Proficient use of EMRs like Epic, Oracle Cerner, Phoenix Ortho, and Meditech
    Team Leadership, Training, and Quality Assurance
    • Oversee proper record release of information and ensure all legal requirements of privacy were upheld
    • Developed and implemented Pediatric Certification Program for Medical Language Specialists
    • Researched and created a 4-part examination for certification, using analytics to demonstrate success rates
    • Run bonuses, games, and “coffee-break” meetings over conferences (virtual office).
    • Motivated and encouraged team members to keep up with the 25,000+ lines per day, as well as meet quality standards of 98.5% or higher
    • Perform quarterly performance reviews using statistical analytics
    • Develop and educate the team about HIPAA laws, regulations, and updates

Some of My

Projects