SUMMARY:

• 7+ years of experience as Business Intelligence Developer and Data Analyst with SQL Server, Oracle, OLTP/OLAP database design, SQL query optimization, performance tuning, and data warehousing. Extensive experience with data integration, analysis and reporting tools such as SSIS, SSAS, SSRS and Crystal Reports.
• Excellent T - SQL programming skills including complex Stored Procedures, Views, User-defined Functions, Triggers, Cursors, Table Variables, Temporary Tables, Common Table Expressions (CTE) and the Analytic / Windowing Functions.
• Experience in importing/exporting large variety of data files into/from SQL Server 2008/2012/2014 databases using SSMS import/export wizard, bulk insert, BCP and SSIS packages; Transferring data between Oracle and SQL Server databases.
• Experience in creating high performance data integration solutions using Microsoft SQL Server Integration Services (SSIS), including extraction, transformation, and load (ETL) packages for data warehousing.
• Experience in development, deployment and configuration of SSIS packages with tools such as Business Intelligence Development Studio (BIDS) for SQL Server 2008 and SQL Server Data Tools for Business Intelligence (SSDT-BI) for SQL Server 2012/2014. Experience in setting up and scheduling SQL Server Agent jobs in SQL Server Management Studio (SSMS) for automating the execution of SSIS packages and T-SQL scripts.
• Experience in generating various kinds of business reports and dashboards using SQL Server Reporting Services (SSRS) 2008/2012/2014, which can be dynamic, interactive and parameterized with drill-down and drill-through features. Experience with deployment, management and delivery of SSRS reports for end-user access.
• Experience in building report models using BIDS and Power BI Desktop for business users to create self-service reports.
• Experience in dimensional modeling and designing SQL Server Analysis Services (SSAS) Cubes with multiple measure groups and associated dimensions as well as data-mining models. Deployment and processing of SSAS databases to Analysis Services instance. Experience with MDX and DMX.
• Experience with source control using TFS and GitBucket for database and BI project source codes and the deployment of codes to different environments (DEV, QA, Production) following Agile software development methodology.
• Working knowledge of .NET Framework with C#/VB.NET custom codes for SSRS reports and C#.NET scripts for extending the functionality of SSIS standard control flow tasks and data flow components.
• Knowledge of the new features of SQL Server 2016 and the latest Microsoft Self-Service BI suite including Power BI, PowerPivot/PowerQuery/PowerView/PowerMap, Tabular model, DAX and M language. Knowledge of Python and R.
• Good team player with great communication / interpersonal skills; Can also work independently with minimum supervision.
• Strong ability to gather/analyze business requirements and build BI solutions in time and with high quality to meet user needs.
• Proven ability to effectively prioritize and complete multiple tasks.
• Highly self-motivated, quick learner, and hard worker. Pay attention to details and take responsibilities.
• Generated variety of business reports using SQL Server 2008/2012/2014 SSRS including tabular, matrix report, parameterized and cascading-parameterized report with drill-down function, dashboard with charts and summary/details drill-through report using parameters, functions, expressions and custom code. Built reports from OLTP/OLAP databases and SSAS cubes using T-SQL / MDX. Configured report server and deployed reports on web server. Automated report delivery, subscription and security control. Debugged various report issues and improved the performance of slow-running reports.
• Created ETL packages using SQL Server 2008/2012/2014 SSIS Designer to extract, transform and load data into SQL Server databases from various data sources such as RDBMS, Excel files and flat files. Loaded different types of dimension tables and fact tables into data warehouse with Star Schema and Snow-flake Schema. Dealt with logging, error handling and performance enhancement for SSIS packages. Deployed SSIS packages to MSDB and Integrated Services Catalog (SSISDB) using both package- and project-based deployment models.
• Developed projects using SQL Server 2008/2012 SSAS, created cubes with measures and dimensions, defined dimension attribute relationship hierarchies, configured cube dimension usage by multiple measure groups for regular, role-playing, referenced and degenerate (fact) dimensions. Modified existing cubes and dimensions, added KPIs with different metrics, added new measure groups and dimensions, created data-mining solutions.
• Performed installation and configuration of SQL Server instances. Experience in system migration by backup/restore, detach/attach, or scripting out. Experience in login/user creation, role/permission configuration, linked server creation/usage.
• Created normalized database tables with various constraints including primary key, foreign key, etc. and indexing strategies for query performance optimization. Created other database objects such as stored procedures and views per project needs.
• Loaded data from flat files and Excel sheets into SQL Server database tables using bcp, bulk insert, and import/export wizard in SSMS and SQLCMD; loaded data from flat files into Oracle database using SQL*Loader and SQL Developer.
• Extracted data from SQL Server and Oracle database tables into flat files and Excel sheets.
• Created advanced SQL queries with multi-table joins, group functions, sub-queries, set operations, CTEs, XML data parsing, pivot/unpivot, and T-SQL or P/L-SQL procedures, system functions and user-defined functions.

TECHNICAL SKILLS:

Database: SQL Server 2008/2012/2014 /2016, Oracle 11g, HP Vertica 7.1

BI / Reporting: MSBI 2008/2012/2014 /2016 SSIS/SSAS/SSRS, SAP Crystal Reports 2011

Programming Language: SQL, T-SQL, P/L-SQL, V-SQL,VB.Net, C#.Net, MDX, DAX, M, PowerShell, MatLab.

Operating System: Windows, Unix/Linux

MS Office: Word, Excel, PowerPoint, Access, Visio, SharePoin

PROFESSIONAL EXPERIENCE:

Sr. SQL Developer

Confidential, Mountain View, California

Responsibilities:

• Working on the creation of a Sales Data Mart for sales commission analysis and reporting by pulling data from SalesForce and NetSuite via T-SQL/SSIS ETL processes using SQL Server 2014/2016 technology.

BI Developer

Confidential, Fremont, California

Responsibilities:

• Worked on the development of a SQL Server database for ERP and Supply Chain applications by creating various database objects including tables, indexes, views, stored procedures to support web applications and reporting.
• Created various SSRS canned reports from multiple databases for Accounting/Finance, Supply Chain and Auditing departments. Also built and maintained report data models to allow business users to easily create their own reports.
• Created SSIS packages and advanced T-SQL scripts to load data into an Enterprise Data Warehouse database from disparate data sources to facilitate reporting and data analysis such as supply-demand and inventory predictions.

Technologies used: SQL Server 2008/2012/2014, T-SQL, SSIS/SSRS, Power BI, Visual Studio, TFS, GitBucket.

BI SQL Developer

Confidential, Mountain View, California

Responsibilities:

• Completed a two-month project after quickly learning a new database platform and its development tools.
• Mainly responsible for the backend design in Vertica data warehouse databases for retailer applications to support a new Enterprise Data Extract solution.
• Created metadata tables/views for all dimension attributes and measures from all fact tables as well as the relationships between fact tables and their applicable dimensions to allow for customers to generate custom reports with large datasets by specifying attributes and metrics needed on an UI portal.

Technologies used: HP Vertica 7.1, Vertica-SQL, SQL Workbench, PowerShell, SQL Server 2012 database/SSAS.

Staff Engineer

Confidential, San Diego, California

Responsibilities:

• Created transactional and dimensional databases, data warehouse and cubes for mobile phone chipset production test system to evaluate and analyze product test data.
• Generated summary reports for management indicating overall performance and trends of product lines.
• Performed more detailed data analysis and provided reports to production/design teams to help yield analysis and identify design defects, leading to manufacturing process improvement and/or chip design quality enhancement.
• Optimized SSIS/ETL data integration performance by using incremental loading, parallel execution with parent/child packages, adjusting data flow buffer property parameter settings, and other techniques.
• Generated non-standard flat data files per user requirements from database tables using SSIS packages.

Technologies used: SQL Server 2008/2012, T-SQL, SSIS/SSAS/SSRS, Oracle 11g, P/L-SQL.