We provide IT Staff Augmentation Services!

Sr. Data Warehouse Architect / Etl Developer Resume

2.00/5 (Submit Your Rating)

Huntington Beach, CA

PROFESSIONAL OBJECTIVE:

IT consulting with opportunities for advancement. Desire a clear chance of increasing responsibilities.

SUMMARY:

  • Over 24 years of IT experience
  • Managed multi - million $ budget; extensively involved in estimating, planning, and managing capital and expense expenditures
  • Offshore and domestic management experience
  • Demonstrated track record of successfully planning and managing muliple simultaneous enterprise initiatives
  • Demonstrated track record in managing teams and keeping teams focused on goals and deliverables
  • Proven knowledge and experience of enterprise architecture and effectively implementing business solutions in line with industry trends
  • Successfully managed and implemented multi terabyte data warehouses in Fortune-labeled companies
  • Effectively collaborates and corroborates with the business, IT, and Sr Management; Communicates status reports regularly and tracks expenditures per project
  • Ability to engineer and implement new processes and methodologies for the team for regulatory compliance such as SOX and HIPAA
  • Technically astute and mentors junior-level teammates to succeed
  • Consistently tapped for leadership role to have ongoing partnerships with various teams in IT and the business
  • Pre sales of Business Objects products - Data Integrator, WEBI, Xcelsius, and Crystal
  • Excellent people and communication skills

TECHNICAL SKILLS:

Dev Lang

Oracle 7.3, 8i, 9i, 10g

AIX

BO Data Integrator

MS Office - Word, Excel, PPT, Access

PL/SQL

SQL Server 7, 2000, 2005

Solaris

Informatica PC7

Visio

T-SQL

UDB/DB2

Linux - SUSE 9

Data Stage

Erwin

Visual Basic

MySQL

Windows

Oracle Warehouse Builder

MS Project

Delphi/Pascal

Business Objects XI r2, 6.5, Live Office

TOAD

Korn

Cognos

Oracle Designer

COBOL

Oracle Discoverer

C

Full SDLC

Change Management

SOX Compliance

HIPAA

Data modeling - 3NM, Star Schema

ETL, ELT, EAI, EII, MDM

Pre Sales

POC

EMPLOYMENT HISTORY:

Sr. Data Warehouse Architect / ETL Developer

Confidential, Huntington Beach, CA

Responsibilities:

  • My area of responsibilities include Data Warehouse Architecture, Systems/Infrastructure Architecture, ETL, Project Management, Data Modeling - ODS 3NM and Star schema, Universe design and development, WEBI development, Pre-Sales, Business Development, Account Management - RFI/RFP/SOW, Technical Consulting, DBA (Oracle and SQL Server), Training, and Support.
  • Designed and developed real-time global data warehouse in Oracle/UNIX for Motion Pictures reporting used by 30 territories/countries.
  • Developed star schema data model for billing, bookings, and AR.
  • Coded ETL in korn and PL/SQL sripts to load data from 30 global territories. Tune and monitor Oracle 5TB database and work with SAN engineers to carve SAN and RAID configuration.
  • Designed and developed Business Objects Universe and WEBI (6.5 and XI) and supported over 500 users globally using Oracle and Teradata.
  • Designed and developed security models that comply with SOX. Developed views and stored procedures for ODS reporting written in Java.
  • Migrated objects from Dev to QA and to Prod using Import Wizard. Setup users and assigned roles and privileges within CMC.
  • Worked with Java and database developers to tune queries and monitor performance of servers and databases.
  • Managed projects for Data Warehouse and Business Objects reporting and provided status reports to users, development team, and management.
  • Continually tapped by management to be involved in overall enterprise projects for Sony Pictures and to be involved in managing reporting team.
  • Also responsible for managing domestic and offshore developers.

Confidential, Riverside, CA

Sr. Data Warehouse Architect / ETL Developer

Responsibilities:

  • Designed, developed, and deployed WEBI, DESKI, and Xcelsius reports for Housing and RV groups.
  • Converted over 100 reports and 20 Universes from 6.x to XI R2.
  • Designed and developed ODS data for operational reporting and designed and developed Data Warehouse utilizing star schema (Kimbal methodology) for BI analytics and reporting.
  • Designed and developed data models (ODS and DW) in Visio.
  • Gathered user requirements and documented functional specs and technical specs.
  • Administered BO 6.x and XI in the areas of security for reports access, folders and objects, Universes, and SSO.
  • Tuned and configured Oracle 9i instances on HP/UX and Windows 03.
  • Installed and configured Business Objects Enterprise on Windows 2003.

Confidential, Costa Mesa, CA

Sr. Data Warehouse Architect / ETL Developer

Responsibilities:

  • Developed, designed and implemented GL and Payroll Data Mart in SQL Server. Designed Data Mart in Star Schema and developed ETL routines in Data Integrator to pull data from GL and Payroll sources to the Data Mart.
  • Designed and developed Business Objects Universe to support Dashboards and Performance Metrics.
  • Developed Dashboards in WEBI and Charts in Xcelsius.
  • Developed Data Flow diagrams, E-R models (source and target systems), and mapping documentation for ETL.
  • Provided consulting expertise in deployment process for development, test and production.
  • Recommended architecture planning for AIX and Oracle migration, SAN configuration, and data files configuration.
  • Configured and tuned SQL Server on production and developed alerts for process failures.
  • Configured and tuned job servers for Data Integrator and developed schedules for loading and transforming data.
  • Monitored Windows and SQL Server to have optimal performance on data loads and query performance for Business Objects WEBI.
  • Developed system reports to automate data discrepancies between source and targets.

Confidential, San Diego, CA

Sr. Data Warehouse Architect / ETL Developer

Responsibilities:

  • Gathered business requirements from business users and analyzed source system data model.
  • Designed and developed data warehouse schema in Visio.
  • Documented data flow and mapping of source data to data warehouse.
  • Developed ETL routines in Data Integrator. Also designed and developed Business Objects Universe for Dashboards, Scorecards, and ad hoc reporting.

Confidential, Los Angeles, CA

Sr. Data Warehouse Architect / ETL Developer

Responsibilities:

  • Pre sales presentation and POC.
  • Gathered business requirements and analyzed data warehouse project including source data staging, ETL routines in Data Integrator, Business Objects Universe design, and reports.
  • Modeled and recommended data warehouse structures, processes, tuning options and mapping documentation of source to data warehouse schema.
  • Also recommended Universe design changes to support enterprise analytics and reporting.

Confidential, Los Angeles, CA

Sr. Data Warehouse Architect / ETL Developer

Responsibilities:

  • Installed Oracle 10g on SUSE Linux.
  • Configured and tuned oracle database and worked with system engineers to create filesystems on SAN to support high performance I/O.
  • Designed and developed schema for Electronic Passenger Information Service. Wrote stored procedures, triggers, materialized views and other Oracle objects to support C++ applications to store and retrieve data in Oracle.
  • Provided support for entire development team on the project and participated in application design and development. Wrote PL/SQL code, control files, and korn scripts to load data.

Confidential, Long Beach, CA

Sr. Data Warehouse Architect / ETL Developer

Responsibilities:

  • Managed a data warehouse team to successfully implement an enterprise data warehouse.
  • Created project plans and estimates for deliverables to provide a roadmap and strategy for upper management and various teams involved in the project.
  • Consistently set up meetings with data owners and end users to get assessment of data requirements.
  • Designed architecture of the enterprise and worked with developers to move and consolidate data per business requirements.
  • Tasked each team member and kept track of progress for status reporting to Executive Committee.
  • Collaborated and corroborated with business reports developers to successfully deliver a total solutions package for the enterprise - from source data to publication.
  • Extensively involved in data quality issues and engineered processes in ETL to trap erroneous data and provide audit reports to data owners.
  • Continuously kept team motivated and focused by checking individual statuses and team meetings to assess overall progress of projects.
  • Worked with IT management in the areas of budgeting, planning, resource allocation, and risk management to minimize setbacks in the project plan.
  • Designed data warehouse schemas and developed ETL routines in Data Stage to move data from DB2/UDB source to target SQL Server database.
  • Developed Framework on Cognos 7 and developed ad hoc reports in Reportnet.
  • Documented mapping, data flows, process flows, E-R of ODS and Star Schema using CA Erwin r7, and data dictionary.

Sr Manager, Data Warehouse

Confidential, Huntington Beach, CA

Responsibilities:

  • Managed a data warehouse team (ETL and Business Intelligence). Working with the business community to leverage data warehouse and to develop new phases of data delivery - portal, dashboards, and data mining.
  • Ability to manage multiple projects to support the operations of the business including but not limited to Finance, Portfolio/Collections, Loss Recovery, Sales/Product Management, Customer Care, and Operations.
  • Actively participated in IT management to do budgets, strategy, and developed policies and procedures for SOX compliance and change management.
  • Member of the IT Executive Steering Committee to present data warehouse opportunities and to plan for capital expenditure.
  • Also involved in the data architecture and technical design of the data warehouse.
  • Developed complex transformations using Informatica Power Center 7 and designed/developed Universe in BO 6.5 and XI r2.
  • Collaborated with the business, IT, and Sr Management to align business processes with the Technical Enterprise Architecture of the corporation. Partnered with the business to create an understanding and appreciation of application portfolios, technical infrastructure, business operating models, and developed processes and methodologies to deliver data across the enterprise. In addition, leveraged leadership role to have ongoing partnership with multi departments and maintaned knowledge of business operations, strategies and information requirements to develop solutions and provided consulting expertise to influence and drive solutions in line with strategic and tactical initiatives.

We'd love your feedback!