Pooja Shelke

Project Overview: This program is a response to the IT Asset Management examination (ITAM) performed by the Federal Reserve Bank of New York. Include delivering a detective control to detect, remediate, and monitor the usage of unauthorised software deployed across the system.

• Collaborated with different teams and stakeholders to identify data sources and gather data from identified sources based on project scope and requirements.
• Creating data profiles and conducting basic data quality assessments to ensure the accuracy and integrity of data.
• Mapping of server data from the source with registered software data.
• Defining the transformation rules for source data.
• Exploratory , statistical data analysis and reports building to help in data-driven decision-making.
• Preparing the weekly report of software remediation progress and remediation trends to show progress to higher management and MD-level stakeholders.

Project Overview : The project involves the migration of jobs from on-premises (IPC) to the cloud (IICS), which were loading base tables of Salesforce for different BPGs or different BPGs.

• Understanding the existing job logic, dependency, and complexity from on-prem (IPC), editing the mappings, mapping tasks in IICS imported from IPC, and creating task flows in IICS.
• Writing test cases and performing unit testing in the DEV environment, peer review of the code, and QA in higher environments (STG).
• Maintaining important project-related documents, such as job details tracking for jobs in scope, UT documents, and QA documents.

Project Overview: VMO2 is one of the largest entertainment and telecommunications operators in the UK.

• The project aims to identify and analyze data quality issues in existing O2 data coming from source systems before migrating it to the new system.
• Created simple and complex SQL code to perform data checks on customers' personal information-related fields.
• Implemented some business rules to validate the service provided to the customer, and its duration, using SQL.
• Created SQL code to compare data between two different systems to complete the analysis for identifying the most accurate data.
• Created data profiles, built rules for data quality, and extracted the customer records where the data is not in accordance with the rules using Ataccama.
• VMO2 is one of the largest entertainment and telecommunications operators in the UK.

Short term project to support parallel run during environment migration.

• Supported parallel batch runs for production environment and data migration activities in hive.
• Monitoring whether files getting ingested as per BAU and manually ingesting missing files.
• Analyzed and troubleshot the discrepancies between data in environments after batch completion.

Project Overview: Government project in the healthcare domain.

• The project is aimed at identifying expired, overlapped, and incorrect medical policy benefits being provided to the citizens of the state.
• Understanding critical business requirements, and providing solutions.
• Creating ETL transformations and jobs using Pentaho Kettle Spoon Designer and Pentaho Data Integration.
• Writing complex SQL queries for Type 1 and Type 2 tables.
• Government project in the healthcare domain.

Project Overview: Westpac is the oldest and one of the four major banking organizations in Australia, and one of the largest banks in New Zealand.

• The project aimed at building one central data warehouse, which will provide a 360 view of customer information by bringing data from different source systems, transforming it into one uniform format, and loading it to the data warehouse.
• ETL developing: Creating mappings and transformations using Informatica PowerCenter.
• Designed a mapplet and reusable transformations according to the business needs.
• Writing SQL queries for test data set-up and data mock-up.
• Performance tuning is performed at the mapping level and the database level to increase data throughput.
• Code deployments to higher environments designed and worked on automation tasks for the code deployment PIV process.
• Participated in production lodgment activities and support for batch runs.
• Westpac is the oldest and one of the four major banking organizations in Australia, and one of the largest banks in New Zealand.