•Research/analyze datasets/mainframe extracts•Ingest data into AWS Data Lake using AWS services and RLUS framework•Perform data gap analysis for quality, integrity and governance purpose•Reverse engineer and automate exisiting manual process using AWS•Client: Resolution Life US

•Design & development of Data Lake Architecture•Design, develop, test and deploy critical ETL pipelines using AWS DMS/IICS/AWS Data Pipeline/AWS EMR/AWS Appflow•Devlop Power BI report, dashboards and data models based on requirements coming from Finance, Sales, Marketing, Ops, Exec, etc area.•Provide enhancements on existing BI Reports as when required.•Manage Power BI Admin activities related to Gateway, Connections, Workspace, App and Permissions.•Analyse critical Data… Show more •Design & development of Data Lake Architecture•Design, develop, test and deploy critical ETL pipelines using AWS DMS/IICS/AWS Data Pipeline/AWS EMR/AWS Appflow•Devlop Power BI report, dashboards and data models based on requirements coming from Finance, Sales, Marketing, Ops, Exec, etc area.•Provide enhancements on existing BI Reports as when required.•Manage Power BI Admin activities related to Gateway, Connections, Workspace, App and Permissions.•Analyse critical Data and provide justification to Business stakeholders on adhoc basis.•Migrated AWS Data Pipeline jobs to AWS Step Function state machines to keep up-todate with Tech trends.•Client: Hibu Inc (formerly Yellowbook Inc) Show less

•Responsible for design, develop, test and deploy ETL workflows.•Ingest data from various third party source systems to Salesforce CRM and Netezza/Redshift Warehouse.•Troubleshoot and resolve any production ETL workflow issue.•Lead team of 6 members which worked for ETL Operations 24*7•Client: Hibu Inc. (formerly Yellowbook Inc.)

•Manage and support ETL workflow operations running 24*7 in shifts.•Report issues to concerned stakeholders after thorough analysis•Interact with business stakeholders and get issues resolved as per ITIL standards•Manage P3/P4 data related incidents and provide client with a resolution, within the stipulated timeframe.•Client: Hibu Inc (formerly Yellowbook Inc.)

Aircel Outbound Voice Process (English, Hindi, Assamese)