Developer Data
Resume:
Tuan Anh Nguyen
South Orange, NJ *****
adfs0c@r.postjobfree.com
SkypeId: adfs0c@r.postjobfree.com
LinkedIn: https://www.linkedin.com/in/tuan-nguyen-21827411/
Summary
ETL SQL Database Developer (70-100%) and Administrator (0-30%) in a wide variety of BI applications, particularly, client/server applications and RDBMS: Transact-SQL, PL/SQL, MSSQL Server, Postgresql, Teradata, Oracle, MySQL; design Star Schemas, Snowflake Schemas and migration database projects, close interaction with the DB manufacturers, health care, business services, retails…on Windows and Unix/Linux systems.
Education
Maharishi University of Management, Fairfield, Iowa, USA
Master of Computer Science, 2007 – 2010, graduated
Southern Taiwan University of Technology, Yung-Kang, Tainan, Taiwan
Master of Business Administration (M.B.A.), 2005 – 2007, postponed
Hung Vuong University, Hochiminh city, Vietnam
Bachelor of Information Technology, 1996 – 2000, graduated
Bouchereau Lingua International (BLI), Quebec, Canada
Learn French in Quebec, summer 2016, summer 2017
Software QA Training Center, Toronto, Ontario, Canada
Learn Software QA Testing, autumn 2017
Specialties
10+ year experience in SQL Programming and Administering with MSSQL Server with SQL Server Management Studio, SSIS, SSRS, Postgresql, Oracle with PL/SQL, MySQL, Teradata with Teradata Studio, T-SQL, SQL Server and ETL/ ELT with Talend or SSIS, DDL, DML, OLTP, OLAP, Snowflake schema, Star schema, Data migration. Strong passion with data and learn fast any new technologies
Experience
Database Developer at Pfizer Inc., Peapack, NJ, USA.
Feb 2020 - Aug 2020:
• Work as back-end developer with T-SQL or SQL programming on SQL Server, PostgreSQL, Oracle, MySQL.
• Use tools: SSMS, PgAdmin, DBeaver, SQL Developer to design, develop and maintain tables, stored procedures, functions, triggers, indexes, sequences, ...
• Develop dynamic queries with Stored Procedures on SQL Server and Postgresql.
• Create ELT jobs with SQL scripts in Stored Procedures, Unit Testing.
• Analyse and design database including data warehouse design with different star schema, snowflake schema, database modeling from business requirements and varying data sources.
Technologies: RDBMS, JDK, PostgreSQL, Oracle, MSSQL, MySQL, OLTP, OLAP.
ELT SQL Database Developer at Federal Verizon, Ashburn, VA, USA.
Nov 2018 - Nov 2019:
• T-SQL and PL/SQL programming on SQL Server and Oracle 11.
• Use PL/SQL and SQL Developer tool to design, create and maintain tables, stored procedures, functions, triggers, indexes, sequences, database links...
• Create ELT jobs with SQL scripts in Stored Procedures, Informatica, Unit Testing.
• Create ELT jobs at Informatica for Replication and Synchronization with Connection from/to different data sources.
• Analyse and design database models from scratch with flat files.
Technologies: SQL, RDBMS, JDK, MSSQL, Oracle, Informatica, SSIS, Salesforce.
ELT SQL Database Developer at State Street, Quincy, MA, USA.
Apr 2018 - Oct 2018:
• Analyze, design and create SQL query data for ETL process.
• Build and maintain ETL documents for Windows and Database Recertification.
• SQL programming with Teradata to create objects in Teradata: tables, views, stored procedures….
• Use Teradata Utility Tool to import data at FastLoad.
• Build and maintain SQL statements to test for ETL, Unit Testing.
Technologies: SQL, RDBMS databases: Teradata Studio, MSSQL, Oracle,
ELT SQL Database Developer at Converse (Nike), Boston, MA, USA.
Jan 2018 - Apr 2018:
• Analyze, design and create SQL query data for Tableau dashboard.
• Build ETL process for Sales and Operation.
• Create technical documents and schema for Snowflake database.
• Use Matillion to build ETL process, clean data and import data to Snowflake database.
• Transform data on Matillion and Snowflake database with staging tables, and send email to notice ETL process success or failure.
• Create views with different dimensional data from tables on Snowflake database.
• Create stored procedures and functions on Snowflake for ETL process on Matillion.
• Create dynamic queries on Snowflake and execute from Python to extract data automatically.
Technologies: SQL, AWS, Matillion, Snowflake database, Cloud Computing, Python, AWS, Data Warehouse Kimball architecture, SQL, Tableau, Git, DBeaver, SQL Workbench
ELT SQL Database Developer at Walmart, Mississauga, ON, Canada.
Nov 2017 - Jan 2018:
• Develop the ETL packages to transform data from raw data to production data by SSIS, C#, T-SQL..
• Involve in analyze and design database for internal applications.
• Build and run optimized query on Teradata and PDW.
• Build SSIS package to extract data from Teradata and other source, transform and load to PDW.
• Build dynamic query for ETL automation, Unit Testing.
• Create variables to pass setting data from database to ETL package for automation.
Technologies: T-SQL, MSSQL Server, Teradata, Big Data, Data Warehouse Kimball architecture, Parallel Data Warehouse (PDW), SSIS, C#, SQL, Tableau, Git Extension, Source Tree, Teradata SQL Assistant.
ELT SQL Database Developer and DBA at Klick Inc., Toronto, Ontario, Canada
Sep 2016 – Jan 2017:
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins using optimized T-SQL, PostgreSQL
• Develop the ETL packages to transform data from raw data to production data by SSIS as Workday tenants.
• Schedule the DTS/SSIS package for migration data from legacy system on MS SQL 2008, 2012, 2014.
• Maintain of Stored Procedures to improve performance of different front end Applications.
• Work on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers from SQL-Server to RDBMS like PostgreSQL
• Design database architecture from logical to physical models
• Extract the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate or staging Database using the SSIS.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Experience in Developing and Extending OLAP Cubes, multiple dimensional data source view.
• Develop complex stored procedure using T-SQL to generate Ad hoc reports using Crystal Report and T-SQL programming.
• Schedule the Reports to run on hourly, daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the Crystal Reports
• Prepare the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Interact with the business users to gather information about the report.
• Create numerous sub reports, drill down reports as part of the project according to business requirements using SQL Server.
• Design multiple stored procedures, views for the Crystal Report as data sources, Unit Testing.
• Create and maintain User Security/Permission
•Migrate the database objects from one server to another server between SQL Server databases and PostgreSQL databases.
• Work with plan administrators to research and resolve data issues and troubleshoot system problems/outages.
Technologies: Big Data, PostgreSQL, MySQL, MSSQL Server 2012, 2014, SSIS, SSRS, T-SQL, XML, Visual Basic, C# in SSIS, Crystal Report, Python, Rake, Win Server 2008, 2012, Inmon Datawarehouse.
Database Developer at Insight Action Inc., Toronto, Ontario, Canada
Nov 2012 - Nov 2015:
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans.
• Worked with Technical Architects and Business Analysts to design database architects and report.
• Populate or refresh OLAP database for report on dashboard by running ETL automation processes for user acceptance testing and loading history data into OLTP database.
• Develop ETL processes by T-SQL scripts to add the logic by getting the related data from the multiple sources.
• Design the functional and technical documents.
• Create report templates and reporting standards for the developers to work on the report development with T-SQL.
• Develop Cubes and Regression Statistic using T-SQL programming
• Create MDX queries to create cube by T-SQL programming.
• Refreshing the cube to get the latest information updated for OLAP databases.
• Extract, Transform and Load data to dashboard as Business Intelligence Web applications.
• Use Talend Open Studio tool is used to clean data and import raw data to SQL Server.
• Use parameters to communicate between Talend and SQL Server and configure Talend to run ETL as automation tasks.
• Shell scripting use to call Talend automation tasks and refresh ETL tasks as Workday tenants.
• Analysis and Design Logical and Physical Data Modeling, import, export, backup, restore, migration... databases.
• Python programming for Geocode location.
• Data visualization with Power BI
• SQL Programming as stored procedures, functions, views, triggers, index, constraints, statistics on relational databases.
• Database server administration, query optimization, stored procedure development and performance analysis.
• Create Entity-relationship and UML diagrams will be employed to model new data import in batch scripting scenarios, combined with command-line scripting in order to transfer, validate and import new information.
• Interface with subject matter experts, customer IT departments and business intelligence experts on a daily basis.
• Self-starter and strongly motivated to operate within this small and rapidly growing Toronto office.
Technologies: Microsoft SQL Server, SQL Clustering, PDW, SSRS, SSIS, MySQL, Power Designer, Talend, Teradata, OLTP, OLAP, DML, and DDL, T-SQL, SQL Tuning, Python, Java, Unix scripting, Kimball Data Warehouse methodology.
ELT SQL Database Developer at CaseBank Technologies Inc., Mississauga, Ontario, Canada May 2012 - Nov 2012:
• SQL programming as Stored Procedures, Functions, Views, Triggers in SQL language to do ETL, import/export data to/from database for aviation application written in Java language.
• Technologies: Power Designer, T-SQL programming on MSSQL Server 2005/ 2008/ 2008 R2, SSRS, SSIS, SQL Server Management Studio, Oracle, Java, Tomcat, Eclipse, JIRA.
IT Specialist at Abba Systems Inc. & Mold Master Ltd., Brantford, Ontario, Canada
Aug 2010 – Sep 2011:
Performs all activities required to support the Information Systems Service Desk; lead and guide day to day operations of IT Help desk.
• Provides remote support over the phone, through email or remote desktop control.
• Supports after hours IT Help desk activities by being the on -call support analyst to respond to issues within 15 minutes 24 hours a day on a rotation basis.
• Creates user accounts in AD, Blackberry and other applications as required for new staff and updates access rights for existing staff.
• Backup/Restore data and database.
• Printers: Install, troubleshoot issues, Sharing and Security, Maintenance
• Windows Server 2003: Administration/Troubleshooting/Configuration
• Group Policy Administration/Creation/Deployments
• Basic Network troubleshooting
• Windows2000/XP/7 Installation/Configuration/Troubleshooting/Administration
• MSSQL Server /Client side administration/configuration
• Project Management for the IT Help desk
• Contacts vendors for product information, pricing and support as required.
ASP/ASP.NET Web Developer at Uno-Interactive, Inc., Colleyville, TX, USA
Jun 2010 - Aug 2010:
Develop, test and maintain modules for web applications as ASP/ASP.NET Developer.
• Technologies used : Power Designer ASP, ASP.NET, ADO/ADO.NET, C#, T-SQL, MSSQL 2008/2008 R2 SQL Server Management Studio, .NET framework 3.5, IIS, Visual Studio 2008/2010 with Visual Studio Management.
• Databases: MSSQL 2005/2008, using stored procedure, trigger, function, batch.
• Operating Systems: Windows Server 2008.
• Write code and calculations for all applications.
• Designed and implemented the database.
• User interface: Designed the GUI and all Web form.
• Created and edited documentation for the flow of the GUI.
• Created all stored procedures, triggers, and views.
• Ensured the integrity of all data and calculations, and made changes as necessary.
• Debugged and maintain the Sterling web application for accounting and financial organization. The YTS Web application is health care web application using in hospital manage
Application Developer at Vehicle Monitor Corporation, Redmond, WA, USA
Apr 2008 - Feb 2009:
Develop, test and maintain modules for a manufacturing information system of Screen Designer, Inventory projects.
• Technology used : UML, VB 6.0, COM, ADO, OLE DB, T-SQL, MSSQL 7.0/2000/2005, Visual Studio 6.0, Visual Studio 2008 as coding language, Crystal Report, MS Dynamics
• Database: Oracle and MSSQL 2000/2005 database.
• Writing code and calculations for all application.
• User interface: Designing and implementing database and designed the GUI and all Web forms
• Created and edited documentation on the flow of GUI
• Creating all stored procedure, triggers.
• Ensured the integrity of all data and calculations and made changes as necessary
• Debugging the program and Preparing it for Presentation The Screen Designer is the latest project I worked on at VMC, Redmond. The software is a tool for engineers to design graphical user interface with bitmaps as pictures or text, the screen is used
in heavy equipment and over the highway truck markets. The complexity of project is to process bitmap objects, including transparent bitmaps, while user adds, deletes, edits with moving and animating images to simulate actual usage. The Inventory application is a database management information tool used for searching and reporting information in manufacturing, accounting and engineering environments.
Information System Engineer at Fujitsu Computer Products of Vietnam, Bien-Hoa, Dong-Nai, Vietnam. Jan 2001 - Jul 2005:
• ETL, develop, maintain and do administration on manufacturing information system with UML, Rational Rose, Access, T-SQL optimization, MSSQL Server 7/2000, 2005, PL/SQL, Oracle 7, 8i, 9i, 10g, C++, Visual Basic, Classic ASP, Crystal Report, Java Script, VB Script, Shell Script on Unix...Windows administration, network management and help desk for more than 500 workstations.
• Manage large Oracle and MSSQL databases Server for about 500 workstations.
Contact this candidate