Data Analyst Engineering

NEHA KHAN

Email: ****.**@*****.***.*** +1-509-***-**** https://www.linkedin.com/in/nehakhan9

Actively Looking for Full Time Opportunities as a Business Analyst Data Analyst and ETL Developer immediately EDUCATION

Northeastern University, Boston, MA Jan 16 – Dec 17 Master of Science in Engineering Management

Relevant Courses: Data Warehouse & Business Intelligence, Database Management & Database Design, Data Collecting, Storing and Retrieving, Data Mining, Probability & Statistics, Economic Decision making B.M.S College of Engineering, India Sept 09 - July 13 Bachelor of Engineering in Telecommunication Engineering SKILLS

Languages: SQL, R

BI Tools: Tableau, Microsoft Power BI, Qliksense, PowerPivot Data Warehousing Tools: Talend, SSIS, SSAS, SSRS, Toad Data Modeller Tools: Microsoft, R studio, Hadoop, Microsoft Office, MS Project Database Tools: SQL server, MySQL, Microsoft Visual Studio, PostgreSQL, SQLite, Mongo DB Data Analysis: Web Scraping, Statistical Modelling, Hypothesis testing, Predictive Modelling Data Mining Algorithms: Decision Trees, Clustering, Random Forest, Regression PROFESSIONAL EXPERIENCE

E.F Johnson Company – Dallas Feb 18 - Present

Pricing Data Analyst

Collaborated with Stakeholders and cross functional teams to elicit, elaborate and capture functional and non-functional solutions.

Translated business requirements to technical requirement and created solution design compliant with two way radio systems.

Generated Quarterly reports and collecting data from multiple data sources to produce competitive pricing for new systems.

Utilize visualization skills to build interactive dashboards, communicate data insights to business users to make actionable decisions. MassDevelopment - Boston May 17 – Aug 17

Data Analytics Intern

Developed, Streamlined CRM database and built SQL queries for data analysis of 1 million + records.

Generated New Market and Investment Banking reports by using SSRS and increased the efficiency by 50%.

Introduced Power BI, designed dashboards for time based data and improved performance by 40%.

Build ETL workflows for automated reporting of Investment Banking data and reduced the workload by 40%.

Migrated reports from Excel platform to Tableau and automated the reports.

Visualized finance data using Tableau and forecasted future trend of the project amount. Green Edge Technologies - India Feb 14 – Dec 15

System Engineer

Generated energy consumption reports using SSRS which showed the trend over day, month and year.

Performed ad-hoc analysis and data extraction to resolve 20 % of the critical business issues.

Well versed in Agile SCRUM development methodology which was used in day to day work in application for Building Automation Systems (BAS) development.

ACADEMIC PROJECTS

Northeastern University, College of Engineering, Boston, MA Predicting Area Under Fire in Forest with Multiple Linear Regression - Aug 17 – Dec 17

Performed Descriptive Analysis to find correlation between predictor and response variables using scatter plot matrix and built linear regression models and compared accuracy of models to select best regression model.

Predicted area under fire in forest for test data by performing regression diagnostics to interpret results and visualized models. Adventure Works Data Warehouse Purchasing - Jan 17 – April 17

Integrated data from Adventure Works 2014 to load into Adventure Works DW purchasing using Talend integration tool and SSIS from MSSQL 2014 to MySQL involving complex mapping between fields and transformations between data.

Used Talend Integration tool and SSIS to perform Slowly Changing Dimension of type 2 and wrote queries to validate the row counts.

Created dashboards using Business using Power BI, Tableau to answer the business questions related to sales. Cellular Service Provider - Sept 16 – Dec16

Designed a database and implemented the stored procedure views, entity relationship diagram enabling excellent customer service via the online website and extracted and integrated their data using SSIS from CSV files.

Contact this candidate