John Tran Email & Phone Number

Beaverton, Oregon, United States

Beaverton, Oregon, United States

• Design, build, test, implement and document complex SQL scripts including SSIS packaging, views, stored procedures, triggers, and SQL job agents using SQL Server and Visual Studio• Extract and mine data from multiple systems, analyze data, integrate data, validate data for accuracy and develop reports/scripts/inquiries to assist organization’s teams.• QC team members SQL scripts, SSIS packages, views, stored procedures, triggers and SQL job agents.

Portland, Oregon

⦁ 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, Oregon Area

⦁ 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 syncronization 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… Show more ⦁ 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 syncronization 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. Show less

Portland, Oregon Area

● 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.

Portland, Oregon Area

•Worked with Various Microsoft technologies (SQLServer, T-SQL Stored Procedures, SSRS, SSIS, C#.net) to manage data coming and going from various Government and private partners. Attempting to keep up with the ever changing healthcare landscape. •Experience in designing, developing, and implementing business solutions. Highly organized with the ability to maximize system efficiency in manufacturing, distribution, finance, non-profit and insurance industry.

Portland, Oregon Area

• 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… Show more • 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. Show less

Portland, Oregon Area

•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.

Portland, Oregon Area

• Data Operations Analyst using SQL Developer for Oracle, Hive Query Language (HQL), T-SQL in the Hadoop and Oracle database environments.• 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.

San Francisco Bay Area

• 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.• 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… Show more • 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.• 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. Show less

San Francisco Bay Area

•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. We 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… Show more •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. We 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. Show less

San Francisco Bay Area

•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.