SKILLS EVALUATION SHEET

Candidate Name: Satya Narayan Sabato

Total Experience: 7 Years

Relevant Experience: 7 Years

Notice Period: Immediate

Name of
Projects No: of
in which the months
Skills possessed by the candidate to perform the Mandatory Description of work done
skills were worked in
role efficiently / Optional using the skill
used (add each
rows if Project
necessary)

 Well versed in Client-

Server application
development using
Oracle 11g/10g, SQL
Server, PL/SQL, TOAD
and SQL Developer.
 Developed ETL mappings
using Informatica to
M 81 Months
implement the business
requirements.
 Worked on Snowflake
Schemas, Star Schemas
and Data Marts.

SQL, PL/SQL, ETL Informatica

 MR. SATYA NARAYAN SABATO
Cell:+91-7264936380(India)
Email: [email protected]
Location preferences: India

Seeking association with progressive organization that gives me scope to update my skills according to latest trends

PROFESSIONALSUMMARY

 Around 7 years of working experience in Oracle, Unix, Data warehousing and Informatica 9.x, 10x.
 Strong Knowledge on Informatica and clear understanding of Software Development Life Cycle (SDLC) and
Agile Methodologies in Data Warehousing.
 Developing ETL processes like Data Extraction, Transformation and Loading using Informatica Power Center.
 Extensively worked on Informatica Power Center Designer, Workflow Manager and Workflow Monitor tools.
 Extensive 5+ Years’ experience in migrating data from legacy platforms into the cloud with Informatica Power
center and Oracle.
 Worked on Snowflake Schemas, Star Schemas and Data Marts.
 Worked with different data sources like Flat Files and Oracle.
 Well versed in Client-Server application development using Oracle 11g/10g, SQL Server, PL/SQL, TOAD and
SQL Developer.
 Expertise in using sub query, aggregate functions and Joins.
 Having good knowledge on SQL, PL/SQL and Linux Environment.
 Having good knowledge in Store Procedure, Function, Trigger, Cursor and Package.
 Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
 Strong in Analytical Functions, Partitioning, Merge and Materialized Views.
 Good communication skills, Interpersonal, Team co-ordination and presentation skills.
 Consistently delivered secure, reliable & robust solutions which increased operational efficiencies, reduced
business risk exposure and accelerated digital transformation.
 Adept at all stages of project lifecycle - from business requirements, functional and technical discussions to
development, testing, implementation support, production release and completion.

PROFESSIONALEXPERIENCE

May’17-Jul’18: CMS IT Services Pvt. Ltd., Mumbai as Technical Support Engineer.

Jul’18-Apr’20: ASM (Altencalsoft Labs) Enterprise Solutions Pvt. Ltd., Mumbai as Senior
Software Engineer.
April’20-April’22: HCL Technologies Ltd., Pune as Senior Software Engineer.
April’22 to Feb Tech Mahindra Ltd., United Kingdom as Senior Software Engineer.
2024:

EDUCATIONALBACKGROUND

Bachelor Degree in ‘dept. of CSE’ from BijuPatnaik University of Technology, Odisha in the year of
2013.
Diploma Eng. In ‘dept. of IT’ from SCTE & VT of Odisha in the year of 2010.
Matriculation from Board of Secondary Education, Odisha in the year of 2007.
TECHNICALSKILLS

 ETL Tools :- Informatica 9.6/10.2

 Databases :- Oracle 10g/11g, Teradata 13, DB2 9.7, SQL
 Cloud DB:- Snowflake
 Language:- Python
 Operating System:- Windows XP,7/8,10, LINUX
 Tools:- SQL Developer, SQL Assistance, Putty, FileZilla, Winscp
 Ticketing Tools:- Service Now, HPSM, Remedy, Helix

PROJECTEXPERIENCE

CLIENT NAME: Virgin Media O2 UK Limited, London, England, UK.

DESCRIPTION:
Product : Card Payment System & Common Payment Interface
Role : Informatica Developer
Technology : Informatica power center 10.2, UNIX, Oracle 11g, SQL, PL/SQL.
Duration : April 2022 to Feb 2024
Team Size : 7 Members
Virgin Media O2 (legally incorporated as VMED O2 UK Limited) is a British mass
media and telecommunications company based in London, England. The company was formed in June 2021 as a 50:50
joint venture between Liberty Global and Telefónica through the merger of their respective Virgin Media and O2
UK businesses.
It is one of the largest entertainment and telecommunications operators in the United Kingdom, with around 60 million
customers in 2023.
 CPS handles credit and debit card transactions, builds on the on-line 3-D authentication services (verify by Visa),
by ensuring that it’s PCI (Payment Card Industry) compliance.
 CPI supports a number of components that enable prepay mobile phone credit and reversal to be applied on
customer’s handsets through ETopup and Vouchers.

RESPONSIBILITIES:
 Developed ETL mappings using Informatica to implement the business requirements.
 Used Informatica file watch events to pole the FTP sites for the external CSV files.
 Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections
and relational connections.
 Designed workflows with sessions, commands, event waits and used Informatica scheduler to schedule jobs.
 Made use of pre-session command and post-session success/failure commands for moving the source files to
processing locations and archiving after they are processed.
 Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and
Aggregator to create robust mappings in the Informatica Power Center Designer.
 Worked on Snowflake Schemas and Data Warehousing.
 Worked in production support for monitoring of ETL workflows, performing workaround in case of failure and
involved in root cause analysis for permanent fix.
  Analyzing the data received from source files for data quality purposes and prevents failure of workflow due to
unwanted characters or unagreed columns.
 Weekly/Monthly status calls involving offshore team and client
 Understand issues on production and share propose solution.

CLIENT NAME: Deutsche Bank

DESCRIPTION:
Product : GTB – Instant Payment Processing
Role : Informatica Developer
Technology : Informatica 10.2 , UNIX, Oracle 11g, SQL, PL/SQL.
Tools : Informatica 10.2 , DAP(Fabric)
Monitoring tool : Geneos Active Console, Splunk
Duration : April 2020 to April 2022
Team Size : 10 Members

Global Transaction Banking (GTB) division is not just a market leader in cash management, trade finance and securities
services, it is also at the forefront in the provision of strategic thinking and the creation of global solutions.

Instant payments can be defined as payments from one bank account to another that are completed and confirmed for
both the payer and the payee within less than one minute, they operate 24*7*365 and when successful are final and
irrevocable.

The GTB-IPP project handles the processing of instant payments over regions like APAC and EMEA. There are majorly
two applications which separately handles the IPP flow for EMEA and APAC.

 B@FIR-SEPA-RTE:- This application is responsible to process EMEA instant payments. The Sepa Instant
Credit Transfer scheme sets the standard that digital payments must be executed in 10 seconds or less.
 Galileo:- This application is dedicated for APAC instant payment (India – UPI transactions, Sri Lanka)

There are multiple components which are internal part of above two applications which is also share of our project to
support and ensure the payments should process within defined SLA and successfully like RTE, DB-SIS, HRS,
HOTSCAN, DBDETECT. RTE (Real time Engine) is a new product of Deutsche Bank Processing Instant payments.
To process Instant payments in real time large number of interfaces have changed from batch-based processing to
message based Real time processing. All other various applications perform various checks for completing a transaction
Like filtering check, Fraud, Embargo, fund Check, Account validation check etc.

RESPONSIBILITIES:
 Developed ETL mappings using Informatica to implement the business requirements.
 Used Informatica file watch events to pole the FTP sites for the external CSV files.
 Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections
and relational connections.
 Designed workflows with sessions, commands, event waits and used Informatica scheduler to schedule jobs.
 Made use of pre-session command and post-session success/failure commands for moving the source files to
processing locations and archiving after they are processed.
 Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and
Aggregator to create robust mappings in the Informatica Power Center Designer.
 Worked in production support for monitoring of ETL workflows, performing workaround in case of failure and
involved in root cause analysis for permanent fix.
  Analyzing the data received from source files for data quality purposes and prevents failure of workflow due to
unwanted characters or unagreed columns.
 Developed data models according to company standards. Used Oracle Connect to extract multiple database source
systems to single analytical system for large databases and also 24*7 Production support for data warehousing
 Monitor system integrity through daily system checks, to ensure a high standard of service is provided to clients.

CLIENT NAME: Reliance Jio Infocomm Pvt. Ltd., Mumbai

DESCRIPTION:
Product : Reliance R4G Implementation
Role : Informatica Developer
Technology : Informatica power center 9.6.1, UNIX, Oracle, SQL, PL/SQL.
Duration : July 2018 to April 2020
Team Size : 9 Members

The company which I am working in Telecom, is one of the India’s largest company in telecom sector, now
company stated to run and upgrade his services. Recently they launched 4G Service in India, in a cheap and
approachable manner.
 JIO Analytics program is an initiative to give edge to Reliance JIO business by providing the right
information to the right people at the right time, enabling them to take the right decisions.
 Development of workflows using Informatica Power center and supporting Informatica MDM System
used by the client for customer data management, Regulatory Reporting, business reporting and
marketing across PAN INDIA.

RESPONSIBILITIES:
 Migrated data from DB2 database to Oracle 11g.
 Developed ETL mappings using Informatica to implement the business requirements.
 Used Informatica file watch events to pole the FTP sites for the external CSV files.
 Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections
and relational connections.
 Designed workflows with sessions, commands, event waits and used Informatica scheduler to schedule jobs.
 Made use of pre-session command and post-session success/failure commands for moving the source files to
processing locations and archiving after they are processed.
 Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and
Aggregator to create robust mappings in the Informatica Power Center Designer.
 Worked in production support for monitoring of ETL workflows, performing workaround in case of failure and
involved in root cause analysis for permanent fix.
 Analyzing the data received from source files for data quality purposes and prevents failure of workflow due to
unwanted characters or unagreed columns.

CLIENT NAME: Edelweiss Tokio Life Insurance, Mumbai

DESCRIPTION:
Role : Informatica ETL Support
Technology : Informatica power center 9.5, UNIX, Oracle, SQL.
 Duration : May 2017 to Jul 2018
Team Size : 6 Members

RESPONSIBILITIES:

 Developed data models according to company standards. Used Oracle Connect to extract multiple database source
systems to single analytical system for large databases and also 24*7 Production support for data warehousing
 Monitor system integrity through daily system checks, to ensure a high standard of service is provided to clients.
 Escalate issues and remediation steps effectively and in a timely manner.
 Perform troubleshooting analysis and resolution of critical applications and batch processes.
 Experience in using Automation Scheduling in Workflow Manager.
 Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as
performance tuning of mappings and sessions.
 Monitored failed, long running workflows and fixed the bugs and reschedule.
 Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.

PERSONAL INFORMATION

Date of Birth: 10th May 1992 Nationality: Indian

Gender: Male Marital Status: Married

Present Address: Jagannath Bihar-2nd lane, Sri Ram Nagar, Berhampur, Ganjam, Odisha, India, Pin-760002.