Madhu Rachabattula

• Lead Automation of the Teradata Object deployment process – PR build checks , deployment validations, etc.
• Lead application Migrations from Greenplum to snowflake
• Lead Infrastructure maintenance activities i.e., database upgrades, linux server upgrades, audit/hygiene items
• Managing the roadmap, prioritizes the backlog, defines the product vision, and managing the automation Deliverables.
• Facilitating Daily standup calls and oversee sprint planning
• Manage reviews and gather feedback from stake holders
• Design and Deployment of Tools to automate the Teradata SDLC activities, DB Maintenance activities, Snowflake deployment strategies.
• Managing and deploying the Teradata Warehouse Database Object changes.
• Plan and Implement the POC`s on database technologies
• Supporting the Database Upgrades with BenchMark Tests and performance Metrics publishing
• Day2Day support of database maintenance activites like PROD issues with Database space/performance, etc.
• Python utilities for data copies, ETL, DB metrics Reports using pandas, numpy
• Creating python libraries to connect to different databases and data extractions

Snowflake DB Support:

• DB Modelling, Database Design, Infra Setup oof SF Deployments, Designing and defining deployment strategies
• Creating databases, roles setup & grant permissions
• Designing the snowflake performance Metrics reports

• Profession in Perl Object Oriented development, ETL Libraires for Extract/load Plugins, Automation of system Monitoring deamons
• Automating the TD Object Deploying using externally imported Liquibase core libraries enriching
  with creating MS specific extensions (product owner).
• Maintaining Infrastructure updates and impact analysis (ttu clients, database upgrades ,
  benchmark tests, stats)
• Automation of data loading activities with high efficient techniques like pipe files in tpt, fastexport,
  mload,etc.
• Database support activities like database model proposal for applications, users setup, roles granting, workloads setup etc..
• Leading various POCs in database technologies TERADATA unity POC, Snowflake Query
  performance POC.
• Generation of database analytics i.e., capacity metrics, production queries performance tuning.
• Creating the Database logical/Physical models in PowerDesigner and normalization
• Lead Team providing database infra support in different timezones IST, EST, CANADA, UK, MEXICO
• Managing 20k Objects in warehouse and 50+ databases in PROD.
• Supporting 15 non prod environments to work with 45+ squads across the globe
• Daily 2-3TB data gets loaded in to warehouse supporting finance reporting including balancesheet, loans, pnlreporting, etc..

• Automation of ETL (Extract, Transform and Loading) process using Teradata Load utilities in Perl,
  Perl –OIO, Perl-WebServices
• Creating Data Handling tools in Teradata, DB2 & Sybase (mload, bteq, db2 load, DB2 export, bcp),
  and performing database compression, load utility benchmarks, concurrency testes, reduced I/O
  and locking strategies, transaction data injection rates, tuning Service Level Agreement queries.
  Perl Web applications Development PERL-CGI, XML, HTML, CSS and JavaScript
• Data base Model migrations across databases Teradata 13.10, DB2 9.7,Sybase 12.5, Greenplum
• Manage code versions using code Repository tools CVS, VSS and Perforce, RCS.
• Tracking of development & QA Defect tasks using JIRA Issue tracker and Defect Tracking System
  Quality Centre.

• Analysis of business Requirements and checking with clients if any clarifications required.
• Preparing Functional and Technical Design documents.
• Developing the front end applications in Perl and PL/SQL code.
• Preparing test cases and test scripts for testing the changes.
• Peer reviews for the code developed by other team members

• Analysis of Business Requirements Document. Checking with clients if any clarifications required.
• Preparing functional and Technical design documents.
• Developing the java API and PL/SQL code.
• Preparing test cases and test scripts for Unit Testing.
• Peer reviews for the code developed by other team member