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.
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.
Secondary Market Analyst01/2016 to 03/2017United ShoreTroy, Michigan
Leading wholesale mortgage lender in the U.S.
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.
Junior Business Systems Analyst05/2015 to 12/2015Ciber IncSouthfield, Michigan
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.
Junior Business Analyst01/2013 to 05/2015Digital TerrainLivonia, Michigan
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
Bachelor of Science: Economics2014University of MichiganDearborn, MichiganEconomics