Nathan Suchan

Chicago, IL *****

708-***-**** • ad1n3v@r.postjobfree.com

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

EXPERIENCE

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).

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

•Collaberated 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 snowflake 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 financial data reconciliation efforts between Essbase and Snowflake, ensuring data consistency and alignment for accounting and capital debt departments.

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 implemantations for Operational, Engineering, Transactional and Cohort data sets before data was productionalized.

•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.

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