SUMMARY:

To continue my growth on the learning curve and perform well in new roles and responsibilities. At the same time contribute towards the overall goal and growth of the organization.

STRENGTHS:

Good Analytical techniques, ability to work on multiple projects and technologies. Ability to coordinate and work with multiple teams driving towards project goal.

SKILLS:

Operating System: Mainframes, Unix, Windows

Database: DB2, Sybase, UDB, SQL Server

Technologies: PL/1, JCL, Shell Scripting, SAS, VB scripting, PL/SQL, LUA scripting

Tools: Autosys, Informatica PowerCenter, HP Quality Center, SharePoint, MS Project, MS Visio, HP Service Manager, Changeman, Trizetto Facets

Others: Data Warehouse, Data Mart concepts, Change Data Capture concepts

Project Management Stream: Business Analyst; Process Consultant

TDM Tools: Informatica, IBM Optim, CA TDM

PROFESSIONAL EXPERIENCE:

TDM analyst and Infrastructure lead

Confidential

Responsibilities:

• Working on application analysis for PHI sensitive data using in - house metadata profiler
• Working with privacy office to finalize PHI sensitive data elements to be masked
• Understanding integrations between multiple cross-platform applications to figure out best possible data masking sequence
• Work with DBAs and Environment management teams to standup a sandbox environment to be used for Data Masking scripts development using IBM Optim
• Work on migrating Data Masking scripts from IBM Optim to Informatica TDM
• Work on creating new Data Masking scripts using Informatica TDM
• Work with Application Portfolio teams on application discovery
• Work on overall enterprise solution design and architecture

TDM Consultant

Confidential

Responsibilities:

• Working on RFI and RFP evaluation criteria for leading TDM tools - Informatica, IBM Optim, CA TDM and Delphix
• Evaluate current state Test Data Practices for the organization and come up with solution themes - data generation, data masking, subsetting, data virtualization
• Prepare Current state evaluation and gap analysis report
• Lead the effort for working on IBM Optim and CA TDM’s tool evaluation
• Recommend Operating Model for efficient working of the TDM team within SQM team
• Develop a roadmap for organization’s TDM framework growth
• Layout team competencies required for TDM organization’s functions

Test Data Analyst

Confidential

Responsibilities:

• Working on VB.net portal for providing self service capability to users to select test data from a set of Group; Member and Claims data
• Work on synthetic data generation of data based on a sampling of existing test data
• Working on data replication using Informatica ETL process
• Working on data masking using Informatica ETL process
• Understanding Oracle based backend data model for Facets product

Development Lead

Confidential

Responsibilities:

• Working with Business Clients to understand the requirements and work on the solution design and test plan for the project
• Work closely with Business analyst for requirements analysis
• Code walkthroughs with business clients and Application support team
• Coordinating with offshore ETL developers for working on client requirements
• Working with DBA and Data specialists for updating database definitions as required by the project.
• Managing team’s effort for development and testing efforts
• Work with multiple business areas and vendors
• Technology Involved: Unix, SAS, Websphere Message Broker, Informatica ETL
• Tools Involved: Autosys, HP Quality Center, MS Visio, MS Project, HP Service Manager
• Tracking schedule for various efforts in design phase
• Following up and resolving dependencies across multiple teams
• Test scenarios and Test case reviews
• Test Data Setup
• Implementation Planning

Data Masking Analyst

Confidential

Responsibilities:

• Working with various Application Development teams to analyse impact of data masking on that particular application.
• Managing team’s effort for development of solution for data masking and risk mitigating application development environments
• Technology Involved: Mainframe
• Tools Involved: IBM Optim (Mainframe)
• Tracking schedule for various on-going data masking efforts for Mainframe applications
• Following up and resolving dependencies across multiple teams
• Worked on Test Data Management within Data Masking Team

Deployment and Requirements Lead

Confidential

Responsibilities:

• Deployment lead for migration of Informatica mappings, JAVA components, DB stored procedures and SSRS reports
• Implementing Informatica based solution for fulfilling projects functional and performance requirements
• Technology Involved: Informatica, SQL stored procedures
• Tools Involved: MS Visio, MS Project, HP Service Manager
• Requirements lead for other Confidential . This role involves stakeholder identification and interaction with various infrastructure teams to identify and capture system requirements
• Regression Testing
• Performance Testing
• Implementation Planning

Analyst and Requirements Lead

Confidential

Responsibilities:

• Providing support and consultation for like Quality Check, Continuous Service Improvement, Process Maturity Assessment and Annual Planning processes
• Developer for VBA based applications for Quality Check and Process Maturity Assessment review applications
• Technology Involved: MS Excel VB programming, SharePoint
• Tools Involved: HP Service Manager, MS Visio, MS Excel
• Requirements lead for new enhancements to applications and infrastructure resources

Test Lead

Confidential

Responsibilities:

• Project involves testing the changes that need to be made for remediating a numeric field in the existing system to an alphanumeric field.
• Test Lead for the project.
• Technology Involved: PL1, Informatica, Unix
• Tools Involved - MS Visio, MS Project
• Requirements gathering, Test Plan creation, Test case Review

Development lead and Test Lead

Confidential

Responsibilities:

• Code changes to existing MF jobs (PLI) and unix scripts. New Informatica Mapping for data load.
• Development and Test Lead for the project
• Coordinating with offshore for ETL based solution for project’s requirements
• Technology Involved: PL1, Informatica, Unix
• Tools Involved: HP Service Manager, Autosys
• Responsibilities include requirements gathering, test scenario and test case creation.
• Coordinating communication between clients and offshore team
• Test Scenarios and Test case creation
• Test data setup