Store Inventory Service Specialist
Panda Retail Company (Savola Group) (Jeddah, Saudi Arabia)
Total years of experience :35 years, 0 Months
Research & Development, Innovation, Re-engineering and Architect, Application Development, maintenance and troubleshooting, ad-hoc modification of existing Application system. Analyzing system requirements and review of business processes to determine the requirements for software applications and user-friendly interfaces.
• Translating client requirements into highly specified project briefs
• Working in conjunction with end users from various departments to ensure technical compatibility and user satisfaction
• Responsible for managing significant development projects
Conducts business process analyses, needs assessments, and preliminary cost/benefits analyses in an effort to align information technology solutions with business initiatives. Works with business users to define and analyze problems and align the most suitable technical, application or configuration solutions. Solicits, develops, documents, and manages requirements and provides detailed design and business rules to support the requirements throughout the project life cycle up to and through change control. Considers the business implications of applying technology to the current and future business environment. Reviews system test plans and system tests modules before implementation. Creates, reviews and delivers end-user documentation (user guide, process flow charts, training materials) and training for accuracy. Works with the user to select or create appropriate scenarios to test all results to determine whether system changes met project specifications; uses scenarios to assist the end user in acceptance testing. Upgrades, monitors production performance enhancements and system integrity with end-users. Develops detailed implementation and upgrade project plans in conjunction with other account team associates. Ensures that documentation is updated when change requests are approved for the project. Provides input on processes, procedures, or new approaches.
Analyze and evaluate existing and proposed systems.
Technical documentation and knowledge to communicate effectively on technical concepts
Work in a team with true spirit and Strong inter- personal ability
Good in detail follow up
Good oral and written communication skills are vital when the job holder is required to discuss problems with colleagues, write reports, and document programs.
Excellent in dealing with databases and ability to write proper SQL statements
Knowledge of the FMCG industry is preferred
Modify existing Applications along with Patches to rollout all business stores
Rollout Oracle Store Inventory Management System (Oracle SIM) across all the formats (500+ Stores)
DTSYS: Decoder Tracking (Stock) & Authorization System. To process the Decoder Satellite Receiver (DSR) modules: Stock, DSR Authorization, Defective/Replacement, Swapping, Stolen, De-authorization, Re-Authorization, Disable DSR, Back to Stock, Employee Scheme, Change of Status, etc.
SMSYS & RVD: Subscription Forms Collection & Bill Processing System (Head office), Estimation of Service and other charges as per service selected. Controlling of Employee Package.
SOS: Sales & Operation System (Head office & Regional Offices). Prospect Customers, Credit Card online Billing, Direct Sales, Walking Customers, Batch processing, Installation Job order processing, etc. Developed using MS VB, MS SQL database & Crystal Report.
SFMSYS: Subscription Collection System (Retail Outlets).
OSCS: Outlet Subscription Collection System. Developed using MS Visual Basic with MS Access database.
MSCS: Subscription Collection System (MEED Stores). Data stored in fully encrypted mode for security.
FoxPro 2.6, Clipper 5.1, Visual Basic 6, Crystal Report 8, ORACLE 10g, MS-SQL 2000, MS SQL 2000 Server, Novell NetWare 4.x, Windows
Responsible for analysis, design, development of Business Application Software.
Quality assurance, configuration, implementation, maintenance, Trouble shooting, User support, standardization and business Application Support.
Software Support for Bar Code scanning software.
To Lead the team of developers.Data warehousing, Data migration & Transfer. Database administration, Database Designing, Data Security, Data Analysing.
Developing of Standard & ad-hoc reports.
Reconciliation of Employee’s Sales Incentive /Commission claim-/ payment with due consideration for the Financial and Maintain a consolidated database or repository in which all staff and dealer commission outputs where archived
Trouble shooting and update of Remote Outlets using Remote Administrator tool.
Daily Data grabbing / data collection from MEED (Convenient Stores) using Reach-out tool.
Establish the project team(s) to implement the project in accordance with the scope of work, budget and project schedule.. Plans and executes close-out activities.
Maintains Maintenance Metrics information - extracts data from Access, MS SQL providing reports on a regular basis via spreadsheet and graphical charts.
Orbit - ODSL - Internet Hub Centre
Monitoring of Internet Hub and it support. Preparing performance report of SMTS Hub server. Co-ordinate / Support to the operation department to configure units in SMTS /RDU. Took part in replacement and Installation of SMTS Plate. Gone thru 7 days full time training of new server at Hub station
ODSL Operation Department: -Daily Reports
Exclusive Customer’s unit status report
VIP units status report
Status of SatNet - Free IKids units
Prospect customers details
Status of Active Units in Iraq
Dealer’s New Sales & Renewals summary report
VVIP Customers
-Daily Data Discrepancy & Reconciliation
IBS - OBAN reconciliation Summary, History of discrepancy, History of unofficial use of units. Find out discrepancy between IBS and OBAN System i.e. discrepancy of Class of Services and discrepancy of status of units (active/Inactive customer). Download data from IBS and OBAN system and after data sort out & data cleaning, process it to find out the discrepancy. Keep track of units History which are repeatedly or frequently misused, abused by user
SatNet - Free IKids units : Find out discrepancy between SatNet units with Free I Kids TV units i.e. Satnet-IKids Summer promotion. Download the data from Diamond report system and active TV I-Kids units received from Dubai. Process it together to find out discrepancy between SatNet & I-Kids TV units
-Weekly & Monthly Reports
Call agents performance Weekly & Monthly summary (Call offered, attended, abandon etc)
-Daily Monitoring Exclusive customer units to keep their services active as per specification. Monitoring of VVIPs, Demo, in-house,
Production Formulation & Cost Estimation system
Material Requisition & Purchase Order Processing system
Tools & Spare Parts Inventory Tracking System
Telephone calls data conversion & Report g system
FoxPro 2.6
Novell NetWare 4.x
Development, System study, Designing and implementation, System administration, Maintenance and trouble shooting, Modification of existing system, Upgrade, Generation of different MIS reports, Installation of System Soft wares and user Support.
Material resources planning inventory
Inventory System - Production & Trading
Order Processing System
Project System
Cost Evaluating for Production System
Insurance System
Invoices, Sales, POS., Purchase, Receivable, Payable, Salesman Commission, Sales on return basis.
Quick Basic, FoxPro 2.6, Clipper
Novell NetWare 4.x
System study, Designing, Implementation, Developing, maintaining of customised business application systems as per clients requirement. Customer support & Training, maintenance, report, updating & modification of system, Demonstration of Software to the various prospect customers, All types of MIS reports.
Project Cost Control System
Project Inventory System
Project Manpower Resources System
FoxPro 2.6, Clipper, Lotus 123
Designed & Developed Business application system, ad hoc reports etc. for the Saline Waterpower & Desalination Project SWCC(Madinatul Yanbu Al Sinaiyah Project).
Wages
Invoicing
Bills Discounting
Challans
Bonus
Inventory (Manufacturing) Production, Production-Transfer, Delivery, Delivery-Transfer
Lions Club of North Mumbai (Treasurer) Activity Account and Admin. Account
FoxBASE+, Clipper, Lotus 123
Analysing, System study, Designing, Implementation, Developing, Data Processing and Controlling, Maintaining books of Financial Accounts, Report generating.
Power Plants Generators Test Results system
Transformer Stations Test Results system
Inventory Control
dBase III +, Lotus 123
Designing, Developing, Modifying, Regular & ad-hoc Report generating, data controlling.
ITIL (Jeddah)
Project Management Professional (Bengaluru)
Project Management Fundamental (Jeddah)
Business Objects XI (Business Intelligence) from Euthenics IT Services (P) Ltd, Bengaluru
Visual Basic V 4 from Shri MM Softek Limited, Bengaluru.
Power Builder V 5 from Brainware Infotech (P) Limited, Bengaluru.
UNIX, C & Oracle V 7 with Developer 2000, Report 4.5 , Form 2.5 -from TATA Unisys Educational Centre Ltd. (TULEC), Mangalore
Post-Graduate Diploma in Computer Programming, System Analysis & Application (PGDCPSA) from Apple Leasing & Industries Ltd (APTECH), Mumbai, Recognised by Maharashtra Technical Examination