Software Developer Engineer

HongHai Li

Data Engineer

Email: ********@*******.***

Tel : 201-***-****

SUMMARY OF QUALIFICATIONS

Oracle8i Certified Professional Database Administrator(OCP)

Oracle PL/SQL Developer Certified Associate(OCA)

Microsoft Certified Professional Developer (MCPD)

Informatica PowerCenter 8.X Level 1&2 Developer

Profile:

Databases: Ms SQL, Oracle, Teradata, RedShift MySql, Ms Access.

Languages and Software: Python, C#, Delphi,PL/SQL, T-SQL, Pro*c, LINQ, JavaScript, Crystal Report, SSRS, SSIS, SSAS, Web Service, ADO.NET, JDBC, Power Center.

Operating Systems: Windows, Linux, Dos, Unix, SAN, AWS.

Web Servers: IIS, Apache and Tomcat.

Tools: Visual studio, Microsoft Team foundation, Power Center, MS Visio, Visual source safe, Toad, Redmine.

Professional Experience

Data Engineer

Quidsi, Jersey City, New Jersey Mar 2011 – Apr 2018

Data Engineer:

Design and implementation communicate programs between different servers by using service broker and change tracking.

Data Design and program database objects (tables, views, procedures, functions, triggers

Help and guide users to create efficient queries against on databases.

Design and develop database warehouse by using SSAS, cube.

Work with system administrators to move all database servers from local data center to AWS(RDS, EC2).

Build reports based on users’ requirements (SSRS).

Develop data transfer ETL between different sources by SSIS.

Move current data warehouse from SSAS to AWS by using Tableau, python, Redshift

Build and management dev/UAT/QA database servers.

Provide Full lifecycle software development (requirements\ analysis\ development \testing \deployment) for custom in-house software systems as needed.

Develop database automation applications by using python, PowerShell.

Design and develop database warehouse by using SSAS, cube.

Work with system administrators to migrate all database servers from local data center to AWS(RDS, EC2).

Migrate current data warehouse from SSAS to AWS by using Tableau, python, Redshift

Developed custom reporting platform for users using SSIS, SSRS.

Developed data transfer ETLs between different sources by SSIS, python, Aps.net, C#.

Optimize and tuning the big (more than 10 TB) and busy database system and make sure them run well all the time.

Design and maintenance database servers' DR plan by using windows server failover clustering on SAN system.

Setup and maintenance sql server replication, log shipping and always-on.

Design and maintenance database servers' separation (separate databases from one server to four different servers by function) also include develop and design communicate programs between different servers by using service broker and change tracking.

Design and program database objects (tables, views, procedures, functions, triggers

Work with Security team to find solution to protect security information (customer address, phone number, Credit card number

Design and develop database maintenance plan (index rebuilding, performance monitoring, archive old data, database cleanup, database backup, windows and sql server patch installation).

Build and management dev/UAT/QA database systems.

Technologies Used: Python, SQL Server, Oracle, Mysql, SSRS\SSIS\SSAS, Web Service, Apache Spark, RedShift, AWS, Tableau,Asp.net, C#,

Database and software developer

Bell Canada, Montreal Canada Apr 2008 – Oct 2010

Plan, design, and implement application database code objects, such as stored procedures, functions, packages and views.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and

extraction.

Worked with application teams to develop web-based applications by using T-SQL

and PL/SQL.

Develop ETL work flow to integrate different sources’ data (SQL, Oracle, Teradata) into DATAMART.

Build report based on customers’ needs.

Perform quality assurance and testing of database server (Oracle and Sql server)

environment.

Work with business stakeholders, application developers, and production teams and

across functional units to identify business needs and discuss solution options.

Ensure best practices are applied and integrity of data is maintained through security,

documentation, and change management.

Technologies Used: Power Center 8.5, Oracle, Sql server, Teradata, My sql, Asp.Net, SSRS, SSIS, Web Service, Unix, Shell Script, Bugzilla, Redmine.

Database and software developer

Capazoo World Corporation, Montreal, Canada Jun 2007 – Mar 2008

Design and create database objects: tables, views, indexes.

Work with ASP.net team to develop web site by coding procedures, functions, triggers.

Review and modify developers’ procedures and functions.

Optimize and tune Procedure performance by using best practice.

Develop report query web interfaces to produce business statistics reports.

Gather needed data from database for business analysis using SSIS.

Technologies Used: Asp.net, C#, SQL Server, T-SQL, SQL Server reporting service, SSIS, Web Service.

Contract software developer

ADT Marketing, Montreal, Canada March 2006 – May 2007

Designed and implemented application “DispatchBoard”.

Designed and implemented Web application.

Technologies Used: Asp.net 2005, Ajax, Delphi, SQL Server 2005, DTS, Web service and WindowsXP.

Database and software developer

Sigema Canada Ltd, Montreal, Canada Dec 2003 – Feb 2006

Oracle and Sql server database maintenance and development.

Design and implement application “ShipMate”, it provides Invoicing, Sales Ordering and Inventory Control.

Designed and implemented the ShipMate central database, including tables, views, and procedures.

Implemented the ShipMate application.

Designed and developed a web application for intranet user provides on-line invoicing, order entry and query

Technologies Used: SQL Server 2000, Oracle, Asp.Net 2003, Delphi, Rave Report, Java, JDBC, Linux and Windows.

Education

Bachelor of Science, University of Science and Technology of China

*References available upon request.

Contact this candidate