Data Analyst Resume
NY
SUMMARY
- Data Scientist/Analyst enthusiast with experience in interpreting and analyzing data for driving business solutions. Proficient knowledge in Statistics, mathematics, and analytics. Excellent understanding of business operations and analytics tools for effective analysis of data.
- Data Scientist/Analyst professional with around 6 years of diversified experience in Data and Business Analytics, Statistical Modeling, Visualization, and Machine Learning. Excellent capability in collaboration, quick learning, and adaptation
- Experience of working in different roles like Data Scientist, Data & Business Analyst.
- Good working knowledge of Software Development Lifecycle (SDLC) - Agile and Waterfall Methodologies
- Experienced in Python modules/libraries such as NumPy Pandas, SciPy, Visualization etc. for generating complex graphical data, creation of histograms etc. Used Python scripts to update the content in database and manipulate files.
- Experience Object Oriented programming (OOP) concepts using Python.
- Experienced in working with various Python Integrated Development Environments (IDE) like IDLE, Jupyter and VS Code.
- Hands-on experience in Data Analytics spanning from Statistics to Programming including data engineering, data visualization, machine learning and programming in Python, SQL.
- Strong working experience on several python packages like NumPy, SciPy etc.
- Highly motivated, quality minded professional, with proven ability to deliver applications against tight deadlines.
- Possess good interpersonal, analytical presentation Skills, ability to work in Self-managed and Team environments.
TECHNICAL SKILLS
Data Skills: Python - NumPy, Pandas, scikit-learn, matplotlib, PySpark, Hadoop, MS SQL, MySQL, PostgreSQL, Power Pivots, Power Query.
Tools: MS SSIS, MS Access, Tableau, MS Power BI, Hortonworks Data Platform, MS Project, MS Visio, Excel, SAS Enterprise Miner, Jupyter Notebook, Azure MLS, Azure Blob, MS Visual Studio, GIT.
WORK EXPERIENCE
Confidential, NY
Data Analyst
Responsibilities:
- Incident and problem management, coordinating resolution of data movement disruptions.
- Capacity analysis and planning for a sizable application server environment. Performance metering and tuning for application servers, database, monitors and alerts.
- Risk identification and evaluation, managing and improving upon internal controls which mitigate risks.
- Data collection procedure enhancement to include information that is relevant for building analytic systems processing, cleansing, and verifying the integrity of data used for analysis.
- Building analytic models using a variety of techniques such as logistic regression, risk scorecards and pattern recognition technologies
- Involved in analysis of Business requirement, Design and Development of High level and Low-level designs, Unit, and Integration testing. Interacted with the other departments to understand and identify data needs and requirements.
Confidential - Dallas, Texas
Data Scientist
Responsibilities:
- Used Python packages for the building Machine Learning models
- Performed exploratory data analysis using pandas and NumPy packages in Python 3. x.
- Designed and completed Tableau dashboards to illustrate analytical results of dataset.
- Used Scikit-Learn to develop classification algorithms such as Logistic Regression,
- Random forest, support vector machine models that help in decision making.
- Used Scikit-Learn to develop regression algorithms such as Linear Regression, Decision Tree,
- Random Forest, K means Clustering models that help in decision making.
- Performed data pre-processing and feature engineering for further predictive analytics using Python.
- Boosted the performance of regression models by applying polynomial transformation and feature selection.
- Generated report on predictive analytics using Matplotlib and Seaborn including visualizing model performance and prediction results.
- Worked in Power BI environment to create weekly, monthly, daily reports and publish them to server.
- Evaluated performance of classification algorithms such as Logistic Regression, Decision trees and Random Forest using Pandas and Scikit-learn using k-fold cross validation.
- Built web scrapers using Scrapy to reduce data retrieval time by 30%.
- Slashed analysis time by 15% by building custom python libraries for categorical data EDA, data ingestion into MS SQL databases and data visualization.
Confidential
Data Analyst
Responsibilities:
- Automated the data entry process of remit information in the company software which will save 2 hours of manual entry using python.
- Collected and processed clinical data from 7 ERs to generate clean dataset which saved 16 hours of manual work each week and presented the insights for senior executives to decide on decreasing the logistic costs (MS SSIS, SQL, Tableau, and Excel).
- Eliminated wait time for scheduled reports by 25% by performing ad hoc analysis to formulate insights as needed using Tableau.
- Reported bi-monthly data analysis ndings to upper management to use in making organizational decisions.
Confidential
Sr. Analyst/ Power BI Developer
Responsibilities
- Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
- Created, extracted data from multiple sources and prepared Incidents and Request Management reports and Dashboards in PowerBI Desktop, that gives various information on Status of the tickets & is shared across team to ensure tickets are updated/resolved on daily basis and to quickly analyze data & help to make better decisions.
- Extracted data from multiple sources like CSV/SQL Server 2012/AZURE SQL DB through Power BI for creating Dashboards/ Reports.
- Performed data analysis, identified, and solved stakeholder issues by creating real-time visualization dashboards in PowerBI Desktop across six technology towers and improved the overall efficiency of various teams.
- Managed over 150000+ Incidents/Requests per year, maintaining a resolution rate of 50-70% and SLA compliance rate of over 92%.
- Developed the Data model in the form of Star Schema, designed structure and relationship between fact and dimension table for end users to have in and be able to create their own Self BI Reports.
- Created Dax Queries to generate computed columns and Measures for the Power BI Dashboards to transform the unstructured data into useful data for the business users.
- Involved in creating new stored procedures and optimizing existing SQL queries and stored procedures.
- Proactively monitored, determined, and solved issues at SQL/database/server levels and addressed any queries related to MS Excel and PowerBI.
Environment: Power BI Desktop, Azure SQL Database, SQL Server 2012, MS SQL Server, Advance Excel, SQL.
Confidential
Technical Data Analyst
Responsibilities
- Investigated, analyzed, and provided technical solutions through RTS to clients and IBM technical personnel on multiple products and environments across several platforms.
- Resolved all level 1 & 2 requests in a timely manner and to customer satisfactions and coordinated with various teams to reduce resolution time by 25% for high severity tickets with issues related to servers and networks.
- Designed and developed IBM Cognos graphical and visualization solutions for creating interactive dashboards that gives various information on applications and Incident status and ensured that the team achieves the defined performance targets and SLA.
- Created internal dashboards for team members using SharePoint list and created forms using InfoPath and created workflows using SharePoint designer.
- Identified several gaps in the process of reporting, proposed and implemented various initiatives to ensure consistent and timely completion of projects.
- Eliminated manual reporting by automating the process of fetching data of each cost center from large data sets. Additionally, developed internal websites and created tailored reports for various internal and external stakeholders using SharePoint and other reporting tools.
- Spearheaded multiple team training sessions on Lotus Notes mail client, Linux, and Windows 10 Operating systems.
- Awarded 'Stack Rank 1' for reducing resolution time for KVM Malfunction issues by 92%.
