Damian A. Perreira
San Diego,CA
Summary
As a Lead Software Engineer (BI) at EPAM Systems, I have over 15 years of experience in designing, developing, and implementing data-driven solutions for various clients and industries. For the last 4 years, I have been assigned to Meta, working with business partners and IT to define and drive the BI roadmap, develop KPIs, and deliver scalable analytics solutions.
Strong background in SQL and Python programming, providing ETL and analytic capabilities for large and complex data sets. Also proficient in multiple business intelligence tools, such as Tableau, Power BI, Azure, and Oracle BI, generating reports and presentations that provide insights and recommendations for data-driven decision-making. Successfully led and managed IT teams in support of financial services, procurement, marketing, and operations, and have demonstrated the ability to apply software technology to design and improve data solutions and processes.
Overview
14
14
years of professional experience
1
1
Certification
Work History
data engineer
- As the data Engineer and Analyst I develop data sets and dashboard tools to support decision making and management of multiple key projects within Meta, using SQL and python, I am responsible for full execution of these solutions, from requirement collection and validation to data engineering, visualization and workflow automation
- I’ve developed dashboard tools combining many business areas such as call center CRMS data, Data Center Operations, Workforce Management, Vendor engagement, finance data (PO, AP, and AR in general), EBS, and more
- As the lead of a team of six data engineers driving the execution of high-priority analytics projects, develop tactical approaches and manage BI analyst and data engineering work streams, engaging with multiple key stakeholders on prioritization, estimation of effort and adjusting course where needed as business priorities evolve
- Develop and make recommendations about methods to collect and analyze data
- Provide documentation for user training, and conduct kick-offs and release presentations of the developed tools.
Lead Software Data Engineer – BI
EPAM Systems, Meta
02.2019 - Current
- First three years as a DE I worked building and enriching data models, dimensions, aggregations, and conforming disparate data eco-systems to build a set of widely adopted dashboards and reports using Hive, Presto SQL, Tableau, and other proprietary tools similar to Jupiter notebooks, Apache Airflow and more
- Worked on various metrics such as financial PO and Invoicing, DC operations, incident response analytics such as time to resolution, headcount, learning and development, dashboard pipeline health, and more
- Recently took on the lead role, I use my creativity and experience to influence positive change, supporting and improving the development, delivery, and continuous improvement of our data-based tooling and workflows which support decision making in many pillars of our organization
- My team develops owns and supports a set of the most widely used ETL, databases, and dashboards in many cross functional teams within Meta IDC
- Previous to Meta my short assignment at APPLE, Inc
- Was in a similar Data Engineering & Dashboard development role within Siri Labs QE team analyzing and reporting QE test results from raw data.
Operations Senior Data Analyst
Cross Country Home Services
06.2018 - 01.2019
- Analyzes prepares, and reports on all business operational KPI, as well as marketing (OPS Dashboards, Claims AP, Marketing campaign performance metrics)
- Leads and executes process and data improvement projects using SQL, data mining/modeling and various data analysis platforms
- Assists all levels of management in the preparation of internal business review and presentation (actual vs budget, forecast and prior year)
- Performs deep-dive analysis of claims data to identify and report challenges, risks and opportunities
- Partner with IT Business Intelligence to review forward looking projects reporting needs related to the BI data warehouse
- Develop tools to assist with managing the business
- Perform routine, ad hoc analysis and reporting for month-end process, including variance explanations
- Contributes to streamlining efficiency across the organization by automating and/or eliminating reporting as the business needs evolve.
OBIEE Developer – BI Team Lead
Cross Country Home Services
03.2012 - 06.2018
- Collaborate with stakeholders and leadership in planning and prioritization of BI projects, coordinate execution of programs between cross functional teams, develop tactical approaches to addressing BI development and analysis request backlogs, and manage analyst and developer work streams
- Reviewed and analyzed data requests and reporting needs to define and document data model requirements, validation plan, and resource needs
- Work closely with the Project Champions, Management team, Development team, Training and Ops teams
- Monitor and ensure accurate and on-time delivery of data feeds and reporting on a daily basis
- Work closely with sales, operations and marketing teams on data needs to support and manage new business initiatives as well a administer existing reporting systems, automation and dashboards
- Collaborate with internal stakeholders to understand changing business data needs and technical requirements
- Experienced in performing product gap analysis and defining a specified customization scope to enhance capabilities from OBI metadata (RPD), OBI presentation layer to facilitate analysis and dashboard development
- Customized prebuilt dashboards and reports, Oracle Business Analytics Warehouse metadata objects, and web catalog objects
- Performed transformation of oracle discoverer rpt files in to OBIEE reports.
Operations Data Analyst
Cross Country Home Services
05.2009 - 03.2012
- Responsible for developing, administering and supporting Claims Cost reporting at all levels of the organization
- Supporting role and SME in all claims cost reduction initiatives
- Performed product gap analysis working with functional and technical leads in IT, SME’s, marketing, finance, and other business groups to identify, analyze, and document business requirements
- Created and Administered the Claims Cost Reporting Database
- Using OBIA I was able to improve claims cost analytics by developing interactive Dashboards/Reports, drilldowns, drill-across & drillable charts, and automation which was not supported in the legacy tool
- Configured IBots to deliver Analytics as well as automating functions
- Performed the Security management at the catalog level for users, groups and using BI catalog tools
- Performed testing and data validation in multiple projects across multiple areas of the organization
- Developed reporting and enhanced existing reporting modules in Oracle Discoverer
- Assisted the OBIEE Data architect in the data modeling of our claims and contracts subject areas, performed testing, and validation of the resulting model, and developed reporting and dashboards
- Developed ad-hoc reporting using Oracle Discoverer, SQL Developer and also Toad 9.1, 10.5 and 2018.1
- 2
Education
Azure Data Fundamentals - Data Cloud Tools
Microsoft Certified
08.2023
Data Analytics - Data Processing Technology
UC BerkeleyExtension
Berkeley, CA03.2020
Certified Tableau Desktop Specialist - Data Visualization
Tableau Certification
07.2019
Business Analytics For Data-Driven Decision Making - Data Analytics
BUx (Boston University Edx-Online)
EdX11.2018
Skills
- Technical Skills Summary:
- Hive, Presto, Azure, SQL, Python, Tableau, Power BI, Apache Airflow, Oracle
- SQL Expertise: Proficient in crafting complex queries, data manipulation, and optimization
- Business Intelligence Dashboarding: Proficient in creating and maintaining dashboards using tools like Tableau, Power BI, also briefly working in Looker and Domo
- Data Engineering: Expertise in sourcing, transforming, and integrating comprehensive data sets from multiple sources to support data science projects, dashboards, and reporting tools
- Project Leadership: Demonstrated ability to lead full-stack teams and align projects with business objectives
- Communication: Proven capability to articulate data-driven narratives to both technical and business audiences
Certification
- [Area of certification] Training - [Timeframe]
- [Area of certification], [Company Name] - [Timeframe]
- Licensed [Job Title] - [Timeframe]
- [Area of expertise] License - [Timeframe]
- Certified [Job Title], [Company Name] - [Timeframe]
Languages
English
Native or Bilingual
Spanish
Native or Bilingual
Portuguese
Limited Working
Timeline
Lead Software Data Engineer – BI
EPAM Systems, Meta
02.2019 - Current
Operations Senior Data Analyst
Cross Country Home Services
06.2018 - 01.2019
OBIEE Developer – BI Team Lead
Cross Country Home Services
03.2012 - 06.2018
Operations Data Analyst
Cross Country Home Services
05.2009 - 03.2012
data engineer
Azure Data Fundamentals - Data Cloud Tools
Microsoft Certified
Data Analytics - Data Processing Technology
UC BerkeleyExtension
Certified Tableau Desktop Specialist - Data Visualization
Tableau Certification
Business Analytics For Data-Driven Decision Making - Data Analytics
BUx (Boston University Edx-Online)