Jeevan Rishi Kumar Sunkara Email & Phone Number

Toronto, Ontario, Canada

Designed and implemented data ingestion pipelines using Hadoop and Spark to extract, transform, and load data from various sources, including structured, semi-structured, and unstructured data. Implemented data processing and streaming pipelines using Kafka to enable real-time data processing and analytics and designed and implemented custom Kafka connectors to integrate with other systems. Designed and developed custom Power BI and Tableau dashboards to provide real-time insights and visualizations and integrated them with the data processing pipelines using REST APIs and webhooks. Deployed data processing and analytics systems on AWS and Azure using services such as EMR, HDInsight, and Data Factory, and implemented security measures such as VPCs, NSGs, and RBAC. Implemented change data capture (CDC) mechanisms to capture and process real-time data changes, improving data accuracy and timeliness. Developed and maintained data models and architectures using SQL and NoSQL databases such as MySQL, MongoDB, and Cassandra, and optimized query performance using indexing and partitioning techniques.Designed and implemented data warehousing systems using Snowflake, Redshift, and BigQuery, and optimized query performance using techniques such as star schema design and query optimization.Conducted data modelling and schema design using ER diagrams and UML and implemented schema evolution and data partitioning to enable scalability and flexibility.Developed and maintained disaster recovery and business continuity plans for data processing and analytics systems and conducted regular disaster recovery tests and simulations to ensure system availability and readiness.Developed and maintained a data lake architecture to store and process large volumes of data, enabling efficient data storage and processing.

Hyderabad, Telangana, India

Developed and maintained predictive models using R and Excel to forecast trends and identify patterns. Conducted A/B testing and statistical analysis to evaluate the effectiveness of marketing campaigns, resulting in an increase in conversion rates.Developed and maintained data visualization dashboards using Tableau and Excel to provide real-time insights into key performance metrics, improving decision-making processes for business stakeholders. Developed and maintained data pipelines using SQL and Excel to extract, transform, and load data from various sources. Conducted ad-hoc data analysis and reporting to support business operations and identify areas for improvement.Worked with business stakeholders to identify key metrics and develop custom reports and dashboards to track business performance.Conducted data quality assessments and implement data cleansing and transformation techniques to improve data accuracy and completeness.Developed predictive models using R and Excel to forecast trends and identify patterns and present findings to business stakeholders.Developed and maintain data visualization dashboards using Tableau and Excel to provide real-time insights into key performance metrics, enabling stakeholders to make data-driven decisions.Worked with cross-functional teams to identify business requirements and develop data solutions to address those needs.Developed and maintained data dictionaries and data documentation to ensure consistency and accuracy across different data sources.Stayed up to date with the latest data analysis techniques and tools, and continually seek to improve data analysis and reporting processes.Developed and maintained automated reporting processes using VBA and other tools to streamline reporting workflows.Conducted root cause analysis to identify the underlying causes of business problems and develop recommendations to address those issues.