Summary
Overview
Work History
Education
Skills
Accomplishments
Personal Information
Disclaimer
Right To Work In Uk
Certification
Additional Information
Languages
Timeline
Generic
Sonalika Pradhan

Sonalika Pradhan

London

Summary

Innovative and results-driven Data Engineer with 7+ years of experience delivering impactful software and data solutions across diverse industries. Proficient in ETL development, data warehousing, and support analysis, with expertise in tools and technologies such as SSIS, SSRS, MSBI, PL/SQL, T-SQL, Python, SAP BODS, Snowflake, Power BI, Azure and UNIX. Adept at designing and optimizing scalable ETL processes to ensure seamless data ingestion, integration, and analysis, contributing to robust and reliable Data Warehouse systems. Experienced in Agile/DevOps and Waterfall methodologies, with a proven ability to create technical design artifacts, QA documentation, and drive cross-functional collaboration. Motivated, adaptable, and continuously learning to stay ahead in a dynamic technology landscape.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Senior Data Engineer, ETL Developer

Infinite Computer Solutions
02.2024 - 11.2024
  • Company Overview: Infinite is a global leader in digital engineering and IT services, with over two decades of experience helping clients turn digital transformation into business value.
  • Data ingestion, analysis and integration using SSIS
  • Built and optimized ETL processes
  • Monitored SAP daily ETL Jobs running on SAP Data Services Management Control where the jobs were responsible for the getting the data loaded to SQL server tables from various up streams which were further used by SAP WebI to create SAP reports was responsible for troubleshooting and fixing the issue if any failure
  • Have worked on major issues on data identified by the business using Information Design Tool and SSMS
  • Have worked on the SAP WebI Report issues which is raised by the business on daily basis
  • Client: WorldStrides

Senior Data Engineer, ETL Developer

Yash Technologies Pvt. Ltd
04.2023 - 09.2023
  • Company Overview: YASH Technologies is a customer-centric transformational global IT solutions and services partner with a proven track record in delivering battle-tested consulting, technology, and outsourcing services to address clients’ evolving and complex digital transformation challenges.
  • Monitored daily ETL jobs running on SSMS and was responsible for giving fix to the daily jobs running on SQL server agent
  • Worked for the Product Backlog Items raised by business stakeholders to maintain the application running smoothly everyday by using the SSIS packages, SQL Server objects i.e., Stored Procedures, Tables, Views, Functions
  • Have worked on application backend to give fix daily /Ad-hoc jobs running on SQL server by digging in the SSIS packages deployed in the servers
  • Client: H.B Fuller

Data Engineer, ETL Developer, Application Lead

Wipro Technologies
06.2017 - 03.2023
  • Company Overview: Client: Wipro is a multinational technology company based in Bengaluru, which provides information technology, consulting and business process services.Its services range from cloud computing, computer security, digital transformation, artificial intelligence, robotics, data analytics, and other technologies, present in 167 countries.
  • Performed data migration from sales 2015 to d365
  • Also, worked on ETL processes which integrate and structure data from various sources to d365 sales hub
  • Proficient in using KingskwaySoft tool, which acts as a plugin between SSIS and CRM
  • Data analysis on CRM using XRM Tool Box
  • Prepare Unit Test cases and conduct Unit testing as part of development lifecycle
  • Worked on User stories related to application backend to fix the issue raised by Product owners or business stakeholder
  • Involved in package upgradation from SQL Server 2008 R2 to SQL Server 2017
  • Updating the backend data i.e store or sales data in the restaurant in the table by using store procedures or manually as per the existing structure
  • Running the Ad-hoc SSIS jobs manually as per the requirement
  • Involved in some development of SSIS packages as per the business requirement
  • Data ingestion, analysis and integration using SSIS
  • Built and optimized ETL processes
  • Involved in maintenance of two application annuity and reconciliation
  • Monitoring daily jobs and Adhoc jobs and fixing if it fails
  • Involved in health checkup of applications
  • Acted as an application lead for annuity
  • Acted as Product support analyst to manage all production issues
  • Monitored batch jobs using Control-m and arow and gave fix to the failed jobs by checking the logs in scheduling tools
  • Involved in automation engineering using protractor
  • Acted as a manual tester and involved in log analysis
  • Clients: Wellmark,P.F Chang,Microsoft,Capital One,Harman,Verifone

Education

Secondary - 10th

Govt. High School, Uditnagar
Rourkela,India,

Higher Secondary - +2 Science

Royal College of Science & Technology
Bhubaneswar,India,
07.2012

Bachelor of Technology - Electronics & Telecommunication Engineering

C V Raman College of Engineering
Bhubaneswar,India,
06.2016

Skills

  • SSIS
  • MSBI
  • SSRS
  • ETL
  • PL/SQL
  • MS SQL
  • Python
  • Unix
  • Snowflake
  • SAP BODS
  • Power BI
  • Azure Data Factory
  • Azure Databricks
  • Data Quality
  • SAP Webi
  • ADO
  • SSMS
  • CRM
  • Xrm ToolBox
  • KingwaySoft
  • Control – M
  • Visual Studio
  • Arow
  • Protractor

Accomplishments

  • Azure Certifications
  • Received many rewards and recognitions from Customers as well as my Employer

Personal Information

  • Date of Birth: 08/04/95
  • Gender: Female
  • Nationality: Indian
  • Marital Status: Married

Disclaimer

I hereby declare that all the above information furnished by me is correct and best to my knowledge.

Right To Work In Uk

Yes

Certification

AZ-900 (Azure Certification)

Additional Information

Personal Information


· Date of birth: 08/04/95

· Gender: Female

· Nationality: Indian

· Marital status: Married

· Right to Work in United Kingdom: Yes

Languages

English
Proficient
C2

Timeline

Senior Data Engineer, ETL Developer

Infinite Computer Solutions
02.2024 - 11.2024

Senior Data Engineer, ETL Developer

Yash Technologies Pvt. Ltd
04.2023 - 09.2023

Data Engineer, ETL Developer, Application Lead

Wipro Technologies
06.2017 - 03.2023

Secondary - 10th

Govt. High School, Uditnagar

Higher Secondary - +2 Science

Royal College of Science & Technology

Bachelor of Technology - Electronics & Telecommunication Engineering

C V Raman College of Engineering

Similar Profiles

CREATE PROFILE
Sonalika Pradhan