Pratik Vijay Chavan

• Worked as a PHP developer. Involved in developing interactive web applications using a PHP developed/design the application using WAMP architecture. • Defined and developed the applications presentation layer using html5, css3, javascript, jquery and used bootstrap for designing web pages to get responsive designs. Tracked and fixed bugs that were found during various phases of developments. • Back-end design database structures for websites using MySQL as well as testing their compatibility with different web browsers and newer software or OS versions. • Interact with client to gather requirement. Analyze requirement and develop functionality accordingly. • Supporting existing applications, developing new features for existing applications, and developing new web-based applications.

Worked with Demurrage and detention department for europe agency (Belgium, Germany, Netherland) • Understanding the exracted data set for analysis and correction of Voyage, Vessel information, days of detention and demmurage on port. • Collecting and verifying data parameters from various CMA CGM applications. • Extracted, cleaned, validated and modeled the data with the purpose of understanding and making conclusions from the large amount of data for better decision-making. • Utilized excel functionality such as vlookup, Hlookup, Macros, Pivot tables etc.. to perform complex data operations. • Developed tools and queries for analyzing and summarizing failure data points • Scheduling SQL job and writing queries to improve the performance. • Suggesting Analysis and process enhancements basis identified patterns and trends • Took initiative in building Automation project as how process should be automated and minimize the user input. • Analyze, trace and handling customer data and coordinate with agency disputes. • Performed reporting and other analytical needs on cmacgm.com's new ecom dashboard by writing simple SQL queries/pre-defined queries to extract all the data related to Web payments & Stripe payments.

• Worked for US input backend process Collaborated with cross-functional teams to define business requirements and translate them into data-driven solutions. • Design, develop, and maintain ETL processes to extract, transform, and load data from various sources. • Part of the Testing team of new website done (UAT Testing, Non functional testing as Performance testing, Usability and compatibility testing. • Design and create visually compelling and interactive dashboards, reports, and data visualizations using Power BI to support decision-making processes. • Ensure data accuracy, consistency, and integrity by implementing data quality checks and monitoring processes. • Assist in troubleshooting and resolving data-related issues in a timely manner. • Continuously learn and stay current on emerging tools, techniques, and best practices to improve data products and processes. • Audit the manifested bills of lading and check the same whether the bills of lading meets the customer requirements or country exceptions.