abhijit - oracle plsql, teradata, shell scripting

Abhijit Kumar Singh 8055360102/ [email protected]

Experience Summary

Over 8 years of experience in PLSQL Development.

Good hands-on experience of Unix Shell Scripting in AIX.

Good knowledge of Teradata database and its utilities fastload, multiload, fastexport, BTEQ, TPT.

Extensive experience in writing PLSQL objects like procedures, functions, packages, views.

Developed number of PLSQL jobs based on business requirements using various Advanced SQL & PLSQL concepts such as analytics, aggregation, bulk collect/forall, dynamic SQL, merge, dynamic SQLs.

Worked on different data store and data warehouse applications.

Extensive experience in developing processes to load flat files using SQL*Loader.

Knowledge of Data Warehousing concepts.

Excellent communication & analytical skills.

Technical Skills

Hardware / Platforms UNIX AIX

Primary Skills Oracle SQL, PL/SQL, SQL*Loader

Secondary Skills Unix shell scripting, Teradata

DBMS Oracle 9i, 10g, Teradata 14.0

Tools and Utilities Toad, SQL Developer, Teradata SQL Assistant

Version Control Systems MS Visual Source Safe

Educational Qualification

B.E. from Pune University in Electronics & Telecommunications in 2006 with Distinction.

XIIth from ISC board in 2002 with 72%. Xth from ICSE board in 2000 with 84%.

Employment History

Cognizant Technology Solutions from August 2006 to date.

of 9 Dated: 04/15/23


Relevant Project Experience

Project #8Global Foundries – Calendar Change Project

Project Technologies Datastage, Business Objects, Oracle PLSQL, Qlikview

Duration Aug 2013 – Oct 2013

Project Abstract

Global Foundries client is a leading semiconductor industry manufac-turer with foundry present in Singapore, Dresden, Germany & U.S.

Calendar Change Project– The calendar used in the Organization fol-lows 4-4-5 format. Every first & second month of a quarter will have 4 weeks, and every third month will have 5 weeks. This calendar imple-mentation is used across the organization. This was having and ad-verse impact for any kind of reconciliation outside the organization. This resulted in an initiative to change the calendar to Gregorian cal-endar across the organization. This initiative has huge impact on en-tire corporate and manufacturing reporting. The tech stack, as a re-sult became varied with Datastage 7.5.2 as ETL tool, Business Ob-jects XIR3, QlikView reports as reporting tool.

Roles & responsibility

Analyze impacted Oracle objects and its basic functionality.

Unit testing of impacted objects due to calendar change viz. Views, Procedures, Functions, Materialized Views.

of 9 Dated: 04/15/23


Project #7JPMC - New Performance Measures

Project Technologies Oracle PLSQL, Datastage, Cognos, Java

Duration Sep 2011 – Dec 2011 & Feb 2013 – Jun 2013

Project Abstract

New Performance Measurement is a data warehousing project dealing with portfolio management/analysis, Risk Attribution, Risk Analysis to be used by fund managers. JPMorgan's new Performance Measurement & Analytics Reporting sys-tem offers extensive capabilities for risk calculations, broader perfor-mance and attribution analyses, greater ability to customize invest-ment reports and much more flexibility to manage performance analyses. The system is designed so performance managers, ana-lysts and institutional investors can analyze the effectiveness of their portfolio strategies.


Understand & analyze technical change requirements.

Create tables, global temporary tables, functions, packages, procedures, functions.

Modify existing packages, procedures, functions for change requirements.

Creating master script for deployment.

Debugging stored procedure and packages.

Use advanced PLSQL methods.

Defect fixing.

of 9 Dated: 04/15/23


Project #6Barclays - MI Interim Reporting Solution

Project Technologies Oracle SQL, Java

Duration Aug 2012 – Dec 2012

Project Abstract

As a part of interim solutions for Release 3 of MI reports, users wanted the detailed level reports to be generated via Oracle SQL. The source application for report data was Siebel CRM.

These sql would then be scheduled in Java to run every day. Using Java only the output generated by these sql’s would be converted into xls file and mailed to the users.


Understand & analyze techincal requirements of the report based on field mapping sheets provided.

Create tables in Oracle & load adhoc excel data provided by client.

Develop the Oracle SQL for reports using complex SQLs involving sub-queries, inline views, outer joins, group by.

Performance tuning of SQLs

Unit Testing

Bug Fixing

of 9 Dated: 04/15/23


Project #5Novartis - Mass Market Veeva Implementation

Project Technologies Oracle PL/SQL, Unix, Apex Data Loader

Duration Feb 2012 – Jul 2012

Project Abstract

Novartis’ groups of Oncology, Multiple Sclerosis, and Managed Markets & Specialty uses the Salesforce CRM platform, called ‘VANTAGE’, where all the customer information processes and transactions are integrated onto one platform. As Vantage is considered as the future CRM in Novartis, there is a need to migrate the Primary Care group from siebel CRM system (edge) to vantage.


Discuss & understand requirements from onsite team.

Writing stored procedures, functions, views and other database objects for migration.

Creating stage and integration tables.

Creating Job flow diagram.

Perform full load, incremental load for data.

Write complex queries involving sub-queries, inline views, outer joins, group by.

Unit testing.

Supporting UAT from offshore.

of 9 Dated: 04/15/23


Project #4Barclays - Lead Generator

Project Technologies Oracle PL/SQL, Unix, Java

Duration May 2009 – Dec 2011

Project Abstract

Barclay’s sales infrastructure in Emerging Market is present in 14 countries. Sales teams sell various retail banking products like Personal Loans, Credit Cards, Liability Accounts, insurance etc.

Products are introduced to prospective customers through Lead Generators (LGs) who explain the product to prospects, help with documentation, and submit completed applications and supporting documents to Barclays. Currently, there total of 32000 LGs across Emerging Markets and this figure is expected to increase steadily across all markets.

In order to meet business growth, demands across Emerging Markets and to handle/manage the LG force efficiently and in a controlled manner, an integrated multi-country intranet based Lead Generators Tracking System (LG System) is being proposed.

LG System will address 2 primary business – LG On boarding and Performance Management


Understand & analyze requirements from client IT team based on BRD provided by them.

Writing stored procedures, packages, functions, views and other database objects. Unit testing.

Creating stage, integration, summary and report tables.

Writing shell script jobs.

SQL*Loader scripts to load flat files.

of 9 Dated: 04/15/23


Project #3Barclays Garuda – Combined Statement

Project Technologies Oracle PL/SQL, Unix Shell Scripting, Java

Duration Feb 2009 – Apr 2009

Project Abstract

Project Garuda for Indonesia has the requirement to provide for retail customers a combination of Combined and Account Level Statements with a monthly run either by Print Fulfillment (via 3rd Party) or e-Statements email (Push Model) as a default option.

All Statements need to be archived in original format, with initial retrieval by Bank staff and future capability for customers to (Directly-Pull) from archive via On Line Banking using Internet-Ready File (AFP to PDF)

The primary objective of this application is to provide with a solution that will:

Provide retail customer a combination of combined and Account level statements.

Provide print statement or e-mail statements on a monthly basis.

Archive the statements for retrieval on an adhoc basis.


Writing stored procedures, packages and functions and other database objects. Unit testing.



of 9 Dated: 04/15/23


Project #2Logitech - SCP Dashboard

Project Technologies Oracle PL/SQL, Unix Shell Scripting, OBIEE, OWB

Duration Apr 2008 - Dec 2008

Project Abstract

The SCP Dashboard data warehouse system is supposed to generate is supposed to source data from Oracle ASCP and generate reports on orders, supplies, demands, etc.

The objective of Logitech Supply Chain Planning Dashboard project is to enable reporting and analytics for Logitech worldwide planning.


Writing stored procedures, packages and functions and other database objects. Unit testing.

Create ETL mappings in OWB



of 9 Dated: 04/15/23

Abhijit Kumar Singh

Project #1Novartis - Report Central ODS

Project Technologies Oracle SQL, PL/SQL, Unix shell scripting, Cognos

Duration Jan 2007 – Dec 2007

Project Abstract

Report Central is sales and marketing data warehouse which revolves around events conducted by Novartis and its third party vendors to promote its brands and products.

The events provide activity information, most of which comes from NEC field application, vendors and geography information, which comes from the ROSTER application.


Minor and major change requests related to PLSQL and Unix shell scripting to the system.

SQLs for ad hoc report generation.

Fixing PLSQL job failures

Creating monthly status reports.

Page 1 of 9 Dated: 04/15/23

abhijit - oracle plsql, teradata, shell scripting

Documents