Sophia Yang 302-***-**** ac6tsb@r.postjobfree.com

OBJECTIVE: BI or Database or ETL or SQL Developer/DBA (Oracle and SQL Server)

SUMMARY

Over 20 years of experience in analyzing, designing and verifying data with relational database and data warehouse environments; Using SQL Server 2016/2014/2012/2008 R2/2008/2005(stored procedure, view, trigger and diagram), Oracle, T-SQL, PL/SQL, SSDT, Visual Studio2012/2010/2008 (SSIS, SSRS and SSAS); ETL, Knowledge Share Power Share, Power BI, Toad, TIER System, Excel, Access, Visio, Erwin, Informatica, Cognos, Tableau, dashboards, VB, Crystal Reports, SAP, SharePoint, JIRA, Remedy.

Significant computer information technology in healthcare, education, accounting and finance experience; Excellent analytical and problem solving skills; Ability to work independently and as part of a team.

Data Conversions and Data Migrations by using SQL Server, SSIS and Informadica; Creating and maintaining an extraction, transformation, and loading process from different sources.

Deep understanding of RDBMS, relational database, data warehouse, data mart, data lake and data modeling(Erwin), business intelligence (Dimensional Modeling and Star/Snowflake schemas) and cube data architectures; Very strong logic thinking, web technology, presentation and software development life cycle.

Performance tuning and resolving databases performance issues (indexing, data partitioning/clustering, updating statistics; Import/Export Data, backup, maintenance, monitoring and other daily administration tasks for databases; Scheduling jobs; Query Builder, data visualization and SQL Tuning Advisor.

Interact with the Database and Business Intelligent development to develop solutions based on the business end user's requirements. Strong PC skills including advanced level of Excel (pivot tables, dashboard, macros, external data, and queries), Access (queries), Word and PowerPoint.

Excellent T-SQL, queries, views, stored procedures, triggers, functions, indexing, web services, flat files; strong reporting skills, Crystal Reports and SharePoint; knowing how to properly use SQL Server Profiler.

TECHNICAL SKILLS

Database: SQL Server 2016/2014/2012/2008R2,Oracle SQL Developer, PL/T-SQL, SSDT(Visual Studio)

2012/20102008(SSIS/SSRS/SSAS), Power BI, Informadica, TIER System, ETL, Excel, Access, Crystal

Reports, XML, Data Mining, Data Modeling/Erwin, Knowledge Share, Power Share, Visio,

Application: Java, JavaScript, C/C++, Perl, Visual Basic, HTML, XML, FrontPage, Illustrator, Dreamweaver,

Photoshop, Microsoft Office (Word, PowerPoint) and Adobe

Op Sys: Windows 10/8/7/2000/XP, Unix/Linux, DOS, and Mac OS

Courses: Database Management Systems (PERL), Quantitative Methods Foundations (using statistical

formulas and models), C/C++, Java/JavaScript, Visual Basic

EDUCATION

Information Technology (MBA), Delaware State University. 2003

Electrical Engineering (BS), Harbin Institute of Technology, China. 1992

WORK EXPERIENCE

Sonepar, 12/2017-2/2018 (Contract)

ETL Architect

Establish best practices for BI, AI, & analytics solutions to ensure they are being effectively applied to all efforts

Guide technology teams in creating and deploying solutions that cater to various business needs.

Perform architectural reviews of BI / AI & analytics solutions

Define and implement business transformation rules and logic

Identify, establish, communicate, and manage data quality and integrity standards

Participate in and direct data architecture design activities within development teams

Experience with database analysis, database modeling, design, and implementation especially for data lakes / marts / warehouses

Working on finical reports and sale products reports with T-SQL coed, SSIS and SSRS.

Experience with the design of scalable ETL / ELT solutions with multiple data sources

Hands-on development experience with ETL tools. Extracting, loading and testing millions rows of data and working on 1.5 Tb databases.

Data transformation support and management through MS SQL SSIS / DTS, Informatica, Cognos, and Tableau

Experience in SQL development focused on MS SQL 2014 / 2012, T/PL SQL-based development

Experience in working across multiple production and development environments

Offer from CACI(Software Developer III) and discontinued on Secret Clearance check, 11/2016-7/2017

Fulton Financial Corporation, Lancaster, PA, 11/2014 – 9/2016

DBA/Database Developer

Creating databases, tables and staging tables in SQL Server 2016/2014/2012; loading, Transforming and

Extracting thousands /millions of data from SQL Server 2016/2012/2008R2, Oracle, Informatica, Flat files, SAP, Knowledge Share.

Writing SQL code and creating SSIS packages for ETL, test data quality and other projects.

Creating and developing control projects by using SSIS: foreach loops, containers, Scripts task, writing C#

code, FTP file, SAP and more functions; Working on Mortgage, Debit and Credit database

Oracle/SQL DBA: scheduling new jobs and reloading and modifying jobs; trouble shooting job problems;

managing jobs; backup and recovery scenarios; adding and deleting users; editing emails.

Technical Support and problems solving; installing software; posting information into SharePoint.

Working report projects by using SQL, SSRS, SAP, Power Share and Knowledge Share.

Creating a Data Elements Document from 235 T-SQL and PL/SQL scripts.

Performance Tuning(Hardware, software and estimating workloads-sizing Data) by using SQL Server

Profiler. SQL Tuning, Testing, Debugging, and Validating a Design.

Installing, testing and updating software(SQL Server 2008R2 to 2012,2014 and 2016), Toad, oracle and etc.

Testing and changing databases, tables and scripts by using SSDT 2016 (Schema Comparison, Snapshots

Project, Refactoring, Solution to Source Control)

Bank of New York Mellon, King of Prussia, PA, 7/2014 – 9/2014(contract)

Business Data Analyst

Two testing projects by writing SQL coding and using Netx360.

Translating and reading 47 Oracle scripts into SQL coding. Creating tables and loading data(ETL) by

writing SQL coding, SSIS packages, and SSDT from flat and excel file to SQL server database.

Reading data and database structure from 15 databases; learning business system from Netx360 and getting

to know account, performance, profile, investment name, type and chart.

Delaware Guidance Services, Wilmington, DE, 4/1/2014 – 6/2014(contract)

Software Developer

Creating and editing TIER forms by writing Tier coding and T-SQL; Designing and editing Tables (with around 800 columns of each table) in SQL Server 2008 R2 database, Loading/ETL data into the database by using SSIS and T-SQL; Developing and testing forms and data; Billing reports by using SSRS; Working with Day Treatment and Crisis Risk Assessment projects.

APS Healthcare, PA, 04/11 – 05/12(contract)

Data Analyst/ (SQL/BI Developer)

Analyzing, reporting, testing and extracting Electronic Medical Record (EMR) data in complex databases; Loading EMR reports to SharePoint after generating claims, members, providers and diseases (ICD9, HIPAA) data; Testing Databases and reviewing code; Designing ETL and diagrams.

Creating and analyzing ad hoc and daily reports by using SQL 2008 R2, Visual Studio 2008(SSIS, SSRS and SSAS) Crystal Report, Tableau, SAP; Creating test data warehouses.

Wrote complex codes and sub queries using T-SQL and leveraged strong understanding of relational and dimensional data modeling (Multi-Dimensional Modeling and Star/Snowflake schema models) and data architecture by using Erwin (tables relationship, primary keys and foreign keys); very strong logic thinking.

Provided manual test, reviewing test cases, peer review and unit test scripts; updated and maintenance database, flow charts, schema, and data modeling; created view, stored procedure and indexes.

Delaware State University, Dover, DE, 01/04 – 09/10

Data Analyst/SQL Developer

Installing, configuring and upgrading SQL 2008/2005, Oracle 9; providing analysis, and data modeling support for the college, creating and maintaining student databases (import/export/backup/storage) and computer Labs.

Setup processes collecting data into database, backup, storage data, performed data validation, mapping and mining data, generating and analyzing student records and various reports by writing SQl and Oracle queries (Dashboards and T-SQL/PL-SQL), Visual Studio 2008 (SSRS, SSAS and SSIS), ETL, Excel, Tableau and Access.

Created, designed and maintained http://chem.desu.edu website by using HTML, Java, JavaScript, Photoshop, Dreamweaver, FrontPage, Illustrator, PowerPoint and Adobe; web development.

Performing advance levels of database systems planning, analysis and design; problem diagnosis, resolution, troubleshooting; tracking, reporting, upgrading and planning for projected software requirements and computer capacity.

Heilongjiang Province Hospital, Heilongjiang, China, 06/85-06/97

Programming Engineer

Establishing, modeling and analyzing Electronic Medical Record (EMR) in complex databases / data for thousands of patients, the claims billing and finance departments (knowledge of Patient Protection and Affordable Care Act (PPACA) and Health Insurance Portability and Accountability Act (HIPAA)), codes and varieties of diseases, and reporting departments.

Establishing data warehouses that maintained patient cases, which included patient contact information, current medical records and medical history and designating medical codes (ICD-9). This resulted in quicker data retrieval and ultimately resulting in a reduction of required physical storage space.

Performing advance database operations (database tuning, table space sizing and location, database monitoring), diagnosing and debugging the two database programs for existing and potential performance or security issues and planning for projecting software requirements and computer capacity needs.

Programming patient billing, hospital finance and Clinical biochemical lab projects by using statistical formulas; setting up a huge volume account database of thousands patients and wrote codes to retrieve monthly, annual and ad hoc reports. After using the programs, the work efficiency improved 90%, more accurate and increasing savings.

Establishing backup and recovery or replication plans to minimize data loss and system downtime.

Developing database standards, documenting and administering processes, system security and authorization procedures, troubleshooting and maintaining data warehouse environment.

OTHERS: U.S. Citizen

Contact this candidate