It Project Manager/sql Dba Manager Resume
Mcdonough, GA
Summary
I am a creative Project Manager, Business Analyst, Senior SQL DBA and IT Management professional with a record of increased responsibility. I am Proficient in prioritizing and completing projects and assigned tasks to time, budget, schedule, yet flexible to multitask when necessary. I enjoy learning new programs and processes. I am a team player who is attentive to detail and able to work in a fast paced environment. I have excellent oral and written communication skills and problem solving and negotiating skills. I am able to make decisions independently and quickly with minimal escalations. I am highly proficient in IT Project Management, ITIL Service Management/implementation, IT Infrastructure Management, IT Vendor/Customers Management and IT Hardware Software Management. I also manage Databases as a Database Administrator - DBA (SQL and with little flare for Oracle).
Major projects successfully managed to date: I have been able to manage the following projects successfully using onshore and offshore resources: GSM Billing application upgrade, Oracle ERP Implementation, Business Intelligence (BI) Implementation, ITIL Service Management Implementation, e-Portal Rollout, Microsoft Exchange rollout, Telco Fraud Management Systems Application rollout, IT Remedy Application Implementation, IT Assets Audit and Tagging, Friendship Centers Rollout, Business to Business site rollouts, IT Hardware and Software Preventive Maintenance project, IT Asset Management Process Development, Business Process Re-engineering, Microsoft SMS implementation, WAN/LAN implementation (Structure cabling), Data Center HW rollout
Management and Technical Skills Overview
- Management: strong leadership, direction, guidance, decision making, verbal and written communications
- Project management: facilitation, risk assessment, task decomposition, resource planning, tracking using PMBok, SDLC and Prince2 methodology
- Asset Management: routine maintenance, asset recording system (Identification, verification, correction and reporting), budgeting, contractual obligations and financial obligations
- Operations support: 7x24, helpdesk, change management, configuration management, SLA management
- Vendor/Procurement: vendor management, volume agreements, and inventory management
- Databases: SQL and Oracle - Data Migration, Disaster Recovery, Integration Services, Performance Tuning, Reporting Services, Database Upgrades patches, Backup and Recovery, Database Security and High Availability Solutions
Professional Job Experience
Confidential, IT Project Manager/SQL DBA Manager (2010 September present) McDonough, GA 30253
- Training, facilitating and educating project managers, IT Managers, supervisors, general staff and the public in Project Management (principles, methodologies and techniques) and ITIL/IT Service Infrastructure Management.
- Defining roles and responsibilities, and providing oversight on the overall programs and projects
- Overseeing the development, design, and implementation of new applications and changes to existing hardware systems and software packages for customers.
- Managing a team of 14 professionals (6 remote and 8 onsite) and coordinating them to achieve project goals and objectives.
- Provide remote support to SQL Servers on customer sites of different companies.
- Writing, debugging, and tuning Transactional SQL, ETL and stored procedures.
- SQL Server database physical model creation and implementation (data type, indexing, table design)
- Setting up and administering SQL Server Database Security environments using Profiles, database Privileges and Roles.
- Database maintenance, replication and tuning
- System database migrations and maintenance
- Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers.
- Supervise all aspects of the assigned team including day-to-day supervision, performance evaluation, and assignment to IT Projects and/or Production Support functions.
- Ensuring definition and development of database documentation and standards
- Ensuring Database performance monitoring and tuning is regularly accomplished
- Designing backup and restore strategies and Disaster Recovery solutions
- Implement security policy design for current and new applications.
- Coordinate team meetings with groups for any new design/strategies.
- Creating database design for new projects support.
- Implementing RAC ASM and upgrading databases in 10g/11gr1/11gR2
- Coordinating and facilitating change review meetings and helping in the management of incidents according to SLAs
- Developing information systems testing strategies, plans, or scenarios using SDLC and Agile.
- Planning and administering projects and the overall program using PMI Guide and expert judgment.
- Collect requirements, project scoping, documentation and serve as a SPOC (Single Point Of Contacts) for Customers
- Ensures that project and program deliverables and benefits align with the customers objectives and advice for change
- As needed and appropriate but no less than annually, providing written technology policy guidance to managers, supervisors, staff and consumers/participants.
- Managing all applications and IT infrastructure projects including major, minor or emergency releases using Agile, SDLC and PMI-guide to cost, time, schedule, quality, and customer satisfaction.
- Oversees some of the functions of the PMO and recommending corrective measures based on expert judgments
- Managing Desktops Printers Maintenance Contracts based on the ITIL Service Management model in line with the overall customer strategy of reducing Total Cost of Ownership.
- Developing annual technology goals and detailed plans for goal accomplishment. Preparing, maintaining and testing technology disaster recovery plans. Managing external technology projects.
- Managing, leading, and administering project resources and monitoring project activities and resources to mitigate risk
- Respecting confidentiality in discussing consumer/participant, staff, volunteer and organizational matters; also maintaining confidentiality of organization, project, fiscal and personnel related information.
- Providing technical supervision of technology interns; supervising other staff as directed; annually updating technology job descriptions; completing technology staff evaluations.
- Managing annual routine preventive maintenance projects of all hardware and software (e.g. BI, Data warehouse ERP).
- Using problems solving skills and root cause analysis to resolving and/or mitigating IT operational issues
- Ensuring conflict resolutions and managing project risks, issues, actions and change logs.
- Identifying, updating, developing, implementing and managing ITIL management best practice processes.
- Analyzing technology requirements and developing functional specifications. Conducting comparative analysis and competitive bidding when necessary.
- Presenting and implementing technological alternatives to streamline functions and improve productivity.
- Developing and maintains technology policies, standards and procedures manual; developing and maintains related technology checklists.
- Ensuring compliance with all software licensing agreements. Managing and safeguarding software media and associated licenses. Tracking software versions and maintaining centralized software use log.
- Developing and managing technology budget and monitoring and approving related expenditures. Reviewing and approving cost pool expenditures. Assisting in other duties as needed and directed
Confidential, Project Manager (2009 May 2010 June) Banana Island, Lagos
- Defining project scope, definitions and deliverables that support business goals in collaboration with senior management and stakeholders.
- Organized, trained facilitated and managed the training academy setup by the Organization for Training Project Managers
- Developed and implemented policies, processes and procedures for managing IT related projects
- Overseen the development, design, implementation of new applications and changes to existing computer systems and software packages for the customers
- Coaching, mentoring, motivating and supervising project team members and contractors, and influencing them to take positive action and accountability for their assigned work
- Managed all risks, issues, and actions logs
- Prepared and submit management daily/weekly/monthly/adhoc reports
- Managed and tracked all projects deliverables and milestones and prepare dashboard reports
- Championed all project meetings and track related minutes emanating from the meetings
- Managed all projects schedules and reverse plans as at when needed
- Identified standards or requirements for infrastructure configuration or change management;
- Ensures appropriate product-related training and documentation are developed and made available to customers.
- Determined appropriate products or services with clients or customers to define project scope, requirements, and deliverables. Also, develops, modifies, and provides input to project plans
- Implements project plans to meet objectives and coordinates and integrates project activities
- Managed, lead, and administered project resources and Monitored project activities and resources to mitigate risk. Also implemented or maintained quality assurance processes
- Made improvements, solved problems, took corrective action when problems arose
- Gave presentations on a regular basis or briefings on all aspects of every project managed.
- Coordinated and facilitated change review meetings and helping in the management of incidents according to SLAs
- Proactively managing changes in project scope, identify potential crises, and devise contingency plans.
- Identified project documentation requirements and procedures. Developed and implemented product release plan
- Evaluated, monitored, or ensured compliance with laws, regulations, policies and standards. Maintained the contract data
- Collected information regarding complex situations and considered various perspectives and provided valuable and appropriate recommendations to IT Governance Management
Confidential, Acting Manager Team Lead SQL DBA; IT Planning and Asset Management (2004 Dec 2009 April) Banana Island, Lagos
- Developed and implemented processes and procedures for IT Equipment movement, Vendor Fault escalation, and IT Asset Management Process.
- Managed Zain Desktops Printers Maintenance Contracts based on the ITIL Service Management model in line with the IT Directorate overall strategy of reducing Total Cost of Ownership.
- Managed all IT Projects according to established Project Governance
- Developed and implement Contract Management guidelines and processes for Information Systems in Zain
- Determination of performance criteria and evaluations of all Business Partners
- Collation and Vendor performance measurement against SLAs
- Administered all IS contracts. Recommended asset and configuration management retained organization
- Identified improvement areas for asset and configuration management
- Introduced effective warranty management processes and procedures with the collaborative effort between suppliers, OEMs, and customers. Assess new computing Technologies to determine potential value for the company
- Oversee ongoing improvements and the feasibility of systems enhancements
- Initiated and implemented a strategic process that ensures Insurance Claims are made for all Zain Nigeria Limited Laptops and other viable equipment against physical damages, theft and fire incidents to reduce TOC.
- Coordinated and assisted in the Development of Project Support Office
- Planned and implemented the following project as the Project Manager adopting the PMI Project Methodology
- As a Team Lead of Remedy Implementation Project, implemented Remedy IT Asset Management.
- Developed guideline and commenced centralized IT Procurement and Contract Management
- Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis
- Write, debugged, and tuned Transactional SQL, ETL and stored procedures
- SQL Server database physical model creation and implementation (data type, indexing, table design)
- Setting up and administering SQL Server Database Security environments using Profiles, database Privileges and Roles.
- Database maintenance, replication, tuning, system database migrations and maintenance
- Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers
Confidential, IT Support Engineer (2001 December 2004 November) Afribank Street, Victoria Island
- Developed and implemented support checklists and support processes and procedures for the department. Resolved all incidents related to hardware and software escalated to second line support; if unsuccessful escalated to 3rd line.
- Developed and executed Processes and Procedures for the Establishment of IS Service Desk (First line support) with an achieved target of 50 percent immediate call resolutions
- Successfully deployed patches and anti-virus updates, and removed of viruses from Servers and Desktops without data lose thereby awarded Chief Information Service Officers award
- Developed and implemented Incident and Problem Management process and procedures
- Managed IT Assets from the point of procurement to that of retirement and implementation of Configuration Management
- Managed and coordinated about 20 contracted staff from different vendors who carries out supports and quarterly preventive maintenance on all Desktops Monitors, Printers and Scanners to reduce downtime.
- Managed manufacturers and vendors warranties to meet with the Service Level Agreements (SLA) thereby reducing TOC (Total Cost of Ownership), decrease downtime and ensures availability.
- Based on the available records and as recommended by management, prepared yearly IT Asset Budgets based on headcounts.
- Established vendors performance measurement baselines templates, which were used to measure Vendors performances, thereby enabling management to determine the performance of each vendor against renewal of contracts.
- Initiated, Planned, executed, monitored and closed various major projects.
Education
- Masters in Business Administration major General Management
- B. Sc. Industrial Mathematics Major numerical Analysis
Other Professional Qualifications
- Certified IT Asset Manager CITAM (USA)
- PMP Project Management Professional (USA)
- Certified ITIL Foundation 2 3 (Fox-It London)
- Chartered Manager (Nigerian Institute of Management)
- MCSA MCSE 2000 2003 (Microsoft Certified System Administrator)
- MCSA MCSE 2000 2003 (Microsoft Certified System Engineer)
- Microsoft Certified IT Professional
- Comptia A+
- Cisco Certified Network Associate (CCNA)
- Certified HP APS Engineer Desktops, Workstations and Thin Clients
- Certificate in Quality Customer Service (Philips Consulting)
Professional Membership
- Project Management Institute Full Membership
- IT Asset Management Institute USA
- PMI-Atlanta Member, US
- IT Asset Management Member, US since 2008
- Nigerian Institute of Management Associate Member since 2003
- CISO Service Excellence Award for rolling out 5 Telco sites before the stipulated time and saving 40% of Project Cost
- Anti Virus Team As a member of Anti-virus team to revive and restore the system network that was costing the company millions of Dollars for every 1hour down time with 2 days of sleepless nights.