Software Engineer Quality Assurance

Summary:

A competent and result oriented professional with over 13 years of progressive IT experience as Senior Mainframe Programmer / Senior Mainframe Systems Analyst in the Evaluation, Analysis, Design, Architect, Development, Testing, Maintenance and Support of mainframe hosted business applications using database management systems, high level programming languages and best practices.

Extensive experience in gathering requirements, designing and implementing new applications and/or enhancements, including the addition of new subsystems, as well as major changes to existing “baseline” subsystems. Actively involved in all phases of the software development life cycle right from Scope Definition, Requirement Study, Estimations, Analysis, Design, Coding, Testing, Customer Demonstration, Implementation and Knowledge transfer activities.

In depth experience in IBM-Mainframes technologies including but not limited to, COBOL, CICS, DB2, SAS, SQL, ETL, Stored Procedures, MQ series, CICS Web services, DB2 XML Extender, VSAM, JCL, various Mainframe utilities / tools.

Experience in DB2 database analysis, design of database model, normalization and data manipulation process. Proficient in performance monitoring and tuning of large DB2 mainframe databases.

Highly motivated, strong work ethic, analytical and mathematical skills backed by sound technical and functional knowledge in federal and state government, transportation, mortgage, nonprofit organization, telecom and financial domains.

Experience in analyzing the entire system and the impact with the other backend and front-end systems.

Experience in requirements gathering and business rules analysis using a variety of data modeling techniques and artifacts, conceptual/logical/physical (3NF) database modeling tools like ERWIN, ER Studio.

In depth knowledge of software methodologies, Software Development Life Cycle Standards (SDLC) with CMM level (4) with well structured and best practices approach, utilizing project management flows. Used Joint Application Development (JAD) / Rapid Application Development (RAD) processes to deliver better results. Implemented AGILE –SCRUM Project Development Methodology.

Exposure to Data ware house concepts and ETL tools. Worked closely with ETL specialist in determining and implementing the best technique for extracting data from a particular source system (DB2 tables and/or files) and moving it to the BI system.

Flexible, organized and absolute team member with both excellent management and hands-on technical skills (MS education and certifications).

Excellent prioritization and organization skills including ability to establish priorities independently, strong self-initiative, strong interpersonal skills, ability to deal effectively in a team environment and clear communication skills.

Expertise in performing different types of testing: Unit, Integration, Stress, Volume, System, Regression and User acceptance testing.

Served as primary contact for migration of applications to production, monitoring and support of nightly batch cycle.

Experience in working on multiple projects concurrently, spread over multiple locations.

Accreditations:

Public trust clearance.

ITIL (Information Technology Infrastructure Library) V3 Foundation Certification.

IBM Certified Database Administrator - DB2 9 DBA for z/OS

IBM Certified Solution Designer - WebSphere MQ V6.0

Received the greatest IBM BRAVO award during 2004-2005.

Hold Masters Degree in Computers.

Professional trainings attended:

ITIL Workshop, FP Counting, PM tool MS Project at AARP, Rockville (2 Weeks).

Six Sigma, Scrum Methodologies, at AARP, Rockville (2 Days).

Information builders Webfocus business intelligence product, MDOT, Hanover (1 week).

CSQA Practices at IBM at VA, USA (1 Week).

CICS, DB2, VSAM, MVS & JCL at IBM, Bangalore (2 Months).

Java and UNIX training at Bangalore (1 Month)

Employer Matrix:

TMI-Solutions, MD, USA August 2005 – till date

IBM Global Services, USA August 2001 – July 2005

IT Solutions, India March 1998 – July 2001

Technical Skills:

Operating Systems MVS/ESA, Z/OS, OS/390, Windows, UNIX.

Languages COBOL, PL/I, JCL, REXX, .NET, C#, Java, C, C++, XML.

OLTP CICS, IMS/DC, ISPF Panels.

Databases DB2, UDB, IMS/DB, VSAM, Oracle.

Tools and Utilities TSO, Rational Rose, Visio, Erwin, QMF, SPUFI, ETI, MQ Series, DB2 XML Extender, CICS Web services, Endevor, Changeman, Easytrieve, CTG, DB2 Connect, DOC Direct, Omegamon, Expeditor, File-Aid, File-Manager, FTP, OPC, RMDS, SCLM, CLIST, Web focus, ETL, stored procedures, Intertest, QUICKSTART, ABEND-AID, CONNECT Direct, SORT, syncsort, fault detector, and general IBM and CA Utilities.

Professional Experience:

Client: Lockheed Martin/SSA – Baltimore, MD

Role: Data Modeler/Sr. Mainframe Programmer January 2012 to Current

Description: The Social Security Administration (SSA) is committed to improving the quality and speed of the disability process by examining the entire process from the first contact with the applicant through the final level of appeal. The primary purpose of the Disability Case Processing System (DCPS) project is to replace the current five disability case processing systems with a modern web-enabled common system. This new common system will also allow SSA and the disability processing components to leverage the latest systems architecture, security and application development technologies and standards, and to lay the foundation to support future HIT initiatives and improved interfaces with other SSA components. DCPS will -

• Support the Disability Determination business process

• Use Service Oriented Architecture principles

• Be flexible so changes to policy, procedures, or law can be accommodated quickly and easily

• Integrate with existing software applications already in use by other agency components

• Access historical data

Key Accomplishments:

Participated in requirement gathering session with business users to understand and document the business requirements as well as the goals of the project.

Identified various facts, dimensions, bridges and cross reference entities from the source system and business requirements to be used for the data warehouse system consultative exam (CE) and fiscal subject area.

Implemented the standard naming conventions for the entities and attributes of logical and physical model.

Created the dimensional logical model with approximately 50 entities and 600 attributes using ERWIN.

Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.

Ensured timely deliveries of work requests. Reported daily status to Technical Delivery Manager and Management.

Client: American Association of Retired Persons (AARP)

Role: Sr. Software Engineer/Sr. Systems Analyst October 2010 to December 2011

Description: AARP is a non-governmental/non-profit organization and interest group for people age 50 and over, dedicated to enhancing quality of life which provides a wide range of unique benefits, special products, and services for members. AARP offers Medicare supplemental health insurance, discounts on prescription drugs and consumer goods, entertainment and travel packages, long-term care insurance and automobile, home and life insurance. It provides quality control over the products and services made available by AARP-endorsed providers. AARP has over 45 million members, making it one of the largest membership organizations in the United States.

The project is about steering the overall responsibility of Major Enhancements as per the Contract, SLAs and Client needs, also ensured smooth running of business within the project level, and addressing any issues, managing the constraints, monitor, capture and Report Project Metrics, status to the PMO / Delivery Head as expected.

Key Accomplishments:

Interacted with the users and prepared detailed design specifications, Low level design documents, detailed instructions and logical steps for coding into language and estimates. Analyzed and documented the business and system requirements specs using VISIO.

Spearheaded the design and development of a highly scalable duplicate database cleanup without impacting the business community using COBOL, CICS, DB2, VSAM and CICS web services. Designed the data model (conceptual/logical/physical). Designed all the tables required to store combined accounts. About 5M duplicate accounts combined resulting significant revenue.

Designed and implemented the “fuzzy logic” algorithm to stop creating duplicate and/or double base accounts in the KONNEX membership system using COBOL, DB2, CICS, XML and sapiens. Used reverse engineering data model and 3rd normal form to maintain data integrity in the system.

Designed, coded and tested several CICS/batch COBOL II, SAS, DB2, stored procedure, MQ series, Easytrieve, CICS web services application programs.

Involved in several knowledge sharing sessions, brought up best practices within team.

Solved problem logs, which involved extensive analysis, coding, testing and quality assurance.

Investigated complicated performance and stability issues involving a large, sophisticated, and evolving code base. Involved in tuning the database to increase the overall performance.

Contributed in the decomposition of sprint in the Agile Software Development with Scrum.

Lead the migration of mainframe application module to production.

Ensured timely deliveries of work requests. Reported daily status to Technical Delivery Manager and Management.

Environment: Mainframe, DB2, SQL, COBOL, CICS, CICS Web services, JCL, VSAM, Easytrieve, SAS, MQ series, REXX, Endevor, INTERTEST, Sapiens, Quick start, Omegamon, File-Aid, SPUFI, QMF, XML, File-aid for DB2 and general IBM utilities.

Client: Maryland Department of Transportation (MDOT)

Role : Sr. Software Engineer/Sr. Systems Analyst August 2005 to September 2010

Domain : Transportation

Description: The ‘Financial Management Information System’ (FMIS) implemented using Mainframe financial (Relational Standard Accounting and Reporting System R*STARS) and purchasing (Advanced Purchasing and Inventory Control System ADPICS) applications. MDOT’s financial system supports the interface to and reconciliation with the FMIS implementation for the State Comptroller. All modals within the department are using the same financial system.

The project is to provide analysis, design, development and support for MD State Department of Transportation's proprietary financial management information system (FMIS) used for order management, project accounting, federal aid billing, asset management, cost allocation, general ledger, accounts payable, accounts receivable, procurement and financial reporting. This project manages data conversions and coordinates intra-departmental interfaces between financial applications to facilitate an integrated enterprise-wide solution.

Key Accomplishments:

Designed, implemented and tested FMIS-IFMIS integration of subcontractor and subcontractor invoice documents using DB2 XML Extender and WMQ.

Designed, implemented and tested the MAXIMO MXES-FMIS integration of BPO, PO, Requisition, Change Orders, Voucher, receipt and Invoice using CICS Web services.

Designed and developed the new Federal Liability Offset process (FLO) for the Department of Budget and Management (DBM) using COBOL, DB2, VSAM and stored procedures.

Interacted with the users and prepared specifications and estimates. Analyzed and documented the business and system requirements. Made recommendations, researches and find out alternative solutions.

Constructed data models, designed schemas, generated DDL and worked with development team members on the implementation of data warehouse. Implemented Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, slowly changing dimensions, foreign key concepts, referential integrity.

Estimated and negotiated the development efforts. Prepared low level design documents and estimates. Ensured timely deliverables meeting quality requirements.

Coordinated with the operations areas and lines of business to spot out and specify complex business requirements and processes.

Redesigned (Reverse engineering), implemented and tested the MBE / SBR vendor application programs for MDOT functional team members. The redesign has enabled the MDOT staff to keep a reliable track of certified MBE and SBR vendors.

Participated in the design and implemented the ICCB subsystem in R*STARS to capture expenditures that meet requirements for reimbursement from Maryland Transportation Authority (MDTA) and provide a systematic method of producing bills for MDTA.

Worked closely with the ETL architect to ensure compliance with all standards, and that the project deliverables are consistent with long-term infrastructure plans.

Analyzed, designed and developed various tasks related to ETL and web focus to load the historical and current data to data warehouse/adhoc database.

Designed, coded and tested several CICS/batch COBOL II, DB2, SAS, stored procedure, MQ series, CICS web services application programs.

Developed system operation manuals for the entire FMIS system.

Performed configuration management duties for MDOT large-scale IBM mainframe environment. Controlled all migrations of application programs and system Job controls from test environment to production environment thru the use of Endevor, a software migration tool.

Provided technical support for FMIS financial system for “on time and under budget” projects.

Design and prepare technical reports and related documentation, charts and graphs (VISIO) to record results.

Debugged several CICS programs using InterTest.

Created test cases, test data and recorded test results for new/enhanced requests.

Setup the environments for QA’s and coordinate in testing.

Developed a web based batch cycle monitoring tool using the SCHED50 / ZEKE batch schedulers output.

Provided on-call technical support for the Financial Management Information System nightly batch cycle.

Prepared the metrics for the application to evaluate the quality standards. Provided the status reports to top management.

Environment: Mainframe, DB2, DB2 XML Extender, Stored procedures, WMQ, COBOL, CICS, CICS Web services, JCL, VSAM, Web focus, ETL, Visio, Oracle, REXX, Endevor, INTERTEST, QMF, SPUFI, File-aid, SAS, file manager, Windows Server, Unix server and various mainframe utilities.

Client: AT&T VA, NJ

Role : Sr. Software Engineer/Sr. Systems Analyst June 2003 to July 2005

Role : Software Engineer/Systems Analyst August 2001 to May 2003

Domain : Telecom

Description: Development, maintenance, production support of SSIRS, an application in AT&T (Switched Services Information and Routing System). This is a system facility composed of five separate subsystems supporting NODAL SERVICES PROVISIONING. It expedites the transfer of information from marketing to customer service test rooms, Dial Administrators and Switch Control Centers by allowing the SDN (Software Defined Networks) Provisioning Centers to input routing information into on-line legacy data files. Thus SSIRS could provide accurate and reliable SDN data for faster routing of SDN troubles to the appropriate work center. For SDN locations SSIRS also provides accurate account LDN-ANI mapping and associated customer profile and service data. SSIRS interfaces include CDDS II, CDIS-NRD, GLITR, SDN-SMS, CLDS, CNRDB, NCD, POPIS, BMP, CMDS II, CDIS-CTSS, IRAS, NRA, NSP, TIMS, UMIU and 4CAST. SSIRS supports SDN, SDS (700 number services), MEG8/MULTIQUEST (800 number / 900 number services), MEGACOM and TSAA.

Also worked on Wide Area Telecommunication Services/Service Order Processor (WATS/SOP) system is one of the applications that are being migrated from AT&T in the U.S to IBM India. WATS/SOP is an order entry and distribution system designed to handle Inbound and Outbound business customer services for domestic and international usage. WATS/SOP interfaces with provisioning, billing, and other ordering systems to ensure end-to-end processing of service orders. It is an IMS (DB/DC), PL/I, and COBOL II based application with both on-line and batch processing.

Key Accomplishments:

System Appreciation – Understanding the whole system.

Involved in the transition of AT&T Account from AT&T to IBM.

Accountable for designing, coding, development, testing, documentation and debugging of mainframe applications to fulfill the requirements of one or more user areas.

Written/Modified several CICS/ batch programs using COBOL, DB2 and VSAM.

Prepared Low level Design docs and estimates.

Analyzed and documented the business and system requirements. Estimated and negotiated the development efforts.

Worked with multiple teams at onsite, as well as offshore teams. Prepared work specifications in co-ordination with the onsite team, allocation of work at offshore.

Support, enhancement and maintenance of existing mainframe applications.

Support Integration, User Acceptance and System testing.

Served as primary contact for Production support of the application.

Fulfilled the SLA’s as per the client requirements to solve the production problems and requirements.

Responsible for developing and maintaining the MQ series on mainframe platform. Designed and coded batch and CICS programs using MQ series.

Created test cases and recorded test results for new/enhanced requests.

Responsible for Version control, movement of code and components from deployment area to integration system and production system.

Documented the flow of application programs to understand the system.

Reviewed the work request execution by all the resources in the module

Environment: Mainframe, DB2, IMS, JCL, COBOL, PL1, WMQ, CICS, stored procedures, VSAM, Endevor, File-aid, EXPEDITOR, REXX, Java, Servlet, JSP and a proprietary language CFL (Control Flow Language) and various IBM and CA utilities.

Client: Wells Fargo, CA

Role: Software Engineer March 1998 to July 2001

Domain: Banking

Description: The RBS, Retail Banking System, was maintained under DB2, CICS, and COBOL environment for Wells Fargo to cater its daily Operations. The application had rich set of tables, modules and processes for Savings Bank Accounts Processing, Loan/ Hire Purchase Processing, Credit Card Transaction Processing, Draft/ MT/ Check issuing Processing, Fixed Deposit Processing.

Key Accomplishments:

Involved in the complete execution of the projects. i.e. Analysis, Design, Coding, Testing (Unit test, System test, Integration test, Stress test and UAT) and Rollout.

Carry out the Adhoc code changes, maintenance requests and quick fixes.

Solving Problem logs, which involve extensive analysis, coding, testing and quality assurance.

Maintaining application, technical support and documentation.

Monitoring daily, weekly, monthly, and quarterly jobs.

Analyzing and fixing the regular job abends and problems reported by the users.

Ensuring that all the work meets the quality requirements according to ISO 9001 standards.

Ensuring timely deliveries of work requests.

Environment: Mainframe, COBOL, VSAM, CICS, MQ series, EZYTRIEVE, CHANGEMAN, JCL, DB2, IMS, Oracle, UNIX, Java, JSP, Servlet, Rational Rose and various IBM and CA utilities.

Contact this candidate