SUMMARY

• Architect / Senior Database Administrator (DBA) with hands - on experience in cost-effective, enterprise data warehouse applications across global companies.
• Proven successes in teh leadership, team player, as well as good listener.
• Skilled in all facets of data warehouse project development life-cycle from data management, architecture design, solution design and delivery, strategic planning, resource management, database adminstration, performance tuning, data integration and migration, process / method standardization and strong client relationships using interpersonal communication skills and professional knowledge.
• Data warehouse architecture design and data modeling
• Physical database design and implementation
• Logical and physical data model design and implementation
• Database / SQL / NoSQL performance tuning and trouble-shooting
• Data Integration and migration

TECHNICAL SKILLS

Platforms: Solaris, Linux, Windows Server 2003, Window Client 7 / XP / 2000 / NT

Languages: SQL / NoSQ, PL / SQL, JavaScript, C++ / C+, Perl, Shell Script, Java 5

RDBMS: Oracle 11g / 10g / 9 / 8, Teradata 12 / 13, MySQL and SQL Server 11

Technologies: Erwin model 8R, SAP 6.2, SAS 9.2, Informatica PowerCenter 9.5, Performance Analysis 6.0, Appfluent 5.0 and AppSQLXpert 4.0, Oracle OEM 10g, Teradata Viewpoint 12, Toad 9.6, CA AppLogic 3.5, Talend Enterprise Data Integration 5.2

PROFESSIONAL EXPERIENCE

Confidential, CA

Data Warehouse Architect Consultant

Responsibilities:

• Performance Comparison of Hadoop on different Clouds (Amazon Web Service, RackSpace, Microsoft Azure, Qubole using Intel-HiBench Hadoop benchmark suite
• Evaluate, design and implement data warehouse architecture
• Logical and physical data modeling and start schema / snowflake data modeling
• Data mining, OLAP, data analytics, crystal and SQl / NoSQL reporting design
• Oracle database design, development and performance tuning
• ETL development and implementation (informatica and talend)
• Best practice for data warehouse process

Confidential, La Jolla, CA

Architect / Senior DBA

Responsibilities:

• Exposed new data warehouse methodology and technology by testing POC projects to evaluate short or long term business values for teh organization. Defined a road map of servers, databases, Informatica and business object for data warehouse applications to estimate teh budget for future application upgrade or retirement.
• Guided and instructed teh conversion of logical model into physical model by specifying database platforms, partitioning strategy, indexing strategy with emphasis on data management, data presentation layers and row level security package. Worked with logical modelers and source systems; defined data transfer mechanisms from source systems to staging / warehouse environment as well as data migration from Oracle to Teradata. Resolved numerous technical issues including Oracle language character set, stats collection, index / table partitions, database link and semantic layer view to deliver high data quality and performance applications to teh medicine discovery.
• Provided solid expertise in designing, building and supporting various data warehouse / data mart such as U.S Global Finance, European Finance, Research Information, Human Resource and Legal Promotion Quality Assurance using Oracle database / PLSQL, Teradata, Erwin model, Business Object and Informatica suite. Delivered applications to meet teh business crunched deadline.
• Built and fostered trust relationship with clients through well-planned presentation and coordinating skills. Utilized excellent analytical, problem solving, communication and interpersonal skills with an ability to interact with individuals at all levels such as ETL / SQL developers, modelers, architect consultants and global Confidential IT and DBA teams.
• Delivered critical solutions in SQL performance tuning and optimization; design data availability and data loading strategies; implement Oracle / Teradata database new features for DW applications.
• Utilized extensive expertise in Oracle / Teradata database installation, configuration and space management, database monitoring, backup and recovery strategies to support production application with 24/7.
• Created automated shell scripts and store procedures to manage / audit teh database security, database monitoring, table import / export, data migration, stats collection to reduce manual works.
• Developed specific database design and development standards, policies, processes and best practices for physical modeling and performance optimization activities. Promoted best practices for data warehouse, Oracle / Teradata procedures from non-production to production environment. Identified any communication gaps between internal and external teams to improve work effectiveness and increase productivity.
• Participated in Database / Platform management governance board meeting to review teh project deployment to production databases.
• Estimated internal or external DBA support resource budget cost for data warehouse projects including MPP (Teradata) GIF / MIC / SAP / GERT. Analyzed project development support technical requirements and created cost saving business mode of combination of on-shore with off-shore team to reduce teh cost.

Confidential, San Diego, CA

Oracle DBA and Developer

Responsibilities:

• Installed, configured and monitored Oracle database to support R & D as well as managed Oracle upgrade, patch backup and recovery to maintain cooperation data assets.
• Support chemistry and biology software (ISIS, Base, ChemOffice and Affluent) to meet scientist’s needs. Worked closely with chemists and biologists for data design, process and problem solving.
• Developed application software to integrate biology and chemistry data for increasing data sharing capability. Designed and developed IntraWeb, Oracle form, PL/SQL and shell scripts for research application function, employee time track, and document sharing and company webpage.
• Facilitated IT members for system / database backup strategy, test plan and security.
• Managed one IT member and several internship students