Anjan Kumar

Data Analyst

Phone: 512-***-**** Email: ady9wl@r.postjobfree.com Location: Austin, TX Summary

An experienced data analyst, professional with around 4 years of Experience and entrepreneur with strong communication, leadership, and interpersonal skills

An analytical and problem - solving professional with good knowledge and experience in Analysis

Seeking an opportunity to showcase my abilities in a growing company looking to effectively utilize their data to more adeptly provide statistical information to their clients

Experience in data visualization, Manipulation, Validation using Python, Tableau and SQL

Used multiple packages of python including NumPy, Pandas, SciPy, PyTorch, Matplotlib, Seaborn etc.

Working knowledge on different data sources as Flat files SQL, SQL Server and MySQL

Experience with Exploratory Data Analytics, Data (Wrangling, Exploration, Visualization, Modeling)

Good experience on Advance Excel, SQL, BI tools like Tableau and Power BI for developing dynamic reports

Proficient in developing different types of Tableau Reports, working at the data model to fit tableau needs and discovering data by Tableau to best answer the business questions

Knowledge in designing and developing Teableau

Knowledge in creating and developing Power BI Dashboards into the rich look

Proficiency in MS Office applications (Word, Excel, PowerPoint)

Hands on Experience on Methodologies like Agile, SDLC and Waterfall

Experience in developing data applications in Windows and Mac OS environments

Knowledge in transforming business requirements into analytical models, designing algorithms, building models, developing data mining and reporting solutions that scale across a massive volume of structured and unstructured data

Good Interpersonal Skills, team-working attitude, takes initiatives and very proactive in solving problems and providing the best solutions

Education

Masters in Computer & Information Science Aug 2021 - Dec 2022 Southern Arkansas University, AR

Bachelors in Computer Science May 2015 - Jun 2019 Jawaharlal Nehru Technical University, India

Skills

Techniques: Data warehousing, Data mining, Data cleaning, Data manipulation, Data visualization, Data Transformation, Statistics and Mathematics

Databases: MySQL, MS SQL Server

Languages: SQL, PL/SQL and Python

Packages: Pandas, NumPy, SciPy, PyTorch, Matplotlib, Seaborn etc. Tools: Tableau, Power BI, SSIS, SSRS, SSAS, and MS Office (with advance Excel) Others: Data Transformation Services (DTS), Import & Export (DTS), SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Enterprise Manager, SQL Profiler and Query Analyzer Methodologies: Agile, SDLC and Waterfall

Operating System: Windows and Mac OS

Experience

CVS Health, USA

Role: Data Analyst Sep 2022 – Present

Responsibilities:

• Performed statistical data analysis and data visualization using Python

• Wrote MySQL queries from scratch and created views on MySQL for Tableau

• Data Modeling for different domains in staging layer

• Involved working on different set of layers of Business Intelligence Infrastructure

• Created and executed SQL queries using SQL scripts to validate data movement

• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis

• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects

• Extracted data from data warehouse server by developing complex SQL statements using stored-procedures

• Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance

• Prepare the data rules spreadsheet using MS Excel that will be used to update allowed values, findings and profiling result

• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results

• Created Data Dictionary in Excel Database

• Hands-on experiences assisting users in creating and modifying worksheets and data visualization dashboards Involved in creating database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently Avenir Technologies, India

Role: Data Analyst Aug 2018 – Jun 2021

Responsibilities:

• Perform data manipulation, development and validation of data models using Python and SQL

• Worked on predictive analytics use-cases using Python language

• Generating various capacity planning reports (graphical) using Python like NumPy, Pandas, and Matplotlib

• Communicated and presented default customers profiles along with reports using Matplotlib and Tableau, analytical results and strategic implications to senior

• Wrote, executed, performance tuned SQL queries for data analysis and profiling and wrote complex SQL queries using joins and sub queries

• Created functions, triggers, views and stored procedures using MySQL and SQL Server

• Performed Data Analysis & Profiling using complex SQL on various sources systems including MS SQL Server

• Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation

• Executed SQL queries to access & analyze data from the relational database for data modelling and reporting

• The Building, publishing customized interactive reports and dashboards, report scheduling using Tableau

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality during POC

• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation

• Converted charts into Crosstabs for further underlying data analysis in MS Excel Responsible for physical/logical data modelling, metadata documentation, user documentation and production specs

• Published Dashboards onto Tableau Server

• Worked with data investigation, discovery, mapping tools to scan every single data record from many sources

Contact this candidate