+1 646 305 2118
+44 1253 335595
+91 9875 492266
HAOYU
San Jose
,
United States
SQL/BI Developer
96000 USD / Year
-
Immediate: Available
6 Years
About Me
Bachelors degree of Computer Science with 6 years experience of SQL Server 2016, Oracle 11g/12c, Access database and Data Loading and Reporting tools such as: SSIS, SSRS, Tableau and Crystal Reports 2011. Strong data manage and reporting experience o...
Show MoreSkills
Portfolio Projects
Description
- Created ETL packages using SQL Server 2016 SSIS Designer to extracted data from flat file, reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio (BIDS) and Tableau/Power BI.
- Experience with statistical analysis using Tableau
- Draws upon a full range of Tableau features to design, develop, enhance, and support Tableau visualizations including, but not limited to, highly interactive dashboards, scorecards, and reports
- Highly skilled in Analysis, Design and Development of application software and ETL using SSIS, SQL Server, particularly in the use of Microsoft technologies. Created and maintained technical documents.
- Designed ORACLE and SQL server database, tables and views structure for the application.
- Successfully transferred inbound data from various sources like flat files, MS Access, and Excel into SQL server database using SSIS Packages.
- Developed complex PL/SQL and T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
- Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSIS and SSRS.
Description
- Generated variety of business reports using SQL Server 2016 SSRS/Tableau including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SSRS/Tableau/Power BI.
- Draws upon a full range of Tableau features to design, develop, enhance, and support Tableau visualizations including, but not limited to, highly interactive dashboards, scorecards and reports
- Serves as an Expert developer of Tableau visualizations. Effectively utilizes features and Best Practices of Tableau and visual analytics to maximize impact and utility of visualization products
- Aid in developing style guide for development of BI visualizations, design of components, naming of items, data source creation and naming
- Experience implementing Tableau in a large-scale environment
- Experience analyzing complex data sets and creating dashboards and visualization to find trends and patterns in data using Tableau and power BI
- Strong background in HealthCare Insurance Domain. Experience working with healthcare data.
- Primary responsibilities have included Application development, ETL, Database modeling, system testing, analysis and design, implementation and project documentation.
- Solid experience working with SSIS development. Excellent understanding of relational and dimensional data models.
Description
- Successfully loaded the data from Information Source to SQL Server and ORACLE to analyse and explain the result using SQL Server and ORACLE in BI tools as SSIS/SSRS/Tableau/Power BI.
- Responsible for the gathering and analysis of the quality related data for the global production sites.
- Gathers production data from the different databases and sites daily, creates and updates reports.
- Produced a weekly report for the customers by gathering all the quality data for the previous week along with historical data.
- Participation in all phases of software development life cycle: analysis, design, develop, test, debug, deploy, and maintain.
- Developed projects using SQL Server 2016 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions; created data-mining solutions in BIDS, deployed them to SSAS instance, trained the model and queried the model using DMX.
- Generated variety of business reports using SQL Server 2016 SSRS/Tableau including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SSRS/Tableau/Power BI.
- Worked with the team to improve the overall performance, stability, scalability and effectiveness of cloud database systems.
- Worked with product development team members, as well as company leadership and customers.
- Optimized T-SQL query performance and populated test data.
- Maintained the ORACLE database using Procedures, Functions, Cursors and Triggers in PL/SQL.
- Performed quality assurance and testing of SQL server and ORACLE environment.
- Assisted clients in using implemented software projects with SSRS and Tableau.
- Handled and debug Data Modelling and Data Profiling in data warehouse.
Verifications
-
Profile Verified
-
Phone Verified
Preferred Language
-
English - Fluent
-
Chinese - Native/Bilingual
