Abhineet Ashish
Software Engineer
Bangalore
Summary
A result-oriented software professional offering extensive experience of 8+ Years in Software Development, Data Profiling, Data Integration, Data Quality and Production Support.
Presently associated with PwC Acceleration Center as Senior Associate2.
Strong hands-on experience in PL/SQL (Oracle 11g), SQL Server, Talend Data Integration, Snowflake, Abinitio, Azure Services like Azure Storage, Azure Data Factory, Azure SQL DB, Azure Databricks.
Strong analytical skill with expertise in Root Cause Analysis, Discrepancy report generation and troubleshooting.
Having experience in preparing project POCs, RFPs for client proposals and other LOB's.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Associate2
PwC Acceleration Center
05.2022 - Current
- One to one engagement with Key Business Stakeholders and platform teams to understand the requirements and expected functionality of the application.
- Created the Internal Accelerator for PwC using Azure Databricks which automates the SIT Process.
- Analyze the various systems and data across them based on the inputs received and interact with data owners to discuss the outcomes and propose them with logical solution.
- Understand the Data Flow from Teradata Objects and transforming them into Logical Snowflake Objects and creating the Tasks based on the business logic for the proper data flow using Orchestration Workflows.
- Designed and implemented a data lake architecture resulting in a 25% reduction in storage costs.
- Designed and implemented ETL processes using Azure Data Factory.
- Collaborated with cross-functional teams to design and implement scalable data architectures.
- Implemented data governance and data profiling rules resulting in a 30% reduction in data quality issues.
- Understand the Data Flow from Upstream system S4 to our Snowflake Tables followed by Data Validation, Data Profiling and Standardization for further processing and transformation as per the BAUs using our Snowflake Procedures and make data ready for the downstream systems.
- Troubleshooting the Deployed Processes, testing, validating the Output and giving support to the deployed Processes along with SIT and UAT.
Technical Lead
HCL Technologies Pvt. Ltd.
10.2021 - 05.2022
- One to one engagement with Key Business Stakeholders and platform teams to understand the requirements and expected functionality of the application.
- Understand the Data Flow from PL/SQL Procedures and Abinitio ETL and transforming them into Logical ETL Jobs using Talend Big Data and Talend DI.
- Extracting the data from different sources like RDBMS, Delimited Files, EBCIDIC Files etc.
- Designing, Developing, Validating and Deploying the ETL Jobs and DQ processes using Talend data integration, Talend Bigdata and Talend Administration Console tools.
- Data Profiling, Standardization and Address Validation, Matching and consolidating them for BAUs.
- Troubleshooting the Deployed Talend Jobs, testing, validating the Output and giving support to the deployed ETL Jobs.
- Creating ETL Job Infrastructure Using Talend and deploying, publishing and scheduling them Using TAC.
- On call interactions with different teams and make them to understand and correct the discrepant data.
I.T Analyst
Tata Consultancy Services
08.2019 - 10.2021
- Managing the production database for Oracle, Microsoft, and resize the space of database, data files, table space and transactional logs.
- Translating the business rules and functionality requirements into ETL framework to ensure conformity, compliance with standards and lack of redundancy.
- Creating ETL Job Infrastructure Using Talend and deploying, publishing and scheduling them Using TAC.
- Research, development, document, and modification of ETL processes as per data architecture and modeling requirements.
- Understand the Data Flow from PL/SQL Procedures and Abinitio ETL and transforming them into Logical ETL Jobs using Talend Big Data and Talend DI.
- Extracting the data from different sources like RDBMS, Delimited Files, EBCIDIC Files etc and using them for transformation as per the BAUs.
Application Development Senior Analyst
ACCENTURE SOLUTIONS PVT. LTD.
10.2015 - 07.2019
- One to one engagement with Key Business Stakeholders and platform teams to understand the requirements and expected functionality of the application.
- Consolidating multiple formats and disjoint data sets into single format data sets and bring actionable insights to surface.
- Baseline the coverage which defines the amount of data profiled at a given point of time and identifies the quality which quantifies the percentage of covered data that is clean and meets business rules.
- Set up Governance for data and provide data quality solution by identifying the discrepancies and performing RCA's to ensure non-recurrence of issue and improve customer satisfaction.
- Prepare discrepancy reports and propose end to end solution for the key highlighted problems to ensure the expected output, better data quality and customer satisfaction.
- Translated business rules and functionality requirements into ETL Jobs using Talend DI and Talend Bigdata.
- Deployed, Published and Scheduled Talend Jobs through TAC.
- Performance tuning of the existing procedures according to reduce the overall job time and cost.
Education
Bachelor of Engineering - Electrical And Electronics Engineering
BNM Institute Of Technology
Bangalore 04.2001 -
12th Standard - AISSCE -
Guru Nanak Higher Secondary School
Ranchi, Jharkhand 04.2001 -
10th Standard - AISSE -
DAV Public School
Muzaffarpur, Bihar 04.2001 -
Skills
Data Integration
Data Quality
Data Profiling
ETLs like Talend, Ab initio and Azure Data Factory
Azure Databricks
Databases like Oracle, Microsoft SQL Server, Snowflake
Scheduling tools like TAC, TMC
PL/SQL, SQL, Performance Tuning
Root Cause Analysis
Certification
DP-203: Microsoft Azure Data Engineer Associate
Awards Recognition
- Received award of highest honor from Accenture: ACE Award for achieving targets and gaining client confidence by multitasking on allotted activities.
- Received APEX award at Vertical level for quality delivery of reports and different interfaces.
- Recognition Award: Appreciation award from the client for exceptional contribution to the project in October 2016 and eCard from Client for Pride and Honor and All-rounder.
Proficiency
- Hindi
- English
Personal Information
Date of Birth: 02/26/93
Disclaimer
I hereby declare that the above stated information is true to the best of my knowledge.
Timeline
Senior Associate2
PwC Acceleration Center
05.2022 - Current
Technical Lead
HCL Technologies Pvt. Ltd.
10.2021 - 05.2022
I.T Analyst
Tata Consultancy Services
08.2019 - 10.2021
Application Development Senior Analyst
ACCENTURE SOLUTIONS PVT. LTD.
10.2015 - 07.2019
Bachelor of Engineering - Electrical And Electronics Engineering
BNM Institute Of Technology
04.2001 -
12th Standard - AISSCE -
Guru Nanak Higher Secondary School
04.2001 -
10th Standard - AISSE -
DAV Public School
04.2001 -