Rahul Banerjee Email & Phone Number

Indianapolis, Indiana, Us

Indianapolis, Indiana, Us

Indianapolis, Indiana, Us

Ontario, California, Us

• Created the data architecture, pipeline, data models and built the SSIS packages to integrate multiple databases in the company to harmonize and synchronize the data in them • Integrated and synchronized the R&D PLM database and ERP database at Finished Good level bringing a direct cost saving of ~ $7.8MM • Built SQL Scripts and SSIS Packages to close the gap between Business and IT and bring all into one consolidated track • Data maintenance & resolution for Supply Chain Planning, Forecasting, Products, Customers and Logistics • Data Modelling for PIM and MRP processes for the organization • Responsible for leading GS1 initiatives from pulling, integrating and reporting data from various databases (PV, JDE, and external) to loading to LANSA/1WS • Lead and organized scrum calls between marketing, Supply Chain, Finance, Operations and R&D for New Product Introduction business process from incubation to deployment • Built reporting metrics for Finance and Supply Chain departments of the organizations

Ontario, California, Us

• Compiled and consolidated data dictionaries across multiple teams and systems, and maintain this information using our metadata management tool (Oracle SSIS) • Ran Data Quality Scripts for data reconciliation between one system to another and informing teams about issues • Created and ran Statistical Scripts for Customer Itemized ranking and publish reports • Managed New Product Introduction reports, mapping & coordinated scrum calls for same • Data maintenance & resolution for ASCP, Demantra and JDE

Diamond Bar, California, Us

• Created Phone App to Visualize Forecast Vs Actual Weekly Sales using Power BI • Created Macro using VB scripts to automate the pre-processing of data saving 2 hrs. of work every week• Created Sales Planner using future Weather data & Forecast data

Addison, Texas, Us

• Extracted, compiled and analyzed client’s data from various social media platforms like Google Analytics, Facebook Insight, Twitter Analytics, LinkedIn Analytics and the rest. • Derived insights and Product/Service Strategy & created Dashboard Reports, Story Points in Tableau, DOMO and Pivot charts using Cost Per Clicks, Impressions, Engagement Rates, Reach, etc. • Created Macro using VB Scripts to automate cleaning, pre-processing and building charts from the data from different social media platforms thus saving over 40 man-hours work per month.

Teaneck, New Jersey, Us

• Analyzed and implemented MSCRM for a Dubai based Insurance Client with a projected saving of over $2MM • Lead a team to engineer server migration for 64 applications in 3 environments from IBM Systems to HCL Systems for one of the world’s largest Pharmaceutical companies in less than 3 months • Oversaw Project Management functions through Estimation, Resource Allocation, Feasibility Matrix, UML Diagrams, Progress Reports and Risk Registers using VBA, Macro and Pivot charts • Audited the CRM Business Horizontal projects as a part of internal audit team

Mumbai, Maharashtra, In

• Lead an Automation Testing team to successfully do the Regression Analysis and Regression Testing of applications for one of the largest banks in America • Lead a Manual Testing team of 20 for over 2.5 years to successfully implement the HOEPA, RESPA and Dodd Frank Laws in the Mortgage Origination System for the largest bank of North America

Master Of Science (Ms), Computer/Information Technology Administration And Management

B.Tech, Computer Science And Engineering

High School, Science