KISHAN R AN KA

• Own and manage all ETL processes across the organization, ensuring reliable and scalable data integration.
• Designed and automated email-based reporting systems for stakeholders, reducing manual effort and ensuring timely delivery of insights.
• Developed and automated KRA (Key Result Area) reports and incentive calculation workflows, improving accuracy and saving 30 hours per month in manual work.

Redesigned and improved the incentive calculation process.

• Identified long-standing gaps, ignored by management, and implemented a robust validation framework.
• Ensured accurate and transparent incentive distribution, boosting employee trust and reducing disputes.
• Streamlined the process, cutting turnaround time from 2 days to 1 hours.
• Built Power BI dashboards to provide real-time visibility into trading, compliance, and operational metrics.
• Collaborated with business teams to understand domain-specific needs in broking and financial services, translating them into effective data solutions.
• Implemented data validation frameworks that improved reporting accuracy and reduced discrepancies by 95%.

• Worked as a data engineer for the client company (SBI Securities)
• Involved in creating multiple custom reports using the Alteryx tool and sending automated reports over email to higher management to make decisions proactively.
• Created 10+ custom reports via Alteryx for different departments and managed the data loads and ETL-related tasks for the client.

• Involving in the requirement gathering phase to understand business needs and translate those needs into Business requirement documents for the build phase
• Creating ETL pipeline to load the data from multiple sources to Azure SQL databases which is then used for building visuals
• Worked on integrating different sources such as web API’s, Salesforce, Oracle, SQL server, DB2 systems, and flat files
• Supporting the implementation and active monitoring of controls and programs for precision and efficacy

• Working to integrate data from Odata APIs to Azure Cloud.
• Working closely with the Power BI developer to derive the complex measures in SQL views and stored procedures.
• Implementing Slowly changing dimensions as per the client's requirement so as to analyze historical comparison of data

• Worked on Informatica to load data from Oracle/SAP/DB2 application sources to data lake.
• Used Informatica Power Exchange to set up the Change data capture for the required entities
• Worked on mappings, creating sessions, and tasks, and monitoring the CDC workflows
• Created multiple reports for supporting and monitoring 3000+ jobs. Also creating reports summaries that are used by teammates as well as saves their time by 5 hours everyday

• Worked on Qlik sense for product sales analysis, budget tracker analysis, and human resource management.
• Understanding the data models and creating customized jobs for month-on-month analysis