Prashant Rane

CEO

Buffalo, New York, United States13 yrs 8 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Over 15 years of experience in data engineering.
Expert in architecting scalable cloud data platforms.
Proven leadership in cross-functional team management.

Stackforce AI infers this person is a Data Engineering Architect specializing in cloud solutions for the Healthcare industry.

Contact

Skills

Core Skills

Solution ArchitectureData EngineeringCloud MigrationData ArchitectureEtl SolutionsProject ManagementEtl DevelopmentTeam Management

Other Skills

PythonPySparkAzure Data FactoryDatabricksSynapse AnalyticsData ValidationADLS Gen2Delta LakeInformatica PowerCenterSQLOracle SQL PLSQLInformaticaAgile MethodologiesData WarehousingBI/DW

About

• Senior Solution Architect with over 15 years of experience designing and delivering enterprise-scale data engineering, data warehousing, and ETL/ELT solutions across insurance and healthcare domains. Proven expertise in architecting modern, scalable cloud data platforms that drive performance and business value. • Well versed with Apache Spark architecture and data processing framework • Deep expertise in distributed computing using Spark, combined with advanced proficiency in Python, PySpark, SQL, Databricks, Azure Data Factory and Synapse Analytics. • Expertise in legacy system modernization, including migration from Informatica PowerCenter and Oracle to cloud-native data platforms. • Skilled in designing robust and reusable ELT/ETL frameworks and optimizing data pipelines for performance and scalability. • Well versed in designing and implementing Medallion architecture using ADLS Gen2, Delta Lake and Databrick’s Unity Catalog for data governance • Recognized for leading cross-functional teams, aligning technical strategy with business goals, and enabling continuous integration and delivery using Azure DevOps. I am passionate about innovation in data and currently expanding expertise in Data Science, Machine Learning, and Generative AI.

Experience

13 yrs 8 mos

Total Experience

6 yrs 10 mos

Average Tenure

9 yrs 7 mos

Current Experience

Independent health

2 roles

Lead Solution Architect - Cloud Data Engineering

May 2021 – Present · 5 yrs · Buffalo, New York, United States · Hybrid

Contributed to the architecture and development of a Python-based automated data validation framework to streamline data quality checks
Led multiple proof-of-concept (PoC) initiatives utilizing Azure Data Factory, Synapse Analytics, and Databricks to define the migration strategy from on-premises data warehouses to the Azure cloud ecosystem
Implemented Databricks and Synapse notebooks to assess and drive the migration approach for legacy Informatica mappings and on-prem enterprise data warehouse (EDW) workloads
Designed and implemented a Medallion Architecture (Bronze, Silver, Gold layers) using Azure Data Lake Storage (ADLS) and Delta Lake to support scalable, modular data pipelines
Leveraged Databricks Unity Catalog to enforce data governance, access control, and lineage across the lakehouse environment
Modeled and implemented dimensional data structures within Synapse Dedicated SQL Pools to support performant reporting and dashboarding for end-user analytics
Engineered optimized Azure Data Factory pipelines to orchestrate movement of curated data from Databricks to Synapse Dedicated Pool for downstream analytics and BI integration
Actively contributed to architectural discussions, establishing CI/CD best practices and implementing version control standards using Azure DevOps to support robust, automated deployments of data pipelines and code artifacts

PythonPySparkAzure Data FactoryDatabricksSynapse AnalyticsSolution Architecture+1

Lead Solution Architect - ETL Solutions

Oct 2016 – May 2021 · 4 yrs 7 mos · Buffalo, New York, United States · Hybrid

Designed and implemented end-to-end ETL solutions using Informatica PowerCenter, ensuring data integrity, performance, and scalability
Created detailed source-to-target mapping (STM) documents to support development and maintain traceability of business requirements
Authored comprehensive application process flow documentation
Provided technical leadership and mentorship to ETL developers, working closely with solution architects to deliver high-quality data integration artifacts
Participated in requirement elicitation and collaborated with BAs and SMEs to review and finalize mapping specifications
Conducted in-depth data scenario analysis and facilitated brainstorming sessions with business analysts and key stakeholders to validate requirements and edge cases
Led and participated in code review sessions and Supported QA and UAT testing by providing technical expertise to ensure code quality
Delivered walkthroughs of data flows and application processes to business users and prod support teams, and prepared Standard Operating Procedures (SOPs)

Informatica PowerCenterSQLETL Solutions

Anthem blue cross and blue shield

Solutions Architect

Jul 2015 – Sep 2016 · 1 yr 2 mos · Cincinnati, Ohio, United States · On-site

Architected and implemented robust ETL solutions using Informatica PowerCenter to support data exchange between various vendors and systems.
Developed comprehensive source-to-target mapping (STM) documents to ensure clarity and alignment with business requirements
Provided technical leadership and mentorship to ETL developers and QA teams, collaborating closely with SMEs to ensure accurate and high-quality data delivery
Conducted detailed data scenario analysis and facilitated brainstorming sessions with business analysts and stakeholders to validate logic and requirements
Participated in code and test result reviews to maintain high development standards and functional accuracy
Delivered technical support for QA, UAT, and integration testing phases
Conducted walkthroughs of data flows and application logic for business and production support teams for seamless handover

Informatica PowerCenterOracle SQL PLSQLSQLETL Solutions

Kronos incorporated

Technical Manager

Apr 2014 – Jun 2015 · 1 yr 2 mos · Pune, Maharashtra, India · On-site

Technical Manager – Informatica ETL Projects
Led a cross-functional team of 16 members, including ETL leads, developers, and testers, ensuring successful delivery of complex Informatica-based data integration projects
Acted as the primary point of contact for business leadership and SMEs, providing regular project status updates, resolving issues, and aligning deliverables with business expectations
Provided hands-on technical guidance to the team, establishing best practices and standardizing processes to improve delivery efficiency and solution quality
Conducted code reviews to enforce high development standards and consistency across the team
Managed team resourcing, supported individual growth aspirations, and maintained alignment with project and business objectives
Successfully turned around a high-visibility project from frequent escalations to a stable delivery model, earning strong customer trust and satisfaction
Recognized by client and internal leadership for achieving delivery excellence, with the feedback: "Just maintain the current delivery standard and continue to keep CSAT high"

InformaticaSQLOracle SQL PLSQLProject Management

Allstate

2 roles

ETL Lead

Jun 2012 – Apr 2014 · 1 yr 10 mos · On-site

Designed dimensional data models to support data mart development and reporting needs
Defined and implemented landing and staging layer load processes for structured ingestion
Authored comprehensive Low-Level Design (LLD) documents outlining transformation logic and data flow
Created detailed source-to-target mapping specifications to guide Informatica ETL development
Established and scheduled nightly data load processes, and coordinated a support team for monitoring and issue resolution
Actively participated in code reviews and validation of test results to ensure data quality and design integrity
Engaged with business stakeholders to secure approval and sign-off for production deployment of the ETL solution

InformaticaSQLOracle SQL PLSQLETL Development

Technical Manager

Mar 2010 – Jun 2012 · 2 yrs 3 mos · On-site

Led a high-performing team of 26 professionals, including Informatica leads, developers, and ETL testers, across multiple phases of complex data integration projects
Served as the single point of contact for business leadership and SMEs, ensuring transparent project tracking, timely status updates, and proactive issue resolution
Provided technical mentorship and solution guidance to team members, while standardizing development practices and implementing process improvements
Conducted regular code reviews to uphold code quality, consistency, and adherence to architectural standards
Oversaw team resourcing and development, balancing individual career growth with business delivery goals
Maintained consistent "Green" project delivery status over a 3-year period, earning multiple spot awards including recognition as the “Team with Zero Escalations”

InformaticaSQLTeam Management