+1 (415) 644 5123
+44 1253 335595
+91 9875 492266
Haoyu
San Jose
,
United States
SQL developer/ BI analyst/data analyst
96000 USD / Year
-
Immediate: Available
6 Years
About Me
- Bachelor’s 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 ...
- Strong data manage and reporting experience on quantitative analysis.
- Professional experience of most advanced SQL Server 2016 Database server installation, login and user creation, role and permission configuration.
- Professional experience on load variety of large volume data files into SQL server 2016 database tables, migrate Oracle tables into SQL Server 2016 database tables and generate Report with SSRS/Tableau.
- Experience on high performance data integration solutions- Microsoft SQL Server Integration Service (SSIS), including extraction, transformation, and load (ETL) packages for data warehousing.
- Robust MS Access and Excel skills with Pivot tables.
- Strong team player with great verbal, written communication and interpersonal skills.
- Proven ability to approach problems effectively, prioritize and complete multiple tasks.
- Quick learner, take initiator, and hard worker. Willing to take responsibilities.
- Created database tables with various constraints including primary key, foreign key, etc.
- Loaded data from flat data files into SQL Server 2016 database tables using bcp, bulk insert, and table export/import; loaded data from flat data files and excel sheet into Oracle database using SQL*Loader and SQL Developer.
- Extracted data from SQL Server 2016 database tables and Oracle database tables into flat data files and Excel sheet.
- Power user of advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL or PL/SQL functions.
- Generated variety of business reports using SQL queries, SQLPLUS, SSRS and Excel.
- Generated variety of business reports using ORACLE 12c, SQL Server 2016 SQL query, SSRS, Tableau, Crystal Report 2011 and Excel Pivot table.
- Creates effective Business Intelligence (BI) solutions and analytical dashboards / analytical tools for business users in 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
- Effectively communicates with team members, business and scientific users, work groups, committees
- Provides and promotes development guidelines to business (dept.)-based authors
- Serves as an Expert developer of Tableau visualizations
- Collaborates with technical team to set-up Tableau Server, MS SQL Data Warehouse, ensure data sources are available and/or developed to support Tableau work products
- Assists with liaison tasks to Tableau (vendor) for operations, training
- Effectively utilizes features and Best Practices of Tableau and visual analytics to maximize impact and utility of visualization products
- Collaborates with BI team to ensure metrics, benchmarks and related content are accurately represented in published content
Skills
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
