Systems Analyst Application Developer

Fariborz Davarpanah

* ******* ****, ***** # *** Cell: 517-***-****

Toronto, Ontario, M3A1E4 Email: *********@*****.***

Status: Canadian Citizen

OBJECTIVE

To operate as a Programmer Analyst / Systems Analyst and Application Developer in a dynamic organization that provides opportunities and challenge.

PROFILE

•B.Sc in Computer Science.

•Extensive experience in Client Server and Mainframe environment.

•Experienced team player at all organizational levels.

•Responsible, flexible, highly adaptable and willing to learn new concepts and methods of operation.

•Proven ability to work effectively and accurately.

TECHNICAL EXPERIENCE

Operating System: OS390, MVS, VM, CMS, DOS/VSE, RDOS, UNIX, AIX, HP-UNIX, VI and Windows

(XP, 2000, NT).

Applications: Retail and Warehouse Management, Business Entity Tax, Calwin Welfare, Financial & Cost

Accounting, Loan, Inventory Control, BOM (Bill Of Material), Purchase, Fixed Assets,

Payroll, Human Resources, Insurance and Purolator Currier Limited Systems.

Database: DB2, INFORMIX, ORACLE, IMS DB/DC, ADABAS, ACCESS, FOXPRO, VSAM and DBAM.

Language: COBOL, MicroFocus COBOL, Net Express 5.1, INFORMIX-4GL, Focus, SQL, PL/SQL,

ESQL/C, PL1, NATURAL, SAS, JCL, IFPL, KornShell and CogniShell Scripts.

Technique: Hierarchical Database Design, Relational Database Design and Modeling with a heavy

emphasize on Referential Integrity, Structured Methodologies, System Testing, and Quality

Assurance.

Tools: ISPW, Maestro, Toad, CA7, Total View, CICS, ENDEAVOR, SYNCSORT, FILEAID,

EXPEDITER, SDSF, QMF, PANVALET, SELCOPY, MKS, SCCS, Change

Management, Incident Management, FTP, Remedy, Excel, Word,

Lotus Notes, Tuxedo, Microsoft Outlook, OLAP Reporting (QBEX), Autosys/Cron, IBM

Now Problem Management, Artemis Timesheet and JIRA Project Management Software.,

Service Desk Manager, ServiceNow

Hardware: IBM AS400, IBM Mainframe, SUN, HP 9000, Data General, and Personal Computers

(Novell, DOS, Windows).

ACADEMIC BACKGROUND

Bachelor degree in Computer Science.

PROFESSIONAL DEVELOPMENT

•SAP01 and SAPTEC, by SAP Canada.

•IBM Lotus Notes (Domino 6.5), by OnX Company.

•Excel (XP/2002&2003), by Computer Help Company.

•Possibilities & Application of AMS, VSAM, by D.P.F.E. Company.

•ORACLE & UNIX, by M.D.S. Company.

•INFORMIX & UNIX, by Tahlilgaran Systems Company.

•COBOL, by SPERRY & UNIVAC Computer Systems Company.

•Financial Accounting, by Sazman Modiriat Sanati Inc.

•Scaled Agile Framework environment (SAFe) at Kroger BTC.

EMPLOYMENT HISTORY

Systems Analyst & Informix-4GL Developer Aug 15, 2022 to June 30, 2024, The State of Colorado:

Colorado Springs, CO

Developed, maintained, enhanced and Supported the Legacy Application Systems for The State of

Colorado using Scaled Agile Framework environment (SAFe).

•Developed a detailed knowledge of the application systems, especially Inmate Banking, Offender Track, Payroll and Restitution.

•Developed, maintained, and enhanced existing programs and modules related to Legacy Application Systems.

•Developed and executed SQL scripts as required for conversions, database

maintenance and ad-hoc query requests.

•Shared knowledge of application programs and development tools with new team members.

Platform Specification: UNIX/Linux, INFORMIX, INFORMIX-4GL, INFORMIX tools,

SQL, Stored Procedures and Unix/Linux shell scripts (ksh), VI, ServiceNow, Service Desk

Manager and Windows 10.

Informix & FourGen Developer Mar 2019 to Aug 2021, Halo Branded Solutions:

Chicago, IL

Developed, maintained, enhanced the Order and Shipment processing for Halo Branded

Solutions and all branches in United States.

•Prepared Design Document for Incentive Program Freight discount for clear

fulfillment shipments for the specific programs and developed the project.

•Prepared Design Document for event date mapping and non-program items (NPR) for third party web store order imports and developed the project.

•Analyzed existing code based on high-level integration requirements.

•Developed a detailed knowledge of the application systems, especially the order and

shippment processing and related modules.

•Developed, maintained and enhanced existing programs and modules related to Order Imports from various sources.

•Developed and executed SQL scripts as required for conversions, database

maintenance and ad-hoc query requests.

•Shared knowledge of application programs and development tools with new team members.

Platform Specification: UNIX (SCO Unix, INFORMIX, INFORMIX-4GL, MicroFocus COBOL, INFORMIX tools,

FourGen applications, FourGen CASE tools,, SQL, Stored Procedures and

Unix shell scripting, VI, ServicePro and Windows 10.

Informix Developer & Analyst Nov 2017 to Oct 2018, Kroger BTC:

Cincinnati, OH

Developed, maintained, enhanced the Order Forecasting Solution Enhancements for Kroger BTC and all branches in United States using Scaled Agile Framework environment (SAFe).

•Analyzed existing code based on high-level integration requirements.

•Developed a detailed knowledge of the application systems, especially the order processing and BOH related modules.

•Developed, maintained and enhanced existing programs and modules related to BOH functionality.

•Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.

•Shared knowledge of application programs and development tools with new team members.

Platform Specification: UNIX (SCO Unix, INFORMIX, INFORMIX-4GL, Informix tools, SQL,

KornShell Scripts, VI, JIRA Project Management Software (V7.3.7) and

Windows 10.

Mainframe Developer Jun 2017 to Sep 2017, HCL America Inc.

(working at the client site, D + H Limited Partnership):

Toronto, Ontario, Canada

Developed, enhanced, maintained and tested the Canada Student Loan Application System.

•Analyzed existing code based on high-level integration requirements.

•Wrote new program and modified the existing batch and online programs to create and process new loans.

•Integrity tests and Quality Assurance for external and internal relations.

•Shared knowledge of application programs and development tools with new team members.

Platform Specification: COBOL, DB2, CICS, VSAM, IAM, JCL, Z/OS, ENDEAVOR, DFSort, FileAid,

Excel, Word, Windows10.

Mainframe Developer Aug 2015 to Jul 20, 2016, Realinterface Corp.

(working at the client site, California Franchise Tax Board):

Sacramento, CA

Developed, enhanced, maintained and tested the Online Suspense Transaction Enhanced Processing (OSTEP) for California Franchise Tax Board to reduce the processing time of suspended transactions of BERA (Online BETS Return Analyst and posting) system.

•Analyzed existing code based on high-level integration requirements.

•Modified the existing programs and wrote the new programs to process corrected and recycled transactions as they are completed in the online system and allow further corrections within the same work cycle.

•Integrity tests and Quality Assurance for external and internal relations.

•Maintained DB2 Stored Procedures.

•Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.

•Shared knowledge of application programs and development tools with new team members.

Platform Specification: COBOL, DB2, CICS, SQL, JCL, Z/OS, DFSort, FileAid, XPEDITER, ISPW,

Excel, Word, Windows7.

Analyst / Developer Sep 2014 to Feb 2015, Eteam Inc.

(working at the client site, Hewlett Packard):

Folsom, CA

Analyzed, developed, maintained, enhanced and supported Calwin Welfare Application systems that comply with user’s requests for all branches in California, United States.

•Analyzed existing code based on high-level integration requirements.

•Performed Analysis of business requirements to improve the business process of existing systems.

•Developed Micro Focus COBOL/Oracle code based on design.

•Provided support by ensuring stability of the application, addressing and resolving the issues in a timely manner.

•Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.

•Shared knowledge of application programs and development tools with new team members.

Platform Specification: Micro Focus COBOL, Net Express (5.1), Oracle (V11), Informix, Informix-4GL,

HP-Unix, Toad, Tuxedo, Windows and Incident Management.

Analyst / Developer Jun 2013 to Aug 2014, IBM Corporation

(working at the client site, State of Michigan):

Lansing, MI

Analyzed, designed and developed Mainframe integration code between the state’s ERP System (KPMG’s R*STARS/ADPICS) and the new purchasing system (BuySpeed).

•Analyzed existing code based on high-level integration requirements.

•Prepared design document based on analysis.

•Developed COBOL/DB2 code based on design.

•Prepared jobs (JCL) based on design.

•Created and Maintained DB2 Stored Procedures.

•Developed DFSort /Icetool based file joins and reports.

•Developed secure FTP scripts based on State's security requirements.

Platform Specification: COBOL, DB2, CICS, SQL, JCL, Z/OS, DFSort, Excel, Word, Windows XP/7,

Change Management, ZEKE and Infoman.

Production Support Analyst Mar 2012 to Aug 2012, ITBMS Inc.

(working at the client site, Kmart/Sears Holding Corporation):

Chicago, IL

Maintained, enhanced and supported Retail / Jewelry Replenishment Center and Warehouse Management Systems that comply

with user’s requests for all branches in United States.

•Performed Analysis of business requirements as offshore team lead to improve the business process of existing systems.

•Interfaced with the Client managers, SMEs and Business partners.

•Prepared Document of Understanding for RRC and JRC Application Systems.

•Coordinated with offshore team.

•Provided support by ensuring stability of the application, addressing and resolving the issues in a timely manner.

•Created and maintained Stored Procedures for Informix Database.

•Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.

•Shared knowledge of application programs and development tools with new team members.

Platform Specification: AIX (V5.3), INFORMIX (V10.0), INFORMIX-4GL, MicroFocus Cobol, SQL,

AIX/Unix Scripts, INFORMIX tools, Access, Excel, Word, Lotus Notes, Windows

XP, Change Management, Incident Management, JIRA and SHARE.

Production Support Analyst Jan 2011 to Jan 2012, TD Bank Financial Goup:

Toronto, Ontario, Canada

Supported the General Ledger (GEAC General Ledger) and Financial Application Systems.

•Responsible for monitoring all daily, weekly, monthly, quarterly and yearly interface jobs that flow through FMS on a daily basis.

•Analysis and resolution of problems resulting from the running of these jobs or processes during business hours and in the off-hours, whether they are of a technical nature or are data-related.

•Provided day time and after hours support for Financial Management Systems especially General Ledger System.

•Worked closely with our CSTS (Corporate Segment Technology Solutions) and TD business client’s through-out the bank resolving issues.

•Coordinated system/process changes with technology and business partners.

•Assisted with job scheduling (CA7) to meet the requirements of clients, and responding to their requests for information.

•Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.

•Extracted, transformed, organized and load data from Mainframe Environment to PC and vice versa.

•Prepared process documentations and migrated to Standard FPS Process Template Documentation provided by TDBFG.

•Shared knowledge of application programs and development tools with new team members.

Platform Specifications: MVS, TSO, ISPF, COBOL, DB2, Access, SQL, SAS, VSAM, JCL, QMF, CA7

Total View, Incident Management, Change Management, Access, Excel, Word,

Microsoft Outlook and Windows XP.

Senior Software Developer Aug 2007 to Mar 2010, VBEYOND Corporation

(working at the client site, VF Imagewear Corporation):

Tampa, FL

The main objective of the project is maintaining and enhancing the Financial Management Systems and Warehouse Management Systems that comply with user’s requests for VF Imagewear Corporation in Tampa, Florida and other branches in United States.

•Performed Analysis of business requirements to improve the business process of existing systems.

•Wrote detailed description of user’s needs, program functions and prepared designed documents ensuring proper IT standard are followed.

•Maintained application through the life cycle of systems.

•Provided support by ensuring stability of the application, addressing and resolving the issues in a timely manner.

•Created functional design & test cases and regression testing.

•Developed new programs as well as enhanced existing programs (INFORMIX-4GL, PL/SQL, MicroFocus COBOL) and promoted to production.

•Created and maintained Stored Procedures for Informix and Oracle Databases.

•Maintained Sarbanes Oxley Compliant documentation.

•Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.

•Shared knowledge of application programs and development tools with new team members.

Platform Specification: AIX on AS400, DB2, ORACLE, INFORMIX, INFORMIX-4GL, INFORMIX

tools, MicroFocus COBOL, SQL, PL/SQL, ESQL, Focus, KornShell Scripts,

Access, Excel, Word, Lotus Notes, Windows 2000, CA7, MQ Series,

IBM Manage Now Problem Management And ArtemisTimesheet.

Technical Consultant Aug 2006 to Jul 2007, Innovapost Company:

Toronto, Ontario, Canada

Provided technical operations support for products and environment that directly service

Business applications. Support is providing to the Client Services organization.

•Supported and enhanced Purolator Currier Limited Systems (Service Directory and Query, Airborne Southbound Manifesting, Tracking (batch and online), Regional Data Entry, Field Management Reporting, Transit Time and Pin Consistency Systems).

•Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.

•Shared knowledge of application programs and development tools with new team members.

Platform Specification: UNIX (HP9000, Sun), VI, INFORMIX, MicroFocus COBOL, SQL,

ESQL/COBOL, Informix tools, Maestro, Tuxedo, KornShell and

CogniShell Scripts, Change Management,MKS, FTP, Remedy, and

Windows 2000.

Programmer Analyst Sep 2000 to May 2006, UNILOCK Group of Companies:

Toronto, Ontario, Canada

Maintained, enhanced and supported the Financial Control Systems for all branches in Canada and United States.

•Developed a detailed knowledge of the application systems, especially the order processing, production and inventory control modules.

•Supported Financial Control Systems (Account Payable, Credit Management and General Ledger).

•Developed numerous new programs as well as enhanced existing programs. By careful testing and release of new and enhanced programs, avoided any business interruptions.

•Added the capability of e-mailed reports and Excel-importable files. Many of these are available by menu picks while others are produced by automated processes.

•Created and maintained Stored Procedures for Informix Database.

•Developed and executed SQL scripts as required for conversions, database maintenance and ad-hoc query requests.

•Maintained the application programs and menus on seven distributed production servers and the development server.

•Shared knowledge of application programs and development tools with new team members.

Platform Specification: UNIX (HP 9000), VI, Informix tools, INFORMIX, INFORMIX-4GL, SQL,

OLAP Reporting (QBEX), KornShell Scripts, Autosys/Cron and Windows XP.

Programmer Analyst Jun 1998 - Dec 1998, Insurance Info. Centre of Canada (IICC):

Toronto, Ontario, Canada

Maintained, enhanced and supported application systems after Y2K changes.

•Supported Automobile Exhibit System (AIX), Automobile Exhibit System for Quebec (AQX), Commercial Liability System (LIA),

Property & Casualty (CA) and Charge Back System (CBS).

•Identified and trouble shouted the specific problem areas including program debugging.

•Analyzed old Charge Back System for new design and develop with Visual Age Generator.

•Developed the new programs (COBOL & SQL) and tested them.

Platform Specification: OS390, MVS, TSO/ISPF and Windows NT at the desk, DB2, ADABAS, VSAM,

COBOL, SQL, NATURAL, CICS, JCL, FILEAID, SDSF, QMF, SYNCSORT

and PANVALET.

Technical Project Manager Dec 1996 - Oct 1997, Rassa Information Structure Eng.:

Tehran-IRAN

Analyzed, designed, developed and supported Financial Systems for Municipality of Tehran.

•Designed Financial Systems using Structured Methodology (Yourdon).

•Developed Budgeting, Financial Accounting and Payroll systems.

•Created logical ERD.

•Designed logical database.

•Integrity tests and Quality Assurance for external and internal relations.

•Exported and converted from COBOL / MVS environment to Informix database on a Unix Solaris platform.

Platform Specification: UNIX (Solaris), VI, INFORMIX, INFORMIX-4GL, Informix tools, SQL and

Microsoft Project for Windows 95.

Systems Analyst / Programmer Analyst Oct 1994 - Nov 1996,

Sazeh Gostar Company (Car Parts Manufacturer):

Tehran-IRAN

Designed, developed, maintained, enhanced and supported Financial systems.

•Analyzed, designed, implemented, tested and supported Purchase, Bookkeeping, Fixed Assets and Accounting systems.

•Designed database (logical & physical), including implementing and testing.

Platform Specification: UNIX (SCO), VI, NOVELL, DOS, INFORMIX, INFORMIX-4GL, Informix

tools, SQL and FOXPRO.

Systems Analyst / Programmer Analyst Dec 1991 - April 1993,

Zamyad Company (Affiliated with VOLVO):

Tehran-IRAN

Designed, developed, maintained, enhanced and supported Financial systems.

•Maintained, enhanced and supported Fixed Assets, Financial and Cost Accounting systems.

•Designed, implemented, tested and supported BOM, Inventory Control, Human Resources, and Payroll Systems.

•Designed logical and physical database.

Platform Specifications: MVS, TSO, ISPF, COBOL, DB2, CICS, VSAM, SQL, JCL, ENDEAVOR,

FILEAID, QMF and SYNCSORT.

Systems Analyst / Programmer Analyst Oct 1987 – Mar 1991,

Irankhodro (Affiliated with Mercedes Benz):

Tehran-IRAN

Designed, developed, maintained, enhanced and supported Financial Control systems.

•Designed and developed and maintained and supported BOM, Inventory Control systems.

•Designed data structures and files.

•Implemented the constructed codes and insured the data accuracy through testing.

Platform Specifications: DOS/VSE, VM, CMS, IMS DB/DC, DB2, COBOL, PL/1, JCL, XENIX,

NOVELL and DOS.

REFERENCES

References covering all phases of education & experience and several letters of commendation will be forwarded upon request.

Contact this candidate