SUMMARY

• 7+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Data Modelling (Logical and Physical).
• Development of client/server, multi tired applications using the Oracle Relational Database Management System (RDBMS), SQL and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux.
• Good experience of Performance Analysis and SQL query tuning while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, Explain Plan and Tk - prof.
• Experience in Gathering Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation and Post Implementation surveys. Highly skilled in Design, Development, Implementation, Testing of business applications, Unit and System testing on database.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Have an extensive knowledge on advanced PL/SQL concepts like Bulk collections, Multi Table insert, PL/SQL tables, Cursors, Nested tables, Varrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Proficient in Oracle11g PL/SQL back end applications development using Toad, SQL Plus, and PL/SQL Developer.
• Strong knowledge on various database concepts like Normalization and ER Diagrams.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Expertise inSoftware Development Life Cycle (SDLC).
• Good understanding of RDBMS,OracleDatabase architecture, designs and having performed DBA duties, such as Table Partitioning, Import/Export and data pump.
• Good understanding in the areas of Users, Roles, Privileges, Schema and Object management & Session monitoring.
• Expertise inData Mapping, Transformation and Loading data in a complex and high-volume environment.
• Expertise in Transaction Management like Commit, Rollback inOracleDatabase.
• Expert working Knowledge of UNIX Shell Scripting and Scheduling Cron jobs and tools like WINSCP, PUTTY, FTP/SFTP and CONNECT DIRECT.
• Expert in Query Optimization, troubleshooting, debugging, problem solving and Tuning for improving performance of the applications.
• Have experience in Relational and Dimensional Data modeling, Normalization, Demoralization, Data Architecture, Planning, Testing, Data Migration and Data Conversion.
• Experience in supporting the production system and handling day-to-day issues.
• Excellent communication skills, problem solving and logical methodology.
• Work well in the team environment, Self-motivated, quick learner, able to work well under tight deadlines and rapidly changing priorities.

TECHNICAL SKILLS

Domain Knowledge: PeopleSoft HRMS 8.4, Financial Accounting, General Ledger & Payroll

GUI: D2K (Forms 6i/9i/10g/11g, Reports 6i/9i/10g/11g)

Tools: Used: SQL * Plus, SQL* Loader, TOAD, SQL Developer

Other Tools: Erwin, ETL

Languages: SQL, PL/SQL, C,C++,JAVA,C#

Database: Oracle 8i, 9i, 10g, 11g

Operating Systems: Windows, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, New Orleans, LA

Sr. PL/SQL Developer

Responsibilities:

• Gathered the requirements from the specifications document and looked at whether the particular data object was tracked in impact or Medidata.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Created image tables for all the 14 data objects that used to store the data that was obtained from IMPACT and Medidata.
• Developed main cursors for each data object which were used to fetch data from Impact and Medidata.
• Developed packages that contains procedures and functions for all the data objects.
• Used Dynamic SQL to run the procedures for each data object.
• Developed complex SQL queries using various joins and developed various dynamic SQL (Sub queries and Join conditions, correlated sub queries).
• Used DBMS XDB package to access and manage Oracle XML DB Repository resources using PL/SQL.
• Triggers were developed to handle the Parent-Child relationship of data objects and also solved the issues that occurred during Insert, Updates or Deletes.
• Created Views required for the front end team to display the specific columns that were needed to be shown to the end user.
• Lead the team of 3 and conducted regular meetings for successful completion of the project.
• Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP).
• Worked on preparing the architecture document.
• Performed thorough Unit testing, System Testing and User Acceptance Testing in development environment for the result of error free and smooth migration process and provided quality work for functional users.

Environment: Oracle, SQL, PL/SQL, SQL Developer, TOAD, UNIX, InformaticaPower Center Reflection X, Visual Studio(TFS), Windows.

Confidential, NYC, NY

Sr. PL/SQL developer

Responsibilities:

• Gather Business rules from the end users that are to be incorporated into the system.
• Extensively worked on the analysis of Tables in both Legacy Data store and new data store.
• Extensively worked on the analysis of Columns in mapping tables for both Legacy Data store and new data store.
• Initialized utilization of Data Warehouse ETL software during conversion of data to Oracle DB.
• Developed the complete documentation of the project based on the analysis of tables and Columns.
• Created DDL scripts to create, alter, drop tables, views, synonyms and sequences.
• Worked on PL/SQL Tables, Records and Collections.
• Wrote PL/SQL Procedures, Functions, and Triggers for Insert, Update and Delete transactions and optimized for maximum performance.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• Utilized tools like PL/SQL Developer during development of the application.
• Developed SQL queries to fetch complex data from different tables in remote databases using database links.
• Used ETL process to identify the new or the changed data in order to make better decisions in the project.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Source data residing in Excel formats are exported verbatim to flat files and then accessed via Oracle external tables in order to load into the staging schema, at which point all source data can be efficiently transformed and migrated to the target schema.
• Extracted data from Flat files using SQL*LOADER.
• Developed Unix Shell Scripts for loading data into the database using SQL* Loader.
• Created partitions on the tables to improve the performance.
• Participated in application planning, design activities by interacting and collecting requirements from the end users.

Environment: Oracle 11g, SQL, PLSQL Developer, SQL Tuning, SQL*Loader, UNIX Shell Scripting, ETL

Confidential, NYC, NY

Oracle PL/SQL Developer

Responsibilities:

• Database developing using Oracle 10g and UNIX shell script.
• Involved in interacting with the end-user (client) to gather business requirements and modelling the business requirements.
• Created mapping document between database objects and website objects for both front-end and back-end team to use.
• Created database objects like tables, views, synonyms, indexes and sequences.
• Analysing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions, Views, Materialized View and Triggers.
• Coded complex SQL queries to retrieve data from the database depending on the need.
• Created Cursors and Ref cursors to retrieve data needed.
• Built and maintained sequences.
• Experience in developing various kinds of triggers and used sequences to generate values for surrogate keys in data warehouse tables.
• Wrote complex functions to output group ids with complex logic using pre-defined sequences.
• Developed other database objects such as indexes and views when needed.
• Coordinate with the front-end design team to provide them with the necessary stored procedures, packages and the necessary data.
• Provided daily support for multi-task development, and worked on DEV/QA testing and interacting job between DEV/ QA/ PROD environment. Work with QA team to debug/fix issues.
• Involved in Unit Testing Stored Procedures and Functions.
• Worked with front-end team to handle QA move & Prod move, create moving sheets to make sure FE and BE are in sync.
• Perform database tuning, make complex SQL statements simple and easy to read, and also make queries more efficient.
• Worked on PL/SQL Error/Exception handling.
• Wrote shell scripts to load data (SQLLDR), run spool jobs, retrieve data from database and create daily jobs to automatically updating tables and views.
• Created technical Documents including task processing document updating and test case preparing.

Environment: Oracle 10g, TOAD, Putty, PL/SQL, UNIX/Linux, SQL Loader, MS Communicator.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Write Technical Specifications based on business requirements to provide account level financial summary reports to the business customers
• Perform Data Mapping and develop ETL Specification documents.
• Develop ETLs using PL/SQL in Oracle 10g & 11g to extract, transform and load data from OLTP into Warehouse.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Created Cursors, Collections and DB Triggers.
• Documented different Stages of Data Transformation, procedures and Scripts.
• Utilized PL/SQL nested tables for conditional trafficking of data within ETL process.
• Filtering of data by developing reusable PL/SQL functions.
• Performance tuning using Oracle Hints and Result caching where appropriate.
• Utilized PL/SQL bulk collect feature to optimize the ETL performance.
• Developed ETL programs using informatica to implement the business requirements.
• Document application from a technical maintenance point of view and host a knowledge transfer session.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Maintain and Oracle PL/SQL batch process for claims based billing and reporting system.
• Debugging Production issues using Toad 9.7 debugger.
• Implemented various UNIX scripts to generate the data in CSV format.
• Worked on inline and correlated Sub queries based on business context.
• Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.
• Experience in operational DBA supporting OLAP and OLTP environment including implementation and design of data warehousing.
• Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tools like Erwin, MS Visio, Power Designer.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Plus, SQL Developer and SQL Navigator.
• Experience in Query optimization & Performance tuning using Execution Plan, Performance Monitor.
• Strong experience on working with Procedures for improving the load performance in various schemas across databases using appropriate HINTS.
• Extensively worked on database up gradation and data migration from other systems to oracle.
• Extensive Knowledge on, PERL Programming and scheduling jobs using CRONTAB and DBMS JOBS.
• Extensive Experience in Creating Repository, Source, Target Databases for Extraction, Transformation and Loading (ETL) using OWB and Informatics.
• Developed and maintainedOracle HTML proceduresand functions withPL/SQLcode integration
• Worked onJDeveloperfor development in Java, XML, SQL and PL/SQL, HTML, JavaScript, BPEL and PHP.
• Analyzed, designed and developed Oracle forms10g queries, layout,reporttriggers, parameterform, data models etc.
• Developed korn shell scripts to kick off back endPL/SQL, SQL, Pro*C programs.
• Worked onReportlayout design, Data models which used Placeholder, Summary and Formula Columns preparation of user manual and development of the program usingForms10g.

Environment: Oracle 10g/11g, SQL, PL/SQL, Toad 9.7, SQL Developer, CVS, UNIX Scripting, HP-UNIX, Windows XP, Oracle Database 11g, PL/SQL, Oracle Developer Suite 10g,, Tortoise SVN, PUTTY.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in logical data modelling, including developing and maintaining data model diagrams (E-R Diagrams), implementing physical designs, and facilitating data model requirements gathering
• Developed user defined functions, back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers based on requirements.
• Worked on creating tables and sequences for the experimental data load capture. Loaded the data into the tables.
• Created metadata validation lookup tables and pre populated them using SQL Loader generator application.
• Created integrity constraints and Database Triggers for the data validations.
• Worked on Pseudo columns (ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, and USER).
• Optimized queries and tuned using Explain Plan, Auto Trace utilities for performance.
• Worked on external hints during the sql optimization to fast up the sql process.
• Implemented various UNIX scripts to generate the data in flat file format. Created relevant staging tables to load, identify the business validation rules.
• Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.
• Worked closely with Project team(s), and reported to management on different statuses.

Environment: Oracle, SQL plus, SQL Developer, TOAD, UNIX, Quality Center, Windows.