Jan 2025 – Apr 2025 · 3 mos · United States · Remote

• Supporting data-driven decision-making at GreenLancer by providing robust data analysis, ensuring data integrity, and delivering actionable insights through the following tasks:
• Employed MySQL advanced queries to extract, transform, and analyze data from multiple databases while ensuring accuracy, efficiency, and security.
• Conducted data quality assessments and troubleshoot issues to prepare data for stakeholder analysis.
• Collaborated with the team to utilize appropriate tools and methods, ensuring data integrity of existing Power BI dashboards, and performance within the defined technology stack.

Jul 2024 – Oct 2024 · 3 mos · Boston, Massachusetts, United States · Remote

• An eight-week sustainability consulting accelerator covering end-to-end Net Zero strategy to decarbonization. The course covers courses & practical labs on Net Zero Target Setting, Materiality Assessments, GHG Accounting (Scope 1, 2 & 3 & Life Cycle Assessment), Reporting & Disclosure Frameworks, Net Zero Transition Planning as well as hosting expert industry speakers on the topics. Throughout the course we also cover SBTi, CDP, GHG Protocol, ISO14000s Standards, IFRS S1 & S2, SASB, GRI, TCFD, TNFD, CSRD, among other leading sustainability standards & frameworks.

Jan 2023 – Jul 2024 · 1 yr 6 mos · Boston, Massachusetts, United States · On-site

• Experiential Learning-XN project As a part of XN project my team worked on analyzing the data given by sponsors to measure the impact of various activities which helped high school students in developing clarity and decision-making capabilities. We performed text analysis on a list of questions answered by students through a survey. Tableau was used to showcase the trends or outcomes for this project.

Oct 2021 – Nov 2022 · 1 yr 1 mo · Gurugram, Haryana, India

• Designed and executed advanced Business Intelligence (BI) and Data Warehouse (DW) solutions tailored to meet the needs of high-profile clients such as Uber Technologies and Meta.
• Partnered closely with the Uber Tax technology team to oversee the full spectrum of indirect tax processes, enhancing accuracy and efficiency.
• Utilized specialized SQL scripts to identify and rectify missing invoices, ensuring meticulous compliance with reporting standards.
• Employed Looker Studio as the primary tool for generating detailed reports that informed strategic decision-making processes.
• Created dynamic and interactive dashboards using Tableau, boosting the accessibility and interpretability of complex data sets.
• Enhanced overall data visualization capabilities, improving client organization decision-making processes.

Aug 2019 – Oct 2021 · 2 yrs 2 mos · Greater Delhi Area · Hybrid

• Spearheaded a strategic data migration initiative using Apache Sqoop, enhancing smart meter tracking efficiency by 40%.
• Designed and implemented a predictive analytics model for payment defaulters, increasing revenue by $900K and cutting costs by 10%.
• Crafted detailed monthly usage reports for over 10,000 smart meters using Tableau, delivering critical insights into consumption patterns.
• Streamlined data analysis processes, boosting operational efficiency and enhancing decision-making capabilities.

May 2018 – Jul 2019 · 1 yr 2 mos · Gurugram, Haryana, India

• Engineered and set up structured data repositories in Hive, significantly enhancing data organization and accessibility for advanced reporting.
• Streamlined data storage designs, focusing on efficient data organization, facilitating quicker and more reliable data retrieval for analytical purposes.
• Implemented Change Data Capture (CDC) methodology to efficiently track and capture data modifications, reducing data latency by 75%.
• Boosted the efficiency of real-time analytics by optimizing data processing workflows, ensuring timely data availability and decision-making.

Sep 2014 – Aug 2017 · 2 yrs 11 mos · Greater Kolkata Area

• Previously associated with Tata Consultancy Services, Bangalore and having experience in Hadoop applications development, enhancement and maintenance activities. Worked as a system engineer and done project related activities like requirement analysis, documentation, application development, testing, production support, client interaction etc.
• Total Experience:
• 3 years of experience in hadoop applications development, enhancement, and maintenance.
• Exposure:
• Product enhancement and maintenance under Windows and UNIX based environments.
• Core Java
• Hadoop(HDFS,MapReduce,Hive,Pig,Sqoop)
• SQL
• Teradata
• Dmxpress(ETL tool)
• Strengths:
• Strong problem solving skills with ability to analyze and understand data.
• Strong oral and written communication skills.
• Effective in working independently and collaborative in teams.
• Resource management to maintain flawless day to day delivery.
• Conducted KTs and mentored junior and new resources.
• Ability to grap new technologies quickly and efficiently.
• Responsibilities :
• Project work involved working within the IT team of clients and developing modules based on the requirement provided by business users.
• Interacting directly to the business users to gather requirement and report progress.
• Providing KT of project to Production Management team.
• Support the system testing and defect fixing.
• Reporting via regular client calls and team meeting to brief about projects progress and proactively suggest process changes to enhance efficiency.
• Working independently and in collaboration with release management team in order to ensure a successful and smooth release.
• Develop shell script and HQL scripts.
• Design and create HIVE data structures.
• Optimize the Batch jobs.