Programmer Analyst Resume Profile
Summary
- To operate as a Programmer Analyst / Systems Analyst and Application Developer in a dynamic organization that provides opportunities and challenge.
- 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 Skills
- Operating System: OS390, MVS, VM, CMS, IMS, DOS/VSE, RDOS, UNIX, AIX, VI and Windows XP, 2000, NT .
- Applications: Retail and Warehouse Management, Financial Cost Accounting, BOM Bill of Material , Inventory Control, Purchase, Fixed Assets, Payroll, Human Resources, Insurance and PCL Purolator Courier Limited Systems.
- Database: DB2, INFORMIX, ORACLE, IMS, ADABAS, ACCESS, FOXPRO, VSAM and DBAM.
- Language: COBOL, MicroFocus COBOL, INFORMIX-4GL, Focus, SQL, PL/SQL, ESQL, C, Perl, 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: Informix, Maestro, CA7, Total View, CICS, ENDEAVOR, SYNCSORT, FILEAID, SDSF, QMF, PANVALET, SELCOPY, MKS, Change Management, Incident Management, FTP, Remedy, Excel, Word, Lotus Notes, 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 .
Professional Experience
Confidential
Mainframe Developer /Analyst
Responsibilities:
- 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.
- Developed DFSort /Icetool based file joins and reports.
- Developed secure FTP scripts based on State's security requirements.
Environment: COBOL, DB2, SQL, JCL, DFSort, Excel, Word, zOS, Windows XP/7, Change Management, ZEKE and Infoman.
Confidential
Responsibilities:
- 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 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.
Environment: AIX V5.3 , INFORMIX V10.0 , INFORMIX-4GL, MicroFocus Cobol, SQL, Perl, AIX/Unix Scripts, INFORMIX tools, Access, Excel, Word, Lotus Notes, Windows XP, Change Management, Incident Management, JIRA and SHARE.
Confidential
Finance Analyst / Production Support Analyst
Responsibilities:
- 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.
Environment: 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.
Confidential
Senior Software/ COBOL Developer
Responsibilities:
- 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.
Environment: AIX on AS400, DB2, ORACLE, INFORMIX, INFORMIX-4GL, INFORMIX tools, MicroFocus COBOL, SQL, PL/SQL, ESQL, Focus, Perl, KornShell Scripts, Access, Excel, Word, Lotus Notes, Windows 2000, CA7, MQ Series, IBM Manage Now Problem Management And ArtemisTimesheet.
Confidential
Technical Consultant
Responsibilities:
- 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 Courier 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.
Environment: UNIX HP9000, Sun , VI, INFORMIX, MicroFocus COBOL, SQL, ESQL/COBOL, Perl, Informix tools, Maestro, KornShell and CogniShell Scripts, Change Management, MKS, FTP, Remedy, and Windows 2000.
Confidential
Programmer Analyst
Responsibilities:
- 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.
- 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.
Environment: UNIX HP 9000 , VI, Informix tools, INFORMIX, INFORMIX-4GL, SQL, OLAP Reporting QBEX , KornShell Scripts, Autosys/Cron and Windows XP.
Confidential
Programmer Analyst/ COBOL Developer
Responsibilities:
- 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.
Environment: OS390, MVS, TSO/ISPF and Windows NT at the desk, DB2, ADABAS, VSAM, COBOL, SQL, NATURAL, CICS, JCL, FILEAID, SDSF, QMF, SYNCSORT and PANVALET.
Confidential
Technical Project Manager
Responsibilities:
- 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.
Environment: UNIX Solaris , VI, INFORMIX, INFORMIX-4GL, Informix tools, SQL and Microsoft Project for Windows 95.
Confidential
Systems Analyst / Programmer Analyst
Responsibilities:
- 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.
Environment: UNIX SCO , VI, NOVELL, DOS, INFORMIX, INFORMIX-4GL, Informix tools, SQL and FOXPRO.
Confidential
Systems Analyst / Programmer Analyst
Responsibilities:
- 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.
Environment: MVS, TSO, ISPF, COBOL, DB2, CICS, VSAM, SQL, JCL, ENDEAVOR, FILEAID, QMF and SYNCSORT.
Confidential
Systems Analyst / Programmer Analyst
Responsibilities:
- 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.
Environment: DOS/VSE, VM, CMS, IMS, DB2, COBOL, PL/1, JCL, XENIX, NOVELL and DOS.
