Objective

To keep learning exploring new areas, so as to assist my organization to achieve its targets, build and implement innovative ideas for the betterment of mankind. To obtain a position where I can maximize my multilayer of management skills, quality assurance, program development, training experience, customer service and create a successful track record in the IT Industry.

Experience Summary

• 5 years of experience in Information Technology.
• Experience in leading Application Servers such Oracle Web-logic 11g/12c and JRUN.
• Expertise in Critical EnterPrise Applications and Customer Support Services.
• Good knowledge of scripting languages as well like JavaScript and HTML.
• Industry experience in BEA Web-logic Application server under UNIX/LINUX environments.
• Good working knowledge of Operation Production Support with large mission critical systems in multiple technologies and platforms including WebLogic, UNIX and Oracle.
• Extensively worked on BEA WebLogic 11g and 12c Server for Server Installations, Configuration, Application components deployment, performance tuning including troubleshooting and maintenance.
• Configured Web-logic JDBC connection pools with databases in Oracle 9i/11g.
• Good Knowledge in Oracle database and Oracle PL/SQL.
• Experience in leading Database technologies such as Oracle 9i/10g/11g
• Successfully passed Introduction to Oracle 9i exam 1z0-007 exam.
• Work on Data pump to import and export data in and out of the database.
• Knowledge of Oracle SQL, Analytical functions, PL/SQL, SQL Loader, UNIX, Performance tuning.
• Good knowledge in developing PL/SQL objects such as Stored Procedures, Analytical functions, Nested tables, V-arrays, Records and Types, packages, views, Materialized views, DB links Triggers.
• Job Scheduling through SQL Batch files.
• ITIL V3 Foundation 2011 Certified.
• Sound knowledge of Change Management, Problem Management, Incident Management and Knowledge Management.
• Good knowledge on SDLC Process in terms of all the documentation required from planning the change to the operation phase deliverables.
• Worked on various HP tools such as HP Service Manager, Quality Centre and Application Life-Cycle Management ALM .
• Experience in handling multiple applications at the same time.
• Worked as Team/Onsite Lead in EnterPrise projects.
• Responsible for Direct Client/Customer Interactions. Played the role of Implementation Manager for Deployment of applications across multiple locations.
• Extensive experience in Onsite/Offshore model and experience in handling offshore teams.
• Have worked actively in taking up the transition of Projects from other vendors like iGATE Sogeti.
• Thorough experience on Information Technology domain with key emphasis on Analysis, Development, Unit, System, Installation as well as UAT testing, production deployment and Application Management.

Technical Skills

Played Roles Daily Responsibilities

• New Development Enhancements
• As a member of EnterPrise Applications Team, I was responsible for Troubleshooting, Load Balancing, Clustering, Deploying Applications, Performance Tuning and Maintenance of Web-logic Servers.
• Create, configure and tune Web-logic domains/applications for performance.
• JDBC Connection Pool and Multi-pool configuration with Oracle database.
• Deployment and troubleshooting of JAR, WAR files in domain and clustered environments
• Work with different Vendors and Developers for application related issues.
• Created and maintained Tables, views, procedures, functions, packages, Ref Cursors, exceptions handlers, DB triggers, and Indexes.
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding actual tables and to eliminate the complexity of the large queries.
• Successfully manipulated Stored Procedures, Functions, Triggers and Packages using TOAD and SQL Navigator.
• Daily data load monitoring, support, enhancement and tuning.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors etc.
• Implemented Exception handling, Autonomous Transactions, Pragma Exception Init, Locks, used save points, commits rollbacks to maintain Transactional consistency database integrity.
• Automated bulk emails with attachments on job completion using PL/SQL packages.
• Also as a part of Best practices, we automated many routine jobs also developed many applications mainly Centralized Web based applications using PL/SQL UNIX Shell Scripting
• Participate in the Analysis sessions, gather requirements and take them to the implementation phase.
• Maintenance Operations M O support at Tier-3 level
• Taking care of the Operational issues.
• Incidents and Problem Management
• Change Management: - Work on all the SDLC phases starting from creation of the CRQ Change Request to updating SDI System Documentation Index .
• Knowledge Management: - Maintaining KEDB Known error database is also a part of our daily work.
• Impact analysis of any new changes coming in our own system or in any of the other integrated systems.
• Have also worked on Unit, Installation and System testing. We use HP ALM Application Lifecycle Management for testing.
• Being ITIL V3 certified, I follow ITIL methodology to work on incidents, problem tickets etc.
• Follow incident reduction plans also work towards achieving 100 SLA compliance. CAPA Corrective and Preventive action is one of activities which we do on monthly basis.
• Conduct knowledge sessions for tier-2 teams.
• Client Interaction Discussing new requirements and issues coming up in production. Presenting status on the issues going on or the progress made on new developments going on, in weekly and bi-weekly calls.
• I played the role of Implementation Manager for deploying applications across multiple sites.
• Completed Transition Project successfully
• Enabled my team to prepare for transition evaluation, one of the main quality gate approvals.
• Played a crucial role in shadowing and reverse-shadowing phases of transition till the steady state.
• Worked on knowledge transfer documents which were evaluated by P G application leads.
• Other Key Responsibilities :-
• Coordinating Onsite-Offshore meetings and tasks allocation.
• Interacting with other teams integrated systems to work on issues involving multiple teams' involvement.
• Preparing and sending out weekly status report to the P G managers.
• Conducting USAT User Satisfaction Survey for getting client's feedback.
• Build, test, and deploy Web database applications new as well as the upgrades on the existing ones .
• Follow incident reduction plans Fortnightly / Monthly analysis of the TOP 5 issues .
• Handled the add-on requirements for the existing applications through CR Change Requests .

Played Roles and Responsibilities

• 1 PL/SQL Development and Managing data requirements
• Worked on packages, stored procedures, analytical functions, ref cursors, dB triggers.
• Development of SQL Queries, Functions, PL/SQL Methods and Exception Handlers.
• Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
• Wrote complex in-line Views which summarized the business needs to the fullest.
• Create control files and load data from flat files to tables using SQL Loader.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL and UNIX utilities.
• Implemented integrity constraints on database tables.
• Scheduling DBMS jobs in Oracle Database for detecting different events and fire appropriate action according to matched condition.
• Created DB Links, synonyms to communicate with remote database server.
• Web-Based Application Development Maintenance Developed simple web applications with Java J2EE as the front-end and Oracle as the Back-end support. Also worked on development add-on requirements for existing applications mainly Centralized Web based applications using scripting languages like JavaScript and HTML.
• Below are some of the applications that I had worked on during this training program:
• Online Banking Tool - This tool lets users to log into their account and check for balances. The tool also included features like funds transfer, user profile updates etc.
• Query Builder - This is a front End tool which is being used by the users for extracting the data directly from the database. Users can utilize this tool for most of their frequent data requirements.