| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatePROFILEDynamic and results-oriented Data Analyst with 7 years of experience in analyzingcomplex datasets, developing insightful reports, and driving business decisions. Proficient in data visualization, statistical analysis, and data mining techniques. Seeking to leverage extensive expertise to contribute to a forward-thinking organization. EXPERIENCEDATA ANALYST/ DEVELOPER- TATA CONSULTANCY SERVICES(AIG) HOUSTON, TX JAN 2022-CURRENT Lead teams of data warehouse and analysts which owns and supports DWH, Reporting and BI and Fraud Analytics applications in collecting, processing, and analyzing large datasets to provide actionable insights for strategic decision-making. Developed automated data cleansing procedures, reducing automated report failures by more than 90% and improving data accuracy. Create and modify reports and dashboards in Power BI to visualize key metrics and KPIs for executive stakeholders. Collaborated with cross-functional teams to identify business opportunities and optimize processes based on data-driven recommendations. Create and modify reports in R/ RStudio to prevent fraudulent transactions and related apps. Create and modify Shiny app as per the stakeholders requirements. Made changes/enhancement to various Stored Procedures in DWH. Completed RCA of many fraudulent transactions and modified RStudio app to prevent similar frauds again in future. Create adhoc reports using pl/sql, Snowflake, RStudio as per business requirements. Provide support for all these app related to migration related activities and deployments. Modify many Linux scripts to reduce DWH cycles failures and to analyze failures of automated oracle jobs easier and quicker. Conduct in-depth analysis of oracle job failures and fix it to keep financial cycles running in DWH. Assist ETL team to enhance/modify daily cycle related ETL jobs to reduce manual interventions. Created dashboards in Service Now to handle incidents, Service Requests and change tickets to make sure to not breach SLAs. Communicate with business to understand their requirements mentioned in various tickets. Provide KT of Fraud Analytics app and DWH to new team members. DATA ANALYST/ DEVELOPERCandidate's Name
COLUMBUS,OH M-PHONE NUMBER AVAILABLE EMAIL- EMAIL AVAILABLE SOFTWARE ENGINEER, TATA CONSULTANCY SERVICES(AMTRUST FINANCIAL- CLIENT) CLEVELAND, OH AUG 2020-DEC 2021 Worked with the web application for commercial insurance policies for small businesses, automobiles etc Performed coding, debugging, modifying, developing computer applications and systems Assisted software developers and programmers on software and application development projects Worked with vb.net and SQL database to carry out RCA and debug Created daily report of all daily incidents and pending incidents Developed codes as per requirements Worked on policy data to predict claims, created ML model for new project proposal I use SQL Navigator(PL/SQL), Snowflake, Rstudio and PowerBI on daily bases JR. ENGINEER/DATA ANALYST, ZYDUS HOSPIRA ONCOLOGY PVT LTD; AHMEDABAD, INDIA, 2011-2014 Performed and Supervised engineering maintenance work in HVAC, water system and plant machine, like production and packing lines. Used basic SQL queries to create and maintain data. Analyzed engineering data including electrical, HVAC and water system data using Excel Perform data cleaning, listing, and table creation as part of the modeling Performed data cleaning, created tables and visualization of engineering data and created story and reports based on it.PROJECT EXPERIENCE Successfully completed projects using R and Python programming, Tableau Developed linear regression model to predict quality of wine based on features like fixed acidity, citric acid, residual sugar, volatile acidity, chlorides, density, pH level, free sulfur dioxide, and sulphates, Checked and removed multicollinearity within al features. Checked for normalization, then splitter the data into train and test data set, then trained the model using train data and find the accuracy of the model using test dataset. Developed ml models to reduce violent crimes in NYC based on different features like age, sex, race, type of residence, married, children, education, income, smoker, drinker etc. Created supervised learning algorithms like decision tree, random forest, and KNN models and checked accuracy using confusion matrix to determine best model. Worked on absenteeism dataset to predict absenteeism, dataset included features like reason, month, day, season, transportation expense, height, weight, bmi, married, children, pet, smoker, drinker, education, absenteeism time. Used 4 algorithms like Decision tree, Naive bayes, K means (k=2 to 15), SVM(Linear, Poly, Rbf kernels) to determine best model. Predicted creditability based on different variables like limit, sex, age, no of marriage, married, education, children, from the credit dataset. Developed models using Random forest and decision tree and used confusion matrix to find out better one. Worked with hearth disease data set to predict heart disease from categorical features using mosaic plots in R, also developed regression model to find out accuracy and precision of the model. Created data visualization and developed a dashboard in Tableau using retail sales data set. Successfully completed a small project on clinical research, worked on SAS to develop SDTM tables from raw datasets using SAS programming in DM domain. TECHNICAL CAPABILITIES Expertise in data cleaning, data mapping, exploratory data analysis, data visualization, data-scaling, converting, sub-setting, multicollinearity Experienced in graphs like box-plots, scatter plots, correlation plots, bar plots, and histograms Familiar with one and two-tailed t-tests, null and alternative hypothesis, one and two way ANOVA Experienced in creating different models using supervised and unsupervised Machine Learning process- SVM, Decision tree, random forest, linear regression, logistic regression, KNN, and K- means algorithm Experienced in data visualization and dashboard creation using Tableau Expertise in Risk analysis, Bayesian network analysis and Monte-Carlo simulation in Genie and Excel Familiar with Simio- a Simulation toolEDUCATIONMS- Data Science- Harrisburg University, Harrisburg-PA, December 2019 (GPA- 3.87) MBA- American National University, Roanoke-VA, October 2016 Bachelor of Mechanical Engineering (BS)- North Maharashtra University, Maharashtra-India, June 2011CERTIFICATIONS SAS- Certified Specialist: Base Programming Using SAS 9.4 Azure Fundamentals- AZ 900 Azure AI Fundamentals- AI 900 Mulesoft Certified Developer Neural Networks and Deep Learning CourseraSKILLS ML with R and Python R- Programming with R studio and R- Markdown Exploratory Data analysis with Python Exploratory Data analysis with R Visualization in R using ggplot2 Visualization in Python using matplotlib Python programming using Numpy, Pandas, Scikit learn, Matplotlib SAS programming SQL database SQL queries, stored proc PL/SQL Tableau and PowerBI for visualization and dashboard Excel, Word, and Powerpoint Familiar with Azure Machine Learning, Alteryx Git AWS Machine Learning Snowflake Service now Jira TAC(Talend tool) |
