Mohan Kumar Email & Phone Number

Bengaluru, Karnataka, India

• Implemented end to end data flow for JDA Enterprise and assortment planning for EMEA to better handle demand and supply chain and increase profit margins by data analytics.• Built complete SQL/PLSQL programs using procedures and functions for data cleaning, validation, and data transformation to suite the business requirements.• Controlled large inflow of data from SAP systems at staging level and built complete data pipeline using plsql packages and automated jobs to run on daily and weekly basis.• Deployed and automated batch jobs in order to automate business process.• Worked with clients closely to understand business requirement and on user acceptance test(UAT)• Worked with internal teams to understand the dependencies/ data reconciliation/ system integration test (SIT)/ deployment.• Provided transition for new joinees as part of buddy program.

Bengaluru, Karnataka, India

Project: Warner Bros. / October 2011- May 2015• Worked as developer for Warner Home Videos (WHV) under CRM sector for North America, EMEA and APAC to handle sales and supply chain, New releases and promotions of new and existing products such as DVD’s, Blu-ray.• Worked in Siebel analytics and analytics using SQL queries to send reports to clients on quarterly basis to help improve sales planning for upcoming fiscal years.• Worked with data warehouse teams for ETL using Informatica to get data to Siebel database.• Implemented end to end SQL/PLSQL modules and EIM jobs to handle large data inflow and to build data pipeline of inbound data of Accounts, Products, Plants, Orders and many others from SAP systems to Siebel base tables.• Worked in Siebel configuration, Siebel workflows, Siebel e-script to achieve business purpose.• Worked directly with clients to understand business requirement, and gave timely releases of newly applied changes in production environment after DEV, SIT and UAT.• Resolved high priority issues within given deadlines.