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

OBJECTIVE: Database/ETL/BI/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 2019/2017/2016/2014/2012/2008 R2(stored procedure, function, view, trigger and diagram), Oracle, T-SQL, PL/SQL, SSDT, Visual Studio 2019/2017/2012/2010/2008(SSIS, SSRS and SSAS); ETL, Talend, Microsoft Azure(cloud), ADO(Azure DevOps Server TFS),Knowledge Share Power Share, Power BI, Toad, TIER System, Excel, Access, Tableau, Erwin, Informatica, Cognos, Mysql, Hive queries, No queries, MS Access, dashboards, VB, Crystal Reports, SAP, SharePoint, JIRA, Agile, Remedy, SQL Power Architect, Snowflake, BMC Control – M Workload Automation,. Windows PowerShell, Java, JavaScript, C/C++, Perl, HTML, XML, FrontPage, Illustrator, Dreamweaver, Photoshop, Microsoft Office and Adobe.

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 and SSIS; 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.

WORK EXPERIENCE

Company: 10/2022 – present

Teaching students how to creating databases and tables, writing T-SQL, ETL and Data analysis.

Working on school databases: Designing database architecture, analyzing data and designing data modeling(diagrams)

Training: 1/2021-3/2022

Snowflake(Cloud DB), writing SQL, designing databases and flow chart, transferring data into cloud databases and testing databases .

Control_M and Talend : using the software to do ETL and managing projects.

UnitedHealth Group(The Judge Group/Optum) 3/2020 – 6/2020

Senitor ETL and SQL Developer

Working on several ETL projects; Writing T-SQL queries and creating and testing nested Store Procedures with C# code, Functions and Valuables by using SQL Server 2017, Visual Studio 2017 and ADO(Azure DevOps Server-TFS).

Solving SSIS packages and DevOps issues.

Installing SQL Server 2019/2017, SSDT 2019/2017 and ADO(TFS).

State of Delaware(CAI/ClarusTec, Inc), Dover, DE 2/2019 – 7/2019

Production Specialist 4 /Database and ETL Developer

Loading government ZIKA Project forms into Redcap; Setting up survey invitation and testing its process.

Creating Redcap and MySQL Database data dictionaries and reports by using Power BI.

Writing about the Process of converting CSV files to forms and database changes in Redcap and MySQL database.

Writing an instruction about Survey Tool-how to send surveys for providers to enter data.

Working on ETL from MySQL database to SQL Server and Microsoft Azure database; Writing MySQL/TSQL scripts and cresting SSIS packages.

State of Maryland (A&T System,Inc), Annapolis, MD 9/2018-11/2018

Senior Database Specialist

Creating databases and tables in my local SQL Server 2016 and Microsoft Azure (cloud).

Testing, extracting and loading data from local and cloud by using SSIS and SQL queries.

Setup Microsoft Azure software, Azure DevOps and Installing SQL Server 2016.

Designing data modeling by using SQL Power Architect.

Sonepar(Vaco), 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.

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, data marts, data warehouses and Azure SQL databases.

Working on finical reports and sale products reports with T-SQL coed, Power BI, Tableau, 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, Power BI Flat files, SAP,

Knowledge Share. Power BI, Tableau, Informatica.

Writing T/PL-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, SSAS,SAP, Power Share and Knowledge Share.

Creating a Data Elements 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/SQL and ETL Developer

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 and SSAS; 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/2001 – 09/2010

Data Analyst/SQL and BI 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 a 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/90-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.

EDUCATION

Information Technology (MBA), Delaware State University.

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

OTHERS: U.S. Citizen

Contact this candidate