Analyst Database Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Joy Kaur

Phone: 571.244.9876
joy.kaurs@hotmail.com

PROFILE:

·         6+ Years of IT experience as a Database Programmer/Analyst with several complete project life cycles including Systems Analysis, Design, Development, Testing, Implementation, Production Support and interaction with the Business/Requirement Analysts and End users.

·         Expertise in Oracle 10g/9i/8i SQL, PL/SQL Programming.

·         Experienced in developing Tables, Stored Procedures, Functions, Packages, Views, Cursors and Database Triggers.

·        Performed SQL Tuning using Oracle Explain Plan, Hints and Indexes.

·         Experienced in developing batch programs by using PL/SQL and shell scripts and in using SQL*Loader for loading data from flat files into Oracle tables.

·         Knowledge of the Software Development Life Cycle (SDLC)

·         Designed and developed Business Intelligence reports using Oracle Discoverer, Oracle XML Publisher and Oracle reports.

·         Working knowledge of writing Batch Jobs using Shell Scripts.

·         Used Oracle UTL_SMTP packages to send out night automated emails.

·         Excellent communication skills and a good team player

·         Highly motivated self-learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

EDUCATION:

MS in Computer Science from Swamy Ramanand Teerth University, Nanded, Maharashtra, India -2001

TECHNICAL SKILLS:

Operating Systems                    : Windows (XP/2000/NT/98/95), Unix/ Sun Solaris 8
RDBMS                                    : Oracle 10.2.0.4/10.2.0.1/ 9.2.0.4/9.2.0.1
Tools                                        : Quest Toad, SQL Navigator, Sql Developer, Sql Loader,

Rational Clear Quest, Subversion, WinSCP, Putty
GUI                                           : Visual Basic 5.0, Forms 4.5
Reporting Tools                          : Oracle XML Publisher, Oracle Reports Builder 10g 

                                  Oracle Discoverer Reports 4i
Languages                                : SQL, PL/SQL

TECHNICAL TRAINING/CERTIFICATIONS:       

·         Oracle PL/SQL Training  (Oracle Corporation, Reston).

·         Oracle Reports Builder Training (Oracle Corporation, Reston).

·         Oracle XML Publisher Training (Oracle Corporation, Reston).

·          

EMPLOYMENT HISTORY:

Oracle Developer, CDM (Camp Dresser and Mc Kee) Chantilly, VA            03/09 - 06/11

CDM is a consulting, engineering, construction and operations firm which caters to Federal Government. CDM executes projects all over world. The HERC application was designed and developed using Oracle eBusiness Software. The application gets data feeds from various offices all over the world and these project details and invoices are loaded to run weekly/monthly reports. This system is a new accounting model for tax sub ledger accounting systems ensuring that all the monthly transactions receive the correct accounting treatment and right ledger file is sent to PeopleSoft.

Responsibilities

·         Worked very closely with the Accounting and Procurement team of CDM.

·         Involved in designing and developing reports using Oracle Discoverer Reports and Reports Builder.

·         Designed and Developed PLSQL program units (Tables, Views, Procedures, Packages)  to automate the voucher creation process.

·         Loaded Data files into oracle database using Oracle Sql loader. Wrote PL/SQL program units to process calculations on the data loads.

·         Worked on the weekly process that involved analyzing MS Access Data, Loading into the Oracle Database, fixing any data issues and generating ad-hoc reports for Accounting, Procurement, Project administrators.

·         Worked on Costpoint database (accounting tool) and creating impromptu reports (Cognos) for accounting group. Involved in generating weekly invoices for various projects.

·         Involved in redesigning General Ledger Financial reports which were developed in Oracle Discoverer into Oracle Business Intelligence Tools. Oracle XML Publisher.

·         Wrote Test Cases for Back end testing and executed those using SQL Queries.

·         Wrote Korn shell scripts to run Batch jobs.

·         Involved in migrating database code to Production environment and provided production support.

·         Used UTL_SMTP package to send out nightly emails with reports, audit reports etc.

·         Performed backend testing using SQL queries for validating the test case results

·         Used Subversion for Source Code Control.

·         WinSCP was used to SFTP to the servers.

·         Also worked as Project setup admin as back up using Oracle E-business.

·         Involved in development of Test Plan and Test Cases from Functional Requirements, Technical Specifications and Use Cases.

Environment: Oracle eBusiness 11i, Subversion, Oracle Discover Reports 4i, Oracle Reports Builder 10g, Oracle XML Publisher 5.6, PL/SQL, Sql, Sql Loader, Windows NT, Quest Toad, Shell Scripting, WinSCP, Putty

Oracle Developer IrCa, Fairfax, VA                                                                 1/08 - 3/09

K-Bar is an online based website that gives a graphical representation of a property and its neighborhood. Every month we get data from MLIS (Multiple Listing Agency) , this data represent all the homes sold in the VA, DC and MD area.  The application uses this data to come up with a home price and price of homes in the neighborhood. The members can also view information regarding the schools, age of the home, lot size etc.  You can visit www.k-bar.net. The K-bar was a framework which was designed keeping in mind to use the same graphical approach for other fields like finance, school rating etc.

Responsibilities

·         Interacting with Business users, gathering and analyzing requirements.

·         Created Tables, Views, Sequences and other database objects.

·         Created PL/SQL packages, procedures and functions that extensively used PL/SQL cursors, user defined object types, exception handling.
Loaded data into the Tables using Sql Loader.

·         Active involvement in Optimization Process through creation of materialized views, partitions, tables, views, indexes etc as.

·         Tuned and optimized SQL statements.

·         Used Toad, PL/SQL Developer Tools for faster application design and developments.

·         Created Audit and Error Logging package to capture Audit and Error details throughout the application.

·         Involved in preparing Unit tests and testing the application.

·         Developed Shell scripts to automate Sql Loader Scripts.

·         Extensively used hints and explain plan tables to optimize sql queries.

Environment: Oracle 9i, PL/SQL, Sql, Sql*Loader, Windows NT, Quest Toad, Shell Scripting.

Oracle Consultant, MDS Pharmaceuticals, Des Moines IA              03/06 – 01/08     

MDS Pharma Services is the premier provider of innovative drug discovery and development solutions, offering a full spectrum of resources to meet the needs of the pharmaceutical and biotechnology industries. The MDS project was developed to be used in every stage of the study. This application was developed using Forms 9i, Reports 9i and oracle 9i Application Sever. The database was on Oracle 9i.

Responsibilities

• Was involved in full life cycle development of software applications. Involved in migration efforts, Change Release Management & Version Control using Subversion.
• Implemented business tier logic in PLSQL modules for an transactional database on Oracle 9i. Extensive use of packages, functions, procedures, triggers, cursors, bulk collect into table types, and table functions.
• Involved in DB Design, implementation of standards and best practices in terms of coding standards, referential integrity, logical grouping of business logic, automate DB creation and drop scripts to assist in prototyping. Performance tuning and Optimization. Materialized view creation to facilitate Oracle Reports reporting. Identified and implemented design changes to improve query performance.
• Involved in designing an ETL process to load DRLS legacy data using Sql Loader scripts.
• Wrote queries for designing reports using Oracle Reports.
• Unix shell scripting using korn shell to automate ETL procedures. Dynamic implementation of Oracle utilities like SQL*Loader.

Environment:  Oracle 9i, Toad, Sql Developer, Sql DBX, Quality Center

Oracle Developer, Jefferson Pilot Financial, Omaha, NE          06/05 – 02/06

Jefferson Pilot's life insurance principally Jefferson-Pilot Life Insurance Company offers full lines of individual and group life insurance products as well as annuity products. Quote engine is a Java based application that was used to generate quotes for various types of Individual and group life insurance.

Responsibilities 

·         Routinely analyzing data and preparing business rules to generate better quality and more robust database.

·         Performance tuning of existing processes (Scripts/Procedures/Queries).

·         Planning, Designing, Developing and Implementing application and data migration from GEO (Sybase database) application to Oracle Database.

·         Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.

·         Developed SQL*loader scripts to load data in the custom tables.

·         Developed PL /SQL code for updating payment terms.

·         Developed invoice-printing reports for single and consolidated invoices.

·         Documented User requirements and Testing of developed modules.

Environment: Oracle 9i, PL/SQL, Sql, Sql*Loader, Windows NT.

Download Resume Format