Amesh Parit
Data Developer
Experience
Data Developer
Orbit Group
Worked on a migration project to move databases from on-prem to Azure Cloud. Involved in shifting warehouse data and databases to Azure to decommission the old server.
- Identification of dependencies, links and servers
- Update all objects that are link dependencies, such as storage procedures, views, SSRS and SSIS packages, to point to the new link server
- Create a new repository and deployment process
- Create a new environment, a development environment, a test environment, and a new production environment
- Create and execute test plans to confirm that the setup works as expected
- Migrate data using the SSIS package or lift and move data and validate
- Also worked on D365 integration project setup ELT process with model Marketing And Sales and field Services
- Write a data obfuscation process to manipulate the production database when it is copied to the TEST or development environment
- Create/update documentation
Data Engineer
WTW
Part of the Modern Data Warehouse development project for financial reporting of IFRS17 and creating IFRS 17 disclosures and 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
- Power BI Dashboard
- Data Modelling and tabular model
- Unit Test Case
- PowerShell script
- Migration from on prem to Azure cloud
- Technical Documentations
BP Performance Analytics
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
- 4.5 terabyte Data migration to Azure
Data Engineer
Deloitte
Infosys IFRS 16 application.
- 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
- Worked Batch process and ETL (SSIS/SSAS) and T-SQL
- Helping to complete the UAT and production rollout
- DevOps
- Participates in the ongoing support and problem resolution of Data and ETL Solutions
SQL/BI Developer
Ernst & Young
Canvas-Financial Audit Tool: 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 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
Next PLC
In store, a Web-based application performs Asset management, Store information, order management, payment process and tracking. Maintains tons of assets data and process them daily with various task. Designed in .Net C#, SSIS, SSRS and SQL server 2008, 2012 Database.
PL/SQL Oracle 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 Java, Oracle 10g, PL/SQL, SQL*LOADER, RESTful API, VB script and Windows XP.
Oracle 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
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. 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, XML, Unix, PowerBuilder 12.5/Sybase ASE.
Consultant
Tata Consultancy Services Ltd
Worked at customer site providing consultancy and development skills on various projects:
- 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 applications for 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
Summary
I am a data engineer with over 10+ years of developer experience in SQL server 2016/2017/2019, ETL, SSIS,SSAS, T–SQL , Azure synapse Analytics, ADF, Advance SQLs, Storage account and Dash Board using Power BI, also D365 integration with model Marketing And Sales and field Services). Throughout my past roles working on several 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
Education
Master of Computer Management · Computer Management · India · Distinction
BSc. in Computer Science · Computer Science · India · 1st class
Similar Freelancers
Discover other experts with similar qualifications and experience