2COMS Consulting Private Limited Jobs 2023 Apply Online VBA Developer_ Bangalore vacancy Jobs in Bangalore - News

Hiring VBA Developer in one of the Leading IT Brand @Bangalore !!


Our Client is a global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Interactive, Technology and Operations services



Primary Skill : VBA Developer and Macro



Work Location : Bangalore (BDC 9)

Work Timings : 11:00am to 8:30pm ( should be okay with WFO )

NP : Immediate to 15 days



Job Role:

• Analyzing the needs of internal departments and assisting staff with development
  
• Reviewing code to ensure best practices are in place
  
• Analyze complex data to develop automated reporting with VBA and Excel
  
• Create macros to work with a huge amount of data and for Excel reports
  
• Develop VBA programs to perform tasks automatically
  

Requirements

• Should have knowledge about Formula creation and should be able to develop formula dynamically
  
• Should be able to suggest multiple ways of solving problem in excel
  
• Should have knowledge of V-lookup and H-lookup (for example, should be able to apply logics in cases where only partial match of data is needed)
  
• Should have knowledge about excel functions like Pivot, Chart, custom sort, conditional formatting etc.
  
• Good to have knowledge about dynamic data source for pivot tables.
  
• Should be able to generate date value based on multiple condition like today-2, 2 nd date of last month, 3 rd last day ofnext month.
  
• Should be able to suggest multiple ways of solving problem in excel
  
• Should have knowledge about VBA macro
  

Benefits

• Monthly Fixed Salary
  
• Opportunity to work in a leading IT Brand