SUMMARY:

• 6 years of experience in Oracle (SQL, PL/SQL), Forms, Shell Scripting and .NET.
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Extensive experience in developing applications using Oracle database 11g/10g/9i, on Windows/Unix/Linux Environment.
• Strong Coding and Designing Experience in Oracle Forms, PL/SQL & SQL.
• Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace and PL SQL Profiler.
• Design of data models and objects including Tables, Views, and User defined Functions, Triggers and Stored Procedures for applications.
• Experience in Dynamic SQL, Records, and Exceptional handling.
• Expert in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages in PL/SQL to implement business logic.
• Expertise in Writing/ Executing Stored procedures, Crystal Reports, Test Cases, Reporting defects.
• Skilled in Database activities which include creating databases, table spaces, performance tuning, role & user management.
• Worked closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications; refine conceptual systems design requirements into the technical design.
• Strong team player, ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning, Possess excellent communication, project management, documentation, interpersonal skills
• Facilitated sharing of knowledge through team presentations and gathering best practices.
• Trained and led a team of four.
• Have got multiple appreciations from the clients and business users for excellence in work and product knowledge.
• Skillful in Remedy management Tools, ETL Tool and UNIX.
• Domain knowledge on Insurance and Mobile Applications.

TECHNICAL SKILLS:

Languages: Oracle, PL/SQL,C,C++, ASP &VB.NET

Scripting: UNIX shell scripting.

Tools: Toad, Putty, Remedy (Tool to schedule Unix jobs), Pl/SQL Developer,Assembla

Internet Programming: JSP,HTML,XML

Packages: Micro Soft Office Suite - MS-Word, MS-Excel, MS-Power point. MS-Access

Others Tools: SQL*Loader, MS Project Professional 2003

OS: Windows XP/2000/Linux

PROFESSIONAL EXPERIENCE

Confidential, Lake Mary, Orlando

Environment: Oracle PL/ SQL, ASP.NET, Assembla Tool

Project Responsibilities:

• Coordinating with offshore team and the Client for discussions/meetings to provide better solution and understanding of business requirements.
• Identified trends and recommended proactive or remedial action to manage business situations.
• Involved and Developed Project that maintains Data Base Objects and Reporting using PL/SQL Stored Procedures, Functions, Triggers and Packages to facilitate the cleanup of unused Oracle objects.
• Created a discussion forum internally to log in activities that are performed daily by the distributed teams.
• Created a Deployment check mechanism to make sure the projects that are delivered are up to the requirements provided by the client.
• The tool can be used by the clients to interact directly with the team lead of each project, through Skype, chat or call.
• Daily automated reports of projects are sent to the management team.
• An Amber alert mechanism is used to trigger mail regarding projects that are in danger zone.

Confidential

Environment: Oracle 10g, ASP.NET

Project Responsibilities:

• Involved in customization of application based on the business specification document.
• Involved in writing custom interfaces for loading Invoice, Payment, Account Receivable data related to data base.
• Guiding the team members for implementing complex SQL queries and tuning for better performance.
• Involved in writing complex SQL queries and building reports based on business requirements.
• Performed unit testing, integration testing and performance testing on the website and updating the reports in Assembla.

Confidential

Environment: PHP, XML,IOs iPhone 5, iphone6,Mobile applications

Project Responsibilities:

• Interactive exercises, discussions and quick prototype development fed into the project roadmap, identifying areas of technical risk and developing mitigation plans DE-bugging and analyzing the applications related issues by looking into logs and configuration.
• Involved in the simulation of production environment to enable real-time integration and testing of software under development.
• Software build and deployment processes were automated so that the team could manage several versions of the software efficiently.
• An automated regression test framework was created to safeguard around the software, rapidly identifying faults and ensuring the highest levels of quality across the application.
• Updating the client every two weeks, functionality was “showcased” to the customer to review and re-prioritize work for the next iteration.
• Agile methodology was followed to ensure quality and timely delivery.

Confidential, Hartford, CT.

Environment: Oracle Forms, PL/SQL, UNIX shell script, Remedy management Tool, TOAD.

Project Responsibilities:

• Involved in writing data base objects to implement interface using procedure, functions and packages to enhance the application based on the client requirements using Oracle Forms, SQL and PL-SQL.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Involved in enhancement of customized decision making rules/policies.
• Performed bug fixes in the existing PLSQL packages, procedures, functions, Materialized Views using TOAD.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Working on Change requests/enhancements based requirements. This includes preparing the documents like Work Request Form, Test Case and Implementation documents and development Using Oracle SQL and PL-SQL.
• Involved in writing new and enhancing the existing Unix Shell Scripts to configure as jobs. This job involves invoking PL SQL Procedures / Packages, automate ftp jobs from Unix Server.
• Served as a Subject Matter expert in Loss processing and provides inputs and reviews the internal team work for technical and functional accuracy
• Used UNIX SHELL scripts for automation of daily and weekly, and monthly jobs on IBM Tivoli Work Load Scheduler.
• Performed the upload and download of flat files from UNIX server using FTP.
• Participated in System Testing and UAT.
• Involved in the functional and technical meetings for each release.
• Provide technical leadership to team members and best practices followed.

Confidential

Environment: Oracle 6i &10 g, PL/SQL, PERL, SQL Reports, UNIX, Remedy and TOAD.

Project Responsibilities:

• De-bugging and analyzing the applications related issues by looking into logs and configuration.
• Involved in writing data base objects to implement interface using procedure, functions and packages to enhance the application based on the client requirements Using Oracle SQL and PL-SQL.
• Involved in enhancement of customized decision making rules/policies.
• Performed bug fixes in the existing PLSQL packages, procedures, functions, Materialized Views and views.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Responded to customers queries assigned as ticket based on the priority.
• Experience in off-hours on - call support, handling resolution of issues on that are critical to the business.
• Writing SQL queries and tuning for better performance. The tuned SQL queries will be used for designing reports..

Confidential

Environment: Tomcat, Eclipse and JAVA.

Responsibilities:

• Was involved in the development of screens using JSP.
• Have monitored and mentored a team of four.
• Coordinated all activities as per schedule provided.
• Project was selected as one of the top projects performed by the management.

Confidential

Responsibilities:

• Analyzed and participated in the activities to control and manage busy routed traffic lines.
• Exercised analytical skills in coming up with ideas on how to improvise the present system of navigation and both independently as well as in a team.
• As part of the team embarked on field trips, visiting places where navigation of the router lines was carefully monitored, giving me a better understanding of telecommunications management and its accompanying systems.