Bhagavan Reddy Rajala

About Bhagavan Reddy Rajala

Over 14 years of total IT experience in analysis, design, development, implementation and troubleshooting in the area of ETL tool Ab Initio, Teradata.• Over 14 years of experience in Big data environment.• Over 14 years of experience in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems and OLAP application development in Windows and Unix platforms.• Ability to prioritize multiple tasks.• Self-motivated and able to work independently and as a member of a team.• Excellent communications, interpersonal and analytical skills.• Quick learner and adaptive to new and challenging technological environments.• Extensive experience in handling ETL using Ab Initio 2.15 and Ab Initio 3.1.2over 12 years.• Extensive experience in designing and developing ETL involving different Source databases DB2, Oracle, SQL Server and flat files (fixed width, delimited).Target databases Teradata, Mainframe, Oracle, SQL server and flat files (fixed width and delimited).• Extensively worked on Abinitio Tool using various components like rollup, join reformat and techniques like parallel processing, component folding etc.• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing.• Expertise and well versed with various Ab Initio Transform, Partition, Departition, Dataset and Database components.• Worked extensively with the data quality teams to ensure the data quality.• Extensive experience in error handling and problem fixing in Ab Initio.• Designed/involved in creating codes for the data processing system up to a volume of 4TB.• Worked on all the phases of SDLC from requirement gathering to product support.• Worked on the automation of the ETL jobs using Maestro schedulers.• Excellent programming skills with the ability to automate routine tasks.• Worked with using EME for version control, impact analysis, dependence analysis for common projects and higher environment migrations.• Vivid experience in using Korn Shell scripting to maximize Ab-Initio parallelism capabilities and developed numerous Ab-Initio graphs using data parallelism and Multi File System (MFS) techniques.• Certified as “ Teradata 12 certified Technical Specialist”• Over 14 years of experience in using Teradata BTEQ to solve the business problems.• Strong knowledge of different schemas (star and snow flake)to fit reporting query and business analysis requirements.• Worked on large data warehouses to the size of 25 TB.

Experience

1. Vice President

   Citi

   Sep 2017 — Present · Tampa, FL, US

   Abinitio, Bigdata,Unix, The CITI Group,Tampa,Florida• Communicating with the business/user groups to understand the business process and gather requirements. • Extracting and analysing the sample data from operational systems (OLTP system) to validate the user requirements to create high level design documents. • Participating in data models (logical/physical) discussions and creating both logical and physical data models.• Developing of design documents with steps to achieve the requirements.• Analysing and Understanding Requirements from High level documents.• Creating low level design documents based on the above understanding.• Creating Ab Initio Graphs, SQL scripts and Unix Shell scripts based on the requirements.• Developing Ab-Initio graphs using Ab-Initio parallelism techniques, data parallelism and MFS techniques with the conditional components and conditional DML. • Identifying the required dependencies between ETL processes and Triggers to schedule the jobs to populate data marts on a scheduled basis.• Carrying the performance tuning on the Ab Initio graphs to reduce the process time. • Creating Ab Initio graphs to load data into Hadoop HDFS, thereby creating tables in • Hive Data warehouse and querying the data using SQL command tools like Hue.• Creating and scheduling Ab initio plans using Ab initio control centre to run developed scripts in order and at user defined timings.• Involving in Unit testing, QA migration and support, defect fixing, deployment setup including implementation plans, QA documents, RFC creation and for the above work streams.• Responsible for the project and participate in design, development, deployment & implementation of the large scale Abinitio applications.• Understand architectural principles, design patterns and best practices and apply them while creating the technical solutions for the applications.• Participate in global rollouts.

Education

• SRI CHAITHANYA JR COLLEGE

  INTERMEDIATE (+2)

  2004 — 2006

• Sri Venkateswara University ,Tirupati

  Bachelor of Technology (BTech)

  2006 — 2010

Skills

• Agile Methodologies
• Data Warehousing
• Database Development
• Informatica
• Ibm Db2
• Oracle
• Requirements Analysis
• Java
• Microsoft Sql Server
• Sql
• Software Development
• Performance Tuning
• Control-M
• Business Intelligence
• Technical Recruiting
• Hp Quality Center
• Oracle Sql Developer
• Core Java
• Microsoft Office
• Etl
• Olap
• Requirements Gathering
• Big Data
• Databases
• Pl/Sql
• Hadoop
• Unix
• Data Modeling
• Business Analysis
• Software Design
• Hive
• Ab Initio
• Shell Scripting
• Teradata
• Sdlc
• Tortoise Svn
• Software Development Life Cycle (Sdlc)
• Db2