Rosalind Powell

*** *. **** ** ***********, Pa **036

Cell 717-***-**** Home 717-***-**** ad1060@r.postjobfree.com

Summary of Career Experience

• My experience as Senior Programmer/Analyst has a full and varied background although for the last 18 years I have specialized database analysis development with Oracle. I am known for quick learning of business rules and new technology, understanding of user requirements and have the ability to translate those requirements to user-friendly, attractive, substantive applications.

Special Areas of Expertise

Federal Security – Secret (Expired 11-2020)

CompTIA A+ Certification (Expired 11-2020)

Experience PowerBuilder 12.5 since PB 4.0, Oracle 11g since Oracle 7.0, Sybase, SQL, PL/SQL triggers,

SQL*PLUS, HTML, ASP, Microsoft Server 2003, SQL Server 8.0

lSystem analysis and requirements documentation, design documentation, test plans

lCode development and unit testing, System Testing

lComplete project support – database changes, new code, maintenance, interface

lProblem solving

lPowerBuilder Migration skills from 4 to 5, 5 to 6, 6 to 8, 8 to 9, 9 to11

lOracle triggers, explain, SQL, Oracle functions

lASP, Javascript, Jscript, Visual Basic

Experience in Large Scale Computer Application Design and Code Development,

IBM 309X MVS/XA/ESA, DB2, COBOL, Natural

lCode development and testing

lTechnical writing including: requirements documents, design documents, technical procedures, standards, checklists, test plans

l

Experience IBM AS/400

lInterface with mainframe

lCode maintenance

lCommand Language programming

Windows 95/98/2000/XP/Vistandows7/Windows8.1, Windows 10, Word, Excel, PowerPoint, Access

Experience instructing, curricula development and department leadership

Special skills include: organizational and leadership qualities, creative information

gathering and assembling techniques, technical writing, various Windows software packages

Published Article – “Using the Web Datawindow in Powerbuilder 8” HTTP://www.scribd.com/doc/18953048/pb8webdatawindow

Education

1996 Masters of Information Science at Shippensburg University, Shippensburg, PA.

31 Additional undergraduate credits - Data Processing, Accounting and Math, Harrisburg Area Community College, Harrisburg

33 Graduate credits, Psychosocial Science, Pennsylvania State University at Harrisburg

BA - Biology, Binghamton University

Summary of Professional Experience

Programmer V

Bank of America through MartinMitchell Inc July ‘22 to Dec ‘22

Project Title: Nightly Cycle

Responsibilities: Learn and Understand complicated Nightly Cycle. Monitor it and help other departments make fixes. Secondarily, take primary responsibility for the Powerbuilder applications that underlie the Administrator’s work application.

Environment: Linux through Putty (nightly cycle runs stored procedures written in Linux.). PB 12.5 with Oracle.

Details: Monitor the nightly cycle. Create and modify stored procedures in Linux called by a scheduler that runs through Powerbuilder application to call the stored procedures.

Learn a complicated a new-to-me Powerbuilder application.

Programmer/Analyst

NY Department of Education through Trigyn Technologies Edison, NJ May ‘21 to April ‘22

Project Title: CaMS

Responsibilities: Make fixes to the CaMS Powerbuilder application

Environment: PB 12.5 with Oracle

Details: Analyze the current system, recommend a process, implement the code changes to fix the problem as described by the users, and test.

Learning a very complicated a new-to-me Powerbuilder application

Analyze problems or changes as brought to attention by the users

Make coding changes and test

Create a new build and notify the users that the changes are ready for their testing

After user acceptance, move the approved code to Production

Programmer/Analyst

Department of State through Edgesource, Inc Alexandria, VA Dec ‘19 to May ‘20

Project Title: IRPMS

Responsibilities: Make enhancements to the IRPMS Powerbuilder application

Environment: PB 12.5 with MS-SQLversion 13.0.4001

Details: Analyze the current system, recommend a process, test code, and implement the code changes to enhance the program as ascertained by the users.

Learning a new-to-me Powerbuilder application

Creating screen prints and discussing proposed changes to the users for acceptance in a joint, live session

Implementing the PowerBuilder code on accepted proposals

Writing database scripts to make required database changes for the enhancements

Test code

Writing meeting notes to document accepted enhancements

Programmer/Analyst

Navy Support Activity through Orbis, Inc Mechanicsburg PA Oct '18 to Aug '19

Project Title: ICAPS MAPL

Responsibilities: Translate java code to PowerBuilder and restructure it to follow PowerBuilder needs. write test plans, create test data, test, review code and work with senior programmers.

Environment: PB 12.5 with Oracle 12

Details: Develop Powerbuilder code to replace a java implementation of the ICAP MAPL Summarization and Comparison Processes. :

Learning a very complicated application written in java

Writing program specifications, PowerBuilder code and test plans

Creating test data

Test code

Used Excel to compare very large test results with very large production results

Business Analyst

Hershey Food through Computer Aid Camp Hill, PA May ' 17 to June '18

Project Title: Product Control Management (PCM)

Responsibilities: Backup to the primary Business Analyst to write program specifications, write test plans, create test data, test, review code and work with programmer, Powerbuilder Programmer

Environment: PB 12.5 with Oracle utilizing the Powerbuilder Foundation Code (PFC)

Details: As a backup to the primary technical support person for an aging and soon to be replaced application, my duties included:

Learning a very complicated application

Writing program specifications and test plans

Creating test data

Testing code ready for implementation

Helping to pinpoint and correct the cause of incidents after implementation

Making database fixes for the users of the application if it was quicker for me to correct the problem rather than the user applying the application to correct errors.

Designed and wrote Powerbuilder code to look up, view and monitor various database tables from within the application for developers and business analysts. These tables included audit tables, material information, user information, system produced emails, to-do events to the users, messages from batch cycle as well as often used code tables. This went into production in September 2017.

Designed and wrote Powerbuilder code to allow users to discover what products were used by a particular product both up and down the Bill of Materials structure. (This included end products as well intermediate products and raw materials)Once the products used were displayed, the user was able to drill down further to find on what projects the product searched on was used.

Programmer/Analyst

Highmark through Computer Aid Camp Hill, PA Jul ' 16 to Nov '16

Project Title: Corporate Provider Application

Responsibilities: Backup to the primary technical support person to move into the primary position after an apprentice period for the limited remainder of the application's life.

Environment: PB 12.5 with DB2 utilizing the Powerbuilder Foundation Code (PFC)

Details: As a backup to the primary technical support person for an aging and soon to be replaced application, my duties included:

Learning a very complicated application

Writing documentation

Helping to pinpoint and correct the cause of any incidents in production

Making approved changes to the current code base

Deploying code changes to the application Test area, and deploying the code changes to the Production Staging area with the required documentation.

Technical Specialist (Powerbuilder)

US Dept of Housing and Development – thru C3-Systems, Arlington VA Oct '15 thru Jul '16

Project Title: EZBudget

Responsibilities:

Acted as the Technical Specialist for the US Department of Housing & Industry’s (HUD) financial application, EZBudget, to fix and/or test any problems documented by Users or Project Leaders.

Created proof-of-concept designs with working Powerbuilder code for possible future implementations of needs identified by Users.

Delivered to Project Leaders and Managers on a monthly basis - Maintenance Logs and Project Management Reports and on a daily basis - application status reports.

Utilized Microsoft Office products, especially Excel and Word and macros within Word that the application utilized extensively. Word documents were saved as blobs into the database and then opened from the application using OLE.

Delivered agendas and meetings notes on an as needed basis for ad hoc meetings and for a scheduled Project Management monthly meeting.

Taught an education seminar and created documentation for little utilized aspects of the application to refresh users.

Managed documentation on a Sharepoint site.

Environment: PB 12.5 with a Microsoft SQL Server 2008 database. Serena Dimensions is the source control.

Details: As the primary Technical Specialist for the EZBudget financial application, I was called upon to test for base system changes to HUD’s technical environment, such as adding Nuance for PDF conversions and the change from Microsoft Office 2010 to Microsoft Office 2016. Issues were found and addressed.

Proof-of-concept working code was developed for creating a single Word document from multiple Word documents stored as blobs in the Microsoft SQL Server 2008 database. Preliminary requirements for another possible project that would include electronic signatures is currently under way.

The position also entailed daily, monthly and ad hoc agendas, minutes and reports to be written and delivered via email and stored on C3-Systems sharepoint site. The site required reorganization. Attendance at weekly technical meetings of many of the contractors involved with the Financial HUD group was required and I was the C3-Systems’ representative.

If changes to the code base were required (none are at this time), the Technical Specialist (me) would make those changes and deliver them through Serena Dimensions to the Test Center Group for testing. All documentation of the application and forms to move the change through the HUD Configuration process, and it is extensive, would be the responsibility of the Technical Specialist.

The users asked for an educational seminar to reintroduce an unfamiliar aspect of the code. I complied and the seminar went well, but when the original code was tested for use with Word 2016, it failed and implementation of that unfamiliar aspect was postponed.

Subject Matter Expert (PowerBuilder)

General Dynamic IT thru Prism Inc. Towson, MD Nov '14 thru Jun '15

Project Title: Informant Rewrite Medicare Fraud Discovery Application

Responsibilities:

Analyzed currently in production PowerBuilder 11.5 code for functionality and sql to help in the rewrite of the Medicare Fraud application to Java and Javascript.

Worked with Product Owners, Team Leaders, Developers and Managers to deliver a useful and readable technical document for use in prioritization of coding tasks and as an outline for code development.

Utilized Microsoft Office products, especially Excel and Word for documentation process.

Managed documentation on a Sharepoint site.

Agile/Scrum methodology utilized.

Environment: Oracle 11g, Teradata, Windows 7, Microsoft Word, Microsoft Excel, Microsoft Access,SQL Developer, Sharepoint.

Details: As the primary Subject Matter Expert, I was responsible for documenting the functionality of the legacy Powerbuilder code for Java and Javascript lead programmers and programmers and product owners. They would use these documents to translate the functionality to their methodology. The documents were written in Microsoft Word and augmented with Microsoft Excel spreadsheets.

The programmers were primarily interested in the SQL and I pulled the SQL from datawindows and datastores from the datawindow or datastore using a Powerbuilder program that I wrote. The file could then be moved to an Excel spreadsheet or a Word document. This was made easier as the system made extensive use of user objects that were then inherited, so it was a matter of putting the code in a the base user object that was itself based on the Powerbuilder datawindow or datastore.

Imbedded SQL was copied from the Powerbuilder IDE to a Word document. There were calls to stored procedures on the Server. I documented when and where in the code made a call to the server for server code.

Programmer/Analyst

Hewlett Packard through OHM Systems, Inc Camp Hill, PA Nov '13 to Oct '14

Project Title: Medicaid Processing for State of Pennsylvania

Responsibilities:

Developed Powerbuilder code for the Medicaid Provider System, the ICD10 project and fixed defects. The Medicaid Provider System was a subsystem that included all navigation, integration with older code and 15 new windows. Completed on time with minimal defects.

Worked with Product Owners, Team Leaders, Developers and Managers to deliver reliable, error free code.

Utilized Microsoft Office products, especially Excel and Word for the documentation process.

Documentation was an important part of the finished product. It included help files and Technical Design documents.

Environment: Oracle 11g, Windows 7, Microsoft Word, Microsoft Excel, SQL Developer, Sharepoint, debugging PL/SQL

Details: As the primary Powerbuilder developer for the Medicaid Provider subsystem changes, I put together documentation, under supervision of the Product Owner, for the Oracle database team so that they could implement the database changes and add new tables required for this subsystem. This subsystem required more changes than normal as it had many new windows with new functionality. The documentation was held in Sharepoint.

I also developed a project checklist to track the stage of development for each window, including whether database changes were completed, whether development started, whether window on hold for some reason, whether code needed fixing after QA testing, whether window was completed and passed QA testing.

This was new functionality, but it had to be integrated in the old Medicaid Provider system. Extensive changes often had to be made to the old Provider system. Integration testing was required by me, as well as the QA team and that meant a proper sequencing of changes to the old and new windows. There were calls to stored procedures written in PL/SQL that sometimes had to be debugged by me when they didn't work as expected.

The changes to the older windows and the new windows were documented by me as well as as documenting an existing user help system. I also wrote the Technical Requirements document.

Proper promotion from my checked out Powerbuilder code to the general test environment was also part of the job description. After promotion, the test environment was rebuilt so it would be available to all including QA and BAs using that environment.

Programmer/Analyst

Highmark through VisionIt Camp Hill, PA Dec '11 to Aug 13

Project Title: Customer Service Application

Responsibilities:

Developed communication between a new PEGA implementation and the legacy Customer Service application utilizing PowerBuilder 12.5 objects.

The Customer Service application had high visibility and was relied upon by thousands of users, so accuracy and clean coding was a must.

Worked with other projects such as the integration of another Blue Shield project into the Highmark Customer Service system was part of my assignments as well as work with the other departments outside of the Customer Service area.

Environment: IBM Mainframe ustilizing DB2 through COBOL programs, Windows 7, Microsoft Word and Excel, Harvest source control and ClearQuest for project tasking.

Details: This was a system utilizing a foundational structure simpler than the Powerbuilder PFC but similar. Base visual user objects with extensive inheritance were used to create a uniform look throughout the system. Non-visual base objects with extensive inheritance were used to keep the application thin for they these non-visual objects were only instantiated when needed.

My first assignment was to create a set of windows to interface with a new Pega system implementation. It involved inheriting from base non-visual objects and windows to allow users to interface with the Customer Service information and create information for the Pega system through XML processing. The Powerbuilder side went smoothly and quickly. The Pega system was slower and full implementation was still in progress when my contract was completed.

I helped to reduce the backlog of documented problems with the Customer Service system. Also I interfaced

with other areas of the extensive Highmark IT system. I sometimes held sessions with these other areas walking through the Powerbuilder code, using stops in the debugger, to show the other areas what was needed to make the interfaces between our subsystems to correctly communicate. There was a very positive response with a clear understanding of what was needed from the other area.

The Highmark Customer Service system is being considered as the paradigm for the Blues Customer Service system throughout the United States. One project was to pull in the Philadelphia Blue Cross system. My best accomplishment on that project was modification of code to correctly handle the calculation of days from a variously worded string parameter. It involved a very complicated Powerbuilder computed field to handle the situation.

Programmer/Analyst

Hershey Foods thru CAI Hershey, PA Aug '11 to Nov '11

Project Title: Sales Representative Application Enhancements

Responsibilities:

Developed code for the Sales Representative Application that included extensive time management of what the callers could or could not see from the database. It also involved tracking of the productivity of the callers.

Worked directly with a manager to deliver the product on time and with reliable code.

Environment: PowerBuilder 10, PVCS with PushOK and Oracle 9.

Details: This was a short-term project in which I worked extensively with the manager who thoroughly tested the system and was very pleased with the outcome. This was minor system in the Hershey Foods repertoire, that was utilized by 20 to 30 employees. Their responsibility was to call small businesses on a regular basis to take orders for Hershey products. The extensive productivity tracking of the callers by their managers required fair access to businesses available to contact. It was a first come/first serve system for the users, so availability to the customer database ready for calling was on a date time basis. As the day passed, new customers would display in the queue for users to check out from the queue and call.

Most of my changes were to add the time element to the system so customers became available on date time basis rather than a date basis. This was accomplished through Powerbuilder coding.

Programmer/Analyst

CompuGroup Medical through AACSC Columbia, SC Feb '11 to June '11

Project Title: Electronic Health Record Application

Responsibilities:

The application provided medical practices with electronic health record (EHR) processing.

Stored procedures, triggers, some Java..

Developed very complicated procedures for reports to the physician and patient as well as provided statistics for government purposes.

Environment: EA Server/Jaguar distributed PB 12 application with PFC, Sybase SQLAnywhere database. Visual SafeSource was the source control.

Details: This was a short-term project in which contractors were called in to develop reports for physicians and the overseeing administration for an electronic health records application used in a physician's office environment. These reports were required for credentialing of the application.

The application was multi-tiered and the SQL was extremely complicated as the data to retrieve was usually defined as series of sub-retrievals. These retrievals were coded within an if statement depending upon system variables. The reports were completed on time and the system passed credentialing.

Programmer/Analyst

NC Department of Transportation through XpertTech, Inc Raleigh, NC Nov '10 to Feb '11

Project Title: Highway Construction and Materials

Responsibilities:

This was the HICAMS project, Highway Construction and Materials application. This application is highly respected throughout many states' Department of Transportation for its combination of planning, contracting, materials, sampling and testing in the one application.

Performed mainly defect coding.

Environment: Sybase Adaptive Server Enterprise was the database. Rational ClearQuest was used for task assignment and tracking and PVCS was the source control. This was a PowerBuilder 10 project.

Details: This was a short-term assignment where I was assigned documented problems with the code and required to fix them. This was a good project for me as I introduced to new technology. The assignments were easy to fix in Powerbuilder, but learning to negotiate the environment was a good learning experience as management was really looking to hire new Powerbuilder developers and were willing to invest in the training of the “contractors”. (I never applied because Raleigh was too far from my home in Pennsylvania).

Programmer/Analyst – Sole Powerbuilder Developer

Brotherhood's Relief and Compensation Fund Harrisburg, PA Apr '99 to Jun '10

Project Title: Membership Application for a Non-Profit Organization

Responsibilities:

This was a sole developer project that ran the company's business including accounts payable and receivable, claims, inventory, reporting, 1099 processing, phone call records, scholarship awards, general membership data record keeping, dues and personnel.

This was a five year old project when I took over and I made many enhancements, fixes and introduced new subsystems.

Database administration to the Oracle 8i database, including new tables, field additions, primary and foreign keys, triggers .

Complex SQL with Oracle functions and triggers for audit trails were built and maintained.

Migration from PowerBuilder 4 through, PB5, PB6, PB8 PB9 to PB 11.2 were part of the duties.

There was an attempt made to move from the Oracle database to the Microsoft SQLServer, but it turned into a canceled project. It was a good introduction to Microsoft SQLServer.

There was a Web component to this project with secured updates to the database utilizing ASP and JavaScript.

Builds and movement of compiled code were routinely performed by me.

Environment: In this project, as it went for more than 12 years, many versions of Powerbuilder were used as well as upgrades to the Oracle system. As a single programmer shop, no source control was utilized and tasks were developed and communicated through email. New builds were built as soon as a project completed.

Details: I was the sole programmer for the maintenance and new development of a large complex Powerbuilder 11.2 application that ran the business of this membership based company.

One of the most time consuming maintenance projects that I did touched almost all aspects of the application. It involved allowing dues levels for membership to be set and reset in the database. Dues levels controlled most of the system. One part of the subsystem involved input of dues into the system and there were 5 separate methods. I combined them into one during this project along with the many other aspects of this change. It had a highly successful roll out and I believe since I left the company, the dues levels have been changed a second time with no problems.

Since that system is membership based, telephone calls from the members are of prime importance. One of the new subsystems that I developed was for telephone notes to be posted to the database. It rolled out as a small project but soon ballooned into large subsystem, with addenda to notes, notes being placed in more than one member's database file, notes being created by one member for more than one other member, notes with form qualities as well as the originally developed free form type note,. Additionally the subsystem had history indexing with sophisticated online viewing and printing. The database design to handle this project was developed by me as well.

The original system did not make much use of inheritance. I implemented a system-wide reporting system that involved base objects inherited by other windows to support a large volume of diverse reports for management, members, supervisors, and users.

I also introduced tab window when PB began support for them.

I worked there almost 12 years, so there were many more projects as well as small maintenance projects that made life easier for the user. The original project was developed in PB3 and moved to PB4 before implementation. I migrated the system through to PB 11.2 and was waiting to roll out PB 11.5.

The system also had a web component. Our web server was old and I was forced to keep old technology even as more sophisticated tools became available. But, I developed the Members' Only area of the website. The site had access to our Oracle database and was developed using ASP, javascript, JScript, and HTML. I used PB datawindows on the website for reporting as well as HTML designed forms for user interaction.

Contact this candidate