SUMMARY

• 12 Years of IT experience in Oracle database technologies for OLTP and data warehousing systems.
• 6 years of experience in technical lead activities evaluation and analysis of requirements, high and low level database designing, code review, standardization & re - factoring, interacting with users, analysts and developers.
• Strong oracle backend development experience using SQL, PL/SQL including collections, dynamic sql, stored.
• procedures, functions, packages, triggers, Jobs scheduler and other advanced features.
• Extensively worked on design and development of fact and dimension tables, back data population.
• batch processing, staging table loads from source flat files, SCD2 & close of business based loading, ETL PL/SQL.
• load and audit frameworks, lookups on dimension tables, data quality logging, partitioning and indexing.
• tables, parallel jobs framework for large loads, rollback of batch loads, housekeeping & custom stats gathering.
• Strong experience in deployment, continuous integration and release management of Oracle database changes.

TECHNICAL SKILLS

O.S & RDBMS: LINUX, HP UNIX, SUN Solaris,WINDOWS NT/2000/XP, Vax,VMS 4000, Oracle 9i,10g & 11g,Sybase, MS Access

LANGUAGES: SQL, PL/SQL, Shell Script, Java,Script, T sql

TOOLS & UTILITIES: SQL *Plus, SQL Loader, Toad 9, PLSQL,developer, ERWIN 4.0, Developer 6i/2000,Eclipse, Informatica 8.6, Control - M, Sql,Developer, Top Link

PROFESSIONAL EXPERIENCE

Confidential

Oracle Technical SME/Senior Developer/Deployment Administrator

RESPONSIBILITIES:

• As SME, designed ETL data loads, laying out the high and low level design documentation for all the components
• f new data loads as well as adjustments processing as per regulatory reporting requirements of the bank
• Worked closely with the warehouse architect on fact, dimension & stage table design, indexing design, technical
• book of work items, code modules & standards
• Code reviewed all oracle changes and provided technical guidance and mentorship to 9 member developers team
• As senior developer, developed stage, dimension / fact tables, PLSQL SCD2/COB dated data loads,
• Developed parallel loads for large partitioned tables, migration of complete workflows from informatica to PLSQL
• Developed adjustment APIs for country scenario adjustments, data maintenance, BAU & Scenarios changes
• Developed for issue fixing and enhancements to adjustments rule & scenario calculation engines using jobs which
• process complex adjustments and calculations based on predefined rules & scenario metadata across multiple COBs
• Developed from scratch the parallel batch data rollback procedures for use in QA/UAT environments to enable
• testing of Month end COB batch runs for both daily and hist batch tables
• Developed the house keeping and shrinking routines based on retention policy for small, large and very large tables
• to be run on every week in off peak hours

ENVIRONMENT & TOOLS: Solaris UNIX, Linux, Oracle 11g, TOAD, PLSQL developer, Sybase, Informatica, Control-M

Technical Lead

RESPONSIBILITIES:

• Developed PLSQL pipelined functions and Infolets using Sql, for drill down reports on various levels of
• aggregation in Audit Management module
• Involved in debugging and fixing of issues with the audits management module and the customized drill reports
• Handled the requirements capture for extending Audits module to on-field Audits for Cattle & Poultry products
• Designed and developed a new Survey's module, which is a part of COI product, right from scratch which enabled
• users to create and maintain interactive/conditional survey templates, sending out surveys, taking survey and
• reporting/mitigation of risks
• Designed and developed the tables for the survey's module and the corresponding PLSQL APIs for all the
• functionality of the module
• Successfully delivered the customized module to client team within five delivery cycles withing short period a file
• Worked with the client team to do master data setup and organization configuration setup for the products

ENVIRONMENT & TOOLS: Oracle 10g, TOAD, Javascript, Metric stream Apps Studio Infolets 

Senior Oracle Developer

RESPONSIBILITIES:

• Lead the database development of banker portal application
• Developed plsql packages, procedures and triggers for coding business logic on various transactions
• Developed complex search function using dynamic sql for producing the deals reports using various search criteria
• Involved in the patch creation for database changes and worked with Architect on code review comments
• Responsible for the complete cycle of database changes to the application from requirements gathering, estimation,
• development, unit testing and deployment.
• Successfully completed major changes to the application which includes  Audit Framework for History
• Information section, procedure for search & package to encapsulate discrete procedures
• Redesigned the database tables for Auctions module and completed migration to new model from old
• Resolved complex issues with the natural key generation of client ids using trigger

ENVIRONMENT & TOOLS: SQL Developer, Toplink, Java/J2EE, Unix

IT Consultant

RESPONSIBILITIES:

• Resolved critical application issues, in co-ordination with systems/development team.
• Worked actively with two projects  two new functionalities.
• Gained experience in Release Management, Testing and handling communications for huge customer base.
• Gained exposure, to a whole set of legacy applications running on various technologies  Perl, PL/SQL, Oracle
• Developed PLSQL APIs for the Admin screens in the Metalink application

ENVIRONMENT & TOOLS: Oracle PLSQL, Unix, HTML DB

Oracle Apps Test Consultant

RESPONSIBILITIES:

• Worked on various modules  Claim Validation and processing, Inspections, Document Management Unit, Customer Service Centre, Interfaces Etc.
• The assignment also addressed review of functional and technical design documents, defect rising & fixing areas of Oracle telesales, customers online and email centre.

ENVIRONMENT & TOOLS: Oracle EBS 11i, Test Director, Oracle application development framework

Oracle 6i Forms and Reports Developer

RESPONSIBILITIES:

• Developed and deployed the module which provides extensive query facility on the impact analysis receipt wise,Base rate change wise, supplier wise etc.
• Supported the modules and planning improvements to the current system, which included the Work In Progress  correction for assembly and machining shops and the introduction of stage wise, Part no Correction for the import parts and price variance posting for the receipts
• The assignment involved the porting of legacy data into the current  structure by mapping of columns after discussion with legacy experts, data correction and controls tallying for the Datawarehouse

ENVIRONMENT & TOOLS: Oracle Forms & Reports 6i, Cobol and Vax Operating System, Sco Unix Oracle Server