Paulami Dutta Mukherjee Email & Phone Number

Sanford, Fl, Us

United States

Project1: Customer Segmentation for Marketing Analysis.Technologies Used: Microsoft Azure (Azure Data Lake Storage Gen2, Azure Data Factory, Azure Databricks, Azure Synapse Analytics), Power BI, Python (Pandas, Scikit-learn), SQL.Project2: Supermarket Sales performance Analysis.Technologies used: Power BI, DAX, MDX, SSMS, Power Query, SQL, Microsoft Azure (Azure Data Lake, Azure Data Factory, Synapse Analytics).Project3: Pharma members’ activities & Beyond… Show more Project1: Customer Segmentation for Marketing Analysis.Technologies Used: Microsoft Azure (Azure Data Lake Storage Gen2, Azure Data Factory, Azure Databricks, Azure Synapse Analytics), Power BI, Python (Pandas, Scikit-learn), SQL.Project2: Supermarket Sales performance Analysis.Technologies used: Power BI, DAX, MDX, SSMS, Power Query, SQL, Microsoft Azure (Azure Data Lake, Azure Data Factory, Synapse Analytics).Project3: Pharma members’ activities & Beyond Analysis.Technologies Used: Power BI, DAX, MDX, Power Query, SQL, Power PointProject4: Detail Healthcare ANALYSIS.Technologies Used: Power BI, DAX, SSMS, Power Query, MS SQL, Power PointProject5: Retail Sales Forecasting and Customer segmentation Analysis.Roles and responsibilities:• Managed and analyzed large volumes of complex and unstructured healthcare data from various sources using Power BI.• Cleaned/transformed/prepared data using SSMS, Power Query, configuring data types, and applying pivoting to transform wide tables into narrow tables.• Designed and implemented robust data models capable of handling millions of records to support reporting and analytics requirements.• Collaborated with IT teams to optimize data extraction, transformation, and loading (ETL) processes for improved performance and scalability.• Developed strategies for data governance and quality assurance to ensure accuracy and consistency of healthcare data.• Optimizing data model by creating dimensional tables (CRT dataset, Details Extracted dataset) to normalize relationships and avoid many-to-many relationships.• Healthcare Parameters and complex DAX formulas (ALL, SELECTEDVALUE, CONTAINSSTRING) to create calculated columns and measures to support dynamic graphs that respond to user selections.• Utilized advanced Power BI features and techniques to enhance data visualization and storytelling capabilities for stakeholders. Show less

Orlando, Florida, United States

Environment:Python, Jupyter Notebook, Power BI, pandas, statsmodels, pmdarima, Matplotlib, seaborn, SQL, Oracle 11g/12c, MS Excel.Roles and responsibilities:• Cleaned/transformed/prepared data using Power Query, configuring data types, and applying pivoting to transform wide tables into narrow tables.• Optimizing data model by creating dimensional tables (salesperson information, datetime table) to normalize relationships and avoid many-to-many… Show more Environment:Python, Jupyter Notebook, Power BI, pandas, statsmodels, pmdarima, Matplotlib, seaborn, SQL, Oracle 11g/12c, MS Excel.Roles and responsibilities:• Cleaned/transformed/prepared data using Power Query, configuring data types, and applying pivoting to transform wide tables into narrow tables.• Optimizing data model by creating dimensional tables (salesperson information, datetime table) to normalize relationships and avoid many-to-many relationships.• Employed Parameters and complex DAX formulas (ALL, SELECTEDVALUE, CONTAINSSTRING) to create calculated columns and measures to support dynamic graphs that respond to user selections.• Performed Sales Data Analysis and KPI dash boarding with Power BI.• Model identification (order selection): first performed seasonal period identification with ACF plotting and seasonal decomposition. Then trend stationarity check with Augmented Dicky-Fuller test. Finally identified promising model algorithm and orders (seasonal and non-seasonal orders) with ACF and PACF plotting.• Built SARIMA model with model order tuning (auto_arima from pmdarima package).• Model diagnostics via visualization and model summary interpretation, mainly checking residual distribution, correlation structure, and variance trending.• Generate in-sample prediction (both one-step-ahead and dynamic prediction) and out-sample forecasting and evaluated model using mean squared and mean absolute errors.• Extracted customer level features closely related to Recency, Frequency, and Monetary (RFM).• Customer segmentation with unsupervised learning clustering algorithms, including K-means, Hierarchical, DBSCAN, Mean Shift, and Gaussian Mixture Model. Multiple aspects of these algorithms (such as computational cost, parameter sensitivity, and robustness to outliers) were evaluated for deployment considerations.• Established a date hierarchy with Year, Quarter, and Month to drill-down visualizations. Show less

Kolkata, West Bengal, India

• Provided/worked in Data, Database, Data Structure, Systems Programming, Database management systems.• Provided/Worked in Numerical Analysis, Statistics, Operating System and different programming languages.• Worked in Oracle, SQL, Oracle 8i/9i Database, Oracle Forms 9i, Oracle Reports 9i, Oracle PL/SQL, Oracle SQL, SQL Queries Performance Tuning, UNIX Shell Script.

Kolkata, West Bengal, India

• Worked as an application developer in Oracle in NGO Schedule. It takes data from 6 sample districts and need to do the required modification to generate the report using Oracle Reports 9i.• Developed one single package written using Oracle PL/SQL which maintained the total validation and manipulation logic. Challenge was there mainly due to time complexity and satisfaction of client.• The technical environment comprised of Oracle8i, PL/SQL Developer, Oracle Forms 9i, Oracle Reports 9i… Show more • Worked as an application developer in Oracle in NGO Schedule. It takes data from 6 sample districts and need to do the required modification to generate the report using Oracle Reports 9i.• Developed one single package written using Oracle PL/SQL which maintained the total validation and manipulation logic. Challenge was there mainly due to time complexity and satisfaction of client.• The technical environment comprised of Oracle8i, PL/SQL Developer, Oracle Forms 9i, Oracle Reports 9i and on Windows XP platform.• The financial accounting system is the module for maintaining and preparation of Budget of the company.• Payroll - salary J/V is the inward interface.• Sales and Receivables - Sales J/V to the customers is the inward interfaces. • Sales Discount as Credit Note. Accounts Payable - Invoice from Suppliers Stores - Goods • Receipt Note as Interface, Consumption J/V, Valuation of Opening Stock (Raw Material), • Valuation of Work in Progress, Valuation of Closing Stock, Valuation of Wastage are the • Inward interfaces. He used to write Oracle Packages, Stored Procedures and Functions.• Worked on Oracle Forms 9i. • The technical environment comprised of Oracle Forms 9i, Oracle 9i on Windows XP platforms. Show less

Master Of Computer Applications - Mca, Computer Engineering, A

Master'S Degree, Digital Marketing

Bachelor In Science (B.S.C), Physics, A

Certification, Data Science With Sas Language, A

Certification, Data Science With R Language, A

Ocp Certification Professional In Application Developer Track, Oracle Application Developer Track, A