Oracle Developer
Resume:
Anoop Veettil
Cell: 201-***-****
*******@*******.***
www.linkedin.com/pub/anoop-t-veettil/23/341/214/
SUMMARY
Overall 14 years of experience in complete software development life cycle
(SDLC) using Oracle (11g/10g/9i/8i/7.x). Worked as a Sr. Oracle Lead
Developer for mentoring team at onsite and offshore with active
participation in Database/data warehouse design, development, ETL
processing, modeling, reporting and database development administration
tasks.
. Over 13 years of extensive experience working with Oracle databases
(versions 7.x to 11g)
. Expert in Oracle 10g/11g PL/SQL programming and Database Development
Administration.
. Expert in database modeling like conceptual, logical and physical
models. Database physical schema designing and implementation.
. Extensive experience in designing the schema, performance tuning,
PL/SQL programming using Packages, Procedures, Functions, Triggers,
DDL, DML, Indexes, Views, materialized views, Enhancing database
performance, and generating ad-hoc reports with SQL*Plus.
. Expertise in latest PL/SQL programming features, optimize the query
performance (Bulk collect, bulk Binds, Materialized views, Inline
views, hints etc). Well versed with DBMS Packages DBMS_JOBS,
DBMS_SCHEDULER, DBMS_PIPE, DBMS_SQL, DBMS_STATS, UTL_MAIL and
UTL_FILE, DBMS_OUPTUT etc
. Good knowledge of Data warehouses/Data Marts, Dimensional modeling,
Star schema, Snowflakes, slowly changing dimensions etc.
. Performance tuning of the database queries using TKPROF, Explain Plan,
dbms_profilers etc.
. Expertise in supporting very large database application systems and
high volumes data
. Performance tuning by creating indexes and gathering table and index
statistics. partitioning large tables to maintain data in
systematically and improve the huge data retrieval performance
. Loading data between databases using Export, Import utility, data pump
and loading data from flat files to database tables using SQL*Loader
. Excellent knowledge of Oracle database tools such as Toad, PL SQL
Developer, Rapid SQL, SQL Navigator etc.
. In depth understanding of Oracle Architecture, memory and process
structures
. Experienced in working with Oracle Forms & Oracle Reports, Pro *C
. Experience in all the phases of the Data warehouse life cycle
involving design, development, analysis & testing of Data warehouses
using ETL, Data Modeling, Online Analytical Processing & reporting
tools
. Good amount of experience in Data modeling (Dimensional & Relational)
concepts like Star-Schema Modeling, Snowflakes Modeling, fact and
dimension tables modeling of data at all the three levels: view,
logical & physical
. Designed and developed Informatica Mappings to load data from Source
systems to ODS and then to Data Mart.
. Extensively used Power Center/Mart to design multiple mappings with
embedded business logic.
. Creation of Transformations like Lookup, Joiner, Rank and Source
Qualifier Transformations in the Informatica Designer.
. Created complex mappings using Unconnected Lookup, Sorter, Aggregator,
newly changed dynamic Lookup and Router transformations for populating
target table in efficient manner
. Experience in ETL tool like OWB, Informatica 6.2/5.1 developing
Mappings, Workflows, Transformations
. Exposure in handling different databases such as MS Access2002/2000,
and SQL Server 2000
. Domain expertise in Financials like Fixed Income, Derivatives, Cash,
Wealth management etc.
. Data modeling including conceptual, physical and logical modeling.
Forward and reverse engineering using ERwin
. Creation of logical and physical data models for OLTP.
. Thorough understanding of Dimensional Modeling, Forward/Reverse
engineering, Software Testing and Quality Assurance activities.
. Seasoned in using Unix editors and utilities vi, sed and awk etc
. Expertise in Korn-Shell scripting. Developed complex shell scripts for
running warehouse jobs that can generate automated emails
periodically. Extensively used job scheduling with Crontab for
different periodicity levels.
. Experienced in Operating System like Windows 98/2000/Xp/NT, Unix,
Solaris 10.
. Experience in Offshore Coordination whereby assisted many new system
studies along with project /client management & logical analysis and
design with PL/SQL batch processes in Development and Test area.
Possess excellent problem solving, inter-personal and communication
skills, proven self-starter capable of working on multiple projects
Education: Master of Computer Applications (MCA) - India.
Technical Skills
OperatingSystems&Servers: Windows 2000, XP / NT, HP-UX 9.0/10.0/11,Solaris
10,ISS 5.1, Apache Tomcat, Web logic, Web sphere, JBOSS
Databases : Oracle 11g/10g/9i/8i/7.0, MS SQL
Server 2000 / MS Access 2002/2000
Database /Dataware housingTools(ETL): Toad 9.2/8.6,PL/SQL Developer
7.1,OEM,ERwin7.0,Informatica 6.2/7.1,OWB,Designer 2000, SQL Navigator,
Rapid SQL
Other packages: MS office
Configuration Management Tool: Visual Source Safe, Synergy, WinCVS, PVCS
Tracker
Programming Languages: PL/SQL, SQL, Unix Shell Scripting, Pro
*C
PROFESSIONAL EXPERIENCE:
Estee Lauder Companies Inc, NY
(Jun 2011 -Till Date)
Role: Oracle database Architect/Developer
The Estee Lauder Companies Inc. is a manufacturer and marketer of skin
care, makeup, fragrance and hair care products. Its products are sold in
over 100 countries and territories under a number of brand names, including
Estee Lauder, Clinique, Origins, M.A.C, Bobbi Brown, La Mer, Smash Box,
Prescriptive and Aveda etc. It is also the global licensee for fragrances
and/or cosmetics sold under brand names, such as Tommy Hilfiger, Donna
Karan, Michael Kors, Sean John and Coach etc.
Responsibilities
. New Marketing and Ecom site database Architectural design, modeling
and implementation
. Support online database across the regions for various brands.
. Designing of Ecomm sites for various brands and their regions
. Designing new centralized repository for market analysis and business
reporting for each region.
. Create database schema, reporting schema for new markets across the
globe.
. Create tables, indexes, packages, procedures, functions etc.
. PL/SQL programming, performance tuning and query optimization
. Development DBA activities like, export, import, creating users,
tuning the queries etc.
Environment: Unix, Oracle 11g, Toad, SQL Navigator, SQL Developer, CVS,
SQL Developer data Modeler
ING Financial Services, NY
(May 2010 -Jun 2011)
Project: IDEAAL Data System
Role: Oracle database Developer/Development DBA
The IDEAAL( Integrated Data Environment for Access, Analysis and Leverage)
project is an integrated application platform that supports the business
groups finance, operations control, OIB Business management and Credit Risk
Management etc. for their new business enhancements and provides access to
transactional and static data for a streamlined and flexible reporting. The
system is an integrated platform for the ING trading data comes from
Bloomberg, Goldman, JPMorgan, Bank of New york etc.
Responsibilities
. Architectural design, data analysis, planning and implementation
. SQL and PL/SQL Programming, database administration and performance
tuning
. Data loading using SQL Loader.
. PL/SQL Performance tuning and query Tuning(Generating Plan Table,
Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, SQL
Trace, TKPROF etc)
. Create database tables, indexes, procedures, packages, functions and
other objects
. Handling database release to production for updating patches and new
enhancements
. Preparing unit test scripts, setting up a test environment and UAT
testing
. Database maintenance and DBA activities like, export, import, creating
users, tuning the queries etc
. Tuning of database objects by creating and usage of indexes and
gathering table and index statistics
. Develop Autosys job script to schedule the jobs
Environment: Unix, Oracle 11g, SQL * Plus, Toad, Rapid SQL, SQL Loader,
PL/SQL& SQL, SQL Developer data Modeler, CVS
UBS Financial Services, NJ
(Sep 2008 -May 2010)
Project: Enterprise Data Warehouse
Role: Oracle database Developer
UBS, one of the leading Global Banks and a major player in the Investment
Banking sector, provides Wealth Management Services (WM) to its clients
across the globe. The Enterprise Data Warehouse project is a central
repository in Oracle for all of the data that UBS processes for its wealth
management clients. It is a subject-oriented, integrated and non-volatile
collection of data in support of management's decision making process. This
enhances the value of operational business applications across the company.
Responsibilities
. Discussions with the business users to capture enhancements for
improvements in proposed system
. Responsible for data validations, partitioning, data loading for
different environment, feeding of live data and user acceptance for
data warehouse.
. SQL and PL/SQL Programming and performance tuning
. Actively involved in data profiling to ensure data quality of vendor
data.
. Involved in production support, to fix the bugs in production codes
testing
. Database maintenance and DBA activities like, export, import, creating
users, tuning the queries etc
. Tuning of database objects by creating and usage of indexes and
gathering table and index statistics
. Developed complex shell scripts for running warehouse jobs
Environment: Unix Shell programming, Oracle 11g/10g, SQL * Plus, Toad,
Rapid SQL, SQL Loader, PL/SQL& SQL, ERWin r7, CVS
AIG Investments, Wall Street, NY
(Aug 2007 -Sep 2008)
Project: Global Pricing System
Role: Oracle Database Developer
The Global Pricing System (GPS) is primarily responsible for pricing the
securities. Different AIG groups require accurate prices for the securities
they hold, they depend on GPS application for pricing these securities.
Responsibilities:
. Prepared Requirement Specification and database design document for
the new requirements.
. Discussions with the business user to capture enhancements for
improvements in proposed system
. Designing of tables and other database objects, creation, and testing
of scripts
. Written PL/SQL Stored Procedures, Functions and Packages and Triggers
to implement business rules into the application
. Worked with developers in trouble shooting and tuning code, recommend
code changes as needed to insure correct operation and performance of
PL/SQL programs
. Database maintenance and DBA activities like, export, import, creating
users and granting privileges, space allocation, tuning the queries
etc
. Extensive involvement in performance tuning and Query
Tuning(Generating Plan Table, Explain Plan, Optimizer with Hints,
Analyze, Indexing strategy, SQL Trace, TKPROF etc)
. Handling database release to production for updating patches and new
enhancements
. Involved in preparing unit test scripts, setting up a test environment
and unit testing the code
. Worked with business users, business analysts and architects to design
and document database objects to support application requirements
. Involved in build verification before dropping into QA/UAT
environments
. Unix shell scripting for invoking PL/SQL jobs
. Support all production oracle issues as needed and participate in
emergency on call support activities
Environment: Sun Solaris, Oracle 10g, SQL * Plus, Toad, Rapid SQL, SQL
Loader, PL/SQL& SQL, Business Objects, Clear Case
Weightwatchers Inc, NewYork
(Feb2007-Aug 2007)
Project: Apollo Database migration
Role : Oracle database Lead/Analyst
Weight Watchers is recognized as the leading name in safe and sensible
weight control. The project is to reengineer the Apollo 1.4 application and
migratethe database from oracle 7, Oracle 8i to Oracle 10g .
Responsibilities:
. understanding the core requirements of the Project and propose the
design model
. Identification of Entities, Attributes and Relationships and design
the logical/ physical model of the new order management system. The
database used is Oracle 10g
. Created staging models
. Unix shell scripting for invoking PL/SQL jobs
. Creation of DDL scripts using ERwin and complete compare with the
development databases.
. Writing database scripts to create tables, index, constraints,
sequence etc in both staging schema as well as the target schema.
. Writing PL/SQL code for the Database migration from Oracle7i/ 8i to
Oracle 10g.
. Make modifications to the already existing logical/ physical design
models and reflect the same in Dev Databases, based on the
enhancements in the application
. Developed Dynamic SQL & and worked with GTTs
. Integration and testing the Database objects with the Online
Application.
. Actively involved in data profiling to reduce risk involved in
integrating data for new applications, including the challenges of
joins and track data quality.
. Performance Tuning of PL/SQL code and Oracle Database objects to speed
up the Database migration and Online Data fetch.
. Writing test cases and testing the application using PL/SQL test
scripts
. Perform post implementation review and user notification
. Associated with DBA's in monitoring the performance related issues
using Explain plan, SQL Trace and TKPROF utility
. Frequent interaction to the business users
. Involved in build verification before dropping into QA/UAT
environments
Environment: Linux, Oracle 10g, SQL * Plus, Toad, Rapid SQL, SQL Loader,
PL/SQL& SQL, ERWin, Synergy
UBS Financial Services, NJ
(May 2006 -Feb 2007)
Project: Corporate Employee Financial Services
Role: Oracle database Developer/ Analyst
UBS, one of the leading Global Banks and a major player in the Investment
Banking sector, provides Wealth Management Services (WM) to its clients
across the globe. UBS WM USA through its CEFS application receives the
stock compensation related data from the clients(Companies).CEFS
application then processes it store in the database namely EO Win
Financial.
Responsibilities
. Involved as a lead to give guidance and monitoring the work allotted
for team members.
. Requirement gathering, Design, implementation, Unit testing and
integration testing
. Played an active roll in designing the architecture of the database
and designing the technical document for the business requirement
specified.
. Discussions with the business user to capture enhancements for
improvements in proposed system
. Responsible for data validations, feeding of live data and user
acceptance for each module.
. Designing of tables, indexes, triggers, and other database objects,
creation, and testing of scripts
. Written PL/SQL Stored Procedures, Functions and Packages and Triggers
to implement business rules into the application
. Actively involved in data profiling to ensure data quality of vendor
data.
. Involved in production support, to fix the bugs in production codes
testing
. Database maintenance and DBA activities like, export, import, creating
users, tuning the queries etc
. Shell scripting and scheduling Autosys jobs for invoking database
jobs
. Handling database release to production for updating patches and new
enhancements
. Prepared checklist, final design documents and general instruction to
follow during development
. Tuning of database by creating and usage of indexes and gathering
table and index statistics
. Performed role of code reviewer, integration lead and release manager
for the release components
. Involved in the deployment of code in Prod environment
. Played a very important roll in designing the technical document for
the business requirement specified.
Environment: Sun Solaris, Oracle 9i/10g, SQL * Plus, Toad, Rapid SQL, SQL
Loader, PL/SQL& SQL, CVS, Informatica
JP Morgan Chase, New York
(September 2004 - May 2006)
Project: IT Risk Management
Role: Senior Oracle Developer
Phoenix - ITRisk is an intranet application by JPMC for performing risk
analysis and mitigation plans of Applications and OSPs (Other Service
Providers). The primary objective of the system is to find out the risk
involving in the applications which are served by other service providers.
This application stores data about all other Applications and OSPs which
are used for JPMC business needs.
Responsibilities:
. Created logical and physical dimension models.
. Documented source/target mappings & metadata.
. The data regarding the participant, permissions, the owner
corresponding to the applications need to be maintained. Make
alterations to the data model to store the column display level at the
individual user level.
. Involved in writing procedural scripts using PL/SQL
. Working with Oracle databases to manage data for development, training
and production environments.
. Created database objects such as tables, views, synonyms, indexes,
sequences.
. Developing and Tuning SQL, PL/SQL triggers and stored procedures.
. Developed SQL *Loader scripts, conversion scripts for the conversion
of the data to the custom new schema
. Provided database support and worked closely with the development team
as they submitted daily changes recorded as releases to the production
database.
. Tuning database and SQL statements and schemes for optimal
performance.
. Tuning of database by creating and usage of indexes and gathering
table and index statistics
. Troubleshoot production problems and worked effectively with other
team members to identify and address problems.
. Analyzing database,tables, index
. Performed Application and SQL statement tuning using Explain Plan,
Optimizer Hints and Partitioning etc
. Developed shell scripts to run the batch jobs
Environment: Sun Solaris, Oracle 9i, SQL * Plus, Toad, SQL Loader,
Informatica, PL/SQL, SQL Server DTS
Project: SAM Data Conversion
The purpose of this project is to convert the key components of the old
application SAM (structured analytical model) to the new proposed TOP
environment WSO(wall street office). There are many data elements shared
between the new TOP environment and the legacy SAM environment. In order to
port all of the asset and historical information collected in the legacy
environment over the years some type of data conversion will have to take
place.
Responsibilities:
. Architect design for data conversion, Testing and Customer Support
environments
. Preparation of Technical Design Document as per the requirement.
. Designing of tables, indexes, triggers, and other database objects,
creation, and testing of scripts
. Developing code in PL/SQL, writing procedures, packages, triggers,
migration scripts etc.
. Tuning of database by creating and usage of indexes and gathering
table and index statistics
. Oracle database creation. Controlling and monitoring user access to
the database
. Reduce the number of un-planned Emergency change requests
. Writing test cases and testing the application using PL/SQL test
scripts
. Developed shell scripts to run the batch jobs
. Ensure the stability of the production environment
. Document all Change Requests and provide monthly metrics for review
. Perform on going process improvement
. Perform post implementation review and user notification
. Frequent interaction to the business users
Environment: Sun Solaris, Oracle 9i, SQL * Plus, Toad, Rapid SQL, SQL
Loader, PL/SQL, Informatica, SQL Server DTS
First American Corporation, CA (April
2003 - September 2004)
Project: First American Web Services & FAM Data Mart
Role:Oracle Developer
This is a web service system designed to meet the requirements of various
clients of First American Corporation. The system is basically an
information provider to the various clients, like banks, insurance, finance
etc.The FAM Data Mart is a Global Financial Reporting system for Mortgage
applications.
Responsibilities:
. Extensive involvement in Data Modeling and Design using ERwin
. The models were to be used in OLTP system for the Entry into FAS
project, where the statistics related to products need to be
maintained.
. Used ERwin DM to compare the model with the database, and to know the
differences and select which differences to move into the model and
which to generate to the database.
. Wrote stored procedures & functions using PL/SQL as per requirements
. Developed query by using Analytical functions
. Uploaded data comes from XML and Excel to DW
. Development of the DW -Extraction of data from disparate sources and
uploading the data after cleansing into the Data warehouse.
. Developed SQL and PL/SQL queries for Crystal reports/sub reports
. Worked with ETL developers on improving table design (e.g.,
demoralized fact tables)
and helped to populate reporting tables (e.g., fact, summary, and
dimension).
. Developed Informatica Mappings to load data into FAM Data Mart
. Extensively developed complex PL/SQL packages for ETL
. Optimizing Query performance using explain plan, SQL Trace and TKPROF
utility
. Performed unit testing and involved in system integration testing
. Involved in Production Support and Operations teams to resolve
production issues in a timely and efficient manner.
Environment: Linux, Oracle 9i, SQL * Plus, Toad, Rapid SQL, SQL Loader,
PL/SQL, Informatica
Paragon Solutions(FCG India), Bangalore
(November 2001 - March 2003)
Project: Parks and Recreation
Role:Oracle PL/SQL developer
Parks & Recreation Application is an n-tier architecture based web system
that is designed to meet the needs of the parks and recreational consumers
of local authorities in Boston. This software is designed for setup of
numerous events like rental space, sporting events, golf club, membership,
cemetery etc.
Responsibilities:
. Studying and Analyzing the Technical Feasibility of the Customer
requirement using Functional Design Document. Preparation of Technical
Design Document as per the requirement.
. Working with Oracle databases to manage data for development, training
and production environments.
. Created database objects such as tables, views, synonyms, indexes,
sequences and database links as well as custom packages tailored to
business requirements.
. Developing and Tuning SQL, PL/SQL triggers and stored procedures.
. Developed SQL *Loader scripts, conversion scripts for the conversion
of the data to the custom new schema.
Environment: Linux, Oracle 9i, SQL * Plus, Toad, Rapid SQL, SQL Loader,
PL/SQL
Bharat Electronics Ltd, Bangalore
(June 2000 - November 2001)
Project: Integrated Personnel Management
Role:Oracle PL/SQL developer
The Objective of this system is to capture online information of the
employees in the organization. The modules handles the details such as new
employees entry, training, wage revision, bank details, medical details,
family details, promotions, transfers, arrears calculations, retirements,
payments, tax details, increments, conveyance, insurance etc.
Responsibilities:
. Working with Oracle databases to manage data for development, training
and production environments.
. Created database objects such as tables, views, synonyms, indexes,
sequences and database links as well as custom packages tailored to
business requirements.
. Developing and Tuning SQL, PL/SQL triggers and stored procedures.
. Developed SQL *Loader scripts, conversion scripts for the conversion
of the data to the custom new schema.
Environment: Unix, Oracle 8i/7.x, Pro*C, SQL * Plus, SQL Loader, PL/SQL,
Crystal reports, Oracle Forms
Hindustan Aeronautics Ltd, Bangalore
(August 1999 - May 2000)
Project: Material Management & Request Planning System/engine Order
Assembly
Role: Software Engineer
This project handles various stocks in several stores of HAL division. It
includes all the features such as Stock control, Material Planning,
Scheduling, keeping track of material requisition, generating Material
Purchase requests, Raising Purchase Orders, Receiving Reports, etc.
Responsibilities:
. Involved in analysis, design and development of the system.
. Developed customized Forms like customer and supplier maintenance,
bill, receipt, invoice, debit and credit notes.
. Developed Reports and PL/SQL Packages to monitor revenue earnings and
expenses.
. Developed stored procedures and functions using PL/SQL for complex
updates and audit trails.
. Tuning SQL, PL/SQL triggers and stored procedures.
Environment: : Unix, Oracle 8i/7.x, Pro*C, SQL * Plus, SQL Loader, PL/SQL,
Crystal reports, Oracle Forms
Contact this candidate