• Over 3 years of professional experience in Information Technology with strong background in the Design, Development, Enhancement and Maintaining applications in Oracle 8i/9i/10g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX environments. Detailed depth Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
• Substantial development experience in creating PL/SQL Packages, Dynamic SQL, Procedures, Triggers, Functions and Cursors. Strong knowledge in Oracle cursor management and exception handling.
• Experience using Advance PL/SQL features like Tuning, profiling and analyzing codes.
• Experience generating and pulling data for Reports.
• Over 2 year of Professional experience in areas of ETL Design and ETL development in Data warehousing using PL/SQL Packages, Informatica Power Center 8.x/7.x.
• Experience in UNIX Shell Scripting.
• Experience in using modeling tools such as Erwin 4.0. (Logical and Physical) and Experience in system analysis, database design, Schema Design: RDBMS (Snow-Flake Schema), Data Warehouse (Dimensional model: Star Schema).
• Experience using version control through SVN.
• Used Tools like PL/SQL Developer, Toad, SQL Developer, Autosys in design and development
• Experience in functional and application knowledge of Finance, Insurance and Manufacturing Domain.
• Possess excellent communication and interpersonal skills with strong aptitude towards learning new technologies, Self-motivated with Positive mental and initiative attitude.

Certifications

Oracle 11g Advanced PL/SQL Developer Certified Professional.

Oracle 9i

Oracle PL/SQL Developer Certified Associate

Auto-Desk

Auto-Cad 2004 Trainee

Tools & Technologies

ETL TOOLS

Informatica Power Center 8.x/7.x

RDBMS

ORACLE 8i/9i/10g/11g, DB2, MS-SQL Server 2005, MS-SQL Server 2000 MS-Access

Languages

PL/SQL, SQL, ANSI SQL, T-SQL, JAVA, Perl

Scripting Technologies

PHP 5.0, HTML, XHTML, Java Script, CSS, UNIX shell scripting

Operating Systems

Mac Os X.5, UNIX (Solaris, HP-UX, AIX, Linux), Windows 98/NT/2k/XP, Windows Server 2003

Data Modeling Tools

Erwin 4.0/4.2, Microsoft Visio 2003

Methodologies

Software Development Life Cycle (SDLC), Ralph Kimball Methodology

Packages

MS-Office, MS Front-Page

Tools & Utilities

TOAD,SQL Navigator, PL/SQL Developer, SQL Loader, Auto-Cad 2004, Pro-E.

Front End Tools

Oracle Report 6i/9i

Tuning & Performance

EXPLAIN PLAN, TKPROF.

Confidential,May’08 Till Date
PL/SQL -Database Developer
Vensoft Inc is an IT consulting company located in Arizona.
Client:Confidential,
The Project was to develop the solution for its client that deals in Banking and investment market. I worked here as a Database developer to maintain the Database Systems for its IT Department. The company deals with many credit card, deposit, and Brokerage dealer account so the project was to maintain their Database and Data ware house and process the daily coming load from various vendors.
My role in this project was to code the PL/SQL to validate the files and tune the applications and to produce the output file for the Business user for the purpose of Reporting.
Responsibilities:

• To develop the Technical Specification Documents related to the Project.
• Involved in Architecture design for Data marts.
• Developed the Stored Procedures, Functions, Views.
• Wrote PL/SQL Scripts to load data into staging tables.
• Modified existing PL/SQL scripts.
• Tuned existing PL/SQL scripts. Procedures.
• Developed the Oracle Job to automate the Process.
• Used various features of Oracle 10g like DBMS_SCHEDULER.
• Tuned the SQL coding using Explain Plan.
• Developed Perl Scripts for Production Support.
• Modified the Procedures and Packages to meet the Business Requirements.

Environment: Oracle 10g, PL/SQL Developer, Windows XP, MS Office.

Confidential,
Responsibilities:

• Assisted in maintaining and improving ETL processing efficiency for improved data quality, impact analysis and data validation. Ensured data availability to the departmental data marts on a requirement-demand basis.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the Data mart. Analysed and created Facts, Dimension tables. Modelled the data warehousing data marts in Star schema.
• Develop ETL Packages through PL/SQL and used Informatica for transformations.
• Performance & Tuning of Existing Mappings and Workflows in Informatica.
• Created reusable mapplet and used them in mappings.
• Created reusable worklets and used them in workflows
• Develop Stored Procedures and Functions in PL/SQL.
• Used Unix Shell Script for Scheduling jobs.

Environment: Oracle 10g, Informatica 8.1, Unix, SQL*Plus, SQL Loader.

Confidential,
ADT Division,Chicago IL
Tyco International ADT Division deals in Home and commercial security system.
This Project was to develop “Scorecard” report. Project involves designing and developing there short term “Scorecard” report system with automating the process.
Responsibilities:

• Requirement gathering from the users and customers.
• Designing the Staging Schema for storing the source files.
• Designing and developing the Reporting Schema.
• Developed PL/SQL scripts to populate the Reporting Schema.
• Developed SQL Loader script to load files from the server to Staging tables.
• Developed Unix Shell Script to run the SQL loader.
• Developed Cron Tab Jobs to Automat Process.
• Developed PL/SQL stored procedure to load the Reporting Tables.
• Tuned the PL/SQL Scripts for better performance.

Environment: Oracle 10.2, Toad, SQL Loader, UNIX, and MS Office.

Confidential, Sep’05 Nov’06
Software/Database Developer
Confidential, is consulting company based in Banglore India. This System was developed for one of its client. The Purchase Order system has Master Maintenance module, Stock management module, Purchase Module and Report Generation module.
Responsibilities:

• Worked extensively on UI, business Logic and Data Access layers of the application.
• Designed and developed JSP pages.
• Implemented client side validation using Java scripts and AJAX.
• Used Java scripts for dynamic UI and browser compatibility tests.
• Assisted in design and development of Database system.
• Assisted in Data modeling.
• Created Logical data models for new system.
• Developed SQL scripts to validate incoming data.
• Developed PL/SQL Stored Procedure, Functions and Triggers for their reporting system Oracle Reports.
• Developed PL/SQL Stored procedure for modifying and pulling data through Forms.
• Developed various Forms for Intra users.
• Wrote Views to generate reports on daily basis.

Environment: JAVA, Eclipse IDE, Windows XP, J2EE, Java Script, HTML, XML, Oracle 9i, Toad, Oracle forms, Oracle Reports, Erwin.

Education

Master of Science
Bachelor of Engineering