Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Timeline
Generic
DINESH A V

DINESH A V

HYDERABAD

Summary

Experienced Data Analyst with 3 years in IT, specializing in Paid Media Marketing, Media Services, and Construction & Real Estate. Expert in Python, SQL Server, Excel, VBA, Power BI, Datorama, and more. Skilled in translating complex data into actionable insights, adept at project management, and proficient in various reporting tools and data modeling techniques. Effective communicator with strong analytical and problem-solving skills, able to thrive in fast-paced environments and meet tight deadlines. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

3
3
years of professional experience

Work History

Senior Data Analyst

Annalect India Ltd
10.2023 - Current
  • Managing extraction of data sets from multiple marketing platforms i.e (Facebook, Instagram, TikTok, Spotify, Reddit, Snapchat, Twitter, Pinterest, Double Verify, Display& Video 360 (DV360), Display & Video 360 (DV360)) and perform hygiene and quality control steps, using Datorama
  • Implementing and managing data system architecture
  • Audit and manage data taxonomy/classifications from multiple systems and partners
  • Managing the extraction, loading, and transformation of multiple datasets
  • Cleansing all data and metrics; perform override updates where necessary
  • Identifying and implementing opportunities for efficiency throughout the process
  • Managing and executing thorough QA process and ensure quality and accuracy of all data and reporting deliverables
  • Manipulating and analyzing “big” data sets synthesized from a variety of sources, including media platforms and marketing automation tools
  • Managing all data visualizations and ensuring data is presented accurately and is visually pleasing
  • Assist analytics team in running numerous insights reports as needed
  • Help maintain a performance platform and provide insights and ongoing recommendations around
  • Preparing Reports as per stakeholder requirements
  • Prepared clear and detailed Business Requirement Documents (BRDs) based on client requirements
  • Collaborated with the analytics team to generate actionable insights and recommendations for optimized campaign outcomes. Helping my team, troubleshooting errors if any in the reports prepared
  • Developed dashboards and visualizations from scratch to display data in an intuitive and meaningful way in Datorama.
  • Acted as a primary point of contact for clients, efficiently addressing inquiries and resolving issues through Hive ticketing system.
  • Provided ongoing support to clients, troubleshooting errors in reports and offering proactive solutions.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Partnered with IT teams to ensure seamless integration between databases and analytical tools, maximizing system efficiency across departments.
  • Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
  • Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms. Generated ad-hoc reports to evaluate specific business requirements.

Project Engineer

JLL, Jones Lang LaSalle Pvt Ltd
08.2022 - 09.2023

Collaborated with Subject Matter Experts and Product Owners to define data requirements and source-to-target mapping necessary to support advanced analytics initiatives within

  • Real-estate domain, including the interfaces between applications, databases, and platforms
  • Made Power BI & Excel reports more interact and activate by using storytelling features such as bookmarks, selection panels, drill through filters also create custom visualizations
  • Utilized Power BI to create various analytical dashboards that help business users to get quick insight of the data Published and maintained workspaces in Power BI Service, scheduled the time refresh for the data, maintained the apps and workbooks
  • Used DAX functions to create measures and calculated fields to analyze data for logical visualization and used Power Query to transform the data
  • Migrated the Data Tables from Excel to Power BI with better Graphs and visualizations for the understanding and improvement of business
  • Collected the Data in Excel sheets from different Regions around the country and combined them in Power BI to know the Loss, Profit, etc
  • Of the Product
  • Identified Construction supply chain problem areas and opportunities to improve service, reduce cost, and increase inventory turns
  • Performed ETL on multiple platforms such as SSIS familiarized with Confidential Legacy, SQL, and other backend environments to pull the data-to-Data Warehouse
  • Maintained SharePoint page for Lean Six Sigma using Power Queries for Plant Data and
  • Audited the different projects in the company for Discrepancies
  • Performed Queries, maintained and extracted Data from SSMS, cleaning and maintaining the
  • Production Environment in SSMS for the performance.
  • Maintained records for each project and engineering discipline.
  • Completed construction tasks while providing safe working conditions, staying on budget and meeting project deadlines. Identified technical risks within managed projects.
  • Coordinated cross-functional teams, fostering collaboration to achieve project goals.
  • Identified risks and implemented mitigation strategies, minimizing potential issues during the project lifecycle.

Project Engineer

NCC LTD
06.2021 - 08.2022
  • Develop and maintain Excel reports for specific areas or departments within the real estate and construction sector, ensuring accurate data representation
  • Acknowledged by the CEO for outstanding Excel reporting skills, leading to commendation for excellence in data analysis and reporting
  • Guided by the CEO to transition Excel reports into dynamic Power BI dashboards, enhancing data visualization and analysis capabilities
  • Drive the implementation of Power BI dashboards, streamlining data presentation processes and empowering informed decision-making
  • Assume responsibility for the upkeep and troubleshooting of Power BI dashboards, prioritizing data accuracy and integrity
  • Serve as the primary point of contact for data-related inquiries and issues, offering comprehensive support for both Excel reporting and Power BI dashboard management
  • Generate and maintain Excel reports for individual projects within the real estate and construction domain, ensuring project-specific insights and analysis
  • Continuously enhance Excel reporting proficiency, leveraging expertise to complement
  • Power BI dashboard management efforts and optimize data-driven outcomes

Education

Certification in Advance Data Science & AI - Data Science

IIT
Madras
07.2023

B.Tech - Civil Engineering

Sree Vidyanikethan Engineering College
Tirupati
06.2018

High School Diploma -

Sree Jayatri Junior College
Kadapa, India
05.2014

No Degree - Higher Secondary Education

Gurukul Vidya Peeth
Kadapa, India
03.2012

Skills

  • Visualization
  • Data and Analytics
  • SQL and Databases
  • KPI Tracking
  • Predictive modeling
  • Team Collaboration
  • Data Acquisition
  • Data Extraction
  • Data Modeling
  • Advanced Excel
  • Power BI
  • Datorama (Salesforce Marketing Cloud Intelligence)
  • DAX
  • Power Query
  • Power apps
  • SQL
  • Service now
  • SharePoint
  • Hive
  • Basics of Machine Learning
  • Basics of Natural Language Processing
  • ETL
  • Data Mining
  • Data scraping
  • Statistics
  • Data Warehousing
  • Business Intelligence
  • Python Programming

Accomplishments

  • ADVANCED DATA SCIENCE AND AI, IIT MADRAS - INTELLIPAAT
  • BIM MODELLING AND PROJECT MANAGEMENT, AUTOCAAD
  • ACCOMPLISHMENTS
  • JLL, Hyderabad
  • Wall of Fame – Reporting Specialist

Languages

English
Upper intermediate (B2)
Hindi
Intermediate (B1)
Telugu
Upper intermediate (B2)

Timeline

Senior Data Analyst

Annalect India Ltd
10.2023 - Current

Project Engineer

JLL, Jones Lang LaSalle Pvt Ltd
08.2022 - 09.2023

Project Engineer

NCC LTD
06.2021 - 08.2022

Certification in Advance Data Science & AI - Data Science

IIT

B.Tech - Civil Engineering

Sree Vidyanikethan Engineering College

High School Diploma -

Sree Jayatri Junior College

No Degree - Higher Secondary Education

Gurukul Vidya Peeth
DINESH A V