SUMMARY:

• Around 5 years of professional IT experience in Software Product development, maintenance and enhancements.
• Expertise in Software Development Life Cycle(SDLC) of client implementations including requirements gathering, business analysis, system configuration, design, development, testing, technical documentation and support
• Experienced in Development and Implementation of applications using MySQL and SQLServer databases
• Experience in SQL, PL/SQL, HTML, CSS
• Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception Handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.
• Experience inData migration/conversion using SQL*Loader
• Experience wifData flow diagrams, data modelling, design techniques and schema design.
• A good understanding of UNIX shell scripting.
• Experience in written PL/SQLscripts to create new tables and their corresponding database triggers, sequences, synonyms, indexes, and constraints understanding of Data model and RDBMS concepts
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• Experience in creating JIL files and setting up of dependencies for Autosys job execution
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Experience wifPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS
• Experience inETLtechniques and Analysis and Reporting
• Hands on experience on Oracle Financials Modules like GL, AP, AR, FA, and CM in R12
• Good experience in development of applications of Java, Oracle as well as Unit, Integration and System Testing.
• Experience interacting wif cross - functional, global teams and communicating project information to multiple levels in an organization.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, LINUX, Mac OS

Programming Language: Oracle PL/SQL, SQL, C, C++, HTML, XML, UNIX shell scripting, Java, PerlDatabaseOracle 11g/10g/9i, MySQL, MS Access

Tools: SQL Developer, PL/SQL Developer, SQL*LoaderTOAD 9.6/11.6.1.6, Informatica power center 8.5/9.1 HF5, MS Visual Studio, MS Office, Autosys Version 3

PROFESSIONAL EXPERIENCE:

Confidential ., NJ

Oracle PL/SQL Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and interaction wif theclient.
• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.
• Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Written complex Oracle SQL queries wif complexity using Inner/Outer joins, Union All, Intersect & Minusset operators.
• Optimized query performance wif modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful indexes and Views.
• Created and Developed various DB objects like tables, views, partitioning tables, indexes, sequences, synonyms using TOAD
• Extensively executed SQL queries to view successful transactions of data.
• Developed PL/SQL package procedures using REF cursor, Collections.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Used Unix Shell Scripting to load files in the respective tables and invoke the procedures.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• Involved in planning process of iterations under the Agile Scrum methodology.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Involved in Code Reviews and preparing Unit test cases.

Environment: Oracle 11g/10g, PL/SQL, SQL*Plus, SQL Loader, TOAD, Unix Shell Scripts, SQL, Agile, Oracle PL/SQL Developer

Confidential ., Piscataway NJ

Oracle PL/SQL Developer

Responsibilities:

• Involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner.
• Troubleshoot the existing PL/SQL procedures, functions, triggers
• Stored Procedures, Triggers and Functions were developed for Business rules.
• Involved in coding and testing of the system.
• Developed database objects like Tables, Views, Indexes, synonyms and sequences
• Analyzing tables and indexes for performance tuning
• Defined indexes on various tables to improve the performance of the queries for reporting purpose
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Created indexes for better performance.
• Worked wif Global Temporary Tables
• Involved in PL/SQLcode review and modification for the development of new requirements.

Environment: Oracle PL/SQL, SQL Developer, Oracle 9i/11g, Java, Perl

Confidential, Piscataway, NJ

Oracle PL/SQL Developer

Responsibilities:

• Developed database objects like Tables, Views, Indexes, synonyms and sequences.
• Created PL/SQL functions, procedures, packages, triggers according to the business requirements.
• SQL, PL/SQL tuning and improvements on existing code.
• Defined indexes on various tables to improve the performance of the queries for reporting purpose
• Created Cursors, Collections and database triggers for maintaining integrity constraints and implementing the business rules.
• Created Views on multiple tables
• Creation of new packages and modification of existing codes to resolve application bugs
• Performed Unit testing, integration and System testing to ensure the application meets business requirement.
• Responsible for data mapping
• Involved in bug fixing and production support after the application moved to production.

Environment: Oracle PL/SQL, SQL Developer, Oracle 9i/11g, SQL Loader

Confidential

PL/SQL Developer

Responsibilities:

• Developed PL/SQL procedures and functions to assign sensitivity levels to specific data based on a set of rules.
• Developed PL/SQL stored procedures and functions to implement customer specific rules
• Worked wif systems and business analysts to establish data warehouse design.
• Used ETL tool Informatica to convert code from other DBMS versions to Oracle
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Participated in moving data from production environment to testing and development environments to test the performance of application.
• Performed Unit testing, integration and System testing to ensure the application meets business requirement

Environment: Oracle 10g, Oracle PL/SQL, SQL, UNIX, Korn Shell Scripting, TOAD

Confidential

Intern - Data Analyst

Responsibilities:

• Interacted wif Business users and Business System Analyst to understand reporting requirements and prepared Functional Requirement document.
• Experience in working wif Technical specification document after getting approvals of BRD's from Business users.
• Analyzed the data files to better know the business.
• Created Tables, Indexes, Views.
• Experience wif Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Developed database objects like Stored Procedures, Functions, and Packages using PL/SQL.
• Worked along wif the DBA to resolve performance and tuning issues.
• Experience in the usage of Autosys scheduler to schedule workflows and sessions.
• Used different partitioning options for better performance.
• Involved in doing Unit Testing, Integration Testing and System Testing.
• Assist in QA and UAT testing and involved in Production support.

Environment: Oracle 10g, Windows XP, SQL Loader, SQL * Plus, MS Visual Studio, TFS.