Analyst – Excel VBA - Deloitte Support Services India Private Limited
Solutions Delivery-Canada is an integral part of the Information Technology Services group. The principle focus of this organization is the development and maintenance of technology solutions that e-enable the delivery of Function and Marketplace Services and Management Information Systems.
Solutions Delivery Canada develops and maintains solutions built on varied technologies like Siebel, PeopleSoft Microsoft technologies, SAP, Hadoop, ETL, BI and Lotus Notes. Solutions Delivery Canada has various groups which provide the best of the breed solutions to the clients by following a streamlined system development methodology. Solutions Delivery Canada comprises of groups like Usability, Application Architecture, Development and Quality Assurance and Performance.
Role Specific Responsibilities / Work you’ll do
- As an Excel – VBA developer, you are responsible for implementing the excel bases solutions for the Projects.
- Should be working on complex macros and complex Excel functions to achieve the solution
- Coordinating with multiple teams and make sure the data accuracy arrived
- You would work on Reports and implement automation for reports which are of repetitive in nature.
- Ensures end solution follows the design and business processes agreements
- Designs and codes programs of moderate to high complexity
- Completes unit and integration testing for conformance to standards and adherence to design specifications
- Ensures that expected performance levels are achieved
- Creates clear, consistent, and coherent written materials.
- Liaise with other project team members to ensure alignment and quality reviews:
- Supports and assist other technical areas involved in project delivery such as QA activities and Performance Management review activities
- Communicates effectively with meaningful and articulate verbal discussions.
Work Location: Hyderabad
Shift Timings: 11 AM to 8 PM
The team
EDC Canada is the Canada CIO’s IT department which manages an end-to-end portfolio of Canada business applications and technology infrastructure that supports business processes common to Deloitte Canada member firm.
Cutting Edge Technologies: At USI DT Canada MF, you will be part of an exciting journey that will keep you ahead of the curve. Be it our innovative delivery model for agile or our Communities of Practices, we are constantly investing in leading edge technologies to give our practitioners a world class experience. We have programs and projects spanning across a multitude of technologies and always abreast on evolving technologies and emerging industry leading practices such as agile.
Application Development and Solutions Delivery: Start from Architecture and User Experience and evolve into design, develop, transform, re-platform, or custom-build systems in complex business scenarios. We manage a portfolio of enterprise scale applications and solutions used by practitioners in Canada. Offerings include Custom Development, Packaged Application Development, Application Architecture and Testing Advisory Services. Technologies include Business Analytics, Business intelligence, Cloud Development, Mobile, .Net, SharePoint, SAP HANA, Manual, Automated, and Performance testing.
Qualifications:
Essential
- A Computer Science University degree and/or equivalent work experience
- A strong commitment to professional client service excellence
- Excellent interpersonal relations and demonstrated ability to work with others effectively in teams
- Good verbal and written communications skills
- Excellent Analytical Skill
Top 5 Keywords: Excel, VBA, Macro Development, Complex macros, Reports
Technical Skills & Qualifications:
- 1 - 2 Years of experience in Excel & VBA Development.
- Strong in VBA (Visual Basic for Applications) and Excel and should have implemented multiple projects.
- Strong in advanced MS Excel and their formulae (including VLOOKUP knowledge and creating pivot tables)
- Should be able to write the complex macros.
- Expert in design and develop flows.
- Should be good in preparing the reports in Excel.
- Manage multiple data sources and ensuring data accuracy.
- Should have working knowledge on Merge and Match techniques, Invoking scripts from Excel
- University degree on computer systems or related area
- Demonstrated experience with Software Development Lifecycle methodologies.
- Passion for problem solving, reverse engineering, product defect discovery, learning new technologies and getting exposure to various software applications
- Detailed oriented with passion for technical quality and client service excellence
- Ability to build strong client and peer relationships while working in a team environment
- Structured and strong organization skills in a client facing service-oriented organization
- Strong verbal and written communications skills