Resume

Sign in

Oracle SQL, PL/SQL, Unix, Shell Scripting, Toad

Location:
Hyderabad, Telangana, India
Posted:
March 13, 2018

Contact this candidate

Resume:

SEBASTIAN THOMAS

Email: ac4sl6@r.postjobfree.com

Phone: +91-998*******, 807-***-****

Summary:

IT experience

12+ Years

Technically adept and confident software programmer with exceptional skills in coding and documentation

12+ years of experience in software development and maintenance.

Expertise in application development using technologies such as Oracle, SQL, PL/SQL.

Experience in various stages of SDLC including requirement gathering, analysis, development, testing, implementation and maintenance.

Experience in UNIX and Shell Scripting.

Experience in documentation to support various stages of SDLC.

Experience in Version Control Tools such as PVCS and Clearcase.

Experience in Data Warehousing concepts, ETL Processing and ETL Tools such as Datastage and Talend

Experience in domains such as Retail, SCM, Banking, Life Science and Oil & Gas.

Experience in client interaction and onsite coordination.

Experience as Developer, Senior Developer and Technical Lead.

Experience in team management, work allocation and mentoring junior members.

Knowledge of databases such as SQL Server, MySQL, Teradata

Knowledge of Hadoop technologies such as HDFS, Pig, Hive, Sqoop and Flume

Knowledge of Microsoft Azure, Event Hub, Stream Analytics, Blob Storage, Cosmos DB

Strong team player with good communication skills and high ethical standards.

Ability to execute within deadlines while ensuring quality delivery of products.

Excellent analytical, logical, debugging and programming skills.

Work experience in countries such as Denmark, Germany, UK, Canada and Abu Dhabi on various project assignments.

Qualifications:

Graduation

Post Graduation

Degree

Institute

Degree

Institute

BSc.

Calicut University

MCA

Madras University

Work Experience:

Aris Global, Mysore from Jan 2017 to Aug 2017

Oracle Financials, Bangalore (Contract) from Dec 2015 to Dec 2016

MPH, Abu Dhabi (Client: ADCO through Schlumberger) from May 2014 to Apr 2015.

HCL Technologies, Toronto, Canada from Nov 2009 to Apr 2011

7N Consulting (Client: RBS), New Delhi, India from Aug 2008 to May 2009

FL Smidth Infotech, New Delhi, India from Sep 2004 to Feb 2007

Eastern Software Systems, New Delhi, India from Jan 2002 to Sep 2004

Technical Proficiency:

Key Skills

Oracle SQL, PL/SQL, UNIX, Shell Script, ETL, DWH

Language

PL/SQL, Shell Script

Operating System

Windows, UNIX, LINUX, Sun Solaris

Database

Oracle 8/9i/10g/11g/12c

ETL Tools

Talend, Datastage

Tools

Clearcase, PVCS, Toad, SQL Developer, CAWA, Autosys

Other Technologies

Hadoop, HDFS, Pig, Hive, Sqoop, Flume, SSAS, SSIS, Azure

Domain Knowledge:

Retail

SCM

Banking/Stock Market

Oil and Gas

Life Science/Health Care

Career Profile:

OFSS Bangalore

1.

Project

:

CERES Automation

Client

:

State Street

Duration

:

From December 2015 to December 2016

Technology

:

Oracle PL/SQL, UNIX, Shell Script, Autosys

Role

:

Technical Lead

Description:

CERES Automation process loads data from sources such as Bloomberg, Reuters and Super Derivatives into Time Series tables in CERES System through daily batch jobs. This enriched data is then provided to downstream systems.

Responsibilities:

Development and Maintenance of Application.

Creation, Development, Enhancement and Modification of database objects such as procedures, functions, packages, tables, views etc., UNIX Shell Scripts and Autosys Jobs.

Attend regular meetings/conference calls to update the status, clear doubts and report issues.

Provide technical guidance to team members.

Code Review, Testing and Defect Fixing.

Performance Tuning.

Schlumberger, Abu Dhabi

2.

Project

:

APEX/PIES Integration

Client

:

ADCO, Abu Dhabi

Duration

:

May 2014 to April 2015

Technology

:

Oracle 11g, SQL, PL/SQL, Oracle Forms, ProSource (a Schlumberger Product)

Role

:

Consultant

Description:

Apex Integration is for ADMA and Pies Integration is for ADCO. Through these applications, ADMA and ADCO users can load data from source (Facility/Field) to their core database named SEABED. It involves all ETL activities such as Extract, Transform and Load.

Responsibilities:

Development and Maintenance of Application.

Development, Enhancement and Modification of PL/SQL procedures, functions, packages, triggers and oracle forms.

Checking and validating data in various tables in the database using SQL.

Attend regular meetings to update the status, clear doubts and report issues.

Conduct Code Review, Unit Acceptance Testing, System Integration Testing and Defect Fixing

Performance Tuning

Migration

HCL Technologies

2.

Project

:

COMIT

Client

:

CCH Canadian Limited, Toronto, Canada

Duration

:

November 2009 to April 2011

Technology

:

Oracle 10g, SQL, PL/SQL, UNIX, Shell Scripting

Role

:

Technical Lead

Description:

CCH Canadian Limited is a premier provider of software, content and services to professionals in the fields of tax and accounting, financial planning, legal and business.

CCH tracks, analyzes and explains tax and business related law, annually producing hundreds of publications in electronic and print form for tax, accounting, legal, human resources and financial planning professionals. In complement to these content solutions, CCH has over 30 annual software releases designed to automate and optimize professional workflows.

CCH’s flagship products include The Canadian Tax Reporter, Preparing Your Income Tax Returns, Canadian Labour Law Reporter, Canadian Securities Law Reporter, and software application Taxprep.

CCH uses an Order Management System called COMIT for the fulfilment of orders placed by customers.

Responsibilities:

Development and Maintenance of Application.

Mentoring Team Members.

Requirement Gathering and analysis.

Transition of knowledge back to offshore team.

Onsite-offshore Coordination

As a single point of contact, support the offshore team on daily basis.

Involved in the continuous enhancements and fixing of production problems.

Development, Enhancement and Modification of PL/SQL procedures, functions, packages and triggers.

Checking and validating data in various tables in the database using SQL.

Attend regular meetings/conference calls to update the status, clear doubts and report issues.

Conduct Code Review, Unit Acceptance Testing, System Integration Testing and defect fixing.

Perform Code Check-In, Check-Out activities in PVCS.



Contact this candidate