Data Analyst

OJAS SAMEEP PHANSEKAR

617-***-**** adcnwy@r.postjobfree.com linkedin.com/in/ojasphansekar/ github.com/ojasphansekar Education

Northeastern University, Boston, MA Sep 2017-Dec 2019 Master of Science in Information Systems

Relevant Courses: Advance Database Management, Data Warehousing, Business Intelligence, Business Analysis, Advance Data Science, Machine Learning in Finance

Mumbai University, Mumbai, MH, India Aug 2011-Jun 2015 Bachelor of Engineering (B.E.) in Electronics

Professional Experience

National Grid PLC, Waltham, MA

Data Management Specialist Internship Jan 2019-Aug 2019

• Analyzed and provided insights on data reports using Python which helped in saving time while creating new data reports

• Created SSIS packages by performing Data Integrations and Transformations and loaded data into ODS

• Developed SQL Queries and published data reports on Datahub by establishing connection to reports using SSRS

• Designed a Logical Data Model for the Workorders and Leaks on Sparx Enterprise Architecture

• Improvised the Accuracy of Data by performing Data Validations and also carried out Data Conversions on SQL Server

• Created dashboard on Tableau and provided meaningful analysis which helped in reducing Duplication of Report Creation Tech Mahindra, India

Data Analyst Aug 2015-Jul 2017

• Developed dashboards on Splunk Cloud (Splunk Enterprise) to enhance the method of finding the fault systems at a quick pace, reducing error identification time by 50%, thereby helped VHA to improve customer experience

• Visualized data and pulled off meaningful analysis on Splunk Cloud using queries in the form of self-explanatory graphs

• Fulfilled business requirements by acknowledging requests for updating records on Oracle 10g database using SQL

• Managed incidents, change requests and carried out root cause analysis for the various defects raised Northeastern University, Boston

Designing of Enterprise Data Warehouse and Data Integration (SSIS, Talend, Tableau, PowerBI)

• Designed a physical data model on Toad Data Modeler, generated DDL scripts for MySQL, Oracle, PostgreSQL, MS SQL server, built a data mapping document, carried out data mappings and data integrations using SSIS and Talend

• Optimized run time for creation of data warehouse using techniques like parallelization, serialization, performance tuning

[17 mins - best in the class of 80], memory management

• Developed interactive visualization dashboards which helped in gaining valuable insights from sales with the help of Tableau and Microsoft Power BI for business requirements Employee Payroll Management System (PL/SQL)

• Created a Pluggable Database (PDB) inside a Container Database (CDB) in SQL*Plus to support Payroll application

• Implemented Reference, Explicit and Implicit cursors in combination with functions and stored procedures and also handled pre-defined exception and user defined exception

• Used Relational, Inline and Materialized Views to solve application based questions Telecom Service Provider (SQL, Data Modeling)

• Designed a database in MySQL Workbench using ER diagrams and established relationships between various entities

• Implemented views, triggers, transactions and functions to solve the purpose of an effective database Zillow Home Value Prediction (Python)

• Conducted exploratory data analysis, data preparation, built and compared the Zestimate efficiency with LSTM, xgboost and random forest algorithm

• Predicted and reduced log error of Zestimate by 3%, by researching on various optimizers, activation and loss functions Skills

Programming Languages : SQL, PL/SQL, NoSQL, Python, Java Databases : MySQL, MS SQL Server, PostgreSQL, Azure SQL, Oracle19c, Spark SQL, MongoDB Data Visualization Tools : Tableau, Microsoft PowerBI, Excel Data Modeling : Toad Data Modeler 6.3, Sparx Enterprise Architecture Data Integration (ETL) : SQL Server Integration Services (SSIS), Talend, SQL Server Import Export Wizard, Tableau Prep Other Tools

: Jupyter Notebook, Salesforce, Agile Craft, Atlassian Jira, Splunk Enterprise, Informatica, SSRS, AWS [S3, EC2, DynamoDB, Redshift] Academic Projects

Contact this candidate