We provide IT Staff Augmentation Services!

Data Architect / Etl Architect Resume

2.00/5 (Submit Your Rating)

San Jose, CA

SUMMARY:

  • A senior Information Technology engineer with more than 20 years of experience in contributing to a variety of diverse and successful businesses
  • Expert in designing ETL processes using Informatica PowerCenter and Oracle
  • Technical excellence in architecture, development, implementation, and support of business intelligence (BI), enterprise data integration, data warehousing, and business applications
  • Strong team player and leader with creative thinking, passion for quality, and customer focus
  • Strong desire to learn new technology

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, C, Java, HTML, Shell Scripting

Software: Informatica PowerCenter, Talend, PowerBuilder, Oracle Designer, Joomla, Tableau, Tidal SysAdmiral

Operating Systems: Windows, Linux, UNIX

Database: Oracle, MS SQL, MySQL, IBM DB2, Big Data Hadoop, Hive, Pig, Sqoop

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Data Architect / ETL Architect

Responsibilities:

  • Architect and design databases (Oracle, SQL Server, dimensional Data Warehouse) that support complex DataWarehouse and business intelligence initiatives
  • Design and document conceptual, logical, and physical models and provide support to in - house applications such as Product Catalog Manager
  • Perform development DBA work such as managing and granting database access to users, setting up databases and database objects for applications
  • Serve as a data specialist for large migration projects due to mergers and acquisitions
  • Work with business analysts and report users to understand and analyze new application and reporting requirements
  • Define, document business rules and communicate requirements to ETL developers
  • Develop ETL programs using Informatica PowerCenter, Oracle, SQL Server, shell scripts, and SysAdmiral Scheduler
  • Assist and provide mentoring in ETL development and Informatica PowerCenter to off-shore developers
  • Assist in SQL tuning to improve application performance

Confidential, San Francisco, CA

Data Architect / ETL Architect

Responsibilities:

  • Designed, developed, tested, and deployed ETL programs (Informatica Powermart/PowerCenter, Oracle PL/SQL) that load customer data for SignalDemand's SaaS application
  • Worked closely with product managers and scientists to define ETL and reporting requirements
  • Collaborated with database administrators to tune ETL processes
  • Acted as a key technical support person for all data and ETL issues
  • Participated in the design of database objects (schemas, tables....) for SignalDemand's application
  • Performed administration work for Informatica PowerCenter. Responsibilities include managing user privileges, tuning mappings and sessions, and upgrading to new software versions
  • Provided leadership, training, and guidance to other developers, support personnel, and off-shore resources
  • Worked well under tight deadlines and high pressure of a growing start-up
  • SignalDemand Core Value Award winner

Confidential, San Jose, CA

Lead Data Warehouse Engineer

Responsibilities:

  • Worked closely with business users, business analysts, and reporting developers to define data and reporting requirements
  • Analyzed, designed, developed, tested, and deployed ETL programs (Informatica Powermart/PowerCenter, Oracle PL/SQL) that get data from various sources, including in-house OLTP systems and COTS systems (Oracle Financial, Portal Infranet Billing, Siebel, NetCracker, Microsoft Active Directory, Sun LDAP, Chordiant CRM)
  • Acted as a key developer / technical support person for various data marts at Covad, most notably the Marketing Database, an engine that provides Covad’s important leads to telesales agencies
  • Performed data migration analysis, design, and development to integrate numerous systems from acquired companies into Covad’s systems
  • Worked as a junior development DBA for various applications. Tasks included installing Oracle software, designing database tables needed to capture data, and providing necessary database administration functions
  • Performed administration work for Informatica Powermart. Responsibilities include managing user privileges, tuning mappings and sessions, and upgrading to new software versions
  • Provided support for hourly and nightly ETL loads and processes
  • Covad Living The Brand Winner

Confidential, San Francisco, CA

Software Engineer / System Analyst

Responsibilities:

  • Participated in the analysis and development of Wells Electronic Banker (E-Banker), a complex Powerbuilder-based software that allows customers to transfer/withdraw money electronically
  • Fixed and performed unit test of defects
  • Provided production support to E-Banker customers and helped troubleshooting issues during customers’ installation processes
  • Programmed and used advanced features of Powerbuilder and the object library Powersoft Foundation Library (PFC)
  • Developed SQL scripts for the software using Sybase SQL Anywhere
  • Built installation diskettes using InstallShield
  • Prepared program and system documentation
  • Worked on a big budget project with tight deadlines

Confidential

Senior Business Systems Programmer

Responsibilities:

  • Prototyped, developed, performed unit/system/acceptance tests, and implemented PowerBuilder applications for the Corporate Data team
  • Assisted analysts with GUI design as well as technical design of PowerBuilder applications using the object library Super Class
  • Developed and promoted the use of reusable objects (stored procedures, functions, views, triggers) in Oracle PL/SQL
  • Provided on-call support for live production applications
  • Trained, coached, mentored other staff members in the Information Technology Center department

Confidential

Programmer Analyst

Responsibilities:

  • Provided support to the legacy systems (PACE, SPA, PPS, CUFS, SENTRY) in the Pension and Investment Management department
  • Created/modified programs based on detailed supplied specifications
  • Prepared program and system documentation
  • Provided on-call support for nightly batch loads
  • Programmed in COBOL, PL/I, JCL, RAMIS
  • Used IBM utilities for the Mainframe (IEBGENER, DCLCOPY, SORT, DCDSUT, File-Aid)

We'd love your feedback!