Data Science Intern Resume CA - Hire IT People

SUMMARY

Data Analyst with 3+ years of experience in analyzing and interpreting large datasets into actionable insights. Proficient knowledge in using analytics and statistics to effectively leverage company's raw data to inform strategic decision - making. Flexible and willing to Relocate

TECHNICAL SKILLS

Analytics: Tableau, Thought Spot, Spotfire, Looker, Google Analytics, IBM Watson Analytics, Omniture, R, Micro Strategy, PowerBI

Databases: MS Sql Server, Oracle Sql (DML, DDL), MySQL, Teradata, Business Intelligence Developer Studio, SSIS, ETL concepts

ERP: SAP, Salesforce

Technical: Excel(Advanced) ANOVA, Visual Basic(VBA), Data Mining, Visio, Adobe Illustrator

Project Management: Scrum for Agile SDLC, Waterfall, Microsoft Project, Jira, Confluence, Kanban

Interpersonal: Excellent communication skills (Verbal & Written), Result oriented, Self-Starter, Quick learner, Excellent team player

PROFESSIONAL EXPERIENCE

Data Science Intern

Confidential, CA

Responsibilities:

Collected, cleansed and provided modeling and analyses of structured and unstructured data (approx. 5 Million records) used for major business initiatives using R and advanced SQL queries
Conducted statistical analysis, data mapping and preprocessing to find various trends and pattern in the data and generate meaningful business insights about customer’s usage, revenue generation during different time frames using R and Excel
Developed KPI’s and interactive dashboards using BI Tools like Tableau, Ggplot2, Excel to help management to concentrate on various customer segments based on revenue
Used statistical techniques for hypothesis testing to validate data and interpretations
Automated existing reports, reducing preparation time over 50% by deploying new procedures and technique
Generated various ad-hoc projects for different business areas for stakeholders and customers for revenue analysis

Business Data Analyst

Confidential

Responsibilities:

Interacted with stakeholders for business requirements gathering and translating them into technical specification documents
Involved in in predicting cost variation for different products based on effect of different variables using predictive algorithms like Regression based in historical data
Used advanced MS Excel to make Pivot table and charts to create visualizations of product trends
Refined the existing use cases and developed new workflow-based systems for project planning and development
Designed and developed cost management system using MS Access to track and store current and historic pricing trends
Developed Key Performance Indicators and scorecards to monitor product sales and operations of vendors and fulfillment centers.
Produced annual saving of $150,000 by close analysis of process, identifying gaps and suggesting improvements and process
Produced routine reports for business users by querying Teradata for taking business and process decisions
Liaised between customer and internal departments to create project progress and planning reports, utilization , sales volume reports