SYBA MELODY Email: ****.******@*****.***
***** ******* **, ********* –OH Mobile No: 216-***-****
Professional Summary
• Over Ten years of experience in all facets of Software Development Life Cycle
including requirement analysis, designing, coding, testing, implementation and
production support.
• Possess expert Functional Knowledge in Manufacturing Domain Applications.
• Diverse experience utilizing Java tools in business, Web, and client-server environments
including Java Platform, Enterprise Edition (J2EE), Enterprise Java Bean ( EJB), Java
Server Pages (JSP), Java Servlets, STRUTS, Java database Connectivity (JDBC),
Hibernate, Jboss.
• Experience in Enterprise RDBMS, ER Diagrams, and developing SQL programs.
• Have been able to take different roles like Programmer, Team lead and Onsite
Coordinator.
• Developed System Design Specifications, Functional Specification and Test
Strategies from Business and Technical requirements.
• Experience in Object-oriented analysis and design (OOAD) using UML.
Experience to prioritize, organize, document, model and analyze
business/technical requirements.
• Strong understanding of Service Oriented Architecture concepts.
• Good problem solving skills and ability to produce results even under stressful
conditions with limited resources or in deadline-oriented environments.
• Experience in working directly with Business users to provide expertise on potential
solutions by researching the Change requests.
• Possess excellent interpersonal, communication and presentation
skills.
Skills
Programming Languages Java (J2EE), C, C++, PL/SQL
Platforms Windows, Solaris, Linux, UNIX
RDBMS Oracle, IBM DB2
Testing and logging Tools JUNIT, Log4j
Web Technologies AJAX, XML (SAX, DOM), XSD, XSLT, JAXB, Servlets, JSP,
HTML, JDBC, STRUTS
Middleware Technologies EJB, Hibernate
Application Servers Weblogic, Jboss
Job Function Analysis, Design using UML, Programming, Testing, Enterprise
RDBMS, ER Diagrams, and Writing SQL.
PROFESSIONAL CERTIFICATIONS
Sun Certified Programmer for the Java 2 Platform, Standard Edition 5.0
Professional Profile
Employer : Sherwin Williams
Title : Senior IT Analyst
Date of Employment : October 2007 Till Date
Employer : Patni Computer Systems (Consultant for GE Lighting)
Title : Senior Software Engineer
Date of Employment : Nov 2003 to October 2007
Employer : Vision Innovative Products pvt Ltd
Title : Programmer
Date of Employment : June 2002 to Oct 2003
Employer : National Informatics Centre
Title : Project Trainee
Date of Employment : Nov 2001 to May 2002
Project Information
Project 1 SSO/GEMS LOGIN’s Integration
Employer Sherwin Williams
Type Development - Business Applications
Role Programmer
Technology/Software Java, J2EE, Oracle, Struts, Hibernate
Duration April 2014 till Date
Remove Static Territory and Store Login Id's which are used by stores to login to Sher-
link and Source .Facilitate users to use GEMS login Id's to login into Sher-link/source
and CustPortal.
Map GEMS Job Titles to Sher-link User Roles and Groups
Remove Existing Store Cookies.
Responsibilities:
• Re-design existing database to in-corporate GEMS user information into
Sherlink.
• Create Mappings GEMS Job Titles to Sherlink User Groups/Roles. New Entities
are created on the top of Existing Entities to Map Job Titles to User Groups.
• Design Screens to facilitate Groups assigned to new Job Titles.
Project 2 National Accounts Rebates
Employer Sherwin Williams
Type Development - Business Applications
Role Programmer
Platform IBM-Mainframe, Windows
Technology/Software Java, J2EE, Oracle, Struts, EJB
Duration Aug 2008 till Date
The Price Record Card defines a National Account. The PRC initiates the National
Account creation. In support of the NA-create process, information is entered into a
System called Approach. Two basic pieces of information are entered: Customer Profile,
This consists of general information about the customer, and Pricing.
Information is also sent to District Control Pricing (DCP).
Responsibilities:
• Design, code and test Parent Maintenance, Account/Job Maintenance Screens
re-design changes.
• Creating History for Accounts and adjusting the dates with in Account/parent
relationship.
• Remittance Reports, Utilities, Facilitate to export Account information to AR.
• Maintenance and Enhancements
• Worked on bug fixing and enhancements on change requests.
Project 3 Career Source
Employer Sherwin Williams
Type Development - Business Applications
Role Programmer
Platform IBM-Mainframe, Windows
Technology/Software Java, J2EE, Progress, Struts, DB2
Duration October 2007 till date
The on-line Job Posting System facilitates employees of the Paint Stores Group and
Chemical Coatings Division. It helps to view and apply for open positions, check the
status of an application, or withdraw from a posting for which the user previously
applied. The user can reapply for an open position for which previously ineligible.
Responsibilities:
• Re-design and code from BEA portal to Struts.
• Programming all the screen design changes.
• Coding the Structural Changes that affected the fundamental protocol between
systems.
• Worked on bug fixing and enhancements on change requests.
• Maintaining and supporting the application.
Project 4 Store Staffing
Employer Sherwin Williams
Type Development - Business Applications
Role Programmer
Platform UNIX, Windows
Technology/Software Java, J2EE, Oracle, Struts2/Hibernate
Duration November 2010 to till Date
The Staffing application facilitates the DM’s and Store Manager’s to input/manage the
attendance and the hours worked at the stores. The stores can post the Full-time/Part-
time/Over-time hours. Budget hours are posted to from Oracle planning system.
ADP/Actual hours are posted back from Mainframe (POS).Generated Variance Reports.
Responsibilities:
• Converting the existing ColdFusion application to Java,J2EE
• Migrating the database tables from mysql to Oracle.
• Designed and developed the presentation layer which includes the development
of standards-browser compliant – user interactive web pages using CSS, Struts
(MVC) tags with Client side validation and unit testing.
• Tuned SQL statements, Hibernate mappings Maintenance and Enhancements
• Worked on bug fixing and enhancements on change requests.
Project 5 Over Stock Inventory
Employer Sherwin Williams
Type Development - Business Applications
Role Programmer
Platform UNIX, Windows
Technology/Software Java, J2EE, Oracle, Struts2/Hibernate, JMESA
Duration April 2011 to September 2011
The Overstock Inventory Reduction Program is an ongoing process to reduce inventory
On select slow-moving GOM and non-GOM products at our stores and distribution
centers.
A searchable catalog is available to show inventory levels of these select products by
DSC.
The Overstock Inventory Reduction Website has the following reports currently
available:
Product Category Reports (Interior Paints, Exterior Paints, and Industrial Maintenance)
Will display current store cost for products available through this program.
These reports also display the DSCs in which stock may exist .These reports are updated
on a weekly basis.
Responsibilities:
• Design, development and testing of the application.
• Using JMESA for displaying reports.
• Designed and developed business layer which includes the creation of action
classes, POJO/beans to handle user interactions through forms and integrated
with hibernate to handle backend functionality.
Project 6 EliteNet Lighting Returns
Employer Patni Computers (Consulting for GE Lighting)
Type Development - Business Applications - Non GUI
Role Technical Lead
Platform IBM-Mainframe, Windows
Technology/Software Java, J2EE, Oracle, DB2, TogetherJ, XML, XSD
Duration Sep 2006 till Date
Lighting Customers can enter and view returns via Elitenet or LDSS. Elitenet gets return
information from LDSS and is used by distributors, sales representatives and home office
personnel. This process facilitates the following:
Provide a single repository for both standard and customer specific Terms
& Conditions. Calculate size of an order at invoice net value and using entire
purchase order by accumulating across multiple product lines and SPA numbers
Responsibilities:
As a Lead Consultant and Onsite coordinator my responsibilities included
• Creating System Design Specifications from requirements and assigning the
development work to offshore.
• Involved in capturing the business requirements, design, development and testing
of the application.
• Designed class diagrams, sequence diagrams and high level technical documents.
• Use of the Struts Framework for the application based on the MVC design
paradigm.
Project 7 Post Sales Service
Employer Patni Computers (Consulting for GE Lighting)
Type Development - Business Applications - Non GUI
Role Technical Lead
Platform IBM-Mainframe, Windows
Technology/Software Java, J2EE, Oracle, IBM Onestop
Duration Jul 2006 till Date
Real time integration with 1-Stop and Orders DW is provided to enable Call Center
representative to retrieve submitted orders into Siebel.
It is a back office transaction done by the Industrial Call Center rep to give the status of the order
placed by customer.
Responsibilities:
As a Lead Consultant my responsibilities included
• Analyzing the requirements and preparing the Design Document for PSS-Onestop
interactions.
• Designed class diagrams, sequence diagrams and high level technical documents.
Project 8 ITR-Order Status and Order Entry
Employer Patni Computers (Consulting for GE Lighting)
Type Development - Business Applications - Non GUI
Role Analysis, Design, Coding, Testing
Platform Windows
Technology/Software JEEE, JSP, TSF, Oracle
Duration Mar 2006 to September 2006
Client GE Lighting -Cleveland
Order Status is a back office transaction done by the Industrial Call Center rep to give the
status of the order placed by customer.
Responsibilities:
• Estimating, analyzing the requirements and preparing the Design Document.
• Designed Low level Technical Specification from the High Level Design
Project 9 LSiebel
Employer Patni Computers (Consulting for GE Lighting)
Type Development - Business Applications - GUI
Role Lead Programmer
Platform IBM-Mainframe, Windows
Technology/Software Siebel, J2EE, TSF Framework, Oracle, 1-Stop
Duration Jan 2005 to August 2006
The system gives customers access to check the order status information by an
automated calling system. User can make a phone call, enter the input criteria and an automated
system will read out the data for the users.
Responsibilities:
• Detailed analysis of user requirements
• Creating System Design Specifications from requirements and assigning the
development work to team members.
• Developed the business layer logic and interacting with the front end Siebel
application.
Project 9 Fiscal Closing
Employer Patni Computer Systems
Type Development - Business Applications - GUI
Role Analyzing, Coding and Testing of 1304 Module
Technology/Software JSP, Java, TSF Framework, PERL, PL/SQL, JCL
Duration Nov 2003 to Feb 2005
Client GE Lighting
The GE MFGVCP Fiscal Closing system allows Plant Finance, Manufacturing,
Technology, Distribution, Product Management, Global Finance (Market Maker), departments to
keep their standard cost accurate and up-to-date in several systems.
Responsibilities:
• Analyzed one of the complex modules in Fiscal Closing 1304 module
• Preparing the Technical Specs for the 1304 op/Est and 1304 Report
• Coding 1304, Testing
Project 10 Excise Manufacturing/Trading
Employer Vision Innovative Products pvt Ltd
Type Development - Business Applications - Non GUI
Role Programming, Designing
Technology/Software Java, Swing, JDBC, Servlets, MySQL, HTML
Duration June 2002 to Oct 2003
Client Virchow Chemicals Ltd.
Ex-Wise Manufacturing/Trading is a Comprehensive automated tool, to the business
establishments registered with Central Excise and Customs Department. Ex-Wise Manufacturing
provides enhanced Graphical User Interface resulting in user-friendly screens for better user
interactions. This process mainly involves 4 phases Purchase, Process, Sale, and Returns
Education
• Master of Computer Applications - Graduated in Distinction
• Bachelor of Science
(Maths, Physics and Computers) - Graduated in Distinction