Candidates About

 

Jyoti Shrivastava 

Experience Summary:

Informatica Certified in MDM Hub with more than 8 years of IT experience in:

Ø  Software Development Life Cycle (SDLC) analysis, design, development, testing, maintenance and quality assurance with implementation of software applications in MDM and Data warehousing.

Ø  Business knowledge and designing experience of Data marts and Party Data Model based on business needs and use cases for Pharmaceutical (Abbvie) and Supply-Chain (HP) and Financial (Moody’s Investor Services, T Rowe Price) domains.

Ø  Business knowledge and analysis expertise for designing MDM solution. Creating Logical and Physical data model, defining relationships and hierarchies.

Ø  Extensive experience on MDM Admin role/responsibilities and worked on Installation and Configuration of Informatica MDM Hub, Cleanse Match Server (Process Server), Upgrading Master and User Specific ORS in different MDM versions and capability to apply any Hot Fixes and EBF.

Ø  Administrative experience of Informatica Developer IDQ, Power center for creating repository, users and assigning privileges, migration and troubleshooting and finding root cause. 

 

Ø  Extensive experience on Testing MDM Components like Base Objects, Match & Merge Rules, IDD Screens, Search/Display Queries/Packages, SIF APIs, System/Applications Health Checks, Infrastructure Upgrades and Testing/Validations.

 

Ø  Enterprise Data warehousing/MDM Testing – Data Integration, preparation and execution of test strategy, test plans and UAT, test scripts and performing regression testing for any business requirement for performance tuning and data validation.

 

Ø  Defining and configuring Query Groups and Display/PUT Packages.

 

Ø  Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.

Ø  Configuring new data source in the application server environment for Informatica MDM Hub.

Ø   Importing and exporting the ORS repositories from different environments.

Ø  Using Informatica Service Integration Framework (SIF) to develop the web service for MDM processes.

Ø  Good understanding of 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

Ø  Configuring Subject Area Groups, Subject Areas, Cleanse Functions, Match Rules Sets in IDD.

Ø  Extensive hand on experience with the Designing and development of Web pages, structured full web sites and templates.

Ø  Hands on experience in Designing web pages through Divs, Object Oriented CSS, and Analytic Reports for web sites/pages and special effects on web pages through JQuery.

Ø  Excellent skills and experience using the different web skills such as XML, HTML, XHTML, CSS, JQuery, Adobe Dreamweaver CS5, Photoshop, CMS like SiteCore and Joomla for web design and development.

Ø  Trained on Data warehousing, Informatica MDM v9.x/10.x and Java Integration tools.

Certifications & Awards:

Ø  Certified in Informatica MDM Hub 9.x, 10.x Developer Specialist.

Ø  Certified in Java Programming SCJP.

Ø  Spot Awards for my Best Performance within team for my previous roles.

 

Technical Skills:

 

EIM Tools	Informatica MDM v9.5, v9.7 (several HFs/EBFs), MDM v10.2, Informatica Power Center v9.6.1, IDQ
Product Platforms	Informatica MDM v9.x/v10.x , Tomcat, WebLogic v10.3, Jboss
Tools/ Software	Putty, Toad, SVN,COS, SNOW, HP ALM, ESMS, JIRA, SNOW, SOAP UI, Eclipse, COS, WinScp and UltraEdit, CMS, Adobe DreamweaverCS5, HTML5, CSS3, JQuery and ASP.net
Language	C++, Java, SOAP, SQL
Databases	MS Access, SQL Server 2005, Oracle 11g/10g/12c
Technical Expertise	Informatica MDM Tool v9.x/10.x, Agile Methodology, MDM Concepts Data Cleansing and Matching, Data Warehousing Concepts, BI/DW Tools, CSS, Java Scripting, HTML, Advanced excel, SharePoint and Documentam, Unix, Linux
Operating Systems	Linux , Vista, Windows XP, Windows 2003, Apple OS x and iOS.

 

 

Educational Qualifications:

Ø  Certified in Software engineering and Software Life cycle development from GNIIT, NIIT Delhi in 2009.

Ø  Bachelor of Science graduate from APS University, Satna, Madhya Pradesh, India in 2005.

 

 

Professional Experience:

 

 

 

Ø  From Aug 2017 to Nov 2017

 

T Rowe Price, Owings Mills                                                      

Informatica Sr. MDM Developer

Product Master -  As T Rowe has been exponentially growing and the marketplace has become increasingly competitive, the rate of new product introduction, Product analysis and product changes has drastically increased along with the number of business units, systems and websites that need to be informed of such changes. Developing and implementing an enterprise level product master data management framework was identified and sponsored by product group.

 

Responsibilities:

●      Worked closely with the Business Team to gather requirements/testing for the Match rules in identifying columns and setting Match Rules Sets as per project needs.

●      Involved in process of identifying and configuring the Match paths, Match Columns and Match rules for Exact and Fuzzy Match and Merge Process.

●      Configured new source systems in MDM and all corresponding MDM objects.

●      Configured Relationships and Lookups for Base Objects and Reference BO.

●      Configured cleanse match server to handle online and batch operations. Created and Used various cleanse functions to standardize the records.

●      Involved in various discussion of requirement and defining External Match process.

●      Running all the MDM processes like Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.

●      Created IDD Applications and configured Task Assignment dashboard.

●      Created and documented the secure resources, Users, Roles and assigned privileges to roles using MDM Hub Security Access Manager for Development, QA, Pre-prod and Prod environment.

●      Provide weekly status updates on progress, status, and issues

 

Tools: Informatica MDM 10.1, IDD, Eclipse, SOAP UI, jboss,  Oracle 12g, UNIX, Putty, WinSCP, SVN

 

 

Ø  From Dec 2016 to July 2017

Syntel Inc, New York                                                     

Project Lead – Informatica MDM/IPC/IDQ Admin

 

Moody’s Investor services: Moody’s Investors Service is among the world’s most respected and widely utilized sources for credit ratings and research. We provide stable, highly efficient infrastructure and application development for all the environments to fulfill Moody’s financial business needs. MIS is responsible for creating, managing and execution of business needs in a well-secured environment.

Responsibilities:

·         Communicated effectively among the various projects teams involving Application Support Team, Network, Database Teams, Storage and Unix teams.

·         Played a key role for Infrastructure Support:

ü  Responsible to manage Development, QA and Production environments.

ü  Responsible to upgrade from current version to next version.

ü  Troubleshoot and Resolve and Infrastructure issues.

ü  Proactively meeting with Business and technical team maintaining the standards.

ü  Worked on multiple servers Prod, Non-Prod environments for the existing MDM/IPC/IDQ to make sure that code is sync in all the environments.

·         Extensive experience in Outages Handling:

ü  Password Changes.

ü  Patch installation (Hot Fixes /Software’s)

ü  Bouncing Activities or Restarting the Services

ü  Network Changes

·         Performed major role as Infrastructure admin in Development and Production support projects Environment Monitoring:

ü  Constantly keeping eye on whether the infrastructure is readily available, I meant to say keep monitoring the readiness in the environment.

ü  System level parameter checks CPU spike, Memory utilization, Number of parallel loads (sessions) running on each node.

ü  Monitoring the loads (workflows) whether the loads are scheduled accordingly.

ü  Recovery or Re-start in loads in case of any failures.

ü  Identifying the tardiness in loading process in case of any sessions are in hung status.

·         Designed and developed various MDM/IDD components for new business requirements.

·         Daily support for MDM/IPC/IDQ application users for any error, data issues and performance.

·         Involved in Installing and building new MDM/IPC/IDQ environments with the latest version and delivering on time.

·         Performed infrastructure upgrade activities: Recently, Migrated from windows to Linux in IPC 9.6.1.

·         Worked on multiple servers Prod, Non-Prod environments for the existing MDM/IPC/IDQ upgrade to the latest version.

·         Enabled MDM/IPC/IDQ Audit in all the higher environments to fulfil secured environment needs.

·         Monitoring JBOSS/IPC/IDQ servers performing Health Check, Disk/memory utilization. to gather information for new server build requirement. 


·         Checking logs and troubleshooting if there are any issues in the server performance and involving vendor if required.

·         Restarting servers as required for all the MDM/IPC and IDQ applications.

·         Created Informatica Audit Reports for IPC for all the users at folder level/ Repository level access for SOX.

·         Performed Deployment and migration activities for MDM/IPC in all the environments.

·         Worked on setting up access roles and privileges for IDD/IPC users.

·         Created SOP for enabling Audit in MDM/IPC/IDQ.

·         Experienced in various ticketing systems like ServiceNow and JIRA to provide weekly/monthly status updates on progress, status, and issues at Team as well as Project level.

Tools: Informatica MDM V9.7.1HF6, 10.2, IDD, Jboss 6.2, Oracle 12c, UNIX, Putty, WinSCP, SVN, ServiceNow.

Ø    From May 2016 to Nov 2016

Hewlett-Packard Co, Houston

IT Development Lead / Business Systems Analysts

 

Integration of Aruba Networks into HPE – Mastering End User, Reseller, Distributor-MDM Deliver a master data solution that provides the ability to track and report on End Users, Resellers and Distributors, under HPE company reference, throughout the end to end Sales process.

Responsibilities:

●      Translate high-level architecture and process flows into technical development items (SOAP web service integration, real time integration, message bus integration, enterprise application integration).


●      Worked with Informatica Admin (MDM/ETL) activities including security, code promotion, config changes and issue debug.

●      Actively gather business requirement and user needs to understand the Real Time processing needs for Web Service calls for this Integration.
Proactively meeting with Business and Global technical team to gather information and distributing tasks to MDM and Java team for web service calls.

●      Work closely with the Business Team to gather requirements/testing for the Match rules in identifying columns and setting Match Rules Sets as per project needs.
Involved in various discussion of requirement and defining External Match process.
Identified Master records for Party Data by analysing the data and duplicate records from different source systems.

●      Provide weekly status updates on progress, status, and issues

 

Tools: Informatica MDM 10.0, IDD, Eclipse, SOAP UI, Web Logic v10.3, Web Logic Admin Console, Oracle 11g, UNIX, Putty, WinSCP, SVN.

 

Ø    From Mar 2014 to April 2016

 

AbbVie Inc, Chicago                                                      

Informatica MDM Tech Lead

SHA Integration – Integrated Master Data Management is a multi-domain MDM solution to have all the information centralized across Product, Account (Hospitals, Healthcare org), and Plan (Insurance Plan, Payer, PBM) data. Goal of the project was to identify master data for improved productivity of customer representative and marketing teams across all domains.

 

Responsibilities:

●      Actively involved in gathering business requirements from the business users in understanding the Real Time processing needs and user exits.

●      Worked closely with the Business Team to gather requirements/testing for the Match rules in identifying columns and setting Match Rules Sets as per project needs.

●      Involved in process of identifying and configuring the Match paths, Match Columns and Match rules for Exact and Fuzzy Match and Merge Process.

●      Configured new source systems in MDM and all corresponding MDM objects.

●      Configured Relationships and Lookups for Base Objects and Reference BO.

●    Configured cleanse match server to handle online and batch operations. Used various cleanse functions to standardize the records.

●    Involved in various discussion of requirement and defining External Match process.

●    Running all the MDM processes like Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.

●    Supported MDM application and Production environment for IDD Applications for any data quality issue or to improve the performance of MDM applications.

●    Created and documented the secure resources, Users, Roles and assigned privileges to roles using MDM Hub Security Access Manager for Development, QA, Pre-prod and Prod environment. 

●    Worked closely with Informatica to solve various defects. Issues such as null key match, issue with parsing foreign character while using Population file, sequence generation, data source issues.

●    Implemented multiple user exits, validation rules, SIF API’s to customize IDD application and create business-classified records.

●    Worked with other supporting teams such as SOA integration team to verify a record created or updated in database is reflected in all downstream systems

●    Write User Exits for validation errors and messages for save operation in IDD

●    Provide weekly status updates on progress, status, and issues.

 

Tools: Informatica MDM 9.1, IDD, Eclipse, SOAP UI, Web Logic v10.3, Web Logic Admin Console, Oracle 11g, UNIX, Putty, WinSCP, SVN.

 

 

Ø    From Sept 2013 till Feb 2014

Client: Quintiles Pharmaceutical, NC        

Role:  Informatica MDM Hub Developer

 

Projects: The US Specialties Business has decided to invest in improving Customer Master Data Management capabilities in order to provide a single trusted view of Quintiles Customers to better execute on Quintiles’s obligation to patients, customers and government agencies.  This Customer Master Phase 2 project is intended to support tactical master data goals and enable progress against broader Customer Centric goals.

 

Responsibilities:

●         Worked on gathering the business requirements and finalizing the different scenarios for finished and non-finished goods for Functional Requirement documents for MDM Testing.

●         Created Unit Test Case/Integration and Performance Test cases and completed several iteration of testing cycle to ensure a high performance/compatible MDM/JAVA.

●          Performed testing for various MDM Project application such as IDD/BDD, Java real time UI, Address and Key felids Validation user exits.

●          MDM Hub Configuration for Different Source Systems, Trust, Landing, Staging, Base Object creation and unit testing.

●          Created and documented the secure resources, roles, users for roles, and assigned privileges to roles  using Security Access Manager in Development, QA, Pre-prod and Prod environment. 

●          Defined the security such that MDM ORS schema will be secured with access only granted for specific integration uses, using users created for those specific integrations

●          Performed various code base line and code migration in different environments.

●          Created System Design Document, Test Cases and SOPs for the data entry team.

 

Tools: Informatica MDM v9.1/v9.5, Web Logic, Web Logic Admin, Oracle 11g, UNIX, Putty, WinSCP, SVN and ESMS.

 

 

Ø    From May 2013 till Sept 2013

Company:  eClerx Services Ltd., Navi Mumbai

Role:          Java Developer

 

Project I : Diagnostic Portal is central Data Management System. It deals with the control/management of the documents that are required for EDLS and DIALOG systems. The diagnostic data and coding data is stored in the Diagnostic portal and it is used in the production and after sales department for diagnosis of vehicles and its controllers i.e. ECU (Electronic Control Unit).Diagnostic Portal essentially consists of Server application (x DWS) and DB2 as database.

 

Responsibilities: As a team member, key activities performed includes

●      Involved in Knowledge Transition with T- Systems and Daimler at Germany

●      Application documentation and Development Environment setup configuration

●      Communication with the Client and Onsite team whenever required

●      Involves in defect analysis and providing the solution within time limit

●      Project Planning and Tracking, Configuration Management (SVN tool), Code Reviews, troubleshooting & Defect prevention,

●      Monitoring development activities, delivering & implementing the project as per scheduled milestones

 

Tools: JAVA, Srtuts1.2, XUL, Swing, DB2, J2EE (JSP and Servlets), Java Scripting and Client supplied Tools, Archiva repository, Artifactory repository.

 

Project II: CA, Inc., currently known as CA Technologies and previously as Computer Associates International, Inc., is one of the largest independent software corporations in the world. CA project includes services to deploy, monitor and secure your applications and infrastructure through planning, implementing and running industry-leading software.

 

Responsibilities:                                                                                                                                 

·         Coordinating with clients to understand the change requests and enhancements/ requirements for web applications and analytic reports.

·         Development of Java application, Web Sites/Pages using Java, SOAP and web technologies.

·         Internal review and audit for all changes made by team before actual client deliverable.

·         Designed and developed Web Pages on different languages over globe and analytic reports for the better reviews and improvements on websites.

·         Always ready to attend client’s request when and where required to make deliverable on time or in an emergency situation.

·         Project Planning and Tracking, Configuration Management (CVS tool), Code Reviews, troubleshooting & Defect prevention,

·         Preparing Weekly and monthly status reports

 

 

 

Ø  From Feb 2008 to Apr 2011

Company: Amorphous Technology Solutions Pvt. Ltd.,

 

Role:             Software Developer

 

Responsibilities:

·         Coordinated with clients/BD teams to understand the change requests and enhancements    requirements for web pages and mobile pages.

·         Developed many Web Sites/Pages using Java/web technologies.

·         Fulfilled all the new requirements of clients after go live for better customer satisfaction as giving support.

·         Appeared for monthly audits.

·         Communication with the Clients and Onsite team whenever required.

·         Interacting with the client for system study, requirements gathering, estimation, analysis and scoping.

·         Providing estimation and level of efforts for Development, Unit testing and Integration testing.

·         Daily monitoring for various web applications and Fix/Modify as per clients requirements.

·         Gathering client’s requirements for current and new web pages and making implementation on time to achieve better customer satisfaction.

·         Support and maintenance for current running Java Applications, web sites/pages.