Ajay Kumar

AJAY KUMAR CAREER OBJECTIVE To combine my skills, experience and education in a responsible and challenging position with a professional organization offering continues learning and opportunities to excel the career with the growth of the organization. PROFESSIONAL EXPERIENCE 1- Worked as Data Analyst /EA (Business Analyses Department) in Gopaljee Ananda Dairy Foods Pvt Ltd. Noida Since June’19 to May 2020 RESPONSIBILTIES IN Gopaljee Ananda Dairy : - Managing all sales data and report to Business Head and Director Creating Daily , Weekly , Monthly , MTD and YTD sales & Revenue Dashboards for Product ,SKU wise, Region wise and Plant wise as well Coordination with the Sales Employees on regular basis and help them for any queries In CRM Like Application , Performance and Incentive Conducting and Presenting Monthly Sales Review Meeting with Directors business and Region Heads and showing and comparing their sales reports (performance) with last Months and Last year as well Organizing meetings and handling external calls for service Taking MoM & follow ups of it , Handing correspondence directed by business head and producing reports & presentations for CMD PROFESSIONAL EXPERIENCE 2- Worked as a Program Coordinator in CPM INDIA sales and marketing Pvt Ltd. Ohkla New delhi from October to June’19 in a PepsiCo Project. (MT Food & Beverages) RESPONSIBILTIES IN CPM India : - Creating weekly , Monthly and Quarterly National dashboard for Modern Trade like Key Account Wise , region wise and city wise as well in behalf of CE, Supervisors and merchandisers performance Creating weekly Visibility report and PPT for our products and POSM and competitors as well share with PepsiCo clients To be create and manage PJP (Proposal Journey Plan ) for the Merchandisers , supervisors and Promoters on Monthly basis To manage attendants for merchandisers, Promoters and supervisors in PAN India level and calculate their salary and incentives in behalf of their coverage Always create & Circulate offers (Promotions ) in Key Account (Stores ) wise in national level Manage Expenses of the sales supervisors and resolve all the issues which is raised from field side. 3- Worked with M&C Saatchi Mobile, 141 Shahpur Jat, Siri Fort, New Delhi as Reporting Executive From June 2017 to October 2018. RESPONSIBILTIES IN M&C Saatchi: - Working in coordination with higher management for process improvements Generating fraud reports and business profit and loss summary by their ( Click, Installs, Frauds and events) and conducting Ad hoc fraud analysis for clients Managing the top worlds online shopping companies data like ( Google, facebook, Amazon Shopping, Ajio, Swiggy, Redmart, Phonepe, Hotstar etc) Creating dashboard for new reports Managing & guiding team in their deliverables and delivered trainings if needed Automation, where required Updated & Maintained the company dashboard to ensure that the real time data being viewed by our clients was accurate 4- Worked with EXL Service SEZ BPO Solution Pvt. Ltd. as a Senior Executive (MIS) from April 19, 2009 to June 2017. RESPONSIBILTIES IN EXL SERVICE: - Analyze and understand client requests Coordinate the work of the various project participants Develops MIS documentation to allow for smooth operations and easy system maintenance. Generate both periodic and ad hoc reports as needed. Analyze business information to identify process improvements for increasing business efficiency and effectiveness Work on TAT Report, Variance report, attendance and Attrition report to share with client Preparing snapshot – containing Details of Daily & MTD wise e.g. – Total Login hrs. Time, AHT, Quality Creating all the reports (Daily / Weekly / Monthly) and also helping other Support functions in the organization for generating reports. Skills Microsoft Excel: - Advanced Formulas, Excel Shortcut Keys, Tables & Formatting, Advanced Charting, Pivot Tables & Pivot Reporting, Integrating Excel with other tools & Optimizing Excel, Data Crunching, Dashboarding, Data Modeling, Data Visualization using Power view, Power pivot, Slicers & Timelines SQL (Basics): -Basic SQL Queries, Select Queries, Functions (Lower, Upper, Length, Concatenate Insert, Replace, Sum, Average, Max, Min, Number, Conversion, Group By, Order By, Primary Key, Referential Integrity, Joins) Qlik Sense : - Data visualization Education Qualification: - Graduation from Kanpur University 12th Passed from U.P. Board 10th Passed from U.P. Board Personal Details. Date of birth: 5th July 1982 Father’s name : Ahibaran Singh Yadav Marital status : married Languages known : English & Hindi Hobbies : Interacting with people, net surfing Date: (Ajay Kumar)