Roshan Chauhan

ROSHAN CHAUHAN - +91 - E-mail- Objective: Offering my services & skills to the organization and become an active part of its growth by unleashing my potential in dynamic environment. Profile Summary: Experience in Operation works, Team Lead, Coordination, Data Analysis, MIS Work, Summarizing and Creating reports. My experience has enhanced my analytical capabilities. Strong Knowledge of Advanced Excel functions. Skills:-. Leadership Decision-Making Business Negotiation People Management Data Processing Skills Reporting Skills Problem Solving skills Deadline-Oriented Planning and Organisation Communication Skills Delegation Team Work Adaptability Stress Tolerance Employment History: 1. UPDATOR SERVICES PVT LTD (2019 TO TILL DATE) Assistant Manager Ops Updater Services (P) Limited (UDS) is India's premier and largest Integrated Facilities Management and Business Support Services company with a strong workforce of 40000 spread across the country in excess of 150 million sq ft of space with a strong branch network. UDS services are- Property Management Service, Integrated Facilities Management Services, Hard Services, Soft Services, Business Support Services, Production Support Services, Specialized Services and Security Services. Roles and Responsibilities: S.No 1. Client Name Sony India Pvt. Ltd Role and Responsibilities 1. We provide MST Technician services in PAN India Sony. 2.To Completely take care of Services for PAN India entire North, East, West, South location including Sony Head office 3. Sony Head office in Sarita Vihar has deployed 16 manpower along with Facility manager and 3 supervisors. 4. Direct coordination with client on daily basis. 5. All issues to be sorted out is under my role and responsibilities like MST report and services, Invoices, Manpower reporting, facility manager and MST report to me in terms of Sony visit services. 6. Monthly review meeting is under my role and responsibilities. 7. PAN India MST services are on basis of UDS application Taskman and this is controlled by me for all locations. 8. R&M activity services locked by client have to be sorted by me. 2. IndoStar Capital Finance Ltd 1. 2. 3. 4. 5. 6. 3. India Infoline Finance Services pvt. Ltd 1. 2. 3. 4. 4. Additional Role – Sanitization services 1. 2. 3. 4. 5. Coordination with client and operations team Manpower deployment as per the requirement Daily manpower report sends to client Material delivery challan and pest control DC will be forward to billing team and cross verified KYC updation and coordination with payroll team Invoices submissions follow up Coordination with the Admin team for day to day work Material to be deliver in every month. Invoices submission to client. Manpower Costing approval and Updation follow up between client and SAP team Collection of the attendance with respective location and get the approval from client side Coordination with Vendor and Client for sanitization service. Collect vendor invoices with supporting documents and submit to billing team for payment follow-up. Preparing the MIS for Sanitization services. Providing the PO to vendor. After completion of work collect the DC and completion certificate from client side. 2. GUNNEBO PVT LTD (2018 to 2019) Credit Analyst Gunnebo is a global leader in security products, services and solutions with an offering covering cash handling, safes and vaults, entrance security and electronic security for banks, retail, mass transit, public & commercial buildings and industrial & high-risk sites. Roles and Responsibilities:  Fetch the client data from Pronto software with the coding of SQL.  Taking care of Adhocs requests from Entire Asia-Pacific  Order the parts to our Technician on daily basis as per site requirements.  Daily follow up with the clients for payments.  Process of Invoicing on daily basis.  Maintained the parts stock in advance. 3. GREAT VALUE PROJECT INDIA LTD, NOIDA (2016 to 2017) GreatValue India is diversified into quality plastic and packaging products, food division and Real Estate with their commercial and residential development. Sr. Reporting Analyst & MIS Roles and Responsibilities:           4. Part of team for implementation of ERP Software across varied verticals of the company. Acted as interface for data compilation in ERP between Marketing, CRM, Projects, Purchase, Logistic and HR. Closely worked with Director – Projects for developing project data into customised form and reports. Develop formats and reports from ERP which were running in old application. Writing SQL queries to mine/extract data for the purpose of report-making. Coordinate with Planning and Billing department for customizes reports on everyday basis. Handling all the MIS reports for Senior Management. Responsible for Modification and revision of report Using Microsoft Power Point/Excel/Graph. Maintain daily & open communication with the team relating to the data analysis. Provide training for MS-Excel and ERP to required teams. ACCOR PLUS, GURGAON (August 2008– June 2016) Accor Plus is a wholly owned subsidiary of Accor Group and a flagship entity for marketing and selling of executive loyalty subscription for Accor Hotels in Asia Pacific region” Accor” is the largest and fastest growing hotel group in the Asia Pacific region, with over 350 hotels in 17 countries and comprises of brands like Sofitel, Pullman, Novotel, Grand Mercure, Sebel, Mercure, Ibis and Ibis Styles. Data Analyst and IT Roles and Responsibilities:  Expertise in writing SQL queries, SQL Server 2005/2008  Expertise in creating queries, stored procedures, cursors.  Knowledge of SSRS tasks(Report Creation)  Strong Knowledge of Advanced Excel functions (like Look-ups, Pivot Tables, Index etc.)  Design and Modification of report Using Microsoft Power Point.  Daily basis interact with client and provide the reports as per their requirements.  Taking care of Adhoc requests from Entire Asia-Pacific. Managerial Support     Back office Works - Office Filing, Maintained records for the members of new joinee’s and existing staff. Entered Employees Daily Activity and Working Hours into the Database. Reconciled Monthly Sales Revenue with Sr. Manager - (Finance) for all offices. Grew a five-person team. Technical Skills: SOFTWARE : O/Systems : LANGUAGES : DATABASES : Allmark, SQL, ERP, Ms-Access, Advance Excel, Ms-Office, Power Point MS/DOS, Win98,WIN7, WINXP HTML/SQL/SSRS SQL Server-R2, MS-SQL, ERP,MS-Access Major Accomplishments/Milestones:     Joined as an Data Executive and promoted from to “Administrator” within a year of service(Company : Accor Plus) Promoted from Administrator to “Data Analyst” within a span of 3 years because of my exceptional performance (Company : Accor Plus) Has been awarded for “completed 5 years in Accor Plus” for showing great commitment towards organization even during times of recession (Company : Accor Plus) Joined as an Assistance Manager-Ops and promoted from to “Key Account Manager” within a year of service(Company: Updater Services Pvt. Ltd) Professional/ Educational Qualifications:     Computer Science with A grade From Pacific Institute of Engineering and Management (Year – 2008) Certificate in Computing from Indira Gandhi National Open University(IGNOU-YEAR 2008) Certificate in participation in Volunteering, New Delhi Certificate in MS-Office from Millennium Information Technology Zone(MITZ), Defence Colony, New Delhi.(Year 2004) Personal Details: Name Date of Birth Father’s Name Marital Status Languages Known Permanent Address : : : : : : Roshan Chauhan 23rd October1986 Sh. J P Chauhan Married English, Hindi House No 99/100 Rajpur Khurd Extension, Chatterpur, New Delhi-74 Reference- On request (Roshan Chauhan)