Afjal Rony

Experience

• 

  VFS Global

  May 2012 - Aug 2015

  It Support and operation

  • Capture of biometrics (fingerprints and facial) on behalf of different governments• Trouble shooting IT issues with the help of the remote IT Service Desk, as needed • Assist all student applicant for Video conference• Processing applications and data entry in the customized VFS software, including digitalization of documents.• On Demand Mobile Visa (ODMV) service. The ODMV uses the UK Visas and Immigration’s mobile Biometric Enrolment System (BES) equipment to take biometric data (finger scans and digital photograph).• User acceptance testing (UAT) is the last phase of the application software testing process that verifies whether a product or software is fit for the purpose Show less

• 

  Amazon

  May 2019 - now

  Data Analyst

  Developed a staffing tool using Excel macros (VBA) to efficiently assign daily tasks to a team of approximately 200 Associates, resulting in a significant reduction of inferred time by 60-70%.Optimized shift comparison reports by leveraging Excel VBA, formulas, and functions to incorporate hourly tracking data, expected goals, and actual goals. This enhancement improved workflow within the warehouse and facilitated better decision-making.Created visually engaging Excel tables and charts to track and analyze the daily goals of the outbound department. This visual representation provided Senior Managers with a clear understanding of the actual rate versus the target rate.Conducted thorough analysis of quality concern cases, including missing or defective products, by running SQL queries on Hubble. Identified and tracked instances of concern to minimize the amount of time products remained unaccounted for.Conducted in-depth research on defect trends to identify patterns and areas for improvement.Assisted with data collection and entry as needed to support various projects.Utilized data mining techniques and problem-solving skills to extract valuable insights and solve complex challenges.Generated charts and graphs for reporting purposes to effectively communicate data-driven insights.Skills: Time Management, Data Mining, Process Improvement, VBA Programming, Microsoft Excel, SQL, Python, Problem Solving, Communication, Analytical Skills, Data Visualization, Data Analysis, Visual Basic for Applications (VBA) Show less