Data Oracle
Resume:
Mr Ketankumar Shah
*******@*****.***
Professional Profile:
. Very extensive experience in design, development, maintenance,
implementation and performance of database application and data
mining techniques
. Proficient in creation of database objects like stored procedures,
functions, packages, triggers, tables, views, indexes, and database
links using Oracle programming (SQL, PL/SQL) in UNIX and Windows
environments
. Data migrations, data loads, data conversions, interface
(Inbound/Outbound) programs, workflows and using Oracle ETL Utility
tools like SQL Loader, External Tables, export, import and data pump
. Innovative professional with proven ability to identify, analyze, and
solve problems to increase customer satisfaction through expertise
knowledge in database programming using PL/SQL Collections, Cursors,
Records, Ref Cursors, Bulk Processes, Merge, Dynamic SQL,
Exceptions handling, Autonomous transactions, Pipelined Table
Functions, Global Temporary Tables, Partitioning, Materialized views,
and Standard Oracle Data Dictionary (DBMS Packages) of Oracle
Database, Utilities and analytic functions.
. Solid experience on Data Warehousing applications analysis,
development, new enhancements implementation, feeds and data loads
inflow to data warehouse and production support with both star schema
and snow flake schema
. Experience in performing SQL tuning and PLSQL application performance
tuning with good understanding in Explain Plan utility, Stats Pack,
SQL Trace & TKProf, Precise, DB Tuner, DBMS trace and OEM/Diagnostics
. Expert in writing and maintaining Batch Programs and Reports using
Shell scripts and Procedure
. Experience working with reporting tools like Crystal Reports, Oracle
Reports
. Overall experience in all aspects of Software Development Life Cycle
(SDLC) including System Analysis, Design, Development, Implementation
and Maintenance, OLTP, OLAP
Computer Skills:
. RDBMS: Oracle 11g/10g/9i, Sybase, SQL Server 2005/2008
. Languages: SQL, PL/SQL, Dynamic SQL, SQR, Unix shell Script(sh,
bash, sed, awk)
. System: Unix (Solaris), Linux, Windows - 9x, NT4, 2000, XP
. Packages: TOAD, SQL developer, ERwin, Oracle Data Miner, Oracle
Reports6i/9i, Exceed,
PuTTy, Crystal Reports, SQL*plus, SQL Navigator, SQL*Plus
worksheet, OEM, SQL Loader, Export/Import, External Tables,
Data Pump
Work Experience:
Knight Capital Group Jersey
City, NJ
June 2010 to till date: Database Developer
. Created PL SQL procedure for Daily reports, Intraday reports, Monthly
reports, etc
. Created programs (scripts) using Shell Script for developing batch
jobs
. Understood SQR and created Procedure related to them and used Dynamic
SQL to create table, drop table and insert data during run time
envirment
. Migrated Data from Sybase to oracle and used both database for
creating Shell script to send data in email or fax or print in format
(rtf, xls, lis, csv, html, doc) for decision support system.
. Created some HTML coding inside the shell script for html format
. Use shell scripting to put and get data on/from the ftp and remote
procedure call (RPC) too
. Created new Tables, integrity constraints (Primary Key/Foreign Key) in
Oracle
. Developed PL/SQL Triggers, Stored Procedures, Functions and Packages
to replicate data in real time which are used by trading system
. Wrote conversion scripts package to reformat extracted batch process
file and export it to real time using PL/SQL. Involved in debugging
various defects relating to implementation of business logic
. Involved in modifying various existing packages, procedures, functions
and triggers according to the new business needs. Developed triggers
and packages to delete stored session data from various tables
. Used SQL Loader and wrote control file scripts to load data from flat
files to Oracle tables.
. Created table partitioning on large database tables, and added new
partitions to existing partitioned tables
. Used Analytical function and materialized view, regular expression etc
. Loaded data in base tables from temporary tables using BULK COLLECT in
stored procedures
. Working closely with traders and quantitative analysts in a highly
fast-paced environment to fix production issues and provide
enhancements as per requirements
. Minor DBA activities like import/export, creating/maintaining database
objects like table, index, sequence, views, DB links, Query
performance and urgent bug fixing in batch
Working Environment:
. Sun Solaris 8, Linux, Oracle 10g, Sybase, TOAD 9.5, Exceed v 11000
New York Institute of Technology New
York, NY
Sept 2009 - May 2010: Database Analysis Assistant (Computer Science
Department)
. Performed research analysis project on "SNOMEDCT & UMLS" -clinical
terminology and medical vocabulary system
. "UMLS" is a compendium of a large number of national and
international vocabularies and classifications and provides a mapping
structure between them "UMLS" developed by The National Library of
Medicine, USA "SNOMEDCT" consists of over a million of medical
concepts
. Research includes the analysis and data mining techniques of database
structure, hierarchical structure, relationship among concepts, and
semantic type structure of "SNOMEDCT&UMLS" with Oracle Data Miner
. Imported data of "SNOMED CT & UMLS" to Oracle 11g database
. Used SQL Loader and wrote control file scripts to load data from flat
files to Oracle tables
. Created Shell script to load data which create the table into the
oracle database, take data in the RRF format and load into the
database create the log file for error and other information
. Used Crystal report to create hierarchical structure of different
terminologies
. Used analytical function and created model for data mining
. Did clustering of the medical terminology using oracle data miner
10.0.2.3
. Created global temporary tables, bulk processes, table partitioning on
large volume tables and worked on materialized views. Created new
partitions for existing partitioned tables
. Wrote conversion scripts package to reformat extracted batch process
file and export it to real time using PL/SQL. Involved in debugging
various defects relating to implementation of business logic
. Involved in modifying various existing packages, procedures, functions
and triggers according to the new business needs. Developed triggers
and packages to delete stored session data from various tables
. Used SQL Loader and wrote control file scripts to load data from flat
files to Oracle tables
. Created table partitioning on large database tables, and added new
partitions to existing partitioned tables
. Created useful triggers, store procedures, functions, tables, views,
indexes and query optimizations & analyzed "SNOMEDCT & UMLS" database
with SQL developer 2.1.0
Working Environment:
. Sun Solaris, Oracle 11g, SQL Server 2008, SQL developer 2.1.0, PuTTY,
Oracle Data miner
Asahi Songwon Colors Ltd
Gujarat, India
June 2005 - Jan 2008: Executive ERP & EDP coordinator
. Developed ERP software related to company's need
. Performed logical and physical data modeling with extensive
normalization and proper naming conventions using Erwin
. Implemented business rules on data using Stored Procedures, Functions
and Packages
. Created new Tables, integrity constraints (Primary Key/Foreign Key) in
Oracle
. Developed PL/SQL Triggers, Stored Procedures, Functions and Packages
to replicate data in real time which is used by newly developed
security management application
. Created global temporary tables, bulk processes, table partitioning on
large volume tables and worked on materialized views. Created new
partitions for existing partitioned tables
. Used Analytical function and materialized view, regular expression etc
. Minor DBA activities like import/export, creating/maintaining database
objects like table, index, sequence, views, DB links
. Used SQL server 2005 database to create some reports using SQL query
inside the Shell scripts and send reports directly to the Managing
team
. Created crystal reports to Finance on Variance analysis,
Reconciliation of accounts and provided consolidated reports for
proper decision making. Analyzed and delivered (Monthly Expenses
report, Month end closing reports) and other Ad-Hoc reports with high
level of accuracy to senior management
. Created useful Indexes and Query optimization for system performance
and tuning
. Report generation with Oracle Report from stored data for some
analysis and decision making (Last year's sales, best month, predicted
target of sales for upcoming month, etc)
. Integrated and managed whole networking system of two locations
. Set up more than 100+ PCs in LAN System in a night when transferred
the Head Office
Working Environment:
. Oracle10g, SQL Server2005,Crystal ReportsXI, Toad, ERwin, SQL Loader,
and HP-Unix
AM Technologies
Gujarat, India
Jan 2005- May 2005: Database Developer
. Developed school management system
. School Management System have Student details, Employee details,
timetable, School Inventory, grade system, Progress report, accounts
module etc for final semester major project in organization
. Did analysis for the school requirement created module with ERwin
. Did SQL query to get data from the database related to each button and
list in the front end
. Wrote DDL scripts and created tables, indexes, views, synonyms, roles
and DB links
. Created new Tables, integrity constraints (Primary Key/Foreign Key) in
Oracle
. Implemented business rules on data using Stored Procedures, Functions
and Packages
. Created reports using oracle reports for fees receipt, exam report,
attendance report, pay check, timetable etc
Working Environment:
. Oracle 9i, Oracle Reports 6i, PL/SQL, ERwin
Education:
. Master's Degree in Computer Science, New York Institute of
Technology, New York, NY
. Bachelor's Degree in Computer Science, Gujarat University, Gujarat,
India
Activities & Awards:
. "Medical and Engineering Student Association, Kalol", President, (2004-
2006)
. "Spirit 2003", 1st Rank in Chess competition - bachelor study
Reference: Available on request
Contact this candidate