AKANSHA SINGH

adhoru@r.postjobfree.com 484-***-**** https://www.linkedin.com/in/singhakansha1/

EDUCATION

University of Maryland, Baltimore County Baltimore, MD Master’s in Information Systems, GPA: 3.47/4 Anticipated Graduation: May 2020 Manav Rachna College of Engineering Faridabad, India Bachelor’s in Electronics & Communication., GPA: 3.5/4 August 2012 – June 2016 SKILLS

Languages & Technologies: Python, MATLAB, C, REST, SOAP, Agile, AWS Data Analysis: Tableau, Python, Qlik Sense, Weka, SAS, Power BI Databases: MySQL, PL/SQL, Oracle, MS SQL Server

Python libraries: Pandas, NumPy, Matplotlib, scikit-learn, Xarray Tools: Informatica, Microsoft Visio, Microsoft SSIS, MS Excel, GIT, Jupyter, Confluence, MS PowerPoint, ServiceNow, JIRA

Core Knowledge: Data Warehousing, Business Intelligence, Data Analysis, Regression Analysis Statistical Analysis, Scrum, KPIs, Dashboards, Reports, Troubleshooting Operating System: LINUX, Windows

WORK EXPERIENCE

Data Engineer, Index Analytics, Maryland-USA October 19 – till date

Imported customer data and analysed it using MS SQL Server and tableau, thus depicting monthly sales report.

Initiated weekly reporting with program development plans, increasing visibility on budget spend, prioritization, statuses using JIRA.

Produced databases, tools, queries, and reports for analysing, summarizing, and root causing board failure data. Versed in finding patterns and trends in complex, multivariable data sets.

Extensively worked on creating SSIS packages and have used for each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.

Data Engineer, Bastian Solutions Toyota Advanced Logistics Company, Kentucky-USA July 19 – September 19

Pre-processed raw data and finish exploratory data analysis using Python Pandas, seaborn, matplotlib library.

Performed multivariate analysis, predictive modelling, cluster, market basket analysis using sophisticated statistical techniques thus predicting the upcoming sales of the products.

Developed intricate algorithms based on deep-dive statistical analysis and predictive data modelling that were used to deepen relationships, strengthen longevity and personalize interactions with customers. Data Analyst, Ericsson Global India Pvt. Ltd., Noida-India August 16-July 18

Designed complex SQL queries, indexes reducing report processing time from 15 secs to 3-4 secs.

Involved in the migration of databases from SQL Server 2005 to SQL Server 2008.

Assisted to build analytic tools to manage data and streamline data analysis using Python.

Designed and optimized SQL queries, Stored Procedures, Triggers and Functions.

Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.

Designed and built statistical analysis models on large data sets (e.g., Aster, Teradata) that helped increase online sales (up to 15% per product).

PROJECTS

Location Based Life Quality Prediction in Baltimore [SQL Python Tableau] October 18-December 18

Explored relevant data from data.baltimorecity.gov like 311 requests, 911 calls, surface water stats, and, performed data pre- processing and built score index for locations across Baltimore using Pandas, NumPy & Matplotlib.

Developed a model to predict quality of life six months down the line at a given location based on assigned quality index. Designed SQL scripting for Event Management System [SQL PL/SQL] August 18- October 18

Implemented data modelling & designed databases using SQL & PL/SQL queries. Black Friday Sales Prediction/ Crime Analysis in Baltimore August 18-November 18

Predictive Data Analysis project of Black Friday sales and Crime rate in Baltimore. Data Analysis using Linear Regression and Random forest models using python libraries pandas, NumPy, matplotlib, and scikit-learn. Visualized the data using tableau. CERTIFICATIONS

AWS Certified Solutions Architect – Professional (Credential ID: RHXPZ2DKFJE1QLCP)