Senior Consultant 2
Pwc
Keywords
Skills
ETL, Big Data, Hive, Data Analysis, Azure cloud/Databricks, analytics, Algorithm, database, text mining, python, Oracle, Autosys, Pandas, Numpy, clustering, Data Warehouse, Sql, DataMart, cursors, DB, DB2, requirement gathering, DB2 table, SQL queries, Pyspark, Oracle PLSql /Sql, Unix, Statistical techniques, Tableau, Predictive Modelling, Microsoft Azure cloud/Databricks
Project history
09/2018
-
04/2021
Roles:
1. Building solutions for fraud analytics and predicting the same using Naïve Bayes Algorithm.
2. Requirement gathering from Business.
3. Build the entire solution for GDPR for audit purpose.
4. Visualizations using Tableau.
5. Automating the task of reading pdf bills and loading the same in a database for analyzing.
6. Application of text mining and statistical techniques on pdf bills to understand the behavior, pattern of the
any frauds and generating an automated notification if there is a pattern found.
1. Building solutions for fraud analytics and predicting the same using Naïve Bayes Algorithm.
2. Requirement gathering from Business.
3. Build the entire solution for GDPR for audit purpose.
4. Visualizations using Tableau.
5. Automating the task of reading pdf bills and loading the same in a database for analyzing.
6. Application of text mining and statistical techniques on pdf bills to understand the behavior, pattern of the
any frauds and generating an automated notification if there is a pattern found.
12/2015
-
09/2018
Consultant
Virtus Polaris; Citi
Roles:
1. Requirement gathering from Business.
2. Creation of LLD and HLD for Business and getting the approval on design.
3. End to End ETL solutions using python and Oracle.
4. Automating the same using Autosys scheduling.
5. Data Analysis using Pandas and Numpy as a part of client POC for predicting the
demand for credit cards using clustering techniques.
6. Creation of Data Warehouse for Application source system. This helps the business
in analyzing any external risk on the same.
7. Applications based on which warehouse were created are External Audit, Internal
Audit, Third Party Risk, Regulatory and Service Now. This involves implementing
SCD and other relevant features of data warehouse.
8. Modules worked under Citi are Third Party Risk, Regulatory Analysis, Service Now
Automation, Internal Audit and External Audit. Specific activities included
building designs for loading the warehouse, writing Sql queries and creating
Oracle packages and triggering the same through python.
9. Writing Stored procedures for extracting and loading the data and updating the
DataMart using PLSql cursors.
10. Creating Materialized view and dynamic/generic procedure for Materialized view
refresh.
11. Designed Stored Procedure to load data for any tables from one environment to
other using DB link feature of oracle.
1. Requirement gathering from Business.
2. Creation of LLD and HLD for Business and getting the approval on design.
3. End to End ETL solutions using python and Oracle.
4. Automating the same using Autosys scheduling.
5. Data Analysis using Pandas and Numpy as a part of client POC for predicting the
demand for credit cards using clustering techniques.
6. Creation of Data Warehouse for Application source system. This helps the business
in analyzing any external risk on the same.
7. Applications based on which warehouse were created are External Audit, Internal
Audit, Third Party Risk, Regulatory and Service Now. This involves implementing
SCD and other relevant features of data warehouse.
8. Modules worked under Citi are Third Party Risk, Regulatory Analysis, Service Now
Automation, Internal Audit and External Audit. Specific activities included
building designs for loading the warehouse, writing Sql queries and creating
Oracle packages and triggering the same through python.
9. Writing Stored procedures for extracting and loading the data and updating the
DataMart using PLSql cursors.
10. Creating Materialized view and dynamic/generic procedure for Materialized view
refresh.
11. Designed Stored Procedure to load data for any tables from one environment to
other using DB link feature of oracle.
09/2015
-
12/2015
Data Analyst
TCS
Roles:
1. Worked in creating POC for AIG Client using Python and DB2.
2. End to End requirement gathering for POC.
1. Worked in creating POC for AIG Client using Python and DB2.
2. End to End requirement gathering for POC.
08/2011
-
08/2015
Senior Engineer
Mindtree Ltd; AIG
1. Developed an end to end automated robust system using python for loading any
DB2 table.
2. Design and development of Data warehouse using python and Stored procedure.
3. Designing and developing Stored Procedure and writing complex SQL queries
4. Developed python scripts for automating the file validations.
DB2 table.
2. Design and development of Data warehouse using python and Stored procedure.
3. Designing and developing Stored Procedure and writing complex SQL queries
4. Developed python scripts for automating the file validations.
Local Availability
Only available in these countries:
India
