Sql Server Data Analyst

Xijia Ni

Flower Mound, Texas *****

************@*****.*** Phone: 817-***-**** US CITIZEN

CAREER SUMMARY

Background with SQL programming in MS SQL Server 2018. Competent with Crystal Reports 2008 and Excel 2021. Experience with data warehouses and relational databases. Experience includes Snowflake and Tableau.

PROFESSIONAL EXPERIENCE

HYOSUNG – Data/Report Analyst - (2/2020 – 9/2023)

HYOSUNG is a world leader in ATM self-service technologies.

Quickbase SQL Updates - Inventory Updates, Update reports tabs on Excel file – Update pivots for

Appropriate Serial Number and Assign, Provided Excel file for Installation Readiness report,

Wrote SQL script for Chase Chronic report, Analyzed Data from Customers Excel files and sent to

Managers with graphs and charts with raw data.

Gather data from various sources and report findings back to the department of Quality. Created and maintained Tables on SQL server, extract and manipulate data from KPI and Quality Analytics databases on SQL server. Use raw data to write SQL scripts for running jobs for the Director of the department and team members. Research and validate data in multiple data sources.

Dynata – Customer Insights Analyst - (10/2018 – 12/2019)

Dynata is the world’s leading provider of first-party consumer and professional data based on extensive, proprietary market research panels, and has built innovative data services and solutions that bring the voice of the individual to the entire marketing spectrum.

Translated various ad-hoc data requests from other panel teams into data manipulation scope and SQL logic. Created SQL queries to retrieve data from data warehouse for various reporting, operational, and analytical needs. Queries routinely required sourcing data from data tables residing on different database systems. Built simple Tableau reports and data visualization that provide insight and are consumable by Panel department. Reviewed (QA) existing Tableau reports for data discrepancies. Updated/modified existing queries and reports as needed.

Dallas Housing Authorities – IT Business Report Developer – (2/2006-1/2018)

DHA provides quality, affordable housing to low-income families and individuals through the effective and efficient administration of housing assistance programs.

Developed and maintained operational reports using Crystal Report, SQL, Excel, and other tools for the housing management system and the financial system. Imported and exported data and created reports per users’ request. Developed an executive decision support system that provided financial data and housing operation data in real time mode. Provided technical expertise to assist other colleagues with data reports and programming services. Analyzed data for errors and made appropriate recommendations and corrections. Assisted in data error correction. Performed all supportive duties related to the PIH-PIC submission process. Prepared ad hoc reports on the system as needed.

Dallas Housing Authorities – Financial Analyst (Temporary Contractor) – (8/2005-2/2006)

Created financial reports with Crystal Reports, Excel, Microsoft SQL Server 2000, and Microsoft Great Plains Dynamics. Prepared ad hoc reports as needed like Audit of Vendor Payments, Purchasing Payment for Minority Vendor, etc.

FUNimation Entertainment –Financial Analyst (Contractor) – (6/2004 – 7/2005)

A brand management company and one of the nation’s largest independent home video entertainment companies.

Created monthly and quarterly sale and royalty reports and special ad hoc reports for finance department. Activities included the extraction of data from host ERP system for download to PC Tools used in analysis and report creation with MS Access, MS Excel, and specifically VLOOKUP, and PivotTables. Analysis included the correction of any report discrepancies. Maintained/developed tables and queries in MS Excel to report actual monthly and quarterly reports.

EDUCATION

Shanghai Technical University, Shanghai, China – Finance Degree – 1984-1988

Temple College, Temple, TX – Computer Information Degree – 1993-1995

North Lake College, Irving, TX – Associate Accounting Degree – 2003-2004

TECHNICAL SUMMARY

BI Data Analytics Snowflake, Tableau

Databases Systems: SQL Server 2018, MS Access.

Software: Excel 2021, MS Word 2021, and other MS Office Applications

ERP Platforms: Microsoft Great Plains Dynamics.

Languages: SQL, Crystal Reports 2008

Contact this candidate