SUMMARY

• Software professional with over 9 years of experience in software design, development, implementation and maintenance in applications related to financial domain.
• 5 years of experience asOraclePL/SQL developer with expertise in Logical database design and development of data structures and objects.
• Expertise in creation and maintenance of Oracle data structures and objects likeTables, Indexes, Triggers, User Defined Data Types, Functions, Procedures andPackages
• Effectively implemented Table Partitioning, Indexes, Collections, Analytical functions, Materialized Views and Query Re-Write.
• Very good experience in advanced PL/SQL concepts like Bulk collect, forall, and Dynamic SQL.
• Proficient inOracle SQLQuery Optimization and Performance Tuning techniques.
• 7 years of strong PERL programming experience in pattern matching, string manipulation, data extraction and usage of Perl built-in Modules.
• Highly skilled in implementing Object OrientedProgramming concepts in PERL. Generated Reports in Excel and HTML format.
• Well versed inusingPerl database Interface utility DBI::DBD for connecting to different databases.
• 5 years of experience and excellent knowledge in Sybase 11/12. Designed and developed various database objects like Tables, Indexes, Triggers, Stored procedures and Cursors.
• 9 years of experience in Unix Shell scripting. Created wrapper scripts for Perl, SQL PLUS, SQL Loader, ISQL, BCP, Informatica workflows and FTP jobs.
• Less than 1 year of work experience in Data Warehousing ETL using Informatica PowerCenter 8.6 Client tools - Designer, Repository manager, Workflow Manager/Monitor.
• Strong problem solving technical skills coupled with ability to quickly grasp and adapt to newer technologies.

TECHNICAL PROFILE

• Programming Languages: PERL, UNIX Shell scripting, PL/SQL
• Databases: Oracle 9i/10g/11g, Sybase 11.x/12.x
• Data warehousing Tools:Informatica PowerCenter 8.6
• Operating System: UNIX Sun Solaris,Linux , Windows XP/NT/2003
• Miscellaneous: SQL Plus, SQL Loader, ISQL, BCP, Sybperl, Visio, ERWIN, AWK, SED, XML, HTML, Control-M, Autosys, Crontab

Work Experience:

Confidential

OraclePL/SQL developer

Contribution:

• Backend application development
• Designed and developed many UNIX Shell scripts for processing upstream feeds and load them into Oracle database using SQL Loader.
• Designed and developed Oracle data objects like Tables, Indexes, User defined data types/objects, triggers and Views
• DevelopedOraclePackages, Stored procedures and Functions for processing the data
• Improved performance of Existing Stored Procedures by breaking large complex SQL into many smaller manageable SQL.
• Optimized Queries for better performance by adding Hints wherever necessary
• Handled coding of the business logic and backend data pre-processing and loading the data into database using PERL, Korn Shell scripting and SQL Loader
• Interacted with the business clients for designing new functionalities
• CreatedSchedulerbatch jobs using Control-M Enterprise Manager
• Involved in Design and development of normalized database tables
• Enhanced optimized data loading processes
• CoordinatedProduction deployments

Technology: Oracle 10g/11g, PL/SQL, Korn Shell scripting, Linux, PERL, Awk, Sed, XML, Control-M, SVN, Win 2008, Informatica PowerCenter 8.6

Confidential

Contribution:

• Backend application development.
• Designed and developed many stored procedures, Functions, triggers, Views, Indexes andSQL queries for enhancements and maintenance of various database modules
• Using Informatica ETLextracted data from oracle, Sybase and Flat files and applied business logic to load them into the oracle database
• Developed Informatica Workflows, sessions and Mappings for generating flat file extracts for downstream systems
• Optimized Oracle procedures for better performance
• Designed and developed many Unix Shell scripts for batch jobs
• Designed and developed batch scheduler jobs using Control-MEnterprise Manager
• Involved in Production deployments

Technology: Oracle 10g, PL/SQL, Informatica PowerCenter, UNIX scripting, Tortoise-SVN, Sun Solaris 2.8, Perl, Control-M, Win 2008

Confidential

Contribution:

• Developedand Supported the Backend application
• Enhanced optimized data loading processes
• Designed and developed many Sybasestored procedures, triggers, Views, Indexes and TSQL queries for enhancements and maintenance of various database modules
• Improved performance of Existing Stored Procedures in Sybase
• Handled backend data processing and loading the data into database using PERL and Korn Shell scripting
• Interacted with the business clients for designing new functionalities
• Involved in migrating from Sybase to Oracle 10g
• Creation of scheduled jobs using AUTOSYS and CRON TAB
• Involved in migrating GPT from Sybase 12.5 to Oracle 10g server
• Designed and developed Oracle Tables, Indexes, Triggers, Views, Packages, Stored Procedures and functions.
• Involved in Production deployments

Technology: Sybase 12.5, Oracle 10g, PERL, KSH, Sybase::CTlib, HTML, Subversion, Clearcase version control system , Sun Solaris 2.8, Oracle, Win 2003

Confidential

Contribution:

• Involved in the development of backend application
• Optimized the EERS daily Batch Cycle by reducing the total Run time by 30
• Enhanced optimized data loading processes and Optimized SQL Queries for better performance
• Designed and developed stored procedures, triggers, Views and TSQL queries for enhancements and maintenance for various database modules
• Handled complete coding, implementation of middleware, coding the business logic and backend data processing and loading the data into database using PERL and Korn Shell scripting
• Worked extensively in supporting the application by giving production support 24/7
• Developed Application specific PERLmodules for generating reports in HTML Excel format from text files.
• Designed and developed many KornShell scripts
• Creation of scheduled jobs using AUTOSYS and CRON TAB

Technology: Sybase11.x/12.x, PERL, Korn Shell, DBI/DBD, Sybase::CTlib, HTML, Autosys, Win 2000, CVS, Sun Solaris