SUMMARY:

• An accomplished manger and Lead consultant with demonstrated skills in project management, Customer orientation and consulting.
• I have proven Oracle technical expertise with excellent problem solving capabilities and analytical thinking.
• 12+ years of immense IT experience.
• 11 years of PL/SQL experience and performance tuning.
• Good PL/SQL development and mentoring experience.
• Oracle Apps DBA and Data modelling experience.
• Experience on Oracle DBA activities.
• Vast expertise in Development, Production Support, maintenance and external consultancy.
• Excellent people management skill with about 10 Years team leading and mentoring experience
• Excellent problem solving capability.
• Experience working with Scrum and Agile methodologies.

PROFESSIONAL EXPERIENCE:

Confidential, Arizona

Lead Developer Consultant

Technologies: Oracle 11i, UNIX, Outage management

Responsibilities:

• Managing a team of 5 to carry out the day to day support activities and enhancements for the Confidential .
• Provide consultancy to the ADMS project.
• Provide the Confidential functional consultancy to various other systems integrating with Confidential .
• Carry out the Administration for the Confidential .
• Interact with the business for the various enhancement of the business process.
• Verify the GIS updates and ensure that they load properly in the outage management system.
• Lead the bug fixes effort for the GIS daily Incremental updates
• Load the Customer information data to the Confidential
• Develop, maintain and enhance interfaces to the various distribution systems like CYME, OI and CIS
• Manage the daily production data refresh to the non - production environments.

Confidential

Project Manager

Technologies: LINUX, UNIX, Oracle 11i

Responsibilities:

• Project planning and delegation of the various task to the team
• Coordinate with the customer and the stake holders to progress with the migration of the OS
• Coordinate with the other partners to convert FTP to SFTP and configure the SFTP on their environments.
• Migrate all the FTP interfaces to SFTP in the LINUX
• Test and improve the performance of about 100 UNIX jobs in the new LINUX environment
• Create or modify various PL/SQL procedures and functions as per the functional and business requirements or changes.
• Troubleshooting PL/SQL Performance/Tuning Issues.
• Liaise with the offshore teams to guide them on the design and development.
• Managing day-to-day support activity such as fixing of incidents reported and batch job failures.
• Requirements Analysis and development for new enhancements.
• Integrations Development & Performance tuning
• UI Design and coordination
• Coordination with team for issue resolution

Confidential

Oracle App DBA & Project Manager

Technologies: Oracle 11i, LINUX, UNIX

Responsibilities:

• Manage the Application DBA activities for the whole GIL Tools Team. Only person to modify the production PL/SQL code and data.
• PL/SQL Performance tuning & monitoring of the Oracle Application Database.
• Create or modify various PL/SQL procedures and functions as per the functional and business requirements or changes.
• Installed and configured Oracle 10g/11g RAC high availability.
• Involved in Applications 11i administration including 11i Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
• Deploy the changes in the certification and production environments.
• Knowledge management for the entire Confidential - Wipro engagements.
• Provide Business value creation by proactive proposals
• Automation of the various process for increasing the team productivity
• Troubleshooting PL/SQL Performance/Tuning Issues.

Confidential

Project Manager & Transition Manager

Technologies: Oracle 11i

Responsibilities:

• Manage the Confidential efficiently
• Ensure that the all the basic Confidential process are adhered
• Involved in transition planning and project readiness program.
• Responsible for alignment of the Confidential transition phases with the Wipro Transition

Confidential

Lead Consultant

Responsibilities:

• Provide PL/SQL technical guidance to the Confidential support team
• Provide Knowledge transfer on Confidential (PL/SQL) data cleansing to the WIPRO Team
• Ensure smooth transition of Confidential from the incumbent Confidential IT UK team to Wipro team

Confidential

Manager, Lead consultant

Technologies: PL/SQL, Oracle 9i, Oracle 10g, Forms and Reports 6i, database design

Responsibilities:

• Proposed, designed, developed and implemented a process called Quick Win Opportunity (QWO) to identify and prevent the various data inconsistency issues in Confidential proactively. QWOs are PL/SQL procedures to address the data inconsistencies in Confidential
• Carry out the data base design and the PL/SQL coding for the Quick wins.
• Automation of the Confidential PL/SQL scripts which improve the over all team productivity.
• Designed and developed batch job monitor scripts which will warn the users for the potential batch job failure for data error.
• As team lead, I need to help the team for meeting the weekly and monthly team targets and guide them and provide the required assistance in resolving the complex data scenarios.
• I need to liaise with npower on behalf of Confidential IT UK for business as usual calls and update the Confidential IT UK management and the WIPRO management
• Effectively manage the diversified Confidential Data-cleansing team which include Confidential IT UKs (npower) permanent Employees, WIPRO Pool Partners, and contractors.
• Provide Oracle technical guidance to apprentice and provide observational assessment to the client management.

Confidential

Team Lead, Onsite coordinator

Technologies: Oracle 8i,Oracle 9i,Oracle Database 10g,HTML,Java,Utilities, BPEL, Oracle 10gVAX- VMS, PL/SQL, Oracle 9i, UNIX, Pro C, Java, Forms and Reports 6i

Responsibilities:

• I had identified the Business needs and Requirements for the Minor Work Requests for 15 Minor work requests and guided the team in carrying out the coding and Unit and System Testing.
• Proposed TWMS Archival solution and PL/SQL Performance tuning solutions to address certain database issues of TWMS and to meet the business requirements.
• Well versed with the Code Management, Change management, Incident Management and other processes needed for efficient execution of the projects.
• Proposed and performed automation of daily morning checks and played a vital role in stabilizing the MIWS and TWMS systems.
• I had provided noteworthy contribution during complex DDS Annual Refresh and stream lined the process.

Confidential

Lead

Technologies: Oracle 9i, PL/SQL, Forms and Reports 6i, database design & modeling

Responsibilities:

• Involved in the requirements gathering, requirements planning and management, requirements analysis, solution assessment and validation.
• I was a key contributor in defining and developing solution to carry out the data archival
• Played a vital role in the Database design for the Proteus Archival System.
• Proposed changes in the design of the batch execution of the Proteus system to increase the performance.
• Involved in developing the Data Migration plan and Data migration scripts.
• Carried out the Unit testing and system testing.
• Carrying out the Performance tuning of the Archival solution.

Confidential

Technical Consultant

Technologies: Oracle 8i, PL/SQL

Responsibilities:

• Involved in database bug fixing and performance tuning.
• Designed the process for loading the data from flat file to tables and vice versa.
• Worked in automation of finding the missing transactions from ISP.

Confidential

PL/SQL Developer & Apps DBA

Technologies: Oracle 8i, Oracle 10G,PL/SQL, database design and modeling

Responsibilities:

• Handled all the DB related issues like development, testing and enhancement in 6 modules
• Solved many complex issues like encryption problems with the UTF8 character set and obfuscating.
• Worked on data migration - ETL and dynamic SQL
• Carried out the database performance tuning (query level tuning) for certain procedures
• Involved in the database design of European Fleet services.
• Carried out the Database Administration Activities
• Installed and configured Oracle 10g/11g RAC high availability