SQL Developer - Information Technology Resume Search
SQL Developer - Information Technology Resume Search
My Spider Scam Awareness Contacting Us F. A. Q.
 
Job Seekers
Search Jobs
Browse Jobs
Post a Resume
Job Alerts
 
Employers
Search Resumes
Browse Resumes
Post a Job

SQL Developer Resume


Desired Industry: Information Technology SpiderID: 67838
Desired Job Location: Applewood, Colorado Date Posted: 3/14/2013
Type of Position: Contractor Availability Date: 03/11/2013
Desired Wage:
U.S. Work Authorization: Yes
Job Level: Experienced with over 2 years experience Willing to Travel: Yes, More Than 75%
Highest Degree Attained: Masters Willing to Relocate: Yes


Objective:
• 81/2 years of IT experience in
Design, Development and Maintenance of
various software applications in client-
server environment using Oracle
Technologies on UNIX & Windows
Platforms.
• Experience in CEMR Data
Conversion to Epic and Clinical Data
Conversion and Dental conversion to
Metavance.
• Strong understanding of the
principles of DW using Fact Tables,
Dimension Tables, Star and Snowflake
Schema Modeling.
• Experience working with BODS
Designer and BODS Data Integrator
Administration.
• Experience in Dimensional Data
Modeling using Erwin and participated in
designing the Logical and Physical Data
Model.
• Experience in Data Extraction,
Migration Transformation and Error
handling.
• Adept in Oracle, Oracle Tools
and Utilities; SQL and PL/SQL.
• Used several tools like
SQL*Plus, SQL *Loader, SQL Developer and
Toad 10.
• Actively participated in
creating database objects such as
Tables, Views, Synonyms, Indexes,
Sequences and Database Links as well as
Custom Packages tailored to business
requirements.
• Developed ETL objects (mappings,
sessions and workflows) as per the
business requirements.
• Experience in the development of
PL/SQL Stored Procedures, Functions,
Triggers and Packages to implement
business logic.
• Experience in Data Migration
processing including data loading from
flat files to the database tables using
SQL*Loader.
• Demonstrated expertise utilizing
ETL tools, including SQL Server
Integration Services (SSIS), Data
Transformation Services (DTS), and
DataStage and ETL package design, and
RDBM systems like SQL Servers, Oracle,
and DB2.
• Extensive experience in
Performance Tuning and Query
Optimization using Explain Plan and re-
designing of poorly designed process
flow of data.
• Knowledge of Data Warehouse/Data
Mart design concepts.
• Maintained project document
repository for ETL Objects, database
objects, UNIX objects, mapping
information, unit test cases, dollar
audits, deployment plan, replic jobs
etc.
• Highly involved in all phases of
Software Development Life Cycle (SDLC)
from Analysis, Design, Development,
Test, Implementation, Documentation and
Support.
• Experience in working with Java
developers to coordinate Web-based
functionalities with Oracle Database.
Knowledge in XML, HTML and JavaScript.
• Well versed in MS Office Suite
such as Visio, Word, Excel, Access and
PowerPoint.
• Involved in programming,
debugging, and unit and system
integration testing of modules.
• Involved in jobs scheduling,
monitoring and Production Support in a
24/7 environment.
• Excellent Analytical and Problem
Solving skills with strong communication
and interpersonal skills.
• Flexible, highly-adaptable,
team-player, pro-active and eager to
learn and perform new tasks.


Experience:
Professional Experience:

Delta Dental, San Francisco, CA
May ‘12- Present
Pl/SQL Developer and Data Migrations

Delta Dental is a Leading Dental
insurance industry in designing
innovative Dental coverage programs that
keep costs down and deliver quality
care. Diverse client list includes
everyone from Fortune 100 companies to
public agencies to individuals and
families. The Delta Dental Difference
saves clients and enrollees billions of
dollars a year, because Delta Dental
dentists agree to determination of fees,
clients enjoy extensive cost controls,
and enrollees pay less out-of-pocket.
They are part of the Delta Dental Plans
Association, a network of companies that
provides dental coverage to more than 56
million people in the U.S. Delta Dental
of California, Delta Dental of
Pennsylvania and Delta Dental Insurance
Company, together with our affiliate
companies and Delta Dental of New York,
Inc., form one of the nation’s largest
dental benefits delivery systems,
covering 26 million enrollees.

Responsibilities:
● Gathered the Requirement from
the business user and prepared the
program specification and design
document for the development of the CEMR
Application.
● Created Jobs in Business Object
data Services Application and Data
Integrator Application.
● Worked on Unix Server for file
transfers and created Shell Scripts to
hand the multiple jobs and kick off the
jobs.
● Created the PL/SQL packages,
procedures, functions applying the
business logic to update the patients’
database.
● Worked with XL file format and
created the workflow in Microsoft Visio
and send the release installation plan
to Release team to insure all the jobs
are in Production database.
● Prepared the proper
documentation for all the jobs and
provided the user guide to the Users.
● Design and developed the scripts
to create table, views, indexes and
sequence.
● Created the custom tables to
import the Patient’s data and insert
into the database tables.
● Extensively used INDEXES AND
HINTS for better performance of queries.
● Optimized SQL and PL/SQL
performance using Oracle utilities like
Explain Plan, SQL-Trace Analysis and TK-
Prof
● Extensively wrote UNIX Shell
scripts to automate the data load from
sqlldr to staging table.
● Used Toad as an advanced SQL -
PL/SQL editor. Built and tested scripts,
PL/SQL packages, procedures, triggers,
and functions. Creating and editing
database tables, views, indexes.
● Converted all Oracle ETL
Packages to Informatica Mappings and
created workflows/Sessions.
● Train and manage developers,
advising other groups in organization on
SSIS development, data warehouse
development, and ETL development best
practices.
● Used FTP to transfer the files
into different servers as per needed by
the business users.
● Involved in preparing functional
document, user document, process flow
diagram and flow charts.
● Ensured data integrity and
verified all data modifications and
calculations during database migration
using ETL tools. Developed test cases to
accomplish ETL data migration
● Customized different modules of
reports after upgrade process using MS
Access.
● Developed Data entry, query and
reports request screens and tuned the
SQL queries.
● Actively involved in preparing
Technical and Business documentation for
the application in design, which could
serve as future reference to the
programmers and system developers.
● Developed customer strategies
and improve business performance


Skills:
Technical Skills

Languages : PRO*C, C#,
Java, XML
Databases : Oracle
9i/10gR2/11g, MS Access
Tools : SQL* Plus,
Toad, SQL* Loader, SQL Developer, Oracle
Developer, MS Visio, Text
Pad, Erwin, Informatica 8.5, VI Editor,
I Many, Model N, Tidal, Apex, SCOM,
ERStudio, Eclipse IDE, Business Objects
Data Services 11.5 and Data Integrator.
Knowledge : SFTP, SSH,
PGP, KSH Scripting
Version Control : PVCS, Open Source CVS
Web Technologies : HTML, CSS,
XML, JSP, SERVLET, JavaScript
Web Servers : Tomcat, IIS
Operating Systems : UNIX, Solaris,
Windows 95/2000/NT/XP, Linux


Candidate Contact Information:
JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.


    





© 2021 Job Spider
Privacy Policy | CC Marketing Sites | Site Map | Links