Scm Administrator Resume Profile
SUMMARY:
- 14 Years of scripting with Perl and UNIX Shells Korn, Bash, Bourne .
- 22 Years experience working in UNIX environments AIX, Solaris, SCO, and LINUX .
- 5 Years as an application release build master.
- 5 Years as Computer Operations Lead Coordinator and Environment Administrator in UNIX environments.
- 5 Years experience as an administrator in source control management.
- 9 Years experience in source control management with SCCS in Solaris and AIX.
- 2 Years experience in QA black box testing and building testing scaffolds in Perl and C in LINUX environments
- 15 Years experience working as a technical programmer in Perl, C, C , FORTRAN and BASIC.
- 4 Years experience as back-up system administrator and programmer on a Sun/Solaris ComputerVision CADDS installation.
- 6 Years experience managing the Noise Control and the Access Control engineering teams.
SKILLS:
- Languages: Perl, UNIX Shells, JavaScript, HTML, CGI, SQL, C, SQLPLUS, PL/SQL, VB/VBA, C , FORTRAN
- Operating Systems: Linux, AIX, Solaris, Windows, DOS, MVS, Vulcan
- Databases: DB2, SQL Server, MYSQL, Sybase, Oracle, Access, Dbase, FoxPro, XBase
- Software: AutoSys, Hermes, SqlLoader, Pro C, AutoCAD, CADDS 4/5
- Tools: Perforce, SVN, CVS, SCCS, SSH, SFTP, Eclipse, Ant, Expect, XML, Cron, Awk, sed, Make, et al
EXPERIENCE:
Confidential
Role: Consultant Back office application support: build, release and patch support
Environment: Ksh, Bash, Perl, AIX, Linux Red Hat , Windows 2003 server, DB2, Citrix, Swift, Lotus Notes, RTC, ProIV
- Member of the Treasury Management group TMG tasked with the responsibilities of deploying, upgrading and patching the WallStreet Systems applications in the development, UAT and production environments. Tasking entailed:
- Installing software packages onto Linux servers
- Deploying and installing dll and Power Shell scripts onto Windows servers
- Resolving software versioning conflicts
- Preparing SQL scripts to support DB2 database changes
- Preparing shell and cron scripts to support batch operations.
- Ancillary tasking included but was not limited to:
- Assisting users in resolving application access problems
- Performing and reporting the results of periodic application security checks
- Synchronization of the testing environments with the production environment
- Documentation of installation and revision procedures
- Automation of manual tasks via cron, Bash, sftp and Perl scripts
- Debugging and implementing vendor supplied scripts
- Converting Excel based data modification procedures into automated shell scripts
- Monitoring test and production environments.
Confidential
Role: Consultant Infrastructure software migration
Environment: Ksh, Bsh, Csh, Perl, AIX, HP-True64 Unix, Universe/Pick database, SCCS, VI, TCL, Make, UNIX utilities
- Member of the GLOBAL UNIX-STORAGE group tasked with the responsibilities of documenting and migrating the RMS system from an HP-True 64 UNIX environment to an IBM AIX environment. The Nestle-Waters RMS system was internally developed in the early 1990s and is the core system that controls the day-to-day operations of the three Nestle-Waters regional divisions. The RMS system consists of an aggregation of linkages between PICK databases and code modules, the JSS job scheduler, SCCS revision libraries, TCL GUIs and UNIX shell scripts written in C-shell, Korn-shell, Bourne shell, C code and Perl . The RMS system was undocumented and all knowledge pertaining to the build release and deployment of RMS revisions to developers vanished in the early 2000s. The task of migrating the RMS system off the HP-True 64 server entailed:
- Reverse engineering the existing RMS system and reconstruction of the RMS build release process.
- Preparing calls trees to map the data and logic flow between the code modules of the RMS system
- Unit and integration testing of migrated code in an AIX development environment
- Reconstruction of lost functionality in migrated code
- Publishing documentation delineating the operations and functions of RMS components and subsystems providing document annotations with respect to bugs found concerning: missing, required, misleading errors and incorrect warnings found within the RMS code modules misleading status reporting found within the RMS log files
- From the code logic, reverse engineering a method by which to provide RMS revisions to the PICK developers
- Developing an automated RMS build release mechanism that reverse engineered what had previously been a manual build release process.
Confidential
Role: Consultant Infrastructure software migration
Environment: Perl, Linux, SQL Server, Sybase, SAS, Perforce, DbArtisan, AutoSys, C-shell, Bash, Ksh, C, SQL, SharePoint
- Member of the Securitized Products Sybase Exodus Project, tasked with the responsibility of migrating of batch jobs from a Sybase, C-shell, SAS and Perl environment to a SQL Server, Bash, SAS and Perl environment. The task entailed:
- Disassembling of the Securitized Products daily, weekly and monthly AutoSys batch jobs.
- Identifying and documenting all files and tables associated with each job in the AutoSys batch.
- Delineating and documenting the parent-child relationships between scripts and between database tables.
- Converting scripts written in C-shell to Bash.
- Converting programs written in C/C to Perl programs.
- Rewriting SAS, SQL and C-shell scripts with respect to logic flow, data file location and error reporting, as required, to conform to Project coding standards and to the Project directory structures.
- In order to facilitate the migration of scripts across environments all hard coded paths, files names and data variables in the scripts and Make build files were replaced with environmental variables invoked from configuration files.
- Creating configuration files as required by the testing and working environments.
- To ensure that all code changes were documented, all pre and post migration code for SAS, C-shell, Perl, C and SQL scripts were stored in a Perforce repository.
- For testing and comparing batch jobs: Developed and implemented AutoSys based testing scripts Jils for daily regression testing of jobs running in a SQL Server environment against jobs in a Sybase Production environment.
- For parallel testing against the production environment: Developed set of Bash and Perl based tools that emulated AutoSys and automated the testing, analysis, and the reporting of differences between jobs running the Production and the migrated Production environments.
Confidential
Role: Consultant software inventory, classification and evaluation
Environment: Perl, Linux, MYSQL, PHP, HTML, CGI, GENOS, SVN, JavaScript, AutoSys
- Member of the TradePlant-AMRS-Engineering group created to support the migration of Merrill Lynch legacy systems to the EFS stateless files system:
- To monitor legacy systems, via ITRS Genos monitoring Net Probes
- To inventory and categorize legacy reports and software tools
- To provide AutoSys support for systems migrated to EFS.
- Primary responsibilities were:
- Creating AutoSys jobs and boxes for EFS.
- Designing and implementing an inventory database of legacy scripts in MYSQL.
- Creating Perl DBI scripts to extract and populate the inventory database with data extracted from the scripts.
- Creating a web based user interface, via Perl DBI/CGI scripts, to support queries of inventory database,
Confidential
Role: Consultant Infrastructure software utilization monitoring and reporting
Environment: Slang, SecDB, Perl, Linux, Sybase, CVS, Java
- Strategist in the FICC Core Infrastructure Division tasked with monitoring and automating the monitoring of reports in a production environment for the Counter Party Reports CPTYR Project. To fulfill the long term monitoring requirements of the task developed a reporting tool that consisted of report monitoring archive and a set of automated GUI based tools that performed data extraction from short term log files, joined the data with the archive data and reported results as daily and long term GUI reports.
- Global, Java 1.6 Complier upgrade project: Tasked with identifying all code that was, either directly or indirectly, Java version specific, contacting the code owners to mandate versioning upgrade, monitoring upgrade progress and reporting daily status to project lead. To expedite the task, developed Perl based tools to extract code from CVS repositories, parsing out all information required to comply with tasking and results reporting requirements.
Confidential
Role: Consultant Computer Operations Lead, Build Master, Application and SCM Administrator
Environment: Perl, Solaris, Sybase, AutoSys, UNIX Shells, Ant, Java, SQL, Cron, Hermes SSH, SFTP, HTML, Make
Application Administrator Responsible for monitoring and maintaining the Calypso trading application and environments. Responsibilities were but not limited to:
- Load balancing the servers in the UAT and Development environments by reconfiguring and redistributing Calypso instances.
- Developing and implementing Perl based tools to monitor performance in the Calypso environments.
- Developing and implementing Perl based tools to automate mundane and repetitive day-to-day tasks.
- Developing and implementing Perl based tools, via Cron, that transparently monitored, created revision history and reported all post release changes made to the production code base.
- Implementation of a Perl tool that transparently insured that the production mirror UAT environment code base remained synchronized with the production code base.
- Developing a Perl tool that extracted of job dependency structure of the Calypso AutoSys Batch.
- Developing and implementing a Perl tool to perform cleanup, archive and relocate reports files.
- Responsible for overseeing the application and database specific technical operations on eighteen UNIX servers, sixteen development, seven UAT and two Production environments.
- The preparation of operational and technical documentation to support the implementation of standards and protocols.
- Coordinator of user permissioning across eighteen Calypso environments.
- Providing technical direction and guidance to the offshore, India, team with respect to day-to-day operations.
- Reconfiguration and relocation of Calypso environments across eighteen servers for load balancing.
- Synchronization of the code bases and databases of environments against the production environments.
- Maintenance of Calypso Java Web Start HTML pages.
- Providing ad-hoc ETL and scripting support to the business analysis and operations groups.
- Build Master- responsible for the management, coordination and deployment of Calypso build release packages to the Developments, UATs and the Productions environments. Responsibilities included but were not limited to:
- Building release packages and patches from the code taken from the CVS repository release branch.
- Resolving any and all release build issues with developers prior to package deployments to UAT environments.
- Revising Make, Ant xml builds scripts as required to reflect changes required by the build and release process.
- Documenting and publishing code changes within the release branch.
- Deploying release packages and patches to the development and UAT environments.
- Performing all administrative and technical tasks required to coordinate the deployment of release packages to the Production environments.
- Source Control Administrator Technical and administrative responsibilities included but were not limited to:
- Implementation of a CVS Access Control System written in Perl for source control management of applications and for controlling of user and group write access to repositories and branches.
- User and group account creation, creation and assignment of project development branches.
- Preparation of release branches for formal deployments to the UAT environments.
- Implementation of Cron based Perl scripts for daily reporting of code changes checked into the CVS repositories.
Confidential
Role: Consultant Computer Operations Lead, Build Release Engineer, User Support
Environment: Perl, CGI, HTML, JavaScript, Solaris, Oracle 9i, Korn Shell, C , SQLPLUS
- Modifying, upgrading or building ComSys Perl/CGI/JavaScript web pages to support the changes required by the operations department.
- Preparing SQL scripts to perform precious metals data extracts for the Market Risk department.
- Extracting and converting data from XML feeds into flat text files for inclusion into Excel spreadsheets.
- Preparing Perl scripts for scraping data from websites for use as feed data for the daily batch.
- Preparing SQL scripts to perform database tables and records changes as requested by the trading department.
- Providing back end programming and technical support to the Commodities Derivatives System ComSys trading application
- Building cross environment production application packages for installation onto the production and UAT servers.
- Archiving production packages into the Hermes system archives.
- Providing technical account support to traders located in London, Hong Kong, and Singapore.
- Automation of the build process via Perl programs and Korn shell scripts.
- Performing regression testing of application build release packages.
- Developing Perl monitoring/reporting software for compliance and to preempt UNIX and Oracle login associated problems.
- Performing system administration tasks with associated with the archiving of online reports.
- Performing Function Point Analysis of the power trading modules for use in the enhancement of the ComSys application for energy trading.
- Setting up, validating new user accounts and providing remote technical support to users in Texas, London, Singapore and Hong Kong with respect to resolving hardware and software problems associated the user accounts.
Confidential
Role: Consultant Quality Assurance Software Tester
Environment: Linux, shell scripts, C , Perl, Perl-XBase, Dbase, EXPECT
Primary task: Black box testing the Call Processor Manager System CPS Reports. Revising user documentation to ensure that documentation was reflective of the latest software release capabilities. Developed XBase and C tools to independently validate the application generated CPS reports.
Confidential
Senior Staff Engineer
Bath Iron Works Electronic Bill of Materials software development for the DD21 Project:
Role: Lead Programmer and Quality Assurance Engineer
Environment: C, Excel, Perl, YACC, AIX, Solaris, shell scripts
- Developed, in C and Perl, data extraction procedures from CAD models and CAD databases.
- Developed, C functions, for transformation and scrubbing of CAD data for database table importation.
- Created shell scripts and C programs for standardization and formatting of commodity input data.
- Created test plans and test cases for testing applications under development.
- Created Korn shell scripts to automate the data extraction processes.
- Developed lookup tables and formatting software to insure standardization of nomenclature within the data extracts.
Confidential
Role: Marine Engineer and Quality Assurance Engineer
Environment: Moses, Excel, VB, Perl, Korn Shell, AutoCAD
- From the vendor's manuals learned to use the analytical software prescribed by the project Naval Architect.
- Developed solid 3D finite element models of the barge and ancillary structures.
- Tested and validated the analytical software prior to release of the models for analysis.
- Resolved software and modeling issues.
- Performed sea motion loading analyses of the barge and reported results of detailed statistical analyses.
Confidential
Role: Lead Programmer and Quality Assurance Engineer
Environment: VB with Graphics, C , FORTRAN
- Developed a graphical user interface whose primary function was to link legacy punch card image based programs for sequential execution and post-processing of ship motion analyses as polar graphics for inclusion into technical reports on a Windows platform. As a consequence of the application's primary function it was necessary to upgrade the legacy programs, develop pre and post processing functions to insure compliance with record and field specifications for the interface linking all the programs. Client requirements for the application were to present the user with graphical user interfaces for:
- The selection of SHCP and FREDYN files, directories and data subsets.
- Checking for the existence of required files across a WAN network.
- Sequential execution of the programs from a graphical interface.
- Pre and post execution field error checking of all input data.
- The post processing the frequency and dynamic response analyses results as polar coordinate plots.
- Providing GUI plotting options to allow the user to select data, ranges, scales and colors.
Confidential
Role: Technical Writer
Environment: Word, Excel
For ISO 9000 certification, tasked to develop and author company standard for the development of new software applications and the upgrade of legacy software applications. Developed standards that covered the development and checking of technical spreadsheets, the design requirements for databases and their table structures, programming coding style, code commenting requirements, guidelines for the development mixed language applications, guidelines for the use of Make files, the requirements for application testing, and the requirements for the development and documentation of application validation data sets. Also included were the requirements and guidelines for administration of source code control and version control, Quality Assurance testing, test plan development and test plan documentation, regression testing, Make files documentation, performing project source code and project version control, project code distribution, and project archiving.
Confidential
Role: Programmer, Source Code Manager, and QA Engineer
Environment: VB, C, C , FORTRAN, Perl, shell scripts, SCCS, Oracle, Pl/SQL SQL, et al
- Provided coding, programming and analytical support for the development of custom client/server applications to support multiple engineering disciplines on Solaris, AIX, and Windows platforms that connecting to an enterprise Oracle relational database. Responsibilities included but were not limited to:
- Data analysis and non-linear numerical regression analyses of engineering design data in order to develop of data functions for stand-alone applications and look-up tables in Oracle and Access databases.
- Analysis and data modeling of new and proposed software modules.
- Development of data extraction software linking CAD model databases and Oracle databases to discipline specific custom engineering applications.
- Debugging mixed-language applications developed in VB, C, C , FORTRAN, Perl, AWK, UNIX shell scripts, PL/SQL and SQL.
- Creating Make files to build mixed-language applications.
- Creating shell scripts and scaffolds to automate software testing
- Creating SQL loader files and Oracle data tables in order to incorporate vendor supplied engineering data into ship and engineering databases.
- Directly responding to client and end user requests for software upgrades or to resolve reported application errors.
- Preparing code specifications, time and cost estimates for upgrades and modification of applications.
- Analyzing and resolving remote site user software problems.
- Source code control manager tracking revisions, documenting application history and fulfilling project management and client quality assurance reporting requirements.
- Preparation of application documentation and user manuals for internal and external distribution.
- Migration of engineering calculations and drawings from paper to software, tasked with responsibilities for:
- Resolving hardware, software installation and configuration problems of four technical departments.
- Migrating engineering applications from a mainframe to Windows and UNIX platforms.
- Performance tuning of migrated legacy engineering applications.
- Developing applications, written in C, C , FORTRAN, and VB, to automate and perform engineering calculations specified in the project contractual requirements documents.
- Re-writing legacy applications to accept both command line and file inputs thereby allowing the applications to execute as either interactive or batch.
- Migrating Lotus and Quattro technical spreadsheets to Excel for multiple technical departments.
- Providing programming and software support for concurrent paper and electronic design efforts.
- Revising legacy applications to transparently allow either manual or automated data input from designers, CAD models and Oracle databases.
Confidential
Role: Programmer and Software Tester
Environment: SQL, Oracle. C, C , Pro C, CGI, HTML, Java, JavaScript, Perl, shell scripts
- To allow the US NAVY and two competing shipyards limited and controlled access to proprietary ship design databases:
- Designed and co-developed the structure and data flow of the secure website.
- Co-developed secure web pages using C, C , Pro C, CGI, HTML, Java and JavaScript.
- Used PL/SQL to populate and publish daily data extraction from the Oracle databases.
- Automated the one-way daily data transfer from a master AIX server to an Apache web server.
- Developed C programs to dynamically create discipline specific and shipyard restrictive SQL queries.
- Developed automated scripts to present output data.
- Authored and executed web site test plan.
Confidential
Role: Lead Programmer and Quality Assurance Engineer
Environment: VBA, Unix/AIX shell scripts, Excel, Access, C, SQL, Perl, AWK
For the Weight and Mass Moment Department developed Excel/Visual Basic reporting tools and GUIs to replicate UNIX legacy reporting tools tools for the bulk migration of data to Excel worksheets from legacy flat files residing on UNIX and Windows platforms GUI tools to enter and extract data from RAN Access databases.
Confidential
Role: Database Programmer and Quality Assurance Engineer
Environment: SED, FORTRAN, Perl, SQL, Excel, Dbase, Unix/AIX shell scripts, Access, Oracle
Assembled and created an FFG7/PFG2 weight control database from ship data residing in legacy FORTRAN, Excel, and Access and Oracle databases. Collated, correlated, reformatted and extracted the subset of data pertinent to the ships of the PFG2 class. Per client requirements, migrated assembled data extracts to DBase.
Confidential
Role: Technical Programmer, Quality Assurance Engineer and Software Tester
Environment: FORTRAN, C, LINT, C , SCCS, VB, CVMAC, Make, Oracle, SQL, shell scripts
- Continued support of the Upgrade Program by provided engineering, analytical testing and programming support for the development and evolution of the following mixed language client/server engineering software tools:
- The HVAC Heat Load Calculations programs.
- The HVAC System Pressure Drop Calculations programs.
- The G C Cable Routing programs.
- The What-IF Design Scenario simulation modeling and analysis software.
- The Longitudinal Strength naval architectural structural design software.
- The Dead Bus electrical modeling and analysis software.
- In addition, tasked with the following responsibilities:
- Developing test plans, test cases and performing regression tests on upgrades to the aforesaid software tools.
- On a demand basis, revising and upgrading associated supporting Oracle data tables and data query routines for the aforesaid software tools.
- Providing upgrade support to the US NAVY Paperless Ship Initiative that attempted to move all engineering design and drawing tasks from paper to software.
- Providing instructions and assistance to the HVAC designers in the use of CAD based HVAC design software tools.
- Performing CAD model design and interference checking of distributives systems.
- Performing CAD model checking of compartment arrangements for the removal and maintenance of equipment.
Confidential
Role: System Administrator and System Programmer
Environment: C, SED, AWK, shell scripts and system tools et al
- Back-up system administrator for a Solaris/ComputerVision CADDS installation with responsibilities for:
- The automation of repetitious tasks via shell scripts and C programs.
- Resolving system, modeling, and user problems.
- Performing system maintenance, backup and recovery.
- Loading and recovering CADDS models to and from tape archives.
- Maintaining project model libraries and user model libraries.
- Providing CADDS and UNIX instructional assistance to designers and engineers.
Confidential
Role: Project Supervisor, Lead Technical Programmer, and QA
Environment: Oracle, SQL, Pro C, Pro FORTRAN, C, FORTRAN, AIX shell scripts, Solaris system tools, CADDS, PSI-Plot, CVMAC, SQL Loader, VB
Engineer tasked with the following responsibilities:
- Developing shell scripts and programs for locating and extracting non-graphical data from CADDS 4X models in response to the needs of the design staff for checking CAD models.
- Providing training and instruction in the use of the developed software.
- Stress testing of Computer Vision/PTC software packages to insure full functionality prior to purchase.
- Developing an Enhanced Geometry Control Model for controlling and checking both the geometry and structural change made to DDG51 class ships.
- For the US NAVY Paperless Ship Initiative mandating the development of an Oracle database containing a complete inventory of all parts, materials, systems, tools, and data required to engineer and build a DDG51 Class ships:
- Co-developed Oracle tables to comply with the requirements delineated by the Navy/Industry Digital Data Exchange Standards Committee NIDDESC .
- Performed analysis and data modeling in order to develop, design and normalize the structure of database tables.
- Performed material analysis for the development and design of material data tables.
- Developed SQL data query routines and functions for extraction of data from the database.
- Developed procedures and functions linking engineering software tools and programs to Oracle databases.
- Co-developed shell script menus to access and check data within the Oracle databases.
- Developed functions and programs to extract data from CAD models for import into Oracle databases.
Confidential
Role: Project Supervisor, Lead Technical Programmer, and Client Liaison
Environment: Basic, Lotus, FORTRAN Harris, IBM, VAX, MS , Excel, C, AutoCAD, et al
- Technical liaison between client, US NAVY and Gibbs Cox on all acoustic noise control and access control issues for the design of the FFG7 and DDG51 class ships. Supervisor and lead technical programmer of two engineering teams assigned to the preparation of acoustic noise control and access control calculations, drawings and documentation. Responsibilities included but were not limited to:
- Preparing project plans and obtaining client sign-off of proposals.
- Preparing project budgets reflective of the approved project plans.
- Preparing and obtaining approval of manning estimates, man-hour budgets and scheduling
- Preparing tracking reports and reporting status of projects to upper management, the client and the US NAVY.
- Developing interim technical spreadsheets in Excel and VBA for the automation of noise and rigging calculations.
- Data flow modeling acoustic and access control data in preparation for software/database development.
- Coding and constructing acoustic noise and access control applications and databases.
- Mathematical modeling and analysis of equipment removals.
- Providing formal project and technical presentations to the US NAVY.
- Preparing formal technical reports and documentation for issue to the client and the US NAVY.
- Responding to and resolving post-project issues.
Confidential
Role: Engineer, Analyst and Programmer
Environment: FORTRAN Harris, VAX, Univac 1108 , Punch card based software
- Performing statistical analysis of ship classes to develop predictive parametric performance and costing models of future US NAVY warships. Results were used in the development of the DDG51 class ships.
- Developing airborne noise prediction programs for use with US NAVY ships.
- Performing stability analyses of the US Navy Sea Control - Spanish Navy Aircraft carrier.
- Performing statistical analyses of ship compartment and machinery spaces for the development of predictive cost and stability algorithms for use with ship upgrades.
Confidential
Role: Engineer, Technical Lead and Programmer
Environment: STRUDL, NASTRAN, FORTRAN 77, VMS , Basic, Lotus, Dos, DBase, FoxPro
- Engineer tasked with:
- Evaluating stress and dynamic vibrations of ship structures and foundations using STRUDL and NASTRAN.
- Performing analysis and design of ship structures and mechanical systems at sea under simulated battle conditions.
- Performing predictive acoustic analyses of ship compartment to ensure compliance with builder's specifications.
- Performing mathematical modeling and studies of helicopter-hangar evolutions in preparation for shipboard testing of helicopter recovery and launching systems.
- Developing PC based software applications to expedite the analysis of engineering analyses.
- Developing post-processing software to expedite the analysis of finite element results from NASTRAN and STRUDL
- Evaluating divisional computer hardware and software needs providing ordering documentation to the division head.
- Converting USN Design Data Sheets into engineering technical spreadsheets to expedite design calculations.
- Installing and configuring both PC software and hardware for the Hull Engineering Division.
- Developing technical spreadsheets in Lotus to expedite engineering calculations.
- Developing technical databases for use in the development of construction drawings and parts lists.
- Training and instructing core divisional and departmental staff in the use of PC and software.