Sourabh Pandey

CURRICULUM VITAE Sourabh Pandey Address: 10-B, Pocket-6, MIG Flats, Mayur Vihar Phase-3, New Delhi-110096 Mob: - Mail--- Objective To contribute as a significant value addition to an organization that offers an opportunity for progression. Profile ➢ Competent and diligent professional with nearly 4 years of Reporting. ➢ Proficiency in Visual Basic for Applications (VBA), with experience developing automated reporting from multiple data sources. ➢ Data Mining and scientific computing using excel and macros. ➢ Develop VBA programs to automatically update excel, export data and prepare reports. ➢ Seasoned professional, with ability to handle multiple functions and activities in high pressure environments. ➢ Dynamic professional with hands on expertise in MS office 365 (Excel/ Word/ Power Point). ➢ Pragmatic and abilities to withstand work pressures, deliver assignments within specified time frame without compromising on quality benchmarks. . PROFESSIONAL EXPERIENCE: Overall Experience of 8+ Years. ❖ Currently working with Mothersonsumi Infotech & Design Ltd. as a Senior Executive from Sep 2013 – Till Date. ❖ Worked with P.K. Narula & Co. as an Accounts Assistant from July 2012 – August 2013. Experience Mothersonsumi Infotech & Design Ltd. Role & Responsibilities ➢ RPA (Robotic Process Automation) I was one of the persons who have introduced the RPA in the company for the first time. I Play a prominent role in the RPA and act as an intermediary between the client who needs to automize a particular process and developers who actually create a robot. • Analyze business processes, identify automation opportunities, define RPA value proposition, reengineer process to improve automation potential and recommend RPA approach/strategy. • • • • Develop Detail As Is Process Description – PDD (Process Description Document), Detail To Be Automated Process Description – SDD (Solution Design Document). Also responsible for quality assurance, and also have to create test cases and scenarios. During Stabilize & Improvement stages, compare the expected results to the actual ones. Coordinating of the handover of the project document to the client and ensuring all the Change management procedures are followed. ➢ VBA/ MS Excel (O365) • • • • • • • • • • • Knowledge in specific data base/reporting work experience or any other involvement in commercial type of reporting Develop dashboards in Excel using Pivot Tables, Power Pivot. Automation of tasks using macros and Excel packages. Support and development of data processing systems using Excel. Create and update automated scripts for graphs, charts, and data tables on a weekly, monthly and quarterly basis. Developed VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries and linked the based module to enable automatic updates for excel workbooks. Designed Dashboard in excel. Converted Excel formulas into VBA code including VLOOKUP HLOOKUP. Developed macros for financial reports, Credit Management Report, Debtors Report, Inventory Report, Ageing Reports, Scrap Report and Dashboards. Data Validation in Excel, created forms for data entry while using data validation. Prepare VBA code to send n numbers of mail. Prepare VBA code to create n numbers of customer template information template. ➢ Data Mining • • • • Collected, cleansed and provided modeling and analyses of structured and unstructured data used for major business initiatives. Providing expertise in data storage structures, data mining, and data cleansing Takeout the required details from unstructured data using excel tricks. Developed macros for data automation and daily data mining for reports and other processes. ➢ Company Credit Management and Collection Process • • • • • Identifies ways to streamline and/or improve work processes. Prepare data of overdue customers on daily basis through macro. Identifying top overdue customers and follow up with them. For this I have prepared the macro which prepare data of overdue customers on individual basis and sent mail to all overdue customers with attachment. Maintaining the daily and response received from the customers. Prepare weekly and monthly Dashboard that shows the Total outstanding and overdue trend of company credit. ➢ ➢ ➢ ➢ ➢ ➢ ➢ ➢ ➢ Preparing MIS, Dashboards and PPTs. Quality Circle Control Report and Global Quality Report. Day 7 Report: Prepare to calculate Profit/Loss of the Company. Group Charges Report: Prepare to raise the charges for their services to their group company. Time Tracker Report: Prepare to calculate the working hours of employees in a particular plant and project. Cost Allocation & Invoicing: Calculate the cost of services provide to their group company and raise the invoices to them. AR/AP Report: Prepare to calculate the Payable and Receivable of the company. Weekly Net Debt Report: Prepare to maintain the weekly Bank Balance and liability of the company. Working on SOPs and updating the same for improving pain areas. Achievements: ➢ Visit to Germany for Process training and Report’s improvement. ➢ Achieved Star Performer of the year 2014-15 for maintaining the quality of the reports. ➢ Achieved Star Performer of the year 2016-17 for maintaining the quality of the work, client satisfaction with zero error and delivery the work before the dead line. ➢ Achieved Innovative Project in the year 2018 for developing the RPA (Robotic Process Automation). P.K. Narula & Co. ➢ ➢ ➢ ➢ ➢ ➢ ➢ ➢ Role & Responsibilities Maintaining the accounts of the company under the supervision of Director. Interaction with clients for accounts payable and receivables. Prepare day to day entries in Tally for daily vouchers and Create bills to be sent to parties. Bank reconciliations, Party account reconciliations. Handling over final trial balances of the company. Taking care of payment received and making timely payments to parties, issuing cheque and cash. Process the salary of employees. Taking care of VAT/CST payments and making timely deposit of tax. Achievements: ➢ Rewarded as best employee of the month twice. EDUCATIONAL & PROFESSIONAL CREDENTIALS ➢ ➢ ➢ ➢ MBA in Finance,-, IMT Ghaziabad. Bachelor of Commerce, 2012, Delhi University. Passed 12th, 2009, CBSE Board. Passed 10th, 2007, CBSE Board. Computer Proficiency ➢ ➢ ➢ ➢ ➢ ➢ ➢ Certificate Course in VBA (Visual Basic of Applications). Diploma in Finance & Accounts from NIIT. Course in Advance Excel. Course in Tally.ERP.9 Expertise in MS Excel/ Power Point/ MS Word. Worked on Tally.ERP.9 software’s. Hands on experience to work on QAD and SAP. Personal Details: Date of Birth: 19th August, 1991 Marital Status: Married Language Proficiency: English & Hindi Passport: On request