Prashanth A Email & Phone Number

Dallas, TX, US

United States

• Build Ab-Initio graphs from high level design document.
• Developed re-usable generic / dynamic Ab Initio graphs and psets for the quality check of the source data.
• Much familiar with the concept of Sand box, EME for check in & checkout process.
• Designed and Built Ab Initio Graphs for unloading data from different source systems. Responsible for different Data mapping activities from Source systems to Teradata.
• Good experience with dml utilities like m db, Cobol-to-dml.
• Extensively used EME for Version control and Code Promotion.

United States

• Developed re-usable generic / dynamic Ab Initio graphs and psets for the quality check of the source data.
• Implemented Oracle utilities SQL loaded, Utility and API based loading from Ab Initio.
• Developed and supported the extraction, transformation, and load process (ETL) for a Data Warehouse from their OLTP systems using Ab Initio and provide technical support and hands-on mentoring in the use of Ab Initio.
• Responsible for High level Design and Detail design document for specific ETL processes.
• Created Sand box, Sandbox Parameters and Graph Parameters.
• Involved in analysis to understand the new data model for the application.

United States

• Worked on improving the performance of Ab Initio graphs by using various Ab Initio performance techniques like using looks instead of Join’s etc.
• Implemented Lookup’s, lookup local, in-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Design Documentation for the developed graphs. Used components like run program and run sql components to run UNIX and SQL commands in AB Initio. Also used the components like filter by expression, partition by.
• Worked on various Teradata utilities like Multi load, Fast load and Fast Export associated with the database components like Input Table, Output Table and Update table components.
• involved in data migration from Oracle to Teradata.

United States

• Implemented Data parallelism by using Multi-File System, Partition and De-partition components and preformed repartition to improve the overall performance.
• Performed validations, Data Quality checks and Data profiling on incoming data.
• Worked on improving the performance of Ab Initio graphs by using various performance techniques like using lookups instead of joins, In-Memory Joins etc.
• Design team member for integrating batch and online architectures, define re-usable components, setting programming and naming conventions, assigning sub-tasks and give inputs and monitor scope/business/technical.
• Usage of Ab-Initio data profiler for data cleansing and analysis. Also using the same to analyze test output for making the data warehouse more robust by identifying highly secured information such as personal account.
• Work in the UNIX environment using Shell Scripts for FTP, SFTP processes.