JAYANTA SENAPATI

Seasoned Associate Principal - Architecture with a robust history at LTIMindtree and significant tenure across esteemed firms like JP Morgan India. Expert in ETL and Talend Integration Studio 5.3, showcasing exceptional problem-solving skills and a proven track record in enhancing operational efficiency by over 30% in retail banking and capital market sectors.

• Level ‘A’ Certification from DOEACC, New Delhi, MM/DD/YY
• OCA (Oracle Certified Associate for SQL and PL/SQL), MM/DD/YY
• Certification in Talend Integration Studio 5.3, MM/DD/YY
• NCFM – Financial Markets Beginner’s Module, 07/01/15
• LTI People Manager Program with Corporate Governance and Compliance, MM/DD/YY
• MBA from Sikkim Manipal University (DL), 07/01/15

Talend Integration Studio 5.3, Oracle PL/SQL, Hive, Snowflake, Core Java, Windows 10, Unix, BigData (CDH 5.14), Autosys, Genkins, Git, RLM, Jira, Retail Banking, Motor Insurance, HP Asset Management, Capital Market/Trade Finance, Retail Supply Chain

01/15/30

• English
• Hindi
• Oriya

Data App Rationalization – Symphony Migration (JCI), 20, 02/01/24, Present, Symphony is OnPrem EDW built for TYCO Internationals two major segments Products and Retail Business. Data from various applications such as BAAN, JD Edwards, Pronto, SAP, SAGE and other ERP systems are fed into the EDW and migrated to Snowflake Cloud platform., Co-ordination with ERP source owners to address ingestion related issues on source connectivity and source table access to ADF platform., Single point of contact for the developers to address source side data issues., Data validation and providing sign off on QA testing., Mapping of Symphony On Prem Dimension and Fact tables into Cloud Enterprise Data Model., Creation of Snowflake complex views for Qlik presentation layer business reports., Preparation of SQL scripts for migration of OnPrem Historical data into Cloud Data Warehouse., Migration of MSTR Business reports into cloud platform., Azure Data Factory, Snowflake, DBeaver Global Product Operations Data Enrichment (JCI), 10, 12/01/21, 01/01/24, To build a flexible, dynamic solution that provides a full view of Global Products Supply Chain Data. To have access and visibility up to 75% of the Global Product customer, supplier, quality, warranty, inventory and forecast data so that data focused decisions can be made quickly to improve supply chain issues such as part shortages and delivery disruption. Drive improvements in customer on time delivery that currently has a 20% gap compared to fiscal year plan. Data ingested from 65 ERP legacy systems in Azure data lake against 17 business KPIs., Preparation and validation of Source to Target mapping document (STTM) across ERP sources., Co-ordination with ERP source owners and stakeholders to address data discrepancies., Single point of contact for the developers to address mapping related queries and data issues., Data validation and providing QA sign off., Successful ingestion of around 65 ERP source data into Azure data lake against 13 KPIs for end user analysis., Azure Data Factory, DBeaver, Snowflake, Hive Data Application Rationalization - JCI, 30, 10/01/20, 11/01/21, JCI App Rationalization program is the migration of On-Premise legacy ETL warehouse to Azure cloud. This includes consolidation and migration of approx. 20 data stores and reporting slices to cloud with cost-effective architecture., Analysis and preparation of low-level design and discovery documents for existing Talend ETL modules, including transformation and integration jobs across various projects., Preparation of Source to Target mapping document for development team., Co-ordination with development team and tech source owners on requirement gathering and data ingestion schedules., Responsible for SIT/UAT Tech support., Mentoring and providing technical support to junior team members on Talend and ADF tools., Talend Data Integration Studio 6.3, Hadoop, Hive AML (Anti Money Laundering) – CITI Bank NA Region, 8, 06/01/16, Present, AML is Citi’s Anti Money Laundering System monitors electronic transactions involving internal accounts, external entities or geographies deemed risky either because of the geography of the transaction is high risk or because of the customer is rated high risk. The application is broadly broken down into Data Acquisition and Assessment performed in L1 and L2 layer and the Transaction monitoring and Alert Generation at L4 layer. Required Alerts are sent to CMT/NextGen team., Preparation of codebase from Scratch for Data enrichment and reporting modules by analyzing the source to target mapping documents., Co-ordinates with PMA and tech team regarding requirement gathering and getting the sign off for the Jira items raised for subsequent release cycles., Responsible for SIT /UAT Code Deployment and Support., Running SIT/UAT batches through AMM framework for RBD., Preparation of Ausosys jils for batch processing., BigData, Hive, Spark, Unix, Autosys, Git BSER (Balance Sheet Exception Reporting) – CITI Bank, 6, 08/01/13, 05/01/15, BSER refers to Balance Sheet Exception Reporting which quantifies trade exceptions by age and value and makes the trade owners accountable. It empowers managers with on-line daily dashboards providing drill down to transaction level details. It generates and maintains a daily summary level feed to contain all auto matched, unmatched and manually matched items for different streams. The System provides daily break reporting for Senior Management, Operations line, Middle office and Operations control., Design and Development of ETL jobs which are made generic so that it can cater to accommodate feeds from different source tech to maintain the BSER data warehouse., Regression testing for BSER streams as and when upstream systems new feeds on-boarded and reference data changes occur., Co-ordinates with PMA and tech team in regard to requirement gathering and getting the sign of for the Jira items raised for subsequent release cycles., Performing admin tasks using Talend Admin Console (TAC)., Responsible for L3 Production fixes and support., Oracle 11g SQL, PL/SQL, Unix, Talend Open Studio Ver5.3 Global Trade Business Intelligence Repository, 13, 04/01/12, 06/01/13, GTBIR is a browser-based application that provides real time tracking of the back-end data processing systems. Data taken from different legacy systems like GTS, TPS and APAR and performs the ETL processes to clean and transform the data into fact and dimension tables. Transactions are sent to BIR as messages on the UM message queue. The GUI is written in Flex complied to FLASH connecting to a JAVA app that sources data from SSAS OLAP cubes or an Oracle database as appropriate. The BIR data warehouse is the data source for the OLAP SSAS layer., Design and Coding of PL/SQL programs for online and historical loads of data to BIR Data warehouse., Preparation of DW Release instructions and scripts for subsequent QA/UAT releases and carrying out the release activities by coordinating with SCM and DBA team., Improvisation of historical data load process and deployment process for high volume of staging data through index management and tuning of data patch scripts which reduces the data load timing to more than 50., Oracle 11g SQL, PL/SQL, Unix, Java Flex 4, SSRS Activity Based Costing for CITI Bank, 10, 02/01/11, 04/01/12, ABM (Activity Based Management) is a part of CITI-GDOS determines unit cost per execution of trade. It quantifies manual interventions and associated unit cost per trade/financial transactions thereby helping to identify and manage operational risks and increases transparency and productivity. Manual settled trades comes through source systems loaded into warehouse through ETL and Peoplesoft derives the unit cost per trade and finally Adhoc BO reports published out of that., Design and Development of ETL jobs for Staging and Data Layer as per estimated timelines., Data Modeling for Fact and Dimension tables with maintenance for type1 and type2 dimensions., Unit testing ETL code to ensure it can be delivered and run in a system testing environment., Validating the summary data., Oracle 11g SQL, PL/SQL, Talend Integration Studio Ver4.0.3, Unix HP Asset Center, CITI Bank, 8, 08/01/09, 01/01/11, HP AssetCenter enhances service and asset costs, mitigate security and compliance risks and align IT with business objectives. It simplifies asset tracking by consolidating assets and each configuration item into a central repository. It defines and manages the complex relationships between hardware and software asset classes like Blackberry (Telephones), Desktop Computers, Servers, Mainframes, contracts and costs providing consistent and accurate inventory information., Implementing the P2P module into AssetCenter., Involved in new cost center migration of portfolio assets., Handling change requests and production issues through an issue tracking system JIRA and VT., Managing off shore team of around 4 members., Oracle 10g, Talend Open Studio Ver 3.0, HP Asset Management Bunge Data Center, 10, 05/01/08, 08/01/09, Bunge is into commodity trading business. It has this supply and demand data in unstructured format (Excel and Flat files). Data is transformed into RDBMS form (Oracle) which is finally exposed to the BI tool (Hyperion). It helps Bunge to understand the History of Commodity Productions – Consumptions across different parts of the world. The whole Process requires Extract-Transform-Load mechanism which is done by PL/SQL coding., Daily Upload of MST and Detail files using AB-Initio (ETL tool)., Developing stored procedures and functions to load the MST and DTL files to Oracle Database tables (SND and SND_ History)., Generating SQL Scripts to load the data to Business Intelligence Reporting Tool (Hyperion) which gets analyzed by ER (Economic Research) team., Handling Database Performance issues by managing Indexes and tablespaces., Oracle 10g, Hyperion, Unix Kastle Universal Lending System, 8, 05/01/07, 04/01/08, Kastle ULS is one of the Banking Product of 3i Info-tech for retail loan management system having 3 modules LO (Loan Origination), LM (Loan Management) and LC (Loan Collection) integrated into one system. Kastle is being implemented for different commercial banks across the globe. LM module got implemented and integrated with LO for BTA at Kazakhstan., Handling Change Request’s by coordinating with client and off-shore leads., Defect tracking by debugging with PLSQL developer., Development and changes to procedures, functions and views in regard to the defects and change requests., Merging of LM module with its masters into LO module at client’s production server., Export and Import of schemas to client’s UAT., Oracle 9i, JSP, PL/SQL Renaissance Ver.3- Application for Insurance System, 12, 07/01/05, 04/01/07, Renaissance is a pioneer motor insurance product from STG- India got implemented with different clients at U.S. General Motors is one of the client. It provides insurance to its dealers for motors and buildings. The Key modules in R3 are Application Entry, Issuance, Endorsement, Cancellation, Reinstatement and Renewal. Insurance coverage for the building as a new line of business got added as an enhancement to the existing product., Understanding client’s requirements through Functional Requirement specifications (FRS)., Creating IDF (Issue Diagnosis Form) for root cause analysis of defects and impact analysis., Customization, Integration, peer code reviews and unit testing of the modules., Managing the production issues followed by unit testing., JSP, ORACLE 9i, SQL, PL/SQL, Reports-6i

09/02/20, PUNE, JAYANTA SENAPATI

Around 19.7 years of relevant IT industry experience in Banking and Manufacturing domain with strong technical proficiencies in Hive/Snowflake, Talend Integration Studio, Data Warehousing and ETL. Experience in Analysis, Designing, Data Modeling, Development, Implementation and Support for OLTP and Data Warehousing applications. Working closely with business stakeholders to understand business needs and provide mapping documents for the development team. Client /Business user’s interaction at all phases of development activities, in regard to requirement gathering, change requests management, delivery and release planning. Strong understanding of the principles of Data Warehousing, Fact and Dimension tables with star schema modeling and mapping of new entities into existing EDM (Enterprise Data Warehouse). Experience in backend programming including schema and table design and building complex views in Hive and Snowflake for reporting. Validation and Reconciliation of report data after the ETL process as per requirement and deliver to business. Leading a team in regard to work allocation and ensuring timely delivery of work items to client by Onsite/Offshore team collaboration on Agile delivery model. Preparing project related documents like functional design document, detailed technical design documents and project process flows. Providing Knowledge Transfer sessions on functional and technical aspects of project to new or fellow team members.

• Passport Number: U2125541
• Date of Birth: 07/01/74
• Gender: Male
• Nationality: Indian
• Marital Status: Married