SUMMARY

• Over 12 years of experience in Information technology with hands on experience in multiple technologies across various Business domains.
• Experienced professional with understanding of Information Life cycle including Data Analysis, Database Design, Data Mapping, data transformations and Data Load.
• More than 7 years of development experience, with strong expertise in implementing Data Growth and Data masking solutions using IBM Optim.
• Over 4 years of experience as TDM architect involved in assessments, tool fitment analysis, devising strategies and providing solutions on test data challenges
• Possess a very strong technical foundation in programming and scripting. Over 9 years of experience as programmer - mainframe applications.
• Good understanding in databases such as Oracle, SQL server, DB2 z/OS, DB2 LUW, Teradata, Data Lake.
• Expertise in analytical and problem-solving skills
• Exposure to various COTS TDM tools like Informatica, CA Gridtools, Delphix
• Active personnel of TDM Center of Excellence’s technical recruiting committee
• Always exhibited ability to learn new technologies and domains quickly and adapt to changing requirements.
• Good communication, interpersonal skills and team player with demonstrated collaborative working relationships.
• Part of team Awarded 5 Star team in 2017 at HCSC on TDM enablement and support
• Created excel based profiling tool that connects to DB automatically and performs metadata profiling.
• Certificate of appreciation from Discover for significant contribution to Project Optimus - Transforming to world class QA.
• Certificate of appreciation from MetLife for key role and performance in enterprise level data masking.
• Worked on multiple assessments and tool evaluation proposals
• Personal letter of appreciation from president of US business, MetLife for commitment and critical project deliveries.
• “STAR” award from Infosys for contribution to the “MetLife Annuity Host maintenance project”.
• Created and executed a proposal for business reports automation that potentially reduces effort of technical team by enabling business analysts to generate reports on their own.
• Created an Erwin data model diagram of entire claims application and care system in LTC partners.
• Created a tool for business team to perform testing of oneshot transaction prior its execution in production. Prior to this automation, a request was made to problem management team for testing.
• Pursuing Harvard manage mentor courses and certifications online.
• LOMA 280 certified.

TECHNICAL SKILLS

Operating Systems: Windows, z/OS, UNIX, OS-400

Languages: COBOL, PL/I, JCL, SQL, FOCUS, EZTREIVE, AS400, CICS, IMS DC, CLIST, VBA, SQL, LUA, basics in C, C++, Python

Databases: DB2, IMS DB, SQL Server, Oracle, DB2-400,

Tools: IBM OPTIM 11.3, CHANGEMAN, XPEDITOR, TSO/ISPF, Endevor, FILEAID, REXX, OPC scheduler, Spufi, SQL developer, Squirrel, SQL assistant, QMF, CA TDM & Informatica ILM TDM,

PROFESSIONAL EXPERIENCE

Confidential

TDM Solutions Architect & lead

Responsibilities:

• Responsible for devising test data management strategy for applications categorized in portfolios
• Has been involved in creating an approach on data profiling and masking for over 250 applications
• Development team lead with ownership of data masking solution and rules customization per business needs
• ETL Configuration and Unit testing using IBM Optim
• Involved in requirements gathering and analysis of the data needs.
• Develop data sub-setting criteria and configuration using IBM Optim.
• Test environment refresh support on masking and data subsetting
• Responsible for setting up configuration management controls and processes
• Support to Actifio and Delphix virtualization POC
• Single TDM point of contact for two critical programs
• IBM optim administration activities such as installations, upgrades, PMR’s, backup and restoration processes

Tools: /Technology Used: IBM Optim 11.3, Delphix, Actifio, JCL, VBA, DFSORT, SQL scripting, LUA programming, SQL server, DB2 z/OS, DB2 LUW, VSAM, QSAM, XML, JSON files, SSMS, Squirrel and Teradata SQL assistant

Confidential

Test Data Management Lead

Responsibilities:

• Responsible for devising test data management strategy for eWallet flagship programs in Discover
• Has been single point of contact for all the data needs and requests
• He’s also responsible in managing test data for development and compliance testing environment.
• Involved in requirements gathering and analysis of the data needs.
• Develop data sub-setting criteria and configure using in house tools.
• Constantly working with tools team to enhance the ESQM tools and enable testers to self-service data mining.
• Create program and design specifications for applications in compliance testing environment
• Execute subseting and data masking scripts in test data bed that is used for development testing
• Understanding existing TDM maturity of the organization.
• Devise a strategy to fill the gaps and mitigate TDM challenges.
• Assessment of TDM tools in the market and their fitment in DFS environment.
• Put up a plan for POC and road map on solution implementation.

Tools: /Technology Used: COBOL, JCL, DB2, SQL, Oracle 11.2, SQL developer, OPC, Endevor, Spufi, QMF, ISPF, VSAM, Internal ESQM tools

Confidential

Data privacy Lead and Technology Analyst

Responsibilities:

• Involved in Project Kick off to multiple stakeholders
• Responsible for data profiling PII data in over 25 applications
• Involved in requirements gathering, Analysis, Design and execution
• Also involved in sunset of 20 applications
• Develop data masking solution and extract right sized data per requirements.
• Creating column maps, table maps, access definitions in IBM Optim
• ETL Configuration using IBM Optim
• Unit testing and QA/UAT support
• Solution deployment and transition to application owners.
• Was responsible for maintaining the custom user exits created for MetLife specific requirements
• Responsible for any changes to the User exits or creating new exits

Tools: /Technology Used: IBM Optim 7.2, COBOL, JCL, DB2, IMS DB, VSAM, QSAM, CLIST, CHANGEMAN

Confidential

Business System Analyst

Responsibilities:

• Implement business change requests with MetLife products and plans.
• Problem discussion with business analysts and requirements gathering.
• Implement critical enhancements, fix production issues,
• Thorough root cause analysis and impact analysis.
• Preparation of unit test plan and technical specification document for the development team.
• Preparation of functional requirement document for the QA team to test the fix.
• Review the QA test results and co-ordinate with business for Signoff.
• Creating SOX docs and production release co-ordination with support.
• Create compliance reports using reporting languages like FOCUS, Eztreive for business analysis.
• Involved in release management

Tools: /Technology Used: COBOL, JCL, DB2, IMS, Tbase, CLIST, REXX, FOCUS reporting, Eztreive, SQL.