Viatcheslav Schwartz
AS400 Programmer analyst at Red Apple Stores Inc- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Hebrew -
-
Russian -
-
English -
Topline Score
Bio
Experience
-
Red Apple Stores ULC
-
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.
-
-
-
Wolseley Canada Inc.
-
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
-
-
-
Princess Auto Ltd.
-
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.
-
-
-
EMET BARMOR
-
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
-
-
-
Magic Software Enterprises
-
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).
-
-
-
StoreNext Technologies
-
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.
-
-
-
Raz-Lee Security
-
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 -
Tel ran
College Coursework Completed, C,C++,JAVA, .NET, Unix -
John Bryce
College Coursework Completed, Java programming -
Cyber Ark
Certification, System Engineer -
John Bryce
Certification, Microsoft certification of achievement -
Brainbench Certified Network
Certification, OS/400, Internet -
IBM Israel
College Coursework Completed, Training course on AS400 Introduction -
Uzbekistan State Institute of Physical Culture
BA, Uzbekistan State Institute of Physical Culture -
43