PROFESSIONAL EXPERIENCE:

• Over 10 years of experience as Techno Functional consultant in JD Edwards OneWorld Xe/ EnterpriseOne which includes Development of objects, Code retrofitting, ETL Testing, System Analysis, SQL,PL/SQLprogramming, SIT and UAT Testing
• Widespread knowledge in building teh Test Strategy & Estimates, Test Case development, Test Execution, Reporting and Regression Testing
• Microsoft Certified Professional in SQL Server 2000
• Sound knowledge in Katalon Test Automation tool
• Hands on experience in Informatica DVO and Power Center
• Hands on experience in Magnitude (Kalido) - MDM (Master Data Management) tool
• Experiance in Collibra - Data Governance tool
• Good Knowledge in Python and Django
• Experience in gathering teh requirement from teh users and preparing Technical Design Document
• Experience in fine tuning teh performance of reports and interactive applications
• Efficient in writing ComplexSQLQueries and use of analytical functions
• Experience in Unit and SIT testing, Debugging and Bug fixing during UAT
• Worked at client location Dublin, Ireland for JDE functional project and had direct interaction with client
• Experience in working on Agile & WaterFall methodologies
• Excellent knowledge in Software Testing Life Cycle
• Obtained a Letter of Recommendation from Client for successful completion of teh project with zero defect
• Familiar with HP ALM, QC, ServiceNow, GIT Hub and Rally tools
• Worked in JDE Upgrade and Migration projects
• Extensive knowledge in various JDE Versions like Xe, 8.10, 8.11, 8.12 and 9.1.
• Expertise in using JD Edwards EnterpriseOne/OneWorldXe Application development tools Form Design Aid, Enterprise Report Writing, C & NER Business Function design, EnterpriseOne Debugger
• Good experience in JDE Sales Order Management, Procurement, Manufacturing, Inventory and Finance modules
• Exposure to NET, C#.NET and ASP.NET
• Excellent communication skills to interact with individuals at all levels
• Highly flexible and adaptable contributor; adept at multitasking, meeting deadlines, and thriving in a fast-paced environment
• Quick Learner and Good team player with solid work ethics and Good Analytical skills

TECHNICAL SKILLS:

Domain Knowledge: Manufacturing, Sales and Distribution, Finance, Inventory and Procurement

ERP Tools: JD Edwards Xe, 8.10, 8.11, 8.12 and 9.1

Tools: Informatica, Magnitude MDM, Katalon, Collibra, Git Hub, BizTalk, Cognos, Hyperion, Primavera

Languages: Python, Unix, C, C++, ASP.Net, XML and XSLT

Database: SQL Server 2005, 2008, 2017 Oracle 10g & 11g and AS 400

Defect Tracking Tool: HP Quality Center, HP ALM, ServiceNow, JIRA & Rally

Operating System: Windows 10, Windows 7, Windows XP

PROFESSIONAL EXPERIENCE:

Confidential

ETL - QA Analyst

Tool: ServiceNow, Rally, Magnitude MDM (Kalido), Informatica, Katalon and GIT Hub

Database: Oracle SQL Developer, MS SQL Server Mgmt Studio 2017

Responsibilities:

• Responsible for handling teh day to day production support tickets by analyzing teh issue and providing teh RCA by looking into teh Informatica mappings and workflows and resolving it by executing Firefighting scripts if required and act as a QA for all teh enhancement works for both Production support development and MDM enhancements.
• Responsible for preparing Test estimates, Test strategy & Test plan document and obtain sign off from teh BA’s
• Ensure business/functional scenarios are covered
• Preparing SQL queries and validating teh data from upstream to downstream in Oracle SQL Developer and MS SQL Server Mgmt Studio 2017 (for MDM)
• Verifying teh data in Direct Entry application, EDW, FDW and Magnitude
• Responsible for doing teh necessary regression testing where ever possible
• Responsible for preparing test results document and provide sign off from QA side.
• Responsible for providing Peer reviews for any of teh fire fight scripts that teh team prepares and provide sign off from QA side by executing teh query in teh necessary DB schema to identify that it would not have any impact other TEMPthan wat it is expected to do.

Confidential

ETL - Test Analyst

Tool: Informatica, JIRA

Database: Oracle 11g

Responsibilities:

• Responsible for preparing Test estimates, Test strategy & Test plan document and obtain sign off from teh Business Stakeholders
• Maintain RTM and ensure no requirements are missed
• Ensure business/functional scenarios are covered
• Preparing SQL queries and validating teh data in SQL Developer
• Verifying teh data in SQL Developer and validating, in different layers like, Target & Stage
• Create test data in sources for System & UAT testing with respect to Business Requirements
• Coordinated with multiple vendors to bring teh data into DB
• Responsible for ETL Jobs which used to load teh data from different source systems to Development & QA Db’s (EDW)
• Conduct defect triage meeting with Development, Project, Business team on teh defects
• Prepared weekly status reports and reported it to Project team and Business

Confidential

ETL Test Analyst

Tool: Informatica, JD Edwards EnterpriseOne 8.12 and 9.1, Biztalk, Cognos, Hyperion, HP Quality Center 10

Database: SQL Server 2008

Responsibilities:

• Responsible for Non-Prod environments (Dev, QA & UAT) & Prod (Production & Disaster Recovery) environments testing, to ensure teh data transition from JDE v8.12 to v9.1 happened successfully
• Verified ETL transformation logic when data loaded through different layers
• Responsible for preparing Test estimates, Test plan document and obtain sign off from teh Business Stakeholders
• Create test data in sources for System & UAT testing with respect to Business Requirements
• Responsible for Debugging and Bug fixing during UAT
• Responsible for maintaining and handling teh day to day Technical/Interface support tickets that teh client’s login in HP Quality center.
• Develop and Support JDE Finance module and several interfaces.
• As a technical lead prepared teh Feasibility report and Technical design document for teh Upgrade project JDE v8.12 to v9.1.
• Involved in object retrofitting and functional SIT testing.
• Involved in finding teh root cause analysis of few defects and provided teh solution for teh same.
• Developed FlowOne application as per client’s requirement.
• Managed a team of 5 members and responsible for allocating work to them
• Review and Fine tune teh code prepared by teh team members
• Ensure business/functional scenarios are covered
• Prepared weekly status reports and reported it to Project team and Business

Confidential

Functional Consultant

Tool: JD Edwards EnterpriseOne 8.0, HP Quality Center

Database: Oracle 11g

Responsibilities:

• Worked in client location Dublin, Ireland for JDE functional project and had direct interaction with client
• Single On-Shore and Off-Shore techno functional support person
• Accountable for Requirement gathering from Business Team
• Developed JDE applications and reports as per user requirement.
• Performed support and maintenance for JD Edwards's Accounts Payable, Warehouse, Procurement and Distribution Modules
• Incident management as a part of JDE EnterpriseOne production support.
• Responsible for preparing test estimate and test plan/case documents
• Responsible for Unit and SIT testing, Debugging and Bug fixing during UAT
• Responsible for maintaining and handling teh day to day functional support tickets that teh client’s login in HP Quality center.
• Involved in finding teh root cause analysis of few defects and provided teh solution for teh same.
• Holding teh major responsibilities in Test execution and defect reporting
• Preparing daily, weekly, monthly status reports and responsible for presenting teh projects progress to teh client
• dis is a proposal from HCL for a new project which interfaces JDE with Primavera
• Responsible for interfacing JDE with Primavera and took care of movement of data from JDE to Primavera without any interruption
• Accountable for preparing test estimates & test plan document
• Responsible for development and testing activities in JDE side

Confidential

Technical Consultant

Database: SQL Server 2008

Responsibilities:

• Responsible for developing and testing teh objects as per client requirement and Peer Review teh objects created.
• Accountable for maintaining and handling teh day to day support tickets that teh client’s login in HP ALM
• Liable for handling change requests for few applications as per client’s requirement.
• Responsible for preparing Functional and Technical Design Documents for all teh CR’s
• Responsible for presenting teh deliverable to teh client, with respect to teh requirements
• Defect Prevention anchor for teh team

Confidential

Technical Consultant

Tool: JD Edwards EnterpriseOne 8.10

Database: Oracle 10g

Responsibilities:

• Single Off-Shore developer who is fully responsible for analyzing and decomposing teh requirement of client
• Responsible for preparing Functional and Technical Design Documents for all teh objects
• Took entire responsibility for designing and developing different objects for Accounts Payable, AR and General Accounting module
• Developed Reconciliation Reports for Sales module
• Responsible for preparing test estimates & test plan document
• Prepared SQL queries and validated teh data
• Responsible for verifying teh data and movement of objects to different layers from staging to production
• SPOC for test execution and defect reporting
• Prepared weekly status reports and reported it to Business team
• Completed teh project as a single resource with zero production defects

Confidential

Technical Consultant

Tool: JD Edwards OneWorld XE

Database: Oracle 10g

Responsibilities:

• Involved in understanding of business processes
• Involved in teh development of LLD’s for reports and business functions
• Responsible for teh design and development of Reports and Applications for various requirements of client
• Prepared Test Effort Estimation and Test Strategy document
• Responsible for Unit and SIT testing
• Responsible for preparing teh test cases to test teh report and Peer Review

Confidential

Technical Consultant

Tool: JD Edwards EnterpriseOne 8.12

Database: SQL Server 2005

Responsibilities:

• Involved in understanding of changes from 8.0 to 8.12
• Involved in comparing teh object code after teh spec merge from 8.0 to 8.12
• Retrofit teh applications, reports and other related Data Structures
• Involved in analyzing teh Requirement, identifying teh test scenarios, manage teh RTM
• Preparation of Test cases
• Responsible for Unit and SIT testing
• Worked as a mentor for new joiners and guided them with teh project activities
• Involved in teh requirement study, design and development of reports
• Developed Reports like Printing A/R Summary details based on teh select Criteria, Printing Sales & Gross Margin Summary, Printing Inventory Details for teh Financial Accounting Period, Printing All teh Location for teh Item and teh entire Item for teh Location, Printing Finished Goods Inventory for Fiscal Period etc.
• Involved in preparing of Test cases
• Responsible for teh testing teh report and Peer Review
• Involved in preparing SQL queries and validated teh data
• Responsible for creating stored procedures
• Created XSLT for reports Responsible for teh testing teh report and peer review