Lakshminarayana MALLI
Bengaluru,KA
Summary
Highly driven and self-motivated postgraduate with a passion to connect data and business. Ability to understand both business and software requirements makes me an efficient technical professional. Prior experiences include performing exploratory analysis and generating visually appealing reports using business related data.
Overview
17
17
years of professional experience
Work History
Sr Data ANALYST
VIRYA LOGISTICS AND TECHNOLOGIES PVT LTD
09.2023 - Current
- Hands-on experience in using SQL and macro's scripts fetching the data on different sources
- Using Power BI (Desktop and Service) Develop the dashboards with different data sources
- Partner wise billing Qty and Revenue tracking and monitoring category wise sales target vs Achievement and Month on month Growth
- Analyze Sales Revenue and Invoice tracker Revenue Matching data
- Analyze Customer level and Vendor performance
- Quarterly and Monthly reconciliation Clients to resolve the finance related Queries
- Prepare AD HOC Reports for Management to take strategic decisions.
Sales Operation Manager
Lenovo India Pvt Ltd
08.2022 - 09.2023
- Experience in Developing and design Water fall trend and Partner Level Performance Dashboards, Business review Scorecards, Market Trend Metrics Hands-on experience in using SQL and macro's scripts fetching the data on different sources
- Using Power BI (Desktop and Service) Develop the dashboards with different data sources
- Partner wise billing Qty and Revenue tracking and monitoring category wise sales target vs Achievement and Month on month Growth
- Analyze PC sales data (internal & market) to understand the company approach as compared to market
- Works on GFK data to get the market view and help in to build the strategy and plan to gain the market share
- Quarterly and Monthly reconciliation with Distributors & Business Partners to resolve the finance related Queries
- Prepare AD HOC Reports for Management to take strategic decisions.
Data Analyst
Shadow fax Technologies
03.2019 - 06.2022
- Develop inventory optimization solutions to determine multi-echelon inventory levels and placement across client fulfilment network balancing inventory targets and customer service expectations
- Collaborate with teams (Operations, Retail, Finance Systems) and external partners to define business requirements and design scalable technology solutions
- Worked ad-hoc reports pertaining to sales information for all levels of management for verticals like Ecommerce and Food, Grocery and Pharma along with the hands-on experience on Profit and Loss Designed and developed the reports according to the requirements using Excel, Power Pivot, Power BI Responsible for automation of all kinds of analytical and reports using SQL, thereby increasing the accuracy and efficiency
- Worked on Payout Analysis, Designed and Configured Payout structure, Cost per Order (CPO) Cost margin (CM), Gross Margin (GM) Analysis of Various Clients / stakeholders Worked on Projects like B2B Client, APIs and Integration with Click post, Seller Codes for high volume sellers to optimize delivery, configuration and allocation logic for reverse shipments
- Implemented planning and in supply chain, consulting, financial planning and analysis, or related field.
Mis Executive
Genesis Infocom Pvt Ltd (SAB Miller India Pvt Ltd)
06.2014 - 02.2019
- Preparing Weekly Tracking reports / Monthly dashboard reports and internal management reports Stock availability analyzing in outlets wise by All India and Brand wise sales growth in pie chart and PPT and Preparing Route Journey plan compliance and usage, call age reports
- Weekly Preparing Channel wise contribution & growth and Industry share reports.
Officer
Karvy Computershare Pvt ltd
05.2013 - 05.2014
- Sending Daily Activity Reports to Desk Manager Final Data Confirmation to the Branches Taking care of redemption all investor documents in online.
Computer Operator
Agri Gold Farm Estates India Pvt Ltd
06.2007 - 05.2013
- I take the responsibility of updating files, producing reports
- Sending Daily activity reports to Desk Manager Generating MIS reports.
Education
Master of business administration - banking and finance
Alagappa university
01.2011
commerce -
Bachelor of Degree
01.2007
Skills
- Advanced Analytics
- Advanced Excel
- ETL Processes
- Gap Analysis
- Business Process Mapping
- Data Mapping
- Data Modeling
- Data Compiling
- Operational Modelling
- Geographic Trend Tracking
- Operations Analysis
- Business Analysis
- Data Synthesizing
- Variance Analysis
- Competitive Analysis
- SQL and Databases
- Data and Analytics
Accomplishments
Technically skilled and professionally talented postgraduate with nearly 15+ years of experience in data analysis and reporting and as Data analyst. Experience in performing sales and profitability analysis, repair/defects analysis, customer analysis. Payout Design, Resolving Payout Discrepancy, Client debit analysis in P&L Expert in performing in-depth analysis on the business-related data using Advanced Excel, PowerPivot Hands-on experience is using advanced excel features like pivot tables, complex functions, charts…etc Programming Languages: SQL, Basic Python, Basic VBA. Analytical and Reporting Tool: Advanced MS Excel, PowerPivot, Periscope, My SQL Workbench Databases: MySQL, MySQL Server, PostgreSQL, MS Access. BI Tool: Sisense, Power BI, ZOHO Analytics, QlikView ETL Tool: Power Query Cloud Service - Power BI service, Bitbucket Integration Tool: Jenkins
Additional Information
DECLARATION I hereby declare that the above particulars written are true to the best of knowledge & belief. Place: Date
Languages
English
Hindi
Telugu
Kannada
Timeline
Sr Data ANALYST
VIRYA LOGISTICS AND TECHNOLOGIES PVT LTD
09.2023 - Current
Sales Operation Manager
Lenovo India Pvt Ltd
08.2022 - 09.2023
Data Analyst
Shadow fax Technologies
03.2019 - 06.2022
Mis Executive
Genesis Infocom Pvt Ltd (SAB Miller India Pvt Ltd)
06.2014 - 02.2019
Officer
Karvy Computershare Pvt ltd
05.2013 - 05.2014
Computer Operator
Agri Gold Farm Estates India Pvt Ltd
06.2007 - 05.2013
Master of business administration - banking and finance
Alagappa university
commerce -
Bachelor of Degree
Similar Profiles
Prakash DesaiPrakash Desai
Operations at Agraga - Virya Logistics Technologies Private LimitedOperations at Agraga - Virya Logistics Technologies Private Limited
PARVEZ HUSSAINPARVEZ HUSSAIN
Business Development Manager at Virya logistics PVT LTDBusiness Development Manager at Virya logistics PVT LTD
Arijit DasArijit Das
Senior Executive at Creativity At Best Technologies Pvt. Ltd.(CABT Logistics)Senior Executive at Creativity At Best Technologies Pvt. Ltd.(CABT Logistics)
Neha DasguptaNeha Dasgupta
Team Lead – Inside Sales & Growth Strategy at LivspaceTeam Lead – Inside Sales & Growth Strategy at Livspace
ANUSHA VIJAY SHETANUSHA VIJAY SHET
Financial Treasury Analyst at Goldman SachsFinancial Treasury Analyst at Goldman Sachs