Sign in

Business Systems and Data Analyst

Agoura Hills, California, United States
March 09, 2019

Contact this candidate



***** ***** ***** · Agoura Hills, California 91301 · 818-***-****(h) · 805-***-****(c) ·

TEAM LEAD & MANAGER: BSA, Data Analyst, Information Technology (IT)

Seasoned IT professional with depth and breadth of knowledge including international experience in analyzing complex business, systems and data requirements. Strong team player dedicated to aligning with IT and business community. Additionally deep technical background in myriad technologies and products, design, development, and project management methodologies.

IT Strategy · IT Management · Team Building & Leadership · Product Management · Project Management · Build Management · Release Management · Risk Assessment · Employee Development & Career Progression · Vendor Management · Process Reengineering · Client Relationship Management · Resource Allocation · Business Systems Analysis (BSA) · Software Development Lifecycle (SDLC) · Requirements Management · Process & Data Modeling Entity Relationship Diagrams (ERD) · User Acceptance Testing (UAT) · IT DR/BC · Rapid / Agile / Waterfall Methods


Master of Information System Management Keller Graduate School of Management, 2006. Suma Cum Laude

Bachelor of Science in Computer Science with honor, National University


Management, Leadership, Advanced Supervisor Compliance Program • Requirements Management Caliber Analyst

Art Of Requirements Engineering • Data Stage/ETL Essentials • PlanView • IS Project Management • Oracle Introduction


Language & DB: Visual Basic, .Net, JAVA, SAP, ETL, Natural4, Construct, Cobol, PL/1, SAS, Focus, Fortran, Assembler, MS Access, SQL Server, DB2, ADABAS, Oracle, SYBASE, OODBMS, ORDBMS, IMS VSAM

Methodology: CMMI, Agile/Scrum, Lean Six Sigma, RUP, UML, JAD, ISOTEC, SSADM, HIPO, Waterfall, Structured Diagram and Pseudo code, Data Modeling (ERD), Work Process Flow, Software Test Strategy

Tools: DOORs, Cloud PLM/Fussion360, iRise, Visio, System Architecture, Todd, CaliberRM, DefineIT, SharePoint, ERWIN, Rally for EPIC/User Stories, Predict, Predict CASE, MS Office (Outlook, PowerPoint, Project, Excel, Word, Paint), WebSphere Studio, Enterprise Java Beans, PeopleSoft, McAfee, Lotus Notes, FileAid, Endevor, Expeditor

OS: Windows 10 / 7 / XP / NT, VSS,UNIX, XML, EntirX, AIX, Linux, Client/Server, Harvest, SVC, DOS, QuickPlace, MVS/JCL, VM/CMS, OS/VS1, OS400, BS2000, CDC6400, TSO/ISPF, CICS, ELIPSE, SDSF, CA-7, Syncsort


VACCO Industries, Los Angeles, California · May 2013 – Present

$ 98 million leading designer and manufacturer of specialty solutions to critical missions for defense, space, and commercial markets.

Senior Business Systems Analyst (Sr. BSA) & Liaison

Attend IT Steering Committee (ITSC) to understand the business objectives and initiatives needed for providing VACCO clients, which 98 percent are governmental and military entities, with their requested products, services, and parts. Lead IT Center of Excellence (IT COE) and work with Program and Product Management for business process improvements. Maintain all information systems (i.e. ERP, Business Intelligence/Data Warehouse (BI/DW), IQS, CRM, Cloud PLM, Inventor/vault, IT HD Ticketing system “Track-It”, etc.) and team up with IT and business for addressing DoD/DoE security needs (DFARS/NIST). Manage IT Change Control meeting, perform IT system function and data gap analysis, and improve IT SOX Audit Process resulting with no deficiency 5 years in a row.

Develop a customized IT Software Development Life Cycle (IT SDLC) stages and associated templates for documenting As-Is versus To-Be deliverables and UML design artifacts (i.e. Vision Document, Business Req., Functional Req., Activity Diagrams, Use Cases, and User Interfaces).

Lead a team of 8 business analysts, uniform IT workflow, and perform business function and data gap analysis.

Act as Solution Architect to analyze business needs and create Function/Data Model (Function Breakdown & ERD).

Develop IT Service Level Agreement (IT SLA) and implement it in the BMC software “Track-It” for addressing user issues and requests properly, the monthly measurements has been %98 or higher for last 5 years.

Define IT Security Policies, Procedures, Standards, plan IT Disaster Recovery and Business Continuity (IT DR/BC).

Lead Connectivity Redundancy initiative utilizing MPLS, FatPipe, and Web Optimizer technologies.

Implement Application Role Base Access and create New Hire and Staff Termination workflow to improve IT Audit.

Develop User Acceptance Test (UAT) master plan, standards, scripts, test cases, and manage the execution of UAT.

FIRST AMERICAN FINANCIAL Co., Los Angeles, California · Mar 2012 – Apr 2013

Vital part of $4680 million First American Family traces its heritage back to 1889, Industry leader in home warranty for over 25 years.

Lead Product and Data Analyst

Interact with business stakeholders, develop product life cycle, and drive a product solution set across teams. Manage new and existing products, including ownership of the respective product roadmaps from strategic planning to tactical activities. Support the development and progression of products/services and play a role in all the stages of BI/DW development and Data Analytics. Collect and analyze data for the potential target markets and promotion of products.

Led the core team for developing a new Business Intelligence/Data Warehouse (BI/DW) process, data model and workflow to plan broad-ranging product initiatives, promotions, and pricing decisions.

Provided algorithms and analyzed data using SAP WBI reports, SQL Server for queries, and Xcel Pivot tables.

TOYOTA FINANCIAL SERVICES, Torrance, California · Nov 2009 – Mar 2012

Vital part of $857 million US Toyota, global financing provider offering financing, vehicle, and payment protection products.

Lead Business Systems Analyst (BSA) & Liaison

Synchronize efforts of change and enhancement requests among onsite and offshore resources (i.e. Risk Management, Dealer Credit, Dealer Sales & Services / Field Operations, Commercial Finance, Special Asset, etc.). Support crossed functional applications AuctionNet, Dealer Credit Online Application (DCOLA), and Dealer Lending Portfolio Management interfaced with other systems and data sources such as Crowe Navigator, Shaw, WMS, EWS, RCLS, EIM and DCRS. Enforce build/release management, collect requirements, provide gap analysis, approve QA functional test cases in Mercury, define project scope using JAD, interviews, questionnaires, surveys, tools (iRise, System Architecture, Visio).

Developed new business process, data model and workflow among six different TFS departments, automating the calculation of probability of default (PD) in Crowe Navigator and improving loan process up to 35%.

Developed User Acceptance Test (UAT) master plan, scenarios, test cases, and managed the execution of UAT

Provided Security Admin requirements (SOX Compliance) and User Support scripts for managing user access.

Enhanced AuctionNet batch process and improved auction car data updates up to 95% faster by using Scrum.

Participated in Data Governance Board Center of Excellence (DGB CoE) for improving the data design process.

Led DCOLA project team (authors of code, reviewers, and QA testers), providing change control management to implement and maintain the Web/.Net applications on time/budget.

Documented As-Is versus To-Be deliverables and UML artifacts (i.e. Vision Document, Use Cases, Business Req., Functional Req., Activity Diagrams, and User Interfaces) and led vendors in System, ETL, and MFT design.

WOLTERS KLUWER (CCH INC.), Torrance, California · Mar 2006 – Jul 2009

Vital part of € 3,660 million business, developer of software, workflow tools, information services for tax, accounting, and legal.

Business Systems Analysis Team Lead

Manage a team of 14 on-site and offshore business analysts and implemented uniform business analysis and project management methodologies. Manage change requests and bug fixes, using Lotus Notes and SharePoint, for Foundation products and Next Generation (.Net) projects. Lead data model design and define ETL and metadata repository approach for EDW (Enterprise Data Warehouse), ODS (Operational Data Store) and various DMs (Data Marts). Mentor associate and vendor staffs with design process, build/release management, reviewed their performance, and lead them in CMMI and SCRUM (Agile) process.

Act as liaison between business and IT leads, documenting User Stories and Product Backlog per Scrum method.

Utilized Lean Six Sigma to create checklists/metrics, improving project process and measuring the progress.

Defined Reverse Engineering process to analyze gaps for Legacy to .Net system transformation & data migration.

Utilized Caliber Requirements Management (CaliberRM) tool, creating UML design artifacts and Traceability (i.e. Vision Document, Business Req., Functional Req., Activity Diagrams, Use Cases, and User Interfaces).

Mentored team with developing the Logical Business Process/Data model for Client Relate data mart and reports.

Received certification of “Advanced Supervisor Compliance Program” and “CCH Excellence In Action (EIA)” award for the completion of analysis/design activities using Scrum (Agile) and JAD on time and within defined budget.


Lead Business Systems Analyst (BSA), WELL POINT PHARMACY MANAGEMENT, West Hills, CA

Report Analyst & Enterprise Data Architecture, GREEN DOT CORPORATION, Monrovia, CA

Data Analyst & Enterprise Architecture, Option ONE Mortgage Co. (OOMC), Irvine, CA

Business Systems Analyst (BSA) & Liaison, American Family Insurance Co. (AMFAM), Madison, WI

Systems Analyst & Project Coordinator, University of Wisconsin (UWP), Kenosha, WI

Senior Systems Analyst & Liaison, S.C. Johnson (SCJ), Racine, WI

Y2K Project Lead, Commercial Union (CU) Assurance, Toronto, Canada

System Analyst, Consumer’s Gas, Toronto, Canada

Database Analyst, Ministry of Community and Social Services, Toronto, Canada

Programmer Analyst, ILVA / IRSA, Milan, Italy

Contact this candidate