SUMMARY

• Highly qualified Business Intelligence Developer with over 7 years of IT experience in Database development and maintenance for Transportation, Financial Services, Manufacturing, and Hospitality industries.
• Strong business acumen and exposure to financial services (banking) industry have passed the CFA I.
• 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
• MDX
• 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
• Report Builder
• MS Office Suite
• Tableau
• MS SharePoint
• MS Windows OS
• MAC OS
• Power Pivot
• SQL Server Migration Assistant (SSMA)
• MS Visio

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

BI Developer (SSMS, SSIS, SSRS)

Responsibilities:

• Analyze 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.
• Developing and implementing Stored Procedures, Indexes, Views, Temp Table on SQL Server 2012.
• Perform data cleansing and data validation according to business requirement.
• Develop stored procedures to process raw data to staging area which should meet business requirement such as revenue, cost, etc.
• Apply 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 and MS Report Builder. Created Cache reports and Snapshot reports for retrieving history reports.
• 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, Queens, NY

MS SQL Server/BI Developer (SSMS/SSIS/SSRS/Tableau)

Responsibilities:

• Involved in writing T-SQL statements which includes joins and functions.
• Implemented complicated transactions for the existing tables.
• Optimized existing stored procedure by monitoring through SQL profiler
• Used common table expressions for better performance in executing commands
• Worked with SQL in-built functions and user defined functions which includes scalar and table valued functions
• Created views for extracting a specific set of data in different procedures
• Exported or imported data from sources such as flat files and excel files using Import/Export through SSIS
• Normalized and de-normalized tables to maintain referential integrity by using Primary and Foreign Keys
• Involved in generating report using SSRS for in-house management system
• Involved in generating rich graphic visualized report using Tableau for end user
• Proficient in creating and formatting various reports such as drill down, drill through, sub reports and parameterized reports

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

MS SQL Server 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
• Involved in Java servlet development, including connection with database using JDBC, receiving requirements from front end website, loading accordingly information from database, sending information back to front end
• Involved in Java service development, mainly applying business logic in the Java code
• Completely followed Model-View-Controller (MVC) rule in the developing process

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

MS SQL Server/BI Developer

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 schema requirements

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

MS SQL 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, Windows Server 2003 R2, Visual Studio 2005, MS Office Suite 2003 (Excel, PowerPoint, Word)