Programmer/system Analyst Resume
PROFILE
Strong analytical and technical skills. Experience in software design, development and production support for back-end applications.
Principal strengths
Programming. Skilled in producing the code that is reliable, easy to read, modularized, upgradeable, designed for reuse, has comprehensive diagnostics for system errors and business rules violations. Methodological work approach; driven to learn and apply best practices.
Business analysis. Ability to work with the users to define requirements that address all the user needs, expectations, and assumptions within the scope of the project.
Business knowledge. Comprehensive and in-depth knowledge of Billing, Account Receivable, Customer Management for Telecom and Manufacturing applications.
TECHNOLOGY SKILLS
ORACLE 10g, PL/SQL, C, Pro-C, SQL*Plus, SQL*Loader, SQL Navigator, Java, Eclipse IDE, Unix-Shell programming, AS/Set, HP-Unix.
PROFESSIONAL EXPERIENCE
Confidential, 2002 - 2012
Boston, USA
Programmer/System Analyst
Toronto, Canada.
Programmer/System Analyst
Rogerssite-leading provider of Wireless, Cable TV,Internetservices.
Environment: ORACLE 10g, PL/SQL, C, Pro-C, SQL*Plus, SQL*Loader, Java, Eclipse IDE, Unix-Shell programming, HP-Unix.
Responsibility: Design, development, performance tuning and production support of the software applications.
Accomplishments:
- Designed, developed a variety of software applications. Involved in software development life cycle:
- Translation of business requirements into functional and technical specifications
- Design and development of Data Models
- Creation of program specifications
- Creation of scripts to test the entire application
- Code Development
- Support of user acceptance tests
- Designed and developed a Collection process with dynamic scheduling based on Owing Age
- Tuned SQL statements using hints for Optimizer to force a desirable execution plan
- Tuned software applications using techniques such as splitting a process into synchronized parallel processes, and communication between processes
- Created Unix Shell scripts to run and synchronize batch processes to validate data
- Promoted system design standards
- Trained programmers
Major Projects (coding was done on PL/SQL, C, Pro-C, Java):
New Collection process: suspension and real-time re-instatement of customer services based on Owing Age
Real-time Collection interfaces with External systems
- General Ledger: Tax Type change
- Interfaces with Credit Bureau and Credit Evaluation systems
Encryption
Production Support
Confidential,1996-2001
Toronto, Canada
Programmer/System Analyst
Environment: ORACLE 8i, PL/SQL, SQL Navigator, Designer/2000, Developer/2000 (Form Builder, Report Builder), SQL*Plus, SQL*Loader, Unix-Shell programming, HP-Unix.
Responsibility: Analysis, design, development, performance tuning, implementation and production support of the software applications.
Accomplishments:
- Designed and developed an application for a conversion process used across different projects. Involved in software development life cycle:
- design and development of Data Models
- setting of requirements for Database memory
- creation of Database tables, indexes, constraints, triggers
- development of fully automatic processes to carry out the following:
- perform tuning on a Database
- perform all business rules validation on input data
- populate a Database and bring it to an appropriate billing state
- Designed Data Models
- Tuned software applications and SQL statements
- Created scripts to test the entire application
- Created program specifications
- Created Unix Shell scripts to run and synchronize batch processes to validate data
- Loaded data into a Database using SQL* Loader
- Supported user acceptance tests
Major Projects:
Data Conversion that performs sophisticated business rules validation on input data
System Implementation
Confidential,1991 - 1994
Tel Aviv, Israel
Senior Programmer.
Experience in BPCS – Business Planning and Control System including products for Manufacturing, Word Class Financials and Distribution. Specialized in Shop floor control, MRP, CIMPath, Order and Purchase processes.
Environment: AS/Set (SSA CASE Tool), OS/400.
Responsibility: Analysis of user requirements, design and development of software applications, production support, training of programmers.
Accomplishments:
- Designed and developed resident application to execute database transactions in batch for Shop floor, Inventory, Order and Purchase processes
- Tuned software applications
- Designed and developed MRP reports
- Trained programmers
Major Projects:
MRP report for Manufacturing system
Resident application to process of any financial transactions in the System
EDUCATION AND TRAINING
Master of Science
Core Servlets and Java Server Pages
XML for Java Programmers
Intensive EJB 2.0
Enterprise Java Beans 2.0
Designer/2000: Analysis, Design and Generation
Development of Data Models and Design of Databases
Oracle PL/SQL, Oracle SQL*Plus
Development of Applications using Oracle Forms
UNIX - Shell programming