KEVIN T. PHAM
Cheektowaga,NY
Summary
Adept BI Data Analyst and Software Application Developer with a proven track record at Northrop Grumman Corporation, 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.
Overview
17
17
years of professional experience
Work History
BI Data Analyst/ System Support and Development
Evans Bancorp, Inc.
Williamsville, NY
07.2020 - 02.2024
- Company Overview: https://evansbank.com
- Developed and maintained IBM Cognos 11 BI data report, Microsoft PowerBI or Tableau report and Programing R to represent the dashboard for visualized data report
- 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 SSMS 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
- Https://evansbank.com
Data Analyst/ Software Application Developer II
Linde PLC
Tonawanda, NY
07.2012 - 05.2020
- Company Overview: http://www.lindeus.com
- Developed and maintain Praxair Automated Inventory and Delivery system in Java and Apache server
- Using Dispatch Application to automate the orders to delivery routes to RoadRunner system
- Integrated
- 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
- Working with team members and vendor consultants to develop, test and deploy business solutions
- Evaluates, recommends and implements systems modifications to reduce user problems
- Http://www.lindeus.com
Software Application Developer II
Kirchmeyer & Associates, Inc.
West Seneca, NY
09.2011 - 05.2012
- 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 ReportBuider with back-end SQL Server 2008 Server
- Using SSIS to migrate data from SQL 2000 to SQL2008
- Http://www.kirchmeyer.com/
Software Development Engineer/ Analyst
Northrop Grumman Corporation
Williamsville, NY
04.2007 - 08.2011
- Company Overview: http://www.northropgrumman.com
- Developed C#.Net Winform and/or Webform applications to extract-translate-load data between systems and/or interfaces between systems as SAP, or Travel Concur and Deltek Costpoint ERP
- 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 (internal to company) 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 10g/11g 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 module, Cobra, TipQA system
- Http://www.northropgrumman.com
Education
Bachelor of Science - Business Administration in Finance
The University of North Carolina at Charlotte
12.2006
Bachelor of Science - Computer Science
The State University of New York at Buffalo
05.2000
Skills
- Software application development
- BI report analyst
- MS Office
- VS SourceSafe
- Team Foundation
- Enterprise Tidal Scheduler
- Connectship
- ServiceNow
- C/C
- C#
- VB /C#
- NET
- Java
- JQuery
- JavaScript
- Python
- R Studio
- Oracle database
- MS SQL
- DB2
- PowerBI
- Crystal Reports
- IBM Cognos BI 11
- Tableau
- SQL ReportBuider
- SQL Server Management Studio (SSMS)
- SSRS
- SSIS
- Encompass
- Meridian Link
- SageWorks
- Prologue
- LasorPRO
- EWire
- Deltek Costpoint
- JDE
- IBM Cognos Administration server
Skills
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
Timeline
BI Data Analyst/ System Support and Development
Evans Bancorp, Inc.
07.2020 - 02.2024
Data Analyst/ Software Application Developer II
Linde PLC
07.2012 - 05.2020
Software Application Developer II
Kirchmeyer & Associates, Inc.
09.2011 - 05.2012
Software Development Engineer/ Analyst
Northrop Grumman Corporation
04.2007 - 08.2011
Bachelor of Science - Business Administration in Finance
The University of North Carolina at Charlotte
Bachelor of Science - Computer Science
The State University of New York at Buffalo
Similar Profiles
Brittany SmithBrittany Smith
Asset Manager at U.S. Bancorp Impact FinanceAsset Manager at U.S. Bancorp Impact Finance
Delaina JohnsonDelaina Johnson
Teller Surpervisor /Personal Banker at Byline Bancorp Inc.Teller Surpervisor /Personal Banker at Byline Bancorp Inc.
Cam ColemanCam Coleman
SBA Loan Officer at Southern BancorpSBA Loan Officer at Southern Bancorp
Alanna HazardAlanna Hazard
Sales Operations Coordinator at Impelix LLCSales Operations Coordinator at Impelix LLC
NATHANIEL BRADLEYNATHANIEL BRADLEY
Manager of Quality Assurance at CSL Plasma CenterManager of Quality Assurance at CSL Plasma Center