About Me
Experienced Senior Data Analyst in IT industry, working to transform raw data into actionable strategic knowledge to gain insight into business processes, and thereby guide strategic and tactical decision-making. Expert …
Experienced Senior Data Analyst in IT industry, working to transform raw data into actionable strategic knowledge to gain insight into business processes, and thereby guide strategic and tactical decision-making. Expert in R and Python scripting. Worked in stats function with NumPy, visualization using Matplotlib/Seaborn and Pandas for organizing data. Experience in using various packages in R and python like ggplot2, dplyr, plyr, SciPy, scikit - learn, Beautiful Soup, Rpy2. Extensive experience in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau. Experience in writing code in R and Python to manipulate data for data loads, extracts, statistical analysis, modeling and data munging. Expertise in creating Scrum stories, Agile Methodologies, Sprints experience in Python based environment, along with data analytics, Excel data extracts and data wrangling.
Experience
Senior Data Analyst and Data analyst
Environment: MySQL, MS SQL Server, Python, Pandas, SciPy, NumPy, Matplotlib, Excel, Tableau, PL/SQL, PowerBI, R programming language, RStudio.
Responsibilities:
Develop a data platform from scratch and took part in requirement gathering and analysis phase of the project in documenting the business requirements.
Worked in designing tables in MYSQL and processing data like importing and exporting of databases involved in
processing large datasets of different forms including structured, semi-structured and unstructured data.
Implemented Custom data extraction using SQL scripts, SQL stored procedures, Functions, Views and Triggers
Imported the customer data into Python using Pandas libraries and performed various data analysis - found patterns in data which helped in key decisions for the company.
Performed Data Cleaning using Python packages such as Pandas, NumPy, Matplotlib, Sci-kit Learn to remove duplicates, errors and outliers.
Implemented data governance policies and procedures while processing the data.
Performed complex data analysis to analyze customer shopping data and proposed locations for future stores
using R programming language.
Used Python programming for managing and transforming and integrating with datasets in preparation for analytics.
Estimated existing and potential markets using statistical tools such as SQL, RStudio and PowerBI.
Created dynamic linear models to perform trend analysis using Python
Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Integrated data from different sources. Developed stored procedures, improved database design, created views, and derived tables to power data for user stories.
Documented entire process of data analysis in R Markdown.
Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
Mentored and assisted junior data analysts and interns.
Senior Data Analyst
Developed a data platform from scratch.
Took part in requirement gathering and analysis phase of the project.
Documented the business requirements.
Worked in designing tables in MYSQL.
Processed data including importing and exporting databases.
Processed large datasets of structured, semi-structured and unstructured data.
Implemented custom data extraction using SQL scripts, SQL stored procedures, functions, views and triggers.
Imported customer data into Python using Pandas libraries.
Performed various data analysis and found patterns in data which helped in key decisions for the company.
Performed data cleaning using Python packages such as Pandas, NumPy, Matplotlib and Sci-kit Learn to remove duplicates, errors and outliers.
Implemented data governance policies and procedures while processing the data.
Performed complex data analysis to analyze customer shopping data and proposed locations for future stores using R programming language.
Used Python programming for managing, transforming and integrating datasets in preparation for analytics.
Estimated existing and potential markets using statistical tools such as SQL, RStudio and PowerBI.
Created dynamic linear models to perform trend analysis using Python.
Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Integrated data from different sources.
Developed stored procedures, improved database design, created views and derived tables to power data for user stories.
Documented entire process of data analysis in R Markdown.
Mentored and assisted junior data analysts and interns.
Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
Data Analyst
Participated in requirements meetings to understand business requirements.
Cleaned and processed datasets using advanced Excel spreadsheet functions.
Written complex SQL queries using joins and OLAP functions like Count, CSUM and Rank.
Developed complex T-SQL code such as stored procedures, functions, triggers, indexes and views for the business application.
Found outliers, anomalies and trends in given data sets.
Performed complex data analysis in support of ad-hoc and standing customer requests.
Used Python NumPy, SciPy, Pandas, Panda SQL, Mat plot and Stats packages to perform dataset manipulation, data mapping, data cleansing and feature engineering.
Built and analyzed datasets using R and Python.
Implemented data governance policies and procedures while processing the data.
Wrote Python routines to log into websites and fetch data for selected options.
Produced monthly visualized analysis reports improving managers’ problem diagnosing and decision-making processes.
Involved in extensive routine operational reporting, hoc reporting and data manipulation to produce routine metrics and dashboards for management.
Published interactive dashboards and scheduled auto-data refreshes.
Created publishing reports for stakeholders using Power BI.
Used Excel sheets, flat files and CSV files to generate Tableau ad-hoc reports.
Worked on creating filters and calculated sets for preparing dashboards and worksheets in Tableau.
Built, published customized interactive reports and dashboards, and scheduled reports using Tableau Server.