Data Analyst Resume
SUMMARY:
- 2 + years experienced Data Analyst in with exceptional skills in SAS, Microsoft Dynamics, Data Visualization and Reporting, Database Development and Analysis.
TECHNICAL SKILLS:
Tools: and Technologies: Tableau, SAS (SAS/BASE, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/ODS), SAP Business Objects, SQL Server Management Studio, Hadoop, Hive, Informatica, Microstrategy,, RStudio, SAP MS Office (Word, Excel, PowerPoint), MS Access, MS SharePoint, HTML 5,Jira
Development/Testing Tools: - Visual Studio, Notepad++, JUnit
Languages: - R, SQL, UML, XML,, C++, JAVA, CSS, JavaScript, JQuery, PHP, C++,, Vb.net, C#, Json, Tcl, Python, R, Matlab, CSS, JSS, SAWscript,, ACL 2
Operating Systems: like MS DOS, Windows 95/98/NT/2000/XP/Vista/7/8/10, Unix, Worked on Mac Os, Linux and Microsoft Operating systems
Databases: RSQLite, MySQL, MongoDB, MS SQL SERVER
PROFESSIONAL EXPERIENCE:
Data Analyst
Confidential
Responsibilities:
- Assisting IT department to deliver quality solutions.
- Worked with all areas of Winsupplyas needed to gather requirements for enhancements to existing solutions or gather requirements for brand new solutions including software solutions, processes and implementations.
- Gather, analyze, and assimilate requirements into a format easily understood by end users and programmers.
- Creating,maintaining existing code,ad hoc reportingand supporting the reporting functions for Project Information Management tools like Informatica.
- Worked with macros to determine the type of products, to be labelled before implementing in MDM database and e-Commerce website.
- Involved in Data Collection, Analysis and Visualizations for Clients during new product development and implementation stage with experience in end to end project management.
Data Analyst
Confidential
Responsibilities:
- Analyse Market Research Survey Data and performed market research and segmentation analysis for clients using SAS, R Studio, SQL and Excel, get the potential target customers and identify the market trend and opportunities.
- Conducted business user workshops, data analysis and data compilation and reporting of data for clients with different SAS environments,and integrating with different reporting tools including Tableau, Power BI, Business Objects.
- Involved in designing, building, maintaining and troubleshooting daily, weekly, and monthly reports and dashboards tools like Tableau or Power BI and scheduling them to run at specific time.
- Hands-on experience in creating solution driven dashboards by developing different chart types including Crosstab, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop.
- Involved in developing code to clean and validate data collected from multiple data sources like SQL server, MySQL, Flat files (Excel, CSV, TSV) and Access Database.
- Experience in data mining, data modeling using R, SAS ETL to further perform statistical tests (hypothesis testing) on the mined data.
- Developed comprehensive reports based on marketing, sales trends, and demographic data analysis.
- Created complex and reusable Macros and used SAS and R functions for Data Cleaning, Validation
- Created technical documentation and presented information to senior management including ad-hoc analysis and reporting as per user requests for managerial meetings and discussions.
- Perform predictive modeling on the data we receive on yearly basis to understand the customer behavior.
- Managed and developed reports that aligned and simplified monthly business reviews, annual planning, and forecasting processes. Created technical documentation and presented information to senior management including ad-hoc analysis and reporting as per user requests for managerial meetings and discussions.
