SUMMARY:

Dynamic and proactive individual with passion for Data Analytics and Business Intelligence (BI). Gained progressive experience over 6 years in BI, Business Data Analytics, Data Visualization and Database Development. Worked with business stakeholders to gather requirements and create more business opportunities in order to maximize efficiency and revenue through data analysis. Mentored a team of twelve client resources to give on Tableau (BI tool), helping them to be independent with creating reports and perform data analysis.

CORE COMPETENCIES:

Business Intelligence

Data Visualization

Data Analytics

Database Development

Data Science with R & Python

Project Management

Agile.

SKILLS & METHODOLOGIES:

Business Intelligence and database tool: Tableau, Qlik View, Excel, Adobe Target, Toad, SSIS, SSRS, R Studio

Database: Hadoop, Hive, Spark, Oracle 11 g, Microsoft SQL 2012, My SQL

Data Analytics Skills: Data Warehouse, Data Mining, Data Modeling, Machine Learning, Multidimensional Modeling

Programming and developer tools: ETL, SQL, PL - SQL, R, Python, Java, A/B Testing, Hypothesis Testing & Regression

Project Management Skills: Requirement Gathering, Project Charter, Cost Benefits & Risk Analysis, Use Cases, Activity diagram, Object diagram

PROFESSIONAL EXPERIENCE:

Business Intelligence Consultant

Confidential, Santa Clara, CA

Responsibilities:

• Working with the stakeholders of multiple business units to gather requirements and help them to analyze the financial trends & making investment plans.
• Laid down the foundation of visualization environment for the team in order to transform legacy excel based reporting to dashboards, which saved time and resource utilization by 60%.
• Extensively used SQL/PL - SQL in Oracle to gather data from diverse data sources by implementing ETL process which helped report creation from various domains.
• Developed dynamic data visualization dashboards in various financial domains utilizing Tableau, which fastened the decision making process for executive team.
• Performing statistical analysis and visualization in R, which help us to anticipate future trends and forecasting.
• Created and managing Tableau server environment, which facilitated us to share real time reporting to authorized users and have ability to access these reports through multiple devices i.e. iPad, laptop, mobile etc.
• Regularly imparted to business team to help them learn about visualization concepts and understand business metrics.

Business Intelligence Analyst

Confidential, Boston, MA

Responsibilities:

• Worked closely with marketing team to gather requirements for ecommerce platform and given recommendation based on it.
• Effectively performed data analysis on various aspects like customer segmentation, marketing campaigns etc. by using SQL, and gave recommendations to stakeholder which facilitated them to take an appropriate decision for making marketing strategies.
• Performed A/B testing to monitor the effectiveness of different variants of web pages, which supports us to decide which one is better by utilizing various marketing metrics.
• Analyzed business requirements and performed ETL task using SSIS packages to create data warehouse for data visualization.
• Developed data visualization dashboards for sales & marketing teams in Tableau, which helped us to find the sales trend, customer’s analytics, anticipate future forecasting and keep track of various sales KPI.

Business Intelligence Intern

Confidential, Boston, MA

Responsibilities:

• Worked with stakeholder to gathered business requirements of marketing research activities for data integration & visualization.
• Performed ETL task by creating efficient SSIS packages for extracting structured and unstructured data from multiple sources.
• Designed and created OLAP cubes by processing Facts and Dimensional tables through Dimensional Modeling in SSAS.
• Developed customer analytics data visualization dashboards in Tableau, which helped the stakeholders to find the customer behavior & trend and triggered them to take an appropriate decision.
• Implemented new reporting methodology utilizing Tableau which saved time and resource utilization by 40%.

Data Analyst

Confidential

Responsibilities:

• Involved in requirement gathering phase, analyzed requirements to implement & document client tasks.
• Implemented ETL process gathered data from different data sources and maintained data warehouse by using SSIS.
• Performed database testing on data warehouse by using complex SQL queries in SQL Server to validate the date present in it.
• Implemented sentiment analysis program in Python, which analyses Twitter data of particular person and help us to understand their emotions on Twitter.
• Extracted film industry celebrities’ data from IMDB through advanced web scraping technique utilizing related packages in Python
• Fetched tweets of these celebrities by using Twitter REST API in Python and then implemented text mining algorithm on it, which facilitated us to perform sentimental analysis and categorize them very easily.
• Effectively used R language in R Studio tool to find the severity and trend of the accident by using UK accident data
• Implemented data mining (Association rules, Regression and Classification) algorithms to find different factors that depicts accident severity
• Performed exploratory and descriptive analysis to analyze various accident trends which helped to prevent accident in future