Alisa Wang

Contact No: 408-***-****

Email id: acs1aw@r.postjobfree.com

Summary

7+ years of professional experience as MS SQL Server Business Intelligence developer in SQL Server Management Studio 2005/2008/2008R2/2012; expert in T-SQL, and MS BI products including SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Excellent understanding of entire Software Development Life Cycle (SDLC) and project development methodologies including waterfall, agile, and scrum.

Involved in planning and designing normalized database based on business requirements and documentations; created and modified complex database objects, Temp-Table, Table-Variable, Stored Procedures, User-Defined Functions, indexes, triggers and joins using T-SQL queries, dynamic SQL queries and sub-queries.

Implemented troubleshooting and debugging in database and improved database performance using index, stored procedures, Database Engine Tuning Advisor and SQL Server Profiler.

Operated Data Extraction, Transformation and Loading (ETL), Bulk Copy Program (BCP), bulk insert command, and Slowly Changing Dimensions (SCDs) between homogenous and heterogeneous systems using SSIS control flow tasks and data flow tasks.

Configured and debugged SSIS packages with logging and error handling using Event Handler, SSIS Logging, Checkpoint and Breakpoint.

Configured various transformation including Aggregate, Derived Column Data Conversion, Conditional Split, Multicast, Fuzzy Lookup, Union ALL, Merge, Pivot and Unpivot transformations in SSIS.

Designed data warehouses and data marts using star schema and snowflake schema concepts and principles.

Populated dimension tables and fact tables, created Key Performance Indicators (KPI) and set up security and perspectives.

Experience in creating Report/Dashboard models and generating Reports/Dashboards for business analysis and management purposes using SQL Server Reporting Services (SSRS) and Tableau

Generated different types of reports like ad-hoc reports, dashboard reports, cascading reports, sub-reports, parameterized reports, drill-down and drill-through reports using SSRS

Created worksheets, dashboards and stories in Tableau using different charts and analytic tools

Excellent analytical, communication and problem solving skills; experience with large, complex projects, ability to work with global cross-functional teams and interact with all levels of business and technology resources.

Technical Skillset

MS SQL Server Management Studio 2005/2008/2008R2/2012, T-SQL, MS SQL Server Integration Service 2005/2008/2012, MS SQL Server Reporting Service 2005/2008/2012, MS SQL Server Analysis Services 2012, Visual Studio 2005/2008/2010, MS Access, MS Excel, MS PowerPoint, Tableau 8.0/8.3, MySQL, SAS (9.3/JMP/EG), Google Analytics, Google AdWords, A/B Testing, Multivariate Testing, Predictive Modeling, Windows OS, MAC OS

Education

Master’s Degree in Integrated Marketing New York University, New York, NY

Bachelor’s Degree in Finance and Marketing University of South Carolina, Columbia, SC

Professional Experience

First Republic Bank, New York, NY

MS SQL Server BI Developer (SSMS/SSIS/SSRS/Tableau) 09/2014 – present

First Republic Bank (NYSE:FRC) is a bank and wealth management company offering personal banking, business banking, trust and wealth management services. The goal of the project is to improve ETL automation and reporting support to 'Risk Alert', and to manage risk reports for business units.

Responsibilities:

Analyzed data sources, requirements and business rules, wrote SQL query for ETL development, and assisted database designation

Developed ETL templates, standards, processes & procedures for loading information into data warehousing systems and for ensuring reliability of information loaded.

Coordinated data staging and processing for electronic data processing projects, provided status reports within and across teams.

Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data transformation

Designed and Implemented Stored Procedures and Triggers for automating tasks.

Modified the existing stored procedures to get the new functionality based on the requirements

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independently

Scheduled reports to be delivered to multiple users and subscribers in several intervals as well as forms like Excel and PDF

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)

Configured and maintained Report Manager and Report Server for SQL Server Reporting Services

Created Tabular and Matrix Reports using Report Wizard and Report Designer and identifying datasets, data regions and Report Items accordingly

Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them

Experienced in creating multiple reports in Drill mode using tables, financial tables, cross tabs and charts using SQL Server Reporting Services (SSRS) and Microsoft SQL Server Report Builder

Documented all works and all processes of integration and reporting services for further references

Environment: MS SQL Server Management Studio 2012, Server Integration Services (SSIS), Server Reporting Services (SSRS), Visual Studio 2012, T-SQL, Windows 8, MS Office, Tableau 8.0/8.3

NetApp, Sunnyvale, CA

MS SQL Server BI Developer (SSMS/SSIS/SSRS) 01/2013 – 08/2014

NetApp, Inc (NYSE:NTAP), formerly Network Appliance, Inc., is an American computer storage and data management company. It is a member of the NASDAQ-100. The goal of the roadmap project is to develop a plan for expanding its existing reporting systems with implementation of an enterprise data warehouse.

Responsibilities:

Designed, developed, and supported all extraction and integration processes (ETL)

Developed database procedures, transformations, integrations, and queries to access and transform data

Used ETL and SQL technologies to prepare data for business intelligence applications and reporting tools (Tableau, SSRS)

Performed data analysis and propose and ensure transformation covers all data possibilities including managing data anomalies

Implemented processes to ensure data quality in the database systems

Performed relational and multidimensional modeling and schema creation

Developed cube dimensions, measure groups, calculations, and any data management code for the partitioning schemes

Provided in-depth troubleshooting skills to assist in resolving errors and performance issues including tier 2 production support

Complied with internal development coding standards, procedure guides, and checklists for the support of the database systems

Focused on performance tuning, optimization and scalability to ensure efficiency in the environment

Assisted with building our data as a service products such as master data management, data governance and data mining

Implemented and managed small to medium-scale projects involving multiple systems

Worked with business users to capture business metadata and maintained data dictionaries

Optimized existing schemas through normalization and de-normalization techniques

Environment: MS SQL Server 2012, SQL Server Integration Services, SQL Server Reporting Services, T-SQL, Tableau 8.0, Windows 8

BlueChoice HealthPlan, Columbia, SC

MS SQL Server BI Developer (SSMS/SSIS/SSRS) 01/2012 – 12/2012

BlueChoice Health Insurance Services offers consumer directed health care insurance plans for all segments of the population including small businesses and individuals. The Project was to develop the analytical and operational reports, and maintain and monitor the report server using Microsoft SQL Server. Also it involved receiving the data from the application, formatting the data suitable to the device, executing the command, receiving the response and displaying it as per the user’s query. The reports are for operation management and marketing analysis.

Responsibilities:

Created complex Stored Procedures, triggers, User Defined Function (UDFs), tables, views and other SQL joins and statements for applications.

Monitored database servers, error logs and events, scheduled backups and customized jobs.

Created SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).

Designed high level ETL architecture for overall data transferring from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.

Developed Custom Reports, Ad-hoc Reports Tabular, drill down, parameterized, cascaded and sub-reports using SQL Server Reporting Services

Gathered and analyzed requirements directly from the business users.

Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.

Defined test conditions and develop accurate and complete test plans

Created packages using SQL Server Integration Services (SSIS) from various databases into different file systems

Developed complex expressions to calculate, group, filter, and format the contents of reports

Created Parameterized Reports using Stored Procedures and Query report parameters and cascading parameters

Created complex reports and enabled drill-down functionality and applied the required formatting

Developed Sub-reports and Master-reports accessible by bookmarks

Created and develop complex SQL queries using various Joins, Sub-queries, and Stored Procedures

Environment: MS SQL Server Management Studio 2008, Visual Studio 2008, T-SQL, Windows 7, SQL Server Integration Services (SSIS), Server Reporting Services (SSRS), MS Office

Synovus Bank – NBSC, Columbia, SC

Business Intelligence Developer (SSIS/SSRS/SSMS) 09/2010 – 12/2011

NBSC is a division of Synovus Bank, one of the largest community banks in the Southeast. The goal of this project was to create business intelligence objects to analyze the data acquired from the various applications and to create reports that help higher management to make decision on budget management based on current expenses.

Responsibilities:

Created dynamical queries, indexes, stored procedures, views, joins and User defined functions, triggers and implemented as per the business requirements for secured data storage, efficient data manipulation and troubleshooting

Designed and deployed various ETL packages to migrate the data coming from flat file, Excel, XML and SQL Server and to synchronize daily transaction data

Generated different types of reports from SQL Server and OLAP Enterprise Data Warehousing, and daily list reports using stored procedures

Developed and deployed Tabular Reports, Matrix Reports, Drill-Down reports, Cross-Tab Reports and Ad hoc reports using SQL Server reporting services (SSRS)

Maintained and modified reports using XML for updated web data service and using Report Builder for Ad-hoc reports.

Scheduled and subscribed reports using Report Server

Designed, implemented data mart, facts, dimensions and online analytical processing (OLAP) cubes using dimensional modeling standards, and created cubes using SSAS

Deployed the cubes and verified the result on the browser. Exported cubes to Pivot Tables in Excel for business analysis

Logical and physical database development using Normalization, Dimension Modeling and Enterprise Manager.

Environment: Windows 7, MS SQL Server 2008, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, MS Team Foundation Server, T-SQL

First Citizens Bank, Columbia, SC

MS SQL Server Developer/ Reporting Developer 09/2009- 08/2010

First Citizens Bank is a bank holding company based in Raleigh, North Carolina provides a full range of banking products and services to meet individual or business financial needs. The goal of the project was to create timing reports for the internal business users by using BI tools to analyze the data from the digital products and to integrate date by using SSRS and T-SQL for the preparation of reports and the integrity as well as uniformity of databases.

Responsibilities:

Carried out a Developer’s role on MS SQL Server 2005 and MS Access Databases.

Utilized business intelligence tools to provide analytics and advisory consulting based on customer insights.

Developed the views, packages, metadata, reports and report definitions.

Developed dashboards, graphs, charts and portal interfaces in SSRS

Translated business requirements into accurate reports within the confines of the SSRS platform.

Used DTS for data population from different sources, created DTS packages for data conversions and loaded data from flat files and excel files.

Generated daily report list using SQL queries and Stored Procedures.

Environment: MS SQL Server 2005, SQL Reporting Services, T-SQL

Contact this candidate