MIS, Analytics & Automation Consultant

Meenakshi Dutta

Address: Marina F ***, Casa Rio, Palava City, Kalyan Shil Road, Dombivali (E), Thane – 421204 Mobile: 928-***-**** Email: *.*******@*****.*** Date of Birth: 15th October, 1978 LinkedIn: www.linkedin.com/in/meenakshi-dutta-9a40ab32 MIS, Analytics & Automation Consultant proϐicient in eliciting requirements, designing and automating dashboards, ϐinancial and statistical models, transforming raw data into actionable insights and strategic recommendations, writing, testing, and deploying scalable code across the software development lifecycle, preparing research reports, conducting trainings, managing projects, teams and stakeholders. Skills:

Technical: Microsoft Office (Excel, Access, Word, PowerPoint) Visual Basic for Applications (VBA)

SQL Power BI Python Tableau Jira

Functional: MIS Reporting Automation Data Analytics Lean Six Sigma Financial Modeling

Statistical Analysis Business Research Design Thinking Inventory Management Project Management Stakeholder Management Team Management Learning & Development Operational: Capital Markets Mutual Funds Trade Finance Insurance Mortgage Banking

Contact Centres Telecom Supply Chain Human Resources Energy & Natural Resources Certiϐications:

Google for Developers: Introduction to SQL

Oracle: Databases for Developers – Foundations

Infosys Springboard: An Overview of Data Modeling in Power BI Data Loading and Visualization in Power BI Data Quality Management Financial Statement Analysis

Cambridge International Qualiϐications, UK: Basics of Power BI Basics of DAX in Power BI

Basics of Data Visualization using Python

Google Cloud: Introduction to Generative AI Introduction to Large Language Models

Corporate Finance Institute: Statistics Fundamentals

Coursera: Data Analytics for Lean Six Sigma Finance for Non-Finance Professionals

HP Life: Design Thinking Basics of Finance Proϐit & Loss Cash Flow Inventory Management

Quantinsti: Stock Market Basics Python for Trading Basics

TCS iON: Accounting Fundamentals Understanding Mutual Funds and Role of a Transfer Agency Understanding Reconciliation Life Cycle in Trades

Franklin Templeton Academy: Selecting an Equity Fund Mathematics of Investing

International Trade Council Academy: Trade Finance for First Time Exporters

WFM eLearning: Contact Centre Fundamentals

Skill India Digital Hub: Project Management with Jira

Master of Project Academy: Scrum Product Owner Certiϐication Education:

Bachelor of Science (Physics) - Indira Gandhi National Open University

West Bengal Council of Higher Secondary Education (Science) - Jogomaya Devi College

West Bengal Board of Secondary Education - Carmel Convent Work Experience:

Company: KG Information Systems Private Limited (KGiSL) Client: Deutsche Bank Designation: Project Lead Tenure: Sep 2024 - Sep 2025

Company: DISYS India Private Limited Client: Morgan Stanley Designation: Subject Matter Expert Consultant Tenure: Sep 2022 – Sep 2023

Company: Citicorp Services India Private Limited Designation: Operations Support Analyst Tenure: Jun 2020 – Apr 2022

Company: Wipro Business Process Services Client: Health Plan Services Designation: Deputy Manager Tenure: Dec 2017 – Dec 2019

Company: Accenture Services Private Limited Client: AT&T Designation: Subject Matter Expert Tenure: May 2013 – Jul 2017

Company: Integreon Managed Solution India Private Limited Client: Eversheds Designation: Specialist Tenure: May 2011 – Dec 2012

Company: Willis Processing Services (India) Private Limited Designation: Senior Associate Tenure: Sep 2008 – Aug 2010 Projects:

Annual Budget: Prepared the capital and operating budget for a non-proϐit organization for the next ϐiscal year, forecasting revenue and expenses by comparing budgeted vs actual ϐigures, monthly, quarterly and annually, over the last 5 years. Technology: Microsoft Excel

Advanced Visualizations: Designed a Gantt Chart to track IT project schedules, a Funnel Chart to show the decrease in the number of candidates as they ϐlow from one stage to another in a recruitment pipeline, a Gauge Chart to track the performance of a stock against the target deϐined by its highest price over a month, a Sankey Diagram to aggregates sales volumes and values across categories, segments and markets connected with ϐlowlines, a drilled down Radar Chart to compare the median income and purchases of customers of a retail giant across segments and a Calendar Heat Map with a slicer to compare daily, monthly and quarterly prices of an oil and gas company over the last 5 years.

Technology: Power BI

Plotting and Analyzing Market Data: Built a code to import the Numpy, Pandas and Matplotlib libraries, read data from a csv ϐile, compute the mean, rolling mean, standard deviation, rolling standard deviation, cumulative returns, Sharpe, Maximum Drawdown and Sortino ratios and plot them using line graphs to analyze daily, weekly, monthly, quarterly, bi-annual and annual trends in stock prices, risks and returns.

Technology: Python

QA Workpapers: Designed and automated a dashboard to create comments columns equal to the number of test step columns, add data validation to test step and comments columns, apply conditional formatting to test step results, compute and format the ϐinal test result, validate comments, highlight discrepancies, classify, count and concatenate IDs by comments and mail it to stakeholders.

Technology: Microsoft Excel Visual Basic for Applications (VBA)

APCRC Deck: Designed and automated a dashboard to copy source data to a dashboard, add formula columns, summarize and format data over 5 quarters, copy it into tables, charts and textboxes in the deck and mail it to stakeholders. Technology: Microsoft Excel Microsoft PowerPoint Visual Basic for Applications (VBA)

Citi Weekly Supplemental Headcount Report: Automated the quality check of a dashboard to match comparable data points, check calculations and mail it to stakeholders. Technology: Microsoft Excel Visual Basic for Applications (VBA)

ITR Form Automation: Automated an ITR form to look up companies based on their PAN numbers, populate the form with company speciϐic information, calculate taxes, copy the form to a new workbook and mail it to stakeholders.

Technology: Microsoft Excel Visual Basic for Applications (VBA)

Variance Analysis Report: Designed and automated a dashboard to identify, categorize and report discrepancies in healthcare insurance data, due to referential integrity issues, analyse monthly, quarterly and annual performance trends in terms of new cases, dropouts and carry forwards, compute basic statistics, summarize ϐindings and mail it to stakeholders. Technology: Microsoft Excel Visual Basic for Applications (VBA) SQL

Sunrise Bakery: Designed and automated a ϐinancial model to compute discounted and free cash ϐlows, payback period, net present value, internal rate of return, ϐinancial ratios (proϐitability, efϐiciency, leverage, solvency and liquidity), weighted average cost of capital, compounded annual growth rate, analyse performance trends, summarize ϐindings and mail it to stakeholders. Technology: Microsoft Excel Visual Basic for Applications (VBA)

Order Trends Report: Designed and automated a dashboard and deck to analyse monthly, quarterly and annual performance trends of a retail giant in terms of order quantities, volumes and values, by customers, cities, categories, products, shippers and suppliers, compute basic statistics, summarize ϐindings and mail it to stakeholders. Technology: Microsoft Excel Microsoft Access Visual Basic for Applications (VBA), SQL

Supplier Performance Tracker: Designed and automated a dashboard to analyse monthly, quarterly and annual performance trends of telecom companies in terms of order volumes and values, bidding behaviour, technical feasibility, summarize ϐindings and mail it to stakeholders. Technology: Microsoft Excel Visual Basic for Applications (VBA)

Leased Line to Ethernet Migration Tracker: Designed and automated a dashboard to track the migration of circuits from Leased Line to Ethernet, billing of ceased circuits and calculate savings. Technology: Microsoft Excel Visual Basic for Applications (VBA)

Competitive Analysis Report: Designed and automated a ϐinancial model to perform vertical, horizontal and ratio analysis of ϐinancial statements, compute basic statistics, summarize ϐindings and mail it to stakeholders.

Technology: Microsoft Excel Visual Basic for Applications (VBA)

Contact this candidate