High performing, critical thinking professional with more than five years' experience in credit bureau, consultancy, telecom and banking sector. Highly skilled at relationship building with clients and across organizations and teams; good writing, presenting, and interpersonal communication skills. Adept at assessing needs, generating options, and implementing solutions in collaboration with clients and stakeholders. Experienced at managing projects from the requirements gathering/needs identification phase through to completion.
Working on expansion of Enterprise Data warehouse.
Creating data processes including download data from sftp, password encryption, column mapping with db and loading data using python 3
Working on Kalido DIW for data warehouse management and development
• Implementation of Data Lake Project on Cloudera.
• Perform Data analysis via Hive and Impala
• Leading a team for end to end process flow including data modeling, data extraction, data loading and dashboards
Responsible for dealing overall ETL/Data related Issues of the client performing
Talend Data Integration ETL tool to create ETL jobs.
Developing and Managing the Data Pipeline for Telefonica - Brazil which included Meetings with the Business Leaders and planning deployment timelines.
Performing Data Analysis on the Client Sales Data Telefonica – Brazil.
Writing MySQL and MS SQL Server scripts and stored procedures to extract data from the source systems and files.
Develop and maintain complex, standardized and adhoc reports based on the requirements from various teams.
Analyze the data in the source in order to perform data quality and data integrity checks which require writing code to fix such issues or escalating to the relevant person or report.
Monitoring daily ETL processes in production environment so that data is readily available to the relevant team.
Creating and monitoring alerts using SQL which validates data integrity checks on the daily data.
Optimizing the SQL code so that the processes run smoothly in the minimal time possible.
Holding discussions with Artificial Intelligence and Business Analytics team to analyze and find out patterns and issues in data, so that the AI models are created using the best dataset.