UNNATY GANDHI

Boston, USA adjmte@r.postjobfree.com:adjmte@r.postjobfree.com%20 https://www.linkedin.com/in/g-unnaty/

Over 7 years of Data Analysis experience with background in econometrics and statistics. Interested in software development opportunities that leverage data analytics & science, software design and strategic consulting to solve complex business problems. By practicing methodical exploration of data with a focus on advanced statistical analysis, I aim to deliver actionable insights from multiple perspectives.

Summary

Solid experience in R and Python scripts performing analysis to support the wider risk strategy, policy, model, and development.

Proficient with the Tableau suite of products such as Tableau Desktop, Tableau Data Prep, Tableau online, Tableau Server.

Hands-on experience in building dashboards, storyboards, reports, and data visualizations using Tableau with multiple data sources, files (Excel, Flat files) and databases.

Implemented complex calculation in Tableau using LOD, Table Calculations, Conditional formatting.

Experience in developing advanced visualizations in Tableau such dual axis, combination chart and sparklines chart.

Experience in building, publishing, and customizing interactive dashboards, report scheduling using tableau server.

Strong SQL skills, including use of multi-table joins, subqueries, group by, unions, scalar functions, aggregate functions.

Proficiency in creation of complex SQL queries to deliver reports to customers and internal stakeholders.

Knowledge and experience in data analysis, data preparation using SQL, and Python (pandas).

Work with Matplotlib in extensions with NumPy and pandas, for providing an Object-oriented API by embedding graphical plots into application.

Work with PyPip/pip package in automation of excel sheets workbooks.

Ability to work effectively with data engineers to meet the data needs of business, translating business needs into analytical requirements.

Ability to work independently as well as a desire to be a productive member of our team.

Excellent communication skills, quick learner with strong analytical/problem solving skills. Always open and ready for new challenges with a positive attitude.

Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Experience in creating and implementing interactive Dashboard and other user interface elements.

TECHNICAL SKILLS & PROFICIENCY

Proficiency: Statistical Modeling (Hypothesis Testing, ANOVA, A/B Testing, Z-test, T-test, Chi-squared Test), Data Analytics, Statistical Analysis, Database Warehousing, NLP, AutoML, Cloud Computing, Qualitative and Quantitative Research

Skill Set: R, Tableau, DataStudio, Spotfire SQL, Python, Microsoft Azure, MS Excel, STATA, RShiny, GCP,

Machine Learning: KNN, Linear Regression, Logistic Regression, Naïve Bayes, Decision Tree, PCA, Classification, Clustering, Random Forest, XGBOOST

Python Libraries: Numpy, Pandas, Scikit-learn, Seaborn, Matplotlib, Tensorflow, ggplot2, Caret, Dplr, spaCy, OpenCV

Education

Bachelor’s in Economics & Statistics, UNIVERSITY OF DELHI, India

Foundations of Data Science: Computational Thinking with Python - UC Berkeley

Foundations of Data Science: Inferential Thinking by Resampling - UC Berkeley

Amazon Web Services Cloud Architect

Tableau Data Scientist

Tableau Analyst

Executive Management Program in Strategic Innovation, Digital Marketing & Business Analytics – Indian Institute of Technology Delhi

Introduction to Econometrics - London School of Economics

Certification on Adoption of Big Data & Analytics - Towards Utilities Transformation

Certificate of Presentation of Case Study on Hyatt Hotels at AGBA’s 15th World Conference at NIDA Business School

Experience

VDart Digital, Alpharetta GA 10/19- Present

Data Analyst

Global Information Technology Services & Workforce Solutions firm headquartered out of Atlanta, GA with presence in US, Canada, MX, UK, Belgium, Japan & India. Founded in 2007, team of over 2550+ professionals continually create impact for our customers worldwide in solving complex technology challenges with cutting edge technologies. They specialize in providing the Fortune 1000 companies, niche hard to find skills in technologies including Social, Mobile, Big Data Analytics, Data Sciences, Cyber Security, IoT, Cloud, Machine Learning, and Artificial Intelligence.

Interpreted data, analyzed results using statistical techniques and provide ongoing reports.

Developed and implemented databases data collection systems data analytics and other strategies that optimize statistical efficiency and quality.

Acquired data from primary or secondary data sources and maintain databases/data systems.

Located and defined new process improvement opportunities.

Experienced with data warehouse tasks supporting requirements management, architecture design, analysis, mapping, modeling, integrity checking, impact analysis and regression testing.

Handled data warehouse and mastered data management approaches, industry standards and industry best practices.

Analyzed source system data, existing data models, and profiling data (using SQL)

Consulted with clients and Implementation team to identify current processes, clarify business objectives,

and to establish technology requirements

Conducted initial data analysis on input files to verify content. Be able to standardize data for processing

Resume Extraction - Performed ML algorithm which helps the recruiters match the resumes more efficiently based on the job description.

Reviewed Business Requirements to identify ETL requirements and utilize Talend to develop ETL processes that support the creation of databases, table spaces, tables, indexes, triggers, procedures, and other database objects.

Developed Line Chart, Map Chart, Cross table, Bar chart, Tree map and complex reports which involves Calculated Columns, Parameters and Table level Calculation.

Modified the existing Tableau reports and improved the performance of the dashboards.

Performed data analysis to understand data marts using data warehousing concepts.

Promoted of Tableau reports to development, testing and production environments.

Performed functional and performance testing, participated in end-to-end reporting support activities.

Performed peer review of code and testing in order to detect and minimize application problems.

Developed and provided training to team members and other business staff on basic utilization and advanced proficiencies.

Executed requirements such as gathering from the business, building data extracts against our Teradata Database, developing Tableau workbooks & publishing to Tableau Server.

Collaborated with data engineers and operation team to implement ETL process, wrote and optimized SQL queries to perform data extraction to fit the analytical requirements.

Identified data anomalies and suggests data quality audits to improve data collection efforts.

Performed data manipulation operations like import/export data from various external file formats using SQL

Produced weekly, monthly, quarterly, and annual reporting on operational metrics with minimal oversight.

Conducted complex data analysis and visualization using both Python and Tableau.

The Motley fool, Alexandria, VA 1/18-9/19

Data Analyst

Founded in July 1993. the Motley Fool is a private financial and investing advice company based in Alexandria, Virginia.

Launched multiple A/B tests in Google Analytics with Retail and Digital teams to increase the subscription rate, awareness of new products detailing current status, forecast, trends, and variance for FY-2018

Extensively utilized SQL to support Ad-hoc for-customer analyses and designed and populated multiple tables for collection, tracking and reporting of data

Scheduled and coordinated routine database maintenance tasks while supporting the database projects and users.

Worked with a team of high-performing analytics, data science professionals, and cross-functional teams to identify

business opportunities and develop algorithms and methodologies to address them.

Developed data processing algorithms for storage, analysis and maintenance of databases using SQL and Python.

Design and develop various Enterprise Business Intelligence Solutions including interfacing and integration with ERP systems of records, ETL design, Data modeling and database design, reporting and analytics solutions.

Identified drivers of business results and recognize appropriate measures and translate that information to business analytics.

Developed data management and reporting requirements and managed data quality in collaboration with business systems and data department.

Performed deep dive analysis into consumer behavior, ranging from pathing, funnel analysis to product interaction, to identify pain points within the online experience and increase product view rate by 30%

Independently created multiple dashboards in Tableau for Site Merchandising and Data Science team to optimize the strategy and algorithms at the product level to enhance the recommended products

Performed Logical & Physical Data Modeling - ER Modeling & Dimensional Modeling.

Normalizing the tables/relationships to arrive at effective Relational Schemas.

Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.

Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.

Worked with data compliance teams, Data governance team to maintain data models, Metadata, Data Dictionaries; define source fields and its definitions.

Global Protection Corp., Boston MA 11/16-12/17

Data Analyst

Global Protection Corp. is part of the Drug Wholesalers Industry. Global Protection Corp. has 25 total employees across all its locations and generates $9.15 million in sales (USD). Unit of Karex- A global family planning manufacturer and distributor on a mission to change people’s approach to sexual health.

Tracked performance and made tweaks to improve performance daily by being data steward of digital marketing team.

Tracked inventories, invented, and updated listings on global marketplace – Amazon, Ebay, Walmart.

Consolidated data from commerce, inventories, and finance platforms to formulate clear picture to marketing team.

Used predictive analytics to assess, clean and validate global marketplace data to forecast company sales and inventories with 95% accuracy.

Successfully interpreted data to draw conclusions for managerial action and strategy.

Boosted sales by 10% over a quarter by identifying association rules between Product/Parts which empowered Retail team in

planning upcoming deals with customers & dealers.

Used hypothesis testing and exploratory data analysis techniques to identify patterns and insights to help the business improve performance by 30%.

Created and deployed rich graphic visualizations with multiple drill down options and maintained Tableau Server Site as a site admin.

Developed Dashboards to convey actionable insights of KPI’s on sales, manufacturing, and financial data on Tableau.

Developed data processing algorithms for storage, analysis and maintenance of databases using SQL and Python

Completed quantitative and qualitative breakdown of customer profile to optimize marketing campaign.

Customer profile classification done in Python by running multiple models (KNN, SVM, Naïve Bayes, K-means, Decision Tree, Logistic Regression etc.)

Collaborated with data engineers and operation department to implement ETL process, wrote and optimized SQL queries to perform data extraction to fit the analytical requirements.

Used Linear Regression and Logistic Regression algorithms in R to analyze and solve complex business problems.

Performed data manipulation operations like import/export data from various external file formats using SQL.

Designed rich data visualizations to model data into human-readable form with Tableau and Matplotlib.

Indian Institute of Technology, Kanpur India 05/14-10/16

Data Analyst

Established in 1959, is one of the premier institutions established by the Government of India with the aim of providing meaningful education, conducting original research of the highest standard and providing leadership in technological innovation.

Extracted, data mined, and visualized Government of India funded project; Applied high class statistical modeling to reach classification of data and forecasted improvement of 85% post vocational training over a period of five months.

Conducted data regression analyses of the relationship between variables on Australia India Council BigQuery data.

Utilized R & STATA to track and analyze data.

Performed univariate and multivariate analysis on the data to identify any underlying pattern in the data and associations between the variables.

Optimized data collection procedures and generated reports on weekly, monthly and quarterly basis.

Used advanced Microsoft Excel to create pivot table and pivot reporting as well as VLOOKUP function.

Prepared analytical and status reports and updated the project plan as required.

Identified data anomalies and suggests data quality audits to improve data collection efforts.

Deployed hypothesis testing and exploratory data analysis techniques to identify patterns and insights to help the business take informed decisions.

Contact this candidate