Data Architect / Etl Architect Resume
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)