Business Intelligence Analyst Resume Fall River, MA - Hire IT People

SUMMARY:

Business Intelligence professional with over 5 years of experience working independently and in collaboration with cross functional teams to deliver high quality data - driven results.
Experience in building interactive KPI dashboards to identify trends in the data from multiple data sources
Expertise in Statistical analysis, Project Management and Predictive analytics.
Highly proficient in Tableau, Python programming and SQL

TECHNICAL SKILLS:

Tools: Python, SAS Base, SAS (JMP, EG, E-Miner), Microsoft Azure, Oracle, SQL, MySQL, SSRS, MS Excel, MS Access, IBM SPSS Modeler, SAP

DW/BI Skills: Tableau, Crystal report, Data Warehouse, OLAP, Data Marts, Dimensional Modeling, Data Mining, ETL, Microsoft BI stack

Statistical Skills: Sampling Techniques, Hypothesis Testing and Confidence Intervals, A/B Testing, ANOVA, Correlation

Machine Learning: Linear regression, Logistic regression, Decision Trees, Random Forest, Time Series Forecasting, K-Means Clustering, NLP

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Analyst, Fall River, MA

Responsibilities:

Collaborated with internal business users (Operations, Purchasing, Sales, Finance) to gather and understand the business requirements
Extracted and manipulated data (ETL) from relational database to create datasets for data analysis and reporting using Tableau for multiple business areas
Developed and Automated business intelligence applications including operational reports, dashboards, scorecards, and ad hoc reporting
Performed dimensional modelling and OLAP analysis to build data products for advance analysis
Created integrated SQL views from multiple data sources like inventory, sales, operations, and Production in SQL server
Troubleshooted SSRS report problem and provided the solution to business users in timely manner
Designed a Gantt Chart Tool in tableau to visually analyze the quality of operational data entered into the production database. Improved the efficiency of the operational processes by 20% by identifying data redundancy.
Built interactive Dashboard for sales team to analyze top and bottom selling finished products from different warehouse across the organization
Built Time Series Forecasting ARIMA model using Python statsmodel library for customer demand forecasting and measured model performance using MAPE

Data Science Analyst

Confidential, Hartford, CT

Responsibilities:

Built a Message Resonance Model for EQUALS3 on real - time Twitter and Instagram feeds data to understand the customer sentiments.
Utilized Python for cleaning 55 GB of raw data and performed text mining using IBM SPSS Modeler for customer segmentation based on their personality traits.
The model will help improve brand marketing for a wide variety of industries for Confidential clients

Confidential

Data Analyst

Responsibilities:

Designed Process Flow and Implemented Database Systems for Membership Enrolment in MySQL.
Automated the tracking of Membership enrollment using Python scripts, and ETL jobs
Generating Automated reports on a periodic basis for management to monitor member enrollment traffic and membership renewals.
Cognizant Technology Solutions |Data Analyst |India Sep 2011 - Dec 2015
Built business rules and data validation framework to clean, transform and load (ETL) around 700 product attributes data into the SQL database
Developed enterprise wide automated workflow for enriching product data attributes thereby improving existing processes and increasing operational efficiency by 33%
Automated the data exports with ETL batch Jobs to reduce the manual effort and risk of errors.
Created Tableau report/dashboard to measure data quality to help client gain visibility into product completion score metric across 7 products portfolio in NA, EMEA and APAC regions and to track KPI's to aid strategic decision making
Full Software Development Life Cycle (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications