Oracle Dba Resume Profile
PROFESSIONAL SUMMARY
- Over 7 years of experience in IT industries and played various roles Developer, Automation Engineer, Devops Engineer, Application Support and Application Team Lead.
- Application Team Lead handles Java , J2ee and Oracle Applications. Responsible for application development, deliverable that includes design, coding and unit testing. Provide Level 3 application development support for production incident and service request.
- Creation of Incidents and Service Requests for the supported applications, first point analysis on tickets and assigning them to L2/L3/ other service lines based on the scope.
- Tracking of Incident from Opening to Closure, with timely communication to business.
- Communication with Business Clients and first point of contact/interface for application issues and outages between Business and Technology Team.
- Excellent communication skills and have ability to interact with business teams, other support and manage customers.
- Collect and analyze the project's business requirements and transferring the same knowledge to development team.
- Provide suggestions to the development team during the development stage of product to meet the client's business needs
- Prepare accurate and detailed requirement specifications documents, user interface guides, and functional specification documents.
- Manage any change requests related to the working project plans daily to meet the agreed deadlines.
- ITIL concept including Incident Management and Change management.
- Hands on experience in Oracle and DB2 database. Experienced in SQL query performance tunning.
- Good knowledge in Unix shell scripting. Automated many manual and complex task and enchanced the existing data model to increase flexibility, efficient and adaptability to changing order codes and regulatory requirement.
- Job scheduling tools knowledge like Autosys, Mastero IBM tool .
- Experienced in Tickiting tool like Remedy, HP Service manager, HP ovsd, Jira tool .
- Have performed the roles of Developer, Team Lead, Technical Lead and SME for Banking, Insurance and Retail Industries.
- Working Knowledge on ITIL based ticketing system.
- Expert in troubleshooting production issues and update the emergency status tracker.
- Setting up triage call and drive up the team towards solution and creating the RCA document.
- Functional experience Banking Finance, Insurance Retail World.
- Technical skills encompasses Java, J2EE JDBC, Servlets, JSP , XML, XSL, HTML and JavaScript
- Hands-on experience in Core Java, JSP, Servlet and Oracle technologies.
- Experienced in management tools such as Remedy Ticketing tool, Toad for Oracle and DB2, Excel Macros report generation. Microsoft Share point forms desing.
- Automated many Metrics using excel macros to pull details from Remedy tool and published to huge audience.
- Experience in application and web servers such as Websphere, Apache Tomcat, Unix.
- Experience in database languages i.e. SQL, Stored Procedures,Triggers, Cursor, PL/SQL and Functions. Knowledge of PL/SQL and Relational Database Systems. Worked on Oracle 9i/10g,
- Excellent Communication and Interpersonal Skills with Strong Technical and Analytical reasoning ability
Technology Expertise
Skills | Endeca, Java, J2EE JDBC, Servlets, JSP , XML, XSL, HTML and JavaScript |
Frameworks | Apache |
Middleware Servers | Tomcat 5.0, Apache 2.0 |
Databases | Oracle 9i, SQL Server 7.0, MS-Access 2000 |
Operating Systems | Unix, Linux and Windows Family |
IDE's / Tools | Eclipse 3.0, TOAD, SVN, Remedy, Autosys. |
Concepts | UML, Design Patterns, Software Engineering |
Domain | Banking Finance, Insurance Retail World |
Technical skills
- Web Designing - JSP, SERVLET, Java Script, HTML, XML.
- Technology Core Java
- Database Oracle Pl/SQL , DB2
- Operating System UNIX, Linux and Windows Platform.
- Ticketing Tools Remedy, Autosys, JIRA, HP Ovsd.
- DB Tool Toad, SQL Navigator.
Achievements
- Associate of the Year in Infrastructure Maintenance Project.
- Innovation Award to implement more Automation tool and scripts.
- Cognizant Spot Award.
Professional Experience
Confidential
Role Application Lead.
Project Description:
- This Project is being executed as per ITL Process management. Cognizant Provides Incident Management and Problem Management Services to its Client Home Depot from locations across USA, Canada, and India covering and managing Severity-2, Severity-1 and Critical Production Incidents for applications across multiple business lines 24 7.
- To restore a normal service operation as quickly as possible and to minimize the impact on business operations, thus ensuring that the best possible levels of service quality and availability are maintained following ITIL best practices approach in adherence with the service-level agreements.
- Act as a focal point within the enterprise for all escalation and communication activities for outages and downtimes related to the Business Applications and Infrastructure, and to ensure that service recovery is handled expeditiously and that systematic issues and problems are addressed proactively and are communicated to senior management and executive levels for awareness and prioritization.
Environment: Unix, Endeca, Linux, Mastero Batch jobs, Java, SQL.
Responsibilities:
- Setup of L1 Support from Transition, Knowledge Transfer and Cross Training to the Offshore, migration of Helpdesk to Offshore, leading a team of 5 members.
- Preparing Key Operating Procedures, Documents of Understanding and Run Books during Transition.
- Creation of Incidents and Service Requests for the supported applications, first point analysis on tickets and assigning them to L2/L3/ other service lines based on the scope.
- Reviewing SLA performance and recommend corrective action.
- To follow up on escalations and issues with clients and Cognizant management.
- Prepare Outage reports.
- Performing and communicating Daily health checks to Management across CTS and Clients.
- SME for 2 applications- Home depot Batch Processing and endeca reference application system. Functional and Technical assistance to help Desk, Online shopping Lifecycle, Global Markets, Trading and Product Structuring
- Handles ETL Batch jobs which runs in Unix server or Mastero job scheduling tool.
- Endeca Fogre jobs to pull business level inputs from ETL extract and load data in to Endeca system.
- Setting up Page Builder application using Endeca Workbench or migrating rules from one to another server and running configupdate live server.
- Clearing cache for Web server, Browser, PIP, WCS admin console.
- We use to extract data from database using ETL extract server using Infomatica server and provide the output to Endeca Server as feed file.
- Endeca is Search engine server which contain all Product informationwith each SKU name.
- Running endeca forge to load data from ETL extract server to Endeca and pushlive triggers to move data to server.
- Implementation technology uses Java, JSP, Servlet, SQL, Unix and Endeca Scripting.
- Leading multiple development team like PIP, PLP, CheckOut, Documentum, Header Fotter apps
- Provided training to QA and Batch support team about the product and troubleshooting methods. Created many SOP's for Produciton support and teacnical team.
- Automated Batch processing like running Endec forge, configupdatelive, Page Builder rules migration, Staging promotion, rebate and shipping.
- Worked in setting up data for Buy online delivery at Store, Buy online shipping store apps.
Additional Responsibilities:
- Performed Training workshop for new joiners in the Team to train them on the entire process and monitoring their transition.
- SPOC for maintain the Quality of tickets by performing daily checks and audits.
- Generated weekly and monthly outage reports and provided to senior management.
- Developed and implemented various process improvements within the team as per ITIL methods and practices..
- Organized Team Building activities to help the team performing efficiently.
Confidential
Role Application Support Lead
Description:
- In this Project we will get insured details in flat file from all the vendors in schedule period and every day morning schedule Batch jobs will pick up files and upload details in to Hartford system which in turn gets reflected in Application. We handle short term disability, long term disability and Leave management system.
- STD Short term Disiability is a benefits in Insurance for all Insuared client and every once acclaim it when they physically disibality. Here we collect details from each insuared company in a flat file
- Daily/Weekly/Bi Weekly and Monthy turns. These files will be processed and load in to Oracle database. Based on business logic the person will be eligible or not.
Following are the services rendered to Hartford Life Insurance Connecticut USA.. L1 Support, User Access Admin, L2 Support, L3 Support, RTB Configuration Management Deployment Environment Services Case Release Management Testing Service
Responsibilities:
- Designed developed various business logic to handle data from Oracle and Unix scripting.
- On-site L1 Support, User Access Administration and Incident Management for Multiple Insurance and Retrie Applications used by internal and external clients.
- Setup of L1 Support from Transition, Knowledge Transfer and Cross Training to the Offshore, migration of Helpdesk to Offshore, leading a team of 10 members.
- Preparing Key Operating Procedures, Documents of Understanding and Run Books during Transition.
- Creation of Incidents and Service Requests for the supported applications, first point analysis on tickets and assigning them to L2/L3/ other service lines based on the scope.
- Tracking of Incident from Opening to Closure, with timely communication to business.
- Communication with Business Clients and first point of contact/interface for application issues and outages between Business and Technology Team.
- Creation and Estimation of efforts for software change requests or enhancements.
- Team Progress Tracking
- Automated batch processing jobs to run on scheduled time based on autosys time.
- Technologies used in this project are Oracle, Applet, Perl, sql loader and oracle forms
Confidential
Role Java Developer
Description:
CPPC module mainly focuses on disbursing pension payments to pensioners at link cell level for all the terminal level branches. Pension disbursement can be done for multiple branches which come under same treasury. The Link cell branch on the basis of scroll received from the paying branch will prepare a summary sheet and send it to RBI / SBI for claiming the reimbursement. GBM 2.8 for United Bank is a version migration project that was customized based on the client's existing version GBM 2.5e . The newer version consists of Tax, PPF Modules with Link Cell functionalities , BOND and SCSS Modules.
Responsibilities:
- Played Developer role at client place and worked as Implementation engineer.
- Worked as onsite developer and single point of contact.
- Provided Post implementation support.
- Worked in customization and adhoc report generation.
- Involved in Providing Technical and Functional Training to clients.
- Responsible for verifying all migration activities during roll outs to pilot branches.
- Execute daily and monthly batch programs in various environment in production, development servers.
- Act as an onsite coordinator to assign tasks and provide clarification to offshore teamEffort estimation for variour change requests and work requests submitted
- Provided Troubleshooting, Functional Testing, Production support and Maintenance.
- Project SPOC for various teams Performing Code mgt using PVCS
Environment: Java, JSP, Servlet, Unix and Oracle.