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
Specialist Print Production at OMNICOM MEDIA GROUP INDIA PVT. LTD. (Annalect India)Specialist Print Production at OMNICOM MEDIA GROUP INDIA PVT. LTD. (Annalect India)