REF34518C - Assistant Manager - EAG, VBA Developer, Power BI, 3 to 5 yrs experience, Mumbai

Company Description

WNS (Holdings) Limited (NYSE: WNS), is a leading Business Process Management (BPM) company. We combine our deep industry knowledge with technology and analytics expertise to co-create innovative, digital-led transformational solutions with clients across 10 industries. We enable businesses in Travel, Insurance, Banking and Financial Services, Manufacturing, Retail and Consumer Packaged Goods, Shipping and Logistics, Healthcare, and Utilities to re-imagine their digital future and transform their outcomes with operational excellence.We deliver an entire spectrum of BPM services in finance and accounting, procurement, customer interaction services and human resources leveraging collaborative models that are tailored to address the unique business challenges of each client. We co-create and execute the future vision of 400+ clients with the help of our 44,000+ employees.

Job Description

Job brief

We are looking for a Seasoned VBA Excel Macro developer to automate business process steps.

You will work independently as full stack developer creating Macros from scratch, modify existing macros to suit additional requirement or change in environment / input or output formats and provide user support.

In this role, you should be able to write functional Excel Macros with a sharp eye for spotting defects. 

You should be a team player and excellent communicator.

If you are also passionate about the Macro Development with Microsoft Excel, we’d like to meet you.

Your goal will be to work with various operations teams to design, develop and maintain Excel Macros using

VBA.Responsibilities•

Participate in scoping, requirements analysis and solution design

• Collaborate with internal teams to produce software design and architecture• Write clean, scalable code using Visual Basic for Applications (VBA) languages

• Test and deploy Excel Macros. Revise, update, refactor and debug VBA code

• Develop documentation throughout the software development life cycle (SDLC)

• Update progress of assignment to all concerned stakeholders

• Highlight automation feasibility risks upfront and get buy-in from stakeholders before moving to next stepRequirements

• 3-5 years Proven experience as a Excel VBA Macro Developer

• Familiarity with the Advance Microsoft Excel Formulas

• Familiarity with the BI Tool like Power BI.

• Familiarity with Database design and development with MS Access and SQL Server

• Familiarity with SAP automation using VBA and Microsoft BI Platform would be added advantage

• Excellent troubleshooting and communication skills

• Attention to detail• BSc/BE in Computer Science, Engineering or a related field

Qualifications

BSc/BE in Computer Science, Engineering or a related field