Â Marketing Data Analyst Resume Pleasanton CAÂ Â Â - Hire IT People

SUMMARY:

2 years of business and data analysis experience in eCommerce, banking and retail domains
Excellent business requirement and technical specification writing skills
Extensive experience in SDLC implementation,agile process and scrum methodology
Experienced in preparing data dictionary,data mapping and data modelling documents
Gained experience with CRM,CMS
Solid experience in preparing test case documents and doing UAT
Experience in designing and developing Dashboards with metrics and KPI’s

TECHNICAL SKILLS:

Database: MS - Access, Mysql, Microsoft Excel, Oracle (11g/10g), sybase, Teradata

Site Tools: Adobe Omniture, DTM(Dynamic Tag Management)

Reporting Tools: Tableau 9x.

Project Management Tool: Microsoft Visio, Omnigraffle,Jira

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton CA

Marketing Data Analyst

Responsibilities:

Worked extensively with stakeholders to deliver advanced analysis (AB/MVT, advanced behavioral analysis, SEO/SEM and online campaign intelligence)
Helped marketing team in doing pre-post behavior analysis on customers who had been targeted with campaigns and email promotions.
Oversaw all aspects of the analytics engagement for marketing and public sites and gave recommendations to improve site performance and traffic flow using Adobe
Built reports and dashboards for different marketing programs and measured KPI

Environment: Oracle,Tableau,Omniture

Confidential, Milpitas CA

Business System Analyst

Responsibilities:

Facilitated meetings among different business units and conduct brainstorming sessions with the technical SME’s from the legacy team to understand the data.
Created functional and technical design document to map the legacy data with the new data warehouse
Helped Data modelers with building data mapping document
Wrote Specs for reports that were migrated from legacy to the new data warehouse
Tested reports to ensure the functionality remains unchanged.
Prepared release plans for all the deployments

Environment: SQL Server, MS Visio, Tableau