Monica Alla

Data Analysis & Reporting:

• Conducted in-depth data analysis to provide actionable insights for strategic decision-making.
• Redesigned and optimized reports using Power BI, retrieving and aggregating data from Azure SQL Database using T-SQL.
• Developed and maintained interactive dashboards to monitor key performance indicators (KPIs).
• Created data visualizations using Power BI and Excel for data storytelling.

Data Engineering & ETL:

• Utilized Azure Data Factory for ETL (extract, transform, load) of insurance data, ensuring seamless system integration.
• Wrote T-SQL queries to clean and validate data during the transformation process.
• Developed and optimized T-SQL stored procedures and views to improve data retrieval performance.
• Analyzed and optimized existing workflows to improve data integration and reporting efficiency.

Project Management & Collaboration:

• Managed the migration of business operations by collaborating with stakeholders, ensuring clear communication and project goal alignment.
• Gathered requirements and performed gap analysis to identify system discrepancies, proposing actionable solutions.
• Managed project tasks and provided updates using Azure DevOps in an Agile sprint environment.

Documentation & Process Improvement:

• Created comprehensive documentation for migrated systems, processes, and reports, including process maps and data models.

Data Analysis & Reporting:

• Collected, transformed, and analyzed large datasets from diverse sources using Power BI and Azure SQL.
• Developed and maintained user-friendly Power BI reports and dashboards to support data-driven decision-making.
• Wrote efficient SQL queries for data retrieval and manipulation, enhancing database performance.
• Created and managed database structures, including tables and views, to ensure data integrity.
• Identified and resolved data errors to maintain data accuracy.
• Translated business requirements into clear report specifications.
• Presented data insights through clear and concise reports and presentations.

Data Engineering & Automation:

• Automated data processes using Azure Data Factory, streamlining data movement and transformation.
• Utilized Azure Synapse to enhance data integration and warehousing capabilities.
• Collaborated with stakeholders to define and address data requirements.

Data Analysis & Reporting:

• Extracted, transformed, and analyzed large datasets using Power BI, Azure SQL, and Google BigQuery.
• Developed and maintained interactive dashboards and reports using Power BI and Google Data Studio.
• Utilized DAX functions in Power BI for advanced queries and calculations.
• Wrote SQL queries for efficient data retrieval and manipulation.
• Analyzed and extracted insights from large datasets using Google BigQuery.
• Identified and resolved data inconsistencies and errors, ensuring data integrity.
• Translated business requirements into technical specifications for data solutions.
• Communicated data findings and insights through reports and presentations.
• Built and maintained data models to support sales and marketing analysis.

Data Engineering & Automation:

• Established and managed database structures, including tables, views, indexes, and stored procedures.
• Developed POCs using Azure Data Factory to automate data workflows (ingestion, transformation, and movement).
• Collaborated with stakeholders to define and deliver data-driven solutions using Power BI, Azure SQL, and Python scripts.

Data Analysis & Transformation:

• Analyzed, cleaned, and transformed data to ensure accurate calculations.
• Performed financial data analysis and forecasting, contributing to financial planning and cost optimization.
• Conducted data validation, integrity, and checks for successful SQL Server migration from on-premises to AWS Cloud.
• Wrote and executed T-SQL queries, modifying stored procedures based on business requirements.
• Collaborated with stakeholders to deliver end-to-end data solutions.
• Automated data transformation, business logic execution, and reporting using Python.
• Gathered requirements, performed data analysis, developed solutions, and managed implementation, testing, and configuration.
• Wrote queries to test and analyze databases in QA environments.
• Created custom triggers and stored procedures based on business specifications.
• Documented and implemented business specifications from data review meetings.

Data Quality & Operations:

• Performed smoke testing after data loading and conducted data integrity checks.
• Debugged and tested triggers to ensure they met specifications.
• Provided post-launch (Go Live) support to new stakeholders, ensuring smooth transitions.
• Resolved data issues raised by the business, validated data, and published Power BI reports.
• Utilized version control (GITea) to maintain source code.
• Performed database activities, including creating and altering tables and views.
• Conducted peer code reviews.
• Prepared technical documentation and gathered requirements from stakeholders.
• Supported operational processes for data refreshes on global projects.
• Monitored daily Jenkins jobs and deployments.