YASEEN ASHRAF S
Sr. Integration Consultant
Bengaluru,Karnataka
Summary
Experienced Data Analyst with over 11+ years of experience working in Data Warehouse environment on various projects ranging from Telecommunication, HealthCare , Banking Corporate Security data & Food Industry.
You'll find me working within and across the business in order to understand the functional and data requirements, identifies, communicates, and endeavors to resolve data gaps that impact the
fulfillment of the business's functional requirements also identifies,
evaluates and profiling potential data sources to build the Data Warehouse.
Overview
11
11
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work History
Sr. Integration Consultant
TEK Systems India Pvt Ltd
Bengaluru, Karnataka
01.2022 - Current
- Gather requirements from the business includes Functional design document, Mapping Document, Data Flow, Scheduling details etc.
- Co-ordinate with multiple teams upstream and downstream to make sure on the data availability and to confirm whether it meets the given requirement.
- Provides estimates for the given requirement includes the man hours needed and the technologies used to achieve the output.
- Build Pipelines based on the requirement includes error handling and scheduling.
- Collaborated with upper management to drive strategy and implement new processes.
- Creating UTC document, Technical Design and Data Flow Chart.
Sr. Data Analyst
B A Continuum India Pvt Ltd.
Chennai, TamilNadu
10.2015 - 01.2022
- Having multiple roles as data modeler, ETL developer, Support engineer and leading the team of 6 people.
- Understanding the new source system, profiling the data and building data model on top of it.
- Gathering the business requirements. Understanding the new data model and preparing the LLD design document on top of it.
- Preparing the STT document and connect with team to segregate the ETL work between us.
- Development of ETL Code includes shell scripting, Autosys scheduler, PL/SQL procedures as part of the requirement.
- Performing unit testing at various levels of the ETL and actively involved in team code reviews.
- Data setup if required to complete the functional testing in SIT/UAT.
Working on the Migration component and implementation plan document for the deployment. - Performing Knowledge transfer session to my BST (Business Support Team) on the new requirement.
- Working with BST team to deploy to successfully in Production and coordinating peer teams.
Analyst
Cognizant Technology Solutions Pvt Ltd
Chennai, TamilNadu
06.2014 - 10.2015
- Developed ETL programs using Informatica to implement the business requirements.
- Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
- Worked on different types of sources and targets such as Relational Tables, XML files and Flat files.
- Worked on both New Development and enhancement on existing ETL code which was running in production.
- Extensively used various transformations such as XML (SQ, Parser and Generator), Filter, Router, Lookup, Expression, Aggregator, Source Qualifier, Joiner, Rank, Normalizer, Sorter, Union, UDT transformations.
Have responsibility on end to end ETL development till it deployed into production environment.
Used tasks such as Session, Command, Decision and Assignment task. - Prepared Technical Design documents, Proof of Concepts (POC) and Test cases.
- Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
- Performed unit testing at various levels of the ETL and actively involved in team code reviews.
- Fixed the invalid mappings and troubleshoot the technical problems of the database.
Analyst
Verizon Data Services India Pvt Ltd
Hyderabad, Telungana
06.2011 - 06.2014
- Identified data source systems integration issues and proposing feasible integration solutions.
- Extracting data from Oracle and Flat file, Excel files sources and performed complex joiner, Expression, Aggregate, Lookup, Filter, Router transformations and Update strategy transformations to extract and load data into the target systems.
- Fixing invalid Mappings, Debugging the mappings in designer, Unit and Integration Testing of Informatica Sessions, Worklets and Workflows.
- Created reusable Mailing alerts, event Tasks, Sessions, reusable worklets and workflows in Workflow manager
- Created the unit test cases for mappings developed and verified the data.
- Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development.
Education
Bachelor of Engineering - Electrical & Electronics Engineering
Info Institute of Engineering
Coimbatore 09.2007 - 04.2011
Skills
ETL Data Integration
Snaplogic
Oracle & MySQL
Tableau & MicroStrategy
Unix Shell Scripting
Agile Methodology
Azure
Data Analysis
Python (Pandas & Numpy)
Certification
Snaplogic Certified Automation Professional
Timeline
Snaplogic Certified Automation Professional
02-2022
Sr. Integration Consultant
TEK Systems India Pvt Ltd
01.2022 - Current
Sr. Data Analyst
B A Continuum India Pvt Ltd.
10.2015 - 01.2022
Analyst
Cognizant Technology Solutions Pvt Ltd
06.2014 - 10.2015
Analyst
Verizon Data Services India Pvt Ltd
06.2011 - 06.2014
Bachelor of Engineering - Electrical & Electronics Engineering
Info Institute of Engineering
09.2007 - 04.2011