SUMMARY

• IT Professional with extensive knowledge of working as a Software Developer with over 7+ years of experience in end - to-end implementation and transformation projects. Used skill sets like JavaScript, Java, COBOL, JCL, ENDEVOR (for change management), JOBTRAC (for scheduling), DB2-SQL (for data processing) in my capacity as a Senior Developer & Technical test lead for application development and enhancements of legacy system. Working with stakeholders and teams from diverse geographies across the globe and involvement in project planning, project delivery, and customer management has made me analytically proficient, resilient at workplace and result oriented.
• Test Data Management specialist (Test Data extract, load support) for PolicyCenter conversion project with Data mapping experience between Legacy & PC Guidewire.
• Very good working knowledge on Data mapping between Source-Target databases during two conversion projects (DB2-SQL Server & Legacy-Guidewire), data masking projects & any new development projects to communicate between downstream & upstream applications.
• Ability to perform complex analysis of user requirements to produce specifications for the creation of new software products for viable cross-systems support, or for the enhancement of multiple systems.
• Extensive experience in analyzing and documenting business requirements and system functional specifications including use cases.
• Excellent knowledge in the analysis, design, and re-engineering of system applications and business processes, using established system analysis, business and system process design, research, and implementation methodologies, placement of business controls, diagramming data and process mapping, applying in Unified Modeling Language (UML), and the implementation of performance measures.
• Worked with business team and project teams in preparing Software requirement specifications (SRS), software design documents (SDD), user interface design
• Familiar with SQL scripting from data analysis perspective.
• Experience in process modeling using Use Cases, Sequence Diagrams/Process Flow Diagram, Collaboration diagrams, Activity Diagrams and Class Diagrams.
• Excellent verbal/written communication skills and can perform well both independently and as a team player. Adept in written correspondence, reports, implementation requirements, project status reports, verbal presentations with PowerPoint, e-mails etc.
• Understanding of various software development methodologies like Software Development Life Cycle (SDLC), Waterfall and Agile Software development.
• Development and management of detailed project plans to include, resources, tasks, requirements, milestones, and review points.
• Managed complex business initiatives to balance requirements for functionality, efficiency and quality.
• Experience in creating, reading and comprehending process-level and system-level documents including Functional Specifications, Project Scoping, Project Planning and Gap Analysis.
• Knowledge about Traceability Matrices and mapping between functional requirements and test cases.
• Experience in providing end user training as well as training the team on using new technologies.

TECHNICAL SKILLS

Hardware/Platforms: z/OS, Windows, TSO, MVS, AS400

Process: Application Management, Change Management, Quality, Problem Management, Test Data Management, Quality Assurance

Languages: COBOL, JCL, REXX, SQL, CICS, C, HTML (Front-End), PERL, UNIX Shell Scripting

Databases: DB2, VSAM, SQL Server

Version Control & Schedulers: Endevor, Jobtrac

Other Interface, Tools and Utilities: Guidewire PolicyCenter V9.0, SoapUIFileAid, FileManager, Spufi, DFSORT, Syncsort, OptimIBM Utilities-IDCAMS, IEBGENER, IEBCOPY, IEFBR14, MQSeries, ISC Messages, TSO/ISPF, CICSLISA/DevTest

Office Tools: Lotus Notes / Outlook, MS Word, MS Excel, MS Power point, MS test manager, MS Teams, Visual Studio 2012, Jira

PROFESSIONAL EXPERIENCE

Confidential

Technical Test Lead (Mainframe)

Responsibilities:

• Conduct Requirement analysis and find requirement gaps, clarify gaps with Advance auto part’s business analyst, QA leads
• Communicate requirements to Infosys offshore test analysts and leads.
• Lead and represent all QA activities for the project, such as test estimation & planning, execution schedule and deliver the same to Advance Auto Parts’ Project Manager
• Build detailed test strategy and test plan. Review with Advance Auto parts with test managers and Infosys test manager.
• Coordinate and review all test scripting activities and validate scenarios, test cases created by Infosys Offshore test team.
• Coordinate all test execution activities and execute critical test cases.
• Create and manage test data for the project.
• Support Infosys test manager and Advance Auto part test manager for test reporting and metrics management
• Represent QA team in project defect management meetings, ensure defects are correctly logged and retested and closed.
• Review test results created by offshore team.
• Involvement in User Acceptance Testing, stakeholders interfacing, Test Closure and Sign off.
• CBR Actions - ATI (Automated Transfer Invoice) validation, expanded PO processing, validate e-invoice and prepare accounting journals for stakeholders.

Confidential

Test Data Management Specialist (Mainframe)

Responsibilities:

• Interacted with clients (multiple systems inside Nationwide) to gather & analyze business requirements for their data needs with respect to business case scenarios for the release.
• Provided effort estimation for the data requests based on the complexity level and various steps involved in the TDM process (Data Identification, Extraction, Data loading, Regression Bed maintenance).
• Created synthetic test data using DevTest (LISA) software for the E2E Policy admin system for Nationwide's front-end Sales Portal. This involves collection of customer data on 'Policy Quote' page, validating the risk using MVR, Lexis Nexis, Credit etc., sending the Quote to Underwriter for evaluation if needed, Policy Submission, Policy Renewal & Cancellation etc.
• Create Data mapping between Guidewire PC and existing Legacy applications such as Policy systems, Billing Systems & Customer database (ECIF) in various databases and write detailed requirements for mapping.
• Review Product model/specification document of various products (Personal Lines, Commercial Lines) when ever needed to understand the various coverage, coverage terms, State specific rules etc. to come up with detailed data need requirements.
• Work with Integration data teams (LexisNexis, MVR, GIS, Acxiom (Prefill), CLUE Auto (Auto Loss) & Transunion) to understand the data resides in external applications.
• Data identification by writing Cobol-DB2 programs or DB2 queries in JCLs based on the Source Database and complexity of the requirement. Data migration are accomplished using IBM OPTIM, IBM File Manager and homegrown tools. Data resides in various databases like DB2 tables, VSAM files and IMS.
• Developed complex SQLs, JCL steps and provided efficient solutions which meets the Data requirements of the requestor. Provided various cost savings solutions for the existing data identification approaches and saved time & CPU cost for many projects.
• Maintained multiple Regression test beds for various databases and keep updating the regression test beds based on each release schedule. Also performed Aging techniques on regression backups & performed Regression restore activities after monthly release.
• Participated in daily and weekly status meetings to keep track of the project health and prioritize the requirements from Customers.
• Designed and developed (or enhance) TDM tools to perform day to day activities.
• Conducted knowledge transfer, reviews and Quality checks on the deliverables done by other TDM specialists.
• Some of the best practices followed in TDM team:
• Provided repeatable and recoverable test data for the similar data requests
• Automated the existing manual process of Data Identification.
• Reduced the amount of time wasted on false problems generated by bad test data
• Ensured the fastest possible test execution which results in Cost savings & timely delivery

Confidential

Test Data Management Specialist (Mainframe)

Responsibilities:

• Interacted with clients (multiple systems inside Nationwide) to gather & analyze business requirements for their data needs with respect to business case scenarios for the release.
• Provided effort estimation for the data requests based on the complexity level and various steps involved in the TDM process (Data Identification, Extraction, Data loading, Regression Bed maintenance).
• Create Data mapping between Guidewire PC and existing Legacy applications such as Policy systems, Billing Systems & Customer database (ECIF) in various databases and write detailed requirements for mapping.
• Review Product model/specification document of various products (Personal Lines, Commercial Lines) when ever needed to understand the various coverage, coverage terms, State specific rules etc. to come up with detailed data need requirements.
• Work with Integration data teams (LexisNexis, MVR, GIS, Acxiom (Prefill), CLUE Auto (Auto Loss) & Transunion) to understand the data resides in external applications.
• Data identification by writing Cobol-DB2 programs or DB2 queries in JCLs based on the Source Database and complexity of the requirement. Data migration are accomplished using IBM OPTIM, IBM File Manager and homegrown tools. Data resides in various databases like DB2 tables, VSAM files and IMS.
• Developed complex SQLs, JCL steps and provided efficient solutions which meets the Data requirements of the requestor. Provided various cost savings solutions for the existing data identification approaches and saved time & CPU cost for many projects.
• Maintained multiple Regression test beds for various databases and keep updating the regression test beds based on each release schedule. Also performed Aging techniques on regression backups & performed Regression restore activities after monthly release.
• Participated in daily and weekly status meetings to keep track of the project health and prioritize the requirements from Customers.
• Designed and developed (or enhance) TDM tools to perform day to day activities.
• Conducted knowledge transfer, reviews and Quality checks on the deliverables done by other TDM specialists.
• Some of the best practices followed in TDM team:
• Provided repeatable and recoverable test data for the similar data requests
• Automated the existing manual process of Data Identification.
• Reduced the amount of time wasted on false problems generated by bad test data
• Ensured the fastest possible test execution which results in Cost savings & timely delivery