Rohan Solanke

Data Engineer

Pune, Maharashtra, India3 yrs 10 mos experience
Most Likely To Switch

Key Highlights

  • Expert in automating data processes and workflows.
  • Proven track record in data warehouse management.
  • Strong experience in product development and client collaboration.
Stackforce AI infers this person is a Data Engineer with expertise in Fintech and SaaS industries.

Contact

Skills

Core Skills

Data EngineeringData Warehouse ManagementProduct DevelopmentData MigrationData VisualizationBusiness Analysis

Other Skills

API DevelopmentAPI GatewayAPI ManagementAWS CloudFormationAWS Command Line Interface (CLI)AWS GlueAWS Identity and Access Management (AWS IAM)AWS LambdaAWS ServicesAmazon EC2Amazon S3Amazon Web Services (AWS)Analytical SkillsAnalyticsApache Spark

About

Leading data extraction and people management at Edelweiss Life Insurance, my role as a Data Engineer blends technical prowess with effective stakeholder engagement. Our team's success in automating data processes using Pentaho Data Integration has streamlined operations and bolstered decision-making capabilities across the board. With a solid educational foundation in Mechanical Engineering and Data Science from Savitribai Phule Pune University, I bring a multifaceted skill set to the table. My expertise in managing data warehouses and crafting automated pipelines resonates with my commitment to continuous learning and passion for data-driven innovation.

Experience

3 yrs 10 mos
Total Experience
1 yr 11 mos
Average Tenure
3 yrs 4 mos
Current Experience

Edelweiss life insurance

Data Engineer 1

Feb 2023Present · 3 yrs 4 mos · Mumbai, Maharashtra, India · Hybrid

  • People Management and Data Extraction:
  • I successfully handled interactions with various stakeholders, understanding their data requirements, and providing timely and accurate data extracts. I ensured effective communication and collaboration, ensuring that the extracted data met their needs and supported their decision-making processes.
  • Automation with Pentaho Data Integration:
  • I leveraged Pentaho Data Integration, a powerful data integration and ETL (Extract, Transform, Load) tool, to automate repetitive tasks and streamline data processing workflows. By designing and implementing automated data pipelines.
  • Data Warehouse Management:
  • Our team was responsible for managing the Data Warehouse, which involved handling data from multiple sources such as Oracle, DB2, SQL Server, and Postgres. We ensured the seamless integration of data from these sources into the Data Warehouse, maintaining data integrity and consistency. This involved designing and optimizing data models, performing data transformations, and ensuring the availability of accurate and up-to-date data for reporting and analysis purposes.
  • AWS Glue and Data Migration Service:
  • I worked on analyzing and improving data pipelines built in AWS Glue and utilizing the AWS Data Migration Service. By optimizing and enhancing these pipelines, I improved data extraction, transformation, and loading processes, resulting in more efficient and reliable data movement across systems.
  • API Management and Deployment:
  • I managed and deployed APIs built in AWS Lambda for the entire Data Warehouse. This involved designing and implementing APIs to provide seamless access to data for various applications and users. Additionally, I proactively resolved any issues related to APIs, ensuring their smooth functioning and optimizing their performance. I also focused on automating API processes to handle large data volumes efficiently, enhancing overall system performance.
Data ExtractionPentaho Data IntegrationData Warehouse ManagementAWS GlueAPI ManagementData Engineering

Usefulbi corporation

Associate Data Engineer

Jul 2022Jan 2023 · 6 mos

  • Developed a core product for UsefulBI: I played a key role in developing a core product for UsefulBI that revolutionized the ETL process by offering an intuitive user interface. Users could simply configure settings on the website, and the product would automate the data movement based on the given configuration. I utilized a range of AWS services such as Docker, Lambda functions, API Gateway, EC2, and Code Commit to ensure seamless and efficient data processing.
  • Automated data pipelines for data science teams: I successfully automated data pipelines for data science teams, leveraging AWS Glue for data extraction and transformation. Additionally, I utilized AWS S3 for data backup, AWS EMR for distributed processing, and AWS Athena for efficient querying, enabling the data science teams to focus on analysis and insights rather than the complexities of data processing.
  • Worked on a Data Migration Project for a Fortune 500 client: I had the privilege of working with a Fortune 500 client on a crucial Data Migration Project. I employed Azure Data Analytics, Azure Synapse, Azure Data Factory, and Azure Databricks to seamlessly migrate and transform their data, ensuring a smooth transition to the new data environment. This project required extensive collaboration and coordination with the client's team to ensure the successful completion of the migration.
  • Product Development in collaboration with the CEO: I had the unique opportunity to work closely with the CEO in developing a product from vision to implementation. I actively contributed to the product's conceptualization, design, and development stages, aligning it with the company's strategic goals and market needs. This experience allowed me to gain valuable insights into product development processes and enhanced my ability to translate ideas into tangible solutions.
AWS ServicesData MigrationProduct DevelopmentAutomated Data PipelinesData Engineering

Cognizant

Programming Analyst

Jan 2022Jul 2022 · 6 mos · Remote

  • QlikView Training:
  • I underwent rigorous training in QlikView, a powerful business intelligence and data visualization tool. Through this training, I gained a deep understanding of QlikView's functionalities, including data extraction, transformation, and visualization. I developed expertise in creating interactive dashboards, reports, and visualizations that effectively present complex data in an intuitive and actionable manner.
  • Tableau Training:
  • I also received comprehensive training in Tableau, a leading data visualization and analytics platform. This training equipped me with the skills to leverage Tableau's features and functionalities to create compelling visualizations, interactive dashboards, and data-driven stories. I learned to work with various data sources, perform data analysis, and effectively communicate insights through impactful visual representations.
  • SQL Proficiency:
  • As part of my training, I gained proficiency in SQL (Structured Query Language), a fundamental language for managing and manipulating relational databases. I learned to write complex queries to extract, transform, and analyze data from databases. This skill proved invaluable in efficiently retrieving and manipulating data for analysis and visualization purposes.
  • Data Visualization Expertise:
  • Through the training program, I developed expertise in data visualization principles and best practices. I learned how to effectively communicate data insights by selecting appropriate chart types, designing visually appealing and informative graphics, and presenting data in a coherent and meaningful manner. I gained a deep understanding of data visualization techniques to convey complex information in a visually compelling way.
  • This training experience not only expanded my technical skills but also enhanced my ability to derive valuable insights from data and effectively communicate them to stakeholders.
QlikViewTableauSQLData Visualization

Urban company

Business Analyst

Apr 2021Jun 2021 · 2 mos · Pune, Maharashtra, India · Remote

  • Operational Excellence: I efficiently managed the day-to-day operations, overseeing service categories to ensure smooth functioning and exceptional customer experiences. I implemented effective processes and protocols to streamline operations, resolve issues promptly, and maintain high service standards.
  • Cross-Functional Collaboration: Collaborating with various teams across the organization, I played a crucial role in steering business growth for the city. By fostering strong relationships and effective communication, I facilitated the alignment of goals and strategies, ensuring cohesive efforts towards achieving business objectives.
  • Demand-Side Management: I strategized and implemented the right product flow on the demand side, analyzing market dynamics and customer preferences. By defining selection criteria, I identified and onboarded top professionals in the trade, enhancing service quality and customer satisfaction.
  • Growth and Expansion: I focused on identifying the most effective channels for demand and supply growth, leveraging data-driven insights to drive volume and revenue. Additionally, I utilized pricing levers to optimize profitability while maintaining competitive market positioning.
  • Process Standardization: I played a pivotal role in institutionalizing service delivery norms and processes for the category. By developing and implementing standardized protocols, I ensured consistency and efficiency in service execution, fostering a culture of excellence.
  • Training and Development: Recognizing the importance of continuous improvement, I created training and retraining programs to enhance the skills and knowledge of professionals. These initiatives aimed to improve the overall quality of service, resulting in higher customer satisfaction and loyalty.
Operational ExcellenceCross-Functional CollaborationDemand-Side ManagementTraining and DevelopmentBusiness Analysis

Education

Savitribai Phule Pune University

Minor degree — Data science

Jun 2019Jun 2022

Savitribai Phule Pune University

BE - Bachelor of Engineering — Mechanical Engineering

Jan 2018Jan 2022

Stackforce found 100+ more professionals with Data Engineering & Data Warehouse Management

Explore similar profiles based on matching skills and experience