Sign in

Data Analyst

Boston, MA
January 06, 2020

Contact this candidate



Boston, MA ***** 857-***-**** EDUCATION

Master of Science (MS) in Information Systems, Northeastern University, Boston, MA Aug’17 – Dec’19 Graduate Degree, Computer Applications, Veer Narmad South Gujarat University, India Jul’16 – Apr’17 Bachelor of Science (BS), Computer Applications, SDJ International College, India Aug’13 – Feb’16 PROFESSIONAL EXPERIENCE

Northeastern University, Boston, MA (Graduate Teaching Assistant) May’18 – Dec’18 / Sep’19 – Dec’19 Responsible to teach Data warehouse and Business Intelligence conceptually and practically to graduate students

• Coaching 50 grad students to Integrate data from different databases such as Azure, Oracle, PostgreSQL, SQL, SSMS using data integration (DI) tools like Talend, SSIS, Alteryx and helping students to create dashboards to visualize data on reporting tools like Tableau, Microsoft Power BI, QlikSense, SPSS, Google Analytics Qcentive, Boston, MA (Healthcare Data Analyst) Jan’19 – Aug’19 Set-up business requirement for maternity healthcare module, verified product roadmap checklist before each release, ensured product quality by regression testing, user acceptance Testing, PHI data quality validation with the QA team

• Queried 53 SQL views for client data dictionary to provide SaaS specific centralized database repository

• Performed weekly gap analysis by refining PHI data using MS Excel (pivot table) & SQL Server

• Formulated end-to-end maternity module by creating 10 screen mockups and verified back end data

• Diagnosed and documented ~100 defects tracking by performing regression, API, data accuracy, UAT testing Mahesh Textile, Gujarat, India (Business Intelligence Analyst) Jan’17 – Aug’17 Engineered structured and unstructured datasets into EDW, build Tableau dynamic dashboards and ad-hoc reports to drive business operations like ROI, KPIs, marketing analysis, cost reduction, seasonal production cycle

• Fashioned a centralized data warehouse by integrating data from OLAP cubes, data-marts, Excel file into Oracle

• Developed a suite incorporating customer feedback, complain section to enhance 6% CRM growth opportunity

• Evaluated customer feedback, suggested changes, reduced customer attenuation rate by 11% in 2 quarters

• Reduced inventory cost by 13% by revising the production cycle using market and seasonal trend analysis SKILL HIGHLIGHTS

ETL/BI : SSIS, SSAS, Alteryx, Tableau, Power BI, Excel ( VLookups, PowerPivot, Macros), Adobe Analytics Database/Tools : SQL Server, Oracle, R, Python, Spark, SAS, HiveQL, Microsoft Excel, Powerpoint, AWS, Word Machine Learning : Statistical Analysis (EDA), Regression modelling, Hypothesis testing, SVM, Naïve Bayes Programing skills : C, HTML, CSS, Javascript

Workflow : Agile Methodology, SAFe framework, Confluence, Jira Relevant Skills : Business analysis, Data Modeling, Project Management, Data Analytics, Data Engineering ACADEMIC PROJECTS

Credit Card Fraud Detection (Python) Sep’18 – Dec’18

• Trained data model to achieve maximum accuracy for detecting credit card fraud using jupyter notebook

• Implemented Random Forest algorithm on undersampled/oversampled (SMOTE) data that gave 94% precision

• Used discrete classifiers to compare accuracy of the model and concluded logistic regression gave 98% accuracy Data Integration and Visualization (SSIS, Tableau) Jan’18 – Apr’18

• Built ELT Job on SSIS to integrate data from MySQL, Azure into EDW on SQL Server using source-target mapping

• Designed dashboards from EDW in Tableau to track Sales, revenue, production, KPI’s, top products & customers

• Rectified errors in Talend jobs by comprehending the back end java code and identifying the root cause Travel Agency Database Management system (Microsoft SQL Server) Aug’17 – Dec’17

• Generated a DBMS on SSMS to optimize data consistency, referential integrity for a travel agency using CRUD

• Incorporated certain Procedures, Functions and Views for efficient data and information retrieval

Contact this candidate