SUMMARY:

• I am passionate data analytics professional with 8+ years of experience in IT industry bringing insights from Customer, Product and Marketing data for devising better targeting and growth strategies.

TECHNICAL SKILLS:

Business Intelligence Tools: Google Analytics, Omniture Analytics, Tableau 7.0/8.2/9.0,Microsoft BI

ETL Tools: SSIS, Ascential Data Stage 7.5

Database Systems: MS - SQL Server 2000/2005/2008/2008 R2/2012, 2014, Teradata, MySQL, Oracle 9i, 10g/11g, DB2, MS Access

Database Management Tools: SQL Query Analyzer, SQL Profiler, SQL Server Activity Monitor, SQL Server Logs, Toad for Oracle, Toad Data Point

Programming Languages: T-SQL, PL/SQL, UNIX Scripting, .Net, HTML, CSS, Java Script

Operating Systems: Windows 98/ME/2000/NT/XP/2003/2008, 2010, 2012, MS DOS, Linux, IIS 5, 6

Project Management/ Database Design: Microsoft Project/Office 2003,2007, 2010, 2013, Microsoft Visio, Erwin

CRM Tools: Siebel, Salesforce

Software Methodologies: Agile - Scrum, Waterfall, UML

PROFESSIONAL EXPERIENCE:

Confidential, Evanston, IL. .

Digital Analytics Consultant

Responsibilities:

• Gather competitive intelligence data & provide insights on opportunities for each marketingchannel.
• Implemented Conversion Tracking and Analytics across all accounts for best optimization strategy.
• Researched keywords, developed metatags, and improved Landing Page Quality for organic traffic.
• Recommended online media for highest ROI based upon Google Analytic trends and statistics.
• Utilized Google Tools to optimize sitesand sitemaps, and keyword strategies
• Increased Traffic Volume, Clicks and Conversions through Account / Keyword Expansion.
• Omniture site catalyst is used for various analysis, tracking and improvements.
• SPOC for analytics team and handled all the data queries from DWH team.
• Responsible for report models creation and involved in DWH marketing subject area models.
• Hands on experience with relational database design and modeling.

Environment: Web Analytics, Google, Omniture, Sql Server 2008, Warehouse, MySQL, HTML5, Java Scripting, and Tableau.

Confidential, Plano, TX

Web Analytics Consultant

Responsibilities:

• Worked on Web Analytics tools like Google Analytics and Omniture Analytics.
• Developed various A/B tests and MVts for analyzing customer web interactions.
• Created and experimented with various interaction flow analysis and improved path browsing
• Omniture site catalyst is used to create heat maps, dashboards, Segmentation.
• Created relational data models for marketing metrics tables.
• Developed reporting standards and practices with role based access.
• Demonstrated problem solving skills and involved in root cause analysis for data discrepancies.
• Involved in POC of data visualization tools Qlikview and Tableau.
• Distributed insights of traffic and performance of the sites to stake holders.
• Compared and reported metrics for different campaign and marketing plans

Environment: Google Analytics, Omniture Site Catalyst, Tableau, MySQL, and Oracle.

Confidential, Anthem, CA

BI - Marketing Data Analyst

Responsibilities:

• Worked as Data Analyst for marketing analytics team.
• Has been instrumental in collecting the requirements from product marketing owners and campaign owners.
• Provided data in different patterns for the Marketing analysis needs.
• Provided benchmark comparison reports using Microsoft Excel.
• Extracted data from various types of relational data bases and pulled the qualified data for analysis.
• Created simplified drill down and roll up views of data for key metrics.
• Created validation rules across systems and data flows from CRM systems to Analytical and warehouse systems.
• Support tickets are logged for IT teams for any deviations in analytical systems.
• Worked closely with IT teams to provide the analysis results to drive the BI requirements.
• Gained exposure to data visualization tools like Tableau.
• Involved in UI design team discussions for developing web user interface for reports.

Environment: Siebel CRM, Teradata, MySQL, Quality Center, Tableau, Java, HTML

Confidential

BI - Marketing Analyst

Responsibilities:

• Ensure dashboards setup for Analytics are functioning.
• Ensure analytics and BI functions could be performed if needed.
• Ensure tracking was in place and the discussed calls to actions could be continuously monitored and improved.
• Implement a Web Analytics Dashboard that monitors daily visitors.
• Web Content Management (WordPress), Web Development ( Corporate Web - HTML, CSS, PHP, XML)
• Suggest Process Development & Improvement initiatives.
• Perform routine Site Audits as part of discussed Quality Assurance measures.
• Reporting Web Analytics, ROI Matrix for SEM, SEO & Social Media, Case Study/Business
• Proposals (Current/New Marketing Channels), Dashboards, Ad-hoc reports, Data-warehouse reports.
• Refactor current code where needed to resolve bugs and/or optimize the web application.
• Test the developed platform for unwanted behavior or security flaws.
• Complete functionality for video conferencing and chat capabilities.
• Refactor code for various dashboards belonging to the existing role based system.

Environment: Siebel CRM, Teradata, MySQL, Quality Center, Tableau, Java, HTML

Confidential

Data Analyst

Responsibilities:

• Design and build large and complex datasets from a variety of data sources across multiple platforms.
• Provided data in different patterns for the marketing analysis needs.
• Perform data analyses on, or discover new uses for existing data sources.
• Extracted data from various types of relational data bases and pulled the qualified data for analysis.
• Creatively visualize data and report findings in a variety of formats to provide relevant insights to the organization.
• Communicate and present models to business customers and executive
• Created simplified drill down and roll up views of data for key metrics.
• Created validation rules across systems and data flows from CRM systems to Analytical and warehouse systems.
• Develop and evaluate the performance of predictive statistical models.
• Worked closely with IT teams to provide the analysis results to drive the BI requirements.
• Design and implement statistical data quality procedures.
• Involved in UI design team discussions for developing web user interface for reports.

Environment: Siebel CRM, Teradata, MySQL, Quality Center, Tableau, Java, HTML.