SUMMARY

• 12 Years of IT experience in Oracle database technologies for OLTP and data warehousing systems
• 1 year onsite(UK) work experience with client exposure and 7 years of offshore experience working with US clients
• 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, VPD, Jobs scheduler and other advanced features
• Extensively worked on design and development of fact and dimension tables, back data population, metadata for 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 of large 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, for a global team of 14 oracle developers, producing re-runnable build consistent scripts, from development to QA, UAT and production environments
• Having experience in handling complex re-factoring of large fact tables in small release windows using parallel jobs
• Exposure to ETL loads using Informatica and batch job scheduling, ordering & monitoring using Control-M
• Strong experience in development of PLSQL APIs of business logic for UI applications developed in Java/J2EE both as adjustments processing on fact and dimension data in data warehouse as well as transactions in OLTP systems
• Experience on tuning and performance improvement of SQL queries & large table loads, working with indexing, explain plan, wait events, trace, plsql profiler, parallel loads, stats management, AWR reports & hints
• Having functional knowledge in the areas of credit risk management, strategic risk management, audit & compliance & capital markets. Also have exposure to material procurement, shop floor control and competency mapping for HRM and CRM.
• Experience in working with test case preparation and functional testing of Oracle Apps 11i order management
• Exposure to Oracle Apps 11i Application Development Framework and customization
• Experience on custom development in Oracle developer 6i/2000, Forms & Reports
• Worked on migration of legacy data to oracle using SQL*Loader and standalone load procedures
• Excellent communication and analytic skills. Effective mediator between end users, developers and peers.
• Have 3 years of experience in handling client communications and resolving issues with Business analysts, users and the development team
• Extensive exposure to application design, application demonstrations to users, implementation & user training. Conducted knowledge sharing sessions on various topics
• Adept at working with diverse technical groups and global customers to develop technology solutions that meet or exceed expectations
• Exposure in varied business processes of many fortune companies. Outstanding organizational skills, work ethic and drive to succeed
• Strong analytical, diagnostic and problem solving abilities

TECHNICAL SKILLS

O.S & RDBMS: LINUX, HP UNIX, SUN Solaris, and 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 of 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 housekeeping and shrinking routines based on retention policy for small, large and very large tables to be run on every week in off peak hours
• As deployment administrator, created release manifests to capture oracle changes and build release file scripts
• Developed standard scripts to drop, copy partitions & sub-partitions, create public synonyms, providing privileges for all objects created in specific schema and create VPD policies based on metadata in excel sheet
• Developed deployment shell script to create SQL*plus connections and deploy release scripts with interactive log
• Completed several successful planned and exception deployments of releases to QA/UAT & production environments working with release management, production support, DBA teams and change management board
• Worked on batch run support for QA/UAT environments, on Oracle, Sybase, Unix, Informatica & Control- M issues and seeing through fixes working with the corresponding teams
• Developed APIs for weekly cutdown and de-swiss of data from production to CIT environment

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

Confidential

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

Confidential, Newyork

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

Confidential

IT Consultant

RESPONSIBILITIES:

• Resolved critical application issues, in co-ordination with systems/development team.
• Worked actively with two projects (Entitlements in Metalink & Fast Track), two new functionalities in Metalink.
• 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 Forms and reports
• Developed PLSQL APIs for the Admin screens in the Metalink application

ENVIRONMENT: & TOOLS: Oracle PLSQL, Unix, HTML DB

Confidential

Oracle Apps Test Consultant

RESPONSIBILITIES:

• The assignment involved the preparation of Test Scenarios, Conditions and Scripts r Application Integration Testing for the different Modules
• 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 in the areas of Oracle telesales, customers online and email centre.

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

Confidential

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 (WIP) correction for assembly and machining shops and the introduction of stage wise WIP, 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 ERP structure by mapping of columns after discussion with legacy experts, data correction and controls tallying for the Datawarehouse
• Ported legacy data in the form of 46 flat file structures each 120 numbers for the time period of (around 80 GB of information - 600 tables)

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