Nuwan Sameera Email & Phone Number

Colombo, Wp, Lk

Sri Lanka

 Gathered and analyzed business requirements and translated the same into system / technical requirements. Created Process Flow Diagrams using MS Visio  Created project artifacts like Use Case documents and Functional Requirements Document. Employed UML methodology and thus created the Context, Class, Object, Activity, State, Sequence, and Collaboration Diagrams, using MS Visio. Facilitated Meetings to allow users / stakeholders from multiple teams to communicate with each other, resolve issues, and reaching consensus. Liaised between the business and technical teams towards providing feedback to both on implication of requests and escalating / resolving issues and conflicts. Worked together with the developers and testers towards tracking / resolving defects and bugs.

Sri Lanka

 Coordinate with TJL, TJP and PV on the day today system issues, follow it up and finish the task at the agreed date Develop the new reports based on user request and HOD approval Analyze the planning process and understand areas which can be automated with PV and do the continuous improvements. Do Monthly Audits to ensure that users are follow the standard processes and report to Head of planning of Scheduling & Head of CBE Manage the special projects based on the HOD’s approval Understand continuous changes of the customer requirements through customer visits to ensure Teejay has excellent customer service through PV Share progress report on the ongoing report developments m projects etc. weekly / monthly basis to the management Perform additional duties commensurate with the current role, as and when requested by management

Sri Lanka

 More than 8 years of experience in design, development and implementation of MS Excel MS Access/VBA based Applications. Proven background translating cell formulas in Excel into VBA code. Created Macros for Business Development. Automating, modifying, and optimizing reports in Excel Access. Experience in the development of financial applications using Excel and Access. Experience in redesigning, maintaining and supporting existing applications and tools especially in Microsoft Excel Access 2007 / 2010/2013/2016 Experience in Advanced Excel and its features like Pivot Tables, Charts, Functions, etc. Experience in migration of databases to MS Access utilizing tables, queries, forms, reports, macros, and modules. Experience in SQL statements, stored procedures using SQL server 2005/2008 and 2012 Experience in extracting, transforming and exporting data between different RDBMS and from flat file to Excel and vise-versa. Used MS Excel/Access VBA SQL to send system generated e-mails, manage and report embedded Excel documents. Created Dashboard in MS Excel. Good experience in the implementation of all phases of Software Development Life Cycle SDLC from requirements gathering through implementation. Prepared program level and user level documentation. Experience working according to internal standards and external audit standards. Excellent team co-ordination, organizational and interpersonal skills with result-oriented approach.List of automated reports and developed Systems (Benefits: -More Time saving/Not depend on the people)1. OTD follow-up report 2. Unit wise FG stock analysis report3. Projection VS Actual report4. Projection VS Actual machine utilization report5. Excess FG analysis report6. Projection Analysis report with constrain list7. Pre requests’ follow up report such as Awaiting greige, awaiting yarn and fb approval for future weeks 8. PFP status report9. Dye batch splitting template10. Non- confirmation report

Sri Lanka

 Worked as a Head of planning in Teejay Lanka print plant since Aug of 2017-2019 Performed all Forecasting, Material Planning, Master Scheduling, Shop Floor Scheduling, and Distribution Logistics Monitor the Sales forecaster numbers and Projection vs actual number on weekly basis  Monitor the RM inventory flow and gave the direction if any deviation with agreed flow.  Monitor the buffer stock level. Manage the Plant by utilizing maximum capacity and reducing utility cost. Monitor the numbers such as delivered quantity, to be delivered quantity, finished good stock, after produced quantity and to be produced quantity then gave required option to manage the plant. Developed a delivery quotation tool in excel with considering the main factors set up time, running time and  discharge print capacity constrains Developed and automated the following reports using data of M3 System with multiple filtering options with using my Excel VBA programming knowledge a) Booking reportb) OTD reportc) Delay reportd) WIP status report Do the delivery quotation of Samples and Bulk Prepare the daily and weekly print plans and circulate to the relevant people Conducting the daily production meeting Implement the new process to get correct data in M3 system Worked as a High-level planner and do the delivery quotation in Teejay Lanka in 2016-2017  Check the projection Check the RM and Capacity availability (Using Fast react system) If the RM available, planned it according the capacity availability then quoted the delivery If the RM not available, then need to be raised the PR Based on the RM in in-housed date the delivery will be quoted I have been worked for the achieve monthly sales target  Done the Yarn and Greige re consolation and share it with the relevant team Prepare the projection vs actual report and discussed with the relevant team with weekly basis.