Prachi Mate

Experience

• 

  Accenture in India

  Aug 2014 - May 2018

  Informatica Developer

  - Involved in the requirement gathering and design phase for building a new Data Warehouse for one of the leading Telecommunication companies in Singapore.- Developed an IFRS (International Financial Reporting Standards) module using Informatica transformations like Aggregator, Router, Java Transformation, Source Analyzer to create contracts for pre-pay and post-pay customers along with additional value-added services.- Developed a File Name and Format Validation shell script to verify file extension, size and naming format of fixed width and delimited text files to avoid failures while loading data into the database.- Created an intuitive User Interface using JavaScript/HTML and SQL stored procedures allowing business stakeholders to manipulate (CRUD Operations via interface) reference tables containing latest and historical revenue related information and this reduced 20 hours of man work each month. Show less

• 

  Cognizant

  Jul 2018 - Nov 2019

  ETL Developer

  - Implemented the Billing Engine component using Informatica transformations like Joiner, Update Strategy, HTTP Transformation, Connected and Unconnected Lookup to fetch real time data from the website and generate monthly invoices.- Developed Informatica mappings using User Defined Functions and Reusable Transformations for early data cleansing and validating, in order to identify potential data issues like duplicate records, incorrect date formats or special characters appearing in the record.- Implemented Slow Changing Dimension Type II and III logic using SQL scripts to maintain full and partial history of all records in the database.- Worked on code optimization using Push-Down optimization and Session Tuning method. This reduced the overall execution and data load time from 5 hours to 30 minutes. Show less

• 

  Northeastern University

  Aug 2020 - Jan 2021

  Community Ambassador
• 

  Costco Wholesale

  Jan 2021 - Apr 2021

  Data Analyst intern

  - Worked on writing complex SQL queries to fetch demographic information about members, geographic information to understand sales and purchase history.- Worked on ClickStream data using Adobe Analytics to find out Costco members online purchase behavior for electronic products - Designed and developed insightful graphs and reports using PowerBI reporting tool to give information about membership and sales performance insights, shopping trends, seasonality and refund ratio at Costco Warehouse across all cities in the United States Technology Used: Oracle SQL, Microsoft SQL Server, PowerBI, Informatica Cloud and Power Center Show less

• 

  Amazon

  Jan 2022 - now

  • Business Intelligence Engineer lll

    Jun 2024 - now

  • Business Intelligence Engineer II

    Jan 2022 - Jun 2024