سونيل كومار V V, Senior IT Officer - Application & Database

سونيل كومار V V

Senior IT Officer - Application & Database

Alshaya Enterprises

البلد
الكويت
التعليم
ماجستير,
الخبرات
16 years, 10 أشهر

مشاركة سيرتي الذاتية

حظر المستخدم


الخبرة العملية

مجموع سنوات الخبرة :16 years, 10 أشهر

Senior IT Officer - Application & Database في Alshaya Enterprises
  • الكويت - الكويت
  • أشغل هذه الوظيفة منذ مارس 2022

Microsoft Dynamics 365 F&O CRM, Power BI

Microsoft Dynamics AX Technical/Functional Consultant في The British School of Kuwait
  • الكويت - سلوى
  • ديسمبر 2016 إلى فبراير 2022

Successfully implemented Microsoft Dynamics Axapta 2012 R3 (CU 12) with Finance (GL, AR, AP, Cash & Bank, FA), Inventory. Procurement, Retail, Payroll & School Fee Collection (Customized) modules. Always adhered to the proper Project management time scale to finish the task on time.

Installed & configured AX 2012 R3, customized standard AX system using MorphX development environment. Done all the customization in AOT (Forms, Class, Macros, Workflow, and Queries) and tested properly before uploading to Live Server. Maintained security level for users by defining proper Privileges, Duties & Roles.

Integration of AX with other legacy systems using Business Connector (Online Fee Payment, Sana Commerce for AX, Mobile Applications). For Sana Commerce the Interface Customization in AX done successfully. Worked with external consultant for the setup / integration of KNET & CyberSource.

Build Analytics Report using Tableau and other standard reports in SSRS and Management Reporter.

Managed database using SQL Server, automated Backup and monitored the performance of the Server to make sure that resources fulfil the AX performance.

Created a proper structured SQL Server Database to read and update the data from the SIMS (Student Information Management System), AX, Laserfiche workflow, Mobile Applications and to do the proper update in the system. Created SQL jobs to query AD (LDAP) and insert the data to the SQL Database.

Worked closely with Finance Department to build COA and Account Structure with Advanced Rule for different Financial Dimensions hence minimized user level errors. Helped them to properly do Month end & Year end closing procedures by tracking any of the functional mistakes and suggesting the solutions. Always make sure that Ledger & Sub ledger reports match properly.

Update data using DMF & Excel Add-ins, Web Services. Created menus to help users to upload data from Excel to Purchase Order, Movement Journal & Transfer Journal.

Worked on Lasefiche Forms to make Petty Cash Request, Order Forms and workflows. Integrated the Workflow with Web services.

Created the Web Services & API to integrate AX & other applications with the mobile application (BSK ParentApp, TSK ParentApp, StaffApp, Laserfiche Public Forms, SMS Service, KNET & Credit Card Payment Gateway) and leads the project to make sure that builds are working properly.

Created Web Services to integrate the Okta SSO with other systems and managed the whole Okta SSO.

Integrated the SecurOS Video Management System (VMS), SecurOS Auto License Plate Recognition (LPR/ANPR) with other applications.

Developed a fully functional Fast Track system like student pickup system, textbook distribution by integrating SecurOS ANPR with Jscript, C# Web Service, NodeJS, SQL Server, MongoDB & Laserfiche Workflow.

Developed integration web service with Google Apps Script for Google Sheet, Google Calendar, and other external services.

Gathering requirements from each department and advising on the process required to deliver the final solution.

Breaking down system specification into its simplest elements and translating this logic into X++/C# programming language.

Testing sample datasets to check that output from the solution works as intended.

Trained end user by explaining the Business logic and the functional features. Solved all the Functional & Technical issues without any delay.

IT Manager في Kuwait Packing Materials Manufacturing Co (K.S.C)
  • الكويت - الكويت
  • سبتمبر 2014 إلى نوفمبر 2016

Manages all software development applications; handles bug/ fixes, modernization programs and schedules enhancement activities.

Serves as the Project Manager for all software development related projects; prepares and establishes budgets, priority list, risk management parameters and ensures that all deadlines and timetables are consistently met.

Successfully implemented Microsoft Dynamics Axapta 2012 in Kuwait, Dubai & Saudi Arabia adopting the complete Software Engineering strategy. Assigned duties like Implementation Co-ordination which includes Project planning, preparation of Functional Design Document, logical & functional checking of all the modules. Co-ordinate with Consultants team to make them understand the business case for needed development. Prepared user manuals & trained end user groups (Finance, Sales, Warehouse, Purchase, Production & Payroll), Customized Reports using SQL Server Reporting Services (SSRS).

Integrated Dynamics Anywhere to MS Dynamics AX 2012 as the Barcode Solution which enabled users (Production, Warehouse & Purchase) to receive and sells products by PDA devices.

Designed & successfully implemented the network architecture for the Business project like Hyper-V & Failover Clustering (Windows 2008) with SAN (IBM DS3500), SQL Mirroring, Citrix XenApp 6.5, Microsoft System Center 2012, Symantec Backup Exec 2012 & Firewall (Juniper & pfSense).

Focus RT application analysis and customized the application with external DLLs and made customized reports for the users. Supported Dubai & Saudi users using remote desktop applications.

Planning for all the service upgrade like Internet, Email Switching and evaluating based on Quality, Cost & Reliability then implements with minimum down time.

Helping management for proper business reports from the system and other technical documents for the future infrastructure planning. Advise Management objectively on where the new technology makes the difference to the business and plan the stages of project by co-ordinating the project team to meet the deadline.

Communicate with Management for all the updates, evaluates the project stages and always make sure that cost, timescales and standards meets and monitors throughout the project.

Senior ERP System Administrator في Kuwait Packing Materials Manufacturing Co (K.S.C)
  • الكويت - الكويت
  • نوفمبر 2011 إلى أغسطس 2014

Manages all software development applications; handles bug/ fixes, modernization programs and schedules enhancement activities.

Serves as the Project Manager for all software development related projects; prepares and establishes budgets, priority list, risk management parameters and ensures that all deadlines and timetables are consistently met.

Successfully implemented Microsoft Dynamics Axapta 2012 in Kuwait, Dubai & Saudi Arabia adopting the complete Software Engineering strategy. Assigned duties like Implementation Co-ordination which includes Project planning, preparation of Functional Design Document, logical & functional checking of all the modules. Co-ordinate with Consultants team to make them understand the business case for needed development. Prepared user manuals & trained end user groups (Finance, Sales, Warehouse, Purchase, Production & Payroll), Customized Reports using SQL Server Reporting Services (SSRS).

Integrated Dynamics Anywhere to MS Dynamics AX 2012 as the Barcode Solution which enabled users (Production, Warehouse & Purchase) to receive and sells products by PDA devices.

Designed & successfully implemented the network architecture for the Business project like Hyper-V & Failover Clustering (Windows 2008) with SAN (IBM DS3500), SQL Mirroring, Citrix XenApp 6.5, Microsoft System Center 2012, Symantec Backup Exec 2012 & Firewall (Juniper & pfSense).

Focus RT application analysis and customized the application with external DLLs and made customized reports for the users. Supported Dubai & Saudi users using remote desktop applications.

Planning for all the service upgrade like Internet, Email Switching and evaluating based on Quality, Cost & Reliability then implements with minimum down time.

Helping management for proper business reports from the system and other technical documents for the future infrastructure planning. Advise Management objectively on where the new technology makes the difference to the business and plan the stages of project by co-ordinating the project team to meet the deadline.

Communicate with Management for all the updates, evaluates the project stages and always make sure that cost, timescales and standards meets and monitors throughout the project.

Software Engineer في Alghanim Enterprise Solutions
  • الكويت - حولي
  • فبراير 2011 إلى يوليو 2011

Web Application, Desktop and Client/Server Application using VB.NET, VB6, ASP.NET, Ajax, SQL SERVER, MS Access, HTML, XML, JavaScript, CSS. Responsible for the analyses of the requirements of the business, designing databases and user interfaces. Responsible for the creation of the user defined applications, databases, and procedures.

Fixing the bugs and troubleshooting the technical problems. Modified applications according to the user requirements. Trained and helped other developers to resolve the technical problems. Prepared user manuals and trained end users.

Software Developer / Project Co-ordinator في Xplorer IT Solutions
  • الهند - كيرالا
  • يناير 2007 إلى سبتمبر 2010

Developed Windows applications using MS Access, SQL server as backend & VB6, VB.NET as frontend. Coordinated the full Software Cycle with Developers & Clients. Trained Junior Developers to meet the project requirements.

الخلفية التعليمية

ماجستير,
  • في Chinmaya Institute of TechnologyKannur University
  • يناير 2007

from

بكالوريوس, Physics
  • في Nehru Arts & Science College
  • أكتوبر 2000

in

الثانوية العامة أو ما يعادلها, Physics, Chemistry, Bioloy
  • في Kannur University
  • يناير 1997

,

Specialties & Skills

Backup Exec
Server Software
Microsoft Dynamics
Reporting Systems
AP STYLE
BUDGETING
FINANCE
MICROSOFT WINDOWS
PAYROLL PROCESSING
BUSINESS CASE

اللغات

الانجليزية
متمرّس
الهندية
متمرّس