SUMMARY

• Over 7years of experience in analyzing, designing, developing, implementing, and maintaining database solutions through business intelligence using SQL Server2012/2008R2/2008/2005, SQL Server Integration, Analysis and Reporting Services (SSIS, SSAS, SSRS)
• Proficient experience in designing logical and physical data model, data mapping, data profiling on SQL Server 2012/2008R 2/2008/2005.
• Experienced in programming tasks - stored procedures, triggers, cursors, views, user defined functions, sub-queries and joins for complex queries involving multiple tables usingSQL Server 2012/2008R2/2008/2005withT-SQL to assist efficient data manipulation and data consistency.
• Advanced reporting skills using SQL Server Report Builder 3.0/2.0, SQL Server Reporting Services(SSRS)2012/2008R2/2008/2005, Crystal Report and Tableau 7.0, involving a variety of features like chart, matrix, sub-report, drill-down, drill-through, filter, gauge, indicator, map, parameter, snapshot reports, bubble, tree map, cache reports, etc.
• Vast experience in utilizing SharePoint and Microsoft BI Power Tools such as power pivot, power map, dashboards, scorecards for the creation of more interactive, appealing reports
• Skilled in SharePoint to create a secure environment for file sharing, collaborating and document managing.
• Extensive practice in extracting, cleansing, transforming and loading data from OLTP (transactional) databases and other data sources, including heterogeneous and homogeneous sources, into Data Warehouse for further Business Intelligence Analysis using SQL Server Integration Services (SSIS)
• Excellent command over designing, developing and executing SQL Server Integration Service (SSIS) 2012/2008R2/2008/2005 package using various control flow and data flow transformation.
• Implemented check points, break points, event handlers and error handling in SSIS packages to improve usability and liability.
• Proficient in data modelling and dimensional modelling techniques such as snowflake schema, star schema and normalization.
• Efficient in designing, deploying, and processing OLAP cubes, creating data source views, queries, dimensions for business analysis utilizing SSAS 2012/2008R2/2008/2005
• Excellent working experience in creating KPIs, attribute relationships, measures, hierarchy using SSAS 2012/2008R2/2008/2005
• Involved in query optimization and performance tuning using SQL Profiler, Index Tuning Wizard, Clustered Index and Non-clustered Index
• Excellent presentation and interpersonal skills combining with problem solving and analytical skills
• Fluent in English and Mandarin

TECHNICAL SKILLS

• MS SQL 2012/2008R2/2008/2005
• MS Visio
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services(SSAS)
• SQL Server Integration Services(SSIS)
• Data Transformation Services (DTS)
• T-SQL
• SharePoint 2010
• Report Builder 3.0
• MS Office Suits 365/2013/2010/2007
• Windows XP/Vista/NT/7
• Power Pivot
• Power BI Office 365
• Visio 2012/2010
• Power Map
• VBA
• Photoshop
• MS Project 2013/2010
• Tableau7.0
• Minitab 17/16
• Bloomberg Terminal

PROFESSIONAL EXPERIENCE

Confidential, Pasadena, CA

MS SQL Business Intelligence Developer

Responsibilities:

• Designed and developedSSIS Packagesto extract, cleanse, transform and load data fromExcel, CSV,Flat files and SQL Server destination into data warehouse
• Involved in a complete SSIS life cycle in building, deploying and executing the SSIS packages using multiple transformations such as Conditional Split, Derived Column, Lookup, Fuzzy Lookup and Data Conversion.
• Worked on updating and maintaining customer information using Slowly Changed Dimension for address and last name changes using SSIS
• Created alerts for successful and unsuccessful completion of scheduled jobs using SQL Server Agent
• Designed and constructed dimension tables and fact tables for retail banking data warehouse
• Created and managed OLAP cubes using SSAS to perform analysis based on business requirements.
• Developed different dimensions, hierarchies and KPIs to evaluated the bank performance
• Designed and created Report templates, bar graphs, pie charts and scatter charts based on the financial data.
• Scheduled, created snapshots and subscriptions for the reports using SSRS 2012
• Used Power BI, Power Pivot, Tableau and Crystal Report to generate better visual reports, including maps, charts, tree maps, histogram, box and whisker plots, bubbles, dashboards and etc. in order to help making better decision
• Created complex SQL queries, stored procedures, triggers, views, cursors, joins, and user defined functions, clustered index and non clustered index to implement the business logic.
• Advised optimization of queries by using SQL profiler
• Used SharePoint to securely shared, collaborated files within team members

Environment: MS SQL Server 2012, MS SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS) 2012, T-SQL, MS SQL Server Management Studio 2012, Windows 7, Power BI, Power View, Power Pivot, SharePoint 2010, Visual Studio 2010, SQL Server profiler, MS Visio 2010, MS Report Builder 3.0, Tableau 7.0, Crystal Report

Confidential, Richmond, VA

MS SQL Server Developer

Responsibilities:

• Created complex T-SQL queries for faster retrieval of data and to display specific information
• Tuned SQL queries for better performance using SQL profiler
• Extracted and manipulated data from heterogeneous data sources such as MS Access, Excel and flat files from different schools and departments records using SQL Server Integration Services 2008R2
• Created complex SSIS packages using proper control flow and data flow elements
• Used the transformations such as merge, data conversion, and conditional split to distribute and manipulate data to the destination in SSIS 2008R2
• Developed and deployed cubes using SSAS 2008R2, analyzing student data in different dimension that help and-users better understand the performance
• Responsible for the deployment of the reports, such as matrix, table, charts, parameter on the reporting server and scheduled subscription for the windows file share using SSRS 2008R2, Report Builder, Tableau 7.0 and Minitab 16
• Developed the email-subscriptions schedules on report server
• Created snapshots for the reports for security and backup purpose
• Provided technique assistance and small group training for reporting.

Environment: MS SQL Server 2008R2, MS SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS), T-SQL, MS SQL Server Management Studio 2008R2, Windows 7, Report Builder 3.0, Visual Studio 2010, Tableau7.0, Minitab 16

Confidential, Philadelphia, PA

MS SQL Server/BI Developer

Responsibilities:

• Designed and developed SSIS packages using various control flow and data flow items to extract, transform and load data from different data sources.
• Utilized SSIS to migrate data from database to the data mart for analyzing and reporting purpose
• Involved in designing dimensional model, star schemas and snowflake schemas
• Created and configured OLAP cubes with fact and dimension tables to analyze financial performance through SSAS 2008R2.
• Exported cube data in MS Excel 2010 to create power pivot and power view and added features like slicers to make interactive reports
• Generated periodic reports, such as matrix, drill-through reports, drill-down reports, cascaded parameters, gauge, filter, maps, sub-reports, and etc, based on the statistical analysis of the data using SSRS 2008R2, MS Excel and Report Builder 3.0 for the executives and business users.
• Created pivot tables in Excel using data from various sources like SSRS and MS Access
• Developed SSRS reports for the cubes and deployed the reports to the report server and managed the access authority and created subscriptions for the reports
• Managed the snapshots, subscriptions and securities for the reports on the reports server
• Used SharePoint to create a secured environment for file sharing between the team members

Environment: MS SQL Server 2008R2, T-SQL, MS SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS) 2008R2, MS Office 2010, Report Builder 3.0, SharePoint 2010

Confidential, Newport News, VA

Business Intelligence Developer

Responsibilities:

• Participated and interacted with team lead and dieticians to understand the requirements of the project
• Developed and tested complex T-SQL database objects using stored procedures, functions, views, indices, and triggers on MS SQL Server
• Designed the data mart structure and built the dimension tables and fact tables and relative keys
• Responsible for query optimization using MS SQL tools such as SQL profiler, index tuning wizard
• Migrated data to variety of data marts from different sources such as flat files, excel and SQL server destination using SSIS 2008
• Designed, developed and deployed ETL packages using several transformations such as Derived column, Sort, Merge, Union All and Conditional Split
• Created cascading reports, sub reports, charts, parameterized reports, drill down reports, drill through reports, gauge and filter for the analysis of data for clients to help them in taking complex decision
• Subscribed reports on report server, assigned permissions using the report manager, allocated required security levels per report.

Environment: MS SQL Server 2008, MS SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS) 2008, T-SQL, MS SQL Server Management Studio 2008, Visual Studio 2008, MS Office 2007

Confidential

MS SQL Server Developer

Responsibilities:

• Communicated with teams across departments and end-users to identify business needs and discuss solution options.
• Developed complex Stored Procedures, Joins, Indexes and Views using T-SQL in SQL Server 2005 to retrieve customer and Itinerary information.
• Enriched in design and optimize T-SQL query to solve specific selection requirements
• Created SSIS packages to load data from OLTP system to data mart for further business intelligence analysis
• Performed various transformations like conditional split, sorting, data conversion, union all, merge and derived column
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks
• Created different types of reports including parameterized, matrix, gauge, filter, drill down, drill through, and cascading reports
• Managed report security by setting different user levels

Environment: MS SQL Server 2005, T-SQL, DTS, MS Office 2007, Window XP, MS Office 2007