Project Oracle

Sudipta Das

Address: Waukegan, IL

Email: *******.*******@*****.***

Mobile: +1-224-***-****

LinkedIn: http://in.linkedin.com/pub/sudipta-das/21/956/75

OBJECTIVE:

To obtain a senior software developer position in a prestigious company where I can leverage my experience in designing, programming and operating high technology applications with emphasis on SOA, business process analysis and quality assurance. I am seeking a project with emphasis on SOA, Java, Oracle Fusion Middleware, and OSB to work as a senior developer or a developer lead.

SUMMARY

Sun Certified Java Programmer 1.5

Oracle SOA Foundation Practitioner – 1Z0-451

Technical expertise in Oracle SOA Suite, Weblogic, Oracle Service Bus and Oracle Data Integrator.

Java consultant with expertise in Spring, Struts, Hibernate, Ibatis, Web Services, XML, XSLT.

Experience in creating software using JAVA, J2EE, EJB, Struts.

Technical Consultant with expertise in Weblogic and fusion middleware technologies.

Expert Knowledge with UML and Proficient in creating Use Cases and architectural diagrams.

Experience in developing Three-tier and N-tier/MVC Architecture applications using J2EE and SOA design patterns.

Experience in configuring, deploying and integrating applications on Sun Solaris, Linux and Windows XP Platforms.

Experience in systems analysis, architecture, development, testing and implementation of various Client/Server Web applications.

Experience in integration of several application such as Oracle Apps, PeopleSoft, MQ, JMS, Mainframe etc.

Experience in using many source control management software i.e. SVN, CSV etc and many ticketing systems Prism and JIRA etc.

Developed application with Oracle, SQL Server databases.

Coordinating between several teams during project life cycle.

PROJECT EXPERIENCE:

Project: RDS-RAVE Integration

Title: Sr. Oracle SOA/Java Consultant

April 2012 –Current

Abbott Laboratories

Northern Chicago, IL

Description: RDS stands for relational data service and it’s a centralized cache of clinical study data. RAVE is an external SaaS application which is used to capture the clinical trial related data. Our goal was to automate the manual process of synching the data between IMPACT and RAVE. When there is an update in IMPACT on a study, site, person or role of the person in a research center or a hospital system, existing TIBCO application brings the data in RDS. We had to develop an integration process which creates an excel file with all the updates.

Designed canonical XSD data model for RDS.

Developed java program using apache POI API to create Excel file based on a template provided by RAVE.

Implemented complex business logics in BPEL, XSLT and Business Rules.

Implemented scheduler service using Quartz to start the integration process.

Environment: Oracle Fusion Middleware 11g, Jdeveloper 11.1..1.5,Oracle SOA, Java, BPEL, Mediators, Business Rules, and sharepoint System.

Project: John Lewis Partnership PTP Integration, London

Title: Sr. Oracle SOA/AIA Developer Lead

April 2011– March 2012 (Multiple Projects)

Description: This project was for an integrating Oracle Ebiz HR and Oracle Finance system. There were 15 interfaces to be developed in AIA 11g. We had to synchronize all employee related data in both HR and Finance modules.

Used Oracle Apps business events and concurrent programs for integration points.

Integrated Hudson with SVN for automatic code deployment every night. This process finds any new commit in SVN and then runs SOA composite test suites and on successful tests, Hudson deploys SOA and PL/SQL code in relevant servers.

Implemented a custom ADF portal to resubmit failed messages from Oracle designated AQ for business events.

Developed the PL/SQL package which was called by ADF portal for resubmitting the AQ messages from error queue.

Implemented AIA deployment automation which deploys and updeploys code and related artifacts in one run.

Worked with Oracle Advanced Queuing and Message Broker to work with Message queues and topic using both PL/SQL and JMS.

Gathered requirements, designed integration pattern and coordinated between multiple teams.

Developed the 15 interfaces in BPEL, Mediator, AIA.

Involved in choosing appropriate EBM and EBS for all the interfaces.

Environment: Oracle Virtual Machine (OVM), Oracle SOA Suit 11g, Jdeveloper 11.1.1.5, BPEL, XSD, XML, XLT, Weblogic 10.3, Oracle Applications Adapter, Weblogic JMS Messaging, Oracle Apps, Oracle PL/SQL, AIA 11g.

Project: Morrisons UK, ER6 BB1 Integration

Title: Oracle SOA Integration Sr. Designer

September 2010 – Feb 2011,

Worked with Morrisons (Bradford, UK) as a sr. integration designer implementing real time data integration between Oracle e-Business suites and Oracle Retail.

Migrated existing 10g and AIA 2.5 projects running in production into SOA Suite 11g and AIA 11g.

Also migrated 2.5 PIPs such as Suppliers, Currency Exchange as part of the project.

Used Oracle Data Integrator to read huge XML data from Weblogic JMS and loaded data into Oracle Apps base table and called concurrent program.

Used DVM and Xref to map static and dynamic data mapping during integration

Led a team of 5 member development team from design phase, integration testing, UAT to hypercare.

Used HP OpenView for error notification to the support team.

Designed and developed deployment tool which could deploy all the SOA and OSB projects in a folder.

Environment: Oracle SOA, Oracle Data Integrator, AIA 11g, JMS, AIA PIP, HP UX Sparc

Project: Morrisons ManP1P2, Bradford, UK

Title: Oracle SOA/BPEL /AIA Sr. Integration Designer

Feb 2009 – Oct 2010

ManP1P2 is an integration project in Morrisons PLC, UK. There were altogether 4 interfaces. One interface, called SalesForecast was implemented in ODI (Oracle Data Integrator) and rests of the interfaces were developed in Oracle SOA using BPEL, Mediator, and AIA. SalesForecast integrates Oracle EBS with SMS2 (Visual basic application/ MS SQL database). Other interfaces were developed to integrate Oracle EBS with Mainframe legacy applications.

Built a custom error hospital application in Java and BPEL to handle non-partnerlink business faults. This application was built to cater error handling across projects in the whole program.

Worked in Jython programming language in SalesForecast interface to handle csv files in ODI dynamically.

Was responsible for gathering requirement, designing and coordinating with different offshore and onshore team members during the project delivery.

Used MQ for message broker to send and receive pricelist data to Mainframe.

Used Business events in Oracle Apps for fetching data from Oracle Apps

Environment: Oracle SOA, Oracle BPEL, XSD, XML, XSLT, AIA, Jython, ODI

Project: Morrisons FinP1

Morrisons PLC, Bradford, UK

June 2008 – Mar 2009

Title: Fusion Middleware (Oracle SOA) Consultant

Description: Morrisons PLC wanted to decommission its old finance GL system implemented in PeopleSoft. Morrisons was implementing new finance GL system in Oracle EBS. FinP1 project’s goal was to load all old data as well as every day’s data from PeopleSoft database to Oracle EBS base database.

The system facilitates direct integration with Peoplesoft GL and Oracle Apps GL.

Involved in end to end design process.

Developed the ODI integration process

Was responsible for gathering requirement, design and coordinating with offshore team members during the project delivery.

Developed PL/SQL procedure to map Peoplesoft finance information to Oracle Apps GL accounts.

Led the development team and coordinated with multiple teams.

Supported the project in UAT and in hypercare.

Environment: Oracle Data Integrator, Oracle PL/SQL.

Project: GM OOHYahoo, India

General Motor,

Dec 2007 – Jun 2008

Title: Fusion Middleware/SOA /J2EE Developer

Description: GIF Online Owners Hub (OOH) is a central data service hub in GM for Yahoo portal and its primary objective is to provide real time vehicle data to GM vehicle owners through the Yahoo portal. OOH provides the data service in both real time and batch mode. Yahoo portal initiates the web service request and sends it to GIF OOH. GM GIF OOH communicates to GM sub systems over real time and provides back the response to Yahoo portal. Previously, GM owners used to view their vehicle related data from various GM website (GM Owner center). For each vehicle, GM vehicle owners had to access specific website to view the vehicle information. There was no centralized website available to provide all vehicle related information to GM Owners in one place. In this project, GM systems use the GIF OOH as a central hub to provide vehicle related information to GM Owners via Yahoo Portal. All GM legacy systems like OnStar, GM Card, GLTO, IR, VIMS and Vehicle Selector are exposed as web services to central Hub. Yahoo interacts with GM GIF OOH central Hub to provide the registered vehicle information to GM owners.

Involved in creating the weblogic 8.1 based web service in top down approach.

Designed and created WSDL for VehicleRecall web service.

Implemented SAML token security for the VehicleRecall web service.

Designed and developed 8 BPEL services as wrapper of the 8 GM legacy services and one composite BPEL service to consolidate all the service data to be sent to Yahoo web portal.

Used OWSM for gateway security for the external Yahoo call to the consolidated BPEL process and client security used SAML tokens for GM legacy system securities.

Involved in performance testing of the EJB based web service and BPEL services.

Involved in developing PL/SQL code to fetch vehicle recall related data.

Built ANT scripts to deploy all the BPEL projects in shot.

Environment: Oracle SOA 10g, Oracle PL/SQL, OWSM, EJB 2.0, Weblogic 8.1, Sun Solaris

Project: Marketing MIX, India

Novartis Pharma AG

Jan 2007 – Dec 2007

Title: J2EE Consultant / Sr. Software Engineer.

Description: Novartis Pharma AG wanted to develop a web based portal for assigning or proposing the promotional expenses for global marketing and sales promotions and also wanted to keep a track of it. This web application contains both the administrative part as well as the business user's pages. This portal had pages for creating new complex details of medical promotional expenses, tracking those details, monitoring graphical metrics and generating reports in PDF and Excel files.

Involved in creating two modules Metrix and MixConsolidator in this project using ibatis, Struts framework and Spring.

Involved in UML design for software development of all applications

Implemented reporting dashboard using Jfree charts.

Heavily used Struts Tag Libraries, JavaScript, and Action Errors.

Developed and maintained the struts-config files.

Resolved application level problems with view controllers and view resolvers.

Handled deployment requests to support various testing efforts like system, performance, UAT etc.

Involved in web logic console administration for checking datasource, connection pool settings deployments.

Administered various Log files using log analyzer, Product logs, Installation logs, Administer server logs, Application server logs.

Involvement in writing scripts to handle everyday System Administration tasks such as backup procedure, system cleanup

Developed ANT scripts to deploy codes in the various servers.

Environment: Java, J2ee, Weblogic, XML, Spring, Struts, Ibatis, Jfree chart

Project: Service Order Request Automation System (SORAS), India

Novartis Pharma AG

(Apr 2006 - Dec 2006)

Title: Java Developer

This was a web based BPM project. We had to develop a web based application for Novartis Pharma for automating its business processes. Novartis wanted us to develop a portal where employees could initiate any service request and managers could track and approve all those service requests.

Responsibilities:

Analyzed, Designed and implemented the struts based application which makes uses AquaLogic BPM for business process monitoring.

Designed and Developed AJAX based web pages and integrated with Struts

Worked on configuring and deploying builds using ANT.

Implemented O/R mapping using Hibernate for persistence

Enterprise development design: Many of the standard design patterns are applied (business delegate, Data Transfer object, Data access object etc.)

Designing and developing functional modules and integrating them with overall architecture using J2EE / Hibernate

Implemented Client Side validations in JavaScript

Developed the business process in AquaLogic BPM.

Used http unit and Junit for continuous test and development cycle

Developed ant build scripts for Dev, UAT and Production environment for application deployment on clustered server environment

Environment : Java, J2ee, Struts, Aqualogic BPM, Swing, Web services, weblogic 8.1, Hibernate, POJOs, Spring, JSP, PAPI API, CSS, JavaScript, Eclipse, CSV

AKZO-Nobel Mix2Win Documentation, India

Jan 2006 – April 2006

Title: Visual Basic 6 and C++ Developer

Description: This was a technical documentation and analysis project. Client (AKZO-Nobel) wanted a complete documentation of its Mix2Win visual basic 6 application before migrating to .Net technology. The Mix2Win application was actually used to help customers in choosing customized colors in stores. It was a windows application. So, AKZO-Nobel had to install this software application in all the computers it had in all of its Paint Shops. That is why they wanted to migrate to .Net web application. We, the project team had to analyze the code and understand the functionality of the API of the application as client did not have any concrete technical documentation of the VB 6 application. API of the application (.dll) was written in C++.

Responsible to find out the architecture of the different modules in the application written in VB and C++.

Created the technical design document

Created UML diagrams for the design document

Environment: Microsoft Visual Basic, MS Visio, MS Visual SourceSafe, UML

EDUCATION:

Bachelors of Technology in Computer Science from West Bengal University of technology, Kolkata, India

TECHNICAL SKILLS:

Operating systems: Windows Server 2003/XP Pro, Sun Solaris, Linux

Programming Languages: Java, VB, SQL, PL/SQL, BPEL

Web technologies: Servlets, JSP, SOAP, Web Services

Database Concepts: JDBC, SQL, E-R Diagrams, PL/SQL procedure

Databases: SQL server 2005, Oracle 8i/9i, 10 g

Web/Application servers: Web Logic, Oracle Application server, Glassfish

IDE: Visual Studio, TOAD, Eclipse, Jdeveloper

Frameworks: Spring, Struts

ORM Tools: Hibernate, iBatis

Fusion Middleware Stack: Oracle SOA, AIA, PIP, BPEL, Integrations with e-Business Suite, Weblogic 10.3

Contact this candidate