Work Experience of Piu Mallick

8 years of experience as a Data Engineer, 4 years as a team lead.
Experienced in writing various technical blogs on Medium related to Data Science.
Experienced in Banking & Financial Services and Healthcare domains with clients such as Wells Fargo Advisors, Societe Generale and Healthways (Tivity Health).
Gathered business and functional requirements – Translate them into robust, scalable operations.
Experienced in working in a distributed team spread around the globe.
Profocient in Agile methodologies and classic Waterfall/Iterative models.

Role: Graduate Teaching Assistant

Place: Pittsburgh, PA, USA

Duration: August 2020 - Present

Responsibilities:

Designation: Technology Consultant - II

Role: Data Engineer

Place: Bangalore, KA, India

Duration: August 2014 - July 2015

Clients :Tivity Health (Healthways)

Responsibilities:

Worked in the Heathcare system that tracked medicine intake and lifestyle choices of diabetic patients and generated reports based on predictive analysis to guide patients regarding healthy lifestyle choices.
Involved in development, enhancement and bug-fixing and code changes as per end-user/client’s requests.
Resolved recurring incidents permanently, performed break fixes and implemented preventative action items.
Monitored data-load activities and recovered failures in Dev, Quality system as a part of unit testing.
Reviewed and developed codes as well as design documents.

Designation: Associate - Projects

Role: Data Engineer / Database Developer

Place: Bangalore, KA, India

Duration: Decembe 2007 - August 2014

Clients :Wells Fargo Advisors, Societe Generale

Responsibilities:

Enhanced, maintained and supported time-tracking application using Oracle database and Unix job scheduling process, lead a project to enhance and improve project documentation and supervised automation processes to remove obsolete jobs and archive expired data.
Created new processes for improved and cohesive reporting, managed collaboration with DBAs to resolve challenges with database schema and the separation of DEV and QA environments and resolved critical production issues; mentored fellow team members..
Enhanced, maintained and supported time-tracking application using Oracle database and Unix job scheduling process, lead a project to enhance and improve project documentation and supervised automation processes to remove obsolete jobs and archive expired data.
Created new processes for improved and cohesive reporting, managed collaboration with DBAs to resolve challenges with database schema and the separation of DEV and QA environments and resolved critical production issues; mentored fellow team members.
Worked in ETL, Analytical Reporting & Metrics generation, Data Governance, Performance Tuning and Disaster Recovery of data.

Professional Achievements

Improved performance in ETL batch jobs to achieve 20% reduction in execution time.
Led the initiative for 100% documentation of a 12-year-old legacy conglomerate system consisting of Human Resources, Financial and Enterprise Performance Management System for easier knowledge transfer.
Reduced the batch job execution time by 30% (by automating the archival of old data through ETL process). The job constituted uploading the information of the new onboarding members and updating the same for the existing members of the organization.