BALAJI

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.