SUMMARY:

• Almost 10 years of experience in software design and development in Java Technologies and tools (FAST Enterprise Search, a search engine and Informatica MDM, a master data management) providing Java APIs for integration.
• Expertise in the entire Software Development Life Cycle (SDLC) phases like Requirement Gathering, Analysis, Design, Development, Testing and Implementation.
• Experienced in the object oriented software systems and development of Web based, Linux based applications with N - Tier distributed architecture using Java Technologies
• Expertise in design and development of the web based applications using J2EE, SOAP Web Services, Struts 1.2, JSP, JDBC, Hibernate and Servlets.
• Experienced in cloud based Reltio MDM Technology to use the REST API to load the data in form of JSON
• Experienced in configuring Match Rules in Reltio MDM Technology
• Experienced in developing the Data Change Requests in Reltio MDM Technology
• Experienced in Informatica MDM Technology in Landing, Staging, Loading and Match and Merge Process.
• Involved in configuring JMS setting in Informatica MDM and integrating the external applications using SIF
• Used the Informatica Service Integration Framework (SIF) to develop the web service for MDM processes.
• Very good in understanding the MDM requirements from the business in achieving the BVT (Best Version of Truth) Record and publish to the downstream applications.
• Highly Skilled in writing the User Exits for IDD to throw Validation errors
• Configured the Subject Area Groups, Subject Areas, Cleanse Functions, Match Rules Sets in IDD.
• Strong debugging skills in Database SQL queries
• Experience in creating and maintaining the database objects like Tables, Stored Procedures.
• Experience in SQL, PL/SQL packages, functions, stored procedures, triggers, views, materialized views to implement the business logic
• Worked on developing SOAP web services using top down approach and involved in working on WSDL.
• Experienced in using java based Search API and Content API provided by FAST ESP for providing search on sites and developing custom connectors to push data to be searched, respectively
• Experienced in developing configurable custom stages in python for FAST ESP doocument processing
• Proficient in scripting languages like JavaScript, AJAX, DWR.
• Worked extensively on Designing, Modeling & Development tools like Rational Rose Architect (RSA), Eclipse and Maven.
• Good exposure with Application servers like WebSphere, JBoss and Web Servers like Apache Tomcat
• Worked extensively in MVC Architecture using Struts and Spring frameworks.
• Experience in creation of auto deployment build and deployment process using Maven and Ant scripts
• Have experience in writing JIL files for Autosys
• Good Exposure to Requirement Analysis, High Level Design, implementing proof of concepts, identifying appropriate design patterns and reusable components, client interaction, conducting reviews, maintaining quality standards and providing technical support to the team members.

TECHNICAL SKILLS:

EIM Tools:  Informatica MDM 9.5.1 / 9.7

Programming Languages&Frameworks:  Core Java, Collection Framework, J2EE, Python Service Integration Framework

J2EE Standards:  JDBC, JNDI, JMS, XML

Web / J2EE Technologies:  Struts, Spring MVC, Hibernate, JSP, Servlets, AJAX, Java Script, HTML, XML, Web Services, XSD

Database:  Oracle 8i/9i/10g

Servers:  WebSphere Application Server 7.X, JBoss 5.X, Tomcat 5.X

IDE:  RAD 7, Eclipse, MyEclipse, SOAPUI

Operating Systems:  Windows, UNIX, Linux

Other Tools:  Log4j, ANT, Toad, SQL Developer, Putty, SFTP, SVN

PROFESSIONAL EXPERIENCE:

Confidential

Module Lead

Responsibilities:

• Working as module lead responsible for architect the MDM solution for CRM 3.0, to master the customers.
• The lambda architect is followed to cater the real-time/ near real-time and batch requirements.
• Responsible for configuring the brand and global view of the customer in Reltio.
• Involved in mapping the customer (Brand and Global) attributes in Reltio with data model followed in Cassandra
• Integrating the JSON Generator and Data Loader Utility with CA API Gateway Layer 7, so all calls to Reltio API will be made via Layer 7.
• Developing the Spark wrapper to call the all Reltio utilities in Spark layer directly by Informatica layer.
• Working on finalizing the match and survivorship rules with business.
• Integrating the Reltio with third party address cleansing service (Axiom Abilitec)

Tools & Environment: Cloud Based Reltio MDM, Java 1.8, Eclipse, Oracle 11g, POSTMAN, JSON Editor, Axiom Abilitec APIs, CA API Gateway.

Confidential

Technical Lead

Responsibilities:

• Involved as technical lead to convert the business requirements into technical specifications.
• Working on the Reltio MDM Level 3 configurations for Entities and respective simple, nested and reference attributes.
• Worked on profiling the IMS and Non-IMS (Alexion Legacy System) Health Care Professional and Health Care Organization data for EMEA and US region and included countries.
• Define the Common File Format that fits to IMS and non-IMS sources and to all countries contributing data for Reltio input flat files
• Profiles the Hierarchies/Relationships/Activity from IMS to understand how that will be consumed by consuming systems and accordingly configured in Reltio.
• Perform comparison study of IMS data in F13 and F11 format to design the MDM system compliance to both formats.
• Design and Develop the Data Change Request outbound workflow in Reltio which sends the Validation Request to IMS for any IMS data scrubbing activity.
• Data Change Request Inbound component transform the Validation Response sends by IMS and take the required decisions at Alexion MDM side.
• Configuring the Country dependent look up values in Reltio as per the Code and Value pair send by IMS for many attributes in Individual and Workplace files.
• Working on JSON generator module which converts the data files in text format into JSON.
• Working on Data Loader Module
• Working on Match Rules Requirements with business and implementing the same in Reltio.

Tools & Environment: Cloud Based Reltio MDM, Java 1.8, Eclipse, Oracle 11g, POSTMAN, JSON Editor.

Confidential

Technical Lead

Responsibilities:

• Involved as technical lead to convert the business requirements into technical specifications.
• Working on the Reltio MDM Level 3 configurations for Entities and respective simple, nested and reference attributes.
• Working on JSON generator module which converts the data files in text format into JSON.
• Working on Match Rules Requirements with business and implementing the same in Reltio.

Tools & Environment: Cloud Based Reltio MDM, Java 1.8, Eclipse, Oracle 11g, POSTMAN, JSON Editor.

Confidential

MDM Integration Specialist

Responsibilities:

• Working on impact analysis for upgrading MDM 901 to MDM 9.7 HF 4, including studying the existing data, custom modules and integrated system.
• Upgrading the database procedure calls in PL/SQL packages to Web Services calls using UTL HTTP to make them work with upgraded system
• Installing the MDM 9.7.1 binaries for Web Sphere Application Server on Linux system
• Correcting the Null Indicator Bitmap issue which exist in State Street MDM system when upgraded from Siperian to MDM 901 version
• Working with integrated applications team to do the integrated testing, including rebuilding the EJBs EAR with updated Informatica MDM jars to make it work with upgraded system
• Performing the testing for EBF 2 provided by Informatica to resolve the flip issue for unmapped columns.
• Developing REST web service for using SIF API to integrate with downstream systems

Tools & Environment: Informatica MDM 9.1, Informatica MDM 9.7, Websphere Application Server 8.5.5, RAD 8.5, Oracle 11g, PL/SQL Developer, UNIX, PL/SQL, REST API

Confidential

MDM Consultant

Responsibilities:

• Worked on gathering the business requirements and finalizing the different test cases for turning the match rules for account data manual.
• Analysing the Account data under merges and over merges by turning the match rules to manual.
• HCP Match rule tuning and changing the sequence of rules pertaining to the issues from IMS and one internal source (Vantage).
• Integrating the Federal Government Employee (FGE) data newly introduces in IMS feed, which requires the change in publish and MDM layer.
• Estimating the enhancements for MDM and working on change requests.
• Integrating the new source Sandoz into the MDM. This source was an extension of the IMS data only. Worked upon synchronizing the data template and inbound frequency.
• Integrating LDAP Authentication MDM Lookup tool. This tool is a MDM SIF (Service Integrating Framework) based tool used by the business to search the master data. They required to add the extra level of authentication through LDAP.
• Involved in creating the environment for operations or any new development. This involves building the new environment by fully or partially refreshing the environment using the latest weekly import and integrating it with ORS.
• As a part of operations team, used to work on data related queries mostly from Vantage source system and about Degree Matrix, which was the mapping implemented through cleanse list..

Tools & Environment: Informatica MDM 9.1, Web Logic, Web Logic workshop, Oracle 11g, PL/SQL Developer, UNIX, PL/SQL

Confidential

MDM Consultant

Responsibilities:

• Worked on gathering the business requirements and finalizing the different scenarios for finished and non-finished goods for Function Requirement documents
• Actively participated in technical discussions to identify the areas which can be reused and changed to accommodate the required enhancements.
• Develop the Register & Add Finish Good and Non-Finish Good screens for web application using SIF APIs
• Involves in External Matching to analyse the customer data from new source system GS1 (Global Standard 1) with the current data from GPO (Group Purchasing Organization).
• Generating the Match reports from External Match Output tables for business.
• Develop the PL/SQL procedures for first step data validation and owner based rule validation.
• Involved in up-versioning the design documents to add the new technical enhancements
• Involved in creating test plan (unit test cases script) in HP Quality Centre.
• Involved in creating the SQL scripts for code deployment on different environment and preparing the Change Control documents for QA and Prod promotions.

Tools & Environment: Informatica MDM 9.5.1, JDBC, JNDI, Web Logic, Log4J, Web Logic workshop, Oracle 11g, SQL Developer, UNIX, IDD, PL/SQL

Confidential

MDM IT Consultant

Responsibilities:

• Working with Contacts source system team to map the inbound fields with as per the data model inbounds landing tables and finally map with the outbound field for down stream systems.
• Involved in resolving the productions issues related to irrelevant matching data for Persons domain.
• Involved with business to prepare the sample data and the match & merge use cases.
• Defining the match & merge rules and customisations required and providing estimations of efforts required.
• Configuring the match rules in hub and running the match & merge iteration on DEV and fine tuning the rules as per the feedback from business.
• Developing the Database Post Load and Post Merge User Exits for MDM 9.5
• Involved in briefing the significance Trust and Validation to business and then involved in assisting the business to decide the fields requiring the trust and corresponding trust settings.
• Developed the customized java cleanse function used for stage process.
• Preparing the XSDs for composite web service used by the data loaders and custom UI to load Contacts data.
• Involved in design the Data Loaders for different Subject Areas used by the business to load the bulk data which was more than the capacity of IDD.
• Implemented the Thread Pooling in Data Loaders to increase the efficiency and capacity of data loaders.
• Provides the production support for data loaders.
• Involved in configuring the Subject Area Group and Subject Area, Cleanse functions in IDD
• Write User Exits for validation errors and messages for save operation in IDD
• Developed IDD User Interface screens with complex business requirements on data validations - Cleanse Functions, User Exits and Queries.
• Manually editing Bddconfig file to provide feasibility (Filters, Sibling References) which can not be achieved by using IDD application Interface.
• Developed data import functionality on IDD for bulk data import
• Involved in monthly releases on Stage (MTS) and Production (MTP)
• Provide weekly status updates on progress, status, and issues
• Developed high level and low level design documents for match and merge and address doctor web service integration.

Tools & Environment: Informatica MDM 9.5.1, SOAP UI, WSDL, JDBC, JNDI, JBoss 5, Log4J, Eclipse, Oracle 11g, SQL Developer, UNIX, IDD

Confidential

Integration Specialist

Responsibilities:

• Involved in installing the Informatica software to make the system ready for using the MDM tool
• Involved in setting up the virtual machines and development environment
• Defining the data model as per the sample data
• Defining the landing, stating and loading processes
• Understanding and defining the Match rules and Match rule set requirements.
• Working on the web services for integrating the MDM with web applications

Tools & Environment: Informatica MDM 9.5.1, SOAP UI, WSDL, JDBC, JNDI, JBoss 5, Log4J, Eclipse, Oracle 11g, SQL Developer, IDD

Confidential

Senior Developer and Offshore Lead

Responsibilities:

• Analysis, Design, Development, Testing and maintenance of the system.
• Created overall Design for the application including component, class and sequence diagrams. Also created design document.
• Worked as Onshore Technical Lead for deployment and UAT phase.
• Involved in designing and developing the web service for importing the client data into Financial Planning Tools
• Involved in developing the client interface to launch the planning tools using Struts and JDBC
• Project Support, Coordinating with clients on regular basis.
• Providing the maintenance / support by working on change request having development efforts longer than 10 days

Tools & Environment: Java, J2EE, Maven, Shell Scripting, Web Service ( JAX-WS based CXF framework ), Spring MVC, Struts1.2, JDBC, Java Script, RAD 7, WebSphere Application Server 7, Toad, Oracle 9i

Confidential

Senior Developer and Onshore Coordinator

Responsibilities:

• Worked as technical Lead using Java, J2EE, Web Services (Jax-ws)
• Provided direction and guidance to the team for implementing change requests/enhancements.
• Analysing the requirement specification, technical design preparation, conduct proof of concepts in analysing the various design approaches and sharing with client.
• Ability to correlate log messages across products/services
• Fast log search on indexed log messages
• Consolidated storage of log data on a single logical place

Tools & Environment: Java, J2EE, Struts 1.2, Tomcat Web Server, Web Services (JAX-WS)

Confidential

Lead Software Developer

Responsibilities:

• Provided direction and guidance to the team for implementing change requests/enhancements.
• Analysing the requirement specification, technical design preparation, conduct proof of concepts in analysing the various design approaches and sharing with client, identifying common reusable components.
• Used various design patterns like MVC & Singleton.
• Involved in the SRE meetings, walkthrough’s and completion of SRE’s.
• Involved in the development of the GUI and incorporate the functionalities for Custom Controls used across many modules.
• Involved in Coding, code optimization in quality assurance point of view, code review as per the coding standards.

Confidential

Module Lead

Responsibilities:

• Involved into total software life cycle & managed team members.
• Lead the team for all technical issues
• Planning the work schedule and estimating the time required for implementation and testing.
• Provided direction and guidance to the team for implementing change requests/enhancements.
• Low level designing for the module Done code reviews, mentored junior team members
• Created the web pages with its required styles.
• Involved in the enhancement study and Project Support.
• Involved in the defect fixing.

Tools & Environment: Java, Spring MVC, JDBC, Oracle, Python, Tomcat 5.x, TOAD, Search API in Java

Confidential

Senior Developer

Responsibilities:

• Interacted with customers, business analyst in design, implementation and feedback issues.
• Coded business logic and developed data layer class extensively for database related transactions.
• Performed fix issues and troubleshooting in production support.
• Provided technical specifications for the tasks and implemented as per suggestions.
• Involved in design including API designing, development and implementation, Troubleshooting

Tools & Environment: J2EE, Struts 1.2, JSP, JavaScript, AJAX, Tomcat 5.9, Oracle 9i, CSS, FAST ESP 5.3, Extracting Entities through Matcher, Dictionary configurations, HCL Search Frameworks and deployment Scripts

Confidential

Senior Developer

Responsibilities:

• Involved in requirement gathering and analyzing requirements, and documenting them with use cases.
• Involved in database design, created tables.
• Was involved in designing and developing the User Interface
• Construction of Indexing and Publishing Module
• Developed sequence diagrams and class diagrams using Visio tool.

Confidential

Developer

Responsibilities:

• Designing of Graphical User interface.
• Done software development, testing and deployment of components of various modules of the project.
• Designing and Development of the framework of the Project
• Involved in the development of Data Access layer, Business layer and Application layer (user interface) of the 3-tier architecture web application using Java, Struts, and JSP.

Tools & Environment: FAST Enterprise Search Platform 5.1.3, FAST Documentum Connector, Struts 1.2, Velocity, Tomcat 5.x, J2EE, Python2.3

Confidential

Developer

Responsibilities:

• Actively involved in interface design using HTML, JSP, JavaScript
• Responsible for coding Java programs, JSP pages and Servlets.
• Implemented modules to connect database using JDBC
• Involved in the development of Data Access layer, Business layer and Application layer (user interface) of the 3-tier architecture web application using Java, Struts, and JSP.

Tools & Environment: Java, J2EE Technologies (JSP, Servlets, JDBC), HTML, XML, Tomcat 5.0.28, Oracle 8i

Confidential

Developer

Responsibilities:

• Actively involved in interface design using HTML, JSP, JavaScript
• Developed the application Struts 1.2
• Implemented modules to connect database using JDBC

Tools & Environment: Java, Struts 1.2, HTML, Tomcat 5.9, Oracle 9i