Business Intelligence Analyst/Developer

Khiem Nguyen

**********@*****.***

linkedin.com/in/khiemn

Summary

Over 25 years of hands-on experience in Business Intelligence (BI) and data management solutions.

> Extensive experience in analysis, design, development, deployment, and data assurance

> Demonstrated a high level of competency in data analytic and BI reporting solutions and in addition, developed innovative approaches, ideas, and concepts

I excelled in designing and implementing BI solutions that enhance data visualization and reporting capabilities, leading to more informed and agile decision-making processes. My work directly contributed to optimizing marketing strategies and improving operational efficiency, resulting in a significant ROI for my employers.

Experience

Sr. Software Engineer (Business Intelligence - AVP)

U.S. Bank

Dec 2022 - Sep 2023 (10 months)

EBI Data Warehouse Data Destruction - US Bank & MUFG Union Bank systems

•Performed complex SQL analysis of data across seven major systems to determine customer/account data ownership, both past and present data, for both MUFG Union Bank and U.S. Bank.

•Developed scripts for data migration from MUFG Union Bank to U.S. Bank and deletion of data from

MUFG.

•Created thorough test plans and supervised their execution by the ETL team in development and test environments.

Sr. Software Engineer (Business Intelligence - AVP) MUFG Union Bank

Jul 2015 - Dec 2022 (7 years 6 months)

Reporting Development Lead - Threat & Vulnerability Management Project

- Played a key development role and supported multiple BI solutions relating to actionable metrics for remediation of vulnerabilities and risks within the IT division relating to MRA (Matters Requiring Attention) and consent orders by the OCC Regulator.

•Demonstrated ownership and effective execution of tasks in Business Intelligence reporting and security solution and POC for Cybersecurity data through HP Service Manager, Splunk, and Qualys applications, and in addition to the project plan, working sessions with PMO, management, and various business areas with technical users.

•Conceptualized with BusinessObjects admin team and data marts to incorporate data and security group/folder roles with different business units and projects.

•Interacted directly with project team members and business stakeholders to translate business requirements into technical specifications to drive the semantic layer and report development documentation.

•Contribution to BusinessObjects admin team through the software development lifecycle for implementing BusinessObjects reports and universes from XI3.5 to 4.x and repository from on-premise to AWS.

•Worked with other Enterprise Business Intelligence (EBI) team members to test reports and influence Data Modeler and semantic layer design and data transformation logic enhancements to support business reporting requirements.

•Led designing and training sessions, and demonstrations with business stakeholders and technical staff in person or via online collaboration.

Business Analyst MUFG Union Bank

Jan 2014 - Nov 2014 (11 months)

•Provided and demonstrated business analyses of Leones – Operations Reporting of combining two Union Bank (West) and BTMU (East) operations.

•Conducted and led working sessions with multiple SMEs between two operations and provided weekly status and updates to team members, and program/project managers.

•Identified, defined, standardized, harmonized, and closed the gaps of key performance indicators based on two banks (Union Bank and BTMU) of operations reporting.

•Delivered assessment and planning on Phase II of Leones – Operations Reporting for non-matching key volume indicators of Legacy UB and BTMU reorganization and Middle Office Data Assurance.

Sr. Software Engineer

Union Bank

Oct 2007 - Sep 2013 (6 years)

•Delivered BI reporting solutions by working closely with DA (Data Architect) and ETL (Extract,

Transform and Load) team on Data Mart projects: ACH (Automated Clearing House), Customer Services, Cash Vault, Online Referral, REIG@TOPS, Loan Origination, ESB (Enterprise Solutions for Bankers), GL BTS (Business Technology and Services), BTS Dashboard and Financial Control Reporting solution, and Consumer Lending.

•Played a key role in BusinessObjects production supports on rotation as administrator and access restriction in CMC.

•Adhere/contribute to BIT best practices; demonstrate professionalism via customer service, innovation via developed solutions, BIT support/UAR processing effectiveness, and compliance with Bank policies and procedures Peregrine (Change Management, Incident Management).

•Assisted business unit stakeholders using Crystal Reports, retired or converted BusinessObjects DeskI, SharePoint contribution, and operational automation.

•Researched and gathered business justification and strategic validation plan for upgrading BO Enterprise XIR2, XI3.1, and XI3.5.

Sr. Information & Reporting Analyst

Argent Mortgage Co, LLC

Sep 2004 - Oct 2007 (3 years 2 months)

●Demonstrated initiative for taking on multiple projects and responsibilities of a strategic and tactical nature.

●100% successful completion of assigned projects: audit and analyze BO usage, reports, and universes and compare feature sets and impact analyses of migration from BO 6.5 to XI from development and end-user perspectives.

●Coached and mentored 2 new reporting analysts in all technical and procedural domains and was responsible for one-on-one and small users' group training using BO WebI and Desktop Intelligence.

● Worked closely with management, executives, IT, operation staff, and end-users to ensure quick solutions to BO, data, and reporting issues.

System Analyst

Union Bank of California (UBOC)

Jun 2001 - Sep 2004 (3 years 4 months)

●Performed customer support and system administration activities for all BusinessObjects modules.

● Worked extensively in gathering business and report requirements and BO database models to perform queries and data analyses with network/database infrastructure while documenting the operation workflows.

●Wrote customized training materials for business partners.

●Developed customized audit and repository universes including generating numerous metric reports to monitor performance against the wide range of systems and data marts.

●Designed effective workflow of instructions, procedures, and guidelines for BO reporter, WebI Admin, Supervisor, and BCA Publisher and customized security procedures aligning to bank security standards.

Education

Orange Coast College

Associate's Degree, Computer and Information Sciences, General

1992 - 1995

Huntington Beach High School

GED

1988 - 1992

Skills

SAP BusinessObjects • PL/SQL • Crystal Reports • Relational Databases • Toad for Oracle • Jira • Business Intelligence (BI) • Problem Solving • Dimensional Modeling Fundamentals by Kimball Group • Reporting & Analysis • Data Analytics • Dashboards • Data Marts • ServiceNow • Data Modeling • Agile Methodologies • Cross-functional Team Leadership • MS Power BI

Contact this candidate