Since January - October (worked in India).

Total Experience in India: Years and months.

January - March – As Hardware & Networking support.

May - October - As Software Programmer/Developer.

 

 

Since October – Present (working in Kuwait). 

Total Experience in Kuwait: + Years.

October - June – As Sr. Software Engineer/Programmer.

June - June - As ERP systems Administrator.

June - Present - As ERP Project Manager.

 

 

Overall Career Experience: + Years

 

 

Career Experiences/Projects

 

Current Experience – As ERP Project Manager

 

Kuwait based furniture retail and manufacturing company having business in Saudi Arabia & Turkey.

 

• Lead the planning and re-implementation of MS Dynamics AX R.

• Managing a full life-cycle ERP implementation from a technical, functional and organizational change management standpoint.

• Liaises with various technology providers, integration with other applications (SharePoint, E-commerce, HR/Payroll & handheld devices), track and follow up project plans and timelines, Identify and minimize project risk etc.

• Collaborates with stake holders, SMEs and functional heads in the business to fulfil their business/technical requirements and objectives. 

• Coordinates with other functional areas of the business - Sales, finance, planning, supply chain, production, Inventory, retail, after sales, call center & other modules on the integration points between process domains.

 

• Responsible to apply best practice across all modules of ERP system according to the industry standard in order to streamline business process and strategies by utilizing ERP system capabilities.

• Assist, train and instruct business users and other operational departments with respect to their day-to-day tasks and problems to improve productivity of business processes and execute corrective action when necessary.

 

 

 

Previous  Experience – Scope of work

. As ERP Systems Administrator

Business process analysis, RFP, FRD, Gap analysis, technical feasibility analysis, analysis business requirements and goals, organization’s change management process, ERP integration into company systems meets functional requirements, system compliance, and interface specifications. Integration with other windows/web applications.

Supply Chain, Inventory Management & Warehousing, Product & Information Management, Sales & marketing, Financial Management (financial dimensions, COA, FA, AR, AP, GL, budgeting & control), AX Retail - Dynamics AX for Retail Operations, Dynamics AX Reporting, BI & Integration Services(SSRS, analysis and Data Cubes, management Reporter, SSIS), Service management, system & organization administration.

 

JD & Responsibilities

 

. Responsible for effective running, support & maintenance of Dynamics AX system as a techno-functional consultant.

. SQL Server Administration & database management.

. All the technical features of the system (workflow, alerts & escalations, auto emails, batch jobs etc).

. Responsible for the design, deployment and administration of Applications.

. Recommend improvements to both physical infrastructure and processes to ensure systems are designed to support business requirements, reliability and performance.

. Design & Develop customized reports based on the management request.

. Capabilities to integrate external systems with MS dynamics AX.

. Configure and implement workflows based on organization’s actual work cycle and any future updates.

. Maintain the integrity, security and performance the system through proactive monitoring and quick problem resolution.

. Perform regular application administrative maintenance tasks based on preset schedule.

. Ensure proper backups and schedules are taking place and recommend changes to backup schedules and enhancements to the overall backup process.

. Deploy updates and upgrades on Applications and Application Systems as required.

. Provide assistance and guidance with ongoing server installations, maintenance and upgrades.

. Provide training on Applications and Application Systems to employees.

 

 

. As Sr. Software Engineer/Programmer.

Migrating from in-house developed ERP SERPS to Microsoft Dynamics AX, through selection, comparing, study and analysis based on requirements. The RFP submits this analyzed business proposal. In FRD stage, it describes different functional levels of organization’s various departments. This includes inventory, buying, merchandising, warehouse, retail operations, finance and accounts etc. Also it covers category managements and its hierarchies, calculations, technical details, data manipulation, transactions and processing other functionalities that define what a system is supposed to accomplish. Analysis and discussions regarding various operations (buying, merchandise planning, retail operations including POS, inventory, finance, back office, MIS etc) handled by different departments and preparing master data templates for UAT and its test cases. The Item master template includes items/products with complete classifications and opening balance of inventory, finance includes Bank, Asset, AR, AP, Ledger and its customer/vendor wise outstanding etc. Study and planning of reports for various user level and management level. 

 

My Role: I was an active member of our implementation core team which includes all functional heads as well as functional consultants. 

 

. Work closely with the business team, functional consultants, and end-users on the key development projects.

. Technical documentation of programs, develop and evaluate the database programs.

. Developing Business Analysis Reports.

. Generate and analyze queries and reports.

. Developing PDA (handheld devices) applications and integrating it with AX.

. Manage installation, configuration and basic setup of MS Dynamics AX environment, from infrastructure level up to the up-and-running level. 

. Manage SQL database installation and configuration.

. Manage development of MS Dynamics AX customizations and add-on&#;s and provide maintenance services for running systems

. Implement technical features of the system (Alerts, E-mails, BI reporting, workflow, SSRS, OLAP, X++, MorphX).

. Dynamics AX system Administrations and Troubleshooting.

. Dynamics AX integration with other applications.

. Thoroughly test the product before go-lives and train users on how to use the system.

. Responsible for developing /modifying Dynamics AX forms, reports and tables in all modules.

. Solving AX problems by diagnose and resolve system faults.

. Able to do a debugging under AX application if there’s any process that requires to be checked and find out solutions to the problems.

. Using existing systems or incorporating new technologies to meet particular needs.

. Prepare and maintain appropriate development documentation.

. Technical support and training to the computer systems users.

 

 

 

. FWPI (Windows Mobile/handheld device Application) - Integration with Microsoft Dynamics AX.

Operating System Windows & Windows Mobile

Languages C Sharp

Databases SQL Server Ce .

Platform Visual Studio

Reporting Service Custom Reporting 

 

 

 

 

 

 

 

FWPI Mobile Inventory Management Application enables automated mobile user operations. The use of mobile devices results in improved data accuracy, increased mobility, and convenience, thereby streamlining movement, counts, and inquiries while reducing human errors. FWPI Mobile Inventory Management is part of SERPS Management solution, which is the integrated suite that streamlines planning, manufacturing, and fulfilment.

It’s a hand held windows mobile application for Inventory counting. This device used to track the stocks which are distributed in different locations. This is developed as a fully customized PDA app and integrating with existing ERP to take the stock of different outlets/stores and the end user can upload data into PDA through this app and after stock counting, the data will be downloaded into existing ERP for viewing stock report as well as doing inventory adjustments.

Developing and implementing this windows mobile application in PDA using MS SQL Server CE Database and C#.

 

. SERPS – Safari House Enterprise Resource Planning System.

Operating System Windows

Languages Vb.net, .net console applications

Databases SQL Server R

Platform Visual Studio

Reporting Service Crystal Report . & SSRS .

 

Our ERP system uses a central database that holds all the data relating to the various system modules. It uses a single database that allows the different departments and different locations to communicate with each other through information sharing. Our systems comprise techno-functional specific components that are designed to interact with the other modules such as Finance, Inventory, HR, MIS, Marketing, CRM, Buying & Merchandising (B&M), POS, Accounts and IT Administration etc.

 

My Role: Understand the requirement from the users from varies departments. Collecting whole information and preparing documentation including technical specification (SSAD). Creating new modules and amending the existing features of the application as well as business reports by using Microsoft technologies. Monitoring database performances, Query execution plan and optimize SQL queries.

 

 

. New Module Developed: Loyalty Programme (Privilege Card).

 

A privilege card is allowing the Privilege member to add up Privilege credits and it is an encouragement people to shop. Whenever a customer shop, they getting some points in their card based on some terms and conditions.

It is an incentive plan that allows a retail business to gather data about its customers. Customers are offered, coupons/vouchers, points toward merchandise. A secondary goal of a privilege card is to build repeat business by offering reward/points to customers.

Privilege card has a barcode or magnetic stripe that&#;s scanned at the point of sale (POS). The card identifies the customer and sends information about what the customer bought to a database. The information in the database is used to help the retailer understand and influence his customers&#; buying habits and this information can help in product selection and stocking the store with high demand products. Privilege card programs can help retain customers, increase traffic and improve sales. Exclusive deals, discounts and incentives attract customers.

Workflow: When any transaction reaches or crosses the minimum requirement for the Privilege Card (PC) issue, system raises a pop up indicating the user is eligible for PC. Customer will be given a form to fill in all his/her details (this information will be entered into the database table against the new PC in process).

This form will carry a field at the top labelled as “Card No.” and there will be a number pre-printed here which will be considered as the privilege card no. for the customer.

Customer’s name and the PC no., from the duly filled form, will be printed onto the card. Then after handing over the card to the customer, the POS user will enter the rest of the data on the manual form into the PC system. Customer can use the privilege card on subsequent purchases from now on.

Data posted is stored in the data base in the specific table.  Also there is a need to capture the invoice no. against which the PC has been issued. This is to store the entire history of the card.

When a customer with PC purchases items, points are accumulated into his privilege card. Points accumulated will be exactly equivalent to the purchase amount. % value from each purchase will be accumulated against a customer’s PC. 

Also points will be accumulated on purchases done with cash, KNET or credit card.

 

PC Redemption: Value in Privilege card can be redeemed only if has accumulated a minimum of KD equivalent points. Redemption will be only in form of vouchers. Customers hence can use the vouchers redeemed in two ways: Take home the redeemed vouchers to be used for a next time. Use the redeemed voucher immediately on his current purchase which will be similar to receiving a discount of the redeemed amount.

DB Handling:

. Tracking all details regarding the customer like customer name, mobile number, area, nationality and other details in a Master table.

. Need one master table for defining the percentage of privilege and for privilege card id/code which will be unique. An authorized person can change this percentage any certain time.

. Need a table for keeping customer’s purchase history. In this table we have to log card number, purchase date, invoice number, total invoice amount, total points achieved, total amount achieved, total amount used, Balance amount etc.

. When an invoice happen above details will insert into that table. But the second last column (total amount used) will be zero until the privilege amount used.

. Whenever a customer is eligible to use privilege amount and he is ready, then second last column will insert the amount and ‘total points achieved’ column would be zero.

. Whenever a customer giving/swipe privilege card, the magnetic strip reader identifies an id inside the stripe. This unique id will talk to a specified table and check Balance amount. If it seems greater than or equal to KD /- he has the right to redeem amount. 

 

Other Projects

 

 

. Inventory Management System

Operating System Windows XP

Languages Vb.net

Databases SQL Server

Platform Visual Studio

Reporting Service Crystal Report .

Configuration controller Visual Source Safe

 

There was an inventory management system which includes the modules are Purchase, Sales, Accounts (AR, AP), inventory, Transfer Orders, Asset, Masters, Service, Warranty & Periodical Maintenance. It is a comprehensive system which can be effectively used to create, maintain and execute inventory items with great ease. And this is for tracking inventory levels, orders, sales and deliveries.

I had the responsibility of whole areas of Purchase, Sales and Accounts module which developed in .net technology.

Purchase Module: 

A PO has five various levels such as Creation, Confirmation, Approval, GRN and then Invoicing.

User creating a PO and once got a pro forma invoice from a vendor, the person who is authorized for PO confirmation he will do it. Then the PO will be ready and moving to its purchase/buying manager to approve it. He uses his credentials and verifying everything right to do the same. Now the PO will be ready to issue a GRN. Once the goods are received in its warehouse or store, GRN will be completed. Now physical cost is calculating for those products. Then the PO will be moving to finance/Accounts to invoice it and to recalculate the financial/actual cost. Once the GRN is ready the products are ready for delivery or for transfers to shops or other locations with physical cost. 

This is the complete cycle of a Purchase Module. Any purchase returns or amending any PO only up to GRN level. Once it is invoiced, nobody can edit it. All amendments treated as versions of PO.

 

Sales Module:

A sale happens through a POS or a Sales Order (SO).In Sales Order, a user can create an SO and then adding items with mentioning warehouse/location with quantity. The SO will be in ‘Confirmed’ mode after confirmation. Again user will go to picking mode for printing the picking copy and then he can post the SO. Now the Sales Order is invoiced. In POS, scanning items will be added into the list with a quantity. Cashier can settle the payment with cash or card or both. 

 

Accounts (AR/AP) Module:

POS Posting:  Accounts will be receiving all POS transactions and posting the POS transactions with reconciling with cash/card/voucher. There is a retail posting module and it will exist all  un-posted POS transactions. The person who is authorized for reconcile a POS transaction, can provide a date period and the data will be available for posting. In this module user can create a customer as well as  vendor and all the transactions related to a customer and vendor will be available in this module.

This means it has made a sale but has yet to collect the money from the purchaser. This module operates by allowing some portion of their sales to be on credit. These types of sales are usually made to frequent or special customers who are invoiced periodically, and allow them to avoid the hassle of physically making payments as each transaction occurs. This module use Accounts payable to track vendor invoices and outgoing expenditures. All related ledgers like bank, cash, income, expense, and its other sub ledgers are also available in this module. Balance sheet, Profit & Loss Report is also available in this module. It summarizes the revenues, costs and expenses incurred during a specific period of time.

 

 

 

Tasks: 

. Study and analysis the complete modules.

. Documentation with technical specification as well as business specification.

. Application designing at various levels by using n-tier architecture.

. Mainly approaching -tier architecture methods (Application Layer, Business Layer and Data Link Layer).

. Creating/Writing common functions and procedures. This will avoid repetitions of coding.

. DB Designing (DB and its Object, Querying, Query execution plan and optimizing).

. Creating tables, assigned proper primary key.

. Indexing tables. 

. Creating Stored Procedures. 

. Creating DB users and assigning permissions/roles.

. Synchronization between DBs.

. Remote synchronization of DB by configuring linked servers.

. Creating batch jobs in .net console applications and executing through windows schedules for synchronising data from different DBs.

 

 

 

. Orthotics (A Production Management System)

Operating System Windows XP

Languages C sharp

Databases SQL Server

Platform Visual Studio

Reporting Service Crystal Report .

Configuration controller Visual Source Safe

 

 

This system deploying a full cycle of a manufacturing/production of orthopaedic equipments such as collar, shoes, plates, elbow support and braces, arm sling, knee braces and support, arthritis support etc . Purchase and Sales modules are the part of this module but the nature the goods purchase and sell is different. Here purchasing the row materials and making/finishing the new goods and deciding its prices then selling. 

You can instantly create many different kinds of bills of materials, work orders, manufacture orders and invoices to help you streamline the manufacturing process.

 

Features:  Generate bills of materials for new manufacturing jobs. Customer sales Order entry and it Convert customer sales orders into work orders. Create work orders for a variety of jobs. Estimate final costs for products to help with pricing, Barcode functionality. Print invoices and packing slips for fast delivery. Waste goods management.

 

Reports: Various reports like Sales and purchase analysis, stock and inventory transaction reports etc for managing the inventory.

 

 

 

. Cafe Manager (Internet Cafe Application)

This is an internet cafe manager application that manages all the computers available in an internet cafe centrally.

 

Operating System Windows Vista

Languages C sharp

Databases SQL Server R

Platform Visual Studio

Reporting Service Crystal Report . & SSRS .

Configuration controller Visual Source Safe  (VSS)

 

General Features: Creating users, assign users to a machine, pre paid and post paid users, customer/user information profile, manual and automated time adjustment, reservation, client and bandwidth monitoring, sales, data exports to excel as well as to PDF, automated DB backup, enable/disable internet access, client session end, shut down, reboot automatically .

 

User Groups: User Groups allow you to create and manage an unlimited number of different customers/user groups. You can specify pricing structure for each group including differentiated time, systems and offer prices.

Statistics & Reports:  Generate a variety of different statistical reports, including application usage report, employee/user statistics, usages from different perspectives etc. These features can help you allocate resources in better way and optimize business.

 

 

. Wakf Board Management System

 

Wakf Board mainly responsible for the supervision of administration of Wakf institutions and its attached properties spread over the entire State of Kerala. Kerala State Wakf Board is a statutory body constituted by the Government of Kerala under the Wakf Act (Central Act of ) several mosques, kabarsthan, orphanages, dargas etc. are registered with this board in addition to the Wakf properties. The Kerala State Wakf Board is a body corporate with perceptual succession and a common seal with powers to acquire and hold property etc.

The functions of the Kerala State Wakf Board are: () General Superintendence of all  Wakf s institutions and their properties in the State ,() to exercise powers under the Wakf Act so as to ensure that the Wakf s under its superintendence are properly maintain controlled and administered and the income thereof is duly applied to the objects for which such Wakf s are created or intended.

 

Operating System Windows XP

Languages Vb.net

Databases SQL Server

Platform Visual Studio

Reporting Service Crystal Report .

Configuration controller Visual Source Safe  (VSS)

 

 

Below are modules handled in the system.

 

• Auction Module.

• Finance Module.

• HR/Payroll Module.

• Master Approvals.

• Registration Assessments.

• File Management.

• Legal Module.

• General Administration Module.

• Wakf Management.

• Master Software.

• Reports.

 

 

 

. School Management System

Operating System Windows

Languages Vb.net

Databases SQL Server R

Platform Visual Studio

Reporting Service Crystal Report . & SSRS .

Configuration controller VSS, VS Team foundation Server

 

It is a compact package, designed to provide a sophisticated, state of the art technology, aimed at bringing about total quality in Education management. This system focuses on excellent coordination between School and students. The various modules are Profile (Candidate, Teacher, Parents) Registration, SMS Management, Student Teacher Administration, Time Table Management, Library Administration, Student Care Management & Examination, Login panel & user rights And Reports etc.

• Profiles: Student Profile creation attaching parents info with respective class in charges as well as other teachers. 

• SMS: General SMS, SMS to Parents regarding various information, SMS to absentees, SMS to students & staff with library book over dues, SMS to students as well as Parents with fee overdue etc.

• Student Teacher Administration: Admission Applications with comprehensive information of Student Applicants, Student Attendance on Period to Period and Class to Class basis, Student activity records, Flexible Fee Management has been designed to give different fee structures to every student with different payment months and modes.

• Table Management: % fully automatic time table generation, Dynamic No. of period generation, Create your own time table with excellent checks on assignment of classes and teachers and Update Time Table.

• Library Administration: Entry of new books with Bar Code facility, Issues and Returns of books with Bar Code reader, Comprehensive search of books through various permutation combinations, late return fine, Library card Generation, Library rules and regulations.

• Student Care Management & Examination: Excellent Examination Date Sheet building tools  & Result Management, Unique Time Table Management, Transport Management with Bus Stops and timings for the bus to pickup and Drop.

• Login Panel & User Rights: Create unlimited users with exclusive users&#; rights, Common login panel for all users, may it be student, teacher, librarian or accountant etc, Different rights as decided by the administrator are available to every user for utmost security, multiple schools can be accessed from the common user interface.

• Reports: Comprehensive reporting system with wild and specific search engines, Comprehensive Crystal reports exportable to MS Excel, PDF, MSWord, RPT & RTF formats, rd part tools for reporting.

 

 

Tasks: 

. Study and analysis the complete modules.

. Documentation with technical specification as well as business specification.

. Application designing at various levels by using n-tier architecture.

. Mainly approaching -tier architecture methods (Application Layer, Business Layer and Data Link Layer).

. Creating/Writing common functions and procedures. This will avoid repetitions of coding.

. DB Designing (DB and its Object, Querying, Query execution plan and optimizing).

. Creating tables, assigned proper primary key.

. Indexing tables. 

. Creating Stored Procedures. 

. Creating DB users and assigning permissions/roles.

. Synchronization between DBs.

. Remote synchronization of DB by configuring linked servers.

. Creating batch jobs in .net console applications and executing through windows schedules for synchronising data from different DBs.

 

 

Other Tasks:

. Creating users profile, computers   in Active directory.

. Meeting room configuration.

. Manage user Privileges.

. Email/outlook configuration.

. Configuring and share mail boxes, printers, drives and folders etc.

. Troubleshooting systems, configuring systems into domain.

. Set user password.

. Configuring email groups.

Nationality : India

---

Residential country : kuwait

---

Date of birth : 01-01-1970

Address :

---

Language: English

---

Language Known

Hindi