Prachi Mate Email & Phone Number

Seattle, Washington, United States

Greater Seattle Area

Issaquah, Washington, United States

- 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

Greater Seattle Area

Pune, Maharashtra, India

- 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.

Pune Area, India

- 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.

Master'S In Analytics, Data Analytics, A+

Course work: Data warehousing and SQL Data Analysis techniques using Python and R Programming Data Visualization using Tableau, Power BI.

Master Of Computer Applications (Mca), Computer Science, A