Senior Experience Analyst Resume
0/5 (Submit Your Rating)
ChicagO
SUMMARY
- Over 5+ years of experience as a Data Analyst / BA, with Progressive responsibilities in data analysis with a focus on market reporting, Data warehouse DW, and business intelligence BI
- Accomplished Senior IT professional with a background in business intelligence, reporting systems, data pull and manipulation ETL, and full lifecycle development.
- Extensive experience in interaction with system users in gathering business requirements and developing project strategies.
- Chaired and conducted JAD sessions with business and technical teams.
- Vast experience working in the area of data management, including data analysis, gap analysis, and data mapping.
- Worked extensively with Tableau, Datorama, Google Data Studio, Dashthis, Python
- Adept at writing Data Mapping Documents, Data Transformation Rules, and maintaining Data dictionaries.
- Created and executed Test Plans, Test Scripts, and Test Cases based on Design and User Requirement documents for testing purposes.
- Coordinated and prioritized outstanding defects and system requests based on business requirements.
- Acted as a liaison between the development and management teams to resolve any requirements conflicts.
- Experience in SQL, and implementing Business Intelligence solutions using SQL Server 2000/2005/2008.
- Excellent experience in data Extraction, Transformation, and cross - disciplinary marketing analysis using tools like Google Analytics, Google Tag Manager, Google Ads, Bing Ads, Facebook Ads, and Dataxu.
- Interacted with all levels of the project development team, from end users to Software Architects, Technical leads, Clients, Database Administrators, and System Administrators.
- Capable of managing projects while leading cross-functional teams to meet and exceed overall IT initiatives.
- Excellent technical, time management, communication, interpersonal and presentation skills.
TECHNICAL SKILLS
Database Skills: Amazon Redshift, MySQL, SQL Server
Analytics and Visualization Tools: Tableau, Datorama, Google Data Studio, Dashthis, Python
CRM: Hubspot, Sharpspring, Constant Contact, Salesforce Pardot, Pinpointe
Digital Marketing Tools: Google Analytics, Google Tag Manager, Google Ads, Bing Ads, Facebook Ads, Dataxu
PROFESSIONAL EXPERIENCE
Senior Experience Analyst
Confidential, Chicago
Responsibilities:
- Analyzed marketing and non-Marketing audience segments dissecting contract composition by factoring in demographic and geographic makeup
- Computed lead time journey between lower funnel conversion events to efficiently map journey pathways
- Strategized recruiter efforts in driving contracts by gauging contact behavior patterns of lead-capturing sources
- Determined the effect of culture and global events on audience engagement to feed into the lead persona
- Conducted deep-dive spotlight analysis to support contract pacing toward monthly and yearly Army contract goals
- Painted wholistic lower funnel performance marrying lead performance to website metrics and campaign efforts
- Studied reactivated cold leads behavior to understand the activation timeline helping devise campaign cadence
- Geo-analyzed state and DMA lead conversion rate of email campaigns to support lists procurement
- Compared lead propensity towards diverse Army wings by interest and disposition codes for marketing direction
- Streamlined monthly reports by revamping workflows creating new efficient templates, and automating manual efforts by building dashboards
- Formulated process and built workflows for weekly reports that served to proactively feed into the monthly report narrative to Major Generals and act as a diagnostic tool to catch data anomalies
Digital Marketing Analyst
Confidential, Chicago
Responsibilities:
- Geo-Analyzed and segmented customers based on demographic patterns to strategize marketing efforts
- Predicted product line growth and identified emerging market areas to support supply chain management
- Patterned past attendee data that identified growing media channels and content segments increasing trade show registrants by 30%
- Identified repeat purchase patterns to understand the timeline and product preference of repeat customers
- Computed lead to customer rate to understand marketing funnel cycle timeline for HVA leads
- Defined data collection practices, identified conversion points, and implemented tracking on the website to collect marketing data
- Structured and maintained CRMs. Developed email campaign strategies for leads in all stages of the marketing funnel
- Built dashboards, created reports and delivered email campaign performances to clients
Data Analyst
Confidential, Chicago
Responsibilities:
- Used clustering to segment students into categories, considering their demographic and academic background
- Developed dashboards identifying channels leading to maximal student registration
- Created a student-faculty interactions dashboard which helped identify pain points boosting interactions by 15%