OBJECTIVE

• A highly resourceful and reliable professional backed by extensive noledge of SQL, T - SQL, data visualization tools Power BI & Tableau, Python and Basic Data Science concepts such as Regression and Classification.

SUMMARY

• Over 3+ years of professional experience in building Data Analytics and Business Intelligence infrastructure and solutions which led to increased efficiency in business operations.
• Attended daily standup meetings to discuss teh tasks at hand and weekly meetings to present teh status of tasks & reports.
• Experienced in writing complex T-SQL queries: derived tables, CTEs, views, sub-queries, and multiple joins etc.
• Performed Data Analysis and Data Validation by writing complex SQL queries.
• Proficient in main Business Intelligence tools such as Tableau and Power BI for creating dynamic dashboards and reports for various business functions.
• Good Understanding of Visualization Techniques by creating summary and detailed reports Using Drill Down and Drill Through techniques.
• Extensive noledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Bins, and Parameters etc. for summarizing and analyzing key analytics findings.
• Proficient in design and development of various dashboards, reports on Power BI Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. Making use of actions and other local and global filters according to teh end user requirement.
• Expertise in designing and developing filter driven interactive Dashboards, trend based KPIs, summary and detail reports featuring parameters, sorting, expressions, drill down and drill through, etc.
• Created summary and detail reports with drill down and drill through features using DAX Functions.
• Extensive experience in using Python Libraries such as Pandas, NumPy, Matplotlib and Scikit Learn.
• Experienced in using Python for Exploratory Data Analysis (EDA) by analyzing data sets to summarize their main characteristics and tan visualizing teh findings using Jupyter Hub.
• Used Pandas for data cleaning, manipulation and analysis.
• Extensive experience in Extract, Transfer and Load (ETL) processes using MS SQL Server Integration Services (SSIS) for Data migration and Data Warehousing projects along with good project management skills.
• Constructed Data Warehouses by integrating data from multiple heterogeneous that support analytical reporting, structured and/or ad hoc queries, and decision making.
• Performed Data validation, Normalization, Harmonization & Data-Cleansing on multiple data sources.
• Hands-on experience on how to pull data by using SQL Server and also SSIS from teh database automatically.
• Great leadership qualities and excellent communication skills. Can work independently or within a team, self-motivated, determined, optimistic, and willing to learn new technology. Ability to stay calm in stressful situations and adapt to new surroundings quickly.

TECHNICAL SKILLS

Data Analytics: Data Cleaning, Manipulation, Visualization & Normalization

Data Science: Regression & Classification

Math & Stats: Variance, Probability, Correlation & Measures of Central Tendency

Reporting Tools: Power BI & Tableau

Languages: SQL, T-SQL & Basic Python

IDE: SQL Developer, SQL Server Management Studio, Jupyter Hub

Python: Pandas, NumPy, Matplotlib, Scikit Learn

Databases: MySQL, SQL Server, Oracle

Cloud Technologies: AWS RDS, Azure

ETL: SQL Server Integrated Services (SSIS)

Operating System: Windows & MacOS

Repository System: GitHub

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Utilized Tableau for data intelligence and analysis.
• Good experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Online and setup schedule refreshes.
• Experienced in creating filters, quick filters, data source filters global filters, context filters, user filters, actions and creating Dashboards for key performance indicators.
• Highly proficient in design and development of prototype reports/ dashboards in Tableau during teh requirement gathering phase to visualize teh reports and clarify requirements.
• Excelled in performance at different client locations with teh interactive dashboard presentations.
• Created reports in tableau to understand successful project patterns and funding trends.
• Heavily relied on data blending as teh end workbooks ultimately required multiple fields from different data sources.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Effectively used data blending feature in tableau to connect different databases like Oracle, MS SQL Server.
• Designed Ad-Hoc reports across various verticals as per teh Business Users requirements.
• Performing yearly analysis and business risks using different line charts.
• Prepared BI Interactive Dashboards using calculations, parameters in Tableau.
• Blended data using multiple data sources (primary and secondary).
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for teh data sources.
• Implemented data cleanup processes and analyzed data integrity problems.
• Lead and oversee full-stack Business Intelligence solutions that leads to direct business impact.
• Work with cross functional teams for Marketing, Product, Finance teams and translate business requirements into SQL queries to answer business questions.
• Built complex Tableau dashboards with advanced functions to provide insightful analysis, identify growth opportunities, and maximize profits.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered teh ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu options and Parameters using Tableau.
• Trained a machine learning algorithm using scikit-learn to forecast state of a project before its launch.
• Performed linear regression using scikit-learn to predict teh amount of money that will be raised by a certain project.
• Cleaned and pre-processed data using pandas to achieve high accuracy from teh Machine Learning model.
• Extracted, Transformed and Loaded data (OLTP) to teh data warehouse (OLAP) using MS SSIS.
• Attended teh project review meetings, daily/weekly status meetings and walkthroughs with project managers and leads.

Environment: MySQL, MySQL Workbench, SQL Server, AWS, Azure, Oracle, Tableau, Jupyter Hub, Slack, Pandas, Scikit-Learn, NumPy, Python