Over 8 Yrs Experience in IT analysis, design and development of software applications in client/server environment with Relational Database concepts using Oracle 8.x/9i/10G and Data Warehousing Concepts.

• Strong Experience in Oracle database design and logical/physical Data Modelling.
• Expertise in using SQL Loader, External Tables, Collections PL/SQL Tables Materialised views, Triggers, Functions, Procedures and packages.
• Expertise in Data Modelling including Star Schema and Snowflake Schema. Used ERWIN to design Normalized and De-Normalized Data Models.
• Good experience working with UNIX Korn/bash shell scripting with SED and AWK and scheduling tools like Autosys and AppWorx.
• Expertise in using SQL * Loader and External Tables for loading data from flat files into Oracle tables.
• Extensively used various Exception handling cases for proper flow of data into database tables
• Experience in performance tuning and optimization of PL/SQL scripts and SQL queries using Explain Plan, TKPROF, and Auto-trace.
• Extensively used Ref Cursors, Bulk binds, Bulk Collects, Dynamic SQL’s, NOCOPY FORALL statements and co-related sub-queries
• Heavily worked with SQL HINTS, INDEXES (B*Tree, Bitmap, Unique, function based, Clustered indexes) for performance improvements.
• Extensively used Oracle built-in Packages such as UTL_FILE, DBMS_JOB, DBMS_SQL, DBMS_SCHEDULER and DBMS_UTILITY.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Developed and supported Extraction, Transformation and Load process (ETL) using PL/SQL and to populate the tables in OLTP and OLAP Data warehouse Environment.
• Good Knowledge of complete Software Development Life Cycle, Data Acquisition, Data Integration and Data Loading. Familiar with Source control management tools like Clear case, VSS, PVCS, SVN and CVS.
• Worked with Ticketing UI tools, JIRA, Clear Quest, BugZilla, and Lotus Notes.
• Savvy with using MS-Access, Excel applications to provide data reports to peers.
• Excellent analytical and interpersonal and communications skills and ability to work independently interacting with people at levels.

Operating System : UNIX (IBM AIX, Sun Solaris, HP UX),
Windows 2000/NT
Languages : SQL, PL/SQL, Korn Shell, PERL
DB/Utilities : Oracle 8i/9i/10g, SQL Server 2000/2003/2005, MS- Access
Oracle Tools : EXPLAIN PLAN, SQL* Loader, SQL*PLUS
Oracle GUI Tools : Toad, ERWIN, SQL Developer, PL/SQL
Navigator, WinSCP, Putty
Internet Technologies : HTML, PHP, Java Script, XML
Protocols : FTP, SFTP, SSH, Telnet.
Documentation Tools : MS Word, MS Excel

EDUCATION:

• Bachelor of Engineering in Computer Science
• Masters in Computer Networks

WORK EXPERIENCE:

Confidential,NY. Sep 2008 Present
PL/SQL DEVELOPER
Responsibilities:

• Worked very closely with functional team to understand their Development related requirements and created TDD (Technical Design Document) for the design provided in SDS (System Design Specification) and translated service requests(SR)
• Created new procedures, tables and shell scripts for Archiving and screening the Remote and local databases
• Developed SQL scripts and Procedures to load data into data marts and database.
• Developed Shell scripts for automation of procedures and SQL scripts
• Extensively used Autosys and DBMS_Scheduler for scheduling the nightly batch jobs
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables using both UTL and SQL Loader.
• Extensively worked with Dynamic SQL, PL/SQL Tables, Ref Cursors to process huge volumes of data
• Used BULK COLLECT AND BULK BIND for mass update as performance improvement process.
• Used PL/SQL COLLECTIONS and RECORDS in procedures and packages to improve the efficiency
• Developed new PL/SQL Package for processing the fulfilment request for the corresponding templates and generates XML data. Transmit process takes the generated XML data and send it to print vendor.
• Used oracle supplied package DBMS_XMLDOM and DBMS_XMLPARSER. For parsing and extracting the data from XML and storing into Oracle tables.
• Tuned SQL Query for optimization in Oracle stored packages using Explain plan and Auto trace.
• Created procedures and packages to support data validation application which were Java and .net applications.
• Used TKPROF (SQL Trace) tool to analyze and fix multiple time consuming SQL statements that were available in stored packages..
• Used SQL queries and analytic functions to develop reports for managers for business analysis
• Involved in Unit testing and migrate the objects to the QA and UAT TEST environment using SVN.
• Interacted with Subject Experts for the makes changes in production environment.
• Created test scenarios for created code and distribute across to the QA along with
• Knowledge transfer and documented work flow of all process.
• Attending and Solving both QA and Production tickets simultaneously for different programs across different schemas at any given point of time.

Environment: Oracle 10g ,11g Windows XP, PL/SQL Developer, TOAD, HP-Unix, SQL*Loader, SQL plus Crystal reports XI, SVN, JIRA and Clear Quest

Confidential,GA.Jan 2008 Aug 2008
PL/SQL DEVELOPER/ REPORTING ANALYST
Responsibilities:

• Gathered various Business Requirements from the client and translated the Service requests (SR) into technical design and specification.
• Involved in importing the production data to work environment through TOAD.
• Extensively Used ERWIN for data base remodeling.
• Involved in Creation of Tables, Join conditions, Correlated sub queries, Nested queries, Views, Sequences, and synonyms for various application.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain Plan and Trace sessions
• Used various Exception handling cases for proper flow of data into database tables.
• Extensively used SQL Loader to load the data from Flat Files into the staging
• Tables and verified the Log Files for rejected rows.
• Written PL/SQL programs, stored procedures and triggers for data loading and data validations for various .net applications
• Extensively used UNIX SHELL scripts for automation of daily and weekly batch jobs.
• Used scheduler tools like Autosys and DBMS_Scheduler for scheduling the batch jobs
• Created indexes on huge number of data available in tables based on requirements.
• Extensively worked on creating sequences, views and writing the SQL queries using JOINS.
• Worked with oracle supplied packages such as UTL_FILE,UTL_TCP, UTL_SMTP and DBMS_PIPE
• Developed new PL/SQL Package for processing the fulfilment request for the corresponding templates and generates XML data.
• Communicated with Subject Experts for Implementing Any modifications affecting production data.
• Attended to user requests in enhancing reports and fixing bugs, providing solutions for existing bugs and redefining newer concepts for better features.

Environment: Business Objects XI R2, Oracle 8i, 9i, 10g, Crystal reports XI Windows XP, AIX, PL/SQL Developer, TOAD, Clear Case, VSS.

Confidential,GA.Nov 06 Dec 07
PL/ SQL Developer
Responsibilities:

• Effectively communicated with Prudential for data requirement and data analysis and properly documented.
• Worked on ERWIN for Re-Design of the Schemas for the OLAP Environment.
• Gathering data elements needed for analysis of the data and flat files were decoded and loaded into temporary schema loads using SQL*Loader
• Worked extensively in various kinds of queries, Sub- Queries, Correlated Sub-Queries, Dynamic SQL, and Union Queries.
• For Developed Java and .net Applications, created and updated several SQL packages and Procedures.
• Wrote the Scripts to create tables, functions, and stored procedures, Triggers, Packages, Indexes and Views in Oracle.
• Used SQL hints and indexes to improve SQL performance and analyzed the schema tables for to get the better performance.
• Developed procedures for validation and error reporting on the data in the intermediate tables Created user defined Exceptions while handling exceptions.
• Used Dynamic SQL for interface programs and exception handling routines.
• Created and implemented DDL Scripts in Development, QA and Production Environment.
• Extensively used of PL/SQL Collections and Records.
• Worked with tools like Appworx and Autosys used for scheduling jobs.
• Used SQL Analytics functions RANK, DENSE_RANK for various reporting needs
• Effectively used the Rational Clear Quest tool for defect tracking.

Environment: Oracle 8i, 9i, 10g, SQL Server 2005, Crystal reports XI, Informatica, PL/SQL Developer, TOAD, SQL*Loader, SQL Plus, Windows XP, AIX ,Clear Quest

Confidential,TX. Feb 05 Oct 06
PL/ SQL Developer / Data Analyst
Responsibilities:

• Gathered Business Requirements form the client and translated the business detail into technical design and specification.
• Loaded data into Data marts from which reporting is done using the Business Objects tool.
• Involved in Creating Sales, Buying and Merchandising, Inventory and Human Resources Data marts.
• Extensively used SQL Loader for loading data into staging tables from various data sources
• Created Custom Staging Tables to handle import data.
• Created new Procedures, Functions and Packages to support existing web applications.
• Fine Tuned existing procedures using SQL Trace.
• Used various Exception handling cases for proper flow of data into database tables.
• Used Dynamic SQL to clean the staging tables for various reporting Purposes
• Used PERL and UNIX scripts for FTP and Automation of batch jobs.
• Developed Complex SQL queries and Inline views, materialized views, global temporary tables for reporting purposes.
• Involved in performance tuning of SQL queries using TK PROF and Explain Plan.
• Developed Shell Scripts to call the newly build PL/SQL programs through shell scripts for automating batch programs.
• Developed automated programs which will extract data from the input files (Input files can be Fixed length or Comma separated text files or XML files) and will parse the extracted data and triggers the procedures to update them in the tables.
• Work with tools like Appworx (enterprise scheduler) for scheduling jobs.
• Worked with Experts for executing any modifications on production tables.
• Work with day-to-day issues that are submitted in the form of tri-active tickets.
• Plan code migration and version control

Environment: Business Objects XI R1/ 6.5.1, Web Intelligence 6.0, Informatica Power Centre, SQL Navigator, Oracle 8i, 10g, TOAD, SVN and Lotus notes

Confidential,CA. Oct 04 Jan 05
PL / SQL Developer / Reporting Analyst
Responsibilities:

• Analysing the Business Requirements
• Analysed the star schema and identify the tables necessary to build the universes.
• Responsible for Data Mapping from legacy system to Oracle.
• Responsible for the data model changes in all enterprise applications.
• Involved in database design changes to determine the impact to the physical database.
• Created DB objects like materialized views, partitions, tables, views,
• Tuned and optimized SQL statements.
• Created various Procedures and packages to support the reports.
• Created custom tables and control files for SQL*Loader to load data into Oracle from legacy system
• Automated various SHELL scripts using Autosys.
• Created DB Triggers, Functions, Packages, Stored Procedures, Views, Synonyms to support various back end applications.
• Developed many new reports as per business requirements.
• Developed test plans and test cases for user acceptance and unit testing.

Environment: Business Objects 6.5.1, Oracle 9i, SQL Server2000, Java,UNIX, SQL*Loader, TOAD and VSS
.
Confidential,Scotland, UK. Nov 03 Sep 04
PL / SQL Developer
Responsibilities:

• Effectively communicated with Business Users for data requirement and data analysis and properly documented.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for weekend batch processing.
• Involved in creation and updates of several SQL packages and Procedures.
• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables
• Created Staging Tables to handle import data.
• Implemented various Exception handling cases for proper flow of data into database
• Implemented PL/SQL scripts using Ref cursors in order to load data dynamically and implemented incremental loading of the data.
• Used Complex SQL queries and Inline views, Materialized views, Global temporary tables for reporting purposes.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User Notes

Environment: Business Objects 6.1, Oracle 9i, PL/SQL, SQL*Plus, SQL*Loader, TOAD, VSS, Windows NT and UNIX.

Confidential,London, UK. Sep 01 Aug 03
PL /SQL Developer
Responsibilities:

• Created Universe on Business objects for Various Departments.
• Responsible for Data Mapping from legacy system to Oracle.
• Building Reports using Business Objects.
• Analysed the schema’s and identify the tables necessary to build the universes
• For reporting needs.
• Used SQL Conditions for the Context and for the Filtering at various levels based on the specifications.
• Responsible for designing the tables, PL/SQL Stored procedures, PL/SQL Packages and PL/SQL Functions.
• Extensively used SQL scripts to create Staging Tables and developed SQL*Loader Control Files to load the Data into the Staging Tables.
• Used SQL queries to develop reports for managers for business analysis.
• Created templates for standardizing reports using company logo, header and footer settings, colour coding, fonts and maintained consistency in viewing cross-tabs, blocks in report.
• Training the End User to use Business Objects for taking Reports

Environment: Business Objects 5.1, SQL Server, Oracle 8i, TOAD and Windows