Profilbild von Amesh Parit Data Engineer , SQL Server 2019 ,Azure synapse Analytics, ADF, SSIS, SSAS, Power BI, Python, aus Bedford

Amesh Parit

verfügbar

Letztes Update: 06.09.2022

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

Firma: A&P It Developers Ltd
Abschluss: nicht angegeben
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: englisch (gut)

Dateianlagen

AMESH PARIT SQL 2020 (de).docx

Skills

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.

Projekthistorie

03/2021 - bis jetzt
Data Engineer
WTW (Versicherungen, >10.000 Mitarbeiter)

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

01/2021 - 04/2021
Data Engineer (Data Migrations/ETL)
BP (Banken und Finanzdienstleistungen, 50-250 Mitarbeiter)

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

05/2018 - 09/2020
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.

07/2017 - 04/2018
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.

01/2016 - 06/2017
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.

04/2015 - 12/2015
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.

09/2014 - 03/2015
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.

01/2013 - 07/2014
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.

06/2008 - 12/2012
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 .

05/2006 - 04/2008
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.

03/2001 - 02/2006
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).

01/2000 - 12/2001
Software Engineer
K.Rajeja Real Estate Services


01/1997 - 01/2000
Software Engineer
Infinite Facility Pvt. Ltd.


Reisebereitschaft

Verfügbar in den Ländern Großbritannien
Profilbild von Amesh Parit Data Engineer , SQL Server 2019 ,Azure synapse Analytics, ADF, SSIS, SSAS, Power BI, Python, aus Bedford Data Engineer , SQL Server 2019 ,Azure synapse Analytics, ADF, SSIS, SSAS, Power BI, Python,
Registrieren