• Directed the strategic and operational data roadmap of the organization, guided the development of a responsible data culture, and influenced the growth of data understanding and use• Managed the Data Engineering team.  This included the maintenance and expansion of the existing data infrastructure and coordinating all data integration efforts with other engineering and analyst teams• Managed the Data Science team and their collaborative efforts with data analysts in marketing, product, and executive teams. Driving deeper insights into the business and influencing adoption of AI and ML driven/assisted reporting solutions• Ideated and launched a scalable, real time, data ingestion pipeline for the collection of data from hundreds of customer/vendor system integrations.  This initiative enabled the long term support of the rapid growth of the Provi customer base.• Influenced design and data ontology for new and existing engineering initiatives. Encouraging standardized integration, higher end to end data quality, and improved long term insights

• Owned high level solutions architecture for the data engineering team. This included leading reviews and approvals of all data pipeline and delivery designs and ensuring adherence to coding, scalability, and output quality standards.• Lead the Data Engineering Guild focusing on guiding the data engineering team towards a culture of engineering excellence. Focusing on various improvements to the teams development processes, code reviews, testing standards, ontology transparency, and support/maintenance procedures.• Founding Pillar member of GAIN (Glassdoor Asian American Impact Network). A DEI group focused on empowering the Pan-asian community towards positive impact growth, education, and alliance• Coordinated data integration projects with sister subsidiaries under the parent company. As the Primary Solutions Architect representing Glassdoor, I encouraged standardized, efficient, and performant integrations empowering large scale strategic value to all parties• Managed the in-depth evaluation of new technologies for functional fit, performance, and security compliance in accordance with Glassdoors existing tech-stack and policies• Established Snowflake implementation as the next iteration of performant and scalable data provision to the business and as a secure data processing environment. Architected the storage strategy, database security models and collaborated with SecOps for approval, and implementation of security integration with existing enterprise systems

• Managed the data engineering sub-team focused on business reporting efforts in support of Glassdoors Go-To-Market Teams [Sales, Marketing(Consumer + Enterprise)]. Supporting the rapid growth of the sales team, regularly changing forecasting/book adjustments in sales, and efficacy of marketing campaigns and spend.• Managed the Tableau administration team and oversaw development and maintenance of Tableau servers, storage, reports, and security model.• Ideated initial data governance project at Glassdoor. Launched initiatives for defining governance tenets, advocating for support, forming the approach, and prioritizing efforts.• Subject matter expert on and mentor for multiple key technologies/tools of the data engineering tech-stack. Areas of expertise included but was not limited to Singer.io, Custom airflow operators and constructs, Legacy SSIS ETL pipelines, SQL Server, Tableau report development and datasource performance.• Training and mentorship of the data engineering team in existing architecture, development practices, and new tech POCs

• Launched and maintained ETL/ELT pipelines, custom tools, external data integrations, reporting frameworks, and executive dashboards. Focusing on effective, trustworthy, and timely reporting of key data points used in strategic and tactical decision making across the enterprise• Lead teams through the planning and migration of existing pipelines and custom tools through various iterations of the data engineering tech stack• Collaboration with engineering, product, marketing, sales, and IT teams identifying opportunities for the data team to provide an optimal level of value to the business• Lead a team of up to 8 data engineers and scientists overseeing requirements gathering, development, and support of ELT pipelines

• Built Data Warehouse, ETL Architecture, and reporting from the ground up.• Vetted technical solutions for front and back end applications for performance and flexibility. Laid the foundation of the on-line flash sale application architecture• Acted as DBA and tech lead for a team of 8+ engineers. This included but was not limited to - Database setup, maintenance, tuning, and support - Training and collaboration of/with software engineering team focused on data modeling and SQL code development/reviews - Release process development and execution• Provided support for application issues. Partnering with the engineering team to determine impact and root cause for most application issues and assisting in code and data fixes.• Developed process and automated backend mechanism enabling configuration and data driven launch of marketing campaigns within the application. • Developed front end application replacing manual process of credit/return/discount performed by customer support team. Removal of the manual process was able to double the support ticket throughput of the the CSMs and eliminate manual involvement of engineering for account updates• Architected, and developed ETL processes (Including integration with third party data sources and tools where needed) in support of executive and departmental business reporting

Assumed the position of BI Engineer tasked with building a complete data warehouse and business intelligence structure from the ground up. Within a five month period, architected and implemented a completely open-source enterprise data warehouse. Subsequently implemented processes for more accurate user activity and application tracking enabling the company to adopt numbers-driven product development, analysis-based marketing strategies and informed executive directions. Throughout the current employment, daily activities included but were not limited to:• Acting as a senior member of a team focused on expanding the original open source data warehouse for more in-depth coverage and the adoption of analytics as part of the company-wide culture and mindset• Architecting, and developing ETL processes (Including integration with third party data sources and tools where needed)• Reporting design and development towards visual, behavioral and functional specifications• Development and deployment of dynamic and intuitive report delivery system• Key participant in efforts to prolong overall integrity and stability of application data• Business analysis and requirements gathering with all departments and levels across the enterprise• End user support and enhancement for all delivered reports and metrics• Training and mentoring incoming employees, off-shore assets, and interns on technical architecture, data definition, and business processes, as well as MySQL syntax, capabilities, and usage• Review of end results delivered by offshore teams for correctness and completeness• Performing DBA duties for engineering team• System administration for all data warehouse systems• Support of departmental analysts on ad hoc reporting development• Conversion and automation of legacy reporting systems to more reliable and up to date systems• Acting as backup for IT team in troubleshooting and resolution of various database, system, and operational issues

Accepted long term, contract in the eBusiness Division on the business intelligence team. The team was responsible for maintaining and expanding a large scale data warehouse and reporting environment that served more than 3500 users across the country. Acted as primary element of a fast paced, high throughput, analytics and reporting team that catered to multiple departments in various divisions in the company. The team’s efforts produced highly available, fast, flexible, and accurate reporting to various levels of upper and middle management. Examples of accomplishments and responsibilities included:• Created scalable, executive level, custom built, online reporting dashboards• Developed and supported complex, executive level reports and ETL stored procedures for multiple projects• Created multiple custom tools and applications to overcome technical limitations of existing applications• Technical lead for eBusiness applications and web based analytical reporting• Led teams of up to four through full project life-cycle of multiple reporting projects• Consulted with business and technical design teams on proper measurement of applications• Directed application development teams toward proper metric capture techniques• Analyzed and evaluated applications and emerging technologies ability to enhance existing data warehouse architecture• Trained end-users in the use of business intelligence and web analytics software• Supervised report development teams adherence to project deliverables and development standards • Troubleshot and debugged multiple legacy application modules and reports• Planned and executed successful upgrade of an enterprise level web analytics application

•Led team of four through multiple revisions of a complex web-based vehicle shopping application •Led team of three in the design, development, testing and deployment of a streamlined web-based vehicle configuration application, integrated with third party, custom built image handler•Revised automotive dealer locator and mapping application towards a more technically robust architecture

•Developed stored procedures and ETL modules for a customized, business intelligence application•Performed SQL Server database administration and stored procedure tuning/development •Tested and performance tuned final application

•Led team of six in the development of an account reconciliation application •Developed and tested back-end reconciliation modules written in Java •Performed Oracle database administration and stored procedure tuning/development •Completed development of application GUI using Visual Basic•Trained/mentored new team members on GUI and internal module development