Pitney Bowes Inc. | Data Business Analyst - Final Mile (June 2023 - Present)

Remote, US

Technologies: Snowflake Cloud on Azure, SQL, Excel, Tableau

• Analyzed and developed query model to calculate misshipped delivery parcels to automate the task by saving 50% time and YOY misload performance savings of $755k roughly.

• Performed an in-depth analysis and devised calculation matrices along with seasonal factors to predict the volume of network facilities for year 2023 with 83% accuracy.

• Researched and developed a query model to accurately calculate the loss on return of parcels, enhancing the savings of loss prevention team by $193k.

Tata Consultancy Services | Data Engineer (Jul 2021 – June 2022)

Indore, India

Technologies: Talend Open Studio, SQL, Oracle SQL Developer, SSMS, WinSCP, Putty

• Job Control Framework implementation

  • Implemented JCF changes in 200+ full and incremental refresh jobs by analyzing their data architecture and increased performance by 30% and annual cost reduction of $700,000.

  • Conducted knowledge transfer session to the JCF team, which improved 40% efficiency of the team.

    • Executed queries and procedures for data validation using test cases in target and staging tables, reducing manual efforts by 15%.

    • Deployed 200+ jobs in the production server.

• Analyzed and built client requirement solutions on ad-hoc queries biweekly, resulting in a 20% improved efficiency.

• Designed and tested data architecture by integrating two data streams generating more than 2 million records daily, which reduced time complexity by 30%.