Report Writing and Integration Advisor
The team is completely responsible for the end-to-end development of Bespoke reports as per client requirements, developed in C#, SQL & VBA
This role is for supporting the Sage Premier & Sage300 People.
Generate and analyze reports for transformation from Sage Premier to Sage300 People.
The main responsibilities of this role are analyzing client requirements, creating reports using C#, SQL & VBA, and testing.
Preparation of Bespoke Specification document as per C#, SQL & VBA coding and maintenance of C#, SQL scripts & VBA on an ongoing basis.
Analyzing Errors or issues/ changes and fixing C#, SQL & VBA coding as per requirement.
Collaborate with the product team for faster resolution of defects.
Skill sets Required:
Expert in SQL – Data Query Language (DQL) Commands
o Conditional selects
o Multi-Table queries
o Aggregate & string functions
o Common Table Expression
o Windows Functions
Experience in C#
Experience in VBA (Excel refresh and macro reports)
Manual Testing Skills
Amend existing SQL queries for performance improvements.
Should have strong analytical, and problem-solving skills.
Should have a strong ability to deliver projects on time and with the highest quality.
Having product/process knowledge is preferable.
Having payroll knowledge is preferable
Interact with clients and understand their requirements.
Should have good communication skills to collaborate with Different teams.
Knowledge of DBMS and RDBMS concepts is desirable.
Qualification BSc (Computers) or equivalent
Min. of 3 -5 years’ development experience
Explore our COVID-19 page https:// to understand how ADP is approaching safety, travel, the hiring interview process, and more.
Diversity, Equity, Inclusion & Equal Employment Opportunity at ADP: ADP affirms that inequality is detrimental to our associates, our clients, and the communities we serve. Our goal is to impact lasting change through our actions. Together, we unite for equality and equity. ADP is committed to equal employment opportunities regardless of any protected characteristic, including race, color, genetic information, creed, national origin, religion, sex, affectional or sexual orientation, gender identity or expression, lawful alien status, ancestry, age, marital status, or protected veteran status and will not discriminate against anyone on the basis of a disability. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.
Ethics at ADP: ADP has a long, proud history of conducting business with the highest ethical standards and full compliance with all applicable laws. We also expect our people to uphold our values with the highest level of integrity and behave in a manner that fosters an honest and respectful workplace. Click https:// to learn more about ADP’s culture and our full set of values.