Project Manager Resume
NJ
QUALIFICATIONS: Oracle Certified Professional Developer, DBA and Architect with in-depth knowledge of SQL, PL/SQL, Oracle RAC, Data Guard, RMAN, Oracle Discoverer, Oracle Designer, Oracle Data Warehouse, Crystal Reports, Business Objects, Oracle Advanced Security, Oracle 9i 10g, 11i,Unix, Windows 2003, IBM AIX5. Expert in using, OEM, RMAN, SQL LOADER, TOAD, MS Project, VISIO, ER-WIN, Unix Shell Scripting. Developer having 15 years experience in Full Life-Cycle Software Development. 10 Years experience in Training/Courseware Development. Subject Matter Expert in developing and implementing systems security policy, guidelines, and procedures for systems processing multiple applications that require differing and conflicting security controls.
SECURITY CLEARANCE: Active Top Secret, US Citizen.
EDUCATION:
M. B. A. Finance
PROFESSIONAL EXPERIENCE:
4/2006 to Present Confidential, Senior Oracle DBA/Project Manager
Installed several Oracle Datagurd Instances on Oracle 10204 and 11202 for DOJ on IBM-AIX plateform. Work with application developers to ensure data integrity on Primary and Logical Standby Databases. Performance monitoring and Tuning of all databases using Oracle Grid Controle and AWR Reports. Redesigned the Database. Created roles, privileges, functions to conrol access for the Momentum (CGI) application. Created Workgroup mode and Enterprise mode environments for Business objects. Created and modified BO Universe, Classes and Objects, Fact Tables and Aggregate Tables as and when requested by endusers. Reviewed final software installation and system plans for additional security risks not identified during proposal stages and recommended work process changes and general design and programming techniques to alleviate potential security problems. Investigated security incidents for cause and the most effective corrective actions. Monitored and evaluated changes that effect systems security. Installed two node Oracle RAC. Created proof of concept for a Oracle Data Warehouse. Created programs using unix shell scripting to automate processes. Set up Oracle Golden Gate and demonstrated proof of concept for senior managers and govt officials. Senior Oracle DBA responsible for MHS LEARN database for Tri-Care, US Military Health Care System. Migrated over 2 Million user accounts from a previous system to Oracle 10g Database using HIPAA guidelines. Maintaing the Database in Production Development and Testing Environments. Coordinating with DBAs and managing servers in Unix VIA VPN and windows environment. Apply Security Patches (CPU Patches) and Upgrade patches to Oracle Databases and Application Servers. Upgraded Oracle Database from 9.2.0.8 to 10.2.0.3 10 to 11202 Upgraded Oracle Application Server from 9.2.0.3 to 10.1.2.0 to 11.2.1 Set up a 2 Node Oracle RAC. Expertise in OEM, RMAN, and TOAD. Supervising 3 DBA’s and 4 Developers. Planned, scheduled, coordinated and monitored the Database downtimes and ensured 24/7 availibility. Advised management on setting goals and targets. Supervised project planning using Ms. Project to ensure meeting deadlines. Trained personnel. Made presentations to senior management and govt. officials. Conducted special security studies, analyses, surveys and reviews of IT systems to assure that appropriate levels of safeguards exist to protect against perceived threats. Planed and directed the development of security criteria and guidelines for users of IT systems.
2/2005 to 3/2006 Confidential, Project Manager
Keyview Systems Manager responsible for maintaining US Army’s Personnel Database for creating reports. Roles and responsibilities include; plan, direct, and co-ordinate a cross-functional team activities to manage and implement project and interrelated programs from contract/proposal initiation to final operational stage using MS Project. Leading a 4 person Data Warehouse project to redesign an existing antiquated system. Established risk-management procedures and ensured that risk-management techniques are applied to all new or modified computer applications. Continually evaluate current system security posture, monitors activities, and assesses the security awareness knowledge of staff as it relates to assigned areas of responsibility. Determined, monitored, and reviewed all project economics to include costs, operational budgets, staffing requirements, sub-contractors, resources, and risk. Identified and assembled the appropriate blend of resources to meet project/program needs and requirements, including sub-contractor selection. Planed, scheduled, monitored and reported on activities related to the project. Lead the project team in determining client requirements and translating requirements into operational plans. Maintaind awareness of emerging technologies and project management techniques. Designed a system that creates and sends out reports without human intervention and help save thousands of man hours. Redisgned an Oracle Datawarehouse and improved response time. Supervise 7 developers and 3 DBAs. Managed 2 subcntracting companies. Implemented Track-It to track Help Desk calls and improved response time. Hired and trained personnel.
9/2004 to 1/2005 Confidential, Oracle DBA/Senior Consultant
Oracle DBA responsible for 7 Servers and 3 environments, namely Production, Development and Testing. Managed Oracle 9i migrating to Oracle 10g. Technical expert in using OEM, RMAN and TOAD to perform migration, backup and restoration of databases. Created Data Model using ER-WIN. Loading and transporting data using SQL Loader. Support application developers. Expert on creating new environment for the next release of the application. Supervised 4 DBAs and 6 developers. Facilitated status review meetings among project team members and clients. Worked with senior management on project proposals, bids, contracts, estimates, and schedules using MS Project. Proposed and developed add-on program opportunities. Mentored and trained the customer and vendor in project management methods, procedures, and activities. Controlled project requirements, scope, and change management issues. Coached and counseled members of cross-functional teams to accomplish project goals, to meet established schedules, and resolve technical/operational issues. Established appropriate metrics for measuring key program criteria. Managed setting up of Oracle Data Guard Environment.
6/2004 to 7/2004 Confidential, Oracle DBA/Senior Consultatnt
Lead DBA/Developer responsible for monitoring production, development and testing Oracle Databases on 15 servers. Performing backup and recovery using RMAN. Create instances and migrate data on new instances. Migrating, upgrading and cloning databases. Development of detailed design for the next release. Used MS Project to support and monitor several application developers for the National Guard. Determined and installed appropriate automated systems for management of projects. Facilitated the creation of communication plans, ensuring that appropriate information is exchanged among key stakeholders. Identified and recommended contingency measures.
1/2003 to 4/2004 Confidential, Oracle Database Administrator
DBA on Integrated Clinical Database (ICDB) for Walter Reed Army Medical Center having thousands of concurrent users. Managing 15 on line databases. Create programs, functions, packages, libraries and triggers in PL/SQL. Create automated reports on daily, weekly and monthly monitoring of the databases. Perform Export/Import. Install Oracle 9i Application server and maintain 3 Web Servers. Manage Database using Oracle Enterprize Manager (OEM) and Tools for Oracle Application Development (TOAD) and MS Project. Perform backup and recovery using Recovery Manager (RMAN). Data Loading using SQL LOADER. Version upgrades on Oracle. Perform version upgrades on ICDB. Provide management support to 10 developers and programmers using MS Project. Created automated reports using UTL file. Maintain a development environment in compliance with HIPPA.
9/1998 to Present Confidential, Part Time Faculty Member
Oracle DBA and Instructor teaching Introduction to SQL, PL/SQL (Advanced SQL), Database Administration, and Oracle Forms on Oracle 8i, 9i. Explaining SQL and PL/SQL concepts to students by creating cursors, procedures, functions, packages and triggers. DBA for Evening Programs. Prepared training manuals for the classes. Designed the Pay-Stub application using SyBase PowerBuilder8 Object Architect with Metaworks. Created the Pay-Stub applicaliaction using Visual J++ and Video Rental application using Oracle Forms. Prepared a mailing list report using Crystal Reports. Developed “Inventory Tracking” application using Object Oriented methodology. Created a Data Warehouse and created programs to extract information. Created application using Oracle 9i Forms and Reports. Expertise in using TOAD and SQL Navigator to monitor database and Debug programs.
6/2001-12/2002 Confidential, DBA/Software Developer
Hands on consultant Project Manager and DBA responsible for a team of software developers. Full lifecycle application development utilizing oracle tools. Developed statement of work for projects and monitored projects using MS Project. Evaluated competing proposals from several vendors. Performed Requirements Analysis, Data Modeling, Logical Database Design, Design reviews and Physical Database design. Reviewed deliverables from subcontractors relating to software applications .
4/2000 to 11/2001 Confidential, Programmer Analyst IV
Project Manager and Oracle DBA responsible for creating test procedures and unit tests for Weapons Direction System (WDS) project. Imported data into tables for MCPS project.
11/1996 to 03/2000 Confidential, Sr. Programmer
Microsoft Access, Excel Programmer using Visual Basic For Applications. Created Loan Adjustment Program. This Program calculated interest payment adjustment based upon credit ratings and several other factors. Maintained Oracle 8i Database on Windows platform. Created users assigned roles and privileges, maintained tablespaces and monitored space. Projected space requirements for the next quarter.
11/1992 to 10/1996 Confidential, Financial Analyst/Programmer
Created weekly, monthly, quarterly and annual financial reports in MS. Excel for the project at NASA. Redesigned and reorganized several reports to display relevant information. Created first program using Ms. Access and SQL Language to keep Employee information for Human Resources department. Program allowed the Project manager to get information on employees and the projects.
04/1992 to 10/1992 Confidential, Production Manager
Financial Analyst analyzing data of failed Banks and Savings and Loans companies. Prepared detailed reports using Lotus 123 and Ms. Excel showing the misappropriation of funds for the prosecutors. Responsible for a team of 15 analysts.
08/1989 to 03/1992 Confidential, Management Associate
Rotated in all departments of the 1200 Rooms hotel to understand the business. Worked with the assistant controller on preparing and maintaining financial reports. Created 30-60-90 accounts receivable reports using Lotus 123. Created manpower reports using Lotus 123 for up coming banquets. Worked with General Manager on special projects. Created financial report in MS. Excel for a new deli style restaurant.
CONTINUING EDUCATION:
Oracle Certified Associate Oracle Certified Professional Gaithersburg, MD 2003
Project Management USDA Graduate School Washington, DC 2001
Local Area Network Concepts USDA Graduate School Washington, DC 1999
Windows NT 4 Server Administration USDA Graduate School Washington, DC 1999
Crystal Reports 6.0 Aalpha Systems Gaithersburg, MD 1998