Achievements:• Successfully optimized the AWS EMR cluster for Snowplow's RDB Transformer, resulting in an average 35% cost reduction.• Integrating dbt (data build tool) into ETL / ELT processes significantly reduces the team's workload in supporting pipelines.

Achievements:• Enhanced ETL code, achieving 5x faster data integration with minimal errors.• Upgraded ETL pipeline for 12x more frequent data updates and under 2-hour BI delivery.• Optimized top-used data marts, reducing query times by 50-75%.Responsibilities:• Selecting and defining the optimal architecture for BI systems, focusing on scalable, efficient solutions that align with organizational data goals and user requirements.• Developing ETL pipelines and data marts using Airflow & dbt.• Developing reports and dashboards using Looker.• Interviewing stakeholders to formalize business needs in the requirements documentation.

Achievements:Developed comprehensive demo materials for presenting the in-development BI system Platform V SDP Analytics to potential clients, which included ETL procedures for parsing data from open sources. This involved preparing data marts and dashboards from these sources, demonstrating the system's capabilities in data integration and visualization.Responsibilities:• Strategically setting priorities and tasks for the product development team to foster continuous enhancement of the BI system.• Designing, implementing, and optimizing ETL procedures with Apache Airflow, ensuring efficient data flow and management.• Developing and maintaining data marts using PostgreSQL, with a focus on data accuracy, consistency, and integrity.• Crafting user-friendly, interactive dashboards using Apache Superset to visualize data and aid business decision-making.

Achievements: • Successfully implemented Power BI Service, playing a key role in DWH development.• Established automated data processing using Power BI Service, Power Automate, Airflow, and Clickhouse.Responsibilities:• Streamlined and enhanced data sets from diverse sources for optimal utilization.• Developed and managed interactive dashboards for key stakeholders including finance, operations, leadership team, and shareholders.• Maintained high standards of data quality and utilized BI analytics for insightful reporting.• Trained and mentored junior BI analysts, fostering a culture of continuous learning and improvement.

Achievements: • Successfully implemented Power BI Reports as a BI analytics tool.• Established automated data processing using Power BI Report Server & SSRSResponsibilities:• Regularly prepared and presented reports for external and internal clients, automating data collection and processing from the 4IT ITSM system, specifically on data center infrastructure usage. Utilized Excel, VBA, Power Query, PowerPoint, and Power BI for data transformation and report generation.• Managed service support for external customers, ensuring satisfaction and business continuity.• Resolved external customer service complaints efficiently, focusing on customer retention and satisfaction.• Involved in pre-sales activities, including creating Excel templates for service billing to enhance invoicing processes.• Monitored service levels and contractual commitments to ensure compliance and superior service delivery.