Sign in

Data Sql Server

Plano, TX
March 29, 2018

Contact this candidate


Sam Guo

Richardson, TX ***** E-Mail:

Objective: Seeking senior Teradata Architect & Lead DBA position in the Data Warehouse & Business Intelligence area that can best utilize my technical skills and experience.

Technical Skills and Capabilities:

15+ years of extensive experience with enterprise software applications. 10+ years with Data Warehouse and Business Intelligence applications. Expertise in Data Modeling, Data integration, 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, 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 Business Object, IBM Infosphere 8.5, DataStage/QualityStage and ERWin, Toad, Teradata SQL Assistant. Informatica 8.6 & 9.1 PowerCenter. DataMirror CDC. IBM Optim data archiving. Vertica DBMS. MS SQL Server 2008 & 2012. SSIS & SSRS development. WebSphere, WebLogic, GoldenGate.

Over 9 years of experiences in Teradata/MS SQL Server Database administration & Physical data modeling & application DBA. Versed in all Teradata/SQL Server utilities & tools. Expert in Teradata/SQL Server DB performance tuning.

Working Experience:

Ace Data Services LLC @Lightbeam Irving, TX

Enterprise EDW Solution Architect 2014/05 ~ Present

Lead Data Architect consultant for data integration from SQL Server to Teradata for a large regional hospital. Create Patient Encounter and Pharmacy Data models based on Teradata Healthcare data model. Modified and revised the data model to accommodate the business requirements.

Lead solution architect in implementation of HL7 data streaming solution for data coming from Cerna/Athena/MediTech HL7 Websphere MQ. Created architecture design using Apache Kafka, Hadoop(CDH 5.0) to ingest 400K HL7 messages from ESB. Created ETL logic/code to digest/extract the HL7 messages/segments data and load it into Hive/Teradata for near real-time EDW analytic solutions for Patient Encounter Subject Area.

Created ETL process (using Bteq/TPT/PERL scripts/T-SQL Stored procedures/SSIS package) to load flat files into Teradata & SQL Server 2012 EDW systems. Rewrite all SQL server Stored Procedures into Teradata Stored Procedures.

Convert existing SSIS packages to Informatica Workflows / Teradata Stored Procedures to reduce network/DB to meet business critical SLAs.

Created multi-tenancy design (logical & Physical Data model) for EDW on Physical & Logical Data Modeling in Erwin. Developed EDW data model LDM/PDM and ETL code for processing claim data(Professional/Institutional/RxClaim). Created data model for Pharmacy and Patient Encounter EDW subject areas based on Teradata Healthcare Model.

Created new Patient MDM dedupe process to fix historical EDW Patient load process issues. Resolved critical PHM patient health management issues company had for a long time. Got CEO recognition for the new ETL process that turned unsatisfied clients into trusted partners.

Developed ETL code for calculation HEDIS measures based on BCBS claim data & cross-checking with client’s hospital EMR clinical data. Identify non-compliant targets for validating provider’s performance.

Calculate patient population care-gaps and create daily alert to ACO clients. Calculate patient’s risk scores using John Hopkins’s risk score engine/model.

Ace Data Services LLC @Pepsico Plano, TX

Sr. Data Architect 2014/6 ~ 2015/09

Provided system/code review for client’s existing ETL/BI applications architecture, process,SLA requirements & performance issues. Review EDW architecture for Client’s various business Data Marts and corresponding EDW applications.

Technical lead for migrating client’s MS SQL Server 2012 EDW data warehouse into Teradata. Review Logical Data Model and Physical Data Model. Identified various modeling issues and provided fix on both LDM and PDM layer during UAT testing phase.

Created ETL design doc, Test Plan, Regression test suites (captured from legacy systems) and executed UAT/QA testing with rest of team. Identified code defects and provided code fix in production.

Provided code fix for other business divisions’ ETL code in Teradata. Improved ETL performance (execution time in DB, spool usage,ImpactCPU reduction,etc).

Create LDM(Logical Data Model) for Sales Data Mart using ErWin. Deploy PDM based on LDM and create DB semantic layer for the data mart reporting using Business Objects.

CVS Caremark, a Fortune 50 Company (PBM division) Richardson, TX

Senior Technical Advisor, EDW Architect 10/2013 ~ 10/2014

My role as a senior Data architect includes :

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 CVS'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.

Lead migration of SQL Sever 2012 legacy RxClaim code into Teradata. Lead data fork-lift efforts. Lead development in converting SQL Server 2012 Stored Procedures into Teradata SPs.

MedAssets Plano, TX

Data Warehouse Architect (Teradata DBA & ETL Lead) 1/2013 – 10/2013


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.

Lead in POC project of using Hadoop as active data archiving for a major Finance client. Migrated about 10T of data into Hive from TD.

Teradata architect in Data migration for a Fortune 50 Financial company’s project of migrating from EDW on DB2 to Teradata. Migrated 500T of consumer banking and card services data from DB2 to Teradata.

Healthcare Management Systems(HMS) Irving, TX

Title : Data Warehouse Architect (Teradata DBA & ETL Lead) 5/2012 – 1/2013


EDW ETL Architect: 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 (3 onshore and 1 offshore). Worked closely with team members on triage of data quality issues.

** Got CEO recognition for my innovation on the new PCF ETL massive data load from MF to TD process. Got CIO reward of the year for employee technology innovation.

Changed Data Capture Solution Lead

Designed architecture and made project planning for DataMirror CDC solution. Installed IBM’s CDC 6.2 agents on RedHat 5.7 linux production servers. Configured Access server and admin console to capture HMS’s PCF & EC DB2 data store’s daily updated data. Brought CDC solution to production from initial conceptual design.

IBM Optim POC project Lead

Worked with DB2 DBA team to offload 3 years of Claim data into IBM Optim for Federal compliance project. Did initial POC project planning on capacity & setup & installation on RedHat servers. Created PERL script to automate the loading of Flat files into Optim.

Teradata Production DBA

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.

AT&T Richardson, TX

Title : Data Warehouse Solution Architect 6/2010 – 05/2012


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 AT&T’s corporate 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.

Vertica POC project for offloading call-detail-tables from Teradata EDW into Vertica DB system.

Worked on developing production ETL workflows/mappings, OBIEE repository development. Lead code migrations and code deployments.

Perficient,Inc Emeryville, CA

Title : Senior Data Warehouse Consultant 3/2010 – 5/2010

Onsite senior consultant for LeapFrog Corporation’s Oracle Business Intelligence solution system:

* 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.

* Responsible for the delivery of production ready systems of Informatica/DAC/OBIEE environment including automation, job scheduling, dependencies, monitoring, security, and administration.

Sun Microsystems Santa Clara, CA

Title : MTS4, Senior System Engineer 7/2002 – 1/2010

Database Performance benchmarking on Sun Micro’s mid-range/hpc systems. Measured Teradata database performance on various server lines. Generated test patterns using PERL scripts to measure Teradata system performance (CPU Usage, I/O wait, high volume data loading with extreme read/write conditions, concurrent session testing with automated process(bteq scripts generated by PERL). Generate Teradata system performance metrics using various tools on key metrics(ImpactCPU, PJI, UII, AWT Heatmap, Query Response times).

Production fallback/clustering architect design. Production code deployment using Informatica PowerCenter ETL tool with Teradata.

Debug and triage ETL load failures and resolved data integration issues with ETL team.

Afara Websystems San Jose, CA

Senior System Engineer 7/2001 – 7/2002

Deploy new Siebel Analytics system to client’s linux servers.

POC project lead for Siebel marketing campaign implementation.

C-Cube Microsystems Milpitas, CA

Title : Staff Software Engineer 1/1999 – 1/2001

Microcode developments of video decoder chip. Maintain and write new features for the video processing microcode of DVD4 decoder project. Worked on bringup. Verified the CPU, HOST controller, VLD, Audio and Video Output units.


Master, Computer Science International Technology Univ, Santa Clara, 1997

Bachelor of Science Tsinghua University, Beijing, China, 1996

Contact this candidate