SUMMARY:

• 10+ years of hands - on working experience in data visualization (SSRS).
• 10+ years of hands-on working experience in computer programming, ETL (DTS and SSIS), database performance tuning, designing and implementing.
• 10+ years of strong analytical, problem solving and communication skills in Academy and Industry
• 10+ years MS Access Report Automations by SSIS, MS Access and Excel VBA
• Quick learner, excellent team player and work well in a fast paced environment

TECHNICAL SKILLS:

Database and ETL: Microsoft Access, MySQL, SQL Server Database 2000~2016, Oracle Database 8, 9i, 10g, Database Design & Creation, Backup & Recovery, Performance Tuning, Upgrade, Data Warehousing, Oracle SQL Developer, ETL, SSIS, SSRS, SSAS, MS SQL Server Report Builder, MS Power BI, Tableau

Programming: C, Visual Basic (5.0, 6.0 & .NET) and C#, VBA MacroT-SQL, Dynamic SQL, PL/SQL, SQL Plus, PHP, ASP, ADO, VBScript, JAVA Script, Crystal Report, HTML, XML, e-Commerce, Web Hosting Service, TCP/IP, FTP, CSS, IIS 6, 7, 7.5 and 8, Apache, MS-DOS, Unix/Linux, Active Directory, Dual Domain Setup, WINSAS400, GeoAccess, GeoCode, Altosoft, Python, Spark, Scala

Statistic and Scientific Applications: SPSS, SAS, Prism, Adobe Photoshop, Living Image 3.0, NMR1, Bruker 360, IGV

Microsoft Application: Microsoft Office 360 including MS Project and MS Visio, MS Power BI Apps

Soft Skills: Outstanding Communication Skills, strong team player, extensive collaboration among different departments in the company as well as with external clients/consultants.

PROFESSIONAL EXPERIENCE:

Confidential

Application Data Programmer

Responsibilities:

• Working with business analysts and stakeholders to understand entire business processes, gather and document project requirements and design and analysis, and translate them into detailed specifications for BI reports and applications. Developing data models, visualizations, deployment, and support. All work with Agile Methodology (JIRA software).
• Maintain and Modify Altosoft Analytic Visualization System including frontend dashboard, backend database and built-in ETL
• Lead Team to Develop Pathology Slide Distribution Visualization System (Equal Job Distribution System) with BI tool: SQL Server Reporting Service (SSRS), SQL Server Integration Service (SSIS) and SQL Server Database
• Develop and Support Pathology Slide Distribution Summary Ad-hoc Reports for Managers and Directors. Visualize KPIs with Dashboards (SSRS 2016) or PowerBI.
• Create SSIS Packages for Pulling Data from Copath System (Sunquest) and Lab System (Sybase) to SQL Server Databases
• Lead Team to Upgrade SSRS 2008 R2 to SSRS 2016
• Create and Maintain SSRS 2016 Mobile Reports with SSRS 2016 Mobile publisher
• Automate Pathologist Work Scheduling Process by SFTP, VBA Macro, SSIS and Window Task
• Develop Capital Blue Cross Performance Metric Dashboards including GeoAccess Reports
• HNL Client and PSC Sites Map Dashboard with SSRS For Senior Executive Management
• Rhodes Report Engine (RRE) Support for Lab Result Report
• Working on Big Data Project with following technology (Hadoop, Spark, HIVE, Nifi and Sqoop) and Visualization tool(Tableau)
• Complted Edureka’s Big Data Hadoop Group Course (two months) covers in-depth knowledge on Big Data and Hadoop Ecosystem tools such as HDFS, Ambari, YARN, MapReduce, Hive, Pig, HBase, Spark, Oozie, Flume and Sqoop.

Confidential

BI Consultant

Responsibilities:

• Develop Report Automations with SSIS, Access and Excel VBA Macro
• Responsible for loading data with SSIS packages and creating ten major tables for Finance group, manipulate large table with 90 million recorders
• Generate over sixty Monthly Finance Reports with SSRS and Access by SSIS
• Develop New reports with SSRS
• Develop Stored Procedures, Views and T SQL
• Develop Dynamic SQL generator by VBA

Confidential

Database/Application Migration Consultant

Responsibilities:

• Work with IT project management and technical staff to discuss and plan timelines and project action items.
• Investigate existing application and database code to determine migration path needs.
• Work with end-users and IT business analysis staff to understand/revise technical requirements documentation.
• Analyze report, and modify application and database security models to conform to current standards.
• Installations and configuration of SQL Server 2012 on Windows Server 2012.
• Database Migration from SQL Server /2012.
• Write and modify the SQL queries, Stored Procedures and Views
• Set up IIS and migrate Classic ASP and PHP application intranets backend databases from Windows Server and 2012.
• Upgrade and Modify VB.Net Windows Application
• Migrate DTS package to SSIS and develop new SSIS package.
• Transfer jobs and create database links.

Confidential

SQL Specialist

Responsibilities:

• Install SQL Server 2008 R2 and SSIS developer
• Migrating SQL Server 2000 Data Transformation Services (DTS) packages to SSIS Packages

Confidential

ETL Developer / DBA

Responsibilities:

• Database Design and Create Tables, Views, Stored Procedures, Function, Triggers, T-SQL statements for various applications
• Develop scripts to automate administration and management
• Performance tuning with profiler, database tuning adviser, Query plans.
• Planning and scheduling backups and developing recovery procedures
• Monitor and Manage Database with SQL Server and Oracle Enterprise Managers
• Design and develop ETL data integration processes and programs to support the data warehousing. The responsibilities including data analysis, source to target data mapping
• Develop SSIS packages using various control flow and data flow tasks, SSIS packages configuration, deployment and job scheduling
• Create customized reports such as complex drill down & drill through report, matrix report, sub report and chart by using SSRS based on Mouse and Phenotype databases.
• Experience with SSIS in loading XML, excel, flat file and other delimited formats
• Develop and maintain mouse phenotype data visualization application by VB and Oracle database
• Manage data for a Ten Year Pfizer contract with total more than 130 projects (over hundred assays per project) and working directly on Pfizer database including creating tables, data uploading & validating and troubleshooting. Interact with external and internal clients (Pfizer IT analyst and Scientists, Taconic scientist and project managers) for their special needs and some potential issues
• Develop and build an automatic data analysis tool by using VBA Macros, VB.net for assays. The system has helped scientists to increase data processing capacity, efficiency and accuracy
• Creative the novel functions by using Microsoft Project Macro to enhance the system flexibility, efficiency and accuracy
• Perform weekly and monthly Server data backup
• Design, implement and test time tracking system by using MS Access database. Generate executive report to senior managers and finance department

Confidential

Data Analyst

Responsibilities:

• Developed VBA macro for NMR spectra data analysis
• Developed data acquisition software by VB6 which is able to collect data from eight scales simultaneously.
• Serve as a technical consultant for a lab of Brigham and Women's Hospital and Harvard Medical School