ANANYA GHOSH CHOWDHURY

313-***-**** adb3h6@r.postjobfree.com www.linkedin.com/in/ananya-ghosh-chowdhury-7a784759

SUMMARY

* ***** ** ************ ********** in Technology Consulting, Data Engineering, Cloud Engineering, Software Development,Analytics, Data Science, Business Intelligence, & Product Development. Possess good communication, presentation, inter-personal and leadership skills.

EDUCATION

Master of Science, Business Analytics & Program Management, University of Connecticut, United States

Bachelor of Technology, Electronics & Communication Engineering, West Bengal University Of Technology, India

TECHNICAL SKILLSET-

Cloud: Azure (Active Directory, Data Factory, Data Lake, Databricks, BLOB, CosmosDB, App Services, SQL Data Warehouse), AWS(Glue, EC2), GCPS

Languages: C#, Python (Panda, Numpy), R, PySpark, ASP.NET, Entity framework, Angular JS/7, MVC, Web API, JavaScript, PowerShell, Linux

Databases/Big Data Tools: SQL, Hadoop, MapReduce, Hive, Pig, Spark, AWS Glue, Pentaho, NoSQL,CosmosDB (Document, Key-Value, Column, Graph)

Data Analysis / Visualization: Tableau, SAS Base, SAS Enterprise Miner, SAS JMP, RStudio, Power BI, DAX, Power Query, Excel (vLookUps, Pivot Tables)

Repositories / SDLC Tools: Azure DevOps,Team Foundation Server, VSTS, Git, Bit Bucket, JIRA, Trello, Confluence, IIS, Postman, Fiddler, Scrum, Agile

Statistical and Analytical Skills: Data Ingestion, Data Cleaning, Data Mining, Data Warehousing, Machine Learning Algorithms, Time Series Forecasting, Sentiment Analysis, Segmentation & Clustering, Text Analytics, A/B testing, Data Governance, Data Quality, RDBMS

Project Management Course Work: Basics of Project Management, Project Risk & Cost Management, Kanban, Scrum, Waterfall Methodologies

WORK EXPERIENCE

Data Engineer, UConn AIMS, Hartford, CT, US Feb 2019 –Present

Analyzed data using SQL, PySpark, Python, perfomed ETL in Azure Databricks, created visualizations in Tableau, drawing meaningful insights

Implemented robust data engineering pipelines using Azure DataFactory that ingests, processes, analyzes big data enabling real-time dashboarding

Migrated data from on-premises SQL Database to Azure Synapse Analytics using Azure Data Factory, designed optimized database architecture

Been part of datawarehouse implementations using Azure SQL Datawarehouse,SQL Database, Azure Data Lake Storage(ADLS),Azure Data Factory

Set up Amazon EC2 instances, Connected to Linux instance from windows using Putty, connected to SQL Server, performed data modifications

Assistant Manager, PricewaterhouseCoopers, Kolkata, India Jun 2018 - Jan 2019

Led a team of business analysts, data-engineers and software developers, to streamline an sales-service application that increased productivity, customer satisfaction by 50%

Worked closely with Partners/SLTs in making strategic decisions on growth, investment, target-customers, cost savings, resource utilization and future direction of investments, by understanding the potential opportunities in market and analyzing data

Created and configured ETL jobs using Pentaho to fetch data from APIs, tested in Post Man, cleaned and stored data in Azure BLOB Storages

Integrated Azure Active Directory Authentication with an ASP.net core WebApp, facilitating secured login and authorized access to the application

Deployed applications with Azure AppServices,created Deployment Slots in staging and production, maintained code in Azure DevOps Server, Git

Consultant, PricewaterhouseCoopers, Kolkata, India Jan 2017 - Jun 2018

Designed database architecture for a Migration phase of a retail client having 0.4M customers by customizing the existing Data warehouse.

Been a Product Owner of a Web API based-solution that stored data in Azure SQL Server, BLOB storages for SLTs a retail client, to track inventory, manage resources, monitor cash flows; increasing revenue by 40%

Configured Azure point to site VPN for secure remote access connectivity to cloud based workloads in Azure VN authenticating through Azure AD

Supervised database designs, set up CrushFTP, extracting, cleaning, transforming data, scheduled routine jobs using SQL Server Agent in SSMS

Programmer Analyst, Cognizant Technology Solutions, Kolkata, India Feb 2014 - Jan 2017

Developed a product that consumes Restful webservices, binds data to browser using JQuery, JS and generates architecture diagram of any project

Developed an e-commerce system for an online food ordering service using ASP.net, MVC, Entity Framework, JavaScript, JSON, AJAX, SQL Server

Analyzed data of various school managements; centralized an EMS for a chain of schools using AngularJS, Unity Framework, reducing revenue loss

Devised Dev Express Dashboards in a tax-reporting tool for generating reports of taxes filed in different financial periods, for promoters and admins

Technical Analyst, IBM, Bangalore, India Jul 2013 - Feb 2014

Developed SQL stored procedures, tables, views, functions and triggers ; implemented best practices to increase performance; tuned queries

ACADEMIC PROJECTS

Predictive Modeling OPIOID drug overdose in the state of CT Python, JMP, Excel, Tableau

Built classification models to identify the factors responsible for the death crises of OPIOID consumption in the state of CT. Applied data wrangling, feature engineering and Rare Event Analysis during Holiday season. Used Logistic Regression, Decision Tree and Random Forest ML algorithms. Improved the model accuracy by 10 folds using k-fold cross validation.

Time series Forecasting EB claims Loss Trend Forecasting SAS Base, SAS Miner, Tableau

Forecasted claims intake volume based on legacy claims data, identifying seasonality, trends, with loss location, premium and equipments as regressors using ARIMA, Exponential Smoothing, Clustering algorithms. Performed Text Analytics on the claims notes.

Data Visualization and Analytics Boston Airbnb Tableau, R, Python

Designed an interactive Tableau storyboard on the best Airbnb places to stay in and around Boston based on ratings, location, user reviews.

Performed data cleaning and transformation with R. Analyzed texts from the user reviews using Python

Built and published ML models and web services with Azure Machine Learning Studio to predict chances of a customer to accept a credit card

Contact this candidate