SUMMARY:

• Superior Technical Marketing skills.
• Successful leadership experiences in multiple IT solutions and projects.
• Providing a well - balanced understanding of business relationships.
• Lifelong learner and self-starter with ability to communication with all levels of stakeholders.

TECHNICAL SKILLS:

Data Architecture Design: ER/Win, Sybase Power Designer.

Business Intelligence: Informatica, DataStage, SSIS, SSAS, Cube, SAS.

Big Data Ecosystem: Hadoop, Hive, HBase, R.

D atabases: Vertica, Teradata, Greenplum, Oracle, SQL Server, DB2, Sybase, Informix.

ERP & CRM: SalesForce, PeopleSoft, Yantra Order Management system, Siebel CRM, Clarify, Remedy, Vignette StoryServer, ClairfyCRM, Oracle Application server.

Languages: Python, VSQL, BTEQ, PL/SQL, HiveQL, UNIX Shell, Java, Perl, Postage, T-SQL, Bteq, ESQL, Pro*C, C/C++,HTML, XML, Power Builder Scripts, PICK Basic.

Platforms: Linux, MS Server, Sun Solaris, IBM AIX, HP UX, Advanced PICK.

AD management: Agile Software Development Methodology.

Job scheduling: Autosys, Approwx, Espresso.

Packaged tools: Visual Studio, TOAD, Enterprise Manager, Oracle SQL Loader, Import, Export, Trace, TKPROF, Statspack, Visio, LoadRunner, Oracle Forms, Oracle Reports, Power Builder, Dynasty, Crystal.

Project management: Agile style projects management and tools.

PROFESSIONAL EXPERIENCE:

Lead Enterprise Data Architect

Confidential, Newark, CA

Responsibilities:

• Data Warehouse Data Architect and Modeling designs for both the ERP and CRM systems. Experienced in the following subject areas: Health Care, Financial, Marketing, Sales, HR, Shipping, Payment, Product planning, and Inventory management.
• Advanced Business Intelligence Data Architecture design for massively parallel (MPP) enabled database systems such as Vertica, Teradata and GreenPlum.
• NoSQL database schema porting. Ensure baseline schemas are portable between many NoSQL databases, such as Vertica, Cassandra, Mongo DB and Oracle.
• Supported applications in the Big Data ecosystems with scalable solutions such as Spark and Kafka.
• Dimensional modeling. Star or Snowflake schema design, fact and dimension table modeling.
• Data Staging schema design. Staging data acquisition, dimension management, transformation and aggregation architecture.
• Master Data Management (MDM) and Operation Data Store (ODS) solutions required for large scale enterprise data warehouses.
• Confidential and development for large scale Data Warehouse System.
• Agile business cloud infrastructure evaluation, such as AWS.
• Enterprise Data Warehouse Data Governance. Source and target data management for the high availability, scalability, usability, integrity, and security considerations.
• Contextual inquiry. Internal or external customer business requirement collection.
• Workflow modeling. Work tasks and environment analysis and design.
• Conceptual level modeling. Identify conceptual views required for corporate ERP centers.
• Logical level modeling. Dimensions tables and Fact tables design for data marts under dimensional modeling concept. Identify attributes domain and business rules.
• Physical level modeling. Tables, columns, views and indexes implementation focus on fault tolerance, performance, scalability and security. Partitioned table and materialized view design.
• FRB CCAR and FRB CapPR project Data Warehouse Architect. Which includes implementing Data Modeling, Data Mapping, Transformation and Stress test under the scope of FRB FR Y-14A, FR Y-14Q, and FR Y-14M schedules, Basel I, II, III frameworks. (with projects 2013-2014 Bank of the West, 2010-2012 Bank of America).

Lead Data Warehouse ETL/ELT Architect and developer

Confidential

Responsibilities:

• Data Warehouse ETL/ELT Architect and development for both the ERP and CRM systems. Experienced in the following subject areas: Health Care, Financial, Marketing, Sales, HR, Shipping, Payment, Product planning, and Inventory management.
• OLAP ETL/ELT architect design with high Performance considerations. Design or improve ETL/ELT architectures to meet performance requirement by using parallel processing, table partitions, index strategies, projections, materialized view, data hashing, and data clustering technologies for MPP based database such as Verti ca, Teradata, and Greenplum .
• Structured ERP and CRM dataset Extracting, Transformation and Loading by using packaged tools such as Informatica, SSIS, SSAS, DataStage, and non-packaged tools such as VSQL, BTEQ, PL/SQL and SQL, Perl, Python and Unix Shell.
• Business Intelligent dataset transformation. Which includes Data Cleansing, Mapping, Conversion, simulation, enrichment, and projection.
• Applications performance tuning and query optimization by using Execution Plan, Trace, statistics analysis and Statspack.
• Virtual Data Federation for International Product Provisioning system.
• Vertica Table Partition, partition swapping, coding, compression and Segmentation.
• Vertica Projection design, K-Save consideration, refreshing and monitoring.
• Data Statistics or histogram analyzing.
• Hodoop Streaming development by using Python Mapper and Reduce scripts.
• Hadoop distribute file system to MPP based relational database, such as Vertica and Teradata data import and export.
• HiveQL programming. Distributed process through querying and mapping large upstream datasets resided in either the Hodoop File Systems or the Local File Systems.

Confidential

Responsibilities:

• Business Intelligent analytical query, modeling, simulation, projection, optimization, virtualization and data mining. Create and use of Cube by using SQL Server Analysis Services.
• Global Marketing reports development which contains Key Performance Indicators. Market size and market share performances reporting with sales amount and sales units metrics.
• Comprehensive Capital Analysis and Review(CCAR), Corporate Business Management and Risk Analysis data architecture design for Business Analytics and Intelligence backend process such as SAS and R.
• Market Size and Market Share data analysis, which includes facts and projections.
• Total Addressable Market growth projection by product category, region, and segment.
• Market shifts identification and forward-looking sizing.
• Market assumptions and sizing iteration and alignment.
• Structured and non-structured data architect and modeling.
• R, SAS and Python code porting and Qlikview support.

Sr. Data Warehouse Data Architect

Confidential

Responsibilities:

• Data Warehouse and Data Mart business requirements collecting and auditing. Interview with internal users and document business requirements.
• Conceptual level Data Architecture and modeling. Identify conceptual views required for Health care organization centers.
• Logical level modeling. Dimensions tables and Fact tables design for data marts. Establish management standards and quality assurance requirement.
• Tables, columns, views and indexes implementation. Staging and data mart area schemas partition. Index strategies and implementations, capacity planning.
• Master Data Management (MDM) and Operation Data Store (ODS) solutions required for Large scale EDW.

Confidential

Sr. Data Warehouse ETL Engineer

Responsibilities:

• ETL architect and development based on DataStage, Autosys, Approwx, Espresso, Informatica, Oracle SQL Loader, Import, Export, PL/SQL, Perl, and Unix Shell.
• Batch process work flow and workload modeling. Dependences and critical path analysis.
• Batch jobs automation, scheduling, monitoring, performance improvement, load balance and fault tolerance design. Metadata jobs repository creating and management.
• Data source area changes capturing and extracting design.
• Staging area cleaning, transformation, and conforming design.
• Complex Oracle Analytic SQL procedures development and maintenance.
• PL/SQL performance tuning and optimization by using Plan, Trace and Statspack utilities.
• Data Mart area delivering, validation, aggregation and rollups.
• Meta data development and management.
• Source data validation and pre-loading process by using Perl and PL/SQL.
• Large tables partitioning, Materialized view implementation and query rewrite.
• Data integrity verification and database synchronization.
• Database applications development based on PL/SQL, Packages, and Stored procedures.
• Batch jobs scheduling by using Autosys, Approwx and Espresso etc.
• Advanced PL/SQL queries bulk binding and parallel execution.
• J2EE Front end interface with Oracle database through JDBC.

Advanced Enterprise CRM Developer

Confidential

Responsibilities:

• SQL server T-SQL stored procedure development, analyzing, tuning and optimization.
• Oracle PL/SQL tracing, execution plan analyzing, tuning and optimization.
• HP world wide CRM CPU, Online storage and Network capacity requirements planning.
• Database server instance CPU utilization improvement and optimization.
• Database server instance I/O performance improvement and disk de-fragmentation.
• Optimum database parameters and system capacity recommendation.
• Clarify based CRM/ERP database migration and integration.
• Oracle 9i Database schema and SQL performance structure analysis.
• Data access implementation with clustering table, index and query hint.
• Application con-currency and parallel operations enhancement.
• Project and resources management.