PROFESSIONAL SUMMARY:

• About 7+ years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.
• Expertise in SQL and PL/SQL programming and strong Knowledge on oracle architecture and database design.
• Solid experience in vertical segment Automotive, Banking, Retail management system, Financial management system and Health Care.
• Good Knowledge in Relational Data Modeling.
• Expertise in using tools such as TOAD, SQL developer, PL/SQL developer.
• Strong knowledge of Oracle 9i/10g/11g, PL/SQL.
• Excellent Analytical, conceptual and root cause analysis and problem solving skills.
• Strong Experience in designing and developing oracle objects Tables, Views, Indexes PL/SQL Packages, Functions, Stored Procedures, and Triggers.
• Strong knowledge in Oracle Cursor management, Exception Handling, REF Cursors
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Collections, Nested Tables, VARRAYS, Records, Types, and Dynamic SQL and Analytical functions.
• Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database.
• Experience in PL/SQL collections, Bulk collections and Exception handling.
• Extensively worked with various SQL scripts for relational databases.
• Knowledge of working with the Oracle Application server for the Forms and Reports application in various projects.
• Extensively worked on PL/SQL features like Forms, Triggers, Data blocks, Report Layout, Parameter forms, Report Triggers.
• Experience in designing and developing various reports using Oracle Reports
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization techniques.
• Experience with database query optimization and performance tuning using Explain Plan, SQL - Trace, TK-Prof oracle utilities and creating relevant system and users documentation
• Strong working experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL)
• Expertise in understanding Slowly Changing Dimensions Type1, Type2 and Type3.
• Providing assistance in logical/physical data modeling using ERWIN.
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
• Experience in Database modeling and database object definitions using tools like Oracle Designer.
• Experienced in Unit testing and Integration Testing with excellent debugging skills.
• Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
• Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Great Team player with Strong interpersonal skills, communication skills and documentation skills

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i, TOAD, SQL Developer, SQL * Plus

Database tools: PL/SQL Developer, Forms10g/9i/6i, TOAD, Oracle Enterprise Manager

Operating systems: UNIX, Windows NT/2000/2003/XP/7

Languages: C, C++, JAVA, SQL, PL/SQL, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with application development teams for preparation of shell scripts.
• Participated in complete process of functionality testing of all AutoSys applications.
• Participated in scheduling development lifecycle stages such as requirements gathering, implementation.
• Responsible for problem identification and resolution of failed processes or jobs and assisted in troubleshooting issues with applications in AutoSys.
• Proactive in finding issues and seeking and implementing solutions.
• Used PL/SQL to create PACKAGES, FUNSTIONS, and PROCEDURES.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Designed Batch Processing system for applications using AutoSys. Developed standardized scripts for job implementation.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Writing SQL or PL/SQL to migrate existing data from production tables to the new db tables.
• Involved in Database Designing and Creation.
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
• Created ETL Procedures for around 600+ tables.
• Tested and corrected errors and refined changes to data base.
• Tuned performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.
• Used Bulk Collect feature to improve performances.
• Wrote Test case/data preparation, execution including verification of the test results.
• Loading data from flat files into Oracle 10g database using SQL*loader and UNIX script.
• Create User Schemas, TABLES, INDEXES, SEQUENCES, and VIEWS.
• Used Scrambled and Unscrambled functions to Encrypt and Decrypt the sensitive data.
• Worked with DBA to create the physical model and tables.
• Created Materialized Views on top of more than 600 tables.
• Built and maintained SQL Scripts, indexes, reports and queries for data analysis and extraction.
• Created CURSORS, Ref Cursors, Database Triggers.
• Verify, validate data using SQL queries.

Environment: Oracle 11g/10g, SQL, PLSQL, UNIX, AUTOSYS, SQL*LOADER

Confidential, Phoenix, AZ

Oracle PL/SQL Developer

Responsibilities:

• ER diagrams with Datamart exposure. Normalization Techniques for designing database with Relational technology.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Learned in detailed Oracle Architecture, Data Dictionary and DBMS Packages.
• Hands on experience in all stages of
• System development efforts, including requirement analysis, design, testing and implementation.
• Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tools like Erwin, MS Visio.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables.
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Analyzing the code written by different developers to understand the transformation applied on columns to document them.
• Gathering requirements for summary data sets for each stakeholder group. Includes elements, configurability; logic for trending reports, history tracking and other aggregations.
• Sorting logical data grouping for originations source data that to be loaded into analytics.

Environment: Oracle 11g/10g, SQL, PLSQL, TOAD, MICROSOFT VISIO

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Excess Equipment is a Web Application for all plants to Request Equipment’s.
• Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract the data from the database to flat files.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages according to the new business measures.
• Worked on PL/SQL tool TOAD to run SQL queries to validate the data.
• Modifying existing web application GUI as per the need from the look and feel point of view using HTML, Java script.
• Extensively used HTP and HTF package used to dynamically build webpage from PL/SQL.
• Developed stored packages with Oracle's Web Toolkit.
• Worked with front end application developers with their queries/stored procedures while building User-Interface for the project.
• Wrote complex SQL queries using Joins, Sub queries and Group functions.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Worked on package more than 15000 lines.
• Good experience in communicating with offshore team.
• Worked closely with end-users and team members to understand business requirements that drive the analysis.

Environment: Oracle 11g/10g, SQL, PLSQL, UNIX, TOAD

Confidential

Oracle PL SQL Developer

Responsibilities:

• Worked in the Dynamic Pricing Portal team, to support the business team.
• Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract the data from the database to flat files.
• Developed stored procedures and triggers to facilitate consistent data entry into database.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Utilized SQL*Loader to load flat files database tables.
• Initialized utilization of Data Warehouse ETL software during conversion of data to Oracle DB.
• Used UNIX Shell Scripts to automate backend jobs.
• Executing and maintaining the data warehouse extract transform load (ETL) process.
• Gathered statistics and analyzed tables and Indexes for performance tuning.
• Used performance tuning utilities like EXPLAIN PLAN, SQL Trace and DBMS PROFILER to improve the performance by reducing the run time of queries on the database.
• Based on the data loaded in the target database (oracle) various business reports are developed.
• For the reporting purpose extensively used SQL Scripts.
• Wrote complex SQL queries using Joins, Sub queries and Group functions.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business measures.
• Worked as an application DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Used Cursors, Native Dynamic SQL and Bulk Collections to implement the Bulk Load.
• Used Materialized views in order to improve the performance.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Trouble shooting performance issues within packages using DBMS OUTPUT
• Coordinating with the business users for System Test and User Acceptance Test.
• Developed scripts for validating the UAT deployment for the schema objects.
• Responsible for Documentation of all the project developments and methodologies followed for the defect-fix, as per the standards defined and the system requirements.
• Resolving problems by reviewing and analyzing software documentation and production outputs to identify causes - troubleshooting
• Handling every week’s production deployment.

Environment: Oracle 11g, SQL, PLSQL, UNIX (Putty).

Confidential

Web Developer

Responsibilities:

• Responsible for Monitoring and Managing site development and regular web site maintenance.
• Redesigned and improvised the user interface in searching, finding the library material content using Ajax, JQuery and JavaScript, CSS.
• Played a major role in migrating the library website to Word Press.
• Designed and developed a web application for managing and tracking IT resources.
• Extensively worked on Java, JSP, JSTL, PHP, SQL, HTML, and CSS.
• Worked closely with designer and converted Photoshop images into web pages consistent withrganizational standards.

Environment: Java, JSP, JSTL, PHP, SQL, HTML, JavaScript, Ajax, JQuery, CSS, Word Press, Apache TomcatMySql.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed various PL/SQL stored procedures and functions
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS PROFILER, DBMS JOB, DBMS MVIEW and UTL FILE.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Utilized SQL*Loader to load flat files database tables.
• Involved in Writing, debugging and optimizing PL/SQL code.
• Involved in migrating database from Oracle 9i to 10g database.
• Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database
• Involved in the ETL process of developing new tables from the existing views and materialized views.
• Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS, Bulk collections and Exception handling.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Worked in SQL, PL/SQL development and database support as well as maintenance.
• Developed and implemented various migration scripts for various schema objects migration.
• Worked on complex queries PL/SQL packages, functions, stored procedures, triggers, views
• Performing Unit, Integration and System testing, and setting up UAT for the project modules.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Worked closely with end-users and team members to understand business requirements that drive the analysis.
• Participated in Peercode reviews and verifying coding standards.
• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.

Environment: Oracle 9i, 10g, SQL, PLSQL, SQL*Loader, UNIX, TOAD.

Confidential

PL/SQL Developer

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Developed the SQL*Loader script, and most of PL/SQL stored procedures, Triggers, and views to handle the Online and Batch processes.
• Created database Triggers for the security purposes.
• Used Oracle snapshots for replication between various sub branches.
• Loaded the data into database using the SQL*Loader from various sources.
• Creating SQL, Object Views, and PL/SQL database objects. Developed the stored procedures for data transformation purposes.
• Tuned the SQL Queries with the output of Oracle Tools like Explain Plan, TKPROF.
• Fixing bugs according to the software change requirement.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Developed test plan documents for all back end database modules.
• Responsible for unit testing, and documentation of the interfaces.

Environment: Oracle database 8i/9i, Java, Servlets, PL/SQL, SQL Plus, SQL*LOADER, Windows 2000 Professional, and UNIX.