SUMMARY

• Excellent 11 years of experience as a Technical Project Manager, ITIL process management, Project Lead, PMO, Project coordinator, Business Analyst, and Oracle DBA
• Experienced in domain like Information Technology, Confidential product management, banking, stock exchange, entertainment /media, marketing research
• Experienced in handling projects in Oracle Database Technology on Operating System viz. Sun Solaris, Linux, AIX and Windows server in 24x7 Production, Application support and Development environments
• Proficient in requirement gathering, writing business and functional specification, data mapping
• Experienced in implementing ITIL Processes, SDLC life cycle, Agile, waterfall methodology, six sigma and Quality, Risk, Incident, Process, Resource and Change Management
• ITIL Ticketing tools knowledge (HPSM), ITSM, TCS internal management tool Ultimatix IQMS, IPMS, Agile Project Management using Scrum, JIRA, Service Now, Remedy, share point, Confidential IS&T experience
• Technical project manager for Transport Layer Security(TLS) set up in Oracle 12c, 11g and MS SQL server
• Technical project manager for Confidential corporate certificate management, Oracle Wallets management
• Managed external Audit (third party Audit), internal security assessments, internal audits, customer audits, compliance, third - party risk management and customer security management
• Managed Database and Oracle software license upgrade project
• Technical Project manager for DVM Project (Data volume management of Oracle Database for SAP application
• Lead Mission Critical projects (MCA Projects) and successfully done set up of Databases, Standby DB, Backup configuration & BCP set up
• Experience in Capacity Planning, Space Management and Database Real Application Testing,
• Experienced on Oracle Database Administration and MS SQL server DB administration
• Coordinate with customers andOracle support to resolve many newly introduced bugs, business critical incident, Service Request (SR) management
• Experienced in SDLC life cycle project planning, requirement gathering, team set up, project set up from startup including effort estimation on technical tasks and resource allocation
• Experienced in handling business for development, staging and production environments, testing, supporting both pre/post go-live activities.
• Deal with Business for escalations by focusing on resolution of issues while prioritizing mission critical applications, setting expectations and maintaining communication with the customer.
• Partner with internal teams to address open issues, determine root cause of incidents, and agree on proactive actions recommended.
• Ability to quickly learn new systems and business processes
• Created project documents, wiki for best practice and documented critical issue for better functionality with best practice
• Good communication, Presentation skill, interacting with different stake holders and manage teams, ready to take ownership of new challenges. Dedicated and passionate towards my Duty, good Risk handling capacity, Decision making skills and Team Management
• Capable of leading and motivating teams while focusing on collaboration between staff, client resources andprojectrelated vendors.

TECHNICAL SKILLS

Operating System: Sun Solaris, Red hat Linux, AIX, Windows 2012, 2014

RDBMS: Oracle 12c/11g / 10g, 9i, SQL Server 2012, 2014, 2016

Languages: SQL, PL/SQL, UNIX shell script, T-SQL

Database Tool: Oracle 10g, 11g, 12c, 13c(OEM), PL/ SQL Developer, SQL Developer, Quest ToadSAP BRTOOLS, Sql server Management Studio, DBCA, DBUA

Interfacing Tools: SSH, Putty, Super Putty, WinSCP, Toad for DBA

Utilities: Datadump, Imp/Exp, SQL*Loader, DBCA, DBUA, SQL TraceTivoli, RMAN, SCP, SQL worksheet, TKProf, AWR, ASH,ADDM, OEM, SAP BR

TOOL: MS excel, PowerPoint, wordand MS Project, share point, Google Docs, Google Sheet, Outlook

Management Tools: ITIL Ticketing tools knowledge (HPSM), ITSM, TCS internal management tool Ultimatix IQMS, IPMS, Agile Scrum Project Management using JIRA, Service Now, Remedy, share point, Confidential management using central station, espresso, Confidential IS&T

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, California

Technical Project Manager | Project coordinator

Responsibilities:

• Preparedproject plans, conducted weekly/daily project status meetings, ensured all team members both internally and externally were adhering to the plan.
• To understand project requirement from SME and research on its pros and cons
• Provided guidance, training, set expectations and coached the client through toprojectcompletion.
• Present critical technical issues, challenges to customer, SME, Oracle support expert and discuss workaround
• To make sure Application team, USER & Database owner following standard technical process and defined methodology which is approved by SME and customer
• Own key capabilities, analyze the current rules and functionalities supported for these capabilities and research current regulations to identify gaps, if any
• Discuss any regulatory deviations identified in the process or system with compliance and operations heads and come up with an approach to fix the same
• Document the requirements through Business and Functional requirements documents, Use Cases, data dictionary and traceability matrix
• Managed TLS, TDE security & wallets, certificate support which was critical time bound project for TLS 1.2 migration and Certificate renewal and Confidential corporate certificate migration
• Identified and implemented best practice which reduced efforts, minimum application downtime, less cost to renew/revoke certificate for critical systems
• Managed many severity 1, P1, P0 database network incidents and application JDBC handshake connection incidents
• Identified & Troubleshoot critical bugs, handshake issue which created new project request for Application & Database configuration change, upgrade of DB from 11g to 12c, Patching, JDK upgrade, JAVA ojdbc.jar upgrade
• Daily monitor and manage business critical report for Data- Guard SSL report, TLS 1.1, TLS 1.2 report, Certificate renewal, expiry report, OEM monitoring of SSL listener, certificate request and revoke report
• Coordinate with Change, Risk, Quality Program Managers through regular project tracking, project dashboards, project metrics
• Tracking and reporting of Incident based KPIs on a daily, weekly and monthly basis.
• Documentation of Reason for Outages (RFOs), RCA when required
• Bridge management during critical incidents. Timeline tracking of significant events or milestones as defined by the incident
• Tracking and reporting of Incident based KPIs on a daily, weekly and monthly basis
• Established and maintained and Incident Management program handling using WebEx
• Ability to navigate through ambiguity, manage and coordinate multiple assignments simultaneously in a fast-paced, deadline-driven environment, accepting ownership and accountability of the deliverables and deliver on commitments
• Ensure teams review performance and identify and implement improvements
• Ensure operational reporting is fit for purpose, mentor teams in use of improvement techniques
• Assist the teams in reviewing and transitioning/knowledge transfer of new solutions from the projects team into the global DBA teams. Help teams plan infrastructure changes with appropriate risk assessments and clear operational implementation/run books.
• Assure all production CR going through all phases of approvals, impact analysis and validation and D2P testing process before implementing it in production. Set up CAB(change-advisory board) meetings.
• Worked on incident, change & task management tools like Confidential IS&T, espresso and central station
• In Confidential Inc. I developed my skills like best security policy handling process, coordination, risk handling, time management, research, knowledge gathering and presentation on new technology. Handled successfully responsibility of Mission Critical project delivery and customer and project team management.

Confidential, New Jersey

Technical Project Manager |PMO| Project coordinator

Responsibilities:

• Develop and manage end-to-end project plans and ensure on-time delivery. Provide hands on project management during analysis, design, development, and release phases
• Perform risk management and change management on projects. Provide day-to-day coordination and track success metrics on projects and tasks
• Drive internal process improvements across multiple teams and functions
• Interface with cross-functional partners for project requirements
• Experience with project management and being a “connector” across teams
• Experienced as a Project Management Office (PMO) in the creation and maintenance of project metrics reports
• Create all kind of reports on project planning, project status, PMM gate reviews, and management dashboards.
• Utilizes critical thinking skills and identifies process changes and improvements, Is trustworthy and reliable; follows through with commitments.
• Identifies and/or aligns on organizational change management needs, plans and executes effectively.
• Teamwork and Collaboration - Effective collaborator amongst their peers and partners, and is able to pull the team together around a common goal.
• Successfully completed ownership of DVM (Data Volume Management) project and released around GB space from each 1TB-5TB Database for SAP Application
• Worked on LOB object of SAP like SOFTCONT tables etc and improved performance and space released from Big table
• Performed Bulk index Rebuild activity on around 100K Index using BRTOOLS for DVM
• Managed Decommission of Databases project
• Meetings with higher management, SAP Support and Oracle Support for critical service request SR
• Managed team for implementing database security Oracle encryption/decryption, data masking and used Oracle Advanced Security features
• Successfully managed 50 members team and trained for implementing Project Audit
• Technical wiki, KT, Quality, process, project plan documents created
• Daily monitor task tracker, change request, Incident and motivate team to complete it within timeline, monitor database reports, generate project matrices reports and provide update to customer influence teams through a strong understanding of system design and stakeholder needs

Confidential, Chicago

Technical Project Manager | PMO | Oracle DBA

Responsibilities:

• Managed project distinct stages, including planning, design, building, testing, and deployment. Coordinate with production support
• Work with stakeholders including Managers/GL defines business systems requirements for new technology implementations.
• Interface on a day to day basis with other analysts, business users, super users and IT team members to support business operations and drive change management
• Lead cross-functional meetings as part of requirements gathering, driving projects or providing status updates on various projects
• Facilitate ITIL management and transition to future state working with various stakeholders
• Identify, and participate in prioritization of business capabilities and act as a catalyst for building mature processes
• Involved in building critical application as MCA (Mission Critical Application) project. As per provided MCA specification defined database policy, structure, standards and its backup policy created
• Lead for DR set up and capacity planning for database servers & Standby Database set up
• Database security which involved user, role, privileges management, data masking
• To ensure execution of Backup policy for Production databases and its respective jobs using daily reports
• To identify databases for decommission and worked with different teams, DBA owner to decommission it
• To manage deployments on databases requested by application and other teams
• Managed Impact analysis and DB design and generated ER diagram for application to maintain LDM/ PDM(Logical/Physical data model)
• Daily Defect Review for Release. Co-ordination of Defect Management and Tracking along with Environment Promotion
• Support of Testing Teams (Dev, Test, Integration, UAT) on tiers ( App, Batch, Middleware)
• Successfully managed yearly, quarterly internal & external Project Audit by providing Audit information to External Auditor(Third Party) and implemented their suggestions and handled multiple database Audit and minimized NCR count from 15 to Zero in a two quarter
• Successfully managed License upgrade project for oracle software
• Managed BCP Project team of around 80 members and multiple BCP drill performed successfully across different geographic locations
• Project management meetings with multiple team like Customer, stakeholder, SME, BA, Oracle support, application owner, database owner, DAG(Quality and process management), Auditor, BCP team, DB Backup team, Tech team and OS team, Networking team, Risk management team, Media public relationship manager, marketing strategy manager
• Prepared all project documents as per customer standards and get it reviewed and approved from GL/PL, DAG for Audit and IBM PMR (Project management review).
• To create and Maintained Unified Project plan, monthly plan, IBM Project management review PMR, concept notes, project plan, daily status, weekly status, monthly status report for project, estimation costing and project efforts, budget, timesheet of resources.
• Presented project statistics reports and matrices to higher management
• To manage CR, Incident and Ticket escalation level within defined SLA
• Exposure to six sigma process implementation for the project
• To be in compliance with strong ITIL processes like Ticket & Change Management, Problem and Known Error management, Knowledge management, Risk, Process, Quality management
• To implement Process improvement to save on cost and estimation, improve on productivity and customer satisfaction

Confidential, New York

Infrastructure Oracle DBA | Project co-coordinator

Responsibilities:

• Production and non production SQL deployment within defined timeframe and SLA’s.
• Basic Linux Administration for DBA
• Database Health check and Troubleshooting
• Create and discuss service request SR status with Oracle support expert and provide resolution update to DBA manager.
• Quality Documentation for all database administration and deployment activities
• Maintain requests and task with Request Tracker management
• Project coordination like KT management for Offshore, Attending client meetings, documentation of processes and getting approval from Client.
• Coordinate with onsite DBA team to assign role responsibility and explain project requirement and process to new team member
• Schedule and present meeting agenda with Project Managers, Systems Architects, Systems Analyst, Application Developers, SME
• Offshore project set up, asset set up, resource training and shift planning
• Monitor and provide daily status reports to higher management internal & external

Confidential

Business Analyst | Oracle DBA

Responsibilities:

• Created Databases, Users, Roles
• Essential Linux/ UNIX administration for DBA
• Maintained physical & logical database structure
• Managed Database availability and security
• RMAN backup recovery troubleshooting and monitoring
• Disk space Management, Archive log space management.
• Database Health check and Troubleshooting.
• Worked with Application Team for database loading, development and management of operational procedures
• Quality Documentation for all database administration and deployment activities
• Maintains requests and task with Request Tracker management
• Direct reporting to Assistant Vice President of Confidential Securities pvt ltd, Interacting with Vice President, Senior Auditor, Business Analyst team, Project Managers, Systems Architects, Developers to gather requirements and to provide daily reports
• Worked with Google Technical Team to improve site performance and implemented Confidential Search Engine
• Handled stock market day end closing, stock matching, final stock values and its trading details
• Handled Mission Critical Application(MCA) which interface between Stock Exchange, NSE, BSE and ICICIDIRECT.COM
• Successfully completed Ownership for daily stock market opening and closing activity and did troubleshooting for server connectivity between NSE, BSE and ICICIDirect.com
• Handled Bulk email sending application to ICICIdirect customers
• Solved client tickets received from Confidential customer care
• To help actively on database side to implement application enhancements and changes
• Created quality documents on standard operating procedure used
• Worked in an investment banking environment, interacting with the traders, etc.

Confidential

Junior. Oracle DBA

Responsibilities:

• Database Administration and Maintenance. production and non production SQL deployment within defined timeframe and SLA’s
• Created Databases, Users, Roles
• Backup recover using RMAN, Export, Import utility
• Stats pack and AWR report creation for Performance Tuning.
• Database Space management.. Database Health check