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
VB Script
VB.6
VB Advanced Excel
Bangalore/Chennai/Hyderabad
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
Role |
Senior Developer- UI path |
Education |
B.E |
Certification |
Advanced certification in UI Path |
Experience |
4-6 years of relevant experience |
Skills |
Excel, Email, Web automation, Orchestrator, Queue management, RE framework, Automating terminal, mainframes in AS400 Automating ERP tools- SAP, JDE Dynamic coding, reusable components |
Other skills |
Exposure on SQL, API, PDF extraction, VBA and ERP tools |
Project management |
JIRA, Git hub or similar tools |