Steve Van Email & Phone Number

Alpharetta Ga

CoreVance Inc Staffing and Recruiting Services team is diligent about understanding your business and your culture. We apply our market and industry expertise to provide a consultative approach and help design a solution that makes sense for your team and your organization. Are you frustrated by seeing resumes that matched a key word search and are clearly not qualified or screened to ensure they meet the qualifications of your position? Through asking the right questions, our goal is to fully understand your business, key projects, culture and technical requirements of your positions. This helps us to identify the best candidate to meet your needs.Want to know the best part? The level of engagement and candor we inject into every interaction with our customers and candidates allows us to build lasting relationships with some great people and organizations.Our customers call on us to help them find talented people in:Information Technology (IT)Engineering & DesignOffice Administrative and ClericalProfessionalFinance/Accounting/ProcurementMarketing/CreativeHuman Resources/RecruitingProgram & Project ManagementSometimes the needs of your projects and the career aspirations of our candidates call for flexible options:Direct placement: Placement of permanent employees for our customers.Contract-to-hire: Allows our customers to assess contract employees first hand to evaluate skills, team and culture fit and productivity.Contract placement: Allows our customers to the flexibility to hire on a project or temporary basis according to business needs.

440 Prospect Pi, Alpharetta Ga 30005

Maintained Test data in Excel files and Importing Excel files from Resources module in Quality center to QTP data table and read the values based on the functional requirement. Converted manual test scripts to automated test scripts in Quick Test Professional, enhanced the scripts by adding user-defined functions.Automated test scenarios for GUI, Functionality, Integration, Database, Boundary, Security and Regression Testing using Quick Test Professional Prepared test scripts using Quick Test Professional with checkpoints using regular expressions for handling windows with different names. Worked on testing Oracle BI reports matching it with the business requirements. Actively involved in functional, unit and integration testing in agile methodology. Worked on QTP hybrid framework (Data Driven), identifying the functional areas and created different functions to make the scripts reusable in Quick Test Professional (QTP). Performed extensive Black-box testing. Designed Stored Procedures to extract and manipulate data from the back end database using SQL Queries.

Developed the Data Driven framework for both Functional and Regression testing. • Developed test scripts for Data driven testing using parameterization in QTP by using Excel sheet for test data and Database Queries based on the functionality. Extensively worked in VB scripting • Extensively worked in developing SQL queries using join statements and performed calculations to get different financial calculationsActively involved in functional, unit and integration testing in Waterfall methodology. Worked onQTP hybrid framework (Data Driven), identifying the functional areas and created different functions to make the scripts reusable in Quick Test Professional (QTP). Performed extensive Black-box testing. Designed Stored Procedures to extract and manipulate data from the back end database using SQL Queries.Performed extensive End-To-End testing and UAT of the process by working in coordination with the TMAX Customers.

Managed a team of 6 Supply Chain planners to facilitate the smooth planning on a daily basis.Works with Benore IT Department to enhance the current supply chain process. Increased the visibility of the present IIM system by designing different reports. Designed an “Advanced Planning and Operations tool” which helps 4 departments to plan their resources way in advance rather than a 6 hour notice. This is a tremendous money saving and making concept used by Benore in tendering for new loads, man power allocation, accuracy in return loading process. Worked extensively on SAP ERP and Procurement Systems.Leading multiple onsite supply chain planning projects of Benore at BMW Re-engineered the process of truck load planning by automating it in excel and designed a template to incorporate the automation in the website. This process improved the accuracy, reduced human errors and saved 20 hours time a week for the load planning team. Working as the bridge between BMW supply planners and its vendors. Designed the template to catch the missing demand after manual planning. This saved the company with not only expedites but also with plant downtime heavy penalties. Trained the Load planning, Customer service, dispatch and load validation teams on DECISION MAKING

Tray Pack Division, Mt Olive Sept 2009- Present • Accumulated the data from manufacturing and demand planning which is required to design a Strategic Capacity model for the first time in TP division. This report is being used extensively by S&OP teams. Redesigned and semi-automated the entire Master Scheduling model (MPS) and the low level daily production planning model for the Tray Pack division. Conducted root cause analysis and eliminated the steps which caused human errors and improved the visibility of the inventory systems. Designed a database to report the distress product reason details which improved theefficiency and communication between the plant and supply planners. • Used Pareto analysis to identify the major causes for the distress and helped manufacturing (QA hold) and distribution (mis-rotation) concentrate on the same. Facilitated the weekly meetings between supply, demand, sales, CS, manufacturing, distribution and R&D teams. Entire plant operations, Longmont, CO Current responsibilities include master production scheduling, capacity planning for S&OP, deployment, raw materials, WIP and SKU inventory management and supply management across multiple facilities. Communicating with plant managers, planners, demand planners, customer service, shipping, 3PL logistics team, and purchasing to maintain smooth supply chain and to satisfy the customer demands. Designed an inventory analysis tool in excel to maintain minimum inventory across various DCsDesigned a new deployment tool that improvised the visibility of the system and used with multiple distribution centers. Saved 60% of the time taken by planners to do the daily deployment. Gathered the information from multiple departments to model the master production schedule both in Excel and MP Voyager. Trained co-planners to model their own plants. Designed a database to generate the Age analysis report for the entire butterball operations.

I designed a detailed framework to evaluate the supply chain risk involved with the Global companies. I performed the financial and weighted score card analysis for the fortune 500 companies including the SRM, spend management, strategic sourcing, category management and LHR analysis

Courses tutored automated systems engineering and manufacturing process engineering. Supervised labsessions for both Graduate and Undergraduate students. Developed course material and the course website.Worked on Latex, Omnigraffle, Tex shop.