SUMMARY

Detail oriented Database Engineer with over 3 years of experience working on Business Intelligence related technology such as SQL Server, SSIS, SSRS, Snowflake Data Warehouse, AWS, and Tableau environments. Developed and migrated various database objects as well as Tableau dashboard.

TECHNICAL SKILLS

Database: MS - SQL Server 2016/Azure SQL Database

Data Warehouse: Snowflake Data Warehouse, T-SQL Programming, Dynamic SQL, HTML

Data Modeling: ER-win, MS Visio

BI Tools: Tableau, SSRS

ETL: Integration Services (SSIS), Snaplogic

Development Tools: Visual Studio, SSMS, Tableau Desktop

Source Control: Team Foundation Server (TFS), SourceTree, Bitbucket, GitKraken

Microsoft Azure: Cloud Services (PaaS & IaaS), Azure SQL Database (PaaS), Azure Data Factory, Azure Data Warehouse

AWS: S3, EC2

SDLC: Agile, Scrum, Waterfall, and Spiral

Management Tool: JIRA, Teamwork

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Business Intelligence Developer

Responsibilities:

• Conducted scrum meeting to get visibility for sprint progress and collect task blocker from team.
• Documented tableau server version upgrade and AWS migration for design review and future reference.
• Hosted user training session to empower user self service using existing data source on tableau server.
• Gathered user requirement via various channel from stakeholder in different team.
• Coordinated with DBA and different team to solve permission and data access issue.
• Exported SQL Server metadata script for table or view, convert to Snowflake standard for data migration.
• Developed JavaScript channel transformer in Mirth Connect to modify HL7 message for lab order and result information.
• Designed Snaplogic ETL/ELT template for different source to snowflake and SQL Server data loading.
• Migrated SSIS package into Snaplogic pipeline for data cleaning, lookup, and ETL solution.
• Developed data pull and data mining script in Snowflake Data Warehouse for analysis purpose and data request.
• Wrote complex stored procedures to implement data profiling and incremental load in data lake architecture.
• Migrated multiple step SQL Server stored procedure into single CTE statement.
• Wrote SQL script including stored procedure, views, and initial SQL for Tableau report.
• Created python script utilizing tableau server REST API to set tableau user favorite based on user groups.
• Developed tabadmin/TSM script for tableau server active directory user group and permission sync.
• Automated tableau server maintenance task including backup, cleanup, and archive process with task scheduler.
• Create multiple tableau dashboard based on user requirement for department such as Billing, Sales, Finance.
• Migrated tableau server from on-premises environment to AWS EC2 environment
• Translated tabadmin script to TSM syntax as part of preparation for Tableau Server version upgrade.

Tools: and Environment:SQL Server 2014/2016, T-SQL, SSMS, SSIS, Snowflake SQL, SnapLogic, Python, Excel, JIRA, Tableau Desktop/Server, AWS S3, AWS EC2

Confidential, San Diego, CA

Database Analyst

Responsibilities:

• Wrote complex stored procedures to implement data profiling and incremental load in OLAP architecture.
• Implemented transactions with proper isolation level and lock to avoid problems such as dirty read and phantom read.
• Utilized SQL profiler, statistics and DMVs to monitor and diagnose health of SQL server database and data warehouse.
• Created data flow diagrams, data mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Created staging database to perform various data migration operations such as data profiling, data conversion and verification.
• Examined and evaluated data structures of the source/legacy systems, analyzed data quality and performed data cleanups.
• Developed SSIS packages with variety of transformations such as look up, derived column, conditional split, fuzzy lookup, multicast and data conversion to filter out problematic data.
• Deployed Tableau Server in local environment and import tableau online site file into new tableau server deployment.
• Generated Tableau Dashboard in Tableau Desktop with actions and parameters to enhance user experience.
• Designed and developed various analytical reports from multiple data sources such as SQL Server, SSAS, Tableau Server source by data blending.
• Developed Tableau Data extract with multiple complex tableau calculation and LOD Expression.
• Maintained data connection on Tableau Server, schedule data extract refresh based on individual business requirement.
• Configured virtual machines for Infrastructure as service (IaaS) and Azure SQL Database (PaaS) on Microsoft Azure
• Migrated data from on premises databases to Azure SQL Database and SQL Server on Azure environment.
• Collaborated with team members with Team Foundation Server.

Tools: and Environment:SQL Server 2016, T-SQL, SSMS, SSDT, Erwin, SSIS, Excel, TFS, SQL Profiler, Tableau Desktop, MS Azure

Confidential. Las Vegas, NV

Data Engineer

Responsibilities:

• Analyzed user requirements and developed specifications in JRD meetings.
• Collaborated in JAD meetings and analyzed the BRD to outline functional/non-function requirements.
• Created and managed schema objects such as tables, views, indexes, and referential integrity.
• Optimized SQL queries with execution plans to improve performance.
• Wrote stored procedures for data profiling, data cleansing, and batch processing.
• Designed mappings between sources and operational staging targets utilizing star schema.
• Designed ETL process in SQL to interpret information from multiple data sources into central data warehouse.
• Updated large amount of data warehouse SQL Script from ICD-9 to ICD-10 standard.
• Created data mining SQL query and performance tuning query performance based on data warehouse index structure.
• Generated Tableau Dashboard in Tableau Desktop with actions and parameters to enhance user experience.
• Optimized underlying table used in Tableau Report, adding non-clustered index on foreign key column.
• Designed Tableau report for data visualization such as Heat map, Tree map, and Stacked Bars.
• Provided support to DBA team for server migration and testing.

Tools: and Environment:SQL Server 2014, T-SQL, SSMS, MS Excel, Erwin, SSIS, SSAS, SSRS, SharePoint, Power BI, Power View, TFS, DTA, SQL Profiler, Paxata

Confidential, San Diego, CA

Data Analyst

Responsibilities:

• Gathered system specification requirements for the project through JAD sessions.
• Collaborated with the database architect to modify physical and logical data models.
• Designed standards for database tables, columns, procedures, and views.
• Implemented indexes and fine-tuned the queries for better performance.
• Developed SISS packages to extract, transform, and load data from OLTP servers to the OLAP database.

Tools: and Environment:SQL Server 2012, T-SQL, SSMS, MS Excel, Erwin, SSIS