SUMMARY

• Around 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS).
• Expertise in database design and development on client/server applications using Oracle 11g/10g/9i/8i, SQL, and PL/SQL
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing and maintenance with timely delivery.
• Worked extensively on Stored Procedures, Triggers, Functions and Packages.
• Experience with Data flow diagrams, Entity relation modeling and design techniques.
• Involved in creating database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL plus.
• Involved in data loading using PL/SQL and SQL Loader.
• Good experience in writing UNIX shell.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Involved in Performance tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Expertise in working with built - in packages like DBMS LOB, DBMS SQL, DBMS SHEDULER, DBMS DDL, UTL FILE
• Experience in working with different operating systems like Windows,UNIX and Linux.
• Ability to work independently and adapt quickly to new and emerging technologies.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle, MS SQL Server & MYSQL

Scripting: UNIX Shell Scripting

Languages: SQL, PLSQL, CORE JAVA, J2EE, UNIX, C & C++.

Tools: SQL Developer, TOAD, SQL plus, PUTTY, WINSCP.

Data Modeling: Erwin 7.3, SQL Developer, Toad.

Markup Languages: JavaScript, HTML, XML, CSS.

Operating Systems: Windows, UNIX, Linux.

Ticketing Tools: BMC Remedy, JIRA.

Version Control: CVS, SVN, Clear Case & GitHub

Software Methodologies: Agile & Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Oracle PL/SQL Developer

Responsibilities:

• Responsible for Analysis, Design, Coding, Debugging and testing the processes/programs that are necessary to extract data from Operational Databases, transforming and cleaning the data and loading it to data ware house.
• Worked in an Agile Environment and participated in requirement gathering.
• Involved in both front-end and back-end development using simple and complex SQL/PLSQL like Stored Procedures/Functions/Package/Triggers, Collections & REF Cursors as per Business Requirements.
• Analyzed and designed relational databases using ER Studio and Erwin Data Model Tool.
• Creation of database objects like tables, views, synonyms, materialized views using Oracle tools like PL/SQL developer.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Created Database links to connect to remote databases and to be able to pull data, perform joins to manipulate the data.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Involved in creating unix shell scripting.
• Involved in performance tuning using tools like EXPLAIN PLAN, SQL*TRACE & TKPROF.

Environment: Oracle Database 11g, PL/SQL, SQL, TOAD, Erwin, Unix shell scripts and XML.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked in an Agile Environment and participated in requirement gathering, analysis and design.
• Designed Logical and physical data models for BN database schemas using Erwin.
• Worked on the bulk uploading of huge amounts of statistical data to the database.
• Wrote loader scripts using SQL Loader/External tables to load large tables.
• Responsible for developing and modifying several PL/SQL packages procedures, functions, views and triggers using PL/SQL to effectively incorporate Business rules.
• Involved in writing the database triggers to furnish the audit details.
• Involved in creating complex views that require complex joins.
• Creating and modifying several Unix Shell scripts according to the changing needs of the project and client requirements.
• Developed SQL queries to provide reports to business team.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the table for Oracle database.
• Worked on SQL Loader to extract data from flat files obtained from various sources using standard packages like UTL FILE & DMBS SQL.
• Scheduled the Jobs for loading data using DBMS SCHEDULER.
• Optimized/Tuned SQL/PLSQL by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes to improve database response time and performance for several applications.
• Debugging Procedures & Functions and improving the performance of application.

Environment: Oracle 11g, SQL, PL/SQL, SQL LOADER, Erwin and Unix Shell Scripts.

Confidential, Chicago, IL

PL/SQL Developer

Responsibilities:

• Involved in gathering requirements, analysis and system design.
• Responsible for designing schema using Erwin Data modeler and generate the DB scripts using the tool.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to main tables.
• Worked with DBA for getting trace files.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Worked on Table structures along with the Triggers, Indexes like Bitmap and Function based Indexes.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Proactive monitoring of jobs.
• Proactive follow-ups with other teams to resolve the issues faster.
• Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files.

Environment: Oracle 10g, PL/SQL, Unix shell scripts, TOAD, PL/SQL, SQL PLUS, SQL LOADER & Erwin

Confidential

PL/SQL Developer

Responsibilities:

• Development of Technical Specification from BRD.
• Data modelling using Rational Rose Tool. Maintenance/Customization of Data Model.
• Standards on Naming Columns, table column Changes, Generation of DML Scripts
• Implemented Clients Outstanding for Loans using PL/SQL Packages
• Design, implementation and maintenance of custom application.
• Create Oracle Packages to extract data from data warehouse.
• Set up and monitor Unicenter Autosys jobs for batch processes.
• Effectively communicate technical solutions to various team members.
• SQL tuning processes including tkprof, explain plan and autotrace.
• Create Unix shell scripts.
• Interface with multiple vendors internally and externally.
• Participation in collaborative design discussions, development process decisions & Performance improvement programs.
• Installation and administration of Development Database and QA Database (Oracle) Windows.

Environment: PL/SQL, Oracle 10G, Sql Developer, Unix Shell Scripts and Windows XP