Ayon Dutta

Phone: 9831240424

Objective

Over 2.11 Years of IT experience in system analysis, design and development of solutions using tools like IBM Infosphere Datastage Designer, IBM Infosphere Datastage Director, ASG Zena Workstation, SAP Crystal Report Enterprise, Oracle and Unix in the domain of US Banking and Financial sector sector. Over the years worked as developer and Support Executive with clients Huntington National Bank and Citi Bank,.Experienced in developing and supporting the datastage jobs and also worked in the promotion of reports and audit of reports using SAP Crystal Reports.

Experience Details

TCS Experience

2 Year(s), 11 Month(s)

Prev. Experience

0 Year(s), 0 Month(s)

Total Experience

2 Year(s), 11 Month(s)

Certifications

Certifications

IBM Certified Solution Developer - InfoSphere DataStage v8.5 Certification

May 2014 - Present
IBM

TCS Business Domain Academy: Certificate in Consumer Lending

Feb 2014 - Present
TCS

Work History

Work History

Datastage Developer at Tata Consultancy Services

Mar 2013 - Present
Tata Consultancy Services Limited

Project Experience Summary

  • CitiGroup Central America and South America:

 

ProjectName          

CITI-GCT-NA-PSUPP-OFF-KOL-SUPP

Client           

Citigroup Central America and South America

Environment  

IBM Infosphere Datastage Designer, IBM Infosphere Datastage director, Teradata., Oracle , Unix

Duration

Jan 2015 – Till Present

Location

Kolkata, India

Team Size & Role

6 Datastage Developer and Support

  


Project Description:

Citi, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management. The Project that I am working on largely deals with Central America and South America regions. Our job mainly deals with the credit system information and the deposit information of the customers. The various data flowing for credit systems and deposit uses ETL tools like Datastage for various transformations and providing the cleansed data to the users. Scope of my work includes providing Level2/Level 3 support for these various datastage jobs and providing a proper fix during the error situations. Also providing code fixes by proper change requests and providing various automation tools to make the process smoother.

 

Roles, Responsibility and Achievements: 

  • Providing Level2/Level 3 support for the various Datastage jobs in Citi for central America and south America regions.
  • Fixing the codes having errors by enhancing various properties of the jobs.
  • Performance tuning for various jobs and developed jobs for automating the various table checks and performing customer validations.
  • Achieved 100% success rate for the Month End processing.
  • Involved in the change management process by deploying various code fixes by proper change requests and reviewing the other critical changes.
  • Service improvement appreciation.
  • 87% success rate achieved.

  

  • Huntington National Bank USA(Ohio/Colombus):

 

ProjectName          

HNB-OHI-BLR-BIPM-SUPP-FP-2014

Client           

Huntington National Bank USA(Ohio/Colombus)

Environment  

IBM Infosphere Datastage Designer, IBM Infosphere Datastage director, ASG Zena Workstation, SAP Crystal report Enterprise

Duration

Nov 2013 – Jan 2015

Location

Bangalore, India

Team Size & Role

7 Datastage Developer and Support

  

Project Description:

Founded in 1866 as The Huntington National Bank, today Huntington Bancshares Incorporated still operates from the same Columbus, Ohio founding location in the heart of the Midwest. As of June 30, 2015, Huntington Bancshares Incorporated is a $69 billion asset regional bank holding company. The Project that I worked on includes Providing Level2/Level 3  Support to datastage jobs from various projects. Analyzing the root cause of the error and the providing a solution to fix the issue. Also working with various code fixes and automation of the manual jobs using ASG Zena Workstation. Promoting various reports and audit of the reports using SAP Crystal report Enterprise.

 

Roles, Responsibility and Achievements:

  • Providing Level2/Level 3 support for the various Datastage jobs in Huntington National Bank.
  • Fixing the codes having errors by enhancing various properties of the jobs.
  • Performance tuning for various jobs and developed jobs for automating the various table checks and performing customer validations.
  • Achieved 100% success rate for the Month End processing.
  • Involved in the change management process by deploying various code fixes by proper change requests and reviewing the other critical changes.
  • Service improvement appreciation.
  • 68% success rate achieved.
  • Customer Appreciation for quick Analysis/Fix of production defects.

  

  • Huntington National Bank USA(Ohio/Colombus):

  

ProjectName          

HNB-OHI-BLR-TCOE-2012

Client           

Huntington National Bank USA(Ohio/Colombus)

Environment  

IBM Infosphere Datastage Designer, IBM Infosphere Datastage director, ASG Zena Workstation

Duration

Jun 2013 – Nov 2013

Location

Bangalore, India

Team Size & Role

3 Datastage Developer

  

Project Description:

Founded in 1866 as The Huntington National Bank, today Huntington Bancshares Incorporated still operates from the same Columbus, Ohio founding location in the heart of the Midwest. As of June 30, 2015, Huntington Bancshares Incorporated is a $69 billion asset regional bank holding company. The Project that I Worked in the development of the ARGO project. Developed the job EJ_Extract for ARGO project. The job will read the data from a single file which will have the data from all the branches of Huntington. The data may contain the customer information or the account related information. These data are separated based on the various process lists. The Purpose of this job is to send all the electronic journal transaction from Teller database (SQL server) to Down Stream Mainframe. The electronic Journal data is been stored as BOLB data in TLR_EJDATADETAILS tables and this data need to be converted in to readable Ascii format for existing mainframe programs. A separate java job has been created to extract the BLOB data from TLR_EJDATADETAILS convert it to a readable ASCII format and creates a pipe delimited file which will be Ftp’d to DataStage. This DataStage job will read this file, formats it into a different Individual process list files and append, Sort and creates a single fixed length file which will be Ftp’d to Mainframe. DataStage reads this file and Matches the processing date from the EJ header record with processing date from date control file and then does look up with TB_Branch table with Cost center Id and replaces the region id with BANKFDIC_NUM value and then formats the fields in to its process list column creating a fixed length individual files for each and every process list. 35 individual files are created based 35 different process list and some of these files will be used by different DataStage jobs like Balancing, MIL and Cash Audit for creating respective files. Finally all 35 files will be concatenated, sorted in ascending order based on serial numbers and creates 3 different files(EJ_Daily, EJ_Stats, EJ_Sales) and ftp’s to Mainframe.

 

Roles, Responsibility and Achievements:

  • Developed the job EJ_Extract for ARGO project. The job will read the data from a single file which will have the data from all the branches of Huntington.
  • Developed a separate java job that has been created to extract the BLOB data from TLR_EJDATADETAILS convert it to a readable ASCII format and creates a pipe delimited file which will be Ftp’d to DataStage.
  • Did validations with various user data to meet the requirements.
  • Service improvement appreciation.
  • 68% success rate achieved.
  • Customer Appreciation for on time delivery of the project.

 

Skills

Skills

Datastage 8.7

Teradata

Oracle

Unix

Education

Education

Bachelor Of Engineering

Jun 2008 - Jun 2012
MVJ College Of Engineering

Qualification

Subject

Percentage/Grade

Bachelor Of  Engineering

Computer Science and Engineering

74.27

Standard Xii / H.S.C

Others

77.8

Undergraduate

Others

80.6

Ssc

Others

85.66

Passport Details

Passport Number

Date of Issue

Expiry Date

Place of Issue

K3227648

18-June-2012

17-June-2022

Bangalore,INDIA