Arka Chatterjee
Abinitio Developer
Newark,DE
Summary
8+ years widely Experienced Abinitio Graph and Metadata HUB Development
Overview
15
15
years of professional experience
Work History
Abinitio Metadata Hub and Abinitio Application developer
Citibank NA
04.2014 - Current
- Using MDHUB tool, creating lineages and extracting reports, generating dictionaries and lineages, publishing to ICG data Catalogue, monitoring consent order released regulatory reports and different use cases.
- Major Abinito development of multiple requirements from the scratch or legacy application enhancement, new mapping and requirements.
- Requirement Analysis of different source and downstream systems.
- Preparing higher level and lower-level design document for the requirement.
- Developing and enhancement of the application on ETL tools using Abinitio as per client request.
- Legacy PLSQL, Proc, Unix codes bug fixes and application enhancements.
- Unit testing and bug fixing of the application.
- Preparation of Design documents, Functional test cases, Use-cases and execution of test cases.
- Code Checking, Packaging, versioning and migration codes to higher environments using GIT, SVN and uDeploy.
- E2E or UAT support with partner systems.
- Oracle 19C migration in Prod parallel environment.
- Stabilization of prod parallel Server, DB and making it prod ready.
- Project Citi Institutional Consumer Group (ICG)-Treasury Trade Solution (TTS) aims to automate enterprise reporting needs by building a Global Information Warehouse (GIW). This would improve the Business Intelligence and Process Management capabilities of various systems within Citi. ETL (Extraction Transformation and Loading) works as a data transformation layer interfacing between various source and downstream systems. Processes are developed using Abinitio, Unix and PLSQL technologies. Downstream and partners extract the data from Warehouse and generate reports based on this for clients.
Lead Developer
Tata Consultancy Services Ltd
Newark, DE
12.2010 - Current
- Widely experienced on Abinitio Metadata hub tool usage, data lineage, data extraction and report generation, data catalogue, dictionary and lineage generations, use cases.
- Experience of different types of Metadata hub imports, reports, dataset and data elements, collection, techystem, tech groups, mapping, applications assignments for multiple types of technologies including Talend, Abinitio, Mainframe based on different extractors and excel rule imports.
- Exposure of regulatory reports, consent orders and BFS terminologies and their implications.
- Over 8 years of Ab Initio Consulting with Data extraction, mapping, Transformation and Loading from Source to Target Databases, data sources, files with different kind of business requirements from client.
- Experienced in legacy code to Abinitio migration of existing functionalities, delivered in compressed time-lines to support the Project Management Scope, Schedule, and Budget to meet the customer's requirements.
- Proficient as a graph designer in GDE with all kind of components and ETL designed based on fundamental concepts of parallelism, normalization, partition, de-partition concepts and their utilization in business domain.
- Worked on both batch and continuous processes which primarily extract data from Source systems(tables or data files) and processes as per client business requirements and finally loading the data into WH and MART or handoffs for downstream report generation.
- Numerous Abinitio graphs developed with GDE over the years with from the scratch development experience, worked on different GDE version like 3.1, 3.2, 4.0 etc.
- Well experienced with built in GDE components like I/P or O/P file/table, Reformat, Filter by expression, Gather, Merge, Concatenate, Replicate, Rollup, Scan, Sort, Partition, Join, Normalize, Call Web Service, run program etc.
- Great concepts working with expanded rollups, key change functions, indexes and all such inbuilt utilities to achieve desired result.
- Proficient with DB components like Join with Db, input/ update table etc.
- Wide exposure on using input/output data source as flat files or xml/excel or Oracle datasource.
- Expertise in string handling, math operations and data type conversations.
- Vast experience with continuous graphs and worked with Subscribe and Publish components of continuous flow.
- Proficient with Abinitio queues( Subscribers and recycle), MQ and JMS queue components, lookups and their operations and functions, Error and Log handling and Reject frameworks, concepts of checkpoints and phases and their impacts on graph designs.
- Experienced on Metadata Hub configuration for lineage view of Abinitio jobs, graph and pset functionalities built in GDE.
- Efficient on graph dependency analysis, resolving conflicts or errors during dependency analysis.
- Vast experience on metadata hub datasource, dataset and graph/pset connection and importing abinitio applications in Metadata hub by creating dbc files and data source connections, testing connection, system and application creation, application assignment workbook standard excel mapping, standard oracle connection and graph import rules.
Application Development(Developer)
Bank of Dilligenta
Kolkata, India
07.2013 - 04.2014
- Customer specific java application build and deployment in weblogic server 10.3.6 using ant scripts.
- Configuration management of manage servers in unix physical hosts.
- Project Dilligenta Banking Solution Carried out the following activities: Created packages based on different development units, Promoted those packages in higher environments.
Team member
UCO Bank
Kolkata, India
12.2012 - 03.2013
- I was part of the back-end database verification and operations using MySQL.
- Project It was a government project on banking applications. The prime objective of UCO FI was to build an application deployed in POS devices which will be handled by agents employed by third party vendors and those agents will be working in rural and urban areas enrolling people and performing online device based transactions using demographic and biometric authentication.
- Carried out the following activities: Verified data based on business volumes, Generated reports on day end, month end and periodical data.
Team member
British Telecom INC.
11.2011 - 08.2012
- Deployment through weblogic application server and JVM tuning.
- Project CMPS application deployment and weblogic application server configurations.
- Carried out the following activities: Created builds and jars to be deployed in model environments, Created weblogic start/stop/manage scripts, Tuned weblogic console and JVM.
Education
Bachelor of Technology - Electronics & communication Engineering
West Bengal University of Technology
01.2010
Designation
Assistant Consultant
Organization
Tata Consultancy Services Ltd
Personal Information
- Relocation: Okay to relocate
- Date of Birth: 05/03/88
Timeline
Abinitio Metadata Hub and Abinitio Application developer
Citibank NA
04.2014 - Current
Application Development(Developer)
Bank of Dilligenta
07.2013 - 04.2014
Team member
UCO Bank
12.2012 - 03.2013
Team member
British Telecom INC.
11.2011 - 08.2012
Lead Developer
Tata Consultancy Services Ltd
12.2010 - Current
Bachelor of Technology - Electronics & communication Engineering
West Bengal University of Technology