SUMMARY:

• 12+ years of extensive experience in IT with strong emphasis on analysis, design, development, maintenance, test and production Support with strong leadership and relationship building skills.
• Relevant experience of 4+ years in test data management (IBM optim) and other Mainframe technologies involved with TDM. Expertise in IBM Optim data masking solution for mainframe and distributed system
• Experience in business application development in various mainframe technologies COBOL - DB2, JCL, VSAM, SAS, REXX, Assembler.
• Expertise in the Mainframe tools like TSO, ISPF, TWS, File manager, SPUFI and RPF (Roscoe Programming File)
• Strong knowledge in creating JCL and JCL PROCs using various JCL utilities, DB2 load/unload utility and so on.
• Extensive experience in development, unit, regression and integration testing, defect troubleshooting, deployment, production support and maintenance.
• Worked on building Java plugins on IDZ. This involves invoking Java API classes to connect to mainframe and read files and REXX output
• Expertise on test automation through UFT tool - Web API and Bluezone Mainframe applications
• Knowledgeable on Selenium, Ruby on Rails, UI Path (RPA)
• Worked on requirements gathering, creating High Level Design, Detailed Design and Functional Requirement documents.
• Provide end-to-end testing support for time and business critical projects by leading test strategy, plan, execution, reporting,documentation, and environment management.
• Onsite customer coordination, business team interactions and managing release process.
• Lead application development, testing and support offering expertise in managing high revenue, mission-critical projects, overseeing teams and projects development.
• Project and People management experience includes all aspects of resource development, management, evaluation and appraisal, IT governance and team motivation.
• Have worked on project planning, recruitment/interviews, budgeting and revenue forecast.
• Worked on driving the proposals with the Sales/pre-sales team for RFP and proactive initiatives.

TECHNICAL SKILLS:

Tools: AQT, IBM Optim,IBM Debugger, SPUFI, Toad, Teradata Assist, SOAPUI, UFT, DocuSign, FileNet, Selenium, UI Path, DBeaver

Databases: DB2, SQL Server, Oracle, Teradata, MS Access, PostgreSQL

Languages: JCL, SQL. Lua COBOL, SAS, REXX, XML, VBScript, Java, Ruby VB, Assembler

PROFESSIONAL EXPERIENCE:

Compunnel, Cincinnati, OH

Senior Consultant

Responsibilities:

• Build a roadmap for test data management and define a strategy for creating obfuscation logic for data across different applications. This involves coordination with stakeholders across application teams to understand and build solutions..
• Using data discovery tool, identify PII fields, document and review the report with SMEs before starting with the design and development.
• Build data obfuscation flow, develop obfuscation logic using IBM optim and Lua, REXX, SAS . This involves defining the tables, Access Definitions, Table Map, Column Map, look-up tables and creation of procedures with Obfuscation code.
• Develop power shell scripts for distributed system applications which use databases like PostgreSQL, SQL server, Oracle.
• Develop JCL Procs and Jobs for mainframe and DB2 applications data obfuscation. The JCL involves modules for pre-processing, Extract, convert, Load, DB2 load/Unload and post-processing (clean-ups, Abends, Checkpointing and so on)
• Monitor and support production implementation as well as production support for complete obfuscation batch cycle.
• Perform Fit-for-Purpose testing and validate the test results
• Prepare comprehensive documentation of the job flow, obfuscation logic, testing artifacts and so on.
• Perform/Load data refresh (DB2 load and unload) for table and create VSAM files for mainframe applicationsApplication testing and support: This is core application for a bank, which provides transaction processing functionalities, origination of customer and accounts, flow of data across different applications and authorizations.
• Test Automation Ambassador: Build automation for API (XML interface) and mainframe 3270 screens. The scripts are built in UFT and Excel Macro (VBA with BHAO).
• IDZ java plugin development - Convert the Roscoe code to java plugins. The development is done in java, REXX and interfaced in GitHub.
• Test Environment Management: There are around 12+ production like test environments. This requires building JCL, configuring the test regions and bringing it up. Refresh the files with the latest obfuscated data (series of jobs).
• Manage a mailbox for test environment issues, support requests
• Provide support for the end to end testing with day plan execution and assist business with the
• Lead team in planning, design, and execution for the projects
• Create a test plan and scripts for the test execution.
• Coordination and reporting and drive projects progress between offshore and onshore
• Allocation and management of team, create estimation and monitor/report the progress
• Define the strategy, estimation and scope for testing and prioritize the execution for successful of the project objective.
• Work on team building, appraisal, resource development, team collaboration activities at organization level while working in SLK.

Confidential

Manager

Responsibilities:

• Build the project and test plan which involves timelines, resource loading, scope and phases and work with stakeholders for approval.
• Derive effort estimates for CRs and define the project timelines with available resources
• Drive the project testing activities - Create and review the test plan with SMEs, track the project process and traceability matrices and generate the daily reports, engage application support and drive end to end testing. Organize and coordinate resources, environment, data set-up for BAT/UAT.
• Environment management - Ensure sub-system connectivity across different test environments
• Support team on technical and functional aspects - This involves requirement and technical specs understanding, review the test scenarios and understanding of the team, help team with the SQL and application flow and so on.
• Drive daily stand-ups, retrospective meetings, test result presentations and sign-off
• Drive the initiative for automation and process improvement
• Work on new proposals and project opportunities
• Work on team building, appraisal, resource development, team collaboration activities at organization level.

Confidential, Columbus, OH

Senior Consultant

Responsibilities:

• Develop master test strategy for project testing covering all the agile teams
• Create test scenarios for system, regression, performance, and end -to -end testing.Enhanced the end-to-end testing process which resulted in detailed coverage, clarity of tasks and timely completion or road-blocks visibility.
• Develop excel macros for various testing tasks. Build a solution to validate a large XML file in project flow which was a challenging task manually.
• Worked on test automation initiative ruby
• Perform testing for different applications as part of end- to - end testing which involved database, data mart, SOA web-services, DocuSign, Filenet, web applications verification.
• Provide support for UAT through working with business team for test scenarios and set-up required test data
• Defect reporting and drive defect review meetings
• Post implementation validation
• As part of project Troika group review/discuss project requirements, design approach, architecture, database T2S
• Collaboration among various groups and stakeholders for successful project execution

Confidential, Cincinnati, OH

Lead

Responsibilities:

• Build a roadmap for test data management and define a strategy for creating obfuscation logic for the mainframe application.
• Create artifacts for fields from the copybook identified as PII and to be obfuscated. This involved 50+ files.
• Build data obfuscation flow, develop obfuscation logic using IBM optim and Lua, REXX . This involves defining the tables, Access Definitions, Table Map, Column Map, look-up tables and creation of procedures with Obfuscation code.
• Develop JCL Procs and Jobs.The JCL involves modules for pre-processing, Extract, convert, Load, DB2 load/Unload and post-processing (clean-ups, Abends, Checkpointing and so on)
• Build the mainframe jobs to copy the obfuscated files to VSAM to be used by application.
• Perform full scale testing for the obfuscated data in combination with applications to validate data sync. This required building DFSORT and other utility programs to validate millions of recordsTest Automation and application testing:
• Worked directly with the business partners to establish problem specifications and system designs.
• Develop test plan, strategy and measuring and monitoring project variables (effort, scope etc) against the plan
• Performed regression and system-level testing to verify software quality and function before it was released.
• Lead ETL testing projects which involves verification of data warehouse, data mart and BO reports.
• Worked on mainframe online and batch testing which involves creating JCLs for multiple tasks and testing in the mainframe online applications.
• Automation using Unified Functional Tool, VBA macro.
• Drive defect review board meetings
• Collaboration among various groups and stakeholders for successful project execution
• Led offshore team in test case execution and creation of test artifacts
• Present comprehensive reports to document bugs and project closure

Confidential, Cincinnati, OH

Senior Software Engineer

Responsibilities:

• Worked as Technical Lead for application development in mainframe Assembler, COBOL-DB2.
• Lead offshore team in the design, and development, code review and technical support.
• Support the daily process written in REXX and VB
• Worked on the IRIS tool for managing project documents.
• Worked on problem tickets/incidents Deployment and post implementation support

Confidential, Cincinnati, OH

Senior Software Engineer

Responsibilities:

• Requirement analysis, understanding of the business requirement and mapping the changes with system impact.
• Test mailbox support - JCL job for refresh, DB2 bind, update test region Jobs - configuration, load.
• Application development in Cobol-DB2, COBOL to Assembler code conversion
• BatchTesting: Create and run JCL; build input files including GDG, VSAM; execute the jobs and verify the results for all scenarios.
• Online Testing: Bring up the test online region with test VSAM clusters, test 3270function and web-based XML services.
• ETL/DW testing: Write simple to complex SQLqueries to extract data from database for testing,validate database after batch processing to verify the end to end dataflow.Create/modify data in database for test scenarios.
• Testing of data warehouse: verify the implemented ETL code against the corresponding mapping document.
• Testing of the reports: verify data in the business object reports by querying the database.
• Data mart testing: verify data loaded in the mart against the mapping documents.
• Led team in development of tools - programs and RPF for online system reports and on-demand data extraction reports for