Tdm Analyst And Infrastructure Lead Resume
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