S ID D HART H CONTRACTOR

absz2j@r.postjobfree.com

** ***** *****,

973-***-**** (Home)

Livingston, NJ 07039 973-***-****

( Mobile)

Brief:

• Strong hands-on experience of 4 years with large IT applications

• Expertise in a pplication development using O racle SQL, Perl, U N IX

• Hands on Experience with J ava, C, C++ with Perl

• Extensive experience in a nalysis, d ata modeling, design, E TL, development

l ifecycle .

• Proficient in writ ing Stored Procedures, F unctions, D atabase T r iggers and

P ackages.

• Expert in SQL queries, P L/SQL P rocedures, C ursors, I nte rfaces and Data

Conversion using PL/SQL, SQL*plus, T OAD, SQL*Loader, I nformatica.

• Hands on experience in performance tuning using E xplain Plan, SQL-T race, T K-

Prof oracle utili ties and creating relevant system and users documentation

• Expertise in handling financial and brokerage application

• Strong analytical and problem solving skills

• Well organized professional with good work ethics and a positive attitude

C areer Objectives:

To work in challenging and growth oriented environment by designing and supporting next-

generation database solutions in technical environment.

Education:

Bachelor of Computer Application (BCA) M arch -

A pril 2012

Sardar Patel University, Gujarat, India

Awards and Achievement:

• 1st Rank - Best Programmer of the Year

Year 2010

• 2nd Rank - System Analysis and Design

Year 2011

• 1st Rank - “Tech Arena 12”- a National Level Event

Year 2012

• 1st Rank - Best Shell Scripter

Year 2012

• 2nd Rank - Best Engineer

Year 2012

• 3rd Rank - Best System’s Idea

Year 2012

Technology Snapshot:

Visual FoxPro 9.0,Oracle 9i/10g,MS Access 2012

Database

Windows NT/2000/7, UN IX, Linux, DOS

Operating System

C, C++, VB 6.0, ASP.NET, JAVA, Core JAVA, SQL, SL/SQL, Shell

Programming

Scripting, DOS programming, KSH.

L anguages

Web Development Tool Dreamweaver, FrontPage, HTM L Editor

MS Office 2013, MS Visio 2010, Flash CS1, TOAD, Oracle Forms and

Software Tools

Reports,

E rwin, Informetica

Apache Server

Web Servers

P rofessional Experience:

I ntellect Invest Brokerage Nov 2012 to

T ill Date

Line89, M D, USA

T he In tellect Invest Brokerage is a part of intellect suite and is a highly customizable wealth

management solution. The In tellect Invest Brokerage is identified as generalized service and spans

off into four broad modules, they are Intellect Mutual funds, Intellect Special Products, In tellect

B rokerage and In tellect Blotter. The In tellect Invest Brokerage is a back office and retail brokerage

solution system that enables bank to offer brokerage distribution service for their retail clients. The

system works as an independent product processor and needs to interface with other

p roduct/system, from the In tellect suite or other third parties, for accessing the cash accounts and

credit information.

Environments: ORACLE, PERL, UN IX, KSH, CGI, DBI/DBD, PL/SQL, SQL, CRON TAB, HTM L,

TOAD, ETL

R esponsibilities:

• Involved in meeting with business people for requirement gathering and addressing the

issues and changes in existing system

• Involved in Data Architecture and Design, E R Modeling, E TL, Business Problem

A nalysis and work with Informatica.

• Optimized the performance of queries with modification in O racle PL/SQL queries

• Created P L/SQL functions to facilitate business. Developed procedures to run the SQL*

L oader to load data from f lat files i nto the target database tables

• Developed and maintain Perl CGI script files for content conversion

• Developed Oracle SQL tables, v iews, i ndexes, q ueries, joins, g roup by, h aving .

• Developed and coded in U N IX and Perl script to a utomate everyday task

• Wrote complex P L/SQL, P rocedures, F unctions, T r iggers, C ursors, M aterialized

v iew i n Oracle and Performance tuning techniques including p artitioning and i ndexing

strategies.

• Involved in O ptimization of SQL queries

• Developed a utomate backup status reporting script in Perl

• Creating M aterialized Views for speeding up the response of SQL queries.

• Wrote U N IX shell script t o automate verification of database information via web

A pplication

• Developed Oracle P L/SQL code to work with Workflow design

• Created multiple U N IX shell script to import data into Oracle

• Create Perl script to provide a pplication level control and d atabase monitoring

• Created Corn jobs for dealing with periodic routine such as password expiration

• Supported in resolving production b atch failures and close out r esolving tickets

• Worked with p roduction Support to resolve issues of data processing

Global Equity Market Portfolio T rading System (GEMPT) M ar

2010 to Nov 2012

Akshar Finance, Gujarat, I ndia

The Global Equity Markets Portfolio Trading (GEMPT) application is a full-featured tool for t rading

'baskets' of securities. GEMPT composed of client baskets, t rading baskets, Inbox, and summary. In

GEMPT, 'baskets' are groupings of t ransactions associated with a client, a t rader, or both. The

t ransactions in a basket are typically performed together, often in patterns called 'waves'. The

orders can come from clients in 3 different ways manually through phone or fax, electronically

t hrough FIX, through files, such as Excel spreadsheet.

E nvironments: ORACLE, PERL, UN IX, KSH, CGI, DBI/DBD, PL/SQL, SQL, CRON TAB, HTM L,

TOAD, ETL, Forms & Report, ETL, TOAD, Erwin

Responsibilities:

• Involved in requirement analysis, database design, coding, testing, implementation and

review

• Involved in D ata Modeling and D atabase design using E r win .

• Also involved in J ava and core java Development for later stage for Programming

• Designed and developed Perl application to automate data parsing efforts

• Developed and implemented Perl scripts to monitor backups for progress and failure

• Wrote complex Oracle SQL queries to ret rieve u nique datasets using i nner and outer

joins

• Programmed Multitasking system in java and also works with inheritance, Data

h iding concept.

• Designed and developed Perl CGI p rograms to collect, analyze and data gathered from log

f ile

• Involved in H igh and detail level design activities including i ndexing, p artitioning for

optimal performance .

• Developed U N IX shell scripts and set up C ron jobs for monitoring the database

• Debugged and wrote e rror trap routines i n U nix KSH .

• Designed E R diagrams and normalization of database

• Involved in Conceptual / Logical / Physical d ata modeling, E TL design and

i mplementation.

• Write p rograms in java using Overloading, Overriding, Data Abstraction, deadlock,

i nterface

• Developed complex O racle SQL scripts to generate d ata content records for a utomatic

content generation

• Responsible for Performance tuning of the Forms and R eports code modules using

E xplain Plan, SQL*T race and T OAD u tilities

• Responsible for scripting data manipulation using SQL and P L/SQL

• Wrote Shell scripts using sed, a wk, g rep, comm etc

• Wrote scripts in U N IX shell and Perl to streamline indexing p rocess

• Provided production support for new features and improvements

• Responsible for p roduction implementation and support

U S Permanent Residence

Contact this candidate