SOPHIA YUAN
Plano, TX
972-***-****• adaoz1@r.postjobfree.com
Reports Developer / Data Analyst
Analytical and resourceful professional with five years of experience in SQL Server Reporting Services and data analysis
Solutions-oriented with strong understanding of developing BI applications utilizing SQL Server, Power BI, and Tableau. Proficient in design, developing, and deploying BI reports. Proven success in designing data warehouses, implementing data modeling best practices, monitoring database performance, collaborating with engineer teams and instructing relevant staff on business intelligence and reporting. Strong analytical skills with the ability to collect, organize, analyze information with attention to detail and accuracy.
Technical Sill Highlights:
SQL Server BI Development
Data Warehouse Development
T-SQL queries and scripts
SSIS ETL Development
Strong Microsoft Excel
CSV version control
OLTP / OLAP Data Analysis
SSRS/Tableau /Power BI Report Development
Technology Integration
Technical Troubleshooting
HTML, XML, JAVA, PL/SQL
Education and Credentials
Master of Business Administration, Information Technology, University of Dallas, Irving, TX
Bachelor of Science, Electrical Engineering, University in Jiangsu, China
Professional Experience
PEYTON RESOURCE GROUP, Irving, TX
SSRS Report Developer, 7/2019 – Present
Design, develop and deploy various reports in MS SQL Server. Perform data analysis and validation to meet report requirements and specifications. Develop SSIS packages and procedures to consolidate various data for reporting. Identify and troubleshoot discrepancies between database tables and reporting applications.
Key Accomplishments:
Engage with business users to gather requirements and map to reports, views and BI query objects.
Test new changes and updates to existing reports.
Develop queries, scripts, stored procedures, triggers to implement business intelligence needs.
Design and develop various reports such as sub-reports, cross-tab, drill-down reports, drill through reports, and parameterized reports using SSRS 2018.
Subscribe and schedule reports to be distributed automatically on a daily, weekly, monthly basis.
Participate in projects migrating SSRS reports to Tableau.
Maintain existing dashboards and reports to ensure the availability and performance.
LEBCO INDUSTRIES, Dallas, TX
Report Developer/Data Analyst, 1/2015 – 7/2019
Interfaced with business analyst and data architect, performed data analysis and created mapping documents. Extracted and loaded transaction and client historical data from various sources to SQL databases using SSIS. Developed different type of SSRS, Power BI and Tableau reports. Oversaw and analyzed sales department on retail business dashboards to conduct trend analysis on retail metrics. Performed ad-hoc analysis on trends, insight on business processes.
Key Accomplishments:
Delivered effective support and insight to business users of the retail corporate office in strategical decision making regarding interpretation of data and trends.
Performed report analysis with data across different brands, categories; Drew relevant and action-oriented conclusions and presented to leadership team.
Created procedures, scripts to integrate and load into SQL Server data warehouse from different data sources, like SQL Server 2008 tables, MS Excel files, MS Access tables, and flat files.
Maintained data models and mappings to support reporting needs.
Implemented projects, created data source/data source view/cube with measures and dimensions, configured attributes of dimension table with hierarchy relationships, and deployed KPIs.
Developed various SQL scripts and data queries for data analysis.
Developed clean up reporting to remove dead data files and other irrelevant information.
Offered data-mining solutions in SSDT, deployed them to SSAS instance, trained the model and queried the model using DMX.
Produced reports from analysis services cube using MDX query designer; configured report server and deployed reports on Web Portal and SharePoint built Performance Points Dashboards in SharePoint 2012.
Assessed reports to enrich operating and financial performance via comparison of marketing channels’ success ratio. Led custom reports and dashboards using Composite, Matrix, Trending Reports, and Calculated Fields.
Worked with management to prioritize business and information needs.
Developed various charts and pivots in MS Excel.