Sunil Nair
*** **** ****** **, # ****,Chicago,IL 60601 . *******@*****.*** .Tel -
TECHNICAL PROFICIENCIES:
ERP Package: JD Edwards Enterprise One 8.0
Document Management too: Optio design studio 7.8
Programming Languages and Tools: C++, SQL, PL/SQL, VB 6.0, Java 2.0,
VB.Net, Crystal reports
RDBMS: Oracle 9i, SQL Server 2000 & MS Access
ETL Tools: DTS
Education:
Master of Science in Information systems (MIS)
University of Wisconsin, Oshkosh
Major Electives: Information Sciences & Computer Applications
Bachelor of Technology in Mechanical engineering
Brief description of my experience:
IT Professional with 9 years of experience in the Software Industry
including 7 years on JD Edwards as Project Technology Lead and Analyst. I
have solid technical foundation, extensive experience in system analysis,
software design, development, problem-solving, and troubleshooting and
system integration...Proven skills in scope, schedule and resource
management on support and development projects and proficient in both
management and development. I actively involved in the complete project
life cycle of implementation of Financial, Human resources & Payroll and
sales & distribution modules.
PROFESSIONAL EXPERIENCE:
SIGNIFICANT PROJECTS: (in reverse chronological order)
JDE Application Development Team Lead
ServiceMaster Inc., USA
(Mar-'04 - Sep -'09)
Project Name: Enterprise Application Development for ServiceMaster Inc.
Environment : JD Edwards One World 8.0, DB2 on AIX, Terminal Server
Development and
Optio design studio 7.8 for document management
system
Description :
ServiceMaster Company provides service to residential and commercial
customers in the United States and serves 10.5 million homes and businesses
each year. ServiceMaster has implemented JD Edwards One World across all
its brands to develop consistent financial processes using the JD Edwards
ERP by creating a single enterprise instance. Modules implemented are Human
Resources & US Payroll, Fixed Assets, Accounts Payable, Accounts Receivable
and General Ledger, Sales Order and Distribution
Roles/Responsibilities:
. Coordinate with the One on One project management leaders, team leads,
& SVM IT to deliver JD Edwards (ERP) based solutions that support the
project's needs.
. Requirement Analysis and preparation of Technical Specifications
. Design, Construction and testing of Reports and Conversions HR,AR,FA,
GL, AP Reports
. Involved in the development and modifications of Custom
interfaces/reports in HR module
. Assistance in Implementation
. Design, develop, and test JD Edwards programs, reports, and/or forms
to meet the business requirements.
. Design, develop, and test interface programs to existing systems or
data feeds to meet the process design and business requirements.
. Design, develop, and test data conversion and data load programs to
support migrating data from existing systems.
. Develop application code and documentation in adherence to established
programming standards.
. Designed and developed the DTS packages for data migration and
conversion purposes from the mainframe to SQL server as well as JD
Edwards
. Project lead and developer for conversion/migrations from legacy
systems (ten years data) from mainframe system to SQL server via DTS
. Developed and managed the Optio documents for AP checks, Payroll
checks, AR statements, invoices and all the relevant optio documents.
Environment: Windows NT, JD Edwards ERP8.0, and SQL Server, Optio design
studio 7.8
MIS Network Administrator & Graduate Assistant
University of Wisconsin, Oshkosh
(Feb-'02 - Jan '04)
. Managed network equipment such as Novel Netware, Win 2000 server,
switch and router for academic use.
. Installed and configured the imaging system (Ghost server and
Client) for the MIS Lab.
. LAN Administrator, where I was responsible for maintaining the
Microsoft LAN and WAN environment.
. Implemented and administered network information services (NIS) for
multiple domains.
. Configured all servers and workstations to system requirements.
. Monitored network traffic and adjust system parameters to increase
system performance
. Set up and managed the internet connection using DNS and firewall
. Teaching Assistant to faculty members
JD Edwards Developer
Oracular Systems & Software
(Apr '01-Jan '02)
Client: Appleton Coated Papers Wisconsin
Role: Coding, testing and implementation.
Description: JD Edwards ERP Project in one of the paper
manufacturing company in Wisconsin.
. Developed an interface program using table conversion to link
existing material handling database with the JDE manufacturing
systems to track the movement of Rolls in and out from the
material handling equipment
. Created a UBE that reads the data from the Z table that was
populated by the F43199 trigger and inserts the appropriate
record in to the Champs queue table
. Created Production history application P553121 to accomplish
simplified data entry and roll to roll genealogy tracking.
. Developed reports involving JDE financials, including those
related to Purchasing, Sales Order Entry, Inventory, Costing,
Work Orders using JDE and Seagate Crystal report
. Responsible for several customizations of applications, program
modifications and business process documentations.
. Created new reports for the client requirements and modified
the existing reports to get client required format.
. Module that worked on includes Inventory Management,
Procurement, Order Management and Manufacturing Management.
The interface created between the materials handling department
communication software with the JDE had saved lot of person-hours
and time for the company
Environment: Windows NT, JD Edwards XE, and SQL Server
Programmer Analyst,
Oct.'00 -Apr.'01
Unique Software Services
This is the web-based project developed to maintain the orders tracking and
payment for the consultancy services. We used MS Access 2000 for Database,
Data Entry and Reports. Queries are used for report building. Access forms
are used for data entry. We used lookups for entering data from the master
tables. This is a Standalone application on a single PC of the Accounts
Manager
Environment: MS Access, Windows 98, Java
Software Engineer,
Feb.'00 -Oct.'00
OnTrack Information System
Role: Designing, Coding, testing and implementation.
Description: Website designing for storing patient medical records on
line. It consists of reliable systems for gathering and storing
clinical data patient encounter. It also provides Internet services to
customers to login and register their appointments.
Environment: Windows NT, Java, JDBC, HTML, Java Script, Oracle.
JD Edwards One World Developer
Jun.'99- Jan.'00
GT Business Solutions India
Job Responsibilities:
. Planning of Distribution implementation project.
. Created new Data Dictionary fields, Batch & Interactive versions,
UDC tables,
. Processing Options and extensively used Enterprise Report Writer
to generate Reports.
. Package Management tasks include Package Assembly, Package Builds,
Package Deployment and Package
. Enterprise Server Setup and workstation installations Installation
. Worked with FDA, RDA, TDA, VDA, UTB and cross-reference Utilities
. Business Process Analysis & Documentation
. Defining Activity Rules, Status Codes and Document Types, Receipt
routing methods, UDC, NN, Setups, Reports formatting
. Preparation of CRP Environment
. Customized Reports Design and testing
. Created new Data Dictionary fields, Batch & Interactive versions,
UDC tables, Processing Options and extensively used Enterprise
Report Writer to generate Reports.
Environment: Windows NT, JDE-ONE WORLD. Oracle 8i
Software Support Engineer
Aug.'96- Jun'.99
Almoayyed International, Bahrain
Role: Involved in an entire life cycle starting form analysis, design
and development of human resources and customer management modules.
Description: Engaged in the in-house development of AS/400 project
involving the human resources modules and customer Management modules.
Developed in OS/400 operating system used RPGILE and ILECL languages.
It involves designing, coding and customization includes payroll system
design to calculate the salaries of employees falling under various
categories and generate salary slips and other related MIS reports.
Environment: AS/400, OS/400, DB2/400, RPGILE, SQL/400, and V3R7.