SUMMARY:

• Expert in designing and implementing Confidential - Data Archive tool of Informatica, Data growth & Test Data Management solutions using Informatica ILM Data Archive.
• Provide consulting strategy on Live archival, application retirement, TDM and Data privacy engagements.
• Provide recommendations on architectural and technology options pertaining to data archival (ILM).
• Ability to multi-task and meet deadlines in a fast-paced, dynamic environment.
• Extensively worked on Informatica PowerCenter Client versions 9.x including Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console.
• Excellent analytical and problem solving skills, shown by resolving numerous production issues.
• Strong Domain expertise in Insurance, Life Sciences and Health care domain.
• Current responsibilities include
• Data de-identification of PII data across all the databases of Hartford and also data archival.
• Key member in Confidential ’s Compliance and data security team which supports THIP team for every PII audit that happens on a quarterly basis.
• Requirements elicitation for Confidential application decommissions.
• Leading the retirement activities of Confidential ’s applications using ILM and playing a vital role in engaging various teams, spreading awareness for data de-identification in Confidential .
• Providing proactive business proposals by understanding customer needs and system capabilities.
• Providing Technical and functional support for Onsite and Offshore development activities.

IT SKILLS:

Product: Confidential (ILM) - Data Archive 6.4 HF2, Confidential (ILM) - Data Archive 6.1.1, Data Validation Option (Power Center by ILM), Confidential (ILM) - Test Data Manager 9.6.1, Informatica Power Center, Informatica Identity Resolution 9.5.4

Databases: Oracle, SQL Server 2005, SQL Server 2008

Frameworks: Microsoft .NET Framework 3.5/2.0

Web Development:

Technologies: ASP.NET3.5/2.0,JavaScript,HTML,ADO.net,Web Services

Operating System: Windows, UNIX - AIX, LINUX

Other Tools: JReports, Visual Source Safe (VSS) 6.0

Job Scheduling Tools: Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Windsor, CT

Lead - PII Remediation & Data Archiving

Environment: UNIX LINUX, ILM Test Data Manager, Informatica PC Clients, ILM Data Validation Option, DDS (Data de-identification Scanning).

Responsibilities:

• Played a vital role in spreading awareness for data de-identification across multiple teams in Confidential .
• PII Data scan of Oracle and SQL databases using the in-house DDS tool and designing the data de-identification plan for PII data masking.
• Played end to end role including generating and providing evidence and having meeting with multiple stakeholders including THIP, internal audit and presenting them with all relevant information.
• Decide the masking strategy for each of the sensitive data to be masked.
• Closely worked with product vendor (Informatica support, R&D) and co-coordinating with them to resolve all the critical issues.
• Installed ILM Data archive products (Data archive and FAS) in windows and Linux environments
• Providing assessments for the requirements with feasibility analysis and proof of concepts.
• Analyze requirement specifications.
• Played an important role in Application’s Product upgrade from ILM TDM version 9.5.1 to 9.6.1 and has been awarded as the Awesomist for the ‘Act of Awesome - AoA’ on that successive year.
• As Lead architect in designing the data masking strategies ensuring the data security and ILM framework for the application decommission providing cost benefits to the customer.
• Exploring TDM product as DaaS (Data as a Service) capabilities to propose new business enhancement and solutions.

Confidential, Wilmington, DE)

Senior Systems Engineer/ILM - Lead

Environment: UNIX AIX, ILM Data Validation Option, JReports.

Responsibilities:

• Closely worked with customer in understanding requirements in system and providing retirement solutions.
• Closely worked with product vendor (Informatica support, R&D) and co-coordinating with them to resolve all the critical issues.
• Providing assessments for the requirements with feasibility analysis and proof of concepts.
• Analyze requirement specifications.
• Business presentation on Infosys Solutions for Confidential initiatives.
• Solving post production issues with respect to application retirement.
• Played an important role in Application’s Product upgrade from ILM version 5.3.7 to 6.1.1 and was awarded as the best performer on that successive year.
• As Lead archivist role in Confidential ’s Siebel application retirement using ILM which benefited ILM in major cost savings.
• As Lead archivist role in Confidential ’s Oracle and SQL server based applications.
• Active role in Confidential ’s application rationalization program.
• Exploring ILM product capabilities to propose new business enhancement and solutions.

Confidential, Wilmington, DE

Senior Systems Engineer/Onsite - Co-coordinator

Environment: .Net Framework 3.5, C#,SQL SERVER 2008, JavaScript, Web services, OOPS Concepts, WCF

Responsibilities:

• Worked as an Onsite Co-coordinator and hence was able to learn the entire application from client perspective.
• Testing the enhanced version of Confidential application after various releases, thereby learning the new functionalities.
• Analyze requirement specifications.
• Write design document and effort estimation.
• Development and Unit Testing.
• Optimized the application code for Performance gain.
• Deploy Web Services and Application deployment in server.
• Solving post production issues.
• Was the Onsite Coordinator and was managing upto 15 people in offshore.
• In addition to the technical skills, my onsite tenure improved the soft skills.
• Extensively worked on Confidential 2.7.2 versions with participation in end to end project life cycle

Confidential, Wilmington, DE

Senior Systems Engineer/Onsite - Co-coordinator

Environment: .Net Framework 3.5, C#,SQL SERVER 2008, JavaScript, Web services, OOPS Concepts, WCF

Responsibilities:

• Worked as an Onsite Co-coordinator and hence was able to learn the entire application from client perspective.
• Testing the enhanced version of Confidential application after various releases, thereby learning the new functionalities.
• Analyze requirement specifications.
• Write design document and effort estimation.
• Development and Unit Testing.
• Optimized the application code for Performance gain.
• Deploy Web Services and Application deployment in server.
• Solving post production issues.
• Was the Onsite Coordinator and was managing upto 15 people in offshore.
• In addition to the technical skills, my onsite tenure improved the soft skills.
• Extensively worked on Confidential 2.7.2 versions with participation in end to end project life cycle

Confidential, Wilmington, DE

Senior Systems Engineer/Onsite - Co-coordinator

Environment: .Net Framework 3.5, C#, Oracle 10g.

Responsibilities:

• Worked as an Onsite Co-coordinator and hence was able to learn the entire application from client perspective.
• Worked with many teams which are involved in different phases of the project.
• Analyze requirement specifications.
• Write design document and effort estimation.
• Development and Unit Testing.
• Solving post production issues.