SUMMARY:

• 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

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

ERP & CRM: Yantra Order Management system, Retek 10 RDW (warehouse), Siebel CRM, Clarify, Remedy, Vignette StoryServer, ClairfyCRM, Oracle Application server.

Languages: VSQL, PL/SQL, 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, Confidential AIX, HP UX, Advanced PICK.

AD management: Agile Software Development Methodology, Autosys, Approwx, Espresso, SQL Navigator, TOAD, Enterprise Manager, Oracle SQL Loader, Import, Export, Trace, TKPROF, Statspack, DBArtisan, Visio, Rational Studio, LoadRunner, Oracle Forms, Oracle Reports, Power Builder, Dynasty, Crystal.

PROFESSIONAL EXPERIENCE:

Sr. Data Warehouse Architect/Engineer, Data Scientist

Confidential

Responsibilities:

• Data Warehouse system Data Modeling and architect design for Enterprise Resource Planning systems. Experienced in the following subject areas: Health Care Clinic, Product planning, Marketing, Sales, HR, Shipping, payment, and Inventory management.
• Enterprise Data Warehouse Data Governance. Data Warehouse source and target data management for the availability, usability, integrity, and security purpose.
• Advanced Business Intelligence system Architecture through massively parallel (MPP) enabled database systems such as Vertica and GreenPlum.
• NoSQL database schema porting. Ensure baseline schemas are portable between many NoSQL databases, such as Cassandra and Mongo DB.
• Dimensional modeling. Star or Snowflake schema design, fact and dimension table modeling.
• Master Data Management (MDM) and Operation Data Store (ODS) solutions required for Large scale EDW.
• Metadata system design. Source data specification, description and processing architecture.
• Data Staging design. Staging data acquisition, dimension management, transformation and aggregation architecture.
• 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.
• Structured ERP dataset Extracting, Transformation and Loading by using packaged tools such as Informatica, SSIS, SSAS, DataStage, and non-packaged tools such as PL/SQL, SQL, Perl, and Unix Shell.
• Business Intelligent dataset transformation. Which includes Data Cleansing, Mapping, Conversion, simulation, enrichment, and projection.
• OLAP ETL architect design with high Performance considerations. Design or improve ETL architectures to meet performance requirement by using parallel processing, table partitions, index strategies, materialized view, data hashing, and data clustering technologies.
• PL/SQL performance tuning and optimization by using Execution Plan, Trace and Statspack.
• Complex Analytical SQL procedures development and maintenance.
• Virtual Data Federation for International Product Provisioning system.
• Batch process system performance design and tuning for Enterprise ERP Data Warehouse.
• Compose and distribute solution roadmaps, standards and guidance based on adopted technologies towards the covered architecture domain.
• Evaluate ETL technologies, industry trends, and tools towards future development need.
• Provide a consolidated global view of business operations across multiple lines of business.
• Worked as a member of the Confidential Big Data group, experienced non-structured dataset MapReduce programming by using analytical platforms such as PIG, Hive, and HBase.
• HiveQL programming. HP Distributed Device Alerts ETL through querying and managing large upstream datasets resided in either Apache HDFS or Apache HBase.
• Business Intelligent analytical query, modeling, simulation, projection, optimization, virtualization and data mining. Create and use of Cube by using SQL Server Analysis Services.
• 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 code porting and Qlikview support.

Lead Enterprise Data Warehouse Architect/Engineer

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.
• Physical level modeling. 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.
• 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.
• Yantra Order Management system Business Intelligence ETL.
• Retek V10 RDW Data Warehouse and Data Mart ETL.

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.

Business Intelligent Developer

Confidential

Responsibilities:

• Health Insurance Portability and Accountability Act (HIPAA, Title II) compliant project.
• Established KP's CIS terminology standards for electronic health care transactions, and KP’s CIS national identifiers for providers and health plans.
• Enhanced the security and privacy of health data through data encryption, decryption and the authentication strategies.
• ETL tools development based on Informatica, PL/SQL, Perl and Unix Shell.
• Data source area changes capturing and extracting.
• Staging area cleaning, transformation, and conforming.
• Data Mart area delivering, validation, aggregation and rollups.
• Relational database schema design, logical and physical data modeling.
• Advanced Oracle 8i PL/SQL based Packages, Stored procedures and triggers implementation.
• DB2 UDB Stored procedures and CLI/ODBC modules development.
• Large size database migration. Migrate stored procedures and tables across platforms.
• Data validation and reconciliation on distributed enterprise database systems.
• WebLogic business logic layer and database interface implementation by using JAVA/JDBC.
• Data Warehouse and Data Mart business requirements collecting and auditing. Interview with internal users and document business requirements.
• Work tasks and environment analysis and design.
• Conceptual level 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.
• Physical level modeling. Tables, columns, views and indexes implementation. Staging and data mart area schemas partition. Index strategies and implementations, capacity planning.
• Metadata design for source system data specification and staging area data acquisition.

Lead Enterprise Database Administrator

Confidential

Responsibilities:

• Lead the DBA team and was responsible for ensuring the success of high availability to customers’ corporate online system.
• Information Technologies Industry.
• E-Business and E-Content Delivery web sites enabling. Manage and implement OLAP/OLTP database servers in production environment.

Data Warehouse and Data Mart architect

Confidential

Responsibilities:

• Data Warehouse and Data Mart requirement collection for corporate decision support system.
• Conceptual Data mart Entities identification and modeling.
• Logical modeling. Star schema Dimension tables and Fact tables design.
• Physical modeling. Tables, indexes and materialized views implementation that considers data loading and data reporting requirement. Focus on performance efficiency.
• Relational database schema design, logical and physical data modeling.
• Oracle instance management. Database backup, recovery, data extracting and loading.
• System high availability, fail-over, fault tolerance, and disaster recovery enabling.
• Large size tables, indexes analysis and partition.
• Massive volume database online session management, monitoring and tracing.
• System load balance, scalability, concurrency, and parallel operations enhancement.
• Data integrity constraints and dependences management.
• Remote server replication, business data loading, extracting, importing and exporting.
• Oracle Packages, Stored procedures, triggers and PL/SQL scripts development.
• Korn shell and Perl scripts based batch jobs implementation.

Senior Database Developer

Confidential

Responsibilities:

• Banking and Financial industries.
• Account receivable applications analysis, development.
• Investment planning web application development.
• Online trading system database schema analysis.
• Advanced PL/SQL based Packages, Stored procedures and triggers implementation.
• Power Builder to database interface objects development.
• Create a Virtual database layer that promotes the rapid development of application.

Lead Database Developer

Confidential

Responsibilities:

• Technical manage/Lead a team of 10 engineers/analysts to convert CRM databases from various resources such as SQL Server, DB2 UDB, and Sybase to Oracle.
• Health Care and Biotech Industries.
• Biotech R&D database management and analysis. Serve as liaison between customers, application users, and IT development teams.
• Oracle 8i Data Warehouse design. Schema, Dimension and Fact tables modeling.
• ETL tools development based on Informatica, PL/SQL, Packages, Stored procedures and triggers.
• Metadata, Dimension table, Fact table, partitioned table and parallel query design.
• Experience of case tools, such as ER/Win and Visio.
• Knowledge of analysis and reporting tools such as Business Object, Crystal and Brio.
• Dynamic SQL, data locking and cursor implementation.
• Korn shell and Perl scripts based batch jobs implementation.

Confidential

Applications Analyst and Developer

Responsibilities:

• Java, Java Servlets, Applet, and Java Beans Object oriented application programming under J2EE platform environment, JDBC interface and XML development.
• Pro*C, C/C++, Perl, and UNIX Shell independent Unix based program development.
• Oracle Packages, Stored procedures, triggers and PL/SQL scripts development.