Sandeep Kumar Sahoo Email & Phone Number

Bengaluru, KA, IN

India

Greater Bengaluru Area

• Designed and developed comprehensive reports and interactive dashboards using Power BI. Utilized Power Query for data extraction, transformation, and loading (ETL) from diverse sources including MySQL and Excel.
• Developed a sales performance dashboard, resulting in easily identifiable insights that helped increase sales revenue and reduce manpower.
• Conducted in-depth inventory analysis, utilizing advanced Excel techniques, which resulted in a notable 9% revenue growth by optimizing stock levels, minimizing overstock, identifying slow moving categories and.
• Optimized dashboard performance by implementing indexing and applying DAX functions resulting in a dynamic dashboard with decrease in load time.
• Developed logical data models based on analyzed business requirements, capturing data and relationship descriptions.
• Collaborated with the finance team to develop a financial reporting dashboard resulting in a 50% reduction in report development time.

Visakhapatnam, Andhra Pradesh, India

• Worked in the Documentation and Planning department, with excellent knowledge of advanced Excel, SQL, Power BI, and PowerPoint.
• Collected, organized, and maintained data from various sources within the organization. This includes customer information, sales data, inventory records and other relevant information.
• Created and maintained Power BI reports and published them for management daily/weekly/monthly.
• Performed modifications, edits, and deletions to the database using SQL on authorized documents.
• Developed informatic mapping utilizing various transformations such as joins, aggregate, expression, filter, and update strategy.
• Identified problematic data during the entry and comparison process.