Real Estate Quality Assurance

Nathan Suchan

Chicago, IL *****

708-***-**** • *************@*****.***

Professional Summary

An analyst who is eager to contribute in diverse roles, such as business analysis, quality assurance, or data analysis. Possesses extensive experience with transactional data (food & beverage), logistical data (shipping), marketing data (real estate), and accounting datasets. Proficient in data analysis, reconciliation, replicating old reports, and conducting data quality checks for various datasets. Adept at translating end-user business requests from technical requirements to implementation. Demonstrates productivity in both team-based and self-managed projects and is a dedicated learner who consistently seeks knowledge by asking questions.

Core Capabilities:

Extraction, Transformation, Loading (ETL) Business Requirements Test Plans

Cross-Functional Team Collaboration Data Manipulation Analytics Documentation End to End Data Reconciliation and Validation Reverse Engineer Data Transformation

TECHNICAL SKILLS SUMMARY

Languages: SQL, PL/T-SQL, R, Python, Java, PySpark

Databases: MySQL, Teradata, MS SQL Server, SnowFlake

Software: Powerpoint, PowerBI, Tableau

EXPERIENCE

DirecTV

A multichannel video programming distributor that offers satellite TV and streaming service and internet

Business Analyst (02/2024 - 09/2024)

Assumed responsibility for generating and delivering comprehensive reports in place of colleagues, ensuring seamless continuity and accuracy in data presentation.

•Developed a gradient boosting model to analyze and predict sales trends, enhancing forecast accuracy and driving data-informed decision-making

•Quality Assurance of existing and operationalized SQL views for Tableau/Power BI

Revantage (A Blackstone Company)

A corporate services company that provides support for accounting and real estate data to Blackstone and its portfolio companies.

Data Analyst ll (02/2019 – 11/2023)

Led reporting initiatives as the subject matter expert (SME) for Revantage-owned portfolio companies, focusing on leasing (KPIs), lead-to-lease marketing, and year-over-year Blackstone financial fund performances. Routinely utilized SQL in Snowflake for data reconciliation and the creation of complex views to replicate old third-party reports (Yardi & RealPage).

•Replicated business logic with complex SQL views in snowflake/SQL Server which replaced a manual task of downloading Yardi/Realpage and combing them in Excel.

•Collaborated as Data Analyst/QA Engineer for Power BI financial reporting on Blackstone funds (BREIT, BPP, BREP).

•Leveraged SQL/Python to perform root cause analysis on data quality issues in SQL Server by testing business logic against transformations on data.

•Collaborated with data engineers and accountants to identify and resolve data quality issues regarding account mappings.

•Performed complex SQL queries for financial data reconciliation efforts between Essbase and SQL Server, ensuring data consistency and alignment for accounting and capital debt departments.

•Adjusted existing Power BI dashboards including changing metrics, KPI's and visualizations.

•Worked with business stake holders on defining requirements for dashboards.

Freeosk, Inc.

A marketing company that leverages kiosks inside Walmart and Sam’s Club to connect consumers with new brands, delivering measurable results to massive brands through free samples.

QA Analyst (07/2017 – 01/2019)

Led quality assurance efforts in new ETL implementations for Operational, Engineering, Transactional, and Cohort data sets before data was productionalized. Regularly tasked with Ad-Hoc reports that explored new ways of presenting marketing campaign performances.

•Lead QA on partial database (OLAP) redesign which unlocked new reporting for operations.

•Designed test cases and automated test scripts using SQL to validate ETL target tables.

•Investigated errors of log files from executable jar files written in Java and provided debugging options by highlighting lines of code that broke business rules.

•Provided back-end unit and regression testing on logistics model written in R that was used by operational analysts for sample demand and shipping to 700+ Sam's Club and Walmart locations.

Data Analyst (02/2015 – 07/2017)

•Prepared ad-hoc metrics that provided sales insights on cohort analyses using Walmart and Sam’s Club transactional data.

•Optimized complex SQL scripts that cut down execution from an hour to 15 minutes in Teradata.

•Utilized Java to create an ETL process that cleansed dirty data before mapping data to fit our ODS schema.

EDUCATION

•B.S Computer Science, Western Illinois University, Macomb, IL

Contact this candidate