Viatcheslav Schwartz

AS400 Programmer analyst at Red Apple Stores Inc
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Vaughan, Ontario, Canada, CA
Languages
  • Hebrew -
  • Russian -
  • English -

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • Canada
    • Retail
    • 1 - 100 Employee
    • AS400 Programmer analyst
      • Jul 2019 - Present

    • Founder & CTO
      • Jan 2010 - Present

      IT solutions, Software development, SEO, E-Commerce company. IT solutions, Software development, SEO, E-Commerce company.

    • Canada
    • Wholesale
    • 700 & Above Employee
    • AS400, SharePoint, SSIS, and MS-SQL server developer
      • Mar 2014 - May 2019

      • Development new modules and customize/enhance existing components in SYNTAX software (AS400). All version of RPG, CL, and COBOL• As a single developer under supervision of a technical lead, created an application for company projects budgeting and workers management in the IT Department of Wolseley. For that purpose, created a stored procedures (as an extension of SQL Server Integration Services (SSIS)), which enabled extremely quick and easy development. Development on C# in Visual studio 2008-2017. Azure cloud. • Maintenance existing and creating new Web services. Transfer and convert data between different systems via EDI, XML, Flat file standards.• Design database tables and logical relations between them.• Communicate directly with business analysts, actuaries and QA testers.• Coordinate work with other developers of the team.• Corporate SharePoint - Created sites, built custom workflows, and managed permissions and content as requested from customers. Provided end user support on every aspect of SharePoint implementation Independently designed, developed and delivered SharePoint sites and Web Part Forms. Met 100% of milestones for SharePoint, Access and Excel deployments and data transfers

    • AS400 Software developer and system administrator
      • Dec 2015 - Apr 2016

      Short term contracts. Consulting services for Performance Improvement of Brandix’s Reporting System based on AS400 and MS-SQL servers Short term contracts. Consulting services for Performance Improvement of Brandix’s Reporting System based on AS400 and MS-SQL servers

    • Canada
    • Retail
    • 700 & Above Employee
    • Senior AS400 (iSeries) developer, Data & System Analyst
      • Jan 2013 - Mar 2014

      Senior AS400 (iSeries) programmer, Data & System Analyst• Development of iSeies-based software applications. Logistics and Distribution systems in JDA MMS environment. SEQVEL query reporting.• Creating new project for mapping and transfer data via XML to Data Force server. IFS and transfer data to Windows sharing folder via QNTC.• Electronic Funds Transfer project – transfer and convert data from / to iSeries. IFS flat files and QShell scripting programming • Development iSeries system utilities applications. Maintenance existing and creating new control and monitoring software for FTP and System active processes.• All new development was done in RPG IV ILE free-form utilizing embedded SQL, if appropriate. The majority of the applications were written as smaller, single-function compiled units, in a modular approach (i.e. service programs & procedure pprototypes), and bound to the programs that needed them, thus eliminating duplicate code and making for easier application maintenance.• Transitioned software development efforts to a test-driven development (TDD) process, which brought QA testing in on the front-end of the development cycle for gains in code quality, software functionality and programmer productivity.SEQVEL Viewpoint software, IBM Rational Developer for System I RPGIII-IV ILE (old and free format) style, RPGSQL, CL, EDI, XML,

    • PC POS Field Service Engineer
      • Oct 2012 - Dec 2012

      Service provides an extensive range of Point of Sale :POS Software, POS Hardware and POS Services. Service provides an extensive range of Point of Sale :POS Software, POS Hardware and POS Services.

    • Israel
    • Software Development
    • 1 - 100 Employee
    • AS400 / Application developer and System administrator AS400 (iSeries) system
      • Apr 2007 - Aug 2012

      Senior AS400 (iSeries) programmer, Data & System Analyst• Connectivity projects, major modifications to existing programs. Prepare existing software (RPGLE) for convert to Web services, WSDL and WEB interface. • AS400 upgrades and migrations, application of PTF's,• Develop Software, Data Model and Design for:  Medical practices, clinics, pharmacies and laboratories. Financial records, insurance claims. EMR electronic medical record.• Developed some UNIX scripts to automate database operation. Performed remote and onsite application system design, development and ongoing maintenance on multiple AS/400s. • FTP and SFTP transfer data to credit card and insurance companies. • Managed and resolved design issues during development stage. Worked closely with developers and QA team.• Provided AS400 (DB2) database administrative supports for other different applications and system.• Hardware Management Console (HMC)• Logical Partitioning (LPAR)• Perform iSeries administration and security maintenance• Web and GUI interface. Query/400. Web Query. RPG (old and free format) style, RPGSQL, CL, UNIX, SQL, Web Services, WSDL. LDAP

    • United States
    • Software Development
    • 300 - 400 Employee
    • AS400 / Windows(C++) programmer
      • Mar 2006 - Apr 2007

      iSeries and Windows Software developer, Application integrator• Developed programs using C, C++, RPGLE, CL, UNIX script. For Magic IBOLT software and technology in AS400 and WINDOWS environment. Cross-Platform Application Development. • Working with a team of seven staff programmers and on mixed platforms, Windows AS400 (iSeries), UNIX. • Responsible for development, implementation and support of Magic software and IBOLT web-applications.• Ddeveloped and maintained RPG ILE/ C 400 programs for both greenscreen and Web applications. COBOL, CL, RPGIII-IV, RPGLE, C++ (Visual studio 6), C on AS400,UNIX scripting. FTP. Microsoft Office, UNIX Schell (PASE environment).

    • Israel
    • IT Services and IT Consulting
    • 100 - 200 Employee
    • AS400 / System I. Software developer, System integrator
      • Jan 2003 - Feb 2006

      Software developer, EDI Application integrator. • Developed and maintained the Item Tracking, Shipping Order, Inventory Processing, Order Entry, and Billing systems. Using Visual Basic, RPG (All version). Web based GUI for trading partner’s software.• System integrator and software developer for EDI solutions from AdvanceFirst Technologies. Advance-i400, (formerly known as Intercept-400). IBM Websphere WBI and WDI• Custom EDI mapping, written in RPGLE or Visual Basic 6. • Developed software for link largest supermarket network with other retailers and consumers via VAN (UNIX servers). Addressed complete application interface and custom programming between clients warehouse distribution package and Supermarkets IT.• Inventory computer systems are designed to keep automatic track of all inventory that the supermarket has. Analyzed and enhanced automated and miscellaneous invoicing systems to enable multiple stop detention billing and added automation features to both (supermarket / vendor) systems. EDI, VAN , CL, RPGIII-IV, VB (Visual studio 6 and .NET), MS SQL Server, UNIX scripting in (PACE environment), Web Sphere WDI, WBI. FTP.

    • United States
    • Software Development
    • 1 - 100 Employee
    • AS400 / ISeries Software developer, System administrator
      • Jan 2000 - Jan 2003

      Software developer, System administrator• Backup Recovery and Media Services (BRMS)• Design, test, document and implement disaster recovery plans (DRP)• Performance measurement, tuning and system management• Developer of system software solutions for AS400. • Focusing on system security, productivity and system management. • Responsible for the installation, upgrades, and maintenance of all phases of an AS400 Database Servers CISC and RISC server environment, including hardware, operating systems, third-party software, network connectivity, and system security and backup.• AS/400 CISC to RISC Conversion Project• Plan for backup, recovery, and fault tolerance of database; Backup and restore the database.• System Administration-PTFs, System Values, Basic Configuration• Security Administration-User Profiles, Authorization Lists, Object Authority• Operations-Backup & Restore, Print Management, Job SchedulerSystem administrator: Microsoft, AS400, Novell (3.12 – 4). RPG (III-IV), RPGLE, CL, MS VB6. OS400 upgrades and patch updates. FTP, Telnet.

    • AS400 Software developer
      • Oct 1998 - Dec 1999

      RPG II, RPG IV, and ILE Programmer• Development of iSeries-based software applications. Logistics and Distribution systems.• Developed and enhanced AS/400 RPG applications to support Financial and Industrial software.• All new development was done in RPG IV ILE free-form utilizing embedded SQL, if appropriate. The majority of the applications were written as smaller, single-function compiled units, in a modular approach (i.e. service programs & procedure prototypes), and bound to the programs that needed them, thus eliminating duplicate code and making for easier application maintenance.(RPGIII-IV / CL)

Education

  • Blue Education centre
    College Coursework Completed, Linux System Administration
    2010 - 2010
  • Tel ran
    College Coursework Completed, C,C++,JAVA, .NET, Unix
    2007 - 2008
  • John Bryce
    College Coursework Completed, Java programming
    2006 - 2006
  • Cyber Ark
    Certification, System Engineer
    2005 - 2005
  • John Bryce
    Certification, Microsoft certification of achievement
    2004 - 2004
  • Brainbench Certified Network
    Certification, OS/400, Internet
    2001 - 2001
  • IBM Israel
    College Coursework Completed, Training course on AS400 Introduction
    1998 - 1998
  • Uzbekistan State Institute of Physical Culture
    BA, Uzbekistan State Institute of Physical Culture
    1990 - 1994
  • 43
    -

Community

You need to have a working account to view this content. Click here to join now