SUMMARY

• Over 10+ 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.
• Performed SQL tuning by using Explain Plan and Tkprof. Used AWR is used to collect performance statistics.
• Knowledge of Oracle reports 6i, Unix shell scripting.
• Practicing QMS processes; involved in Production Support (24x7) and fixing the problems.
• Experienced programmer in Java Servlets 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

IDE: Oracle Forms

Report building: Oracle reports 6i.

Java EE: Servlet, JSP.

Framework: Struts

API Tools: SOAP UI

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, Cleveland, OH

Programmer Analyst / Oracle PLSQL developer

Responsibilities:

• Involved to determine business/technical requirements, analyzing business process and workflows and suggest improvements.
• Involved to set up automated processes for data loading, Tracking, monitoring and error reporting and messaging in middleware environment utilizing Unix Shell scripting; scheduling daily/weekly/monthly processes utilizing CRON script.
• Involved in logical and physical design and partitioning the database tables; writing SQL queries, advanced PLSQL artifacts; coding of stored procedures, triggers, packages, functions and complex queries at an advanced level; SQL loading using SQL Loader, external tables.
• Developed and ModifiedPL/SQL packages,functions, Proceduresas per customer requirement to make new enhancements or to resolve problems.
• Involved in performance tuning of databases and applications by optimizing database code utilizing SQL Optimizer, mapping objects to the relational database; design and develop applications to generate customized reports utilizing Crystal reports; analyze, code and test application utilizing XML/XSL/XSLT technologies and SOAPUI.
• 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.

Environment: Oracle 11g, HTML, TOAD, Sql developer, Shell scripting, Crystal reports, SQL Loader, FileZilla, JIRA, GITLab, Agile environment

Confidential, Richmond, VA

Oracle PLSQL 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. Worked on a system to integrate data received from various database schemas into centralized, scalable platform.
• Development of Trackwise system which involved collecting information about the products and their relative features of various operating companies, integrating information received from SAP, Excel sheets, Flat files, Microsoft Access database and other systems. Developed source code for 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.
• Performed SQL tuning by using Explain Plan and Tkprof. Used AWR is used to collect performance statistics.
• 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 PLSQL 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.
• Worked on developing, bug fixing, and optimizing the dynamic SQL for an application required for a search utility within application.
• Also worked onPL/SQLcollections, Bulk collections and Exception handling.
• Extensively worked onPL/SQLfeatures likeTriggers, Data blocks, Report Layout, Report Triggers.
• Performed SQL tuning by using Explain Plan and Tkprof. Used AWR is used to collect performance statistics.
• The UI was developed on Oracle Forms. Worked on debugging issues faced in development phases.
• 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 by scheduling CRON jobs.
• 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, Oracle Forms, Sql developer, Shell scripting, FileZilla, PVCS version manager, Agile environment, CRON scripting

Confidential, Plantation, FL

Oracle PLSQL developer / Team lead

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.
• 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.
• 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.
• Worked on comparative rater application which calculates multiple rates for a policy and load quotes on MS access database for further assessment and reporting purpose.
• Worked on JSP, struts framework, Java Servlets, JavaScript and HTML. Also worked on SOAP UI for comparative rater application.
• 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, SOAP UI, Java Servlet, Java Script, HTML, TOAD, UNIX, Oracle reports 6i, Sql developer, Shell scripting, CRON scripting, FileZilla, Agile environment

Confidential, LA

Oracle PLSQL developer / Team lead

Responsibilities:

• Involved in development of POS application, deployment and testing phases.
• Functional requirements specification document preparation and reviews. Requirement Gathering, Analysis and Design.
• Worked on environment creation/refresh activities.
• Worked on comparative rater application developed using SOAP UI.
• Involved in unit test case preparation and integrated testing of the entire application.
• Handled the release management, release coordination and verification.
• 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.
• 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, SOAP UI, HTML, TOAD, UNIX, shell scripting, CRON scripting, and Oracle reports 6i, Agile environment.

Confidential, LA

Oracle PLSQL developer

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.
• 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.
• 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

Oracle PLSQL developer

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.
• 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.
• Created and/or modified SQL stored procedures whenever required for change requests/enhancements
• Conducted presentations for review.

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