Dinesh A V

• Connected to 11 Social Ads Platform APIs for automated data extraction in CSV format and also pulling data manually from Programmatic advertising platforms UI
• Loaded and analyzed data in Datorama, creating and refining KPI-focused interactive dashboards
• Validated data accuracy by cleaning in Excel and developed enhanced reports in Power BI using Power Query and DAX
• Automated report distribution to management using Power Automate
• Implemented and maintained robust data system architecture, ensuring accurate taxonomy and classifications across multiple systems
• Functioned as primary client contact, addressing inquiries and resolving issues promptly to maintain high client satisfaction through Hive ticketing system
• Preparing SOP's, BRD's as per Stakeholder requirements

Key Achievements:

• Improved data visibility and actionable insights by 20% with optimized Datorama dashboards
• Increased reporting accuracy by 15% with advanced Power BI analysis and enhancements
• Boosted report accessibility by 30% through automated distribution with Power Automate

Tools Used: DATORAMA (Salesforce MCI), Excel, VBA & Macros, HIVE, Power Query, Power BI, Office 365, Share Point, Power Automate

Project-1: Data Management and Reporting

• Extracted and cleaned operational data from SharePoint; appended data and refreshed Excel reports to maintain accuracy and timeliness
• Identified and resolved data integrity issues by streamlining data formats in collaboration with clients and internal stakeholders
• Reduced report generation time by 2 days through optimized data processing and workflow improvements
• Prepared detailed reports for ad-hoc requests, ensuring prompt and precise information delivery to stakeholders

Project-2: ETL and Dashboard Development

• Managed SSIS ETL flows for HR data, resolved errors, and ensured accurate data population in SQL databases
• Connected to the SQL Database and also SSAS tabular model to Power BI
• Wrote SQL queries to check for data quality
• Developed interactive dashboards in Power BI using Power Query for data transformation and DAX functions for advanced analytics
• Published Power BI reports to the Power BI service, maintained the app and associated gateways to ensure consistent and secure data access
• Conducted sentiment analysis using Python to extract actionable insights from HR data, supporting data-driven decision-making

Key Achievements:

• Automated data processes, reducing manual tasks by 50% and increasing reporting efficiency
• Enhanced Data Integrity by identifying and resolving data integrity issues by collaborating with clients and stakeholders, resulting in more reliable and accurate reports
• Played a key role in integrating Power BI with existing systems, improving data accessibility and analysis

Tools Used: Power BI, DAX, Python, SQL, SSIS, Excel, VBA & Macros, Power Query, Office 365, Share Point

• Integrated operational data from SharePoint into Excel for enhanced data management and accuracy, ensuring adherence to SLA standards
• Created and maintained Power BI and Excel reports (daily, weekly, monthly), troubleshooting issues to meet SLA-defined response and resolution times
• Developed custom ad-hoc reports and KPI-focused dashboards in Excel and Power BI based on stakeholder requests
• Leveraged DAX formulas, Power Query, and advanced Excel functions (e.g., VLOOKUP, XLOOKUP, PivotTables) for dynamic data analysis and visualization
• Collaborated on BRDs and FRDs with stakeholders, aligning reports with business and SLA requirements

Achievements:

• Using Macros, automated report generation, reducing manual effort by 50% and boosting data accuracy
• Skilled in crafting impactful visual representations, including bar charts and histograms, both in Excel and PowerPoint, enhancing data-driven presentations
• Adept at developing KPI-focused dashboards in Excel, providing clear insights into key performance indicators for informed decision-making

Tools Used: Power BI, DAX, Excel, VBA & Macros, Power Query, Office 365, Share Point

• Hands on every single activity of both finishing and structure including critical works for 2 different residential projects from start to hand over
• Independently following up with Design project heads (Architecture, Structural, MEP, HVAC) for drawing changes etc. as per site requirements
• Looking after construction activities, making requisition and arranging man, materials and machineries for completion of work
• Execution of Civil, Interior and Exterior ground finishing works and site supervision
• Maintained Stakeholder running Quantities & Bills and Handling the workforce management and Quality of the day to day works.