Data Analyst Resume
New York, NY
OBJECTIVE
- Highly motivated individual seeking a full - time/Contract opportunity in an organization where I can apply my knowledge and skills, that serve as a springboard to move ahead in my career by providing me interesting career opportunities and harness the best of my caliber.
SUMMARY
- Strong knowledge and good practical experience in Data Modelling, Database Design and SQL Development.
- Hands-on experience on data processing and flowchart technique.
- Excellent understanding of databases and its implementation.
- Experience on implementing business logic using Stored Procedures, Functions, CTE and joins.
- In-depth knowledge on SQL reporting, analytics, and business intelligence.
- Able to work with SSIS Transformations for Fuzzy Lookup, Data Conversions and Data Cleansing Activities.
- Designed different custom dashboards for various user groups based on their business functionalities and needs.
- Efficient in designing Dashboards and Map Reports with SSRS.
- Maintained and populated configuration workbook.
- Provided production support to tableau users and wrote custom SQL to support business requirements.
- Create and execute UAT test scripts and strategies and document results.
- Maintain compliance with Discovery’s Software Development Lifecycle documentation and mandated compliance requirements for all application changes.
TECHNICAL SKILLS
Computer Languages: C/C++, Python
Web Technologies: HTML5, JavaScript.
Databases: MySQL, MSSQL Server.
Tools: MSOffice, MS Excel (Pivot Tables, VLOOKUP), Tableau, Power BI, ETL, Apache Spark
Business Skills: SDLC, Scrum/Agile Development Methodologies, Team Management
Gathering, Documentation, familiar with ITIL foundations and processes: Experience with Lean principals and methods.
Operating System: Linux, Windows, Ubuntu
PROFESSIONAL EXPERIENCE
Data Analyst
Confidential, New York, NY
Responsibilities:
- Designed new queries and utilized existing query models to draw relevant customer information for development of financial reports utilized in forecasting, trending, and result analysis.
- Manipulating, cleansing & processing data using Excel, Access and SQL.
- Responsible for loading, extracting and validation of student Data.
- Analyzing raw data, drawing conclusions & developing recommendations.
- Creating dashboards, reports and trend analysis using Power Pivot and Tableau on Agile methodology.
- Performing daily system checks: data entry, data auditing, creating data reports & monitoring all data for accuracy.
- Designing, developing, and implementing new functionality.
- Monitoring the automated loading processes.
- Advising on the suitability of methodologies and suggesting improvements.
- Carrying out specified data processing and statistical techniques.
- Supplying qualitative and quantitative data to colleagues & clients.
Technologies: MS Excel, MS Office Suite, MY SQL, Power Pivot, VLOOKUP, Tableau
Confidential
Machine Learning Data Associate
Responsibilities:
- Worked on Confidential 's versatile digital assistant "Alexa" in improving its efficiency and in performing all the tasks to provide a valuable customer end quality.
- Data creation, curation, and analyzation to develop, test, and train the Alexa AI performance and analyze the cloud data performance in the Alexa enabled devices.
- Worked closely with internal customers like Machine Learning Science modeling teams, providing the critical data they need to improve Alexa's Automatic Speech Recognition and Natural Language Understanding models and domain features.
- Provided Process related support tasks like metrics management, process deep dive and improvement projects.
- Responsible for advanced calculations to draw conclusions about data findings.
- Used Tableau to build and publish customized interactive reports, data visualizations, and executive level dashboards that are in support our development team operations.
- Presented detailed reports about the meaning of gathered data to members of management and help them identify scenarios utilizing modifications in the data.
- Responsible for two Alexa enabled devices - "Fire TV" and AOT (Alexa on tablets) data quality and its efficiency and driving all the associates successfully with 96% of data accuracy.
- While working for my primary client location, I was involved to support for 4 other different client locations.
Technologies: MS Excel - Pivot tables, VLOOKUP, MS Office Suite, Tableau, Confidential Data Services Software, Data Analysis using MySQL, SQL, CRM
