Karthikeyan Durai

412-***-****

412-***-****

gtwjx2@r.postjobfree.com

SPECIALITIES:

• Oracle SQL

• PL/SQL Programming

• Shell Scripting

• Testing

• Documenting

SUMMARY

Oracle Certified PL/SQL developer having eight years of experience in Design, Development, Enhancement and Maintaining applications in Oracle 8i/9i/10g using SQL, PL/SQL in Windows and UNIX environments.

Experienced in systems analysis, programming, addressing unique issues of architecture and data management.

Strong Oracle SQL and Oracle PL/SQL skills

Strong UNIX Shell Scripting skills

Experienced in different types of testing which includes Unit, Black Box, Regression and System Testing.

Experienced in creating functional and technical specification documents with high standards.

Excellent logical and analytical skills to solve complex problems

Highly capable of learning new technologies and adapt to new environment in quick time. Good team player.

CERTIFICATIONS

• Oracle Certified Associate (1Z0-047 Oracle Database SQL Expert)

• Oracle Certified Associate (1Z0-147 Program with PL/SQL)

PROFESSIONAL EDUCATION

• Master of Computer Applications (MCA)

• Bachelor of Science (Mathematics)

TRAINING & WORKSHOPS

• SQL Performance tuning, Fidelity workshop – 2 Days

• Training on Shell scripting, Fidelity workshop - 2 Days

TECHNICAL EXPERTISE

Languages SQL, PL/SQL, Shell Scripting and Visual Basic

RDBMS Oracle 8i/9i/10g/11g

Database Tools TOAD, SQL Navigator and SQL*Plus

Platform Windows, AIX and UNIX

ETL Tool AppWorx and UC4

Web Development HTML and VB Script

Testing Tools Quality Center, QTP and Clear Quest

PROJECT EXPERIENCE

1. Rx Data Management System: Ectobox (Jun 2010 – till now)

Environment: Oracle 11g, PL/SQL, Toad, Shell Scripting, AppWorx

Senior database developer with a team of database analysts and data analysts involved in maintaining RX data staging which includes designing and analyzing the application for all enhancement and integration. Implementing business rules using oracle packages and processing daily data using AppWorx ETL tool. Development and maintenance of software in AIX, LINUX and Windows platforms. Involved in developing the reporting and notification system.

Role:

• Design and analyze all enhancements to the database application.

• Develop new modules using oracle packages and shell scripts.

• Performance enhancements using query optimization techniques and indexes

• Coordinate with data suppliers to configure daily data feeds.

• Build and maintain report and notification system for the data staging.

• Coordinating with the data analysts for production release.

• Maintain labels and version controlling

2. Apollo Data Warehouse & Reporting system: Ectobox (Jun 2009 – May 2010)

Environment: Microsoft SQL Server and Microsoft Reporting Services

Lead engineer on a team of software developers involved in evaluating and designing the base framework and Reporting component for the Reporting system. The Reporting system has a complex report specification process which is a .NET application tied in with SQL Server 2005 Reporting Service as the reporting component. Involved in developing various ETL processes, DTS packages, Stored Procedures and Triggers to incorporate business logic for reporting tool and to load data into the warehouse.

Role:

• Evaluate Reporting tools and the OWC OLAP approach for the Reporting portal requirements.

• Designed and implemented the base classes’ derived form Microsoft Enterprise Library framework and User Interface Process Application Block framework.

• Developed the Forms Authentication Custom Security Extension for the SQL Server 2005 Reporting Services.

• Developed the business logic, stored procedures, User functions and Triggers in T-SQL to supplement report specification, Subset the universe and feed calculated data to the reports.

• Worked with the ITSS team to configure the application servers and deploy the application and Reporting services in the DMZ environment.

• Processing and loading weekly data files

3. Electronic Brokerage System: Fidelity Investments (Mar 2007 – Jun 2009)

Environment: Oracle 10g, PL/SQL, Toad, SQL*Plus

EBS system consists of equities and options orders in the OSM & KDB components of RouteHub. Orders are first pumped in RouteHub using Verifix and the return status messages are used to update the order info in the Oracle database. The validations done are Verifix Data with RouteHub GUI, Mainframe with Routehub GUI and KDB with RouteHub GUI.

Role:

• Extensively involved in creating database packages, procedures, functions, cursors and triggers using PL/SQL.

• Preparation, Maintenance and Enhancement of PL/SQL Procedures and Functions.

• Analyze business systems requirements and design technical solutions based on those requirements

• PL/SQL code review and modification for the development of new requirements.

• Optimized SQL queries for better performance.

• Created batch jobs using ETL tool for loading database tables from Flat Files with SQL*Loader.

• Used PL/SQL tables, array structures as a part of oracle collections

• Supporting existing programs and modules.

• Extensively used UNIX Shell Scripts for automating batch programs.

• Involved in the Requirement Analysis and Preparation of functional Specification Documents.

• Developed Technical specification documents & Change Request documents.

• Developed unit and integration test scenarios to support new programs, program changes and configuration.

4. www.streetscape.com: Fidelity Investments (May 2005 – Feb 2007)

Environment: Oracle 9i, PL/SQL, Toad

Streetscape Report Manager is a centralized location enables access to several reports so you can retrieve information on accounts and activity to which you are authorized. Selecting a report typically displays its query parameters where you can enter criteria to target specific data to include in a report.

Role:

• Designed/developed tables, views, various SQL queries, stored procedures and functions.

• Extensively developed complex PL/SQL packages for EBS systems.

• Preparation, Maintenance and Enhancement of PL/SQL Procedures and Functions.

• Analyze business systems requirements and design technical solutions based on those requirements.

• PL/SQL code review and modification for the development of new requirements.

• Extensively involved in creating procedures, functions, cursors and triggers using PL/SQL.

• Optimized SQL queries for better performance.

• Extensively used UNIX Shell Scripts for automating batch programs.

• Developed functional specifications and prepared Technical & Change Request documents.

• Involved in Unit Testing and Integration Testing.

5. TCON EMEA: Polaris Software Lab Ltd (Apr 2004 – Apr 2005)

Environment: Oracle 9i, PL/SQL, SQL Navigator

Atlantis (TCON) is an Integrated Treasury System used widely in Citibank. Atlantis has complete front, middle and back office features for the following various treasury products – FX (Spot/Forward/Swap), MM (Borrowing/Deposit & Fixed/Floating), IRS (Interest & Currency Swap), Forward Rate Agreements, Premium Deposits, Market Linked Deposits, Margin FX, Funds Transfer. This project involves VB to VB dot net migration.

Role:

• Creation of database objects like tables, views, procedures, packages

• Involved in writing procedural scripts using PL/SQL

• Involved in coding and testing of the system

• Stored procedures and triggers were developed for business rules

• Involved in implementation and documentation of the system

• Involved in Unit Testing and Integration Testing.

6. Online Product Utility System: Zensar Technologies Ltd (Dec 2003 to Apr 2004)

Environment: Environment: Oracle 9i, PL/SQL, Toad

Online Product Utility System (OPUS) is a web-based tool used to submit, edit, view and approve product information into the Oracle system. The online submission system supplies immediate detailed product information that includes "live" pricing and orderability information.

Role:

• Creation of database objects like tables, views, procedures, packages

• Involved in writing procedural scripts using PL/SQL

• Involved in coding and testing of the system

• Stored procedures and triggers were developed for business rules

• Involved in implementation and documentation of the system

• Optimize SQL queries for better performance.

7. Customer Services Dashboard: Zensar Technologies Ltd (Jun 2003 to Nov 2003)

Environment: Oracle 9i, PL/SQL, Toad

CSD Dashboard is an initiative developed to standardize reporting of metrics across teams. CSD Dashboard displays various metrics such as Case Volume, P1/P2 Tracking, P1/P2 Tracking, Productivity, SLA & Utilization in summary and drill down views by teams and quarters.

Role:

• Creation of database objects like tables, views, procedures, packages

• Involved in writing procedural scripts using PL/SQL

• Involved in coding and testing of the system

• Stored procedures and triggers were developed for business rules

• Involved in implementation and documentation of the system

Contact this candidate