OnBenchMark Logo

BALAJI

Senior Data Analyst
placeholder
Location Chennai
view-icon
Total Views80
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 7 Year
  • Cost
    Hourly Rate$9
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnJune 22, 2024
Key Skills
Data AnalystPower BIMS SQL Server
Summary

Project:

Project            : Ramco Aviation(Finance and Commercials)

Role                : Power BI Developer

Duration         : Mar 2018 to Aug 2020

Environment  : MS Sql Server 2012, Power BI, DAX

 

 

Description:

Ramco Aviation software is an end to end Aircraft services such as Flight safety and Maintenance, Finance operations (payables and Receivable Management), Customer, Repair and  shop work orders, Hanger maintenance, Flight parts alarms etc.

Responsibilities:

·        Creating multiple dashboards based on business requirements using Power BI chart representation.

·        Created Dax Queries to generated computed columns in Power BI.

·        Generated computed tables in Power BI by using Dax.

·        Creating Database objects – tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement.

·        Involved in creating new stored procedures and optimizing existing queries and stored procedures.

·        Designed and developed Sales & Profit Analysis report

·         Includes design & implementation of KPIs such as Current year Sales Revenue, Expenses , Profit, Customer count in CY, Gross Margin% in CY, Top ‘N’ Sales by Customer and Region, Period wise sales trend, Category wise Profit % etc.

·        Comparison between current and previous year Sales Revenue, Expenses, Gross Margin%, Profit Margin % etc

·        YTD, QTD and MTD sales comparison etc.

·        Created running totals for Customer and Supplier transactions.

 

 

Project:

Project            : Ivy_CPG_DMS (Consumer Product Goods, Distributor Management System)

Role                : Database and Reports Developer.

Duration         : August 2016 to till date

Environment  : MS Sql Server 2012, Sql Server Reporting Services.

 

Description:

This is to work completely with the Domain of FMCG(Fast Moving Consumer Goods) from the product Ivy CPG to ensure effective Distributor Management System. It is structured with complete Distributor cycle starting from high level operations to last level operations i.e., Retailers thereby ensuring that all levels to go with effective sequence of operations.

Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon