Prashanth Reddy Desani

469-618-0775
[email protected]
Summary:
 5 years of experience in development, administration, maintenance, support and enhancement in Talend
Real Time Big Data Platform for Big Data and MS SQL Server
 Have a clear understanding of Data Warehousing concepts with emphasis on ETL and life cycle
development.
 Expertise with Talend Data Integration and ESB frequently used components like tMap, cTalendJob,
tJMSOutput, tContextLoad, tFixedFlowInput, tXMLMap, tSystem, tJavaRow, tSOAP, tESBProviderRequest,
tESBConsumer, tRunJob and more.
 Good Knowledge in creating route using a data service, WSDL and calling a SOAP web service
 Well versed in developing various database objects like packages, stored procedures, functions, triggers,
tables, indexes, constraints, views in MS Sql Server.
 Experience in Debugging sessions and mappings, Performance Tuning of the Sessions and mappings,
implementing the complex business rules, optimizing the mappings.
 Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, XML
Files) to load into Data Warehouse/DataMart targets.
 Developed Type-1 and Type-2 SCD for mappings to current and historical data.
 Worked in Agile environment and using Atlassian tool set including JIRA, Confluence, Bit Bucket and
Bamboo for Continuous Integration.
 Experience in Database development skills using Oracle PL/SQL to write stored procedures, functions,
packages and triggers.
 Extensive development, support and maintenance experience working in all phases of the Software
Development Life Cycle (SDLC) especially in Data Warehousing and Business Intelligence.
 Migrated the code into QA (Testing) and supported QA team and UAT (User).

EDUCATION:
 M.S in Computer Science, Univ of Illinois- Springfield

TECHNICAL SUMMARY

ETL Tools Talend Real Time Big Data Platform 6.4.1

Databases SQL Server 2016, Teradata, Oracle,MySql

Data Access Tools TOAD, SQL Navigator

Programming SQL, PL/SQL

TopGolf/ Synapsis INC. Dallas, TX Feb 2019- Till Date

Responsibilities:
 Provided Talend solutions for various projects at Topgolf, including international and US venue source
systems, vendor data and Topgolf data into an analytical presentation layer for consumption. Delivered
outstanding solutions utilizing multiple leading technologies in marketplace. Developed Talend Big Data
ETL jobs for a rapidly expanding company. Key member of the SQL Server to AWS migration team.
Migrating all of our current tables, data into the AWS data lake ecosystem, using S3JSON, Talend, Athena
and Redshift using the ingest, model, enhance, transform, delivery method.

Environment: Talend Real Time Big Data Platform for Big Data 6.4.1, MS SQL Server 2016, AWS CLI, AWS Redshift,
S3, Athena, MySQL, ActiveMQ, Java, JIRA, Git, Talend Administration Console.

The Boeing Company / Synapsis INC. Seattle, WA July 2018– Feb 2019
Talend Developer

Responsibilities:
 Key player in developing Talend jobs to ingest Saudi Arabian Airlines (SVA) and Aircraft Maintenance and
Engineering System (AMOS) data into the ADW Inbound layer to support operational metrics for BGS
Fleet Care program using Talend Real-time Big Data Platform.
 Currently involved in the development of Flight Following application to support flight scheduling and
flight execution data from the Airline Customer to the Gold Care AMOS application by creating services
and routes using cAMPQ, cTalendJob, cProcessor, tESBProviderRequest,tJMSOutput,tXMLMap and
tESBProviderResponse
 Implemented FTP operations using Talend Studio to transfer files in between network folders as well as to
FTP
 Server using components like tFileCopy, TFileArchive, tFileDelete, tCreateTemporaryFile, tFTPDelete,
tFTPCopy.
 Experienced in using debug mode of Talend to debug a job to fix errors. Created complex mappings using
tHashOutput, tHashInput, tNormalize, tDenormalize, tMap, tUniqueRow, pivot To Columns Delimited etc.
 Used tRunJob component to run child job from a parent job and to pass parameters from parent to child
job. Created Context Variables and Groups to run Talend jobs against different environments.
 Written complex PL/SQL procedures for specific requirements
 Used tParalleize component and multi thread execution option to run sub jobs in parallel to increase job
Performance.
 Performed data manipulations using various components like tMap, tJavaRow, tFixedFlowInput,
tOracleRow, tJoin, tReplicate, tFilter and many more.
 Used reusable components like routines, context variable and globalMap variables.
 Published Talend Jobs as SNAPSHOT to TAC, created CRON Triggers and did a release candidate to support
monthly releases as a Talend Administrator.
  Maintaining the project in GitLab VCS as owner and merging the code back to master from individual
branches after the end of each release.
 Monitored the daily runs, weekly runs and adhoc runs to load data into the target systems.
Environment: Talend Real Time Big Data Platform for Big Data 6.4.1, MS SQL Server 2016, MySQL, Oracle,
Teradata, ActiveMQ, Java, JIRA, Git, Talend Administration Console.

Power School Group LLC / Synapsis INC. Roanoke, VA October 16– Jun 18
Talend Developer

Responsibilities:
 Participate in project Sprint Planning, Refinement and Retro.
 Coordinated with Product owner on a regular basis to discuss the business requirements.
 Involved in the Talend Development Standards document which describes the general guidelines for
Talend developers, the naming conventions to be used in the Transformations and development and
production environment structures.
 Created complex mappings in Talend 6.2.1 Big Data Edition using tMap, tParallelize, tJava,
tAggregateRow, tFixedFlowInput, tFlowToIterate, tMSSqlInput, tMSSqlRow etc.
 Created Talend jobs using the dynamic schema feature.
 Worked on Joblets & Java routines in Talend
 Published events to Kafka from Talend and consumed events from Kafka.
 Implemented Error handling in Talend to validate the data Integrity and data completeness for the data
from the Flat File.
 Optimized the performance of the mappings by various tests on sources, targets and transformations.
 Wrote complex SQL queries to take data from various sources and integrated it with Talend.
 Developed Type-1 and Type-2 SCD for mappings to current and historical data.
 Incorporated business logic for Incremental data loads on a daily basis.
 Written complex PL/SQL procedures for specific requirements.
 Used Parameter Variables and Mapping variables for incremental data feeds.
 Schedule Talend Jobs using Job Conductor (Scheduling Tool in Talend) - available in TAC.
 Worked with Microsoft SQL Server management Studio while Implementing Unit Testing.
 Provided support to QA team during testing of solutions.
Environment: Talend Real Time Studio for Big Data 6.3.1, MS SQL Server 2012, MySQL, Apache Kafka, Java, JIRA,
Git, Talend Administration Console.

Bose Corporation / Synapsis. Boston, MA Feb 15 – Sep 16

Description: Data extraction from various sources, cleansing data, transforming data according to the business
needs and loading into Repository used by end users.

Responsibilities:
 Assisted in creating fact and dimension tables as per requirement.
 Used Informatica client tools such as Source Analyzer, Warehouse designer, Mapping designer, Mapplet
Designer, Transformation Developer.
  Developed various transformations like Source Qualifier, Update Strategy, Lookup & Expression
transformation, Expressions and Sequence Generator for loading the data into target table.
 Developed numerous Complex Informatica Mappings and reusable Transformations.
 Migrated existing Informatica Jobs to Talend Using ETL Talend Studio for Data Integration 6.0.1
 Designed and created complex source to target mappings using various transformations inclusive of but
not limited to Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
 Configured mappings to handle updates to preserve existing records using Slowly Changing Dimensions
SCD Type-2.
 Created stored procedures and functions, as per requirements in PL/SQL.
 Performed Performance tuning of targets, sources, mappings and session.
 Used UNIX scripting while writing cron jobs for batch processing.
 Used Test Director to log and keep a track of defects. Worked with Test team in resolve defects.
 Documented Technical specifications, business requirements and functional specifications for
development of ETL mappings to load data into various tables.
Environment: Talend Open Studio for Data Integration 6.0.1, Informatica Powercenter, Oracle 9i, DB2 UDB,
Teradata, UNIX, SQL Server, PL/SQL, SQL*Loader.