ASHISH PANCHBUDHE
Data Architect
Pune
Summary
Collaborative leader with dedication to partnering with coworkers to promote engaged, empowering work culture. Documented strengths in building and maintaining relationships with diverse range of stakeholders in dynamic, fast-paced settings.
Overview
13
13
years of professional experience
4
4
years of post-secondary education
4
4
Certifications
Work History
Tech Manager
ECLERX
Pune
11.2021 - Current
- Designed solution for Data modernization project using Snowflake and ADF.
- Cost for technology selection and resource estimations for project.
- Understand requirements in discovery phase and well document data transformation and translation requirements from client.
- Worked on snowflake cost optimizer accelerator which saved compute and storage cost by 20% for project.
- Worked closely with tech team and monitor best practices. Conducted Stakeholder interviews for new client onboarding.
- Additional responsibilities:
- Growing Snowflake cloud DWH practice within organization.
- Pitch solutions to existing and new customers on Snowflake and create supporting collaterals.
- Work on reusable framework and Accelerators.
Application development specialist
ACCENTURE
12.2020 - 10.2021
- Worked on data modernization and data migration project.
Worked extensively on writing optimized SQL queries in snowflake and Oracle. - Leveraged Azure Blob storage as external storage for Snowflake.
- Closely worked with Client SMEs for requirement gathering and on going issues.
- Well versed with Azure DevOps utilities and version control (Git or equivalent).
- Documentation of process and tech flows includes data mapping sheets, ETL design documents, UT docs, etc.
- Adequate experience in performance tuning in snowflake.
Application development specialist
ACCENTURE
03.2019 - 11.2020
- I was leading offshore team with testing and development module.
- Interacted with client to understand requirement for development phases and closely work on ETL designs.
- Recorded business transformations and design dimensional modeling.
- Developed Cloud mappings to extract data for inbound and outbound processes using Informatica cloud ETL.
- Implemented CDC and Incremental load strategies as per business requirement.
- Worked on improving mapping performance by tuning Sources, transformations, Targets and identified system bottlenecks.
- Monitor and Involved in E2E Testing and UAT.
Sr. Data Analyst
COGNIZANT
12.2017 - 03.2019
- Interacted with the client and draft out the business requirements.
- Worked on the enhancement and development of data Mappings using informatica power center tool.
- Worked on the data related issue which are raised by customer and provide the permanent fix.
- Developed mapping using key data transformations in Informatica and optimized them based on industry best practices.
- Collaborated with stakeholders regarding project capabilities and limitations to deliver optimal functionality.
ETL Informatica Developer
PHROGAPP LAB
12.2016 - 12.2017
- Requirement understanding and define roadmap for new process development.
- Performed one time migration from premise database structure to Redshift data warehouse.
- Developed unix shell script framework to perform migration and operationalized process.
- Data analysis and creating solutions based on business requirement and customer needs.
- Worked on data loading and file housekeeping framework using Amazon Redshift, Unix, S3 file system and Postgres sql.
- Involved in developing High-Level Design Document (HLDs) and Low-Level Design Documents (LLD).
- Analyzed sources, targets, transformed data, mapped data and loaded data into target.
ETL Informatica Developer
TECH MAHINDRA
01.2014 - 12.2016
- Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
- Performed analysis on quality and source of data to determine accuracy of information being reported.
- Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
- Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from Oracle, flat file sources targeting the views (views on the target tables) in the target database (Oracle).
- Worked on Informatica PowerCenter tool - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
- Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
- Involved in unit testing, Integration testing and User acceptance testing of the mappings.
Data Migration Specialist
TECH MAHINDRA
02.2011 - 12.2013
- Responsible for requirement gathering and analysis for data migration using Siebel EIM.
- Developed EIM mappings for migration the proposed data base design.
- Used plsql packages and UNIX shell scripts to run jobs on production.
- Responsible for data cleansing and modifications of all post-paid, epostpaid and prepaid customers data.
- Used plsql packages and UNIX shell scripts to run jobs on production.
- Extensively involved into CRM support activities once data had been migrated on CRM and worked to reduce remedy tickets for CRM.
Education
Bachelor of Engineering - Electronics And Telecommunications
JDIET College, Amravati University, Maharashtra, India
Yavatmal 06.2006 - 08.2010
Skills
REQUIREMENT GATHERINGundefined
Certification
Snowpro core
Timeline
Tech Manager
ECLERX
11.2021 - Current
Application development specialist
ACCENTURE
12.2020 - 10.2021
Application development specialist
ACCENTURE
03.2019 - 11.2020
Sr. Data Analyst
COGNIZANT
12.2017 - 03.2019
ETL Informatica Developer
PHROGAPP LAB
12.2016 - 12.2017
ETL Informatica Developer
TECH MAHINDRA
01.2014 - 12.2016
Data Migration Specialist
TECH MAHINDRA
02.2011 - 12.2013
Bachelor of Engineering - Electronics And Telecommunications
JDIET College, Amravati University, Maharashtra, India
06.2006 - 08.2010
Similar Profiles
Chante ReedChante Reed
Event Marketing Manager at eClerxEvent Marketing Manager at eClerx
NANDINI LAGADNANDINI LAGAD
Analyst at eClerxAnalyst at eClerx
Mukul BhoriaMukul Bhoria
Analyst at eClerxAnalyst at eClerx
Priyanka GhopradePriyanka Ghoprade
Senior Analyst, SFMC DEVELOPER at eClerxSenior Analyst, SFMC DEVELOPER at eClerx
Niraj DigheNiraj Dighe
Lead Software Engineer at Cloud Software GroupLead Software Engineer at Cloud Software Group