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.