SUMMARY

• Highly qualified Business Intelligence Developer with over 7 years of IT experience in Database development and maintenance for Healthcare, Financial Services and Manufacturing industries.
• Strong business acumen and exposure to healthcare and financial services (banking) industry have passed the CFA first level exam
• Extensive experience with multiple development environments including SQL Server 2005/2008/2008 R2/2012/2014, Visual Studio 2005/2008/2010 , Team Foundation Server (TFS) 2008/2010, and SharePoint 2010
• Flexible, proactive and project oriented team player with excellent written, verbal communication and leadership skills under waterfall and agile models
• Adept in developing and debugging Stored Procedures, User - defined Functions (UDFs), Triggers, Indexes, Constraints, Transactions, and Queries using Transact-SQL (T-SQL)
• Expert in query optimization and performance tuning using performance monitoring tools such as SQL Server Profiler and Database Engine Tuning Advisor, as well as analyzing Execution Plans
• High proficiency in creating, documenting, and deploying ETL packages under both Package Deployment Model and Project Deployment Model using SQL Server Integration Services (SSIS) to load data from homogenous and heterogeneous data sources into data warehouses and data marts
• Proficient in Data Scrubbing and Data Cleansing, data validation checks during Staging, before loading the data into the Data warehouse.
• Adept in Data Conversion, Normalization and Multi-Dimensional Modeling in Enterprise Data Warehouse design.
• Leading experience in staging data, cleansing data, and transforming data using transformations
• Skilled in implementing initial data load using Bulk Insert Task and Fast Load as well as incremental data load using techniques such as Slowly Changing Dimensions (SCDs)
• Expertise in designing and developing Dimensions, Hierarchies, KPIs, and Cubes in SQL Server Data Tools (SSDT) and deploying to SQL Server Analysis Services (SSAS) Server
• Profound understanding of Enterprise Data Warehouse (EDW)/Operational Data Store (ODS) modeling concepts including OLTP/OLAP, Dimension/Fact tables, Top-down/Bottom-up models, Star/Snowflake schemas
• Proficient in designing and developing complex reports such as Sub-Reports, Parameterized Reports, Drill-Down Reports, Drill-Through Reports, and Snapshot Reports in SQL Server Reporting Services (SSRS) and deploying to end users through Data-Driven subscriptions and SharePoint Server
• Leading experience in using Tableau to create well-formatted report using existing data-warehouse
• Proficient in Mandarin Chinese and English.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008/2005
• Transact-SQL (T-SQL)
• SQL Server Management Studio
• Tableau
• MS Visual Studio
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Reporting Service (SSRS)
• MS SQL Server Analysis Services (SSAS)
• Database Engine Tuning Advisor
• MS Office Suite
• MS SharePoint
• MS Windows OS
• MDX
• Power Pivot
• SQL Server Migration Assistant (SSMA)
• MS Visio
• C#

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

BI Developer (SSMS, SSIS, SSRS, SSAS, Tableau)

Responsibilities:

• Participated in gathering requirements and discuss details with team lead
• Involved in all phases of System Development Life Cycle (SDLC)
• Analyzed the source data and figured out correct data mapping to staging tables, data warehouse and data marts.
• Created complex Stored Procedures, Triggers, User Defined Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Used execution plan and tuning advisor to solve performance issues of query and followed instructions to improve query performance
• Performed data cleansing and validation to figure out reportable data based on the requirements
• Designed, developed and implemented ETL procedures using SSIS
• Created packages to validate, extract, transform and load data to a centralized SQL server staging database
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, Aggregate, Sort, Multicasting, Conditional Split, Derived column and Row Count to transform data and validate data
• Applied various tasks like execute SQL tasks to apply stored procedure into the package, script task and Containers like Sequence Container/Foreach Loop Container to well organize the package
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Used data viewer, check point and break point in development for debugging
• Set dynamic connection string to facility the configuration when packages are deployed to different environment
• Deployed SSIS Package into Production and scheduled SSIS jobs through SQL Server Agent
• Develop rich interactive visualizations integrating various reporting components from multiple data source
• Used SQL to pull complex data from data marts with a goal of presenting and visualizing them in Tableau, SSRS.
• Created drill down, drill through report to facility the usability of reports and applied custom expression in defining properties in reports.
• Applied parameters and calculated fields in creating the dashboard to satisfy different user requirements.
• Wrote and maintained technical documentation based on business and functional requirements

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau, SQL Server Management Studio (SSMS), T-SQL

Confidential, New York, NY

BI Developer (SSMS, SSIS, SSRS, Tableau)

Responsibilities:

• Analyzed and review business requirements and interact with Project Manager.
• Important role in team to have quick response to urgent requirements and problems, based on the ability to quickly root problem and find solutions.
• Important role in team to fast learning new technology if needed in development and improvement process and apply it in project to meet business requirements.
• Developed and implemented Stored Procedures, Indexes, Views, Temp Table on SQL Server 2012.
• Performed data cleansing and data validation according to business requirement.
• Applied complicated stored procedures in SSIS
• Designed and implemented SSIS package to migrate data from multiple data sources to data mart for data analysis, deployment and dynamic configuration of SSIS packages
• Coordinated database implementations and changes for transaction analysis department (Created, modified and delivered trouble shooting to T-SQL stored procedures, designed and implemented tables/data structures and performed code reviews)
• Worked with staff from multiple departments to design and build reporting using SSRS that helped streamline the business and make reporting, analyzing, planning and forecasting more efficient
• Developed Ad-hoc reports and modified them by using Tableau.
• Use action and parameter in Tableau to fulfill the requirements
• Created reporting documentation based on best practices and company standards and diagnosed and resolved reporting issues and recommended process improvements

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau, SQL Server Management Studio (SSMS), T-SQL, SharePoint

Confidential, New York, NY

BI Developer (SSMS/SSIS/SSAS/SSRS)

Responsibilities:

• Designed ER Diagram for the new database according to business requirements
• Performed SQL Database Development tasks - Creating database, tables, views, storedprocedures, triggers, user defined functions, index and other database objects, based on business requirements and provided documentation
• Created SSIS Packages to migrate data into new database from various data sources, for example flat file, excel file, SQL Server
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Generated rich graphic visualized report using Tableau
• Created Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects

Environment: MS Visio 2010, SQL Server 2008/2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Visual Studio 2008/2010, T-SQL

Confidential, New York, NY

BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP system and created alerts for successful and unsuccessful completion of schedule jobs
• Designed and developed SSIS packages to extract data from different source files
• Created complex Stored Procedures, Functions, Views, Indexes for increasing performances
• Responsible for performance checks and performed index tuning and query optimization
• Generated Drill-down, Drill-through, and Parameterized Reports using SSRS
• Constructed technical documents for the stored procedure and SSIS packages

Environment: MS Visio 2010, SQL Server 2008/2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Visual Studio 2008/2010, T-SQL

Confidential

BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Developed Stored Procedures, User-Defined Functions (UDFs), Indexed Views, and DML Triggers to maintain database operations, meet operational requirements, and facilitate ETL processes
• Created Clustered/Non-Clustered Index on multiple tables to improve performance of complex queries and stored procedures
• Set up SQL Server Profiler traces for long-running queries/stored procedures and analyzed the traces using Database Engine Tuning Advisor for performance/index recommendations
• Configured SQL Server Integration Services (SSIS) ETL packages to load data from heterogeneous sources such as SAP FICO and XML/Excel/Flat/CSV files
• Created ETL packages to perform incremental loading to Enterprise Data Warehouse (EDW) using Sequence Container, Execute SQL Task, Bulk Insert Task, Lookup, and OLE DB Command

Environment: SQL Server 2005, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), Business Intelligence Development Studio (BIDS), Data Transformation Services (DTS), Report Builder 1.0, Visual Studio 2005, MS Office Suite 2003 (Excel, PowerPoint, Word)