adbirz@r.postjobfree.com +1-734-***-**** https://www.linkedin.com/in/shah-khyati/

PROFESSIONAL SUMMARY

* ***** ** ************ **** experience as Data Analyst, working with Excel, Tableau, SQL and Python

Experienced process-oriented Data Analyst having excellent analytical, quantitative and problem-solving skills using SQL, Advanced Excel, Python, R and Tableau. Self-motivated with the ability to work both independently and in a team. Seeking an opportunity as a Business/Data Analyst to drive growth for a company

Skilled in visualizing, manipulating and analyzing large datasets and also has ability of designing and developing effective reports. Proficient with MS Office Applicants, Excel (Pivot Table, Hook UP, VLOOKUP, CountIf, etc.) and also experienced with Tableau, MS SQL Server

Experience in writing complex SQL Queries to extract data from various data sources.

Experience in understanding and creating Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.

Expertise in Data Warehousing concepts including Metadata and Data Marts

Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.

Highly skilled in Tableau Desktop for data visualization, Reporting and Analysis, Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart

Strong Analytical, Interpersonal, Communication skills and excellent team player

Good project management, communication and presentation skills

Strong organizational skills. Ability to work well under pressure. Self-motivated and able to work on my own initiative. Proactive and can work flexibly as part of a team

EDUCATION

Northeastern University- Masters in Informatics, Specialization: Analytics (GPA: 3.82) Jan 2018 – July 2019

Gujarat University- Bachelors of Engineering, Electronics & Communication (GPA: 3.8) Aug 2012 – Jun 2016

SKILLS AND CERTIFICATIONS

Online Courses: SQL for Data Science, Excel for Data Analysis, Python and R for Data Science, Tableau for beginners

Technical Skills: SQL, Python, R, MS Excel

Tools: Jupyter Notebook, R-studio, Tableau, MS Office, MS Word, PowerPoint, Power BI, MySQL

ETL /Analysis /Reporting: SSIS, SSRS, Business Objects & Crystal Reports

PROFESSIONAL EXPERIENCE

Walgreens, Jersey City, New Jersey Jan 2019 – Till Date

Role: Data Analyst

My role as a Business/Data Analyst was to work on Data Quality, Data Validation, and Reporting to analyse business processes to identify areas of reducing operating costs and improving efficiencies. This project aimed to improve Nationwide's overall ability to identify, measure, and manage risk.

Responsibility:

Performed Requirements Gathering and Analysis through interactions, meetings and periodic walkthroughs with potential users of the application along with the creation of Use Case Scenarios based on business requirements

Developed system process flows and User Requirements Specifications through surveys and interviews.

Involved in ETL and data cleansing of the contacts database for successful migration of legacy contact database to new CRM Application-Salesforce

Performed UAT on the Data Marts and validated the models against the business requirements

Prepared the ETL mapping specifications to extract data from the existing source systems to the Data marts

Data analysis using SQL, data quality validation, data governance (business processes, policies)

Prepared Data Cleansing methodologies

Assisted ETL developers with the design and development of ETL workflows for extracting, data cleansing, transforming, integrating, and loading data into different Data Marts

Maintained data consistency and database integrity and attended team meetings to identify requirements for data loading and reporting

Documented data sources and transformation rules required populating and maintaining data warehouse content.

Conducted the Data Analysis and identified the Data quality issues using Data profiling methodologies

Developed strategies with Quality Assurance group to implement Test Cases in Quality Center for stress testing and UAT (User Acceptance Testing)

Wrote Test Plan and created Test cases and scenarios for the various Reports and Dashboards in accordance with the business requirements

Responsible for writing and updating test plan documents for every version update to the Data Mart

Prepared/Reviewed weekly testing status and reports. Presented program-level testing information at meetings as requested

Environment: Teradata, Oracle, SQL Server, MS Visio, Agile methodology, MS Power Point, Microsoft Office Suite

(Word, Excel, Power Point, Visio)

C.B. TECHNOLOGY Jul 2016 – Nov 2017

Role: Data Analyst

Responsibility:

Completed exhaustive data cleaning including data integrity checks, anomaly detection and missing value imputation of 50+ attributes using MS Excel and reduced about 60% redundant data

Identified customer needs by predicting their buying behaviour and forecasting trends and demand. Analysed large amounts of data in data files and tables using SQL to identify data patterns and issues

Developed analytics reports and dashboards using Tableau for ad-hoc projects

Proactive monitoring using analysing skills identified trends in complex data resulted in increasing accuracy by 30% which helped in making better decisions for cost reduction and revenue improvement

Successfully interpreted data to identify outliers not in current market forecast using Excel and Python

Environment: MS Power Point, Microsoft Office Suite (Word, Excel, Power Point), Tableau, SQLite, Python

ACADEMIC PROJECTS

KA ANALYTICS – CLOUD BASED BIG DATA SMART SURVEY Jan 2019 – Mar 2019

Led a team of 5 graduate students to analyse the products for clients like Dunkin and Starbucks by executing questionnaires with the goal to collect 300 customer feedback using Big Data Smart Survey app

Used data collected through the survey to understand the current trends/needs of customer and explore solutions through customer feedback to improve the productivity and sales of rarely sold products by 10%

INNOVATIONS DOMAIN, LLC – BUSINESS OPERATIONS EXECUTIVE DASHBOARD July 2018 – Aug 2018

Initiated, executed and monitored 8 weeks virtual project with team of 4 graduate students to create executive dashboard that track organizational KPI metrics like MRR and data for revenue and business development

Presented executive level dashboard design in excel incorporating drill-down capabilities, pivot table exception reporting, operational adoption and ROI which helped non-technical team to understand about changes and improvement in monthly revenue

Collaborated with teammates to prepare strategies and build dashboard for the innovation ecosystem of Start-up Accelerator & Incubator, Investor, Entrepreneurship & Innovation Program and Contract Manufacturer

LIFE STORY HEALTH – DATABASE CONSULTANT May 2018 – June 2018

Researched and recommended secured data transmission Health Nexus Platform to Life Story Health, resulted in 50% more secured women healthcare data than before

Tested security platforms for securing the sensitive women health data of the company.

Proposed, presented and demonstrated the use of NIST 800-53 controls for Risk Management and Operational Security to secure patient’s data while storing and transmitting

ANALYSIS ON HEART DISEASES – (Python and Tableau) May 2019 – Aug 2019

Pre-processed the dataset that came with duplicate rows, multiple data formats, null values, etc. and categorized similar words, diseases types using dictionaries for over 1 million records

Visualized the data into pie-charts, bar graphs, histograms, scatter plots and performed analysis

Performed prediction analysis on classification models like linear regression, random forest, decision trees

Technologies used are Scikit Learn, Pandas, Numpy, Jupyter Notebook

Contact this candidate