James Y. Huang

Fremont, CA • adl31v@r.postjobfree.com • 510-***-**** • www.linkedin.com/in/james-y-huang

MS SQL SUPPORT ENGINEER

Focused and results-oriented Software / Data Engineer / Analyst with over 10 years of experience in software and database development and design. Proven ability to design and develop high quality and high performing applications, reports, and data pipeline. Excellent research, design, develop, project planning and implementation skills. Demonstrated success leading and executing complex projects in data analytics and reporting. Effective communicator with experience working with all level of stakeholders.

Strong SQL database skills using MS SQL Server, PostgreSQL, Oracle

Expertise in analytical, data analysis to deliver analytical methods and to enhance system performance

SDLC - Agile software development best practices and methodology

TECHNICAL SKILLS

Programming Languages: Python, SQL, SQL Server SSIS/DTS, C#, JSON, VB.net, VB Script, Java Script,

Oracle PL/SQL, NoSQL, Visual Basic, VBA, XML, ASP.Net, C

Database: MS SQL Server, PostgreSQL, Cassandra, MySQL, Oracle, Spark SQL/Databricks, MS Access

Operating System: Windows, UNIX, Linux (CentOs, Red Hat)

Application Software and tools: MS Visual Studio / VS Code, MS SQL Server Management Studio, Tableau, Excel,

SQL Workbench, DBeaver, Toad, Business Object/Crystal Report, Git/GitHub, R Studio, Google Analytics

Cloud Computing: AWS, MS Azure

PROFESSIONAL DEVELOPMENT

CALIFORNIA SCIENCE and TECHNOLOGY UNIVERSITY, Milpitas CA

Emerging Technology Training Program 06/2020 – 12/2020

Relevant Course Work:

Python programming – Python 3, Pandas, Numpy, Matplotlib, scikit-learn and PyTorch

Data Engineering with Apache Cassandra and Advanced SQL – Window Functions, NoSQL Cassandra

Cloud Computing and Security – AWS, VPC, Security in cloud, Azure, DataBricks, DataFactory Pipeline

Machine Learning – Deep Learning, PyTorch, Keras and TensorFlow 2.0

Digital Marketing – SEO, Google Analytics, Google Ads, Web Analysis

Relevant School Team Projects:

ETLite framework – Using Python to develop lite ETL frame work and processing via Rest API

Medical Image Processing – Utilize U-Net / V-Net to train and predict pancreases CT scan images with cancer,

Image data preprocess using Labelme and Python

Data Visualization – Salary by State using Tableau

https://docs.google.com/document/d/1JDivSQvoJ6nu-eX7OG-hFKkw7PHdr8wh

EXPERIENCE

MUFG / UNION BANK, San Francisco, CA 6/2006 – 12/2019

Senior Software Engineer

Project Lead Online Trust & Custody product and Global Trust department projects. Researched, analyzed data, designed, developed and deployed for automated scheduling delivery numerous reports and processes requested by internal and external business clients for customize tailor by individual business requirements.

Utilized ETL framework using SSIS to integrate data store in MS-SQL Server DataMart/Data Warehouse, import/exports from all types of data format. Created automated scheduling solution and reporting tools resulting in automatically delivering reports, files, data, and statement to business clients using MS-SQL Server SQL/stored procedure, SSIS, C#, XML, Excel, MS Access DB, CSV, PDF.

Developed, implemented and maintained numerous in house, financial and banking applications, FX, Class Action, Corporate Action, Litigation, job scheduling process using VB/C#, SSIS packages to trigger run jobs.

Co-Lead in major conversion project, converted 200 SQL server DTS package to SSIS package, Visual Basic code to C#, rewrite over 100 complex stored procedures, reduces redundancy codes by redesign and reduce SP calls from web application. In addition, tuning numerous SQL scripts, stored procedures for faster performance by 50% and easier to maintain.

Lead annual Disaster Recovery Exercise, failover for all Trust Technology Applications, Servers, and Databases. Coordinated with over 50 staffs and business users from cross functional group and business units for week long DR exercise. Successful recovered twice of actual disaster in 60% less time than expected.

Support production issue when occurred, research and analyze data, solving problems by create ad-hoc report or query data for business user and provided best solution to fix data or code issues in fast turnaround time.

Continued to enhance the team SSIS ETL scripts evolving it into a cleaner and maintainable template thus reducing the development time by 40%.

Supported Commission and Fee Unit group, developed ad-hoc analysis using MS-SQL and Tableau dashboard reporting.

Provided Business Requirements (BRD). Participated in design reviews and provided approval from Business Users. Managed SIT and UAT, Work with Business users to created user test cases and provided daily status to Management on UAT.

ADDITIONAL RELEVANT EXPERIENCE

CATELLUS DEVELOPMENT CORPORATION / PROLOGIS, San Francisco, CA 6/2001 – 2/2006

Senior Programmer / DBA

Lead developer, designed, and developed, Oracle database administrator and automate reports solutions for multiple platforms and system support.

Generated Asset Management and Financial Reports for executives from Yardi via Oracle database.

Supported maintenance Budget Management System application using Visual Basic and AS/400 back-end.

Supported accounting and HR departments to create ad-hoc reports, generated by using MS SQL stored procedure and Crystal Report on Ceridian source 550 system.

Developed and implemented numerous GUI / client server applications for Inventory and Purchase Order system, Litigation, Title and Escrow, Certificate of Insurance, etc. These applications helped managers to better tracks data and produce useful reports. Via, Visual basic, MS SQL server and Crystal report. Maintained HR performance appraisal web application. Via ASP, Java script, VB script, Crystal report and Oracle DB.

Maintain and perform Oracle and MS SQL server database backup/recovery. Perform annual offsite (SunGuard) database disaster recovery simulation.

EVOLVE SOFTWARE, Emeryville, CA

Senior Engineer / Programmer

Developed automation solutions for corporate web application via on Oracle and Crystal Report.

SNICKELWAYS INTERACTIVE, New York, NY

Senior Application Developer

Developed and maintain finance system and report solutions and company core web applications on MS SQL Server, Crystal report, Visual Basic.

FEDERATED MERCHANDISING GROUP, New York, NY

Senior Programmer Analyst

Designed and developed Oracle / MS SQL Server database and build automate deliver crystal report solution to corporate merchandising executive for multiple platforms and system support.

AT&T CONNECTIVITY INFORMATION SYSTEMS, Berkeley Heights, NJ

Senior Technical Associate II

Lead developer, designed, developed and implemented Oracle database forecasting model solutions for multiple platforms and system support via Oracle and PowerBuilder.

EDUCATION / CERTIFICATION

Microsoft Certified: Azure Fundamentals (2020)

Master of Science (MS), General Management

Steven Institute of Technology, Hoboken, New Jersey

Bachelor of Science (BS), Computer Science; Minor, Business Management

State University of New York, Stony Brook, NY

Contact this candidate