Principal Marketing Specialist/Data Engineer Resume Mountain View, CA - Hire IT People

SUMMARY:

A results - driven engineering professional, offering more than 15 years of demonstrated experience in data-driven organizations. Specializing in developing, designing and implementing and administering data warehouse/ETL applications and building marketing data analytics.
Implemented and managed Marketing Analytics data warehouse platform, ETL processes, visualizations and analytics in Oracle, SQL Server and Hadoop.
Lead all the marketing operations including lead management processes and metrics, lead scoring, nurture, campaign tracking, marketing automation systems, database health, targeting and segmentation plans.
Lead all marketing systems enhancement releases and drive requirements for improvements and enhancements.
Hands on experience in Hadoop and developed Oozie workflow for automation and storage optimization
Recognized for exceptional technical expertise and received achievement awards by Symantec, and Chevron.
Microsoft Certified technology specialist in SQL Server 2008.

TECHNICAL SKILLS:

SQL Server 2016, MySQL, Oracle, SSIS

Hadoop, HDFS, Hive, Impala, Sqoop, Hue, Oozie workflow, Shell Scripting, Unix

Python, TSQL, PL/SQL, Shell scripts

Tableau, Eloqua, Domo, CRM: Salesforce

Erwin, Power Designer, Putty, SFTP, FTP, Toad, SSMS, SQL*Loader

Agile/Scrum, Jira

PROFESSIONAL EXPERIENCE:

Confidential, Mountain View, CA

Principal Marketing Specialist/Data Engineer

Architected marketing processes and the workflow to integrate Marketing Automation system (Eloqua), CRM (Salesforce) and internal enterprise systems
Developed and implemented the strategy for data acquisition, validation, augmentation, and enhancement.
Directly responsible for supporting all marketers for $250M renewal business
Marketing Analytics - responsible for all standard reporting needs for marketing functions shared with the marketing leadership on weekly basis.
Marketing Automation - was the point of contact for the MA team to support their campaigns including data ingestion and building basic propensity models
Responsible for Database analysis across all marketing efforts to support overall marketing strategy working closely with marketing, financial, DBA and web teams.
Hands-on experience with Oracle (SQL, PL/SQL), SQL Server, MySQL and Hadoop/HDFS
Developed and implement the strategy for ongoing maintenance, and enhancement of existing marketing database: process, standards, access control, documentation, etc.
Developed sophisticated ETL workflows in multi-threaded parameter, Config driven SSIS, Python scripting
Developed Python UDFs and shell scripts for transformation and data cleansing.
Experience working with BI, Data Visualization and development tools such as Tableau 10, Domo, Hadoop Ecosystem including Hive, Sqoop.
Developed Oozie workflow for data reconciliation, consolidation, storage optimization in HDFS

Confidential, San Ramon, CA

Database Developer

Worked as a Team Lead and data analyst for Retail Pipeline, MIIP, and other databases application.
Provided support to Development team for ongoing DB changes and support.
Providing status and update to the senior management and Project management on an ongoing basis.
Created and maintain database objects tables, views, materialized views and indexes.
Created utilities in Shell scripting for monitoring day to day DBA activities.
Created Data Transformation packages (DTS) and SSIS packages for data transition
Architect Data Stage ETL jobs and processes within a data warehouse.
Coded various modules of the Extractions, Transformation, and Loading (ETL).
Created processes for conversion of transaction data into relational marketing databases.
Performance database and application tuning. Debug and Tuned the SQL Queries and store procedures.
Worked with the cross team and involved in the release process for QA and production builds deployment.
Scripted in SQL loader to load flat files into database tables.
Scripted Shell scripting for monitoring day to day DBA activities.
Wrote stored procedures, functions, packages, triggers, and indexes.

Confidential, San Francisco, CA

Oracle Database Developer

Responsible for data migration from LDAP server to oracle (8.1.7).
Develop SQL script, store procedures, function and packages using PL/SQL.
Developed complex SQL query to load flat file.
Performed SQL tuning using TKprof, Toad
Scripted in SQL loader to load flat files into database tables.
Wrote stored procedures, functions, packages, triggers, and indexes.
Created and maintain database objects tables, views, materialized views and indexes.