System Administrator
transmed
Total years of experience :13 years, 8 Months
• Working on MSS mobile sales Application
• Creating VSR (Van Sales Representative’s) & Pre-sell Accounts, creating their Journey plans
• Complete working experience on product hierarchy till reporting on Powerplay
• Working on Powerplay reports
• Creating items, users, item groups and user groups.
• Assignment of different discount/promotion per item Or brands
• Working on JDE and have comprehensive knowledge of JDE tables
• Working experience on Oracle JDE-MSS integration and having complete understanding of JDE-MSS mapping
• Order creation and processing orders through all stages
• Complete knowledge of EDI, ITEMS, UOM, Payment, Collection, Discounts, Free goods and sales tables e.g. F47011, F47012, F4011, F03B11Z1, F03B13Z1, F09B11Z1, P02b002
• Understanding of different JDE stages and drive orders from sales application to Oracle JDE and from JDE to WMS and back to Oracle JDE vice versa
• Troubleshooting orders stuck on EDI tables and coordinating with accounts for inactive accounts
• Handling factsheets, Factsheets budgeting and creating different channels based on company requirement
• Controlling discounts and making sure all orders getting discounts including free goods
• Maintaining promotions, instant promotions on invoice level, structured discounts on brands level, Family to family discounts for free goods
• Working on SQL server 2008 and having complete understanding of all tables, backup and database recovery
• Complete knowledge of SQL triggers that fetch record from JDE and back to JDE
• Configuration of promotions on Oracle JDE for pre-sell orders and whose-sales orders
• Daily administration and support including but not limited to managing multiple user setup, profiles and roles, customization of objects, fields, record types, page layouts and validations
• Working with management, strategic planning & analysis staff and end-users to create and manage complex workflow rules, data validation, and triggers
1. Troubleshooting & configuring overall network, windows server 2008 R2, Routers & switches, Active Director, DNS, DHCP, Network Securities, Policies, exchanger server 2010, VPN, firewall configuration etc
2. Handling and configuring internet securities and arranging training for staff training accordingly as per company Internet policy.
3. Implementation of Various Anti-Virus software and updating software on regularly basis
4. Handling and updating our website www.nascintl.com | www.nurses4canada.com | www.doctors4canada.com
5. Purchasing domain name, data migration from one domain to another, configuration of database online on PHP MySQL, creation of tables & databases, complete understanding of SQL queries, Importing data from any database to MS Access and extracting data through SQL Queries & Generate reports according to requirements.
6. Leading email marketing campaign, developing email database all over the world according to business segments and targeting through advance email marketing software, using effective way of email marketing to avoid spam, complete control on email marketing tools e.g. Mail-List controller, Bulk Mailer, Atompark & online solution aweber.com
7. Regularly shifting to different Virtual private servers VPS & Dedicated servers to continue Effective email campaign and to avoid any spamming.
8. Regularly updating our websites, using Macromedia-Dreamweaver & FTP tool file zila.
9. Hands on Photoshop CS2, MCP Certified, Professional MS Office 2010 etc.
1. Hands on accounting software Tally 9.0
2. Follow up with clients for receivables
3. Managing payables to different suppliers
4. Dealing with clients and preparing for them for Canadian Govt Fees, UK, US etc.
5. Check & Balance for PDC
6. Bank reconciliation with daily transaction sheet
7. Maintaining payroll
8. Controlling & follow up with POS system for daily transaction through credit card
Bachelor of Science In Information Technology (BS-IT) 4 Years