Jeff Stafford

Jeff Stafford Email and Phone Number

Senior Data Engineer / Architect @ Teacher Retirement System of Texas
Austin, TX, US
Jeff Stafford's Location
Austin, Texas, United States, United States
Jeff Stafford's Contact Details

Jeff Stafford personal email

n/a
About Jeff Stafford

Highly motivated data architect/engineer with a specialization in finance and investment related data. Great people skills coupled with the analytical awareness to quickly understand new tasks.

Jeff Stafford's Current Company Details
Teacher Retirement System of Texas

Teacher Retirement System Of Texas

View
Senior Data Engineer / Architect
Austin, TX, US
Website:
trs.texas.gov
Employees:
1377
Jeff Stafford Work Experience Details
  • Teacher Retirement System Of Texas
    Teacher Retirement System Of Texas
    Austin, Tx, Us
    View
  • Teacher Retirement System Of Texas
    Senior Data Engineer / Architect (Private Markets Data Analytics)
    Teacher Retirement System Of Texas Jul 2015 - Present
    Austin, Texas, Us
    Tools and Languages Used:T-SQL, Microsoft SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Power BI, Power Automate, Tableau, SAS, Visual Basic for Applications (VBA), eFront (FrontInvest, FrontScript, FrontReport, FrontCMD), Advanced Microsoft ExcelPerformed ground up analysis and final deliverable to replace existing reporting and dashboard tools. Created dimensional model and views of system tables for use in business intelligence tool. Tested and selected agency-wide business intelligence tool. Tools tested: Tableau, Power BI, and Qlik. SQL Server database analysis and data manipulation, SQL queries/functions and stored procedures. Automated applications and spreadsheets using VBA in Excel, Outlook and Word. Financial data manipulation using SAS. Scripting in VB. Reporting using a multitude of solutions, including Power BI, SSRS, Excel, and Front Report (a proprietary reporting solution).Performs lead and highly advanced analysis, design and administration of complex investment information systemsWork involves overseeing the planning, design, implementation and administration of automated investment information and reporting systems to meet business user needsCompiles, analyzes, evaluates, and reports on investment processes and related financial dataConsults with Investments and TRS management on information and reporting needs.
    View
  • Advanced Business & Automation Solutions, Llc
    Data Consulting Services
    Advanced Business & Automation Solutions, Llc Mar 2015 - Aug 2019
    Austin, Texas, Us
    From an accounting and finance perspective, provided automations, data analysis and reporting services to a variety of organizationsCreated scalable subscription services for automation of various Intuit payroll and accounting modules.Worked with clients from multiple industries to assist with their data analysis and reporting needs.Created visual representations of data for management decision-making, including Interactive Spreadsheets - interactive charts, graphs and dashboardsCompile and rewrite efficient SQL queries, functions and stored proceduresAutomated data entry and reporting.Tools used (not all-inclusive):-Business Intelligence Tools-Microsoft Excel (Advanced User) - Dashboard Creation, H-Lookup, V-Lookup, Sumif/s, Countif/s, Index/Match, If/Then/Or/And Statements, Pivot Tables, KPI Analytics, Slicers, Advanced Filtering Techniques, Data Bars, Charts, Graphs, Advanced Conditional Formatting Techniques, etc.-Visual Basic for Applications - Automate Microsoft Applications using VBA macros, including Excel, Outlook and Access.-Collect data for consumption using multiple sources via ODBC, APIs, and advanced data collection techniques.-Microsoft SQL Server Management Studio - Query multiple, large databases at once, Alter stored procedures, Create databases, Create functions, etc.-Other SQL RDMBS (Relational Database Management Systems), including IBM DB2
    View
  • Farm Credit Bank Of Texas
    Financial Data Manager
    Farm Credit Bank Of Texas Jan 2013 - Feb 2015
    Austin, Texas, Us
    Performed senior-level financial data analysis and reporting utilizing a variety of data mining techniques and specialized software applications (Advanced Microsoft Excel, Microsoft SQL Server, IBM DB2 RDBMS, MicroStrategy Business Intelligence, and light Excel VBA)Designed, developed, implemented and maintained financial business solutionsWorked with project and business leaders to identify analytical requirements, performed maintenance of data on system applications and reporting needs, ad-hoc and standardized reporting requirementsActed in the capacity of the subject matter expert for financial systemsAssisted GL in the architectural redesign, creation of GL Standard Reports, and the creation of ad hoc analysis tools for MicroStrategy, the bank's Enterprise Reporting Engine and Business Intelligence toolAssisted in the overhaul of the database extract sent to organization's regulator, including automation of reconciliation/exception reporting using SSRS (SQL Server Reporting Services), mapping of data elements, and analysis of gaps/issues within our dataCreated multiple templates to assist with areas needing streamlining, including, but not limited to, fair market valuations and financial ratios for merging association entitiesPerformed user acceptance testing (UAT) on multiple systems, streamlined processes and communicated effectively with team members
    View
  • Avail Recruiting, Inc.
    Regional Manager
    Avail Recruiting, Inc. Aug 2011 - Oct 2012
    Mckinney, Tx, Us
    View
  • Amherst Securities Group Lp
    Senior Hedge Fund Derivatives/Fixed Income Accountant/Analyst And Data Streamliner
    Amherst Securities Group Lp Jun 2008 - Jul 2011
    Austin, Texas, Us
    Hired specifically to assist CFO and COO in the accounting, settlement, and clearing of derivatives, mortgage backed securities, and mortgage loans held for sale not handled by our current systemSought items to streamline to assist C-level team and worked closely with IT on proprietary systemsThrough an understanding of our systems' backend, spearheaded an overhaul of our trading and accounting systems from SunGard and QuickBooks to Bloomberg TOMS and MS Dynamics, respectivelyIn charge of accounting for the entire lifecycle of a variety of securities, from purchase to saleStreamlined current systems using Excel/Bloomberg formulas and macro functionsProvided an extensive securities' knowledge base to the current staff including: Equities, Futures, Forwards, Interest Rate Swaps, Equity Swaps, CDS, Mortgage Bonds, Corporate Bonds, ABS, Options, Money Markets, Security Lending, Margin Transactions, etc.Took over and exclusively managed all duties related to derivatives and bonds including contractual agreements between counterparties, regular dealings with trading and IT regarding mispriced and poorly performing securities, and communication with counterparties on data errorProvided superior project management skills to CFO by taking tasks currently handled by him, including dealings with loan servicers regarding borrowers, streamlining of balance sheet reconciliations for multi-billion dollar companies, and P&L reviews.
    View
  • Citibank Hedge Funds
    Senior Hedge Fund Derivatives Accountant
    Citibank Hedge Funds Feb 2006 - Mar 2008
    New York, New York, Us
    Quickly promoted to supervisory role due to strong past contributions to team and quick understanding of accounting and financial conceptsResponsible for #1 income producing client at Citibank - SOLUS Alternative InvestmentsIn charge of credit default swap, equity swap, option, and other derivative accountingPrepared timely and accurate Net Assets Values, allocations, and other fund accounting outputWorked heavily in Microsoft Excel with an emphasis on analysis of securities
    View
  • Sovereign Bank
    Investment Associate
    Sovereign Bank Oct 2004 - Jan 2006
    Boston, Ma, Us
    Responsible for providing superior sales and service to Sovereign's most profitable client base through traditional banking products, various types of securities, and non-traditional banking productsRecognized as Top 7 producer out of 69 producers in banking regionReceived series 6,63, and life licenses
    View
  • Midfirst Bank
    Supervisor/Loan Officer
    Midfirst Bank Dec 2002 - Oct 2004
    Us
    Originated and processed conforming and non conforming refinance and purchase mortgagesRecognized as '#1 LendingTree Loan Advisor' for three months in a row; 'Top 3 originator' for four months in a row; and '#1 processor' for three months in a rowQuickly promoted to manage a team of 15 mortgage loan originators to achieve a production goal of 3,000 refinance applications for the month of January, a nine month record
    View
  • Pioneer Investments
    Client Service Specialist
    Pioneer Investments Jan 2001 - Jan 2002
    Boston , Ma, Us
    Fielded inquiries from brokers and shareholders regarding Pioneer mutual fundsSettled redemptions, exchanges and transfers of client and broker-controlled accounts
    View

Jeff Stafford Education Details

  • Pepperdine University
    Pepperdine University
    Finance
  • University Of Canberra
    University Of Canberra
    Finance

Frequently Asked Questions about Jeff Stafford

What company does Jeff Stafford work for?

Jeff Stafford works for Teacher Retirement System Of Texas

What is Jeff Stafford's role at the current company?

Jeff Stafford's current role is Senior Data Engineer / Architect.

What is Jeff Stafford's email address?

Jeff Stafford's email address is js****@****glp.com

What is Jeff Stafford's direct phone number?

Jeff Stafford's direct phone number is +144055*****

What schools did Jeff Stafford attend?

Jeff Stafford attended Pepperdine University, University Of Canberra.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.