Nikhilesh Killada

• Stakeholder Collaboration and BI Development: Collaborated with stakeholders to understand their needs and utilized Oracle databases to analyze data, developing comprehensive dashboards in Oracle BI (OBIEE) and Tableau. This approach enhanced data visualization and decision-making capabilities, leading to a 30% improvement in reporting efficiency.
• Automation of Reporting Processes: Automated Excel reports using Power Query, significantly streamlining data analysis and reporting processes, thereby increasing efficiency and reducing manual effort by 40%.
• Web Development for Registrar’s Office: Assisted in updating the university's registrar's website, focusing on intuitive interfaces and seamless functionality. These enhancements improved user experience and streamlined access to important academic information.
• Data Management and Operations: Interacted with diverse data management systems, including Salesforce and Microsoft Access databases, as part of operations management. This role facilitated efficient data management and enhanced reporting capabilities.
• Predictive Analytics for Academic Planning: Utilized Python scripting to predict term session calendar dates, enabling proactive academic planning and scheduling. This innovative approach has improved the accuracy and efficiency of academic calendar management by 35%.

Project Role: Snowflake Developer, BI Developer

• Stakeholder Engagement: Utilized strong communication skills to collaborate with stakeholders, effectively gathering and understanding their requirements to ensure alignment with project goals, resulting in a 50% increase in project alignment and satisfaction.
• Advanced ETL Design: Demonstrated expertise in ETL design within Snowflake, showcasing proficiency in advanced SQL concepts such as Window functions, CTEs (Common Table Expressions), UDFs (User Defined Functions), and Stored Procedures. Led the migration of existing SAP HANA models to Snowflake, leading to a 40% increase in data processing efficiency.
• Data Modeling and Governance: Designed and implemented robust data models in SQL using SCD (Slowly Changing Dimensions) methodology, optimizing data accuracy by 30% and utility. This approach included transitioning models from SAP HANA to Snowflake, leveraging a deep understanding of BI/DW (Business Intelligence/Data Warehousing) architecture and data governance principles.
• Project Management: Managed multiple critical projects with a focus on solving problems under pressure and migrating complex data systems to Snowflake. Excelled in organizing and prioritizing tasks, which enhanced project delivery and efficiency, reducing delivery timelines by 25%.
• BI Reporting and Visualization: Developed operational, sales, and HR dashboards and reports in Power BI, customized to meet specific stakeholder requirements, enhancing data accessibility and decision-making by 45%. Integrated SAP HANA data sources into Snowflake to streamline report generation.
• ETL Tool Proficiency: Gained hands-on experience with leading ETL tools, including Talend and Informatica. Played a key role in facilitating seamless data integration across platforms and migrating data workflows from SAP HANA to Snowflake, improving integration processes by 50%.