SUMMARY

• Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

RDBMS: SQL Server 2000/2005/2008/2008 R2/2012, MS Access

Languages: C, VB.NET, C#, VB, ASP.NET, Java, T-SQL, PL/SQL, PHP, HTML, XML

ETL Tools: DTS, SQL Server Integration Services (SSIS).

Tools: SQL Profiler, SQL Query Analyzer, SQL Server Management Studio, SQL Server data tools (SSDT).

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports

Operating Systems: Windows NT/2000/XP Pro/Vista, Windows Server 2000/2003/2008 , Linux, Unix

Case Tools: MSOffice 2010/2007/2003 , MSExcel 2010/2007/2003 , MSOutlook 2010/2007/2003 , MS Vision, SharePoint Server.

Database Tools: SQL Server Management Studio, Query Analyzer, SQL Profiler, Data Transformation Services(DTS), ETL, Query Builder, BCP, Bulk Insert, SSIS,SSAS,SSRS, BIDS,VSS, Crystal Reports, ERWIN.

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

PL/SQL Developer

Responsibilities:

• Developed user defined functions based on requirements. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages.
• Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing.
• Created relevant staging tables to load the CSV files, identified the business validation rules.
• Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Experience in creating the tables and sequences for the experimental data load capture.
• Loaded the data into the tables using TOAD and SQL*Plus. Created metadata validation lookup tables and pre populated them using SQL Loader generator application.
• Designed competent PL/SQL programs using PL/SQL collections, Records types, and Object types.
• Developed and automated the interfaces by using the PL/SQL. Developed user defined stages and common templates.
• Tuned several Oracle SQL statements using Explain plan, Auto Trace utilities.
• Involved in implementing table partitions using Range, Hash, Composite techniques.
• Worked on external hints during the SQL optimization to fast up the SQL process.
• Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL.
• Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.
• Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.

Environment: Oracle 10g/11g, PL/SQL, SQL Plus, Informatica ETL, SQL Loader, SQL developer, Toad.

Confidential, New Haven CT

PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for gathering, business analysis, testing, and implementation.
• Involved in logical modeling and physical modeling of database application and Developed Stored Procedures, Functions, Packages using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from flat files.
• Developed SQL scripts, cursors, tables, views, materialized views as per the business requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, Tk-prof and Auto trace.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Part of a development team for creation and maintenance of custom apps/reports.
• Evaluating new techniques for enhanced functionality.
• Developed Perl scripts for data sources for data migration.
• Experienced with bulk collections and for all operations on tables to improve the performance of manipulation language statements.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Developed UNIX Shell scripts to automate table creation, execute procedures using dynamic SQL statements.
• Worked on Data schema modeling and designed Database Schema using ERWIN tools and implemented Normalization on relational modeling.
• Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.
• Extensively used Database Query tuning and performance tuning of reports.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g, Perl, UNIX, Windows XP/2000.owb 10g

Confidential, FL

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.
• 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.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• 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.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting using Parallel Queries, Javastored procedure, HTPPackage and WEB.SHOW DOCUMENT. Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Involved in creating UNIXshellScripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle.
• Used SQL Server SSIStool to build high performance data integration solutions including extraction, transformation and load packages for datawarehousing. Extracted data from the XML file and loaded it into the database.
• Designed and developed Oracle forms & reports generating up to 60 reports.
• Performed modifications on existing form as per change request and maintained it.
• Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target datastructures.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIXShellscripts to automate repetitive databaseprocesses.

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting.