Sql Server Power Bi
Resume:
Zujie (Zubeen) Zhang
******@*****.***
Summary
• Over 10 years of experience in data reporting and analysis with large datasets using Tableau, SQL, Excel, SSIS, SSRS, and Power BI.
• ETL development using T-SQL and SSIS; experience with data mapping and data lineage through Er-Studio.
• Converted Oracle Business Intelligence Enterprise Edition (OBIEE) reports to SQL Server SSRS or Power BI reports.
• Proficient in Tableau tools including Desktop, Server, Reader, and Public.
• Skilled in troubleshooting and performance tuning of reports, especially in Tableau.
• Extensive experience with Windows Server, SQL Server, Oracle databases, and Data Warehousing.
• High-performance data integration solutions using SSIS and T-SQL.
• Expertise in loading and migrating various data types into SQL Server, generating reports with SAP Crystal Reports, SSRS, Access, Excel, and Tableau.
• Proficient in C# for SSIS projects.
• One year experience with OBIEE reporting.
• Strong ability to work independently and as part of a team.
• Comprehensive technical skills in database management, data manipulation, and data cleansing.
• Experienced in all stages of data processing and database creation, including requirements gathering, modeling, schema creation, and reporting.
• Skilled in a wide range of tools for data management, analysis, and reporting, including SQL Server, Oracle, Tableau, Python, and Power BI.
• Knowledgeable in Big Data platforms (e.g., Hadoop) and Azure. Selected Achievements in Business Intelligence
• Created ETL packages using Microsoft Visual Studio and loaded various types of data into data warehouses, deploying SSIS packages and scheduling jobs using SQL Server Agent.
• Generated diverse business reports using SAP Crystal Reports, SSRS, Access, Excel, and Tableau, including matrix reports, parameter reports, and dashboards.
• Loaded ClinicalTrials2011 data into SQL Server and generated supporting reports for research case studies.
Selected Achievements in SQL Server and Access
• Configured SQL Server database parameters to optimize memory usage and file sizes.
• Created database tables with various constraints and loaded data from multiple sources into SQL Server through ETL processes by using SSIS, bcp, and export/import wizard.
• Migrated tables from Oracle to SQL Server and extracted data for analysis.
• Expertise in advanced SQL queries, including multi-table joins, group functions, subqueries, CTEs, cursors, stored procedures, and user-defined functions.
• Successfully completed a commercial customer marketing campaign for a financial institute using SQL to collect data and rank customers. Computer Skills
• Database: SQL Server, Oracle, MySQL, Access
• Language: SQL, T-SQL, PL/SQL, MySQL, Excel, Python
• Reporting: SSAS, SSRS, Tableau, OBIEE, Pentaho report-designer
• Application: SAP Crystal Reports, SSIS, SSRS, Tableau, Dax-Studio, Er-Studio, Git, Pentaho report-designer
• MS Office: Word, Excel, PowerPoint, Access, and Windows Forms Additional Information
• U.S. citizen; currently hold Top Secret Clearance which expires in March 2025. Professional Experience
iWorks Corp, Reston, VA
Senior Consultant March 2018 to March 2024
• Converted Oracle queries to SQL Server queries for federal government projects.
• Developed ETL packages using T-SQL, SSIS, and Pentaho.
• Created and deployed reports with Visual Studio and Power BI.
• Utilized Dax-Studio to verify DAX queries for Power BI reports.
• Troubleshot and resolved SQL queries and report issues for end users.
• Managed version control using Git.
• Wrote stored procedures, functions, and views for data mapping and monitoring data- loading.
• Used ER-Studio for data model lineages.
• Created and tested Pentaho reports.
Pertainium Technologies, Newtown, PA
BI Developer / Tableau Developer November 2013 to February 2018
• Gathered business requirements and developed logical and physical database designs.
• Designed and built databases and data warehouses for a multi-state fitness company.
• Loaded and updated weekly experiment data files using SSIS packages.
• Migrated databases from SQL Server 2008 R2 to SQL Server 2012.
• Designed and implemented efficient ETL processes and developed SQL Server database objects.
• Created multiple visualization reports and dashboards using Tableau.
• Improved hospital appointment procedures using T-SQL.
• Developed Tableau Business Intelligence reports and dashboards.
• Completed a commercial customer marketing campaign for a financial institute using SQL skills.
Contact this candidate