Avatar

Janekia Pinkard

Data Analyst/Web Developer

Charlotte, NC

janekia.pinkard@gmail.com

718-594-2432

Skills

Microsoft Excel

90%

Sql

70%

Javascript

75%

Languages

English



Work Experience

Download My Resume
Promera Technologies – Data Quality Analyst / Data Cleansing Specialist (Contract)
12/2025 - 06/2026
  • Performed data cleansing, validation, and quality assurance activities to improve data accuracy, consistency, and integrity across multiple business systems.
  • Audited large datasets using Microsoft Excel to identify and correct duplicate records, discrepancies, incomplete data, and formatting inconsistencies.
  • Maintained and updated customer records within Acumatica ERP and Pipedrive CRM, ensuring information remained accurate, complete, and current.
  • Executed data quality reviews and system audits to support reliable reporting, business operations, and decision-making.
  • Collaborated with internal stakeholders to resolve data issues, improve workflows, and support data governance initiatives.
  • Documented data management procedures, audit findings, and quality control processes to promote operational consistency and compliance.
  • Troubleshot data-related issues, investigated record discrepancies, and supported multiple concurrent projects in a fast-paced environment.
  • Streamlined validation and review processes through standardized quality control procedures, improving efficiency while reducing data errors.
PinkkardDesign – Founder & Freelance Web Developer
11/2025 - Present
  • Founded and operate a freelance web design and development business delivering custom websites, branding solutions, e-commerce functionality, and ongoing technical support for small businesses.
  • Manage complete website projects from client consultation and requirements gathering through design, development, testing, deployment, training, and post-launch support.
  • Design and develop responsive websites using HTML, CSS, JavaScript, Bootstrap, WordPress, Visual Studio Code (VS Code), and GitHub.
  • Create website wireframes and page layouts in Figma to support client collaboration and interface planning before development.
  • Configure hosting environments, domain registration, DNS records, SSL certificates, email routing, GitHub repositories, Netlify deployments, SiteGround hosting, and Cloudflare services.
  • Perform WordPress website migrations between hosting providers, ensuring successful transfer of website files, databases, domains, SSL certificates, and minimal downtime.
  • Implement WooCommerce and Stripe payment integrations, product catalogs, contact forms, and secure checkout experiences.
  • Conduct quality assurance testing, accessibility reviews, troubleshooting, and cross-browser/device compatibility testing to ensure website performance.
  • Apply SEO best practices including metadata optimization, XML sitemaps, Google Search Console setup, and search performance monitoring.
  • Manage proposals, contracts, estimates, invoicing, and client communications using HubSpot CRM and Wave Accounting while coordinating multiple concurrent client projects.
Spectrum via Apex Systems – Business Analyst (Contract)
7/2025 - 10/2025
  • Collaborate with the Data Integrity team to improve address accuracy and serviceability across internal systems.
  • Developed an Excel-based automation script to speed up bulk address validation, increasing efficiency by approximately 25–30%.
  • Use ArcGIS and other geospatial tools to verify physical address locations, lot boundaries, and service eligibility for unverified records.
  • Work within a structured shared drive system (PACE → Region → State → Ticket) to maintain organized workflows and data traceability across multiple regions.
  • Perform deep-dive research to validate addresses, confirm if tied to businesses, or identify new developments without assigned addresses.
  • Assign clear dispositions and handoff notes for follow-up teams (e.g., Add PRISM Number, Poor Quality Address, Delete), including supporting screenshots and map evidence.
  • Cross-reference internal systems like CSG-Billing to identify active accounts, duplicate records, and service discrepancies.
  • Manage assigned tickets through Jira, documenting progress, outcomes, and quality notes for accountability.
  • Assist team members with troubleshooting issues such as Excel functions, WebEx connectivity, and external screen casting during training sessions.
  • Recognized for strong problem-solving, resourcefulness, and maintaining high accuracy and attention to detail under tight deadlines.
Prime Therapeutics – Insight Global
3/2024 - 12/2024
  • Spearheaded the successful design and implementation of multiple new benefit plans within the RxClaim system, ensuring efficient claims processing for over 80 clients.
  • Actively managed and processed pharmacy benefit updates from Blue Cross Blue Shield, contributing to seamless integration of new policies.
  • Streamlined benefit plan coding processes in RxClaim, reducing errors and improving claims processing accuracy by 10%.
  • Led the implementation of benefit plan changes, improving system functionality and adapting to evolving client needs with a 5% increase in processing speed.
  • Proactively resolved coding and claims processing issues, leading to a 5% improvement in system accuracy and efficiency.
  • Executed detailed system testing, ensuring high performance and accuracy of system capabilities, reducing post-launch issues by 10%.
  • Provided expert-level support for Benefit Edit Tool (BET) submissions, enhancing client satisfaction by resolving 8% of submissions on the first attempt.
  • Automated benefit plan processes using advanced Excel macros, cutting manual input time by 2% and streamlining bulk entries.
  • Collaborated with cross-functional teams, including IT and UX departments, to improve system processes within the RxClaim CMS, enhancing system usability and accuracy by 5%.
  • Conducted quality control testing on benefit plans, verifying coding accuracy to uphold system integrity and reduce post-launch issues by 10%.
  • Utilized Zoom and Slack to coordinate benefit plan updates and quality control measures, ensuring alignment with client requirements and timely delivery.
Freelancer – Work from Home
01/2024 - 03/2024
  • Transformed raw data into actionable insights by meticulously labeling and analyzing complex datasets, enabling data-driven decision-making and the development of impactful business strategies.
  • Implemented a comprehensive labeling system that improved model accuracy by 6% across diverse AI projects, ensuring precise data handling and aligning outputs with key business objectives.
  • Selected and optimized prompts for AI-generated imagery, improving the accuracy and relevance of analysis by 10%, driving better alignment between user requirements and business goals.
  • Executed detailed web content labeling and analysis for AI model accuracy improvement projects, aligning outputs with content strategy to meet business objectives.
  • Used content management principles to organize and label large datasets, ensuring efficient project execution and optimized data handling for web-based AI applications.

Block Inc / Data Analyst – Contract – Work from Home
Jun 2010 - Mar 2012
  • Led the development of comprehensive data management policies and protocols, fostering a culture of data integrity that significantly improved data accuracy and reliability across the organization.
  • Implemented rigorous data validation procedures, reducing errors and improving information accuracy by 50% while ensuring data completeness for critical decision-making.
  • Developed and executed custom JavaScript scripts for mail and data merging across Google Sheets, Google Docs, and Gmail platforms, enhancing operational efficiency and training team members to leverage these automatons effectively.
  • Proficiently managed data operations within platforms like Workday, Airtable, and Google Sheets, maintaining 100% accuracy and optimizing daily data processing workflows.
  • Established standardized data-sharing protocols for upper management and external partners, providing ongoing support to team members, which improved the efficiency of cross-departmental collaboration by 50%.
  • Extracted and analyzed key report data, identifying and resolving data-related issues proactively, and using tools like Snip It to clearly communicate findings and solutions.
  • Optimized database management processes, efficiently organizing and maintaining large volumes of data, which improved accessibility and reduced retrieval time by 65%.
  • Ensured content quality control through rigorous data validation, reducing inaccuracies by 50% and supporting data integrity for business-critical reports.
  • Enhanced Google Workspace operations by implementing custom JavaScript scripts for mail and data merges, improving data accuracy and team coordination across the CMS.
  • Collaborated on data management systems to support key marketing insights, contributing to improved content accuracy and marketing system efficiencies.
Disys – US Bank / Data Analyst – Service Delivery & Technical Operations – Contract (Hybrid)
Jun 2010 - Mar 2012
  • Acted as primary data coordinator for onboarding and operational readiness, reducing onboarding time by 40% through detailed tracking and resource optimization.
  • Designed and delivered detailed reporting dashboards using advanced Excel tools (Pivot Tables, Charts, VLOOKUP), driving a 100% improvement in decision-making clarity for project stakeholders.
  • Consolidated and maintained key project performance trackers and compliance reports, improving documentation accuracy and oversight efficiency by 40%.
  • Partnered with QA to conduct pre-audit data analysis of evidence packages, contributing to a 100% reduction in compliance issues by ensuring completeness and accuracy of submitted data.
  • Conducted in-depth fraud analytics using platforms like Actimize, LEAP, SharePoint, and Hogan, identifying trends and supporting the development of improved fraud detection strategies that increased catch rates by 20%.
Insight Global – Mood Media / Data Analyst – Operational Data & Systems – Contract (Hybrid)
Jun 2010 - Mar 2012
  • Standardized operational workflows across departments, reducing error frequency and improving project consistency by implementing unified data protocols.
  • Supervised and trained new hires on data systems and internal platforms, improving their onboarding speed and data accuracy.
  • Managed daily tasks using Oracle and Service Cloud, optimizing data flow and improving task completion rates across the team.
  • Maintained detailed technical travel logs and project data in Excel, enhancing audit-readiness and data retrieval efficiency.
  • Juggled multiple data-centric projects simultaneously, delivering results under tight deadlines while ensuring accuracy and clarity.
  • Leveraged database systems to organize and manipulate large data volumes, providing reliable support for decision-making and performance tracking.

Education

Grand Circus
2024

Certified in: Supabase, powerBI, PostgreSQL Server and pgAdmin

Nucamp Coding Bootcamp
2020

Certified in Languages: CSS, HTML, and JavaScript (vanilla) Frameworks: Bootstrap, Express.js, and React Native  Libraries: React MongoDB, Node.js

Pace University
2011 - 2012

Program provides hands-on skills development, Pace University credits, and earned 22 college credits

Recipient of the Strive to Learn Award, Module 1