Sql Server Data

Frank Y

ETL developer/ SQL BI Developer

Professional Summary:

Around 5 years of IT experience in various Industries in health care company and financial company.

Excellently experienced in using Transact-SQL, PL-SQL, and XML to create, develop and test functions, stored procedures, applications and packages. .

Proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, relational database models and data integrity, SQL joins and query writing.

Experienced in logical, physical and dimensional data modeling, data mapping, and data normalization.

Excellently experienced in using various ETL tools to manipulate data workflow including their applications such as BCP utility, data transformation services.

Experienced in writing Parameterized Queries for generating and developing drill through, drill down reports, formatting report layout, sorting the data in SSRS.

Sound experience and understanding of SSAS, OLAP Cube, Dimensions in software development.

Extensively used PivotTables/Tableau to perform data visualization for analysis purpose.

Technical Skills:

Language: SQL, HTML, XML, MDX, C# Net.

Database: SQL Server, MySQL, Teradata, Oracle

Tools: SSIS, SSRS, SSAS, Alteryx Analytics, MS Office Suite, SQL server Management studio built-in tools, Tableau Software, Crystal Reports

Methodology: Waterfall/Agile Software Lifecycle Development.

MS Certificate: Querying MS SQL Server 2012 (892/1000)

Others: AWS System (Redshift, S3), Erwin, GIT Version Control, Subversion Version Control (SVN).

Professional Experience:

Our Piece of the Pie, Hartford, Connecticut 02/2015- Present

SQL BI Analyst

Responsibilities:

Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.

Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.

Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis using SQL Server Agent

Designed, Developed and Generated Sub-Reports, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS.

Created dynamic worksheets by using PowerPivot and created charts and graphics in MS Excel.

Configured the report viewing security for various users at various levels using Report Manager.

Implemented data mart, facts, dimensions and OLAP cubes using SQL Server Analysis Service (SSAS).

Experienced in using SQL profiler, Execution plan and database engine tuning advisor to improve SQL DB performance.

Environment: SQL Server 2012, SSRS, SSIS, SSAS, MDX, MS Excel 2010, SQL Profiler, Erwin.

CareSource Inc, Dayton, Ohio 06/2014-01/2015

ETL developer /SQL Data Analyst

Responsibilities:

Worked Closely with QAs to understand business and functional requirements used for technical design and quality solution

Hands on experiences in using SQL coded to create Database Objects in SQL Server.

Actively involved in Normalization (3NF) & De-normalization of database using ERWIN.

Created SSIS packages to load data from XML, CSV, Excel files to SQL Server 2012 by using Lookup, Derived Columns, Aggregate and Slowly Changing Dimension

Hands on experience in using SSIS to perform data profiling, data cleansing accordingly.

Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

Involved in preparing implementation plan and turnover documents for Ops team to run.

Involved in revision control system and performed SVN cleanup periodically.

Supported for business team by generating reports per their requirement.

Used Tableau software to create dashboards for reporting service.

Environment: SQL Server 2012/2008R2, SSRS, SSIS, Tableau Software, XML,MS Access 2010, MS Excel, Simple storage service, Redshift, Subversion, Visual Studio, C#.net.

Glass Capital Research Inc, New York 04/2013- 04/2014

SQL BI Developer

Responsibilities:

Created ETL Modules to load financial data with various types into external database SQL server using Alteryx analytics.

Generate testing utility, test cases and perform ETL testing under the testing environment.

Performed data source management and share any updates using GIT source tree.

Prepared planed English Documents to whole team member for explanation purpose.

Issued tasks and report my job status on JIRA system Dashboard.

Created Alteryx Modules to load data from the Legacy system to a Data mart for analyzing data.

Created SQL Server tabular reports, Sub reports, Drill down, Drill through, Ad-hoc, Cross-tab, parameterized report using SSRS to fit business requirements.

Supported remote assistance for operation teams for debugging purposes.

Environment: SQL Server 2012, SSRS, Alteryx Analytics, Jira, MS Office Suite, Git, MS BIDS, Visual Studio

Ecovane Environmental, Shanghai, China 09/2011 – 08/2012

SQL/SSRS Developer

Responsibilities:

Utilized Joins and sub queries to create ad-hoc report to meet business requirements

Designed and documented report layout and formation according business requirements.

Used SQL Server Agent to schedule reports to be generated on predetermined time.

Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Brought SSAS Cube into MS Excel PowerPivot for reporting purposes.

Documented for unit testing plan of reports performance.

Worked with customers and collected feedbacks for the reporting optimization purposes.

Environment: SQL Server 2008R2, SSRS, SSIS, SSAS, Ad-hoc reporting, MS Excel

EDUCATION

Master of Science, Computer Sciences – Columbia University, NY

Bachelor of Science – Computer Sciences – University of Science & Technology, Beijing

Reference will be furnished upon request

Contact this candidate