Amesh P.
Data Developer
Experience
Data Developer
Orbit Group
Worked on a migration project to move databases from on-prem to Azure Cloud, shifting warehouse data and other databases to Azure to decommission the old server.
Identified dependencies, links and servers.
Updated all objects with link dependencies, such as stored procedures, views, SSRS and SSIS packages, to point to the new linked server.
Created a new repository and deployment process.
Created and configured development, test, and production environments.
Created and executed test plans to confirm that the setup works as expected.
Migrated data using SSIS packages or lift-and-move methods and validated results.
Worked on D365 integration project, setting up ELT processes with Marketing and Sales and Field Services modules.
Wrote a data obfuscation process to manipulate the production database when copied to test or development environments.
Created and updated documentation.
Data Engineer
WTW
Part of the modern data warehouse development project for financial reporting of IFRS 17 disclosures and broader management reporting (KPIs) with Power BI dashboard.
Developed star schema for reporting purposes.
Created a data pipeline to pump data into the reporting schema.
Created a complex data flow to generate multiple reports and dashboards.
Managed Azure SQL Server 2019.
Developed Power BI dashboards.
Performed data modelling and created tabular models.
Wrote unit test cases.
Developed PowerShell scripts.
Migrated from on-prem to Azure cloud.
Produced technical documentation.
Performance Analyst
BP Performance Analytics
Migrated treasury management data from Oracle 10g to Azure SQL 2019 cloud 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.
Developed dashboards and data request reports in Power BI.
Executed a 4.5 TB data migration to Azure.
Data Engineer
Deloitte
Customized the Infosys IFRS 16 application according to customer requirements.
Wrote procedures, functions and designed tables based on change requests.
Performed SQL DBA activities: set up new database servers, SQL Agent jobs, backup and restore.
Tuned performance using columnstore, parameter sniffing, table partitioning and indexing.
Worked on batch processes and ETL using SSIS, SSAS and T-SQL.
Supported UAT and production rollout.
Contributed to DevOps practices.
Provided ongoing support and problem resolution of data and ETL solutions.
SQL/BI Developer
Ernst & Young
Developed the Canvas financial audit tool used by global auditors in the Assurance service line under the Audit sub service line.
Implemented features to reflect the financial status of audited companies.
SQL Developer, C# (BI)
Unilever
Developed a data warehouse for SCDG global demand analysis and forecasting of products including the company's fastest growing categories.
Enabled buyers and supply planners to manage inventory.
Maintained and reported forecast KPIs such as forecast accuracy, bias and MAPE.
SQL Developer (ETL)
Next PLC
Developed the In Store web-based application for asset management, store information, order management, payment processing and tracking.
Designed and implemented processes in .NET C#, SSIS, SSRS and SQL Server 2008/2012 to maintain and process large volumes of asset data daily.
PL/SQL Oracle Developer
Cargill PLC
Developed the HRIT multi-platform human resource module maintaining data for over 140,000 employees.
Worked with Java, Oracle 10g, PL/SQL, SQL*Loader, RESTful API, VBScript on Windows XP.
Oracle Database Developer
Capita Employment Benefit
Developed and maintained Orbit, a web-based employee benefits portal used by over 200 companies and 218,000 employees.
Worked with Java Spring/Hibernate, Oracle 10g/11g, PL/SQL, SQLLoader, SQL Server 2008, SQLPlus, ETL, SSIS, XML, HP-UNIX shell scripting and iReport.
Senior Database Developer
Capita Children’s Services
Supplied business process outsourcing solutions (SIMS, One, eSuite) to local authorities and schools.
Developed in C#.NET, .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 Erwin Data Modeler 7.0.
Senior Oracle Developer
Jardine Lloyd Thompson
Supported and developed PCBFE model runs for risk management and employee benefit administration services.
Worked with C#.NET, Oracle 9i, SQL Server 2005, SQL*Plus, Crystal Reports, Toad/Erwin 4.1, Informatica, XML, Unix and PowerBuilder 12.5/Sybase ASE.
Consultant
Tata Consultancy Services Ltd
Provided consultancy and development skills at customer sites on various projects.
BNP Paribas: Application support and monitoring of automated processes using Oracle, Java, JavaScript, UNIX shell scripts, XML, C++ and VB 6.0.
HDFC Ltd: Developed modules for a complex derivatives system using VB 6.0 and SQL Server T-SQL.
TATA AIG: Analyzed requirements and maintained applications for policy underwriting, claims processing and reinsurance using Oracle Forms & Reports 6i, VB 6.0 and Oracle 10g.
The Stock Exchange (India): Led a team for new business requirements, application support and testing using C, C++, Oracle 8i, Erwin 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 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.
Skills
- 10+ Years’ Experience As Database Developer On .Net C#, Sql Server 2016/2017/2019, Etl, Ssis, Ssas, T–sql And Complex Sqls.
- Strong Experience Of Developing Complex Database Objects Like Stored Procedures, Functions, Packages And Triggers Using T-sql.
- Worked On Developing Database Design, Tabular Models, Star Schema And Data Warehouse Using Server Analysis Services.
- Experience On Modern Data Warehouse, Azure Synapse, Databricks, Data Lakes.
- Worked On Large Database 4tb On Performance Tuning Working With Column Store, Parameter Sniffing, Table Partition Indexing Etc.
- Power Bi Dashboard, Dax, Python, R, Power Automate And Advanced Excel Reporting.
- Python For Data Processing.
- D365 Integration With Module Market And Sales And Field Services.
- Comfortable With Event-based Architectures And Streaming To Process Data In Real Time.
- Involved In All Phases Of The Sdlc (Software Development Life Cycle) From Analysis, Design, Development, Testing, Implementation And Maintenance With Timely Delivery Against Aggressive Deadlines.
- Excellent Communication, Interpersonal, Analytical Skills And Strong Ability To Perform As Part Of A Team.
- Successful Delivery Of High-quality Solutions Within The It Services, Banking, Employment Benefits, Insurance And Public Sectors.
Languages
Education
BSc. in Computer Science (1st class) · Computer Science · India
Master of Computer Management (passed with distinction) · Computer Management · India
Similar Freelancers
Discover other experts with similar qualifications and experience
Senior MLOps, DevOps Engineer
SSIS Development
Senior Software Developer
Senior Data Architect & Data Engineer
Microsoft Azure Senior Data Engineer / Senior Data Scientist
Sabbatical, professional development
Technical Consultant, AWS Infrastructure
Architect & Technical Team Lead & Senior Developer
External IT Consultant BI and DWH
Data Management Solution Architect
Data Solution Architect, Founder
Microsoft Azure Synapse and Power BI Developer
Data Consultant & Technical Lead DataVerse
Consultant for data-driven AI solutions
SAP Business Intelligence Solution Architect / Team Lead Core Program
Senior Data Engineer
BI Developer
BI consultant
ServiceNow Consultant
Requirements Engineer
Data Architect
Data Engineer
Document parser for picking lists (PDF & PNG)
Integration Architect
Power BI Expert
incl. CI/CD, automation
Senior Data Engineer
Data Warehouse Architect and Lead Data Modeler
Business Analyst, Data Warehouse Developer
