Shreya Dey

Client - Manulife Insurance

Project - IFRS17 Valuation Systems Transformation

• Collaborated with stakeholders and client leads to define project objectives and criteria.
• Performed gap analysis to identify areas of improvement.
• Coordinated with offshore team of developers to translate requirements and project scope as per demands of business.
• Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
• Executed analysis of risks and identified risk mitigation strategies.
• Wrote and optimized in-application SQL statements along with coordinating deployments of new feature updates and fixes using IICS.
• Created proofs of concept for innovative new solutions using IICS.
• Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
• Supervised work of programmers, designers and assigned tasks and monitored performance against deliverables.

Client - British American Tobacco

Project - Global Demand Forecasting

• Involved in development of ETL jobs for loading data from Snowflake Systems, flat files and Excel files from multiple Azure Blob Storage to MS SQL Server and files generated to be pushed to Kinaxis for purpose of Demand and Forecasting.
• Developed Talend jobs single handedly for one of themajor complex markets without any single defect or bug.
• Used transformation of Talend, routines along with components of Talend.
• Participated in daily status meetings with client to discuss various scenarios compatible with heterogeneous sources besides handling DevOps queries, issues and defects for 6 markets from Data Integration perspective, single-handedly.
• Contributed to shaping Global Demand Forecasting especially in setting up BAU Service model.
• Organized Knowledge Transfer sessions and responsible for training and grooming junior resources in project.

Client - Vodafone India

Project - DXL DDS ETL

• Involved in development of ETL jobs for loading data from Oracle DB to MongoDb.
• Developed Talend mappings and fine tuned them for better performance.
• Worked in an atmosphere of Oracle and MongoDb data.
• Used transformation of Talend, routines along with the components of Talend.
• Participated in daily status meetings with client and onsite developers to discuss various scenarios compatible with the heterogeneous sources.
• Monitored and performed deployment of jobs to Azure cloud with the help of Kubectl.

Client - Petronas

Project - MPM Digital Transformation

• Involved in development of ETL jobs for loading data from flat files to PostgreSQL.
• Developed Talend mappings and fine tuned them for better performance.
• Used transformation of Talend, java codes and other reusable Joblets along with components of Talend and PostgreSQL.
• Participated in daily status meetings with client and onsite developers to discuss various scenarios compatible with heterogeneous sources.

Client - GE Oil & Gas

Project - Smart QMI

• Involved in development of ETL jobs for automating the process of running queries on a day today basis in the Oracle DB side so that less of manual intervention is required.
• Developed Talend mappings and fine tuned them for better performance.
• Worked in an atmosphere of Oracle data.
• Used transformation of Talend, Java codes and other reusable Joblets along with the components of Talend.
• Participated in daily status meetings with client and onsite developers to discuss various scenarios compatible with the heterogeneous sources.
• Produced robust, accurate code that minimized production issues.

Client - GE Oil & Gas

Project - DOMO Migration

• Involved in development of ETL jobs based on Project Tracking Softwares and Web Services.
• Developed Talend mappings and fine tuned them for better performance.
• Worked in an atmosphere of API data and Web Services.
• Used transformation of Talend including setting up of proxy connections along with REST client services, java codes and other reusable Joblets along with the components of Talend.
• Participated in daily status meetings with client and onsite developers to discuss various scenarios compatible with the heterogeneous sources.

Client - GE Oil & Gas

Project - QMI OFE Sourcing

• Involved in development of ETL jobs based on the requirements provided by onshore leads.
• Developed Talend mappings and tuned them for better performance.
• Worked in a mixed atmosphere of Flat Files and Databases.
• Used transformation of Talend including lookup, aggregation, java codes and other reusable Joblets along with the components of Talend.
• Worked on various issues on existing Talend mappings to produce correct output.
• Developed and fine tuned the queries of GreenPlum to check for deflation or inflation.
• Participated in daily status meetings with client and onsite developers to discuss various scenarios compatible with the heterogeneous sources.

Client : Elements ANZ

Project: Cassandra Fleet

• Involved in development of ETL jobs based on the requirements provided for the Australia & New Zealand region.
• Developed Talend mappings and tuned them for better performance.
• Worked in a mixed atmosphere of Flat Files and Databases.
• Used transformation of Talend including lookup, aggregation along with the components of Talend.
• Worked on various issues on existing Talend mappings to produce correct output.
• Participated in daily status meetings with client and onsite developers to discuss various scenarios compatible with the heterogeneous sources.

Client : Elements

Project: EVMS REPORT MIGRATION

• Involved in development of ETL jobs, testing the data and reporting.
• Developed Talend mappings and tuned them for better performance.
• Used transformation of Talend including lookup, Update Strategy, Joins along with different mailing components of Talend.
• Worked on various issues on existing Talend mappings to produce correct output.
• Worked on reports for defect analysis and report generation.
• Participated in daily status meetings with client and onsite developers.