Manager, Marketing Automation And Data Analytics Resume
SUMMARY:
- Over Fifteen Years of experience as a Web Developer and marketing Automation Lead with skills in analysis, design, development, integration
- As of now working as a Manager at Salesforce
- Extensive experience in ELOQUA, Salesforce, UNICA Affinium, Oracle, Teradata, SQL, UNIX
- Developed Marketing Campaigns and Website Display Ads
- Experienced in interacting with the business users to collect requirements, analyze them and brainstorm them into technical specifications as well as translating the organizational mission into understandable, measurable and attainable goals.
TECHNICAL SKILLS:
CRM: ELOQUA, Salesforce, UNICA and Responsys
Languages: SQL, Core JAVA, HTML
Database: Oracle, MS SQL Server, Teradata
PROFESSIONAL EXPERIENCE:
Confidential
Manager, Marketing Automation and Data Analytics
Responsibilities:
- Eloqua - Salesforce integration
- Eloqua Program for CRM integration / Preference Management / Nurtures
- Integrating Marketing Automation Data / CRM data into Data Ware house
- Data Analysis, Data validation and mining across multiple data sources
- Cloud connectors implementation
- Building Dashboards in Wave for all Marketing
- Eloqua REST API Integration with other Applications
- Apps using Java, REST API
Environment: Eloqua, Sales Force, Oracle, SQL, Java, REST API, Python, Wave, Splunk
Confidential, Mountain View, CA
Consultant - Marketing Automation, Data Management and Analytics
Responsibilities:
- Implementation of New Marketing Platform Eloqua for Confidential and VERITAS
- Building Marketing Nurture Campaigns, Internal Communication Emails using Eloqua
- Retirement of Harte-Hanks and building marketing Enterprise data warehouse
- Work with global cross-functional teams to ensure tasks are completed on schedule, conduct code reviews and troubleshoot defects.
- Data Analysis, Data validation and mining across multiple data sources
- Data Cleansing using IDQ
- Integration of ELOQUA-SFDC
- Integration of Eloqua to Data warehouse
- Integrating On-premise applications TIBCO/Data warehouse with Eloqua
- Cloud connectors implementation
- Migration and Cleansing of Enterprise Data into Eloqua System
- Handling of large data both for consumer and enterprise
- Synchronization of data across multiple marketing automation systems and ELOQUA
- Demand Base Integration
- Migration and consolidation of preferences data from Legacy Application
- REST API
- Eloqua Forms/Landing pages migration into AEM
Environment: Eloqua, Sales Force, Teradata, Oracle, SQL, Responsys, JAVA, REST API, Omniture, Splunk
Confidential, Redwood City, CA
Consultant
Responsibilities:
- Implement marketing programs using Unica Affinium, Responsys and SQL
- Consult with marketing Managers on campaign strategy
- Gather requirements and provide the scope document
- Identify the data sources needed for Campaign Targeting
- Provide Estimations on campaign sizing and segments based on the requirements
- Develop Programs in Unica Affinium
- Post Campaign Analysis
Environment: Unica Affinium, Responsys, Oracle, SQL, PL/SQL,UNIX and Windows XP
Confidential, San Jose, CA
Digital Marketing and Analytics
Responsibilities:
- Provide Consultation to LOB on strategy for multiple programs/channel and implementation. Detail the testing plan that accommodates both business and technical implementation
- Worked on Confidential Custom Ad-Solution Tool and integration of Email campaigns with on-Site Ads.
- Implemented Confidential New member experience in all Channels with a complex logic including A/B Testing, real time message to Customer On Line
- External File processing automation
- Worked extensively on multichannel campaigns Email, Online, System email and Transactional Emails.
- Consult with marketing managers to confirm and finalize marketing campaign requirements and scope document
- Collaborated with Data Management, Analytics and Product teams to identify the data sources/tables needed for new business needs
- Defined Business requirements for Campaign Data Model for response, Contact History management.
- Analyze the response data and sharing the results with Management
- Worked on Pilot programs to test the capabilities of new Technology / Tools
- Translate marketing campaign requirements/scope into campaign targeting/selection rules
- Migration of campaigns in Unica to a new Data ware house and new ESP, without impacting the existing production and in phases.
- Implement marketing programs using Unica Affinium, SQL, Shell scripts
Environment: Unica Affinium, Marketo, Responsys, Teradata, SQL, UNIX and Windows XP, Omniture, Display Ads
Confidential, San Francisco, CA
Marketing Database Consultant
Responsibilities:
- Implement marketing programs using Unica Affinium, SQL, Shell scripts
- Consult with marketing staff to confirm and finalize marketing campaign requirements and scope document
- Determine/select data sources required to meet campaign scope document
- Translate marketing campaign requirements/scope into campaign targeting/selection rules
- Provide a high level campaign sizing (size of population) based upon requirements from the scope document
- Finalize Marketing Scope document and Execute campaign.
- Coordinate and complete analyses involving campaign response data.
- Work with the Marketing Execution Team and email vendor to resolve any data issues in their response data
Environment: Unica Affinium, Teradata, SQL, Responsys, UNIX and Windows XP
Confidential, San Francisco, CA
Business Data Analyst
Responsibilities:
- Extensively implement marketing programs using Unica Affinium, SQL,PL/SQL, Shell scripts
- Develop technical solutions to marketing business needs and changes by gathering, compiling and reviewing requirements and data, examining and evaluating existing systems and procedures, identifying alternate courses of action.
- Review and translate functional specifications to validate and ensure that they meet business requirements
- Present Analysis Results to the business
- Define testing criteria, prepare test scripts to verify outcome
- Lead project activities including assigning and ensuring the completion of tasks, determining project schedule and resolving project issues
- Conduct or facilitate meetings attended by a variety of technical, non-technical and supervisory/management staff
- Perform other duties as assigned
- Responsible for new application development as well as enhancing the performance of existing applications by adding new features. Involved with EUFSv6.0 online modules design and development, as well as SRDBv2.0 redesign with new business requirements
- Implemented Model-View-Controller (MVC) Struts Architecture.
- Involved in preparation of Functional Specifications, Data Flow Diagrams and Data Modeling
- Migration of the Web Applications EBC and SRDB from ATG to Web Sphere Application server.
- Designed the Interface and developed the GUI pages to display the data.
- Responsible for overseeing the Quality procedures related to the project
- Oracle/ SQL Server Database Design and Development. Back-end programming using PL/SQL
- Configured JDBC connection pool.
- Developed and performed Integration Test of releases and managed the defect tracking and resolution using Test Director. Wrote several test cases
Environment: J2EE, Java, IBM Web sphere Application server4.x/5.x, Oracle9i/8i, SQL, PL/SQL, AIX and Windows NT/2000.