Ravi N Kiran

Experience

• 

  IQVIA

  Jul 2017 - Jun 2019

  ETL Developer & Data Engineer

  Experienced Microsoft BI and VBA Developer specializing in SQL Server, SSIS, and SSRS. Proficient in monitoring, supporting, and troubleshooting SQL Agent and MS Access jobs. Developed reports for various teams, including Credit Reporting, Document Capture, and Retention Teams. Led migration projects from MS Access to SQL Server 2005 using SSIS and SSRS, ensuring seamless transitions. Built high-performance data integration solutions with SSIS, incorporating error handling and logging techniques. Developed SSRS reports with advanced features like cascading, drill-down, and parameterized subscriptions, deploying and scheduling reports for regular generation. Collaborated on gathering business rules, preparing technical specifications, and documentation. Implemented performance tuning and transactional logic in SQL Server objects, while also managing maintenance activities for SQL Server 2000/2005 environments. Show less

• 

  HighRadius

  Jul 2019 - Dec 2020

  Sr Data Engineer & Functional Data Analyst.

  Experienced ETL Lead Developer adept at delivering complex work items and ensuring timely completion of monthly and quarterly deliverables. Skilled in AGILE delivery with 2-week sprints, participating in daily stand-ups and poker meetings for status updates and user story estimations. Collaborated with third-party vendors like Net Cracker, Scorecard Team for data extraction and integration. Coordinated with Testing teams and end-users for UAT testing and execution of test cases. Translated business requirements into logical and physical data models, developed SSIS packages for data integration from heterogeneous sources, and optimized performance on SSIS, SSRS, and database objects. Proficient in complex T-SQL queries, joins, sub-queries, and XML techniques. Implemented data quality services, designed master data models, and utilized Power View/Pivot for geographical templates and analysis. Show less

• 

  Amazon

  Jan 2021 - Dec 2021

  Sr Data Engineer & Production Support Specialist

  Experienced in data conversion and migration between media planning applications, focusing on RedShift Data Mart integration. Collaborated with BAs to understand system requirements and limitations, analyzing competitor BI domains for design enhancements. Designed Dimensions/Facts, constraints, indexes, and user-defined functions for data integrity and modular logic. Developed interactive Tableau dashboards, following Kimball EDW model for Competitor BI Data Mart, and created metadata-driven ETL solutions in SQL Server. Migrated ETL processes from Informatica to SSIS, managing AWS S3 data import/export for RedShift. Implemented SSAS multidimensional cubes, including linked cubes for data integration. Leveraged Power BI tools for enhanced visualization of reports, ensuring accuracy and usability. Proficient in SSIS, SSAS, and Power BI for end-to-end BI solutions. Show less

• 

  Infovity

  Jul 2022 - Aug 2023

  Sr Data Engineer

  As a Senior Data Engineer at Infovity, I led the development and deployment of advanced Big Data solutions for multiple clients within the Rackspace Data Engineering Team. Utilizing Agile methodologies, I efficiently delivered solutions on both Kanban and Scrum frameworks, leveraging Hortonworks data platform and AWS Cloud. My expertise in Hive enabled the creation of complex data warehouse structures for critical modules such as Global Sales and VM Billing, while implementing SCD Type 1 and Type 2 functionalities. Leveraging Spark 2.1 with Scala 2.12, I managed large data volumes, executing intricate data transformations with precision and meeting strict SLAs. Additionally, I orchestrated job scheduling using Oozie and designed Dimensions, Facts, and Reporting tables in Datamart, ensuring robust data structures for analytical insights. Through meticulous documentation and collaboration with Quality Engineering teams, I ensured the integrity and quality of deployed solutions, while also developing APIs in Scala and Python for seamless data integration with downstream applications. Show less

• 

  Humana

  Aug 2023 - now

  Sr Cloud Data Engineer

  At Humana, I lead the development and automation of cutting-edge data products, leveraging Python, Spark, Scala, and Docker to streamline pipelines across Azure ADLS and SQL. Specializing in real-time processing with Spark-streaming and Kafka, I drive actionable insights and operational efficiency. Proficient in Tableau and Python libraries, I ensure data visualization meets stakeholder needs. I orchestrate build pipelines with Azure YAML, deploy Docker containers, and develop APIs using Java Spring Boot. I establish robust data governance through Azure Data Lake management and compliance. Committed to excellence, I drive Humana's healthcare data innovation forward, empowering informed decision-making. Show less