Satish Aily Email & Phone Number

Hyderabad, In

Hyderabad Area, India

Miami/Fort Lauderdale Area

• Performed ongoing and ad hoc analysis of SQL data sets for management decision making and problem solving.• Developed and routinely process Tableau reports and other analyses that effectively monitor various KPIs and assist the supply chain business teams such as demand planning, inventory management, and logistics.• Served as the lead analyst for the department and work with IT and Data Analytics to ensure the appropriate use of analytical tools so that analysis and reporting is… Show more • Performed ongoing and ad hoc analysis of SQL data sets for management decision making and problem solving.• Developed and routinely process Tableau reports and other analyses that effectively monitor various KPIs and assist the supply chain business teams such as demand planning, inventory management, and logistics.• Served as the lead analyst for the department and work with IT and Data Analytics to ensure the appropriate use of analytical tools so that analysis and reporting is accurate and consistent with the data warehouse.• Provided mentoring and support to other analysts to assist in their development surrounding data and utilizing selfservice tools such as refreshables.• Attended Tableau annual conference in 2016 and in 2017. Show less

Buffalo/Niagara, New York Area

• Performed statistical analysis of 6900 business plan applications using variance analysis and confidence intervals on normal distribution and t-distribution curves.• Developed various excel macros using Excel VBA for extracting daily status reports from database.

Pune Area, India

• Performed extensive data analysis of entire operations and developed dashboard of KPIs to present trends and statistical findings to management. • Initiated a lean manufacturing process and proposed change in 20 year old process with new prototype indent tracking system (PITS), which reduced process lead time by 20% and improved employee satisfaction.• Designed and developed a six sigma process for Proto type Build Execution System (ProtoBETS) which allowed department to deliver… Show more • Performed extensive data analysis of entire operations and developed dashboard of KPIs to present trends and statistical findings to management. • Initiated a lean manufacturing process and proposed change in 20 year old process with new prototype indent tracking system (PITS), which reduced process lead time by 20% and improved employee satisfaction.• Designed and developed a six sigma process for Proto type Build Execution System (ProtoBETS) which allowed department to deliver highest number of prototype vehicles (1022) in a decade; a 26% rise from previous year.• Reviewed historical trends, prepared forecast demand data, and optimized inventory by evaluating forecast results.• Performed facilities planning and design for the shortage of storage space problem and improved storage space by 46% with new storage layout.• Designed a new process and developed the Part Manufacturing Tracking System (PMTS) to track vehicle parts from birth to end and accurately record and organize more than 150,000 parts.• Programmed mathematical model in MS Excel macros to reduce lead time in pipe bending operation, which saves three man hours per day and a total of 900 hours annually.• Computed linear programming mathematical model in Excel for capacity estimation and manpower requirements via vehicle equivalent units (VEQ) using advanced tools (data tables, pivot tables, vlookup, VBA Macros and solver). Show less

Pune Area, India

• Led a team of eight including two direct reports.• Executed 16 Sports Utility Vehicle prototypes in span of 11 months with the team of eight, which was a record prototype built speed in the department.• Collaborated in product development, New Product Introduction (NPI), Supplier quality audits, PPAP, APQP• Performed Production Activity Control (PAC) and Materials Requirements Planning (MRP) for building prototype vehicle.• Purchased automobile parts from various vendors… Show more • Led a team of eight including two direct reports.• Executed 16 Sports Utility Vehicle prototypes in span of 11 months with the team of eight, which was a record prototype built speed in the department.• Collaborated in product development, New Product Introduction (NPI), Supplier quality audits, PPAP, APQP• Performed Production Activity Control (PAC) and Materials Requirements Planning (MRP) for building prototype vehicle.• Purchased automobile parts from various vendors through contract negotiations and Purchase Orders (PO).• Computed forecast, demand planning, production scheduling, and optimum inventory of auto parts.• Developed assembly sequence for the entire CAB of the vehicle comprised of 824 parts using time study analysis.• Presented progress on the project to Management Committee each week. Show less

Master Of Business Administration (Mba), Supply Chain And Management Consulting

Activities and Societies: President of Supply Chain and Operations Club

Master'S Degree, Industrial Engineering