PROFESSIONAL SUMMARY:

• Over 11 years of experience in Information technology wif hands on experience in multiple technologies across various Business domains.
• Experienced professional wif understanding of Information Life cycle including Data Analysis, Database Design, Data Mapping, data transformations and Data Load.
• More TEMPthan 6 years of development experience, wif strong expertise in implementing Data Growth and Data masking solutions using IBM Optim.
• Over 3 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 and
• Exposure to various COTS TDM tools like Informatica, CA Gridtools, Delphix
• Always exhibited ability to learn new technologies and domains quickly and adapt to changing requirements.
• Good communication, interpersonal skills and team player wif demonstrated collaborative working relationships.
• ed 5 Star team in 2017 at HCSC on TDM enablement and support
• Created excel based profiling tool dat connects to DB automatically and performs metadata profiling.
• f appreciation from Discover for significant contribution to Project Optimus - Transforming to world class QA. f appreciation from MetLife for key role and performance in enterprise level data masking.
• Personal letter of appreciation from president of US business, MetLife for commitment and critical project deliveries.
• “STAR” from Infosys for contribution to teh “MetLife Annuity Host maintenance project”.
• Created and executed a proposal for business reports automation dat 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 Confidential .

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 and C++

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, Richardson TX

TDM Solutions Architect & lead

Responsibilities:

• Responsible for devising test data management strategy for applications categorized in portfolios
• TEMPHas been involved in creating an approach on data profiling and masking for over 250 applications
• Development team lead wif 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 teh 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, Riverwoods IL

Test Data Management Lead

Responsibilities:

• Responsible for devising test data management strategy for eWallet flagship programs in Discover
• TEMPHas been single point of contact for all teh 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 teh data needs.
• Develop data sub-setting criteria and configure using in house tools.
• Constantly working wif tools team to enhance teh 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 dat is used for development testing
• Understanding existing TDM maturity of teh organization.
• Devise a strategy to fill teh gaps and mitigate TDM challenges.
• Assessment of TDM tools in teh 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, Somerset NJ

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 teh custom user exits created for MetLife specific requirements
• Responsible for any changes to teh User exits or creating new exits

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

Confidential, Hartford CT

Business System Analyst

Responsibilities:

• Implement business change requests wif MetLife products and plans.
• Problem discussion wif 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 teh development team.
• Preparation of functional requirement document for teh QA team to test teh fix.
• Review teh QA test results and co-ordinate wif business for Signoff.
• Creating SOX docs and production release co-ordination wif 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.

Confidential

System Analyst

Responsibilities:

• Implement enhancements, maintenance and support of Long Term health Care products.
• Responsible for new business enrollment, billing, payment applications development
• Involved in requirements gathering, impact analysis, design, test planning and unit testing
• Involved in re architecture of critical claims system where one of my two suggested data base models was selected and implemented for application re architecture.
• Created complete database model for Claims LOB using Erwin studio

Tools: /Technology Used: AS400, COBOL/400, DB2/400, Erwin Data Modeler.

Confidential

Senior Programmer/Software Engineer

Responsibilities:

• Responsible for maintenance of legacy annuity system wif no issues.
• Involved in resolving bugs, data fixes and live abends in production
• Requirements analysis, design, coding and unit testing and Implementing minor enhancements
• Responsible for thorough root cause analysis and impact analysis.
• Creating business reports using Focus/Eztrieve reporting languages.
• Responsible for designing and execution of ETL process using IBM Optim for data refreshed to lower environments for analysis
• Regression testing in lower environments before production release.
• Production release support.
• Application data archival using IBM Optim.

Tools: /Technology Used: COBOL, JCL, DB2, IMS DB/DC, IBM OPTIM, CLIST, REXX, FOCUS, Eztreive, SQL, FILEAID, CHANGEMAN, OPC.

Confidential

Programmer/Software Engineer

Responsibilities:

• Responsible for maintenance of application storing customer statements on Calligo system
• Involved in minor and major enhancements to backend applications accessed by web applications
• Responsible for restructure of application, performance improvement and addition of new functionalities to E Pub suite
• Requirements analysis, design, coding and unit testing, Integration testing and Implementation