SUMMARY

• 4+ years of experience in Data Analysis, Machine Learning, Data mining with large datasets of Structured and Unstructured data.
• Strong skills in Machine Learning algorithms such as Linear Regression, Logistic Regression, Naive Bayes, Decision Tree, Random Forest, Support Vector Machine, K - Nearest-Neighbors, K-means Clustering, Neural networks, Ensemble Methods using Python Pandas, NumPy and scikit-learn.
• Proficient in Predictive Modeling, ANOVA, Hypothetical testing, A/B testing and advanced statistical techniques.
• Knowledge in SQL database servers, MySQL, Denodo Database Systems.
• Worked on web scrapping tools like Scrapy and Beautiful Soup in python to extract data form websites.
• Experience in R, using libraries like Stringr, tidyr,dplyr, ggplot2, data.table with R Studio
• Experience in visualization tools like Tableau, Looker and Plotly for web apps, matplotlib and seaborn in Pandas.

TECHNICAL SKILLS

• SQL
• C Programming
• Java
• HTML
• Visual Basic Scripting
• R
• Python
• MS Excel 2016
• Looker
• MS Office 2016
• MySQL
• Oracle SQL
• SDLC
• Agile
• JIRA
• HP Quality Center
• Power BI

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Newark, NJ

Responsibilities:

• Gather data using SQL queries to interpret datasets for decision-making on a daily, weekly, monthly, quarterly and annual basis.
• Provide data analyses and coordinate teh development of reports for teh Engineering Department for continual operational improvements
• Use MS Excel's various functions such as Pivot tables, VLOOKUP, Concatenate, transpose, etc. to perform extensive data manipulation on teh raw data, helped in a better, clean dataset to work with.
• Perform Data cleaning, Data analysis using R and Data visualization using Looker, helped in improving effective decision making.
• Develop dashboards in Looker to visualize teh suspicious patterns/activities in real time for business users.
• Implement topic modeling using LDA to predict teh product category of feedback and detect specific issues in each category by analyzing teh feedback collected from customer service.
• Perform sentiment analysis on customer feedback after every release.
• Create and presented executive dashboards and scorecards to show teh trends in teh data using Excel and VBA-Macros.
• Work on multiple datasets alone from data cleaning to data visualization.
• Create and maintain rich interactive visualizations through data interpretation and analysis integrating various reporting components from multiple data sources

Environment: MySQL, Hyperion, Looker, Oasis, JIRA, Microsoft Office Suit (Word, Excel, PowerPoint, Outlook)

Financial Data Analyst

Confidential, Newark, NJ

Responsibilities:

• Gather data using SQL queries to interpret datasets for decision-making on a daily, weekly, monthly, quarterly and annual basis.
• Provide data analyses and coordinate teh development of reports for teh Engineering Department for continual operational improvements
• Provide feedback directly to supervisors, managers, directors and VP concerning daily, weekly and monthly department performance metrics
• Oversee development and maintenance of data repositories, ensure successful data gathering, and validating teh accuracy of teh data prior to publication of reports
• Research and implement methods to streamline and automate manual processes
• In corporate technical skills to fulfill duties associated with financial analytics
• Financial / Data liaison between Finance team and technical team
• Experienced with handling and incorporating multiple billing systems and datasets for statistical analyses
• Generate complex reports and metrics for research and analysis from different aspects of teh business for company growth
• Adept at analyzing and modeling business process, requirements gathering and expectation management
• Perform and generate teh monthly GPM analysis report from teh Hyperion/Looker BI Tools
• Create dashboards on Looker to identify KPIs in specific regions
• Participate in Sprint meeting with Scrum team to discuss about teh latest development in product

Environment: MySQL, Hyperion, Looker, Oasis, JIRA, Microsoft Office Suit (Word, Excel, PowerPoint, Outlook)

Jr. Data Scientist

Confidential, Washington, DC

Responsibilities:

• Participate in Sprint meeting with Scrum team to discuss about teh latest development in product
• Participated in all phases of data acquisition, data cleaning, developing models, validation, and visualization using python Pandas, NumPy, Scikit-learn, R to deliver data science solutions.
• Develop models to accurately detect instances of fraud for further action using Logistic Regression, Decision Trees, Random Forest and Neural networks provided by Scikit-learn in python.
• Designed and implemented Cross-validation and statistical tests including k-fold, stratified k-fold, hold-out scheme to test and verify teh models' significance.
• Design built and deployed a set of python modelling APIs for customer analytics, which integrate multiple machine learning techniques for various user behavior prediction and support multiple marketing segmentation programs
• Validated teh machine learning classifiers using ROC Curves and Lift Charts.
• Segmented teh customers based on demographics using K-means Clustering
• Explored different regression and ensemble models in machine learning to perform forecasting
• Presented Dashboards to Higher Management for more Insights using Power BI
• Used classification techniques including Random Forest and Logistic Regression to quantify teh likelihood of each user referring
• Performed Boosting method on predicted model for teh improve efficiency of teh model
• Designed and implemented end-to-end systems for Data Analytics and Automation, integrating custom, visualization tools using R, Tableau and Power BI
• Collaborating with teh project managers and business owners to understand their organizational processes and help design teh necessary reports
• Articulating business questions and using mathematical techniques to arrive at an answer using available data.

Environment: Python, R, Tableau Desktop, Power BI, Microsoft Office Suite (Word, Excel, PowerPoint).

Research Assistant

Confidential

Responsibilities:

• Articulating business questions and using mathematical techniques to arrive at an answer using available data.
• Conducted 1 noledge sharing sessions per quarter to capture “lessons learned” and streamline teh product improvement process.
• Collected monthly data of customer behaviors on securities trading application and analyzed page conversion rate by drawing Sankey diagram using Tableau.
• Made optimization on page priority and button layouts. Improved application efficiency from 46% to 55%. Clustered customers into 10 groups based on purchase history data by K-Means using Python(scikit-learn). Helped department director filtrate 15% inactive customers
• Designed a customer-based recommendation system on securities trading application based on user browse and click history by Python.
• Collaborated with a team of 6 on reporting performance of teh app based on Power BI charts to department director

Data Analyst

Confidential

Responsibilities:

• Implemented SQL queries to get teh segmented data from teh database by cleaning and massaging teh data to create data dashboard views and designs
• Analyzed teh data in Tableau to develop teh business insights
• Handled challenging responsibilities in organizing and prioritizing tasks to work proactively
• Collaborate with teams and leaders across teh company to develop new strategies for decision-making
• Ensured delivery of project and adhere to agile methodology
• Generated teh weekly deviation reports check teh health of teh business
• Involved in teh entire System study, Analysis, Design and Support.
• Worked on data analysis by using SQL Developer and Excel.
• Wrote and executed SQL scripts, Stored Procedures to develop reports and perform data/report validation and execution.
• Designing, developing, testing, and maintaining Power BI reports and dashboards based on user requirements.
• Creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.

Environment: Tableau 8.0 Desktop, Power BI, Oracle8.0. SQL Developer, Microsoft Office Suite (Word, Excel, PowerPoint).