Prabhat Ranjan Email & Phone Number

Hyderabad, Telangana, India

Location intelligence, geospatial analysis, mapping and visualization, customer behaviour, route optimization, customer segmentstion

Mumbai Area, India

Mumbai Area, India

• Creating different types of MIS and reports for management • Designing end to end reporting System in Excel and Access environment.• Automation of reports with help of Macro and VBA.• Developed multiple excel based tool for data collection and analysis.• Good understanding of ADO and connection string between excel, access and SQL• Data analysis based on 5why methodology and fishbone methodology• Writing Complex quires and function for interpretation and analysis purpose in Access• Creating Excel Based Macro as per requirement.• Maintaining Access and mysql database with help of SQL queries

• Develop multiple inhouse excel and access based tools for efficient data storage and reporting purpose.• Automation of reports with help of Macro and VBA.• Handling data in access database• with help of SQL queries• Developed World Kitchen and Cisco clients inventory management system and other excel based application with combination of excel and access.• Preparing Daily Alignment report, Visibility report and various warehouse operation based report.• Gathering data from various clients and analyzing the data• Keeping track of all inbound, Outbound and VOS activity of 4 warehouses• To coordinate with Warehouse Operations team and updating of dashboards and reports

Mumbai Area, India

• Monthly Collection of VTM result data from 23 circles & preparing report for compliances.• Publishing Circle wise CAF reverification reort• Circle wise CAF submission report .• Regionwise,HubWise CircleWise Report for penalty received from DoT & Co-ordination with circle for contest with DoT.• Circle wise rejection reason analysis of CAF rejected by VTM . Pre-Post analysis of rejection and find out curable and non-curable CAFs.• Taking care of VTM suspension/unsuspension of MDN for all circles.• Preparing MVR for management.• Preparing RCA and Action Plan.• Maintaing database in MS-Access. Writing SQL quries for data extraction, updation.• Writing VBA module and macros in excel for extract report in short time period