SUMMARY

• Data Scientist/ Power BI Developer with around 4 years experience in Machine Learning, Deep Learning, Data mining with large datasets comprising of Structured and Unstructured Data, Data Validation, Predictive Modeling, Data Visualization using R, SAS and Python and various BI Tools.
• Worked extensively on Power BI and created Reports/Dashboards using different type of Slicers and different Visualizations like Bar Charts, Line Charts, Graphs, and Pie Charts etc. to make it more attractive and explored data in a Variety of ways and across multiple visualizations using Power BI.
• Rich domain knowledge and experience with data in domains like Healthcare and Financial institutions.
• Solid experience in designing and developing Stored Procedures, queries and views by writing complex SQL queries using Joints, Sub quires.
• Transformed and combined the data using Query Editor in the Power BI and published Power BI
• Involved in the entire data science project life cycle and actively involved in all the phases including Data acquisition, Data preparation, Hypothesis and Modeling, Evaluation and Interpretation, Deployment, Operations and Optimization.
• Developed many Tabular Reports, Matrix Reports, drill down Reports, Bar Graph Reports using Power BI.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering and deploying reports to Power BI Service
• Having knowledge on Apache Spark, developing data processing and analysis algorithms using PySpark.
• Knowledge of Machine Learning algorithms like Classification, Regression, Clustering, Decision Tree algorithms and Time Series Methods.
• Wrote simple Power Shell command line scripts.
• Created many calculated columns and measures using DAX in Power BI based on report requirements and published Power BI reports to end user via mobile
• Experience in building models with deep learning frameworks like TensorFlow and Keras.
• Experience in Python to manipulate data for data loading and extraction, using python libraries like Matplotlib, Seaborn, NumPy, Scipy and Pandas for data analysis.
• Have working knowledge implementing cloud computing technologies like AWS, Google Cloud and Microsoft Azure.
• Proficient in Power BI, Tableau, Qlik, SSRS and Shiny data visualization tools to analyze and obtain insights into large datasets, create visually powerful and actionable interactive reports and dashboards.
• Excellent understanding Agile development methodology.

TECHNICAL SKILLS

Languages: R, Python, SAS

Database: MS SQL, Oracle

Big Data: HDFS, Spark, Pig, Hive, Scoop

Regression Techniques: Linear regression, Logistic Regression, Decision Trees

Data Tools: NumPy, Pandas, Scikit - learn, Keras, NLTK, ggplot2

BI Tools: Tableau, PowerBI, SAP BO, SSRS, Cognos

Analytics Tools: SAS E-Miner, Angoss, Azure

Cloud Services: AWS, Google Cloud and Microsoft Azure

Statistical /ML Methods: Time Series, Regression/Classification Models, Hypothesis Testing and Confidence-Interval, Principal Component Analysis, Dimensionality Reduction and Deep Learning.

PROFESSONAL EXPIRENCE

Confidential, Sioux Falls, SD

Power BI Developer

Responsibilities:

• Designed and developed stored procedures, queries and views as necessary. Extensively use joints and sub-queries for complex queries which were involving multiple tables from different databases.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop
• Developed and implemented several types of Financial Reports by using SSRS. Validated reports and resolve issues in a timely manner.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Created Credit Risk Financial Models.
• Worked on analyzing Charge Backs to decrease costs and increase efficiency using Angoss.
• Migrated existing self-service reports and ad-hoc reports to Power BI.
• Created sub-reports, drill down reports, summary reports, parameterized reports, and ad-hoc reports using Power BI.
• Wrote Calculated Columns, Measures, and Queries in Power BI desktop to show good data analysis techniques
• Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization.
• Identified various parameters to improve the existing data models for approving credit cards and line increases to individuals.

Environment: SQL Server 2012, Power BI, MS SQL Server Management Studio, SSRS, T-SQL, Visual Studio, Angoss, Excel.

Confidential, Sioux Falls, SD

Data Scientist/Power BI Developer

Responsibilities:

• Worked in the Enterprise Data & Analytics department to create data visualizations, analysis and statistical modelling using the programming language R and python.
• Processed large amounts of health data for data visualization and statistical modeling and report results of statistical analyses, in the form of graphs, charts, and tables.
• Worked with EPIC and Clarity databases for everyday workflow.
• Experience in creating different visualizations and dashboards using Power BI
• Evaluated new internal and external data elements and technologies to be included in predictive models.
• Identified relationships within data sets that can produce meaningful differentiation for Confidential .
• Created geographical data visualizations and graphical representations of the data.
• Worked on Truven Health Insurance data on Hadoop (over 10 TB of datasets) using Hive, Spark.
• Conducted investigative projects utilizing Python for data analysis and machine learning.
• Automated monthly reports using Python, which help save man hours.

Environment: SQL Server 2012, MS SQL Server Management Studio, Power BI, T-SQL, Visual Studio, R, Python, Hadoop, Spark, Hive, Excel.

Confidential, Brookings, SD

Power BI Developer

Responsibilities:

• Developed many Tabular Reports, Matrix Reports, drill down Reports, Bar Graph Reports using Power BI.
• Develop machine learning models to recommend ads, improve sales strategies and improve client’s products
• Worked on gas chromatography machine (Shimadzu) and LabSolutions software.
• Working on large datasets of gas reading of CO2, NO2, CH4 from soil samples.
• Worked on eliminating noise and other unwanted peaks on LabSolutions software.
• Creating ad-hoc Reports using MS Excel and Data Visualizations using Power BI.
• Presented my reports and visualizations to research members and principal investigator of the lab.

Environment: Power BI, Excel.

Confidential

Junior Data Scientist

Responsibilities:

• Used web scrapping libraries in Python to scrape web pages to extract useful information tables, reviews and automated the process using Web Crawlers with Scrapy.
• Finding the sentiment about the clients using Text Mining and NLP techniques using the web scrapped data and Social Media Platforms.
• Performed data visualization and designed dashboards with Tableau and provided complex reports, including charts, summaries, and graphs to interpret the findings to the team.

Environment: SQL Server 2012, MS SQL Server Management Studio, T-SQL, Python, Tableau, Excel.