Oracle PL/SQL developer

EDUCATION:

Bachelor Of Technology, Computer Engineering

Model Engineering College, Cochin University of Science and Technology, INDIA

CERTIFICATION:

OCA – Oracle Certified Associate

TECHNICAL SKILLS:

Languages : PL/SQL, Visual Basic, ASP, XML/XSLT, JavaScript, HTML, Unix Shell Scripting, Perl

Database : Oracle 8i/9i/10g, Microsoft SQL Server 7

Tools : Informatica, OWB (Oracle Warehouse Builder), TOAD, PL/SQL Developer, Erwin, MS Access, SQL*Loader, Crystal reports

Platforms : Windows/NT/2000/XP/2003/Vista, UNIX, MAC OSX

EXPERIENCE

System Analyst Dec 2008- Present

Birlasoft, Edison, NJ – Working with their client MetLife to setup ETL feeds from multiple MetLife vendors through NSCC.

Programmer Analyst Nov 2007- Nov 2008 (12 Months)

Circuit City Stores Inc, Richmond, VA - Worked on the design and development of the marketing database.

Programmer Analyst Oct 2006 – Nov 2007 (13 Months)

Marlabs, Edison, NJ – Designing, developing and implementing database solutions for clients in US.

--> Circuit City Stores Inc - Worked on the design and development of the marketing database.

--> Verizon – Worked on the HR database.

Programmer Analyst Feb 2003 – Sep 2006 (43 Months)

Infosys Technologies Ltd, Bangalore - Worked for multiple clients onsite and offshore.

--> Intel Technologies Ltd. – Development of web site reseller.intel.com.

--> Apple Inc. – Design, development and implementation solution for Apple sales datawarehouse.

--> ABN AMRO - Maintenance of North America region mortgage database.

Projects

1. Project Name: MetLife- New Vendor ETL feeds

Employer: Birlasoft, Edison, NJ

Role: Programmer Analyst

Dec 2008 - Present

Description of the project

MetLife is the largest leader in savings and retirement products and services for individuals, small business, and large institutions.

The Project involved in processing Variable Anuuities and Variable Life files from partner firms of MetLife. This involved data modeling, schema design, writing packages in Oracle 10g and UNIX shell scripts.

Responsibility

- Support partner firms regarding electronic transfer of Asset Pricing, Positions and Values, Financial Activity Reporting through the National Securities Clearing Corporation (NSCC).

- Communicating with broker dealer back office to setup new electronic data sent via NSCC or proprietary feed to MetLiIfe.

- MetLife database for tracking Broker Dealer was in Oracle 10g hosted on Unix.

- Testing and implementation of all NSCC trading partners.

- Exceeded service goals in a fast paced, high volume atmosphere dealing with time sensitive financial transactions and information sharing.

- Develop and test automation processes for efficiency gain and eliminate manual intervention where appropriate.

Environment: Windows 2000 Software: AIX UNIX, ORACLE 10g

2. Project Name: Circuit City – Direct Marketing

Employer: Circuit City, Richmond, VA

Role: Programmer Analyst

Jan 2007- Nov 2008 (23 Months)

Description of the project

Circuit City was the second largest consumer electronics retailer in the United States

The Project involved in processing campaigns, contract, warranty, customer information for getting marketing information and targeting customers for marketing based on their history. This involved data modeling, schema design, writing packages in Oracle 10g and UNIX shell scripts.

Responsibility

- Extensive use of Unix Shell Scripts, Cron jobs and Autosys to automate process.

- Used PL/SQL to create Packages, Functions, and Procedure.

- Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.

- Involved in testing the application for Oracle 9i to 10g upgrade.

- Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.

Environment:

Windows 2000 Software: AIX UNIX, ORACLE 9i/10g

3. Project Name: AWARE – HR Database for Verizon

Client: VERIZON, Dallas,TX

Employer: Marlabs

Role: PL/SQL CONSULTANT

Oct 2006- Dec 2006 (3 Months)

Description of the project

Verizon Communications Inc, is a leader in delivering broadband and other communication innovations to wireline and wireless customers.

The Project involved applying business logic for handling the HR database of Verizon for processing and analyzing data in the AWARE (Advanced Workforce Analysis and Reporting Environment). The front end for this system is using ASP.

Responsibility

- Involved in the Requirement analysis, Design, Development & System Integration testing.

- Prepared Technical Specifications from the Business Requirement Documents.

- Produced Schema Design using – ERWIN.

- Used PL/SQL to create Packages, Functions, Procedure, Cursors and Triggers

- Used PL/SQL to create ETL packages for flat file loading and error capturing into log tables.

- Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.

- Was involved in coding the ASP front end for this project.

- Utilized UTL_SMTP to send email notification on program success and failure.

- Windows batch files were used for automating the scripts.

Environment:

Windows 2000 Software: AIX UNIX, ORACLE 8i

4. Project Name: La Salle – Mortgage Data Capture (North America)

Client: ABN AMRO, Troy, MI, US

Employer: Infosys

Role: Programmer Analyst

Apr 2006- Sep 2006 (6 Months)

Description of the project

ABN AMRO is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and mortgage products and services.

The Project is about implementing PL/SQL packages and modifying the database schema for processing and analyzing data to capture mortgage underwriting data from across USA to a central Data Warehouse.

Responsibility

- Served as a liaison between the Business and Technology Department (Client Side). Enhanced communication lines between executives, managers, and peers.

- Conducted Requirement analysis, Design, Development & System Integration testing.

- Prepared Technical Specifications from the Business Requirement Documents.

- Used PL/SQL to create Packages, Functions, Procedure, Cursors and Triggers

- Designed and developed Informatica mappings to resolve complex business requirements.

- Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Autotrace, Hints to reduce the response time.

- Involved loading data to tables, loading data to staging area using SQL Loader.

- Done performance analysis & tuning of queries to handle the large volume of data received everyday for fast retrieval. Optimized the performance by analyzing the different queries run by the system.

- Good knowledge on Mortgage Process.

Environment:

Windows 2000 Software: AIX UNIX, ORACLE 8i, Oracle 9i, ASP.net

5. Project Name: Enhancements for iTunes Music Store

Client: Apple Computers Inc

Employer: Infosys

Role: Software Engineer

Feb 2005 – Mar 2006 (13 Months)

Description of the project

Apple Computer, Inc. is an American computer technology corporation Headquartered in Cupertino, California. Apple develops, sells, and supports a series of personal computers, portable media players, computer software, and computer hardware accessories. The company's most well-known products are the Apple Macintosh line of personal computers, the iPod portable music player, and the iTunes media player.

The Project is specifically for the design and modeling of Data Warehouse modules for iTunes Music Store Data Integration to their Global Sales DW. This included understanding of their Sales Order Life Cycle and working of the Apple iTunes Music Store. Also used XML and XSLT to send XML data to Europe Artist society for Royalties.

Responsibilities:

- Understanding Business Requirements for doing an Impact Analysis on the Apple Global Sales DW for all enhancement requests.

- Module Lead with 6 members.

- Creating and using PL/SQL packages extensively for data processing and analysis. Some examples of utilities written are:

--> Packages for monitoring frequency and volume of data flow.

--> Packages for parallel processing of data using Oracle AQs.

--> Flat File loader scripts for Synchronization of iTunes sales data.

- Creating UNIX Shell Scripts for flat file processing and wrapper jobs to call PL/SQL packages.

- Tuning of all queries used in DW using Explain Plan.

- Creating XSLT scripts to present data in XML format from DW to Artist Societies in Europe.

- Developed code in XSLT to generate XML data to be sent to Europe artist society.

- Used various transformations like Source Qualifier, Aggregator, Update, Filter, Expression, Lookup, Stored Procedure, Joiner, Sorter, Router and Sequence Generator to get things done in JCM.(ETL Tool compatible with MAC OSX).

Environment:

MAC OSX, Software: ORACLE 9i, XML/XSLT

6. Project Name: Global Sales Data Warehouse

Client: Apple Computers Inc

Employer: Infosys

Role: Software Engineer

Mar 2004 – Jan 2005 (10 Months)

Description of the project

Apple Computer, Inc. is an American computer technology corporation Headquartered in Cupertino, California. Apple develops, sells, and supports a series of personal computers, portable media players, computer software, and computer hardware accessories. The company's most well-known products are the Apple Macintosh line of personal computers, the iPod portable music player, and the iTunes media player.

The Project is specifically for the design and modeling of Global Sales Data Warehouse to handle the data coming from SAP and presenting this data to downstream data marts for OLAP. The Data Warehouse was designed for handling volume of 100K messages per hour from SAP.

Responsibilities:

- Prepared software requirement specifications, business rules interacting with business units and designed Star schema, logical and physical database design for Domains.

- Coding Using PL/SQL and UNIX Shell Scripts.

- Package for Backlog processing.

- Package for Daily Summarization.

- Package for Close of Business processing.

- Introduction of change layer in the Data Warehouse database schema.

- Developed various mappings & mapplets to load the data from various sources using different transformations like Source Qualifier, Expression, Look up, Aggregate, Update Strategy, Joiner, and Filter to store the data in staging area/target table.

- Developed multiple workflows for initial loading, historical data loading, backup and shutdown.

Environment:

Windows NT, Oracle 9i, INFORMATICA 6I (ETL TOOL)

7. Project Name: Intel Channel Reseller Data Warehouse

Client: Intel Technologies Ltd.

Employer: Infosys

Role: Software Engineer

Feb 2003 - Feb 2004 (13 Months)

Description of the project

The Project is about designing and coding for the Intel website reseller.intel.com.

This involved detailed study of the client requirements, interaction with the end-user, creation of the Software Specifications, design, build, testing and deployment.

Responsibility

- Involved in the Requirement Gathering, Analysis, Design and Development of the schema.

- Involved in providing solutions for the client requirements

- Involved in creating XSLT and CSS to parse through XML to provide the content for the website resller.intel.com

Environment:

Windows NT, Software: ASP.net

Personal Details:

Age : 28

Marital Status : Married

Nationality : Indian

CONTACT Details:

Email : *****.*****@*****.***

Cell : 201-***-****

Contact this candidate