Macros Jobs in Chennai

VB Macros expert

Mandatory Skills :

• Should have Expertise in VBA skills (Ability to create complex forms/functions/subroutines, Experience using constants and visibility modifiers, Programmatic manipulation of objects/tables/data connections/formulas/loop)

• Experience with consolidating extracted data from multiple resources using automated tools (excel, VBA macro, SQL database), and/or from different system/tools/Database

• Expertise in building complex VBA scripts to automate Excel spreadsheet processes.
  
  

Location : Chennai

Timings : UK shift

About Klenty

Klenty is a Software Product company operating in the Sales Engagement category.

One of the fastest growing SAAS startups in the sales engagement space, Klenty is headquartered in California and operates from Chennai, India.

Klenty’s Sales Engagement Product helps thousands of sales teams automate all the repetitive activities involved in the sales process like sending emails, follow-ups, tracking engagement metrics, etc - so that the sales team can focus more on activities like building relationships and closing deals.

With over 3000 customers all over the world, we are on a mission to transform every B2B Sales team into an unstoppable force

Join us in building the future of sales engagement software

Roles & Responsibilities

1. Ensure that the application doesn’t misbehave under changing user load and that no bugs or errors reach the end-users.

2. Understands and analyze performance test requirements - Develops performance test script suite and Executes tests —> Captures —> Analyzes results.

3. Conduct system performance testing to ensure system reliability, capacity and scalability and reports performance test progress & defects.

4. Maintains performance script repository.

5. Writing test scripts of various test phases like integration, regression, system.

6. Analyzing users stories / Use cases / requirements for validity and feasibility.

7. Interact with SMEs & Business to gather PT/PE requirements.

8. Identifying tools and techniques to improve testing quality and efficiency.

9. Raise issues or concerns to the stakeholders upfront and if required come up with mitigation plan.

10. Collect all metrics (Client Side, Server Side, DB, Network and Load Balancer) and analyse the performance metrics and bottlenecks to suggest corrective actions.

11. Design and create benchmark scenarios and prepare performance benchmark documents.

12. Prepare test summary reports for management review.

13. Collaborate closely with other team members and departments and assist in other performance engineering activities as needed.

Seniority Level - Entry level

Industry - Information Technology & Services

Employment Type - Full-time

Job Functions - Product Development

Employment Type - Full-time

Experience creating PowerPoint slide decks and along with that experience in automating the PowerPoint slide creation using excel VBA Formats extracted data based on expected report output with batching capability and multiple data formatting requirements Consolidate and combine extracted data from multiple resources using automated tools excel, VBA macro, SQL database, and/or from different system/tools/Database in one single database using SQL queries to standardize data structure

Professional Attributes :
Gathers and analyse report requirements from stakeholders Identify the processing tool Excel / SQL and provide a robust solution which can be easily leveraged or extended to other domains Building complex VBA scripts to automate Excel spreadsheet processes