SUMMARY:

• Strategist with skills Confidential identifying clients’ business needs and formulating technology based strategic response to position client’s business for success
• Excellent track record of delivering large, complex enterprise - level projects of value over $ 1.5 million, by using Agile & Waterfall Methodologies, for high value global clients located across NA, EMEA and Asia
• Exposure in building and leading high-performing teams of size 20+, located both at onsite and offshore
• Experience in managing P&L and improving margins & profitability by reducing costs and increasing productivity
• Acquired 3.5 years of onsite experience Confidential Cummins Inc. - Confidential - IN - Confidential and 5 months Confidential British Telecom Plc. (BT) -Glasgow - Scotland -UK
• Initial 8 years of technical experience Confidential Oracle DBA concepts and activities
• Strong analytical, planning, and organizational skills with an ability to manage competing demands, strong knowledge and understanding of business needs with ability to establish/maintain high level of customer trust and confidence
• Exceptional interpersonal communicator who effectively interacts with clients and all levels of management.

TECHNICAL SKILLS:

RDBMS: Oracle 9i, 10g, 11g R2, MS SQL Server

Operating Systems: Sun Solaris (9, 10), IBM (AIX 4.2), Windows X, Linux, HP Itanium

Scripting: UNIX Shell Scripting

Tools: MS Project, MS Office (Excel, Word, PowerPoint), SharePoint, OEM 11g/ OEM 12c, Appworx, BMC Remedy, ServiceNow, Oracle Application Express (APEX), Appload, PVCS (Serena), OSWatcher

Process Compliance: SOx Reporting / Auditing, ClearCase

PROFESSIONAL EXPERIENCE:

Confidential

IT Project Manager (IMS)

• Driving simultaneous execution of 3 projects, sported by a team of 15+ members (onsite + offshore)
• Manage projects from the stage of initiation till closure ; advocate timely and high quality delivery of projects while managing stakeholder expectation; monitor and report on project progress
• Developed & managed a well-defined project management process and championed ongoing process improvement initiatives to implement best practices
• Define processes and tools best suited to each project ; creating detailed project road maps, plans, schedules and work breakdown structures; utilising Agile and Waterfall approache s depending on project specific& client goals
• Ensuring resolution of project related issuesand deliverables as per project plan and SLA
• Drive improvement of project design and system documentation Confidential collaboration with subject matter experts & architect team; facilitating process standardization as one of the pillar resources
• Undertaking regular analysis of project metrics aimed at reduction of project cost ; performing root cause analysis and implementing corrective/preventative actions over qualifying incidents and issues observed during implementation
• Emphasizing on value adds and better ROI with the cost saving drives Confidential existing projects
• Driving significant improvement in product quality and stability through implementation of CMMI-3 processes
• Contributing extensively Confidential drafting technical proposals & SOW, including effort estimation, pricing, staffing model, and showcasing initiatives; contributed strategically to various sections of proposals
• Providing strategic consultancy to clients on quality & process excellence viz.:
• Analyzing various processes & recommending modifications to enhance operational / process efficiency
• Introducing modifications Confidential process flow, working practices, etc. for reducing conversion cost per unit produced

Environment: -MS Project, MS Office, Oracle Database versions 10g, 11g R2, Oracle Enterprise Manager (OEM 12c) Oracle Solaris 10, 11, BMC Remedy 8.1, Oracle Utilities - RMAN, Expdp/Impdp, DBVerify, SOx Reporting.

Project Manager (IT Projects)

• Worked Confidential close coordination with Onsite-offshore Tea m to meet the ticket SLA/CRQs raised for production environments
• Functioned as Single Point of Contact (SPOC)for escalations Confidential different Business Units (BUs) assigned
• Participated Confidential multiple weekly Change Control Board (CCB) meetings with stakeholders for the identified problems through Incident management and Service Request management
• Overall responsibility and ownership of the Project Plan.
• Assisted Change Manager Confidential defect status reporting, defect management reporting, defect metrics, KPIs.
• Prepare status reports for the project and review with client management team.
• Prepare and manage the projects logs: Action Item Log, Risk Log, Issue and Decision Log
• Budgeting, estimation, forecasting, staffing and quality management.
• Conduct joint sessions with the project stakeholders to elicit business Requirements
• Contributed extensively to project value additions and process standardization drives
• Managed, Liaison with the Bestseller A/S procurement team for Software Acquisitions/licenses required for the Data Architecture team
• Monitor the SOW adherence by the services provider
• Maintained Project Roadmap and Blueprint for Data Architecture
• Facilitate and participate Confidential the project Architecture and Design meetings.
• Participate Confidential the Design and Modelling of the Databases
• Monitoring alignment of prioritized projects against resource capacity and partner with delivery teams to assist with balancing capacity and demand.
• Allocated the resources to the projects based on the forecast and work priority
• Tracked key project milestones and adjusted project plans
• Set KRAs and KBAs for the team members ; a assisted team for effective usage of hardware or software
• Conducted half yearly and yearly appraisals ; scheduled knowledge sharing sessions for new members

Environment: -MS Project, MS Office, Oracle Database versions 10g, 11g R2, Oracle Enterprise Manager (OEM 12c) Windows Server 8, ServiceNow for ticket tracking, Oracle Utilities - RMAN, Expdp/Impdp, DBVerify.

Project Leader (DBA and Applications)

• Coordinating activities between the project team and database administration (onshore & offshore teams), project & program managers and other stakeholders on project delivery, issue resolution, status communication & reporting.
• Provide timely communication on project status to client and all relevant stakeholders along with weekly status meetings with SLA adherence
• Defect coordination, responsible for efficient management and resolution of defects across all projects, including activities like defect verification, defect prioritization, defect assignment and defect resolution and defect closure.
• Formalize standards for planning and testing of database related implementation.
• Interfaced with key stakeholders and apply technical proficiency across different stages of the Software Development Life Cycle including Requirements Elicitation, Migration Architecture definition and Design.
• Organize knowledge transitions for onshore & offshore team members.
• Tracked project plans and budget.
• Administered change management for the projects
• Prepared Risk Management Plans and Issue resolution logs.
• Conducted weekly/ Bi-weekly meeting with the stakeholders.
• Help offshore on technical/infrastructure challenges & coordinate with other groups for issue resolution.
• Identify/raise/escalate risks/issues and facilitate discussions towards mitigation & resolution.
• Structure own or others' activities to improve productivity or minimize delays/rework.
• Review offshore work before delivery. Provide feedback for performance improvement.
• Adhere to the Quality procedures Confidential the team.
• Handling Growth requirements of Databases.
• Monitoring the Database space usage and adding space to the tablespaces on requirement basis.
• Carried out maintenance, tuning and 24x7 support of Production, Staging and Development instances of Oracle Version 9i, 10g, 11g Confidential UNIX environment, supported by DBA Team of 15-20 FTEs
• Coordinating the development team Confidential case of any issues for procedures.

Environment: - Microsoft Office, Oracle Database versions 9i, 10g, Oracle Timesten In-Memory Database, Oracle Enterprise Manager (OEM 10), Solaris Ver. 9, HP Itanium, Oracle Statspack reports, Crontab.

Project Leader

• Worked as an IT Project Leader and managed functionally and technically complex database and application development projects which involved enhancing existing overall DB and Application functionality
• Responsible for Project Tracking, Control & Report which involves tracking the project scope, schedule, quality, resource requirements, financials, risks, adherence to SLAs on a periodic basis,
• Taking corrective measures and communicating to all stakeholders as per the communication plan; scheduling, monitoring, reviewing and controlling the effort of project teams Confidential all the project phases (Requirements gathering, Design, Architecture, Development, Testing, Implementation, Warranty) Confidential their entirety Confidential order to deliver project successfully as per project goals.
• Responsible for Leading and managing the project team, ensuring that appropriate resources have been assigned to the project, reviewing project guidelines with the team, ensuring clarity of roles by defining each team member’s deliverable for the project
• Monitoring and planning for system capacity and growth usage for new hardware or software requirements and communicate these requirements to management.
• Identifying resource bottlenecks Confidential the production system and carry out performance tuning exercises.
• To support application team during the dry run and deployment phase of the SRF on the test/dev. and production DB.
• Creating and monitoring TAR with Oracle Support.
• Oracle 9i and 10g Installation on Sun Solaris OS with Database creation and configuration for BTCOM & Visibility Apps.
• Monitoring the database through alert.log file for Oracle errors and with internal application for CPU and Memory utilization.

Environment: - Microsoft Office, Oracle Database versions 9i, 10g, Oracle Enterprise Manager (OEM), Solaris Ver. 9, Oracle Statspack reports, Siebel CRM 6, Open Reach.

Senior Oracle DBA

• Part of core Production DBA team maintaining Prod/Test/Stage/Dev databases environments
• Installation and Configuration of Oracle databases on Solaris / HP platforms.
• Coordinating activities between the project team and database administration.
• Participate Confidential establishing and evolving database standards within the company.
• Providing 24 x 7 supports for production databases.
• Actively participated Confidential Migration activity for three databases from 8.1.7 to 9.2.0.6.
• Maintaining data integrity and tuning the database for optimum performance and availability.
• Installation of Patch and bug fixes.
• Refreshing database as per the requirements and creation of schemas and control access.
• Handling Growth requirements of Databases.
• Used the Export/Import utility for transferring the data from one server to another.
• Monitoring the database through alert.log file for oracle errors.
• Converting Dictionary managed tablespace to locally managed tablespace.
• Generation of statspack reports regularly and analyzing the reports.
• Oracle 9i to 10g migration from Oracle 32bit to 64bit on Solaris Env.
• Provided second line technical support to the Front-Line-Support team/other DBA’s
• Administering the aspects of the database such as creation and addition of space to the tablespaces, rebuilding indexes, gathering statistics, managing the storage parameters on all object level.
• Identify poorly performing SQL’s through OEM and Statspack / AWR, and optimize the same.
• Database monitoring through various alerts set on the databases.

Environm ent: - Oracle Database versions 8.x, 9i, Oracle Enterprise Manager (OEM), Solaris Ver. 9, Oracle Statspack reports, Exp/Imp, Oracle RMAN.

Oracle DBA

• To Monitor Databases, Performance monitoring, Hang analysis.
• Creation and Maintenance of database and storage design and management.
• Applying Oracle Patches and installation. also, done Upgradation and migration of 8i and 9i
• Successfully implemented ASSM tablespaces.
• Created users and allocated tablespaces and roles to the users.
• Performed Oracle performance tuning by creating indexes, SGA tuning, eliminating chained rows and SQL optimization. also, tuned INIT.ORA parameters.
• Created required indexes to improve performance and removed unnecessary indexes that affect the performance of DML statements.
• Monitor tablespace utilization and removed fragmentation of tables by exporting, dropping tablespaces, and importing them into tables and coalescing tablespaces.
• Use Explain Plan to monitor the execution of the query.
• Identifying resource bottlenecks Confidential the production system and carrying out performance tuning exercises.
• Participate Confidential establishing and evolving database standards within the company.

Environment: - Oracle Database versions 8.x, Red Hat Linux 2.4 (32 bit)