Description
keyboard_arrow_downSKILLS
Redprairie,
JDA
MYSQL
JASPER REPORTS
NICELABLE
ORACLE
DDA
INTEGRATOR
- 5 years of IT supply chain, Logistics, distribution functional concepts and WMS (Warehouse Management System) Functional Analyst and consulting experience in Warehouse Management industry.
- Experienced to work in KOREA & JAPAN as a Business functional WMS consultant to help them in providing reporting analytical thinking, Configuration, process improvements, Problem-solving, time management, decision making , issue resolution, client user training, create SOP’s and post, implementation support at the time of UAT(User Acceptance Testing), SIT (System Integration Testing) ,E2E (End To End), Go Live.
- Proficient skills in IT, Engineering & Business ERP Application Consulting, Configuration, Training, managed services support, performing trouble-shooting, resolving database access and performance issues, including designing, development, unit/integration/End-To-End testing using competent methodologies, technology and tools, debugging and troubleshooting code related issues/defects, producing client deliverables such as detailed design documentation, unit test plans, test cases and well documented code, gaining an understanding of the unique business and technical requirements on each engagement to facilitate the most appropriate solution design and delivering the projects on time.
- Worked as WMS Training Lead to a group of new resource and trained them in Red Prairie WMS (Database)/ERP system and Business Processes.
Experience
______________________________________________________________
Jul 13 –Oct 17
Responsibilities:
Responsibilities As Training Lead:</ Main Skills
keyboard_arrow_downOther Skills
keyboard_arrow_down workbooks
JSP
database
SQL queries
Database system
C
warehouse environment
Citrix
Web based
SQL
Database software
UAT
MySQL Database
Data integrity
Programming
JIRA
ServiceNow
eclipse
scrum
Databases
PL/SQL
jboss
Bug tracking
screenshot
Database performance
Debug
ORACLE
Unit Testing
Apex
Database testing
performance testing
Oracle Developer
debugging
MySQL
relational database
Warehouse Management System
Visual Basic
Data driven testing
JASPER REPORTS
SQL Server
JavaScript
Toad
System Integration Testing
Visual Studio
java
test scripts
My SQL
Putty
application development
User Acceptance Testing
Database application
Html
Bugzilla
Work & Experience
keyboard_arrow_down 01.07.2013 — 31.10.2017
AMWAY; TIMKEN MINERS ALCON Responsibilities:
Responsibilities As Training Lead:
Projects:
AMWAY
Responsibilities as Functional Consultant
BROAN
COOPER VISION
Responsibilities as Cooper Vision Project Lead
TIMKEN
MINERS
ALCON 01.07.2011 — 31.08.2011
Programmer Analyst in smart-IS, WMS Consultant in Oracular(USA) * Providing Technical supports, assessing client business requirements and assist them in
configuration and implementation of the WMS (Warehouse Management Database system).
* RedPrairie/JDA WMS Consulting/Development and Configuration/Set-up in WMS in industry experience.
* Customize Red Prairie/JDA Database application software written in C, PL/SQL, Visual Basic, MOCA
and SQL Server relational database to meet client requirements and resolving database access and
performance Issues using Proficient technology, methodologies and tools.
* Investigate databases issues and resolved with providing efficient solutions, Apply SQA and
Testing Techniques (Unit Testing, Integration Testing), Create and execute Test Plans, Test Cases,
create documents, Deploy Rollouts and producing client deliverables such as detailed design
documentation, unit test plans and well documented code and Assist customer in the creation and
execution of test scripts focusing on application functionality and performance testing.
* Excellent experience in writing SQL queries to validate data movement between different layers in
warehouse environment.
* Actively participated in scrum activities (Sprint planning, Sprint review, Daily standup etc.)by
using Visual Studio Team Services (VSTS)
* Database testing (Data validity, Data integrity, Database performance, Data driven testing)
* Proficient in creating Commands and RF/GUI screens using MOCA language (SQL Queries), RP DLx
Client and Putty.
* Efficient in creating Jasper Reports, RP Writer Report designer and NiceLable.
* Increased Knowledge of Integrator.
* Reporting Bug on Bug tracking tool or Project management tool name as JIRA, Bugzilla, ServiceNow.
_________________________________________________________________
* Responsible for creating and updating documentation to include: revising project specific
documentation, updating configuration workbooks, standard operating procedures (SOPs), Manuals and
product release notes.
* Coaching supply chain consultants on RedPrairie/JDA WMS's (Database) functional and development
framework.
* Conduct trainings; Lunch & Learn; take assignments and tests at the time of probation of new
resources. Multilevel Marketing Company (Amway) Company in USA/KOREA/JAPAN/PHILLIPINE/INDONESHIA and almost
more than 80 countries.
* Configuring JDA (RedPrairie) WMS application to meet customer needs, Provide Training to SME's
(Subject Matter Expert) and gave them live support at the time of System Integration Testing
(SIT), User Accaptance Testing (UAT) and End to End testing (E2E) in KOREA and JAPAN warehouses
APAC 2 and APAC 3 on Amway Warehouses.
* Managed and created training/Test case materials/SOP's in HPQC used for Client and identify the
gaps, and add details (steps, screenshot) when necessary.
* Lead functional and technical discussions with the client including integrating WMS to ERP and MHE
systems.
* Aids in preparing and analyzing project plans and documentation. Work closely with team members to
understand client needs.
* Worked with SME's to monitor system performance, fixed production data issues and also provided
solutions to the business users.
* Responsible for assisting on reporting: develop SQL (MOCA)queries, organize and extract data
* Resolved database usage issues and malfunctions and ensured performance, security, and
availability of database (RedPrairie/JDA WMS).
* Resolved and troubleshoot complex Red Prairie and Database issues at the time of pre & post
Go-Live operations support.
* Incident management and Solving Problems on time resolution of customer issues.
* Perform WMS operations like cycle counting, receiving, shipping, inventory reconciliation,
palletization, consolidation, putaway, labels, reporting etc
* Understand customer technical specifications and created solution designs.
* Researches and thoroughly understands requirements, Process Flows and develops effective solutions
to meet the expectations of the customer.
* I participated in the Go-live of the WMS (Red prairie/JDA) Database system in KOREA and JAPAN.
House Accessories Manufacturing Company in USA
Conducted manufacturing life cycle analysis of the company to redesign the business processes in
such a way that they can use the Red prairie WMS Database system for their manufacturing cycle as
well.
Contact Lens Manufacturing (COOPER VISION) Company in USA/UK/BELGIUM
Added enhancements in the Database system (RedPrairie/JDA WMS) according to the client's requirement
keeping in view the efficiency of the software.
* Lead business/Managed Services Support analyst for 3 independent regions (USA, UK and BELGIUM).
* Resolved critical database (RP issues) per request that includes DDA, Integration Events, RF
Screens, new user's roles, Services bounce. Citrix receiver, cluster restart on their production
environment.
* Responsible for full lifecycle ownership of WMS operational improvements opportunities: Discovery/
Reporting/System issues/Configuration/ Proven Track Records/ Testing/ Implementation/
Documentation/ Monitoring/ Usage.
* Analyzed Data take on and DB locks issue, debugging and troubleshooting code related
issues/defects.
* Database testing (Data validity, Data integrity, Database performance).
* Increased an understanding of unique business and technical requirements on each engagement to
assist the most appropriate solution design.
* Created SOP's of managed services support project issues with resolution steps.
* Achieved analysis of inbound and outbound processes of WMS to increase efficiency according to
client's requirements.
* Troubleshooting with SQL queries (MOCA) crashes and trace logs.
* Customizations in the functionality of RedPrairie Database system while keeping RedPrairie in sync
with its default functionality.
* Responsible for managing assigned escalations, researching or providing root cause analysis, and
adhering to client SLAs.
* Responsible for gathering completing systems configuration changes and testing to ensure the
application changes work as designed to meet client needs.
* Proven experience in life cycle application development with the ability to generate application
development policies, standards and procedures. Third Party Logistics (3pl) Company Third Party Logistics (3pl) Company in USA
Third Party Logistics (3pl) Company in USA
Contact Lens Manufacturing (Alcon) Company in USA
* Added enhancements in the RedPrairie WMS (Database) according to the client's requirement keeping
in view the efficiency of the Database software and upgrade from most updated version.
* Debug and resolve a variety of issues (bugs, performance, and user) by reading through trace
files.
* Apply rollouts as per request.
* Continued to provide customer support remotely.
* Resolved critical Database application issue on their production environment..
* Manage day by day tickets/bugs with proper tracking and documentation.
* Reviewed SQL query performance and optimizing code.
* Designing and coding database tables to store the application's data.
* Created table indexes and replacement patterns to improve database performance.
* Program, implement, and test a collection of new modifications and standard functionalities.
* Experienced on JDA WMS Discrete application, configurations and changes related to MOCA
technology, testing, Reports and Labels, integrator, jobs, alerts etc. * SFS (Software Functional Specification)
* Created manuals of Apex ERP Product.
* SRS Document of Campus Management System.
* Web based POS(Point of Sale) application using Html, JSP, JavaScript, My SQL server, SQL YOG.
* JSP Programming using eclipse, My SQL (worked on small POS system).
* Migrate Database Application to java using jboss developer studio)
* Develop POS (Pont of Sale) Application in Oracle Developer 10g and Toad.
* Created and presented Formal Presentations on JAVA.
* Worked on ERP Ajex solution Reports. SCO Special Communication Organization SCO Special Communication Organization, Rawalpindi
1 Month Internship
PROJEKTHISTORIE
* 5 years of IT supply chain, Logistics, distribution functional concepts and WMS (Warehouse
Management System) Functional Analyst and consulting experience in Warehouse Management industry.
* Experienced to work in KOREA & JAPAN as a Business functional WMS consultant to help them in
providing reporting analytical thinking, Configuration, process improvements, Problem-solving,
time management, decision making , issue resolution, client user training, create SOP's and post,
implementation support at the time of UAT(User Acceptance Testing), SIT (System Integration
Testing) ,E2E (End To End), Go Live.
* Proficient skills in IT, Engineering & Business ERP Application Consulting, Configuration,
Training, managed services support, performing trouble-shooting, resolving database access and
performance issues, including designing, development, unit/integration/End-To-End testing using
competent methodologies, technology and tools, debugging and troubleshooting code related
issues/defects, producing client deliverables such as detailed design documentation, unit test
plans, test cases and well documented code, gaining an understanding of the unique business and
technical requirements on each engagement to facilitate the most appropriate solution design and
delivering the projects on time.
* Worked as WMS Training Lead to a group of new resource and trained them in Red Prairie WMS
(Database)/ERP system and Business Processes. Attachments
keyboard_arrow_down