SUMMARY:

• Over 7.5 years of Enterprise Software Implementation and integration experience that includes Architecture, Analysis, Design and Development of Oracle SOA, J2EE Applications and Data warehousing using Cognos.
• Good Experience in SOA, Orchestration and Integration Technologies in the areas of BPEL, Web Services, OSB, SOAP, WSDL, XML, XSD, UDDI, WS - *.
• Well versed with Architecting and using fusion middleware technologies like BPEL, ESB, BAM, B2B and JCA Adapters.
• Successfully completed three full implementations of Oracle SOA suite projects using fusion middleware components like BPEL, OSB, Human Task, OSR, OER, WSM, BAM and JCA Adapters.
• Very good experience with Web Services, XSD, XML, XSL, Xpath, XQuery, WSDL
• Experience with server side development using Java/J2EE, Web services, EJB, Servlets and JDBC
• Experience in designing and implementing Service Oriented Architecture (SOA), WSDL, SOAP and UDDI.
• Strong experience in database management systems like Oracle, MS SQL Server, DB2.
• Good experience in development of front end user interface using JSP, HTML, XSL, CSS, Java script.
• Expertise on Development IDE’s like JDevoloper, TOAD.
• Able to install and configure SOA suite adapters like JMS, Database, BAM and OSB on Weblogic.
• Good Experience in Cognos tools.
• Good understanding of Data warehousing concepts.
• Quick learner with ability to rapidly achieve organizational integration, understand job requirements employ new ideas, concepts, methods, and technologies.

TECHNICAL SKILLS:

Application/Web Servers: Web logic, Oc4j, IIS 6.0/7

Database: Oracle 9i/8i/11g, MS SQL Server and DB2, TOAD.

Operating Systems: Windows 03/XP/00

Middleware Technologies: Oracle SOA Suite 10g and 11g (Web services, BPEL, ESBMediator, Human Task, OSB, B2B, BAM, WSM, EAI.

Programming Skills: ADF BC, JSF, Java, JSP, JDBC, JNDI, JMS, PL/SQL, Servlets, EJB, JDBCJavaScript, HTML, XML, XSD, XSLT, XQuery

Cognos ETL Tools: Cognos7 Cognos8 tools Data Manager, Decision Stream, Cognos Analytic Console and SSA Extraction Manager.

Cognos BI Tools: Cognos7/8.1/8.2/8.3/8.4 Framework manager, Power play Transformer, Report Studio, Query Studio, Analysis Studio, Event Studio Metric Studio, Cognos Connection, Cognos Configuration, Impromptu.

PROFESSIONAL EXPERIENCE:

Confidential, Iowa City, IA

Oracle SOA Consultant

Responsibilities:

• Understanding the existing functionality of Confidential Quality Core CR scoring.
• Responsible for changing the EssayScoring BPEL Process to update the tables to handle the CR routing to Pearson which used DB Adapter.
• Developed the new BPEL process named RequestScoringProcess to route the Quality Core CRs to Pearson using DB Adapter and FTP Adapter.
• Developed WriteResponseAcknowledgement BPEL process from scratch to send the acknowledgement to Pearson once the Score response is received.
• Developed multiple PL/SQL procedures which are called from BPEL using DB Adapters.
• Worked on Exception Handling.
• Worked on Log processing and Email notification.
• Worked on the Design changes.
• Developed the Test Cases for Unit testing.
• Worked on solving the defects.
• Configured proxy service and business service.
• Worked on creating the DB adapter interfaces in JDeveloper and imported in OSB to poll the data from the database table.
• Worked on configuring the FTP transport in OSB to write files to the remote server and worked on creating a service account.
• Good knowledge on other transports of OSB.
• Worked on XQuery transformations.
• Participated in analysis of business requirements and creation of Technical Design form from the functional specifications.
• To identify and specify the different middleware function points or use cases, in the overall procedural flow of a particular process.
• Design, develop and deploy business process orchestrated in BPEL using Oracle SOA suite 11g and JDevoloper.
• Developed different BPEL flows to create the communication between Customer Relationship and ICOMS modules, the deployed BPEL process used Database Adapter, JMS Adapter.
• Worked on developing the composites for payment authorization.
• Created different business rules using Business Rule Component and routed the requests using those rules.
• Developed and deployed work list applications for human work flow using ADF.
• Used Exception handling in BPEL Processes and implemented fault policies for composites.
• Participated in Unit testing.

Technologies: SOA Suite 11g, Oracle 11g, Web logic 11g, XML, XSD, XQuery, XSLT, Xpath.

Confidential, Omaha, NE

Oracle SOA consultant

Responsibilities:

• Analysis of business requirements and creation of Technical Design form from the functional specifications.
• Design, develop and deploy business process orchestrated in BPEL using Oracle SOA suite 11g and JDevoloper.
• Developed BPEL process for Pre-Employment flow.
• Developed a communication system between Transentric and ADTS and University Services using JMS Adapter and DB Adapter.
• Developed a communication system between Transentric and University Services and University Services using JMS Adapter and DB Adapter.
• Used Exception handling in BPEL Processes and implemented fault policies for composites.
• Study and analysis of business and functional requirements
• Worked as a Component Developer to code in Java and J2EE technologies.
• Created UI using JSPs.
• Used Spring Framework for implementing business logic and maintaining transactions.
• Used POJOs for storing data required.
• Maintained documentation using Javadoc.
• Provided extensive pre-delivery support using Bug Fixing and Code Reviews.
• Written build scripts for ANT deployment.
• Unit testing was done using JUnit.
• Extensive usage of J2EE design pattern namely DAO.
• Extensive usage of XML throughout modules.
• Used Web Logic as Application Server
• Used VSS for version controlling.
• Used Log4j for logging.

Technologies: Java, J2EE, Spring Framework, JSP, Eclipse, XML, DB2, Web logic, ANT, JUnit, Quality Center, Log4j, VSS.

Confidential, Indianapolis, IN

Java Developer

Responsibilities:

• Designed object model and created diagrams(Class diagrams, State Chart / Activity Diagrams, Sequence Diagrams) using UML
• Developed front end screens using JSP and HTML.
• Developed Session beans that encapsulate the business logic and Message Driven Beans that consume JMS messages received from Brokerage Systems.
• Developed front end validation using Javascript.
• Implemented Log4J for logging mechanism
• Worked on the Transformation mappings and the Derivations in Data Manager.
• Always me the customer deadlines for high priority defects and also appreciated by the Managers.
• Team Lead in migrating all the analytics from Cognos7 to Cognos8 and the database from Oracle 9i to Oracle 10g.
• Apart from handling the regular defects in the queue, also handled the Enhancements in providing the backorder functionality in Purchase and Sales Analytics for the Customer Snap-On.
• Visited the Customer Snap-on, USA in May-2007, to do the performance testing for the ERPLN Analytics.
• Participated in Performance tuning for Sales, Purchase, Accounts Payables and Accounts Receivables ERPLN Analytics, in case of large volumes of data.
• Worked on the customer defects and helped the team in solving the defects.
• Developed Analysis studio reports and converted them into report net reports.
• Tested the product successfully and delivered.
• Tested the converted report net reports and successfully delivered.
• Had to understand the General Ledger module functionality.
• Gathering the requirements, understanding them and worked on the Design.
• Explain the requirements, design to the team and guided them in the implementation.
• Tested the product successfully and delivered.

Technologies: Cognos Framework Manager, Cognos Report net, MS SQL server

Confidential

Associate Software Engineer

Responsibilities:

• Data warehouse database tables design.
• Coding for Extraction, transformation and loading (ETL) of data from Baan4 ERP to data warehouse using decision stream (ETL part).
• Creating transformation mappings, lookups to load the huge data sets into data warehouse.
• Packaging the builds using Cognos Packager, creating the builds using the Cognos Build Manager.
• Collecting and analyzing requirements from the Business users / Onsite coordinators.
• Worked on Calculations, Filters, shortcuts, relationships and security.
• Created packages within FM and published them to the development server.
• Design and development new reports based on the client requirement and migration of existing reports with new changes.
• Created all kinds of reports in report studio using lists, cross tabs and charts, master detail and drill through reports.
• Importing metadata into the Framework manager and working on relationships, calculations, filters etc.
• Development of IQDs from framework manager model.
• Development of transformer Models for weekly and monthly data.
• Designing dimension hierarchies, measures and aggregation principles for the measures.
• TUT, FUT and ST of both ETL and BI layers.

Technologies: Baan5 Accounts Payable, Baan5 Accounts Receivable, Cognos decision stream, power play, report net, oracle 9i, Cognos Packager, Cognos Build Manager, MS SQL server, Microsoft Visual source safe.