Experience

Angel Cellular

• Canada
• Retail
• 1 - 100 Employee

• Data Analyst and Inventory Manager

  • Jun 2021 - Present

  Tampa, Florida, United States • Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making. • Developed PySpark scripts using both Data Frame/SQL and RDD in spark to query, aggregate, and writing back data to transactional systems using Sqoop. • Extracted data from RDBMS to HDFS using Sqoop and leveraged S3 as a storage layer for HDFS. • Created AWS Lambda functions for ad-hoc business reports and automated them using CloudWatch. • Developed… Show more • Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making. • Developed PySpark scripts using both Data Frame/SQL and RDD in spark to query, aggregate, and writing back data to transactional systems using Sqoop. • Extracted data from RDBMS to HDFS using Sqoop and leveraged S3 as a storage layer for HDFS. • Created AWS Lambda functions for ad-hoc business reports and automated them using CloudWatch. • Developed Glue Jobs using PySpark to transform the data and load it to Redshift. • Monitoring and creating a data pipeline using Bash to consolidate Show less



WellCare Health Plans

• United States
• Insurance
• 700 & Above Employee

• Delivery Tech Lead

  • May 2020 - Present

  Tampa, Florida, United States • Lead a team of 6 to identify data sources, perform data mapping, gather requirements and create reports for Business / State Agencies. • Create and automate reports on Medicare and Medicaid Claims using SAS that runs daily, weekly, monthly and quarterly. • Implemented AWS Step Functions to automate and orchestrate the Amazon SageMaker. • Create Technical Design Document from Functional Specification Document as per Client standards. • Use Python scripting and Informatica… Show more • Lead a team of 6 to identify data sources, perform data mapping, gather requirements and create reports for Business / State Agencies. • Create and automate reports on Medicare and Medicaid Claims using SAS that runs daily, weekly, monthly and quarterly. • Implemented AWS Step Functions to automate and orchestrate the Amazon SageMaker. • Create Technical Design Document from Functional Specification Document as per Client standards. • Use Python scripting and Informatica PowerCenter to clean and load files into Greenplum. • Created an automation process for Distribution group which receive Inventory and sales data send activation report using Talend and Big query

• Delivery Tech Lead

  • May 2020 - Nov 2020

  Tampa, Florida, United States • Lead a team of 6 to identify data sources, perform data mapping, gather requirements and create reports for Business / State Agencies. • Create and automate reports on Medicare and Medicaid Claims using SAS that runs daily, weekly, monthly and quarterly. • Implemented AWS Step Functions to automate and orchestrate the Amazon SageMaker. • Create Technical Design Document from Functional Specification Document as per Client standards. • Use Python scripting and Informatica… Show more • Lead a team of 6 to identify data sources, perform data mapping, gather requirements and create reports for Business / State Agencies. • Create and automate reports on Medicare and Medicaid Claims using SAS that runs daily, weekly, monthly and quarterly. • Implemented AWS Step Functions to automate and orchestrate the Amazon SageMaker. • Create Technical Design Document from Functional Specification Document as per Client standards. • Use Python scripting and Informatica PowerCenter to clean and load files into Greenplum. • Created an automation process for Distribution group which receive Inventory and sales data send activation report using Talend and Big query



Synchrony

• United States
• Financial Services
• 700 & Above Employee

• Data Engineer

  • Dec 2020 - Jun 2021

  Tampa, Florida, United States • Encoded and decoded json objects using PySpark to create and modify the dataframes in Apache Spark • Develop framework for converting existing PowerCenter mappings and to PySpark(Python and Spark) Jobs. • Performed end- to-end Architecture & implementation assessment of various AWS services like Amazon EMR, Redshift, S3. • Design and develop ETL integration patterns using Python on Spark. • Create Pyspark frame to bring data from DB2 to Amazon S3 • Provide guidance to… Show more • Encoded and decoded json objects using PySpark to create and modify the dataframes in Apache Spark • Develop framework for converting existing PowerCenter mappings and to PySpark(Python and Spark) Jobs. • Performed end- to-end Architecture & implementation assessment of various AWS services like Amazon EMR, Redshift, S3. • Design and develop ETL integration patterns using Python on Spark. • Create Pyspark frame to bring data from DB2 to Amazon S3 • Provide guidance to development team working on PySpark as ETL platform • Review and approve changes related to different data warehouses to ensure all functionalities are met and coding standards are followed.

• Data Engineer

  • Dec 2020 - Jun 2021

  Tampa, Florida, United States • Encoded and decoded json objects using PySpark to create and modify the dataframes in Apache Spark • Develop framework for converting existing PowerCenter mappings and to PySpark(Python and Spark) Jobs. • Performed end- to-end Architecture & implementation assessment of various AWS services like Amazon EMR, Redshift, S3. • Design and develop ETL integration patterns using Python on Spark. • Create Pyspark frame to bring data from DB2 to Amazon S3 • Provide guidance to… Show more • Encoded and decoded json objects using PySpark to create and modify the dataframes in Apache Spark • Develop framework for converting existing PowerCenter mappings and to PySpark(Python and Spark) Jobs. • Performed end- to-end Architecture & implementation assessment of various AWS services like Amazon EMR, Redshift, S3. • Design and develop ETL integration patterns using Python on Spark. • Create Pyspark frame to bring data from DB2 to Amazon S3 • Provide guidance to development team working on PySpark as ETL platform • Review and approve changes related to different data warehouses to ensure all functionalities are met and coding standards are followed.



Wipro Technologies

• Data Engineer

  • Dec 2015 - Jan 2020

  India • Worked in different verticals like manufacturing, aviation, petroleum and utilities. • Started with Philips account as support engineer in multi geography project, worked on customer support, ticket resolution, change managements and system upgrades. • Later, moved to analytics department and worked on Python and Spark to scrape, clean, and analyze large datasets. Provide insights and extract knowledge, perform data transformation on Health Care (Medical datasets), Insurance… Show more • Worked in different verticals like manufacturing, aviation, petroleum and utilities. • Started with Philips account as support engineer in multi geography project, worked on customer support, ticket resolution, change managements and system upgrades. • Later, moved to analytics department and worked on Python and Spark to scrape, clean, and analyze large datasets. Provide insights and extract knowledge, perform data transformation on Health Care (Medical datasets), Insurance domains. • Moved to Airbus Account on project engineer role, forecasted sales and improved accuracy by 10-20% by implementing advanced forecasting algorithms that were effective in detecting seasonality and trends in the patterns in addition to incorporating exogenous covariates. Increased accuracy helped business plan better with respect to budgeting and sales and operations planning Show less



Videocon Telecommunications Ltd

• India
• Telecommunications
• 700 & Above Employee

• Data Scientist

  • Jan 2015 - Nov 2015

  India • Worked in new product launch project with end users and analysts to provide analysis of customer based on demographics. • Prepared ER- Diagrams, DFD’s, Requirement documents, Source-to-Target documents. • Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and Physical data Models. • Daily tasks include design, develop and produce reports that connect quantitative data to insights that drive and… Show more • Worked in new product launch project with end users and analysts to provide analysis of customer based on demographics. • Prepared ER- Diagrams, DFD’s, Requirement documents, Source-to-Target documents. • Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and Physical data Models. • Daily tasks include design, develop and produce reports that connect quantitative data to insights that drive and change business. Show less