SUMMARY

• Over 7 years of IT experience in various application phases of Software Development Life Cycle using Oracle 11g/10g/9i/8i/8.x/7.3, SQL, PL/SQL, SQL*Loader, SQL server 2008/2012.
• Involved in all phases of Software Development Life Cycle (SDLC) from analysis, gathering requirements, design, development, testing, implementing, and support using Oracle technologies.
• Good understanding of Data modeling concepts such as Design of the Dataflow, ER Diagrams, Use Cases, Normalization and De - normalization of Tables.
• Experience in SQL, PL/SQL, Tables, Table Partitions, Database links, Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes.
• Knowledge of Autonomous Transactions, Materialized Views, Bulk Collects and Collections.
• Excellent in deployment of Application Servers like IBM Web Sphere, Web Logic, JBoss, Apache Tomcat.
• Good knowledge of soap & restful web services.
• Expertise in Documenting user requirements, low level technical designs, implementations and user guides using Agile Scrum Methodology.
• Analyzing & gathering table statistics for Query Optimization.
• Experience in Performance Tuning using SQLTRACE, EXPLAIN PLAN & TKPROF with the help of Hints, Partitioning, Bulking techniques and Indexes.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Utilized different database packages like DBMS JOB, written inline views to remove complexity of joins, used collection objects like nested tables and index by tables
• Excellent in writing UNIX, LINUX. Worked with scripting languages like HTML and XML.
• Hands on implementation experience in industries like Banking, Insurance, Telecommunications and Inventory Systems.
• Worked with applications like Manufacturing Process, Banking Information Systems, Health Care Management Information Systems, Telecommunication system and Financial Accounting.
• Oracle External Tables, Import/Export Utilities & SQL*Loader.
• Experience in Migrating Data to Oracle database.
• Good understanding of Oracle Architecture.
• Experience using TOAD, SQL Developer, PL/SQL developer, SQL Navigator under UNIX and Windows NT/2000/XP/Vista operating systems.
• Excellent Database administration skills including user authorizations, Database creation, Tables, indexes and clusters creation.
• Experience in OLTP System Study, Analysis and E-R modeling, understanding in developing Database Schemas
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

OPERATING SYSTEMS: WINDOWS XP/Vista/Windows 7, LINUX AS3.0 & 4.0.,Unix

DATABASE: ORACLE 11g/10g/9i, MS Access, SQL Server 2008/2012 SP2.

GUI's: Oracle Developer suite11g/10g/9i.

TOOLS: TOAD 10.6, SQL Developer, PL/SQL developer, SQL*PLUS, SQL*LOADER, SQL Server Management Studio 2008/2012 SP2, Oracle Forms 6i/9i/10g, SQL Navigator

Application Servers: IBM Websphere, weblogic, Pramati, JBOS servers

Web services: Soap, Restful

SCRIPTING: UNIX Shell Scripting, XML, HTML

Languages: C, C++, Java

Web Technologies: XML, HTML, CSS.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Database Developer

Responsibilities:

• Analyze business requirements/processes and system integration points to determine appropriate technology solutions.
• Developed complex procedures and functions, views, triggers and batch processes in PLSQL (Oracle 9i, 10g).
• Implemented processes using object types, table types (Collections), GTT tables, DB Links.
• SQL, PLSQL tuning, query optimization.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Partitioned large Tables using partition techniques.
• Developed complex reports and alerts.
• Involved in performance tuning and troubleshooting issues using Sql Profiler & Sql Trace.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Used Common Table Expressions in Sql Server & Start With…Connect BY PRIOR in Oracle to retrieve hierarchical data from tables.
• Prepared weekly status reports to report ongoing activity to higher management.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Written inline views to remove complexity of joins, used collection objects like nested tables and index by tables.
• Partitioned the fact tables and materialized views to enhance the performance.

Environment: Oracle 11g, SQL Developer 3.2, SQL Server 2008/2012 SP2, MS-Office, IBM WebSphere server

Confidential, NY

Sr. Oracle Developer

Responsibilities:

• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Worked with SQL*Loader and External Tables to load weekly flat files into staging tables.
• Developed procedures to move data from staging tables to production tables.
• Created B-Tree and Bitmap Indexes and tuned SQL queries for better performance of database.
• Created PL/SQL packages, procedures, functions to apply the complex business logic rules
• Analyzed the performance of SQL queries using Explain plan and SQL TRACE, and increased the query performance by creating proper indexes on tables.
• Created data for Reports using procedures and complex Queries.
• Exclusively worked on UNIX environment and rewrote complex UNIX shell scripts as per the requirement.
• Ran batch jobs for loading database tables from Flat Files using SQL*Loader and also used DBMS SCHEDULER to schedule PL/SQL stored procedures.
• Documented design specifications and architecture using Microsoft Visio.

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, WebLogic servers, PL/SQL Developer 9.0.3, MS-Office

Confidential, Chicago, IL

Oracle PL/SQL Developer

Responsibilities:

• Involved in design, development, testing and implementation of the application.
• Involved in writing Queries, Stored Procedures, functions and triggers to implement the business requirements.
• Identified all the impacted scripts and reports and modified accordingly.
• Performed unit testing on modified scripts.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Developed materialized views for data replication in distributed environments.
• Responsible for the production support and bug fixing.
• Involved in Performance tuningofSQL queriesas data warehouse consists of many tables with millions of rows of data.
• Conducted training sessions to end-users.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Environment: Oracle 10g, SQL*Plus, SQL*Loader, PL/SQL Developer, JBOSS, UNIX

Confidential, FL

Oracle Developer

Responsibilities:

• Understanding the business requirements, writing functional specs, test specs and plans.
• Implemented PL/SQL advanced topics like System variables, Ref Cursors, Dynamic SQL, Collections, UTL FILE to read and write the files.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Developed stored procedures, packages and functions for workflow validation and verification.
• Document the whole process flow: PL/SQL packages, log files, locations, descriptions, log tables, possible error messages and process codes.
• Prepared procedures to update the internal structures to reflect the newly loaded data.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and maintained logs for the results.
• Created error log table to capture the error messages, session load time.
• Extensively involved in tuning the queries for faster and better performance of the SQL queries Optimized critical queries to eliminate Full Table scans, reduce Disk I/O and Sorts.
• Worked with Partition tables and indexes to improve the performance of data loading and query processing.
• Responsible for production support and bug fixing.

Environment: Oracle 9i/10g, Soap WebService, SQL*PLUS, PL/SQL, SQL*Loader, UNIX, Windows XP, SQL Developer 1.2, Toad 8.6.1., Weblogic

Confidential

TSQL Developer

Responsibilities:

• Involved in various SDLC Life cycle phases like development, deployment, testing, documentation, implementation & maintenance of application software.
• Understand the existing Stored Procedures. Modify and develop the complex Stored Procedures to in corporate the business rules.
• Make changes to the table schema, impact analysis of the schema changes, retrieve the parent-child relations in the functions using Common Table Expressions.
• As this is an OLAP database, I always used to remember the approximate number of rows that will be populated in each of the base tables when the OLAP process runs once in every week and just seeing the count in these tables, I was able to nail down the root causes of many issues.
• I was awarded shining star award for my hard work and excellence in this project.
• I was responsible for database tables design and developed the complete functionality using procedures and functions.
• Configuring the sql jobs and batch jobs
• Prepare the Install and Rollback builds for deployment to SIT, UAT and Production environments. Used sqlcmd command to deploy all the database files.

Environment: SQL server 2008/2012, Pramati Server, TSQL, PL/SQL, Windows XP, SQL server Management Studio, Websphere