OBJECTIVE:

To become skill full in Software Developing industry, where I can contribute to the best of my skills and efforts, for the growth of the company as well as myself.

SUMMARY:

• 11+ years of IT experience that includes more than 6 years in Informatica MDM, IDD, SIF, JMS queues, IDD and Hub User Exits, Weblogic & JBoss administration, Active VOS, Core Java, Power center, IDQ and SOAP & REST based Web services using JAX - RS, Spring Boot, WebAPI
• Experienced in designing and architecting end to end solutions using MDM, Data modelling, Data integrations, Data warehousing, Data Quality, Data Governance in real and batch modes.
• Good understanding of ITIL Processes in executing support engagement - Event Management, Incident Management, Problem Management, Access Management, Transition Planning, Change Management, Capacity and Availability Management, Release and Deployment Management and Knowledge Management processes
• Experienced in Requests for Proposals, Proposal Presentation, Product Demo, and Solution Architecture.
• Extensive experience in leading and managing large global teams across multiple countries and also in onsite/offshore model.
• Expertise in executing Implementation, Application & Technical Upgrade and Application Support & Maintenance.
• Experience in Project Management, Functional Consulting, Solution Architecture, Transformation and Business Process Reengineering.
• Played different roles as Business Analyst, Project Manager, Technical Architect, Systems Analyst and Developer.
• Informatica Products (MDM, IDD, SIF, Active VOS, Address doctor, Power Center, & IDQ)
• Data standardization of addresses using Address Doctor and Informatica Data Quality tools and Data integration in real-time
• MDM and Active VOS installation and upgradation on both windows and Linux servers
• Configuring the Active VOS workflow adapter in MDM and expert in task configuration
• Creating and configuring MDM tables, lookups, cleanse functions, mappings, batch processes, match & merge settings, external matching, SAM privileges, roles & users management, JMS queues setup, IDD, user exits, data security, data encryption, data masking, custom indexes, custom procedure integrations etc.
• Optimizing match & merge rule performance
• Scheduling MDM jobs using Auto Sys scheduler
• Working with Real Time Integration by using REST Web services (JAX-RS, Spring Boot, Web API’s), SIF Integration and JMS Queues.
• Data Processing experience in designing and implementing Data Mart applications using ETL tool Informatica Power Center 9.1
• Experience in migrating data to Salesforce Cloud using Power Exchange tools.
• Involved in Database design, entity relationship modeling and dimensional modeling using Star.
• Worked on developing and debugging Informatica Mappings, Mapplets, Sessions, Worklets and Workflows for data loads.
• Created reusable transformations to clean the data, which were used in several mappings.
• Worked with many existing Informatica Mappings to produce correct output.
• Experienced in working with tools like TOAD, SQL Developer and SQL plus for development and customization.
• Used IDQ tool to perform discovery and profiling of the production data.
• Determine data quality rules to resolve any issues discovered.
• Establish data problem mitigation action plans; and provide training and guidance on best practices for applying the IDQ application.
• Experience with data profiling, data quality measurement and data validation processing
• Creating Sales force triggers using APEX code, writing SOQL queries, data migration to sales force objects like accounts, products, cases, entitlements, assets, case feed, case attachments etc…
• Experience using Apex data loader/ Informatica data loader tools to insert/update/delete data from sales force
• Experience in creating single view of customers using Informatica cloud 360

TECHNICAL SKILLS:

Business Intelligence: Informatica MDM, IDD, SIF, User Exits, Informatica cloud 360, Informatica data loader, Informatica Power center, Active VOS, IDQ, SSIS, SSRS, SSAS, Power Pivot, Excel Reports, Performance Point Dashboards and Power View, Data Modelling, Data Profiling

Languages: Core Java, Adv. Java, OOPS, Sales force, APEX, C#.NET, ADO.NET, Web services, Rest services, Data Services

Testing Tools: Selenium, NUnit, Fiddler, ANT Profiler, SOAP UI

Web Technology: ASP.NET, HTML, XML.

Scripting Languages: JavaScript & JQuery, XML, JSON

Web Servers: IIS, Weblogic, JBoss, Web Sphere

IDEs: Eclipse, Spring Studio, Visual Studio

Version Control Tools: Microsoft Visual Source Safe. TFS, SVN

Operating Systems: Linux, Windows 2000/98/NT/XP/7/8.1

Databases: MS SQL Server, Oracle 11g, SOQL Queries

PROFESSIONAL EXPERIENCE:

Confidential,Boston, MA

Solution Architect

• Designed and implemented a business ID in MDM and always the lowest ID should win
• Designed and implemented KVC (key value change) logic using custom procedures
• Designed and created reject reconciliation logic to handle all the MDM and custom rejects
• Designed and implemented solution to keep the ID column unique across the system
• Created user exits to merge the children automatically during merge and unmerge of parents
• Jboss administration and troubleshooting the logs to find the root causes of the issues
• Configured hierarchies for Confidential legal entities accounts and their associations
• Exposed MDM golden data to consumers via REST services using SIF API’s, Composite Services, Spring boot and Spring STS
• Configured IDD for legal entities, children and relationships to govern and manage the data.
• Creating and configuring MDM tables, lookups, cleanse functions, mappings, batch processes, match & merge settings, external matching, SAM privileges, roles & users management, JMS queues setup, IDD, user exits, data security, data encryption, data masking, custom indexes, custom procedure integrations etc.
• One step, Two step, Update & Merge task configuration using IDD & Active VOS
• Configuring and tuning the match and merge rules and trust settings decay
• Optimized performance of oracle queries and procedures.

Environment: Informatica MDM Multi-domain 10.1.2 EBF5, Confidential ESP & ERP applications, Oracle 11g, IDD, User Exits, Composite objects and services, Active VOS, SIF, Java REST based web services, Spring boot, Spring STS, Provisioning tool

Confidential,Thousand Oaks,CA

Technical Architect

• Installed Informatica MDM 10.0.1 EBF2 and upgraded to 10.1 HF2 EBF5
• Design and development of web services frame work for the compliance team using eclipse and MDM SIF calls
• Weblogic administration
• Configuring managed nodes and load balancing using weblogic and F5 load balancer
• Designed and configured Hierarchy management for customer, product and territory models
• Migrated HM data into production without impacting the existing production data.
• Created a java based web application to perform the external match and merge by the business users to take the merge decisions.
• Configured IDD for the customer, product and territory models
• Configured Landing, Staging, Base objects and mapping for the data flow.
• Scheduled Business meeting to understand the requirements and explain the current data model.
• Used IDQ tool to profile the data from different sources and created dashboard for business to make decision on the Match Rule sets.
• Design and development to integrate the IDQ cleanse libraries with MDM hub
• Validated and Standardized the European customer addresses
• Created Active VOS tasks using a custom java program using the composite service calls.
• Implemented logic to survive the oldest Confidential and global Id’s for the customer records.
• Custom logic implementations using MDM and IDD use exits
• Implemented logic to generate the Territory number on initial and incremental data load, On IDD user save operations.
• Created functional, Design and Mappings documents
• Integrated external business application with Informatica MDM hub using Batch process, SIF and message queues a significant advantage
• Created POC to master the salesforce customer using Informatica cloud 360

Environment: Informatica MDM Multi-domain 10.0.1 EBF2, 10.1 HF2 EBF5, Informatica Power center/Analyst/IDQ 9.6, Address doctor, Oracle 11g, IDD, User Exits, Composite objects and services, Active VOS, SIF, Java web services, Informatica cloud 360

Confidential,Pittsburgh,PA

MDM & IDQ Consultant

• Installed Informatica MDM and power center in Development, Test and Production Environments
• Designed data model for the customer master.
• Configured Landing, Staging, Base objects and mapping for the data flow.
• Scheduled Business meeting to understand the requirements and explain the current data model.
• Used IDQ tool profile the data from different sources and created dashboard for business to make decision on the Match Rule sets.
• Created functional, Design and Mappings documents
• Created reference tables and lookup services using Informatica data quality tool

Environment: Informatica MDM Multi-domain9.7, Informatica Power center/Analyst/IDQ 9.5,Power exchange, Oracle 11g, Google API’s, IMS HCOS, IMS HCPS, Nucleus 360, Veeva, NCPDP

Confidential,Scottsdale,AZ

Project Lead

• Installed Informatica MDM and power center in Dev, Test and Production Environments
• Configured data model which is suitable for JDA business model for Product and customer.
• Configured Landing and staging and base objects and mapping to load data from landing to staging’s.
• Configured IDD application for product master where users can see the data and data stewards can steward the data.
• Created batch groups to run the regular loads and initial load and these batch groups and built power center mapping to call the batch groups through web service call.
• Participated in match and merge rule discussions and implemented the same according the business needs.
• Working with Informatica GCS team to resolve the product bugs
• Applied various hot fixes to resolve the product issues.
• Implemented near real time functionality as part of incremental load as per business needs.
• Provided training to various business users on the product and how to use the IDD and other required needs.
• Wrote extensive IDD custom logics to meet the business requirements using user exits and SIF
• Configured task approval process for product master using Active VOS
• Installed Informatica MDM 9.7.1 HF4
• Upgraded Informatica MDM 9.7.1 to 10.1
• Installation of Active VOS Server in Windows, JBOSS
• Configuring the Active VOS workflow adapter in MDM HUB console
• Configuring the task settings in IDD with Active VOS integration
• Feasibility check on the Informatica MDM cloud 360 (Data Scout)
• Scheduled Business meeting to understand the requirements and explain the current data model.
• Used IDQ tool profile the data from different sources and created dashboard for business to make decision on the Match Rule sets.

Environment: Informatica MDM Multi-domain9.7, Informatica MDM 10.1, IDD, SIF, User Exits, Informatica Power center/Analyst/IDQ 9.5,Power exchange, Active VOS, SQL Server, oracle 11g, Address Doctor, Core Java, Microsoft Visio, Sales force CRM, Workday financial & Jira.

Confidential,Scottsdale,AZ

Technical Architect

• Identify the gold set records for each object.
• Create Informatica mapping to push the data to the Salesforce using Informatica power exchange tools.
• Co-ordination with system owners/ users of multiple upstream / downstream applications spread across multiple affiliate countries and their support groups to ensure smooth integration and minimum business impact from the changes to existing system
• Designing the Solution. Creating model for employee’s master.
• Finalizing the table structures based on discussion with the various stake holders.
• Finalizing the Match Rules and Trust settings based on discussions with data stewards and data analysis.
• Finalizing the hierarchies to be built based on business needs.
• Application development and enhancements in Informatica MDM hub and ETL, PL/SQL.
• Development of MDM Match and Merge processes
• Development of MDM Trust settings at different source systems.
• Development of MDM Landing to Staging to Base batch jobs.
• Creating Product Hierarchies
• Configuring IDD
• Revamp of the whole publish process to the ODS.
• Identifying risks, business critical issues, performance issues and fixing them.
• Technical/gateway approvals and sign off on following documents:
• Requirement Document
• Design Document
• Mapping Document
• Verifying and Validating the application
• Code Migration to Production and production load monitoring.
• Post-delivery communication to up/down-stream applications/Support teams and Business
• Objects like Accounts, Products and Contacts are mastered using Informatica MDM - Initial Phase.
• Account Notes, SIG, knowledge Articles, Product Documentations are to be migrated as one time.
• Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses using Informatica Power Center, Power Mart (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Created Mappings in Mapping Designer to load data from various sources using complex transformations like transaction control, Lookup (Connected and Un-connected), Joiner, sorter, Aggregator, Update Strategy, Filter and Router transformations.
• Performed the data analysis making use Informatica Data Quality (IDQ).
• Installing and upgrading Informatica MDM.
• Build a re-usable staging area in database for loading data from multiple source systems using template tables for profiling and cleansing in IDQ

Environment: Informatica MDM 9.7, IDD, SIF, Power center/Analyst/IDQ 9.5, Power exchange, SQL Server, Core Java, Microsoft Visio, and JDA Salesforce sales module, PeopleSoft CRM, PeopleSoft FMS and Red Prairie Salesforce Support.

Confidential,Atlanta,GA

Application Lead

• Participated in preparing Sprint plans, Release Plans and Prod Release Plans along with the Client PM.
• Responsible for coordinating requirements with SME’s(Product Owners) and BA(Business Analysts)
• Project planning, tracking and status reporting to client and senior management.
• Co-ordinate and manage both offshore and Onsite teams (development, support, business, release, QA)
• Adopted the Agile Methodology and SCRUM processes for High flexibility and agility in development process
• Provided technical leadership for incorporating/developing business related projects/ enhancements through the creation of Technical Specifications after Analyzing the Requirements Spec and guidance to development team.
• Designed .NET interfaces and Components for all new development to make the application to be able to communicate with third party tools/systems and legacy applications.
• Involved in designing and developing the SOA / WCF Services and Web applications
• Conduct and participate in joint reviews with other Lead Architects on all the deliverables.
• Responsible for Prod Deploy and Support for the Production turn Co-ordination and Release Management teams in Application Deployment.
• Lead a team of 12 resources (Onsite and Offshore).

Environment: MS Project, GE Proficy, GE Proficy workflows, C#.Net, Share Point 2010, SQL Server, Visio, SSIS, SSRS, WCF, Visual Studio 2010

Confidential,Atlanta,GA

Application Lead

• Acted as a Business Systems Analyst (BSA) and Technical System Analyst (TSA) as a medium of client communication and team communication/coordination
• Completed the banking 101 Wipro exam and gained knowledge on banking domain
• Developed extensive unit testing using Unit and Support during Integration testing with various components.
• Application Setup and configuration management.
• Performed Configuration Management duties for front end applications using VSS and held final code review sign off for phase wise code releases.
• Client communication and coordination on business requirements.
• Acted as a change control manager for all mainframe packages and application deployments
• Co-ordinated a team of 16 resources.

Environment: Informatica Power center, Informatica data quality and assessment, SSRS, .Net WCF services, SAP BI/BO, Mainframes, ESB

Confidential

Team Lead

• Translated customer requirements into new features and services.
• Extensively involved in Developing Components for Business Layer and Data Layer, implementation in SOA Architecture.
• Designed and developed XAML Forms using C#.Net for the user interface.
• Used C #. Net Technology for server side programming.
• Integrated new Device Manger with Acuity Unwired application.
• Designing the user interface using Microsoft Expression Blend and Silver Light.
• Involved in writing Complex SQL queries, stored procedures and Triggers accessed SQL Server database using ADO.Net.
• Utilized ADO.Net technology extensively for data retrieving, querying, storage and manipulation
• Wrote the data access layer code using ADO.Net for SQL Server database.
• Extensively used Visual Source Safe, SVN as Version Control Tool.
• Business logic implementation for technical validations for the data was done using server control Form Validations.

Environment: Visual studio 2005, ASP.NET, C#.NET, ADO.NET, HTML, AJAX, SQL SERVER 2005, XML, IIS, Windows XP

Confidential

Software Engineer

• Involved in Maintenance / Enhancements of the application which includes consuming the web services
• Responsible for Database design, and creating of Stored Procedures to perform the Data retrieval from multiple tables using SQL Server Database.
• Works closely with Technical Lead to ensure understanding of the specifications and communicate updates on development milestones in project plan.
• Developed web pages using Asp.Net, JavaScript for Client side Validation.
• Implemented Core Business logic and the Error Handling.
• All the commonly used functions are written in a class file and calling those functions using inheritance.
• Developed Unit Test Scenarios and tested Test Scenarios in Web methods.
• Fixing the RFC’s within the stipulated time interval.

Environment: Visual studio 2005, ASP.NET, C#.NET, ADO.NET, HTML, AJAX, SQL SERVER 2005, XML,IIS, SQL Reporting, Nunit, Windows XP, VC++, MFC