Overall 10 years of extensive experience in Information technology with expertise in full SDLC including database Design, Development and Implementation of database applications on a broad range of application development environments and factoring business domain using various technologies.

Experience summary:

• Strong programming experience in creating packages, procedures, functions, triggers, views, collections, materialized views and other database objects using SQL and PL/SQL
• Developed and improved various key modules of the Re-insurance custom built Projects from the scratch.
• Good Experience in Developing Oracle applications using advanced utilities like Search Engine projects using Oracle Text and Security Project using Oracle Context
• Good Experience in Various databases MS SQL Server 7.0/6.5, Sybase 12.x, DB2, Teradata V2R4/R5.
• Experience in Migration projects from Legacy Systems to Oracle database and ERP 11i.
• Effective troubleshooting of performance and tuning problems in Oracle databases and Oracle Applications including I/O optimization, SQL Tuning and Backup and Recovery Planning, Testing and Implementation.
• Team lead Experience with consistently increasing responsibilities in team management which includes Requirement Analysis, Tasks allocation WBS , Project Budgeting, Scheduling and managing Deliverables.
• Leading an Automation team Experience in automating Monitor Jobs and control Jobs to increase the performance of the various applications and decrease the manual intervention to handle the SLA's effectively.
• Excellent communication and interpersonal skills, with the ability to manage responsibilities individually or as team lead.
• Excellent communication and documentation skills in preparing project related documents Project charter, BRD's, Risk Analysis and lessons learnt
• Experience in direct Client Interaction, conducting project stack holders meetings, resolving the issues in innovative approach and working in Result oriented manner.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server, Flat files and Teradata.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Responsible for all activities related to the development, implementation, and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Good experience in writing complex SQL queries using analytical functions and working experience with SQL Reports.
• Experiences on Data ware house tools such as Essbase Hyperion 11.1.2, Hyperion Excel Adding and Datastage 8.0.
• Experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Experience in Developing Parallel, Sequential and Server jobs for the credit card applications using Data Stage 8.0.
• Well versed in UNIX shell scripting.

SKILLS:

• Business Domains : Credit Cards, Retail Banking, Insurance Reinsurance, Group and Telecom.
• Operating Systems : AIX, UNIX, Linux, Windows 2000/NT/XP.
• Programming Languages: SQL/PLSQL, Shell, AWK, Java script, C and Hibernate
• RDBMS : Oracle 11g, 10g, 9i, Oracle RAC/Grid, Teradata and Sqlserver.
• DB Tools : TOAD 11.6, PLSQL Developer 8.0, SQL Developer, Erwin.
• DW tools : IBM Info sphere server-Data stage 8.5/8.1 Parallel Extender , Essbase Hyperion and Hyperion Excel add in and Informatica Power center 8.6
• Scheduling Tools : crontab, Autosys and Control M
• Utilities : WinCVS 1.3.14, VSS, SVN, putty and SSH

Projects experience:-

Confidential

Oracle ETL Senior Developer

Responsibilities:

• Involved in Analysis, Testing and Solution for different Issues Tickets requested for different schemas in Credit cards Marketing area.
• Analyzed Business requirements for new requirements and changes to the Datastage jobs to handle the performance issues.
• Reconciliation/Correction of dividend data provided from various vendors
• Automation of manual tasks which require more effort/resource and various other tasks
• Involved in Performance Tuning databases using various techniques. Collected performance statistics memory usage, data storage, data manipulation, physical / logical storage, network traffic and implement / manage parallelism for optimum performance using Explain Plan, SQL Trace, Tkprof Stats pack.
• Development of PL/SQL stored procedures along with Unix shell scripts.
• Development of parallel jobs using Datastage tool.

Environment: Oracle 11g, Datastage 8.1, Control M, Unix and SQL/PLSQL

Confidential

Oracle Lead Developer

Responsibilities:

• Developed CORPFIN application and delivered with minimal issues and on Time.
• Received many appreciations from clients for on time deliverables
• Design Develop the Outlines for Corpfin and Recon.
• Actively participating in development of business entity
• Coordinated and helped other developers in the team to their development tasks.
• Development of PL/SQL stored procedures.
• Development of UNIX shell scripts.
• Scheduling the Autosys jobs for Essbase cube building
• Preparation of fortnightly status report of project activities

Environment: Oracle 11g, Autosys, UNIX, SQL/PLSQL, Hyperion Essbase 11.1.2, Essbase Studio, Hyperion Excel Adding

Confidential

Oracle Lead Developer

Responsibilities:

• Responsible in developing Privacy Initiative PI project using Virtual Private Database VPD .
• Automated the Testing of security policies on schemas which restricts sensitive data to the users.
• Involved in Analysis, Testing and Solution for different Issues Tickets requested for different info1 maintained schemas.
• Coded and implemented packages to perform PI testing and batch job scheduling.
• Developed Shell Scripts to automate the testing PI applied columns across the schema.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for batch processing.
• Performed tuning and optimization on SQL queries using Explain Plan.
• Expertise in use of Export/Import and Data pump object level, schema level, transportable table space and full database .
• Experience in Performance Tuning databases using various techniques. Collected performance statistics memory usage, data storage, data manipulation, physical / logical storage, network traffic and implement / manage parallelism for optimum performance using Explain Plan, SQL Trace, Tkprof Statspack.

Environment: Oracle 10g, Crontab, AIX, SQL/PLSQL, Informatica power center 8.6

Confidential

Senior Oracle Developer

Responsibilities:

• Involved in Discussions with Swiss Re personnel based on the System Requirements Document to cover the functionality, technical issues and scope of work
• Analyzed, diagnose dividend data to identify any problems in data
• Analyzed Business requirements for changes.
• Reconciliation/Correction of dividend data provided from various vendors
• Automation of manual tasks which require more effort/resource and various other tasks
• Coded in PLSQL and Unix Shell Scripting
• Developed Data Inflation module using PLSQL packages.
• Code Review for the team developed procedures.
• Created many PLSQL packages
• Created many tables, stored procedures on Oracle
• Worked in query optimization
• Participated in performance tuning
• Provided support to the data files by running extracts and performing data imports through SQL Loader.

Environment: Oracle 10g, TSQL, MS SQL Server

Confidential

Senior Oracle Developer

Responsibilities:

• Involved in user requirement gathering, analysis, design, coding and testing
• Involved in Design Documents of HLD LLD
• Coded in PLSQL and Unix Shell Scripting
• Developed modules using SQL/PLSQL
• Designed, developed and modified Pl/SQL scripts using the package modules
• Worked in automating feed processing module with table-based data
• Created queries to generate complex reports by using inline quires and joins
• Created many tables, stored procedures on Oracle
• Involved in database design and SQL query performance tuning
• Created many batch scripts using KSH and scheduled in CRON TAB
• Created batch processes to function independently behind the scenes for data transfers and database updates
• Worked on bug fixing and supported the production applications
• Participated in design and development of various modules
• Worked in design documentation and change control up

Environment: TSQL, MS SQL Server

Confidential

Oracle PL/SQL Programmer

Responsibilities:

• Involved in the Data Migration Activities
• Involved in Development of AOL objects like Defining Concurrent Programs and Executables for finance modules.
• Prepared requirement documents, high level design and unit test plans
• Developed and tested new scripts required to automate and drive the procedural execution of applications for efficiency and troubleshooting purposes
• Worked on creation of Control Files for SQL Loader to load data from Text Files.
• Created new stored procedures, triggers, views as part of Implementation. In AR, AP, GL Modules.
• Created Forms and Reports in AR, AP modules.
• Used SQL Loader for data loading
• Created Unix Shell Scripts for sequential execution of scripts including data extraction, transformation and loading. and Stored Procedure execution
• Involved in client interaction at requirements capturing stage
• Developing test plans.

Environment: E-business Center 11i FINANCE Modules, PLSQL, Shell Scripting

Confidential

Responsibilities:

• Responsible for Onsite Client interaction for information gathering.
• Developed an ISR data Entry tool to allow users to enter the terms of new ISR or Traded deals under negotiation signed or unsigned
• Coding and bug fixing
• Created new stored procedures, Triggers and modified existing packages and other schema objects
• SQL query tuning on complex reports
• Maintained the version control through Visual source safe.

Environment: PERL Solaris 2.x, KSH, Sybase 11x, T-SQL

Confidential

Responsibilities:

• Developed utilities and different shell scripts which were used while unit testing the code fixes.
• Created new stored procedures, Triggers and modified existing packages.
• Created Reports and customized Graphs to display real-time Views of the Data.
• Maintained the version control through Visual source safe.
• Worked on new modules and enhancements
• created views and table joins for generating Reports
• Analyzing the PLSQL code, log files and core dump taken from the defective systems.
• Worked on Shell Scripting.
• Involved in functionality testing and integration testing

Environment: PERL Solaris 2.x, KSH, SQL/PLSQL, OFA, OSA