Post Job Free

Resume

Sign in

Marketing Programs Sql Server

Location:
Prior Lake, MN, 55372
Posted:
March 27, 2024

Contact this candidate

Resume:

Hiep Vu

OBJECTIVE

Seeking a position as an SSIS ETL Developer with responsibilities of designing, implementing, testing, and troubleshooting technical solutions that meet company and customer requirements.

EMPLOYMENT HISTORY

Northern Tool Company Burnsville, MN Jan 2018 – Present

Business Intelligence Developer

Augeo Marketing works with category leaders to design, build and operate data-driven marketing programs. It offers points-based rewards programs, marketing programs, and custom programs.

Maintaining, troubleshooting, and developing programs used in high-volumes of transaction data from numerous sources.

Build ETL packages to load data into Stage, OLTP, and Enterprise Data Warehouse using SSIS (SQL Server Integration Services).

Writing/generating SQL queries (T-SQL) to retrieve and manipulate data. Test databases, correct errors and make necessary modifications.

Augeo Affinity Marketing, Inc. St Paul, MN Jan 2010 – 2018

Programmer Analyst

Augeo Marketing works with category leaders to design, build and operate data-driven marketing programs. It offers points-based rewards programs, marketing programs, and custom programs.

Maintaining, troubleshooting, and developing programs used in high-volumes of transaction data from numerous sources.

Build ETL packages to load data into Stage, OLTP, and Enterprise Data Warehouse using SSIS (SQL Server Integration Services).

Writing/generating SQL queries (T-SQL) to retrieve and manipulate data. Test databases, correct errors and make necessary modifications.

Wells Fargo Bank Bloomington, MN March 2009 – Dec 2009

Software Developer

In this position there are so many different responsibilities involved that I had to wear many hats. I work as a software developer, a database designer, a data analyst and a report writer. These do not include documentation, software quality assurance and deployments.

Build website for Non-Process Client Calling Campaign using ASP.Net 3.5, C# with SQL 2005 backend. This involved creating normalized databases, writing SSIS packages to import and clean old data, building website for multi-users, creating several reports using SQL Report Services (SSRS).

Analyze and create reports for accounting managers to clean up data in Evolve database.

Import data from several instances of the system, analyze data, and create SSRS reports show accounting managers know which data on which companies they have to correct.

IDT Carmel, Inc. Bloomington, MN June 2008 – March 2009

Programmer Analyst

IDT Carmel is a receivables portfolio management and collection company. It purchased credit card debt portfolios from a major commercial bank and collect debt.

Writing DTS package in SQL SSIS (SQL Integration Services) to automate imports/exports data processes between PIMS (Portfolio Inventory Management System) and customer systems.

Using SQL Server 2005 advanced queries, create analytical reports in SSRS (SQL Server Reporting Services) to support business needs such as monitor performances, tracking revenue details, revenue productivity and dial performances.

Design and develop Business Intelligence applications, custom tools using VB.Net, ADO.Net, SQL.

Develop web based applications in ASP.Net/VB.Net to capture user inputs and update SQL database.

Participate in teams to build internal Data Warehouses.

Integrated Healthcare Strategies, MN Oct 2007 – May 2008

Programmer Analyst

IHStrategies is a health care group that provides services and products such as performance management, performance review, private advisor and leadership development services.

Support enterprise Access/Microsoft SQL Cash Compensation system for Kansas and Minneapolis applications. Using VB.Net/SQL to create ad hoc queries, create reports, design and implement changes as requested.

Build new Project Time Tracking application using VB.Net and MS SQL for IT and Marketing departments to keep track of time spending on various projects for planning purposes.

Support Project Management application written in MS Access for Cash Consultant Services department.

Using VB script to modify, improve the Survey processes.

.

Cymbet Corporation, Elk River, MN Nov. 2006 – Sep. 2007

Software/Testing Engineer

Cymbet™ Corporation is the first to market a true solid state energy system using a proprietary, patent pending "POWER FAB™" low temperature manufacturing process. The Cymbet™ thin-film battery system will enable new concepts in battery application for IC's and new products for handheld computer, communication, medical, sensor, and portable electronic devices.

Designed and developed software for production testing batteries. This was a database application using Microsoft SQL Server and C# to automate the battery test process. It involved tracking parts, capturing and analyzing testing data.

Using VBA to modify and automate the capturing and analyzing processes.

STARKEY LABS, Eden Prairies Jan 2004 – Nov 2006

Manufacturing Quality Engineer

I work as an Analyzer for all of Hearing Aids being remade with fitting issues. Examining 3D images to determine the causes and solutions to fix the problems. I developed a client server application using C# (front end) to access Oracle, MS Access databases through ODBC to capture information and images for data analysis. Write VBA scripts in Excel to perform variety of reports and analyze data to monitor ShellTech performances and improve overall quality by reducing return rate.

SKILLS SUMMARY

Languages: Assembly, Fortran, C, C++, COM/DCOM, VB 6, VBA, VB.Net, C#

Database Systems: VAX RMS, All-In-1, Datatrieve, DCL, CDD/plus, Oracle 7.0,

MS Access, MS SQL

Web: HTML, ASP.Net 3.5

Others: Excel, Word, SSIS, SSRS

EDUCATION AND TRAINING

Computer Science Rochester Institute of Technology, Rochester, NY

B.A. in Applied Mathematics University of California Berkeley

Computer Science National Technological University, Fort Collins, CO

Certified Novell Administrator – CNA 3.1x Novell Certification Training Programs

Certified Novell Engineer – CNE 3.1x Novell Certification Training Programs



Contact this candidate