Bhanu kiran Reddy Bommu
Senior Data Engineer
Hyderabad
Summary
To excel in a dynamic role within the software industry, taking on challenging assignments that provide job satisfaction and contribute to steady professional growth.
Over 13 years of experience in software lifecycle, specializing in Data Warehouse. Skilled in developing strategies and frameworks for Extraction, Transformation, and Loading using ADF, SnapLogic, and SSIS. Currently employed as a Senior Data Engineer at UXLI, Hyderabad. Quick learner with adaptability to new and challenging technological environments. Capable of working both independently and collaboratively as a part of a team. Proficient in agile execution methodology. Was instrumental in creating a generic Integration framework capable of handling heterogeneous data from pre-defined source system to pre-defined target systems. Experience in project development, implementation, and Software Testing. Proficient in Data Warehousing, OLAP, and deploying code across SDLC environments. Contributed to learning and training efforts for building tool-agnostic solutions.
Overview
14
14
years of professional experience
3
3
Languages
Work History
Senior Software Engineer
OSI Consulting
11.2010 - 11.2018
Senior Data Engineer
UXLI Limited
11.2018 - Current
Ingestion Lead/consultant
UXLI limited
03.2023 - Current
- Leading the migration of jobs from Netezza to Snowflake as part of C360
- Interacting with new source owners to gather necessary information for source integration
- Managing 35 diverse sources (Oracle, PostgreSQL, SQL Server, MySQL, S3 files, SFTP, SFDC: CSV, TXT, Parquet, Excel) and creating pipelines for each
- Analyzing features in the new Datapipes tool, raising defects if needed, and coordinating enhancements with the tool team
- Playing a crucial role in R&D efforts, contributing over 100 features to enhance the Datapipes tool
- Collaborating with various stakeholders to gather data-level information for building and testing pipelines, addressing execution issues
- Serving as a bridge between teams, project managers, customers, and external parties.
Integration consultant
UXLI limited
05.2020 - 03.2023
- Created a generic Integration framework which can handle heterogeneous data from pre-defined source system to pre-defined target systems
- Pre-defined system can be SFTP, FTP, Datalake, Synapse, CosmosDB etc
- This will reduce the overall integration efforts in building and testing the pipelines
- Scenarios handled
- Scenario 1 – Extraction of data from file systems (e.g., FTP, SFTP, Data Lake) to Azure Data Lake Scenario 2 - Extraction of data from Azure Data Lake to a file system (FTP, SFTP) Scenario 3 – Movement of data from Azure Data Lake to a table in a Data Warehouse (Synapse SQL, CosmosDB) Scenario 4 – Movement of data between tables within a Data Warehouse by calling Stored Procedures
- (Synapse SQL) Scenario 5 – Extraction of data from a Database (Synapse SQL, CosmosDB) to Azure Data Lake Scenario 6 – Calling Azure functions
- Scenario 7 – Event base triggers (static) Scenario 8 – Extraction of data from email attachments to Azure Data Lake Scenario 9 - Scheduling and dependency logic
- Scenario 10 - Email notification Scheduling Jobs and Monitoring them and resolve the issues faced during its execution
- All the errors will be logged in error log table, this error can be shared to respective groups/ids using an Email notification pipeline
- Received the Best Team Performer of the Year award
- Also recognized for exceptional commitment in another year.
Integration consultant
UXLI limited
08.2019 - 05.2020
- Involved in delivering the code according to the user requirements with quality
- Created a framework in SSIS to handle csv, excel, txt files from SharePoint, sftp and mailbox and load them to SQL server
- All the details can be passed on using configuration tables
- Scheduling Jobs and Monitoring them and resolve the issues faced during its execution
- Awarded as best performer.
Integration consultant
UXLI limited
11.2018 - 07.2019
- Involved in delivering the pipelines/code according to the user requirements with quality
- Updated PECI and PICOF framework pipelines as per requirement without impacting existing logic
- Scheduling Jobs and Monitoring them and resolve the issues faced during its execution.
Technical Consultant
Planview
8 2016 - 11.2018
- Involved in migrating exiting job to Snaplogic Development of Snaplogic Pipelines to perform data integration and scheduling the jobs as per business requirements
- Develop Installation Guide and convert High level documentation to flow chart
- Using web services to retrieve and perform transformations on Data
- Deliver Snaplogic Interface, Requirement Gathering, Testing, Deployment, Documentation Involved in support and enhancement activities
Team member
OSI Technologies
08.2013 - 07.2016
- Development Involved in delivering the code according to the user requirements with quality which includes Writing triggers, functions, procedures, and packages using SQL, PL/SQL
- Scheduling Jobs and Monitoring them to resolve the issues faced during its execution
- Involved in performance tuning to meet the SLA’s for report generation which includes identifying bad queries, query rewriting and using new features of oracle for faster data import and export (Data Pump)
- Involved in bug/data fixes
- User Acceptance Testing Support
- Worked on Migration project between Databases
- Quality & Standards Maintenance and Practices Carried out quality related internal inspections and followed practices for maintaining the quality standards applicable in project
- Involved in Quality Assurance Activities
- Knowledge Management Conducted knowledge transfer sessions on different concepts
- Involved in creating and executing jobs based on client requirement
- Implemented oracle procedure logic with Talent jobs
- Used SVN for code integration.
Technical Consultant
Taylor Made-Adidas Golf Company (TMaG)
05.2013 - 07.2013
- Involved in Developing and Customizing Reports
- Developing database stored procedures, functions and packages
- Defining Reports, Concurrent Programs and Executables
- Development & Customization of new reports, Forms as per the Specification provided.
Technical Consultant
Jacobs Engineering Group Inc.
12.2010 - 04.2013
- Involved in support and enhancement activities Involved in development of technical specifications for new enhancements
- Involved in Defaulting Sales order Shipping Warehouse using Forms Personalization based on Client customizations
- Involved in Development of Approved Supplier List Interface
- Involved in Converting Purchase order report to XML report
- Involved in Development of Custom BI reports like Sales Order Details Report, Jacobs Sales Orders with shipping warehouse mismatch report based on requirement.
Education
Skills
ETL development
Data Pipeline Design
Data Warehousing
Team Leadership & Development
Agile methodologies
Skillsprofile
Azure Data Factory, Data pipes, Snap Logic, SSIS, DataStage, Talend, Snowflake, Azure Synapse, redshift, SQL server, Oracle, Postgres SQL, Cosmos DB, Datalake, S3, FTP, SFTP, mailbox, Logic Apps, Azure functions, Triggers, Devops, Tortoise SVN, ETL concepts and SQL, PL/SQL
Visavalidity
2025
Personal Information
- Passport Number: H9827910
- Father's Name: Haribabu Bommu
- Date of Birth: 05/07/88
- Gender: Male
- Nationality: INDIAN
- Marital Status: Married
- Visa Status: B1
Timeline
Ingestion Lead/consultant
UXLI limited
03.2023 - Current
Integration consultant
UXLI limited
05.2020 - 03.2023
Integration consultant
UXLI limited
08.2019 - 05.2020
Senior Data Engineer
UXLI Limited
11.2018 - Current
Integration consultant
UXLI limited
11.2018 - 07.2019
Team member
OSI Technologies
08.2013 - 07.2016
Technical Consultant
Taylor Made-Adidas Golf Company (TMaG)
05.2013 - 07.2013
Technical Consultant
Jacobs Engineering Group Inc.
12.2010 - 04.2013
Senior Software Engineer
OSI Consulting
11.2010 - 11.2018
Technical Consultant
Planview
8 2016 - 11.2018
Similar Profiles
Pavan NalamadaPavan Nalamada
Practice Director at Enterprise Applications and Business Analytics OSI DigitalPractice Director at Enterprise Applications and Business Analytics OSI Digital
Janie KingJanie King
Associate at OSI GlobalAssociate at OSI Global
Cameron SmithCameron Smith
Maintenance Technician at Park 100 Foods/OSI Foods LLCMaintenance Technician at Park 100 Foods/OSI Foods LLC
Ismail MohammedIsmail Mohammed
Data Specialist at S&P GlobalData Specialist at S&P Global
Bharath Kumar KondetiBharath Kumar Kondeti
Senior Drupal Developer at SpecbeeSenior Drupal Developer at Specbee