SUMMARY OF QUALIFICATIONS

• Qualified Software Professional with 5 years of experience in development of software applications in Oracle Sql Java and J2EE.
• Opportunity to work on OPT from FEB-2015 for 12 months.
• Design Development Implementation and support Of RDBMS in Development Test and Production environments using Oracle Tools.
• Extensive experience in Project Development Life Cycle including requirement gathering and Analysis Database design Database development Application development.
• Extensive experience in Oracle 11g/10g/9i/8i and hands on experience writing Oracle SQL queries and Oracle PL/SQL Stored Procedures Functions Packages Database Triggers Exception Handlers Cursors and using latest features to optimize performance Bulk Collects Collections Ref Cursors Global Temporary Tables Hints .
• Proficient in writing and tuning complex SQL statements complex joins co-related sub-queries and SQL statements with Analytical functions Rank Lead Lag etc .
• Experience in tuning application using tools like Explain Plan SQL Trace and TKPROF for high efficiency.
• Knowledge of various Client-Server development technologies with the help of J2EE JSP Servlets JDBC HTML Ajax.
• Experienced of developing application using C and MS Access
• Experienced in developing batch programs by using PL/SQL and shell scripts and in using SQL Loader for loading data from flat files into Oracle tables.
• Extensively worked with third party database tools like TOAD.
• Excellent Interpersonal and Communication skills coupled with strong technical and problem solving capabilities.
• Experience in working on projects individually and as part of teams as big as 30 people.

TECHNICAL SKILLS

PROFESSIONAL ACCOMPLISHMENT

Confidential

Business Software Intern

1 Project Name - Review CRM Database Performance

• I analyzed CRM Database and relationship between different tables like Lead ActivityPointerBase AsyncOperationTypes and suggested indexes which can improve database as well as application performance. AP Wireless uses Microsoft CRM DB.

2 Project Name - Address Split Tool

• Marketing Team has USA Address file which contains data like Street City State Zip code and Area code. They had used number of formats to document this information.
• I created one application by which will parse all the formats and arrange into one single format which will enlist Street City and State as fields. It will also show error to the user if any one of the field is invalid.
• Created Front end using windows application forms of Visual C and also Ms Access database table which contains data about each State validates user provided address.

Confidential

Senior Software Engineer

• Re-engineered software systems for policyholder that allowed them to focus on providing the best products and services to meet the ever-changing needs of their members.
• Conducted new requirements specifications defects resolution and status updates discussion on a regular basis with clients located in Texas.
• Prepared technical design documents test plan and test cases for different modules of the policy system.
• Constructed modules for account payable account receivable cash allocation reverse cash allocation and checks entry module along with reports of policy application for handling accounting operations.
• Achieved a performance enhancement of 20 by partitioning the appropriate tables to optimize data. Improved the maintenance of tables by applying partitioning concepts.
• Created partitioned tables partitioned indexes for manageability and scalability of the application.
• Developed Database Triggers for the integrity and security purpose
• Analyzed the existing data structure and evaluated the integrity of data.
• Worked on JBEAM for Scheduling and executing end of the business day or monthly processing also monitored of the Jobs status and execution.
• Experience in working a variety of analytical functions RANK DENSE RANK LAG LEAD and PARTITION OVER.
• Constructed reporting module for each level application using complex queries to produce customized report formats for each team based on individual requirements.

Familiar with SQL Loader to load data from external source like flat files into database tables.

• Associated with testing existing code and making necessary enhancements for Oracle 11G upgrade. Created database objects such as tables indexes views materialized views triggers sequences synonyms.
• Involved in working with IMPLICIT CURSORS EXPLICIT CURSORS REF CURSORS.

Created huge database packages with related functions and procedures. Created views by joining multiple cash flow tables to show output as a report to the user.

Used several Oracle predefined functions NVL NVL2 DECODE CASE STATEMENT.

Designed competent pl/sql programs using collections Records types and Object types.

Confidential

Software Engineer

• Developed three different applications using java and sql for each level of business starting with asset management pre-sales activity and order management systems. Increased the revenue of the Internet Data Center IDC by automating these three systems.
• Designed and implemented a model that systematically defines a problem.
• Interacted with various teams for gathering business requirements and confirmation of process flow diagram. Created interface design documents.
• Successfully executed all the phases of testing unit Integration data validation user acceptance testing and launched the final product.
• Constructed reporting module for each level application using complex queries to produce customized report formats for each team based on individual requirements.
• Create triggers to keep track of changes to the fields of tables when changes are made.
• Extensively used java OOP Core java concepts like interfaces Abstract classes collections etc.
• Developed server side code using Servlets.
• Developed JDBC code for retrieving data from Oracle.
• Developed JavaScript validations on the client side.
• The application was deployed on the Tomcat.

Confidential

Programmer

• Developed a java application that collects stores and displays news concerning equity markets from Dow Jones.
• Used file handling concepts for reading and writing data from file.
• Developed SQL queries using various functions like date NVL Decode analytical functions.
• Maintained the company s central website to display financial reports and provide future investment trends using HTML.