Nitish Daurkar
Aurora,IL
Summary
Data analysis professional prepared to deliver impactful insights and drive business decisions. Adept in data visualization, statistical analysis, and database management, with strong focus on teamwork and adaptability. Known for reliability, analytical thinking, and results-driven approach. Skilled in Python, SQL, and Excel, ensuring robust data solutions and strategic recommendations.
Overview
4
4
years of professional experience
Work History
Data analyst
TCS/AIG
Milford, OH
11.2024 - Current
- Working on project contained a heavy Python, SQL, Tableau and data modelling.
- Working extensively with Tableau Business Intelligence tool to develop various dashboards.
- Working on datasets of various file types including HTML, Excel, PDF, Word and its conversions.
- Participated in data modelling discussion and provided inputs on both logical and physical data modelling.
- Reviewed the Performance Test results to ensure all the test results meet requirement needs.
- Opened Risks or Issues that the current project is facing and worked towards resolving them.
- Performed data merging, cleaning, and quality control procedures by programming data object rules into a database management system.
- Created detailed reports for management.
- Reported daily on returned survey data and thoroughly communicated survey progress statistics, data issues, and their resolution.
- Develop a master data flowchart which was used to measure the completion of study objectives.
- Served as primary contact for the acceptance or rejection of surveys where unique or rare issues were involved.
- Used Data sources are extracted, transformed and loaded to generate CSV data files with Python programming and SQL queries.
- Connected to AWS EC2 using SSH and ran spark-submit jobs.
- Designed and implemented configurable data delivery pipeline for scheduled updates to customer facing data stores built with Python.
- Stored and retrieved data from data-warehouses using Amazon Redshift.
- Created the source to target mapping spreadsheet detailing the source, target data structure and transformation rule around it.
- Wrote Python scripts to parse files and load the data in database, used Python to extract weekly information from the files, Developed Python scripts to clean the raw data.
- Performed Database and ETL development per new requirements as well as actively involved in improving overall system performance by optimizing slow running/resource intensive queries.
- Developed data mapping documentation to establish relationships between source and target tables including transformation processes using SQL.
- Created master Data workbook which represents the ETL requirements such as mapping rules, physical Data element structure and their description.
- Environment: Teradata, MS Power Point, UNIX Shell Scripts, MS Excel, Python 3.7, SQL, AWS, Hadoop Spark 2.0,2, AWS, Spark, Python
Data Analyst
USAA
Plano, TX
03.2024 - 10.2024
- Worked with an ERP Data Science team to ensure analytical work product is consistent across studies and programs where appropriate and that user experience is optimized and follows the design principals and standards established by the team.
- Leveraged various statistical methodologies to drive innovative analytical solutions to create insights from clinical healthcare data.
- Involved in Data Analysis, Data Cleansing, Data Governance, Transformation, Integration, Data Import and Export using ETL tools like by building batch and streaming pipelines with Spark, pipelining data in and out of Data Lake, storing data in Hive tables for querying.
- Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
- Maintenance of large data sets, combining data from various sources by Excel, Pandas dataframes, and SQL queries by writing SQL statements (Stored procedures and packages).
- Communicating with the business users and developers to communicate any defects and issues and actively participated in replicating the bugs and performing regression testing using Jira.
- Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.
- Involved in designing and deploying multi-tier applications and data ingestion using all the AWS services like (EC2, S3, RDS, Dynamo DB, SNS, SQS, IAM, ElasticSearch, Neptune(Graph database)) focusing on high-availability, fault tolerance, and auto-scaling in AWS Cloud Formation.
- Used Pandas as API to put the data as tabular format for manipulation and retrieval of data.
- Environment: Scala, Oracle SQL Visual Studio Code, MS Office Suite - Excel (Pivot, VLOOKUP), PowerBi, AWS, Hive, Python, Jupyter Notebook, Jira, Spark.
Data Analyst
Spectra Info Systems
Hyd, Ind
09.2021 - 07.2023
- Established and maintained solid relationships with the team in developing an affiliate marketing tool for self-driving car/bike providers.
- Utilized the marketing tool for sourcing the best available deals while promoting brand/business visibility.
- Data flow check with source to target mapping of the data. Data matrix creation for mapping the data with the business requirements.
- Responsible for defining the functional requirement documents for each source to target interface.
- Hands on Experience on Pivot tables, Graphs in MS Excel.
- Extensively querying data using SQL Server for data extraction, analysis and validation.
- Processed and cleaned raw data from multiple file formats such as CSV, JSON, XML, GIS files into organized form using Pandas and Numpy on Python.
- Built reports and dashboards using Tableau comparing the pricing strategy of various websites using crosstabs, heatmaps, geographic maps, pie charts in order to make the best-informed decisions for better satisfaction of target customers.
- Created Linear regression models for predictive analysis of the pricing structure of various websites which provided self-driving vehicles in order to provide the best deals to the end users.
- Environment: Python, Visual Studio Code, ETL, SQL Server, Jira MS Office Suite - Excel (Pivot, VLOOKUP), R Studio, Tableau, Jupyter Notebook.
Education
Bachelor's - Information Technology
JNTUH
India01.2022
Master's - Information Technology with Cyber Security
Governor's State University
Illinois05.2025
Skills
- Data Analytics
- Data Cleaning
- Visualization
- Normalization
- Power BI
- Tableau
- SQL
- TSQL
- Basic Python
- SQL Developer
- SQL Server Management Studio
- Jupiter
- Python
- Pandas
- NumPy
- Matplotlib
- Seaborne
- SciPy
- Scikit Learn
- Databases
- MySQL
- SQL Server
- Oracle
- Cloud Technologies
- AWS RDS
- Azure
- ETL
- SQL Server Integrated Services (SSIS)
- Operating System
- Windows
- GitHub
- SQL databases
- Data cleaning
- Analytical problem solving
- Statistical analysis
- Data validation
- Database management
- ETL processes
- Data modeling
- Database maintenance
- Data mining
- Data warehousing
- Database programming and SQL
- Python programming
- Excel functions
- Data analysis
- Data visualization and presentations
- SAP netweaver BW
- Data quality
Timeline
Data analyst
TCS/AIG
11.2024 - Current
Data Analyst
USAA
03.2024 - 10.2024
Data Analyst
Spectra Info Systems
09.2021 - 07.2023
Bachelor's - Information Technology
JNTUH
Master's - Information Technology with Cyber Security
Governor's State University