Qa - Support Resume
Dearborn, MI
PROFESSIONAL SUMMARY:
- Highly experienced quality assurance and software development professional with value - added skills are in the areas of business analysis, quality assurance, software design and development, gathering user requirements, creating high-level systems documentation, low-level program and systems specifications, creation of detailed test scripts, quality assurance evaluations and performance measurements.
- Experience includes application of formal methodologies (e.g., STRATUS by McDonnell-Douglas) and more generalized methodologies such as Agile Development, JAD, RAD, SCRUM, Orr-Warnier, Yourdan-Constantine and others.
- Testing and quality assurance tasks have been performed using both manual test scripts and evaluation techniques and, more recently, automated testing and quality control products of vendors (IBM, CA, H-P and Compuware) in this expanding market.
PROFESSIONAL EXPERIENCE:
Confidential (Dearborn, MI)
QA - Support
Responsibilities:
- Support for the MOMS system used by Ford dealers to stock after-market replacement parts, this system is the responsibility of Ford Customer Service Division and provides full warehouse functions for parts distribution both domestic and export
- Gathered user requirements, determined impact of changes, developed resource requirements estimates and gathered other relevant information to assist management to qualify and prioritize application maintenance and enhancement requests
- Area of specialization was in-bound inventory processing so concentration was on receiving, location organization and management, vendor supply scheduling and coordination with assembly plant needs and special (recall) parts handling and expediting
Environment: is z/VSE, COBOL, VSAM, JCL, FAQS, ICCF and CICS for the parts distribution centers (PDCs) systems and COBOL, VSAM, JCL, FTP/NDM, Mobius, TSO/ISPF, REXX, CA7 and Change Manager for the z/OS headquarters functions and common functions, usually consolidations and interfaces with other corporate systems (i.e., payables, receivables, scheduling, releasing, etc.)
Confidential (Dearborn, MI)
Quality Assurance Lead
Responsibilities:
- Quality Assurance Lead for team of 12 quality assurance analysts located in Dearborn, MI, USA and Gurgaon, India. Managed analyst assignments for module level quality assurance testing on agile development teams for the Product Definition Office effort at Ford
- Differentiated unit and user acceptance functional testing from system and integration testing. Created QA test strategy for elaboration and construction phases of agile project. Created system and acceptance test strategies for Release 0.01.
- Identified opportunities for automated, repeatable testing to be completed with each build and repeated at the end of each development iteration. Achieved success in the adoption of agile techniques for continuous improvement, testing and implementation
- Used agile methodology and QA tools Confidential Compare, JUnit, AnthillPro, Selenium, AccuRev and scheduling tool Autosys. Created and executed tests using SQL Server SQL developers’ suite. JUnit and J2EE code.
Confidential (Dubuque, Iowa)
Business Analyst/Quality Assurance Analyst
Responsibilities:
- Performed maintenance and enhancement to address performance issues on initial database load for upgrade to version 12.5 of Practice Plus Solutions software achieving 40% reduction in runtime requirement.
- Created use cases and test cases for changes to accounting practices (linking unapplied payments to specific charges) and modifications required to support ICD-10 diagnosis code changes mandated for 10/2012 implementation.
- Created technical specifications from functional requirements for enhancements in support of CMM 5010 electronic claims processing requirements and laying the basis for further conversions to meet 6020 standards as they emerge.
- Created and executed test plans for various modules as they emerged from development teams. Coordinated regression testing and build and promotion of successful modules.
- Environment is a medical practice management system, including insurance claims processing, designed for medium to large group practices. System is unix-based using Oracle, COBOL, Python/Tuxedo (for screens) with standard utilities for the environment (PL/SQL, Ultra Edit, Ultra Compare, Putty, Filezilla, etc.) with migration to Linux in future plans.
- Ensure HIPAA and Sarbanes-Oxley compliance for all affected systems modules and related documentation.
- Produce updates to systems documentation, operations manuals, user guides and s and functional and technical specifications, performed data flow analysis, data mapping of files and databases, sources and uses of data, structural flow charts, identification and analysis of system risk points, and ergonomic studies of user workflow and productivity impacts.
- Conducted peer reviews of applications development efforts, assisted quality assurance in creating test scripts and scenarios for product validation.
- Aggressively advocated for ISO process s and standardized metrics to be applied to development and maintenance tasks and system performance. My single greatest challenge has been the linkage of functional and technical specifications within a virtually undocumented applications programming and database environment. The concepts of data analysis and management, an integrated data dictionary and the ability to model data and gather and maintain metadata are unknown to this company.
Confidential (Menomonee Falls, WI)
Quality Assurance Analyst
Responsibilities:
- Stress testing of data feeds and processes involved in distribution center warehouse activities using mainframe-based data sources and file transfers to Unix-based application servers running Manhattan Associates supply chain warehouse management and logistics management systems.
- Created test strategy and test plan for interfaces and data transfers. Developed test cases for user acceptance and integration testing that included mainframe and web interfaces.
- The project is a prelude to the business season in retail in which e-commerce customer orders from Kohl’s website will be sent to one of the warehouses for packing and shipping. Prior experience indicated many performance problems in the past. Software and hardware upgrades applied to ameliorate these issues needed to be thoroughly tested under extreme conditions to validate the preparations for the 2010 holiday shopping season.
- I was the point person on the entire testing process. Reporting to the project manager, I did the analysis to select the data for testing, constructed the transaction scenarios, built the mainframe test jobs and the Unix scripts to emulate a production environment, ran the tests and analyzed the results.
- Performed detailed analysis of trace output (.trc and.out files from TKPROF), AUTOTRACE and EXPLAIN PLAN analysis, usually via TOAD but frequently stand-alone via SQL*Plus, to track down, identify, and get design, programming and database administrator bugs and errors fixed. Indexing errors alone allowed me to identify huge resource savings. I was able to reduce cpu time in one batch job, for example, from 20800 cps seconds to less than 2,100 through detailed analysis of table indexes, keys and links.
Environment: z/OS, JCL, TSO/ISPF, JCL, QSAM, VSAM, DB2, CICS, MQSeries, Websphere MQ, COBOL, Syncsort, Intertest, ESP, File Aid, Abend Aid, Expediter, Remedy, Clarity, Oracle DB, PL/SQL, SQL*Plus, Trace, TOAD, Blue Martini, FTP, EDI, Biztalk, MySQL, Unix/AIX scripts (k, c, bash, bourne shells), PERL, sed & awk, Crystal Reports, Microsoft Project, Access, Powerpoint, Excel, Visio and Word.
Confidential (Brookfield, WI)
Quality Assurance Analyst
Responsibilities:
- Primary responsibility was the data mapping for conversions of clients from other vendors or internal systems to Thomson/Reuters data architecture. Some data was mapped, other data required conversion rules. All conversions were first completed in the test environment and verified by Thomson/Reuter and then by the client. When completed, conversions were run in the production environment. All conversions in the backlog were completed on schedule.
- Performed analysis of batch schedules, determined predecessor and successor jobs, evaluated dependencies, ensured efficient abend handling, and established recovery and restart points.
Environment: z/OS, JCL, TSO/ISPF, JCL, QSAM, VSAM, DB2, DATACOM, CICS, MQSeries, Websphere MQ, COBOL, Syncsort, Intertest, SAR, ZEKE, ZEBB, File Aid, Abend Aid, Expediter, Remedy, Peregrine, Change Manager, Main Event, Detector, Rational Rose, ClearView, ClearCase, Microsoft Project, Access, Powerpoint, Excel, Visio and Word.
Confidential (Milwaukee)
Quality Assurance Analyst
Responsibilities:
- Performed data validation and loading of sales and marketing data warehouse. Files were transferred between servers and mainframes and validated prior to database update.
- Performed ad hoc queries, produced analysis reports, did data analysis to certify data integrity, performed a variety of cross platform file transfer functions, maintenance and enhancement development and 24 x 7 production support.
Environment: z/OS, JCL, TSO/ISPF, QSAM, VSAM, DB2, Oracle DB, CICS, Change Manager, MQSeries, COBOL, Expediter, ZEKE, ZEBB, File Aid, Abend Aid, Peregrine, FOCUS, Quikjob, Easytrieve, UNIX, Remoteware, C Shell, Bourne Shell, Bourne Again Shell scripting, Crystal Reports, Visual Basic Express, C#, .NET, SQL Server, VMWare, Microsoft Project and Office 2007.
Confidential (Chicago)
Quality Assurance Analyst
Responsibilities:
- Converted data from EDI formats to the ERP system (Passport) and its server-based front ends (Documentum and APEx) for vendor ASNs. The transactions for this process were sent in ANSI standard record types and layouts. Mainframe-based applications validated the data and reformatted the EDI transactions into data records acceptable to the in-house batch process which handled ASNs.
Environment: z/OS, TSO/ISPF, JCL, QSAM, VSAM, Oracle DB, COBOL, CICS, Change Manager, MQSeries, Intertest, Websphere MQ, File Aid, Abend Aid, DB2, Endevor, Citrix, UNIX, CA 7, CA 11, Citrix, VPN (for remote access), Visual Basic, C#, VMWare, Microsoft Office 2007.
Confidential (Milwaukee)
Quality Assurance Analyst
Responsibilities:
- Performed system analysis and conversion programming, testing in preparation for merger of MGIC and its intended partner in Philadelphia. Established strategy for mergers of like systems and evaluation and adoption of preferred software among competing applications.
- Engaged in DB2 resource evaluation and tuning, troubleshooting and performance issues resolution.
Environment: z/OS, TSO/ISPF, JCL, QSAM, VSAM, COBOL, DB2, Oracle DB, CICS, Panvalet, Easytrieve, MQSeries, UNIX, Oracle, C Shell, Bourne Shell scripting, ZEKE, ZEBB, Microsoft Office 2007.
Confidential (Chicago)
Quality Assurance Analyst
Responsibilities:
- Designed automated third-party prescription benefits applications to medical insurance accumulators. Developed automated file transfers via CICS/MQSeries interfaces to edit and validation programs and subsequent introduction of validated data to the batch update environment.
Environment: z/OS, JCL, TSO/ISPF, Endevor, COBOL, Assembler, File Aid, Interest, VSAM, MQSeries, NDM, CA 7, CA 11, Microsoft Office 2007, Microsoft Project.
Confidential (Aurora, IL)
Quality Assurance Analyst
Responsibilities:
- Supported a variety of cross platform (IBM mainframe and DEC VAX) manufacturing, planning, scheduling and financial applications. A great deal of process analysis and data verification was required to meet ad hoc information requirements of users and website developers.
- Constant user interfaces with plant financial reporting staff and plant production management personnel was required to determine requirements, set performance standards and metrics, determine data requirements and availability and perform ad hoc process improvement functions.
Environment: z/OS, TSO/ISPF, JCL, VSAM, QSAM, IMS DB/DC, SAS, DB2, Oracle DB, File Aid, Abend Aid, Easytrieve, Quikjob, Syncsort, Dataxfer, COBOL, PL/1, Assembler, Change Manager, NDM, CA-7, CA-11, Oracle, SQL Server, Visual Basic, Access, Crystal Reports, AS/400 with COBOL/400, DB2 UDB, OCL/400 and the usual midrange tools, Peregrine, Microsoft Office, Microsoft Project.
Confidential (Southfield, MI)
Quality Assurance Analyst
Responsibilities:
- Supported the payroll system of General Motors Corporation written using IMS DB/DC and COBOL. Provided data mapping for the replacement DB2 database, the IMS data structures had to be broken down into their data item components and relationships between data entities established.
- Performed project evaluation for my employer which showed that the project was in great jeopardy due to the lack of experience in IBM mainframe projects among Lockheed-Martin staff and a lack of appreciate for the relationship intri Confidential es of changing from one outsourcing vendor to another. GM eventually understood that the project had little chance of success and Lockheed-Martin pulled out in favor of another vendor with the requisite experience and resources. My efforts brought the high-risk nature of the situation to light and saved GM many millions of dollars in potential losses.
Environment: OS/390, COBOL, IMS DB/DC, TSO/ISPF, VSAM, CICS, Endevor, DB2, JCL, CA-7, CA-11, NDM, COBOL, Microsoft Office, Microsoft Project, Peregrine, Rational Rose, ClearView, ClearCase.
Confidential (Dearborn, MI)
Developer
Responsibilities:
- This project, very simply, involved the creation of a single, global, manufacturing system for use at Ford Motor Company at all its locations, worldwide. The process involved identification of the components of the “manufacturing system” and a detailed analysis of all the in-house systems around the world which addressed this complete list of functions.
- From the list of competing applications, a “best practice” suite was selected based on a variety of criteria including ability to be modified to accommodate country/region specific requirements yet maintain the integrity of the system and its current functionality. Metric were established to determine the success of each step in the process. Once the criteria had been satisfied, the next step would be initiated.
- I participated, with other business analysts, in identifying the mandatory and option functional components, creating specifications and working with development teams both in the US and overseas to ensure complete and tested modules which would then be turned over to the user testing group for stress, functionality and performance testing. My concentration was on the manufacturing facility inventory module which included on-hand and in-transit inventory, key elements in manufacturing scheduling in a “just-in-time” environment.
Environment: z/OS, DB2, IMS DB/DC, MQSeries, COBOL, CA-7, CA-11, Assembler, File Aid, Abend Aid, Easytrieve, Syncsort, PUPS, SMP/E for PTFs and version updates for CA 7/CA 11, UNIX, Visual Basic, C++, C#, .NET, Microsoft Office, Microsoft Project.