Oracle Developer,Business Analyst,SQL Developer

. An Information technology professional with ** years of extensive

Information Technology experience in all phases of Software

development life cycle (SDLC) including System Analysis, Design,

Development, Implementation, Testing, Support, Maintenance of various

Applications in OLTP and OLAP applications

. Experience in oracle PL/SQL Programming using team development process

and Agile development methodology. Experienced in writing Materialized

view, SQL queries, SQL Loader, PL/SQL, SQL*Plus, performance tuning

using explain plan, SQL Trace etc.

. More than 7 years of experience in system architecture including

System design, Data Modeling, Database Design, OLTP, ETL, Erwin data

modeling, Star-Schema database design process

. Analytical, troubleshooting /problem solving skills with a strong

technical background and result oriented individual with excellent

written and oral communication and interpersonal skills. Demonstrated

ability to quickly grasp new concepts, both technical and business

related and utilize as needed

. Experience of working with offshore team and global/regional teams to

provide support to system including Production support, User

Acceptance Testing and demonstrating the product to the client and

training to the end user

. Good experience and domain knowledge of Finance, Pharmaceutical etc.

. Extensive experience in developing SQL queries, PL/SQL package, stored

procedure design, development, implementation, performance tuning.

Experience in data warehouse applications using PL/SQL jobs,Informatica ETL processes

. More than 7 years of experience of ORACLE,MS-SQL Server programming

using SQL, PL/SQL, creating packages, triggers, stored procedures,

tables, indexes

. Experience in UNIX Shell programming and creating scripts for

scheduling jobs, reorganization of tables and indexes

. Experience in working with other application programmers like .NET,

Java, Informatica to test and debug software enhancement and

experience in subversion tools Tortoise SVN and VSS,HP Quality Centre

|Technical Skills |

|Environments |MS-DOS, WINDOWS NT/98/95/2000/XP, LINUX |

|ETL |Informatica 8.1,Business Objects |

|RDBMS |ORACLE 10g/11g/9i/8i/7, SQLServer, MySQL |

|Languages |SQL, PL/SQL, T-SQL, C, C++, PowerBuilder |

|Data Modeling |ERWIN 4.0/3.5, Visio |

|Others |SQL*Loader, SQL*Plus, Toad, PL/SQL Developer, SQL |

| |Developer, Control M |

|Professional Experience |

Credit Suisse, RTP, NC 09/08 - Present

Sr. Oracle Developer

Projects: Concur Expense Management System:

Concur is vendor application implemented globally in Credit Suisse.

This system is used for tracking and reconciling employee business

travel and reimbursable out-of-pocket business expenses. Frontend is

developed in Java and backend database is Oracle.

Concur Data warehouse:

Concur Data warehouse is mainly used for reporting purpose. It is

developed using Informatica ETL tool and reports generated using

Business Objects. It consists of different kinds of report requested

by business users.

eProcurement System:

eProcurement system is implemented globally in Credit Suisse. It

allows user to create requisition for purchase all item. All the

procurement orders are prepared in this system and system generates

approval workflow and send approved requisition to PeopleSoft system

for PO generation. Front end is developed in .net and backend database

is Oracle.

New Business Database:

This system is implemented globally in Credit Suisse. It helps New

Business department to get approval for new business proposal from all

department and help project manager to maintain all the details of

project. Front end is developed in .net and backend database is

Oracle.

Overall Responsibilities:

. Managing the relationship with the business partners translating their

requirements into clear definitions of system requirements or

enhancements that met their objectives.

. Worked with cross-functional teams to design and execute system test

plans to identify and resolve application issues

. Work with Internal and External auditor to perform IT Risk analysis,

System access reviews,provide satisfactory resolution to queries and

implement recommendations based on their findings

. Generate required system documents including Technical specification,

Design specifications, Unit Test Case

. Create/Modify database objects like Stored Procedures, Triggers,

Functions, Packages to effectively incorporate Business logic

. Coordinated with source system owners, day-to-day ETL progress

monitoring, Batch Job, Data warehouse target schema design and

maintenance

. Develop and implement standards for data naming and database design

. Designing the Database Tables/Indexes and other database objects

. Maintained warehouse metadata, naming standards and warehouse

standards for future application development

. Tuned slow running queries and stored procedures that cause lot of

Disk-Reads, created indexes and correcting joins and sub-queries to

meet performance requirements with Query Rewrites

. Production support as well as maintenance/enhancement in system and

release database code to production after getting Signoff from

Business

. HP Quality Center for maintaining defects and resolved defects by user

. Acted as the liaison between various delivery teams for hardware,

storage, and DBA technical support coordinating those resources

Functional Responsibilities:

. Development of database code and design of the data model using Erwin

support the user requirements of the Concur Expenses, New Business

Database & Eprocurement system

. Work closely with analysts to understand business requirements and

translate into design

. Work closely with the test team to support the component and

acceptance test phases investigating and resolving defects

. Agreeing and enforcing development standards and quality control

procedures

. Perform Database performance Tuning of slow running queries and modify

database code to improve performance

. Attend Meeting with Business Users for new development and

modification in existing system

. Work with Business Object admin team for setup new user data per

missioning, security and generate report from data ware house

environment using Business Object as per ad hoc request received from

Business admin

. Work with Front End Developer(Team Member) to modification required in

system

Environment: Oracle 10g/11g, PL/SQL, SQL*PLUS, Informatica, Tortoise SVN,

Business Objects, Control M, UNIX, HP Quality Center, Java,

Toad

Comcast, Philadelphia, PA 03/08 - 09/08

Oracle PL/SQL Database Analyst

Project: Comcast is largest provider of cable services and one of the

world's leading Communication Company. I did work on video on demand

project as Oracle PL/SQL Database Analyst. This system allows user to

select and browse the different category of films and select them using the

remote control. This system has been designed to implement all over USA. It

is designed using Oracle and Java by Sun Microsystems. I am working in

database team as oracle developer.

Responsibilities:

. Prepare Test Plan & Results for stored procedure and packages

. Discussion with Developers regarding new development and modification in

existing systems

. Database objects Code review

. Developed Stored Procedures, Functions, Trigger, PL/SQL scripts. Database

was implemented in RAC architecture

. Performed Database Performance tuning for long/slow running queries,

increasing performance of Database

. Analyze requirements and document potential solutions. Attend regular

stand up meeting within team and business for regular updates

. Responsible for schema design, schema changes, creating views as per

discussion with Tech Team

Environment: Oracle 10g, PL/SQL, SQL*PLUS, Pl/SQL Developer, UNIX

ETS, Princeton, NJ 11/07 - 02/08

Oracle Developer

Project: ETS is a nonprofit institution advancing quality education with

valid educations testing, curriculum development assets and test prep

products. I am working on NBPTS Reengineering project as Oracle PL/SQL

Database Analyst. This NBRIC system allows candidates/organizations to

register themselves for assessment which is done by NBPTS.This system will

store their information regarding scoring of their exams conducted by

NBPTS.This system will help candidates to get certified for teaching which

is acceptable in almost all the states in USA.

Responsibilities:

. Developed Stored Procedures, Functions,Trigger, PL/SQL scripts

. Created a new database schema and migrated/copied all the database

objects from old schema to new schema and validated them

. Discussion with Developers regarding new development and modification in

existing systems

. Used Erwin for maintaining database model

. Perform the Database Impact Analysis for Database related changes

. Worked on Agile methodology for Development process

. Responsible for schema design, schema changes, creating views as per

discussion with Architecture

. Performed Database Performance tuning for long/slow running queries,

increasing performance of Database

Environment: Oracle 10g/9i, PL/SQL, SQL*PLUS, SQL Developer, Win 2000,

UNIX, Erwin

BASF Chemical, Dover, NJ 06/06 - 10/07

ETL/Oracle Developer

Project: BASF has an enterprise wide data warehouse system (EDW), which

acts as the data source for various systems. Using Oracle PL/SQL scripts

data is populated from EDW into the SFA system using nightly jobs. PL/SQL

scripts perform various tasks like data cleansing, data validation, and

data aggregation etc., before loading data into the SFA system. SFA system

keeps track of essential customer information like Contact, Lead, Follow-up

and Sales orders related information etc. This system also includes some

advance features for sales forecast, order management etc., this ensures

that sales efforts will not be duplicated.I had worked on different

projects including CRM Support, Engelhard Acquisition and G-KAM (Global Key

Account).

Responsibilities:

. Primary production support for CRM support

. Managed Offshore team for development, testing efforts

. Developed Stored Procedures, Functions,Trigger, PL/SQL scripts

. Prepare Technical Specification and Test Plan & Results for pl/sql

jobs

. Follow IPEC standards for Software Project Management

. Discussion with Business users regarding new development and

modification in existing systems

. Perform the Database Impact Analysis for Database related changes

. Used Documentum for maintaining project documents

. Developed Dynamic SQL to build Complex Queries

. Performed Database Performance tuning for long/slow running queries,

increasing performance of Database

. Developed Unix shell scripts to automate the data export process

. Import data from flat files to Oracle database for Engelhard

Acquisition

. Used different oracle packages in PL/SQL Programming

. Used UTL_FILE for converting Oracle database data to rtf file and text

files for G-KAM project

. Used SQL,PL/SQL for Data Cleansing, Data Aggregation before populating

to data warehouse

. Create/Modify existing Nightly data loading schedule as per

requirement

Environment: Oracle 10g/9i, PL/SQL, SQL*PLUS, SQL*LOADER, TOAD, Windows

2000, UNIX

Playersarena sportswear Inc., Toronto, Canada

01/05 - 03/06

Developer

Playersarena.com is one of the leading online e-commerce web portals for

sports apparel; equipment and accessories. They are selling license sports

apparels, equipment and accessories. It has a largest network of 20

distributors all around Canada and USA.

Responsibilities:

. Involved in the requirements definition and analysis for the data

warehouse project

. Interpreted the logical and physical data models for business users to

determine common data definitions and establish referential integrity

of the system

. Extensively used PL/SQL programming in functions, procedures, packages

to implement business rules.

. Wrote SQL, PL/SQL codes, stored procedures, tuned database triggers,

queries

. Managed performance tuning of various sessions, reducing processing

time

. Responsible for daily verification that all scripts, downloads, and

file copies were executed as planned, troubleshooting any steps that

failed, and providing both immediate and long-term problem resolution

Environment: Oracle 8.x/7.x, SQL, PL/SQL, TOAD, ERWIN, Windows 2000, MS

Access

NIRMA Limited, Ahmedabad, India 09/02 - 08/04

Developer

Procurement Management System:

This includes complete Procurement Module. Main features include Indent

generation, Inquiry Preparation, Quotation Comparison, Purchase Order

Generation; Amendment of existing PO's and Reports includes Quotation

Comparison, Purchase Register, Inquiry Letter Printing, MIS Reports, All

major Item Master and Vendor Listings. This system is implemented in

client/server architecture.

Inventory Management System:

This includes complete Inventory Module. Main features include Indent

generation, Stock Transfer, Material receipt voucher, Material Issue

Voucher and Reports includes Stock Statement, Stock Movement Register,

MIS Reports,Master reports includes item and Vendor Listings. This

system is implemented in client/server architecture.

Responsibilities:

. To design database structure and user interface

. Developed Data Transfer utility using data pipeline utility

. Developed auto e-mail facility for Inquiry Letter Generation

. Implementation of Inventory Management system at various locations of

Organizations

. Performed database activities including database design, data

migration, writing stored procedures, import/export data and backup

of database

. Used PL/SQL programming in functions, procedures, packages to

implement business rules

. Used ERWIN data modeling tool for creating database design

. Designed concept for Nirma Enterprise Application (ERP Project),

which is developed in Forms 6i

Technologies/Platforms: PowerBuilder 7.0 and Oracle 8.04,

ERWIN, Windows-NT

Zydus Cadila HealthCare Ltd, Ahmedabad, India

09/00 - 08/02

Developer

C&S (Consignee and Sales) System:

This online system is developed in PowerBuilder 7, MS- SQL Server 7.0

using 3 tier architecture using VSAT technology. This system consist of

all C&S transaction includes Order entry, Auto invoice generation, Stock

issue,Stock receipt and Stock transfer,Credit note, Debit note

transaction and finance module. This system also contains various reports

like Order Printing, Invoice Printing, Credit/Debit Note Printing,

Inventory related reports and master reports like vendor listing, product

listing.

Key feature of C&S System:

. This online system helps to monitor all the C&S operations

effectively in both H.O. as well as C&S agents location

. This system is implemented in 3 tier-architecture using VSAT

Technology

Responsibilities:

. Uploading data from legacy system to MS-SQL Server 7.0

. Managed implementation team to install C&S system more than 10

locations across India

. To design database structure and user interface

. Developed various sales and Inventory reports

. Developed Inventory related transactions

. Developed Technical Manual and User Manual

. Implemented C&S system more than 9 locations nationwide

. Involved in end user training and developing technical manual, user

manual

. Extensively used PL/SQL programming in functions, procedures and

packages to implement business rules, worked with DBA for SQL query

tuning

. Involved in testing, debugging, performance tuning, bugs fixing and

documentation of the system.

. Used Visio for system design

Environment: PowerBuilder 6.5/7.0 and MS-SQL Server 7.0, Visio

|Education and Certifications |

Bachelor of Science from Gujarat University, Ahmedabad, India

Advanced Diploma in System Management, NIIT, India

Informatica Designer Certification

Masters of Science in Info. Mgmt. -Project Management from Grantham

University (Cont.)

|Reference on request |

[pic]

[pic]

Contact this candidate