PROFESSIONAL SUMMARY

• 7 Years of IT industry experience as a developer/analyst in multiple technologies and different roles.
• Experience in Oracle Development.
• Extensive experience in developing PL/SQL Procedures, Functions, Packages, Triggers.
• Experience in Analysis of Query EXPLAIN PLANS and performance tune SQL SELECT Queries.
• Experience using SQL Plus editor for older oracle versions.
• Possess good knowledge and fair amount of experience in other performance tuning concepts like EXTERNAL tables, partitions and Indexes.
• Possess good Logical /Physical database design principles and Normalization concepts.
• Experience working with OLAP functions.
• Experience in JAVA and C Programming languages with good Procedural and Object Oriented Analysis Skills.
• Experience in web technologies like XML, HTML5.0 and Java Script.
• Experience writing JAVA test cases using testing API's like JUnit, Apache Camel test kit.
• Experience in creating and working with CTE for the implementation of Recursive and Hierarchical queries in T-SQL/ORACLE.
• Experience in advanced PL/SQL concepts like BULK COLLECT, BULK LOAD and FOR-ALL.
• Proven experience using Oracle 8i/9i/10g/11g, SQL, PL/SQL, SQL Plus.
• Experience in using SQL server Management Studio
• Experience working in OLTP and Data warehouse Environments.
• Experience in Requirements capturing, System analysis, Logical and Physical data modeling, Development and Implementation of software applications.
• Experience in Data Warehouse Environments and related technologies.
• Experience using version control software's like CVS and SVN.
• Solid understanding of data structures and algorithms using C/JAVA
• Possess excellent oral/written communication and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.
• Strong problem solving technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer

Responsibilities:

• Analysis of different layers of the legacy transaction server code in C.
• Conversion of the transaction server code to new open source architecture frame work built using JAVA and other open source technologies
• Testing, building and deployment of applications in development environment.
• Prepare documents based on the analysis for the business flows under conversion for future reference and development purpose.
• Publish transaction messages, check message queues and compare the data processing on both legacy and modern servers as part of the integration testing.
• Developed Materialized Views and partitioning tables for performance reasons.
• Analyze Integration testing data for breaks executing backend SQL queries.
• Extraction of data from different sources like OLTP server, flat files, excel and legacy.
• Analyze stored procedures to move code other than business logic to JAVA.
• Analyze stored procedures for slowly changing data to cache in Application Server JBOSS cache reducing back end calls and network calls/data transfers.
• Analysis and conversion of database procedure calls to JBOSS CACHE and XML reducing database calls and increasing performance.
• Writing scripts to automate the message publishing process for testing and reconciliation on different transaction servers.
• Build, Migration and Deployment of application JAR files in DEV environment.
• Running Database Scans to fix back-end issues and improve the query performance after analyzing query plan as part of business support for Book keeping business flow.
• Running database scans on Production and QA environments as per requests from business users and clients.
• Involved in the client support handling priority tickets and productions support issues.

Environment: LINUX/UNIX

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Maintenance of the company web site hosted on remote IIS server 7.0.
• Generated Managerial level reports using SQL server SSRS.
• Wrote stored procedures/functions implementing business activities.
• Wrote SQL scripts to fix back end related issues.
• Modified existing procedures and functions implementing best techniques to improve the performance.
• Wrote C code to extend the functionality of the community site using third party API like Telligent 5.6.
• Involved in the system upgrade activities to new versions.
• Design and development of multiple drilled down/drill through reports to integrate summary and detail data alongside using SSRS Report Designer.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
• Created Filtered reports using report parameters, stored procedures cascading parameters.
• Extraction of data from different sources like OLTP server, flat files, excel and legacy databases
• Analyze Oracle SQL query plans using EXPLAIN PLAN command.
• Gather Database and User Level Statistics and Analyze Overall System Performance.
• Organize and participate in company annual events.
• Writing test cases for the code analysis and bug issues before deployment on to the production server.
• Maintain company network, user accounts and fix any software and desktop related issues.
• Scheduling and running jobs in the background, and taking regular backups of the systems and recover data during failures.

Environment: IIS server 7.0

Confidential

Senior Oracle PLSQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Created Materialized Views and partitioning tables for performance reasons.
• Worked on various backend Procedures and Functions using PL/SQL.
• Writing JAVA test cases using JUnit 4.0 API, Apache Camel test kit API.
• Modifying the existing stored procedures or functions to improve the performance.
• SQL Query Performance Tuning with the creation of Partitions/Indexes after analysis.
• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Involved in all phases of the SDLC for Designing giving recommended approach to satisfy the requirements.
• Involved in Integration testing and load testing of the message layer and transaction data persistence layer.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
• Used TOAD, ORACLE developer tools for faster application design and development.
• Developed procedures using Dynamic SQL.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements

Confidential

Environment: UNIX shell scripting, IBM/AS400

Confidential

PL/SQL developer

Responsibilities:

• Used the technical document to design the database tables.
• Coded various stored procedures, packages and triggers to incorporate business logic into the application.
• Creating table spaces, tables, views, scripts for automatic operations of the database activities.
• Maintaining Logical and Physical structure of the database.
• Involved in the maintenance and enhancement of the application.
• Installation, Creation and support of Oracle database environments.
• Writing stored procedures/functions according to the business requirements and organize them into packages.
• Gather Database and User Level Statistics and Analyze Overall System Performance.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.

Environment: UNIX, Weblogic Server.