Masters in Data Science
Monash University, Melbourne,
Pursuing Masters in Data Science at Monash University, Melbourne. Six years of extensive programming experience in Oracle PL/SQL to analyse, design and develop database applications using Oracle Relational Database Management System (RDBMS). One year of international exposure in the United Kingdom working directly with business users (Clients). Involved in all phases of the SDLC (Software Development Life Cycle). Expertise in data modeling, dynamic SQL, analytical functions, Oracle advanced collection data type and exception handling. Knowledge of key Oracle performance related features such as query optimizer, execution plan, partitioning. Also experienced in ETL techniques, analysis, and reporting. Aware of SSIS, Informatica, Python & UNIX. Excellent communication, interpersonal, analytic skills and strong ability to perform as part of a team. Oracle certified associate in PL/SQL programming. Microsoft certified in Data Warehousing with SQL Server.
Synopsis: Analyse the system with statistical data and look for improvements.
Synopsis: Relevant maintenance of the application and managing the team from United Kingdom (client location)
Achievements: Client & inter Vendor appreciations for dealing the issues and managing the client efficiently without any escalation. In order to reduce the client's effort on application monitoring, I have proposed a system that holistically provides an overview of all the applications currently in place and will send notification automatically to relevant stakeholders. This idea has been appreciated by the customer and is now being worked upon.
Synopsis: In order to embrace the advantage of the information technology and to improve the business model, ASDA (client) was all ready to digitize their existing logistics system under the brand name Store Connect. It allows ASDA to receive & manage parcels in store and dispatch it to the customers with minimum effort via a handheld mobile device. The performance of the application was set on top priority.
An application of this caliber is unprecedented in the UK retail industry.
Achievements: Developed a system using JAVA spring and PLSQL that replaced google API for locating ASDA stores in an area. This has reportedly generated huge profit for the client. ASDA has appreciated this effort and acknowledged it by an appreciation certificate. TCS provided 'On Spot' award for the dedication & commitment to the work.
Synopsis: International Sales and Stocks (ISS) was developed for Marks and Spencer's (client) which provides overall business insights on sales and stocks in areas like Merchandising, Food, Petroleum for countries outside the United Kingdom.
Achievements: Many team appreciations. Awarded by client (Marks & Spencer's) recognizing my efforts to automate the database testing using PLSQL
Synopsis: General Store Merchandising (GSM) deals with stock management for Co-Operative (client). It defines the stock value in the system segregated under two categories, which are 'Store' and 'Warehouse'. The location, arrangement of the stocks within the store are also managed through GSM. It is the upstream source to many other applications which forms the SMART system developed for better retail management.
Achievements: One of the few billed resource for the client. Published paper in TCS on ORACLE PL/SQL best practices.
Synopsis: Working with Co-operative (client), the business required to develop a system that could manage the sale of the products which are near to their expiry. Based on proper analysis, forecast and threshold calculation, discounts are generated on the 'near to expire' products thus promoting faster sales of those products.
Key Responsibilities :-
Achievements: Gained knowledge on tuning database codes through hands-on.
Synopsis: National Scholarship Program ( NSP ) was an initial learning project at Tata Consultancy Services (TCS).
Achievements: On successful completion of the project, it garnered quite a positive feedback from everyone.
Miss. Joyeeta Dey Das Mr. Arunava Biswas
Senior Project Analyst, System Analyst,
- Strategic Projects, Analytics, Suncorp Insurance, Sydney,
Common Wealth Bank, Sydney, 061 413 866 409
061 469 332 843
Mr. Lakhya Jyoti Dihingya
Information Technology Analyst,
Tata Consultancy Services ltd, India,
091 8900 402069