SUMMARY:

• Have around 16 years+ of overall IT industry experience (till date).
• Adept in designing and managing TDM solutions framework (Test Data Management) on zOS and Distributed platforms using various tools such as IBM Optim, CA TDM (formerly, known as Grid - Tools) and Informatica TDM.
• Have excellent knowledge on industry leading TDM tools such as Informatica TDM (v10.1), CA TDM (v3.2) & IBM Optim (v11.3).
• Have expertise in Enterprise-wide TDM Assessment, Data Profiling, PII/PHI/NPI Analysis, Data Obfuscation/Masking, Data Subsetting, Synthetic Data Generation, Test Data on Demand, Data Mapping (Source-to-Target), Environment Refresh and Data Migrations (master, transactional, and ).
• Have excellent understanding on RDBMS systems such as Oracle 11g, Sybase, MS SQL Server & DB2.
• Have strong working experience in Mainframe technologies such as COBOL, JCL, CICS, VSAM, DB2, FILEAID, SPUFI, TSO/ISPF, IDMS & ADSO etc.
• Experienced in industry domains such as: Health Care, Securities and Capital Markets, Retail Corebanking (Pricing and Customer Communication systems), Telecom and Shipping.
• Have expertise in Business System Analysis, interacting with business & translating business requirements into technical architecture of the proposed solution.
• Have good project management skills including Scope evaluation, Estimation, and Project & Resource Planning, Work prioritization, Monitoring and Project Status reporting (technical project management experience).
• Have handled end-to-end Solution Delivery responsibilities starting from Requirement Analysis, System Architecture Design, Solution Design, Construction, Testing (SIT/UAT/Pre Prod), Reviews and Deployment of changes to production and Post-production support.
• TOGAF® Certified (Foundation) and familiar with architectural concepts of Open Group Architecture Framework (TOGAF® 9).
• Have proven leadership skills and led teams spread across multiple geographies.
• Have excellent analytical, communication, presentation and organizational skills.
• A quick learner & self-starter, eager to explore new technologies/domains.

PROFESSIONAL EXPERIENCE:

Confidential, NC

TDM Architect

Solution Environment: IBM Optim, Oracle 11g, DB2, Teradata, MS SQL, zOS (Mainframe), iSeries/AS400, Unix, FACETS™ v5.6 R2.

Responsibilities:

• Lead Data Masking assessment for the in-scope non-production environment and implement test data management solution in Confidential for different datastores including FACETS™ (A Confidential TriZetto product).
• Define strategy and implementation road map for masking the non-prod environments in scope.
• Implement Gold Copy architecture and create masked Gold Copy data for non-prod environment refreshes.
• Masking requirement analysis, application landscape understanding from system stakeholders and masking approach finalization.
• Data profiling, PII/PHI analysis, masking design creation.
• Create Masking frameworks for distributed databases and files as per need.
• Recommend necessary TDM tools based on the masking assessment outcome and technology landscape.
• Estimation & Project Planning, Project status reporting to various stakeholders.
• Team management.

Confidential, Michigan

Data Masking Lead

Solution Environment: Informatica TDM 10.1, PowerCenter 10.1, Oracle 11g, Sybase, Unix, FACETS™ v5.5 R2, SQL Developer, SQLDBX, WINSCP.

Responsibilities:

• Lead Data Masking activities for all the in-scope databases and implement test data management solutions in BCN.
• Implement Gold Copy architecture and create masked Gold Copy data for non-prod environment refreshes.
• Interact with SMEs, DBA and Application Managers to understand system constraints.
• Data profiling, PII/PHI analysis, masking design creation, seed data creation, Informatica workflow script creation & execution, Unit Testing, bug fixing, & QA support.
• Project management activities including scope evaluation, Estimations, Project and Resource Planning, Work prioritization and dissemination, Monitoring and Project status reporting.

Confidential, Michigan

Data Masking Lead

Solution Environment: Informatica TDM, PowerCenter 10.1, Oracle 11g, Unix, MPP (Microsoft Project Planning), FACETS™ v5.4 R2, TOAD, SQL Developer, WINSCP.

Responsibilities:

• Lead Enterprise Data Masking assessment for all the in-scope applications/databases and implement test data management solution in Confidential .
• Create strategy and implementation road map for masking all the non-prod environments.
• Implement Gold Copy architecture and create masked Gold Copy data for non-prod environment refreshes.
• Masking requirement analysis, application landscape understanding from system stakeholders and masking approach finalization.
• Data profiling, PII/PHI analysis, masking design creation, seed data creation, Informatica workflow script creation & execution, Unit Testing, bug fixing, & UAT support.
• Create Masking frameworks for distributed databases and for files such as EDI (X12 formats), XML, Flat, Delimited, CSV & FACETS Keyword files as per need.
• Coordinate and install Informatica PowerCenter and Informatica TDM tools to kick off data masking activities.
• Estimation, Project Planning, Resource planning.
• Project status reporting to various stakeholders.
• Team management.

Confidential, Maryland

TDM Architect

Solution Environment: CA TDM (Grid-Tools), FACETS™ v5.4 R2, Oracle 11g, Unix, MS SQL Server, IBM Mainframe, JCL, DB2, MPP (Microsoft Project Planning)

Responsibilities:

• Data Profiling, PII/PHI Analysis, Data Masking, Data Subsetting (federated data cube), Synthetic data generation, Test Environment/DB Refresh activities.
• Create self-service automation frameworks for synthetic data generation using TDoD (Test Data on Demand) and ARD (Agile Requirement Designer).
• Reengineer Test Data Warehouse (TDWH) to house gold copy data for the critical data sources in Confidential .
• Create and manage Gold Copy strategy in TDWH for environment refresh (lower environment).
• Optimization of masking and synthetic data creation process and implement process improvement ideas.
• Create Masking & Synthetic frameworks for distributed databases and for files such as EDI (X12 formats), XML, Flat, CSV & VSAM files as per need.
• Prepare & manage TDM strategy and Practice guide for TDM team.
• Ensure all SLAs & KPI targets are met & conduct RCA for the deviations.
• Onshore and offshore team management.
• Project status reporting, metrics preparation for various stakeholders.

Confidential, OH

TDM Architect

Solution Environment: IBM Optim, IBM Mainframe, COBOL, JCL, VSAM, DB2, AQT, SPUFI, FTP, MS Visio, MPP (Microsoft Project Planning)

Responsibilities:

• Create TDM strategy and solutions as needed by various applications (Enterprise wide).
• Understand test data needs from different applications and prepare data extraction scripts.
• Suggest and implement Gold Copy strategy.
• Extract Test Data, execute Obfuscation cycle as per data masking requirements of the organization and applications (different applications might have different masking requirements - conforming to the organization’s data security standards).
• Support adhoc test data requirements from application teams in sync with their Releases/Sprints.
• Create & manage real test data & synthetic data for SIT/UAT/Regression testing of various application teams.
• Run & Maintain the regular obfuscation cycle, Gold Copy process, fix the defects/issues and implement process improvements.
• Test Data version management.
• Carry out & manage data refresh cycles (Master & Transaction tables) in Dev/Test/UAT environments.
• Onshore and offshore coordination.
• Project status reporting to various stakeholders.

Confidential

Architect

Solution Environment: IBM Mainframe, COBOL, JCL, VSAM, CICS, EAZYTRIEVE, DB2, ENDEVOR, ESP (Scheduler), INSYNC, BMC Catalog, SPUFI, FTP, HP PPM (project & portfolio management), SharePoint, HP Quality Center, MS Visio, MPP (Microsoft Project Planning)

Responsibilities:

• Business System Analysis: Understand business needs and propose & develop technical architectural solutions for functional and non-functional requirements.
• Participate in Requirement gathering meetings involving multiple stakeholders such as Business sponsors, 3rd party vendors, customers.
• Participate in Architecture Governance and Architecture Review Board meetings.
• Responsible for getting sign-off on Architecture design approach from various project stakeholders such as ARB (Architecture Review Board), Front End team, Back End team, QA team, Business users, Project Sponsors.
• Participate in Architecture Design meetings, System Design & Technical Rollout review meetings and propose solutions and recommendations.
• Preparing BFSD/BVA (Business Viability Analysis), SOW (Statement of Work having high level architecture solutions), System Designs (having detailed solution approach) & Test Approach documents.
• Enterprise Data Analysis and propose Data Flow designs.
• Preparing Impact Analysis, Functional/High Level Design/Low Level Design, and guiding team in Construction, Testing & Implementation phases.
• Estimation, Project & Resource Planning.
• Liaise with different project teams (including 3rd parties), Project managers, Technical Managers and various other stake holders to ensure the business needs are addressed as per agreed timelines and deliverables are delivered without any defect.
• Project status reporting to various stakeholders.

Confidential

Architect/Technical Manager

Solution Environment: IBM Mainframe, COBOL, JCL, VSAM, EAZYTRIEVE, IBM TIVOLI OPC (Scheduler), SharePoint, FILEAID, CHANGEMAN, INFOMAN, PLANVIEW, HP Quality Center, MS Visio, MPP (Microsoft Project Planning).

Responsibilities:

• BAU Prod data analysis to identify NPI/PII data, Data Mapping (Source-to-Target), Data Masking or Obfuscation, Data Conversion/Transformation scripts preparation, Data Migration (master, transactional, and ) and Loading to the new Functional environment (OLTP/OLAP systems).
• Preparing Impact Assessment, Estimation, Functional/High Level Design/Low Level Design, Coding/Testing, Implementation.
• Responsible for Design/Development/Support/Maintenance of CSWP applications, having interfaces to Fidelity Systematics suite of applications such as RM/IMPACS/ALS etc.
• Participate in System Design & Technical Rollout review meetings and propose solutions and recommendations.
• Support SIT/UAT/PAT/Production batches and coordinate with various stakeholders such as Deployment/Testing/Business team to ensure smooth testing.
• Code Reviews and Defect fixing.
• Responsible for completion of FD/HLD/LLD as per the requirement (BRD) and ensure the design documents are Signed off on or before the target date.
• Liaise with Regional Managers, Project managers, Project team members, and various other stake holders to ensure the deliverables are delivered on time without any defect.
• Resource planning, Project status reporting to various stakeholders & Team Management.
• Project Management activities.

Confidential

Technical Specialist

Solution Environment: IBM Mainframe, COBOL, JCL, VSAM, DB2, Planview, SharePoint, HP Quality Center, FileAid, SPUFI, ENDEVOR.

Responsibilities:

• Requirement analysis and estimation.
• Understand the scope and clear business objectives of the project and the critical success factors of implementation project.
• Analyze and identify the business requirements and translate them in technical terms for Development team.
• Preparing System Design, FD/TD, UTP and reviewing various system documentations.
• Support SIT/UAT/Prod batches till the system gets handed over to BAU PS team.
• End to end delivery for projects (starting from RA phase till Implementation).
• Preparing RLS (Resource Loading Sheet) for resource planning.
• Project Status reporting.