secondary market analyst resume example with 4+ years of experience

Your Name
Montgomery Street, San Francisco, CA 94105 609 Johnson Ave., 49204, Tulsa, OK
Home: (555) 432-1000 - Cell: - - : - -
Career Overview
Extensive SQL Server experience with: Planning and installing instances, configuration of instances, migrating data, mirroring and replication of databases, clustering and Always On availability groups, SQL Server jobs, dynamic SQL, RAID configuration, database design and normalization, transaction log management, optimizing hardware to resolve query bottlenecks using various tools (Performance Manager, DMVs, Stored Procedures, Tasks Manager, Windows Events log, SQL Server Extended Events, Activity Monitor, and third-party tools), and general internals knowledge of SQL Server. Technical Skills Databases: Microsoft SQL Server 2012-2016, MySQL Operating Systems: Windows 7, 8,10, Windows Server 2012 R2, Windows Server 2016, Ubuntu, ESXi 6.0. Languages: SQL, T-SQL, XML, Windows PowerShell Applications: Microsoft Suite (Excel pivots and macros, Access, Word, PowerPoint, Outlook, Visio, SharePoint), SAS, SPSS, Tableau, SSRS, SSAS, SSIS, SSMS, Visual Studio, Oracle Hyperion, SAP Crystal Reports.
  • Guest services
  • Inventory control procedures
  • Merchandising expertise
  • Loss prevention
  • Cash register operations
  • Product promotions
Technical Skills
Work Experience
01/2016 to 03/2017
Secondary Market Analyst Home Bancshares, Inc. Springdale, AR,
  • Leading wholesale mortgage lender in the U.S.
  • for 2016.
  • Provides database support and maintenance, and data analytics to senior staff.
  • Creates executive-level reports, examined directly by senior staff and CEO, using various methods (SSRS, Excel, Hyperion, SSMS).
  • Intermediates ETL (SSIS) processes to data warehouse and examines data for anomalies.
  • Performs database administration tasks such as query tuning, index management, solving concurrency issues, database backups/restores, and user complaints.
  • Builds interactive reporting solutions for end-users through a web interface using SSRS/Visual Studio.
  • Launches and maintains virtual machines through ESXi using vSphere/vCenter for production environments and testing-level environments.
  • Creates business applications using stored procedures to aid in customer automation processes.
05/2015 to 12/2015
Junior Business Systems Analyst Caci International Inc. Weddington, NC,
  • Global consulting services and outsourcing firm with multinational commercial clients.
  • Provides quantitative and qualitative consultation on how best to attain maximum productivity by presenting economic and statistical concepts and ideas such as market structures, consumer theory, and central tendency.
  • Employs statistical methods using SAS and SPSS and serves as a consultant on topics such as data analytics, descriptive statistics, inferential statistics, hypothesis testing, regression analyses, and analyses of variances.
  • Develops SQL queries to organize and analyzes large datasets from relational databases and converts them into forms of reports, charts, and tables using Tableau, SAS, or Excel for easy comprehension.
  • Communicates technical economic, statistical, and financial subjects clearly and concisely to individuals from different professional backgrounds.
  • Provides actionable information to support various business functions.
  • Consults with managers to determine the role of computer systems in the organization.
01/2013 to 05/2015
Junior Business Analyst Asrc Federal Holding Company District Of Columbia, DC,
  • Management consulting, technology services, and outsourcing with national commercial clients.
  • Works as an intermediary between IT and stakeholders to facilitate efficient business operations.
  • Designs and develops new systems by choosing and configuring hardware and software.
  • Conducts testing to ensure the newly implemented systems work to their potential.
  • Trains system's end-users and writes simple instruction manuals for support.
  • Manages and analyzes large array of data to help model industrial organization and creates ad-hoc reports to answer questions about specific at hand problems using various data.
  • Manipulates spreadsheets and databases to extract only specific data needed to answer project management questions.
  • Constructs cost-benefit analyses to evaluate resource allocation decisions, and examines alternatives if resources are not allocated to maximum efficiency.
  • Completes marginal utility analyses to better understand and model consumer behavior, and formulates pricing and output recommendations.
  • Increases productivity by analyzing statistical variances, recognizing patterns, trend analyses on data, and comparing the results to forecasted plans.
Education and Training
Expected in 2014 to to
Bachelor of Science: Economics
University of Michigan - Dearborn, Michigan
ad, analyst, automation, business operations, charts, hardware, consultant, consultation, consulting, clients, data warehouse, database administration, databases, database, ETL, financial, forms, Hyperion, instruction, Management consulting, market, Excel, Works, developer, presenting, pricing, processes, project management, Relational database, relational databases, reporting, SAS, spreadsheets, SPSS, SQL, statistics, Tableau, tables, trend, Visual Studio

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • University of Michigan

Job Titles Held:

  • Secondary Market Analyst
  • Junior Business Systems Analyst
  • Junior Business Analyst


  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: