SUMMARY:

• Senior IT Professional with proven history of Design, Development, Testing, Quality Assurance, Implementation and Maintenance of software systems on SQL, DB2, Mainframe environment, ERP and J2EE / .Net technologies, technical and Project Management skills to give an efficient and effective solution that would help the organization to achieve the desired goals in the business and technology.
• Twenty - five years of detailed experience including full life cycle.
• Cobol Programming, design, analysis, QA, testing, documentation, hardware, release management, user training and support.
• Define and proposing technical strategies, Discussion with stakeholders, resolving technical issues as an architect.
• Worked in Project Delivery Management (E2E) ensuring delivery of strategic projects, building cross-functional project teams for BSS (Business Support System) Transformation projects in Insurance, Financial Services, Annuity, Retirement and 401K domains
• Communicating administrative items, plans, project status, business direction, and IT strategy to business areas/ IT staff. Also participating in the Director level status meetings for business areas.
• Monitored Project performance using Earned Value, Schedule Variance, Cost Variance and tracked projects timelines.
• Use strong planning, technical and organizational skills to priorities based upon business objectives and service level agreements.
• Provide consulting (BSS & OSS) services to Toyota, Confidential, Confidential, Confidential, BCBSMS, Edward Jones,United Healthcare, Confidential project teams and collaborate with subject matter experts toIdentify solutions to meet business needs.
• Program management responsibilities which includes but not only limited to project initiation, scope planning, scope definition and scope change control, project plan development, project plan execution, and integrated change control activities, communications planning, information distribution, progress and performance reporting for Fortune 500 clients.
• Software Testing Life Cycle (STLC) experiences include Test Planning, Test Analysis, Test Design, Construction and Verification, Testing Cycles, performance testing, Final Testing, Implementation and Post Implementation. Extensively used bug reporting tools to report the defects.
• Facilitated creation of Test Suite powered by hybrid keyword/data driven framework, featuring unattended execution and extensive verification/validation, detailed reporting, easy maintenance, and covering over 2500 of test cases on multiple test environment for the clients Toyota, United Health Care, BCBSMS, Confidential, Confidential, Confidential, Confidential, Time Customer Service, Confidential,
• Creation, preparation, and conduct of Quality Assurance reviews and the development and execution of test plans and test scripts.
• Preparing and analyze the annual IT budget through consolidation of system manager’s information. Negotiate with the system managers, Finance, and the CIO on the appropriate annual budget to fit the corporate guidelines/task for budgets.
• Defined project scope and objectives through internal project management methodologies for Aglie model. Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.
• Conduct project closure activities to formalize and communicate the project completion, handover documentation and ongoing activities and identify accountable resources for future issues and resolution processes. Maintained standard documentation for compliance with CMMI level 5 standards.
• Experience in User Acceptance Testing (UAT), Performance Testing, GUI Testing, Functional Testing, System Integration Testing, Regression Testing, End-to-End, Data Driven, Keyword driven and White Box testing .Strong experience in Preparing Reports for some of the Functional and Performance Testing.
• General Project Management Roles:
• Manage a communication plan that involves keeping the business and IT team as well as leadership apprised of Project process, Changes in timeline, scope, resources, Issues & risks.
• Communicate with team leads to engage resources in a timely fashion. Ensure that project resource on and off-boarding dates are accurate and communicated.
• Time reporting for resources, Screen, tests, and qualify candidates through the use of behavioral interviewing techniques and skill assessment testing. Interview IT Resources to document current IT process and new process needs. Facilitate the onboarding process, I-9 verification, Asset allocation.
• Interview IT Resources to document current IT process and new process needs.

TECHNICAL SKILLS:

Programming Languages:: VS-Cobol-II, Eazytrieve Plus, SAS, Telon, Focus, MF-COBOL, JCL, JavaScript, HTML, CICS, COBOL 370, SQL, PL/1, Assembler, CA7, DHTML, VSAM, IMS, IDMS, Platinum Utilities, CA7, ZEKE JOB Scheduler, XPEDITOR, DB2 Utilities, HP Quality Center/ALM,, Visio, ELIPS, Nikko Time Sheet, Control-M Lotus notes, CICS Web Services, HTTP,SOAP,IBM Debug tool, RACF, File-AID, Job Track, Interest, Expeditor, Peregrine Service Center, IBM Web sphere, DB2 Stored Procedures, SOA, IBM Content Manager,IBM Clearquest,Clearcase,Focus,CA-Erwin,ASP, VB 6.0, Visual Studio.NET 1.1, Visual Source Safe 6.0, SDLC,CSS, J2EE, EJB, JSP, JDBC, Selenium, PeopleSoft HR, Content Management Systems, Text pattern CMS, Toad for DB2, DB2 connect family, Tandem/NonStop, COBOL, SCOBOL, TACL, Informatica Power Center 9.1, Unix, Informatica Data Quality (IDQ), IBM 3390, OPC,Z/OS

Integrated Development:: DB2 Databases, Microsoft SQL Server 2000, IBM Rdz 7.6, MS-Access

Source Control: Microsoft Visual Source Safe, Endeavor, Change Man, Pan Valet

Databases:: DB2, IDMS, MS-ACCESS, IMS/DB, Oracle 8i, FOXPRO

PROFESSIONAL EXPERIENCE:

Confidential

Senior QA & Test Analyst

Responsibilities:

• Worked in all phases of STLC (Test Life Cycle) for EFTPS ongoing projects (NACHA implementation, COBOL Upgrade testing efforts, EFTPS - Blocked RTN implementation efforts, Direct Pay Email verification projects).
• Creating test plans, test cases, test scripts, execution of tests scripts, test results capture, mapping requirements in CLM, defect analysis, defect resolution.
• Design and develop SPUFI SQL queries to execute the test scripts for NACHA implementation, COBOL Upgrade efforts, EFTPS - Blocked RTN implementation efforts, Direct Pay Email verification projects.
• Interfacing with test managers, test analysts on day to day basis for testing requirement gathering, test plan development, Tractability matrix development and test script design.
• Assisting in the completion of the Test plan document by including details about mainframe impacts and EFTPS functional areas to be changed to meet the requirements.
• Setting up input data files via File Aid/Master and unit testing, Documenting code changes and unit test results for distribution prior to review, Coordinating and completing code and unit test results walkthroughs with other mainframe development SMEs to ensure the highest quality bug-free code migrating the mainframe changes into Endevor .
• Reviewing QA Test Plans to ensure all impacted EFTPS functional areas are being tested. Supporting QA and Acceptance Test efforts by clarifying result expectations & fixing defects.
• Providing Knowledge Transfer for new hires about various EFTPS (IRS) payment channels Direct Deposit Installment Agreement, Online Bill Pay, ACH Credit Direct Pay with all the supporting documents.

Environment: MVS, COBOL, JCL, CICS, DB2, JCL, MVS/TSO, FILEAID, VSAM, Endeavor, SPUFI, RACF, VSAM, GDG, File Manager, Platinum Utilities, Expeditor, CLM, SharePoint, Z/OS.

Confidential

QA Manager

• Creating test plans, test cases, test scripts, execution of tests scripts, test results capture, mapping requirements in ALM, defect analysis, defect resolution for Dodd Frank Compliance, Guaranteed Principle Exempt Funds project initiatives for Confidential planned releases.
• Interfacing with multiple stakeholders, to on-boarding new clients / regions as a part of the OFAC watch list filtering expansion in different geographic locations.
• Define and ensure appropriate governance, methodology, and best practices. Partner with project managers and leadership to support major global initiatives through the project's Lifecycle.
• Evaluate risk and assess project health through independent analysis. Manage risks/issues, ensure corrective actions and ownership is defined in a timely manner.
• Support objective and standardized project reporting and stakeholder communications. Define proposals, timeline, resource plan and cost benefit analysis.
• Initiate projects and establish proof of concepts. Evaluate user needs, strategies, and issues to help better business practices.
• Compose comprehensive descriptions of user needs including functional and technical requirements.
• Maintain Issue / Defect / Risk tracker and work towards to completion / close. Maintain project timelines, defining roles and streamlining processes.

Environment: MVS, COBOL, JCL, CICS, DB2, JCL, MVS/TSO, FILEAID, VSAM, Endevor, SPUFI, RACF, VSAM, Toad for DB2, DB2 connect family, Waterfall, Scrum /Agile/ SAF, Expeditor, HP ALM/Quality Center, IBM Rational, SharePoint, Z/OS.

Confidential

QA Manager

• Preparation of Master test plan, test coverage plan for FAST BI project (Release 2) of Confidential . FAST (Financial Accounting System Transformation) project includes implementation of a consolidation tool at TFS which includes Hyperion Financial Management (HFM), Hyperion Financial Reporting (HFR), Hyperion Data Quality Management (FDM), Hyperion Data Relationship Management (DRM) and Hyperion Smart view. Release 2 of this project focus on leveraging the roll forward dimension to support cash flow and iFEM reports in HFM to meet business needs of BTS (Business technology Services) and BI (Business Intelligence) of TFS.
• Enabled incremental loading of data in fact table mappings and made required changes to the mappings to populate the production data.
• Data analysis, Design, development of procedures to extract production data from production region tables then loading the reformatted data to test region tables.
• Defects logging, retesting the test scripts, tracking the defects and closing the defects. Analyze Test Execution Results and Report Defects using HP/ALM/Quality Center.
• Developed mappings to transform the data according to the business rules and integrated with other sources like ODS, legacy marts, before loading into Confidential tables.
• Defined project scope and objectives through internal project management methodologies for Scaled Agile frameworks (SAF) model. Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.
• Creation, preparation, and conduct of Quality Assurance reviews and the development and execution of test plans and test scripts using HP ALM.
• Prepared the Test Plan, Test Scripts, uploading and track the test plan in Quality Center and reviewed the Test plans. Tracking using HP ALM.
• Creation and maintenance of the logical and physical data models for the production and Business Intelligence data warehouse and data marts. Conducting data design walkthroughs to communicate data warehouse and Data Mart table designs to ETL developers.
• Worked extensively on different transformations like source qualifier, Expression, Filter, Aggregator, Router, Update strategy, lookup, Normalizer, Stored procedure, Mapping Variables and Sequence generator.

Environment: MVS, COBOL, JCL, CICS, DB2, JCL, MVS/TSO,SAS,FILEAID, VSAM, Change Man, QXNT,SPUFI, RACF, VSAM, SAS, Toad for DB2, DB2 connect family, Hyperion Enterprise Management, Hyperion Reports, Waterfall, Scrum /Agile/ SAF, SOAP/UI, Expeditor, Informatica power center 9.0, HP ALM/Quality Center, IBM Rational, Informatica Data Quality (IDQ) 9.6.0 & 9.5.1, IBM 3390, OPC,Z/OS.

Confidential

Manager

• Production support maintaining, troubleshooting, and problem solving of Client business programs and systems. Evaluates and anticipates impact of technical solutions on related projects. Translates technical solutions based on client's needs and feasibility.
• Apply necessary and discretionary system changes and/or fixes, making system enhancements as required by IT management, business units as part of change management process.
• Software Testing Life Cycle (STLC) experiences include Test Planning, Test Analysis, Test Design, Construction and Verification, Testing Cycles, performance testing, Final Testing, Implementation and Post Implementation.
• Creates and follows technical standards and best practices including leveraging repeatable processes and deliverables.
• Design, development of Cobol/DB2 program, jobs, copybooks for BCBSMS VSAM conversion to DB2 efforts that enables the efficient processing of claims (Dental Professional and Institutional) which is the part of EDI claim flow jobs.
• Defects logging, retesting the test scripts, tracking the defects and closing the defects. Analyze Test Execution Results and Report Defects using HP/ALM/Quality Center.
• Development and execution of parallel tests runs for ICD-9 claims and multiple versions of corresponding ICD-10 claims. Verifying ICD-10 codes (remediation) for subrogation transactions of the corresponding ICD-9 codes.
• Managed the monthly production release of code to ensure timely fixes to production incidents were implemented or release of software improvements was accomplished. Prepare and distribute communications regarding the delivery (based on the established release schedule).
• Facilitate meetings to gain alignment and approvals for planned releases. Monitor deployment and validation plans to ensure compliance with the process. Own the release calendar, produce detailed release plans, control release scope.
• Collaborate with Configuration manager, QA Manager and Application Development Directors in ensuring proper Release Plans, Test Plans, and Acceptance Criteria are set.
• Preparation of back up, contingency and blackout plans for releases for addressing to risks.
• Functional, unit and system testing of EDI claim and non EDI claim processing flow jobs (both DB2 and VSAM versions).Used HP ALM for test management and tracking.
• Creation, preparation, and conduct of Quality Assurance reviews and the development and execution of test plans and test scripts using HP ALM.
• Prepared the Test Plan, Test Scripts, uploading and track the test plan in Quality Center and reviewed the Test plans. Tracking using HP ALM.Extracting, analyzing, reconciling, trending, and forecasting data, auditing uploads of data to ensure the quality and timeliness of the data. Identifying, researching, analyzing, and trouble-shooting issues within QXNT / Legacy claims and membership systems.
• To facilitate ICD10 conversion testing, built provider/institutional agreements and benefit plans on to QXNT front end.
• Facilitated creation of Test Suite powered by hybrid keyword/data driven framework, featuring unattended execution and extensive verification/validation, detailed reporting, easy maintenance, and covering over 500 of test cases on multiple test environment for ICD 10 conversion functional and technical testing.
• For the Policy Subscriber or Member, with Policy and Plan details, based on the availability of the Member data, Validated SOAP /UI Response, Error code and Error Messages.
• Acting as liaison between business stakeholders, such as management, customers or end users, and the software development or information technology team.Interacted with users for requirement analysis, BCBS MS ICD 10 conversion Impact Assessment & Remediation.
• Defined project scope and objectives through internal project management methodologies for Scaled Agile frameworks model. Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.
• Established effective communication for the department with consistency across development and business management. Presentations, recommendations and updates provided regularly to the Director office.
• Provide visibility to team impediments/risks and helps eliminate them
• Coaches and mentors agile team members and provides constructive performance feedback
• Trained and coached a development team of 6-8 and management team of 12 to utilize Agile Methodology with Scrum
• Collaborated with the stakeholders and SMEs in finalizing the requirements per Center for Medicare and Medicaid Services (CMS) HIPAA Compliances/Regulations for change requests.
• Involved in HIPAA assessment and ANSI X12 EDI transaction (835, 837)mapping and identified changes that needed to be done to comply with HIPAA regulations.
• Participated in couple enhancement releases for both HIPAA 270 and 276 transactions.
• Develop EDI maps, convert 4010 maps to 5010 maps using EDIFECS.
• Worked with Claims Manager to resolve EDI claim issues.
• Performing verification and validation of the EDI transactions.
• Develped and supported JCL, PROC for Advanced EDI file split/merge processing.
• Possess strong knowledge of healthcare terminology and extensive experience working on healthcare projects. Specialized experience in healthcare insurance domain. Profound understanding of insurance policies like HMO and PPOand proven experience with HIPPA 4010/5010 EDI transaction codes such as 270/271(inquiry/response health care benefits), 276/277(Claim status), 999(Functional Acknowledgment)

Environment: MVS, COBOL, JCL, CICS, DB2, JCL, MVS/TSO,SAS,FILEAID, VSAM, Change Man, QXNT,SPUFI, RACF, VSAM, SAS, Toad for DB2, DB2 connect family, Hyperion Enterprise Management, Hyperion Reports, Waterfall, Scrum of Scrum/Agile/SAF, SOAP/UI, HP ALM / Quality Center, Expeditor, IBM 3390, OPC,Z/OS.

Confidential, Torrance,CA

Manager

• Provide consulting services to Confidential project teams and collaborate with subject matter experts to identify solutions to meet business needs.
• Develop, define and execute project plans, project scopes, activities, schedules, goals, and deliverables.
• Monitor and report project status to stakeholders and project team members by preparing and presenting reports outlining projects progress, open tasks, know issues and solutions. Review and maintain all project artifacts to ensure proper audit documentation is present for compliance purposes.
• Evaluates and anticipates impact of technical solutions on related projects. Translates technical solutions based on client's needs and feasibility.
• Be responsible for the technical leadership of IT systems architecture solutions for large-scale billing transformation projects in complex BSS environments.
• Apply necessary and discretionary system changes and/or fixes, making system enhancements as required by IT management, business units as part of change management process.
• Managing the monthly releases of TTMS application for Oracle, J2EE, Hyperion, Mainframe defects/tasks. Leading the LDMC, CAP, DAP allowances reporting projects in all SDLC phases.
• Data collection and requirement analysis for Oracle OIM Suite implementation using enterprise Architecture philosophy. This includes evaluation of business and functional requirements to build enterprise architecture for future business scalability and support for multiple lines of business of the customer.
• Creates and follows technical standards and best practices including leveraging repeatable processes and deliverables.
• Executed testing of mainframe batch jobs (HP ALM) for Lexus Dealer allowance programs and troubleshooting of jobs.
• Defined project scope and objectives through internal project management methodologies for SAF /Aglie model. Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.
• Established effective communication for the department with consistency across development and business management. Presentations, recommendations and updates provided regularly to the Director office.
• Provide visibility to team impediments/risks and helps eliminate them
• Coaches and mentors agile team members and provides constructive performance feedback
• Well experienced with Functional, Regression, Performance, System and End to End testing and Non Functional requirement testing on Web based, mobile applications testing and Backend Applications in Unix environment, CRM and API testing using SOAP UI for Confidential and Confidential .
• Design of Technical and functional requirement for Toyota Enterprise security service (TESS) for integrating into TBG (Toyota Business Gateway - TBG) for various applications.
• Managing the monthly releases of TTMS application for Oracle, J2EE, Hyperion, Mainframe defects/tasks. Leading the LDMC, CAP, DAP allowances reporting projects in all SDLC phases.
• Communicates project status to all interested parties and ensures team stays on track to satisfy client expectations.
• Managed the monthly production release of code to ensure timely fixes to production incidents were implemented or release of software improvements was accomplished. Prepare and distribute communications regarding the delivery (based on the established release schedule).
• Facilitate meetings to gain alignment and approvals for planned releases. Monitor deployment and validation plans to ensure compliance with the process. Own the release calendar, produce detailed release plans, control release scope.
• Collaborate with Configuration manager, QA Manager and Application Development Directors in ensuring proper Release Plans, Test Plans, and Acceptance Criteria are set.
• Preparation of back up, contingency and blackout plans for releases for addressing to risks.
• Executed manual testing of mainframe batch jobs for Lexus Dealer allowance programs and troubleshooting of jobs.
• Support the deployment of enterprise upgrades for the Technology and Application teams that impact the TMS and the Toyota Affiliates.
• Creation, preparation, and conduct of Quality Assurance reviews and the development and execution of test plans and test scripts using HP ALM.
• Prepared the Test Plan, Test Scripts, uploading and track the test plan in Quality Center and reviewed the Test plans. Tracking using HP ALM.
• Defects logging, retesting the test scripts, tracking the defects and closing the defects. Analyze Test Execution Results and Report Defects using HP/ALM/Quality Center.
• Assist in development and deployment of Configuration Management policies and procedures.
• Proactively conduct research and investigate new ideas to find candidates through a variety of methods including: complex Internet searches, social and professional networking groups, and the development of existing candidate relationships.
• Develop an ongoing and diverse pipeline of prospective candidates for assigned positions.
• Identify and submit qualified candidates to Recruiting Team based on the provided job description.
• Screen, test, and qualify candidates through the use of behavioral interviewing techniques and skill assessment testing. Facilitate the onboarding process, I-9 verification, Asset allocation.
• Create and/or facilitate the creation of User Training documents. Conducting performance appraisals for juniors for Career Advancement and wage revision.

Environment: MVS, COBOL, JCL, CICS, DB2, FILEAID, VSAM, Change Man, SPUFI, RACF, VSAM, Expeditor, IBM Clear Quest, Clear case,, Oracle 11g,Java Script,SAS, HTML, Platinum Utilities, ASP, VB 6.0, Visual Studio.NET 1.1, Visual Source Safe 6.0, SDLC,CSS, Selenium, Hyperion, SOAP/UI, Primavera Planner III,IBM Rational, PHP, Hyperion Enterprise Management, HP ALM / Quality Center, Aglie/SAF/ Scrum /Scrum of Scrum Procesing, Hyperion Reports, IBM 3390, OPC,Z/OS.

Confidential

Manager (IT)

• Provide consulting services to Confidential project teams and collaborate with subject matter experts to identify solutions to meet business needs.
• Retail IT ( Confidential / Confidential ) - Involved in Interfacing with the Confidential business representatives to validate business requirements/requests for analysis and present intermediate and final analytical results.
• Retail IT ( Confidential / Confidential ) - Gathered and analyzed data to solve complex problems and evaluate scenarios to make predictions on future outcomes and support decision making.
• Retail IT ( Confidential / Confidential ) - Documented analytical methodologies used in the execution of analytical request projects. Translate scientific methodology to business terms, providing guidance and assistance to others in translation
• Evaluates and anticipates impact of technical solutions on related projects. Translates technical solutions based on client's needs and feasibility.
• Data collection and requirement analysis for Oracle OIM Suite implementation using enterprise Architecture philosophy.
• Worked in design and testing of programs for Tandem COBOL / Non-stop development environment for POS payment processing.
• Software Testing Life Cycle (STLC) experiences include Test Planning, Test Analysis, Test Design, Construction and Verification, Testing Cycles, performance testing, Final Testing, Implementation and Post Implementation.
• This includes evaluation of business and functional requirements to build enterprise architecture for future business scalability and support for multiple lines of business of the customer.
• Documentation of new function and maintenance of documentation on existing functions. Utilizing structured programming techniques in ADABAS, NATURAL 2.2.and NATURAL 2.1 with TSO for state of GA.
• Worked in conversion of excessively large ADABAS files into multiple DB2 files using utilities like ADASTRP to pull data for loading into DB2 files and tables.
• Developed, maintained, and tested programs in the Collections/Recovery system in Natural and COBOL LE/DB2.
• Performed testing of Mainframe Natural applications using HP Quality Control Center.
• Communicates project status to all interested parties and ensures team stays on track to satisfy client expectations.
• Managed the monthly production release of code to ensure timely fixes to production incidents were implemented or release of software improvements was accomplished. Prepare and distribute communications regarding the delivery (based on the established release schedule).
• Defined project scope and objectives through internal project management methodologies for Aglie (SAF) model. Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.
• Established effective communication for the department with consistency across development and business management. Presentations, recommendations and updates provided regularly to the Director office.
• Provide visibility to team impediments/risks and helps eliminate them
• Coaches and mentors agile team members and provides constructive performance feedback
• Trained and coached a development team of 6-8 and management team of 12 to utilize Agile Methodology with Scrum
• Facilitate meetings to gain alignment and approvals for planned releases. Monitor deployment and validation plans to ensure compliance with the process. Own the release calendar, produce detailed release plans, control release scope.
• Collaborate with Configuration manager, QA Manager and Application Development Directors in ensuring proper Release Plans, Test Plans, and Acceptance Criteria are set.
• Preparation of back up, contingency and blackout plans for releases for addressing to risks.
• Worked in the Bridge Enhancement, IRS-1099C, Sears and RPL development projects for Confidential Group.
• Developed User Interface /GUI layer using asp.net, C# class libraries and projects for Business Support teams using Object Oriented design and methodologies. Used SQL Server 2000 stored procedures, created jobs schedulers for various data insertion requirements. Developed modules in ASP.Net, C# for intranet based application which allows business users to maintain master data. Support all delivery expectations based on the implementation and use of the ITIL framework for Confidential, Confidential and Confidential .
• Making recommendations for solutions or improvements that can be accomplished through new technology or alternative uses of existing technology.
• Project Lead and CMS SME for SBC.com and Confidential .com. Participated in the Confidential Wireless and Cingular catalog merges with SBC.com and the migration of SBC.com content to Confidential .com.
• Content Management System business analyst with over 2 years’ experience selecting, designing, deploying and managing enterprise CMS solutions for SBC/AT&T marketing division.
• Participate with senior management and SMEs of other client locations to support programs and development of strategic plans for the organization
• Analyzing and communicating stakeholder needs by translating business requirements into software requirements.
• Create scripts for testing of services using SOAP UI, or equivalent toolset. Test data preparation for SOAP UI script execution.
• Validate services using SOAP UI by testing XML request and response data.
• Creates and follows technical standards and best practices including leveraging repeatable processes and deliverables.
• Worked as Project Manager (end to end) to ensure delivery of BSS (Business Support System) Transformation projects in Insurance, Financial Services, Annuity, Retirement and 401K plans domains for the clients Edward Jones, State Farm Insurance, Confidential, Confidential,, Morgan Stanley.
• Establish a solid relationship with the customer aimed at increasing Client’s credibility as the primary partner for delivering transformation programs and in doing so clearly articulate the scope and benefits that would be delivered.
• Well experienced with Functional, Regression, Performance, System and End to End testing and Non Functional requirement testing on Web based, mobile applications testing and Backend Applications in Unix environment, CRM and API testing using SOAP UI for Confidential and Confidential .
• Communicates project status to all interested parties and ensures team stays on track to satisfy client expectations in role of onsite/offshore coordination.
• Documenting Login and Security Procedures, Job handling procedures, Architecture diagrams, Program move procedures, region monitoring procedures, trouble shooting procedures, project plans, license management, escalation procedures, transition plan, status reports coordinating offshore team meetings, onsite coordination.
• Creation, preparation, and conduct of Quality Assurance reviews and the development and execution of test plans and test scripts.
• Worked in the projects Friends & Family usage -#Min and bill-face changes, Vision Lock-box file opt out, Competitive Response - Bill information credit.
• Provide general project management support which includes: developing work breakdown structures, managing the requirements definition process, interfacing with technology subject matter experts, managing projects to their on- time completion, within budget and meeting quality standards.
• Extracting, analyzing, reconciling, trending, and forecasting data, auditing uploads of data to ensure the quality and timeliness of the data. Identifying, researching, analyzing, and trouble-shooting issues within QXNT / Legacy claims and membership systems.
• Work closely with the business / User team to capture the data requirement (from the functional requirement).
• Retail IT ( Confidential / Confidential ) -Lead the data base / ETL process design effort to capture data from various sources.
• Retail IT ( Confidential / Confidential ) -Experience with SQL Plus, DB2 connect family and TOAD/SQL Developer as an interface to databases, to analyze, view and alter data.
• Retail IT- Worked in Legacy Modernization team for Confidential /ALBERTSONS - DB2 Database Migration, data analysis, design & integrity of the mainframe retail system, Manage IT Analyst team in support of business and financial systems.
• Facilitated creation of Test Suite powered by hybrid keyword/data driven framework, featuring unattended execution and extensive verification/validation, detailed reporting, easy maintenance, and covering over 1000 of test cases on multiple test environment for Confidential, Confidential, Confidential, Confidential .
• Strong Data Analysis and Data Profiling background using Informatica Analyst, Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ). Design the ETL process to load the source data into the database (Visio).
• Creation of mappings according to the use cases by following the ETL specifications. Analyzed the source data coming from different sources (Oracle, DB2, XML, Flat files) and worked on developing ETL mappings.
• Oversees the design/development and supports the data models/structures and ETL. Performs quality testing prior to UAT, and reports progress throughout the project and enhancement life cycle.
• Created mappings accessing data from DB2 mainframes using Informatica Power Connect. Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Performed Source system study to load the Hierarchy Table. Created Multiple Mappings to load data from including mainframe data available in DB2 schema.
• Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation (DVQ), developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Conducted extensive analysis on migration and conversion of Provider and Member data, Group configurations, plan codes, benefit set-ups, fee schedules, provider pricing, etc from Legacy system to QNXT.
• Worked as Senior QA for Confidential & CSC Medicare applications and have experience in manual and auto testing (End-to-End, Data Driven, Keyword driven Set top box testing) of TriZetto QNXT applications.
• Creation, preparation, and conduct of Quality Assurance reviews and the development and execution of test plans and test scripts using HP ALM.
• Prepared the Test Plan, Test Scripts, uploading and track the test plan in Quality Center and reviewed the Test plans. Tracking using HP ALM.
• Defects logging, retesting the test scripts, tracking the defects and closing the defects. Analyze Test Execution Results and Report Defects using HP/ALM/Quality Center.
• Develop data migration architecture, Produce data migration functional document, Map the legacy application data points and design process flow diagram for migration ETL process to convert data from legacy application database. Assist in development and deployment of Configuration Management policies and procedures .
• Retail IT ( Confidential / Confidential ) -Documenting Login and Security Procedures, runbook maintenance procedures, Job handling procedures, Architecture diagrams, Program move procedures, region monitoring procedures, trouble shooting procedures, project plans, license management, escalation procedures, transition plan, status reports coordinating offshore team meetings, for Group-1 applications / Confidential as part of release management.
• Lead the teams and influence peers on goals/objectives, policies and processes and also build support for initiatives.

Environment: MVS, COBOL, JCL, CICS, DB2, FILEAID, VSAM, CHANGE Man, SPUFI, RACF, VSAM, Expeditor, IBM Clear Quest, Clear case,, Oracle 10i,Java Script, SAS, HTML, Platinum Utilities, ASP, VB 6.0, Visual Studio.NET 1.1, Visual Source Safe 6.0, SDLC,CSS, Quality Center, Selenium, QXNT,API, SOAP/ UI, Informatica BI/DW, Informatica Data Quality (IDQ) 9.6.0 & 9.5.1, Toad for DB2, DB2 connect family, Tandem, Scobol, Aglie/Scrum /SAF,TACL,Informatica Power Center 9.1, Cognos, CMS, JCL, MVS/TSO, ADABAS 7.1,NATURAL 3.1.4, Primavera Planner III,QTP,MS - SQL SERVER, HP ALM/ Quality Center, SOAP/UI,UNIX, IBM 3390, OPC,Z/OS.

Confidential, Random House

Mainframe Programmer Analyst

• Created new monthly confirms report using Cobol/DB2.
• Worked in design, development and testing of programs for Tandem COBOL / Non-stop development environment to facilitate Debit card, merchant credit payment processing.
• Design, coding, testing of new Easytrieve+ program to create a statement suppression report for participants.
• Involved in analysis, design, coding, testing of modules to create secured info Pac reports for Confidential plans.
• Created JCL, Process for executing the new modules.
• Utilized IBM 3090, SQL, DB/2, MVS JCL, TSO, SPUFI, QMF, Relational Databases and Debugging Tools

Environment: COBOL, VSAM, DB2, CICS, MVS JCL, TSO/ISPF, File Aid, ZEKE, QMF, SPUFI, PLATINUM UTILITIES, IBM 3090, MVS/ESA, EXPEDITOR, SQL, VTAM, Easytrieve Plus,DB2 BI,DB2 stored procedures, Tandem, Scobol, TACL.