Data Management Business Objects
Resume:
Bradley (Brad) Scott Zasio
******@*****.***
Education
●Bachelor of Arts - English Literature, University of California, Santa Barbara (Graduated)
Technical Skills
●System: Unix, Linux, Windows
●Database: Oracle 11g, Netezza, MS-SQLServer, MySQL, Teradata on NCR, Informix 8.x, Vertica
●Languages and BI Tools: Informatica PowerCenter 10.x, Informatica Developer (IDQ) 10.x, Informatica Analyst (DQ), IICS (Informatica Cloud Services), IDMC(Intelligent Data Management Cloud), Snowflake Core Certified, Netezza SQL, Oracle PL/SQL, utPL/SQL, Oracle Data Integrator (ODI), T-SQL, K-shell w/vi editor, Business Objects Web-Intelligence (WEBI), Business Objects Universe Designer, Tableau 8, Control-M, Maestro TWS, ERWin, TOAD, ServiceNow, Rational ClearCase, Rational ClearQuest, Jira, MicroFocus Cobol. IBM Mainframe, CICS, DB2, Cobol II, JCL.
Technical Training
●Business Objects – Web Intelligence Report Writing - Irvine, CA (Completed)
●Informatica Global Education Services - Irvine, CA, Informatica 8.1.1 Administration (Completed)
●Oracle 10g - Irvine, CA. Oracle University (Completed)
●Teradata Architecture - San Diego, CA (Completed)
●Verizon Wireless - Bellevue, WA. - Informatica 1.6 (Completed)
●University of California, Irvine - Introduction to Java (Completed)
●Oracle
Oracle 8: New Features for Administrators Completed)
Tuning Oracle 7.3 (Completed)
Oracle 7.3 Database Administration (Completed)
●Informix - Tuning Online 7.2
Online 7.2 Database Administration (Completed)
●Completed extensive curriculum in Computer Programming - 700 hours, Computer Learning Center, Anaheim, California (Completed)
●Python 1-2 years
●Obtained Snowflake Core Certification
Employment History
The Planet Group (Consulting)
Marketing Technologist Oct 2024 to Dec 2024
Supported client Ersi Inc (Redlands, CA) in its marketing initiatives using SQL, Salesforce, Informatica IDQ to produce and maintain potential client mailing list.
Produce presentations and documentation highlighting KPI surrounding marketing efforts that are reportable to the user community.
Deloitte LLC – Costa Mesa, CA
Sr. Solution Specialist Jan 2022 to Aug 2024
Supported Data Governance Project with the IRS – 6/24 – 8/24
●Produced presentations and documentation highlighting the features, benefits and usage Experience using Informatica Intelligent Cloud Services, IDQ Developer, Intelligent Data Management Cloud-IDMC, Informatica Address Doctor, Informatica Analyst and Informatica EDC for creating, maintaining and reporting in a Data Governance/Data Quality ecosystem infrastructure within the Bureau.
Supported Data Catalog Project with the CFPB 08/23 – 5/24
●Designed Data Catalog for large Consumer Complaint database for use by the Consumer Fraud Protection Bureau.
●Utilized Data.World software to implement and build-out the Data Catalog.
●Captured Requirements and created use cases for the catalog
Supported Project with the OCC for U.S. Treasury 02/22 – 7/23
●Used MS-SQLServer to support Table, View, Stored Procedure Maintenance.
●Used MS-SSIS to support ETL/ETL workflows to load EDW tables overnight.
City National Bank (CNB) FTE - Los Angeles, CA
Sr. Data Quality Architect/Developer Oct 2018 to Dec 2021
●I worked in the Data Office, which is part of the Risk group, not IT. We serve as the second line of defense to ensure that all data within the enterprise is fit for use and will not have negative impact on the company when consumed for Regulatory Reporting, Decision Making, or Financial Reporting.
●Design, Develop and implement Data Quality Profiling, Scoring, Data Assessment and Reporting solutions on data amongst multiple lines of business within the enterprise.
●Experience using Informatica Intelligent Cloud Services, IDQ Developer, Intelligent Data Management Cloud -IDMC, Informatica Address Doctor, Informatica Analyst and Informatica EDC.
●Engage Business Analysts and Data Stewards to develop Data Quality rules and standards used across the enterprise.
City National Bank (CNB) - Los Angeles, CA
Consultant Employee – Sr. Informatica Data Quality Architect / Developer
Informatica Data Quality Architect employed by Solugenix July 2018 to Oct 2018
●Design, Develop and implement Data Quality Profiling, Scoring, Data Assessment and Reporting solutions on data amongst multiple lines of business within the enterprise.
●Experience using Informatica IICS, IDQ Developer, Intelligent Data Management Cloud -IDMC, Informatica Address Doctor, Informatica Analyst and Informatica EDC.
●Engage Business Analysts and Data Stewards to develop Data Quality rules and standards used across the enterprise.
ICU Medical – San Clemente, CA Feb 2018 to Apr 2018
Sr. Informatica Architect/Developer
●Informatica Power Center 9.x Data Integration Architecture, Design, Development, Maintenance
●Oracle BI-EDW
●Oracle DAC.
●Develop Functional, Technical, Test Plan documentation.
●Prod Support
Rabobank N.A. – Roseville, CA July 2016 to Feb 2018
Sr. Informatica Architect /Developer
●Work with Business Analysts to interpret and implement ETL/Data Integration requirements.
●Data Governance initiatives using Informatica Analyst DQ interface with scorecards.
●Develop Data Quality standards with Business Analysts and user community for use in our internal QA and User Acceptance Test of ETL processes.
●Develop Functional, Technical, Test Plan documentation of ETL processes.
●Informatica Power Center 9.x Data Integration Architecture, Design, Development, Maintenance
●IICS (Informatica Cloud Services) with API Integration Manager
●Linux Shell-Scripting
●Troubleshoot failed Informatica Workflows and ETL data transport interfaces. (MQX)
Experian Corp. – Costa Mesa, CA Nov 2014 to July 2016
Consultant Employee – Sr. Informatica Specialist
Informatica Specialist employed by Kaygen
●Informatica Power Center 9.x Data Integration Design, Development, Maintenance
●Support Experian’s Brazil “Me Prejora” DOS. Nightly Load to
●Develop Functional, Technical, Test Plan documentation.
●Troubleshoot failed data transport interfaces.
●Support DataMigration SQL-Server to Netezza
Paramount Pictures Corp. – Los Angeles, CA Apr 2014 to Nov 2014
Consultant Employee – Sr. Informatica Specialist
Informatica Specialist employed by TCS America
●Informatica Power Center 9.x Data Integration Design, Development, Maintenance
●Support EAI Framework components within the company to facilitate data transport middleware infrastructure.
●Make use of SAP BAPI/RFC Informatica Transformations
●Develop Functional, Technical, Test Plan documentation.
●Troubleshoot failed data transport interfaces.
U.S. Treasury Department (IRS) - Ogden, UT Nov 2013 to Apr 2014
Contract Consultant – Sr. Informatica Specialist
Informatica Sub-Contractor employed by Charter Global Inc.
Supporting Deloitte Consulting’s engagement with the Federal Government to support their IRDM/AUR projects.
●Informatica Power Center 9.x Data Integration Design, Development, Maintenance
●Developed an Informatica ‘Continuous Integration’ process that incorporate Informatica command-line utilities, Rational ClearCase command-line utilities, utPL/SQL, shell-scripting in order to support a continuous and synchronized Informatica Unit Test environment with multiple release versions and the flexibility to select from several release versions for promotion to the Informatica SAT (System Acceptance Test) environment.
●Designed an Informatica Based automated unit test process for executing sessions and scoring results based on business rules stored as parameter variables. Results are versioned for reference when needed as part of a build release.
Intuit - Turbo Tax, San Diego, CA Nov 2011 to Sep 2013
Employee – Sr. Business Systems Analyst
Support the company’s TurboTax Consumer Group Business Analytics initiatives using the latest Database and Business Intelligence technologies.
●Gather, understand, procure approval of Business System requirements.
●Business Objects 3.1 Universe Design, Develop, Maintenance
●Business Objects WEBI XI Report/Dashboard Design, Develop, Maintenance
●Informatica 9.1 Data Integration Design, Develop, Maintenance
●Informatica Cloud with Salesforce Integration
●Data Integration with Salesforce connector for PowerExchange using Informatica Power Center.
●Translate SSIS mappings to Informatica mappings.
●Tableau 8 Development
●Design, Develop, Test and Deliver Business Intelligence Solutions to various BUs.
●SDLC
●Manage customer engagement.
●Big Data exploration – Intro to Hadoop, NoSQL, Pig, Hive, ODBC Business Intelligence layer
●Predictive Analysis initiatives.
Qualcomm, San Diego, CA Jul 2011 to Nov 2011
Contract Consultant
Project ––Enterprise Data Warehouse – Finance
Sr. ETL Architect/Programmer/Analyst
Support the company’s Enterprise Data Warehouse ETL for Finance reporting
●Informatica 8.6.1 ETL (Extraction-Transform-Load) Architect, Design, Code, Test, Implement, and support mappings and workflows.
●Oracle 11g PL/SQL Development within ETL
●Oracle ODI Development to support ELT (Extraction-Load-Transform) based datamart
●Data Warehouse Design, Star Schema, including dimensional modeling.
●Production Support. – Rotating Support of Informatica Batch DW Loads
Intuit - Turbo Tax, San Diego, CA
Contract Consultant Jan 2011 to June 2011
Project - Netezza Data Analyst
Sr. Data Analyst/Architect
Support the company’s TurboTax customer loyalty initiatives via
●Design and develop Netezza SQL Analysis on over 8T and growing database.
●Familiarized with internal processes to quickly identify and resolve filer issues with software releases so that customer relationships are improved.
●Predictive Analysis initiatives.
Qualcomm, San Diego, CA Jan 2010 to Jan 2011
Contract Consultant
Project ––Firethorn DW
Sr. ETL Architect/Programmer/Analyst
Support the company’s Firethorn Data Warehouse ETL and BI reporting initiatives, executive dashboard, KPI, etc.
●Informatica 8.6.1 ETL (Extraction-Transform-Load) Architect, Design, Code, Test, Implement, and support mapping including the use of partitioned loading and workflows.
●Oracle 10g PL/SQL Development within Powercenter ETL
●Data Warehouse Design, Star Schema, including dimensional modeling.
●Data Warehouse Design, Star Schema, ER-Win.
●Control-M Development and Production Support
Insight Imaging Inc. Lake Forest, CA Dec 2008 to Dec 2009
Employee - Sr. Data Warehouse Analyst/Architect
Support the company’s IRIS Data Warehouse and BI reporting initiatives, executive dashboard, KPI, etc.
●Informatica 8.6.1 ETL (Extraction-Transform-Load) Architect, Design, Code, Test, Implement, and support mapping and workflows.
●Informatica 8.6.1 Administration – monitor system, ensure continuous availability.
●Install, upgrade, and apply patches and version updates across Dev, QA and Prod environments.
●SQL-Server 2008 T-SQL
●Translate SSIS mappings to Informatica mappings.
●Data Warehouse Design, Star Schema, including dimensional modeling.
●Business Objects – Universe Development, Web-Intelligence Report Development and Central Management Console Administration
●Microsoft Analysis Services – Executive Dashboard KPI cube design
Fidelity Information Services. Santa Ana, CA Jan 2007 to Dec 2008
Employee - Sr. Data Analyst/ETL Architect
●ETL (Extraction-Transform-Load) data integration team
●Spearhead and contribute to data integration systems projects using Informatica 8.1.x, Informatica 7.1.x, Oracle 9i, 10g, PL/SQL
●Design, code, test, deploy, support data integration systems and subsystems using disparate data feeds to maintain a large Customer/Account OLTP system, FEDR Data Warehouse and provide time critical DSS reports
●Experience with Informatica 8.x Data Quality and Data Profiling modules
●Production Support, Monitor, Troubleshoot, Recover and Tune Informatica Workflows
●Informatica 8.x Administration – monitor system, ensure continuous availability. Install, upgrade, and apply patches and version updates across Dev, QA and Prod environments.
●Informatica Support Liaison
AMC Mortgage Inc. Irvine, CA. Oct 2005 to Jan 2007
Employee - Sr. Data Analyst/ETL Architect ETL (Extraction-Transformation-Load) data integration team member
●Spearhead data integration systems projects using Informatica 7.1, Oracle PL/SQL and BMC Control-M.
●Design, code, test, deploy, support data integration systems and subsystems using disparate data feeds to maintain a large Customer/Account OLTP system and supply downstream systems.
●Production Support, Monitor, Troubleshoot, Recover and Tune Informatica Workflows
Softmaster Inc. July 2002 to Aug 2005
Contract Consultant -Toyota Motor Sales, USA, Torrance, CA. - (3 projects)
Project – TOMS - Oct 2004 to Aug 2005
●ETL (Extraction-Transformation-Load) development with Informatica 7.1 and Oracle PL/SQL for data integration of web-based vehicle order management system.
●Develop K-shell scripts to invoke Informatica Sessions programmatically.
●Support TOMS database development using ER-Win
●Support Oracle Stored Procedures and Functions to support Informatica Transformation
●Support nightly Subset Upload production load process.
●Support Informatica production builds
Project – Raven – November 2002 to Oct 2004
●ETL (Extraction-Transformation-Load) development with Informatica 6.x/7.x and Oracle PL/SQL for data integration of new OLTP, Object-Oriented relational database, web-based claim/warranty system.
●extract RDBMS data, transform it, and send it back up to VSAM Legacy environment.
●Create, Support, Monitor, Troubleshoot, Recover and Tune Informatica Sessions with Informatica Repository Manager, Designer, Server Manager.
●Set up and execute Informatica Sessions in batch and stand-alone.
●Develop Oracle Stored Procedures and Functions to support Informatica Transformation.
●Develop K-shell scripts to invoke Informatica Sessions programmatically.
Project – Monarch July 2002 to November 2002
●ETL (Extraction-Transformation-Load) development with Informatica 5.1 and Oracle PL/SQL for large Parts data warehouse.
●Experience with ODS (Operational Data Store), Data Mart Design, and Slowly Changing Dimensions including Data Warehousing development methodologies.
●Create, Support, Monitor, Troubleshoot, Recover and Tune Informatica Sessions with Informatica Repository Manager, Designer, Workflow Manager.
Softmaster Inc.
Contract Consultant, Feb 2002 to July 2002
Project – Union Bank of California, CA.
●ETL (Extraction-Transformation-Load) development with Informatica 5.1 and Oracle PL/SQL for Very Large CRM database
●Design and Develop Informatica Transformation Logics and Mappings
●Experience with ODS (Operational Data Store), Data Mart Design, and Slowly Changing Dimensions including Data Warehousing development methodologies.
●Create, Support, Monitor, Troubleshoot, Recover and Tune Informatica Sessions
Verizon Wireless, Irvine, CA.
Employee - Sr. Data Warehouse Administrator/ETL Developer, Oct 1999 to Feb 2002
●ETL (Extraction-Transformation-Load) development with Informatica 1.6.2 and Oracle PL/SQL for Very Large (Over One terabyte) CRM database.
●Design and Develop Informatica Transformation Logics and Mappings.
●Experience with ODS (Operational Data Store), Data Mart Design, and Slowly Changing Dimensions including Data Warehousing development methodologies.
●Support Monitor, Troubleshoot, Recover and Tune Informatica Sessions with Informatica Server Manager.
●Oracle 7 and 8 DBA for Large CRM database on Sun Solaris platform. Duties include database design, creation, administration, installation, upgrades, backup and recovery, migration, tuning, space allocation, object maintenance, support liaison.
●Support Migration of Oracle Householding DW to Teradata utilizing Informatica and BTEQ scripts.
●Assist in design of Householding DW Structure for Teradata using ER-Win
SBC Interactive - Smartpages.com, Pasadena, CA.
Employee - Aug 1999 to Oct 1999
Sr. Oracle DBA/Manager Business Systems Support,
●Managed a website production team consisting of Oracle DBAs and Oracle database developers.
●Supported on-sight development and staging database as well as production and standby Oracle instances at the website in San Jose, CA.
●Database design, creation, administration, installation, upgrades, backup and recovery, migration, tuning, space allocation, object maintenance, support liaison.
SBC Interactive - Smartpages.com, Pasadena, CA.
Contract Consultant, Jun 1999 to Aug 1999
Project - SBC Smartpages.com, Pasadena, CA.
●Oracle 7 and 8 DBA on various Sun Solaris platforms. Duties include database administration, installation, upgrades, backup and recovery, migration, tuning, space allocation, object maintenance, support liaison. Went perm.
The Wet Seal, Lake Forest, CA.
Contract Consultant, Mar 1999 to May 1999
Project - The Wet Seal, Lake Forest, CA.
●Retek (Retail Software) implementation. Converting Pick POS to Retek system on Oracle 8.
●Develop and execute QA Test plans for Oracle/Pick interfaces using Pro-C, PL/SQL, SQL-Plus, HP-UX.
iBASEt (Telecom Solutions Inc.), Lake Forest, CA.
Employee - Sr. Database Engineer, May 1998 to Feb 1999
●RDBMS design, administration and Oracle PL/SQL programming for Shop Floor 2000, a client/server application used by Boeing and other companies to replace costly paper trail when manufacturing jets or other products produced on the shop floor.
●Font-End programming using in-house development tools with Borland Delphi.
●Work closely with the customer on-site to configure and implement the product on their back-end. Professionalism and communication are vital.
ATT Wireless Services (formerly LA Cellular), Cerritos, CA.
Employee - Database Administrator/Cellular Network Analyst, May 1996 to May 1998
●Designed, built and administrate very large DSS database on Oracle 8.0.4.
●Duties include database installing, creating and maintaining database objects, database tuning including index creation, SQL tuning, backup and recovery, disk space maintenance and planning.
●Provide DSS support including data collection, parsing, storage, queries, reports & front end for various Network Elements (STP, HLR, SWITCH MPs, SWITCH config files, ICBH, SYSBH, Cluster, etc.).
●Data is used by every department within engineering and throughout the company including finance and customer service departments.
AVCO Financial Services, Irvine, CA.
Employee - Programmer/Analyst, July 1990 to May 1996
●Provide DSS support to IS management for trending analysis and presentations to upper finance management regarding performance of company products and services.
●Estimate, design, code, maintain and test subsystems and utilities for an OLTP Client/Server customer management system for over 800 branches nationwide using SQL embedded in Microfocus Cobol on IBM OS/2 platform.
●Coordinate and facilitate the electronic transfer of customer/account data between HQ and branch location and between branch openings, closings and relocations.
Provide Client/Server LAN system software support to branch users.
Contact this candidate