Summary:

• Having around 8 years of IT experience in various application phases of Software Development Life Cycle including Designing, Development, Testing and Production Support using SQL, PL/SQL and UNIX.
• Experience with multiple RDBMS including Oracle 11g/10g/9i/8i, Microsoft SQL Server 2000/2005/2008 and associated SQL Dialects such as Transact SQL T-SQL , PL/SQL
• Expert level experience on PL/SQL that includes Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Object, Materialized views, Partitioned Tables, Triggers, Synonyms, Sequences and Table Indexing.
• Experience in creating cursors, composite data types, collections and exception handling.
• Expertise in developing Data Conversions/Migration from Legacy System of various sources flat files, Oracle, Non Oracle Database to Oracle system Using SQL LOADER , External table and Using Appropriate Interface tables.
• Proficient in developing the Data mart in Star Schema and Snowflake Schema, Flat files and building the Data warehouse, Efficient in developing the Data model, OLTP/OLAP and organizing the data as per the Business requirements.
• Extensive experience in writing SQL Loader routines and file based interfaces using UTL File.
• Extraction of XML files to load it into database through SQL loader.
• Extensive experience in improving the performance of Query by minimizing the number of context switches between the PL/SQL and SQL engines Using Collections, Bulk Binds.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 Forms, Reports , Forms and Reports 9i, Oracle Developer Suite 10g and other front-end tools.
• Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and Hints.
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
• Experience in using tools like SQL Plus, SQL Assistant, PL/SQL developer, TOAD
• Experienced in writing UNIX shell scripts for automating the process of data loading Batch Processing.
• Extensive Programming experience in designing reports using Reports 9i/6i/3.0/2.5 like matrix reports, group above reports and designed user interfaces with Forms 6i/5.0/4.5.
• Worked on Production Support, receiving production calls, troubleshooting the application and resolving the issues.
• Expertise in building and maintaining Microsoft Excel Spreadsheets, Pivot tables and Macros.
• Strong perseverance and diligence towards attaining challenging goals and effective time management.
• Self motivated and enjoy working in a technically challenging environment.
• Coordinated with DBAs, QA, Release management and external team for technical needs and to ensure the timely release of project.
• Excellent communication, interpersonal and versatile team player with problem solving skills.

Technical Skills

ConfidentialProfessional Experience

Oracle PL/SQL Developer

Responsibilities:

• Created, debugged and modified stored procedures, functions, packages, tables, views, materialized views and SQL scripts using PL/SQL.
• Created UNIX shell scripts to automate table creation, execute procedures by using CRONTAB.
• Involved in performance tuning which included creating indices, table partitioning, SQL hints using explain plan utility.
• Involved in developing and maintaining control files for SQL loader to load the data from SQL server to oracle database tables.
• Worked on queries using Teradata SQL Assistant to connect various ODBC sources.
• Worked with DBAs to help them in data loading process, batch jobs and various administration tasks.
• Responsible for data mapping and creating Run-Books from legacy system to oracle.
• Extensive experience in working with different FTP clients such as IpSwitch, winSCP for extracting data from sources to own destination.
• Created synonyms and make sure that users have executable permissions on all objects.
• Performed re-org for several dimension and fact tables for space release management in data warehouse.
• Extensively used cursors, sequences and indexes in the procedures.
• Created PL/SQL based ETL process to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Responsible for monthly ETL in SQL server which are used by the users for potential tableau reporting.
• Researching and resolving the problems occurred in daily and weekly jobs and also involved with end user to resolve the problems.
• Created stored procedures for daily database space monitoring.
• Wrote dynamic SQL queries in different procedures and packages to work on PIVOT function.
• Worked extensively on Exception handling to trouble shoot the PL/SQL code.
• Involved in automation of SQL server jobs that are performed manually which involves MS ACCESS.
• Involved in data migration of SQL server tables into oracle.
• Converted SAS process scripts into oracle process scripts and scheduled them in UNIX.
• Worked in production support environment which involved in performing operation such as monitoring jobs, performing root cause analysis, troubleshooting the issues, monitoring top activity and long running queries, performance tuning and space management.
• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.

Environment: Oracle 11g/10g, SQL PLUS, SQL LOADER, PL/SQL Developer, Teradata Client 13.0, IpSwitch, UNIX Shell script, SQL server 2008, MS Access, Business intelligent development studio 2008, windows 2007, MS office.

Confidential

Database Analyst

Responsibilities:

• Converted Actual report to Oracle report.

• Creating and populating table fields by migrating data from different Databases.
• Used Cursors, Ref-cursors, Bulking techniques, Oracle Supplied Packages, Collections, Dynamic SQL.
• Designing/modifying design of database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Improved query performance by query optimization - tracing the query execution plan explain plan .
• Developing and modifying PL/SQL packages, functions and procedures.
• Created partitioned tables, partitioned indexes for manageability and scalability.
• Did Migration from one database to another database using SQL loader.
• Designed and developed user interfaces using Oracle Forms 10g
• Designed and developed Oracle forms and reports according to user specification
• Did Relational Data modeling, and created Data Dictionary.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.

Environment: Oracle 10g, Oracle Forms 10g, Reports10g,, SQL PLUS, TOAD, SQL LOADER, PL/SQL, Windows 03, MS office, SQL Navigator.

Confidential

PL/SQL developer

Responsibilities:

• Extracted xml files to load it into database through SQL loader.
• Extracted data from various location and load them into the oracle table using SQL LOADER.
• Creating database objects And Developing and modifying PL/SQL packages, functions, procedures, PL/SQL Tables.
• Handled Input data coming from Real Time system to create xml file using pl/sql procedure.
• Handled various inbound files and process them with the help of SQL LOADER and loaded them into the oracle Global table.
• Experienced in Datamart and Data warehouse.
• Created indexes and used SQL hints for better performance.
• Created promotion scripts and documents for migrating objects from one database instance to other instance
• Designed and developed Oracle Forms Reports using Forms10g and Reports10g Including Forms based on stored procedures
• Unix shell scripting and Used Job scheduling tool like Cron job for automation.
• Extensive knowledge on UNIX shell scripting and commands.
• Worked on creating users and roles as needed for the applications.
• Understanding and documenting business rules, output requirement and data sources.
• Improved query performance by query optimization - tracing the query execution plan explain plan .
• Unit test and debug developed software.
• Collaborated with a multi-disciplinary team to design, build and test software to meet client needs.
• Participated in design and analysis of Acxiom systems and/or products.
• Wrote Complex SQL script, Analytical Function using Cursors, Bulking techniques, Collections, Dynamic SQL.

Environment: Oracle 9i/10g, Oracle Forms 10g, Reports10g, PL/SQL, SQL Plus, PL/SQL Developer 6.0, Toad 9.1, UNIX, MS Access

Confidential

PL/SQL Consultant

Responsibilities:

• Designing and modifying of Database tables, indexes, triggers, packages, functions and procedures etc.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Support Data warehouse, ETL Process.
• Creating database objects And Developing and modifying PL/SQL packages, functions, procedures, triggers.
• Developed Database Triggers for the integrity and security purpose.
• Creating high performance queries and PL/SQL codes using Bulk Binds, Collections, REF Cursors etc.
• Unit testing on Pl/SQL Packages and procedure, functions according to business requirement.
• Did manual testing and build test script.
• Did use oracle supplied package like DBMS SCHEDULER, DBMS JOB packages.
• Used Unix FTP Connection for extracting data from legacy sources to own destination.
• Improved query performance by query optimization - tracing the query execution plan explain plan and Used TKPROF SQL scripts to monitor the performance.
• Knowledge on handling QA tickets and analyze trouble tickets.
• Experienced in all phases of the system development life cycle SDLC and Development methodologies/Guidelines.
• Participation in reviewing code and ensuring testing, facilitate code delivery to production environments.
• Involved in generating plenty of reports in Reports 6i.
• Developed the user interface in Forms 6i and generated reports in Reports 6i.
• Extensive knowledge on Unix Shell Scripting and commands.
• Extensive knowledge on Unix FTP Connection for extracting data from different sources to own destination.
• Extensive knowledge on operations support for production environment.
• Knowledge on system configuration for the database PL/SQL applications.
• Responsible for developing and maintaining Oracle PL/SQL applications and database Programming
• Loading of data from external systems using SQL LOADER.

Environment: Oracle Database 10g, Forms 6i, TOAD, PL/SQL Developer, SQL Loader, UNIX

Confidential

Software Engineer

Responsibilities:

• Checked explain plan of the SQL queries to improve the performance.
• Modified the existing shell scripts to support conversion process.
• Used SQL hints and indexes to improve the performance of queries.
• Created/modified the procedures, functions and packages to support data conversion.
• Involved in tuning and optimization of SQL statements.
• Created materialized views, partitions, tables, views and indexes.
• Developed various data exception reports and submitted to the client for data clean up.
• Created database objects like tables, synonyms, sequences, views.
• Responsible for data mapping from legacy system to Oracle.
• Gathering data elements needed for analysis of the data, decoding flat file data and loading into database tables using SQL Loader.
• Gathering required data, data analysis and documentation of the plan.
• Wrote shell scripts for automating the process of data loading and daily process.

Environment: Oracle 9i/8i, TOAD, SQL Plus, PL/SQL, Import/Export Utility and Windows NT, UNIX.

Confidential

System Analyst

Responsibilities:

• Writing PL/SQL code for deleting data for employee records for previous data.
• Involved in software requirement specification and technical design.
• Performed Normalization and Logical Database Design.
• Created of database links and accessing the data through SQL statements.
• Created tables, views, table spaces, user schemas, and assisted in database administration and maintenance.
• Created Stored Procedures, Functions and Packages to manipulate the database and to apply the business logic according to the user's specifications.
• Involved in creating the tables and views in SQL Server databases.
• Involved in preparing the test cases according to the functional requirements.

Environment: Oracle 8i, SQL, SQL developer, SQL server 2005, Microsoft BIDS 2005