John Minh Tran

*** ** ********** ******, ********, OR 97239

https://www.linkedin.com/in/johntranpdx

ac7vg3@r.postjobfree.com

971-***-****

Technical Skills

Microsoft SQL Server (2005, 2008 R2, 2012, 2014), SSRS, SSIS, Amazon Web Services, Amazon Redshift, PostgreSQL, Qlik Sense, Talend, .Net 3.0, C#, Visual Studio, JavaScript, HTML, ASP, Visual Basic, VBA, VBScript, Microsoft Access, Team Foundation Server, Microsoft Excel, Linux, PHP, MySQL, Hive Query Language (HQL), Oracle, Salesforce, IBM Cognos, Adobe Photoshop, Adobe Illustrator, Adobe Dreamweaver, Windows XP, Windows Server 2008, Windows Server 2012 OS.

Education

James Madison University - Harrisonburg, VA

Bachelor of Arts, Mass Communication

Dec 1995

Professional Experience

Gridworks IC - Portland, OR Aug 2018 – Nov 2018

Business Intelligence Engineer

•Created new Data Warehouse using PostgreSQL and Amazon RDS for call center and healthcare claims.

•Created operational and management reports using Qlik Sense.

•Created ETL processes using Talend Studio.

Portland General Electric - Portland, OR Oct 2017 – Jul 2018

Business Analyst/Database Developer

•PGE technical Business Analyst representative for customer programs with outside vendors.

•Created and maintained ETL processes between vendors using SQL Server and SSIS.

•Managed data synchronization processes for high-level business programs using SQL Server, stored procedures and SSIS.

•Created a SQL Server database and ETL process from excel to manage program participants.

•Wrote ad hoc T-SQL queries for business analysis with management and business partners.

•Managed UAT testing for custom vendor software implementation.

New Seasons Market - Portland, OR Mar 2017 – Jul 2017

Database Developer

•Created new retail Data Warehouse using SQL Server 2012, T-SQL Stored Procedures and AWS Redshift.

•Created operational and management reports using SSRS and T-SQL Stored Procedures.

CareOregon - Portland, OR Oct 2015 – Dec 2016

Software Developer/Business Analyst

•Worked with Various Microsoft technologies (SQLServer, T-SQL Stored Procedures, SSIS, C#.net) to manage data coming and going from various Government and private partners (ETL).

•Create and update operational and management reports using SSRS and T-SQL Stored Procedures.

•Experience in designing, developing, and implementing business solutions. Highly organized with the ability to maximize system efficiency in retail, manufacturing, distribution, finance, non-profit and healthcare insurance industries.

Cambia Health Solutions - Portland, OR Mar 2015 – Oct 2015

Systems Administrator IV

•Systems Administrator for Microsoft SQL Server Reporting Services.

•Installation, upgrade, testing and ongoing maintenance of new and existing corporate BI and data technologies.

•Provided technical, interpersonal and administrative skills in performing day to day work; interacting with developers, end users, management and vendors to maximize tool performance, stability and uptime.

•Developed new reports and modified existing reports using Visual Studio 2008 and Microsoft SQL Server 2008 and 2008 R2.

•Upgraded application and database servers to SQL Server 2008 Reporting Services.

•Extract Transform and Load data using SQL Server Integration Services packages.

Daimler Trucks North America - Portland, OR Sep 2014 – Nov 2014

Software Consultant

•Technical lead in migrating Business Intelligence software to latest version of IBM Cognos Metric Studio 10.2.1.

•Implemented the testing of functionality between the development and production environment.

•Migrated management reports to Cognos Reporting Studio 10.2.0.

•Systems Administrator for IBM Cognos Metric Studio. Installation and configuration of development and production SQL Server database environments.

Nike - Beaverton, OR Nov 2013 – Aug 2014

Data Operations Analyst

•Data Operations Analyst using SQL Developer for Oracle, Hive Query Language (HQL), T-SQL in the Hadoop and Oracle database environments.

•Troubleshoot data issues between the Retail and Consumer databases; Adobe Omniture data.

•Liaison between Business Intelligence and Digital Technology.

•Attended daily Agile scrum meetings and reported Business Intelligence requirements and issues.

•Unit Application Test (UAT) new features in Cognos Business Intelligence (BI) software with Oracle databases.

Goodwill Industries of San Francisco - San Francisco, CA Jun 2008 – Nov 2013

.NET Software Engineer/Database Administrator/Business Analyst

•Design and development of all agency software solutions using Microsoft .NET, C#, SQL Server. Developed a retail sales database and reporting system for 20 stores using .NET and Microsoft Reporting Services from a legacy Linux environment.

•DBA duties including installing and configuring database servers, implementing security settings for reports and databases, scheduling automated backups using SQL Server Agent, monitoring of database performance using SQL Profiler, and installing patches & upgrades to SQL Server.

•Developed corporate Intranet for 6 departments using Microsoft Sharepoint 2010.

•Developed all web applications including a warehouse inventory system, donations management system, facilities work order system, and transportation management system.

•Gathering and analyzing user requirements to design and develop solutions, testing and documenting design specifications.

•Developed Analysis Cubes using SSAS to measure KPIs.

•Salesforce CRM administrator.

EVault/Seagate Services - Emeryville, CA Apr 2005 – Jun 2008

Web Developer/Webmaster

•Web Developer using Microsoft .NET 2.0, C#, SQL Server, HTML, XHTML, JavaScript, Photoshop, CSS, Perl, IIS, and ASP. Our team developed and maintained all of the internal web applications for the company.

•Completed all front-end and back-end development of web pages.

•Customer Relationship Management (CRM) administrator of Sage SalesLogix application.

•Intranet administrator using Microsoft SharePoint.

•Webmaster of the corporate web site. I created Web Analytic reports for upper management about web site traffic and lead conversions.

High Voltage Interactive - Sausalito, CA Jan 2004 – Apr 2005

Production Manager

•Managed team of on-site and off-site web developers, programmers and web designers in building customized client websites and databases using SQL Server, HTML, IIS, ASP, Photoshop, JavaScript, XHTML, and Perl.

•Project Manager for all internal and client database, web and software related projects.

•Technical Account Manager for all client-service technical related issues.

•Created management reports and studies for upper management.

Mortgage-Education.com - Kennesaw, GA Sep 2003 – Jan 2004

Webmaster

•Developed, maintained and administered company-wide web site and off-site server using Microsoft IIS, SQL Server 7.0, ASP, HTML, JavaScript, Macromedia Flash, Adobe Photoshop, CSS and JavaScript.

•Created and modified stored procedures within SQL Server database, and modified ASP pages to add new functionality and correct errors.

•Created new images for website and corporate client section using Adobe Photoshop.

Speer & Associates - Atlanta, GA Feb 2001 – Sep 2003

Webmaster

•Developed, maintained and administered company-wide website and web-server using Microsoft IIS 5.0, SQL Server 7.0, Microsoft Server 2000, XML XSLT Stylesheets, ASP, Javascript, Adobe Photoshop, Macromedia Ultradev, Macromedia Flash 4 and Adobe Photoshop.

•Created management reports and studies for upper management.

•Designed, developed, and maintained financial web sites assessment database using Microsoft Access. Developed and maintained DMS system using Microsoft Sharepoint.

B/D Solutions - Atlanta, GA Nov 1998 – Feb 2001

Technology Manager and Webmaster

•Designed, developed, maintained and advertised company-wide websites using Dreamweaver, FrontPage, HTML, Active Server Pages, Javascript, Microsoft Access, Visual Basic for Applications, Adobe Photoshop and Corel Draw.

•Designed, developed and maintained internal online timesheet and expense tracking system using Active Server Pages, HTML, Microsoft Access and Visual Basic for Applications.

•Developed back-end and front-end design of company-wide proprietary brokerage branch auditing software using Microsoft Access.

•Provided database, web application, and back-office software consulting to external clients.

•Oversaw all software and hardware related purchases and maintenance.

S.P Richards - Smyrna, GA Jan 1998 – Nov 1998

Access Database and Visual Basic Developer

•Analysis, design, and development of inventory tracking and sales applications for national office supplies wholesaler using Microsoft Access, Visual Basic and Visual Basic for Applications.

•Developed back-end, front-end design of client websites using Dreamweaver, FrontPage, HTML and Microsoft Access in a small team environment.

•Trained and supported software for all sales and administrative staff.

Computer Sciences Corporation - Falls Church, VA Oct 1996 – Jan 1998

Access Database Developer

•Developed and maintained budget and expense tracking database for Department of Defense projects using Microsoft Access.

•Created queries, reports and macros for client-server database.

Contact this candidate