Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

LYGIO IMMATTY JOY

Oxnard,CA

Summary

Seasoned data analytics and data quality engineer with a proven track record in leading and mentoring teams to achieve organizational goals. Expertise includes formulating migration strategies, data modeling, fostering collaboration, and promoting knowledge sharing. Excels in designing data systems and models, test strategies, collaborating with agile teams, identifying data quality concerns, and streamlining testing procedures. Demonstrates adaptability and versatility in managing multiple roles and navigating complex technical landscapes to consistently drive innovation and exceed customer expectations.

Overview

15
15
years of professional experience
1
1
Certification

Work History

SENIOR MANAGER, DATA ANALYTICS ENGINEERING

SONOS
10.2022 - Current
  • Successfully led and mentored a highly skilled and motivated team of data analytics engineers, fostering a collaborative and productive work environment
  • Developed and implemented a comprehensive modern data stack migration strategy, ensuring a smooth transition from legacy systems to a cutting-edge data infrastructure
  • Oversaw the successful migration of data systems from SQL Server to a modern data stack, significantly enhancing data accessibility and scalability
  • Conducted thorough analysis of current business processes, identifying areas for improvement and driving operational efficiencies
  • Collaborated effectively with technical peers and business users, fostering strong relationships and ensuring alignment with business objectives
  • Built a robust data product for the finance team, enabling accurate and efficient financial reporting and analysis
  • Supported the business in performing SEC reporting as a public company, ensuring compliance with regulatory requirements and providing timely and accurate financial information to stakeholders.

MANAGER, DATA ANALYTICS ENGINEERING AND DATA QUALITY

SONOS
03.2020 - 10.2022
  • Successfully led a small team of data analytics engineers, providing high-quality, reliable data to Sonos for informed decision-making
  • Developed and implemented an automation testing framework using Python and Jenkins, significantly improving the efficiency and scalability of the quality assurance process
  • Conducted thorough documentation and analysis of current business processes, including underlying systems and applications, ensuring a comprehensive understanding of the organization's data landscape
  • Communicated effectively with technical peers and business users, fostering collaboration and ensuring alignment with business goals
  • Performed root cause analysis of issues identified, prioritizing and resolving them promptly to minimize operational disruptions
  • Provided guidance and mentorship to the team, promoting the adoption of best engineering practices and continuous improvement in the development process
  • Collaborated with the DevOps team to ensure smooth production releases and effective error handling, maintaining high system availability and reliability.

SENIOR DATA QUALITY ENGINEER

SONOS
05.2014 - 03.2020
  • Led the design and development of a comprehensive test strategy for data quality and system integration validation, ensuring the accuracy and reliability of data
  • Defined and documented testing best practices for the team, establishing clear guidelines and standards for quality assurance
  • Performed manual testing by writing SQL scripts and developing SSIS packages, ensuring thorough validation of data integrity and consistency
  • Identified and documented data quality issues, working closely with stakeholders to suggest data cleansing strategies and improve data accuracy
  • Proposed and implemented ETL process improvements, enhancing the traceability of data from source to destination and streamlining data integration processes.

ETL QA ENGINEER

LYNDA.COM (NOW: LINKEDIN LEARNING)
09.2013 - 05.2014
  • Collaborated with agile team members to estimate testing efforts using the SCRUM methodology
  • Liaised with Developers, Project Managers, and Project Owners to achieve project milestones
  • Conducted a thorough analysis of ETL mapping requirements, modeling, and metadata documentation
  • Translated requirements into comprehensive test plans, detailed test cases, and intricate test SQL scripts
  • Created traceability matrices to ensure alignment between product requirements and test plans
  • Documented issues discovered during testing cycles accurately and consistently
  • Developed and executed robust test scripts
  • Utilized SQL to validate data as an integral part of the testing process
  • Built QVDs and QVWs for QlikView dashboard creation
  • Implemented Jira, a Scrum tool, to log bugs effectively
  • Conducted testing of SSIS Packages in BIDS as a component of ETL testing
  • Estimated test automation tasks efficiently and prioritized test automation activities.

QUALITY ANALYST

STRATEGIC SYSTEMS INC
08.2011 - 09.2013
  • Client: Redbox, Oakbrook Terrace, IL (Aug 2011- Sep 2013)

QUALITY ANALYST

IT AMERICA INC
05.2009 - 08.2011
  • Client: Redbox, Oakbrook Terrace, IL (Oct 2010- Aug 2011)
  • Client: Microsoft Corporation, Redmond, WA (Apr 2010 - Jun 2010)

Education

Master of Science (MS) degree in Electrical Engineering -

FLORIDA INTERNATIONAL UNIVERSITY
04.2009

Bachelor of Engineering (BE) degree in Electronics and Communication Engineering -

ANNA UNIVERSITY
05.2006

Skills

  • Data Warehousing/ ETL: Data Build Tool (DBT), SSIS, Boomi, Fivetran,Informatica, Snowflake, SQL Server
  • Business Intelligence: Tableau, QlikView, MicroStrategy, SSRS
  • Programming Languages: Python, SQL, T-SQL, C
  • DevOps Tools: Jenkins, Docker, GitActions
  • Issue Tracking and Collaboration: Jira, Confluence
  • Scheduling Tools: Airflow, SQL server agent
  • Strategic Planning
  • Cross-Functional Collaboration
  • Operations Management
  • Cross-functional Team Coordination
  • Documentation And Reporting
  • Troubleshooting and problem resolution
  • Cross-Functional Communication
  • Talent Development
  • Organizational improvement
  • Resource Allocation
  • Team Leadership
  • Problem-Solving
  • Process Improvement
  • Teamwork and Collaboration
  • Project Planning
  • Decision-Making
  • Work Planning and Prioritization
  • Employee Development
  • Employee Coaching and Mentoring
  • Performance Tracking and Evaluation
  • Performance reviewing
  • Onboarding and Orientation

Certification

Certified Scrum Master

Timeline

SENIOR MANAGER, DATA ANALYTICS ENGINEERING

SONOS
10.2022 - Current

MANAGER, DATA ANALYTICS ENGINEERING AND DATA QUALITY

SONOS
03.2020 - 10.2022

SENIOR DATA QUALITY ENGINEER

SONOS
05.2014 - 03.2020

ETL QA ENGINEER

LYNDA.COM (NOW: LINKEDIN LEARNING)
09.2013 - 05.2014

QUALITY ANALYST

STRATEGIC SYSTEMS INC
08.2011 - 09.2013

QUALITY ANALYST

IT AMERICA INC
05.2009 - 08.2011

Master of Science (MS) degree in Electrical Engineering -

FLORIDA INTERNATIONAL UNIVERSITY

Bachelor of Engineering (BE) degree in Electronics and Communication Engineering -

ANNA UNIVERSITY
LYGIO IMMATTY JOY