Raja Immadisetty Email: raja_iv@hotmail.com PROFESSIONAL SUMMARY Innovative and resourceful Supply Chain Professional with experience in forecasting, inventory management, inventory optimization and implementation. Proficient in data mining, analysis and reporting with an excellent track record in innovative solutions to optimize forecast accuracy and excess inventories. WORK EXPERIENCE DEMAND PLANNER: Ameriwood Industries Designs, Manufactures and Imports Ready-To-Assemble furniture for North American 'Big Box' retailers, Annual sales: $400M * Primary responsibilities include Demand forecasting, Financial & budget analysis and inventory analysis involving 800 Active SKU's, with 25% new SKU's per year. * Managed the demand forecasting process in coordination with the sales and the manufacturing teams. * Business Process Optimization of forecast process integrating the Purchasing and Master Production Scheduling. * Improved forecast accuracy by 15%. Developed excel macros to automate the forecast accuracy reports by various categories replacing the previously very arduous process. * Review of historic sales trends, research of demand drivers, preparation of forecast and evaluation of results * ABC classification for items, Inventory analysis and impact of forecast on levels of inventory * Coordination of the forecasts for new product rollouts based on trends in historic data. Developed new rollout performance tracking macro to monitor sales. * Lead and managed the implementation and upgrade of new forecasting system. This included the separation of the forecast for the replenishment and the Even forecast. * Automation of key data-exchange processes between the forecasting system and ERP. * Forecast variance and accuracy with cause effect analysis ~ In comparison with POS, Customer forecasts, Oh-hand inventory and data ~ Statistical forecast Vs Judgmental forecasts * Manage other administrative duties and daily / monthly progress reports. Developed a Monthly progress report which tracks the Sales, open orders, History, and Budgets. * Adjust safety stock levels based on forecast error. Reduced the On-hand inventory levels by 18%. * Performed root cause analysis on forecast errors and implemented action plans with sales teams to resolve issues and ensure 98% on time customer delivery and service. FINANCIAL ANALYST AND TECH SUPPORT, Aug'03-Dec'05 School of Extended Education, Ball State University, Muncie, IN * Annual/Semester Financial & Cost analysis for four departments of the School of Extended Education * Annual financial reports and trend analysis (Student Enrollment & Expenditure). Automated and developed linked spreadsheet templates for the reports. * Annual / Semester budget and grant analysis for four departments * Created custom queries and reports for REGDAT (a Microsoft Access student registration database) reducing the data retrieval time by 75% * Created course evaluation web pages using ASP and JavaScript for courses administered by Electronic programs * Server administration and tech support (Windows server 2003) OPERATIONS MANAGER, (Intern July'04 - Feb'06) Best Western, Muncie, IN * Primary responsibilities include supervision of the complete operations of a privately owned franchise * Streamlined the day to day operations and reporting procedures along with audit process * Automated the audit process which helped reduce the processing time by 70 * Developed report templates to standardize the procedures. * Developed and implemented cost cutting measures to reduce operating costs PROJECT COORDINATOR, Aug'02- Aug'03 Community Based Projects, Ball State University, Muncie, IN * Team management and work scheduling * Developed the maps required for the analysis in the charretts * Organized and participated in charrette workshops and community meetings * Evaluated information to determine compliance with the standards for final reports * Generated/ consolidated reports from team for final submission SENIOR ARCHITECT, 2001 - 2002 C-con Consultants Hyderabad, AP India (Architecture and Interior Design Firm) * Managed many arch and interior projects independently with a team of architects, draftsmen, engineers and the graphic departments * Project management, coordination, drawings, site supervision and cost estimation * Played a key role in sales promotion by acquiring new projects (Sales improvement of 38%) CONSULTANT / DOMAIN EXPERT, 1999 - 2001 Net Decisions, Visakhapatnam, India (UK based Software and Content Development firm) * Lead a group of 32 architects and civil engineers * Project management, process development & implementation, work scheduling * Developed a construction material specification database for 100,000 products * Coordinated various SW and content support teams * Performed under strict time constraints and quality control EDUCATION MASTER OF BUSINESS ADMINISTRATION MBA with Concentrations in Production and Operations management and Entrepreneurship Miller College of Business, Ball State University, and Muncie, IN (GPA: 3.7) Dec 2005 BACHELOR OF ARCHITECTURE (B. ARCH) Andhra University college of Eng, Vizag, India (GPA: 3.9) Jan 1999 RECENT ACCOMPLISHMENTS & AWARDS * EMPLOYEE RECOGNITION AWARD, SCHOOL OF EXTENDED EDUCATION, BALL STATE UNIVERSITY, IN ~ Outstanding Performance and significant contribution to the project Annual Semester Financial & Cost Analysis for four departments with in School of Extended Education * OUTSTANDING INTERN AWARD ~ Implementation of operational changes and automation of audit procedures at Best western Muncie * Merit based Graduate Assistantship and Tuition waiver through out the Masters Program * Secured a Score of 640 in GMAT COMPUTER PROFICIENCY * Languages: C, C++, Visual Basic, PL/SQL * Proficient in Microsoft Office, MS project 2003, Advanced knowledge of Excel * Certified Administrator Futurcast (Forecasting tool) * Functional Knowledge of SAP R/3 System MM, PP, SD, HR, FI, ABAP * Good knowledge of database design, MS Access and Oracle10g PROFESSIONAL ASSOCIATIONS * Association of Operations Management (www.apics.org) Currently pursuing CPIM * Institute for Business Forecasting (www.ibf.org) * Business for Social Responsibility (www.bsr.org) * Indian Institute of Architects (www.iia-india.org)