SUMMARY

• Extensive experience in analysis, design, development, testing and implementation as Oracle PL/SQL and Forms/Reports Developer.
• Worked on client - server application development using Oracle 11g, 10g, 9i, 8i, PL/SQL.
• Expertise in Writing SQL Queries and Optimizing SQL Queries.
• Excellent understanding of the Oracle Architecture
• Extensive experience in building Client Server Applications using Oracle, PL/SQL, Stored Procedures, Packages and Database Triggers working with partitions, creating, modifying and sizing database objects.
• Excellent experience in installation and configuration of Oracle 8i, 9i, 10g and 11g in UNIX/LINUX and Windows environment
• Used various levels of triggers and procedures to validate the data at each level.
• Experience in UNIX administration, Shell scripts, Crontab.
• Experienced working on data modeling, requirement collection and business process mapping.
• Designed ETL process using Kettle Informatica Tool (Pentaho) to load from Sources to Targets through data transformation.
• Experience in developers (off-shore) and advising technical groups on reporting best practices.
• Proficient in legacy data conversions and interface development using SQL, PL/SQL, UNIX, TOAD, SQL Developer, Pl/Sql Developer and SQL*Loader.
• Conversion of data into XML using SQL Prompt as per client’s requirement.
• Designed ETL process using Informatica Tool to load from Sources to Targets through data transformation.
• Performance tuning by resolving users issues and problems, monitoring production database by using SQL*Plus and performed refinement of the database design leading to significant improvement in system response time and efficiency using EXPLAIN PLAN and TKPROF.
• Deep rooted concepts in Data Extraction, Transformation and Loading from databases, flat files and XML files.
• Experienced in DBA concepts like Creating Indexes, Tables and database physical extensively used Erwin for data modeling and Dimensional Data Modeling by ERWIN.
• Created and managed database object like tables, views, sequences, synonym, index, trigger, user, roles, DB link and Materialize view (M-view).
• Experience in full Software Development Life Cycle (SDLC) i.e. requirements analysis, detailed design, development, unit testing and integration.
• Good team player
• Highly motivated & conceptually strong individual with outstanding oral and excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Unix-shell scripting.

Database Tools: Oracle SQL*Plus, SQL*Loader, SQL Navigator, Toad, SQL Developer, Pl/Sql Developer

Data Modeling: Erwin, MS Visio.

RDBMS Servers: Oracle 11g/10g/9i/8i, MS Access, MS SQL Server 2000

GUI Tools: Oracle Forms 3.0, 4.5, 6i, Oracle Reports 6i, MS Power BI

ETL Tools: Informatica, Kettle Job (Pentaho)

Version/Migration Tool: PVCS VM, JIRA

Operating Systems: UNIX (Solaris 8/2.x, Red Hat Linux 7.x/6.x), Windows NT.

PROFESSIONAL EXPERIENCE

Oracle Developer / Analyst

Confidential

Responsibilities:

• Involved in creating constraints on various tables to load the data from different sources to target.
• Participated in change and code reviews to understand the testing needs of the change components.
• Working on troubleshooting defects, Query optimization in timely manner.
• Involved in creating UNIX shell Scripting.
• Working on troubleshooting defects, Query optimization in timely manner.
• Create Cron job for schedule the tasks
• Developed different adhoc queries as per client's needs.
• Supports Dev and QA team
• Created and managed database object like tables, views, sequences, synonym, index, trigger, user, roles and Materialize view (M-view).
• Created and deployed Shell and SQL Scripts
• Pull the data from flat files into Tables as per client’s need
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages.

Environment: SQL Developer, Oracle 10g/11g, PL/SQL, SQL*LOADER, Java, PVCS VM, SQL PLUS, UNIX shell scripting, ESPx

Oracle Developer / Data Analyst

Confidential, Houston, TX

Responsibilities:

• Created and managed database object like tables, views, sequences, synonym, index, trigger, user, roles, Materialize view (M-view).
• Involved in creating UNIX shell Scripting.
• Working on troubleshooting defects, Query optimization in timely manner.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Create crontab for scheduling the upload the data from various source such as flat, excel files
• Involved in creating constraints on various tables to load the data from different sources to target.
• Developed different adhoc queries as per client's needs.
• Convert the data into flat file layout as per customer needs.
• Developed triggers, Indexes, PL/SQL packages, procedures, functions, using SQL Developer, Pl/Sql Developer Tools. Generated server side PL/SQL scripts for data manipulation and validation of data for remote instances.

Environment: SQL Developer, Oracle 10g/11g, PL/SQL, SQL*LOADER, MS Power BI, SQL Server, PVCS VM, SQL PLUS, Java. UNIX shell scripting

Oracle Developer / Data Analyst

Confidential, Houston, TX

Responsibilities:

• Developed various queries as per client's needs.
• Created and managed database object like tables, views, sequences, synonym, index, trigger, user, roles, DB link and Materialize view (M-view).
• Working on troubleshooting defects, Query optimization in timely manner.
• Creates email alerts to perform jobs in timely manners using scheduler tasks and cron jobs
• Developed triggers, Indexes, PL/SQL packages, procedures, functions, using SQL Developer, Pl/Sql Developer Tools. Generated server side PL/SQL scripts for data manipulation and validation of data for remote instances.
• Involved in creating UNIX shell Scripting.
• Participate in change and code reviews to understand the testing needs of the change components.
• Create crontab for scheduling the upload the data from various source such as flat, excel files
• Involved in database strategy (backup)
• Involved in creating constraints on various tables to load the data from different sources to target.
• Participated in change and code reviews to understand the testing needs of the change components.
• Convert the data into flat file layout as per customer needs.

Environment: SQL Developer, Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL Server, Java, PVCS VM, SQL PLUS, UNIX shell scripting

Oracle Developer / Data Analyst

Confidential, Houston, TX

Responsibilities:

• Update ETL process using Kettle Informatica Tool (Pentaho) to load from Sources to Targets through data transformation.
• Developed different adhoc queries as per client's needs.
• Created and managed database object like tables, views, sequences, synonym, index, trigger, user, roles, DB link and Materialize view (M-view).
• Designed ETL process using Kettle Informatica Tool (Pentaho) to load from Sources to Targets through data transformation.
• Working on troubleshooting defects, Query optimization in timely manner.
• Creates email alerts to perform jobs in timely manners using scheduler tasks and cron jobs
• Developed triggers, Indexes, PL/SQL packages, procedures, functions, using SQL Developer, Pl/Sql Developer Tools. Generated server side PL/SQL scripts for data manipulation and validation of data for remote instances.
• Involved in creating UNIX shell Scripting.
• Create crontab for scheduling the upload the data from various source such as flat, excel files
• Involved in creating constraints on various tables to load the data from different sources to target.
• Participated in change and code reviews to understand the testing needs of the change components.

Environment: SQL Developer, Toad, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, FTP, SQL PLUS, UNIX shell scripting

Oracle Developer

Confidential, Richardson, TX

Responsibilities:

• Developed procedure for the conversion of data into XML using SQL Prompt, Oracle utilities as per client’s requirement.
• Working on troubleshooting defects, Query optimization in timely manner.
• Create Cron job for schedule the tasks
• Developed triggers, Indexes, PL/SQL packages, procedures, functions, using SQL Developer, Pl/Sql Developer Tools. Generated server side PL/SQL scripts for data manipulation and validation of data for remote instances.
• Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table to make Database Faster and easier to maintain.
• Experience in database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Create DB Link
• Participated in change and code reviews to understand the testing needs of the change components.
• Extracted data from the XML file and loaded it into the database.

Environment: SQL Developer, Pl/Sql Developer, Toad, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL PLUS, HTML, XML, FTP, UNIX shell scripting

Oracle Developer

Confidential, Irving TX

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic, using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created and deployed Shell and SQL Scripts
• Experience in database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Used SQL Server tools to build high performance data integration solutions, including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Written UNIX Scripts to automate Jobs.
• Designed and developed Oracle forms & reports

Environment: JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL PLUS, HTML, XML, HP-UNIX shell scripting, SQL Developer, Pl/Sql Developer, Toad

Oracle Developer

Confidential, Dallas TX

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic, using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Participated in change and code reviews to understand the testing needs of the change components. Working on troubleshooting defects in timely manner.
• Performed modifications on existing form as per change request and maintained it.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, 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 data structures.

Environment: Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL PLUS, HTML, SQL Server 2008, TOAD, XML, UNIX shell scripting.

Oracle Developer

Confidential, Richardson, TX

Responsibilities:

• Participated in gathering the user requirements and involved in writing technical design documents.
• Responsible for definition and management of schemas and objects and monitoring, tuning and troubleshooting of Oracle databases.
• Responsible for coding stored procedures, functions and triggers and other scripts based on functionality of the domain and as per business requirements using PL/SQL.
• Designed and developed various types of Reports as per the requirements.
• Prepare UNIX shell scripts for testing the application.
• Used SQL Server for data integration solutions, including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the oracle database.
• Involved in Migration of tables and indexes to different table spaces.
• Extensively involved in Fine-tuning the Informatica Code (mapping and sessions), Stored Procedures, SQL to obtain optimal performance and throughput.
• Experience in writing UNIX shell scripts (Wrapper scripts) to automate batch jobs and Oracle Backups to store in the appropriate tables using PL/SQL and Shell Scripts.
• Wrote Test scripts for Unit, involved in System, and Integration testing.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, TOAD, Power Builder, SQL Loader, Reports 6iSQL Server 2008, MS Visio, Erwin, UNIX Shell Scripts, UNIX.