Abhinav Gupta
SAS Migration Specialist
Bengaluru
Summary
Experienced IT professional with over 16 years of expertise in SAS EG, SAS DI, SAS EBI, Teradata, SQL, SAS Grid, SAS FCM, SAS BASE, and SAS MACROS. Certified as a Microsoft Azure Data Engineer Associate and AWS Data Engineer Associate. Deep understanding of SAS 9.4 Intelligence Platform Architecture and successful experience leading migration projects. Skilled in SQL, Oracle, and Teradata. Proven track record of training and mentoring junior staff in SAS-based projects across various domains including Clinical, Banking, and Taxation.
Overview
16
16
years of professional experience
4
4
years of post-secondary education
Work History
Senior Specialist-Data Engineering
LTIMindtree Pvt. Ltd
03.2022 - Current
- Spearheaded the implementation of Agile frameworks, improving project delivery speed by 35% and enhancing
reporting accuracy for 150+ stakeholders. - Championed Agile adoption across the data engineering team, resulting in a 35% increase in project completion rates through bi-weekly sprints.
- Evaluated staff performance and provided coaching to address inefficiencies.
- Performed detailed impact analysis of ETL modifications, resulting in a 25% increase in data processing efficiency
and a 30% reduction in system downtime. - Executed meticulous debugging of over 200 Databricks notebooks, reducing overall ETL pipeline execution time by 35%.
- Optimized PySpark scripts for Denodo view integration, reducing data retrieval time by 40% for a user base of over 500.
- Generated and analyzed TOSCA reports, achieving a 97% data match between SAS datasets and PySpark outputs,
ensuring data integrity. - Implemented parallel data pipeline execution, enabling the processing of over 1 million records per hour with an
80%+ performance improvement.
Associate Consultant
Wipro Limited
02.2019 - 03.2022
- Delivered high-quality presentations showcasing key findings and recommendations to both internal stakeholders and clients.
- Helped team of 10 to optimize efficiency of current systems by conducting training sessions.
- Developed and maintained comprehensive documentation for 150+ job functions, accelerating engineer onboarding
and reducing training time by 30%. - Facilitated cross-functional collaboration with testing and administration teams, resolving execution issues and
delivering daily status reports. - Diagnosed and molded execution issues, achieving a 95% same-day resolution rate, and enhancing project visibility
through timely reporting. - Performed detailed root cause analysis, identifying and preventing recurring testing defects, improving overall code quality.
Technical Lead
L&T InfoTech Pvt. Ltd
07.2017 - 02.2019
- Verified and implemented complex ITD compliance rules, accurately introducing 150+ database fields and
transforming client platform data accuracy by 40%. - Engineered and deployed over 200 targeted Teradata queries, enabling timely alerts and increasing critical issue response rates by 30%.
- Designed and fostered 50+ SAS Prep and enrichment tables for SAS FCM, streamlining data processes and reducing report generation time by 60%, enhancing client satisfaction.
- Analyzed and translated intricate ITD compliance regulations, successfully introducing 300+ database fields and decreasing processing errors in client reports by 40%.
- Developed sophisticated data visualization tools using Excel and PowerPoint, which improved stakeholder
engagement during presentations, leading to a 25% increase in project funding approvals and enhanced decision making capabilities. - Orchestrated cross-functional problem-solving sessions that addressed critical project bottlenecks, successfully
resolving issues for over 50 projects and improving overall team efficiency by an impressive 40%. - Spearheaded strategic negotiations with cross-functional teams, enhancing collaboration and decreasing project
delivery time by 30%, while successfully managing a portfolio of projects worth $5M.
CDP II
Parexel International Pvt. Ltd.
12.2014 - 07.2017
- Interpreted complex client specifications, translating them into actionable data processing requirements, ensuring project alignment.
- Self-motivated, with a strong sense of personal responsibility.
- Engineered standardized datasets, achieving a 20% reduction in data redundancy through optimized programming techniques.
- Accelerated data retrieval by 15% through implementing optimized SQL queries for efficient large dataset merging. Delivered comprehensive reports and listings, empowering statistical programmers to efficiently analyze critical clinical trial data.
- Developed and validated CDISC-compliant mapping programs, guaranteeing data standardization across multiple studies.
- Molded external data discrepancies, sustaining 100% data accuracy through meticulous reconciliation processes. Designed and deployed efficient data extraction codes, streamlining data acquisition from diverse sources, improving efficiency.
- Upholding strict adherence to SOPs, mitigated compliance risks and safeguarded data integrity throughout all project phases.
Statistical Programmer
Cenduit India Pvt. Ltd.
07.2011 - 11.2014
- Reduced project costs by optimizing algorithms and codebase performance, enhancing overall efficiency.
- Generated and delivered client reports on a bi-weekly, bi-monthly, and quarterly basis, providing timely insights into
study progress. - Conducted early-stage verification of Randomization/Material requirements using SAS, ensuring consistency with the study protocol and preventing downstream errors.
- Validated dummy randomization and material lists generated by SAS, ensuring accurate system configurations before live implementation.
- Performed detailed consistency checks between system-defined visits, URS documents, and Visit Designer
configurations, aligning with SRS document specifications.
Verified system design alignment with protocol and randomization plans, ensuring compliance with documented requirements and preventing deviations. - Executed critical SAS checks to guarantee accurate randomization and treatment balance within the live system,validating system adherence to SRS specifications.
- Conducted monthly reviews of active systems using SAS macros and standard codes, identifying and resolving issues related to randomization, kit distribution, and dispensing algorithms.
SAS Analyst
Neptune Solutions
04.2009 - 06.2011
- Spearheaded the migration from legacy systems to updated SAS platforms, ensuring minimal downtime during transition periods.
- Managed the full lifecycle of business change requests, from analysis and design to development and implementation,ensuring seamless integration.
- Developed detailed solution designs and provided accurate effort estimations, optimizing project planning and resource allocation.
- Engineered and tested robust SAS ETL processes, ensuring data integrity and efficient data flow across systems.
- Executed thorough unit testing using Enterprise Guide and Base SAS, identifying and resolving defects early in the
development cycle. - Resolved SIT and UAT variances efficiently, ensuring smooth transitions to production and minimizing disruptions.
- Optimized ETL job performance through meticulous tuning, reducing processing times and improving overall system efficiency.
- Designed and developed OLAP cubes and information maps, enabling advanced data analysis and reporting
capabilities. - Created and deployed scheduled, parameter-driven, and interactive reports, providing clients with actionable insights.
- Deployed and scheduled jobs, ensuring timely and reliable data processing and report generation.
Education
B.Tech - IT
Kurukshetra University
Kurukshetra, Haryana 01.2004 - 01.2008
Skills
Microsoft Azure
Windows
UNIX
SAS Grid
SAS DI Studio
SAS OLAP Studio
SAS/BASE
SAS/MACRO
SAS/SQL
SAS/ODS
SAS Enterprise Guide
SAS Management Console
SAS Information Map Studio
SAS Web Report Studio
SAS Information Delivery Portal
undefinedProject Portfolio
- SAS2PySpark Migration, 02/23 - 02/25, LTIMindtree Pvt Ltd, Thryve Digital Health LLP, Associate Consultant, SAS BASE, SAS MACROS, PySpark, Databricks, Gitlab, GCP Big Query, Denodo, TOSCA
- Product Owner, 04/22 - 02/23, LTIMindtree Pvt Ltd, Scintilla, Product Owner, SAS BASE, SAS MACROS, PySpark, Databricks, HDINSIGHT, AWS EMR, GCP, GIT, VS CODE
- SAS Developer, 01/20 - 03/22, Wipro Limited, ANZ Bank, Associate Consultant, SAS BASE, SAS MACROS, Oracle 11g, SAS DI, SAS SMC, SAS EG, Linux, JIRA, Confluence, Oracle 19c
- SAS Admin, 02/19 - 01/20, Wipro Limited, Regeneron Pharma, Associate Consultant, SAS BASE, SAS MACROS
- Insight, 07/17 - 02/19, Income Tax Department, Central Board of Direct Taxes, Taxation, Technical Lead, SAS FCM, SAS DI, SAS EG, Teradata, Postgres, Python
- Clinical Data Management, 12/14 - 07/17, Parexel International Pvt. Ltd., AstraZeneca, Merck, Clinical, CDP II, SAS EG, SAS/Base, Macros, SAS/ SQL, Excel, UNIX
- Clinical Data Management, 07/11 - 11/14, Cenduit India Pvt. Ltd., AstraZeneca, Novartis, Astellas, Merck, Health Care, Statistical Programmer, SAS/Base, Macros, SAS/ SQL, Excel, UNIX
- Retail Credit Data Warehouse (RCDW), 04/09 - 06/11, Neptune Solutions, Bank from Canada, Banking/Finance, SAS Analyst (SAS Data Integration Studio), Windows XP, Oracle DB, SAS Data integration Studio, SAS EBI Server (SAS DI Studio, OLAP Cube Studio, Information Map Studio, EG, OLAP Viewer WRS, and IDP)
Timeline
Senior Specialist-Data Engineering
LTIMindtree Pvt. Ltd
03.2022 - Current
Associate Consultant
Wipro Limited
02.2019 - 03.2022
Technical Lead
L&T InfoTech Pvt. Ltd
07.2017 - 02.2019
CDP II
Parexel International Pvt. Ltd.
12.2014 - 07.2017
Statistical Programmer
Cenduit India Pvt. Ltd.
07.2011 - 11.2014
SAS Analyst
Neptune Solutions
04.2009 - 06.2011
B.Tech - IT
Kurukshetra University
01.2004 - 01.2008
Similar Profiles
Benny M KurianBenny M Kurian
Senior Software Developer at Anlage Pvt Ltd / LTIMindtree Pvt LtdSenior Software Developer at Anlage Pvt Ltd / LTIMindtree Pvt Ltd
Susmita BiswasSusmita Biswas
Senior Engineer Cloud&Infra Management(ProjectSME) at LTIMindtree Pvt LtdSenior Engineer Cloud&Infra Management(ProjectSME) at LTIMindtree Pvt Ltd
Aditi SinghAditi Singh
Software Engineer at LTIMindtree Pvt. Ltd.Software Engineer at LTIMindtree Pvt. Ltd.
HARISH VADLAMANIHARISH VADLAMANI
Consultant at Affine AnalyticsConsultant at Affine Analytics
Srikanta K NSrikanta K N
Senior Python Developer / AI Integration Engineer at Wipro LTD (Daimler-AG Project)Senior Python Developer / AI Integration Engineer at Wipro LTD (Daimler-AG Project)