Akshay Solanki
Data & Analytics Consultant with 5+ years of experience in data modernization, cloud migration, and ETL transformation
Hire this person
Send a job offer directly to this candidate
About
Data & Analytics Consultant with 5+ years of experience in data modernization, cloud migration, and ETL transformation across BFSI and regulatory domains. Proven success in migrating SAS frameworks to Databricks/PySpark, achieving 35% faster processing. Skilled in regulatory compliance (SEBI), Informatica BDM, data quality frameworks, and stakeholder engagement. Adept at translating complex data architectures into business outcomes.
Experience
Consultant - CLA Global Indus Value Consulting - Ahmedabad (Remote)
(2024-02 - 2026-05)
- Led migration of SAS frameworks to Databricks/PySpark, delivering 35% faster processing for Tier-1 banking datasets.
- Architected PySpark pipelines, reverse-engineered SAS macros, and optimized distributed jobs via partitioning, caching, and SQL tuning.
- Implemented dual-run validation frameworks ensuring 100% data consistency between SAS and Spark outputs.
- Managed DevOps lifecycle with Git/Bitbucket integration, code reviews, and production deployments.
- Partnered with cross-functional teams to translate business requirements into technical delivery plans.
SAS Consultant - Protogene Consulting Pvt Ltd - Mumbai
(2022-02 - 2023-09)
- Enhanced regulatory reporting by deploying Informatica BDM solutions ensuring SEBI compliance.
- Conducted multi-source data extraction, cleansing, and transformation using SAS EG/Studio & SQL.
- Built executive dashboards in Tableau/Power BI, surfacing insights for senior management.
- Tuned queries across databases, reducing execution run-times and improving SLA adherence.
SAS Developer - Nupeak IT Solutions LLP - Mumbai
(2020-11 - 2022-01)
- Delivered Tier-2 engineering consulting & SAS platform administration for enterprise clients.
- Supported pre-sales activities with proposals and Proof-of-Concepts.
- Conducted C-level presentations, aligning technical designs with business outcomes.
- Maintained system documentation & runbooks ensuring high availability.
Trainee Data Analyst - KMK Consulting Inc. - Vadodara
(2019-06 - 2019-07)
- Applied SAS programming to pharma datasets, producing analytical outputs for reporting workflows.
SAS Trainee / Student - Epoch Research Institute India Pvt. Ltd. - Ahmedabad
(2017-12 - 2018-12)
- Completed Statistical Business Analyst certification program, mastering data analytics architectures and statistical modeling workflows.
- Gained hands-on proficiency in Base & Advanced SAS programming, enhancing large-scale data manipulation and reporting.
- Attended and earned certifications across core components including Base SAS, SAS Viya, Deep Learning, ANOVA/Regression, and Text Analytics.
Education
M.Sc. - Biostatistics - Sardar Patel University (2017)
B.Sc. - Statistics - MG Science Institute (2014)