Candidates About

 

Fariborz Davarpanah

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, Change Management, Incident Management, FTP, Remedy, Excel, Word, Lotus Notes,

                                                  Tuxedo, Microsoft Outlook, OLAP Reporting (QBEX), Autosys/Cron, IBM Now Problem Management and Artemis

                                           Timesheet.   

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.

 

 

 

EMPLOYMENT HISTORY

 

Mainframe Developer      Jun 2017 to Present, HCL America Inc.  (working in client site, D + H  Limited Partnership): 

         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, CICS, VSAM, IAM, JCL, Z/OS, ENDEAVOR, DFSort, FileAid, Excel, Word, Windows10.

 

Mainframe Developer     Aug  2015 to Jul 20, 2016,  Realinterface Corp. (working in client site, California Franchise Tax Board):  

         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 in client site, Hewlett Packard):       

         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, HP-Unix, Toad, Tuxedo, Windows and

                                                       Incident  Management.

 

Analyst / Developer                      Jun 2013 to Aug 2014, IBM Corporation (working in client site, State of Michigan): 

         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 in client site, Kmart/Sears Holding Corporation): 

        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.

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

·         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.

 

Finance Analyst / Production Support Analyst             Jan 2011 to Jan 2012, TD Bank Financial Group: 

       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 in client site, VF Imagewear Corporation):

        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:

        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:   

        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 Information Centre of Canada (IICC):

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 (CAS) 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.:

        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):

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):

        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):

 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.