Amesh Parit available

Amesh Parit

SQL/BI Developer, SQL Developer, C# (BI), SQL Developer (ETL)

available
Profileimage by Amesh Parit SQL/BI Developer, SQL Developer, C# (BI), SQL Developer (ETL) from London
  • MK42 London Freelancer in
  • Graduation: not provided
  • Hourly-/Daily rates: not provided
  • Languages: English (Limited professional)
  • Last update: 31.03.2021
KEYWORDS
PROFILE PICTURE
Profileimage by Amesh Parit SQL/BI Developer, SQL Developer, C# (BI), SQL Developer (ETL) from London
ATTACHMENTS
CV - Amesh Parit

You need an account to view this information.

SKILLS
Net C#, SQL server 2016/2017/2019, ETL, SSIS, SSRS, SSAS, T-SQL, developing complex database objects, large database 2Tb, SQL DBA activity, PowerShell Scripting, C#, Power scripting, Scripting, VBA Excel programming, VBScript, Test, C# Data Enginner, SQL DBA activity setup new Database server, SQL Agents jobs, Backup, UAT, DevOps, SQL, SQL Developer, Data warehouse, SQL server 2008, 2012 Database, SQL Server 2012, VBA, VB script, Windows XP, Database, JAVA, Spring, Hibernate, Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL server2008, XML, HP-UNIX, shell scripting, iReport, C#.Net, Frame work 4.5, ASP.Net, VB, PowerBuilder 12.5, Oracle, 11g, Crystal Reports, TOAD, CRM, PVCS, Ervin data modeler7.0, Oracle Developer, C# .Net, Oracle 9i, SQL Server 2005, SQL* plus, Toad/Erwin4.1, Unix, Sybase ASE, JavaScript, UNIX shell scripts, C++, VB 6.0, SQL Server-T-SQL, Oracle Forms, Oracle 10g, C, ORACLE 8i, Erwin, COBOL
PROJECT HISTORY
  • 05/2018 - 09/2020

    • Deloitte
  • Data Enginner
  • 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

    • Ernst & Young
  • SQL/BI Developer
  • 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

    • Unilever
  • SQL Developer, C# (BI)
  • 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

    • Next PLC
  • SQL Developer (ETL)
  • 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

    • Cargill PLC
  • SQL Developer
  • 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

    • Capita Employment Benefit
  • Database Developer
  • 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

    • Capita Children's Services
  • Senior Database Developer
  • 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

    • Jardine Lloyd Thompson (JLT)
  • Senior Oracle Developer
  • 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

    • Tata Consultancy Services Ltd
  • Consultant
  • 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

    • K.Rajeja Real Estate Services
  • Software Engineer

  • 01/1997 - 01/2000

    • Infinite Facility Pvt. Ltd.
  • Software Engineer

GET IN TOUCH

Message:

Sender: