| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Data Marketing AnalystE-mail: EMAIL AVAILABLE Mobile: PHONE NUMBER AVAILABLEProfessional SummaryOver 4 years of experience as a Data Analyst, Designed and developed interactive Power BI dashboards for complex data visualization. Utilized advanced features in Power BI, such as DAX functions, custom visuals, and drill-through capabilities.Integrated Snowflake with Power BI for seamless data extraction, ensuring real-time data updates. Employed Snowflake's cloud-based solutions for efficient data management and analysis.Implemented ETL processes using Snowflake to automate data pipelines, enhancing data reliability. Conducted data mapping and migration tasks to move data from legacy systems to Snowflake.Utilized SQL to analyze marketing campaign data, identifying key performance indicators. Leveraged Guidewire for analyzing housing and marketing data and supporting strategic initiatives. Developed data models and reporting solutions using Guidewire to meet marketing team objectives. Integrated Guidewire with other data sources for a more thorough analysis.Developed and maintained landing pages using Drupal, improving website functionality and user experience. Managed social media platforms to boost engagement and promote on-campus living.Led a team in creating graphics for the website and enhancing visual content. Utilized Microsoft Word, Excel, and PowerPoint for marketing presentations, and visualizing data changes.Improved website performance by 35% using Dub Bot, addressing SEO and web governance issues. Increased and Analyzed marketing data using SQL, R, and Tableau for strategic overhauls. SEO compliance by 30%, improving search engine visibility and organic traffic.Conducted data analysis to identify key performance indicators, resulting in increased lead conversion rates.Created Guidewire dashboards to present data insights to stakeholders. Ensured data accuracy and consistency during data mapping and transformation tasks with Guidewire. Analyzed trends using Guidewire to inform marketing strategies.Produced detailed technical documentation, including application functionality and test methods.Designed Power BI dashboards to provide actionable insights for business decision-making. Created interactive dashboards to visualize key metrics and trends. Used Power BI to visualize and interpret complex data sets for marketing campaigns.Worked with cross-functional teams to gather requirements and deliver tailored Power BI reports. Visualized server performance metrics with Power BI and Tableau, aiding IT teams.Utilized machine learning algorithms to enhance data analysis and prediction capabilities.Skill Sets:Programming:Python, Java, C, C#, JavaScript, Shell Scripting, RMark Up Languages and Style SheetsHTML, CSS, JavaScriptDatabasesMySQL, OracleToolsMS Visual Studio/Code, MS SQL Server, Drupal, Anaconda IDE, Eclipse IDE, Team City, Microsoft Power BI, Data warehouses, Tableau, Hadoop, Mango DB, GithubFrameworksReact, Angular, Node.js, Linux, UnixSkillsData Processing, Data Visualization, Data governance, Quality analysis, Problem-Solving, project management, Data security, Data curation, Data Structures, DBMS, ETL, Big Data, Scripting, Data Science, Data Mining, Analytical Techniques, Data Lakes, Data Transformation, Databases, Analytical Skills, Data gathering, Data structuring, Fraud detection, Communication skills, Interpersonal Skills, Oral Communication, Business Requirements, Key Performance Indicators, Pivot Tables, Qualitative Research, Metadata Modeling, Requirements GatheringPROFESSIONAL EXPERIENCE:George Mason University, Virginia Jan 2023-PresentROLE: Data Marketing AnalystResponsibilities:Created and maintained landing pages using Drupal, enhancing website functionality. (https://housing.gmu.edu/)Managed social media platforms to enhance engagement and promote on-campus living, supporting the Assistant Director of Marketing and Communications. Led the graphic design team and web assistants in creating graphics for the website.Spearheaded data-driven projects to analyze user behavior and website performance, resulting in a 50% improvement in overall user experience satisfaction and a 40% increase in website conversion rate and total users to 200K.Designed and implemented new data models and reporting dashboards, providing actionable insights that led to a $500K increase in annual revenue.Implemented advanced statistical techniques and machine learning algorithms to analyze 10000+ Key Performance Insights (KPI) data points, uncovering trends and patterns that informed strategic initiatives.Translated complex analytical findings into actionable strategies for executive teams, driving a 25% increase in client retention and enhancing operational workflow efficiency by 18%. Analyzed marketing campaign data over 6 months using SQL, R, and Tableau to identify key performance indicators, resulting in a strategic overhaul that increased lead conversion rates. Designed and developed interactive Power BI dashboards to visualize complex datasets, providing actionable insights for business decision-making.Utilized Power BI to create dynamic reports, incorporating advanced features such as DAX functions, custom visuals, and drill-through capabilities. Integrated Snowflake with Power BI for seamless data extraction and transformation, ensuring real-time data updates and accurate reporting. Employed Snowflakes cloud-based data warehousing solutions to manage and analyze large volumes of data efficiently.Conducted data mapping and migration tasks to move data from legacy systems to Snowflake, ensuring data integrity and consistency. Leveraged Guidewire software to analyze insurance data, identifying trends and patterns to support strategic marketing initiatives.Utilized Guidewire software to manage and analyze housing and marketing data effectively.Developed and maintained data models and reporting solutions using Guidewire to support the housing marketing team's objectives. Collaborated with cross-functional teams to integrate Guidewire with other data sources for comprehensive data analysis.Conducted data mapping and transformation tasks using Guidewire to ensure data accuracy and consistency. Analyzed housing market trends and customer data to inform marketing strategies and decision-making processes. Created dashboards and visualizations in Guidewire to present data insights to stakeholders.Implemented ETL processes using Snowflake to automate data pipelines, reducing manual data handling and improving data reliability. Collaborated with cross-functional teams to gather requirements and deliver tailored Power BI reports that address specific business needs.PROJECT: Automated Real Estate Data Pipeline for Snowflake with Airflow and Python Jan 2023 June 2023Brief:Tech: Python, Apache Airflow, S3, EC2, Snowflake, Power BIBuilt an automated ETL pipeline using Airflow and Python to process real estate data from Redfin.Integrated data into Snowflake for efficient data warehousing and analysis.Cleaned and transformed real estate data using pandas for better insights.Leveraged AWS services like EC2 and S3 for infrastructure and data storage.The pipeline is designed to seamlessly connect with data visualization tools like Power BI, empowering users to explore trends and patterns in the data.PROJECT: Predicting Customer Subscription to Personal Loan Offers Aug 2023 Dec 2023Brief:Tech: Machine Learning, Power BI, StreamlitA machine learning model using logistic regression was built to predict customer acceptance of personal loan offers based on demographics and banking activity.Analysis of a rich customer dataset revealed patterns and insights that help identify potential loan recipients.The logistic regression model achieved high accuracy (95%) in predicting loan approvals and offers interpretable results, allowing stakeholders to understand key loan decision factors.A user-friendly Streamlit web application allows loan officers and potential borrowers to get real-time loan acceptance predictions with visualizations explaining approval factors.CLIENT: Virtusa, IND Jun 2021 - July 2022Role: Data Analyst/EngineerResponsibilities:Utilized Power Query in Power BI to clean and transform raw data from various sources, ensuring data quality and consistency. Merged datasets from different departments to create a unified view for analysis.Created interactive dashboards in Power BI to visualize key metrics such as sales performance, customer demographics, and product trends. Designed various types of charts (bar, line, pie, scatter) to represent data insights effectively.Provided training and support to team members on using Power BI for their data analysis tasks. Communicated complex data insights in a clear and concise manner to non-technical stakeholders.Created interactive dashboards with Power BI and Tableau to visualize real-time sensor data, offering IT teams easily interpretable insights into server performance metrics. Utilized SQL and Python for ETL processes, extracting, transforming, and loading data from diverse sources. Conducted exploratory data analysis (EDA) to reveal patterns, trends, and outliers within datasets.Utilized Machine learning algorithms that detected anomalies and predicted potential hardware failures before they occurred, reducing server downtime by 25%.Consistently conveyed complex analytical insights to non-technical stakeholders and collaborated with departments to gather feedback, ensuring continuous improvement and alignment with business goals.CLIENT: Mindtree, Hyderabad, India. Jan 2022 - May 2022Role: Software InternResponsibilities:Led the redesign and implementation of the project database, facilitating seamless collaboration and reliable communication between frontend and backend web development teams. Developed and executed SQL queries for Quality Assurance, resulting in a 45% reduction in software bugs. Collaborated with cross-functional teams to define data requirements and deliver comprehensive marketing reports.Involved in the implementation of a real-time data analytics system for server sensor data, which involved processing and analyzing large streams of data using Apache Kafka and Apache Spark. This system handled over 10 million data points per day, reducing data processing times by 40% and cutting server downtime by 25%.Education:George Mason UniversityMasters in computer and information science 3.6/4 CGPA (4.0) Aug 2022 - May 2024 Fairfax, USAVardhaman College of Engineering, IndiaBachelors in Computer and Information Science May 2018 June 2022 Hyd, IND |
