SUMMARY

• AWS Certified (Solutions Architect - Associate ) professional with extensive expertise in data management.
• Strong analytical and problem solving skills, with sound experience of designing and developing Data management solutions with expertise in MDM & AWS platform.
• Highly motivated, creative and versatile professional having more than 10 years of IT developer experience in JAVA/J2EE including Informatica Master Data Management package and AWS Platform Offerings.
• Expertise in Informatica SIF (Siperian Integration Framework), IDD/BDD (Informatica Data Director), Data Governance and Data Quality.
• Extensively designed solutions using AWS platform offerings including but not limited to S3, EC2, Lambda, RDS etc.
• Extensive experience in developing Enterprise level web services around SIF to interact with Informatica MDM through packages, functions and stored procedures using various SIF API’s.
• Extensively worked on IDD customizations which involved user exits, custom cleanse and validation functions.
• Configured various Workflows with varied user profiles and roles in IDD to depict the business processes.
• Used HM (Hierarchy Manager) to configure Organization level Hierarchy.
• 7 years of experience in development and deployment of applications using BEA Weblogic Application Server 8.1, IBM WebSphere Application Server 5.x
• Experienced with various J2EE design patterns like Model View Control (MVC), Data Access Object, Factory Pattern, Session Façade, & Singleton in the development of Enterprise Applications.
• Involved in complete Software Development Life Cycle (SDLC) phases which include Estimations, Requirement analysis, Design, Implementation, Testing and Deployment.
• Extensive knowledge of various Data Structures and Algorithms used in JAVA.
• Hands on experience in Object-Oriented Analysis and Design (OOAD) methodology using Unified Modeling Language (UML) using Rational Rose and Rational Software Modeler.
• Deep Expertise in J2EE technologies like JSPs 2.0, Servlets 2.x, EJBs 2.0, JDBC, Java Beans, Exception Handling, Multi-threading, JavaBeans, I/O and Collections.
• Proficient in developing Web Applications with various Open Source frameworks: Struts Framework 1.2, Hibernate 2.0, and Spring framework
• Worked with XML parsers like JAXP (SAX and DOM).
• Good Experience in Server side Business Logic Development using Session, Entity and MDB.
• Proficient in various Web based technologies like HTML, DHTML, XML, XSL, and JavaScript.
• Experienced in working with databases like MS SQL and Oracle.
• Extensive experience with Java complaint IDE’s like Eclipse and RAD.
• Articulate in written and verbal communication along with strong interpersonal, analytical, and organizational skills.
• Highly motivated team player with the ability to work independently and adapt quickly to new and emerging technologies.

TECHNICAL SKILLS

Programming Languages: Java (JDK 1.6), PL/SQL

Master Data Management: Siperian Integration Framework (SIF), Informatica Data Director (IDD), Informatica MDM 9.1.0, MDM 9.5.1, MDM 9.7.1, MDM 10.0

Data Quality: Informatica Data Quality.

AWS Platform: Elastic Compute Cloud (EC2), S3, Lambda, API Gateway, SNS, SQS, RDS etc.

Scripting & Markup Languages: Java Script CSS, HTML 4.0, XML 1.1, XSL, XSLT, DHTML

Web Technologies: JSP 2.0, Servlets 2.3, EJB 2.0

Frameworks & Middleware: Struts 1.2, Hibernate 2.1, JUnit 3.8.1, EJB 2.0, Spring

IDEs: Eclipse 3.x, RAD 7.5.x

RDBMS: TOAD 7.x, Oracle 10g, MS SQL server

Web/Application Servers: BEA Weblogic 8.1, Apache Tomcat 5.x, IBM WebSphere 6.x

Platforms: Windows, Linux (RedHat 7.2), Sun Solaris

XML Parsing technologies: Castor, Ajax, JAXB

OOAD Language and Tools: Unified Modeling Language (UML) using Rational Rose and Rational software Modeller 7.5.x

Version Control tools: PVCS, Clear case, VSS, Dimensions, TFS

Quality Control tools: Clear Quest, Quality Centre

PROFESSIONAL EXPERIENCE

Confidential

SENIOR CONSULTANT

Responsibilities:

• Converted existing CMXUE PL/SQL code to CMXUE java implementation as per MDM 10 requirements since the existing CMXUE package has been deprecated. Did complete development and testing for same.
• A huge volume of existing stored procedures had references to some of the CMX packages are that no longer supported in MDM 10. Actively worked on design and development of an approach to implement deprecated CMX packages using equivalent SIF APIs. It included CMX.PUT, CMXSM.SETHUBSTATE etc.
• Analysis and development to migrate existing SIF based application from 9.0.1 to 10.0.
• Utilized AWS platform offerings to provide solutions around Informatica MDM, which was migrated, to AWS.
• Design and development of real time RESTful web service for consuming data from MDM hub.
• Configuration of MDM Hub for data load.

Confidential

SENIOR CONSULTANT

Responsibilities:

• Actively participated in requirement analysis and mapping them to what is feasible vs non-feasible.
• Actively involved in data modeling feedback sessions to verify if IDD design is compatible to display necessary data based on the data model.
• Conducted UI sessions with business to understand the requirements and transform them to IDD. Developed a prototype as the first step.
• Prepared work flow diagrams for various business use cases to depict the approval process.
• Configured various complex custom roles in SAM based on business requirements.
• Build the IDD from scratch and did all the configurations needed to meet requirements.
• This includes all layouts, complex workflows, security filters, search queries etc.
• Developed custom java cleanse functions for various IDD fields and configured them.
• Developed very complex IDD user exits which used multiple SIF calls.
• Implemented custom action user exits.

Confidential

SENIOR CONSULTANT

Responsibilities:

• Top down approach. Created WSDL and XSD.
• Used Axis to generate POJO classes using the wsdl and internally marshal and un- marshal the SOAP messages (request and response).
• Data retrieval using jdbc data source and stored procedure call to fetch from nested tables.
• Used data transfer objects (DTO) to transfer data between layers.
• Exception handling: Created Custom exception class to wrap exceptions in all layers.
• Implemented a jdbc module using connection pooling, data sources and parameter file loading on server startup.
• Implemented performance logger to monitor performance at various stages of end to end flow and identify bottle necks.
• Implemented siperian connection pooling using GenericObjectPool and PoolableObjectFactory.
• Implemented WS security using CallbackHandlers.
• Implemented log4j using DOMConfigurator to read log4j.xml using an absolute path outside WAR/EAR.
• Extensively used servlets to load static data and initialize log4j, connection pooling etc on server startup using parameter file loading.
• Implemented WS client using jsp, servlets and java scripts.
• Developed front end to search data from MDM Hub.
• Implemented security features for JDBC connection as well as SIF connection.
• Configured roles, users, secure resources, queries and packages.
• Configured match paths, fuzzy and exact match columns, match rules and match rule sets.
• Implemented SIF calls with exact as well as fuzzy search to retrieve data from MDM Hub and display results in UI.
• Used single match columns as well as concatenated match columns for fuzzy search.
• Created unit test scripts, suites to implement functional testing.
• Implemented performance and stress testing using SOAP UI Pro 4.5.1to access throughput on existing infrastructure and tolerance to spike in load.
• Implemented excel file upload from UI to application server.
• Transformed excel file to delimited file using POIFSFileSystem.
• Implemented EJB siperian connection on server start up using properties file.
• Used SOAP UI for WS testing.
• Implemented initialization of all static lookups from DB on server startup.
• Did detailed design for WS Server and WS Client.
• Created Release Documentation, User’s Guide and Go Live Manual for MDM WS.
• Implemented data driven load testing for a SOAP request from external excel file.
• Executed multiple separate SOAP requests together as part of a load test.
• Migrated MDM WS from DEV to QA and Production.
• Did analysis and implemented jsp restricting to make them modular.

Confidential, NJ

SENIOR ASSOCIATE CONSULTANT

Responsibilities:

• Lead Onsite and offshore teams for successful delivery of the project.
• Interact with business users to understand the requirements and map them to design.
• Actively participate in development of web services for e-documents of policy holders.
• Perform code review, ensure proper unit testing is done to achieve defect free delivery.

Environment: Core Java, XML, Java, RAD (IBM Web Sphere Application Developer) 6.0, Oracle 10g and Toad.

Confidential, Seattle, WA

Onsite Team Lead

Responsibilities:

• Interacting with business users for requirements gathering and converting these requirements into technical solutions for Informatica Master Data Management product focusing mainly on IDD and SIF modules.
• Lead Onsite and offshore teams for successful delivery of the project.
• Customized IDD using Complex User exits, Custom actions, Custom Cleanse and validation functions.
• Configured Workflows to enable multiple step approval process for Create, Update, Delete, Merge and Unmerge Data Steward Operations.
• Designed and Developed Enterprise Level Read/Write web services to interact with Informatica MDM involving complex transformations with adherence to Strict Performance SLA’s.
• Developed complex queries and stored procedures to extract data from MDM using MDM Packages.
• Prepared detailed design for various modules based on design patterns like Factory Pattern Singleton, Adapter.
• Implemented Spring MVC and Spring ORM in different modules.

Environment: Informatica MDM 9.0.1, IDD, SIF, HM, Core Java, J2EE, XML, Java, Eclipse, Hibernate, Spring, Web Services, JAXB, Oracle 11g and Toad.

Confidential

Sr. JAVA Developer

Responsibilities:

• Develop the GUI of the application using JSP.
• Implemented the application using MVC Framework and integrated with Spring using Spring MVC.
• Used XML Parsers like SAX parser to parse the data
• Used Log4J extensively for logging purposes into the application
• Used MAVEN scripts to build and deploy the application
• Used ORACLE SQL for database access to execute queries update records through DML in database schema
• Extensively used Java Collection framework, Exception handling
• Used CVS for version controlling and JUnit for unit testing.
• Involved in fixing bugs and enhancements of the modules
• Developed Stored Procedures, database schema design in Oracle 10g database
• Used IBM WebSphere application server for deploying various components of application.
• Have delivered defect free releases.
• Implemented Hibernate Relational Mapping Framework using XML and developed HQL queries
• Employed Hibernate (ORM tool) for communicating with database
• Used SQL stored procedures with JDBC API for storing, updating user request.
• Implemented *.hbm.xml files, for developed POJO, to map objects to relational database
• Did effort estimations SMC technique.
• Worked on high level design and detailed design of various code components.
• Worked extensively on Rational Software Modeler 7.5.2 to create Class Diagrams, Sequence Diagrams for various use cases.
• Actively involved in Design and Code Reviews.
• Involved in using PMD for code review and integrate it with RAD to improve productivity.
• Used checksytle for defining coding standards and integrated it with IDE.
• Have implemented caching at appropriate places to improve response time.
• Have code complex stored procedures for fetching data from database.
• Actively involved in performance tuning initiative, which included java performance tuning as well as SQL performance tuning.
• Have worked on analysis of SQL queries for indexing to improve performance.
• Have worked on log reduction exercise to improve logging and remove redundant logging using Log4j.
• Created JUnit and executed the same.
• Worked on various source control tools which include PVCS, Clear case, VSS, Dimensions, TFS.
• Worked on various quality control tools like Clear Quest, Quality Centre.
• Have worked on productivity calculation for the project and ways to improve the same.
• Have worked on code quality improvement initiative and had come up an extensive coding standards checklist.
• Worked on XML parsing technologies like castor and JAXB.
• Developed code using Ajax for fetching data with partial submit.
• Have delivered defect free releases.

Environment: EJB 2.1 (Enterprise Java Bean), Core Java, XML, Java, RAD (IBM Web Sphere Application Developer) 6.0, Oracle 10g and Toad.

Confidential

Java Developer

Responsibilities:

• Design, develop and test functionalities user interface with JSP.
• Implemented several JUnit test cases.
• Involved in injecting dependencies into code using Spring core module concepts like IOC of Spring Framework.
• Worked on Hibernate for interacting with database Oracle 9i.
• Created mapping files and configuration files for Hibernate and Spring Inversion of Control (IOC).
• Supported Maintenance and bug fixes.
• Developed the application using Struts framework to model the MVC architecture along with Tiles and Validation framework.
• Developed EJB session beans, Message Driven Bean and Entity Bean.
• Development of XML files using XSLT, DTD's, Schema's and Parsing using both SAX and DOM parsers.
• Used Java/J2EE Design patterns like Session Façade and Data Transfer Object (DTO) in the project extensively, which facilitates clean distribution of roles and responsibilities across various layers.
• OO Analysis and Design using UML including development of Class Diagrams, Sequence Diagrams, Activity diagrams and implemented these diagrams in Rational Rose.
• Used the MAVEN scripts to build and deploy the application.
• Developed JSP Pages and Servlets to provide dynamic content to HTML pages.
• Wrote SQL stored procedures, and used JDBC to connect to database.
• Created database schema design, stored procedures using PL/SQL.
• Used queries to get the data from the Oracle database using SQL.

Environment: Core Java, Hibernate 2, Spring Framework 2, JavaBeans, Eclipse 3.0, MAVEN and Oracle 9i.