Implementation / Application Consultant
Reflex Planning Solutions LTD
Total years of experience :8 years, 7 Months
➢ Programming in PL/SQL to create procedures, functions and packages
➢ Worked with Oracle and MS SQL database
➢ Good Knowledge in Reporting Services (SSRS, Cognos)
➢ Knowledge in Design Patterns and Software Architecture
➢ Familiar with the complete life cycle of the project management.
➢ Knowledge in ASP.net for developing web application and C#.net for windows applications
➢ Experience in JavaScript and JQuery.
➢ Efficient client handling
Reflex Planning Solutions, Stafford UK Implementation / Application Consultant September 2011 - Till Date
➢ Extract data from different sources for different clients, Transform and Manipulate Client data, Load data to Intermediate database and build an actual demo system, . Implement once client signs off.
➢ To liaise with external clients to ascertain required development, then develop test and integrate functionality.
➢ Backup/restore databases, source codes, client management, client training, reports, and troubleshoots.
➢ Develop Applications for end users on automating their daily repetitive tasks.
➢ Maintains Systems for Inventory Forecasting, Supply Chain, Warehouse management system.
➢ Develop reports and dashboards using Cognos Report Studio, Query Studio and Analysis Studio.
➢ Support and management of the Enterprise Data-Warehouse.
➢ Prepare ad-hoc reports using SQL, Crystal Reports, SSRS and Excel
➢ Maintain/Enhance existing reports on Cognos, SSRS (Microsoft Reporting Services)
➢ Support and maintain user interface and run time performance.
➢ Management and delivery of projects and report requirements.
➢ Prepare and deliver training to end users.
Axiom Telecom, Dubai UAE MIS IT Consultant / Systems Analyst / Senior Systems Analyst August 2005 - August 2011
➢ Extract data from different sources and generate reports
➢ Develop Applications for end users on automating their daily repetitive tasks.
➢ Maintains Systems for Inventory Forecasting, Supply Chain, Warehouse management system.
➢ Develop reports and dashboards using Cognos Report Studio, Query Studio and Analysis Studio.
➢ Support and management of the Enterprise Data-Warehouse.
➢ Prepare ad-hoc reports using SQL, Crystal Reports and Excel.
➢ Maintain/Enhance existing reports on Cognos.
➢ Support and maintain user interface and run time performance.
➢ Management and delivery of projects and report requirements.
➢ Prepare and deliver training to end users.
Project Profiles:
#1 Title: Tudor Rose International (http://www.tudor-rose.com/) - Implementation
Role: Implementation Consultant
Tools: Reflex Demand and Supply Planning Solution, SQL Server 2008 R2, SQL
Server Reporting Services
Implemented Reflex Demand and Supply planning solution for Tudor, Europe's leading Export Market Management company, supplying British Brands around the world. This project is to provide a smart forecasting solution for the client and added supply planning module. These solutions ensure the company's Inventory to be at the most optimized level.
Responsibilities: ➢ Created a demo system from data provided (text files, excel files, etc)
➢ After contract signing, Started the actual system gathering all data directly from their host system SAP
➢ Designed the Interface from Host SAP to Reflex through MS SQL SSIS, generated stored procedures and scheduled Jobs
➢ Integrated email functions into their scheduled jobs for success and error notifications
➢ Defined Business Hierarchy and data streams
➢ Performed custom logic as per client requirements
➢ Designed and published management reports
#2 Title: Astro Lighting (www.astrolighting.co.uk/) - Implementation
Role: Implementation Consultant
Tools: Reflex Demand and Supply Planning Solution, SQL Server 2008 R2, SQL
Server Reporting Services, Sage
Implemented Reflex Demand and Supply planning solution for Astro Lighting. They are a British lighting company with a reputation for innovative designs and high quality manufacture of interior lighting, exterior lighting and many more.
Responsibilities: ➢ Created a demo system from data provided (excel files)
➢ Designed the Interface from Host Sage system to Reflex through MS SQL SSIS, generated stored procedures and scheduled Jobs
➢ Integrated email functions into their scheduled jobs for success and error notifications
➢ Defined Business Hierarchy and data streams
➢ Performed custom logic as per client requirements
➢ Designed and published management reports through SSRS
#3 Title: House of Dorchester (www.hodchoc.com) - Implementation
Role: Implementation Consultant
Tools: Reflex Demand and Supply Planning Solution, SQL Server 2008 R2, SQL
Server Reporting Services, Opera system
Implemented Reflex Demand and Supply planning solution for House of Dorchester. HOD makes a range of scrumptious chocolate products for some of the UK's leading hotels, restaurants, shops and venues and is now enjoyed around the world. Provided our system to control their Inventory and deliveries across their branches and clients.
Responsibilities: ➢ Created a demo system from data provided (text files, excel files, etc)
➢ After contract signing, Started the actual system gathering all data directly from their host system Opera
➢ Designed a Delphi application to extract the data from Opera system and integrated with SSIS
➢ Designed the Interface through MS SQL SSIS, generated stored procedures and scheduled Jobs
➢ Integrated email functions into their scheduled jobs for success and error notifications
➢ Defined Business Hierarchy and data streams
➢ Performed custom logic as per client requirements
➢ Designed and published management reports
#4 Title: Community Foods UK (www.communityfoods.co.uk) - Implementation
Role: Implementation Consultant
Tools: Reflex Demand and Supply Planning Solution, SQL Server 2008 R2, SQL
Server Reporting Services, CGA, SAP
Implemented Reflex Demand and Supply planning solution for Community Foods UK. They are Britain's experts in the procurement, sale and distribution of organic and natural dried fruits, nuts, seeds, pulses, grains and branded health foods. Helped them with their whole demand and supply chain
Responsibilities: ➢ Created a demo system from data provided (csv files)
➢ After contract signing, Started the actual system gathering all data directly from their host system SAP
➢ Designed the Interface from Host SAP system to Reflex through MS SQL SSIS, generated stored procedures and scheduled Jobs
➢ Integrated email functions into their scheduled jobs for success and error notifications
➢ Defined Business Hierarchy and data streams
➢ Performed custom logic as per client requirements
➢ Designed and published management reports in SSRS
Other Implementations / Clients
➢ Krispy Kreme Doughnuts UK - www.krispykreme.co.uk/
➢ Welspun formerly Christy Towels - UK
➢ All About Food UK - http://www.allaboutfood.uk.com/
➢ Hitchen UK
➢ NSI UK - www.uk-nsi.co.uk
➢ TGLynes - www.tglynes.co.uk
➢ Axiom Telecom UAE and KSA
2001 - 2005: Bachelor of Science in Computer Science, University of the Assumption, Pampanga, Philippines