Data Analyst Application Developer

KEVIN T. PHAM

Buffalo, NY *****

Cell Phone : 716-***-**** Email: ******@*****.***

Summary

Adept BI Data Analyst and Software Application Developer with a proven track record at Northrop Grumman Corporation, Linde PLC and Evans Bancorp, enhancing decision-making and operational efficiency by over 95% through advanced BI reporting and system support. Skilled in IBM Cognos BI 11 and collaborative problem-solving, I excel in developing innovative solutions and leading technology-driven projects to successful completion.

Skills

Software application development

BI report analyst

MS Office

Enterprise Tidal Scheduler

ServiceNow

C/C++

C#

VB /C#

.NET

Java

JQuery/ SQL Query

JavaScript

Python

R Studio

Oracle database/ MS SQL Database

IBM Cognos Administration server

DB2

PowerBI

Crystal Reports

IBM Cognos BI 11

Tableau

SQL ReportBuider/ SSRS

SQL Server Management Studio (SSMS)

SSRS/ SSIS

Encompass

Meridian Link

SageWorks

Prologue

LasorPRO

EWire

Deltek Costpoint, Deltek PPM (Cobra, OpenPlan...)

JDE

Shipping System Development, Automated Delivery software system, Business Intelligence, Business Software Administration, Agile software development methodology, Attention to detail, Teamwork, Collaborating attitude, Can-do attitude

Experience

BI Data Analyst/ System Support and Development, 07/2020 02/2024

Evans Bancorp, Inc. Williamsville, NY

Company Overview: https://evansbank.com

Developed and maintained IBM Cognos 11 BI data report, Microsoft PowerBI/DAX or Tableau report and Programing R, python and SQL query to represent the dashboard for visualized data reports and automated scheduling to support business needs and enhance decision-making processes.

Utilized SSIS to pipeline data between IBM Cognos report server and MS SQL Server and MS SQL.

IBM Cognos Server administration (install, upgrade, troubleshoot Cognos environments), performing health checks, content administration (reports/package promotion, user security)

Designed and created Data Modeling with SSIS for MS SQL data warehouse, developed and maintained ETL packages between DB2 database system and Datawarehouse

Oversee 360BI report & ImageCenter system by ensuring alignment with business needs, automating scheduling of reports, and monitoring & maintaining systems, improving business reporting efficiency above 95%

Administrated Banking Application Administration: Encompass, Meridian Link, SageWorks, Prologue, LasorPRO, eWire, IBM Cognos Administration Server

Data Analyst/ Software Application Developer II, 07/2012 05/2020

Linde PLC Tonawanda, NY

Company Overview: http://www.lindeus.com

Developed and maintain Praxair Automated Inventory and Delivery system in Java and Apache server and maintain the CRM system up-to-date to sync it between ACUSTAR delivery system and CRM module in ERP system (JDE). Pipeline data between JDE, Dispatch,

Using Dispatch Application to automate the orders to delivery routes to RoadRunner system

Developed and maintained Shipping system integrated with Connectship /UPS /FedEx

Developed and maintained eCOA web application in c#.net, MVC and created Data Modeling with SSMS for this application in MS SQL

Documented processes & procedures by conducting root cause analysis, creating SOP maintenance, and streamlining troubleshooting process, reducing system downtime to minimal

Developed and manage project plans, estimates/budget, to assure objectives are met on time and within cost

Presented technical analysis and solutions to business issues, research and implement technical alternatives to meet business requirements

Performed technical support for highly complex, critical programs and systems, utilized ServiceNow for Corporatewide ticket request.

Working with team members and vendor consultants to develop, test and deploy business solutions

Evaluates, recommends and implements systems modifications to reduce user problems

Software Application Developer II, 09/2011 05/2012

Kirchmeyer Associates, Inc. West Seneca, NY

Company Overview: http://www.kirchmeyer.com/

Developed web-based application in ASP.Net, CSS, JQuery and C#/VB.NET with SQL 2008 R database back-end

Developing data reports by SSRS ReportBuider with back-end SQLServer

Using SSIS to migrate data from SQL 2000 to SQL2008

Software Development Engineer/ Analyst, 04/2007 08/2011

Northrop Grumman Corporation Williamsville, NY

Company Overview: http://www.northropgrumman.com

Developed C#.Net Winform and/or Webform applications to ETL data between systems and/or interfaces between systems as SAP, or Travel Concur and Deltek Costpoint ERP. Migrated data to Oracle from MS SQL.

Administrated and developed IBM Cognos BI data reports with backend database in Oracle or MS SQL to support manager's decision making

Evaluates, recommends and implements systems modifications to reduce user problems

Collaborated with team members and vendor consultants to develop, test and deploy business solutions

Researched, designed, developed and/or modified enterprise-wide software in C# and ASP.NET

Involved in planning of full life cycle software system development including requirement, specification, design, implementation, unit testing/user acceptance testing and deployment as well as responsible for meeting company software compliance standards

Created and documented critical software system backup and/or software system disaster recovery

Administrated multiple Oracle servers, managed and implemented database schemas, including but not limited to creating/altering tables, constraints, indexes; created and granted database user roles, stored procedures, SQL statements, and sequences

Evaluated interface between hardware and software, operational requirements and characteristics of overall system, may include security, quality control, applications, system design or systems software development

Administration and supporting of Deltek Costpoint ERP system included MRP, BOM module and Deltek PPM ( Cobra, Open Plan ...) and integrated TipQA system

Education

12/2006 The University of North Carolina at Charlotte - Bachelor of Science Business Administration in Finance

05/2000 The State University of New York at Buffalo - Bachelor of Science Computer Science

Websites, Portfolios, Profiles

http://www.linkedin.com/in/kevin-pham-86252538

Contact this candidate