Prachi Mate

Prachi Mate

Informatica Developer

Followers of Prachi Mate2000 followers
location of Prachi MateGreater Seattle Area

Connect with Prachi Mate to Send Message

Connect

Connect with Prachi Mate to Send Message

Connect
  • Timeline

  • About me

    Business Intelligence Engineer IIl @ Amazon

  • Education

    • Sri. Ramdeobaba Kamla Nehru Engineering College, Katol Road

      2011 - 2014
      Master of Computer Applications (MCA) Computer Science A
    • Northeastern University

      2020 - 2021
      Master's in Analytics Data Analytics A+

      Course work:Data warehousing and SQLData Analysis techniques using Python and R ProgrammingData Visualization using Tableau, Power BI and R ShinyPredictive Analytics - Regression and Classification modelsRisk Management and Contingency planning

  • 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
  • Licenses & Certifications

    • Analyzing Business Data in SQL

      DataCamp
      May 2020
    • Business Intelligence Python and Programming Essentials

      Udemy
      Sept 2020
    • Reporting in SQL

      DataCamp
      May 2020
    • Exploratory Data Analysis in SQL

      DataCamp
      Mar 2020