Harshal Kane

DATA ANALYST

SUMMARY

• Having * years of Information Technology experience in data mining large data sets of Structured and Unstructured data, Data Acquisition, Data Validation and Data Visualization of data and management.

• Proficient in programming languages such as Python, SQL, and R, with expertise in developing complex SQL queries for data extraction, manipulation, and aggregation.

• Skilled in using a variety of packages and libraries including NumPy, Pandas, Matplotlib, SciPy, Scikit-learn, and TensorFlow for advanced data analysis and machine learning.

• Demonstrated proficiency in visualization tools such as Tableau, Power BI, Advanced Excel, and Qlik View, creating visually appealing dashboards and presentations to convey actionable insights.

• Experienced in working with diverse databases including MySQL, MongoDB, Microsoft SQL Server, PostgreSQL, and Oracle.

• Familiar with cloud technologies, particularly Google Cloud Platform, for efficient data storage, management, and analysis.

• Possesses expertise in other technical skills including Google Analytics, DAX, Power Query, SAS, JIRA, SAP, SSIS, SSRS, and various machine learning algorithms.

• Strong background in statistical analysis, hypothesis testing, regression analysis, and data mining, with a focus on data cleaning, wrangling, and transformation.

• Proven ability to collaborate with cross-functional teams, using version control tools like Git and GitHub, while adhering to Agile methodologies for effective project management. SKILLS

Methodologies: SDLC, Agile, Waterfall

Programming Language: Python, SQL, R

Packages: NumPy, Pandas, Matplotlib, SciPy, Scikit-learn, TensorFlow, Seaborn, Plotty Visualization Tools: Tableau, Power BI, Advanced Excel (Pivot Tables, VLOOKUP), Qlik View IDEs: Visual Studio Code, PyCharm, Jupyter Notebook, IntelliJ Database: MySQL, MongoDB, Microsoft SQL Server, PostgreSQL, Oracle Cloud Technologies: Google Cloud Platform, Snowflake Other Technical Skills: Google Analytics, DAX, Power Query, SAS, JIRA, SAP, SSIS, SSRS, Machine Learning Algorithms, Probability distributions, Confidence Intervals, ANOVA, Hypothesis Testing, Regression Analysis, Linear Algebra, Advance Analytics, Data Mining, Data Visualization, Data warehousing, Data transformation, Data Storytelling, Association rules, Clustering, Classification, Regression, A/B Testing, Forecasting & Modelling, Data Cleaning, Data Wrangling, Critical Thinking, Communication Skills, Presentation Skills, Problem-Solving

Version Control Tools: Git, GitHub

Operating Systems: Windows, Linux, Mac iOS

EXPERIENCE

Data Analyst CVS Health, NJ May 2022-Present

• Develops complex SQL queries to extract, manipulate, and aggregate clinical data, resulting in actionable insights.

• Utilizing Snowflake for data storage, management, and analysis, enhancing team efficiency and scalability.

• Creating visually appealing dashboards and visualizations using tool Tableau to convey insights effectively, Managing and interpreting a wide variety of clinical or EHR based data.

• Executes complex queries in SQL to extract and transform raw data from diverse sources, ensuring data consistency and accuracy.

Phone: +1-347-***-****

Email: ad1y6t@r.postjobfree.com

Location: Jersey City, NJ

LinkedIn

• Leverages Python for data manipulation and transformation tasks, contributing to streamlined data processing pipelines and complies clinical data to meet customer requirements or analytic needs.

• Automating data extraction and transformation processes using Python scripts, reducing manual effort and errors.

• Maintaining comprehensive documentation of data models, transformations, and processes, enhancing team collaboration.

• Working with integration analysts to validate, analyse, codify, and normalize clinical data from a variety of electronic medical records (EHR).

• Designing and developing schema data models using MS Excel, SQL, and other data warehouse analytical tools.

• Uses SSIS to transfer data from various sources like SQL Server to be used for generating reports using SSRS 2008.

• Managing end-to-end data projects, from requirements gathering to deployment, ensuring timely and successful project completion.

• Performing data cleansing and manipulation by using excel VLOOKUP’s, pivot and other advance excel functions and creates project presentations for business, stakeholders and clients using MS PowerPoint.

• Performing data quality check, and validation of different data sets to identify outliers, inconsistencies, and anomalous results from the data obtained from multiple sources using Excel.

• Conducting exploratory data analysis (EDA) using SAS tools to uncover valuable insights.

• Utilizes Git for version control and collaborated with cross-functional teams using Agile methodologies for project management.

• Maintaining Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports, and updating spreadsheet information. Data Analyst Cognizant, India Jul 2018 - Dec 2020

• Utilized SQL, Python to perform ETL and load data into the target tables which enabled effective reporting and business Intelligence Functions.

• Performed data analysis using SQL, provided quality assurance of imported data, working with quality assurance analyst if necessary.

• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. In a single dashboard by using parameters.

• Built automated data solutions and PowerBI dashboards for analytical reporting and provided technical assistance on data storage structures, data mining, data mapping and data cleansing.

• Converted the Boulder Tables from Excel to Power BI with better Graphs and visualizations for the understanding and improvement of business.

• Created data dictionary, Data mapping for ETL and application support, DFD, ERD, mapping documents, metadata, DDL and DML as required.

• Worked with OLAP tools such as ETL, Data warehousing and Modelling, Used Informatica / SSIS to extract, transform &load data from SQL Server to Oracle databases.

• Used DAX functions to create measure and calculated fields to analyse data for logical visualization and used Power Queries to transform the data.

• Generated, wrote, and run SQL script to implement the DB changes including table update, addition or update of indexes, creation of views and store procedures.

• Documented the data requirements and system changes into detailed functional specifications and performed Extraction, Transformation and Loading (ETL) using Informatica power centre.

• Developed Mappings using Source Qualifier, Expression, Filter, Look up, Update Strategy, Sorter, Joiner, Normalizer and Router transformations.

EDUCATION

Master of Science in Information System – Stevens Institute of Technology, NJ, USA Bachelor of Engineering in Computer Science and Engineering – Shah and Anchor Institute of Technology, India

Contact this candidate