Mallikarjun Rao Machavarapu
Database Engineer
Bangalore,Karnataka
Summary
Experienced Development Engineer with 8.5 years in the industry, specializing in database development and Cloud Data Engineering using Big Data Technologies like Databricks and SQL. Possesses strong technical acumen and a drive to solve complex problems with innovative solutions.
Overview
11
11
years of professional experience
8
8
years of post-secondary education
Work History
Cloud Data Engineer
Hexaware Technologies Ltd.
Bangalore
03.2020 - Current
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Utilized Azure Databricks for data processing and transformation, meeting project requirements and enhancing operational efficiency.
- Developed and implemented custom data validation stored procedures for metadata summarization for the data warehouse tables.
- Collaborated with clients to understand, implement detailed reporting needs.
- Created detailed functional and technical design documents.
- Developed, documented and validated complex business rules which are vital for data transformation.
- Developed ETL Solutions using Spark SQL in Azure Databricks for data extraction, transformation and aggregation from data sources.
- Managed the development and execution of test plans and effected corrective action on data quality issues.
- Utilized Azure Synapse for data processing and transformation, meeting project requirements and enhancing operational efficiency.
- Hands on experience on developing SQL Scripts for automation.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Documented migration processes and best practices, providing training and support to team members on Databricks workflows and technologies.
- Collaborated with cross-functional teams for seamless integration of data sources into the company''s data ecosystem.
- Analyze and evaluate existing systems and identify gaps, create plans for changes and suggest solutions.
Senior Database Developer
Verisk Financial (formerly Fintellix Solutions Pvt Ltd)
Bangalore
03.2020 - 02.2021
- Developed packages to load Data Warehouse to satisfy the subscribers needs.
- Designed, modeled and implemented Data Warehouse: tables, indexes, procedures and Packages.
- Automated and executed operational processes and procedures to ensure uptime and performance in a high availability.
- Developed and implemented custom data validation stored procedures for metadata summarization for the data warehouse tables.
- Collaborated with clients to understand, implement detailed reporting needs.
- Created detailed functional and technical design documents.
- Developed, documented and validated complex business rules vital for data transformation.
- Managed the development and execution of test plans and effected corrective action on data quality issues.
PLSQL Developer
Addecco India Pvt Ltd
Bangaolre
08.2016 - 02.2017
- I am responsible to analyze and understand these requirements and create intake report.
- I do Intake and Software Development Estimation for creating and deploying new source code or making changes in existing source code.
- I create Technical Design document, which contains changes, needs to be done in existing Source Code and put it in Pseudo Code format and new objects, which needs to be created for the same.
- As per the client requirement, customized report has been generated.
- Providing progress to the management on the regular basis.
- Above responsible for providing 24
- 7 production support to the client.
- Getting the exact requirement from the client to make the changes in the application reports and making the customer satisfaction rating in growth.
- Used internal functions, which are regularly used by the Cerner in the script.
- Communicating with the clients and the technical advisor (Onsite Candidate) for the issues if not resolved.
- Cerner is a company, which works on Healthcare domains.
Support Engineer
Info Services
Bangalore
01.2015 - 05.2015
- Improved customer satisfaction by promptly addressing support tickets and providing accurate solutions.
- Implemented technical solutions to solve customer issues and increase satisfaction.
- Documented technical issues and solutions to enable tracking history and maintain accurate logs.
- Developed strong relationships with key clients, acting as their primary point of contact for all technical concerns.
- Reduced response times by prioritizing urgent requests and escalating issues when necessary.
Intern
Infosys Technologies
Mysore
09.2014 - 12.2014
- Supported staff members in their daily tasks, reducing workload burden and allowing for increased focus on higher-priority assignments.
- Gained valuable experience working within a specific industry, applying learned concepts directly into relevant work situations.
- Analyzed problems and worked with teams to develop solutions.
- Contributed to a positive team environment by collaborating with fellow interns on group projects and presentations.
- Developed organizational skills through managing multiple tasks simultaneously while adhering to strict deadlines.
- Explored new technologies and approaches to streamline processes.
Education
B. Tech (ECE) -
Kuppam Engineering College
Kuppam, Chitoor District, Andhra Pradesh 01.2010 - 01.2014
Intermediate (M.P.C) -
Srichaitanya Jr. College
Nellore, Andhra Pradesh 01.2008 - 01.2010
SSC -
Vedavyasa E.M High School
Nellore, Andhra Pradesh 01.2006 - 01.2008
Skills
Timeline
Cloud Data Engineer
Hexaware Technologies Ltd.
03.2020 - Current
Senior Database Developer
Verisk Financial (formerly Fintellix Solutions Pvt Ltd)
03.2020 - 02.2021
PLSQL Developer
Addecco India Pvt Ltd
08.2016 - 02.2017
Support Engineer
Info Services
01.2015 - 05.2015
Intern
Infosys Technologies
09.2014 - 12.2014
B. Tech (ECE) -
Kuppam Engineering College
01.2010 - 01.2014
Intermediate (M.P.C) -
Srichaitanya Jr. College
01.2008 - 01.2010
SSC -
Vedavyasa E.M High School
01.2006 - 01.2008
Similar Profiles
Ramanji RaiRamanji Rai
Technical business analyst at Hexaware Technologies Ltd.Technical business analyst at Hexaware Technologies Ltd.
Ponni ParthibanPonni Parthiban
NA at Hexaware Technologies Ltd.NA at Hexaware Technologies Ltd.
Jose AbrahamJose Abraham
ServiceNow Developer at Hexaware Technologies Ltd.ServiceNow Developer at Hexaware Technologies Ltd.
Vijay Narasimha Reddy ThathireddyVijay Narasimha Reddy Thathireddy
Consultant at Capgemini Technology ServicesConsultant at Capgemini Technology Services
Mohammed Muzaffar HussainMohammed Muzaffar Hussain
Information Technology Operations Manager at Mobily Infotech India Pvt LtdInformation Technology Operations Manager at Mobily Infotech India Pvt Ltd