09/06/2022 updated

**** ******** ****
100 % available

Data Engineer , SQL Server 2019 ,Azure synapse Analytics, ADF, SSIS, SSAS, Power BI, Python,

Bedford, United Kingdom
United Kingdom
Bedford, United Kingdom
United Kingdom

Profile attachments

CV - Amesh Parit

azure data factoryAzure Data LakeAzure DatabricksPhytonSSASpower shell scriptpower biSQL Server 2017data warehouse/modelling/analyzing/reporting/QM-..
I am a data engineer with over 10+ years of developer experience in .NET C#, SQL server 2016/2017/2019, ETL, SSIS,SSAS, T–SQL , Azure synapse Analytics, ADF, Advance SQLs and Dash Board using Power BI with Python R. Throughout my past roles working on a number of servers and databases, I have played a key role throughout the system development and support life cycle of a project to ensure that quality solutions exceed business objectives. My detail oriented and strong technical background add to my ability to produce advanced technical solutions based on client requirements. Happy to work any location in Europe.

Languages

EnglishGood

Project history

Data Engineer

WTW

Insurance

>10.000 team member

I am part of the Modern Data Warehouse development project for financial reporting of IFRS17 and the implications of creating IFRS 17 disclosures and broader implications for management reporting (KPIs) and Power BI dashboard.

  • Involved developing Start schema for reporting purpose
  • Created a data pipeline to pump data into reporting schema 
  • Created a complex data flow to create multiple reports and Dashboard
  • Azure SQL Server 2019, DevOpps
  • Power BI Dashboard
  • Data Modelling and tabular model
  • Azure synapse, Databricks, Data Lake
  • Creating Pipeline with a Data Factory
  • Unit Test Case
  • Technical Documentations

Data Engineer (Data Migrations/ETL)

BP

Banking & Financial Services

50-250 team member

Performance analyst treasury management data migration from oracle server to SQL cloud base environment.

  • Created table structure on Azure SQL server /Azure Synapse
  • Developed data pipelines to transfer data from Oracle and SQL Server to the Cloud environment
  • Developed dashboard and data request reports in Power BI
  • Testing

Data Enginner

Deloitte
Innosys IFRS 16 application.
Working on IRFS 16 tool
* Worked on Setup Innosys for clients like HSBC , VEON, WesFarmer, TetraPack etc
* Customization of IFRS 16 application according to customer requirement.
* Writing procedure, functions table design according the change request.
* Involved in SQL DBA activity setup new Database server, SQL Agents jobs, Backup and restore.
* Performance tuning working with column store, parameter snipping, table partition indexing etc
* Worked Batch process and ETL (SSIS) and T-SQL.
* Helping to complete the UAT and production rollout.
* DevOps setup .
* Participates in the ongoing support and problem resolution of Data and ETL Solutions.

SQL/BI Developer

Ernst & Young
Canvas-Financial Audit Tool.
Canvas, IS 'Audit Tool of the Future', is designed to create financial audits by auditors across
globe. Canvas is used in Assurance service line under Audit sub service line. Auditors use Canvas
tool to get the Financial Audit done which reflects the financial status of the company which is
being audited.

SQL Developer, C# (BI)

Unilever
Data warehouse for SCDG.
Global demand analysis and forecast product, including the company's fastest growing
categories.Buyers/Supply planners to manage inventory. Maintain and report forecast KPIs, such as
forecast accuracy, bias and MAPE.

SQL Developer (ETL)

Next PLC
In store, a Web-based application performs Asset management, Store information, order management,
payment process and tracking etc. Maintains tons of assets data and process them daily with various
task. Designed in .Net C#, SSIS, SSRS and SQL server 2008, 2012 Database.

SQL Developer

Cargill PLC
HRIT is a multi-platform human resource module which maintains all Cargill employees' data more than
140,000 workers. IT runs on Net. C#, SQL Server 2012, SQL Server 2008, SSIS, VBA, VB script and
Windows XP.

Database Developer

Capita Employment Benefit
Orbit is a web based award-winning employee benefits portal used by over 200 companies and more than
218,000 employees. It runs on JAVA Spring/Hibernate, Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL
server2008, SQL PLUS, ETL, SSIS, XML, HP-UNIX shell scripting, iReport.

Senior Database Developer

Capita Children's Services
Capita is a FTSE 100 company and a market leader in business process outsourcing to the Local
Authorities and schools in England and Wales. Some of the solutions Capita supplies include SIMS,
One and eSuite. These solutions run on C#.Net, Frame work 4.5,ASP.Net,VB 6.0, PowerBuilder 12.5,
Oracle 10/11g, SQL Server 2008, PL/SQL, Crystal Reports, SQL Developer, TOAD, CRM, PVCS, Ervin data
modeler7.0 .

Senior Oracle Developer

Jardine Lloyd Thompson (JLT)
The Jardine Lloyd Thompson group of companies is a leading risk management adviser and insurance and
reinsurance broker. JLT is also a major provider of employee benefit administration services and
related consultancy advice. I worked as Oracle Developer to support and development of PCBFE model
runs on C# .Net, Oracle 9i, SQL Server 2005,SQL* plus, Crystal Reports, Toad/Erwin4.1, informatica,
Power enter 6.0,XML, Unix, PowerBuilder 12.5/Sybase ASE.

Consultant

Tata Consultancy Services Ltd
Worked at customer site providing consultancy and development skills on a wide range of projects.
Clients included:
* BNP Paribas (London): Application support and monitoring of automated processes (Oracle,
Java, JavaScript, UNIX shell scripts, XML, C++, and VB 6.0).
* HDFC Ltd: Developed several modules as part of a complex derivatives system used by the
dealing and risk teams (VB 6.0, SQL Server-T-SQL).
* TAT AIG: Analysed business requirements, developed and maintained a set of applications for
the Insurance business functions; policy under-writing, claims processing, re-insurance etc
(Oracle Forms & reports 6i, VB 6.0, Oracle 10g).
* The Stock Exchange (India): Team leader responsible for managing new business requirements,
application support and testing (C, C++, ORACLE 8i, Erwin, C and COBOL).

Software Engineer

K.Rajeja Real Estate Services

Software Engineer

Infinite Facility Pvt. Ltd.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in