SUMMARY

• Over 9+ years of professional IT experience in Software Product development, maintenance and enhancements.
• Over 7+ years of experience in technology driven Core Insurance Domain Projects.
• Extensively worked through the phases of Software Development Life Cycle (SDLC):analysis, design, development, testing, implementation, enhancement and Maintenance.
• Strong in PL/SQL programming, writing stored procedures, functions, packages and triggers, views on Oracle 10g/11g databases.
• Knowledge of Oracle reports 6i, Unix shell scripting.
• Practicing QMS processes; involved in Production Support (24x7) and fixing the problems.
• Understanding of basics of Object Oriented Programming, and Frameworks such as Java Servlets, Struts. Basic knowledge in JSP, JavaScript and HTML;
• Good knowledge in rational tools such as ClearQuest. Capable of translating business requirements into functional technology requirements.
• Have used Version control tools like SVN and VSS
• Self - motivated with an ability towork independentlyto meet operational deadlines in a demanding fast-paced environment.
• Excellent interpersonal skills, ability to interact with people at all levels, In-depth experience in managing and providing technical guidance/support to teams and providing implementation support.
• Received appreciation from client and Management for work in data center migration projects, successfully implementing major enhancements in the systems, providing solutions, documentation and support provided for the critical situations.
• Team Player and have been successful in mentoring and guiding teammates, as well able to work independently with minimum supervision.
• Good communication skills with strong ability to interact with end-users, customers, and team members; Enthusiastic, quick learner & and strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

RDBMS: Oracle 11g, MS SQL Server and MS-Access

Languages: PL/SQL, Java, HTML, XML, C, C++, VB6.0, shell scripting, VBScript and JavaScript

Report building: Oracle reports 6i.

Java EE: Servlet, JSP.

Framework: Struts

IDE Tools: Toad, SQL Developer, PL/SQL developer, FrontPage, Edit Plus, Notepad++

Version Control: Tortoise SVN, Microsoft Visual Source Safe.

Defect Tracking: Rational Clear Quest, LANDesk and OTRS.

Operating Systems: MS Dos, Windows XP/2000/Windows7, Linux, and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Oracle developer

Responsibilities:

• Involved in development and production support of Customer Response and Complaints (CRC) system which is used to integrate data received from various feeds/systems for managing all incidents, problems, customer responses and feedback, and any related action items leveraging a centralized, scalable platform that is used by various departments of the organization.
• Development of Trackwise system which involved collecting information about the products and their relative features of various operating companies, integrating information received from SAP and other systems, validation, implementing business logic and error reporting.
• Regular Interaction with business users and product experts in R&D department to determine business/technical requirements, analyzing business process and workflows and suggest improvements.
• Set up automated system for data loading, Tracking and monitoring and error reporting.
• Involved in development of Bill of Material feeds that interact with machines used in the manufacturing of the products.
• Developed and ModifiedPL/SQL packages,functions, Proceduresas per customer requirement to make new enhancements or to resolve problems.
• Worked on writing queries for data analysis, data validation and generating reports, developed data modification scripts to implement business requirements.
• Worked onPL/SQLcollections, Bulk collections and Exception handling.
• Extensively worked onPL/SQLfeatures likeTriggers, Data blocks, Report Layout, Report Triggers.
• Also worked on advancedPL/SQLconstructslike Oracle supplied packages, Collections, Nested Tables, VARRAYS, Records, Types, and Dynamic SQL and Analytical functions.
• Along with Code development worked on impact analysis of fix, unit test case preparation and unit testing.
• Support activities like data configurations, data patch, etc.
• Worked with users during UAT to ensure smooth functioning of the deliverables and provided support to resolve user queries and concerns.Resolved defects and provided continuous support till GO-LIVE.

Environment: Oracle 11g, HTML, TOAD, Sql developer, batch scripting, SQL Loader, FileZilla, Microsoft visual source safe, Agile environment

Confidential, Monroeville, PA

Oracle developer

Responsibilities:

• Interacting with Client (Internal or External), end to end coordination of the requirements starting from requirement gathering to development and then to Integration Testing.
• Regular Interaction with customers to determine business/technical requirements, analyzing business process and workflows and suggest improvements.
• Developed and ModifiedPL/SQL packages,functions, Proceduresas per customer requirement to make new enhancements or to resolve problems.
• Worked on advancedPL/SQLconstructslike Oracle supplied packages, Collections, Nested Tables, VARRAYS, Records, Types, and Dynamic SQL and Analytical functions.
• Also worked onPL/SQLcollections, Bulk collections and Exception handling.
• Extensively worked onPL/SQLfeatures likeTriggers, Data blocks, Report Layout, Report Triggers.
• Along with Code development worked on impact analysis of fix, unit test case preparation and unit testing.
• Support activities like data configurations, data patch, etc.
• Worked with users during UAT to ensure smooth functioning of the deliverables and provided support to resolve user queries and concerns.Resolved defects and provided continuous support till GO-LIVE.
• Worked on oracle Reports and shell scripting to automate/schedule the reports as per requirements.
• Ability to programUNIX shell scriptsin applications that schedule, validate flat file data, execute SQL, archive files or FTP files
• Strong working experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing

Environment: Oracle 11g, HTML, TOAD, UNIX, Oracle reports 6i, Sql developer, Shell scripting, FileZilla, PVCS version manager, Agile environment

Confidential, Plantation, FL

Sr. Software Engineer / Oracle developer

Responsibilities:

• Interacting with Client (Internal or External), end to end coordination of the requirements starting from requirement gathering to development and then to Integration Testing.
• First point of contact for severity 1 issues, address the Sev1 issues on priority and work towards quick resolution and turnaround. Makes sure SLAs are meet for all the issues reported. Excellent analytical and problem solving skills with understanding of project management.
• Regular Interaction with customers to determine business/technical requirements, analyzing business process and workflows and suggest improvements.
• Worked with users during UAT to ensure smooth functioning of the project.Resolved defects and provided continuous support till GO-LIVE.
• Designed and coded application components in an Agile environment utilizing a test driven development approach. Also experience in working in pair programming approach to ensure high quality code.
• Created important data Reports for the clients to help them understand Market trends and inclinations.
• Involved in successful data center migration project. Coordinated with different teams (DBAs, Unix support & Network team, development team at offshore), Single point of contact for all clients and stakeholders.
• Ensure all support processes are carried out on time and there is no impact to deliverables.
• Successfully implemented health checks systems for Defect tracking. Automated end of month activities to save manual efforts, reduce turnaround time and eliminate manual errors. Implemented batch scripts to automate the process.
• Worked proactively to provide appropriate root cause analysis for recurring problems to avoid issues in the applications
• Interacted with customers to determine business/technical requirements, issue resolution.
• Was involved in Planning and tracking the requirements through the entire life cycle.
• Generate dashboard report every week and discuss with clients.

Environment: Oracle 11g, Struts, JSP, HTML, TOAD, UNIX, Oracle reports 6i, Sql developer, Shell scripting, FileZilla, Agile environment

Confidential, LA

Sr. Software Engineer / Installation lead

Responsibilities:

• Involved in development of POS application, deployment and testing phases.
• Functional requirements specification document preparation and reviews. Requirement Gathering, Analysis and Design.
• Estimation preparation.
• Worked on environment creation/refresh activities.
• Worked on development of interfaces like MVR ordering, Clue ordering. Coordination with multiple groups (oracle DBAs, network team, Unix support team, etc.), internal and external clients, third party vendors for successful implementation of the interfaces.
• Involved in unit test case preparation and integrated testing of the entire application.
• Handled the release management, release coordination and verification.
• Deployment, Application support and documentation.
• Actively involved in production support during business hours for a month after go production live.
• Received Appreciation from client and management for go-live production support (solutions/work around provided, data patch, setup configurations, etc.)
• Lead a team of 5 resources at offshore for production support and enhancements.
• Involved in code reviews, test case reviews and gave feedback on various design aspects.
• Involved in the requirement gathering for Change Requests
• Used Microsoft Visual source Safe tool for Version Controlling
• Proven successful in coding and technical sharing with the team of developers.
• Involved in successful data center migration project, taken care all pre-requisite & checkpoints for successful data center migration.
• Worked on configurations, interfaces and communication of various systems.

Environment: Oracle 11g, Struts, JSP, HTML, TOAD, UNIX, and Oracle reports 6i, Agile environment.

Confidential, LA

Installation lead

Responsibilities:

• Lead a team of 3 resources at offshore.
• Involved in code reviews, test case reviews and gave feedback on various design aspects.
• Worked on Deployment, Application support and documentation
• Involved in the requirement gathering for Change Requests
• Functional requirements specification document preparation and reviews.
• Estimation preparation.
• Involved in integrated testing of the entire application
• Worked on environment creation/refresh activities.
• Handle the release management for the project.
• Used Microsoft Visual source Safe tool for Version Controlling
• Proven successful in coding and technical sharing with the team of developers.
• Providing the functional help for the team members.
• Worked in an Agile environment utilizing a test driven development approach.
• Involved in database migration from 10g to 11g.

Environment: Servlet, HTML, Oracle 11g, TOAD, UNIX, Oracle reports 6i, Agile environment.

Confidential, Phoenix, AZ

Team member

Responsibilities:

• Involved in Production support.
• Analysis of defects logged by client, worked on debugging the problem.
• Preparing IID and detailed investigation documents for issues logged.
• Code development, impact analysis of fix, unit test case preparation and unit testing.
• Handle the release management for the project.
• Involved in support activities like data configurations, data patch, etc.
• Worked on preparing business understanding documents and FRS for new enhancements.
• Actively participated in development of major enhancements like new line of business, implementing new state for existing line of business.
• Created and/or modified SQL stored procedures whenever required for change requests/enhancements
• Conducted presentations for review.

Environment: HTML, CSS, JavaScript, Servlet, Oracle application server, Oracle 10g, SQL Developer, Toad, Unix/Windows XP, Agile environment.