Business Intelligence Quality Assurance
Resume:
Asking great data questions for great business decisions!
Jordan Williams LinkedIn
Apt. 506
Oak Lawn, IL 60453
***********@*****.***
Skills
Tools/Languages: SQL, Python, HTML, XML, CSS, JSON, Jupyter Notebook, Sisense, Domo, Tableau, Power Query, Power BI, Looker, Snowflake, Snowsight, Pendo, Atlassian (Jira/Confluence), PostgreSQL, SQL Server, SSMS, Microsoft Office, Google Suite, Salesforce (data exports), data catalogs, Collibra, BluePrint CMS, Articulate Storyline, ChatGPT, PetPoint, Petfinder, ShelterBuddy, GitHub: Jordanjn11
Abilities: Agile/Scrum Methodologies, data modeling, business question and user persona development, critical thinking, user story and business requirement development, analysis presentation, vendor management, custom business analytics, project management, data governance, vendor/supplier management, client-facing solutions consulting, curriculum development, software testing & UAT
Experience
Fractional Business Operations Lead
Heavenly Yin Studios APR 2025 - Present, CHICAGO, IL
● Analyze internal operations and identify areas for process enhancement
● Implement business strategies and plans that align with the short- and long-term objectives developed in tandem with CEO
● Configure and develop product analytics to optimize social media and business operation strategies
● Oversee operations, HR, and accounting, and partner with CEO in sales management so that sufficient investment capital can be budgeted for near-term growth targets
● Manage capital investments and expenses aggressively to ensure that the company achieves investor targets for growth and profitability
● Monitor performance with tracking software and take corrective measures when necessary, and prepare detailed updates and forecasts
● Build and maintain trusting relationships with key customers, clients, partners, and stakeholders Data Analyst & Digital Product Consultant
SEPT 2024 - Present, CHICAGO, IL
● Fractional Business Operations Lead - Heavenly Yin Studios
● Data warehousing, modeling, & analysis: Use SQL Server, Jupyter Notebook, Python, and Power Query to clean and analyze large data sets, then curate prepared data as views and data marts for analysis and visualization
● Data reporting & visualization: Use Power BI, Tableau, Looker, Gsuite, and Excel to create compelling analytics and data storytelling visualizations
● Data governance: Use Excel, GitHub, SQL Server, GSuite, other tools to develop data catalogs, including data dictionaries and entity relationship diagrams (ERDs) to represent, define, and query business data from relational databases and curated data marts
● Head of Product @ Slightly More Awesome: https://www.slightlymoreawesome.com/ BenchPrep - Data Product Analyst/Owner
JAN 2022 - SEPT 2024, CHICAGO, IL
https://www.benchprep.com/reporting-data
● Migrated and enhanced white-labeled embedded analytics and self-service data products from legacy vendor systems: improved performance, ease of access, and saved $100k's in subscription and usage costs.
● Designed and automated billing reports for dozens of enterprise customers, saving 100's of man-hours per month, increasing customer confidence, and supporting platform usage overage billing
● Ideate, research, recommend, mock-up, and demo new data products based on stakeholder business requirements.
● Gather business requirements from non-technical stakeholders, prioritize features per product strategy, and refine into actionable user stories.
● Deployed new embedded dashboards and reporting features to enterprise customers with 0 downtime.
● Delivered bespoke reports and analytics from SaaS data to answer critical customer and internal learning business strategy questions, driving renewals, professional service revenue, and contract growth
● Produced reports using advanced Excel/Gsuite spreadsheet functions.
● Utilized data visualization and queries to effectively communicate business insights through ad hoc reporting.
● Improved decision-making processes with accurate data analysis and visualization techniques.
● Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
● Extract, transform, load, and integrate application data across platforms for analysis and reporting product delivery
● Developed & maintained curriculum & documentation for business intelligence and data warehousing tools, then used it to train customers and cross-functional teams, scaling data literacy & report development and delivery initiatives, and enabling customers on high-margin self-service analytics products.
● Analyzed SaaS software systems and reporting products to identify, document, translate, and utilize application metadata and data lineage for reproduction, translation, migration, and improvements in business intelligence.
● Enhanced business efficiency by identifying trends and patterns in complex datasets.
● Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
● Streamlined data access for remote teams by implementing cloud-based data management solutions.
● Conducted comprehensive data analysis to support strategic planning, leading to more informed decision-making.
● Facilitated knowledge sharing by creating centralized data repository accessible to all relevant parties.
● Improved data governance practices, ensuring compliance with regulatory standards and internal policies.
● Facilitated cross-departmental data integration, enhancing overall data coherence and utility.
● Conducted ad-hoc analysis to address urgent business questions, facilitating rapid response to market changes.
● Streamlined reporting processes, resulting in faster turnaround times for monthly performance reports.
● Enhanced team's analytical capabilities with training on latest data analysis tools and techniques.
● Enabled more personalized customer experiences by analyzing behavior patterns and preferences.
● Automated routine data analysis tasks, freeing up time for more complex analysis.
● Improved data visualization techniques, making insights more accessible to non-technical stakeholders.
● Enhanced data accuracy by automating data cleansing processes, significantly reducing manual errors.
● Analyzed data to identify root causes of problems and recommend corrective actions.
● Developed customized reports, summarizing and presenting data in visually appealing format.
● Created data models to support decision-making processes.
● Created dashboards to monitor and track key performance indicators.
● Updated and developed scripts and queries to extract and analyze data from multiple sources.
● Provided technical support for troubleshooting analytics and reporting issues.
● Collaborated with stakeholders to identify business needs and data sources.
● Generated ad-hoc reports to evaluate specific business requirements.
● Developed complex dashboard and reporting tools to track business performance metrics.
● Implemented business intelligence solutions to increase operational efficiency.
● Developed and implemented data governance policies and procedures.
● Deployed predictive analytics models to forecast future trends.
● Developed and maintained data warehouses and data marts to support business operations.
● Suggested and implemented product development and team management process improvements to cross-functional and customer stakeholders, improving efficiency and cutting production costs.
● Optimized data access and storage to improve performance of analytics systems.
● Enhanced team productivity by implementing agile methodologies, leading to more efficient project completion. BenchPrep - Manager, Learning Content & Conversion JUL 2020 - DEC 2021, CHICAGO, IL
● Delivered bespoke reports and analytics from SaaS data to answer critical customer and internal learning business strategy questions, driving renewals, professional service revenue, and contract growth
● Developed curriculum on organization’s business intelligence and data warehousing tools, then used it to train customers and cross-functional teams, scaling data literacy & report development and delivery initiatives, and enabling customers on high-margin self-service analytics products.
● Enhanced customer satisfaction by resolving disputes promptly, maintaining open lines of communication, and ensuring high-quality service delivery.
● Extract, transform, load, integrate, model, enrich, and QA application data across platforms for LMS product delivery
● Ideate, research, recommend, mock-up, and demo new data products based on stakeholder business requirements.
● Gather business requirements from non-technical stakeholders, prioritize features per product strategy, and refine into actionable user stories.
● Queried, analyzed, and visualized large, complex SaaS product datasets for insights
● Developed and maintained relationships with customers and suppliers through account development.
● Used industry expertise, customer service skills, and analytical nature to resolve customer concerns and promote loyalty.
● Suggested and implemented product development and team management process improvements to cross-functional and customer stakeholders, improving efficiency and cutting production costs.
● Presented product analysis insights to cross-functional teams to drive better business decision-making and to customers for better digital product development and enhancement decisions.
● Developed a strong company culture focused on employee engagement, collaboration, and continuous learning opportunities by mentoring employees for career advancement, fostering a pipeline of future leaders within the organization.
● Resolved staff member conflicts, actively listening to concerns and finding appropriate middle ground.
● Built high-performing teams through effective recruitment, onboarding, and talent development initiatives.
● Streamlined workflows by identifying bottlenecks in existing systems and implementing appropriate solutions.
● Developed comprehensive risk management plan, minimizing potential disruptions to business operations.
● Enhanced team productivity by implementing agile methodologies, leading to more efficient project completion.
● Enhanced product quality by instituting rigorous quality control procedures, resulting in fewer customer complaints.
● Achieved significant cost savings by renegotiating contracts with key service vendors, without compromising cutting operational costs while maintaining product and service quality
● Streamlined project delivery processes, significantly reducing time to market for new product launches.
● Established team priorities, maintained schedules and monitored performance.
● Evaluated employee performance and conveyed constructive feedback to improve skills.
● Maintained professional demeanor while troubleshooting customer pain points and recommending solutions.
● Recruited, interviewed, and hired employees
● Developed & implemented mentoring, upskilling, professional development and cross-training programs to maximize team agility and performance, and increase positive employee feedback and engagement
● Established performance goals for employees and provided feedback on methods for reaching those milestones.
● Set aggressive targets for employees to drive company success and strengthen motivation.
● Identified and communicated customer needs to supply chain capacity and quality teams.
● Launched quality assurance practices for each phase of development BenchPrep - Senior Learning Content Manager
OCT 2015 - JULY 2020, CHICAGO, IL
● Delivered hundreds of responsive online LMS courses generated $10M+ in annual SaaS revenue from enterprise partners, credentialing bodies, and certification organizations in a fast-paced, B2B SaaS start-up environment.
● Presented to and interviewed B2B customers to understand their business objectives, then developed suitable learning product solutions, and evangelize the SaaS LMS’s value proposition.
● Ideate, research, recommend, mock-up, and demo new digital learning products based on stakeholder business requirements.
● Gather stakeholder business requirements, prioritize features per product strategy, and refine into actionable user stories.
● Extract, transform, load, integrate, enrich, and QA application data across platforms for LMS product delivery
● Streamlined workflows by identifying bottlenecks in existing systems and implementing appropriate solutions.
● Consistently met tight deadlines while managing multiple projects simultaneously, prioritizing tasks effectively.
● Conducted regular post-launch content audits & site metrics analysis to present content gaps and redundancies to customers.
● Evaluated launched products’ usage data and user feedback to recommend product enhancements and future product roadmap initiatives, improving product management and future product quality.
● Enhanced team productivity by implementing agile methodologies, leading to more efficient project completion.
● Enhanced product quality by instituting rigorous quality control procedures, resulting in fewer customer complaints.
● Achieved significant cost savings by renegotiating contracts with key service vendors, without compromising cutting operational costs while maintaining product and service quality
● Organized professional development programs for staff, leading to improved performance and skill sets.
● Streamlined project delivery processes, significantly reducing time to market for new product launches.
● Recruited, interviewed, and hired employees; mentored junior team members for career advancement, fostering a pipeline of future leaders within the organization to promote positive feedback and engagement.
● Used industry expertise, customer service skills and analytical nature to design and recommend technical solutions to resolve customer concerns, address business needs, and promote loyalty.
● Maintained professional demeanor while troubleshooting customer pain points and recommending solutions.
● Developed detailed plans based on broad guidance and direction.
● Suggested and implemented product development and team management process improvements to cross-functional and customer stakeholders, improving efficiency and cutting production costs.
● Identified and communicated customer needs to professional service vendors and support teams
● Launched quality assurance practices for each phase of development Certifications & Education
Sisense / UX Dashboard Design Certificate
Feb 2022, REMOTE
General Assembly / Data Analytics Certificate
Apr 2021 - JUNE 2021, REMOTE
Learned and applied advanced analytics skills in Excel, SQL, and Tableau to novel data analytics projects using the data analytics framework to answer real business questions and make business recommendations. DataCamp / Certificates
2022: Intermediate Python
2021: Understanding Data Visualization, Understanding Data Science, Data Manipulation in SQL 2020: Data Science for Everyone, Data Visualization for Everyone, Joining Data in SQL, Intermediate SQL, Introduction to Python, Introduction to Data Science in Python
2019: Introduction to R, Introduction to SQL
TEFL Institute / TEFL/ESL Certification
2010, REMOTE
100 coursework hours / 20 practicum hours (Jewish Vocational Service - Chicago, IL) University of Kentucky / History, French
Contact this candidate