Tianfang Yang

G

President

Gateway Townhome Association

May 2025 - Current (1 year 4 months)

Delivered measurable governance, process, and vendor-performance improvements across a multi-stakeholder community organization. Secured three additional board and executive sessions to accelerate project approvals and negotiated vendor deliverables free of charge, cutting decision cycle time by 30%. Led board meetings and assigned tasks to directors and property managers; used a shared ERP system to track repairs, which sped up issue resolution, improved resident satisfaction, and reduced emergency response time Partnered with legal, operations, and vendor teams to resolve contract disputes and enforce service warranties, recovering costs and improving vendor accountability while applying dispute management practices. Reviewed tax filings,

Senior Business Analyst

Natera

May 2024 - Nov 2024 (7 months)

Led quarter-end-close ASP forecasting analysis using 3L6T and 6L6T models and historical reimbursement rates, delivering unit forecasts, revenue summaries, and consolidated revenue reports with commentary on trends and payor-level changes, which enabled more accurate quarterly forecasts and informed budgeting decisions Led strategic discussions with senior leaders, using Snowflake SQL analysis to assess government reserve policies, secure agreement on policy stances (negative, silent, positive), and enable data-backed decisions (release, retain, refund) that ensured compliance and protected financial integrity Utilized Snowflake SQL, Power BI, and Excel for data analytics and reporting, adhering to HIPAA Privacy Rule standards when handling

Strategic Planning Consultant

TransUnion

Aug 2021 - May 2024 (2 years 10 months)

Co-led two 3-year planning cycles with the enterprise strategy team and C-suite leaders, aligning priorities across key functions such as Sales and Solutions; the resulting roadmap was adopted by senior leadership, ensuring TransUnion's structure supported the growth agenda Evaluated credit-reporting and adjacent-industry trends using Solver and macro-driven data modeling analyses to define growth drivers; the insights enabled the go-to-market team to prioritize initiatives that expanded market share and supported new capability development. Formulated investment-case frameworks and built Excel financial models with CAPEX/OPEX assumptions, leveraging macros and Solver; the clear buy/build/partner recommendations guided senior leadership to

Senior Business Analyst

Abbott Laboratories

Dec 2019 - Aug 2021 (1 year 9 months)

Identified operational weakness and conducted analysis on global projects review initiatives for process improvement and delivered accurate and transparent presentation of risks, assumptions and issues to solve business problems for senior leaders Led and automated operations-strategy enhancement activities with VBA macros, Power Automate flows, and SharePoint lists, cutting resource time for metrics tracking by 50% while handling multiple priorities Developed PMO executive dashboards, KPI scorecards, and governance trackers in Power BI by extracting and transforming data from OData, data flows, and SharePoint into robust ETL models, and analyzed the results, which improved reporting efficiency and transparency across new initiatives Coded

Business Analyst

Independent

May 2018 - Dec 2019 (1 year 8 months)

Tracked project progress by aligning deliverables, milestones, and activities to baselines using Excel Pivot Tables and Power Query, ensuring stakeholders received up-to-date status reports Designed views, surveys, and SharePoint lists, and exported timeline data through SharePoint Flow for automated scheduled refreshes, which reduced manual reporting time Assisted project managers in developing project management plans and schedules with MS Project and Power Query, supporting all phases of the project life cycle and improving plan completeness Diagnosed data issues and adjusted workflows and predecessors using SQL and Excel, then re-baselined projects to meet FDA submission timelines, helping the team stay on schedule Conducted gap and tre

E

Equity Research Analyst Intern

Elle Investments Inc.

Jun 2017 - May 2018 (1 year)

Drafted equity research reports using Capital IQ and ERP system, presented findings that highlighted investment opportunities and credit risks in the financial market, supporting the team's investment decisions Analyzed major stock price and volume movements, provided actionable recommendations that were adopted by senior analysts, and summarized cost-benefit analyses to guide business decisions Investigated catalysts and regulatory indicators through SEC filings and market data, performed DCF valuation with Excel, and identified undervalued stocks for further review, enriching the investment pipeline Managed stock portfolio of $100,000 for prospective and existing clients, realizing a 10% rate of return over 12 months Implemented a custom

Deals of Practice Advisory Intern

PwC

Jan 2015 - Feb 2015 (2 months)

Performed an independent review of draft consolidated financial statements prepared by senior associates, using Power Query to verify accuracy and ensure consistency of figures, and identified errors that improved statement reliability Extracted information from over 90 client contracts (contract names, dates, and bid prices) and summarized results using excel (Vlookup, match, index & pivot tables) for data value mapping, minimizing data duplication by 20% Communicated with cross-functional teams to share knowledge on the shared drive, clarified risks, and standardized work processes using SharePoint and PowerPoint dashboards, which streamlined collaboration

About

Detail

Timeline

Résumé