Project Manager

Posted on: 2007-02-04

Summary: More than fifteen years experience in database design, development implementation, and project management. Engaged in full systems development life cycle (SDLC) practices. Strong written and oral communications skills as well as analytical abilities. Project Management Certification: Passed the examination for certification as a Project Management Professional (PMP) given by the Project Management Institute (PMI), 1988. Management: Managed the work of a large team of application developers and database administrators located in three geographic sites for Lockheed Martin Mission Systems. The system developed is the largest, most complex logistics management in existence to date and was a distributed, Internet-accessed system. Communicated important aspects of project including progress as well as changes to work in both written and verbal form. Assessed risks of projects and took actions to avert the occurrence of adverse consequences. Determined resources required to complete work including hardware and software as well as manpower. Estimated time necessary for completion based on records of time actually spent during past projects as well as in consultation with team members. Developed Work Breakdown Structure showing units of work which were manageable, controllable, and scheduleable as well as depicting milestones for completion. Capability to negotiate favorable terms of contracts with vendor and suppliers. Focused in management of fast-track projects to complete the scope of work on time and within budget. Utilized tracking systems to ascertain whether the project was falling behind schedule so as to take corrective measures in a timely manner. Systems Architecture: Planned architecture and design of systems after ascertaining business requirements. Selected hardware, middleware, and software to result in a finished system which functioned well. Knowledgeable in datawarehousing and data mining. High Availability architecture, disaster recovery, mirroring, clustering, and partitioning. Web Technologies: Familiar with Java, J2EE, and XML technologies. Database Technologies: Sybase, Oracle, MS SQL Server Extensive troubleshooting and problem-solving. Highlighted experience (chronological follows afterwards): Lockheed Martin Mission Systems 1998 - 2000 Defense Information Systems Project: Global Air Transportation Execution System (GATES), an interface which is part of the Global Transportation Network (GTN), a logistics management system. Customer: United States Transportation Command (USTRANSCOM) Sybase Adaptive Server 11.5; Sybase Replication Server 11.5 5,000 database objects, production environment of 65 gigabytes replicated across 4 nodes in two geographic sites Summary of activities: Database administration, data mapping, physical and logical database design in a complex schema, business rules, stored procedures, triggers, cursors, system integration testing under replication, data archiving, error processing, installation support for production system, post-installation modifications for production system Replication: Assisted with work associated with creation of replication definitions and subscriptions, creation and mapping of function strings, and user-defined functions. Re-started data queues on Replication Server which had stopped due to errors. Monitored Replication Server. Database Design, Development, & Administration: Modified schema to create new columns and tables to properly relate entities which were previously unstored in such a way as to allow for a high speed of retrieval of query results. Created a multitude of stored procedures to process the data feed in a replicated environment as well as having created tables, indexes, and keys. Worked with the processing performed by triggers to ensure that they were fired in all necessary cases. Re-considered the means of data archiving and worked on the data archiver. Created cursors as part of the database testing phase in order to run a multitude of specified cases to ensure that no erroneous processing occurred. Participated in code modifications for an error processing tool used by the customer. Used the bulk copy utility (bcp) to load the database with large amounts of data. Set permissions for accessing data. Utilized showplan, forceplan, statistics io, and statistics time to optimize code. Selectively introduced data redundancy to speed the return of query results. Data Modeling & Schema Design Tools: ERWin Data Modeler, Sybase PowerDesigner Data Architect Reporting Tool: Crystal Reports System Integration & Testing: Participated in and coordinated activities related to system integration testing for the replicated system. Made modifications to correct processing. Performance tuning. Created UNIX shell scripts in order to run tests automatically and to perform routine tasks such as re-creating the database. Worked in a system environment under the control of configuration management systems. Involved in code modifications through several rounds of system integration testing in a replicated environment through to the final Customer Acceptance Test. Tools: Change & Configuration Management / Version Control: Rational Clearcase Installation Support: Provided the installation instructions for the main release, the release of patches, the version description document, and the data archiver for the database code. Provided support during the installation on the live production system which included working on weekends and late into the evening. Product Reviews: Participated in Peer Review meetings (about 30 reviews) by reviewing code and providing feedback as to corrections and improvements for other projects as well as our own. Represented the GATES project team as the expert on the details related to the database code in Engineering Review Board meetings and Product Review Board meetings. Quality Assurance: Ensured that the entire team followed all necessary processes and procedures which were streamlined. Both the quality of our code as well as its associated documentation and the timeliness of our delivery of the product to our customer, the United States Transportation Command (USTRANSCOM), were commended by the Quality Assurance department which audited us several times. Miscellaneous: Provided information used in capacity planning for the live production system and the data archive. Additional experience: (confidential - an Internet company) 2006 - Present Troubleshooted problems with Sybase ASE, Sybase Replication Server, and Sybase IQ in a complex, heterogeneous environment. Prudential 2006 Production Support DBA (24/7). Upgraded Sybase Adaptive Server Enterprise and Sybase Replication Server from version 12 to version 12.5 on a Sun Solaris platform. Configured parameters for optimum performance of the Servers. Maintained and troubleshooted existing instances of ASE and Replication Server. Performance tuned both ASE (at the levels of both the server-and the database) as well as Replication Server. Created replication definitions and subscriptions. Performed backups and loaded new database instances. Monitored overnight batch jobs and dumps. Archived data into a data warehouse. Transferred subsets of data into new databases. Increased database size and cleared directory space as needed. Controlled access. Audited database use. Performed DBA work associated with quarterly releases of new software which accessed data from multiple dataservers and databases. Utilized Unix utilities for Sybase. Wrote Unix shell scripts to automate tasks. Troubleshooted Sybase Open Client problems. Star Funding 2002 - 2006 Production Support DBA & Project Manager. Work was performed associated with ongoing maintenance of Sybase ASE versions 12 and Sybase Replication Server versions 12. Backup and recovery. Failover strategy & disaster planning. Security and permissions. Performance tuning. Referential integrity maintenance. Index structuring. Utilized bulk copy utility. Utilized capabilities of optimizer. Barclays Capital 2000 - 2001 Production Support DBA (24/7) to enable the smooth operation of the day-to-day activities of the investment bank. Provided global as well as local support for database systems in a Sybase replicated environment and also a Microsoft SQL environment. Management of batching for complex transactions. Installation, configuration, setup on Sun Solaris platform. Created and scheduled autosys jobs. American Steam Timer Corporation 1988 - 1998 (most recent work is described below) Sybase SQL Server Administration for Versions 4, 10 and 11: Upgraded from Sybase version 10.x.x to 11.x.x Installed and configured SQL Server 11.0.x (UNIX & NT) for production, warm-backup, development/test, as well as disaster recovery. Set up UNIX shell scripts and cron jobs to perform the database administration activities for each server. Examined error logs throughout each day to ensure servers were running at optimal levels. Verified each morning that the databases were properly dumped the night before in order to maintain up-to-date backups. Monitored growth of databases and altered their size when the amount of available free space was low. Added/removed users from the Sybase servers and user databases to maintain security. Database Design / Development / Administration: Creating and using tables, primary and foreign keys, indexes, views, stored procedures, cursors and triggers as well as maintaining referential integrity. Mapping of database to proposed new business process to ensure accounting for all the data. Adjusting database design selectively to a denormalized form to improve speed of information retrieval yet still avoid modification anomaly. Performance & Tuning: Troubleshooted and corrected performance problems by performing a variety of diagnostic checks or further utilizing the capabilities of the Sybase Server to improve performance. UNIX Shell Scripting: Korn, Bourne, Bourne Again, C shells used to convert files to appropriate formats. Pattern matching; editing (vi, sed); awk scripting language for processing databases fields; formatting text files using nroff & troff; Source Code Control System to track revisions. Education: The Entrepreneurial Center: Reengineering, Strategic Planning, Finance, Accounting, Marketing, Operations, and Sales. Project Management Certification, Passed the examination for certification as a Project Management Professional (PMP) given by the Project Management Institute (PMI), 1988 The City College of The City University of New York, Bachelor of Engineering, May 1986 Columbia University, Postbaccalaureate Program in Computer Science