Anand Yerwa
Pune
Summary
Data Lead with 10 years of experience working on the large datasets. Skilled in data management, data migration, data integration projects. SQL Developer with hands- on experience on database management, developing SQL queries, handling functions & procedures, administering database and information systems. Lead team of 5-10 people across technology and data department.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Senior Associate Data Analytics
Stratosphere IT Services Private Limited
Pune
01.2024 - Current
- Designed and implemented the master data mapping for the data migration
- Collaborated with stakeholders to gather and validate data for migration, ensuring accuracy and alignment with their specific business needs and objective.
- Migration of data out of various Legacy Systems into the Salesforce. Leading the Migration team.
- Collaborated with cross-functional teams to ensure smooth communication and execution of the data migration process.
- Build a data integration platform from scratch to read data from various sources in different formats and perform data validation.
- Created advance SQL scripts to validate the data and import it into Salesforce using the SSIS.
- Developed multiple layers to transform the data according to the mapping document.
- Build, test and debug the data migration scripts to ensure their proper functioning.
- Develop reports for migrated data and provide post-go-live support to clients and needed.
- Provided technical guidance and support to team members as needed.
Senior Software Developer
YRC Software India LLP
02.2022 - 11.2023
- Designed and implemented the master data mapping for the data migration
- process for multiple Projects.
- Collaborated with clients to gather and validate data for migration, ensuring accuracy and alignment with their specific business needs and objective.
- Migration of data out of various Legacy Systems into the Salesforce. Leading the Migration team.
- Collaborated with cross-functional teams to ensure smooth communication and execution of the data migration process.
- Build a data integration platform from scratch to read data from various sources in different formats and perform data validation.
- Created advance SQL scripts to validate the data and import it into Salesforce using the Pentaho/SSIS.
- Developed multiple layers to transform the data according to the mapping document.
- Build, test and debug the data migration scripts to ensure their proper functioning.
- Develop reports for migrated data and provide post-go-live support to clients and needed.
- Provided technical guidance and support to team members as needed.
Assistant Manager
Bajaj Auto Finance Private Limited
11.2020 - 01.2022
- Implement Collection Strategies to improve Process.
- Data Integration between FTP Server files with SQL Database to update SQL database with latest Customer & Payment details.
- Creating & Maintaining database, indexes. Enhance database performance. Involved in developing and handling the Functions and Stored Procedures. Develop complex SQL queries, SQL Sub queries and Complex Joins.
- Responsible for publishing Zone-wise, Region-wise performance MIS of PAN India collection agents using SQL queries, Power Pivot, Microsoft Excel.
- Extract, Collate and consolidate Raw Data from various sources for Quality Reports.
- Responsible for data allocation to Call-Centers for Pre delinquency Management, also track call-centers performance on the same.
- Data analysis, Analytics and Reporting.
Senior Data Analyst
EGON Software Private Limited
07.2012 - 10.2020
- Daily / weekly / Monthly Report generation as per requirement. Collect & Analyze data from different resources
- Verify KYC/KYS documents of Customers/Vendors.
- Online Research of Customer business profile, review Annual report or Credit report of Customers & vendors.
- Responsible to keep updated all available customer information in system. Initiate and implement quality assurance protocols for software.
- Manage and document concepts, practices, procedures, processes and issues. Provide training to Sales team on Pivotal CRM.
- Worked closely with management teams to plan, develop, coordinate, and execute technical strategies aligned with the vision, mission and purpose.
Education
MCM - Master’s in Computer Management -
University of Pune
04-2016
PGDCM - Post Graduation Diploma in Computer Management -
University of Pune
04-2014
B-Com - Bachelors of Commerce -
University of Pune
04-2010
Skills
- Data Migration
- Salesforce Admin
- MS SQL
- Team Management
- MYSQL
- SSIS
- Pentaho, Data Loader, Rest Api's
- Power BI
- Microsoft Excel
- Stakeholders Management
- Management Reporting
Certification
Certified Salesforce Admin
Accomplishments
- Successfully migrated data for 6 projects during tenure.
- Awarded with Highest performer rating for 2 consecutive quarters. Automated 3 critical MIS.
- Recognized for handling critical reports and stabilized them during lockdown situation.
- Visited Hong Kong & China sales office multiple times for KYC/KYS document validation.
Contact Number
8983752214 / 9511658659
Full Name
Anand Chandrashekhar Yerwa
Personal Information
- Date of Birth: 07/12/90
- Marital Status: Single
Languages
- English
- Hindi
- Marathi
Timeline
Senior Associate Data Analytics
Stratosphere IT Services Private Limited
01.2024 - Current
Senior Software Developer
YRC Software India LLP
02.2022 - 11.2023
Assistant Manager
Bajaj Auto Finance Private Limited
11.2020 - 01.2022
Senior Data Analyst
EGON Software Private Limited
07.2012 - 10.2020
MCM - Master’s in Computer Management -
University of Pune
PGDCM - Post Graduation Diploma in Computer Management -
University of Pune
B-Com - Bachelors of Commerce -
University of Pune
Certified Salesforce Admin
Similar Profiles
Saurabh Kumar SinghSaurabh Kumar Singh
Sr. Solution Specialist at Noventiq Services India Private Limited(Former Softline Services India Private Limited)Sr. Solution Specialist at Noventiq Services India Private Limited(Former Softline Services India Private Limited)
IRCHAM JAUHARIIRCHAM JAUHARI
Building Inspector at Stratosphere Limited, PNGBuilding Inspector at Stratosphere Limited, PNG
SURAJIT SATPATHYSURAJIT SATPATHY
Technical Support Engineer at Stratosphere IT Services Pvt. LtdTechnical Support Engineer at Stratosphere IT Services Pvt. Ltd