Summary

Senior analyst in the IT industry. Experience includes supporting large mainframe and SAP systems, data analytics, and team leadership, as well as developing custom applications in Access, Visual Basic, and Web based JSP and Oracle ADF applications. Strengths include business analysis, writing clear and concise specifications and application code, working effectively in a team environment, and a good rapport with satisfied clients. Have experience with:

Project Leadership Mentoring Team Conflict Mitigation Waterfall and agile projects

Technology Skills

Professional Experience

Senior Programmer Analyst

Confidential

Supported a custom built budgeting application, using Powerbuilder, PL/SQL, and Unix shell scripts. Responsible for enhancements to the Powerbuider application and batch interfaces scheduled in Cybermation. Supported a financial warehouse. Worked on migrating an Oracle database to Kognitio as part of an effort to evaluate in memory databases, using Microstrategy for reporting.

Free lance computer support

• Supported a local restaurant with their need for a simple click and go backup procedure.
• Supported a local financial services company with an under performing computer. Resolved the performance problem and set it up to print to 2 networked printers.

Confidential

• CSC provides outsourcing services for companies, providing CMMI level 3 compliance. Most of the accomplishments below are for Bath Iron Works, a company that builds ships for the Navy.
• SAP warehouse management project blueprint
• Wrote functional specs for changes to SAP material master, vendor master, as well as business process changes for receiving and inspecting material.
• COTS package migration for earned value and scheduling. Artemis replaced by Deltek.
• Revised ABAP program in SAP to use the new data source.
• Revised a Microsoft Access database to support material EACs Estimated Cost at Completion .
• Electronic statusing for a ship test notification application.
• Managed this as a small project. Worked with a programmer to get him up to speed in the application and support him doing coding modifications to this Java web based JSF and Oracle ADF application. See below for more description of this application.
• Work in Progress Parts Locator project
• Developed a Work in Progress Parts Locator for machine operations on steel as part of a team effort.
• Using IBM Rational Websphere, wrote Java beans to implement business rules. The JSP web forms were written to be used by portable radio frequency RF guns.
• Forms included the following: move a pallet to a new location, place parts on a pallet, re-label a pallet, find the location of a part, and clear a pallet.
• Helped with project management tasks for this agile project, including estimates, sprint planning, and scrum master tasks.
• Helped to design a report of average machine time per part. Using data profiling principles, recommended doing a mean instead of an average in order to discard inaccurate numbers that are very low or high.
• Worked with the lead developer to gather business requirements and develop specifications.
• Application written to conform to OWASP security requirements.
• Prepared statements used to prevent SQL injection.
• Service account credentials stored securely using JNDI.
• Positive input testing done in the Java Server Pages in order to prevent malicious attacks from getting to the data update beans.
• A secure URL check was implemented to prevent credentials from being transmitted if they are not encrypted.
• Level of effort support for materials, finance, and quality applications, production and break fix support.
• Wrote a program from scratch to resolve the problem, replacing an entire job stream.
• On hand cost calculations were done by a 30 year old mainframe process that turned out to have some bugs in it. The bugs became more evident when reporting on cost for two different ship programs. The correct total cost was being reported, but when the cost was being reported to the wrong ship program, the bug become more evident than it did when the cost was shifted between hulls for the same program.
• There were some major shifts in on hand cost during an accounting period, which got the attention of management.
• Financial cost calculations
• This Microsoft Visual Studio/Visual Basic project helped to discover design improvements that saved a significant amount of cost in building the ships.
• Created Design for Manufacturing Metrics reports, reporting on metrics for ship design in order to reduce manufacturing costs.
• Design for manufacturing metrics
• Implemented positive input testing on text typed in by the user.
• Converted the signon to use Active Directory credentials.
• Retrofitted this web application to address several weaknesses that didn't conform to OWASP security requirements.
• Material tracking inventory web security
• Because of this new approach, material cost reporting is now a streamlined application with much more functionality that it had before, including the ability to view material cost at the detail level, and tie it directly to material items and general ledger documents.
• During the fall, met with two of the Program Finance employees and worked on an alternative approach for getting material cost to support Cost View, Spend Plan, Navy billing, and material cost reporting. The three of us made a proposal that we felt we could implement and work with, and sold it to a cautious audience.
• One of the needs of this project was to support material cost reporting. The original plan was to keep a mainframe system called MCZ to do the material cost reporting. Further analysis determined that is was not practical to keep this system, and it would be more effective to replace it. This left a major gap in the project: there was no plan for replacing MCZ, a significant system that took a couple of years to develop, and over 50,000 lines of code.
• Supervised an ABAP programming effort to publish results to data warehousing Oracle tables external to SAP.
• General Ledger conversion from the mainframe to SAP FICO Finance and Controlling Module .
• Level of effort support for materials, finance, and quality applications, production and break fix support.
• As a result of this new application, government reporting requirements for minority reporting are now supported by an application, providing data that was not available prior to this time.
• Reusable code was written using objects and methods. This approach gave us the ability to encapsulate functionality cleanly, including the use of private and public methods and variables.
• The end product was a rich set of reports that display in Excel, allowing full spreadsheet functionality, using XML spreadsheet technology. This technology eliminates the need for macros and spreadsheet templates, and generally has a faster response time than running Excel macros.
• Played a major role in a Small Business Reporting application, including much of the coding and development.
• Small Business Reporting
• This report support three different output types: Excel, Access, and a standard SAP report. Excel and Access outputs open the respective programs automatically and display output, using a single click and go style of requests.
• Data transformations made this report more than a typical plain vanilla report. For an example of a data transformation, General Ledger entries store the purchase order on certain line items, and the vendor on others. On the report, they want to see the purchase order and vendor on all line items for a document, even if the data only stores it on one of the lines. For another example, vendor name is required for both regular vendors and one time vendors, including the ability to search on it.
• Wrote a General Ledger report for finance. This report reads Finance and controlling data from SAP directly to create the report.
• General Ledger report
• This application replaced the two existing applications, and provides some significant improvements over the existing applications. For example, a number of fields have table validation. Work orders, compartments and hull lookups use corporate data that is refreshed daily.
• Application takes advantage of Oracle's Model View Architecture MVC to separate the data model from the forms.
• Test releases are related to one or more actions that determine when notification is required. A release is always created with an action. After that time, new actions can be created against the release.
• The application made use of Java Applet technology to do printing as well as publishing results to an Access database.
• Played the lead business role in developing a Java Oracle ADF Web application to support ship test notification for the Navy.
• Ship test notification application
• This is a new Java based web page that required the use of Javascript and Java Server Pages.
• The mass edit functionality provides a list of all end uses and specifications for a given buyer, and provides the opportunity to change any or all of them to different buyer codes on a grid display, then save the changes all at once.
• Revised a milestone tracking application to provide a mass edit for buyer codes. Prior to this functionality, buyer codes had to be changed one at a time, requiring significant effort.
• Milestone tracking application
• Built a process to do the selection and display, then, with a click of a button, generate the proposal for processing.
• Researched this and determined that a front end program could be written that selects and displays the candidate auto payments
• Worked on a process improvement for program finance's auto-pay process. Using the existing system, they had to print out and enter document numbers and ranges by hand in order to get a payment proposal and print it.
• SAP FICO auto-pay process
• Wrote an Executive Compensation report for CSC human resources in ABAP. This remote support effort required getting up to speed in aspects of the SAP Human Resources module, including Info Types.
• Executive Compensation report for CSC human resources
• Oversaw an effort to revise an Access database to read Oracle data directly, eliminating the need for file transfers. Using the new process, all the user has to do is enter the drawing number, and the latest data is available immediately. The Access application connects to Oracle using ODBC and uses an Oracle view to get the results.
• Wrote a mainframe process to populate Datacom tables from DB2.
• Wrote PL/ SQL scripts to do extracting, transforming, and loading of data ETL .
• Configuration Management application migration from IBM mainframe to Oracle/web
• Played the lead role on a project to add a new process to a mainframe Cobol Contract Deletion system. Responsible for meeting cost, schedule, and the product deliverable.
• Contract Deletion for materials
• Forecasting the cost of building a new ship
• Projecting a spend plan into the future
• Wrote reports in Microsoft Access to provide support for a number of needs, including the following:
• Material cost reporting and financial analysis
• The web application communicates with SAP using Java connector classes on the SAP server, which open up a port and listen for messages from the web server. The Java connector classes in turn do remote calls to the SAP ABAP functions.
• This application calls a web service to communicate with SAP ABAP programs to exchange data with SAP. The web service had to be modified to support new naming conventions for SAP servers.
• Made required changes to the material tracking inventory web application to support the SAP upgrade. FTP addresses changed due to security changes.
• Remediated ABAP code to run under the new release of SAP.
• SAP upgrade to ECC 6.0
• Material inventory management
• Played the lead role in replacing an aging inventory control reporting application with a new customer application integrated into SAP.
• The new application provides customers with a reporting capability directly integrated with SAP and a legacy mainframe based material control system.
• The reporting creates results directly in Word, Excel, or Access when appropriate, with a single click and go user interface to view the output.
• Material tracking inventory
• Created new web based Java forms to update reorder points and quantities for material using IBM Websphere and JSP. Updated mainframe DB2 tables in real time. Created grid based inserts and updates, allowing the user to update many rows of data in one transaction.
• Managing material attributes for procurement
• Replaced an aging Bulk Commodity Contract Codes application with a new custom application integrated into SAP.
• The new application shows relevant data about the material, including requirement dates, order dates, and comments.
• Material attributes are tracked, such as spot buy, on contract, obsolete, contract candidate.
• This information used to take hours to research using the old application.
• Material Cost Estimate At Complete EAC
• Played a lead role in re-engineering the EAC application using a Microsoft Access front end, and a back end in Oracle integrated into the SAP environment. The EAC application provides the following:
• Extensive reporting capabilities
• Tools for an EAC coordinator to manage the entire life cycle of a periodic EAC review.
• The ability to do direct updates.
• Parameter driven report selection using input forms.
• Complex nested Access reporting.
• The life cycle of a periodic EAC review includes the following:
• Establishing a new period.
• Scheduling the loading of material cost and earned value data.
• Activating a period to allow material cost coordinators to update data.
• Hard lock.
• Final submittal.
• Verification of published results.
• Electrical Support System ESS
• Served as lead designer and supervisor of a team of programmers enhancing this Mainframe Cobol application.
• Responsible for the direct supervision of as many as six programmers and analysts at one time.
• Jointly responsible for recommendations allowing for changes in the way Engineering does business so they can open up a revision notice electronically, make revisions to it in several different functional areas, then issue the revision notice all at once.
• Mainframe schedule simplification
• Simplified the CA7 schedules for materials applications.
• Required extensive research of job dependencies.
• Required knowledge of CA7 networks, triggers, and job dependencies.
• Each CA7 Network was designed to be a self contained unit of work, with the ability to backout all updates in the event a failue couldn't be resolved with job step recovery.
• Cobol copybook conversion to Easytrieve
• Wrote an Easytrieve utility to convert Cobol Copybooks to Easytrieve. This was used by other programmers as required by Easytrieve reports and extracts.

Additional Experience at CSC/Montgomery Kone, Lincoln Technology, Cornell University Department of Computer Sciences and John Hancock Mutual Life Insurance Company, Camp counselor at summer camps