Abhay Swarnkar
Pune,Maharashtra
Work Preference
Work Type
Full TimeLocation Preference
On-SiteHybridImportant To Me
Work-life balanceCompany CultureCareer advancementPersonal development programsSummary
Strategic IT leader with 10+ years of experience driving digital transformation, business intelligence, and technology solutions across global organizations. Proven expertise in end-to-end delivery of cloud, data, and analytics platforms, with a strong focus on stakeholder engagement and business value realization. Adept at aligning technology initiatives with business goals, optimizing project portfolios, and leading high-performing teams. Recognized for innovative problem-solving, operational excellence, and delivering measurable impact in fast-paced, regulated environments.
Overview
11
11
years of professional experience
2
2
Certification
Work History
Business Technology Manager
ZS Associates
Pune, Maharashtra
01.2025 - Current
- Liaised between business and technology units to manage delivery schedules for applications.
- Communicated cross-functionally with technology leaders across analysis, architecture, build, quality assurance, deployment and support teams on project execution.
- Lead multiple teams overseeing multiple projects focused on delivering valuable insights and suggestions to Veeva CRM and HQ emails through SFMC and other vendor channels across the globe.
- Worked as Solution Architect on a custom Stack to create a Kimball Data model-based Snowflake data warehouse.
- Skilled in identifying, evaluating, and integrating new technologies (AI, automation, cloud) to drive innovation and operational efficiency.
Business Technology Consultant
ZS Associates
Pune, Maharashtra
07.2022 - 12.2024
- Leveraging ZS's tool, ZAIDYN CE, a cloud-based product suite handling ETL, configuration, and reporting for omnichannel implementation, our efforts aim to enhance sales reps' efficiency and empower doctors with informed decision-making.
- Using a distributed ETL framework, we generate diverse metrics for evaluating insights before presenting them in Veeva CRM and Vendor channels.
- The backend operations utilize Spark SQL and EMR clusters for robust compute power, and the implementation spans across multiple countries.
- Regional Omnichannel implementations for field customers have helped increase sales and targeted marketing resulting in an uplift of 5% of sales in a quarter.
- Working closely with Client leadership for creating Sales Impact Dashboard on Power BI.
- Adept at designing, implementing, and continuously improving project management processes, quality checks, and data governance frameworks.
- Demonstrated success in leading change management initiatives, training, and driving user adoption for new systems and processes.
- Strong background in developing and validating analytics solutions, supporting data-driven decision-making and executive reporting.
Technical Lead
Accenture
Pune, Maharashtra
06.2021 - 06.2022
- Collaborated closely with the client's sales team, functioning as the pivotal figure for revenue reporting and acting as the primary liaison for any reporting-related needs, thereby contributing significantly to sales strategy and decision-making.
- Engaged with Client Senior Leadership to provide insightful ad hoc reports and conducted thorough monthly/quarterly data analyses, playing a pivotal role in shaping strategic business decisions at the highest level.
- Assumed a leadership role by mentoring the team and rigorously reviewing code changes, ensuring the highest standards of quality and efficiency in our data solutions.
- Demonstrated a strong capacity to bridge the gap between business requirements and technical solutions by translating intricate business needs into effective process designs and developments for Data Warehousing and ETL, thereby optimizing data-driven decision-making processes.
- Coordinating with On-shore and Off-shore Managers and sharing DSR and WSR.
Senior Software Engineer
Accenture
Pune, Maharashtra
08.2019 - 06.2021
- Designing and developing Complex Informatica mappings including Type-I, Type-II, Type-III slowly changing dimensions (SCD).
- Worked with various transformations like Normalizer, Expression, Rank, Filter, Group, Aggregator, Lookup, Joiner, Sequence Generator, Sorter, SQL, Stored Procedure, Source Qualifier.
- Experienced in writing SQL, PL/SQL programming, Stored Procedures, Functions, Triggers, Views, Materialized Views.
- Performed performance improvement on existing for ETL Jobs.
- Maintaining documentations.
Data Engineer
Amdocs
Pune, Maharashtra
03.2019 - 08.2019
- Responsible for collecting, managing, and converting raw data into usable information through Business KPIs.
- Prepared detailed Ad hoc Reports as per Client requirements.
- Performing query performance testing and data validation.
Software Engineer
Tech Mahindra
Pune, Maharashtra
08.2015 - 03.2019
- Was Onshore for requirement gathering, development and support existing stack.
- Designed and developed Mappings, Workflows and scheduled them on Informatica.
- Prepared information from bulk data for Client analysis with Informatica.
- Problem tickets and Incidents Monitoring and Reporting.
- Reports development in XML Publisher and Oracle Reports.
- Developed scripts and programs as per business requirements in SQL, PL/SQL and Unix Scripts.
Education
Bachelor of Engineering - Computer Science and Engineering
01.2015
Skills
- AWS cloud-based data solutions
- Informatica PowerCenter
- Informatica IICS
- SSIS
- DBT
- ZAIDYN
- Snowflake
- SQL Server
- Data Warehouse Management
- SQL
- PL/SQL scripting
- Shell scripting
- Python
- Power BI
- Qlik
- SSRS
- XML Publisher
- Jira
- HP QC
- Git
Websites
Certification
- AWS Certified Solutions Architect – Associate, ab29bac567c8442e850a61494f64d4c6
- AWS Certified Developer – Associate, 7DJRGGJKPFVE1CKE
- Analytics, Modeling & Machine Learning Professional, ASAM0000022672
- Data Architect Associate Professional, ASMD0000017952
Accomplishments
- Project Champions Award - Celebrating Impact 2023
- FY20 Q3: ACE - Client & Customer Award
- FY18 Q4: Pat on Back Award
- FY17 Q4: Pat on Back Award
Skills And Strengths
Experienced with AWS cloud-based data solutions, Proficient in Informatica PowerCenter, Informatica IICS, SSIS, DBT, and ZAIDYN for end-to-end data pipeline development, Skilled in Snowflake, SQL Server, and Data Warehouse Management, with strong expertise in SQL and PL/SQL scripting, Proficient in Shell scripting and Python for automation and data manipulation, Hands-on experience with Power BI, Qlik, SSRS, XML Publisher, and Out-of-the-box reporting tools, Familiar with testing and defect tracking tools like Jira and HP QC, Competent in Git for repository and codebase management
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Timeline
Business Technology Manager - ZS Associates
01.2025 - Current
Business Technology Consultant - ZS Associates
07.2022 - 12.2024
Technical Lead - Accenture
06.2021 - 06.2022
Senior Software Engineer - Accenture
08.2019 - 06.2021
Data Engineer - Amdocs
03.2019 - 08.2019
Software Engineer - Tech Mahindra
08.2015 - 03.2019
Madhav Institute of Science and Technology - Bachelor of Engineering, Computer Science and Engineering