We provide IT Staff Augmentation Services!

Senior Technical Advisor, Edw Architect Resume

Richardson, TX

OBJECTIVE:

Seeking challenging Data Warehouse & Business Intelligence Architect position that can best utilize my technical skills and experience.

SUMMARY:

  • 15+ years of extensive experience with enterprise software applications. 9+ years with Data Warehouse and Business Intelligence applications. Expertise in Data Modeling, Data integration,MDM,ODS, Dimensional Modeling & Star - Schemas(Kimball), ETL process and frameworks. Deep understanding of Big Data analytic theory & practices.
  • Expertise’s with programming languages: SQL, Oracle 10g, PL/SQL, Teradata 13.10, Teradata 14.10, C/C++, Java, UNIX Shell Scripts, Perl, .NET,ASP, PHP.
  • Experts of Unix system architecture (Solaris 10, AIX 6.x, RedHat Enterprise Linux, Oracle Enterprise Linux) and Win 2003/2008 R2 servers
  • Extensive Experiences with business intelligence tools, including Siebel Analytics 7, OBIEE 10g/11g, SAP BusinessObject, IBM Infosphere 8.5, DataStage/QualityStage and BEA WebLogic server 9.x. ERWin, Toad, Teradata SQL Assistant. Informatica 8.6 & 9.1 PowerCenter, DataTransformation. Confidential .

WORKING EXPERIENCE:

Confidential, Richardson, TX

Senior Technical Advisor, EDW Architect

Responsibilities:

  • Work as a senior technical advisory source for all EDW projects.
  • Provide technical advices in Teradata physical data model design and implementations.
  • Attend multiple EDW project design reviews per week.
  • Performance tuning for current production jobs (ETL & Microstrategy reports) in Confidential 's Teradata Enterprise EDW environment.
  • ETL code review and provide performance enhancements solutions.
  • Review RxClaim,Med D new data mart projects’ physical model design & ETL code review for all new PBM EDW projects.
  • Worked as senior architect for Aster/Hadoop Big Data solution initiatives for data archiving solution.
  • Review Code push from QA to prod. PROD Data backup,archive and refresh to QA/DEV using Teradata BAR & Tivoli.
  • Help production support team debug production job failures and provide technical solutions.
  • Create database monitoring alerts(on top of Viewpoint existing alerts.).
  • Create production SQL profiling tools to find out usage patterns.
  • Worked on setting up TASM workloads.
  • Assist in database planning for new business initiatives.
  • User Profiling & manage various roles.

Confidential, Plano, TX

Data Warehouse Architect (Teradata DBA & ETL Lead)

Responsibilities:

  • BI Architect: Review current DW ETL process and provide assistance for improving current SPEND/MAP/SLA ETL processes implemented using Wherescape RED. Debug MicroStrategy Reports that having performance issues due to physical model design issues.
  • Rebuilt physical models to achieve 20x fold report performance gains.
  • Created ETL frame work to extract data from corporate EDW SDI data-mart to provide updated info to external corporate customers.
  • Automated the whole process which was not possible before by building PERL script frameworks.
  • Worked with GHX7 team to re-invent the corporate GHX7 extract ETL process.
  • Rebuilt existing SQL Stored procedures to make the SPs worked fast on Teradata system.
  • Teradata Production DBA:Worked as Data architect to convert logical models into Teradata physical implementation.
  • Created database artifacts(database,tables and views,SP,FUNCTIONs) needed for business analyst group users.
  • Backup of production databases, tables and data dictionary. Worked with Teradata GSC to patch & upgrade production systems.
  • Worked closely with ETL team to migrate corporate SQL Server data(5T) into Teradata. Admin for all dev/qa/uat Teradata systems.

Confidential, Irving, TX

Data Warehouse Architect (Teradata DBA & ETL Lead)

Responsibilities:

  • Design and develop corporate ETL framework for Enterprise Claim data warehouse.
  • Built ETL process scripts from scratch.
  • Lead in inventing proprietary ETL solutions to integrate terabytes of data from corporate Mainframe source systems.
  • Lead in forklift project to make sure it’s delivered on time.
  • Design and develop Informatica mappings for the data integration of EDW. Lead a team of 4 ETL designers.
  • Worked closely with team members on triage of data quality issues.
  • Designed architecture and made project planning for Confidential solution.
  • Installed Confidential ’s Confidential 6.2 agents on RedHat 5.7 linux production servers.
  • Configured Access server and admin console to capture Confidential ’s PCF & EC DB2 data store’s daily updated data.
  • Brought Confidential solution to production from initial conceptual design.
  • Worked with Data architect to convert logical models into Teradata physical implementation.
  • Created database objects(tables and views) needed for business analyst group users. Daily/weekly backup of production databases, tables and data dictionary.
  • Created store procedures to manage user access & user rights and database space usage.
  • Worked with Teradata GSC to patch & upgrade production systems.
  • Worked closely with ETL team to migrate corporate MF DB2 data(15T) into Teradata.
  • Used ARC to do daily and weekly backup to NFS drive.
  • Worked with BA to create views for front-end reporting. Worked on data analysis/profiling for revenue projection.

Confidential, Richardson, TX

Data Warehouse Solution Architect

Responsibilities:

  • Teradata Application DBA. Lead project of converting wireline/wireless Oracle 10g data marts to Teradata V2R6.
  • Created physical model(db,tables,views,Store Procedures) based on previous Oracle schemas. Created ETL scripts for ELT process, using BTEQ, MLOAD, TPT scripts.
  • Created all needed UNIX shell/PERL scripts for ETL process. Debugged ETL issues with business analyst team.
  • Provide BI/DW application architecture design and roadmap for Confidential Data Warehouse projects. Design & implement clustering for high-availability and high performance.
  • Design & implement system outage/performance degradation alert tools/scripts. Provide detailed infrastructure solution (hardware platform, selection of software packages, etc) for such data warehouse projects/environments. Lead in Data Warehouse application upgrade ( design & implementation. )
  • Production/QA/ST administrator for OBIEE 10g, BusinessObject, IBM Infosphere 8.x. and Informatica 8.6.Support on-call and outage emergencies.
  • Debug performance issues with DBA.
  • Lead a team of offshore engineers for 24/7 coverage of all environments.
  • Upgrade of afore mentioned BI/DW tools. Work with vendors to resolve upgrade issues. Work with PM closely to guarantee project success.
  • OBIEE business repots development for Siebel marketing and Sales cubes.
  • Worked on developing production ETL workflows/mappings, OBIEE repository development. Lead code migrations and code deployments.

Confidential, Emeryville, CA

Senior Data Warehouse Consultant

Responsibilities:

  • Develop new ETL processes to support design, UAT and production environments of the data marts in Siebel Marketing cubes.
  • Develop logical and physical data models for Client s new Siebel Marketing Segment cubes.
  • Complete POC architecture design of Siebel CRM / OBIEE (OBI 7) systems
  • Lead and administer systems performance including on - going optimization and tuning of Informatica/DAC environment.
  • Analyze and evaluate data sources and bug fix for ETL tasks/Informatica mappings.
  • Customization Siebel Analytics / Oracle Bi and DAC integration Oracle eBusiness Suite.
  • Deliver new ETL mappings, new RPD design and Web Catalog design job scheduling, dependencies, monitoring, security, and administration.
  • Responsible for the delivery of production ready systems of Informatica/DAC/OBIEE environment including automation,

Confidential, Santa Clara, CA

Senior System Engineer

Responsibilities:

  • Senior member in corporate Siebel CRM & Siebel Analytics data warehouse solution team.
  • Responsible for production administration of Siebel CRM & Analytic applications.
  • Worked as iPlanet Web server administrator.
  • Data warehouse application integration with iPlanet server.
  • Production fallback/clustering architect design.
  • Production code deployment.
  • Debug and triage ETL failures, data abnormality and other data integration issues.

Confidential, San Jose, CA

Senior System Engineer

Responsibilities:

  • Deploy new Siebel Analytics system to client’s linux servers.
  • POC project lead for Siebel marketing campaign implementation.

Hire Now