We provide IT Staff Augmentation Services!

Tdm Solutions Architect & Lead Resume

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.

Hire Now