SUMMARY

• Over 15 years of experience in software analysis, design, development, and implementation with focus on highly scalable systems.
• Proven track record of definition and implementation of architecture strategy.
• Proven ability to lead and mentor group of people
• Excellent ability to resolve complex technical issues.
• Strong analytical skills. Extremely strong troubleshooting skills. Proven ability to lead and mentor groups of people.
• Extensive experience in data modeling and design
• Good knowledge of Hadoop, HDFS, Big Data, Hive
• Experienced on working with Big Data and Hadoop File System (HDFS).
• Strong technical hands on experience in Oracle 11g/10g/9i/8i MySQL 5.1/5.6 databases
• Experience in developing web applications using MySQL, Oracle PL/SQL, Perl, CGI, TSQL, Tcl/Tkl, as well as other SQL flavors, ETL tasks, database and query optimization (Analyze, Explain Plan, TKPROF)
• Strong analytical skills including the ability to transform complex business requirements into a successful system design
• Database/System Administration with 8 years of professional experience in administrating various
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment
• Hand - on experience writing backward compatible code
• Excellent interpersonal and communication skills and willingness to learn new tools, concepts and environments
• Working knowledge of Git, Maven, and Jenkins

TECHNICAL SKILLS

Databases: Oracle, Sybase, Microsoft SQL Server, MySQL

Operating systems: UNIX (Solaris, HP-UX, IBM AIX), Linux (Red Hat), Windows NT, PICK/REALITY Operating System, OS/MVS

Languages: PL/SQL, Perl, Tcl, Expect, JavaScript, UNIX shell, SQL

Big Data Ecosystems: Hadoop, MapReduce, HDFS, Hive, Pig, Sqoop,MongoDB

Applications and Tools: PL/SQL Developer, TOAD, Oracle Enterprise Manager, Brio 6.0, SQL*LoaderSQL*Plus, DB Artisan, Oracle Parallel Server, Oracle Application Express, Sybase ASE 11.9/12.0/12.5 , Sybase Central, Replication Server 12, SQL Advantage, BMC SQL-BackTrack, Legato Networker, IBM ADSM, Veritas Volume Manager, Veritas NetBackup, Jenkins/Hudson, Cruise Control

MC/Service: Guard, HP Glance Plus, HP Omni Back II v.255, Remote Control

Web Servers: Apache Web Server 1.3/2.0, Apache Tomcat 4, Netscape Enterprise Server 6.0

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Engineer/Architect

Environment: MySQL, Windows, Unix, Hadoop

Responsibilities:

• Responsible for design/development of distributed data storage platform and web applications for Online Marketplace, Catalog/Inventory/Order Management Systems as well as Data Analytics/BI tools in big data paradigm
• Implemented analytical solution on Big Data using Hadoop/Hive/Sqoop/Pig/Shell
• Was responsible for development of Hive-MapReduce-streaming Shell modules using Hive
• Evaluated benchmark and compile metrics for total MapReduce CPU time spending while running Hive aggregates.
• Provided technology direction, lead the development efforts
• Trained, led and mentored to onsite and off-shore developers.
• Led architecture and design of a high performing/highly available and horizontally scalable application
• Conducted POC for new releases of MySQL
• Support the existing framework and implementation of new store procedures for the feeding the data to the various systems using store procedures and scripts (MySQL 5.1/5.6 on Fedora/RHEL5)
• Perform data modeling and design new database objects to support new functionality
• Support and implementation of new program for the Eventual Consistency to support Data Sharding
• Implement store procedures for the ETL process to load the data from the External Providers through the staging environment to the main entities
• Leveraged Platfora for Data Visualization
• Responsible for Data Retention and Pruning, SQL performance and tuning
• Development of data strategy/best practice and associated policies
• Selection of compatibility and systems to meet business information needs

Confidential, CA

Senior Database Engineer/Technical Lead

Environment: Oracle/MySQL, Windows, Unix

Responsibilities:

• Responsible for database side implementation and development various new releases using Oracle/MySQL
• Designed and implemented hierarchical data structure and all the database related functionalities
• Responsible for the OLTP and OLAP data modeling
• Lead and participated in DB performance enhancement efforts, In-house ETL development

Confidential, Menlo Park, CA

Senior Database Engineer/Developer/DBA

Environment: Oracle 9i/10g/11g, Windows, Unix

Responsibilities:

• Responsible for the database side implementation and development of PES (Partner Engagement System) releases using PL/SQL, SQL and Unix Shell scripting
• Design and implement data warehousing to facilitate reporting using Pentaho
• Migration of through ETL processing from transactional systems to reporting systems
• SQL query optimization using Hints and utilities like Explain Plan, Auto Trace.
• Extensively used PL/ SQL blocks Collection, Procedures, Functions, Packages and Triggers for implementing complex business logic.
• Develop and maintained DB utilities to extract and load sets of between the different systems
• Performed automated load using shell scripting and Oracle tools and techniques such as: SQL*Loader, export/import, external tables
• Automated load for I18N project using Unix shell scripting and Oracle tools and techniques such as: SQL*Loader, export/import
• Perform analysis to evaluation the existing interfaces, business needs and provide solution
• Translated requirements into functional and technical specifications
• Perform unit and integration testing and debugging and set test conditions based on code specifications
• Responsible for designing, developing, specification of test plans

Confidential, Newark, CA

Senior Database Developer/Product Quality Lead

Environment: s: Oracle 9i, Unix, Perl, JavaScript

Responsibilities:

• Developed a number of entirely new applications, store procedures, packages for reporting different product metric/scorecards with the goal of improving product availability and quality using PL/SQL, Tcl, Perl, CGI, JavaScript, Lout, Unix Shell Scripting
• Assisted in the implementation Oracle OLAP, mapping, migration
• Implemented automated syntactic CLI test software for Honeycomb products using Perl, Tcl/Expect
• Design, develop and implement Health Check tracking process to improve customers quality experience using PL/SQL, HTML, Tcl, Perl, CGI, JavaScript
• Performed mining, created, and delivered custom reports, models to halp analyze different product quality metric (Escalations, Bugs, Radiance Cases, Install Base, FIN/FCO's, CPAS and etc...) using Brio, Perl for the Network Storage products
• Built Web Pages with HTML, Java Script and CSS
• Perform analysis utilizing establish scorecards of the Remote Monitoring/Telemetry Compatibility
• Fault tolerance/management metric, identifying product quality highlights and low lights
• Design, develop and implement NWS QCC Lesson Learned database and application utilizing PL/SQL, Perl, CGI, HTML