Amesh Parit
Data Developer
Experience
Data Developer
Orbit Group
- 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.
- Worked on D365 integration project setup ELT process with model Marketing and Sales and Field Services.
- Wrote a data obfuscation process to manipulate the production database when it is copied to the TEST or development environment.
- Created and updated documentation.
Data Engineer
WTW
- Part of the Modern Data Warehouse development project for financial reporting of IFRS17.
- Developed star schema for reporting purposes.
- Created a data pipeline to pump data into reporting schema.
- Created a complex data flow to generate multiple reports and dashboards.
- Used Azure SQL Server 2019 for database creation.
- Developed Power BI dashboards.
- Performed data modeling and built tabular models.
- Created unit test cases.
- Used PowerShell scripts for automation.
- Migrated data from on-prem to Azure cloud environment.
- Produced technical documentation.
Performance Analyst
BP Performance Analytics
- Migrated treasury management data from Oracle server to SQL cloud-based environment.
- Created table structures on Azure SQL Server and Azure Synapse.
- Developed data pipelines to transfer data from Oracle and SQL Server to the cloud environment.
- Developed dashboards and data request reports in Power BI.
- Migrated 4.5 terabytes of data to Azure.
Data Engineer (Contractor)
Deloitte
- Customized Infosys IFRS 16 application according to customer requirements.
- Wrote procedures, functions, and table designs based on change requests.
- Involved in SQL DBA activities including setting up new database servers, SQL agent jobs, and backups/restores.
- Improved performance through techniques like column store optimization, parameter sniffing, table partitioning, and indexing.
- Worked on batch processes, ETL (SSIS/SSAS), and T-SQL.
- Assisted in completing UATs and production rollouts.
- Participated in DevOps practices.
- Provided ongoing support for data and ETL solutions.
SQL/BI Developer (Contractor)
Ernst & Young
- Developed Canvas-Financial Audit Tool, which is used globally for financial audits.
- Used in the Assurance service line under Audit subservice line.
- Helped auditors generate financial audits.
- Contributed to creating tools that reflect the financial status of audited companies.
SQL Developer (Contractor)
Unilever
- Worked on the data warehouse for SCDG.
- Developed a global demand analysis and forecast product.
- Supported buyers and supply planners in managing inventory.
- Maintained and reported KPIs like forecast accuracy, bias, and MAPE.
SQL Developer (Contractor)
Next PLC
- Developed an in-store web-based application to manage assets, store information, orders, payments, and tracking.
- Maintained and processed asset data daily for various tasks.
- Application designed using .Net C#, SSIS, SSRS, and SQL Server 2008/2012.
PL/SQL Oracle Developer (Contractor)
Cargill PLC
- Supported HRIT, a multi-platform human resource module.
- Maintained employee data for over 140,000 workers.
- Worked on technologies like Java, Oracle 10g, PL/SQL, SQL*Loader, RESTful API, VB Script, and Windows XP.
Oracle Database Developer (Contractor)
Capita Employment Benefit
- Worked on Orbit, a web-based employee benefits portal.
- Used by over 200 companies and more than 218,000 employees.
- Application developed using Java Spring/Hibernate, Oracle 10g/11g, PL/SQL, SQL*Loader, SQL Server 2008, XML, HP-UNIX shell scripting, and iReport.
Senior Database Developer
Capita Children's Services
- Worked on solutions like SIMS, One, and eSuite for Local Authorities and schools in England and Wales.
- Technologies used include C#.Net, Framework 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, and Ervin Data Modeler 7.0.
Senior Oracle Developer
Jardine Lloyd Thompson
- Supported and developed PCBFE models.
- Technologies used include C#.Net, Oracle 9i, SQL Server 2005, SQL*Plus, Crystal Reports, Informatica, XML, Unix, and PowerBuilder 12.5/Sybase ASE.
Consultant
Tata Consultancy Services Ltd
Provided consultancy and development skills for clients including BNP Paribas, HDFC Ltd, TATA AIG, and The Stock Exchange (India).
BNP Paribas: Application support and monitoring of automated processes (Oracle, Java, JavaScript, UNIX shell scripts, XML, C++, and VB 6.0).
HDFC Ltd: Developed several modules for a derivatives system used by dealing and risk teams (VB 6.0, SQL Server-T-SQL).
TATA AIG: Analysed business requirements, developed, and maintained applications for policy underwriting, claims processing, and re-insurance (Oracle Forms & Reports 6i, VB 6.0, Oracle 10g).
The Stock Exchange (India): Managed 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.
- Master of Computer Management (passed with distinction), India.
- BSc. in Computer Science (1st class), India.
- .Net C# Course & Data Warehousing course.
- Microsoft Power BI.
- Data Science with Python.
- Java Development course.
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 Dashboard 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
Unknown
BSc in computer science · Computer science · India · 1st class
Unknown
Master of computer management · Computer management · India · passed with distinction
Similar Freelancers
Discover other experts with similar qualifications and experience