SUMMARY

• Professional Business Intelligence Developer with 7+ years of experience in Insurance, Finance and Media industries specializing in MS SQL Server 2008/2008R2/2012 design, development and testing, expertise in T - SQL,SQL Server Management Studio(SSMS), SQL Server Integration Server(SSIS) and SQL Server Reporting Services(SSRS), Oracle SQL, SAS, SAS Enterprise Miner, Tableau and Software Development Life Cycle(SDLC)
• Extensive experience in designing and building Databases, Data Warehouses including designing Dimension Tables and Fact Tables, and adding constraints such as primary key, foreign key and index
• Highly proficientwithStored Procedures, User-Defined Functions(UDF), Common Table Expressions(CTE), Temp Table, Table Variable, Views, Dynamic SQL and Pivoting
• Adept in Error Handlingwithin the design processes
• Highly experienced in creating fast and multiple searches by using Dynamic SQL to support design of software for business users
• Expertknowledge in designing and granting security for database, stored procedure, views and etc
• Effectively deliver table transformation and migration by using ETL process in SSIS from multiple sources to multiple destinations including OLEDB, Excel, Flat file and XML
• Strong-skilled in configuring and deploying SSIS working packages into servers
• Proficiency in designing and creating Drill-Down, Drill-Through, Parameterized, Sub and Heat Map Reports usingSSRS
• Experienced in deploying reports to online servers and scheduling subscriptions
• Lead Involvement in building reports based on cubes by applying MDX queries
• Comprehensive understanding in visualization using Tableau, and create reports, dashboards and stories
• Expertise in Time series forecasting, Data Preprocessing and Data prediction using SAS and SAS enterprise miner for the need of business analysis
• Outstanding communications as a strong solution oriented team player, providing best support and solutions to achieve all critical business objects

TECHNICAL SKILLS

Data Management Tools: Microsoft SQL Server 2008/2008R2/2012, SQL Server Integration Services,Oracle SQL Developer 11g

Business Analysis Tools: SQL Server Analysis Services, SAS, SAS Enterprise miner, JMP, Excel

Reporting Tools: SQL Server Reporting Services, Report Builder, Tableau 7.0/8.0/9.0

Environment: SharePoint 2010/2013, Team Foundation Server(TFS)

Operation Systems: Windows XP/7/8

Others: ASP.NET, C#, Microsoft Office Suits 2003/2007/2010/2013 (Word, Excel, Visio, PowerPoint, Outlook)

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

SQL Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Partnered with Claim IT, Business analysts, Strategy Team and project managers while providing technical direction to a team of data analysts, Report developers ensuring successful project delivery and support.
• Implemented strategic plan for information delivery by planning and designing information logging system using transaction.
• Created stored procedure to store CTE and Table valued parameters in order to optimize database functionality.
• Analyzed and confirmed the business need with Business Analysts, and created view to store complex table for future analyze and report.
• Imported data from flat file, EXCEL and XML source to OLEDB destination using SSIS in order to implement database for claim needs.
• Applied multiple transformations such as Derived Column and Conditional Split to increase table readability.
• Developed Slowly Changing Dimension to record any new insert to certain tables for the needs of time series forecasting.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to the IT and Business Analysts team.
• Created scrip tasks with C# to pop up windows for result monitor.
• Deployed SSIS Package into Production and used Package configuration to adjust various package properties and make package environment independent.
• Deployed SSRS report to server and made possible changes according to requirement from business users by report builder.
• Delivered Tableau reports from Data Warehouse with customized visualization of worksheets and dashboards.

Environment: SQL Server Management Studio 2012, SQL Server Integration Services 2012, SQL Server Report Services 2012, Visual Studio 2012, EXCEL 2010, Tableau 8.3/8.0, TFS, C#, ASP.NET, MS Office, Windows 8/7.

Confidential, Cheshire, CT

BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Gathered user requirements to develop business logics, analyzed data needsand designed database solutions.
• Load necessary tables to database from Excel, XML and flat file source by SSIS.
• Completed complex SQL queries for analyzing purposes and created multiple stored procedures, views and UDFs to implement the business needs.
• Created multiple pivot tables using SQL query and stored them into views for future reporting needs.
• Designed and programed transactions, stored procedures and Error log table to record Error messages for debugging purposes.
• Responsible for debugging and tuning during the test period, creating indexes and security design for database to improve performance.
• Designed and created reports based on business requirement with drill-down, drill through and parameter features with the new database using SSRS.
• Deployed report to database server and set subscriptions on a weekly basis.
• Created visualization report to support the decision making process using Tableau.

Environment: MS SQL Server 2012, SQL Server Integration Services 2012, SQL Server Report Services 2012, Tableau 7.0, Excel 2010, SharePoint 2010, MS Office, Windows 7.

Confidential, Dallas, TX

Business Intelligence Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Analyzed existing database and assisted in designing extensions to the data warehouse systems by creating ETL packages to migrate data from multiple sources to the SQL Server.
• Learnt and assisted on creating Triggers and Indexes to increase the performance of the data warehouse.
• Created Views for complex queries and designed security for each existing role in the database.
• Worked closely with the Data Architecture team and provided technical design recommendations on the data mart structures.
• Debugged and tuned existing database and process, and created error logging table in database to catch possible errors with stored procedures and transaction.
• Implemented script task with C# to monitor the row count number.
• Backed up and restored database among different servers.
• Deployed SSIS projects to different servers.
• Developed parameterized reports in SSRS for business users and other stakeholders.
• Deployed reports and scheduled subscriptionsby using SSRS and Report Server.
• Implemented Report Server Securities by creating different roles.

Environment: SQL Server Management Studio 2008R2, SQL Server Integration Services 2012, SQL Server Reporting Services 2012, SharePoint 2010, MS Office, Windows 7/XP.

Confidential, New York City, NY

Business Intelligence Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Designed, developed and implemented data architecture for SQL Server database with T-SQL queries.
• Created ETL packages to migrate data from Oracle source to OLEDB destination.
• Applied multiple transformations including derived columns and conditional split in SSIS to load data to ODS for reporting and analyzing need.
• Debugged with data conversion transformation to ensure the data type.
• Created stored procedures to call transactions for the database to avoid possible wrong information being loaded to the database.
• Created report using SSRS to show the views of the ads under each category and applied drill through function to link to detailed report of the certain category.
• Added drill down and Parameter features to the report for the benefit of business users.
• Deployed the report to online server and schedule automatic snapshots on a weekly basis.

Environment: SQL Server 2008, Oracle SQL Developer 9, Oracle 10g/9i, SQL Server Integration Services 2008, SQL Server Report Services 2008, SharePoint 2010, Windows 7/XP.

Confidential

Business Intelligence Analyst (SSMS/SSIS/SSRS)

Responsibilities:

• Dealt with raw dataset and prepared data with Excel and SAS.
• Created basic table descriptions to define metadata for each column.
• Identified relationships between tables and reported to supervisor.
• Created stored procedures based on business requirements and collaborated with business analytics team to build views to serve data mining process.
• Dropped and recreated indexes to increase the database performance following instructions.
• Developed pivot table using T-SQL to prepare for the report.
• Created automatic backed up function in SQL server agent and scheduled the backup on a certain frequency.
• Implemented tables by normalization and denormalization using Derived Column in SSIS.
• Built report with market research team using SSRS to analyze market performance on different levels of products, features including drill-down, drill-through, parameter and heat map.
• Deployed reports to report server and scheduled auto email services to several business users and stakeholders.

Environment: SQL Server Management Studio 2008, SQL Server Integration Services 2008, SQL Server Reporting Services 2008, Excel 2007/2003, SAS 9.2, MS Office, Windows XP.