SUMMARY

• Around 4 years of work experience as an ILM/Implementation Consultant
• Expertise in Confidential Optim Data Growth, Test Data Management and Data Privacy V11.3 Solutions on Distributed and Z/OS environments
• Technical expertise in Data Growth, test Data management and Data Privacy Solutions using Confidential Optim enterprise data management tool Oracle/PeopleSoft/JDE applications
• Expertise in setting up Confidential InfoSphere products for custom and packaged application database systems.
• Understand the customer requirement and provide the solution design for implementation of ILM products across diverse environments
• Experience in analysis of the business requirements and software requirements specification
• Experience in implementing, designing and deploying the data governance and ETL solutions using Information Server 11.3/11.5 stack
• Experience in design and governance of metadata information using Information governance catalogue and Information governance dashboard
• Expertise in Informatica Power Center V9.x and V10.x
• Expertise in Informatica Test Data Management V9.x, V10.x for Data sub setting and Data Privacy
• Expertise in Informatica Data Archive v6.4 HF2
• Expertise in Informatica Application retirement v6.4.x
• Expertise in Informatica Data Validation Option (DVO), Test Data Warehouse
• Expertise in Informatica Data Visualization
• Expertise in Implementing Informatica Secure@Source V3.0, V4.0 to detect and protect critical data across the enterprise, lowering risk associated with cloud modernization
• Expertise in Informatica Enterprise Information Catalog (EIC) V10.2 for comprehensive discovery and visibility of all data assets across the enterprise
• Expertise in Informatica Live Data Map to present comprehensive view of data assets and data assets relationships
• Experience in preparing Technical design documents, Test Plans, Training Documents, Test cases and scripts
• Technical expertise in implementation of Discovery/Information Analyzer/Application Repository Analyzer (ARA) in identification of sensitive columns and data model relationships.
• Proficient in application design, development, customizations, coding, post - production support, Maintenance, testing of large applications
• Expertise in developing shell scripts for automation
• Expertise in product performance tuning
• Hands on experience on Confidential Optim with all databases like Oracle, DB2, SQL server etc.
• Expertise in setting up Confidential Optim and Informatica environment on Windows and Linux
• Strong Experience on Workflow Manager Tools - Task Developer, Workflows & Worklet Designer and Managing, Scheduling, and Monitoring of Informatica workflows.
• Identify business opportunities to increase usability and profitability of information architecture
• Experience in creating Confidential Cognos reports for archived data
• Ability to work on own initiative and as a part of team. Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly

TECHNICAL SKILLS

Operating System: Windows server 2008, 2012, RHE Linux, Oracle Enterprise Linux (OEL), Confidential AIX, Z/OS

Databases: ORACLE 10gR2 RAC/11g/12c, MS SQL Server 2008, 2012, 2014, Confidential DB2, Postgres

Languages: SQL/PLSQL, Unix Shell, R, Batch Scripting

Tools: & Utilities: Confidential Optim, Informatica TDM v9.7.1, v10.1, Data Archive 6.4, Power Center v9.6.1, v10.1, Secure@Source V3.0, V4.0, Informatica Live Data Map 10.1.1, Intelligent Data Lake 10.1, TOAD, SQL*Loader, Confidential Discovery, Confidential Information Analyzer, Confidential Application Repository Analyzer, Confidential Watson Explorer, Informatica DVO, Informatica Data Visualization, Informatica Enterprise Information Catalog

PROFESSIONAL EXPERIENCE

Confidential

ILM Implementation Consultant

Responsibilities:

• Installation and configuration of Informatica Data Archive 6.4 HF2 in Test and Production Environments
• Experience in installing PeopleSoft Accelerator FSCM 9.1 and HCM 9.1 in Test and Production Environments of ILM Data Archive
• Analysis of the environment and provided the architectural recommendations for Information Analyzer and Optim
• Performed installation and configuration of Information Server along with Information Analyzer component and Optim components
• Creation of connections in metadata asset manager and import of the metadata definitions
• Analysis of QNXT application database using Information Analyzer against SQL server 2012/2014 versions.
• Validated the data model generated by Information Analyzer. Also verified for any data anomalies.
• Imported the Information Analyzer data model into Optim for archiving.
• Creation of Optim access definitions, archive request, delete and restore request to perform archival process.
• Work with Confidential support/technical team to resolve the issues/bugs within the InfoSphere products identified during implementation
• Worked on PeopleSoft AP, AR, INV, OM and GL modules to determine the tables, archive criteria and entity development and implemented in ILM Data Archive EDM.
• Worked on defining entity constraints relationship between the tables in ILM Data Archive EDM
• Ran test archive cycles for each business object/entity. Adjust table lists, parameter and business rules to achieve desired results
• Created hundreds of Data Visualization reports using report Designer for viewing Archived data
• Ran test restore for each business object/entity to be archived in Production and Test Environments
• Built Seamless Access to access Production and Archived data from separate PeopleSoft PIA URL
• Configure Archive solutions based on the retention guidelines given by record manager
• Installation and configuration of Confidential Optim v11.3 on windows and Linux
• Installation of Confidential Cognos Framework manager v10.2
• Installation and configuration of Confidential Watson explorer foundational components
• Integrating Confidential Optim ODM with Confidential Watson explorer
• Performance tuning for Confidential Watson Explorer and Confidential Optim
• Developing technical design document, functional design document, Optim Run Book, siop diagrams
• Review documented strategy, architecture and approach with management and obtain sign-off
• Running Confidential Discovery to find the relationships between tables.
• Running Application repository analyzer (ARA) to find the relationships between tables for ERP applications
• Installation & configuration of Optim with SQL Server database
• Development of Access Definition (AD), Archive request, delete request, Restore Request, Table map.
• Building Access Definition, Defining selection criteria
• Testing the solution and validating the results
• Creating Data sources in ODM
• Integrating Confidential Cognos with Optim connect data sources
• Once the development process is completed, unit testing for the custom application
• Team meetings, project and team management, presentations and demos to the customer’s higher management
• User training and knowledge transfer

ILM Implementation Consultant- TDM/Data Privacy/Administrator

Confidential

Responsibilities:

• Understand the customer environment and provide the architectural design for implementation of ILM products across diverse environments
• Installation and configuration of Informatica TDM v9.7.1, v10.1
• Installation and configuration of Informatica PowerCenter v9.6.1 and v10.1 using silent and console installation mode for high availability
• Install and Configure Informatica Data Validation Option (DVO) v9.6 to run tests on masked data
• Created Shell scripts for automating data validation tasks
• Upgraded Informatica PowerCenter v10.0 to v10.1
• Upgraded Informatica Data Transformation v10.0 to v10.1
• Hard ware sizing for Informatica TDM solution
• Develop Enterprise wide TDM strategy using Informatica ILM tool
• Implemented ILM solutions using Informatica and Optim tools in customer infrastructure
• Performed installation and configuration of Discovery, Optim and Federation server products and its components
• Develop data rules, Meta data rules and data domains to discover sensitive columns using Informatica Developer Client
• Export Developer Client results and import it to TDM workbench
• Create Custom and Advanced masking rules to mask discovered sensitive data
• Developed mapplets for custom masking rules
• Configure JASPER reporting service in Informatica to display the test results from DVO
• Customization of the standard masking algorithm using LUA scripting in Confidential Optim to accommodate all of the customer masking requirements
• Developed TDM solution using Confidential Optim for databases on distributed and Z/OS platforms
• Experience with Confidential Information Analyzer to discover the data and relationships
• Performance tuning on Confidential Optim TDM masking solution executions
• Work with Confidential support/technical team to resolve the issues/bugs within the InfoSphere products identified during implementation
• Creation of batch scripts to automate the masking process for Oracle database systems
• Developed Architecture design, functional design, technical design, Installation and configuration documentation
• Knowledge transfer and provide support

ILM Consultant

Confidential

Responsibilities:

• Developed Archive, Delete, Restore Optim templates for Confidential Cúram modules as per user specification
• Developed Candidate table script
• Developed technical design document, System Validation Test (SVT) and command line test plans, unit test case documents