Data Python

VIVIDHA SINGH

781-***-**** Boston, Massachusetts linkedin.com/in/vividha-singh *******.**@*******.***

EDUCATION

Northeastern University, Boston, MA Expected May 2021

Master of Science in Information Systems

Relevant Courses: Data Management and Database Design, Data Science Methods & Tools (Machine learning), Data Warehouse Designing & Business Intelligence, Advanced Data Mgmt., Advances in Data Science, Engineering of Big Data Systems

Mumbai University, Mumbai, India May 2016

Bachelor of Technology in Computer Engineering

Relevant Courses: OOPM, Big Data Theory of Computer Science, Data Structures & File Systems, Artificial Intelligence

TECHNICAL SKILLS

Core Competencies: Data Visualization, Data Profiling, Data Modeling, Statistical Analysis, Regression, Predictive

Modelling, Qualitative Data Analysis, Data Warehousing

Programming Languages: SQL, VBA, Python, R

Business Intelligence Skills & Tools: Talend, Alteryx, Tableau, Power BI, BI Reporting, Velero ETP

Big Data Ecosystem [Apache]: Hadoop, MapReduce, HBase, Hive, Pig

Database, Storage & Cloud Services: SQL Server, Oracle 10g/11g, MySQL, MongoDB, Neo4j, Microsoft Azure, AWS S3, Athena

Other Technologies: Business Intelligence - SAP Business Warehouse, Integrated Planning, BPC, ABAP

WORK EXPERIENCE

Northeastern University Boston, United States

Graduate Teaching Assistant Jan 2021 - Present

Working individually with students who are finding difficulties in understanding Big data concepts

Helping students with their Assignments & Projects

Capgemini Bangalore, India

SAP BI Consultant Aug 2016 - July 2019

Developed self-serve insightful dashboards to track key business metrics, for stakeholders to devise new strategies & drive decision making, wrote complex SQL queries to analyze trends in consumer behavior, and to identify potential products

Migrated the system from SAP ERP to SAP HANA for unparalleled speed and access to data in real-time

Collaborated closely with Hana DBA Team for deploying the applications into production as well as validating the data

Analyzed data inconsistencies that helped deliver business insights for developing business reports

Coached 200+ end users across North America & Europe in adopting Warner Bros’ BI Planning tools

Helped support team in solving support issues in production and been a bridge between the support & development teams

Worked extensively on Data modelling and Data Warehousing, Ability to work independently and complete the task within the given time by the client with minimal supervision

Developed SAP Bex, AO, Excel Reports for reporting on the actual and planned data to answer ad-hoc queries

ACADEMIC PROJECTS

NYC Citi Bikes Big Data Analysis: (Hadoop, HDFS, Pig, Mahout) Jan 2021 - Present

Planning to load data to HDFS, employ MapReduce Algos to analyze on various parameters on Hadoop

Execute complex queries in Hive & Pig to draw conclusions and construct recommendation engine using Mahout

Big Data Architecture and Governance: (Talend, MongoDB, Tableau, Data 360, Velero ETP) May 2020 – Aug 2020

Used Talend of Big Data for data ingestion, processing and integration and loaded it to NOSQL Database – MongoDB

Connected MongoDB to Tableau to create interactive Dashboards to get insights from the big data.

E- Commerce Data Warehouse: (Python, Oracle SQL Server, Talend, Tableau AWS S3, Toad Modeler) Jan 2020 – April 2020

Generate humongous data sets using Python code in multiple formats like (CSV, XML) and loaded data to the staging area Designed a dimensional model (Snowflakes Schema) based on Business Goals & KPIs

Used Talend – Data Integration Tool to perform ETL operations (Extract, Transform & Load), Data cleansing & Integration Then delivered a unified consistent view of data from numerous sources and loaded to AWS S3 and queried on AWS Athena. Also loaded data to Oracle SQL Server, SSAS. Tableau for visualization

E- Commerce Database: (Microsoft SQL Server Management Studio (SSMS), Power BI, Toad Modeler) Sep 2019 - Dec 2019

Developed database based on mode of integration to store & manipulate data

Combined normalized data requirements into one consolidated logical database and translated the ER-Model to relational database using Microsoft SSMS. Created Functions, Stored Procedures, Triggers to increase efficiency of query processing

AWARDS

Secured First Rank in the Trainee batch in all over India after Business Intelligence (BI) Training at Capgemini.

Certified in TABLEAU DESKTOP, and Coursera certifications in DATA ANALYSIS & VISUALIZATION USING PYTHON

Contact this candidate