Data Analyst Real Estate

Sumiyasuren Jamiyan (Sonya)

Skokie, IL ***** • 317-***-**** • ************@*****.*** • linkedin.com/in/sumiyasuren-jamiyan-bs/

SUMMARY

Highly experienced Data Analyst with over 7 years in analyzing complex data sets and crafting data-driven strategies to drive business performance. Demonstrated success in delivering actionable insights that shape key business decisions and streamline processes to enhance operational efficiency. Adept at utilizing SQL, Python, Tableau, and GIS tools to deliver actionable insights and enhance business performance.

SKILLS

Management: Agile and Waterfall methodologies

Languages: Python (Pandas, NumPy), SQL

Frameworks: Pandas, NumPy, SciPy, Matplotlib

Tools: Excel, Tableau, Power BI, MySQL, ETL processes, and SSIS, SSMS and DBEAVER

Platforms: Jupiter Notebook, Visual Studio Code

Soft skills: Rapport building, Strong Stakeholder management, People management, Excellent communication

PROJECTS

Small Business Administration (SBA) loan dataset Analysis

Dec/2024

•Led the creation of an efficient data processing framework, automating processes with Python, SQL, and Excel to enhance workflow.

•Partnered with cross-functional teams to develop statistical models for rick projection, boosting accuracy with advanced regression methods.

•Created user-friendly Tableau comprehensive dashboards for stakeholders, improving report usage and decision-making effectiveness by 20%.

Real Estate Data for Market Insights Analysis

Jul/2023

•Analyzed real estate market trends using SQL, Excel, and Tableau to provide actionable insights on property values, rental rates, and market demand, improving investment decision-making by 15%.

•Conducted data validation and cleaning for large datasets using Python containing property sales, demographics, and economic indicators, ensuring 98% accuracy in reports and analytics.

•Built interactive dashboards to visualize key metrics, such as price per square foot, property sales volume, and absorption rates, enabling executives to identify emerging market opportunities.

COVID-19 Patient Characteristics and Outcomes Analysis

May/2021

•Cleansed and preprocessed 1M+ rows using Pandas in Python to prepare data for analysis and gain insights on patients' performance, resulting in a 25% reduction in data processing time.

•Analyzed patients' performance utilizing SQL queries to derive meaningful insights from the COVID dataset on gender distribution, age groups, pregnant patients, patients with specific conditions.

•Interpreted trends in 2 complex data sets by finding correlations between them and visualizing the results using SQL and Tableau.

WORK EXPERIENCE

Data Analyst (contract through Byte2AI)

Atlantic union bank

June/2022 – present

Atlantic Union Bank offers personal and business banking solutions including loans, mortgages, credit cards, and online banking. The Bank enhanced their Fiserv Signature Core Banking Software using DB2 data management product. The enhanced mortgage platform lending space will channelize and Empower/Loan Sphere for retail and direct channel. Home equity loans are also routed to Empower in future.

•Retrieved data from the data warehouse and used the data to create insightful reports and analyses.

•Worked on user defined stored procedure PL/SQL Developer for data conversion from flat files to database.

•Provided support of ad-hoc JIRA requests and special projects as assigned directly or through Agile.

Tools: Jira, SQL Server, SQL, SSIS, SSRS, Tableau, Oracle, UNIX, MS Office suite, Azure.

Monitoring and Reporting Officer

United Nations Human Settlements Program

Sep/2019 – June/2022

Project: FRUGA - Enhancing Climate Change Resilience in Flood-Prone Settlements Focused on improving flood resilience in vulnerable settlements through community engagement.

Data Collection & Management: Streamlined data collection and reporting procedures, reducing procession time by 20% enhancing efficiency. Utilized Excel Pivot Tables and applied data validation techniques to ensure data accuracy and reliability, supporting project goals and providing a solid foundation for decision-making and planning. Assessed the impact of small grants on 1K+ households, revealing a 20% increase in above-living-standard rates through data-driven insights.

Data Analysis & Reporting: Utilized Python to analyze feedback from 1K+ flood-resilient sanitation projects, identifying design adaptations that improved satisfaction rates by 25% for 5K+ community members.

Data Visualization: Developed an interactive dashboard using Tableau to visualize attendance trends for consultations, revealing scheduling optimizations that increased participation rates by 15% across 6K+ representatives.

GIS and Spatial Analysis: Used GIS tools to integrate flood risk data with land use plans for 10 areas, producing visualizations that highlighted high-risk zones and reduced potential property damage by 30%.

Database Management: Managed and optimized databases using SQL Server and Snowflake to track flood resilience metrics, infrastructure improvements, and community feedback for long-term data monitoring.

HR Assistant/Administrative assistant

Clean Energy LLC

Jan/2018 – Aug/2019

Organized and proactive HR Assistant with comprehensive experience in administrative support and HR functions. Skilled in managing office operations, scheduling, and handling employee inquiries, while providing key assistance with recruitment, onboarding, and employee records management.

•Developed and implemented the company’s first document control system, enhancing record management.

•Introducing an Integrated Management System (IMS), streamlining operations across all levels.

•Trained and led 32 internal auditors for OHSAS 18001, ISO 9001, and ISO 14001 standards.

Strategic planning expert

United Nations Development Program

May/2012 – Dec/2017

Project: Ecosystem-Based Adaptation for Water Security in Mongolia Implemented adaptation measures across Altai Mountains and Great Lakes Depression, and Dornod steppe eco-zones to enhance water security and ecosystem resilience.

Data Collection & Management: Gathered, cleaned, and managed large datasets on climate vulnerability, meteorology, animal populations, and community infrastructure using Python (NumPy) to ensure data accuracy and reliability in support of project goals. Analyzed data from monitoring trips, applying statistical techniques to uncover trends that informed conservation strategies, enriched the State Environmental Database, and contributed to a 40% increase in the marmot population.

Data Analysis & Reporting: Produced 15+ comprehensive reports and presentations summarizing findings and recommendations, facilitating clear communication with stakeholders and driving actionable outcomes. Conducted in-depth market research and analysis, resulting in the identification of 10+ key trends and insights that informed strategic decision-making processes.

Data Visualization: Analyzed data using SQL and created data visualizations and dashboards in Tableau and Power BI to effectively communicate project findings and highlight ecosystem resilience for diverse stakeholders. Assessed the impact of small grants on 1K+ households, revealing a 20% increase in above-living-standard rates through data-driven insights.

EDUCATION

Post Graduate Course in Satellite Meteorology & Global Climate 2005

Space Application Center (ISRO), Center for Space Science and Technology Education in Asia and Pacific, Ahmedabad, India

Master of Science in Computer Science 1998

Mongolian University of Science and Technology, Ulaanbaatar, Mongolia

Bachelor of Science in Hardware Engineering 1995

Mongolian University of Science and Technology, Ulaanbaatar, Mongolia

Contact this candidate