Andrea D'Vaz

I am a Data Analyst with 4 years of experience, specializing in Big Data, Extract Transform Load (ETL) Process, Data Warehousing, and Data Analytics. I have a strong technical background that enables me to deliver data-driven solutions and provide valuable insights. Throughout my career, I have successfully developed and maintained ETL pipelines. My expertise includes working with Informatica. I have experience with creating Power BI dashboards, optimized SQL processes, and collaborated with cross-functional teams to implement resilient solutions.

At McKinsey & Company, I developed a Power BI dashboard that improved customer value by 10% by identifying bottlenecks in the client's ecosystem. I also optimized a client deliverable job runtime by 30% through SQL optimization. Additionally, I supervised and upgraded ETL pipelines, implemented business requirements, and generated insights from large volumes of data using PL/SQL.

During my tenure at Infosys Limited, I developed an ETL pipeline that increased the client's customer base by 15%. I designed ETL pipeline architecture using Informatica PowerCenter and Unix Scripts, implemented Slowly Changing Dimensions (SCD) Type II, and created impactful Power BI dashboards for data reporting. I also provided on-call support, collaborated with Business Analysts, and volunteered in live production fixes.