Highly adaptable application support engineer with total 12 years of experience in IT sector and relevant 10 years of experience in Dynamics ERP application. Having strong knowledge in MS Dynamics AX 2009, Dynamics AX 2012 R3, Dynamics 365. Experience of working in an ERP facilitated environment on Financial and Production modules and SQL server administration. High Quality knowledge of Microsoft Dynamics Ax functionality, features, configuration and implementations like FDD. Having strong experience in Microsoft Power Platform. Ability to interpret customer needs and customize the modules. Proficiency and expertise in SQL server replication, backup and recovery. Technical experience in D365 Systems Administration and Configuration.
Overview
12
12
years of professional experience
1
1
Certification
Work History
ERP Support Specialist
RPM Performance Coatings Group
Coimbatore
04.2022 - Current
Managed a variety of everyday tasks, including database backups and restorations, maintenance jobs and requests from developers.
Deliver services and solutions using the Power platform suite with Azure integrations, Microsoft Power apps, Power automate and Dynamics 365.
Performed Log shipping and implemented replication as high availability techniques.
Experience in administration and development of reports on Power BI.
Manage environments, configurations, security, Integrations and Deployments.
Development of automated notification when SQL server Backups and schedule maintained jobs.
Setup Microsoft Flow in Power Automate to provide auto approval and status update features based on predefined criteria.
Performing diagnostic tests and resolving issues to optimize performance.
Setup multiple nodes (Active/Passive) in SQL servers to add clustering feature.
Frequently monitor connections, locks and database performance.
Provides user support for incidents escalated from the helpdesk and resolve system / application issues.
Built and deploy a complex solution with flows, apps, and entities.
Plan and modify SQL server permissions in Quarterly basis.
Managed security for sites and lists by setting up permission levels for different users and groups.
Experienced in opening bugs and enhancement requests with detailed information and follow up for speedy resolution.
Setup and configured DB mail and create jobs to send out an email whenever any SQL job fails.
Highly experienced in User creation, Role access, Customized user role creation in D365.
Increased database efficiency by 25% by performing routine performance tuning.
Scheduled backups for databases and transaction log across different environments using SQL server management studio.
Effectively used third tools for trouble shooting issues and providing ad-hoc reports to complete tasks quickly.
Technical Consultant
LIFECELL International Pvt Ltd
Chennai
11.2013 - 03.2022
Implementation of the Dynamics AX software and ensure the end users acquaintance with the software.
Developed and implemented Microsoft Dynamics AX for multiple sites and systems.
Interact with clients to comprehend their needs and note down the features required in the software and their core modules.
Handles Microsoft Dynamics Ax Installation and configuration for both client and servers.
Monitor daily backup operations and handles SQL database administration including database backup and log clearance.
Install, configure, and support Microsoft technology solutions on windows 2003 / 2008 platform hosting web and database applications, while maintaining security patches, antivirus updates, backups, monitoring and performing routine server maintenance.
Assisted in the creation and documentation of business processes and module configurations.
Suggested and implemented backup strategies which greatly increased overall productivity.
Implemented SQL Server Reporting Services (SSRS) to provide a comprehensive analysis demanded by the management, enhancing business intelligence by 35%.
Work on experience on Web services, Number sequences and SSRS reports.
Create, Modify and Delete the user accounts based upon the requirements and manage access to the user roles.
Wrote SQL Queries, modified existing reports, and designed custom reports.
Perform periodic support for capacity planning and other windows security patch updates.
Contributed to consulting team's process improvement by providing feedback on lessons learned during projects.
Suggested upgrade to the existing modules as per the changing from client requirements.
Plan the project schedules and support the management in implementing each step on time and obtain desired results.
Successfully restored and recovered 100% of critical data post server crash, ensuring no loss for the company.
Trainee Programmer
PERI Software Solutions
Chennai
03.2012 - 09.2013
According to the Client requirements, getting functionalities like Inventory Registration, developing new reports and Form Customizations.
Understanding the user support issues and rectifying the problems.
Analyzing the requirements and solving the solutions.
Keep monitoring on daily batch jobs.
Developed MS applications using access for the front end and SQL in the back end.
Analyzing and supporting tickets for the clients based on priorities like Emergency, High, Medium basis.
Giving support to customers for technical related queries.
Education
M.Sc - Software Engineering
Sathyabama University
04.2010
Skills
ERP Tools : Microsoft Dynamics AX 2009, AX 2012 R2, AX 2012 R3, Microsoft Dynamics 365
BI Tools : Microsoft Power Bi, Microsoft Power Apps, Microsoft Power Automate
Databases : SQL Server 2016, SQL Server 2019
Operating system : Windows 2016, Windows 2019, Windows Azure
Certification
Certified SQL from Skill Nation
Certified Power BI specialist from Skill Nation
Certified My SQL Basics from Great Learning
Certified Microsoft Azure Essentials from Great Learning
Accomplishments
Best contributor award for IT in Lifecell International Pvt Ltd - 2014
Best support award for IT in Lifecell International Pvt Ltd - 2015