SUMMARY

• Over 8+ years of experience in Database development using Oracle, SQL, PL/SQL.
• Substantial development experience in creating Procedures, Packages, Functions, Triggers views, Cursors, PL/SQL Collections andoptimizing query performance and other database objects using SQL, PL/SQL.
• Experienced in backend database development using tools SQL*PLUS,SQL* Loader, Oracle Designer, Oracle TOAD with good understanding of RDBMS and Normalization Techniques.
• Experienced in environments requiring direct customer interaction during specifications, design, and development and product implementation phases.
• Experience in developing forms and generating reports.
• Extensively worked with various SQL scripts for relational databases.
• Proficient in Application Performance Tuning and Query Optimization.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Strong knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
• Enforcing data integrity using integrity constraints and database triggers.
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
• Developed (Extraction, Transformation and Loading) Using Pre - Stage, Stage, Pre-Target and Target tables.
• Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and load testing. Seamlessly migrated the Code from Development to Testing, UAT and Production.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization techniques.
• Experienced in requirement analysis, coding and testing various modules in a software development life cycle.
• Excellent interpersonal skills, team player and ability to work well with all levels of an organization with effective presentation, verbal and written communication skills.
• Ability to utilize new tools and technologies in a changing environment.
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i, SQL Server, MySQL, Teradata 12.0, MS-Access, db2

Languages: MDM, SQL,AIX, PL/SQL, UNIX Shell scripting, Perl, C, PHP, HTML, Java

Web technologies: XML, HTML, DHTML, Java script

Tools: Oracle Enterprise Manager, TOAD, SQL*Plus, SQL* Loader, SQL Developer, PL/SQL Developer, Oracle reports and forms 6i/9i/10g, OLAP, OLTP, Discoverer 4i/9i/11g, Erwin, JIRA, Visio, Control-M, Autosys, Putty, Winscp, CVS, ARCH and SVN

Operating Systems: Windows, UNIX, Red Hat Linux 7.0, Sun Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

PL/SQL Developer

Responsibilities:

• Has partitioned various domains in the database to suit the needs and also to make the system faster.
• Performance tuning was extensively needed in these projects and played a major part in it.
• Worked intensively on PL/SQL Tables, Procedures, Records, and Used Dynamic SQL and triggers.
• Created the data model for the given schema.
• Wrote Cleanup procedures to clean up the data that is too old.
• Have worked on tasks like monitoring the number of records received, calculating the threshold of the counts and sending email from Oracle when the threshold is not met.
• Analyzed the record count for a given domain, calculated the mean, standard deviation, the upper and lower limits for the same and illustrated them in excel charts.
• Also worked on tasks like file frequency, where an email from Oracle has to be sent when there is any delay in receiving the file from dealer and also check the status of the file.
• Was part of Job scheduling for Snapshot tasks like inserting history data into history tables when the original tables are overloaded and the data needs to be moved.
• In order to overcome performance bottlenecks, implemented alternate approaches like range partitioning of tables, use of various methods like global temporary tables etc.
• Provided alternative approaches when faced with performance bottlenecks. Approaches like range partitioning, global temporary tables.
• Supported file loading process and solved the errors involved.
• Wrote extensive Exception handling procedures to handle exceptions.
• Played an important role in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• In order to increase the performance, partition table with partition index has been introduced.
• Performance tuning and query optimization were extensively needed in these projects and worked on the same.
• Have worked on testing the database after the patch (Gathering table stats, refresh table stats, recreating the indexes, etc).
• Worked on indexes, rebuilding indexes online, invisible indexes, parallel hint.
• Dealt with various production issues in an efficient manner.
• Made use of cursors in procedures to generate high performance queries and PL/SQL code.
• Scheduled different jobs using job.submit and also using DBMS Scheduler.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Analyzed software specifications by interacting with business analysts and developers.
• Created Materialized views and Materialized view logs.

Environment: Oracle 11g, Oracle Forms 10g, Reports10g, PL/SQL, SQL*Plus 10.1, SQL*Loader, Toad 8.6 & 9.1, UNIX, Windows.

Confidential, Austin TX

Oracle Developer

Responsibilities:

• Generated SQL and PL/SQL scripts to install building database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms with oracle 10gdatabase.
• Created complex functions, stored procedures and packages by using PL/SQL.
• Participated in Designing databases (schemas) to ensure that the relationship between data is guided bytightly bound Key constraints.
• Responsible working with user groups, analyzing reported problems, performing root cause analysis andpresenting alternatives to correct the problem.
• Developed back end interfaces using PL/SQL packages, stored procedures, functions, Object Types, Pipelined functions, Oracle queues and used Collections, Bulk Collects to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Developed Batch Reports using SQR and enhanced SQR reports for production.
• Involved in Dimensional modeling and developed the star and snowflake schemas.
• Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms 10g.
• Converted oracle form application 6i to 10g using migration assistant.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues with effective defect management.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Developed SQR’s for loading data from feed file to staging tables.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN etc.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.

Environment: s: Oracle 10g/11g, Oracle forms/reports 10g, SQL, PL/SQL, SQL*Plus, Toad, MSSQL Server, Windows NT, HTML, XML.

Confidential, Plano, TX

PL/SQL Developer

Responsibilities:

• Has designed a Data load framework for dynamically adding Tables replicating from one system to another.
• Created PL/SQL Tables, Collections, Records, and Used Dynamic SQL and triggers.
• All the business requirements were met by creating database objects like tables, synonyms, views, sequences, indexes etc.
• In order to increase the performance partition table with partition index has been introduced.
• Made use of cursors, collections, bulk binds etc., to generate high performance queries and PL/SQL code.
• Analyzed software specifications by interacting with business analysts and developers.
• In order to overcome performance bottlenecks, implemented alternate approaches like range partitioning of tables, use of various methods like global temporary tables etc.
• Analyzed, designed and developed Oracle forms.
• Was part of Reverse Engineering framework for Data Stage Jobs
• Played an important role in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Have worked on Oracle Express, Discoverer & Reports.
• Developed Oracle Forms 10g database triggers, cursors, stored procedure.
• Made the Business Requirement Document by collecting the requirements and interacting with the business users.
• Worked on XML parsing, XML packages for loading of large amount of data.
• Was part of the building team for the Erwin physical data model, laying out ER-Diagrams, defined table structures and involved in high level database design.
• Number of complex PL/SQL procedures, functions and packages have been developed for the specifications of the application
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexed to gain performance.
• In process of developing a data purging framework.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Provided basic understanding of the project to the new members of the team

Environment: Oracle 10g, Oracle 11g, Oracle Forms 6i, Reports 6i, PL/SQL, SQL*Plus 10.1, SQL*Loader, Erwin 4.1.4, Toad 8.6 & 9.1, UNIX, Solaris, Windows.

Confidential

Oracle Developer

Responsibilities:

• Developed Stored Procedures, Function and Packages for the Financial System.
• Setup, tested and implemented new descriptive flex fields in Oracle Financials.
• Used database triggers and PL/SQL for development of system.
• Extensively used PL/SQL to write Cursors for acquiring information to be used in calculations written in stored procedures.
• Developed interfaces using PL/SQL packages, stored procedures, functions, Object Types, Cursors, Pipelined functions, Oracle queues and used Collections and Bulk Collects.
• Worked extensively on tuning of SQL and PL/SQL code using various tools like explain plan, TKPROF, SQL tuning advisor and SQL trace to enhance the performance.
• Created Korn Shell scripts which act as a wrapper for various tasks like - for executing the SQL*Loadercommand lines, for refreshing the materialized views and for updating the Fact and the Dimension tables.
• Worked on various projects involving gap and map analysis, design and customization as per the businessrules and worked on custom applications development involving.
• Load the data into Oracle 9i, Oracle High -Performance, scalable database. Change of Accounts, Currencies, defining calendars, setup books and Multiorg setup.
• Design, development, testing and implementation of a custom billing System and order entry system.
• Implemented using Oracle 9i and Forms 6i.
• Developed forms to view payments, accept payments, view financial transactions, maintain and view cashassignments, view refunds, credit accounts, and transfer debit balances.
• Involved in Tuning Database & Application performance using Explain Plan, TKprof, resolving lock contentions, identifying & killing sessions.
• Worked with java developers to repair and enhance current base ofPL/SQL packagesto fix production issues and build new functionality and improve processing time throughcode optimizations and indexes.

Environment: s: Oracle 10g, SQL, PL/SQL, UNIX,SQL* Plus, Reports 6i, Forms 6i/4.5, SQL* LOADER, TOAD, Discoverer 6i, Apex 4.2.

Confidential

Master Data Management Specialist

Responsibilities:

• Analyzed and documented all client requirements and business processes.
• Implemented master functionality and analysis for existing business.
• Working on OLAP and OLTP.
• Maintained detailed documentation of process flow diagrams and operational support.
• Formulated standard operating processes and resolved sales field inquiries.
• Prepared and updated presentations for Sales IT departments.
• Reviewed existing requests from sales fields and updated ITEM database records.
• Evaluated security pricing data for quality control purpose.
• Developed MDM strategies and solutions utilizing SQL server MDS tools.