JD Edwards consultant
Resume:
JEY GANAPATHY US Citizen
Woburn, MA 01801 Cell (781)
**********@*****.***
PROFILE
Jey Ganapathy is a results driven, solution oriented, Senior Business analyst over 15 years of experience in full
life cycle implementation. Specialize in optimizing ERP Systems (JD Edwards Enterpriseone (9.0) and JDE
World) for Financials, HR/Payroll, and Distribution. Experience includes all phases of system implementation in
various industries such as Facility management, Real estate, procurement. Proven IT Strategist with strong
creative thinking, time management, problem solving and decision making skills with ability in sticking to the
project deadlines and team goals from inception to delivery. Good knowledge and exposure to Data Mining and
Data Warehousing concepts. Exceptional ability to maintain and build client relationships, frequent meetings one
on one with clients, able to comfortably converse with all facets in the clients organization. Experience in
conducting GAP analysis by identifying existing technologies, documenting the enhancements to meet the end
state requirements, User Acceptance Testing (UAT), SWOT analysis, Cost Benefit analysis and ROI analysis.
Extensive experience in the implementation, integration and development of marketing strategies within a team
oriented environment, utilizing quantitative and qualitative analytical skills. Worked in multiple global projects
including Asia, Europe, and Australia. Work well within team or independently and willingness to learn and adopt
new technologies.
SPECIALITY/CERTIFICATIONS
Oracle JDE E1 Finance Certified Implementation Specialist
o
Oracle JDE E1 HRM & ADP implementation specialist
o
Oracle JDE Solution specialist in Procurement
o
Fit/Gap analysis
o
Training documentation
o
Work flow diagrams
o
Business process Re engineering
o
Data Conversion
o
ETL
o
1
JEY GANAPATHY US Citizen
12 Hawthorne St Home:
Woburn, MA 01801 Cell (781)
775-3394
**********@*****.***
TECHNICAL SKILLS
• Process/Model Tools: MS Visio, Rational Unified Process (RUP), Rational Rose, Rational
Requisite Pro, Enterprise Architect, UML, MS Visio 2003, Use Case Diagrams, Activity
Diagrams, State Diagrams, Sequence Diagrams, MS Office.
Test Tools: Oracle OATS, Test Director, Win Runner, Load Runner
•
Methodologies: UML, RUP, SDLC, AGILE, SOA
•
• Javascript/Ajax,html
• PL/SQL develop
• T SQL,MY SQL
• Oracle BI publisher
• Insight report writer
• COGNOS Finance & EP
• Application: JDE Enterprise one 9.0
• Java/JSP,J2EE
• C/C++,XML,XSLT,XSD
PROFESSIONAL EXPERIENCE
Client: Fresenius medical care Oct 2014 Present
Business Analyst
Fresenius Medical Care offers quality health care products and services designed exclusively to meet the
changing health care needs of customers. They provide kidney dialysis services and renal care products,
including treatment options for later stage Chronic Kidney Disease to Medicare patient with End Stage Renal
Disease (ESRD). This project called for integrating the Renal Care Group (RCG) clinics patient data in the
Fresenius Integration Hub. This included upgrading the RCG ADT (Admission, Discharge and Transfer) HL7
messaging system to Fresenius ADT HL7 messaging system. As a part of this system migration and data
integration, error reports were created to examine if the interface accurately transformed the messages.
* Worked with Business Process Owners, Subject Matter Experts (SME) and Health Center users for
Requirement gathering in Definition Stage using Rational Requisite Pro.
* Worked with business representatives to understand requirements and priorities and ensure that software
development work is appropriately aligned.
* Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements
for the change in the proposed system.
2
JEY GANAPATHY US Citizen
12 Hawthorne St Home:
Woburn, MA 01801 Cell (781)
775-3394
**********@*****.***
* Created a plethora of SQL scripts to pull and manipulate large financial and clinical and demographic
datasets to deliver forecast model, operational strategies, to improve the revenue cycle performance.
* Document the Transfer Specifications and Implementation Guide for ADT messaging.
* Organized system risks into high, medium and low impact to help business analyze the level of effort for
remediation activities and ease resource allocation work.
* Participated in user meetings to understand requirements for the Data Warehouse design.
* Created various Use Cases and workflow diagrams, using MS Visio.
* Created Report Mockups and Sample Mapping documents for the Error Reporting and maintained
traceability matrix.
DTZ, Inc. Oct 2010 Sep 2014
Senior Business Analyst
* Participated in technology innovation initiatives (JD Edwards Mobility, RIAF, BI 11g, JDE
interoperability).
* Responsible for the Development of a Master Data Governance Model within a multi regional,
multi language, multi currency environment.
* IT Audit and map key business processes.
* Created a plethora of SQL scripts to add, change, delete, and extract data from database using
join, union, sub query, and other SQL techniques to process data from the same table, different
tables, the same database, different database, used SQL Loader to load data to JDE E1 system
to solve urgent business requirement.
* Responsible for documenting workflows and results of Business Analysis into Business Requirement
Document (BRD) and obtaining sign off from the client on specifications.
* Involved in converting the business requirements into Functional Requirements Document (FRD) and also
created business process models from the requirement specifications.
* Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and HCM users for
Requirement gathering in Definition Stage using Rational Requisite Pro.
* Led, Designed an enhancement HCM application allow HCM users to define complicated rules
on max vacation and sick accrual limits by service months, job start date and job types.
o The primary employee leave accrual program was automated into the pre payroll process and calculates the beginning
balance, hours taken, hours incremented to compare with the limit rules. When pre payroll is reset, this enhancement resets
all the hours back.
Project greatly improved the productivity of HCM staff through automation, and reduces liability.
o
3
JEY GANAPATHY US Citizen
12 Hawthorne St Home:
Woburn, MA 01801 Cell (781)
775-3394
**********@*****.***
* Involved in gathering, analyzing, distilling and clearly conveying complex information to business and
project team members through JAD sessions and designed a JDE/BI Publisher solution with XML object,
Report Definition and Word Template using JDE embedded BI Publisher to allow users to run a UBE that
automatically sends output to different external emails with bursting and data driven emailing.
Prior to this solution, users had to break down 300 page pdf and manually distribute to each business unit involving over 100
o
emails.
* Designed and Implemented a JDE/BI Publisher solution with XML object, Report Definition and
Word Template using JDE embedded BI Publisher to print pixel perfect Pay check, AP check,
1099s, W2, Invoice and Purchase order report with associated signature images and charts.
* Performed requirements gathering, business process analysis, design, development, test plan
design for a complex interfaces with Kronos software.
o The interfaces included employee information to Kronos, accruals to and from Kronos which involved creating table
conversions to process data into JDE custom table and UBE to edit and process the accrual information into Pre payroll work
file for the accruals to be processed into JDE Payroll Cycle, Time Cards from Kronos, and Work Order information to and
from Kronos.
* Creating user training document, employee on boarding document and SOP using Oracle UPK
tool kit.
* Performed Gap analysis for custom build application for Employee union payment application.
* Led and developed Corrigo work order Integration using JAVA and BSSV.
o Once an order is configured on third party software, this integration will update the data into JDE E1 tables in real time.
* Responsible for configuration, implementation and end user training of TWE, tax jurisdiction look
up and tax calculation. Vertex – Payroll tax monthly update load into JDE E1 for both US and
Canada.
* Production support for JDE integrations with other systems such as Corrigo, Cassandra and end
users and analysts by solving both urgent and long existing production issues.
* Served as mentor and resource for offshore application developers and users on JDE system
other JDE E1 tools as well as the business functionalities of Order to Cash, distribution and AR
modules.
* Experienced in writing Insight reports, testing and implementation of Stored Procedures and
Packages at database level using PL/SQL.
* Develop user guides and lead in person and over the web training classes for over 800 users
nationally.
* Created Regression testing scripts using Oracle OATS, Reviewed technical specifications to
develop test plans, test objectives and test cases. Worked closely with both the business and
development teams to coordinate and schedule testing efforts and QA to build and execute test
4
JEY GANAPATHY US Citizen
12 Hawthorne St Home:
Woburn, MA 01801 Cell (781)
775-3394
**********@*****.***
scenarios for Integration, Regression and involved in User acceptance test (UAT) process before
rolling out to production.
* Pre Go Live and Post Go Live support for North America Locations.
UGL Service Company Jun 2007 Oct 2010
IT Business Analyst
Due to an in depth knowledge of financial systems, processes and requirements, played an integral part
in the overall functional design of all internal facing projects for the company. Responsible for functional
requirements through design, development, build, test and production support for all internal facing
projects of UGL Services.
* Upgraded JD Edwards World A7.3 (legacy) to EnterpriseOne 9.0(java based Application):
o Used Agile software development methodology in defining the problem, gathering requirements, development iterations,
business modeling and communicating with the technical team for development of the system.
Responsible for documenting workflows and results of Business Analysis into Business Requirement Document (BRD) and
o
obtaining sign off from the client on specifications.
Involved in converting the business requirements into Functional Requirements Document (FRD) and also created business
o
process models from the requirement specifications.
Facilitated Joint Application Design (JAD) sessions with Research Analyst and Subject Matter Experts (SME) to identify
o
business rules and requirements and document them in a format that can be reviewed and understood by both business and
technical people.
Performed a GAP analysis which involved understanding the reports in the old financial management system.
o
Managed daily aspects of the project including, process definition, goal documentation, facilitating meetings, gathering
o
business requirements, issue management, user acceptance testing, vendor management and project team deliverables.
Participated in the development of overall test strategies/test plans for manual testing including definition of test cycles and
o
schedules.
Developed Test Plan/Strategy document. Worked closely with both the business and development teams to coordinate and
o
schedule testing efforts.
Assisted in developing test case objectives for verifying the accurate functioning of the system.
o
o Reviewed technical specifications to develop test plans, test objectives and test cases.
o Involved in UAT process before rolling out to production.
o Extensive use of TOAD to run SQL Queries for reporting purposes.
o Created customized SQL scripts to covert the data from legacy system to Enterprise one tables.
o Worked on profiling the data for understanding the data and mapping document.
o Involved in Data Quality Analysis to determine cleansing requirements.
* Employee benefit enrollment tracking tool:
o Lead client facilitation meetings to gather requirements (Inception phase), there after assisted tech leads in Analysis &
Design of architecture using OOAD approach using UML & Rational Unified Process.
Gathered requirements from SME and designed a batch application which reconciled the employee enrollment for
o
benefits detail, periodical deduction from paycheck and amount posted to GL. This enhancement greatly reduced the
amount of time for user to monitor and plan for employee benefit cost and budgeting.
ADP: Payroll Tax quarterly and periodic data interface from JDE to ADP.
*
o Identified, documented system bugs and data errors; communicated with programmers to resolve issues within budget
5
JEY GANAPATHY US Citizen
12 Hawthorne St Home:
Woburn, MA 01801 Cell (781)
775-3394
**********@*****.***
and before deadlines.
* Concur: Implemented a SaaS expense management system utilized by all company travelers.
o Conducted and participated in JAD Sessions periodically with various Subject Matter Experts at various phases of the
Development Life Cycle to discuss open issues and resolve them.
Implemented the integration between Vendor and JDE for bi directional with Java interfaces.
o
Functioned as a development liaison and advocate to outside departments and end users.
o
* Cognos TM1 implementation for budgeting and forecasting.
o Fulfilled role of SME for design of the ETL requirements. Assist in developing training material for End users.
* Led an enhancement to allow users to reconcile AP and Payroll checks from the bank and send
cashed checks to the bank automatically.
o This project included a new programs to prepare and process the bank file into custom table, reformatted the data, to
process it into JDE work files after user review.
Created a full suite of SQL reports to reduce manual work including exception reports and issued, cashed, canceled, un
o
cashed checks and summary reports.
* Canada Lighting Project:
o Lead for Inventory and Item Master Conversions. Advanced price implementation for various warehouse locations.
Supported Validation of Software for Inventory and Item Master Conversions as well as all Warehouse Functionality.
Unicco Service Company Apr 2000 May 2007
Business Analyst
* Corrigo work order management application:
o Facilitated business requirement gathering, assist in the definition of business process flows and developed related
documentation.
Lead client facilitation meetings to gather requirements (Inception phase), there after assisted tech leads in Analysis &
o
Design of Model View Control architecture between JD Edwards Sales Orders and Corrigo, a SaaS work order
management system using UML & Rational Unified Process.
Acted as a resource in understanding how IS systems carried out business functions and assisted in ensuring timely
o
and effective implementation.
Analyze and design Use Case diagrams, Sequence diagrams, Business Objects, Domain Object Model, and Visio to
o
depict process flows and PowerPoint presentations.
Implemented Traceability Matrix and User Requirement Specification Document (URS) verified the functionality
o
coverage.
Identified important user scenarios from Business and Functional Requirements to develop test cases, worked with end
o
users to define these test cases for testing functionality.
* Vendor Management System:
o Led cross functional team to design and build a Vendor Management System to be used for vendor self registration and
subcontractor sourcing supporting the company's operations staff. Additionally implemented the ability to rate vendors
through the system for added value when selecting vendors to use. This application is designed, developed and tested
the Websphere Portal Application based on Model View Controller (MVC) architecture deployed on IBM Web Sphere
Portal /Application Server.
Facilitated change configuration management and versioning.
o
Worked with customer service on UI related issues that were reported by customer and End users as well as developing
o
marketing strategies to promote the company’s products.
6
JEY GANAPATHY US Citizen
12 Hawthorne St Home:
Woburn, MA 01801 Cell (781)
775-3394
**********@*****.***
* ERP Conversion from Great plains software to JD Edwards:
o Extracting the business requirements from the end users keeping in mind their need for the application.
o Involved in gathering and documenting the requirements that were critical to the business process and using those
requirements to design application software using a Use Case approach.
Involved in converting the business requirements into functional requirements and also created business process
o
models from the requirement specs.
Played a substantial role in the process identification and definition and functional requirements gathering, in an effort to
o
develop a practical technology solution for automating the system.
Prepared Business Workflow models and used agile software development methodology to build new business
o
processes
Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of Rational
o
Unified Process effort in different iterations and phases of the Software Development Life Cycle
Outlined and modeled the process using UML to create use case diagrams and activity diagrams.
Used Rational Clear Case for revision control and configuration management.
o
o Worked extensively with the QA team for testing to ensure all quality requirements are met.
* AR Dashboard:
o Acted as a liaison between system users, client managers and software development team to gather requirements and
document workflows and results of Business Analysis into the Business Requirement Document (BRD).
Led Credit and Collections department in the development of an AR Dashboard to be rendered through the company's
o
portal.
Performed requirements documents and managed contractors to build an interactive real time system used by the
o
Collections department and Operations personnel to manage and track customer receivables.
Followed UML processes and standard operating procedures in developing Use Cases, Use Case diagrams and other
o
supporting documentation.
Played a key role in the planning, testing, and implementation of the new enhancements and conversions. Monitored
o
user expectations through user involvement and communication throughout the project lifecycle.
* Customer Profitability Reporting and ROI:
o Involved in gathering and documenting the requirements that were critical to the business process and using those
requirements to design application software using a Use Case approach.
Custom designed dashboard application accessed through the company’s portal using Rocket Software Visionary tool.
o
Designed involved data warehouse type backbone that can be viewed and aggregated based on user’s selection.
Performed Risk analysis of the requirements to identify the key business risks areas for the project and prioritized the
o
application development and testing.
Performed requirement walkthroughs with the Development and QA teams with the aim to develop testing strategies
o
and test plans such that test cases reflect user needs.
Tracked and maintained user requested enhancements and changes.
o
* BeneDetails:
o Facilitated Joint Application Design (JAD) sessions with Research Analyst and Subject Matter Experts (SME) to identify
business rules and requirements and document them in a format that can be reviewed and understood by both business
and technical people.
Implemented an on line Open Enrollment / Benefit management system managed through IPA a SaaS company. Used
o
to manage benefit options for over 8,000 employees with an automated bi directional interface with JD Edwards payroll
and benefits systems.
7
JEY GANAPATHY US Citizen
12 Hawthorne St Home:
Woburn, MA 01801 Cell (781)
775-3394
**********@*****.***
Keane Inc. Feb 1998 March 2000
JDE Principle Consultant
Keane helped me gain immense knowledge and experience in my overall growth as a professional. I had the
opportunity to work with many clients and implementation projects in industries like distribution, Manufacturing,
Service, Life Science, Auto Mobile etc. Involved in design, upgrade development for various JDE Edwards world
software modules. Developed functionality analysis for the fit of JD Edwards Sales Order Management and Purchase
Order Processing for a mid size wholesale food distributor.
Education: MS Computer Applications (1996), MK University, Tamil Nadu, India.
8
Contact this candidate