SUMMARY:

• 14+ year’s hands - on experience in IT industry. Have worked in all phases of software development life cycle from requirements gathering to production. Successfully developed and implemented several projects with responsibilities ranging from Lead Developer to Technical Architect at locations.
• Seasoned professional with expertise in Data Integration Systems, multi - tier, object-oriented J2EE and Web based applications.
• Data Integration Architect with strong skills in creating Integration Strategy, creating framework and to build and create integration environment for Organization, Oracle DB Design, ETL architecture
• Wide experience in requirements gathering and analysis, system design, deployment artifacts and architectural views.
• Expertise in system integration, application deployments, Server configuration, load testing, log analysis, Ant scripting Performance tuning and Continuous Integration
• Data Architect with strong skills in Conceptual / Logical Data Modeling, Physical Data Modeling, Creation of Data Dictionary/Metadata, Development of Data Strategy and associated Policies and defining Best Coding Practices.
• Implementation of Data Quality Framework which includes activities like Data Cleansing, Data De-duplication and applying Business Processing Rules.
• Creating / Defining strategy and platform for Data Virtualization / Data Federation to bring the isolated applications together using Virtualized Platform and Integrate the Legacy and to be Systems/Platform.
• Extensive & expert level of experience with
• Java Platform, JEE5, EJBs, SPRING, JDBC, JPA, Servlets, Struts, JSP, AJAX, Filters, JMS, XML, JSF, JavaScript, Log4j, Pojos
• Enterprise integration technologies, Message Oriented Middleware (MOM) IBM MQ Workflow, WebServices, SOAP, WSDL, UDDI, JMS, Hibernate, LDAP, Content management, application deployment, Datasources configuration
• XML technologies, SAX, DOM, JDOM, JAXP, JAXB,XSD,Schemas,Document Handlers, Parsers, XML Schemas and XSLT
• Design patterns like Dependency injection, Singleton, Domain Object, DAO, Session Fa ade, Factory pattern, Service Locator, Front Controller, Command pattern, MVC
• Databases like Sybase, Oracle 11g, IBM DB2, My SQL, SQL Server, experience in database design, PL/SQL, Queries, Triggers, DB2 Client, DB Artisan, SQL Explorer, TOAD,O/R Mapping, Hibernate
• Experience in Crystal Reports and Business Objects
• Expertise in implementing business logic in Oracle using Stored Procedures, Functions, Packages, Views, materialized views, function based indexes and Triggers, Dynamic SQL, ad-hoc reporting using SQL
• Experience in ETL tools Talend, Informatica Power Center 9.6, Ab Initio, SSIS and Composite (Data Virtualization Tool).
• Experience in estimating, project planning (specialized in development phase, testing phase & implementation phase), and monitoring & mentoring development team.
• Highly result oriented and pro-active, proven abilities to learn new technologies quickly and implementing them successfully in production
• Ability to transform complex business requirements into technical specifications
• Have good Communication & Interpersonal skills to deal with project stakeholders & direct customers
• Capable of working independently as well as a part of dynamic team. Ability to quickly grasp business domain.
• Fast learner with a keen interest in expanding my skill set with new technologies.
• Multi-Domain experience - Financial Industry experience with Banking and Financial Services such as Confidential, Confidential and Confidential, Publishing industry experience with Pearson

TECHNICAL SKILLS:

JEE5 & Web Platform: Core Java, EJB, SPRING, Servlet, JSP, JDBC 2.0, Hibernate, JSF, Struts 1.2, MVC, Applets, JAAS, JMS, Log4j AJAX, Dojo, JUnits JSF,JavaScript, Dojo, WebServices, SOAP,JAX-RPC, WSDL 1.1,SOAP,JavaMail, GUI - AJAX, JavaScript, Log4j, JSF, Struts taglib, HTML, CSS, LDAP and .Net

Application Servers: WebSphere WAS 6.1/5/4, WebLogic 9/8.1/6, JBOSS 4.2, and Apache Tomcat 5.5.

Software Design: IBM Rational Rose, UML, Visio.

Special Tools & Technology: WebSphere MQ, LDAP, Load Runner, Visio, SQL Explorer, TOAD, Squirrel, Talend Data Quality, Informatica Power Designer, Ab Initio, MS Project, DB Artisan, JTest, Jprobe, GNU PG, Crystal Reports, JUnit and JIRA.

Database: Sybase, IBM DB2, Oracle, My SQL, SQL Server

XML Technologies: SAX, DOM, JAXP, JDOM, XSD, XSLT, XML Parsers, document Handlers

RAD/IDE Tools: RAD 6, WSAD 4/5.1.2, WSAD, Eclipse 3x

Configuration Mgmt / Continuous Integration: ANT, SVN, VSS, Rational ClearCase, Clear Quest

Operating System: UNIX, LINUX, AIX, Windows NT/2000/XP

PROFESSIONAL EXPERIENCE:

Confidential

Developer/Architect

Responsibilities:

• Capturing business process requirements and involved in the design, development and documentation, and testing processes.
• Built Canonical Model for Accounts, Contacts and Product from Confidential for K12 and Higher Ed Data.
• Creating Mapping Artifact for all the Integration.
• Creating Workflow using Talend Platform to consume Flat file from Source, convert it to tabular format and persist it to Database and perform CDC Operation on the source data and publish the same to SFDC subscribing systems using SFDC Adaptors.
• Performing Change Data Capture Procedure from 2 different Sources. The CDC Process was designed in Oracle to provide change data every day on scheduled time to SFDC. (Target System).
• Creating logging and publishing frameworks using Java and spring.
• Publish data to SFDC CRM using SFDC connectors in Confidential (Composite/Talend) which includes Select/ Insert / Delete and Update Operations.
• Creating various Oracle Stored Procedures, Triggers, Packages, Views, and Materialized Views at Application layer for publishing the data to targets SFDC/Cameleon (CPQ) and Performance Tuning and Optimization Process for Oracle Procedures and Views and SQLs.
• Publishing the XML messages to Topic where various downstream systems subscribes our topic for consumption.
• Creating PERL and Shell script for project maintenance and cleanup process.
• Creating work flow in Informatica Power Center for loading data into Oracle MDM and using IDQ for standardizing, cleansing, de duping the Product and Customer data.
• Preparing deployment plans and setting up the LINUX servers for deployment in QA/UAT/PROD.

Environment: Core Java 1.5, Spring, Oracle 11i, PL/SQL, Composite Data Virtualization Tool, Talend Platform for Data Management, SSIS (Visual Studio 2005/2008), LINUX, Eclipse 3.2, XML, Autosys, PERL and Shell Scripting, Informatica Power Center 9.6.1 and Informatica DQ 9.6.1

Confidential

Senior Java/Sybase/Perl Developer

Responsibilities:

• Capturing business process requirements
• Involved in the design, development and documentation, and testing processes
• Involved in developing the Gateways for various source systems using Java
• Involved in developing the Enrichment module using Java
• Developed various utilities in Perl for QA process, validating booking and clearing files
• Developed backup process in Perl for booking, clearing, detail reports to clients
• Developed various Stored Procedures and performed Performance tuning the SQL in Sybase database.
• Involved in developing and supporting various regulatory reports and bluesheets process
• Performed unit and integration testing and involved in the deployment process
• Worked with management for project development task estimations and scheduling

Environment: Core Java 1.5, PERL, Sybase, Quality Center, Tomcat, UNIX/AIX, Eclipse 3.2, Autosys and Shell Scripting

Confidential

Senior Data Integration Developer

Responsibilities:

• Capturing business process requirements.
• Involved in the design, development and documentation, and testing processes.
• Designed and developed various mappings using the ETL tool Talend.
• Performed unit and integration testing and involved in the deployment process.
• Involved in production support.
• Worked with management for project development task estimations and scheduling
• Designed SSIS packages to extract data into flat files.
• Did development team mentoring and code reviews

Environment: Talend ETL Tool, Core Java 1.5, Weblogic, Oracle, SSIS (Visual Studio 2005/2008), UNIX/AIX, Eclipse 3.2, XML, Autosys, PERL and Shell Scripting

Confidential

Senior Java/ETL Developer

Responsibilities:

• Capturing business process requirements.
• Involved in the design, development and documentation, and testing processes.
• Developed various report formats in Java such as CCF, Concur, VCF and CDF based on XML based configuration.
• Involved in developing the Tikki framework.
• Designed and developed various graphs using the ETL tool Ab Initio for generating various outbound reports and inbound feed processing
• Wrote the generics scripts to invoke the deployed Ab Initio graphs.
• Have used Ab Initio plans to call various graphs in one plan.
• Developed Shell and PERL scripts for processing various inbound files that we received from different regions
• Designed and developed a front tool named FDRTool in Struts framework for Level 1 support.
• Performed unit and integration testing and involved in the deployment process.
• Involved in production support.
• Worked with management for project development task estimations and scheduling
• Designed and developed core components and classes for the application
• Did development team mentoring and code reviews

Environment: Ab Initio, Core Java 5, Websphere, DB2, UNIX/AIX, Eclipse 3.2, Struts, XML, Microstrategy, Autosys, JUNIT, PERL and Shell Scripting

Senior Java/J2EE/ETL Developer

Confidential

Responsibilities:

• Capturing business process requirements.
• Assessing the information needs of the users and developing functional specifications and test cases.
• Involved in the analysis and design of Data Model.
• Developed various J2EE Components such as Servlets, JSP, XML, JMS and Web Services.
• Designed Asynchronous Email Notifier using MDB and JMS.
• Designed the Web Pages to fire activities upon user action without reloading the page using AJAX.
• Developed PERL and Shell Scripts to retrieve the data from LDAP and upload into CES Core system.
• Designed various mappings using ETL tool Informatica to convert UNIX/PERL scripts to mappings.
• Conducted Code Review to enforce best practice standards.
• Preparation of regular status reports and presentation of functionality.
• Performed unit and integration testing and involved in the deployment process
• Created guidelines for JUnits testing in the project
• Involved in Load Runner test planning for the release

Environment: Weblogic 8.1, Sybase, Windows XP/Linux, Eclipse 3.2, Core Java, J2EE, JMS, XML, XSL, DHMTL, AJAX, Web Services, Active Widgets, LDAP, PERL, Crystal Reports and Shell Scripting

Senior Java/J2EE/ETL Developer

Confidential

Responsibilities:

• Point of contact between Business Team & Technical Team.
• Involved in the business analysis and system design to support the complex workflow logic
• Involved in the design, development and documentation, and testing plans.
• Designing the Sybase database schemas.
• Mentor the team on J2EE technologies and actively involved to trouble shoot many of the issues.
• Designed the Web Pages using AJAX.
• Created the Best Practices guidelines documents and ensured that the team members are following them as a standard for the development.
• Created base classes and application framework for the project to be followed by development team
• Did troubleshoot on production issues & pass on the issues to development team for application fixes & further improvements.
• Setup ANT scripts for Continuous Integration for the project
• Created migration playbooks, deployment and backup plan.
• Created project estimates and involved in development status meetings with management

Environment: Weblogic 8.1, Sybase, Windows XP/Linux, Eclipse, J2EE, XML, Struts, AJAX, Crystal Reports and Web Services

Senior Java/J2EE/ETL Developer

Confidential

Responsibilities:

• Implemented the project end-to-end, system is currently running successfully in production environment.
• Point of contact between Business Team & Technical Team. Did Business & Technical Analysis for application.
• Incorporated J2EE best practices in project for JSP, Sessions, Web Technologies
• Created technical Architecture and Design of the application on J2EE technologies and Fast4JExpress framework
• Designing the Sybase database schemas.
• Mentor the team on J2EE technologies and actively involved to trouble shoot many of the issues.
• Designed the Web Pages using AJAX.
• Created the Best Practices guidelines documents and ensured that the team members are following them as a standard for the development.
• Created deployment playbooks, migration and backup plan.
• Stored procedures for replacing prepared statements where required, implemented a typical scenario

Environment: Weblogic 8.1, Sybase, Windows XP/Linux, Eclipse, J2EE, XML, Struts, Crystal Reports and AJAX