MADHU RACHABATTULA
North Brunswick,NJ
Summary
Ambitious and strategic Data Engineer with 19+ years of experience in IT industry with various technical roles including senior Data Engineer, DevOps Lead, APPDBA for Teradata,Snowflake, DB2 , Perl Developer. Seeking to have challenging Career in data analytics/analysis along with Cloud Technologies.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Senior Data Engineer/DevOps Lead
MorganStanley
01.2018 - Current
- Lead application Migrations from Greenplum to snowflake covering all objects, data initialization & validations
- Managing the roadmap, prioritizes the backlog, defines the product vision, and managing the automation Deliverables
- Facilitating Daily standup calls and oversee sprint planning
- Leading applications Migrations from Teradata to snowflake with object, data Migration with Huge Data Bolt data validations
- Developed CI/CD pipelines using GITHUB, bitbucket increasing developer efficiency
- Creating python libraries/pugins as part of ETL framework BUILD to connect to different databases and data extractions , data transformations and load to Target
- Lead Automation of the Teradata Object deployment process - PR build checks, deployment validations, etc
- Defining Database standards and automating the integrity checks in SDLC
- Defining Data Governance Principals and gate keeping controls for DB Object Deployments maintaining model integrity
- Lead Infrastructure maintenance activities i.e., database upgrades, linux server upgrades, audit/hygiene items
- 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
- Snowflake DB Activities: 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 KPI & report Generations.
Data Engineer
Morganstanley
11.2015 - 12.2017
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Migrated legacy systems to latest databases like greenplum, snowflake
- Automating 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 Database logical/Physical models in Power Designer and normalization
- Lead Team providing database infra support in different timezones IST, EST, CANADA, UK, MEXICO
- Daily 3+ TB data gets loaded in to warehouse supporting finance reporting including balancesheet, loans, pnlreporting, etc..
ETL Automation
Tata Consultancy Services
10.2007 - 12.2014
- 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.
Software Engineer
Zensar Technologies Pvt Ltd
05.2006 - 10.2007
- Developing front end applications in Perl and PL/SQL code
- Preparing test cases and test scripts for testing the changes
- Peer reviews for code developed by other team members.
Software Engineer
India Softima Pvt Ltd
08.2004 - 04.2006
- Creating perl Scripts & modules for misys claims processing and generating reports
- Developing the java API and PL/SQL code.
Education
Master of Computer Applications - Computer Science
Acharya Nagarjuna University
01.2004
Bachelor of Science - Computer Science
Acharya Nagarjuna University
04.2001
Skills
- Snowflake, Teradata, Greenplum, DB2, ,ybase
- Python, Perl, Perl OIO, CGI, Shell
- XML, YAML, JSON
- Autosys, Airflow, Cron Jobs
- GitHub, BitBucket, CVS, Perforce,
- Jenkins CI/CD pipleines, Azure pipelines
- Basic Java Programming
- Sphinx Documentation
- Ms Visio, Power Designer, Erwin,
- Collibra
- DBArtisan, sqlAssistant, pgAdmin, DBeaver
- Visual Studio Code, Intellij, Pycharm
Certification
- IBM certified - DB2
- Fundamentals NCFM - Currency Derivatives(A Beginners Module)
- NCFM - Financial Markets(A Beginners Module)
Timeline
Senior Data Engineer/DevOps Lead
MorganStanley
01.2018 - Current
Data Engineer
Morganstanley
11.2015 - 12.2017
ETL Automation
Tata Consultancy Services
10.2007 - 12.2014
Software Engineer
Zensar Technologies Pvt Ltd
05.2006 - 10.2007
Software Engineer
India Softima Pvt Ltd
08.2004 - 04.2006
Master of Computer Applications - Computer Science
Acharya Nagarjuna University
Bachelor of Science - Computer Science
Acharya Nagarjuna University
Similar Profiles
Felix Feng ZhaoFelix Feng Zhao
Java Developer at MorganstanleyJava Developer at Morganstanley
Madhu RachabattulaMadhu Rachabattula
Database Dev Ops Lead at MorganStanleyDatabase Dev Ops Lead at MorganStanley
Suyash HoshingSuyash Hoshing
Technical Architect at TCS - MorganstanleyTechnical Architect at TCS - Morganstanley
Roseli ColonRoseli Colon
Dual Language/Long-Term ESL Substitute Teacher at Linwood Elementary SchoolDual Language/Long-Term ESL Substitute Teacher at Linwood Elementary School
LAUREN DIEHMLAUREN DIEHM
PTU Support Staff at Middlesex County Prosecutor’s OfficePTU Support Staff at Middlesex County Prosecutor’s Office