Data Analyst Resume
SUMMARY
- 2.5 years of extensive expertise in Business Data Analytics, which include Responsibilities of BA, Requirements Gathering, Business Process Modelling / Mapping, Data Definitions and Lineage, UML Diagrams, Visio, Flowcharts, Agile, Sprint Planning, User Stories, Documentation and Knowledge Transfer.
- Leveraged deep technical understanding in SQL (8/10), Python (8/10) and Tableau (8/10) to solve business problems in the field of Operations, Finance, Supply Chain Management, Real Estate, Marketing and Health Care.
- Flexible and Self - Motivated team player with the ability to learn and grow in a fast-paced domain
TECHNICAL SKILLS
Languages: Python, C, C++, C#, shell scripting
Data Analysis: Python, R, MS Excel, SAS, STATA, SSAS
Data Visualization: Tableau, Python, MS Excel, SSRS, Power BI, R, SAP Lumira, MS PowerPoint
Database: PostgreSQL, MySQL, SSMS, MongoDB
Machine Learning: NumPy, Pandas, Keras, Sci-kit learning, ANN, CNN, Regression, Classification, NLP, SVM, SGD, Linear Regression, Logistic Regression, Recommendation Engine, Feature Extraction, Sentence Classification, Multiclass Prediction
Soft Skills: Effective communication skills, Problem-solving, Teamwork, Critical Thinking, Adaptability, Willingness to learn
Tools: PyCharm, Jupyter Notebook, R Studio, Visual Studio, IBM Urban Code Deploy, Confidential Process Studio (RPA), TFS, Jenkins, MS SharePoint, SSIS, Teradata, Snowflake, Hadoop, HBASE, Spark
PROFESSIONAL EXPERIENCE
Data Analyst
Confidential
Responsibilities:
- Instrumented a Smart AI Chatbot (Bob) to achieve precise search with recommendations and 24/7 customer support. Collected and Analyzed business process models and implemented DMBOK practices to build dataflows.
- Collected a large amount of customer data from legacy systems, www, search results, emails and phone conversations. That resulted in process modeling, improving the chat experience and supply and demand forecasting.
- Performed Feature Extraction, Sentence Classification, Multiclass Prediction, NLP, CNN to obtain 82% accurate responses. 90% of the audience voted that they received 80% correct answers from Bob.
- Worked alongside project owner and design team from ideation to presentation. Created a Business Catalog.
Business Analyst
Confidential
Responsibilities:
- Achieved 50% reduction in time by automating the reporting procedure, developed 15 Batch processes (VBA, PowerShell) along with Macros (MS-Excel). Delivered Weekly, Monthly, Quarterly Reports to the Executive Leadership.
- Migrated the reporting process to Tableau and Power BI for rich visualizations, developed and monitored customerfocused KPIs, hands-on experience in presenting interactive charts, annotated dashboards and time-series trends.
- Created and executed complex, highly optimized SQL queries by introducing indexes, partitions, recursive CTE’s and window functions, thereby reducing database load and query retrieval time.
- Built end-to-end ETL pipelines using SSMS, SSIS, SSAS, SSRS and proficient in PostgreSQL, MySQL, SQL Server.
- Introduced RPA to the team, gathered requirements from the client, implemented one-click application feature testing that reduced human effort and errors to 0% and documented the procedure according to client specifications.
- Orchestrated Hassle-Free Management of day-to-day operations through JIRA stories, ServiceNow and Scrum calls.
- Expert Point Man - liaised with Release Management, Change Management, Application and Server teams to accomplish 12 Environment refresh, 45 Fully Automated Prod & Non-Prod deployment and monthly patching activities.
- Analyzed large in-house data (TBs) to find business gaps and scope for improvement using Python and MS Excel.
- Proficient in all stages of SDLC referring to Requirement Analysis, Design, Implementation, Testing and Operations.
- Accomplished high-priority BAU activities in a cross-functional and cross-domain environment. Summarized and Documented actions, communications and workarounds.
- Performed RCA of day-to-day operations and found that unplanned plant down time caused by improper planning, maintenance delays, warehouse mismanagement and inexperience work force has reduced plant efficiency.
- Plant efficiency can be increased by 50%, If the time spent on pre-planning of maintenance is doubled, hiring expert labor and implementing Just-In-Time Inventory Management
- Predicting and Influencing Health and Wellness of Real time SRG Survey data
- Built a model that clusters consumers who associated with health and wellness based on their physical and psychological attitude.
- Profiled each market segment, predicted health and wellness, and provided measurement of people healthiness in different dimensions using Python and SAS.
- Visualized and narrowed down different parameters that affect the price surge in different areas of Boston such as temperature, time of the day, day of the week, number of drivers in the area, etc. and was able to answer questions such as ‘Does distance affects the Average Surge Multiplier?’
