IT Programmer, DBA, Helpdesk Resume

SUMMARY:

Highly skilled Business Data Integrating and Analyst with 10+ years of experience assisting executives in the finance, retail and technology sectors by providing BI/EDW architecture designing, data analysis, data modeling and result reporting.
Background includes use of a variety of data integrating and analytics including SQL, Script, ETL Tools, BI Tools and MS Office Suite among others.
Experienced in project management as team leader with additional skills as a technical trainer.

PROFESSIONAL EXPERIENCE:

Confidential

IT Programmer, DBA, Helpdesk

Responsibilities:

Used PowerShell and Created Store Procedures for eComm - orders, EDI-orders batch and automatic import into company’s ERP system on Azure SQL server. Calculated SKU Safety-Stock by T-SQL base on history data. Also as DBA role maintained SQL DBs Backup, role permission setting and performant tuning.
Created SSIS packages for integrating Source data, Data Quality Control, Generating Report, Exporting Inventory Feed and Maintenance SQL Server. Created script to send out message, report and data automatic by SQL dbmail, FTP and Web-service, also used Python, PowerShell script and SciTE-Lite script to complete the tasks.
Created program for automatic generating Product SKU ID, Import new orders and export Purchase orders on ERP system. Created program to synchronize data between ERP system, eComm web-site, Dealers and supplier system.
Created Excel VBA programs for data query and collecting. Helped co-worker convert data into unified format report. Used SQL script to load and update data in Database base on Excel file, Text file and DB-linked data source.
Built internal web-site for sharing public information and created web-business reports with SQL, ASP.net, SSRS, SSAS, MS PowerBI
Communicated with company HQ. Transferred and updated new IT technologic, project status and IT system running status.
As helpdesk role, maintaining company IT system and co-worker computer ensure its run well and safely. Include installing, setting and troubleshooting OS, server, Anti-Virus software, System security policy, Office software, Printer, Telephone, SW/HW tools and network.
Recreated company IT architecture. Migrated server into Cloud service (Azure, AWS, Effortless), included SQL Database, Email, Home and business web-site and backup server. Built VMWare vSphere platform for local servers. Built new domain controller and deployed security policy, WSUS and files-share controller.

Confidential

IT Consultant

Responsibilities:

Built a Website on AWS (confidential), With HTML5, Asp.net, Java, Perl Script, Mysql.
Wrote an Auto-Collect and Generate Invoice program, With Excel VBA.
Coded a Statistical Analysis tiny-program, With Python
Created a Game APP(IOS) with Xcode8 and Objective-C.

Confidential

BI Technical Consultant/ Data Analyst / Manager

Responsibilities:

Implemented data loading and transforming with Confidential tools. Built the ETL jobs with Perl language, Confidential SQL and ETL Tools.
Edited SQL statement for inquiring data and analyzing the business requirements (Ad-hoc). Tuned complex SQL and ETL jobs to improve system performance.
Created ETL job with Perl embedded SQL to analysis history data and control data quality.
Developed Key Analysis Requirement with BI Tools: Tableau; Cognos, SSAS/ RS.
Designed data model base on TD-FSLDM to store history data with ERwin.
Designed OLAP data model to support application development base on Cognos and BO BI tools for CUBE and Reporting.
Participated in Confidential DBA work for Data access right control, Space management, Data Backup and Restore.
Built the SQL Coding standard document and used it in various projects.
Trained team members on how to create good performance SQL in Confidential DB.
Presented customer with report project status and development result.
Led team members in completed Shanghai Stock Exchange dual EDW system projects.
Led team members in completed China Industry Bank Data Standard consulting project.

Confidential

Senior Software Develop Engineer

Responsibilities:

Created SQL code, store procedures and responsible for MS SQL server deployment, data management and maintenance.
As SQL DBA role, deployed SQL server on windows server, maintained databases backup, performance tuning, role setting and database designing.
Designed data model for MS SQL Server data storage with PowerDesigner
Developed and deployed Securities Broker software products, e.g.: Securities Integrated Management Platform, Securities Management System (supports for automatic operations of data collecting, settlement, clearing, monitoring, report producing, and statistical analysis). IT Technology used: MS SQL Server, Visual Basic.
Completed three projects of paper manufacture on automation field to control the temperature of the boiler and ensure producing high-quality paper by using PC controller (PLC A/D), coding with Visual Basic, BC, MS SQL Server, Excel VBA and Socket Protocol(TCP/IP). The implementation of these projects enhanced the working conditions of workers and improved paper quality.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship