Sam Guo Email & Phone Number

Irving, Tx, Us

Ace Data Services LLC is a company that provides top notch DBA and data engineering solutions in EDW(Enterprise Data Warehouse) arena. We have helped our clients migrating billions of records from Mainframe, Oracle, DB2 into Snowflake, Teradata and Databricks.We also provide core DBA services for Teradata, MS SQL Server, Databricks and Snowflake. We helped various size clients on their Big Data development needs. We have experiences managing large size (>1 Petabytes, >1000+ nodes) Teradata EDW systems. Our clients include (not full list) : Pepsico , CVS Caremark, AT&T , UHG and other Fortune 100 Companies. We always provide the ACE quality services, period. We are confident that we can beat other vendors with AAA quality of services and more reasonable budget.Contact us : wguo888@gmail.com

Richardson, Texas

Sr. Teradata 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. Assist in physical model design & review existing physical model for various Data Mart.POC project : Teradata Aster/Hadoop Appliance. Worked with TD Aster team to access the Aster/Hadoop Appliance performance for CVS's active data archiving project. Evaluate TD's solution's join query performance and assessment of TOC.Teradata DBA (Production support) : Assist in code push from QA to prod. PROD Data backup and archive using Teradata BAR. 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.

ETL Architect: Design and develop corporate ETL framework for Enterprise Claim data warehouse. Built ETL process scripts from scratch. Project Lead in inventing & implementing proprietary ETL solutions to migrate 20 terabytes of data monthly from corporate Mainframe source systems to Teradata EDW. 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. ** This innovation got CEO recognition. It proved proprietory ETL process can out-win Informatica Data Integrator tool 1000:1 in terms of performance. ( I put 1000 here , but the real speed my ETL process can load Mainframe data can be much much higher than Informatica's Data Integrator tool. The hardware is the only limit ! ). CIO awards for this ETL framework innovation.Sr. Production DBAWorked with Data architect to convert logical models into SQL Server & 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 DB2 & SQL Server DB data(15T) into Teradata. Used ABU 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.

Richardson, Texas

Senior Teradata EDW Consultant. Lead project of converting wireline/wireless Oracle 10g data marts to Teradata V2R6. Create 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.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. )Worked on developing production ETL workflows/mappings in Teradata, OBIEE repository development. Lead code migrations and code deployments.Lead for admins of Production/QA/ST administrators team(onshore/offshore) 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.

Senior System Engineer. Key contributor for the multi-thread multi-core Niagara (T1,T2) systems.

Bachelor Of Science (B.S.), Thermal Engineering

Ms, Computer Science