Mahender Merugu

Senior Data Engineer @ Cotiviti

About

Passion and diligence are two traits that I believe most reflect me as an individual. It is my belief that this is the key to being successful in any endeavour that one sets one mind to. I love to generate new ideas and devise feasible solutions to broadly relevant problems. I enjoy embracing the lessons learned from failure, stand up and continue to grow. I am an accomplished professional with 10+ years of progressive experience in Data Engineering and Data Warehousing platforms with expertise in Data Analysis, Design & Implementation of Database and ETL StreamSets, Informatica, Teradata, and Kafka across Insurance, Banking, Retail and Health Care domains. I have demonstrated experience in ingestion, transformation, manipulation, and computation of data using StreamSets, and Kafka. My professional achievements show that I have extensive experience managing databases, extracting and evaluating complex data, and translating results into understandable terms to inform the organization and facilitate improved operations. I interact productively with people from diverse backgrounds. I have a career history of achieving employment goals. Moreover, I have a history of quality work carried to timely completion. Along with my skills, I bring a resourceful and energetic environment to the organization, with a desire and willingness to work with others. I have consistently followed expected precision and quality standards as set by the management and possess an ability to work under pressure and meet tight deadlines. I have the opportunity to become a member of StreamSets Product Advisory Council for year 2021. The Product Advisory Council is an influential group of StreamSets users who provide vital feedback to StreamSets, guiding the future of data through their insights and creating a community of intelligent, passionate data professionals. Academically I am backed with a Master’s degree in Computer Science from Staffordshire University, UK, and a Bachelors degree in Electrical and Electronics Engineering from Osmania University, India

Country

United States

City

Alpharetta

Industry

Computer Software

Skill

Snowflake, Amazon Web Services (AWS), MongoDB, Informatica, Data Engineer, Teradata, SAP data services HANA, Diversity & Inclusion, Global Talent Acquisition, Data Engineering , Data Warehousing platform , Data Analysis , Database Design & Implementation , Automation Requirement Gathering , Data Cleansing , Data Validation , Data Integration , Document Mapping , Data Transformation , Data Visualisation

Experience

Senior Data Engineer

Cotiviti

2023-12 - Present · 2 yrs 10 mos

Alpharetta, Georgia, United States

Associate Architect

Virtusa

2023-6 - 2023-12 · 7 mos

Alpharetta, Georgia, United States

Senior Data Engineer

UST

2022-10 - 2023-6 · 9 mos

Alpharetta, Georgia, United States

Senior Analyst

UST

2020-7 - 2022-10 · 2 yrs 4 mos

Hyderabad, Telangana, India

• Working on StreamSets- pipelines sourced from Oracle DB, HTTP Client- StreamSets Data Collector 3.20.0 and Control Hub • Handling Data ingestion and Tie-out process of Oracle and Mongo DB • Working on HTTP microservices endpoints • Managing Payments dashboards using Tableau

Senior Analyst

Dell Technologies

2018-8 - 2020-7 · 2 yrs

India

• Managed StreamSets- pipelines sourced from Teradata, SFDC, and Oracle CDC • Handled the Data ingestion and Tie-out process of Teradata and Greenplum DB • Worked on TPT, Kafka Streaming, and Greenplum DB • Handled SAP Data Services and SAP HANA DB for various frequency reporting purposes • Conducted ongoing performance tracking and success metrics for sales consultants to increase sales consistently • Executed daily updates using Microsoft excel and pivot tables • Initiated automation of weekly sales report with pivots, linking, and audit trail tabs • Contributed to ETL code changes for Critical Sales Reporting (CSR), which management uses for critical decision making • Handled data visualization tools like Tableau for reporting using KPIs, dashboards, metrics • Designed SQL Queries for Ad Hoc Report Generator (OLTP) Analytical Queries

Software Development Tech Lead

Synchrony

2017-1 - 2017-9 · 9 mos

India

• Engaged in knowledge transfer scheduling, planning, and execution • Extensively used Look-up Files for getting data from multiple sources and when the size of the data is limited • Developed Generic graphs for data cleansing, data validation, and data transformation • In charge of cleansing data from source systems utilizing Ab Initio components including Join, Dedup Sorted, Denormalize, Normalize, Reformat, Filter-by-Expression, and Rollup • Partitioned the data from a serial file using Partition Components such as Partition-by-key, Partition-by-expression, and Partition-by-Round Robin

ETL Developer

Accenture

2013-5 - 2016-12 · 3 yrs 8 mos

India

• Received web service calls from external vendors and used the Informatica data integration hub to do ETL to integrate them with the server's internal host • Collaborated with the BI team on several projects • Partnered with cross-functional teams to implement advanced analytics on customers and products • Integrated customer data from multiple data sources to achieve consistency in data and provide a single source of truth for business decision making • Created mapping documents in collaboration with business analysts • Developed complex and customized ETL code in response to the needs of the external vendor and internal host • Modified the XSDS schema in response to changing requirements