Manager Data
Resume:
ANIL GOGINENI
*************@*******.***
609-***-****(Cell)
Note: Looking for Remote Positions Only
PROFESSIONAL SUMMARY:
Anil has 18 years of experience in Software Industry with 8 years of Quality Assurance and 10 years of Mainframe Development experience. Anil has extensive experience in developing Test Plans, Test Cases and Test Scripts. Anil has experience with Manual Testing and has strong experience with Test Director. Anil has been involved in Quality Assurance, System study, Analysis, Module design, Development, Testing and Implementation of Mainframe applications. Anil have expertise in Mainframe technologies COBOL, PL1, Assembler, FOCUS, TSO/ISPF, DB2, DB2 Stored procedures, IMS DB/DC, IDMS, MQ-Series, SAS, EasyTrieve, CICS, VSAM, QSAM, JCL, REXX and tools Xpediter, Endevor, ChangeMan, File-Aid, Sync-sort, TMON, MF-Revolve, Inter-Test, QMF, SPUFI, RC-Query, SAR, CA-7 Scheduler, CA11,Control-M, IDCAMS, CompareX, SuperCE and BMC Utilities. Apart from Mainframe technologies Anil also expertise in Oracle, PL/SQL, DB Triggers, UNIX, PERL, C, C++, J2EE, JAVA Script, Data-Ware Houses, Red Prairie WMS software and Transport Management system, Rational Tools, Rapid SQL. Performed full software life cycle development and have thorough knowledge in Quality procedures.
TECHNICAL PROFILE:
PROGRAMMING LANGUAGES : COBOL, PL1, Assembler, SAS, C, C++, JAVA, JAVA Script,
MQ Series, JCL, and DB2Stored procedures, Shell Scripting,
PL/SQL, VB Script, Spring Batch
OPERATING SYSTEMS : OS/390, GECOS, UNIX, MAC, Windows'95/98/NT, XP, DOS,
LINUX
DBMS : DB2, IMS DB, UDB, ORACLE, SYBASE, DM8, MS Access,
IDMS/DB
OLTP : CICS, CA-IDMS/DC
TOOLS : Mercury Tools(Quality Center, QTP, WinRunner, Load
Runner..etc), Rational Tools(Test Manager, Clear Quest,
Clear Case, Rational Rose)
UTILITIES : TSO/ISPF, ENDEVOR, ChangeMan, PVCS, FILE-AID, QMF,
VSAM, XPEDITER, INTER TEST, SYNCSORT, IDCAMS,
CompareX, SuperCE, CONNECT-DIRECT, FTP, SAR,
CA-7 Scheduler, CA11, Control-M, Job Tracks
HARDWARE : ES/9000, S/390, HBI Mainframe, RS/6000, MAC, and IBM- Compatible PC's, Thin Client
EDUCATION: B.Tech in Electronics & Communication Engineering from JNTU College of Engineering with First class.
SUMMARY OF PROJECTS:
INTEGRATED DATA RETRIEVAL SYSTEM (IDRS)
Client: Internal Revenue Service(IRS), LANHAM, MD
Duration: September 2018 to Till date
Environment : UNISYS, E300, ECL, IPF, COBOL, ECONS, SQuA, BLDTIF, AMDU, TSO/ISPF, Assembler(ALC), VSAM, JCL, FILE-AID, File-Manager, Control-M, SDSF, SYNCSORT, DB2, SPUFI, QMF, FTP, SuperCE, Control-D, ENDEVOR, RTC, Rational Functional Tester, Clear Quest, Rational Requisite Pro, XML, XML Spy, OCS/Skype for Business, Microsoft Office Outlook and MS-Office etc..
DESCRIPTION: Integrated Data Retrieval System(IDRS) is a major application supported on the Unisys AND IBM mainframes it manages data extracted from the corporate account data stores(BMF, EPMF, IMF and CADE) and stores IDRS database named as Taxpayer File Data Store( TIF). IT allows IRS employees to take specific actions on taxpayer account issues, track status and post transaction updates and back to the Master files. It interacts with different sub-systems like CAF, CAR, CCA, EACS, RAF, TDI, TDA, Transcripts, Collection systems, Criminal Investigation Systems..etc.
ROLE: Sr. Mainframe Analyst
Involved in IDRS modules Impact Analysis due to Tax year changes
Involved in identifying impacted Pre-WTU and Post WTU programs due to Tax year changes
Involved in modifying the ALC, COBOL IDRS programs
Involved in creating TIF records using BLD TIF utility and AMDU utility
Involved in testing the modified programs
Involved in WTU, Pre-WTU IDRS Assembler(ALC), COBOL modules testing
Involved in giving demo’s to the team about modified the changes and test results
Involved in creating the packages to promote to higher environments
Involved in modifying the command code programs
Heavily involved impact analysis, modifying and testing the Assembler and COBOL programs
ELECTROINC FRAUD DETENTION SYSTEM (EFDS)
Client: Internal Revenue Service(IRS), LANHAM, MD
Duration: September 2017 to Aug 2018
Environment : Visual C++, Informatica, Oracle 11g, XML Spy, Secure FX, TOAD, SQL Developer, PL/SQL, Linux, TSO/ISPF, Assembler, SAS, EasyTrieve, CICS, VSAM, JCL, FILE-AID, File-Manager, Control-M, SDSF, SYNCSORT, DB2, SPUFI, QMF, FTP, SuperCE, Control-D, ENDEVOR, RTC, Rational Functional Tester, Clear Quest, Rational Requisite Pro, XML, XML Spy, OCS/Skype for Business, Microsoft Office Outlook and MS-Office etc..
DESCRIPTION: The Electronic Fraud Detection System (EFDS) is a compliance system within the Enforcement Division, Compliance Domain that provides tools needed to perform pre-refund detection of potentially criminal fraudulent tax returns and civil fraud Earned Income Tax Credit (EITC) and other Examination issues. It is currently used primarily to examine electronically filed returns, but also provides limited support for all return filing modes. In addition, EFDS is used to track QRP/RPP schemes and support the Revenue Protection Strategy.
ROLE: Sr. Mainframe Analyst
Involved in Agile methodology
Involved in creating Automation frame work
Involved in modifying, Testing the Assembler(ALC), COBOL programs
Involved in creating the JCL’s and adding them to the Endevor
Involved in creating the test data
Creating the Endevor packages and moving modified programs to the higher environments
Implemented Tax Year changes to the existing ALC, COBOL modules
CADE2 AUTHORITATIVE DATA SOURCE (ADS) TRANSCRIPTS
Client: Internal Revenue Service (IRS), LANHAM, MD
Duration: March 2016 to August 2017
Environment : OS/390, Windows 7 Professional, TSO/ISPF, Assembler(ALC), SAS, EasyTrieve, CICS, VSAM, JCL, FILE-AID, File-Manager, Control-M, SDSF, SYNCSORT, DB2, SPUFI, QMF, FTP, SuperCE, Control-D, ENDEVOR, LINUX, Rational Tools(RTC, RRC, RQM…), J2EE, JAVA Script, Java Beans, EJB, JSP, JDBC, Spring Batch, Microsoft Office Outlook and MS-Office etc..
DESCRIPTION: Transition State 2 (TS2) Authoritative Data Source (ADS) Transcripts Project to establish CADE 2 as the authoritative data source for transcript processing to downstream systems like Microfilm Replacement System (MRS) and the Transcript Research System (TRS) processing. The project is replacing current IMF data with CADE data as input while creating the Transcripts for MFTRA types ‘J’, ‘C’, ‘M’, ‘S’ and ‘X’ with minimal impact to the current processing.
ROLE: Sr. Mainframe Developer/ Sr. QA Analyst
Involve in Agile methodology
Involved in creating the Design document
Involved finding the gaps in requirements
Involved in creating the Core Record Layouts by studying the existing system
Involved in resolving the requirement gaps by contacting the stake holders
Involved in release requirement analysis, problem resolution, and modification to existing COBOL/DB2/ASSEMBLR/CICS programs.
Created Control-M schedules and set-up the job dependencies.
Created templates to map the TIF records using File-Manager
Involved in creating the Test Plan/ Test Strategy
Created schedule and Involve in running the jobs using Control-M
Involved in using TMON and OMEGAMON tools
Validated the Test results, Once defects are found created defects in RTC
Created the user stories in RTC and update them once the sprint progresses
Identified data in the database by writing the SQL’s
Involve in Database Testing
DIVISION OF VALIDATION & TESTING TECHNOLOGY (DVTT)
Client: SOCIAL SECURITY ADMINISTRATION, BALTIMORE, MD
Duration: July 2013 to Feb 2016
Environment : OS/390, TSO/ISPF, JCL, FILE-AID, FILE-AID/RDX, FILE-AID DB2, SYNCSORT, DB2, SPUFI, QMF, FTP, SuperCE, Control-M, ENDEVOR, REXX, CLIST, ISPF Dialog Manager, ALM, UNIX, ORACLE, PL/SQL, J2EE, JAVA Script, Java Beans, EJB, JSP, JDBC, Web sphere, Web Services, Selenium, JAWS, Microsoft Office Outlook, VISIO, MS-Office etc..
DESCRIPTION : Validation Operations Branch(VOB) is one of the branch under Division of Validation & Testing Technology(DVTT). The VOB is responsible for the design, development and maintenance of the Validation Database (VDB) and its associated utilities. VOB ensures sanitized test data is available. VOB delivers Enterprise-wide support, installation and license tracking for HP’s Application Lifecycle Management(ALM) software and its entire suite of tools. VOB provides SSA field office employees with sight impairments a solution for CICS screens not yet 508 compliant.
ROLE: Sr. Mainframe Developer/Sr. QA Analyst
Involved in all phases of SDLC cycle
Involved in gathering the requirements
Involved in modifying COBOL, ASSEMBER, REXX, CLIST programs
Involved in Deep understanding of the existence of the data in DB
Involved in Design phase and drafting the design proposals
Involved in Developing the Project Plans
Participated meetings with the clients about finalizing the requirements
Involved in Analyzing the RI Relationships of the DB’s.
Involved in creating the Relationship Diagrams
Involved in developing the Relationship Files
Involved in developing the File-Aid/RDX components
Develop the Test cases for complex Test Scenarios
Develop the RTM’s (Requirement Tractability Matrix) to make sure all the requirements are covered by the Test Cases.
Involved in all types of Testing (Smoke Testing, Unit Testing, System Testing, Integration Testing, Performance Testing)
Perform all the required processes for implementation
Implementing the developed components
Involved in supporting the Post implementation activities
Involved in Production support
Involved in writing the complex SQL queries
Involved in 508 Compliance testing using JAWS tool
REPLACEMENT DISSEMINATION SYSTEM
Client: CENSUS BUREAU, SUITLAND, MD
Duration: Jan 2012 to June 2013
Environment : Unix, AIX Utilities, JAVA, ORCLE, PL/SQL, SQL Loader, XQuery, ArcGIS GeoProcessing Framework, Endeca tool set, Jasper Reports, RSA for JAVA, AJAX, Trivoli workload Scheduler, SAS,, J2EE, JAVA Script, Java Beans, EJB, JSP, JDBC, Web Logic, Web Methods, JBoss, DB Triggers, PERL, PVCS, Informatica, Data Warehouse, TOAD, Rapid SQL, UNIX Shell Script, JAWS, JXRML, XML, XML Schema, Xquery, Selenium, Load Runner, Rational RequisitePro, Clear Quest, Clear Case, Visio, MS Office..etc.
DESCRIPTION : RDS(Replacement Dissemination System) provides easy access to Census Data for non-expert users without sacrificing detail for the experts. The RDS comprises of 3 major components. The Data Load and Transformation (DLT) receives data and metadata from data providers and places this data into the Data Stores used by the End User System. The Data Stores are a collection of files, databases, and indexes containing the dissemination data and metadata. The End User System (EUS) is an interactive web site that allows end-users to access the data and metadata in the Data Stores in the form of tables, maps, and charts.
ROLE: Sr. QA Analyst/Business Analyst
Involved in testing the ETL (Extract, Transform, Load) process based on business rules by comparing the source and object tables.
Involved in Requirement analysis.
Involved in design develop and test the Mainframe DB2 Batch & CICS programs.
Involved in testing the DB2, CICS and Z/OS modules
Identify the defects and logged them in defect tracking tool
Involved in debugging the COBOL,DB2,CICS programs and fixing the defects
Involved in performance tuning
Involved in installing the products
Involved in Fine-tune, troubleshoot, and diagnose TCP/IP and SNA network performance among IBM Websphere, IBM CICS
Involved in Mainframe system monitoring and performance management using OMEGAMON
Involved in Tape management using CA-1
Involved in creating the schedules and monitoring the jobs using the CA-7 scheduler
Involved in Performance Testing
Involved in 508 Compliance testing using JAWS tool
Tested Data Transformation, Loading, Scrubbing and Extraction programs using Informatica tool.
Involved in creating the testing artifacts like test plan, Test cases, RTM…etc
Involved in testing the PL/SQL procedures, DB Triggers
Involved in DB&GUI testing
Validating the data in DB’s, Data Ware house DB’s by writing the simple to complex SQL’s
Once the defect is fixed conduct the regression test it the defect is fixed closing the defect otherwise re-open the defect and assign back to developer
CUSTOMER ACCOUNT DATA ENGINE
Client: Internal Revenue Service(IRS), LANHAM, MD
Duration: Aug 2009 to Dec 2011
Environment : OS/390, Novell client for windows, Windows–XP, TSO/ISPF, Assembler, SAS, EasyTrieve, CICS, VSAM, JCL, FILE-AID, File-Manager, TMON, SYNCSORT, DB2, SPUFI, QMF, FTP, SuperCE, Control-M, Control-O, ENDEVOR, UNIX, Rational Tools(Test Manager, Clear Quest, Clear Case, Rational Rose…), Microsoft Office Outlook, MS-Office etc..
DESCRIPTION : The Customer Account Data Engine (CADE) project will incrementally design, develop and implement the data foundation for a modernized IRS. This foundation includes the creation of online transactional processing data stores of “record” for taxpayer returns and accounts. CADE will replace the existing tape-based master files and Integrated Data Retrieval System (IDRS) with new technology, new applications and new databases.
ROLE: Sr. QA Analyst/Sr. Mainframe Developer
Involved in creating the new test environments.
Modified the production JCL’s according to the Test environments
Installed new builds on test environments.
Created Control-M schedules and set-up the job dependencies.
Executed the jobs using Control-M scheduling tool.
Created simple to complex SQL queries and run them thru SPUFI/QMF
Analyzed the failed jobs and informed the development team
Gathered and Analyzed the Requirements.
Analyzed the CICS transactions using TMON
Designed, developed and implemented test cases as per customer and system requirements.
Understanding the Complex Scenarios and build Test Scenarios for those complex scenarios.
Used Rational Test Manager to design and develop test scripts/ cases as per the requirements.
Deep understanding of the CADE & IMF(Individual Master Files) systems
Created test data using File Manager.
Involved in doing the Back-End Testing.
Involved in testing the Ware-House DB’s.
Preparing status reports, gathering project data and creating metrics
Used Rational Tool Clear Quest to enter and track defects, and worked closely with the development and SME’s validation of defect fixes and resolution of defects.
Maintained source files and software builds using Clear Case.
Participated and interacted with cross-functional team in project status meetings, in identifying issues and resolution
Being a Developer and Tester as Dual roles I brought a Unique perspective to the Project.
Participated in Peer Reviews and ensured that test cases/ scripts were developed in accordance with testing requirements.
Created test data using Pegasus and performed various tests using the data to run the test scripts in Parasoft’s automated test tool.
Involved in creating the Rational SoDA template to extract the test scripts from Test Manager and generate test script documentation.
Used Rational Clear Quest to track defects and worked closely with the development team to resolve defects.
Participated in Peer Reviews and ensured that test cases/ scripts were developed in accordance with testing requirements and followed CMMI standards for documentation.
Worked closely with peers to train them in using test tools to generate data, test cases/ scripts and automated testing.
E2E Testing
Client: Freddie Mac, Mclean, VA
Environment : UNIX, ORACLE, PL/SQL, J2EE, JAVA Script, Java Beans, EJB, JSP, JDBC, IPlanet, Web Logic, Web sphere, Web Methods, DB Triggers, PERL, PVCS, Informatica, Data Warehouse, TOAD, Rapid SQL, SQL Plus, Auto-Sys, Business Objects, PeopleSoft, OS/390, TSO/ISPF, VS COBOL II, SAS, ASSEMBLER, CICS, DB2, IMS DB, VSAM, JCL, QMF,SPUFI,ENDEVOR,XPEDITER,INTERTEST, EasyTrieve, FILE-AID, SYNCSORT,FTP, CompareX, SuperCE, Connect-Direct, SAR, JOB Tracks, Change Management, BMC utilities, CA-Scheduler, Mercury Tools(Quality Center, QTP, LoadRunner..etc), Rational tools(Clear Case, Clear Quest, Test Manager, Rational Robot, Rational RequisitePro...etc) Doors, MS-Office, MS Access, MS Project, Visio…etc
Duration: Apr 2008 to July 2009
DESCRIPTION: End to End(E2E) testing involves in testing most of the systems in the organization. It starts from creation of master commitments, importing the loans, creating the contracts, attaching the loans to the created contracts and sending the contract data to the downstream systems like Midas, SAP, ODI, CFA, AR Billing, SAFE, servicing the loans, Creating the contracts in Midas & CS Web, importing the loans using the Midanet.
ROLE: QA Lead/Sr. QA Analyst
Creating the Test Plans, Test Cases based on Requirements
Captured and analyzed requirements information with detailed attribute customization and filtering using Rational RequisitePro tool.
Develops the RTM by mapping the Test cases and the requirements
Executing the test cases from Test Manager.
If any defects are found during the testing, log them into defect tracking tools(Clear Quest/Quality Center).
Once the defect got fixed and do the regression testing
Participated in defect review meetings.
Participating code walkthroughs
Identify the code defects during the code walkthroughs
Preparing the Test Data
Running the jobs using Auto-Sys.
Taking the IMS DB backup
Involved in creating and testing the UNIX scripts
Involved in doing the Back-End Testing.
Loading the IMS DB segments with the data
Loading and unloading the data into DB’s like ORACLE, DB2
Running the Unix scripts
Involved in testing the Ware-House DB’s.
Writing the simple to complex SQL queries
Involved in testing the modules designed using iterative methodologies like Agile/Scrum.
Maintained source files and software builds using Clear Case.
Analyzing the mainframe jobs in case of any errors occurred
Prepares the Test Results document
Coordinated the UAT testing.
PORTFOLIO POOLING SYSTEM
Client: Fannie Mae, Herndon, VA
Environment : OS/390, Novell client for windows, Windows–XP,TSO/ISPF, COBOL II, SAS, EasyTrieve, CICS, IDMS DB, IDMS/DC, DMLO, IDMS OLQ, VSAM, JCL, FILE-AID, SYNCSORT, IDCAMS, FTP, CYCLONE, SuperCE, CA-7, ENDEVOR, UNIX, ORACLE, PL/SQL, J2EE, JAVA Script, Java Beans, EJB, JSP, JDBC, IPlanet, Web Logic, Web sphere, Web Methods, DB Triggers, C++, PERL, PVCS, Ab Initio, Data Warehouse, TOAD, Rapid SQL, SQL Plus, Auto-Sys, Business Objects, WinRunner, LoadRunner, QTP, Quality Center,Clear Quest, Microsoft Office Outlook, MS-Office etc...
Duration: Jan 2007 to Feb 2008
DESCRIPTION : The portfolio Pooling System (PPS) aids in Fannie Mae’s capability to structure whole loan purchases for subsequent sale as mortgage-backed securities (MBS). This satisfies not only a continuous business need to sell mortgages rather than to hold them in portfolio, but also, to comply with federal regulations as to how much Fannie Mae can hold in its investment portfolio.
ROLE: Sr. QA Analyst/QA Lead/Business Analyst
Doing the Requirement Analysis.
Identify the gaps in the requirements.
Participates in Functional & Technical specifications documents review
Imported the requirements into Quality center.
Created Requirement Traceability Matrix to match the requirements.
Preparing the Test Plans, RTMS for each project
Creating the test cases based on the Business requirements, Functional specifications and Technical specifications.
Identify the Testing Approach.
Conducted and participated in Test Plan & Test case review meetings.
Participating code walkthroughs
Identify the code defects during the code walkthroughs
Extensive experience in testing the PL/SQL Procedures, functions and DB triggers
Identify the naming conventions which are not met the Fannie Mae Standards
Preparing the Test Data
Mocking up the Test Data by doing the update to the files, Data Base
Configure the JCL’s, Proc’s to the system test environment by modifying them
Involved in doing the Back-End Testing.
Involved in testing the Ware-House DB’s population.
Involved in testing the C++ components
Creating the Test Lab in Quality center.
Executing the Test cases from the Test Lab in Quality center.
Identify the defects and logged them in Quality center.
Participated in defect review meetings.
Update the test case status in Test Lab incase if test cases passed or failed
Creating all kinds of Reports (Defect, Requirement, RTM...) from Quality center.
Applying the experience in software development life cycle.
Created the Mainframe jobs for to do automation.
Migrated Mainframe Jobs from DEV environment to Test environment.
Running the mainframe jobs using CA-7 scheduler.
Extracting and transforming the data feeds in Mainframes using File-Aid
Testing the EasyTrieve, SAS jobs
Involved in testing the ETL (Extract, Transform, Load) process based on business rules by comparing the source and object tables.
Verify the ETL transactions and identify the Irregularities in data loading
Tested Data Transformation, Loading, Scrubbing and Extraction programs using Ab Initio tool.
MULTISUITE FOR PRICING
Client : Freddie Mac, VA, USA
Environment : OS/390, Novell client for windows, Windows–XP, Windows 2000, J2EE, JAVA Script, JSP, Servlets, JAVA Beans, JSP, EJB, JDBC, RMI, Swing, I planet, Web Logic, Web sphere, WebMethods, C++, PowerBuilder, Unix, Oracle, PL/SQL, PVCS, VS COBOL II, SAS, TSO/ISPF, CICS, IMS DB, DB2, DB2 Stored Procedures, VSAM, JCL, QMF, SPUFI, FILE-AID, SYNCSORT, IDCAMS, FTP, SuperCE, JOB Tracks, UDB DB2, Auto-Sys, Mercury Tools(Quality Center, QTP, Load Runner..etc), Rational tools(Clear Case, Clear Quest, Test Manager, Ration Robot, Rational RequisitePro ..etc …), Toad, Rapid SQL, Sybase, DB Triggers, SQL Plus, Lotus Notes, MS-Office …e.t.c.
Duration : Oct 2005 to Dec 2006.
DESCRIPTION : The MultiSuite for Pricing application calculates net spread and Return on Equity (ROE) based on information you provide in a pricing scenario. Pricing information is used to negotiate loan purchases between Freddie Mac and its business partners. The application ensures that an Underwriter is provided with the minimum required ROE and net spread for a specific loan type prior to issuing a quote. The Pricing application also allows the Home Office to change cost factors for requests on customized loans and interacts with the Underwriting (UW) application of the Multifamily Processing System (MPS).
ROLE: Sr. Mainframe Programmer/ Sr.QA Analyst
LOGISTISTICS SYSTEM (DMPULS)
Client : Sony Electronics Inc, NJ, USA
Environment : Test Director 8.0, OS/390, Windows-NT, VS COBOL II, EasyTrieve, TSO/ISPF, CICS, IMS DB, DB2, DB2 Stored Procedures, VSAM, JCL, QMF, SPUFI, TMON, LIBRARIAN, XPEDITER, INTERTEST, FILE-AID, SYNCSORT, IDCAMS, COMPAREX, FTP, CompareX(NDM), SuperCE, FTP, Oracle, DB Triggers, PL/SQL, TOAD, UNIX, Shell Script, PERL, Red Prairie(McHugh) Packages for Warehouse and Transport Management system(TMS), Control-M, MS-Office …e.t.c.
Duration : May 2003 to Sep 2005.
ROLE: Sr. Mainframe Programmer/QA Analyst
ASSET MANAGEMENT SYSTEM
Client : Merrill Lynch, Newjersy, USA
Environment: OS/390, Windows-NT, VS COBOL II, SAS, ASSEMBLER, MQ Series, FOCUS, TSO/ISPF, CICS, DB2, IMS DB,VSAM, JCL, QMF,SPUFI, ENDEVOR, XPEDITER, INTERTEST, FILE-AID, SYNCSORT, IDCAMS, FTP, CompareX(NDM), SuperCE, Connect-Direct, SAR, BMC utilities, CA-Scheduler, ORACLE, UNIX, MS-Office, MS Access, VB Script, MS Project,Visio …etc.
Duration : Jan 2001 to Apr 2003.
ROLE: Sr. Mainframe Programmer / Project coordinator
Contact this candidate