Priyabrata S. Email & Phone Number

Dublin, County Dublin, Ireland

Kolkata, West Bengal, India

• Role: Data Engineer, Client: World’s largest Restaurant chain, BU of Clients: Hospitality, Project Duration: 2+ years • Interacted with clients to understand business demands & brainstorm solutions and implementations.• Identified data discrepancies and data quality issues to ensure data consistency and integration.• Formulated and documented the physical ETL process design based on business requirements and system specification, including source to target mappings, transformations, lookups, aggregations, and expressions.• Designed multiple SSIS packages to extract data from client's multiple OLTP databases to the destination database, including error reporting and exception handling.• Developed and scheduled various reports in Reporting server for the business to easily reconcile transactional data utilizing Reporting Services (SSRS).• Developed a sales forecasting model for each product using the best time series forecasting Machine learning model, Auto-Regressive Integrated Moving Average.

• Role: Data Transformation and Interface Developer, Client: Melbourne’s one of the fortune 500 companies, BU of Clients: Utility, Project Duration: 4+ years • Analysed multiple raw data files in JSON, XML, and Excel from the client’s previous system and cleaned the data using python pandas framework before loading data into Oracle Database.• Developed PL/SQL packages and stored procedures to consume/publish SOAP and REST Web Services (XML/JSON) to interpret both data formats utilizing APEX Web Services.• Co-led a 15-person technical team to replace the client's prior application FOCUS3 with Oracle EBS by developing more than 30 inbound and outbound interfaces, resulting in a 4.5 percent increase in revenue.• Created a tableau dashboard and various XML publisher reports to measure key performance indicators (KPIs), visualize user behavior, and assess the economic impact on clients.• Trained in PL/SQL and SQL query optimization, oracle forms, and reports.• Was part of a team that upgraded the Oracle EBS application from 12.1.3 to 12.2.4, which had a significant influence on the system's user interface. So, too, did the necessary OAF adjustments to fulfill business needs.

Master'S Degree, Data Analytics, 1.1

Modules: Data Science with Python, Statistics, Data Storage, Information Visualizations, Machine Learning, Data Mining, Applied Research.

Bachelor'S Degree, Electrical Engineering Technologies

Science