Tizu Biru
Alexandria,VA
Summary
Professional with strong analytical and problem-solving skills, well-versed in data modeling, SQL, and ETL processes. Drive impactful insights through data visualization tools like Power BI and Tableau. Reliable team player focused on collaboration and delivering results, adaptable to changing project requirements. Excel in turning complex data into actionable business strategies.
Overview
8
8
years of professional experience
Work History
Database and BI Developer
Allstate Corporation
09.2023 - Current
- Developed dynamic and interactive Power BI dashboards and reports, delivering real-time insights for improved decision-making by monitoring key performance indicators (KPIs).
- Designed and integrated advanced data models, consolidating information from SQL Server and cloud platforms to provide a unified view of business metrics.
- Optimized database performance and improved query execution times, enhancing data retrieval efficiency by refining SQL queries.
- Streamlined data extraction and transformation processes using Power Query reducing manual reporting efforts and increasing data accuracy.
- Collaborated with stakeholders to gather business requirements, translating them into effective BI solutions that align with organizational objectives.
- Build data models (star, snowflake, normalized) to support analytics and reporting
- Translate raw data into meaningful insights and visual stories for stakeholders
- Established data governance practices, incorporating role-based access control (RBAC) and encryption protocols to ensure data accuracy, security, and compliance.
- Developed and delivered comprehensive training programs and documentation to support the effective use of Power BI tools, driving smooth adoption across teams.
- Managed and optimized ETL processes using SSIS and Talend, ensuring accurate data flow and seamless reporting.
- Integrated diverse data sources, including CSV files, Excel, SharePoint lists, and external databases, to enable comprehensive analytics and reporting.
- Built scalable data pipelines using Azure Data Factory, improving data processing efficiency and enabling timely reporting.
- Led BI projects using agile methodologies, coordinating with cross-functional teams through JIRA and GitHub for efficient project management and version control.
- Applied best practices in data security and compliance, ensuring the protection of sensitive information and adherence to organizational standards.
- Delivered actionable insights through detailed data analysis and reporting, empowering strategic decision-making and driving operational improvements.
- Design, develop, and maintain relational and non-relational databases based on business requirements
- Write and optimize complex SQL queries, stored procedures, views, functions, and triggers
- Environment: Power BI, Power Query, SQL Server, SSIS, Talend, CSV, Excel, SharePoint lists.
Data Analyst/Power BI Developer
Mastercard Incorporated
03.2019 - 08.2023
- Created advanced visualizations and custom reports in Power BI Desktop and Power BI Service, providing real-time insights and promoting team collaboration.
- Designed and developed interactive Power BI dashboards and reports, integrating data from sources like CSV, Excel, SharePoint lists, and external databases to enhance business decision-making.
- Leveraged Power Query for efficient data preparation and transformation, optimizing workflows and boosting reporting accuracy.
- Managed and fine-tuned complex SQL Server queries to ensure high data accuracy and performance.
- Executed ETL processes using SSIS and Talend, ensuring data integrity across relational databases and maintaining consistent reporting.
- Built and maintained data warehousing solutions using Azure Data Factory, enabling smooth data flow and reliable reporting.
- Utilized advanced Excel functions, including pivot tables, macros, and complex formulas, for effective data manipulation and detailed reporting.
- Implemented scalable data pipelines, integrating data from Oracle and cloud platforms like Azure SQL Database for robust analytics and comprehensive reporting.
- Automated data integration processes, ensuring stakeholders receive accurate and timely data for informed decision-making.
- Established data security protocols, including role-based access control (RBAC) and encryption, to safeguard sensitive information and ensure compliance with standards.
- Employed data governance tools like Collibra and Talend Data Quality to maintain high data integrity and regulatory compliance.
- Streamlined data preparation and visualization processes, significantly improving workflow efficiency and reporting accuracy through automation.
- Build interactive dashboards and visually engaging reports in Power BI
- Customize visuals using Power BI themes, bookmarks, filters, slicers, and drill-throughs
- Conduct exploratory data analysis to identify trends, correlations, and anomalies
- Translate findings into actionable business insights and recommendations
- Environment: Power BI Desktop, Power BI Service, Power Query, SQL Server, SSIS, Talend, Azure Data Factory, Excel
Database /ETL Developer
Citigroup Inc.
09.2017 - 02.2019
- Crafted intricate SQL queries and stored procedures, delivering powerful solutions for data retrieval and reporting.
- Led the management and optimization of SQL Server databases, focusing on enhancing performance and maintaining data accuracy and integrity.
- Designed robust data warehousing frameworks using Azure Data Factory, ensuring efficient data flow and consistent reporting.
- Handled ETL processes with SSIS and Talend, supporting seamless data integration and preserving data quality across systems.
- Streamlined data operations by automating extraction, transformation, and loading tasks using advanced SQL techniques, resulting in more efficient workflows.
- Built scalable pipelines to aggregate and integrate data from various sources like CSV, Excel, SharePoint and cloud environments such as Azure SQL Database
- Implemented strict data governance protocols, including role-based access control (RBAC) and encryption, to secure sensitive data and maintain compliance.
- Engaged closely with stakeholders to capture requirements and translate them into optimized SQL-based solutions that align with business goals.
- Created detailed documentation and conducted training sessions to ensure effective adoption and maintenance of SQL processes and database systems.
- Utilized SQL Server features to monitor and fine-tune database performance, ensuring reliability and consistent operation across the organization.
Education
Bachelor's -
Skills
- Data Analysis & Reporting: Power BI, interactive dashboards, custom visualizations
- Database Technologies: SQL Server, Azure SQL Database, data integration, ETL processes (SSIS, Talend)
- Data Integration: live connections to CSV, Excel, SharePoint lists, external databases
- Data Security & Compliance: Implementing RBAC, encryption, data governance tools like Collibra, Talend Data Quality
- KPI Design, Executive Dashboards, and Self-Service Enablement
- Skilled in query optimization, indexing strategies, and analyzing execution plans
- Advanced in writing complex SQL queries, stored procedures, triggers, views, and functions
- Expertise in designing normalized and demoralized schemas, ER diagrams, and data models
Timeline
Database and BI Developer
Allstate Corporation
09.2023 - Current
Data Analyst/Power BI Developer
Mastercard Incorporated
03.2019 - 08.2023
Database /ETL Developer
Citigroup Inc.
09.2017 - 02.2019
Bachelor's -
Similar Profiles
Karen Hernandez-RamosKaren Hernandez-Ramos
Licensed Insurance Agent at Allstate CorporationLicensed Insurance Agent at Allstate Corporation
M A Y A D A G AM A Y A D A G A
Liability Adjuster at The Allstate Corporation [Insurance company]Liability Adjuster at The Allstate Corporation [Insurance company]
Jayasimha GJayasimha G
AVP, Senior Java Developer at State Street CorporationAVP, Senior Java Developer at State Street Corporation
Jabari NeddJabari Nedd
Linux System Administrator (contract) at Army National GuardLinux System Administrator (contract) at Army National Guard
Alyson NashAlyson Nash
Director of Business Development at Price ModernDirector of Business Development at Price Modern