Oracle/J2EE Consultant

Resume Sumana Majumder

Sumana Majumder

Avenue Trembley 3, 1209 Geneva, Switzerland

Tel.: 41.764316599 Email: ******.********@*****.***

Oracle ERP/Fusion Middleware Consultant

• 8 and half Years of extensive experience in Java, J2EE and ADF based systems development

which includes System Analysis, System Designing, Programming, Debugging, Defect fixing,

Testing, Application Performance Analysis and Deployment and other products of Oracle Fusion

Middleware Stack like UCM and Integration experience with SOA Suite 11G specifically BPEL,

integration OF UCM with Oracle ERP.

• 2 and half Years hands on experience in Oracle ADF 11g Architecture, Oracle ADF Development

(ADF, ADF Faces, ADF Task Flows and Business Components) with Web Services.

• Extensive experience in all phases of SDLC & Agile Methodology.

• Experience in writing Object Oriented Concepts, Analysis & Design, RUP (Class and Sequence

Diagrams) by using Rational Rose.

• Experience in developing commercial web applications, Multi-lingual web apps, enterprise

applications and web services by using enterprise technologies, such as Java, J2EE, Struts,

Spring, JSF, Oracle ADF, Hibernate, EJB, JMS, JSP, Struts, Servlets, Beans, JMS, RMI, HTML,

JDBC, XML (XSL, XSLT, XPath), Web Service, SOA and AXIS.

• Excellent knowledge in RDBMS concepts (Oracle 11g) and strong SQL, PL/SQL query writing

skills (by using TOAD & SQL Navigator tools) Stored Procedures and Triggers.

• Extensive experience in deploying, configuring, and administering J2EE Application Servers like

Web Logic 10.1 and Apache Tomcat.

• Good knowledge in developing Stand-alone admin applications by using Java/ AWT and JFC/

Swing components.

• Strong experience in various IDEs such as JDeveloper 10g, 11g, Eclipse3.2.

• Expertise in source control tools like CVS, SVN, VSS and Clear Case.

• 6+ years of experience in Implementing multiple full life cycle ERP (11i and R12) implementations

following SDLC procedures through GAP analysis, Business requirements analysis, Technical

specifications design and documentation, conducting workshops with end-users, End user

training sessions, Legacy system analysis, Process to product mappings, Conversions and

Interfaces strategy, CRP, Integration and SWAT testing

• Good hands on knowledge in Change management, Instance Management using Mercury

Interactive (Kintana) configuration management

• Possess strong leadership, interpersonal and excellent analytical & problem solving skills.

• Excellent communication and leadership skills developed through technical team leading,

customer engagements and working with globally distributed product teams

• Experience in managing team and work remotely for offshore engagements

Desired Positions

Senior J2EE Implementation Consultant/ Architect/ Technical Lead.

Work Preferences

1

Resume Sumana Majumder

Location: Preferably Geneva

Availability: Immediate

Desired Job Type: Full Time, Part Time

Nationality: Indian

Residency / Visa: Authorized to work in Switzerland

Languages

English: Native /full working proficiency

French: Limited working proficiency (DELF A1 and DELF A2, Pursuing DELF B1)

Technical Skills:

Technologies: Java2, Swing, J2SE, J2EE, EJB2.0, JMS, JDBC2.0, MVC Architecture, Spring2.5,

Hibernate3.0, SQL, PL/SQL, MQ Series, Web Service, SOAP, WSDL, ADF Business Components and

Task Flows, Oracle Application framework( OAF),Oracle Workflow, BPEL, Oracle Forms and Reports,

XML Publisher reports

Web-Technologies: HTML, CSS, JavaScript, Servlets2.3, JSP1.2, JSF, Oracle ADF Faces, Struts2/1.1/,

Tiles, XML, XPath, XSLT, XSL and AJAX.

Application Servers: Oracle Application server 10G, Tomcat 5.0, BEA Web Logic10.1/8.1, Web Sphere

6.1/5.0, JBoss6.1.0

Oracle Development Tools: Oracle Developer Suite, Oracle JDeveloper 11g and previous versions, Oracle

Workflow Builder, Oracle Forms and Reports Builder, SQL navigator 4.6,Toad, Eclipse IDE, Rational Rose 2000,

RAD7.0/6.1, Ant, Maven 2.0.9, JUnit3.7, Log4j, SAX, DOM, DTD, XML Schema.

Design/Analysis: SDLC, OOAD, RUP and Agile Methodologies.

Databases: Oracle 10g/9i/8i, DB2.8.2, SQL Server 2000 and Sybase.

Operating Systems: Windows XP/2000/NT/95, DOS, AIX, UNIX.

Design Patterns: GOF (Singleton, Factory, Abstract Factory and Front Controller), J2EE Design Patterns

(Business Delegate, Session Façade and Service Locator) and many more.

Key achievements

1. Has been recognized as Star Performer, highest performance award in the organization, for 3

consecutive years.

2. Trained about 60 resources (internal and external) in fusion middleware technologies.

3. Designed numerous out of box solutions like UCM integration with Oracle ERP R12, integration of

UN portal into oracle ERP R12, integrating legacy and other fusion middleware systems into R12

stack and also resolved numerous critical problems, which were deemed not possible or very

difficult to achieve, in a quick time.

4. Appreciations from customer and our organization management for leading projects successfully

with-in the specified budget and timelines thus saving cost for company and customer

organization.

2

Resume Sumana Majumder

Trainings Undertaken

• Oracle Application Framework (OAF) - Oracle University

• J2EE technology stack – oracle University

Education

• Graduate in Electrical Electronics engineering Technology from one of the reputed institutes in India,

Visveswarya Technology University, Bangalore (2000-2004)

Professional Certificates

• Satyam Quality Management Certification – 2011

• ITIL Foundation Certification V3

• Prince2 Foundation certification

• Prince2 Practitioner certification

•

Professional Experience

(2006.March – 2012.October)

Oracle Fusion middleware Specialist/Technical Project Lead/Offshore Coordinator, International

Labor Office (ILO), Switzerland

Project: Oracle applications 11.5.9 implementation, Support and upgrade to 12.0.3, Custom Bolt on

development on R12, Support on custom modules built on J2EE architecture and ADF stack and

standard modules of Oracle ERP

Contribution:

• Serving as a Consultant to provide technical direction, design, and implementation at all stages of

the applications lifecycle.

• Evaluating alternatives, recommending approaches, leading design and creating solid technical

solutions for complex business requirements based on office policies and principles.

• Provide second level support for IRIS application. Investigate reported application problems,

conduct tests to isolate problems and root cause in order to prepare clear Incident Reports for

further investigation by technical operations and development experts. Conduct further diagnosis

and tests as necessary to assist with problem resolution investigating and implementing

workarounds where appropriate.

• Analyze the existing system UI, WebServices, core Java code and EJBs.

• Standardize a lot of java code and include JUnit testing after the fact

• Design and developed user interface components using ADF Rich Faces.

• Developed UI fragments, rich client side validations using JavaScript, ADF templates and

bounded task flows using Jdeveloper 11g.

• Developed, implemented validations and interacting services in managed beans.

• Developed Web Services to be invoked from managed beans and interacting to data layer.

• Developed ADF Model components (creation, configuration, and tuning of entity objects, view

objects, application modules, bindings and data controls). Responsible for developed ADF Data

Controls from Web Services and Java Components.

• Integrated different heterogeneity systems using middleware applications i.e. Oracle AIA, BPEL,

ESB, Web Services, XSLT into Oracle - Ebusiness suite 11i and R12.

• Integrated ADF based systems into oracle procurement using BPEL and oracle Workflow mailer.

• Proactively reviewing the stability-scalability of applications and participating in project delivery

and roadmap development. Demonstrate continuous effort to improve practices, decrease

3

Resume Sumana Majumder

turnaround times, streamline work processes, and work cooperatively and jointly with others to

provide quality seamless service for the Office.

• Provide out-of-box solutions for complex business requirements. Prepare comparative reports for

various solutions and draw cost benefit analysis.

• Preparation of specifications for the migration of data.

• Preparation of Technical design documents based on AIM methodology (MD70)

• Preparation of Unit and integration test scenarios (TE10, TE20 and TE30)

• Lead a team of 6 resources after relocating to India for a period of 6 moths for the Travel redesign

Project. Lead the team of developers through Planning, architecture, design, build, test, and

enhancement of corporate business solutions.

• Gathering business requirements from onsite and validating the functional specs to be in line with

the requirements. Drafting business requirements and technical documents.

• Implement and adhere to project management standards including preparation of status reports,

project plans, work estimations, etc. Prepare briefing materials and presentations as needed by

the Technical Section head.

• Act as a focal point contact for any support or enhancement work related to four custom modules

of IRIS system, TRAVEL, IPEC, ITRACK, ILO-AIDS. Collaborate with business units (FINANCE

and HR, IPEC, ITRACK, ILO-AIDS), to understand and anticipate change in business needs, and

suggest appropriate solutions to ensure business needs are met to the satisfaction of the office.

• Identify opportunities for changes to the processes, systems and structures that would result in

increased efficiency and effectiveness to the Office, at headquarters and in the field. Assist in

ERP planning, analysis, design, development and testing activities during IRIS upgrades and

Field roll out.

• Develop and maintain various applications (IRIS, IPEC, EVAL and ITRACK) using Java, J2EE

and struts framework

• Developing, unit testing and migrating components to UAT0 and Prod, by strictly adhering to

quality process/standards.

(2005. September –2006.March)

Technical Module Lead, British Airport Authority (BAA), UK

Project: Oracle applications 11.5.10 implementation and implement custom solutions using JSF,

JavaScript, ADF Rich Faces, JSP and HTML

Contribution:

• Analysis of the specifications provided by the clients.

• Convert business requirements, using flowcharts and diagrams, into sequence of detailed instructions

and logical steps, applying knowledge of computer programming techniques and computer languages

• Worked specifically on iProcurement (Oracle Finance) customization based on Oracle Application

framework.

• Design and developed multiple web (UI) pages using JSF, ADF Rich Faces, JSP and HTML.

• Develop the customization as per approved technical design.

• Responsible for building, debugging and tuning application using ADF 10g.

• Responsible for continuous integration and deploying custom app on Web Logic App server.

• Customization/Personalization on UIX pages using Oracle Application Framework with

Jdeveloper9.0.3 editor.

• Design and development of business intelligence reports using discoverer 4i

• Design data extraction routines for Data warehouse

• Undertake packaging of tested customizations into version control tool and prepare necessary setup

documentation.

• Undertake timely completion of fixes for bugs observed during integration testing.

• Adhere to the timely delivery of technical objects in accordance to the schedule.

• Adherence to the documented quality systems procedures. Preparation of specification for design

documents based on AIM standards which were used as templates for preparation of Functional

design, Technical design and Test cases,

• Updating and maintenance of the corresponding technical object related quality (project control)

documents

4

Resume Sumana Majumder

(2005. February –2005.November)

Senior Developer, Air India ERP Implementation, India

Project: Oracle applications 11.5.10 implementation, writing new custom client side validations using

JavaScript, developing web pages using,JSP,Struts Framework

Contribution:

• Requirement study for both developing new web pages to existing standard web pages

• Strategic solutions for historical data partitioning for performance optimizations

• Development of High level and detail design documents

• Development of validation framework using jsp based pages and JavaScript.

• Leading the Analysis and Design team for the Integration System

• Devising an integration methodology to integrate various modules of Oracle Applications to provide

information over WEB.

• Interaction with the ERP business analysts Team and Ewelfare Web Team

• Designing and firming up specifications for database

• Development and Implementation of the interfaces and Master Programs.

• Designing Unit and Integration Testing case studies and guiding the team in success execution of the

same

• Responsible for the Quality procedures related to the project

• Carrying out the Code review.

• Reviewing the deliverables to the client

(2004. October –2005.February)

• Web Developer, Qatar Telecommunication Services (QTEL ), Qatar

Project: Web Application (JSP, Servlets, EJB based applications deployed on 9iAS)

Contribution:

• Analysis of the specifications provided for the project

• Prepare a complete functional specification

• Prepare detailed and comprehensive design specification

• Developing code using JSP, Struts (using MVC architecture)

• Establishing connectivity to the database

• Responsible for maintaining the quality procedure during coding and also during preparing all related

documents

• Testing of the entire application

5

Contact this candidate