Data Analyst - Global Market, Intern Resume Boston, MA - Hire IT People

TECHNICAL SKILLS:

Analytics: Predictive Modelling, Text Analytics, Regression, Clustering, NLP, Neural Net, Random Forests, Deep Learning

Big Data: Hortonworks Apache Ambari (Pig, Hive, Spark, Hadoop, Map Reduce), TensorFlow, Cloud (AWS, MS Azure)

Data Integration / Warehousing: ETL (Extract - Transform-Load) Framework - Talend Studio, SSIS

Databases: MS SQL Server (TSQL), Postgres SQL, Oracle (PL/SQL), MySQL

Data Visualization: Tableau, Qlikview, Power BI

Statistical Analysis: R (dplyr, tidyr, ggplot, rvest), Python (Numpy, Pandas, Scikit-Learn, Plotly, Cufflinks, Matplotlib, Seaborn), Jupyter Notebook

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Data Analyst - Global Market, Intern

Responsibilities:

Conducted analysis of product offerings for business development to evaluate progress against established goals
Documented strategic objective and rationale of project including relevant NBPRA’s and regulatory filings as required
Coordinated meetings with relevant stakeholders, documenting minutes, approach and action items requiring follow up
Developed financial proforma for project and spend vs plan reports, assisted in business requirements for IT development
Created visualization dashboard on Tableau for budget and resource allocation of workforce for onboarding of new hires
Improved scope of business management by changing project management reporting to MS Project from MS Excel
Generate periodic status updates to reflect implementation progress, project risks and issues requiring escalation
Analysed SSGM business documents to manage clients for applying regulatory changes, margin requirements, fiduciary rules

Confidential

Data Analyst

Responsibilities:

In a client facing role, analysed network coverage data to identify the areas of weak signals using regression model against call volume and signal strengths, hence improving the deliverable turnaround by 8% and improved SLA’s and network coverage
Developed visualization reports on Tableau to correlate site serving areas and standard issues to analyse network availability
Performed descriptive analytics on call data to determine KPI’s using reports created in Tableau, with a focus on action-ability
Conducted cluster analysis on customers complaining about the same issue indicating that the issue was prevalent in the network
Performed Data Usage trending and analytics by Consumer Application Categories, Genre, Top Applications and Hourly Usage
Worked on data validation and data quality issues by writing complex SQL queries and tested them
Gathered requirement from department and mapped the data to the warehouse using custom SQL scripts and schema design
Worked closely with business stakeholders to understand, document and analyze network source systems
Trained 10 new employees through on job training, mentoring and team building, reducing their onboarding time by 30%
Recognized with ‘Power Award’ for implementing a query-based tool, resulting in increased scope and reduced alarm flow
Scraped 450,000 tweets and financial data using web REST API’s from stock discussing twitter profiles and finance portfolios
Created predictive model in R studio and evaluated results using SVM and Naïve Bayes, achieving 55% prediction accuracy
Used python for linear and logistic regression, clustering (K-means & PAM) algorithm to obtain analysis and data insights
Performed classification of data to draw conclusions and fit of the various attributes for predictive modelling
Built a recommendation framework using python, ambari hortonworks to suggest movies to the users based on ratings
Used pandas, matrix pivoting, hive query to build and check model on content-based user behaviour to recommend a movie
Optimized mappings, data integration in ETL (Extract-Transform-Load) tools, source to target mappings, datatype translation
Designed ETL packages dealing with SQL Server and Flat Files sources; performed different transformations using SSIS
Implemented SCDs to maintain history of records and currency rate transactions from the data lake for migration and reporting

We provide IT Staff Augmentation Services!

Data Analyst - Global Market, Intern Resume

Boston, MA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship