Angela Sony

• Responsible for generating daily operational reports on unit occupancy, lease renewals, collections, and vacant units using Excel and Power BI. • Actively contributed to the migration of financial and leasing data from PACT ERP to YARDI, ensuring structural compatibility and data integrity. • Conducted data extraction, transformation, and mapping from PACT ERP to YARDI modules for seamless migration and reporting continuity. Streamlined reporting workflows, reducing manual errors and turnaround time by over 40%. • Ensured data consistency, integrity, and compliance across daily and migration-related datasets. • Built validation templates and audit reports to cross-check migrated data from PACT ERP with live YARDI entries. • Ensured accuracy and consistency of historical records by reconciling PACT ERP data with migrated outputs. • Cross-departmental collaboration with Leasing, Finance, Property Management, Facility Management, and IT teams for lease tracking, rent reconciliation, unit occupancy, asset monitoring, and ERP integration.

Designed and deployed ETL pipelines using Azure Data Factory, automating and optimizing large-scale data workflows. • Implemented Unity Catalog to ensure secure data governance and compliance across global teams. • Designed and developed interactive Power BI dashboards for real-time data visualization and business intelligence. • Developed and maintained custom Power Apps, streamlining business workflows and improving productivity. • Collaborated with cross-functional teams to design scalable architectures using Azure Databricks, enhancing analytics workflows. • Consolidated data from multiple sources into Azure Data Lake Storage (ADLS), ensuring data accessibility and availability. • Utilized Jira Dashboards to track deliverables, prioritize tasks, and ensure on-time sprint completion in Agile methodologies. • Conducted rigorous testing, deployment, and monitoring of Unity Catalog Frameworks, fostering data security and seamless team collaboration. • Part of a successful migration project of business-critical data from outdated SQL systems to IBM Maximo Application Suite using Talend, achieving exceptional data accuracy. • Architected and implemented comprehensive ETL workflows that ensured seamless data integration and scalability across pipelines. • Enhanced system performance by optimizing SQL query execution times and refining ETL processes, reducing downtime by 40%. • Project logistics was managed through Azure DevOps, ensuring efficiency in task management and timely execution. • Implementation of automated validation mechanisms, upholding data integrity and compliance throughout the migration process. • Automated validation mechanisms, upholding data integrity and compliance throughout the migration process. • Delivered scalable pipeline solutions, providing actionable insights and analytics for informed decision-making. • Analyzed competitor strategies to support the development of effective business development approaches