Neelema Parwani
Iselin,NJ
Summary
Analytical and process-oriented Data Engineer/Data Analyst with five plus years of experience identifying efficiencies and problem areas within data streams, in-depth knowledge in ETL (Data Extraction, Transformation & Loading), Data Manipulation, Data Modeling, Data Integration. Expertise in Designing and development of dashboards, parameterized, chart, tabular, matrix reports in Tableau. Adept in programming language like Python, SQL, including Big Data tools and technologies like Azure Databricks, HDFS, Map Reduce, and PySpark.
Overview
5
5
years of professional experience
Work History
Senior Data Engineer
Deloitte Consulting LLP
Dallas, TX
12.2021 - Current
- Worked on Membership data for insurance across various lines of business, gathered business requirements, developed strategy for data architecture flows, writing functional and technical specifications,
- Collaborated with solution architects to define database and analytics engagement strategies for operational territories and key accounts.
- Created data pipelines used for the purpose to Extract, Transform and Load data from source to make it available for outreaching the customers,
- Performed data profiling steps by writing SQL to transform and aggregate the data as per the metric calculation,
- Worked as a technical lead in collaboration with dev team and business in gathering requirements and creating the CI-CD pipelines to meet data needs,
- Worked on deliverables and providing the data for downstream application to consume and making the data available to be displayed on UI, Developed Spark applications using Spark-SQL for data extraction, transformation and aggregation,
- Leaded Azure migration from on-Prem Data lake to cloud for all the applications
Data Analyst
Tata Consultancy Services
Edison, NJ
09.2020 - 11.2021
- Worked on Azure Databricks using PySpark and Spark-SQL for data extraction, transformation and aggregation from multiple file formats for Analyzing & transforming the data to uncover insights,
- Worked on Covid Healthcare data and gathered business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation,
- Created data pipelines in Airflow using Azure Data bricks to Extract, Transform and Load data from different sources like Azure SQL, Azure Data Lake, Azure Storage,
- Hands on experience for ingesting data from disparate data sources using Pyspark to make the data available to be displayed on Tableau Dashboards, Responsible for estimating the cluster size, monitoring and troubleshooting of the Spark Databricks cluster,
- Worked on on-call production issues - resolving the errors and workaround for defects within SLA duration, Experience in ingesting data to Relational Database Systems (RDBMS)- Oracle, DB2 and SQL Server and from RDBMS to HDFS
Data Analyst Intern
American Heart Association
Dallas, TX
04.2019 - 08.2019
- Designed and built statistical analysis models on large data sets that helped business for making strategic and tactical decisions to increase in the number of memberships provided by 20%,
- Worked on Microsoft SQL Server for storing and accessing the counts and the structure of the data in the databases,
- Build interactive dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently,
- Designed and developed workflows in Alteryx to perform data cleaning, data blending and data preparation for analysis,
- Created reporting tools to help lower support costs by identifying time wasted serving customers, Improved the accuracy of data analytics and reporting by 20% resulting in higher memberships and earnings
Education
Masters in Data Science -
University of North Texas
12.2019
Masters in Accounting and Finance -
University of Mumbai
05.2017
Skills
SQL Oracle PL/SQL Teradata Pyspark Python HTML CSS Spark Snowflake SQL Server Microsoft Azure Data Analysis Skills
Accomplishments
SQL Essential Training | Statistics Foundations: 1 | Statistics Foundations: 2 | Statistics Foundations: 3
Timeline
Senior Data Engineer
Deloitte Consulting LLP
12.2021 - Current
Data Analyst
Tata Consultancy Services
09.2020 - 11.2021
Data Analyst Intern
American Heart Association
04.2019 - 08.2019
Masters in Data Science -
University of North Texas
Masters in Accounting and Finance -
University of Mumbai
Similar Profiles
DAMANJIT SINGHDAMANJIT SINGH
DIGITAL TRANSFORMATION/DELIVERY LEADER at DELOITTE CONSULTING LLPDIGITAL TRANSFORMATION/DELIVERY LEADER at DELOITTE CONSULTING LLP
Nikolaus GeiheNikolaus Geihe
Manager, Human Capital at Deloitte Consulting, LLPManager, Human Capital at Deloitte Consulting, LLP
Vipin SinghVipin Singh
Development Technical Lead at Deloitte Consulting LLPDevelopment Technical Lead at Deloitte Consulting LLP
ABID KHANABID KHAN
Specialist Leader at Deloitte Consulting LLPSpecialist Leader at Deloitte Consulting LLP
Mubeen ButtMubeen Butt
Business Intelligence Analyst at General Vision ServicesBusiness Intelligence Analyst at General Vision Services