We provide IT Staff Augmentation Services!

Programmer Resume

Scottsdale, AZ

SUMMARY

  • Senior Programmer Analyst with over 20 years experience in design, development and implementation.
  • Strong background in the use of the IBM midrange systems AS/400 and the I-Series under OS/400
  • Well versed in the use of object management software (ALDON) and it’s various environments
  • Experienced in developing and maintaining robust test scripts per the required productions specs.
  • Experience with Load and Stress testing Scenarios (bench marking). USE of MQT to improve performance in the I-Series
  • Excellent experience in the entire test process from unit testing, to system testing, to implementation and finally post implementation verification.
  • Knowledgeable in the use of tools like MicroStrategy and Informatica
    • Experienced in SQL/400, MS/SQL, RPG/400, RPG/ILE, RPG Free, Embedded SQL, I-Series Navigator, QUERY/400, OS/400, Websphere (IBM RDI), FTP
  • Coordinated with Auditors and end Users in different phases of the test and implementation process.
    • Excellent communication, technical and interpersonal skills and a team player.
        • Project Leader and Project manager experience for over 15 year
        • Corporate Trainer/Instructor for Software Alternative, Inc. (IBM Business Partner)

TECHNICAL SKILLS
Testing Automation Tools : SQL/400, ACCESS, QUERY/400, I-Series Navigator, MS/SQL
Test Language : SQL/400 test script, embedded SQL
Development Tools : RPG/400, RPG/ILE, SQL//400, EMB SQL, MQT, Microstrategy, Informatica
Databases : IBM/DB2
OS Expertise : Windows 95/98/2000/XP/NT, OS/400, CPF/OS, SSP/OS


WORK EXPERIENCE

Confidential, (Senior Programmer / Analyst) May 2008 - Apr 2009. Scottsdale, AZ.

Senior Programmer Analyst responsible for the development of new code to enhance the existing Construction Management software as well as custom business requirements modifications. Deliverables included but were not limited to the improvement of the applied methodology used with the existing RPG code. Implementation of embedded SQL as the preferred mode of processing was instrumental in our benchmarking for old and new process. All modifications were to be documented both in the program itself and as an addendum to the test scripts. The change management system of choice was ALDON and we had to operate within the restriction of the software. It was a requirement to have the flexibility of becoming a project leader as part of the ongoing business strategy. sharing my knowledge and expertise with junior programmers. This provided a very dynamic and friendly work environment best described as a great team who catered to an ever improving customer relationship.

Testing Procedural Steps
At Computer Guidance I maintained in the AS/400 a comprehensive test environment that could be use throughout the cycle. Creation, development and maintenance of comprehensive test environments capable of handling migrations, conversions and rollouts to a client base of over 400 customers through out the United States, Canada and the U.S. Virgin Islands. Worked in conjunction with development teams enforcing business rules. Used several stress test techniques (bench marks) in the environments thus ensuring the most efficient processes were used.

It was crucial to work within the confines of our business model making sure that all of our tests were a true representation of the same. The set up of the various AS/400 environments were handled as part of the test scripts. In them it was detailed the order on which the production and test libraries were to be arranged. (AS/400 library list set up). Note: Refer to “Environment Formats and Functions” at the end of this section for more detail.

Confidential, (contract programming through Confidential.) Nov 2007 - Apr 2008. Scottsdale, AZ

Senior programmer / analyst with deliverables that included maintenance of existing home grown software for the food industry. While adhering to the food industry business requirements we strive to apply the most current and best practices in coding. The RPG code and embedded SQL were a key element in our benchmarking. Not only in improving processing time but also being mindful of cross functionality. Customer relationship management was a crucial element of our mind set. We catered to the specific needs of the several local as well as national accounts as an integral part of said mind set. As a member of the team we shared some of the responsibilities of writing code, testing code and providing the final quality assurance prior to production implementation. It was within the scope of my position to provide analysis, determine the cause of the problem, unit test and system test prior to implementation. The creation of comprehensive test scripts for all stages was a very important aspect of those responsibilities adhering to all current best practices. All modifications were to be documented both in the program itself and as an addendum to the test scripts. Several testing tools were used specially the I-Series navigator when determining the efficiency of the code being written.

Role:
As a contract to hire, it was expected of me to be proficient in many if not all aspects of the Data Warehouse group operation. Due to said expertise with the I-Series I was called upon to direct a specific programming approach from time to time. If the implementation of the new approach was accepted by the team, then it would be my responsibility to make sure that all other members fully understood the process effectively becoming the corporate trainer. Change management was also very crucial and the responsibility was evenly shared by all members of the Data Warehouse Group.

Testing Procedural Steps
At Food Services of America I maintained a comprehensive test environment in the I-Series that could be use throughout the test cycle. Creation, development and maintenance of comprehensive test environments capable of handling migrations, conversions and rollouts to warehouses and terminals in our system through out the United States and Canada. Worked in conjunction with development teams enforcing business rules. Used several stress test techniques (bench marks) in the environments thus ensuring the most efficient processes were used.

It was crucial to work within the confines of our retail business model making sure that all of our tests were a true representation of the same. The set up of the I-Series environments were handled as part of the test scripts. In them it specified which profile to use which in turn will determine the order on which the production and test libraries were to be arranged. (I-Series library list set up). Note: Refer to “Environment Formats and Functions” at the end of this section for more detail.

Confidential, May 2000 – Sep 2007 Phoenix, Arizona

Senior Programmer Analyst and Extract Transform & Load (ETL) developer for the Data warehouse system. Within this system I applied modern methodology while being mindful of the best practices thus insuring that all business requirements were being met. Movement of data from the source system to the data warehouse system was drastically improved when process reengineering was applied and RPG code was replaced with embedded SQL. We used a couple of approaches to move data from one AS/400 to another. SARBANES / OXLEY (SOX) rules were in place hence all data movement in the production environment was done using File Transfer Protocol (FTP). It was in the deliverables writing code that kept the DW system up to date while minimizing the processing time. A process was modified and it’s performance improved by more than 300% when we converted some of the RPG code to SQL only when such modification would yield the expected results. Our continued benchmarking assured that best practices in coding were always used in our system. By moving away from old technology and embracing some of the newer methodology we were able to provide support while improving performance. My thorough understanding of the corporation business model allowed me to be efficient while engaged in business analysis. This goes hand in hand with the ability to properly convert the data to SQL tables and SQL indexes from DDS files and logical files thus lowering overhead and improving performance. Used embedded SQL to supplement the existing code rather than converting the whole thing. Created aggregate tables to minimize table scans and searches. It was my responsibility to provide the end user with this ability by designing the data base with enough flexibility that could be use in a variety of internal applications. The main focus however was for the data to be accessed by the MicroStrategy tool for the sake of generating reports for the various end users.

Role: Deliverables included business process reengineering by creating new code with embedded SQL as well as writing SQL scripts. A combination of RPG Free, RPGLE and embedded SQL provided the flexibility that was needed to keep the Data Warehouse functioning at it’s peak performance. When the task required the use of additional resources, I would be the project lead making sure that I kept the department manager informed of every phase. Status meetings were used in a regular basis as a mean to deliver good customer service by maintaining open lines of communication that would guarantee a successful completion and implementation.

The upkeep of our test environment was crucial to the operation. AS/400 triggers as well as SQL triggers were widely used and had to reflect how it would affect the production environment when the objects were promoted. Verified the flat files as well relational data base files by using SQL and Queries in the source system as well as in the test environment. Used a quasi live environment to test the generated data with cross references to the source systems. Data integrity was crucial and in the test phase it was a requirement that all levels of the data would have a perfect match . This was also part of the test script generated for the specific application.

Performed manual and automated tests using the test scripts generated for the application or initial load.
Prepared test conditions, detailing the various level of test which covered development, unit test and system test prior to implementation. All errors discovered in the source system would be documented and a projected course of action was then outlined for the source system teams to handle the issue.

Testing Procedural Steps
At CSK Auto it was required to maintain a comprehensive test environment in both the source AS/400 and the Data Warehouse I-Series that could be use throughout the test cycle. Creation, development and maintenance of comprehensive test environments capable of handling migrations, conversions and rollouts to over 1,200 stores in several major markets. Worked in conjunction with development teams enforcing business rules while ensuring compliance with SOX (Sarbanes / Oxley) mandates. Used several stress test techniques (bench marks) in the environments thus ensuring the most efficient processes were used.

It was crucial to work within the confines of our retail business model making sure that all of our tests were a true representation of the same. The set up of the various AS/400 environments were handled as part of the test scripts. In them it was detailed the order on which the production and test libraries were to be arranged. (AS/400 library list set up). Note: Refer to “Environment Formats and Functions” at the end of this section for more detail.

Confidential, Mar 1999 – May 2000 Tempe, Arizona

Senior programmer analyst providing support to existing programming package for the natural gas industry. Deliverables included maintenance of the code while applying best practices in coding in a combination of RPGII, RPGIII and RPG/400. Customer relationship management was accomplished by constantly catering to the specific needs of the several accounts that were maintained. Keeping in line with the business model no modifications to the base package were allowed unless it was requested by the majority of the customers. These requests were received through out the year. In the event that they were to be added to the base product, we had to make sure that the business model was followed at all times. Due to the nature of the business all modifications and tests of those modifications were closely monitored by the corporate office in Billings Montana. There were some very strict guidelines that were followed by the QA person that would in turn notify the programmer if the modification passed or failed their scrutiny.

Role:
1. Analyze the code that had been flagged as having an issue (bug)
2. Determine if in reality it is a bug or if it was a data issue.
3. If it was a data issue, correct the data and determine it’s origin, then creating the proper documentation so that the cause of the data issue can be corrected.
4. If it was not a data issue then generate work order to correct the program “bug” which in turn will be part of a PTF that will be sent to all customers.
5. New development was handled by another programmer and was not part of my role.

Confidential, Oct 1997 – Mar 1999 Phoenix, Arizona

Deliverables, methodology, benchmarking, change management system, business processes, integration, business unit, cross functional, strategies, business needs, business rules, customer relationship management

Senior Programmer Analyst providing support to their retail sales programming package. Customer Relationship management was an integral part of my duties for we provided support remotely and in person. Deliverables included their code maintenance which was written mostly in RPG III and some portions were written in RPG II. It was required the strict adherence of retail sales business rules. Due to the complexity of the software we were restricted on the type of modifications we were allowed to do so that the integrity of the package was not compromised.

Role:

1. Code analysis insuring that all proper methodologies were followed.
2. Determine if in reality a bug existed or if it was a data issue.
3. If it was a data issue, correct the data and determine it’s origin, then creating the proper documentation so that the cause of the data issue can be corrected making sure that a proper strategy was drawn out and executed.
4. If it was not a data issue then generate work order to correct the program “bug” which in turn will be part of a PTF that will be sent to all customers.
5. New development was handled by the R & D department and was not part of my role.

Environment Formats and Functions

  • Set up data refresh processes thus ensuring data integrity equal to production data
  • Managed all test environment data individually by application
  • Created skeleton SQL scripts to assist on the various tests and data extraction
  • Worked with business analysts adding my expertise and knowledge when required or needed
  • Extensive expertise in the use of AS/400 utilities and HLL. (such as RPG III, RPG IV, RPGLE, RPG $Free, Embedded SQL)
  • Well versed in the use of RLU, DBU, Query 400, PDM, WDSC
  • Strong Project management background and data conversions from DDS to SQL tables, from Logical files to SQL Indexes.
  • Improved system performance by implementing the use of aggregates as well as MQT (materialized query tables) processing.
  • Created comprehensive test scripts providing support to Quality Assurance prior to production implementation.

EDUCATION

Bachelor : Business Administration
Associate: Computer Science
Certificate: MicroStrategy
Certificate : Computer Operations
Certificate : System Security
Certificate: INFORMATICA

Hire Now