PROFESSIONAL PROFILE:

• Fifteen years IT professional, the last 11 years of which have been exclusively implementing Test Data Privacy Products & Test Automation on Mainframe and Distributed and Cloud platforms using various Vendor Tools.
• Strong functional experience in Banking, Insurance and Financial Services Domain and familiar with various modules (Retail Banking, Credit cards, Mortgages, Commercial Lending, Corporate Action, Pledge, Clearing, Exchange, Trade Settlement, Buy - ins, Claims, Duck Creek, Workbench, Personal & Commercial Lines).
• Wide and varied background in developing and implementing business applications and I have had roles in all phases in the SDLC.
• As an Architect, developed and implemented Test Data Management solution on Mainframe, Distributed Platforms.
• As a consultant, dealt with many difficult situations, and have had to take part in, and lead teams through complex and difficult build and implementation of new applications, and/or new releases, in all projects developed good rapport with customers and received appreciation for my efforts.
• Created and maintained project plans, provide progress reporting, and resolve issues.
• Deployed SQL Servers on cloud platform and involved with build, implementation of SQL\Oracle Servers on Windows\Linux Platforms.
• Test Data Privacy Architect for Confidential and single point of contact at bank for Test Data Privacy/Test Data Management needs.
• Have 10 years' experience working with North American customer's onsite.
• Proficient in working with the stake holder, product teams, business users, technical teams, Off-shore and testing teams on different stages in an SDLC and experience in SDLC Methodologies like Waterfall and Agile.
• My mainframe\distributed skills are current. Additionally, extensive experience (expertise) using the Data Masking, Data Management and debugging tools from different vendors COMPUWARE, INFORMATICA, IBM, CA (TDM Workbench, File-Aid EX, File-AID/RDX, Data Solution, Optim, CA Data Maker, Delphix and Informatica PowerCentre), GenRocket

AREAS OF EXPERTISE:

• Test Data Privacy - Using the Data Privacy/Masking/Subsetting Tools (Mainframe, Distributed and Cloud)
• Mainframe Business applications development and maintenance.
• FIS / Instamatics software
• Duck Creek, Claims
• TOSCA Test Automation

AREAS OF EXPERTISE:

Experience and Skills: Delivering Test Data Privavcy Solutions MVS JCL/JES, DB2, VSAM, CICS,ORACLE 11 &12, IMS, RDBMS(Sybase, MS SQL Server 2008 & 2012, Oracle, Sybase, DB2 UDB) Python,COBOL / COBOL II, Easytrieve, SQL, C, C++, JAVA

Compuware Tools: (File-AID/RDX, File-AID/EX, File-AID/Data Solution, File-AID/MVS, Topaz Workbench), TDM Workbench, File-Aid EX, File-AID/RDX, Data Solution, IBM Optim, CA Data Maker, Delphix and Informatica PowerCentre, Informatica Test Data Manager, TOSCA Tricentis, XPEDITER, ABEND-AID, SAS, FTP, ENDEVOR, SYNCHSORT, ICETOOL,ChangeMan, INFOMAN, TSO/ISPF, SPUFI, CA-7, BMC, Revolve, Mainframe Express, INTERTEST, PWB, Oracle SQL Developer, SQL Management Studio, Putty, Toad

ETL: Datastage 7.5.2/8.0.1/8.7 (Enterprise Edition / Server), Microsoft Office .including Word, Excel, Microsoft Project, Visio

CHRONOLOGY OF EXPERIENCE

Confidential

Test Data Privacy Architect/Lead

Environment: Distributed, Cloud (Microsoft Azure) and Duck creek

Methodology: Waterfall

Distributed Tools: Relational DBMS (SQL 2016, 2012, 2008), SQL management Studio

TDM Tools: Delphix TDM v 5.3.7.0, TDM Central

Responsibilities:

• Analyze business requirements, work closely with project team members, technical leads and business partners to arrive at an optimal solution design.
• Conduct feasibility analysis.
• Develop test data management strategies and plans to provide optimum, reusable and secured test data solution.
• Perform proof of concept (POCs) on agreed approach and provide presentations to key stakeholders.
• Implement various TDM Services such as Data Identification, Data Profiling & Provisioning, Data Mining, Test Data Generation & Data Subsetting etc.
• Define Test Data Management process for the initial implementation as well as ongoing support.
• Lead Test data management team throughout all phases of the test data management, including planning, design, development, provisioning and maintenance of data.
• Provide consulting support to identify test data required to test specific business scenarios.
• Coordinate with application DBAs to copy data from one environment to another while protecting customer sensitive information.
• Validate test data and provide test data related consulting support to customers.
• Create reusable mechanism to automate test data delivery and minimize manual intervention.
• Proactively Identify project issues and risks. Create mitigation plans and review with concerned stakeholders.
• Participates in weekly status meeting with key stakeholders and share the progress reports and identified issues/risk and mitigation plan.
• Work with client and handle all Resource changes communication.
• As a Test Lead responsible for Automation of the Application.
• Understanding and gathering Requirement Specification.
• Co-ordinating with Offshore and Onshore Testing team.
• Planning and Grooming the User stories for Testing Team.
• Scripting, customizing and executing the Test Cases in Gherkin Format.
• Co-ordinating with Product Owner for requirements and backlog plaining.
• Attending all the scrum meetings, retro meetings and agile ceremonies.
• Reporting status to Client and CG higher management.

Confidential, Mt Laurel, NJ

Test Data Privacy Architect/Solution Consultant/Data Mining Consultant/Test Automation Consultant

Environment: Mainframe, Distributed and Cloud

Methodology:Agile\Waterfall

Mainframe\Distributed Tools:

Mainframe: COBOL, JCL, CICS, VSAM, Easytrieve, CA-7, VSAM/Sequential files/DB2/IMS, File-Aid/RDX, File- Aid/MVS, File-Aid/Data Solutions

Distributed: Relational DBMS (Oracle 11g&12g, SQL 2016, 2012, 2008, DB2 UDB, Sybase), Pervasive, SQLDataMart, Cloud, Delimited Files, Oracle SQL Developer, SQL management Studio, SQLPLUSPutty, TOAD

TDM Tools: Delphix TDM, CA TDM v4.7 (CA Test Data Manager, FastDataMasker, GT DatamakerAgileDesigner), Compuware TDM v16.3.3 (File-AID/EX, Topaz Workbench, Data Solution, File- AID/RDX), Informatica TDM v10.1.0 (Informatica Test Data Manager, Informatica Power Centre)

Test Automation: TOSCA Tricentis

Responsibilities:

• Design, Develop and ensure Implementation of Test Data Management Solution various TDP Tools(CA TDM, Delphix, Compuware) on Mainframe(Sequential Files\VSAM Files, DB2,IMS) and Distributed(Oracle, MS SQL Server,Sybase,DB2UDB, Data Marts, Cloud, CSV Files, XML Files, tab delimited Files) platform.
• Demonstrate use of Test Data Privacy Products required for solution on Mainframe\Distributed\Cloud Platforms.
• Conducted Proof of concept for Delphix TDM for Insurance & Banking domain that included deployment of Delphix, designing profiler & masking algorithms & strategies for applications on mainframe & distributed platforms.
• Building Strategy\Cycle Schedule to extract data, mask PII data and refresh\load non prod environments with masked data.
• Engage in discussions with Project Delivery Leads, Project Architects to help them prepare required solution artifacts i.e., ABP (Architecture Blueprint), NFRW (Non-Functional Requirements Worksheets), PID, IBOM and develop a solution that integrates seamlessly with existing tools and process and is in accordance with established practices.
• Engage in discussions with TRMIS (Technology Risk Management and Information Security) to prepare various Security compliance artifacts i.e. ADAM (Application Database and Middleware Intake Worksheet), CDSA (Control Design Assessment)
• Engage in discussions with Business Analyst to help him prepare BRD (Business Requirement Document), SDS(System Design Specification) and SRS(System Requirement Specification)
• Engage in design, implementation, troubleshooting of Firewall and other Confidential Network Access Rules
• Engage in setting up and maintaining profile\access for the team on Oracle Server\SQL Server\DB2 UDB\Windows Server\Unix\Compuware tools.
• Crafting of Statement of Work to include
• Requirements to meet Confidential Test Data Privacy needs
• Scope of projects, design and necessary resource requirements
• Development of pricing & timing of engagements
• Project plan development & Weekly status reporting to client
• Oversee the development of the required Delivery Documents.
• Development of Project Plan to include
• Migration of Test Data Privacy Tools from older versions to 16.03 Version on Mainframe and retrofitting effort on existing applications.
• Installation of Test Data Privacy Tools 16.03 version on Distributed Platform.
• Build and Deployment of SQL Server on Cloud and subsequent Rules\Job Repository set up on Cloud.
• Build and Deployment of Application Server and subsequent Execution Server, File-AID Services, Topaz Workbench
• Validation of All Test Data Privacy Tools on Mainframe\Distributed\Cloud Platform
• Build Implementation Plan for Endevor Migration of existing Data Privacy Fictionalization\Subset Jobs by identifying various possible components and customize them as per existing endeavor standards in Confidential .
• Analyzed Existing Data Privacy Fictionalization\Subset Jobs to identify dependencies and worked with Schedule Team to set up CA-7 Schedule.
• Build design and implementation plan for setting up Dev and Prod Environments\Repositories for Data Privacy Jobs on mainframe and distributed environments.
• Worked with various stakeholders to develop mechanism to onboard Production data into Landing Zone, Fictionalize it and off board it back to application's lower environment.
• Build & Monitored adherence to project plan, track schedule and effort variances and issue ageing, provided status to senior management, stake holders periodically through progress cards, project dashboards, Risk dashboards.
• Participate in Sprint Planning, creation of user stories, tasks, update backlog, task assignment.
• Worked with various teams to develop schedules to refresh and synchronize their lower environments with fictionalized\Subset copy of data for their testing & environment sizing need.
• Represented Test Data Management Team at various Program Level & Status meetings across the Confidential Bank.
• Analyzed schedule and implemented preventive and corrective actions to bring variance under Control, introduced Defect Prediction Models to prevent defects.
• Ensured Project Repository andknowledge base is maintained for future references and reviewed the product help documents.
• Delivered and implemented all the projects as per the schedule.
• Designed Profiler, Masking Algorithms using various TDP Tools(Delphix, CA & Compuware),
• Analyzed business and technical requirements and issues, and provide software solutions accordingly.
• Implemented Lochbridge's Best Practices (Analysis, Design, Develop, Deliver).
• Implemented Test Data Privacy Methodology.
• Generated Selection Criterion Rules and developed Data Privacy Disguise Rules.
• Designed and developed Pre-Process look-up tables.
• Created Project Plan for Tool migration.
• Retrofitted existing Jobs on Mainframe and Distributed platforms, documented process.
• Applied coding enhancements, analysis, and design toexisting systems.
• Completed Regression test cases for Development and Production Environments.
• Estimating, Resourcing and progress/status reporting.
• Defect Resolution and enhancement management.
• Troubleshooting Batch Cycle problems.
• Managed work distribution.
• Prepared and delivered presentations to team and management on project progress.
• Extensive interaction with Users and SMEs (Subject Matter Experts).
• Developed COBOL and Easytrieve Programs
• Generated Audit Reports.
• Work on Strategy to build right size copy of Fictionalized\Subset copy of data for different applications across mainframe and distributed platform.
• Design Subset Strategy to build master list of accounts from various mainframe\distributed applications selecting nth record and other data conditions per application.
• Write SORT\ICETOOL\Easytrieve Utility Jobs to extract accounts

Confidential, Charlotte, NC

Test Data Privacy Architect/Solution Consultant

Environment: Mainframe, Distributed and Cloud

Methodology:Agile\Waterfall

Mainframe\Distributed Tools:

Mainframe: COBOL, JCL, CICS, VSAM, Easytrieve, CA-7, VSAM/Sequential files/DB2/IMS, File- Aid/MVS, File-Aid/Data Solutions

Distributed: IBM Optim, IBM InfoSphere, Relational DBMS (Oracle 11g&12g, SQL 2012&2008, DB2 UDB, Sybase), PervasiveSQL, DataMart, Cloud, Delimited Files, Oracle SQL Developer, SQL management StudioSQLPLUS, Putty, TOAD

Responsibilities:

• Architect, Develop and implement a Data Management solution using Data Management tool sets and custom development so that the Data Management solution that will span SaaS, private cloud, public cloud and heritage Platforms
• Build an architecture and develop a solution that will be able to take care of prebuilt integrations and auto field mapping and auto association at Database level
• Create the Data management solutions in a way that they will have ease of use for Manulife with minimal learning path while incorporating an enterprise centric view of disparate data sources, wherein each data source has a clearly identified data cycle that is conformant to compliance and security constraints in all deployment scenarios for all LOB's in scope for the Data management solution build
• Create detailed design Architecture, Data Model for Solution Development and design, develop, and unit test the Data Management solution in accordance with established standards.
• Ensure the developed Data management solution will handle data in VSAM files, Relational DB systems in Client including Oracle, MS SQL Server, Sybase, Hadoop & DB2 while having integrations with Jenkins/ CARA/ Client ALM
• Understand the current process in place and execution of standard masking techniques across the applications and projects
• Gathering data masking and subsetting requirements from application SMEs and testing SMEs
• Develop and implement automation of the data masking processes

Confidential, Malvern, PA

Test Data Management Consultant\Mainframe Technical Lead\Senior Developer

Environment: IBM mainframe, IBM DataStage WebSphere

Tools: IBM Optim, IBM InfoSphere, Mainframe Express, Endeavor, DEBUGGER, SPUFI, PWB, RMS, TSO, ISPF and FILE-AID, Casual Analysis, CA-7 SCHEDULER, JCLSYNC, FreezeFrame, BMC, Optim

Methodology:Agile\Waterfall

Responsibilities:

• Analysis of the requirement(information) provided by the client in the form of BRS and prepare requirement review document.
• Interaction with Client\Onsite Team in Requirement gathering.
• PrepareHighLevelDesign - HLDspecifying the business requirements, impact on the existing system, impacted components and approach to implement the new changes.
• Prepare Low Level Design - LLD (Technical Specs) from high level design.
• Participate in Sprint Planning, creation of user stories, tasks, update backlog, task assignment.
• Distribution of work among team members and tracking of deliverables
• Defect and enhancement management
• Implemented Test Data Privacy Methodology.
• Generated Selection Criterion Rules and developed Data Privacy Disguise Rules.
• Designed and developed Pre-Process look-up tables.
• Develop Extract, Load Jobs for Subsetting
• Troubleshooting Production\Test Batch Cycle problems
• Developnew and change existingCOBOL-DB2, COBOL-CICS programsand stored procedures
• Performance tune existing COBOL-DB2 applications using FreezeFrame/BMCTool.
• Develop new and change existingJobs for Production\Test Regions.
• Develop and maintain new \existing ETL Jobs
• PrepareTest PlanforUnit and System Testing.
• Responsible for carrying out Unit and System Testing.
• Responsible forRoot-cause analysis for the defectsoccurring in the application and providing permanent fix to these defects.
• Responsible for doing technical and functional review of new and existing programs and Jobs written by project members.
• Responsible for helping technically and functionally project members in on-time delivery of work packets.
• Conducted various trainings onCOBOL, DB2andJCLfor new team members in the project.