Learn Data Skills
Keith Mascarenhas

Keith Mascarenhas

Data Engineering

DataGeekInMe

Technologies

Data Enthusiast! | Passion for Learning | Data Engineering | Big Data

My Work

Take a look at my latest work.

project

Exploring London's Travel Network

SQLBigQuery
project

Exploring London's Travel Network

SQLBigQuery

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Product School Product Manager Certification

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Data
Communicating Data Insights

My Work Experience

Where I've interned and worked during my career.

Unity | Aug 2021 - Present

Manager, Data Engineering

☛ Designed and implemented data models and pipelines that accurately tracked monthly active users, seat utilization, revenue, and user segmentation for Unity's Create business ☛ Managed a 6-member data engineering team, overseeing the development of a low-code data pipeline framework that streamlined data processing and enhanced team productivity ☛ In the capacity of a part-time product manager, pioneered a low-code pipeline framework and Data LakeHouse vision at Unity Ads, leveraging modern open-source tools. ☛ Streamlined the development of data pipelines, optimized data flow and lifecycle management, and enhanced data observability and incident management while curbing costs. ☛ Enabled various data teams across Unity Ads to deliver reliable internal stakeholder and customer-facing reporting data models using the pipeline framework and data architecture ☛ Conducted talent interviews, orchestrated successful onboarding of new team members, and fostered continuous growth through impactful feedback conversations and performance reviews ☛ Mentored and guided interns and junior data engineers, equipping them with valuable insights into data engineering principles and exposure to a variety of open-source data stack technologies ☛ Led agile execution by meticulously managing backlog grooming, capacity planning, and seamless alignment of sprint deliverables with overarching product management objectives
Show More

Atlassian | Sep 2018 - Aug 2021

Lead, Data Engineering

☛ Led an 11-member data engineering team across 2 geographies, overseeing multiple initiatives and driving execution following agile principles ☛ Spearheaded MAU reporting to Wall Street with multi-granularity data models and pipelines, encompassing Daily, Weekly, and Monthly Active Users, along with user segmentation ☛ Spearheaded PEU reporting, delivering a rapid prototype for Jira and Confluence products, and building a pipeline aligned with company OKRs. Collaborated with acquired products for data integration and partnered with analytics to present the metric to Wall Street ☛ Led NER (Net Expansion Rate) reporting, delivering data model and pipeline to Wall Street by partnering with Analytics and Investor Relations ☛ Led the development of an extendable attribution framework and data model, to help measure the impact of Marketing, Growth, Product, and Migrations teams on revenue growth. ☛ Leading the development of forecasting pipeline framework using Apache Airflow and Databricks. ☛ Partnering with analytics and FP&A for standardized Level 1 metric forecasting. ☛ Successfully led the team in developing comprehensive Data Models and pipelines for precise reporting of L2 (Dept/Business) and L3 (Team) metrics for Confluence and Enterprise and Ecosystem Products ☛ Standardized the incident management and on-call pipeline framework for Level 1 metrics within the organization ☛ Conducted interviews and successfully onboarded talent, expanding the team from 3 to 12 members within a 2-year timeframe

Unifi Software | Jan 2016 - Aug 2018

Principal Implementation Engineer

☛ Provided big data solutions to clients in Media, Manufacturing, Healthcare/ Insurance, and Banking/Financial Services domains using Unifi as a data preparation tool on various Big data distribution platforms ☛ Built a customer 360 for a banking/financial services client, resulting in a CRM system with $2.5 million year-over-year income tied to its functionality ☛ Integrated 46 ERP data sources using Unifi in a Cloudera Enterprise Data Hub cluster, enabling revenue and gross margin reporting for a global manufacturing company ☛ Helped Unifi explore strategic and OEM partnership opportunities with Tableau and Adobe by working with product and engineering on integrating Unifi product capabilities with the strategic partners ☛ Certified Unifi's compatibility on managed big data platforms like Azure Insight and Amazon EMR Collaborated with sales, product management, and engineering teams to assist with pre-sales proof-of-concepts and incorporate customer requirements into the product ☛ Led installation and configuration of Cloudera CDH, Hortonworks HDP, and Azure HDInsight using automated templates, alongside developing utilities to enhance Unifi's functionalities and expertly troubleshooting cluster issues to ensure peak performance of Unifi as the data transformation engine ☛ Managed the recruitment process, conducted interviews, and mentored a group of interns, transitioning them into full-time Data Analyst positions

KPI Partners | Mar 2011 - Jan 2016

Principal Consultant

☛ Implemented data warehousing and business intelligence solutions for diverse sectors like Technology and Healthcare, leveraging transactional applications like Oracle e-Business Suite, Siebel, and legacy systems. ☛ Deployed analytics solutions for Supply Chain and Order Management, Sales, Human Resources, Procurement and Spend, Forecasting, Point of Sales, Incentive Compensation, Service Contracts, and Customer Technical Support ☛ Collaborated with Business Users and Business Analysts to gather functional requirements and translate them into optimal technical solutions using dimensional modeling techniques ☛ Installed, configured, and administered Oracle Business Intelligence Applications and Tableau Server, gaining expertise in OBIA, OBIEE, and OWB upgrades ☛ Built interfaces, mappings, and dimensional metadata using ETL/ELT tools, applying performance-tuning techniques across the database, ETL, and reporting layers ☛ Authored blog articles on data integration tools like Oracle Data Integrator (ODI) and Oracle GoldenGate (OGG), sharing insights and expertise with the community ☛ Conducted interviews for senior-level positions, evaluating candidates' qualifications and suitability for various clients ☛ Led multiple project teams simultaneously for BI Applications implementations, providing mentorship to entry-level engineers and conducting performance reviews for team members

Invenger Technologies, Inc | May 2007 - Mar 2011

Lead Analyst

☛ Collaborated with stakeholders to align technical solutions with business requirements in the Insurance Sector, ensuring effective utilization of Legacy and Siebel source systems ☛ Developed optimized dimensional modeling techniques, empowering business analysts and users with efficient ad hoc reporting capabilities ☛ Led and coordinated multiple teams, ensuring seamless project execution and timely delivery of concurrent maintenance projects ☛ Conducted performance reviews, fostering a culture of growth and development within the team ☛ Built robust interfaces and mappings using ETL/ELT tools, optimizing dimensional metadata and enhancing performance across the database, ETL, and reporting layers ☛ Implemented OLAP cubes using Cognos PowerPlay Transformer for comprehensive Customer Satisfaction Survey analysis ☛ Acted as a subject-matter expert in Customer Survey Technical aspects, providing valuable insights and expertise ☛ Conducted code and documentation reviews, enforcing quality standards and facilitating smooth code migration ☛ Provided support to the Testing team, ensuring comprehensive test coverage and timely defect resolution ☛ Mentored and trained entry-level engineers in data warehousing fundamentals, SQL, and PL/SQL

My Education

Take a look at my formal education

Bachelor of Engineering - BE, Computer Science and EngineeringVisvesvaraya Technological University | 2005
High School Diploma, PCMESt. Aloysius College, Mangalore-575003 | 2001

About Me

Keith Mascarenhas

A huge data enthusiast!

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free