SUMMARY

• Over 10 years of experience as Database developer, designer and architect. Experienced in Reporting Tools, Web based applications, Product Development and Data migration projects.
• Involved in all phases of the SDLC from Analysis, Design, Development, Testing, Implementation and Maintenance in Banking, Investment Banking and Data Migration with timely delivery against aggressive deadlines.
• Expertise in client - server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL*PLUS, TOAD and SQL*LOADER, Sybase ASE, Sybase IQ, Power Builder.
• Effectively made use ofIndexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Dynamic SQL, Joins and Exception Handling.
• Experience with Data flow diagrams, Data dictionary, Database normalization techniques, Entity relation modeling and design techniques.
• Developed complex database objects like Stored Procedures, Functions, Triggers using SQL and PL/SQL.
• Experience with Data Warehouse Techniques (Star and Snow flake schemas. Slowly Changing Dimensions (type1 and type2, type3), Fact and Dimension Tables).
• Good knowledge of Hadoop architecture and its components like HDFS, Job Tracker, Task Tracker, Name Node and Data Node.
• Experience in query optimization, Performance tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of Global Temporary Tables and Table Partitioning.
• Good knowledge of key oracle performance related features such as Query Optimizer, Execution plans and Indexes.
• Experience in UNIX Shell Scripting.

TECHNICAL SKILLS

Software, Tools: Oracle Designer, Erwin 3.5.2, Toad, PL/SQL Developer

Languages: Data Pump, SQL Navigator, RMAN, Oracle Enterprise Manager, SQL*Loader, UtPLSQL, Cron, UNIX Shell scripting, System Admin utilities

Databases: Oracle8i/9i/10g/11g/12c, MySQL, Sybase ASE, Sybase IQ, SQL Server

Hardware &SUN Servers: Storage 6130/6140, Solaris 10/9, Linux, AIX, SCO-UNIX

Operating Systems: MS Windows

Other: Performance Tuning, SVN, CVS, MS Visual Source Safe 6.0Remedy Force, Share Point, Large Database solutions, Power Builder

PROFESSIONAL EXPERIENCE

Confidential - New York, NY

Sr. Oracle Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and necessary insight into the data.
• Worked on SQL*Loaded to load data from flat files obtained from various facilities every day
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Created PL/SQL Stored Procedures, Functions and Packages for moving the data from staging area to data mart.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Created scripts to create new Tables, Views, and Queries for new enhancement in the application using TOAD.
• 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, Procedures using oracle tools like TOAD, Pl/SQL Developer and SQL*PLUS
• Created Records, Tables, and Collections for improving Query performance.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• 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
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Performed SQL and PL/SQL Tuning and Application Tuning using various tools like EXPLAIN PLAN, SQL*TRACE
• 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
• Partitioned the fact tables and Materialized Views to enhance the performance
• Extensively used the advanced features of PL/SQL like Records, Tables, and Object Types.

Confidential - New York, NY

Sr. Oracle Developer

Responsibilities:

• Developed PL/SQL procedures, Triggers, Functions, Indexes and Collections to implement business logic using SQL Navigator
• Developed UNIX Shell Scripts to automate repetitive Data Base Processes.
• Generated server side PL/SQL Scripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting using parallel Queries
• Worked on Trouble Shooting defects in timely manner
• Involved in creating UNIX Shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in Table Re-designing with implementation of Partitions Table and Partition Indexes to make Database faster and easier to maintain
• Involved in ETL code using PL/SQL in order to meet requirements for Extract, Transformation, Cleansing and loading of data from source to target Data Structures.
• Involved in 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.
• Experience in Database Application Development, Query Optimization, Performance Tuning and implementation experience in complete SDLC
• Used SQL Server SSIS TOOL to build high performance data integration solutions including Extraction, Transformation and Load Packages for Data Warehousing.
• 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, DBMS SQL and PL/SQL Collections and used BULK Binding involved in writing database procedures, Functions and packages for Front End Module.
• Received ‘Pat on the Back’ award for the successful optimization in various stored procedures.

Confidential - Rocky Hill, CT

Sr. Oracle Developer

Responsibilities:

• Created and modified SQL*PLUS, PL/SQL and SQL*Loader scripts for data conversions.
• Creating Indexes on tables to improve the performance by eliminating the Full Table Scans and Views for hiding the actual tables and to eliminate the complexity of the large queries
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Designed logical and physical data models
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Upgraded Oracle 9i to 10g software in different Environments for latest features and also tested databases.
• Developed and modified Triggers, Packages, Functions and Stored Procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Designed Data Modeling, Design specifications and to analyze Dependencies
• Fine-tuned procedures/SQL Queries for maximum efficiency in various database using Oracle Hints for Rule based optimization
• Responsible for overall production support issues for modules such as Appraisals, Closings, Property Reports, Info Products, Titles and Recordings of the Order Entry.

Confidential

Oracle Developer

Responsibilities:

• Responsible for overall production support issues, overall deliverables and coordination from offshore
• Create functional and technical design specifications for enhancements and bug fixes
• Develop stored procedures, packages, triggers and other oracle database logic
• Performing code review for the code changes from offshore
• Performing Unit Testing, Integration Testing for the new bug fixes and Enhancements on Development & Test Environments
• Providing estimates for completion times
• Was actively involved in requirement analysis, Estimation and Project Plan.

Confidential

Oracle Developer

Responsibilities:

• Gathering high-level requirements from Client. Analyzing and translating those requirements into written plans.
• Translate high-level business requirements into low-level tasks and then design Oracle PL/SQL code to accomplish these objectives
• Create Functional and Technical Design Specifications for Development efforts.
• Develop complex Stored Procedures, Functions, Packages, Triggers and oracle Database Logic
• Design, analyze and develop efficient table and index design, monitor and tune performance and execution plans to improve performance
• Designing components and performing complex coding, De-bugging and testing within a Data-Management system
• Worked with development team to improve Oracle Application Performance and resolve Real-Time problems as they occur
• Prepare requirements specifications, design documents and Unit Test Plans.
• Performing Design Review, Code Review, Unit Testing, Integration Testing and additional care for new modules and enhancements in production.
• Providing estimates for completion times and required resources for assigned projects and program initiatives.
• Providing mentoring to team members on Oracle PL/SQL
• Participating in user group meetings to understand new enhancements and existing problem areas.
• Resolving user issues/tickets and consistently maintained SLA

Confidential

Oracle Developer

Responsibilities:

• Performed Database Administration of all database objects including Tables, Clusters, Indexes, Views, Procedures
• Implemented 11g and upgraded the existing database from Oracle 91 to Oracle 11g.
• Involved in Logical & Physical Database Layout Design
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Performance tuning of Oracle Databases and User applications
• Provided user training and production support
• Improved the performance of the application by re-writing the SQL Queries
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub-queries and database links.