JIAYUAN SONG

857-***-**** / ac2j53@r.postjobfree.com

Bay Street, Fremont, CA

SUMMARY

4+ years of IT experience in Design, development & Administration of Business Intelligence Solutions with Microsoft SQL server 2012/2008/2005/2000 with various business domains like Pharmaceutical, Information Technology.

Good experience in Information Technology field as a SQL server Developer with strong expertise in SQL server development, designing Stored Procedures/Transact-SQL coding.

Excellent in High Level Design of ETL - DTS Packages & SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2012/2008/2005.

Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity

Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues.

Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.

EDUCATION

Master of Arts in Business Administration(Information Sys&Technology) May,2019

William Jessup University,San Jose, CA

Master of Science in Computer System Engineering May, 2014

Northeastern University, Boston, MA

Bachelor of Science in Computer Science August, 2008

China Institute of Defense and Technology, Beijing, China

SKILLS

Languages

SQL, T-SQL, PL/SQL. HTML, XML,

Databases

SQL Server 2012/2008/2005/2000/7.0, Oracle 9i/8.x

Reporting Tools

SQL Server Reporting Service (SSRS)

Other Tools

SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data

Other Software

MS Office- 2007/2003/2000, SharePoint

Operating Systems

Windows /98/2000/2003/XP/Vista, Unix, Linux RedHat 5.2/5.0/4.0

Database Tools

SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio(SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS)

Methodologies

Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

EXPERIENCE

Sep 16 - Aug 17 Data Analyst XCG Design Corp, NY

XCG Design Corp is an international corporation focused on the multiple business consultants in United States and China. We have a professional team of consultants in multiple industries, such as Finance, Environment, Engineering, Supply Chain and Database. XCG Design has been serving a large amount of clients who are doing business between United States and China.

Involved in Physical / Logical design of database, creating and managing the database and all the database objects.

Created ER diagrams (physical and logical using Erwin) and mapping the data into database objects.

Worked with Implementation team and closely moved with end users to implement manufacturing solutions.

Worked closely with developers, end users and Administrators in designing and creating databases and other objects.

Actively involved in designing databases for the system.

Created new tables, written stored procedures for Application Developers and some user defined functions.

Creation/ Maintenance of Indexes for fast and efficient reporting process.

Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights.

Deploy SSIS packages via MS VS and use SSRS to develop different kinds of reports.

Oct 15 - Jun 16 Data Analyst Pfizer,Inc, Peapack, NJ

Adjust BOX technology to be used as a document share platform and use Java to successfully test.

Experienced using TOAD, SQL Developer tools to develop Oracle stored packages, functions and procedures for Oracle database back-end validations.

Create updated triggers based on new tables with journal tables for inserting, updating and deleting.

Develop and generate different kinds of reports based on the data getting from database.

Use Pipeline Pilot to do some ETL process and do comparison with different reports.

Created test case for testing new developed software and platform.

Take part in AAEM project for maintaining door access and activities data, based on development environment and production environment.

Joined AMS project, for modifying every release version changes via PLP protocols based on requirements from business side.

Jul 15 – Sep 15 SQL Server BI Developer Baanyan Software Inc, Edison, NJ

Created complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications by using T-SQL.

Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.

Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures

Created complex SSIS packages using proper control and data flow elements.

Analyzed the existing application programs and tuned SQL queries using Execution plan, SQL performance Monitor, SQL Profiler.

Dec 14 – Jun 15 SSIS SQL Developer Smartworks, Inc, Edison, NJ

Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.

Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal Process.

Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.

Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.

Developed an automated report subscription process using SSRS.

Applied conditional formatting in SSRS to highlight key areas in the report data

Created report links to refer other reports in a particular report.

Resolved any deadlocks issues with the Databases/Servers on a timely basis.

Handled Underwriting and pricing of renewal accounts within underwriting authority for

Compensation. Assisted (via remote) with payroll, tax, and account processing.

Installed SQL server 2000 on Windows 20003 servers and involved in Physical and logical Database Design using Erwin tool.

Created database objects like tables, users, roles, stored procedures, triggers.

Worked on solving issues by doing data recovery in existing database.

Used various formatting techniques like interactive sorting, grouping to created user friendly reports.

Environment: SQL Server 2005, Windows 2000/2003,MS Access 2000/2003,T-SQL,Windows 2000 Advanced Server, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services.

Oct 10 - Sep 11 SQL Server DBA Minghao Technology Company Limited Weifang, China

Minghao Technology Company Limited is a developing IT company in China which provides IT support to national banks, schools and public organizations and also develops software according to business usage to satisfy clients' need.

Installing SQL Server 2005 and administration of servers, ensuring zero downtime and provide 24 X 7 dedicated support to all Production, development servers.

Interacting with Developers in identifying the requirements and designing and implementing the Database Schema.

Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.

Created and modified stored procedures, triggers, views and indexes to provide best performance.

Successfully implemented and maintained Microsoft clustered technologies for database servers.

Managing security, which includes monitoring and controlling database access, assigning permissions to application owners.

Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.

Environment: SQL Server 2005, Windows 2000/2003,MS Access 2000/2003,T-SQL,Windows 2000 Advanced Server, SQL.

Contact this candidate