Mohan Sai Tejaswi Dasari

Project:

Dubai Islamic Bank – Digital Platform

Description:

• As part of this project, we process to run the job, Participated in all phases of development life – cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs
• Changes to be made according to Change Requests in existing developed jobs
• Involved in production and deployment activities, creation of the deployment guide for migration of the code to production.

Tools:

Talend DI, DBEAVOUR

Project :

SBI - Next Gen DWH

Description:

• It is a migration project in which upgrading the performance of the system hardware and software also optimise the job for better performance

Responsibilities:

• Working with operations team
• Checking job failures in DataStage and working on resolution
• Working on Adhoc requests to pull data from current system
• Monitoring DataStage jobs and scripts which are scheduled in TWS and analysing issues if there are any failures.

Tools:

Datastage, TWS, WINSCP, Unix

Project:

Florida Power & Light Co, NEE

Responsibilities:

· Create and maintain Talend jobs to extract data from different source and load into Target fact tables used for reporting.

Extensively worked with delimited files, .data files, oracle components, Kafka Components and Excel files. Partnered with the Business team in gathering and analysing business requirements from various sources, ensuring the Business needs. Done the Unit testing and UAT for the developed jobs for different iterations

Tools:

Talend DI, Redshift

Project:

Dubai Islamic Bank

Responsibilities:

· Involved in Client’s requirement call to gather requirements and designed, architected the solution

· Created mappings which extracts the data from the flat file, multiple databases and transforms it based on the requirement

· Using ETL tool DataStage, create extract job, which extracts the data

· Implemented best practices of pattern development by making the pattern shared across multiple similar environments.

· Responsible for Procedural documentation.

· Leveraged technical skills in collaboration with client team to diagnose problems.

· Created numerous technotes

Tools:

Talend DI, Datastage, Big data, SQL

Description:

Reporting is very important aspect of any organization as it helps to take decisions, monitor performance. Report engine is a tool developed keeping in mind the need of all kinds of report required by management, customers and operational peoples.

Responsibilities:

• · Member of warehouse design team in creating dimension tables based on specifications provided by managers.
• · Designed various jobs for extracting data from various sources involving flat files and relational tables.
• · Developed jobs using Talend for data loading.
• · Importing Source/Target tables from the respective databases.
• · Understanding existing business model and client requirements.
• · Extensively involved in development of jobs using various transformations of Talend according to business logic.
• · Preparing Design document for ETL processes and databases.
• · Co-ordination between development team and client.
• · Changes to be made according to Change Requests in existing developed jobs.
• Talend platform setup on Windows

Tools:

Talend DI, SQL