Nitin Pandya Email & Phone Number

Maharashtra, India

New York, Ny, Us

New York, Ny, Us

> Leading a team of 8 Data Scientists and Data Engineers, driving data enabled revenue & insights for 20+ clients across the globe in Healthcare.> Automated 10+ ETL pipelines using Python, enhancing data support for Tableau and PowerBI dashboards. These automations led to savings of more than $400,000 in the organization. > Developed 10+ Python-based analytics solutions, improving decision-making efficiency by 30% for BI applications.> Designed 15+ dashboards based on stakeholder BRDs, driving a 40% y-o-y increase in revenue through actionable insights.> Consistently created KPIs, solutions and stories for business with the help of data.> Help enterprise clients to build models and analytics platforms to achieve sales goals.> Also developed and tracked metrics to identify current and historic performances to move towards greater final goals.> Consistently develop new metrics to analyze data which leads to better tracking and driving of sales.> Led various POCs and POVs for sales enablement in ESG, HR & Insurance Analytics, collect data sets from varied sources to power insights in BI dashboards

New York, Ny, Us

New York, Ny, Us

Analytics, Automation & AIML Expert, Mercer Digital Team, USA

Greenwich, Ct, Us

Advanced Analytics Team, USA> Working with Lead Data Scientist, Operations Research for geographical data mapping with the help of Google API, Python & Tableau.> Writing complex SQL queries in Google’s Big query for ETL. Validating data extracts to ensure accuracy.> Writing python scripts for analytics and automation of reports. Analyzing the data for trends and seasonality.

New York, Us

Client - Procter & Gamble, Japan> Develop data-driven recommendations and insights that align with client business objectives and help them grow.> Analyzing and manipulating large and unstructured data sets using python, with the ability to convert them into actionable insights and compelling storylines and dashboards in order to drive business and strategic decisions.> Structure and solve complex, ambiguous business challenges and strategically analyze the needs of clients to arrive at the best solution.> Data warehousing and database manipulation using SQL.> Building and automating interactive, intuitive dashboards using Tableau Desktop and Power BI from large and complex data sets from various sources into Tableau for analysis and visual presentations.> Using Machine Learning models like Linear, classification, Random Forest, Decision Trees, K-Means Clustering to data set and generate forecasts, predictions and analysis using R & Python.

Zurich, Ch

On Contract for 2 MonthsClient - Birla Cellulosic by Aditya Birla Group - LIVA> For the festive season promoters had to be deployed at various MT retail outlets across 30 cities in India so that maximum sales can happen with the optimum number of promoters. Predicted that 260 promoters would be required across 30 cities understanding the past 3 years data of sales & staffing of Liva and its competitors.> Setting targets for promoters using the predicted (vs. expected) sales using random forest and linear regression models.> Reporting the daily dashboard of recruitment at the initial stages, reporting the attendance of promoters, sales and feedbacks of customers interested in buying Liva fabric based products.

Tokyo, Jp

>Accountable for development of Mumbai’s Sony Retail business with team of 250+ SFAs (Shop Floor Associate) positioned at MT & GT stores for TV, Mobile, Camera, Home Theatre, and Headsets along with its accessories.> Performed sales data analysis with Advanced Excel techniques to present branch’s sales insights to HO, Branch Manager and sales person in charge.> Recurrent monitoring of MTD sales to understand the sales momentum and ensure optimal return on investment. Using business insights and understanding the other brand’s sell thru to increase customer wallet share. Maintaining analytical data on stock at each outlet.> Assigning targets by analyzing the sales data making an allowance for seasonal aids along with new product introductions.> Maintaining customer insights at Sony Centers for consistent improvisations.> Budgeting, vendor management, cost effectiveness, event management & invoicing of monthly trainings, meetings and promoter’s day biannually in consultation with finance and senior management.

Gurgaon, Gurgaon, In

Client - Apple, India> Managing daily operations of 1000+ sales force deployed at MT & GT stores across India.> Analysis of Sales vs. Target to understand share, productivity and true potential of the market. Designing Incentive schemes with Apple management.> Recommending the sales force in stores considering the various factors of market.> Recruitment, managing exits, retention plans for promoters.> Consistent initiatives and motivating the sales staff towards achieving targets.> Preparing Quarterly estimates, calling for P.O, invoicing to the Apple Management as per the terms agreed.

Gurgaon, Gurgaon, In

Client - Apple, India> Forecasting and Budgeting of Mac & iPad sales for Marketing Team across India.> Used MySQL, VBA & Advanced Excel techniques> Continuously collaborate with Regional Sales Manager to ensure data consistency and accuracy.> Analysis of partner wise, region wise sales and inventory to ensure efficient minimal stock holding.> Analysis and research of information relating to reports collated from various resources.> Proactively identifying trends, recurring problems and risk; suggest and implement resolutions.> Ensuring timely delivery of all the informative reports, along with ad-hoc requests.> Develop management reporting which showcases the productivity, profitability, capability and other keycomponents to highlight performance of the various operational and technological aspects.

> Coordinating with Managing Director for implementing systems, policies & procedures to facilitate internal financial control by preparing quarterly projections and forecasting trends.> Developing reports for directors, summarizing the business financial position in areas of income, expenses & cash flows, and coordinate the preparation of strategic plans, budgets and financial forecast.> Preparation of P&L, Balance Sheet, Financial Reports & Financial Statements for internal usage and assisting statutory auditors.

> Income Tax & MVAT, CST return filing and Statutory & Concurrent Audit.

Eagan, Mn, Us

> HP Desktop / Laptop's Technical Customer Support (Voice) and Road Runner Internet (Time Warner Cable) Technical Support (Web)

Master Of Science - Ms, Information Technology

Bachelor Of Engineering, Electronics & Telecommunications

Hsc, Science

Ssc, Schooling