SUMMARY

• Confidential is a Techno - Functional Consultant with over 25 years of experience in HealthCare, Finance/Banking, Retail, Child Welfare, Telecom domains developing IT solutions using Informatica MDM, Informatica Intelligent Cloud Services (IICS), Informatica Power Exchange, Informatica Power center, Informatica Data Quality, Informatica Designer, Workflow Manager, Repository Manager, Informatica TDM, Informatica EDC, Erwin Data modeler, IBM Data Stage, IBM Quality Stage, Collibra, IBM Cognos BI tool, Tableau, Microsoft Power BI, SOA and Java technologies.
• Experience in integrating data to/from on-premise database and cloud-based database solutions using Informatica Intelligent Cloud Services (IICS).
• Experience in major databases and in different not relational databases such as Mainframe files, flat files, XML files
• Expert in all phases of Software development life cycle (SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Venkat TEMPhas experience in graph databases Neo4J, Amazon Neptune, Tiger graph, Cypher Query language.
• Excellent communication, presentation skills, a very good team player and self-starter with ability to work independently and as part of a team
• Extensive experience in UNIX Shell scripting, AWK and file manipulation techniques.
• Experience leading, mentoring, and managing onsite and offshore teams

TECHNICAL SKILLS:

Specialties: Informatica MDM, ESB, SOA, TIBCO MDM (CIM) 8.2, TIBCO Business Works

Data Modeling: Erwin, ER Studio and Oracle Designer

Integration: ESB, JMS, Web Services (SOAP/REST), RabbitMQ, Apache MQ

Graph Db: Neo4J, Amazon Neptune, Tiger graph, Cypher Query Language

ETL: Microsoft SSIS, Informatica PowerCenter, IBM Data Stage

Languages: Java, C/C++/C#, XML, UML, SQL, T-SQL, CORBA IDL, ASP, JavaScript

Distributed Computing: J2EE, Struts 2, Hibernate 3, Spring 2.0, EJB, WebLogic 9.2, WebSphere 6.1 CORBA, JDBC.

RDBMS: Oracle 9i/10g/11g, MS SQL Server, DB2, MySQL, Sybase.

Op. Systems: UNIX, Linux 2.4, Windows NT/2K, Solaris and DOS.

IDEs: Informatica MDM Workbench, Informatica Power center, Informatica Data Quality, TIBCO MDM Studio, TIBCO Designer, Eclipse, WebLogic Workshop, IntelliJ IDEA, Oracle JDeveloper, WebSphere Studio Application Developer

PROFESSIONAL EXPERIENCE

Confidential, TX

Informatica MDM Lead Developer

Responsibilities:

• Design, configure, implement, and test Master Data Management solution (Member Domain) using MDM 10.4, Oracle 11g, MQ, JMS, JBoss Application Server in Agile methodology
• Built the data model, configured mappings in the MDM Hub. Worked with ETL Developers in creating external batch jobs to execute mappings using Informatica workflow to integrate varied sources like Mainframe Copy Books, Oracle, flat files and loading into Informatica MDM landing tables
• Designed and created Base Objects, staging tables, mappings, transformations per business requirements and mappings to perform tasks such as cleansing the data and populate into staging tables
• Worked with Data Steward team for designing, documenting, and configuring Informatica Data Director for supporting management of MDM data
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
• Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD
• Configured Informatica Data Director (IDD) using e360, Provisioning Tool, Business Entity Services (BES), Subject Area Groups and Subject Areas
• Created mapping documentation, HDD and LDD
• High level review of SAM - discussed and documented user roles, created the users and assignment of user to roles
• Designed and implemented SIF APIs to publish data from MDM to ESB using message queues. Worked with ESB team to integrate MDM with down-stream systems
• Used Metadata manager for validating, promoting, importing, and exporting repositories from development environment into test environment

Environment: Informatica MDM 10.4, Informatica Data Director, SIF API’s, Informatica Power Exchange, Informatica Power center, Informatica DQ, Oracle 11g, JDK, Toad, JBoss, Address Doctor, SOAP UI, JMS, ESB, Eclipse IDE, Windows server, Unix

Confidential, Hartford, CT

Test Data Management Lead

Responsibilities:

• Installation, configuration, and administration of Informatica Test Data Management
• Defined data masking policies and data domains to mask specific types of data and group sensitive fields
• Discover and identify data relationships across different data sources
• Defined data masking and data sub-setting operations from source with and without reference data. Designed data masking functions worksheet for PII data elements
• Developed graph data model and framework to derive valuable insights of the data
• Worked with different application SMEs and DBAs to understand and document custom tables
• Involved in new Pre-Production environment build, configuration, and administration

Environment: Informatica TDM, Neo4J, Informatica EDC, Informatica Metadata Manager, Informatica Designer, Informatica Workflow Manager, Informatica Repository Manager, Informatica PowerCenter, AWS, CA ERWIN, Oracle 12g, PL/SQL, Toad, Case Management System

Confidential, Pasadena, CA

Informatica MDM Lead Developer

Responsibilities:

• Design, and implement Master Data Management solution (Member, Provider Domain) using MDM 10.2, IBM DB2, Oracle 11g, MQ, JMS, Oracle WebLogic Application Server 12.2 in Agile methodology
• Defined and built the data model in the MDM Hub, configured landing tables, staging tables, base objects and mappings, relationships, look-up systems, queries, and packages
• Worked with ETL Developers in creating mappings using Informatica Power center to integrate varied sources like DB2, flat files and other systems to load data into Informatica MDM landing tables
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
• Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD
• Configured Informatica Data Director (IDD) using e360, Provisioning Tool, Business Entity Services (BES), Subject Area Groups and Subject Areas
• Configured match rule set property by enabling search by rules in MDM according to Business rules
• Involved in SIF integration to develop XML code for external applications to perform search match API calls against MDM Hb Data
• Defined user roles and groups and created them in MDM Hub SAM workbench

Environment: Informatica MDM 10.2, Informatica IDD, PowerCenter, IDQ, SIF API Framework, Active VOS, Eclipse IDE, JDK 1.8, SOAPUI 5.3.0, JMS, ESB, Oracle 11g, IBM DB2, SQL, Oracle WebLogic Application Server 12.2

Confidential, Jersey City, NJ

Informatica MDM Lead Developer

Responsibilities:

• Design, configure, develop, test and implement Master Data Management solution (Customer (Party) Domain) using MDM 10.3, Oracle 11g, MQ, JMS, JBoss Application Server in Agile methodology
• Built the data model, configured mappings in the MDM Hub.
• Defined cleansed rules, match and merge rules, trust rules, queries and packages and batch groups
• Developed ETL mappings and Data quality rules using Informatica Power center, Data Quality, Data Analyst
• Configured Active VOS workflows to enable tasks to MDM data stewards to review/accept new records and merge potentially duplicate records
• Developed HDD, LDD, Mapping documentation, match and merge rules documentation. Analyzed functional specifications and user requirement documents.
• Performed data encryption in the MDM Hub Console and IDD UI.
• Developed Business Integration services and integrated with Informatica MDM system
• Configured Informatica Data Director (IDD) using e360, Provisioning Tool, Business Entity Services (BES), Subject Area Groups and Subject Areas.
• Mentored and lead onsite and offshore teams.

Environment: Informatica MDM 10.3, Neo4J, Active VOS, IDQ, Informatica PowerCenter, Informatica Data Analyst, AWS, Java 1.8, WSDL, XSD, Message Queues, Eclipse IDE, JBoss, Oracle 11g, SharePoint, ER Studio, HP Quality Center, Log4J.

Confidential, Denver, CO

MDM Lead Developer

Responsibilities:

• Design, configure, develop, test and implement Master Data Management solution (Customer (Party) Domain) using MDM 10.2, SQL Server, MQ, JMS, IBM WebSphere Application Server in Agile methodology
• Build the data model, configured mappings in the MDM Hub.
• Defined cleansed rules, match and merge rules, trust rules, queries and packages and batch groups
• Worked with ETL and IDQ developers to develop the cleanse rules and the mappings and workflows to develop ETL jobs for loading data into MDM and publishing data from MDM.
• Configured Active VOS workflows to enable tasks to MDM data stewards to review/accept new records and merge potentially duplicate records
• Configured Informatica Data Director (IDD) by creating subject areas, subject area groups.
• Reviewed configuration documentation and design documentation as well as analyzed functional specifications and user requirement documents.
• Mentored and lead onsite and offshore teams.

Environment: Informatica MDM 10.2, Informatica IDD, Active VOS, IDQ, Informatica Power center, Eclipse IDE, WebSphere Application Server 8.5, SQL Server, SQL Server Management Studio, SharePoint, TFS, Log4J.

Confidential, Orville, OH

Informatica MDM Consultant

Responsibilities:

• Design, configure, develop, test, and implement Master Data Management solution (EDI Trade Partner and Item Domains) using Informatica MDM 10.1 HF 2, Java, Oracle 11g, Oracle WebLogic Application Server, SOA.
• Architected and developed the MDM solution to integrate a variety of downstream systems using SIF API framework and Service Oriented Architecture (SOA).
• Worked closely with business and data steward team to get a good understanding of the data and to capture business requirements.
• Built the data model, configured mappings, cleanse rules, match and merge rules, trust configuration, queries and packages, batch groups in the MDM Hub.
• Developed and implemented Security model for the MDM solution
• Worked closely with the ETL team to develop the integration processes using Informatica Power center, Informatica Power Exchange and SIF APIs for real-time integration of the MDM application with downstream systems
• Developed IDD User Exits to implement custom business rules.
• Configured workflows using Active VOS.
• Involved in the complete Software development life cycle (SDLC) of the project.
• Created BRD, TDD, and User training documents.

Environment: Informatica MDM 10.1, Informatica IDD, PowerCenter, IDQ, SIF API Framework, Active VOS, Eclipse IDE, JDK 1.8, SOAPUI 5.3.0, JMS, ESB, Oracle 11g, PL/SQL, Oracle WebLogic Application Server 12.2.

Confidential, NYC, NY

Informatica MDM Developer

Responsibilities:

• Design, configure, develop, test, and implement Master Data Management solution (Customer (Member) and Provider Domains) using Informatica MDM 10.1, Java, Oracle 11g, WebLogic Application Server, SOA in Agile methodology.
• Designed and developed the MDM solution to integrate various source systems using ESB in a Service Oriented Architecture (SOA).
• Developed IDD User Exits for custom business rules.
• Configured task notification workflows using Active VOS.
• Developed MDM Hub Match and Merge rules, trust configuration, Batch groups, Queries and packages in MDM Hub Console.
• Coordinated TEMPeffectively between onsite and offshore teams for optimum utilization of the resources and time.
• Created configuration and design documents and analyzed functional specifications and user requirement documents.

Environment: Informatica MDM 10.1, Informatica IDD, Active VOS, SIF APIs, Eclipse IDE, Oracle 11g, PL/SQL, WebLogic Application Server 12.1, Log4J, Linux 2.4, JDK 1.8, SOAPUI 5.3.0, ESB, Mercurial, Pega Management Framework (PMF).

Confidential, Dallas, TX

Informatica MDM Developer / Solution Architect

Responsibilities:

• Design, configure, develop, test, and implement Master Data Management solution (Customer (Party) Domain) using MDM 9.6.1, Java, Oracle 11g, MQ, JMS, IBM WebSphere Application Server.
• Build the data model according to the business needs by interacting with the data architect
• Configured Informatica Data Director (IDD) by creating subject areas, subject area groups.
• Performed data cleansing and transformations/standardization using Informatica Data Quality and Informatica Power center
• Developed rules for cleansing/validating/standardization of data using regular expressions, pattern matching and reference tables. Defined System Trust and Validation rules for the base object columns
• Developed User Exits for implementing custom business rules.
• Developed MDM Hub Match and Merge rules, Batch jobs and Batch groups.
• Created Queries and packages in MDM Hub Console.
• Developed and reviewed configuration documentation and design documentation as well as analyzed functional specifications and user requirement documents.
• Mentored and lead onsite and offshore teams.

Environment: Informatica MDM 9.6.1/9.1, Informatica IDD, Informatica MDM Workbench, Informatica Data Quality, Informatica Power center, Eclipse IDE, WebSphere Application Server v7.0, Oracle 11g, PL SQL, Oracle JDeveloper, SVN, Log4J, Tomcat, Linux 2.4, HP Quality Center.

Confidential, Cincinnati, OH

MDM Developer (Lead) / Solution Architect

Responsibilities:

• Design, develop, test, and implement the MDM solution (Item domain) using TIBCO CIM, TIBCO BW, Java, DB2. Responsible for implementing, maintaining master data hubs and applications/processes in support of Kroger’s Master Data Management effort.
• Designed and developed workflows using Business Studio for data governance and maintaining the data quality in the MDM system using Tibco BW, Web Services, SOAP and integrated with the CIM application.
• Perform data cleansing and transformations using ETL (Informatica Power center and Informatica Data Quality
• Design and configure rules for cleansing/validating/standardization of data.
• Wrote Cron jobs and used with TIBCO File Watcher utility for auto scheduling of various jobs to import and/or export, synchronization.
• Leading, mentoring and managing onsite and offshore teams.

Environment: TIBCO CIM 8.2/8.1, Informatica Data Quality, Informatica Power center, TIBCO BW, EMS, JMS, TIBCO Hawk, TIBCO Administrator, XML/XSLT, SOAP Web Services, WebSphere Application Server v6.0, DB2, SQL, Eclipse IDE, Linux 2.4, Tortoise SVN, HP Quality Center.

Confidential, Plano, TX

Sr. MDM Developer

Responsibilities:

• Design, development, testing and implementation of the Customer and Store domains of MDM using TIBCO CIM, TIBCO BW, Java, Oracle.
• Responsible for designing, developing, implementing, maintaining master data hubs and applications/processes in support of Rent-A-Center’s Master Data Management effort.
• Developed the Email system for sending email notifications based on certain triggers in the application like entering the Store Number, setting the Actual Opening Date using Tibco BW, Web Services.
• Performed data cleansing and transformations using ETL (Informatica Power center and Informatica Data Quality
• Used JDBC, Web Services for developing the necessary interfaces to extract data from external systems into the stage tables for import into the CIM application.
• Wrote Cron jobs for scheduling nightly data import into the MDM system and data export using TIBCO File Watcher utility.
• Developed CIM workflows and rule bases to use with the MDM system.
• Leading, mentoring and managing onsite and offshore teams.

Environment: TIBCO CIM 8.1, TIBCO BW, Informatica Data Quality, Informatica Power center, EMS, TIBCO Hawk, TIBCO Administrator, XML/XSLT, SOAP Web Services, WebSphere Application Server v6.0, Oracle 11g, SQL, Eclipse IDE, Linux 2.4, Tortoise SVN, HP Quality Center.

Confidential, Dallas, TX

Programmer Analyst

Responsibilities:

• Design, develop, test, and implement a J2EE, Web Services, Hibernate, Spring framework web-based solution designed for Insurance Providers and Employers to enroll employees from organizations.
• Used Java EE, Web Services, AJAX, WebSphere, Hibernate, Spring framework and J2EE software design patterns to develop the web-based Benefit Management System.
• Involved in creating Detailed Design Documents, Sequence Diagrams, and Class Diagrams.
• Performed data cleansing and transformations using ETL (Informatica Power center and Informatica Data Quality (IDQ))
• Used HL7 standards for message formatting in the output files.
• Used Extreme Programming (XP) methodology for developing the system.
• Used JUnit for writing System Test Cases and unit testing.

Environment: Java EE 5, Java 1.6, EJB 3.0, Servlets, JSP 2.1, Informatica Data Quality, Informatica Power center, Webservices, Hibernate, Spring, JAXP, JAX-WS, WSDL, JDBC, JavaScript 1.2, JUnit, Visual Source Safe, JIRA, Eclipse, IBM WebSphere Application Server 6.0, IBM DB2, IBM Application Server Toolkit

Confidential, Tallahassee, FL

Sr. Software Engineer

Responsibilities:

• The FSFN Application uses the FSFN Application Framework which is non-proprietary and is based upon the Apache Jakarta Struts Framework (Struts) implementing the Model-View-Controller (MVC) design pattern using Java 2, J2EE (JDK 1.4.2, JDBC, JSP 1.1, Servlet 2.3, RTF 1.6, JavaScript 1.2 and HTML 4.0.1, CSS, WebLogic 9.2, Db2 v8.1.11, BusinessObjects XI Release 2.
• Developed reports using Crystal Reports and Desktop Intelligence Reports. Summary reports are developed using Crystal Reports and listing reports are developed using Desktop Intelligence Reports.
• Responsible for developing and maintaining the Business logic (entity and session beans) for my modules of the application.

Environment: JDK 1.6, J2EE, JDBC, JSP 1.1, Struts 1.2, Servlet 2.3, RTF 1.6, DB2, SQL, XML Spy, JUnit, WebLogic Application Server 9.2, Linux.

Confidential, Dallas, TX

Java Developer

Responsibilities:

• Design, develop, test, and deploy a J2EE, JSF, WebSphere, Db2, Hibernate, Spring based 3-tier web application. The different modules of the portal are COB Manager, Medicare Disallowance System (MDS), Managed Care (MCO) and Phoenix.
• MDS is the first intranet application of HMS. MDS is used to match the claims received from the insurance companies using various parameters like SSN, MA number.
• Used HL7 standards to comply with the HealthCare standards in building the Phoenix system.
• Interacted with the end users in requirement gathering.
• Mentored and coordinated the team members.
• Provided production support for the application.

Environment: Java 1.4, J2EE, JSF, Hibernate, Spring, JSP 2.0, JMS, AJAX, JERPA, Adobe Flex, HTML, DHTML, ASP, VBScript, JavaScript, XML, Db2 UDB, HQL, Quest Central, XML Spy, JUnit, IBM WebSphere Application Server 5.3, WebSphere Studio Application Developer v5.1.2, Apache Ant, Linux.

Confidential, Santa Ana, CA

Programmer/Analyst

Responsibilities:

• Develop, test, and deploy a web-based case management system for the Confidential and the California Superior Courts using J2EE, EJB, JSP, XML, SQL Server, and SQL. The V3 Project is developed based on the Struts Framework and the V3 Framework.
• The V3 system is designed to meet the requirements of Civil, Small Claims, and Probate case types. Requirements for the other case types will also be taken into consideration with the intention of developing an architectural framework that can be extended later to other case types.
• Developed the Admin (Configure Scheduling Rules, Configure Resource Allocation, and Configure Resource Unavailability), Calendar (Finalize Calendar, Display/Print Calendar), Disposition (Record/Enter Judgment), Courtroom (Record Issuances), Case Management (Case Initiation, Case Association, and Case Disassociation) modules for the V3 Application.
• Deployed the V3 application on IBM WebSphere Application Server 5.1.

Environment: Java 1.4, J2EE, Jakarta Apache Struts Framework, EJBs, Web Services, JSP 2.0, JSTL, Tiles, XML, SQL Server, SAX Parser, SQL, XML Spy, JUnit, Rational Rose (UML), Rational Clear Case, Clear Quest, IBM WebSphere Application Server 5.1, WebSphere Studio Application Developer, Windows XP, Sun Solaris.

Confidential, Rockville, MD

Software Developer

Responsibilities:

• Developed a Web based system for the Altimate (Federal Financial Management System) using Struts framework an integrated with the BC4J (Business Components for Java) framework.
• Designed and developed the views (User interfaces) using JSP.
• Implemented using WSAD as IDE for deployment on WebSphere Application Server in Production Environment.

Environment: Java 1.4, Struts Framework, JSP 2.0, Servlets 2.4, HTML, XML, UML, Oracle 10g, PL/SQL, Windows NT, BC4J Framework, JUnit, JBoss 3.0, WebSphere Studio Application Developer, WebSphere Application Server.

Confidential, Boxborough, MA

Software Engineer

Responsibilities:

• Designed and developed EMT (Edge Service Router Management Tool) an intricate, TEMPeffective and an efficient management tool for the operation technicians to view and monitor the provisioned subscribers and services, as well as, to trouble-shoot problems on the Cisco 10K Series ESRs (Routers) using Java Swing and JDBC.
• Additionally, EMT will provide capability to halp service providers to easily configure and provision subscribers and services.
• The user interfaces are developed using the Java Foundation Classes (Swing Classes), which allows users to view the various parameters related to the 10K ESRs.
• Used the SAX for processing the 10K Series ESRs data from the XML format.
• Involved in the design of the ESR Management Tool.
• Designed and developed the database for the ESR Management Tool.

Environment: Java 2, Swing (Java Foundation Classes), BEA WebLogic 6.1, SAX, XML, JDBC, SQL, SQL Server, Borland JBuilder and Windows NT.

Confidential

Consultant

Responsibilities:

• Designed and developed user interface screens using HTML.
• Used OMG IDL to map Java objects to C++ objects.
• Implemented the CORBA interfaces using Java IDL’s required for the application.
• Used IIOP, a CORBA-based protocol (program) to interoperate with a CORBA based program from another programming language, which is C++.

Environment: Java, CORBA, C++, JDBC, HTML, JavaScript, Oracle, PL/SQL, and Borland JBuilder.