Data Entry Tibco Spotfire

SUMMARY

Around ** Years of Experience as an Oracle and ETL Developer in the IT Industry

Worked on Talend DI, Oracle and SQL Server.

Working on IICS, Oracle and SQL Server.

Expert in Database Programming and Analyst skills with proficiency in Oracle 9i,10g and 11g.

Excellent in performance tuning and Query optimization and writing Consistency Query for easy Tracking

Excellent in ETL job Development.

Experienced in custom data type like records, objects and collections to optimize the code.

Experienced in SQL LOADER.

Experienced in Oracle Job scheduling.

Experienced in Oracle Forms and Report 9i, 10g.

Experienced in UNIX

Good knowledge in software Development & Testing.

Excellent understanding of the Software Development Life Cycle.

Key player in Analyzing Enhancement requests and Modification requests.

Strong analytical skill coupled with Good Communication and Interpersonal Skill.

Good experience in client support and production support.

Good experience in SCM activity using IBM Clear Case tool.

EDUCATION

Level

Subject

College / University

Degree

MCA

Rajeev Gandhi Technical University, Bhopal, M.P., India

TRAININGS AND CERTIFICATIONS

Attended

Completed Training on Tibco Spotfire.

Certification

Oracle Certified Associate (Oracle 9i)

Oracle Database 12c Certified Implementation Specialist

SKILLS SUMMARY

Skill Name

Level

Last Used

Experience

Operating Systems

Windows (98/2000/NT/XP), Linux, Unix

2020

14+ Years

Languages

HTML, PL/SQL, SQL, ORACLE

2020

14+ Years

Database

Oracle9i/Oracle10g/Oracle11g/Oracle12C, MS SQL SERVER

2020

14+ Years

Tools

TOAD, Oracle PLSQL Developer, Oracle Form & Reports, Big Data, Oracle Repots 9i/10g

2020

14+ Years

Application Server

WebLogic

2014

3+ Years

ETL Tool

TALEND DI

2016

6+ Years

Methodologies:

Agile, SCRUM, Waterfall

2022

14+ Years

PROJECT EXPERIENCE

Project-1:

Client

The Cognite Hillsborough, NJ

Duration

Aug 2016 -Present

Position

Oracle Technical Lead, BCT

Environment

Oracle 12C SQL, Oracle 12C PL/SQL,MS SQL Server, Talend DI, Unix, Big Data

Background: This is an online Data Warehousing project. This system is used for reporting on different customers data stored in data warehousing database.

Responsibilities :

Involved in database design and impact on existing product with new changes.

Write procedures, packages, functions and queries as required.

Design jobs for table replication and file load from different source system to data warehousing system.

Support on production tickets.

Involved in POC to migrate existing project in to Big Data.

Support for other team member related to database changes and Talend tool.

Project-2:

Client

Bahwan Cyber Tek Pvt. Ltd.

Duration

Aug 2014 to Sep 2016

Position

Technical Lead, BCT

Environment

Oracle 11g SQL, Oracle 11g PL/SQL, ADF, SOA, Unix.

Background: This is an online card order management system. Purpose of this system is to manage users for on boarding with HID, Place Order for different type of cards and manages these orders.

Responsibilities :

Involved in database design and impact on existing product with new changes.

Work on IAD for database related changes.

Write procedures, packages, functions and queries as required.

Use of custom data type like records, objects and collections to optimize code.

Did changes in existing procedures, packages and functions and queries as required.

Manage central repository with SCM tool for changes in source.

Support for other team member related to database changes.

Project-3:

Client

Nucleus Software Export Ltd.

Duration

Nov 2012 to Aug 2014

Position

Senior Software Engineer

Environment

Oracle 11g SQL, Oracle 11g PL/SQL, Windows XP.

Background: Work for addition of new features in existing product (FinnOne) Like Gold Loan, Education Loan and performance benchmarking activity.

Responsibilities :

Involved in database object design and impact on existing product with new changes.

Work on IAD for database related changes.

Write procedures, packages and functions and queries as required.

Use of custom data type like records, objects and collections to optimize the code.

Involved in QCT issue fixing and coordination.

Support for other team member related to database changes.

Work on Performance testing, benchmarking activity of core product and performance tuning and Query optimization for the same

Project-4:

Client

Nucleus Software Export Ltd.

Duration

Mar 2011 to Nov 2012

Position

Senior Software Engineer

Environment

Oracle 11g SQL, Oracle 11g PL/SQL, Windows XP.

Background: Edelweiss is one of the India's leading Financial Services Group that used Nucleus product known as FinnOne now nucleus develop product FinnOne Pro for same purpose with new features and replace earlier product with new product. This is a Migration Project (FinnOne – LMS to FinnOne Pro - LMS).

Responsibilities :

Involved in database object design and impact on existing product with new changes.

Work on IAD for database related changes.

Write procedures, packages and functions and queries as required.

Use of custom data type like records, objects and collections to optimize the code.

Involved in QCT issue fixing and coordination.

Support for other team member related to database changes.

Work on Performance testing, benchmarking activity of core product and performance tuning and Query optimization for the same

Project-5:

Client

Nucleus Software Export Ltd.

Duration

May 2008 – March 2010

Position

Software Engineer

Environment

SQL SERVER 2005, ASP.NET, C# NET

Background :

Worked for LI Phase-2 enhancement For BHFL.

Worked for Auto Loan Cancellation enhancement for BHFL.

Ceiling and flooring rate enhancement for ADF.

Some small enhancement for Axis bank like addition fields in existing screen.

Worked for enhancement-99 (Balance confirmation certificate and IBA Letter) of HDFC.

Worked for NOC Blocking Enhancement of ADF.

Worked for Multi-Bankers Enhancement of Bussan.

Worked on performance tuning and Query optimization activity.

Responsibilities :

Involved in writing SQL Queries, PL/SQL packages, function, procedures, triggers as per required for enhancements.

Write/Update PS and UTP related to change/enhancement.

Involved in Unit testing, UAT of enhancements done for HDFC and Bussan clients.

Involved in performance tuning and Query optimization activity.

Project-6:

Client

Nucleus Software Export Ltd.

Duration

Mar 2009 to Nov 2009

Position

Software Engineer

Environment

Oracle 10g AS, D2K Forms 10g, Reports 10g, Windows 2003

Background :

This project is for ACOM Bank, Japan. ACOM is the 2nd largest Non-Banking Financial Corporate of Japan. This project consists of modules like CIF (Costumer Information System), APS (Application Processing System), Guarantee, LMS (Loan Management System), Collections, Security.

Responsibilities :

Involved in writing PL/SQL packages to populate fields used in report layout.

Involved in mapping of report layout fields with the fields generated in data model by PL/SQL Package.

Project-7:

Client

Nucleus Software Export Ltd.

Duration

Jan 2008 to Mar 2009

Position

Software Engineer - Nucleus Software Export Ltd.

Environment

Windows XP, Developer 2000(Forms 10g & Reports 10g), Oracle 10g

Background :

A complete Loans Management Systems managing the loan right from the loans application stage to

the Loan termination. It contains almost every aspect associated with the Loans in the Banking

industry. An integral part of FinnOne suite.

Responsibilities :

Work for SCM related activities of whole team.

Resolve Core bugs.

Project-8:

Client

HCL Info system

Duration

Jun 2007 to Jan 2008

Position

Software Engineer

Environment

Windows XP, Developer 2000(Forms 10g & Reports 10g), Oracle 10g.

Background :

DGS&D (DIRECTORATE GENERAL OF SUPPLIES & DISPOSALS), being the Central Purchase

Organization of Government of India has a system to bring items on Rate Contract. Rate contract is a

mutual agreement between suppliers and DGS&D to make item available on agreed upon rate as well

as terms& condition for a specific period to the various departments of Government of India, State

Government, Public Undertakings etc.

To make readily available Technical Particulars of a specific item for specific RC period, To make Tender

Notices available online, To make Complete Tender Document available online, Faster process for tender

decision, to make Rate Contract Document available online.

Responsibilities :

Forms for Data Entry and verification of the Records

Involved in writing Operating validations, Writing SQL queries, Procedure and function.

Building Reports.

Enhancements in existing forms and reports.

Debugging in modules.

Support of the Project at the user End.

Project-9:

Client

- HCL Info system

Duration

Jun 2006 to Nov 2006

Position

Technical Support Engineer

Environment

Linux, Java

Background: “Common Integrated Police Application” is developed to make all India Police High-tech .It is useful to store the information of criminals old record and new criminals records and Information related to crime .This software is helpful to view Information at any place and at any point of (Daily, Weekly, Monthly, Quarterly and Yearly, Region wise). It is easy to use and beneficial to improve Performance.

Responsibilities:

Involved in writing SQL queries, Procedure and function.

Building Reports, Support of the Project at the user End.

Contact this candidate