Rishi Kumar Email & Phone Number

Gurugram, Haryana, India

Gurugram, Haryana, India

End to end delivery of ETL pipelines for data warehousing and data modeling.Developed interactive analysis reports for Service, Sales, and Insurance, driving data-driven decision-making.Optimized data models to reduce scaling costs, enhancing system performance and cost-efficiency.Optimized Power BI datasets, reducing memory consumption by 65% and refresh time by 25%.Enhanced ETL data load pipeline, reducing data load time by 18%.Coordinated directly with key business and IT members at the client side and IT members from external entities, facilitating effective communication and project success.Set up detailed planning and milestone tracking for implementations, ensuring timely deployment of change requests.Provided comprehensive expertise for related functional areas and processes to team and business partners, enhancing overall project quality.

Gurgaon, India

Developed and automated batch integration processes for CRM systems.Created ODI packages and mappings to consume flat files from various sources uploaded to a shared drive on a Linux application server and inserted the data into the CRM system.Automated batch jobs by scheduling ODI packages and implemented logic to automatically pick the latest files from external systems, ensuring timely data integration.Designed and developed packages and mappings to load master data into the CRM system from export files, ensuring data consistency and accuracy.Developed outbound interfaces where data from the CRM system was exported into files using SQL SPOOL, and automated the processes with shell scripts to streamline data delivery.Debugged and resolved issues post go-live, ensuring smooth operation of the interfaces and developed new requirements as needed.Designed and developed shell scripts to automate ad hoc tasks, including data validation before master data imports and data recovery processes, improving operational efficiency.