Post Job Free

Resume

Sign in

Oracle PL/SQL developer

Location:
Merrimack, NH, 03054
Salary:
70000
Posted:
March 31, 2009

Contact this candidate

Resume:

Dhivya Kaliappan

** ******* *****

Merrimack, NH 03054

Cell: 603-***-****

jq6p7a@r.postjobfree.com

PROFILE

Over 4 years of experience in the IT industry working on varied technologies and functional platforms for enterprise scale and medium scale development projects. Hands-on experience in working with virtual teams in an onshore-offshore project structure. Highly motivated individual willing to put in extra hours to get the job done with ability to work on multiple projects simultaneously and with a proven track record of on time on schedule delivery. Specialization in database technologies including Oracle and SQL server.

SUMMARY OF QUALIFICATIONS

 4 years of professional experience in the IT industry as a Software Engineer with core focus on Oracle Technologies.

 Oracle Certified Associate (OCA) with solid experience in Database design including

o Database side : Oracle (9i & 10g) PL/SQL, Triggers, Packages, procedures

o Front end : Oracle Forms, Performance tuning

 2 years hands on experience in HP Peregrine Service Management Tools

 Subject matter expertise in ITIL processes, Software Asset Management (software license management and software recognition) and IT asset management.

 Experience with all phases of Software Development Life Cycle (SDLC).

 Dedicated and hard working individual with great passion for relational database technologies.

PROFESSIONAL EXPERIENCE

 Fidelity Investments: Software Engineer, May ’07 - Present

 Worcester Polytechnic Institute: Research Assistant, Jan ’07 – May ’07

 Cambridge Solutions: Software Engineer, July ‘04 – July ‘06

EDUCATION AND CERTIFICATIONS

 Master of Science in Information Technology, Worcester Polytechnic Institute (GPA 3.87)

 Bachelor of Engineering in Electronics and Communications, University of Madras, India

 Professional OCA (Oracle Certified Associate) certification

 ITIL foundation Certification

 Certification in UNIX, C/C++ from SSI, Chennai, India

TECHNICHAL SKILLS:

 DBMS/RDBMS: Oracle (9i & 10g), PL / SQL, SQL server 2005, MS Access

 IDE/Data Modeling: TOAD, SQL Developer, MS Visio

 ITIL/ITAM technologies: HP Peregrine AssetCenter (4.4 & 5.2), Connect-IT (3.2 & 3.5), PPMC/ITG Central, HP Enterprise Discovery

 Web Technologies: IIS, HTML, Dreamweaver

 Reporting Tools: Crystal Reports

 Programming Languages: SQL, PL/SQL, Java, VB Script, Batch Scripting, C++, UNIX

 Project Management/Productivity Tools: MS Project, MS Office, SharePoint

PROFESSIONAL EXPERIENCE

Organization: Fidelity Investments

Enterprise Asset Management May 2007 – Present

Fidelity Investments manages its physical, financial and contractual aspects of all IT (HW & SW) assets with the help of HP Peregrine Tool AssetCenter. Managing the assets from procurement to retirement helps to optimize costs, mitigate security, compliance risks and drive business decisions. The application captures the complete lifecycle of an asset from procurement to retirement and assists Fidelity to track the IT assets within the organization.

Responsibilities

o Developed and customized AssetCenter user interface, pages, wizards, workflows, access restrictions, Connect-It scenarios and Crystal Reports according to business requirement.

o Developed Oracle Packages, Procedures, Functions, Views, Tables, Jobs, DB Links and Triggers for various Asset Center projects on Oracle 9i/10g.

o Participated in database design, performance tuning and schema development.

o Was responsible for maintaining the software recognition mapping data for Fidelity

o Interacting with the users for requirements gathering and resolving incident tickets.

o Responsible for resolving all the Access requests to AssetCenter client submitted by users across various business units.

o Business analyst for Systems Requirement/End User documentation, interpretation of business requirements, communication.

o Responsible for maintaining the intranet website for Enterprise Asset Management.

o On shore technical support

Organization: Worcester Polytechnic Institute

Management Department Jan ‘07-May ‘07

Worked as a Research Assistant in the Management department under Professor. Diane Strong.

Responsibilities:

o Conducted Oracle lab sessions and labs for undergraduates

o Assisted Professor in conducting Database course and in grading assignments

o Did research of various functionalities and tested various Oracle 11i business suite lab modules.

o Participated in the database design for an internal research project of WPI

Organization: Cambridge Solutions

Client: Dietiker, Switzerland

GBS Argus Dec ‘04 – August ‘06

ARGUS is an enterprise application developed with Oracle 10g technologies for commodity trading. It has got a wide range of features like Screen and Menu Generator, Document Management and Multi-lingual/ currency handling. The Software is specific for companies buying and selling raw materials. The management of these commodities needs software to control and react on the ongoing changes in financial management, market fluctuation, and supply chain and transport information.

Responsibilities:

o Development and unit testing of the document management module.

o Made extensive use of TOAD and developed complex database packages, functions and procedures.

o Participation in database design and schema development.

o Create technical and end user documentation.

Client: Wyoming Department of Family Services

Integrated Resource Information Systems (IRIS) July ’04 to Dec’04

Integrated Resource Information Systems (IRIS) is a web-based application for the State of Wyoming. This system is developed on an n-tier web based application model. It will provide services for all State Medicaid programs. The system is designed with @Vantage Framework, using AJAX and Servlets. This Framework is the Basis for implementing Eligibility System for different states like Tennessee as VIP (THE VISION INTEGRATION PLATFORM), Massachusetts as BEACON, Wyoming as IRIS

Responsibilities:

o Developed and tested various functional windows (capturing pregnancy and citizenship information) and used Eclipse for Java coding

o Database table design to suit the Application requirement

o Involved in Performance Tuning of the IRIS System, such as SQL Tuning, Code reviews to optimize the performance.

o User documentation for business rules

Immigration status:

Authorized to work in the US.



Contact this candidate